f_find_mtrl_ljfieb.srf 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281
  1. $PBExportHeader$f_find_mtrl_ljfieb.srf
  2. global type f_find_mtrl_ljfieb from function_object
  3. end type
  4. forward prototypes
  5. global function integer f_find_mtrl_ljfieb (string arg_mtrlcode, long arg_storageid, ref s_mtrldef_array arg_s_mtrldef)
  6. global function integer f_find_mtrl_ljfieb (string arg_mtrlcode, ref s_mtrldef_array arg_s_mtrldef)
  7. end prototypes
  8. global function integer f_find_mtrl_ljfieb (string arg_mtrlcode, long arg_storageid, ref s_mtrldef_array arg_s_mtrldef);Int rslt = 1
  9. //Long cnt = 0
  10. //
  11. //String ls_like_mtrlcode
  12. //String ls_mtrlcode,ls_mtrlname,ls_unit,ls_mtrlmode,ls_mtrltype
  13. //String ls_mtrlsectype,ls_zxmtrlmode,ls_mtrlengname
  14. //String ls_unit_buy,ls_dscrp
  15. //Long ll_mtrlid
  16. //String ls_prdpackcode
  17. //Decimal ld_packqty,ld_planprice,ld_lmbuyprice,ld_lmsaleprice
  18. //Decimal ld_rate_buy,ld_mprice
  19. //Int li_mtrlorigin,li_mtrlkind
  20. //Int li_statusflag,li_woodcodeflag,li_pcodeflag
  21. //Long ll_statustype,ll_woodcodetype,ll_pcodetype
  22. //Decimal ld_mtrlarea,ld_mtrlarea1,ld_mtrlarea2
  23. //Decimal ld_minbuyqty
  24. //Decimal ld_net_weight,ld_gross_weight,ld_cubage
  25. //Decimal ld_scidprice
  26. //Decimal ld_orderdays,ld_buydays,ld_wfjgdays,ld_aheaddays
  27. //Int li_ifunit
  28. //Long ll_configcodetype
  29. //String ls_configcode,ls_configname,ls_mtrlcolor
  30. //Long ll_ifautodd,ll_iflljg
  31. //String ls_usermtrlmode
  32. //Int li_ifmtrlcuscode
  33. //Int li_buyunit,li_scllunit,li_wfjgunit,li_saleunit
  34. //String ls_unit_scll,ls_unit_sale
  35. //Decimal ld_rate_scll,ld_rate_sale
  36. //Int li_buydec,li_wfjgdec,li_sclldec,li_saledec
  37. //Decimal ld_expday
  38. //Int li_outtype,li_ifpackpro
  39. //Decimal ld_maxqty,ld_minqty,ld_capaparm,ld_sctaskqty
  40. //Int li_mtrlprp
  41. //Decimal ld_maxarg,ld_minarg
  42. //Decimal ld_maxdays,ld_mindays
  43. //Long ll_dftwrkGrpid
  44. //Int li_ifusedeliqty
  45. //String ls_status_config,ls_woodcode_config,ls_pcode_config
  46. //Int li_pricepztype
  47. //int li_ifcustom,li_status_check,li_woodcode_check,li_pcode_check
  48. //string ls_handtype
  49. //int li_ifpack
  50. //int li_ifpackpz
  51. //int li_ifpackpro2
  52. //int li_ifpacktype
  53. //
  54. //Boolean if_find = False
  55. //
  56. //IF Trim(arg_mtrlcode) = '' THEN
  57. // rslt = 0
  58. // GOTO ext
  59. //END IF
  60. //
  61. //IF Pos(Trim(arg_mtrlcode),'%') = 0 THEN
  62. // ls_like_mtrlcode = '%'+ Trim(arg_mtrlcode) + '%'
  63. //ELSE
  64. // ls_like_mtrlcode = Trim(arg_mtrlcode)
  65. //END IF
  66. //
  67. //IF arg_storageid = -1 THEN
  68. //
  69. // SELECT u_mtrldef.mtrlid,
  70. // u_mtrldef.mtrlcode,
  71. // u_mtrldef.mtrlname,
  72. // u_mtrldef.unit,
  73. // u_mtrldef.mtrlmode,
  74. // u_mtrldef.mtrltype,
  75. // u_mtrldef.prdpackcode,
  76. // u_mtrldef.packqty,
  77. // u_mtrldef.lmbuyprice,
  78. // u_mtrldef.lmsaleprice,
  79. // u_mtrldef.unit_buy,
  80. // u_mtrldef.rate_buy,
  81. // u_mtrldef.dscrp,
  82. // u_mtrldef.mprice,
  83. // u_mtrldef.mtrlorigin,
  84. // u_mtrldef.mtrlsectype,
  85. // u_mtrldef.zxmtrlmode,
  86. // u_mtrldef.mtrlkind,
  87. // u_mtrldef.statusflag,
  88. // u_mtrldef.woodcodeflag,
  89. // u_mtrldef.pcodeflag,
  90. // u_mtrldef.statustype,
  91. // u_mtrldef.woodcodetype,
  92. // u_mtrldef.pcodetype,
  93. // u_mtrldef.mtrlarea,
  94. // u_mtrldef.minbuyqty,
  95. // u_mtrldef.mtrlarea1,
  96. // u_mtrldef.mtrlarea2,
  97. // u_mtrldef.net_weight,
  98. // u_mtrldef.gross_weight,
  99. // u_mtrldef.cubage,
  100. // u_mtrldef.scidprice,
  101. // u_mtrldef.configcodetype,
  102. // u_mtrldef.configcode,
  103. // u_mtrldef.configname,
  104. // u_mtrldef.mtrlcolor,
  105. // u_mtrldef.ifautodd,
  106. // u_mtrldef.iflljg,
  107. // u_mtrldef.orderdays,
  108. // u_mtrldef.buydays,
  109. // u_mtrldef.wfjgdays,
  110. // u_mtrldef.aheaddays,
  111. // u_mtrldef.ifunit,
  112. // u_mtrldef.usermtrlmode,
  113. // u_mtrldef.ifmtrlcuscode,
  114. // u_mtrldef.buyunit,
  115. // u_mtrldef.wfjgunit,
  116. // u_mtrldef.scllunit,
  117. // u_mtrldef.saleunit,
  118. // u_mtrldef.unit_scll,
  119. // u_mtrldef.unit_sale,
  120. // u_mtrldef.rate_scll,
  121. // u_mtrldef.rate_sale,
  122. // u_mtrldef.buydec,
  123. // u_mtrldef.wfjgdec,
  124. // u_mtrldef.sclldec,
  125. // u_mtrldef.saledec,
  126. // u_mtrldef.expday,
  127. // u_mtrldef.outtype,
  128. // u_mtrldef.ifpackpro,
  129. // u_mtrldef.maxqty,
  130. // u_mtrldef.minqty,
  131. // u_mtrldef.capaparm,
  132. // u_mtrldef.sctaskqty,
  133. // u_mtrldef.mtrlprp,
  134. // u_mtrldef.maxarg,
  135. // u_mtrldef.minarg,
  136. // u_mtrldef.maxdays,
  137. // u_mtrldef.mindays,
  138. // u_mtrldef.dftwrkGrpid,
  139. // u_mtrldef.ifusedeliqty,
  140. // u_mtrldef.status_config,
  141. // u_mtrldef.woodcode_config,
  142. // u_mtrldef.pcode_config,
  143. // u_mtrldef.pricepztype,
  144. //u_mtrldef.ifcustom,
  145. //u_mtrldef.status_check,
  146. //u_mtrldef.woodcode_check,
  147. //u_mtrldef.pcode_check,
  148. //u_mtrldef.handtype,
  149. //u_mtrldef.ifpack,
  150. //u_mtrldef.ifpackpz,
  151. //u_mtrldef.ifpackpro2,
  152. //u_mtrldef.ifpacktype,
  153. //u_mtrldef.mtrlengname
  154. // INTO :ll_mtrlid,
  155. // :ls_mtrlcode,
  156. // :ls_mtrlname,
  157. // :ls_unit,
  158. // :ls_mtrlmode,
  159. // :ls_mtrltype,
  160. // :ls_prdpackcode,
  161. // :ld_packqty,
  162. // :ld_lmbuyprice,
  163. // :ld_lmsaleprice,
  164. // :ls_unit_buy,
  165. // :ld_rate_buy,
  166. // :ls_dscrp,
  167. // :ld_mprice,
  168. // :li_mtrlorigin,
  169. // :ls_mtrlsectype,
  170. // :ls_zxmtrlmode,
  171. // :li_mtrlkind,
  172. // :li_statusflag,
  173. // :li_woodcodeflag,
  174. // :li_pcodeflag,
  175. // :ll_statustype,
  176. // :ll_woodcodetype,
  177. // :ll_pcodetype,
  178. // :ld_mtrlarea,
  179. // :ld_minbuyqty,
  180. // :ld_mtrlarea1,
  181. // :ld_mtrlarea2,
  182. // :ld_net_weight,
  183. // :ld_gross_weight,
  184. // :ld_cubage,
  185. // :ld_scidprice,
  186. // :ll_configcodetype,
  187. // :ls_configcode,
  188. // :ls_configname,
  189. // :ls_mtrlcolor,
  190. // :ll_ifautodd,
  191. // :ll_iflljg,
  192. // :ld_orderdays,
  193. // :ld_buydays,
  194. // :ld_wfjgdays,
  195. // :ld_aheaddays,
  196. // :li_ifunit,
  197. // :ls_usermtrlmode,
  198. // :li_ifmtrlcuscode,
  199. // :li_buyunit,
  200. // :li_wfjgunit,
  201. // :li_scllunit,
  202. // :li_saleunit,
  203. // :ls_unit_scll,
  204. // :ls_unit_sale,
  205. // :ld_rate_scll,
  206. // :ld_rate_sale,
  207. // :li_buydec,
  208. // :li_wfjgdec,
  209. // :li_sclldec,
  210. // :li_saledec,
  211. // :ld_expday,
  212. // :li_outtype,
  213. // :li_ifpackpro,
  214. // :ld_maxqty,
  215. // :ld_minqty,
  216. // :ld_capaparm,
  217. // :ld_sctaskqty,
  218. // :li_mtrlprp,
  219. // :ld_maxarg,
  220. // :ld_minarg,
  221. // :ld_maxdays,
  222. // :ld_mindays,
  223. // :ll_dftwrkGrpid,
  224. // :li_ifusedeliqty,
  225. // :ls_status_config,
  226. // :ls_woodcode_config,
  227. // :ls_pcode_config,
  228. // :li_pricepztype,
  229. // :li_ifcustom,
  230. //:li_status_check,
  231. //:li_woodcode_check,
  232. //:li_pcode_check,
  233. //:ls_handtype,
  234. //:li_ifpack,
  235. //:li_ifpackpz,
  236. //:li_ifpackpro2,
  237. //:li_ifpacktype,
  238. //:ls_mtrlengname
  239. // FROM u_mtrldef
  240. // WHERE ( u_mtrldef.mtrlcode = :arg_mtrlcode OR u_mtrldef.mtrlname = :arg_mtrlcode )
  241. // And ( u_mtrldef.isuse = 1 );
  242. // IF sqlca.SQLCode <> 0 THEN
  243. // SELECT count(*) INTO :cnt
  244. // FROM u_mtrldef
  245. // WHERE ( u_mtrldef.mtrlcode LIKE :ls_like_mtrlcode OR u_mtrldef.mtrlname LIKE :ls_like_mtrlcode )
  246. // And ( u_mtrldef.isuse = 1 );
  247. // IF sqlca.SQLCode <> 0 THEN
  248. // rslt = 0
  249. // GOTO ext
  250. // END IF
  251. //
  252. // IF cnt <> 1 THEN
  253. // rslt = 0
  254. // GOTO ext
  255. // ELSE
  256. //
  257. // SELECT u_mtrldef.mtrlid,
  258. // u_mtrldef.mtrlcode,
  259. // u_mtrldef.mtrlname,
  260. // u_mtrldef.unit,
  261. // u_mtrldef.mtrlmode,
  262. // u_mtrldef.mtrltype,
  263. // u_mtrldef.prdpackcode,
  264. // u_mtrldef.packqty,
  265. // u_mtrldef.lmbuyprice,
  266. // u_mtrldef.lmsaleprice,
  267. // u_mtrldef.unit_buy,
  268. // u_mtrldef.rate_buy,
  269. // u_mtrldef.dscrp,
  270. // u_mtrldef.mprice,
  271. // u_mtrldef.mtrlorigin,
  272. // u_mtrldef.mtrlsectype,
  273. // u_mtrldef.zxmtrlmode,
  274. // u_mtrldef.mtrlkind,
  275. // u_mtrldef.statusflag,
  276. // u_mtrldef.woodcodeflag,
  277. // u_mtrldef.pcodeflag,
  278. // u_mtrldef.statustype,
  279. // u_mtrldef.woodcodetype,
  280. // u_mtrldef.pcodetype,
  281. // u_mtrldef.mtrlarea,
  282. // u_mtrldef.minbuyqty,
  283. // u_mtrldef.mtrlarea1,
  284. // u_mtrldef.mtrlarea2,
  285. // u_mtrldef.net_weight,
  286. // u_mtrldef.gross_weight,
  287. // u_mtrldef.cubage,
  288. // u_mtrldef.scidprice,
  289. // u_mtrldef.configcodetype,
  290. // u_mtrldef.configcode,
  291. // u_mtrldef.configname,
  292. // u_mtrldef.mtrlcolor,
  293. // u_mtrldef.ifautodd,
  294. // u_mtrldef.iflljg,
  295. // u_mtrldef.orderdays,
  296. // u_mtrldef.buydays,
  297. // u_mtrldef.wfjgdays,
  298. // u_mtrldef.aheaddays,
  299. // u_mtrldef.ifunit,
  300. // u_mtrldef.usermtrlmode,
  301. // u_mtrldef.ifmtrlcuscode,
  302. // u_mtrldef.buyunit,
  303. // u_mtrldef.wfjgunit,
  304. // u_mtrldef.scllunit,
  305. // u_mtrldef.saleunit,
  306. // u_mtrldef.unit_scll,
  307. // u_mtrldef.unit_sale,
  308. // u_mtrldef.rate_scll,
  309. // u_mtrldef.rate_sale,
  310. // u_mtrldef.buydec,
  311. // u_mtrldef.wfjgdec,
  312. // u_mtrldef.sclldec,
  313. // u_mtrldef.saledec,
  314. // u_mtrldef.expday,
  315. // u_mtrldef.outtype,
  316. // u_mtrldef.ifpackpro,
  317. // u_mtrldef.maxqty,
  318. // u_mtrldef.minqty,
  319. // u_mtrldef.capaparm,
  320. // u_mtrldef.sctaskqty,
  321. // u_mtrldef.mtrlprp,
  322. // u_mtrldef.maxarg,
  323. // u_mtrldef.minarg,
  324. // u_mtrldef.maxdays,
  325. // u_mtrldef.mindays,
  326. // u_mtrldef.dftwrkGrpid,
  327. // u_mtrldef.ifusedeliqty,
  328. // u_mtrldef.status_config,
  329. // u_mtrldef.woodcode_config,
  330. // u_mtrldef.pcode_config,
  331. // u_mtrldef.pricepztype,
  332. // u_mtrldef.ifcustom,
  333. //u_mtrldef.status_check,
  334. //u_mtrldef.woodcode_check,
  335. //u_mtrldef.pcode_check,
  336. //u_mtrldef.handtype,
  337. //u_mtrldef.ifpack,
  338. //u_mtrldef.ifpackpz,
  339. //u_mtrldef.ifpackpro2,
  340. //u_mtrldef.ifpacktype,
  341. //u_mtrldef.mtrlengname
  342. // INTO
  343. // :ll_mtrlid,
  344. // :ls_mtrlcode,
  345. // :ls_mtrlname,
  346. // :ls_unit,
  347. // :ls_mtrlmode,
  348. // :ls_mtrltype,
  349. // :ls_prdpackcode,
  350. // :ld_packqty,
  351. // :ld_lmbuyprice,
  352. // :ld_lmsaleprice,
  353. // :ls_unit_buy,
  354. // :ld_rate_buy,
  355. // :ls_dscrp,
  356. // :ld_mprice,
  357. // :li_mtrlorigin,
  358. // :ls_mtrlsectype,
  359. // :ls_zxmtrlmode,
  360. // :li_mtrlkind,
  361. // :li_statusflag,
  362. // :li_woodcodeflag,
  363. // :li_pcodeflag,
  364. // :ll_statustype,
  365. // :ll_woodcodetype,
  366. // :ll_pcodetype,
  367. // :ld_mtrlarea,
  368. // :ld_minbuyqty,
  369. // :ld_mtrlarea1,
  370. // :ld_mtrlarea2,
  371. // :ld_net_weight,
  372. // :ld_gross_weight,
  373. // :ld_cubage,
  374. // :ld_scidprice,
  375. // :ll_configcodetype,
  376. // :ls_configcode,
  377. // :ls_configname,
  378. // :ls_mtrlcolor,
  379. // :ll_ifautodd,
  380. // :ll_iflljg,
  381. // :ld_orderdays,
  382. // :ld_buydays,
  383. // :ld_wfjgdays,
  384. // :ld_aheaddays,
  385. // :li_ifunit,
  386. // :ls_usermtrlmode,
  387. // :li_ifmtrlcuscode,
  388. // :li_buyunit,
  389. // :li_wfjgunit,
  390. // :li_scllunit,
  391. // :li_saleunit,
  392. // :ls_unit_scll,
  393. // :ls_unit_sale,
  394. // :ld_rate_scll,
  395. // :ld_rate_sale,
  396. // :li_buydec,
  397. // :li_wfjgdec,
  398. // :li_sclldec,
  399. // :li_saledec,
  400. // :ld_expday,
  401. // :li_outtype,
  402. // :li_ifpackpro,
  403. // :ld_maxqty,
  404. // :ld_minqty,
  405. // :ld_capaparm,
  406. // :ld_sctaskqty,
  407. // :li_mtrlprp,
  408. // :ld_maxarg,
  409. // :ld_minarg,
  410. // :ld_maxdays,
  411. // :ld_mindays,
  412. // :ll_dftwrkGrpid,
  413. // :li_ifusedeliqty,
  414. // :ls_status_config,
  415. // :ls_woodcode_config,
  416. // :ls_pcode_config,
  417. // :li_pricepztype,
  418. // :li_ifcustom,
  419. //:li_status_check,
  420. //:li_woodcode_check,
  421. //:li_pcode_check,
  422. //:ls_handtype,
  423. //:li_ifpack,
  424. //:li_ifpackpz,
  425. //:li_ifpackpro2,
  426. //:li_ifpacktype,
  427. //:ls_mtrlengname
  428. // FROM u_mtrldef
  429. // WHERE ( u_mtrldef.mtrlcode LIKE :ls_like_mtrlcode OR u_mtrldef.mtrlname LIKE :ls_like_mtrlcode )
  430. // And ( u_mtrldef.isuse = 1 );
  431. // IF sqlca.SQLCode <> 0 THEN
  432. // rslt = 0
  433. // GOTO ext
  434. // ELSE
  435. // if_find = True
  436. // END IF
  437. // END IF
  438. // ELSE
  439. // if_find = True
  440. // END IF
  441. //ELSE
  442. // SELECT u_mtrldef.mtrlid,
  443. // u_mtrldef.mtrlcode,
  444. // u_mtrldef.mtrlname,
  445. // u_mtrldef.unit,
  446. // u_mtrldef.mtrlmode,
  447. // u_mtrldef.mtrltype,
  448. // u_mtrldef.prdpackcode,
  449. // u_mtrldef.packqty,
  450. // u_mtrldef.lmbuyprice,
  451. // u_mtrldef.lmsaleprice,
  452. // u_mtrldef.unit_buy,
  453. // u_mtrldef.rate_buy,
  454. // u_mtrldef.dscrp,
  455. // u_mtrldef.mprice,
  456. // u_mtrldef.mtrlorigin,
  457. // u_mtrldef.mtrlsectype,
  458. // u_mtrldef.zxmtrlmode,
  459. // u_mtrldef.mtrlkind,
  460. // u_mtrldef.statusflag,
  461. // u_mtrldef.woodcodeflag,
  462. // u_mtrldef.pcodeflag,
  463. // u_mtrldef.statustype,
  464. // u_mtrldef.woodcodetype,
  465. // u_mtrldef.pcodetype,
  466. // u_mtrldef.mtrlarea,
  467. // u_mtrldef.minbuyqty,
  468. // u_mtrldef.mtrlarea1,
  469. // u_mtrldef.mtrlarea2,
  470. // u_mtrldef.net_weight,
  471. // u_mtrldef.gross_weight,
  472. // u_mtrldef.cubage,
  473. // u_mtrldef.scidprice,
  474. // u_mtrldef.configcodetype,
  475. // u_mtrldef.configcode,
  476. // u_mtrldef.configname,
  477. // u_mtrldef.mtrlcolor,
  478. // u_mtrldef.ifautodd,
  479. // u_mtrldef.iflljg,
  480. // u_mtrldef.orderdays,
  481. // u_mtrldef.buydays,
  482. // u_mtrldef.wfjgdays,
  483. // u_mtrldef.aheaddays,
  484. // u_mtrldef.ifunit,
  485. // u_mtrldef.usermtrlmode,
  486. // u_mtrldef.ifmtrlcuscode,
  487. // u_mtrldef.buyunit,
  488. // u_mtrldef.wfjgunit,
  489. // u_mtrldef.scllunit,
  490. // u_mtrldef.saleunit,
  491. // u_mtrldef.unit_scll,
  492. // u_mtrldef.unit_sale,
  493. // u_mtrldef.rate_scll,
  494. // u_mtrldef.rate_sale,
  495. // u_mtrldef.buydec,
  496. // u_mtrldef.wfjgdec,
  497. // u_mtrldef.sclldec,
  498. // u_mtrldef.saledec,
  499. // u_mtrldef.expday,
  500. // u_mtrldef.outtype,
  501. // u_mtrldef.ifpackpro,
  502. // u_mtrldef.maxqty,
  503. // u_mtrldef.minqty,
  504. // u_mtrldef.capaparm,
  505. // u_mtrldef.sctaskqty,
  506. // u_mtrldef.mtrlprp,
  507. // u_mtrldef.maxarg,
  508. // u_mtrldef.minarg,
  509. // u_mtrldef.maxdays,
  510. // u_mtrldef.mindays,
  511. // u_mtrldef.dftwrkGrpid,
  512. // u_mtrldef.ifusedeliqty,
  513. // u_mtrldef.status_config,
  514. // u_mtrldef.woodcode_config,
  515. // u_mtrldef.pcode_config,
  516. // u_mtrldef.pricepztype,
  517. // u_mtrldef.ifcustom,
  518. //u_mtrldef.status_check,
  519. //u_mtrldef.woodcode_check,
  520. //u_mtrldef.pcode_check,
  521. //u_mtrldef.handtype,
  522. //u_mtrldef.ifpack,
  523. //u_mtrldef.ifpackpz,
  524. //u_mtrldef.ifpackpro2,
  525. //u_mtrldef.ifpacktype,
  526. //u_mtrldef.mtrlengname
  527. // INTO :ll_mtrlid,
  528. // :ls_mtrlcode,
  529. // :ls_mtrlname,
  530. // :ls_unit,
  531. // :ls_mtrlmode,
  532. // :ls_mtrltype,
  533. // :ls_prdpackcode,
  534. // :ld_packqty,
  535. // :ld_lmbuyprice,
  536. // :ld_lmsaleprice,
  537. // :ls_unit_buy,
  538. // :ld_rate_buy,
  539. // :ls_dscrp,
  540. // :ld_mprice,
  541. // :li_mtrlorigin,
  542. // :ls_mtrlsectype,
  543. // :ls_zxmtrlmode,
  544. // :li_mtrlkind,
  545. // :li_statusflag,
  546. // :li_woodcodeflag,
  547. // :li_pcodeflag,
  548. // :ll_statustype,
  549. // :ll_woodcodetype,
  550. // :ll_pcodetype,
  551. // :ld_mtrlarea,
  552. // :ld_minbuyqty,
  553. // :ld_mtrlarea1,
  554. // :ld_mtrlarea2,
  555. // :ld_net_weight,
  556. // :ld_gross_weight,
  557. // :ld_cubage,
  558. // :ld_scidprice,
  559. // :ll_configcodetype,
  560. // :ls_configcode,
  561. // :ls_configname,
  562. // :ls_mtrlcolor,
  563. // :ll_ifautodd,
  564. // :ll_iflljg,
  565. // :ld_orderdays,
  566. // :ld_buydays,
  567. // :ld_wfjgdays,
  568. // :ld_aheaddays,
  569. // :li_ifunit,
  570. // :ls_usermtrlmode,
  571. // :li_ifmtrlcuscode,
  572. // :li_buyunit,
  573. // :li_wfjgunit,
  574. // :li_scllunit,
  575. // :li_saleunit,
  576. // :ls_unit_scll,
  577. // :ls_unit_sale,
  578. // :ld_rate_scll,
  579. // :ld_rate_sale,
  580. // :li_buydec,
  581. // :li_wfjgdec,
  582. // :li_sclldec,
  583. // :li_saledec,
  584. // :ld_expday,
  585. // :li_outtype,
  586. // :li_ifpackpro,
  587. // :ld_maxqty,
  588. // :ld_minqty,
  589. // :ld_capaparm,
  590. // :ld_sctaskqty,
  591. // :li_mtrlprp,
  592. // :ld_maxarg,
  593. // :ld_minarg,
  594. // :ld_maxdays,
  595. // :ld_mindays,
  596. // :ll_dftwrkGrpid,
  597. // :li_ifusedeliqty,
  598. // :ls_status_config,
  599. // :ls_woodcode_config,
  600. // :ls_pcode_config,
  601. // :li_pricepztype,
  602. // :li_ifcustom,
  603. //:li_status_check,
  604. //:li_woodcode_check,
  605. //:li_pcode_check,
  606. //:ls_handtype,
  607. //:li_ifpack,
  608. //:li_ifpackpz,
  609. //:li_ifpackpro2,
  610. //:li_ifpacktype,
  611. //:ls_mtrlengname
  612. // FROM u_mtrldef LEFT OUTER JOIN
  613. // u_mtrl_storage ON u_mtrldef.mtrlid = u_mtrl_storage.mtrlid
  614. // WHERE ( u_mtrldef.mtrlcode = :arg_mtrlcode OR u_mtrldef.mtrlname = :arg_mtrlcode )
  615. // AND ( u_mtrl_storage.storageid = :arg_storageid OR :arg_storageid = -1 )
  616. // And ( u_mtrldef.isuse = 1 );
  617. //
  618. // IF sqlca.SQLCode <> 0 THEN
  619. // SELECT count(*) INTO :cnt
  620. // FROM u_mtrldef LEFT OUTER JOIN
  621. // u_mtrl_storage ON u_mtrldef.mtrlid = u_mtrl_storage.mtrlid
  622. // WHERE ( u_mtrldef.mtrlcode LIKE :ls_like_mtrlcode OR u_mtrldef.mtrlname LIKE :ls_like_mtrlcode )
  623. // AND ( u_mtrl_storage.storageid = :arg_storageid OR :arg_storageid = -1 )
  624. // And ( u_mtrldef.isuse = 1 );
  625. // IF sqlca.SQLCode <> 0 THEN
  626. // rslt = 0
  627. // GOTO ext
  628. // END IF
  629. //
  630. // IF cnt <> 1 THEN
  631. // rslt = 0
  632. // GOTO ext
  633. // ELSE
  634. //
  635. // SELECT u_mtrldef.mtrlid,
  636. // u_mtrldef.mtrlcode,
  637. // u_mtrldef.mtrlname,
  638. // u_mtrldef.unit,
  639. // u_mtrldef.mtrlmode,
  640. // u_mtrldef.mtrltype,
  641. // u_mtrldef.prdpackcode,
  642. // u_mtrldef.packqty,
  643. // u_mtrldef.lmbuyprice,
  644. // u_mtrldef.lmsaleprice,
  645. // u_mtrldef.unit_buy,
  646. // u_mtrldef.rate_buy,
  647. // u_mtrldef.dscrp,
  648. // u_mtrldef.mprice,
  649. // u_mtrldef.mtrlorigin,
  650. // u_mtrldef.mtrlsectype,
  651. // u_mtrldef.zxmtrlmode,
  652. // u_mtrldef.mtrlkind,
  653. // u_mtrldef.statusflag,
  654. // u_mtrldef.woodcodeflag,
  655. // u_mtrldef.pcodeflag,
  656. // u_mtrldef.statustype,
  657. // u_mtrldef.woodcodetype,
  658. // u_mtrldef.pcodetype,
  659. // u_mtrldef.mtrlarea,
  660. // u_mtrldef.minbuyqty,
  661. // u_mtrldef.mtrlarea1,
  662. // u_mtrldef.mtrlarea2,
  663. // u_mtrldef.net_weight,
  664. // u_mtrldef.gross_weight,
  665. // u_mtrldef.cubage,
  666. // u_mtrldef.scidprice,
  667. // u_mtrldef.configcodetype,
  668. // u_mtrldef.configcode,
  669. // u_mtrldef.configname,
  670. // u_mtrldef.mtrlcolor,
  671. // u_mtrldef.ifautodd,
  672. // u_mtrldef.iflljg,
  673. // u_mtrldef.orderdays,
  674. // u_mtrldef.buydays,
  675. // u_mtrldef.wfjgdays,
  676. // u_mtrldef.aheaddays,
  677. // u_mtrldef.ifunit,
  678. // u_mtrldef.usermtrlmode,
  679. // u_mtrldef.ifmtrlcuscode,
  680. // u_mtrldef.buyunit,
  681. // u_mtrldef.wfjgunit,
  682. // u_mtrldef.scllunit,
  683. // u_mtrldef.saleunit,
  684. // u_mtrldef.unit_scll,
  685. // u_mtrldef.unit_sale,
  686. // u_mtrldef.rate_scll,
  687. // u_mtrldef.rate_sale,
  688. // u_mtrldef.buydec,
  689. // u_mtrldef.wfjgdec,
  690. // u_mtrldef.sclldec,
  691. // u_mtrldef.saledec,
  692. // u_mtrldef.expday,
  693. // u_mtrldef.outtype,
  694. // u_mtrldef.ifpackpro,
  695. // u_mtrldef.maxqty,
  696. // u_mtrldef.minqty,
  697. // u_mtrldef.capaparm,
  698. // u_mtrldef.sctaskqty,
  699. // u_mtrldef.mtrlprp,
  700. // u_mtrldef.maxarg,
  701. // u_mtrldef.minarg,
  702. // u_mtrldef.maxdays,
  703. // u_mtrldef.mindays,
  704. // u_mtrldef.dftwrkGrpid,
  705. // u_mtrldef.ifusedeliqty,
  706. // u_mtrldef.status_config,
  707. // u_mtrldef.woodcode_config,
  708. // u_mtrldef.pcode_config,
  709. // u_mtrldef.pricepztype,
  710. // u_mtrldef.ifcustom,
  711. //u_mtrldef.status_check,
  712. //u_mtrldef.woodcode_check,
  713. //u_mtrldef.pcode_check,
  714. //u_mtrldef.handtype,
  715. //u_mtrldef.ifpack,
  716. //u_mtrldef.ifpackpz,
  717. //u_mtrldef.ifpackpro2,
  718. //u_mtrldef.ifpacktype,
  719. //u_mtrldef.mtrlengname
  720. // INTO
  721. // :ll_mtrlid,
  722. // :ls_mtrlcode,
  723. // :ls_mtrlname,
  724. // :ls_unit,
  725. // :ls_mtrlmode,
  726. // :ls_mtrltype,
  727. // :ls_prdpackcode,
  728. // :ld_packqty,
  729. // :ld_lmbuyprice,
  730. // :ld_lmsaleprice,
  731. // :ls_unit_buy,
  732. // :ld_rate_buy,
  733. // :ls_dscrp,
  734. // :ld_mprice,
  735. // :li_mtrlorigin,
  736. // :ls_mtrlsectype,
  737. // :ls_zxmtrlmode,
  738. // :li_mtrlkind,
  739. // :li_statusflag,
  740. // :li_woodcodeflag,
  741. // :li_pcodeflag,
  742. // :ll_statustype,
  743. // :ll_woodcodetype,
  744. // :ll_pcodetype,
  745. // :ld_mtrlarea,
  746. // :ld_minbuyqty,
  747. // :ld_mtrlarea1,
  748. // :ld_mtrlarea2,
  749. // :ld_net_weight,
  750. // :ld_gross_weight,
  751. // :ld_cubage,
  752. // :ld_scidprice,
  753. // :ll_configcodetype,
  754. // :ls_configcode,
  755. // :ls_configname,
  756. // :ls_mtrlcolor,
  757. // :ll_ifautodd,
  758. // :ll_iflljg,
  759. // :ld_orderdays,
  760. // :ld_buydays,
  761. // :ld_wfjgdays,
  762. // :ld_aheaddays,
  763. // :li_ifunit,
  764. // :ls_usermtrlmode,
  765. // :li_ifmtrlcuscode,
  766. // :li_buyunit,
  767. // :li_wfjgunit,
  768. // :li_scllunit,
  769. // :li_saleunit,
  770. // :ls_unit_scll,
  771. // :ls_unit_sale,
  772. // :ld_rate_scll,
  773. // :ld_rate_sale,
  774. // :li_buydec,
  775. // :li_wfjgdec,
  776. // :li_sclldec,
  777. // :li_saledec,
  778. // :ld_expday,
  779. // :li_outtype,
  780. // :li_ifpackpro,
  781. // :ld_maxqty,
  782. // :ld_minqty,
  783. // :ld_capaparm,
  784. // :ld_sctaskqty,
  785. // :li_mtrlprp,
  786. // :ld_maxarg,
  787. // :ld_minarg,
  788. // :ld_maxdays,
  789. // :ld_mindays,
  790. // :ll_dftwrkGrpid,
  791. // :li_ifusedeliqty,
  792. // :ls_status_config,
  793. // :ls_woodcode_config,
  794. // :ls_pcode_config,
  795. // :li_pricepztype,
  796. // :li_ifcustom,
  797. //:li_status_check,
  798. //:li_woodcode_check,
  799. //:li_pcode_check,
  800. //:ls_handtype,
  801. //:li_ifpack,
  802. //:li_ifpackpz,
  803. //:li_ifpackpro2,
  804. //:li_ifpacktype,
  805. //:ls_mtrlengname
  806. // FROM u_mtrldef LEFT OUTER JOIN
  807. // u_mtrl_storage ON u_mtrldef.mtrlid = u_mtrl_storage.mtrlid
  808. // WHERE ( u_mtrldef.mtrlcode LIKE :ls_like_mtrlcode OR u_mtrldef.mtrlname LIKE :ls_like_mtrlcode )
  809. // AND ( u_mtrl_storage.storageid = :arg_storageid OR :arg_storageid = -1 )
  810. // And ( u_mtrldef.isuse = 1 );
  811. // IF sqlca.SQLCode <> 0 THEN
  812. // rslt = 0
  813. // GOTO ext
  814. // ELSE
  815. // if_find = True
  816. // END IF
  817. // END IF
  818. // ELSE
  819. // if_find = True
  820. // END IF
  821. //END IF
  822. //
  823. //IF if_find THEN
  824. // f_get_planprice_mtrl(ll_mtrlid,'','','',ld_planprice)
  825. // arg_s_mtrldef.planprice[1] = ld_planprice
  826. //
  827. //
  828. // arg_s_mtrldef.mtrlid[1] = ll_mtrlid
  829. // arg_s_mtrldef.mtrlcode[1] = ls_mtrlcode
  830. // arg_s_mtrldef.mtrlname[1] = ls_mtrlname
  831. // arg_s_mtrldef.unit[1] = ls_unit
  832. // arg_s_mtrldef.mtrlmode[1] = ls_mtrlmode
  833. // arg_s_mtrldef.planprice[1] = ld_planprice
  834. // arg_s_mtrldef.mtrltype[1] = ls_mtrltype
  835. // arg_s_mtrldef.prdpackcode[1] = ls_prdpackcode
  836. // arg_s_mtrldef.packqty[1] = ld_packqty
  837. // arg_s_mtrldef.lmbuyprice[1] = ld_lmbuyprice
  838. // arg_s_mtrldef.lmsaleprice[1] = ld_lmsaleprice
  839. // arg_s_mtrldef.unit_buy[1] = ls_unit_buy
  840. // arg_s_mtrldef.rate_buy[1] = ld_rate_buy
  841. // arg_s_mtrldef.dscrp[1] = ls_dscrp
  842. // arg_s_mtrldef.mprice[1] = ld_mprice
  843. // arg_s_mtrldef.mtrlorigin[1] = li_mtrlorigin
  844. // arg_s_mtrldef.mtrlsectype[1] = ls_mtrlsectype
  845. // arg_s_mtrldef.zxmtrlmode[1] = ls_zxmtrlmode
  846. // arg_s_mtrldef.mtrlkind[1] = li_mtrlkind
  847. // arg_s_mtrldef.statusflag[1] = li_statusflag
  848. // arg_s_mtrldef.statustype[1] = ll_statustype
  849. // arg_s_mtrldef.woodcodeflag[1] = li_woodcodeflag
  850. // arg_s_mtrldef.woodcodetype[1] = ll_woodcodetype
  851. // arg_s_mtrldef.pcodeflag[1] = li_pcodeflag
  852. // arg_s_mtrldef.pcodetype[1] = ll_pcodetype
  853. // arg_s_mtrldef.mtrlarea[1] = ld_mtrlarea
  854. // arg_s_mtrldef.minbuyqty[1] = ld_minbuyqty
  855. // arg_s_mtrldef.mtrlarea1[1] = ld_mtrlarea1
  856. // arg_s_mtrldef.mtrlarea2[1] = ld_mtrlarea2
  857. // arg_s_mtrldef.net_weight[1] = ld_net_weight
  858. // arg_s_mtrldef.gross_weight[1] = ld_gross_weight
  859. // arg_s_mtrldef.cubage[1] = ld_cubage
  860. // arg_s_mtrldef.scidprice[1] = ld_scidprice
  861. //
  862. // arg_s_mtrldef.configcodetype[1] = ll_configcodetype
  863. // arg_s_mtrldef.configcode[1] = ls_configcode
  864. // arg_s_mtrldef.configname[1] = ls_configname
  865. // arg_s_mtrldef.mtrlcolor[1] = ls_mtrlcolor
  866. // arg_s_mtrldef.ifautodd[1] = ll_ifautodd
  867. // arg_s_mtrldef.iflljg[1] = ll_iflljg
  868. //
  869. // arg_s_mtrldef.orderdays[1] = ld_orderdays
  870. // arg_s_mtrldef.buydays[1] = ld_buydays
  871. // arg_s_mtrldef.wfjgdays[1] = ld_wfjgdays
  872. // arg_s_mtrldef.aheaddays[1] = ld_aheaddays
  873. // arg_s_mtrldef.ifunit[1] = li_ifunit
  874. // arg_s_mtrldef.usermtrlmode[1] = ls_usermtrlmode
  875. // arg_s_mtrldef.ifmtrlcuscode[1] = li_ifmtrlcuscode
  876. // arg_s_mtrldef.buyunit[1] = li_buyunit
  877. // arg_s_mtrldef.wfjgunit[1] = li_wfjgunit
  878. // arg_s_mtrldef.scllunit[1] = li_scllunit
  879. // arg_s_mtrldef.saleunit[1] = li_saleunit
  880. //
  881. // arg_s_mtrldef.unit_scll[1] = ls_unit_scll
  882. // arg_s_mtrldef.unit_sale[1] = ls_unit_sale
  883. // arg_s_mtrldef.rate_scll[1] = ld_rate_scll
  884. // arg_s_mtrldef.rate_sale[1] = ld_rate_sale
  885. //
  886. // arg_s_mtrldef.buydec[1] = li_buydec
  887. // arg_s_mtrldef.wfjgdec[1] = li_wfjgdec
  888. // arg_s_mtrldef.sclldec[1] = li_sclldec
  889. // arg_s_mtrldef.saledec[1] = li_saledec
  890. // arg_s_mtrldef.expday[1] = ld_expday
  891. //
  892. // arg_s_mtrldef.outtype[1] = li_outtype
  893. // arg_s_mtrldef.ifpackpro[1] = li_ifpackpro
  894. // arg_s_mtrldef.maxqty[1] = ld_maxqty
  895. // arg_s_mtrldef.minqty[1] = ld_minqty
  896. // arg_s_mtrldef.capaparm[1] = ld_capaparm
  897. // arg_s_mtrldef.sctaskqty[1] = ld_sctaskqty
  898. // arg_s_mtrldef.mtrlprp[1] = li_mtrlprp
  899. //
  900. // arg_s_mtrldef.maxarg[1] = ld_maxarg
  901. // arg_s_mtrldef.minarg[1] = ld_minarg
  902. //
  903. // arg_s_mtrldef.maxdays[1] = ld_maxdays
  904. // arg_s_mtrldef.mindays[1] = ld_mindays
  905. // arg_s_mtrldef.dftwrkGrpid[1] = ll_dftwrkGrpid
  906. // arg_s_mtrldef.ifusedeliqty[1] = li_ifusedeliqty
  907. //
  908. // arg_s_mtrldef.status_config[1] = ls_status_config
  909. // arg_s_mtrldef.woodcode_config[1] = ls_woodcode_config
  910. // arg_s_mtrldef.pcode_config[1] = ls_pcode_config
  911. // arg_s_mtrldef.pricepztype[1] = li_pricepztype
  912. //
  913. // arg_s_mtrldef.ifcustom[1] = li_ifcustom
  914. // arg_s_mtrldef.status_check[1] = li_status_check
  915. // arg_s_mtrldef.woodcode_check[1] = li_woodcode_check
  916. // arg_s_mtrldef.pcode_check[1] = li_pcode_check
  917. // arg_s_mtrldef.handtype[1] = ls_handtype
  918. // arg_s_mtrldef.ifpack[1] = li_ifpack
  919. // arg_s_mtrldef.ifpackpz[1] = li_ifpackpz
  920. // arg_s_mtrldef.ifpackpro2[1] = li_ifpackpro2
  921. // arg_s_mtrldef.ifpacktype[1] = li_ifpacktype
  922. // arg_s_mtrldef.mtrlengname[1] = ls_mtrlengname
  923. //
  924. //END IF
  925. //
  926. //ext:
  927. RETURN rslt
  928. end function
  929. global function integer f_find_mtrl_ljfieb (string arg_mtrlcode, ref s_mtrldef_array arg_s_mtrldef);Int rslt = 1
  930. Long cnt = 0
  931. String ls_like_mtrlcode
  932. String ls_mtrlcode,ls_mtrlname,ls_unit,ls_mtrlmode,ls_mtrltype
  933. String ls_mtrlsectype,ls_zxmtrlmode,ls_mtrlengname
  934. String ls_unit_buy,ls_dscrp
  935. Long ll_mtrlid
  936. String ls_prdpackcode
  937. Decimal ld_packqty,ld_planprice,ld_lmbuyprice,ld_lmsaleprice
  938. Decimal ld_rate_buy,ld_mprice
  939. Int li_mtrlorigin,li_mtrlkind
  940. Int li_statusflag,li_woodcodeflag,li_pcodeflag
  941. Long ll_statustype,ll_woodcodetype,ll_pcodetype
  942. Decimal ld_mtrlarea,ld_mtrlarea1,ld_mtrlarea2
  943. Decimal ld_minbuyqty
  944. Decimal ld_net_weight,ld_gross_weight,ld_cubage
  945. Decimal ld_scidprice
  946. Decimal ld_orderdays,ld_buydays,ld_wfjgdays,ld_aheaddays
  947. Int li_ifunit
  948. Long ll_configcodetype
  949. String ls_configcode,ls_configname,ls_mtrlcolor
  950. Long ll_ifautodd,ll_iflljg
  951. String ls_usermtrlmode
  952. Int li_ifmtrlcuscode
  953. Int li_buyunit,li_scllunit,li_wfjgunit,li_saleunit
  954. String ls_unit_scll,ls_unit_sale
  955. Decimal ld_rate_scll,ld_rate_sale
  956. Int li_buydec,li_wfjgdec,li_sclldec,li_saledec
  957. Decimal ld_expday
  958. Int li_outtype,li_ifpackpro
  959. Decimal ld_maxqty,ld_minqty,ld_capaparm,ld_sctaskqty
  960. Int li_mtrlprp
  961. Decimal ld_maxarg,ld_minarg
  962. Decimal ld_maxdays,ld_mindays
  963. Long ll_dftwrkGrpid
  964. Int li_ifusedeliqty
  965. String ls_status_config,ls_woodcode_config,ls_pcode_config
  966. Int li_pricepztype
  967. Int li_ifcustom,li_status_check,li_woodcode_check,li_pcode_check
  968. String ls_handtype
  969. Int li_ifpack
  970. Int li_ifpackpz
  971. Int li_ifpackpro2
  972. Int li_ifpacktype
  973. long ll_mtrltypeid
  974. Boolean if_find = False
  975. IF Trim(arg_mtrlcode) = '' THEN
  976. rslt = 0
  977. GOTO ext
  978. END IF
  979. SELECT u_mtrldef.mtrlid,
  980. u_mtrldef.mtrlcode,
  981. u_mtrldef.mtrlname,
  982. u_mtrldef.unit,
  983. u_mtrldef.mtrlmode,
  984. u_mtrldef.mtrltype,
  985. u_mtrldef.prdpackcode,
  986. u_mtrldef.packqty,
  987. u_mtrldef.lmbuyprice,
  988. u_mtrldef.lmsaleprice,
  989. u_mtrldef.unit_buy,
  990. u_mtrldef.rate_buy,
  991. u_mtrldef.dscrp,
  992. // u_mtrldef.mprice,
  993. u_mtrldef.mtrlorigin,
  994. u_mtrldef.mtrlsectype,
  995. u_mtrldef.zxmtrlmode,
  996. u_mtrldef.mtrlkind,
  997. u_mtrldef.statusflag,
  998. u_mtrldef.woodcodeflag,
  999. u_mtrldef.pcodeflag,
  1000. u_mtrldef.statustype,
  1001. u_mtrldef.woodcodetype,
  1002. u_mtrldef.pcodetype,
  1003. // u_mtrldef.mtrlarea,
  1004. // u_mtrldef.minbuyqty,
  1005. // u_mtrldef.mtrlarea1,
  1006. // u_mtrldef.mtrlarea2,
  1007. u_mtrldef.net_weight,
  1008. u_mtrldef.gross_weight,
  1009. u_mtrldef.cubage,
  1010. // u_mtrldef.scidprice,
  1011. u_mtrldef.configcodetype,
  1012. u_mtrldef.configcode,
  1013. u_mtrldef.configname,
  1014. u_mtrldef.mtrlcolor,
  1015. // u_mtrldef.ifautodd,
  1016. // u_mtrldef.iflljg,
  1017. // u_mtrldef.orderdays,
  1018. // u_mtrldef.buydays,
  1019. // u_mtrldef.wfjgdays,
  1020. // u_mtrldef.aheaddays,
  1021. u_mtrldef.ifunit,
  1022. u_mtrldef.usermtrlmode,
  1023. // u_mtrldef.ifmtrlcuscode,
  1024. u_mtrldef.buyunit,
  1025. u_mtrldef.wfjgunit,
  1026. u_mtrldef.scllunit,
  1027. u_mtrldef.saleunit,
  1028. u_mtrldef.unit_scll,
  1029. u_mtrldef.unit_sale,
  1030. u_mtrldef.rate_scll,
  1031. u_mtrldef.rate_sale,
  1032. u_mtrldef.buydec,
  1033. u_mtrldef.wfjgdec,
  1034. u_mtrldef.sclldec,
  1035. u_mtrldef.saledec,
  1036. // u_mtrldef.expday,
  1037. // u_mtrldef.outtype,
  1038. u_mtrldef.ifpackpro,
  1039. u_mtrldef.maxqty,
  1040. u_mtrldef.minqty,
  1041. // u_mtrldef.capaparm,
  1042. // u_mtrldef.sctaskqty,
  1043. u_mtrldef.mtrlprp,
  1044. // u_mtrldef.maxarg,
  1045. // u_mtrldef.minarg,
  1046. // u_mtrldef.maxdays,
  1047. // u_mtrldef.mindays,
  1048. // u_mtrldef.dftwrkGrpid,
  1049. // u_mtrldef.ifusedeliqty,
  1050. u_mtrldef.status_config,
  1051. u_mtrldef.woodcode_config,
  1052. u_mtrldef.pcode_config,
  1053. // u_mtrldef.pricepztype,
  1054. u_mtrldef.ifcustom,
  1055. u_mtrldef.status_check,
  1056. u_mtrldef.woodcode_check,
  1057. u_mtrldef.pcode_check,
  1058. u_mtrldef.handtype,
  1059. u_mtrldef.ifpack,
  1060. u_mtrldef.ifpackpz,
  1061. u_mtrldef.ifpackpro2,
  1062. u_mtrldef.ifpacktype,
  1063. u_mtrldef.mtrlengname,
  1064. u_mtrldef.mtrltypeid
  1065. INTO :ll_mtrlid,
  1066. :ls_mtrlcode,
  1067. :ls_mtrlname,
  1068. :ls_unit,
  1069. :ls_mtrlmode,
  1070. :ls_mtrltype,
  1071. :ls_prdpackcode,
  1072. :ld_packqty,
  1073. :ld_lmbuyprice,
  1074. :ld_lmsaleprice,
  1075. :ls_unit_buy,
  1076. :ld_rate_buy,
  1077. :ls_dscrp,
  1078. // :ld_mprice,
  1079. :li_mtrlorigin,
  1080. :ls_mtrlsectype,
  1081. :ls_zxmtrlmode,
  1082. :li_mtrlkind,
  1083. :li_statusflag,
  1084. :li_woodcodeflag,
  1085. :li_pcodeflag,
  1086. :ll_statustype,
  1087. :ll_woodcodetype,
  1088. :ll_pcodetype,
  1089. // :ld_mtrlarea,
  1090. // :ld_minbuyqty,
  1091. // :ld_mtrlarea1,
  1092. // :ld_mtrlarea2,
  1093. :ld_net_weight,
  1094. :ld_gross_weight,
  1095. :ld_cubage,
  1096. // :ld_scidprice,
  1097. :ll_configcodetype,
  1098. :ls_configcode,
  1099. :ls_configname,
  1100. :ls_mtrlcolor,
  1101. // :ll_ifautodd,
  1102. // :ll_iflljg,
  1103. // :ld_orderdays,
  1104. // :ld_buydays,
  1105. // :ld_wfjgdays,
  1106. // :ld_aheaddays,
  1107. :li_ifunit,
  1108. :ls_usermtrlmode,
  1109. // :li_ifmtrlcuscode,
  1110. :li_buyunit,
  1111. :li_wfjgunit,
  1112. :li_scllunit,
  1113. :li_saleunit,
  1114. :ls_unit_scll,
  1115. :ls_unit_sale,
  1116. :ld_rate_scll,
  1117. :ld_rate_sale,
  1118. :li_buydec,
  1119. :li_wfjgdec,
  1120. :li_sclldec,
  1121. :li_saledec,
  1122. // :ld_expday,
  1123. // :li_outtype,
  1124. :li_ifpackpro,
  1125. :ld_maxqty,
  1126. :ld_minqty,
  1127. // :ld_capaparm,
  1128. // :ld_sctaskqty,
  1129. :li_mtrlprp,
  1130. // :ld_maxarg,
  1131. // :ld_minarg,
  1132. // :ld_maxdays,
  1133. // :ld_mindays,
  1134. // :ll_dftwrkGrpid,
  1135. // :li_ifusedeliqty,
  1136. :ls_status_config,
  1137. :ls_woodcode_config,
  1138. :ls_pcode_config,
  1139. // :li_pricepztype,
  1140. :li_ifcustom,
  1141. :li_status_check,
  1142. :li_woodcode_check,
  1143. :li_pcode_check,
  1144. :ls_handtype,
  1145. :li_ifpack,
  1146. :li_ifpackpz,
  1147. :li_ifpackpro2,
  1148. :li_ifpacktype,
  1149. :ls_mtrlengname,
  1150. :ll_mtrltypeid
  1151. FROM u_mtrldef
  1152. WHERE ( u_mtrldef.mtrlcode = :arg_mtrlcode)
  1153. And ( u_mtrldef.isuse = 1 );
  1154. IF sqlca.SQLCode <> 0 THEN
  1155. rslt = 0
  1156. goto ext
  1157. END IF
  1158. // f_get_planprice_mtrl(ll_mtrlid,'','','',ld_planprice)
  1159. // arg_s_mtrldef.planprice[1] = ld_planprice
  1160. arg_s_mtrldef.mtrlid[1] = ll_mtrlid
  1161. arg_s_mtrldef.mtrlcode[1] = ls_mtrlcode
  1162. arg_s_mtrldef.mtrlname[1] = ls_mtrlname
  1163. arg_s_mtrldef.unit[1] = ls_unit
  1164. arg_s_mtrldef.mtrlmode[1] = ls_mtrlmode
  1165. arg_s_mtrldef.planprice[1] = ld_planprice
  1166. arg_s_mtrldef.mtrltype[1] = ls_mtrltype
  1167. arg_s_mtrldef.prdpackcode[1] = ls_prdpackcode
  1168. arg_s_mtrldef.packqty[1] = ld_packqty
  1169. arg_s_mtrldef.lmbuyprice[1] = ld_lmbuyprice
  1170. arg_s_mtrldef.lmsaleprice[1] = ld_lmsaleprice
  1171. arg_s_mtrldef.unit_buy[1] = ls_unit_buy
  1172. arg_s_mtrldef.rate_buy[1] = ld_rate_buy
  1173. arg_s_mtrldef.dscrp[1] = ls_dscrp
  1174. // arg_s_mtrldef.mprice[1] = ld_mprice
  1175. arg_s_mtrldef.mtrlorigin[1] = li_mtrlorigin
  1176. arg_s_mtrldef.mtrlsectype[1] = ls_mtrlsectype
  1177. arg_s_mtrldef.zxmtrlmode[1] = ls_zxmtrlmode
  1178. arg_s_mtrldef.mtrlkind[1] = li_mtrlkind
  1179. arg_s_mtrldef.statusflag[1] = li_statusflag
  1180. arg_s_mtrldef.statustype[1] = ll_statustype
  1181. arg_s_mtrldef.woodcodeflag[1] = li_woodcodeflag
  1182. arg_s_mtrldef.woodcodetype[1] = ll_woodcodetype
  1183. arg_s_mtrldef.pcodeflag[1] = li_pcodeflag
  1184. arg_s_mtrldef.pcodetype[1] = ll_pcodetype
  1185. // arg_s_mtrldef.mtrlarea[1] = ld_mtrlarea
  1186. // arg_s_mtrldef.minbuyqty[1] = ld_minbuyqty
  1187. // arg_s_mtrldef.mtrlarea1[1] = ld_mtrlarea1
  1188. // arg_s_mtrldef.mtrlarea2[1] = ld_mtrlarea2
  1189. arg_s_mtrldef.net_weight[1] = ld_net_weight
  1190. arg_s_mtrldef.gross_weight[1] = ld_gross_weight
  1191. arg_s_mtrldef.cubage[1] = ld_cubage
  1192. // arg_s_mtrldef.scidprice[1] = ld_scidprice
  1193. arg_s_mtrldef.configcodetype[1] = ll_configcodetype
  1194. arg_s_mtrldef.configcode[1] = ls_configcode
  1195. arg_s_mtrldef.configname[1] = ls_configname
  1196. arg_s_mtrldef.mtrlcolor[1] = ls_mtrlcolor
  1197. // arg_s_mtrldef.ifautodd[1] = ll_ifautodd
  1198. // arg_s_mtrldef.iflljg[1] = ll_iflljg
  1199. // arg_s_mtrldef.orderdays[1] = ld_orderdays
  1200. // arg_s_mtrldef.buydays[1] = ld_buydays
  1201. // arg_s_mtrldef.wfjgdays[1] = ld_wfjgdays
  1202. // arg_s_mtrldef.aheaddays[1] = ld_aheaddays
  1203. arg_s_mtrldef.ifunit[1] = li_ifunit
  1204. arg_s_mtrldef.usermtrlmode[1] = ls_usermtrlmode
  1205. // arg_s_mtrldef.ifmtrlcuscode[1] = li_ifmtrlcuscode
  1206. arg_s_mtrldef.buyunit[1] = li_buyunit
  1207. arg_s_mtrldef.wfjgunit[1] = li_wfjgunit
  1208. arg_s_mtrldef.scllunit[1] = li_scllunit
  1209. arg_s_mtrldef.saleunit[1] = li_saleunit
  1210. arg_s_mtrldef.unit_scll[1] = ls_unit_scll
  1211. arg_s_mtrldef.unit_sale[1] = ls_unit_sale
  1212. arg_s_mtrldef.rate_scll[1] = ld_rate_scll
  1213. arg_s_mtrldef.rate_sale[1] = ld_rate_sale
  1214. arg_s_mtrldef.buydec[1] = li_buydec
  1215. arg_s_mtrldef.wfjgdec[1] = li_wfjgdec
  1216. arg_s_mtrldef.sclldec[1] = li_sclldec
  1217. arg_s_mtrldef.saledec[1] = li_saledec
  1218. // arg_s_mtrldef.expday[1] = ld_expday
  1219. //
  1220. // arg_s_mtrldef.outtype[1] = li_outtype
  1221. arg_s_mtrldef.ifpackpro[1] = li_ifpackpro
  1222. arg_s_mtrldef.maxqty[1] = ld_maxqty
  1223. arg_s_mtrldef.minqty[1] = ld_minqty
  1224. // arg_s_mtrldef.capaparm[1] = ld_capaparm
  1225. // arg_s_mtrldef.sctaskqty[1] = ld_sctaskqty
  1226. arg_s_mtrldef.mtrlprp[1] = li_mtrlprp
  1227. // arg_s_mtrldef.maxarg[1] = ld_maxarg
  1228. // arg_s_mtrldef.minarg[1] = ld_minarg
  1229. // arg_s_mtrldef.maxdays[1] = ld_maxdays
  1230. // arg_s_mtrldef.mindays[1] = ld_mindays
  1231. // arg_s_mtrldef.dftwrkGrpid[1] = ll_dftwrkGrpid
  1232. // arg_s_mtrldef.ifusedeliqty[1] = li_ifusedeliqty
  1233. arg_s_mtrldef.status_config[1] = ls_status_config
  1234. arg_s_mtrldef.woodcode_config[1] = ls_woodcode_config
  1235. arg_s_mtrldef.pcode_config[1] = ls_pcode_config
  1236. // arg_s_mtrldef.pricepztype[1] = li_pricepztype
  1237. arg_s_mtrldef.ifcustom[1] = li_ifcustom
  1238. arg_s_mtrldef.status_check[1] = li_status_check
  1239. arg_s_mtrldef.woodcode_check[1] = li_woodcode_check
  1240. arg_s_mtrldef.pcode_check[1] = li_pcode_check
  1241. arg_s_mtrldef.handtype[1] = ls_handtype
  1242. arg_s_mtrldef.ifpack[1] = li_ifpack
  1243. arg_s_mtrldef.ifpackpz[1] = li_ifpackpz
  1244. arg_s_mtrldef.ifpackpro2[1] = li_ifpackpro2
  1245. arg_s_mtrldef.ifpacktype[1] = li_ifpacktype
  1246. arg_s_mtrldef.mtrlengname[1] = ls_mtrlengname
  1247. arg_s_mtrldef.mtrltypeid[1] = ll_mtrltypeid
  1248. ext:
  1249. RETURN rslt
  1250. end function