w_mtrlware_cust_fx.srw 8.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337
  1. $PBExportHeader$w_mtrlware_cust_fx.srw
  2. $PBExportComments$(销售)查看 客户推送的库存信息
  3. forward
  4. global type w_mtrlware_cust_fx from w_publ_pageretr_easyq
  5. end type
  6. type dw_cust from u_dw_rbtnfilter within w_mtrlware_cust_fx
  7. end type
  8. end forward
  9. global type w_mtrlware_cust_fx from w_publ_pageretr_easyq
  10. integer width = 4713
  11. integer height = 2500
  12. string title = "客户库存信息"
  13. windowstate windowstate = normal!
  14. long backcolor = 16777215
  15. string icon = "graphics\chain_link_128px.ico"
  16. dw_cust dw_cust
  17. end type
  18. global w_mtrlware_cust_fx w_mtrlware_cust_fx
  19. type variables
  20. long ins_cur_pageNum = 1 // 用于记录当前页码
  21. long ins_totalPages = 1 // 用于记录总页数
  22. long ins_comid
  23. end variables
  24. forward prototypes
  25. public subroutine wf_get_cust ()
  26. public subroutine wf_get_mtrlware (long arg_comid)
  27. end prototypes
  28. public subroutine wf_get_cust ();dw_cust.Reset()
  29. dw_pageretr.Reset()
  30. string arg_msg
  31. oleobject obj, parm, list, item
  32. parm = FXAppCom.CreatePbDictionary()
  33. parm.SetString('token', app_token_fx)
  34. obj = FXAppCom.GetMyCustList(parm, ref arg_msg)
  35. if (arg_msg <> '') then
  36. MessageBox('提示', '获取客户列表失败:' + arg_msg)
  37. return
  38. end if
  39. list = obj.GetPBArray('list')
  40. dw_cust.SetRedraw(false)
  41. long i, row
  42. for i = 1 to list.Count
  43. item = list.GetPBDictionary(i - 1)
  44. dw_cust.Object.comid[i] = item.GetInt('comid')
  45. dw_cust.Object.comname[i] = item.GetString('comname')
  46. dw_cust.Object.simplename[i] = item.GetString('simplename')
  47. dw_cust.Object.address[i] = item.GetString('address')
  48. dw_cust.Object.freight[i] = item.GetString('freight')
  49. dw_cust.Object.freight_tele[i] = item.GetString('freight_tele')
  50. next
  51. if (dw_cust.RowCount() > 0) then
  52. dw_cust.SetRow(1)
  53. dw_cust.SelectRow(0, false)
  54. dw_cust.SelectRow(1, true)
  55. dw_cust.Post Event RowFocusChanged(1)
  56. end if
  57. dw_cust.SetRedraw(true)
  58. end subroutine
  59. public subroutine wf_get_mtrlware (long arg_comid);int rslt = 1
  60. if IsNull(arg_comid) then arg_comid = 0
  61. if (arg_comid <= 0) then return
  62. string arg_msg
  63. long pageSize
  64. pageSize = long(em_pagerowno.Text)
  65. if (pageSize <= 0) then
  66. rslt = 0
  67. arg_msg = '每页显示行数必须大于0'
  68. em_pagerowno.SetFocus( )
  69. em_pagerowno.SelectText(1, Len(em_pagerowno.Text))
  70. goto ext
  71. end if
  72. long pageNum
  73. pageNum = ins_cur_pageNum
  74. string likeStr
  75. //likeStr = Trim(sle_usual_query.Text)
  76. oleobject obj
  77. obj = FXAppCom.GetMtrlwarePropel(app_token_fx, arg_comid, pageSize, pageNum, likeStr, ref arg_msg)
  78. if (arg_msg <> '') then
  79. rslt = 0
  80. goto ext
  81. end if
  82. ins_totalPages = obj.GetInt('totalPages')
  83. dw_pageretr.Reset()
  84. dw_pageretr.SetRedraw(false)
  85. oleobject list, item
  86. list = obj.GetArrOfPBDictionary('List')
  87. long i, row
  88. for i = 1 to list.Count
  89. item = list.GetItem(i - 1)
  90. row = dw_pageretr.InsertRow(0)
  91. dw_pageretr.Object.comid[row] = item.GetInt('comid')
  92. dw_pageretr.Object.comid_send[row] = item.GetInt('comid_send')
  93. dw_pageretr.Object.scid[row] = item.GetInt('scid')
  94. dw_pageretr.Object.mtrlwareid[row] = item.GetInt('mtrlwareid')
  95. dw_pageretr.Object.mtrlid[row] = item.GetInt('mtrlid')
  96. dw_pageretr.Object.mtrlcode[row] = item.GetString('mtrlcode')
  97. dw_pageretr.Object.mtrlname[row] = item.GetString('mtrlname')
  98. dw_pageretr.Object.storagename[row] = item.GetString('storagename')
  99. dw_pageretr.Object.status[row] = item.GetString('status')
  100. dw_pageretr.Object.woodcode[row] = item.GetString('woodcode')
  101. dw_pageretr.Object.pcode[row] = item.GetString('pcode')
  102. dw_pageretr.Object.plancode[row] = item.GetString('plancode')
  103. dw_pageretr.Object.mtrlcuscode[row] = item.GetString('mtrlcuscode')
  104. dw_pageretr.Object.location[row] = item.GetString('location')
  105. dw_pageretr.Object.notauditnoallocqty[row] = item.GetDouble('notauditnoallocqty')
  106. if not IsNull(item.GetDateTime('senddate')) then
  107. dw_pageretr.Object.senddate[row] = item.GetDateTime('senddate')
  108. end if
  109. dw_pageretr.Object.mtrlmode[row] = item.GetString('mtrlmode')
  110. dw_pageretr.Object.unit[row] = item.GetString('unit')
  111. next
  112. dw_pageretr.SetRedraw(true)
  113. ext:
  114. if (rslt = 0) then
  115. MessageBox('提示', '获取库存信息失败:' + arg_msg)
  116. else
  117. end if
  118. end subroutine
  119. on w_mtrlware_cust_fx.create
  120. int iCurrent
  121. call super::create
  122. this.dw_cust=create dw_cust
  123. iCurrent=UpperBound(this.Control)
  124. this.Control[iCurrent+1]=this.dw_cust
  125. end on
  126. on w_mtrlware_cust_fx.destroy
  127. call super::destroy
  128. destroy(this.dw_cust)
  129. end on
  130. event open;wf_movetocenter()
  131. string arg_msg
  132. if (f_find_fx_user_power(32, ref arg_msg) <> 1) then // 32-客户库存查看
  133. MessageBox('权限提示', arg_msg)
  134. Close(this)
  135. return
  136. end if
  137. dw_cust.Modify('destroy custype_t ~r~n destroy custype ~r~n destroy tele_t ~r~n destroy tele ~r~n') // 删除客户联系人、联系电话列
  138. wf_get_cust()
  139. end event
  140. event resize;if (this.Width < 4400) then this.Width = 4400
  141. if (this.Height < 2300) then this.Height = 2300
  142. ln_bar.EndX = THIS.Width
  143. ln_bar2.EndX = THIS.Width
  144. ln_1.EndX = THIS.Width
  145. ln_2.EndX = THIS.Width
  146. r_bar.Width = THIS.Width
  147. dw_cust.Width = this.workspacewidth()
  148. dw_pageretr.Height = this.workspaceheight() - dw_cust.Y - dw_cust.Height
  149. dw_pageretr.Width = this.workspacewidth()
  150. cb_exit.X = this.workspacewidth( ) - cb_exit.Width
  151. cb_nextpage.X = cb_exit.X - cb_nextpage.Width - 5
  152. cb_retrieveall.X = cb_nextpage.X - cb_retrieveall.Width - 5
  153. em_pagerowno.X = cb_retrieveall.X - em_pagerowno.Width - 5
  154. end event
  155. event ue_page2;// 上页
  156. if (ins_cur_pageNum = 1) then return
  157. ins_cur_pageNum --
  158. wf_get_mtrlware(ins_comid)
  159. end event
  160. event ue_page3;// 下页
  161. if (ins_cur_pageNum >= ins_totalPages) then return
  162. ins_cur_pageNum ++
  163. wf_get_mtrlware(ins_comid)
  164. end event
  165. event ue_page4;// 末页
  166. if (ins_cur_pageNum = ins_totalPages) then return
  167. ins_cur_pageNum = ins_totalPages
  168. wf_get_mtrlware(ins_comid)
  169. end event
  170. type cb_func from w_publ_pageretr_easyq`cb_func within w_mtrlware_cust_fx
  171. end type
  172. type cb_exit from w_publ_pageretr_easyq`cb_exit within w_mtrlware_cust_fx
  173. integer x = 4347
  174. integer picsize = 16
  175. toolbaralignment pic_align = alignattop!
  176. end type
  177. type sle_usual_query from w_publ_pageretr_easyq`sle_usual_query within w_mtrlware_cust_fx
  178. boolean visible = false
  179. integer x = 1435
  180. integer y = 2252
  181. boolean enabled = false
  182. end type
  183. type cb_retrieveall from w_publ_pageretr_easyq`cb_retrieveall within w_mtrlware_cust_fx
  184. end type
  185. event cb_retrieveall::clicked;ins_cur_pageNum = 1
  186. wf_get_mtrlware(ins_comid)
  187. end event
  188. type em_pagerowno from w_publ_pageretr_easyq`em_pagerowno within w_mtrlware_cust_fx
  189. integer x = 1806
  190. integer y = 40
  191. integer height = 80
  192. string text = "100"
  193. end type
  194. type dw_pageretr from w_publ_pageretr_easyq`dw_pageretr within w_mtrlware_cust_fx
  195. integer y = 484
  196. integer width = 3319
  197. integer height = 1584
  198. string dataobject = "dw_fx_mtrlware_propel"
  199. boolean rbutton_filter_use = true
  200. boolean rbutton_setposition_use = true
  201. boolean titleclick_sort_use = true
  202. end type
  203. type st_1 from w_publ_pageretr_easyq`st_1 within w_mtrlware_cust_fx
  204. boolean visible = false
  205. integer x = 1225
  206. integer y = 2272
  207. end type
  208. type cb_nextpage from w_publ_pageretr_easyq`cb_nextpage within w_mtrlware_cust_fx
  209. end type
  210. type ddlb_yl from w_publ_pageretr_easyq`ddlb_yl within w_mtrlware_cust_fx
  211. integer x = 1211
  212. integer y = 40
  213. end type
  214. type cbx_yl from w_publ_pageretr_easyq`cbx_yl within w_mtrlware_cust_fx
  215. integer x = 1006
  216. integer y = 44
  217. long backcolor = 16777215
  218. end type
  219. type cb_psetup from w_publ_pageretr_easyq`cb_psetup within w_mtrlware_cust_fx
  220. end type
  221. type cb_2 from w_publ_pageretr_easyq`cb_2 within w_mtrlware_cust_fx
  222. end type
  223. type cb_refresh from w_publ_pageretr_easyq`cb_refresh within w_mtrlware_cust_fx
  224. end type
  225. event cb_refresh::clicked;call super::clicked;wf_get_cust()
  226. end event
  227. type cb_help from w_publ_pageretr_easyq`cb_help within w_mtrlware_cust_fx
  228. boolean visible = false
  229. integer x = 3250
  230. boolean enabled = false
  231. end type
  232. type cb_copyself from w_publ_pageretr_easyq`cb_copyself within w_mtrlware_cust_fx
  233. end type
  234. type gb_2 from w_publ_pageretr_easyq`gb_2 within w_mtrlware_cust_fx
  235. end type
  236. type ln_bar from w_publ_pageretr_easyq`ln_bar within w_mtrlware_cust_fx
  237. end type
  238. type ln_bar2 from w_publ_pageretr_easyq`ln_bar2 within w_mtrlware_cust_fx
  239. end type
  240. type r_bar from w_publ_pageretr_easyq`r_bar within w_mtrlware_cust_fx
  241. end type
  242. type ln_1 from w_publ_pageretr_easyq`ln_1 within w_mtrlware_cust_fx
  243. integer beginy = 172
  244. integer endy = 172
  245. end type
  246. type ln_2 from w_publ_pageretr_easyq`ln_2 within w_mtrlware_cust_fx
  247. integer beginy = 176
  248. integer endy = 176
  249. end type
  250. type dw_cust from u_dw_rbtnfilter within w_mtrlware_cust_fx
  251. integer y = 172
  252. integer width = 1179
  253. integer height = 312
  254. integer taborder = 20
  255. boolean bringtotop = true
  256. string dataobject = "dw_fx_cust_ch"
  257. boolean hscrollbar = true
  258. boolean vscrollbar = true
  259. boolean rbutton_filter_use = true
  260. boolean rbutton_setposition_use = true
  261. boolean titleclick_sort_use = true
  262. end type
  263. event clicked;call super::clicked;if (row > 0) then
  264. this.SetRow(row)
  265. this.SelectRow(0, false)
  266. this.SelectRow(row, true)
  267. end if
  268. end event
  269. event rowfocuschanged;call super::rowfocuschanged;if (currentrow > 0) then
  270. ins_comid = this.Object.comid[currentrow]
  271. wf_get_mtrlware(ins_comid)
  272. end if
  273. end event