123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281 |
- $PBExportHeader$f_find_mtrl_ljfieb.srf
- global type f_find_mtrl_ljfieb from function_object
- end type
- forward prototypes
- global function integer f_find_mtrl_ljfieb (string arg_mtrlcode, long arg_storageid, ref s_mtrldef_array arg_s_mtrldef)
- global function integer f_find_mtrl_ljfieb (string arg_mtrlcode, ref s_mtrldef_array arg_s_mtrldef)
- end prototypes
- global function integer f_find_mtrl_ljfieb (string arg_mtrlcode, long arg_storageid, ref s_mtrldef_array arg_s_mtrldef);Int rslt = 1
- //Long cnt = 0
- //
- //String ls_like_mtrlcode
- //String ls_mtrlcode,ls_mtrlname,ls_unit,ls_mtrlmode,ls_mtrltype
- //String ls_mtrlsectype,ls_zxmtrlmode,ls_mtrlengname
- //String ls_unit_buy,ls_dscrp
- //Long ll_mtrlid
- //String ls_prdpackcode
- //Decimal ld_packqty,ld_planprice,ld_lmbuyprice,ld_lmsaleprice
- //Decimal ld_rate_buy,ld_mprice
- //Int li_mtrlorigin,li_mtrlkind
- //Int li_statusflag,li_woodcodeflag,li_pcodeflag
- //Long ll_statustype,ll_woodcodetype,ll_pcodetype
- //Decimal ld_mtrlarea,ld_mtrlarea1,ld_mtrlarea2
- //Decimal ld_minbuyqty
- //Decimal ld_net_weight,ld_gross_weight,ld_cubage
- //Decimal ld_scidprice
- //Decimal ld_orderdays,ld_buydays,ld_wfjgdays,ld_aheaddays
- //Int li_ifunit
- //Long ll_configcodetype
- //String ls_configcode,ls_configname,ls_mtrlcolor
- //Long ll_ifautodd,ll_iflljg
- //String ls_usermtrlmode
- //Int li_ifmtrlcuscode
- //Int li_buyunit,li_scllunit,li_wfjgunit,li_saleunit
- //String ls_unit_scll,ls_unit_sale
- //Decimal ld_rate_scll,ld_rate_sale
- //Int li_buydec,li_wfjgdec,li_sclldec,li_saledec
- //Decimal ld_expday
- //Int li_outtype,li_ifpackpro
- //Decimal ld_maxqty,ld_minqty,ld_capaparm,ld_sctaskqty
- //Int li_mtrlprp
- //Decimal ld_maxarg,ld_minarg
- //Decimal ld_maxdays,ld_mindays
- //Long ll_dftwrkGrpid
- //Int li_ifusedeliqty
- //String ls_status_config,ls_woodcode_config,ls_pcode_config
- //Int li_pricepztype
- //int li_ifcustom,li_status_check,li_woodcode_check,li_pcode_check
- //string ls_handtype
- //int li_ifpack
- //int li_ifpackpz
- //int li_ifpackpro2
- //int li_ifpacktype
- //
- //Boolean if_find = False
- //
- //IF Trim(arg_mtrlcode) = '' THEN
- // rslt = 0
- // GOTO ext
- //END IF
- //
- //IF Pos(Trim(arg_mtrlcode),'%') = 0 THEN
- // ls_like_mtrlcode = '%'+ Trim(arg_mtrlcode) + '%'
- //ELSE
- // ls_like_mtrlcode = Trim(arg_mtrlcode)
- //END IF
- //
- //IF arg_storageid = -1 THEN
- //
- // SELECT u_mtrldef.mtrlid,
- // u_mtrldef.mtrlcode,
- // u_mtrldef.mtrlname,
- // u_mtrldef.unit,
- // u_mtrldef.mtrlmode,
- // u_mtrldef.mtrltype,
- // u_mtrldef.prdpackcode,
- // u_mtrldef.packqty,
- // u_mtrldef.lmbuyprice,
- // u_mtrldef.lmsaleprice,
- // u_mtrldef.unit_buy,
- // u_mtrldef.rate_buy,
- // u_mtrldef.dscrp,
- // u_mtrldef.mprice,
- // u_mtrldef.mtrlorigin,
- // u_mtrldef.mtrlsectype,
- // u_mtrldef.zxmtrlmode,
- // u_mtrldef.mtrlkind,
- // u_mtrldef.statusflag,
- // u_mtrldef.woodcodeflag,
- // u_mtrldef.pcodeflag,
- // u_mtrldef.statustype,
- // u_mtrldef.woodcodetype,
- // u_mtrldef.pcodetype,
- // u_mtrldef.mtrlarea,
- // u_mtrldef.minbuyqty,
- // u_mtrldef.mtrlarea1,
- // u_mtrldef.mtrlarea2,
- // u_mtrldef.net_weight,
- // u_mtrldef.gross_weight,
- // u_mtrldef.cubage,
- // u_mtrldef.scidprice,
- // u_mtrldef.configcodetype,
- // u_mtrldef.configcode,
- // u_mtrldef.configname,
- // u_mtrldef.mtrlcolor,
- // u_mtrldef.ifautodd,
- // u_mtrldef.iflljg,
- // u_mtrldef.orderdays,
- // u_mtrldef.buydays,
- // u_mtrldef.wfjgdays,
- // u_mtrldef.aheaddays,
- // u_mtrldef.ifunit,
- // u_mtrldef.usermtrlmode,
- // u_mtrldef.ifmtrlcuscode,
- // u_mtrldef.buyunit,
- // u_mtrldef.wfjgunit,
- // u_mtrldef.scllunit,
- // u_mtrldef.saleunit,
- // u_mtrldef.unit_scll,
- // u_mtrldef.unit_sale,
- // u_mtrldef.rate_scll,
- // u_mtrldef.rate_sale,
- // u_mtrldef.buydec,
- // u_mtrldef.wfjgdec,
- // u_mtrldef.sclldec,
- // u_mtrldef.saledec,
- // u_mtrldef.expday,
- // u_mtrldef.outtype,
- // u_mtrldef.ifpackpro,
- // u_mtrldef.maxqty,
- // u_mtrldef.minqty,
- // u_mtrldef.capaparm,
- // u_mtrldef.sctaskqty,
- // u_mtrldef.mtrlprp,
- // u_mtrldef.maxarg,
- // u_mtrldef.minarg,
- // u_mtrldef.maxdays,
- // u_mtrldef.mindays,
- // u_mtrldef.dftwrkGrpid,
- // u_mtrldef.ifusedeliqty,
- // u_mtrldef.status_config,
- // u_mtrldef.woodcode_config,
- // u_mtrldef.pcode_config,
- // u_mtrldef.pricepztype,
- //u_mtrldef.ifcustom,
- //u_mtrldef.status_check,
- //u_mtrldef.woodcode_check,
- //u_mtrldef.pcode_check,
- //u_mtrldef.handtype,
- //u_mtrldef.ifpack,
- //u_mtrldef.ifpackpz,
- //u_mtrldef.ifpackpro2,
- //u_mtrldef.ifpacktype,
- //u_mtrldef.mtrlengname
- // INTO :ll_mtrlid,
- // :ls_mtrlcode,
- // :ls_mtrlname,
- // :ls_unit,
- // :ls_mtrlmode,
- // :ls_mtrltype,
- // :ls_prdpackcode,
- // :ld_packqty,
- // :ld_lmbuyprice,
- // :ld_lmsaleprice,
- // :ls_unit_buy,
- // :ld_rate_buy,
- // :ls_dscrp,
- // :ld_mprice,
- // :li_mtrlorigin,
- // :ls_mtrlsectype,
- // :ls_zxmtrlmode,
- // :li_mtrlkind,
- // :li_statusflag,
- // :li_woodcodeflag,
- // :li_pcodeflag,
- // :ll_statustype,
- // :ll_woodcodetype,
- // :ll_pcodetype,
- // :ld_mtrlarea,
- // :ld_minbuyqty,
- // :ld_mtrlarea1,
- // :ld_mtrlarea2,
- // :ld_net_weight,
- // :ld_gross_weight,
- // :ld_cubage,
- // :ld_scidprice,
- // :ll_configcodetype,
- // :ls_configcode,
- // :ls_configname,
- // :ls_mtrlcolor,
- // :ll_ifautodd,
- // :ll_iflljg,
- // :ld_orderdays,
- // :ld_buydays,
- // :ld_wfjgdays,
- // :ld_aheaddays,
- // :li_ifunit,
- // :ls_usermtrlmode,
- // :li_ifmtrlcuscode,
- // :li_buyunit,
- // :li_wfjgunit,
- // :li_scllunit,
- // :li_saleunit,
- // :ls_unit_scll,
- // :ls_unit_sale,
- // :ld_rate_scll,
- // :ld_rate_sale,
- // :li_buydec,
- // :li_wfjgdec,
- // :li_sclldec,
- // :li_saledec,
- // :ld_expday,
- // :li_outtype,
- // :li_ifpackpro,
- // :ld_maxqty,
- // :ld_minqty,
- // :ld_capaparm,
- // :ld_sctaskqty,
- // :li_mtrlprp,
- // :ld_maxarg,
- // :ld_minarg,
- // :ld_maxdays,
- // :ld_mindays,
- // :ll_dftwrkGrpid,
- // :li_ifusedeliqty,
- // :ls_status_config,
- // :ls_woodcode_config,
- // :ls_pcode_config,
- // :li_pricepztype,
- // :li_ifcustom,
- //:li_status_check,
- //:li_woodcode_check,
- //:li_pcode_check,
- //:ls_handtype,
- //:li_ifpack,
- //:li_ifpackpz,
- //:li_ifpackpro2,
- //:li_ifpacktype,
- //:ls_mtrlengname
- // FROM u_mtrldef
- // WHERE ( u_mtrldef.mtrlcode = :arg_mtrlcode OR u_mtrldef.mtrlname = :arg_mtrlcode )
- // And ( u_mtrldef.isuse = 1 );
- // IF sqlca.SQLCode <> 0 THEN
- // SELECT count(*) INTO :cnt
- // FROM u_mtrldef
- // WHERE ( u_mtrldef.mtrlcode LIKE :ls_like_mtrlcode OR u_mtrldef.mtrlname LIKE :ls_like_mtrlcode )
- // And ( u_mtrldef.isuse = 1 );
- // IF sqlca.SQLCode <> 0 THEN
- // rslt = 0
- // GOTO ext
- // END IF
- //
- // IF cnt <> 1 THEN
- // rslt = 0
- // GOTO ext
- // ELSE
- //
- // SELECT u_mtrldef.mtrlid,
- // u_mtrldef.mtrlcode,
- // u_mtrldef.mtrlname,
- // u_mtrldef.unit,
- // u_mtrldef.mtrlmode,
- // u_mtrldef.mtrltype,
- // u_mtrldef.prdpackcode,
- // u_mtrldef.packqty,
- // u_mtrldef.lmbuyprice,
- // u_mtrldef.lmsaleprice,
- // u_mtrldef.unit_buy,
- // u_mtrldef.rate_buy,
- // u_mtrldef.dscrp,
- // u_mtrldef.mprice,
- // u_mtrldef.mtrlorigin,
- // u_mtrldef.mtrlsectype,
- // u_mtrldef.zxmtrlmode,
- // u_mtrldef.mtrlkind,
- // u_mtrldef.statusflag,
- // u_mtrldef.woodcodeflag,
- // u_mtrldef.pcodeflag,
- // u_mtrldef.statustype,
- // u_mtrldef.woodcodetype,
- // u_mtrldef.pcodetype,
- // u_mtrldef.mtrlarea,
- // u_mtrldef.minbuyqty,
- // u_mtrldef.mtrlarea1,
- // u_mtrldef.mtrlarea2,
- // u_mtrldef.net_weight,
- // u_mtrldef.gross_weight,
- // u_mtrldef.cubage,
- // u_mtrldef.scidprice,
- // u_mtrldef.configcodetype,
- // u_mtrldef.configcode,
- // u_mtrldef.configname,
- // u_mtrldef.mtrlcolor,
- // u_mtrldef.ifautodd,
- // u_mtrldef.iflljg,
- // u_mtrldef.orderdays,
- // u_mtrldef.buydays,
- // u_mtrldef.wfjgdays,
- // u_mtrldef.aheaddays,
- // u_mtrldef.ifunit,
- // u_mtrldef.usermtrlmode,
- // u_mtrldef.ifmtrlcuscode,
- // u_mtrldef.buyunit,
- // u_mtrldef.wfjgunit,
- // u_mtrldef.scllunit,
- // u_mtrldef.saleunit,
- // u_mtrldef.unit_scll,
- // u_mtrldef.unit_sale,
- // u_mtrldef.rate_scll,
- // u_mtrldef.rate_sale,
- // u_mtrldef.buydec,
- // u_mtrldef.wfjgdec,
- // u_mtrldef.sclldec,
- // u_mtrldef.saledec,
- // u_mtrldef.expday,
- // u_mtrldef.outtype,
- // u_mtrldef.ifpackpro,
- // u_mtrldef.maxqty,
- // u_mtrldef.minqty,
- // u_mtrldef.capaparm,
- // u_mtrldef.sctaskqty,
- // u_mtrldef.mtrlprp,
- // u_mtrldef.maxarg,
- // u_mtrldef.minarg,
- // u_mtrldef.maxdays,
- // u_mtrldef.mindays,
- // u_mtrldef.dftwrkGrpid,
- // u_mtrldef.ifusedeliqty,
- // u_mtrldef.status_config,
- // u_mtrldef.woodcode_config,
- // u_mtrldef.pcode_config,
- // u_mtrldef.pricepztype,
- // u_mtrldef.ifcustom,
- //u_mtrldef.status_check,
- //u_mtrldef.woodcode_check,
- //u_mtrldef.pcode_check,
- //u_mtrldef.handtype,
- //u_mtrldef.ifpack,
- //u_mtrldef.ifpackpz,
- //u_mtrldef.ifpackpro2,
- //u_mtrldef.ifpacktype,
- //u_mtrldef.mtrlengname
- // INTO
- // :ll_mtrlid,
- // :ls_mtrlcode,
- // :ls_mtrlname,
- // :ls_unit,
- // :ls_mtrlmode,
- // :ls_mtrltype,
- // :ls_prdpackcode,
- // :ld_packqty,
- // :ld_lmbuyprice,
- // :ld_lmsaleprice,
- // :ls_unit_buy,
- // :ld_rate_buy,
- // :ls_dscrp,
- // :ld_mprice,
- // :li_mtrlorigin,
- // :ls_mtrlsectype,
- // :ls_zxmtrlmode,
- // :li_mtrlkind,
- // :li_statusflag,
- // :li_woodcodeflag,
- // :li_pcodeflag,
- // :ll_statustype,
- // :ll_woodcodetype,
- // :ll_pcodetype,
- // :ld_mtrlarea,
- // :ld_minbuyqty,
- // :ld_mtrlarea1,
- // :ld_mtrlarea2,
- // :ld_net_weight,
- // :ld_gross_weight,
- // :ld_cubage,
- // :ld_scidprice,
- // :ll_configcodetype,
- // :ls_configcode,
- // :ls_configname,
- // :ls_mtrlcolor,
- // :ll_ifautodd,
- // :ll_iflljg,
- // :ld_orderdays,
- // :ld_buydays,
- // :ld_wfjgdays,
- // :ld_aheaddays,
- // :li_ifunit,
- // :ls_usermtrlmode,
- // :li_ifmtrlcuscode,
- // :li_buyunit,
- // :li_wfjgunit,
- // :li_scllunit,
- // :li_saleunit,
- // :ls_unit_scll,
- // :ls_unit_sale,
- // :ld_rate_scll,
- // :ld_rate_sale,
- // :li_buydec,
- // :li_wfjgdec,
- // :li_sclldec,
- // :li_saledec,
- // :ld_expday,
- // :li_outtype,
- // :li_ifpackpro,
- // :ld_maxqty,
- // :ld_minqty,
- // :ld_capaparm,
- // :ld_sctaskqty,
- // :li_mtrlprp,
- // :ld_maxarg,
- // :ld_minarg,
- // :ld_maxdays,
- // :ld_mindays,
- // :ll_dftwrkGrpid,
- // :li_ifusedeliqty,
- // :ls_status_config,
- // :ls_woodcode_config,
- // :ls_pcode_config,
- // :li_pricepztype,
- // :li_ifcustom,
- //:li_status_check,
- //:li_woodcode_check,
- //:li_pcode_check,
- //:ls_handtype,
- //:li_ifpack,
- //:li_ifpackpz,
- //:li_ifpackpro2,
- //:li_ifpacktype,
- //:ls_mtrlengname
- // FROM u_mtrldef
- // WHERE ( u_mtrldef.mtrlcode LIKE :ls_like_mtrlcode OR u_mtrldef.mtrlname LIKE :ls_like_mtrlcode )
- // And ( u_mtrldef.isuse = 1 );
- // IF sqlca.SQLCode <> 0 THEN
- // rslt = 0
- // GOTO ext
- // ELSE
- // if_find = True
- // END IF
- // END IF
- // ELSE
- // if_find = True
- // END IF
- //ELSE
- // SELECT u_mtrldef.mtrlid,
- // u_mtrldef.mtrlcode,
- // u_mtrldef.mtrlname,
- // u_mtrldef.unit,
- // u_mtrldef.mtrlmode,
- // u_mtrldef.mtrltype,
- // u_mtrldef.prdpackcode,
- // u_mtrldef.packqty,
- // u_mtrldef.lmbuyprice,
- // u_mtrldef.lmsaleprice,
- // u_mtrldef.unit_buy,
- // u_mtrldef.rate_buy,
- // u_mtrldef.dscrp,
- // u_mtrldef.mprice,
- // u_mtrldef.mtrlorigin,
- // u_mtrldef.mtrlsectype,
- // u_mtrldef.zxmtrlmode,
- // u_mtrldef.mtrlkind,
- // u_mtrldef.statusflag,
- // u_mtrldef.woodcodeflag,
- // u_mtrldef.pcodeflag,
- // u_mtrldef.statustype,
- // u_mtrldef.woodcodetype,
- // u_mtrldef.pcodetype,
- // u_mtrldef.mtrlarea,
- // u_mtrldef.minbuyqty,
- // u_mtrldef.mtrlarea1,
- // u_mtrldef.mtrlarea2,
- // u_mtrldef.net_weight,
- // u_mtrldef.gross_weight,
- // u_mtrldef.cubage,
- // u_mtrldef.scidprice,
- // u_mtrldef.configcodetype,
- // u_mtrldef.configcode,
- // u_mtrldef.configname,
- // u_mtrldef.mtrlcolor,
- // u_mtrldef.ifautodd,
- // u_mtrldef.iflljg,
- // u_mtrldef.orderdays,
- // u_mtrldef.buydays,
- // u_mtrldef.wfjgdays,
- // u_mtrldef.aheaddays,
- // u_mtrldef.ifunit,
- // u_mtrldef.usermtrlmode,
- // u_mtrldef.ifmtrlcuscode,
- // u_mtrldef.buyunit,
- // u_mtrldef.wfjgunit,
- // u_mtrldef.scllunit,
- // u_mtrldef.saleunit,
- // u_mtrldef.unit_scll,
- // u_mtrldef.unit_sale,
- // u_mtrldef.rate_scll,
- // u_mtrldef.rate_sale,
- // u_mtrldef.buydec,
- // u_mtrldef.wfjgdec,
- // u_mtrldef.sclldec,
- // u_mtrldef.saledec,
- // u_mtrldef.expday,
- // u_mtrldef.outtype,
- // u_mtrldef.ifpackpro,
- // u_mtrldef.maxqty,
- // u_mtrldef.minqty,
- // u_mtrldef.capaparm,
- // u_mtrldef.sctaskqty,
- // u_mtrldef.mtrlprp,
- // u_mtrldef.maxarg,
- // u_mtrldef.minarg,
- // u_mtrldef.maxdays,
- // u_mtrldef.mindays,
- // u_mtrldef.dftwrkGrpid,
- // u_mtrldef.ifusedeliqty,
- // u_mtrldef.status_config,
- // u_mtrldef.woodcode_config,
- // u_mtrldef.pcode_config,
- // u_mtrldef.pricepztype,
- // u_mtrldef.ifcustom,
- //u_mtrldef.status_check,
- //u_mtrldef.woodcode_check,
- //u_mtrldef.pcode_check,
- //u_mtrldef.handtype,
- //u_mtrldef.ifpack,
- //u_mtrldef.ifpackpz,
- //u_mtrldef.ifpackpro2,
- //u_mtrldef.ifpacktype,
- //u_mtrldef.mtrlengname
- // INTO :ll_mtrlid,
- // :ls_mtrlcode,
- // :ls_mtrlname,
- // :ls_unit,
- // :ls_mtrlmode,
- // :ls_mtrltype,
- // :ls_prdpackcode,
- // :ld_packqty,
- // :ld_lmbuyprice,
- // :ld_lmsaleprice,
- // :ls_unit_buy,
- // :ld_rate_buy,
- // :ls_dscrp,
- // :ld_mprice,
- // :li_mtrlorigin,
- // :ls_mtrlsectype,
- // :ls_zxmtrlmode,
- // :li_mtrlkind,
- // :li_statusflag,
- // :li_woodcodeflag,
- // :li_pcodeflag,
- // :ll_statustype,
- // :ll_woodcodetype,
- // :ll_pcodetype,
- // :ld_mtrlarea,
- // :ld_minbuyqty,
- // :ld_mtrlarea1,
- // :ld_mtrlarea2,
- // :ld_net_weight,
- // :ld_gross_weight,
- // :ld_cubage,
- // :ld_scidprice,
- // :ll_configcodetype,
- // :ls_configcode,
- // :ls_configname,
- // :ls_mtrlcolor,
- // :ll_ifautodd,
- // :ll_iflljg,
- // :ld_orderdays,
- // :ld_buydays,
- // :ld_wfjgdays,
- // :ld_aheaddays,
- // :li_ifunit,
- // :ls_usermtrlmode,
- // :li_ifmtrlcuscode,
- // :li_buyunit,
- // :li_wfjgunit,
- // :li_scllunit,
- // :li_saleunit,
- // :ls_unit_scll,
- // :ls_unit_sale,
- // :ld_rate_scll,
- // :ld_rate_sale,
- // :li_buydec,
- // :li_wfjgdec,
- // :li_sclldec,
- // :li_saledec,
- // :ld_expday,
- // :li_outtype,
- // :li_ifpackpro,
- // :ld_maxqty,
- // :ld_minqty,
- // :ld_capaparm,
- // :ld_sctaskqty,
- // :li_mtrlprp,
- // :ld_maxarg,
- // :ld_minarg,
- // :ld_maxdays,
- // :ld_mindays,
- // :ll_dftwrkGrpid,
- // :li_ifusedeliqty,
- // :ls_status_config,
- // :ls_woodcode_config,
- // :ls_pcode_config,
- // :li_pricepztype,
- // :li_ifcustom,
- //:li_status_check,
- //:li_woodcode_check,
- //:li_pcode_check,
- //:ls_handtype,
- //:li_ifpack,
- //:li_ifpackpz,
- //:li_ifpackpro2,
- //:li_ifpacktype,
- //:ls_mtrlengname
- // FROM u_mtrldef LEFT OUTER JOIN
- // u_mtrl_storage ON u_mtrldef.mtrlid = u_mtrl_storage.mtrlid
- // WHERE ( u_mtrldef.mtrlcode = :arg_mtrlcode OR u_mtrldef.mtrlname = :arg_mtrlcode )
- // AND ( u_mtrl_storage.storageid = :arg_storageid OR :arg_storageid = -1 )
- // And ( u_mtrldef.isuse = 1 );
- //
- // IF sqlca.SQLCode <> 0 THEN
- // SELECT count(*) INTO :cnt
- // FROM u_mtrldef LEFT OUTER JOIN
- // u_mtrl_storage ON u_mtrldef.mtrlid = u_mtrl_storage.mtrlid
- // WHERE ( u_mtrldef.mtrlcode LIKE :ls_like_mtrlcode OR u_mtrldef.mtrlname LIKE :ls_like_mtrlcode )
- // AND ( u_mtrl_storage.storageid = :arg_storageid OR :arg_storageid = -1 )
- // And ( u_mtrldef.isuse = 1 );
- // IF sqlca.SQLCode <> 0 THEN
- // rslt = 0
- // GOTO ext
- // END IF
- //
- // IF cnt <> 1 THEN
- // rslt = 0
- // GOTO ext
- // ELSE
- //
- // SELECT u_mtrldef.mtrlid,
- // u_mtrldef.mtrlcode,
- // u_mtrldef.mtrlname,
- // u_mtrldef.unit,
- // u_mtrldef.mtrlmode,
- // u_mtrldef.mtrltype,
- // u_mtrldef.prdpackcode,
- // u_mtrldef.packqty,
- // u_mtrldef.lmbuyprice,
- // u_mtrldef.lmsaleprice,
- // u_mtrldef.unit_buy,
- // u_mtrldef.rate_buy,
- // u_mtrldef.dscrp,
- // u_mtrldef.mprice,
- // u_mtrldef.mtrlorigin,
- // u_mtrldef.mtrlsectype,
- // u_mtrldef.zxmtrlmode,
- // u_mtrldef.mtrlkind,
- // u_mtrldef.statusflag,
- // u_mtrldef.woodcodeflag,
- // u_mtrldef.pcodeflag,
- // u_mtrldef.statustype,
- // u_mtrldef.woodcodetype,
- // u_mtrldef.pcodetype,
- // u_mtrldef.mtrlarea,
- // u_mtrldef.minbuyqty,
- // u_mtrldef.mtrlarea1,
- // u_mtrldef.mtrlarea2,
- // u_mtrldef.net_weight,
- // u_mtrldef.gross_weight,
- // u_mtrldef.cubage,
- // u_mtrldef.scidprice,
- // u_mtrldef.configcodetype,
- // u_mtrldef.configcode,
- // u_mtrldef.configname,
- // u_mtrldef.mtrlcolor,
- // u_mtrldef.ifautodd,
- // u_mtrldef.iflljg,
- // u_mtrldef.orderdays,
- // u_mtrldef.buydays,
- // u_mtrldef.wfjgdays,
- // u_mtrldef.aheaddays,
- // u_mtrldef.ifunit,
- // u_mtrldef.usermtrlmode,
- // u_mtrldef.ifmtrlcuscode,
- // u_mtrldef.buyunit,
- // u_mtrldef.wfjgunit,
- // u_mtrldef.scllunit,
- // u_mtrldef.saleunit,
- // u_mtrldef.unit_scll,
- // u_mtrldef.unit_sale,
- // u_mtrldef.rate_scll,
- // u_mtrldef.rate_sale,
- // u_mtrldef.buydec,
- // u_mtrldef.wfjgdec,
- // u_mtrldef.sclldec,
- // u_mtrldef.saledec,
- // u_mtrldef.expday,
- // u_mtrldef.outtype,
- // u_mtrldef.ifpackpro,
- // u_mtrldef.maxqty,
- // u_mtrldef.minqty,
- // u_mtrldef.capaparm,
- // u_mtrldef.sctaskqty,
- // u_mtrldef.mtrlprp,
- // u_mtrldef.maxarg,
- // u_mtrldef.minarg,
- // u_mtrldef.maxdays,
- // u_mtrldef.mindays,
- // u_mtrldef.dftwrkGrpid,
- // u_mtrldef.ifusedeliqty,
- // u_mtrldef.status_config,
- // u_mtrldef.woodcode_config,
- // u_mtrldef.pcode_config,
- // u_mtrldef.pricepztype,
- // u_mtrldef.ifcustom,
- //u_mtrldef.status_check,
- //u_mtrldef.woodcode_check,
- //u_mtrldef.pcode_check,
- //u_mtrldef.handtype,
- //u_mtrldef.ifpack,
- //u_mtrldef.ifpackpz,
- //u_mtrldef.ifpackpro2,
- //u_mtrldef.ifpacktype,
- //u_mtrldef.mtrlengname
- // INTO
- // :ll_mtrlid,
- // :ls_mtrlcode,
- // :ls_mtrlname,
- // :ls_unit,
- // :ls_mtrlmode,
- // :ls_mtrltype,
- // :ls_prdpackcode,
- // :ld_packqty,
- // :ld_lmbuyprice,
- // :ld_lmsaleprice,
- // :ls_unit_buy,
- // :ld_rate_buy,
- // :ls_dscrp,
- // :ld_mprice,
- // :li_mtrlorigin,
- // :ls_mtrlsectype,
- // :ls_zxmtrlmode,
- // :li_mtrlkind,
- // :li_statusflag,
- // :li_woodcodeflag,
- // :li_pcodeflag,
- // :ll_statustype,
- // :ll_woodcodetype,
- // :ll_pcodetype,
- // :ld_mtrlarea,
- // :ld_minbuyqty,
- // :ld_mtrlarea1,
- // :ld_mtrlarea2,
- // :ld_net_weight,
- // :ld_gross_weight,
- // :ld_cubage,
- // :ld_scidprice,
- // :ll_configcodetype,
- // :ls_configcode,
- // :ls_configname,
- // :ls_mtrlcolor,
- // :ll_ifautodd,
- // :ll_iflljg,
- // :ld_orderdays,
- // :ld_buydays,
- // :ld_wfjgdays,
- // :ld_aheaddays,
- // :li_ifunit,
- // :ls_usermtrlmode,
- // :li_ifmtrlcuscode,
- // :li_buyunit,
- // :li_wfjgunit,
- // :li_scllunit,
- // :li_saleunit,
- // :ls_unit_scll,
- // :ls_unit_sale,
- // :ld_rate_scll,
- // :ld_rate_sale,
- // :li_buydec,
- // :li_wfjgdec,
- // :li_sclldec,
- // :li_saledec,
- // :ld_expday,
- // :li_outtype,
- // :li_ifpackpro,
- // :ld_maxqty,
- // :ld_minqty,
- // :ld_capaparm,
- // :ld_sctaskqty,
- // :li_mtrlprp,
- // :ld_maxarg,
- // :ld_minarg,
- // :ld_maxdays,
- // :ld_mindays,
- // :ll_dftwrkGrpid,
- // :li_ifusedeliqty,
- // :ls_status_config,
- // :ls_woodcode_config,
- // :ls_pcode_config,
- // :li_pricepztype,
- // :li_ifcustom,
- //:li_status_check,
- //:li_woodcode_check,
- //:li_pcode_check,
- //:ls_handtype,
- //:li_ifpack,
- //:li_ifpackpz,
- //:li_ifpackpro2,
- //:li_ifpacktype,
- //:ls_mtrlengname
- // FROM u_mtrldef LEFT OUTER JOIN
- // u_mtrl_storage ON u_mtrldef.mtrlid = u_mtrl_storage.mtrlid
- // WHERE ( u_mtrldef.mtrlcode LIKE :ls_like_mtrlcode OR u_mtrldef.mtrlname LIKE :ls_like_mtrlcode )
- // AND ( u_mtrl_storage.storageid = :arg_storageid OR :arg_storageid = -1 )
- // And ( u_mtrldef.isuse = 1 );
- // IF sqlca.SQLCode <> 0 THEN
- // rslt = 0
- // GOTO ext
- // ELSE
- // if_find = True
- // END IF
- // END IF
- // ELSE
- // if_find = True
- // END IF
- //END IF
- //
- //IF if_find THEN
- // f_get_planprice_mtrl(ll_mtrlid,'','','',ld_planprice)
- // arg_s_mtrldef.planprice[1] = ld_planprice
- //
- //
- // arg_s_mtrldef.mtrlid[1] = ll_mtrlid
- // arg_s_mtrldef.mtrlcode[1] = ls_mtrlcode
- // arg_s_mtrldef.mtrlname[1] = ls_mtrlname
- // arg_s_mtrldef.unit[1] = ls_unit
- // arg_s_mtrldef.mtrlmode[1] = ls_mtrlmode
- // arg_s_mtrldef.planprice[1] = ld_planprice
- // arg_s_mtrldef.mtrltype[1] = ls_mtrltype
- // arg_s_mtrldef.prdpackcode[1] = ls_prdpackcode
- // arg_s_mtrldef.packqty[1] = ld_packqty
- // arg_s_mtrldef.lmbuyprice[1] = ld_lmbuyprice
- // arg_s_mtrldef.lmsaleprice[1] = ld_lmsaleprice
- // arg_s_mtrldef.unit_buy[1] = ls_unit_buy
- // arg_s_mtrldef.rate_buy[1] = ld_rate_buy
- // arg_s_mtrldef.dscrp[1] = ls_dscrp
- // arg_s_mtrldef.mprice[1] = ld_mprice
- // arg_s_mtrldef.mtrlorigin[1] = li_mtrlorigin
- // arg_s_mtrldef.mtrlsectype[1] = ls_mtrlsectype
- // arg_s_mtrldef.zxmtrlmode[1] = ls_zxmtrlmode
- // arg_s_mtrldef.mtrlkind[1] = li_mtrlkind
- // arg_s_mtrldef.statusflag[1] = li_statusflag
- // arg_s_mtrldef.statustype[1] = ll_statustype
- // arg_s_mtrldef.woodcodeflag[1] = li_woodcodeflag
- // arg_s_mtrldef.woodcodetype[1] = ll_woodcodetype
- // arg_s_mtrldef.pcodeflag[1] = li_pcodeflag
- // arg_s_mtrldef.pcodetype[1] = ll_pcodetype
- // arg_s_mtrldef.mtrlarea[1] = ld_mtrlarea
- // arg_s_mtrldef.minbuyqty[1] = ld_minbuyqty
- // arg_s_mtrldef.mtrlarea1[1] = ld_mtrlarea1
- // arg_s_mtrldef.mtrlarea2[1] = ld_mtrlarea2
- // arg_s_mtrldef.net_weight[1] = ld_net_weight
- // arg_s_mtrldef.gross_weight[1] = ld_gross_weight
- // arg_s_mtrldef.cubage[1] = ld_cubage
- // arg_s_mtrldef.scidprice[1] = ld_scidprice
- //
- // arg_s_mtrldef.configcodetype[1] = ll_configcodetype
- // arg_s_mtrldef.configcode[1] = ls_configcode
- // arg_s_mtrldef.configname[1] = ls_configname
- // arg_s_mtrldef.mtrlcolor[1] = ls_mtrlcolor
- // arg_s_mtrldef.ifautodd[1] = ll_ifautodd
- // arg_s_mtrldef.iflljg[1] = ll_iflljg
- //
- // arg_s_mtrldef.orderdays[1] = ld_orderdays
- // arg_s_mtrldef.buydays[1] = ld_buydays
- // arg_s_mtrldef.wfjgdays[1] = ld_wfjgdays
- // arg_s_mtrldef.aheaddays[1] = ld_aheaddays
- // arg_s_mtrldef.ifunit[1] = li_ifunit
- // arg_s_mtrldef.usermtrlmode[1] = ls_usermtrlmode
- // arg_s_mtrldef.ifmtrlcuscode[1] = li_ifmtrlcuscode
- // arg_s_mtrldef.buyunit[1] = li_buyunit
- // arg_s_mtrldef.wfjgunit[1] = li_wfjgunit
- // arg_s_mtrldef.scllunit[1] = li_scllunit
- // arg_s_mtrldef.saleunit[1] = li_saleunit
- //
- // arg_s_mtrldef.unit_scll[1] = ls_unit_scll
- // arg_s_mtrldef.unit_sale[1] = ls_unit_sale
- // arg_s_mtrldef.rate_scll[1] = ld_rate_scll
- // arg_s_mtrldef.rate_sale[1] = ld_rate_sale
- //
- // arg_s_mtrldef.buydec[1] = li_buydec
- // arg_s_mtrldef.wfjgdec[1] = li_wfjgdec
- // arg_s_mtrldef.sclldec[1] = li_sclldec
- // arg_s_mtrldef.saledec[1] = li_saledec
- // arg_s_mtrldef.expday[1] = ld_expday
- //
- // arg_s_mtrldef.outtype[1] = li_outtype
- // arg_s_mtrldef.ifpackpro[1] = li_ifpackpro
- // arg_s_mtrldef.maxqty[1] = ld_maxqty
- // arg_s_mtrldef.minqty[1] = ld_minqty
- // arg_s_mtrldef.capaparm[1] = ld_capaparm
- // arg_s_mtrldef.sctaskqty[1] = ld_sctaskqty
- // arg_s_mtrldef.mtrlprp[1] = li_mtrlprp
- //
- // arg_s_mtrldef.maxarg[1] = ld_maxarg
- // arg_s_mtrldef.minarg[1] = ld_minarg
- //
- // arg_s_mtrldef.maxdays[1] = ld_maxdays
- // arg_s_mtrldef.mindays[1] = ld_mindays
- // arg_s_mtrldef.dftwrkGrpid[1] = ll_dftwrkGrpid
- // arg_s_mtrldef.ifusedeliqty[1] = li_ifusedeliqty
- //
- // arg_s_mtrldef.status_config[1] = ls_status_config
- // arg_s_mtrldef.woodcode_config[1] = ls_woodcode_config
- // arg_s_mtrldef.pcode_config[1] = ls_pcode_config
- // arg_s_mtrldef.pricepztype[1] = li_pricepztype
- //
- // arg_s_mtrldef.ifcustom[1] = li_ifcustom
- // arg_s_mtrldef.status_check[1] = li_status_check
- // arg_s_mtrldef.woodcode_check[1] = li_woodcode_check
- // arg_s_mtrldef.pcode_check[1] = li_pcode_check
- // arg_s_mtrldef.handtype[1] = ls_handtype
- // arg_s_mtrldef.ifpack[1] = li_ifpack
- // arg_s_mtrldef.ifpackpz[1] = li_ifpackpz
- // arg_s_mtrldef.ifpackpro2[1] = li_ifpackpro2
- // arg_s_mtrldef.ifpacktype[1] = li_ifpacktype
- // arg_s_mtrldef.mtrlengname[1] = ls_mtrlengname
- //
- //END IF
- //
- //ext:
- RETURN rslt
- end function
- global function integer f_find_mtrl_ljfieb (string arg_mtrlcode, ref s_mtrldef_array arg_s_mtrldef);Int rslt = 1
- Long cnt = 0
- String ls_like_mtrlcode
- String ls_mtrlcode,ls_mtrlname,ls_unit,ls_mtrlmode,ls_mtrltype
- String ls_mtrlsectype,ls_zxmtrlmode,ls_mtrlengname
- String ls_unit_buy,ls_dscrp
- Long ll_mtrlid
- String ls_prdpackcode
- Decimal ld_packqty,ld_planprice,ld_lmbuyprice,ld_lmsaleprice
- Decimal ld_rate_buy,ld_mprice
- Int li_mtrlorigin,li_mtrlkind
- Int li_statusflag,li_woodcodeflag,li_pcodeflag
- Long ll_statustype,ll_woodcodetype,ll_pcodetype
- Decimal ld_mtrlarea,ld_mtrlarea1,ld_mtrlarea2
- Decimal ld_minbuyqty
- Decimal ld_net_weight,ld_gross_weight,ld_cubage
- Decimal ld_scidprice
- Decimal ld_orderdays,ld_buydays,ld_wfjgdays,ld_aheaddays
- Int li_ifunit
- Long ll_configcodetype
- String ls_configcode,ls_configname,ls_mtrlcolor
- Long ll_ifautodd,ll_iflljg
- String ls_usermtrlmode
- Int li_ifmtrlcuscode
- Int li_buyunit,li_scllunit,li_wfjgunit,li_saleunit
- String ls_unit_scll,ls_unit_sale
- Decimal ld_rate_scll,ld_rate_sale
- Int li_buydec,li_wfjgdec,li_sclldec,li_saledec
- Decimal ld_expday
- Int li_outtype,li_ifpackpro
- Decimal ld_maxqty,ld_minqty,ld_capaparm,ld_sctaskqty
- Int li_mtrlprp
- Decimal ld_maxarg,ld_minarg
- Decimal ld_maxdays,ld_mindays
- Long ll_dftwrkGrpid
- Int li_ifusedeliqty
- String ls_status_config,ls_woodcode_config,ls_pcode_config
- Int li_pricepztype
- Int li_ifcustom,li_status_check,li_woodcode_check,li_pcode_check
- String ls_handtype
- Int li_ifpack
- Int li_ifpackpz
- Int li_ifpackpro2
- Int li_ifpacktype
- long ll_mtrltypeid
- Boolean if_find = False
- IF Trim(arg_mtrlcode) = '' THEN
- rslt = 0
- GOTO ext
- END IF
- SELECT u_mtrldef.mtrlid,
- u_mtrldef.mtrlcode,
- u_mtrldef.mtrlname,
- u_mtrldef.unit,
- u_mtrldef.mtrlmode,
- u_mtrldef.mtrltype,
- u_mtrldef.prdpackcode,
- u_mtrldef.packqty,
- u_mtrldef.lmbuyprice,
- u_mtrldef.lmsaleprice,
- u_mtrldef.unit_buy,
- u_mtrldef.rate_buy,
- u_mtrldef.dscrp,
- // u_mtrldef.mprice,
- u_mtrldef.mtrlorigin,
- u_mtrldef.mtrlsectype,
- u_mtrldef.zxmtrlmode,
- u_mtrldef.mtrlkind,
- u_mtrldef.statusflag,
- u_mtrldef.woodcodeflag,
- u_mtrldef.pcodeflag,
- u_mtrldef.statustype,
- u_mtrldef.woodcodetype,
- u_mtrldef.pcodetype,
- // u_mtrldef.mtrlarea,
- // u_mtrldef.minbuyqty,
- // u_mtrldef.mtrlarea1,
- // u_mtrldef.mtrlarea2,
- u_mtrldef.net_weight,
- u_mtrldef.gross_weight,
- u_mtrldef.cubage,
- // u_mtrldef.scidprice,
- u_mtrldef.configcodetype,
- u_mtrldef.configcode,
- u_mtrldef.configname,
- u_mtrldef.mtrlcolor,
- // u_mtrldef.ifautodd,
- // u_mtrldef.iflljg,
- // u_mtrldef.orderdays,
- // u_mtrldef.buydays,
- // u_mtrldef.wfjgdays,
- // u_mtrldef.aheaddays,
- u_mtrldef.ifunit,
- u_mtrldef.usermtrlmode,
- // u_mtrldef.ifmtrlcuscode,
- u_mtrldef.buyunit,
- u_mtrldef.wfjgunit,
- u_mtrldef.scllunit,
- u_mtrldef.saleunit,
- u_mtrldef.unit_scll,
- u_mtrldef.unit_sale,
- u_mtrldef.rate_scll,
- u_mtrldef.rate_sale,
- u_mtrldef.buydec,
- u_mtrldef.wfjgdec,
- u_mtrldef.sclldec,
- u_mtrldef.saledec,
- // u_mtrldef.expday,
- // u_mtrldef.outtype,
- u_mtrldef.ifpackpro,
- u_mtrldef.maxqty,
- u_mtrldef.minqty,
- // u_mtrldef.capaparm,
- // u_mtrldef.sctaskqty,
- u_mtrldef.mtrlprp,
- // u_mtrldef.maxarg,
- // u_mtrldef.minarg,
- // u_mtrldef.maxdays,
- // u_mtrldef.mindays,
- // u_mtrldef.dftwrkGrpid,
- // u_mtrldef.ifusedeliqty,
- u_mtrldef.status_config,
- u_mtrldef.woodcode_config,
- u_mtrldef.pcode_config,
- // u_mtrldef.pricepztype,
- u_mtrldef.ifcustom,
- u_mtrldef.status_check,
- u_mtrldef.woodcode_check,
- u_mtrldef.pcode_check,
- u_mtrldef.handtype,
- u_mtrldef.ifpack,
- u_mtrldef.ifpackpz,
- u_mtrldef.ifpackpro2,
- u_mtrldef.ifpacktype,
- u_mtrldef.mtrlengname,
- u_mtrldef.mtrltypeid
- INTO :ll_mtrlid,
- :ls_mtrlcode,
- :ls_mtrlname,
- :ls_unit,
- :ls_mtrlmode,
- :ls_mtrltype,
- :ls_prdpackcode,
- :ld_packqty,
- :ld_lmbuyprice,
- :ld_lmsaleprice,
- :ls_unit_buy,
- :ld_rate_buy,
- :ls_dscrp,
- // :ld_mprice,
- :li_mtrlorigin,
- :ls_mtrlsectype,
- :ls_zxmtrlmode,
- :li_mtrlkind,
- :li_statusflag,
- :li_woodcodeflag,
- :li_pcodeflag,
- :ll_statustype,
- :ll_woodcodetype,
- :ll_pcodetype,
- // :ld_mtrlarea,
- // :ld_minbuyqty,
- // :ld_mtrlarea1,
- // :ld_mtrlarea2,
- :ld_net_weight,
- :ld_gross_weight,
- :ld_cubage,
- // :ld_scidprice,
- :ll_configcodetype,
- :ls_configcode,
- :ls_configname,
- :ls_mtrlcolor,
- // :ll_ifautodd,
- // :ll_iflljg,
- // :ld_orderdays,
- // :ld_buydays,
- // :ld_wfjgdays,
- // :ld_aheaddays,
- :li_ifunit,
- :ls_usermtrlmode,
- // :li_ifmtrlcuscode,
- :li_buyunit,
- :li_wfjgunit,
- :li_scllunit,
- :li_saleunit,
- :ls_unit_scll,
- :ls_unit_sale,
- :ld_rate_scll,
- :ld_rate_sale,
- :li_buydec,
- :li_wfjgdec,
- :li_sclldec,
- :li_saledec,
- // :ld_expday,
- // :li_outtype,
- :li_ifpackpro,
- :ld_maxqty,
- :ld_minqty,
- // :ld_capaparm,
- // :ld_sctaskqty,
- :li_mtrlprp,
- // :ld_maxarg,
- // :ld_minarg,
- // :ld_maxdays,
- // :ld_mindays,
- // :ll_dftwrkGrpid,
- // :li_ifusedeliqty,
- :ls_status_config,
- :ls_woodcode_config,
- :ls_pcode_config,
- // :li_pricepztype,
- :li_ifcustom,
- :li_status_check,
- :li_woodcode_check,
- :li_pcode_check,
- :ls_handtype,
- :li_ifpack,
- :li_ifpackpz,
- :li_ifpackpro2,
- :li_ifpacktype,
- :ls_mtrlengname,
- :ll_mtrltypeid
- FROM u_mtrldef
- WHERE ( u_mtrldef.mtrlcode = :arg_mtrlcode)
- And ( u_mtrldef.isuse = 1 );
- IF sqlca.SQLCode <> 0 THEN
- rslt = 0
- goto ext
- END IF
- // f_get_planprice_mtrl(ll_mtrlid,'','','',ld_planprice)
- // arg_s_mtrldef.planprice[1] = ld_planprice
-
-
- arg_s_mtrldef.mtrlid[1] = ll_mtrlid
- arg_s_mtrldef.mtrlcode[1] = ls_mtrlcode
- arg_s_mtrldef.mtrlname[1] = ls_mtrlname
- arg_s_mtrldef.unit[1] = ls_unit
- arg_s_mtrldef.mtrlmode[1] = ls_mtrlmode
- arg_s_mtrldef.planprice[1] = ld_planprice
- arg_s_mtrldef.mtrltype[1] = ls_mtrltype
- arg_s_mtrldef.prdpackcode[1] = ls_prdpackcode
- arg_s_mtrldef.packqty[1] = ld_packqty
- arg_s_mtrldef.lmbuyprice[1] = ld_lmbuyprice
- arg_s_mtrldef.lmsaleprice[1] = ld_lmsaleprice
- arg_s_mtrldef.unit_buy[1] = ls_unit_buy
- arg_s_mtrldef.rate_buy[1] = ld_rate_buy
- arg_s_mtrldef.dscrp[1] = ls_dscrp
- // arg_s_mtrldef.mprice[1] = ld_mprice
- arg_s_mtrldef.mtrlorigin[1] = li_mtrlorigin
- arg_s_mtrldef.mtrlsectype[1] = ls_mtrlsectype
- arg_s_mtrldef.zxmtrlmode[1] = ls_zxmtrlmode
- arg_s_mtrldef.mtrlkind[1] = li_mtrlkind
- arg_s_mtrldef.statusflag[1] = li_statusflag
- arg_s_mtrldef.statustype[1] = ll_statustype
- arg_s_mtrldef.woodcodeflag[1] = li_woodcodeflag
- arg_s_mtrldef.woodcodetype[1] = ll_woodcodetype
- arg_s_mtrldef.pcodeflag[1] = li_pcodeflag
- arg_s_mtrldef.pcodetype[1] = ll_pcodetype
- // arg_s_mtrldef.mtrlarea[1] = ld_mtrlarea
- // arg_s_mtrldef.minbuyqty[1] = ld_minbuyqty
- // arg_s_mtrldef.mtrlarea1[1] = ld_mtrlarea1
- // arg_s_mtrldef.mtrlarea2[1] = ld_mtrlarea2
- arg_s_mtrldef.net_weight[1] = ld_net_weight
- arg_s_mtrldef.gross_weight[1] = ld_gross_weight
- arg_s_mtrldef.cubage[1] = ld_cubage
- // arg_s_mtrldef.scidprice[1] = ld_scidprice
-
- arg_s_mtrldef.configcodetype[1] = ll_configcodetype
- arg_s_mtrldef.configcode[1] = ls_configcode
- arg_s_mtrldef.configname[1] = ls_configname
- arg_s_mtrldef.mtrlcolor[1] = ls_mtrlcolor
- // arg_s_mtrldef.ifautodd[1] = ll_ifautodd
- // arg_s_mtrldef.iflljg[1] = ll_iflljg
-
- // arg_s_mtrldef.orderdays[1] = ld_orderdays
- // arg_s_mtrldef.buydays[1] = ld_buydays
- // arg_s_mtrldef.wfjgdays[1] = ld_wfjgdays
- // arg_s_mtrldef.aheaddays[1] = ld_aheaddays
- arg_s_mtrldef.ifunit[1] = li_ifunit
- arg_s_mtrldef.usermtrlmode[1] = ls_usermtrlmode
- // arg_s_mtrldef.ifmtrlcuscode[1] = li_ifmtrlcuscode
- arg_s_mtrldef.buyunit[1] = li_buyunit
- arg_s_mtrldef.wfjgunit[1] = li_wfjgunit
- arg_s_mtrldef.scllunit[1] = li_scllunit
- arg_s_mtrldef.saleunit[1] = li_saleunit
-
- arg_s_mtrldef.unit_scll[1] = ls_unit_scll
- arg_s_mtrldef.unit_sale[1] = ls_unit_sale
- arg_s_mtrldef.rate_scll[1] = ld_rate_scll
- arg_s_mtrldef.rate_sale[1] = ld_rate_sale
-
- arg_s_mtrldef.buydec[1] = li_buydec
- arg_s_mtrldef.wfjgdec[1] = li_wfjgdec
- arg_s_mtrldef.sclldec[1] = li_sclldec
- arg_s_mtrldef.saledec[1] = li_saledec
- // arg_s_mtrldef.expday[1] = ld_expday
- //
- // arg_s_mtrldef.outtype[1] = li_outtype
- arg_s_mtrldef.ifpackpro[1] = li_ifpackpro
- arg_s_mtrldef.maxqty[1] = ld_maxqty
- arg_s_mtrldef.minqty[1] = ld_minqty
- // arg_s_mtrldef.capaparm[1] = ld_capaparm
- // arg_s_mtrldef.sctaskqty[1] = ld_sctaskqty
- arg_s_mtrldef.mtrlprp[1] = li_mtrlprp
-
- // arg_s_mtrldef.maxarg[1] = ld_maxarg
- // arg_s_mtrldef.minarg[1] = ld_minarg
-
- // arg_s_mtrldef.maxdays[1] = ld_maxdays
- // arg_s_mtrldef.mindays[1] = ld_mindays
- // arg_s_mtrldef.dftwrkGrpid[1] = ll_dftwrkGrpid
- // arg_s_mtrldef.ifusedeliqty[1] = li_ifusedeliqty
-
- arg_s_mtrldef.status_config[1] = ls_status_config
- arg_s_mtrldef.woodcode_config[1] = ls_woodcode_config
- arg_s_mtrldef.pcode_config[1] = ls_pcode_config
- // arg_s_mtrldef.pricepztype[1] = li_pricepztype
-
- arg_s_mtrldef.ifcustom[1] = li_ifcustom
- arg_s_mtrldef.status_check[1] = li_status_check
- arg_s_mtrldef.woodcode_check[1] = li_woodcode_check
- arg_s_mtrldef.pcode_check[1] = li_pcode_check
- arg_s_mtrldef.handtype[1] = ls_handtype
- arg_s_mtrldef.ifpack[1] = li_ifpack
- arg_s_mtrldef.ifpackpz[1] = li_ifpackpz
- arg_s_mtrldef.ifpackpro2[1] = li_ifpackpro2
- arg_s_mtrldef.ifpacktype[1] = li_ifpacktype
- arg_s_mtrldef.mtrlengname[1] = ls_mtrlengname
- arg_s_mtrldef.mtrltypeid[1] = ll_mtrltypeid
-
- ext:
- RETURN rslt
- end function
|