w_mtrlware_storageid_ch_2.srw 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961
  1. $PBExportHeader$w_mtrlware_storageid_ch_2.srw
  2. forward
  3. global type w_mtrlware_storageid_ch_2 from w_pageretr_ch
  4. end type
  5. type cbx_ml from checkbox within w_mtrlware_storageid_ch_2
  6. end type
  7. type cbx_showall from checkbox within w_mtrlware_storageid_ch_2
  8. end type
  9. type cb_ok from uo_imflatbutton within w_mtrlware_storageid_ch_2
  10. end type
  11. type cb_del from uo_imflatbutton within w_mtrlware_storageid_ch_2
  12. end type
  13. type cbx_mlselect from checkbox within w_mtrlware_storageid_ch_2
  14. end type
  15. type cb_2 from uo_imflatbutton within w_mtrlware_storageid_ch_2
  16. end type
  17. type cb_1 from uo_imflatbutton within w_mtrlware_storageid_ch_2
  18. end type
  19. type dw_choice from datawindow within w_mtrlware_storageid_ch_2
  20. end type
  21. type tv_1 from uo_tv_mtrltype within w_mtrlware_storageid_ch_2
  22. end type
  23. type cb_3 from uo_imflatbutton within w_mtrlware_storageid_ch_2
  24. end type
  25. type cbx_selectall from checkbox within w_mtrlware_storageid_ch_2
  26. end type
  27. type cb_other from uo_imflatbutton within w_mtrlware_storageid_ch_2
  28. end type
  29. end forward
  30. global type w_mtrlware_storageid_ch_2 from w_pageretr_ch
  31. integer width = 3415
  32. integer height = 2168
  33. string title = "库存选择 [按Ctrl键反选]"
  34. event ue_retrieve_info ( )
  35. event ue_help ( )
  36. cbx_ml cbx_ml
  37. cbx_showall cbx_showall
  38. cb_ok cb_ok
  39. cb_del cb_del
  40. cbx_mlselect cbx_mlselect
  41. cb_2 cb_2
  42. cb_1 cb_1
  43. dw_choice dw_choice
  44. tv_1 tv_1
  45. cb_3 cb_3
  46. cbx_selectall cbx_selectall
  47. cb_other cb_other
  48. end type
  49. global w_mtrlware_storageid_ch_2 w_mtrlware_storageid_ch_2
  50. type variables
  51. s_mtrlware_noalloc_array INS_RT_STRU
  52. boolean if_changeselect=true
  53. int if_mlselect=0,cur_mtrlprp=0
  54. String ls_handtype = ''
  55. long arg_storageid , arg_sptid, arg_cusid
  56. boolean ins_dispmtrltype
  57. end variables
  58. forward prototypes
  59. public function integer wf_face_change ()
  60. end prototypes
  61. event ue_retrieve_info();Long ll_row
  62. Long ll_mtrlid
  63. ll_row = dw_pageretr.GetRow()
  64. IF ll_row <= 0 THEN
  65. ll_mtrlid = 0
  66. ELSE
  67. ll_mtrlid = dw_pageretr.Object.mtrlid[ll_row]
  68. END IF
  69. IF IsValid(w_mtrl_info) THEN
  70. w_mtrl_info.WindowState = Normal!
  71. w_mtrl_info.ins_mtrlid = ll_mtrlid
  72. w_mtrl_info.wf_retrieve(ll_mtrlid)
  73. END IF
  74. end event
  75. event ue_help();Int i
  76. i = htmlhelpA(Handle(THIS), sys_help_chm, 0, THIS.Title+".html")
  77. end event
  78. public function integer wf_face_change ();//wf_face_change()
  79. if cbx_ml.checked then
  80. dw_pageretr.height=1752
  81. dw_choice.visible=false
  82. cb_ok.visible=false
  83. cb_del.visible=false
  84. else
  85. dw_pageretr.height=1040
  86. dw_choice.visible=true
  87. cb_ok.visible=true
  88. cb_del.visible=true
  89. end if
  90. if ins_dispmtrltype then
  91. tv_1.visible=true
  92. dw_pageretr.x=tv_1.x+tv_1.width+5
  93. dw_pageretr.width=3360 - tv_1.width - 5
  94. dw_choice.x=tv_1.x+tv_1.width+5
  95. dw_choice.width=3360 - tv_1.width - 5
  96. else
  97. tv_1.visible=false
  98. dw_pageretr.width=3360
  99. dw_pageretr.x=9
  100. dw_choice.width=3360
  101. dw_choice.x=9
  102. end if
  103. return 1
  104. end function
  105. on w_mtrlware_storageid_ch_2.create
  106. int iCurrent
  107. call super::create
  108. this.cbx_ml=create cbx_ml
  109. this.cbx_showall=create cbx_showall
  110. this.cb_ok=create cb_ok
  111. this.cb_del=create cb_del
  112. this.cbx_mlselect=create cbx_mlselect
  113. this.cb_2=create cb_2
  114. this.cb_1=create cb_1
  115. this.dw_choice=create dw_choice
  116. this.tv_1=create tv_1
  117. this.cb_3=create cb_3
  118. this.cbx_selectall=create cbx_selectall
  119. this.cb_other=create cb_other
  120. iCurrent=UpperBound(this.Control)
  121. this.Control[iCurrent+1]=this.cbx_ml
  122. this.Control[iCurrent+2]=this.cbx_showall
  123. this.Control[iCurrent+3]=this.cb_ok
  124. this.Control[iCurrent+4]=this.cb_del
  125. this.Control[iCurrent+5]=this.cbx_mlselect
  126. this.Control[iCurrent+6]=this.cb_2
  127. this.Control[iCurrent+7]=this.cb_1
  128. this.Control[iCurrent+8]=this.dw_choice
  129. this.Control[iCurrent+9]=this.tv_1
  130. this.Control[iCurrent+10]=this.cb_3
  131. this.Control[iCurrent+11]=this.cbx_selectall
  132. this.Control[iCurrent+12]=this.cb_other
  133. end on
  134. on w_mtrlware_storageid_ch_2.destroy
  135. call super::destroy
  136. destroy(this.cbx_ml)
  137. destroy(this.cbx_showall)
  138. destroy(this.cb_ok)
  139. destroy(this.cb_del)
  140. destroy(this.cbx_mlselect)
  141. destroy(this.cb_2)
  142. destroy(this.cb_1)
  143. destroy(this.dw_choice)
  144. destroy(this.tv_1)
  145. destroy(this.cb_3)
  146. destroy(this.cbx_selectall)
  147. destroy(this.cb_other)
  148. end on
  149. event ue_before_open;call super::ue_before_open;if_ue_retr=true
  150. if_ue_sort=true
  151. end event
  152. event close;call super::close;cLOSEWITHRETURN(THIS,INS_RT_STRU)
  153. //<INS_RT_STRU> 窗体级子定义结构变量,用于返回
  154. end event
  155. event open;
  156. This.TriggerEvent('ue_before_open')
  157. wf_movetocenter()
  158. OLD_TITLE = This.Title
  159. s_tran = Message.PowerObjectParm
  160. IF Not IsNull(s_tran) THEN
  161. retrieve_all = local_retrieve_all //s_tran.if_retrieve_all
  162. mode = s_tran.work_mode
  163. arg_pkid = s_tran.arg_pkid
  164. arg_string_code = s_tran.arg_string_code
  165. arg_storageid = s_tran.d_long
  166. arg_sptid = s_tran.c_long
  167. arg_cusid = s_tran.e_long
  168. END IF
  169. //////////////// //
  170. String ls_storagename
  171. ls_storagename = f_find_storageid(String(arg_storageid))
  172. This.Title = ls_storagename + This.Title
  173. //////////////// //
  174. dw_pageretr.RBUTTON_FILTER_USE = True //右键查询功能开关
  175. dw_pageretr.titleclick_sort_use = True //单击标题排序功能开关
  176. dw_pageretr.SetTransObject (sqlca)
  177. pkcolumndbtname = wf_get_pkcolumndbtname(dw_pageretr) //取第一列为关键字
  178. ori_oldselect = dw_pageretr.Describe("DataWindow.Table.Select")
  179. ls_newselect = ori_oldselect
  180. ds_curquery = Create DATASTORE
  181. ds_curquery.DataObject = 'd_extr_find'
  182. ds_curquery.SetTransObject (sqlca)
  183. wf_editindex_lockf()
  184. sle_usual_query.Text = Trim(arg_string_code)
  185. IF Not retrieve_all And Trim(arg_string_code) <> '' THEN
  186. This.TriggerEvent("ue_usual_query_RETR") //修改ls_newselect,retrieve
  187. ELSE
  188. wf_retrieveuc(dw_pageretr,ls_newselect,1)
  189. This.TriggerEvent('RETRIEVE_pageretr')
  190. END IF
  191. IF retrieve_all And Trim(arg_string_code) <> '' THEN
  192. This.TriggerEvent("ue_usual_query_filt")
  193. END IF
  194. INS_RT_STRU.mtrlwareid[1] = 0
  195. dw_choice.SetTransObject(sqlca)
  196. wf_face_change()
  197. s_hide_col s_col
  198. s_col.col_1 = 'cost'
  199. s_col.col_2 = 'wareamt'
  200. f_hide_col(490,dw_pageretr,s_col)
  201. f_hide_col(490,dw_choice,s_col)
  202. s_hide_col s_col_mtrlsectype
  203. s_col_mtrlsectype.col_1 = 'u_mtrldef_mtrlsectype'
  204. f_hide_col(1308,dw_pageretr,s_col_mtrlsectype)
  205. f_hide_col(1308,dw_choice,s_col_mtrlsectype)
  206. s_hide_col s_col_zxmtrlmode
  207. s_col_zxmtrlmode.col_1 = 'u_mtrldef_zxmtrlmode'
  208. f_hide_col(1309,dw_pageretr,s_col_zxmtrlmode)
  209. f_hide_col(1309,dw_choice,s_col_zxmtrlmode)
  210. end event
  211. event retrieve_pageretr;boolean cb_firstpage_enabled,cb_nextpage_enabled,cb_retrieveall_enabled
  212. boolean cb_priorpage_enabled,cb_func_enabled,cb_retrieve_enabled
  213. cb_nextpage_enabled=cb_nextpage.enabled
  214. cb_retrieveall_enabled=cb_retrieveall.enabled
  215. cb_func_enabled=cb_func.enabled
  216. cb_nextpage.enabled=false
  217. cb_retrieveall.enabled=false
  218. cb_func.enabled=false
  219. SetPointer(HourGlass!)
  220. int li_showall
  221. if cbx_showall.checked then
  222. li_showall = 1
  223. else
  224. li_showall = 0
  225. end if
  226. dw_pageretr.retrieve(arg_storageid,li_showall,arg_sptid,ls_handtype,arg_cusid)
  227. if dw_pageretr.rowcount()>0 and dw_pageretr.getrow()=0 then dw_pageretr.setrow(1)
  228. SetPointer(Arrow!)
  229. cb_nextpage.enabled=cb_nextpage_enabled
  230. cb_retrieveall.enabled=cb_retrieveall_enabled
  231. cb_func.enabled=cb_func_enabled
  232. IF cbx_mlselect.Checked AND dw_pageretr.RowCount() > 1 THEN
  233. dw_pageretr.SelectRow(1,FALSE)
  234. END IF
  235. end event
  236. event ue_usual_query_filt;call super::ue_usual_query_filt;string obj_expr=''
  237. if trim(sle_usual_query.text)<>'' then
  238. IF POS(trim(sle_usual_query.text),'%')=0 THEN
  239. obj_expr=obj_expr+'( u_mtrldef_mtrlcode LIKE "%'+trim(sle_usual_query.text)+'%") '
  240. obj_expr=obj_expr+' or ( u_mtrldef_mtrlname LIKE "%'+trim(sle_usual_query.text)+'%" )'
  241. ELSE
  242. obj_expr=obj_expr+'( u_mtrldef_mtrlcode LIKE "'+trim(sle_usual_query.text)+'" )'
  243. obj_expr=obj_expr+' or ( u_mtrldef_mtrlname LIKE "'+trim(sle_usual_query.text)+'" )'
  244. END IF
  245. end if
  246. dw_pageretr.setfilter(obj_expr)
  247. dw_pageretr.SetRedraw(False)
  248. dw_pageretr.filter()
  249. if dw_pageretr.rowcount()>=1 then
  250. dw_pageretr.selectrow(0,false)
  251. dw_pageretr.selectrow(1,true )
  252. end if
  253. dw_pageretr.SetRedraw(TRUE )
  254. end event
  255. event ue_usual_query_retr;call super::ue_usual_query_retr;String ls_querystrpart = ''
  256. ls_newselect = Lower(ori_oldselect)
  257. IF Trim(sle_usual_query.Text) <> '' THEN
  258. IF Pos(Trim(sle_usual_query.Text),'%') = 0 THEN
  259. ls_querystrpart = ls_querystrpart + "(u_mtrldef.mtrlcode like '%"+Trim(sle_usual_query.Text)+"%'"
  260. ls_querystrpart = ls_querystrpart + " or u_mtrldef.mtrlname like '%"+Trim(sle_usual_query.Text)+"%')"
  261. ELSE
  262. ls_querystrpart = ls_querystrpart + "( u_mtrldef.mtrlcode like '"+Trim(sle_usual_query.Text)+"'"
  263. ls_querystrpart = ls_querystrpart + " or u_mtrldef.mtrlname like '"+Trim(sle_usual_query.Text)+"')"
  264. END IF
  265. IF Pos(ls_newselect," where ") <> 0 THEN
  266. ls_newselect = ls_newselect+" AND ("+ls_querystrpart+')'
  267. ELSE
  268. ls_newselect = ls_newselect+" where ("+ls_querystrpart+')'
  269. END IF
  270. END IF
  271. wf_retrieveuc(dw_pageretr,ls_newselect,1)
  272. THIS.TriggerEvent('retrieve_pageretr')
  273. end event
  274. type cb_func from w_pageretr_ch`cb_func within w_mtrlware_storageid_ch_2
  275. end type
  276. type cb_exit from w_pageretr_ch`cb_exit within w_mtrlware_storageid_ch_2
  277. integer x = 1417
  278. end type
  279. type sle_usual_query from w_pageretr_ch`sle_usual_query within w_mtrlware_storageid_ch_2
  280. integer x = 347
  281. end type
  282. type cb_retrieveall from w_pageretr_ch`cb_retrieveall within w_mtrlware_storageid_ch_2
  283. integer x = 2158
  284. end type
  285. type em_pagerowno from w_pageretr_ch`em_pagerowno within w_mtrlware_storageid_ch_2
  286. integer x = 1842
  287. end type
  288. type dw_pageretr from w_pageretr_ch`dw_pageretr within w_mtrlware_storageid_ch_2
  289. integer x = 9
  290. integer width = 3360
  291. integer height = 1040
  292. string dataobject = "dw_mtrlware_noalloc_storageid_ch_2"
  293. end type
  294. event dw_pageretr::clicked;if row>0 then
  295. this.setrow(row)
  296. if if_mlselect=1 then
  297. if if_changeselect then
  298. this.selectrow(row,not this.IsSelected(row))
  299. else
  300. if_changeselect=true
  301. end if
  302. else
  303. this.selectrow(0,false)
  304. this.selectrow(row,true)
  305. end if
  306. end if
  307. end event
  308. event dw_pageretr::doubleclicked;if cbx_ml.checked then
  309. cb_choice.TRIGGEREVENT(CLICKED!)
  310. else
  311. cb_ok.TRIGGEREVENT(CLICKED!)
  312. end if
  313. end event
  314. event dw_pageretr::rowfocuschanged;if if_mlselect=1 then
  315. if currentrow <=0 then return
  316. if keydown(keycontrol!) then
  317. if this.isselected(currentrow) then
  318. this.selectrow(currentrow,false)
  319. if_changeselect=false
  320. else
  321. if_changeselect=true
  322. end if
  323. else
  324. if not this.isselected(currentrow) then
  325. this.selectrow(currentrow,true)
  326. if_changeselect=false
  327. else
  328. if_changeselect=true
  329. end if
  330. end if
  331. else
  332. if dw_edit_mode then return
  333. if currentrow <=0 then return
  334. this.selectrow(0,false)
  335. this.selectrow(currentrow,true)
  336. end if
  337. PARENT.TriggerEvent('ue_retrieve_info')
  338. end event
  339. event dw_pageretr::dwnkey;call super::dwnkey;if keydown(keyenter!) then return 1
  340. end event
  341. type st_1 from w_pageretr_ch`st_1 within w_mtrlware_storageid_ch_2
  342. integer x = 14
  343. integer width = 343
  344. string text = "编码/名称含:"
  345. end type
  346. type cb_nextpage from w_pageretr_ch`cb_nextpage within w_mtrlware_storageid_ch_2
  347. integer x = 2309
  348. end type
  349. type cb_choice from w_pageretr_ch`cb_choice within w_mtrlware_storageid_ch_2
  350. integer x = 1266
  351. integer taborder = 120
  352. end type
  353. event cb_choice::clicked;call super::clicked;Long ROW,ls_i = 0,chC = 0
  354. IF cbx_ml.Checked THEN
  355. ROW = dw_pageretr.GetRow()
  356. IF ROW <= 0 THEN
  357. MessageBox('提示','请先选择目标行!', Information!, OK! )
  358. RETURN
  359. END IF
  360. FOR ls_i = 1 TO dw_pageretr.RowCount()
  361. IF dw_pageretr.IsSelected(ls_i) THEN
  362. chC++
  363. INS_RT_STRU.mtrlwareid[chC] = dw_pageretr.Object.mtrlwareid[ls_i]
  364. INS_RT_STRU.mtrlid[chC] = dw_pageretr.Object.mtrlid[ls_i]
  365. INS_RT_STRU.u_mtrldef_mtrlcode[chC] = dw_pageretr.Object.u_mtrldef_mtrlcode[ls_i]
  366. INS_RT_STRU.u_mtrldef_mtrlname[chC] = dw_pageretr.Object.u_mtrldef_mtrlname[ls_i]
  367. INS_RT_STRU.u_mtrldef_mtrlmode[chC] = dw_pageretr.Object.mtrlmode[ls_i]
  368. INS_RT_STRU.u_mtrldef_unit[chC] = dw_pageretr.Object.u_cus_price_unit[ls_i]
  369. INS_RT_STRU.u_mtrldef_prdpackcode[chC] = dw_pageretr.Object.u_mtrldef_prdpackcode[ls_i]
  370. INS_RT_STRU.u_mtrldef_packqty[chC] = dw_pageretr.Object.u_mtrldef_packqty[ls_i]
  371. INS_RT_STRU.noallocqty[chC] = dw_pageretr.Object.noallocqty[ls_i]
  372. INS_RT_STRU.cost[chC] = dw_pageretr.Object.cost[ls_i]
  373. INS_RT_STRU.planprice[chC] = dw_pageretr.Object.planprice[ls_i]
  374. INS_RT_STRU.storageid[chC] = dw_pageretr.Object.storageid[ls_i]
  375. INS_RT_STRU.plancode[chC] = dw_pageretr.Object.plancode[ls_i]
  376. INS_RT_STRU.status[chC] = dw_pageretr.Object.u_mtrlware_status[ls_i]
  377. INS_RT_STRU.sptid[chC] = dw_pageretr.Object.u_mtrlware_sptid[ls_i]
  378. INS_RT_STRU.dxflag[chC] = dw_pageretr.Object.u_mtrlware_dxflag[ls_i]
  379. INS_RT_STRU.noauditingqty[chC] = dw_pageretr.Object.noauditingqty[ls_i]
  380. INS_RT_STRU.woodcode[chC] = dw_pageretr.Object.u_mtrlware_woodcode[ls_i]
  381. INS_RT_STRU.pcode[chC] = dw_pageretr.Object.u_mtrlware_pcode[ls_i]
  382. INS_RT_STRU.u_mtrldef_mtrlsectype[chC] = dw_pageretr.Object.u_mtrldef_mtrlsectype[ls_i]
  383. INS_RT_STRU.u_mtrldef_zxmtrlmode[chC] = dw_pageretr.Object.u_mtrldef_zxmtrlmode[ls_i]
  384. INS_RT_STRU.sptcode[chC] = dw_pageretr.Object.sptcode[ls_i]
  385. INS_RT_STRU.sptname[chC] = dw_pageretr.Object.sptname[ls_i]
  386. INS_RT_STRU.noallocaddqty[chC] = dw_pageretr.Object.noallocaddqty[ls_i]
  387. INS_RT_STRU.noauditingaddqty[chC] = dw_pageretr.Object.noauditingaddqty[ls_i]
  388. INS_RT_STRU.wareamt[chC] = dw_pageretr.Object.wareamt[ls_i]
  389. INS_RT_STRU.barcode[chC] = dw_pageretr.Object.u_mtrldef_barcode[ls_i]
  390. IF IsNull(INS_RT_STRU.noauditingqty[chC]) THEN INS_RT_STRU.noauditingqty[ls_i] = 0
  391. IF IsNull(INS_RT_STRU.noauditingaddqty[chC]) THEN INS_RT_STRU.noauditingaddqty[ls_i] = 0
  392. INS_RT_STRU.u_mtrldef_net_weight[chC] = dw_pageretr.Object.u_mtrldef_net_weight[ls_i]
  393. INS_RT_STRU.u_mtrldef_gross_weight[chC] = dw_pageretr.Object.u_mtrldef_gross_weight[ls_i]
  394. INS_RT_STRU.u_mtrldef_cubage[chC] = dw_pageretr.Object.u_mtrldef_cubage[ls_i]
  395. INS_RT_STRU.lmsaleprice[chC] = dw_pageretr.Object.u_mtrldef_lmsaleprice[ls_i]
  396. INS_RT_STRU.u_mtrldef_mtrlengname[chC] = dw_pageretr.Object.u_mtrldef_mtrlengname[ls_i]
  397. END IF
  398. NEXT
  399. IF chC = 0 THEN
  400. MessageBox('提示','请至少选择一个目标行!', Information!, OK! )
  401. RETURN
  402. END IF
  403. ELSE
  404. dw_choice.AcceptText()
  405. ROW = dw_choice.RowCount()
  406. IF ROW <= 0 THEN
  407. MessageBox('提示','请先选择目标行!', Information!, OK! )
  408. RETURN
  409. END IF
  410. FOR ls_i = 1 TO dw_choice.RowCount()
  411. INS_RT_STRU.mtrlwareid[ls_i] = dw_choice.Object.mtrlwareid[ls_i]
  412. INS_RT_STRU.mtrlid[ls_i] = dw_choice.Object.mtrlid[ls_i]
  413. INS_RT_STRU.u_mtrldef_mtrlcode[ls_i] = dw_choice.Object.u_mtrldef_mtrlcode[ls_i]
  414. INS_RT_STRU.u_mtrldef_mtrlname[ls_i] = dw_choice.Object.u_mtrldef_mtrlname[ls_i]
  415. INS_RT_STRU.u_mtrldef_mtrlmode[ls_i] = dw_choice.Object.mtrlmode[ls_i]
  416. INS_RT_STRU.u_mtrldef_unit[ls_i] = dw_choice.Object.u_cus_price_unit[ls_i]
  417. INS_RT_STRU.u_mtrldef_prdpackcode[ls_i] = dw_choice.Object.u_mtrldef_prdpackcode[ls_i]
  418. INS_RT_STRU.u_mtrldef_packqty[ls_i] = dw_choice.Object.u_mtrldef_packqty[ls_i]
  419. INS_RT_STRU.noallocqty[ls_i] = dw_choice.Object.noallocqty[ls_i]
  420. INS_RT_STRU.cost[ls_i] = dw_choice.Object.cost[ls_i]
  421. INS_RT_STRU.planprice[ls_i] = dw_choice.Object.planprice[ls_i]
  422. INS_RT_STRU.storageid[ls_i] = dw_choice.Object.storageid[ls_i]
  423. INS_RT_STRU.plancode[ls_i] = dw_choice.Object.plancode[ls_i]
  424. INS_RT_STRU.status[ls_i] = dw_choice.Object.u_mtrlware_status[ls_i]
  425. INS_RT_STRU.sptid[ls_i] = dw_choice.Object.u_mtrlware_sptid[ls_i]
  426. INS_RT_STRU.dxflag[ls_i] = dw_choice.Object.u_mtrlware_dxflag[ls_i]
  427. INS_RT_STRU.noauditingqty[ls_i] = dw_choice.Object.noauditingqty[ls_i]
  428. INS_RT_STRU.woodcode[ls_i] = dw_choice.Object.u_mtrlware_woodcode[ls_i]
  429. INS_RT_STRU.pcode[ls_i] = dw_choice.Object.u_mtrlware_pcode[ls_i]
  430. INS_RT_STRU.u_mtrldef_mtrlsectype[ls_i] = dw_choice.Object.u_mtrldef_mtrlsectype[ls_i]
  431. INS_RT_STRU.u_mtrldef_zxmtrlmode[ls_i] = dw_choice.Object.u_mtrldef_zxmtrlmode[ls_i]
  432. INS_RT_STRU.sptcode[ls_i] = dw_choice.Object.sptcode[ls_i]
  433. INS_RT_STRU.sptname[ls_i] = dw_choice.Object.sptname[ls_i]
  434. INS_RT_STRU.noallocaddqty[ls_i] = dw_choice.Object.noallocaddqty[ls_i]
  435. INS_RT_STRU.noauditingaddqty[ls_i] = dw_choice.Object.noauditingaddqty[ls_i]
  436. INS_RT_STRU.wareamt[ls_i] = dw_choice.Object.wareamt[ls_i]
  437. INS_RT_STRU.barcode[ls_i] = dw_choice.Object.u_mtrldef_barcode[ls_i]
  438. IF IsNull(INS_RT_STRU.noauditingqty[ls_i]) THEN INS_RT_STRU.noauditingqty[ls_i] = 0
  439. IF IsNull(INS_RT_STRU.noauditingaddqty[ls_i]) THEN INS_RT_STRU.noauditingaddqty[ls_i] = 0
  440. INS_RT_STRU.u_mtrldef_net_weight[ls_i] = dw_choice.Object.u_mtrldef_net_weight[ls_i]
  441. INS_RT_STRU.u_mtrldef_gross_weight[ls_i] = dw_choice.Object.u_mtrldef_gross_weight[ls_i]
  442. INS_RT_STRU.u_mtrldef_cubage[ls_i] = dw_choice.Object.u_mtrldef_cubage[ls_i]
  443. INS_RT_STRU.lmsaleprice[ls_i] = dw_choice.Object.u_mtrldef_lmsaleprice[ls_i]
  444. INS_RT_STRU.u_mtrldef_mtrlengname[ls_i] = dw_pageretr.Object.u_mtrldef_mtrlengname[ls_i]
  445. NEXT
  446. END IF
  447. Close(PARENT)
  448. end event
  449. type cb_refresh from w_pageretr_ch`cb_refresh within w_mtrlware_storageid_ch_2
  450. end type
  451. type cb_help from w_pageretr_ch`cb_help within w_mtrlware_storageid_ch_2
  452. boolean visible = false
  453. integer x = 1417
  454. end type
  455. type ln_bar from w_pageretr_ch`ln_bar within w_mtrlware_storageid_ch_2
  456. end type
  457. type ln_bar2 from w_pageretr_ch`ln_bar2 within w_mtrlware_storageid_ch_2
  458. end type
  459. type r_bar from w_pageretr_ch`r_bar within w_mtrlware_storageid_ch_2
  460. integer x = 2290
  461. end type
  462. type ln_1 from w_pageretr_ch`ln_1 within w_mtrlware_storageid_ch_2
  463. end type
  464. type ln_2 from w_pageretr_ch`ln_2 within w_mtrlware_storageid_ch_2
  465. end type
  466. type cbx_ml from checkbox within w_mtrlware_storageid_ch_2
  467. integer x = 878
  468. integer y = 208
  469. integer width = 357
  470. integer height = 60
  471. boolean bringtotop = true
  472. integer textsize = -9
  473. integer weight = 700
  474. fontcharset fontcharset = gb2312charset!
  475. fontpitch fontpitch = variable!
  476. string facename = "宋体"
  477. long textcolor = 16711680
  478. long backcolor = 134217739
  479. string text = "直接多选"
  480. end type
  481. event clicked;wf_face_change()
  482. int use_ml
  483. if this.checked then
  484. use_ml=1
  485. else
  486. use_ml=0
  487. end if
  488. f_SetProfileString (sys_empid,dw_pageretr.DATAOBJECT, "use_ml", string(use_ml))
  489. end event
  490. event constructor;int use_ml
  491. use_ml=integer(f_ProfileString (sys_empid,dw_pageretr.DATAOBJECT, "use_ml", '0'))
  492. if use_ml=0 then
  493. this.checked=false
  494. else
  495. this.checked=true
  496. end if
  497. end event
  498. type cbx_showall from checkbox within w_mtrlware_storageid_ch_2
  499. integer x = 1253
  500. integer y = 208
  501. integer width = 613
  502. integer height = 60
  503. boolean bringtotop = true
  504. integer textsize = -9
  505. integer weight = 700
  506. fontcharset fontcharset = gb2312charset!
  507. fontpitch fontpitch = variable!
  508. string facename = "宋体"
  509. long textcolor = 255
  510. long backcolor = 134217739
  511. string text = "显示 0 库存物料批"
  512. end type
  513. event clicked;int if_zeromtrlware
  514. if this.checked then
  515. if_zeromtrlware=1
  516. else
  517. if_zeromtrlware=0
  518. end if
  519. f_SetProfileString (sys_empid,dw_pageretr.DATAOBJECT, "if_zeromtrlware", string(if_zeromtrlware))
  520. parent.triggerevent("retrieve_pageretr")
  521. end event
  522. event constructor;int if_zeromtrlware
  523. if_zeromtrlware=integer(f_ProfileString (sys_empid,dw_pageretr.DATAOBJECT, "if_zeromtrlware", '0'))
  524. if if_zeromtrlware =0 then
  525. this.checked=false
  526. else
  527. this.checked=true
  528. end if
  529. end event
  530. type cb_ok from uo_imflatbutton within w_mtrlware_storageid_ch_2
  531. integer x = 2665
  532. integer y = 1356
  533. integer width = 379
  534. integer taborder = 60
  535. boolean bringtotop = true
  536. string text = "选定[Enter]"
  537. end type
  538. event clicked;call super::clicked;LONG ROW,ls_i,chC=0
  539. ROW=dw_pageretr.GETROW()
  540. if ROW<=0 then
  541. messagebox('提示','请先选择目标行!', Information!, OK! )
  542. return
  543. end if
  544. for ls_i=1 to dw_pageretr.rowcount()
  545. if dw_pageretr.isselected(ls_i) then
  546. if dw_choice.find('mtrlwareid ='+string(dw_pageretr.object.mtrlwareid[ls_i]),1,dw_choice.rowcount())=0 then
  547. chC++
  548. dw_pageretr.RowsCopy(ls_i, ls_i, Primary!, dw_choice, dw_choice.rowcount() + 1, Primary!)
  549. end if
  550. end if
  551. next
  552. end event
  553. type cb_del from uo_imflatbutton within w_mtrlware_storageid_ch_2
  554. integer x = 3063
  555. integer y = 1356
  556. integer width = 311
  557. integer taborder = 140
  558. boolean bringtotop = true
  559. string text = "删除"
  560. string normalpicname = "delete.bmp"
  561. end type
  562. event clicked;call super::clicked;IF dw_choice.GETROW()=0 THEN
  563. MESSAGEBOX('提示','请选择删除的行对象!', Information!, OK! )
  564. RETURN
  565. END IF
  566. dw_choice.DeleteRow (0)
  567. dw_choice.TriggerEvent (rowfocuschanged!)
  568. end event
  569. type cbx_mlselect from checkbox within w_mtrlware_storageid_ch_2
  570. integer x = 1947
  571. integer y = 208
  572. integer width = 219
  573. integer height = 60
  574. boolean bringtotop = true
  575. integer textsize = -9
  576. integer weight = 400
  577. fontcharset fontcharset = gb2312charset!
  578. fontpitch fontpitch = variable!
  579. string facename = "宋体"
  580. long backcolor = 134217739
  581. string text = "多选"
  582. end type
  583. event clicked;if this.checked then
  584. if_mlselect=1
  585. cbx_selectall.visible=true
  586. else
  587. if_mlselect=0
  588. cbx_selectall.visible=false
  589. end if
  590. f_SetProfileString (sys_empid,dw_pageretr.DATAOBJECT, "if_mlselect", string(if_mlselect))
  591. end event
  592. event constructor;if_mlselect=integer(f_ProfileString (sys_empid,dw_pageretr.DATAOBJECT, "if_mlselect", '0'))
  593. if if_mlselect =0 then
  594. this.checked=false
  595. cbx_selectall.visible=false
  596. else
  597. this.checked=true
  598. cbx_selectall.visible=true
  599. end if
  600. end event
  601. type cb_2 from uo_imflatbutton within w_mtrlware_storageid_ch_2
  602. integer x = 1115
  603. integer width = 151
  604. integer height = 164
  605. integer taborder = 20
  606. string text = "拆货"
  607. string normalpicname = "mx1.bmp"
  608. integer picsize = 16
  609. toolbaralignment pic_align = alignattop!
  610. boolean border = false
  611. end type
  612. event clicked;call super::clicked;long ll_row
  613. long ll_mtrlwareid
  614. if not f_power_ind(288) then
  615. messagebox('提示','你没有使用权限!', Information!, OK! )
  616. return
  617. end if
  618. ll_row = dw_pageretr.getrow()
  619. if ll_row <= 0 then
  620. messagebox('提示','请选择资料', Information!, OK! )
  621. return
  622. end if
  623. ll_mtrlwareid= dw_pageretr.object.mtrlwareid[ll_row]
  624. s_edit_index_tran s_tran_open //翻页功能窗口 传递参数使用
  625. s_tran_open.if_retrieve_all = local_retrieve_all //是否一次RETRIEVE所有行
  626. s_tran_open.work_mode = 0 //0-单纯编辑模式, 1-选择模式
  627. s_tran_open.arg_pkid = 0 //目标定位PKID (备用)
  628. s_tran_open.arg_string_code = '' //查询列部分内容,用于初步筛选
  629. s_tran_open.d_long = 1
  630. s_tran_open.e_long = 1
  631. s_tran_open.e_string = '拆'
  632. s_tran_open.f_long = ll_mtrlwareid
  633. openwithparm(w_dismantle_install_response,s_tran_open)
  634. end event
  635. type cb_1 from uo_imflatbutton within w_mtrlware_storageid_ch_2
  636. integer x = 965
  637. integer width = 151
  638. integer height = 164
  639. integer taborder = 120
  640. string text = "装货"
  641. string normalpicname = "mx2.bmp"
  642. integer picsize = 16
  643. toolbaralignment pic_align = alignattop!
  644. boolean border = false
  645. end type
  646. event clicked;call super::clicked;long ll_row
  647. long ll_mtrlwareid
  648. if not f_power_ind(288) then
  649. messagebox('提示','你没有使用权限!', Information!, OK! )
  650. return
  651. end if
  652. ll_row = dw_pageretr.getrow()
  653. if ll_row <= 0 then
  654. messagebox('提示','请选择资料', Information!, OK! )
  655. return
  656. end if
  657. ll_mtrlwareid= dw_pageretr.object.mtrlwareid[ll_row]
  658. s_edit_index_tran s_tran_open //翻页功能窗口 传递参数使用
  659. s_tran_open.if_retrieve_all = local_retrieve_all //是否一次RETRIEVE所有行
  660. s_tran_open.work_mode = 0 //0-单纯编辑模式, 1-选择模式
  661. s_tran_open.arg_pkid = 0 //目标定位PKID (备用)
  662. s_tran_open.arg_string_code = '' //查询列部分内容,用于初步筛选
  663. s_tran_open.d_long = 1
  664. s_tran_open.e_long = 0
  665. s_tran_open.e_string = '装'
  666. s_tran_open.f_long = ll_mtrlwareid
  667. openwithparm(w_dismantle_install_response,s_tran_open)
  668. end event
  669. type dw_choice from datawindow within w_mtrlware_storageid_ch_2
  670. integer x = 9
  671. integer y = 1460
  672. integer width = 3355
  673. integer height = 600
  674. integer taborder = 130
  675. string title = "none"
  676. string dataobject = "dw_mtrlware_noalloc_storageid_ch_2"
  677. boolean minbox = true
  678. boolean hscrollbar = true
  679. boolean vscrollbar = true
  680. boolean hsplitscroll = true
  681. boolean livescroll = true
  682. borderstyle borderstyle = stylelowered!
  683. end type
  684. event rowfocuschanged;IF currentrow <=0 THEN RETURN
  685. this.selectrow(0,false)
  686. this.selectrow(currentrow,true)
  687. end event
  688. type tv_1 from uo_tv_mtrltype within w_mtrlware_storageid_ch_2
  689. boolean visible = false
  690. integer x = 9
  691. integer y = 300
  692. integer width = 864
  693. integer height = 1752
  694. integer taborder = 20
  695. integer textsize = -9
  696. fontcharset fontcharset = gb2312charset!
  697. fontfamily fontfamily = anyfont!
  698. string facename = "宋体"
  699. end type
  700. event selectionchanged;call super::selectionchanged;ls_handtype = THIS.uo_cur_info.handtype
  701. ls_handtype = ls_handtype + '%'
  702. parent.triggerevent("retrieve_pageretr")
  703. end event
  704. type cb_3 from uo_imflatbutton within w_mtrlware_storageid_ch_2
  705. integer x = 302
  706. integer height = 164
  707. integer taborder = 130
  708. boolean bringtotop = true
  709. string text = "显示类别树"
  710. string normalpicname = "mx2.bmp"
  711. integer picsize = 16
  712. toolbaralignment pic_align = alignattop!
  713. boolean border = false
  714. end type
  715. event constructor;call super::constructor;Int use_ml
  716. use_ml = Integer(f_ProfileString (sys_empid,dw_pageretr.DataObject, "use_mtrltype", '0'))
  717. IF use_ml = 0 THEN
  718. THIS.Text = '显示类别树'
  719. ins_dispmtrltype = FALSE
  720. ELSE
  721. THIS.Text = '隐藏类别树'
  722. ins_dispmtrltype = TRUE
  723. END IF
  724. end event
  725. event clicked;call super::clicked;Int use_ml
  726. use_ml = Integer(f_ProfileString (sys_empid,dw_pageretr.DataObject, "use_mtrltype", '0'))
  727. IF use_ml = 0 THEN
  728. THIS.Text = '隐藏类别树'
  729. ins_dispmtrltype = TRUE
  730. ELSE
  731. THIS.Text = '显示类别树'
  732. ins_dispmtrltype = FALSE
  733. END IF
  734. wf_face_change()
  735. IF use_ml = 0 THEN
  736. use_ml = 1
  737. ELSE
  738. use_ml = 0
  739. END IF
  740. f_SetProfileString (sys_empid,dw_pageretr.DataObject, "use_mtrltype", String(use_ml))
  741. end event
  742. type cbx_selectall from checkbox within w_mtrlware_storageid_ch_2
  743. boolean visible = false
  744. integer x = 2267
  745. integer y = 212
  746. integer width = 233
  747. integer height = 60
  748. boolean bringtotop = true
  749. integer textsize = -9
  750. integer weight = 400
  751. fontcharset fontcharset = gb2312charset!
  752. fontpitch fontpitch = variable!
  753. string facename = "宋体"
  754. long backcolor = 134217739
  755. string text = "全选"
  756. end type
  757. event clicked;long i
  758. if this.checked then
  759. for i=1 to dw_pageretr.rowcount()
  760. dw_pageretr.selectrow(i,true)
  761. next
  762. else
  763. for i=1 to dw_pageretr.rowcount()
  764. dw_pageretr.selectrow(i,false)
  765. next
  766. end if
  767. end event
  768. type cb_other from uo_imflatbutton within w_mtrlware_storageid_ch_2
  769. integer x = 603
  770. integer width = 361
  771. integer height = 164
  772. integer taborder = 120
  773. boolean bringtotop = true
  774. string text = "物料相关查询"
  775. string normalpicname = "imexport.BMP"
  776. integer picsize = 16
  777. toolbaralignment pic_align = alignattop!
  778. boolean border = false
  779. end type
  780. event clicked;call super::clicked;Long ll_row
  781. ll_row = dw_pageretr.GetRow()
  782. IF ll_row <= 0 THEN
  783. MessageBox('提示','请选择物料', Information!, OK! )
  784. RETURN
  785. END IF
  786. Long ll_mtrlid
  787. ll_mtrlid = dw_pageretr.Object.MtrlID[ll_row]
  788. IF IsValid(w_mtrl_info) THEN
  789. w_mtrl_info.WindowState = Normal!
  790. w_mtrl_info.ins_mtrlid = ll_mtrlid
  791. w_mtrl_info.wf_retrieve(ll_mtrlid)
  792. ELSE
  793. OpenWithParm(w_mtrl_info,ll_mtrlid)
  794. END IF
  795. end event