w_permit_bill.srw 56 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137
  1. $PBExportHeader$w_permit_bill.srw
  2. forward
  3. global type w_permit_bill from w_publ_base
  4. end type
  5. type tab_1 from tab within w_permit_bill
  6. end type
  7. type tabpage_1 from userobject within tab_1
  8. end type
  9. type dw_salemx from u_dw_rbtnfilter within tabpage_1
  10. end type
  11. type dw_sale from u_dw_rbtnfilter within tabpage_1
  12. end type
  13. type tabpage_1 from userobject within tab_1
  14. dw_salemx dw_salemx
  15. dw_sale dw_sale
  16. end type
  17. type tabpage_2 from userobject within tab_1
  18. end type
  19. type dw_buymx from u_dw_rbtnfilter within tabpage_2
  20. end type
  21. type dw_buy from u_dw_rbtnfilter within tabpage_2
  22. end type
  23. type tabpage_2 from userobject within tab_1
  24. dw_buymx dw_buymx
  25. dw_buy dw_buy
  26. end type
  27. type tabpage_3 from userobject within tab_1
  28. end type
  29. type dw_wfjgmx from u_dw_rbtnfilter within tabpage_3
  30. end type
  31. type dw_wfjg from u_dw_rbtnfilter within tabpage_3
  32. end type
  33. type tabpage_3 from userobject within tab_1
  34. dw_wfjgmx dw_wfjgmx
  35. dw_wfjg dw_wfjg
  36. end type
  37. type tabpage_9 from userobject within tab_1
  38. end type
  39. type dw_wfjgmx_cj from u_dw_rbtnfilter within tabpage_9
  40. end type
  41. type dw_wfjg_cj from u_dw_rbtnfilter within tabpage_9
  42. end type
  43. type tabpage_9 from userobject within tab_1
  44. dw_wfjgmx_cj dw_wfjgmx_cj
  45. dw_wfjg_cj dw_wfjg_cj
  46. end type
  47. type tabpage_4 from userobject within tab_1
  48. end type
  49. type dw_cusamtmx from u_dw_rbtnfilter within tabpage_4
  50. end type
  51. type dw_cusamt from u_dw_rbtnfilter within tabpage_4
  52. end type
  53. type tabpage_4 from userobject within tab_1
  54. dw_cusamtmx dw_cusamtmx
  55. dw_cusamt dw_cusamt
  56. end type
  57. type tabpage_5 from userobject within tab_1
  58. end type
  59. type dw_sptamtmx from u_dw_rbtnfilter within tabpage_5
  60. end type
  61. type dw_sptamt from u_dw_rbtnfilter within tabpage_5
  62. end type
  63. type tabpage_5 from userobject within tab_1
  64. dw_sptamtmx dw_sptamtmx
  65. dw_sptamt dw_sptamt
  66. end type
  67. type tabpage_6 from userobject within tab_1
  68. end type
  69. type dw_income_expenses from u_dw_rbtnfilter within tabpage_6
  70. end type
  71. type tabpage_6 from userobject within tab_1
  72. dw_income_expenses dw_income_expenses
  73. end type
  74. type tabpage_7 from userobject within tab_1
  75. end type
  76. type dw_rap_money_transfer from u_dw_rbtnfilter within tabpage_7
  77. end type
  78. type tabpage_7 from userobject within tab_1
  79. dw_rap_money_transfer dw_rap_money_transfer
  80. end type
  81. type tabpage_8 from userobject within tab_1
  82. end type
  83. type dw_invoicemx from u_dw_rbtnfilter within tabpage_8
  84. end type
  85. type dw_invoice from u_dw_rbtnfilter within tabpage_8
  86. end type
  87. type tabpage_8 from userobject within tab_1
  88. dw_invoicemx dw_invoicemx
  89. dw_invoice dw_invoice
  90. end type
  91. type tab_1 from tab within w_permit_bill
  92. tabpage_1 tabpage_1
  93. tabpage_2 tabpage_2
  94. tabpage_3 tabpage_3
  95. tabpage_9 tabpage_9
  96. tabpage_4 tabpage_4
  97. tabpage_5 tabpage_5
  98. tabpage_6 tabpage_6
  99. tabpage_7 tabpage_7
  100. tabpage_8 tabpage_8
  101. end type
  102. type st_1 from statictext within w_permit_bill
  103. end type
  104. type sle_usual_query1 from u_sleedit within w_permit_bill
  105. end type
  106. type st_2 from statictext within w_permit_bill
  107. end type
  108. type ddlb_scid from uo_ddlb_scid within w_permit_bill
  109. end type
  110. type st_3 from statictext within w_permit_bill
  111. end type
  112. type ddlb_1 from dropdownlistbox within w_permit_bill
  113. end type
  114. type cb_permit from commandbutton within w_permit_bill
  115. end type
  116. type cb_c_permit from commandbutton within w_permit_bill
  117. end type
  118. type cb_retr from commandbutton within w_permit_bill
  119. end type
  120. type st_4 from statictext within w_permit_bill
  121. end type
  122. type sle_usual_query2 from u_sleedit within w_permit_bill
  123. end type
  124. end forward
  125. global type w_permit_bill from w_publ_base
  126. integer width = 3611
  127. integer height = 2380
  128. string title = "终审核单据"
  129. boolean maxbox = true
  130. windowstate windowstate = maximized!
  131. event ue_usual_query_retr ( )
  132. event retrieve_pageretr ( )
  133. tab_1 tab_1
  134. st_1 st_1
  135. sle_usual_query1 sle_usual_query1
  136. st_2 st_2
  137. ddlb_scid ddlb_scid
  138. st_3 st_3
  139. ddlb_1 ddlb_1
  140. cb_permit cb_permit
  141. cb_c_permit cb_c_permit
  142. cb_retr cb_retr
  143. st_4 st_4
  144. sle_usual_query2 sle_usual_query2
  145. end type
  146. global w_permit_bill w_permit_bill
  147. type variables
  148. long cur_scid
  149. long cur_secflag = 0
  150. datawindow dw_sale,dw_salemx
  151. datawindow dw_buy,dw_buymx
  152. datawindow dw_wfjg,dw_wfjgmx
  153. datawindow dw_wfjg_cj,dw_wfjgmx_cj
  154. datawindow dw_cusamt,dw_cusamtmx
  155. datawindow dw_sptamt,dw_sptamtmx
  156. datawindow dw_income_expenses
  157. datawindow dw_rap_money_transfer
  158. datawindow dw_invoice,dw_invoicemx
  159. uo_outware_sale uo_sale
  160. uo_inware_buy uo_buy
  161. uo_inware_wfjg uo_wfjg
  162. uo_cusamt uo_take
  163. uo_income_expenses uo_ie
  164. uo_rap_money_transfer uo_output
  165. uo_invoice uo_ware
  166. end variables
  167. forward prototypes
  168. public function integer wf_refresh_curuc (ref string arg_msg)
  169. end prototypes
  170. event ue_usual_query_retr();String obj_expr = ''
  171. CHOOSE CASE tab_1.SelectedTab
  172. CASE 1
  173. IF Trim(sle_usual_query1.Text) <> '' THEN
  174. IF Pos(Trim(sle_usual_query1.Text),'%') = 0 THEN
  175. obj_expr = obj_expr+'( u_outware_outwarecode LIKE "%'+Trim(sle_usual_query1.Text)+'%" )'
  176. ELSE
  177. obj_expr = obj_expr+'( u_outware_outwarecode LIKE "'+Trim(sle_usual_query1.Text)+'" )'
  178. END IF
  179. END IF
  180. IF Trim(sle_usual_query2.Text) <> '' THEN
  181. IF Pos(Trim(sle_usual_query2.Text),'%') = 0 THEN
  182. obj_expr = obj_expr+'( u_outware_part LIKE "%'+Trim(sle_usual_query2.Text)+'%" )'
  183. ELSE
  184. obj_expr = obj_expr+'( u_outware_part LIKE "'+Trim(sle_usual_query2.Text)+'" )'
  185. END IF
  186. END IF
  187. dw_sale.SetFilter(obj_expr)
  188. dw_sale.SetRedraw(FALSE)
  189. dw_sale.Filter()
  190. IF dw_sale.RowCount() >= 1 THEN
  191. dw_sale.SelectRow(0,FALSE)
  192. dw_sale.SelectRow(1,TRUE)
  193. dw_sale.SetRow(1)
  194. dw_sale.TriggerEvent(RowFocusChanged!)
  195. END IF
  196. dw_sale.SetRedraw(TRUE)
  197. CASE 2
  198. IF Trim(sle_usual_query1.Text) <> '' THEN
  199. IF Pos(Trim(sle_usual_query1.Text),'%') = 0 THEN
  200. obj_expr = obj_expr+'( inwarecode LIKE "%'+Trim(sle_usual_query1.Text)+'%" )'
  201. ELSE
  202. obj_expr = obj_expr+'( inwarecode LIKE "'+Trim(sle_usual_query1.Text)+'" )'
  203. END IF
  204. END IF
  205. IF Trim(sle_usual_query2.Text) <> '' THEN
  206. IF Pos(Trim(sle_usual_query2.Text),'%') = 0 THEN
  207. obj_expr = obj_expr+'( part LIKE "%'+Trim(sle_usual_query2.Text)+'%" )'
  208. ELSE
  209. obj_expr = obj_expr+'( part LIKE "'+Trim(sle_usual_query2.Text)+'" )'
  210. END IF
  211. END IF
  212. dw_buy.SetFilter(obj_expr)
  213. dw_buy.SetRedraw(FALSE)
  214. dw_buy.Filter()
  215. IF dw_buy.RowCount() >= 1 THEN
  216. dw_buy.SelectRow(0,FALSE)
  217. dw_buy.SelectRow(1,TRUE)
  218. dw_buy.SetRow(1)
  219. dw_buy.TriggerEvent(RowFocusChanged!)
  220. END IF
  221. dw_buy.SetRedraw(TRUE)
  222. CASE 3
  223. IF Trim(sle_usual_query1.Text) <> '' THEN
  224. IF Pos(Trim(sle_usual_query1.Text),'%') = 0 THEN
  225. obj_expr = obj_expr+'( inwarecode LIKE "%'+Trim(sle_usual_query1.Text)+'%" )'
  226. ELSE
  227. obj_expr = obj_expr+'( inwarecode LIKE "'+Trim(sle_usual_query1.Text)+'" )'
  228. END IF
  229. END IF
  230. IF Trim(sle_usual_query2.Text) <> '' THEN
  231. IF Pos(Trim(sle_usual_query2.Text),'%') = 0 THEN
  232. obj_expr = obj_expr+'( part LIKE "%'+Trim(sle_usual_query2.Text)+'%" )'
  233. ELSE
  234. obj_expr = obj_expr+'( part LIKE "'+Trim(sle_usual_query2.Text)+'" )'
  235. END IF
  236. END IF
  237. dw_wfjg.SetFilter(obj_expr)
  238. dw_wfjg.SetRedraw(FALSE)
  239. dw_wfjg.Filter()
  240. IF dw_wfjg.RowCount() >= 1 THEN
  241. dw_wfjg.SelectRow(0,FALSE)
  242. dw_wfjg.SelectRow(1,TRUE)
  243. dw_wfjg.SetRow(1)
  244. dw_wfjg.TriggerEvent(RowFocusChanged!)
  245. END IF
  246. dw_wfjg.SetRedraw(TRUE)
  247. CASE 4
  248. IF Trim(sle_usual_query1.Text) <> '' THEN
  249. IF Pos(Trim(sle_usual_query1.Text),'%') = 0 THEN
  250. obj_expr = obj_expr+'( inwarecode LIKE "%'+Trim(sle_usual_query1.Text)+'%" )'
  251. ELSE
  252. obj_expr = obj_expr+'( inwarecode LIKE "'+Trim(sle_usual_query1.Text)+'" )'
  253. END IF
  254. END IF
  255. IF Trim(sle_usual_query2.Text) <> '' THEN
  256. IF Pos(Trim(sle_usual_query2.Text),'%') = 0 THEN
  257. obj_expr = obj_expr+'( part LIKE "%'+Trim(sle_usual_query2.Text)+'%" )'
  258. ELSE
  259. obj_expr = obj_expr+'( part LIKE "'+Trim(sle_usual_query2.Text)+'" )'
  260. END IF
  261. END IF
  262. dw_wfjg_cj.SetFilter(obj_expr)
  263. dw_wfjg_cj.SetRedraw(FALSE)
  264. dw_wfjg_cj.Filter()
  265. IF dw_wfjg_cj.RowCount() >= 1 THEN
  266. dw_wfjg_cj.SelectRow(0,FALSE)
  267. dw_wfjg_cj.SelectRow(1,TRUE)
  268. dw_wfjg_cj.SetRow(1)
  269. dw_wfjg_cj.TriggerEvent(RowFocusChanged!)
  270. END IF
  271. dw_wfjg_cj.SetRedraw(TRUE)
  272. CASE 5
  273. IF Trim(sle_usual_query1.Text) <> '' THEN
  274. IF Pos(Trim(sle_usual_query1.Text),'%') = 0 THEN
  275. obj_expr = obj_expr+'( u_cusamt_cusmoncode LIKE "%'+Trim(sle_usual_query1.Text)+'%" )'
  276. ELSE
  277. obj_expr = obj_expr+'( u_cusamt_cusmoncode LIKE "'+Trim(sle_usual_query1.Text)+'" )'
  278. END IF
  279. END IF
  280. IF Trim(sle_usual_query2.Text) <> '' THEN
  281. IF Pos(Trim(sle_usual_query2.Text),'%') = 0 THEN
  282. obj_expr = obj_expr+'( u_cusamt_relcode LIKE "%'+Trim(sle_usual_query2.Text)+'%" )'
  283. ELSE
  284. obj_expr = obj_expr+'( u_cusamt_relcode LIKE "'+Trim(sle_usual_query2.Text)+'" )'
  285. END IF
  286. END IF
  287. dw_cusamt.SetFilter(obj_expr)
  288. dw_cusamt.SetRedraw(FALSE)
  289. dw_cusamt.Filter()
  290. IF dw_cusamt.RowCount() >= 1 THEN
  291. dw_cusamt.SelectRow(0,FALSE)
  292. dw_cusamt.SelectRow(1,TRUE)
  293. dw_cusamt.SetRow(1)
  294. dw_cusamt.TriggerEvent(RowFocusChanged!)
  295. END IF
  296. dw_cusamt.SetRedraw(TRUE)
  297. CASE 6
  298. IF Trim(sle_usual_query1.Text) <> '' THEN
  299. IF Pos(Trim(sle_usual_query1.Text),'%') = 0 THEN
  300. obj_expr = obj_expr+'( u_cusamt_cusmoncode LIKE "%'+Trim(sle_usual_query1.Text)+'%" )'
  301. ELSE
  302. obj_expr = obj_expr+'( u_cusamt_cusmoncode LIKE "'+Trim(sle_usual_query1.Text)+'" )'
  303. END IF
  304. END IF
  305. IF Trim(sle_usual_query2.Text) <> '' THEN
  306. IF Pos(Trim(sle_usual_query2.Text),'%') = 0 THEN
  307. obj_expr = obj_expr+'( u_cusamt_relcode LIKE "%'+Trim(sle_usual_query2.Text)+'%" )'
  308. ELSE
  309. obj_expr = obj_expr+'( u_cusamt_relcode LIKE "'+Trim(sle_usual_query2.Text)+'" )'
  310. END IF
  311. END IF
  312. dw_sptamt.SetFilter(obj_expr)
  313. dw_sptamt.SetRedraw(FALSE)
  314. dw_sptamt.Filter()
  315. IF dw_sptamt.RowCount() >= 1 THEN
  316. dw_sptamt.SelectRow(0,FALSE)
  317. dw_sptamt.SelectRow(1,TRUE)
  318. dw_sptamt.SetRow(1)
  319. dw_sptamt.TriggerEvent(RowFocusChanged!)
  320. END IF
  321. dw_sptamt.SetRedraw(TRUE)
  322. CASE 7
  323. IF Trim(sle_usual_query1.Text) <> '' THEN
  324. IF Pos(Trim(sle_usual_query1.Text),'%') = 0 THEN
  325. obj_expr = obj_expr+'( u_income_expenses_billcode LIKE "%'+Trim(sle_usual_query1.Text)+'%" )'
  326. ELSE
  327. obj_expr = obj_expr+'( u_income_expenses_billcode LIKE "'+Trim(sle_usual_query1.Text)+'" )'
  328. END IF
  329. END IF
  330. IF Trim(sle_usual_query2.Text) <> '' THEN
  331. IF Pos(Trim(sle_usual_query2.Text),'%') = 0 THEN
  332. obj_expr = obj_expr+'( u_income_expenses_credencecode LIKE "%'+Trim(sle_usual_query2.Text)+'%" )'
  333. ELSE
  334. obj_expr = obj_expr+'( u_income_expenses_credencecode LIKE "'+Trim(sle_usual_query2.Text)+'" )'
  335. END IF
  336. END IF
  337. dw_income_expenses.SetFilter(obj_expr)
  338. dw_income_expenses.SetRedraw(FALSE)
  339. dw_income_expenses.Filter()
  340. IF dw_income_expenses.RowCount() >= 1 THEN
  341. dw_income_expenses.SelectRow(0,FALSE)
  342. dw_income_expenses.SelectRow(1,TRUE)
  343. dw_income_expenses.SetRow(1)
  344. dw_income_expenses.TriggerEvent(RowFocusChanged!)
  345. END IF
  346. dw_income_expenses.SetRedraw(TRUE)
  347. CASE 8
  348. IF Trim(sle_usual_query1.Text) <> '' THEN
  349. IF Pos(Trim(sle_usual_query1.Text),'%') = 0 THEN
  350. obj_expr = obj_expr+'( billcode LIKE "%'+Trim(sle_usual_query1.Text)+'%" )'
  351. ELSE
  352. obj_expr = obj_expr+'( billcode LIKE "'+Trim(sle_usual_query1.Text)+'" )'
  353. END IF
  354. END IF
  355. IF Trim(sle_usual_query2.Text) <> '' THEN
  356. IF Pos(Trim(sle_usual_query2.Text),'%') = 0 THEN
  357. obj_expr = obj_expr+'( relcode LIKE "%'+Trim(sle_usual_query2.Text)+'%" )'
  358. ELSE
  359. obj_expr = obj_expr+'( relcode LIKE "'+Trim(sle_usual_query2.Text)+'" )'
  360. END IF
  361. END IF
  362. dw_rap_money_transfer.SetFilter(obj_expr)
  363. dw_rap_money_transfer.SetRedraw(FALSE)
  364. dw_rap_money_transfer.Filter()
  365. IF dw_rap_money_transfer.RowCount() >= 1 THEN
  366. dw_rap_money_transfer.SelectRow(0,FALSE)
  367. dw_rap_money_transfer.SelectRow(1,TRUE)
  368. dw_rap_money_transfer.SetRow(1)
  369. dw_rap_money_transfer.TriggerEvent(RowFocusChanged!)
  370. END IF
  371. dw_rap_money_transfer.SetRedraw(TRUE)
  372. CASE 9
  373. IF Trim(sle_usual_query1.Text) <> '' THEN
  374. IF Pos(Trim(sle_usual_query1.Text),'%') = 0 THEN
  375. obj_expr = obj_expr+'( invoicecode LIKE "%'+Trim(sle_usual_query1.Text)+'%" )'
  376. ELSE
  377. obj_expr = obj_expr+'( invoicecode LIKE "'+Trim(sle_usual_query1.Text)+'" )'
  378. END IF
  379. END IF
  380. IF Trim(sle_usual_query2.Text) <> '' THEN
  381. IF Pos(Trim(sle_usual_query2.Text),'%') = 0 THEN
  382. obj_expr = obj_expr+'( relcode LIKE "%'+Trim(sle_usual_query2.Text)+'%" )'
  383. ELSE
  384. obj_expr = obj_expr+'( relcode LIKE "'+Trim(sle_usual_query2.Text)+'" )'
  385. END IF
  386. END IF
  387. dw_invoice.SetFilter(obj_expr)
  388. dw_invoice.SetRedraw(FALSE)
  389. dw_invoice.Filter()
  390. IF dw_invoice.RowCount() >= 1 THEN
  391. dw_invoice.SelectRow(0,FALSE)
  392. dw_invoice.SelectRow(1,TRUE)
  393. dw_invoice.SetRow(1)
  394. dw_invoice.TriggerEvent(RowFocusChanged!)
  395. END IF
  396. dw_invoice.SetRedraw(TRUE)
  397. END CHOOSE
  398. end event
  399. event retrieve_pageretr();Long thflag
  400. Long flag1,flag2
  401. flag1 = 0
  402. flag2 = 0
  403. CHOOSE CASE tab_1.SelectedTab
  404. CASE 1
  405. If (f_power_ind(267)) THEN
  406. flag1 = 1
  407. END IF
  408. If (f_power_ind(539)) THEN
  409. flag2 = 1
  410. END IF
  411. IF flag1 = 1 AND flag2 = 1 THEN
  412. thflag = -1
  413. ELSEIF flag1 = 1 THEN
  414. thflag = 0
  415. ELSEIF flag2 = 1 THEN
  416. thflag = 1
  417. ELSE
  418. GOTO ext
  419. END IF
  420. dw_sale.Retrieve(cur_scid,cur_secflag,thflag)
  421. case 2
  422. If (f_power_ind(304)) THEN
  423. flag1 = 1
  424. END IF
  425. If (f_power_ind(542)) THEN
  426. flag2 = 1
  427. END IF
  428. IF flag1 = 1 AND flag2 = 1 THEN
  429. thflag = -1
  430. ELSEIF flag1 = 1 THEN
  431. thflag = 0
  432. ELSEIF flag2 = 1 THEN
  433. thflag = 1
  434. ELSE
  435. GOTO ext
  436. END IF
  437. dw_buy.Retrieve(cur_scid,cur_secflag,thflag)
  438. case 3
  439. If (f_power_ind(355)) THEN
  440. flag1 = 1
  441. END IF
  442. If (f_power_ind(550)) THEN
  443. flag2 = 1
  444. END IF
  445. IF flag1 = 1 AND flag2 = 1 THEN
  446. thflag = -1
  447. ELSEIF flag1 = 1 THEN
  448. thflag = 0
  449. ELSEIF flag2 = 1 THEN
  450. thflag = 1
  451. ELSE
  452. GOTO ext
  453. END IF
  454. dw_wfjg.Retrieve(cur_scid,cur_secflag,thflag)
  455. case 4
  456. If (f_power_ind(739)) THEN
  457. flag1 = 1
  458. END IF
  459. If (f_power_ind(744)) THEN
  460. flag2 = 1
  461. END IF
  462. IF flag1 = 1 AND flag2 = 1 THEN
  463. thflag = -1
  464. ELSEIF flag1 = 1 THEN
  465. thflag = 0
  466. ELSEIF flag2 = 1 THEN
  467. thflag = 1
  468. ELSE
  469. GOTO ext
  470. END IF
  471. dw_wfjg_cj.Retrieve(cur_scid,cur_secflag,thflag)
  472. case 5
  473. dw_cusamt.Retrieve(cur_scid,cur_secflag)
  474. case 6
  475. dw_sptamt.Retrieve(cur_scid,cur_secflag)
  476. case 7
  477. dw_income_expenses.Retrieve(cur_scid,cur_secflag)
  478. case 8
  479. dw_rap_money_transfer.Retrieve(cur_secflag)
  480. case 9
  481. dw_invoice.Retrieve(cur_scid,cur_secflag)
  482. ext:
  483. END CHOOSE
  484. end event
  485. public function integer wf_refresh_curuc (ref string arg_msg);Long pagerert_row
  486. Long ll_id
  487. Long ll_scid
  488. Int secflag
  489. String secauditingrep
  490. DateTime secauditingdate
  491. Long rslt = 1
  492. CHOOSE CASE tab_1.SelectedTab
  493. CASE 1
  494. pagerert_row = dw_sale.GetRow()
  495. ll_scid = dw_sale.Object.u_outware_scid[pagerert_row]
  496. ll_id = dw_sale.Object.u_outware_outwareid[pagerert_row]
  497. SELECT u_outware.secflag,
  498. u_outware.secauditingrep,
  499. u_outware.secauditingdate
  500. INTO :secflag,
  501. :secauditingrep,
  502. :secauditingdate
  503. FROM u_outware
  504. WHERE u_outware.scid = :ll_scid AND
  505. u_outware.outwareid = :ll_id;
  506. IF sqlca.SQLCode <> 0 THEN
  507. arg_msg = '查询销售单据的信息失败 !'
  508. rslt = 0
  509. GOTO ext
  510. END IF
  511. dw_sale.Object.secflag[pagerert_row] = secflag
  512. dw_sale.Object.u_outware_secauditingrep[pagerert_row] = secauditingrep
  513. dw_sale.Object.u_outware_secauditingdate[pagerert_row] = secauditingdate
  514. CASE 2
  515. pagerert_row = dw_buy.GetRow()
  516. ll_scid = dw_buy.Object.u_inware_scid[pagerert_row]
  517. ll_id = dw_buy.Object.inwareid[pagerert_row]
  518. SELECT u_inware.secflag,
  519. u_inware.secauditingrep,
  520. u_inware.secauditingdate
  521. INTO :secflag,
  522. :secauditingrep,
  523. :secauditingdate
  524. FROM u_inware
  525. WHERE u_inware.scid = :ll_scid AND
  526. u_inware.inwareid = :ll_id;
  527. IF sqlca.SQLCode <> 0 THEN
  528. arg_msg = '查询采购单据的信息失败 !'
  529. rslt = 0
  530. GOTO ext
  531. END IF
  532. dw_buy.Object.u_inware_secflag[pagerert_row] = secflag
  533. dw_buy.Object.u_inware_secauditingrep[pagerert_row] = secauditingrep
  534. dw_buy.Object.u_inware_secauditingdate[pagerert_row] = secauditingdate
  535. CASE 3
  536. pagerert_row = dw_wfjg.GetRow()
  537. ll_scid = dw_wfjg.Object.ow_wfjg_in_scid[pagerert_row]
  538. ll_id = dw_wfjg.Object.inwareid[pagerert_row]
  539. SELECT ow_wfjg_in.secflag,
  540. ow_wfjg_in.secauditingrep,
  541. ow_wfjg_in.secauditingdate
  542. INTO :secflag,
  543. :secauditingrep,
  544. :secauditingdate
  545. FROM ow_wfjg_in
  546. WHERE ow_wfjg_in.scid = :ll_scid AND
  547. ow_wfjg_in.inwareid = :ll_id;
  548. IF sqlca.SQLCode <> 0 THEN
  549. arg_msg = '查询仓库外协收货/返工单的信息失败 !'
  550. rslt = 0
  551. GOTO ext
  552. END IF
  553. dw_wfjg.Object.secflag[pagerert_row] = secflag
  554. dw_wfjg.Object.secauditingrep[pagerert_row] = secauditingrep
  555. dw_wfjg.Object.secauditingdate[pagerert_row] = secauditingdate
  556. CASE 4
  557. pagerert_row = dw_wfjg_cj.GetRow()
  558. ll_scid = dw_wfjg_cj.Object.ow_wfjg_in_scid[pagerert_row]
  559. ll_id = dw_wfjg_cj.Object.inwareid[pagerert_row]
  560. SELECT ow_wfjg_in.secflag,
  561. ow_wfjg_in.secauditingrep,
  562. ow_wfjg_in.secauditingdate
  563. INTO :secflag,
  564. :secauditingrep,
  565. :secauditingdate
  566. FROM ow_wfjg_in
  567. WHERE ow_wfjg_in.scid = :ll_scid AND
  568. ow_wfjg_in.inwareid = :ll_id;
  569. IF sqlca.SQLCode <> 0 THEN
  570. arg_msg = '查询车间外协收货/返工单的信息失败 !'
  571. rslt = 0
  572. GOTO ext
  573. END IF
  574. dw_wfjg_cj.Object.secflag[pagerert_row] = secflag
  575. dw_wfjg_cj.Object.secauditingrep[pagerert_row] = secauditingrep
  576. dw_wfjg_cj.Object.secauditingdate[pagerert_row] = secauditingdate
  577. CASE 5
  578. pagerert_row = dw_cusamt.GetRow()
  579. ll_scid = dw_cusamt.Object.u_cusamt_scid[pagerert_row]
  580. ll_id = dw_cusamt.Object.u_cusamt_cusmonid[pagerert_row]
  581. SELECT u_cusamt.secflag,
  582. u_cusamt.secemp,
  583. u_cusamt.secdate
  584. INTO :secflag,
  585. :secauditingrep,
  586. :secauditingdate
  587. FROM u_cusamt
  588. WHERE u_cusamt.scid = :ll_scid AND
  589. u_cusamt.cusmonid = :ll_id;
  590. IF sqlca.SQLCode <> 0 THEN
  591. arg_msg = '查询客户收款单的信息失败 !'
  592. rslt = 0
  593. GOTO ext
  594. END IF
  595. dw_cusamt.Object.secflag[pagerert_row] = secflag
  596. dw_cusamt.Object.secemp[pagerert_row] = secauditingrep
  597. dw_cusamt.Object.secdate[pagerert_row] = secauditingdate
  598. CASE 6
  599. pagerert_row = dw_sptamt.GetRow()
  600. ll_scid = dw_sptamt.Object.u_cusamt_scid[pagerert_row]
  601. ll_id = dw_sptamt.Object.u_cusamt_cusmonid[pagerert_row]
  602. SELECT u_cusamt.secflag,
  603. u_cusamt.secemp,
  604. u_cusamt.secdate
  605. INTO :secflag,
  606. :secauditingrep,
  607. :secauditingdate
  608. FROM u_cusamt
  609. WHERE u_cusamt.scid = :ll_scid AND
  610. u_cusamt.cusmonid = :ll_id;
  611. IF sqlca.SQLCode <> 0 THEN
  612. arg_msg = '查询供应商付款单的信息失败 !'
  613. rslt = 0
  614. GOTO ext
  615. END IF
  616. dw_sptamt.Object.secflag[pagerert_row] = secflag
  617. dw_sptamt.Object.secemp[pagerert_row] = secauditingrep
  618. dw_sptamt.Object.secdate[pagerert_row] = secauditingdate
  619. CASE 7
  620. pagerert_row = dw_income_expenses.GetRow()
  621. ll_scid = dw_income_expenses.Object.u_income_expenses_scid[pagerert_row]
  622. ll_id = dw_income_expenses.Object.u_income_expenses_billid[pagerert_row]
  623. SELECT u_income_expenses.secflag,
  624. u_income_expenses.secauditemp,
  625. u_income_expenses.secauditdate
  626. INTO :secflag,
  627. :secauditingrep,
  628. :secauditingdate
  629. FROM u_income_expenses
  630. WHERE u_income_expenses.scid = :ll_scid AND
  631. u_income_expenses.billid = :ll_id;
  632. IF sqlca.SQLCode <> 0 THEN
  633. arg_msg = '查询收入支出单的信息失败 !'
  634. rslt = 0
  635. GOTO ext
  636. END IF
  637. dw_income_expenses.Object.secflag[pagerert_row] = secflag
  638. dw_income_expenses.Object.secauditemp[pagerert_row] = secauditingrep
  639. dw_income_expenses.Object.secauditdate[pagerert_row] = secauditingdate
  640. CASE 8
  641. pagerert_row = dw_rap_money_transfer.GetRow()
  642. ll_id = dw_rap_money_transfer.Object.billid[pagerert_row]
  643. SELECT u_rap_money_transfer.secflag,
  644. u_rap_money_transfer.secemp,
  645. u_rap_money_transfer.secdate
  646. INTO :secflag,
  647. :secauditingrep,
  648. :secauditingdate
  649. FROM u_rap_money_transfer
  650. WHERE u_rap_money_transfer.billid = :ll_id;
  651. IF sqlca.SQLCode <> 0 THEN
  652. arg_msg = '查询收入支出单的信息失败 !'
  653. rslt = 0
  654. GOTO ext
  655. END IF
  656. dw_rap_money_transfer.Object.secflag[pagerert_row] = secflag
  657. dw_rap_money_transfer.Object.secemp[pagerert_row] = secauditingrep
  658. dw_rap_money_transfer.Object.secdate[pagerert_row] = secauditingdate
  659. CASE 9
  660. pagerert_row = dw_invoice.GetRow()
  661. ll_id = dw_invoice.Object.invoiceid[pagerert_row]
  662. ll_scid = dw_invoice.Object.scid[pagerert_row]
  663. SELECT u_invoice.secflag,
  664. u_invoice.secemp,
  665. u_invoice.secdate
  666. INTO :secflag,
  667. :secauditingrep,
  668. :secauditingdate
  669. FROM u_invoice
  670. WHERE u_invoice.invoiceid = :ll_id and
  671. u_invoice.scid = :ll_scid;
  672. IF sqlca.SQLCode <> 0 THEN
  673. arg_msg = '查询支票单的信息失败 !'
  674. rslt = 0
  675. GOTO ext
  676. END IF
  677. dw_invoice.Object.secflag[pagerert_row] = secflag
  678. dw_invoice.Object.secemp[pagerert_row] = secauditingrep
  679. dw_invoice.Object.secdate[pagerert_row] = secauditingdate
  680. END CHOOSE
  681. ext:
  682. RETURN rslt
  683. end function
  684. on w_permit_bill.create
  685. int iCurrent
  686. call super::create
  687. this.tab_1=create tab_1
  688. this.st_1=create st_1
  689. this.sle_usual_query1=create sle_usual_query1
  690. this.st_2=create st_2
  691. this.ddlb_scid=create ddlb_scid
  692. this.st_3=create st_3
  693. this.ddlb_1=create ddlb_1
  694. this.cb_permit=create cb_permit
  695. this.cb_c_permit=create cb_c_permit
  696. this.cb_retr=create cb_retr
  697. this.st_4=create st_4
  698. this.sle_usual_query2=create sle_usual_query2
  699. iCurrent=UpperBound(this.Control)
  700. this.Control[iCurrent+1]=this.tab_1
  701. this.Control[iCurrent+2]=this.st_1
  702. this.Control[iCurrent+3]=this.sle_usual_query1
  703. this.Control[iCurrent+4]=this.st_2
  704. this.Control[iCurrent+5]=this.ddlb_scid
  705. this.Control[iCurrent+6]=this.st_3
  706. this.Control[iCurrent+7]=this.ddlb_1
  707. this.Control[iCurrent+8]=this.cb_permit
  708. this.Control[iCurrent+9]=this.cb_c_permit
  709. this.Control[iCurrent+10]=this.cb_retr
  710. this.Control[iCurrent+11]=this.st_4
  711. this.Control[iCurrent+12]=this.sle_usual_query2
  712. end on
  713. on w_permit_bill.destroy
  714. call super::destroy
  715. destroy(this.tab_1)
  716. destroy(this.st_1)
  717. destroy(this.sle_usual_query1)
  718. destroy(this.st_2)
  719. destroy(this.ddlb_scid)
  720. destroy(this.st_3)
  721. destroy(this.ddlb_1)
  722. destroy(this.cb_permit)
  723. destroy(this.cb_c_permit)
  724. destroy(this.cb_retr)
  725. destroy(this.st_4)
  726. destroy(this.sle_usual_query2)
  727. end on
  728. event open;call super::open;dw_sale = tab_1.tabpage_1.dw_sale
  729. dw_salemx = tab_1.tabpage_1.dw_salemx
  730. dw_buy = tab_1.tabpage_2.dw_buy
  731. dw_buymx = tab_1.tabpage_2.dw_buymx
  732. dw_wfjg = tab_1.tabpage_3.dw_wfjg
  733. dw_wfjgmx = tab_1.tabpage_3.dw_wfjgmx
  734. dw_wfjg_cj = tab_1.tabpage_9.dw_wfjg_cj
  735. dw_wfjgmx_cj = tab_1.tabpage_9.dw_wfjgmx_cj
  736. dw_cusamt = tab_1.tabpage_4.dw_cusamt
  737. dw_cusamtmx = tab_1.tabpage_4.dw_cusamtmx
  738. dw_sptamt = tab_1.tabpage_5.dw_sptamt
  739. dw_sptamtmx= tab_1.tabpage_5.dw_sptamtmx
  740. dw_income_expenses= tab_1.tabpage_6.dw_income_expenses
  741. dw_rap_money_transfer= tab_1.tabpage_7.dw_rap_money_transfer
  742. dw_invoice= tab_1.tabpage_8.dw_invoice
  743. dw_invoicemx= tab_1.tabpage_8.dw_invoicemx
  744. dw_sale.SetTransObject(sqlca)
  745. dw_salemx.SetTransObject(sqlca)
  746. dw_buy.SetTransObject(sqlca)
  747. dw_buymx.SetTransObject(sqlca)
  748. dw_wfjg.SetTransObject(sqlca)
  749. dw_wfjgmx.SetTransObject(sqlca)
  750. dw_wfjg_cj.SetTransObject(sqlca)
  751. dw_wfjgmx_cj.SetTransObject(sqlca)
  752. dw_cusamt.SetTransObject(sqlca)
  753. dw_cusamtmx.SetTransObject(sqlca)
  754. dw_sptamt.SetTransObject(sqlca)
  755. dw_sptamtmx.SetTransObject(sqlca)
  756. dw_income_expenses.SetTransObject(sqlca)
  757. dw_rap_money_transfer.SetTransObject(sqlca)
  758. dw_invoice.SetTransObject(sqlca)
  759. dw_invoicemx.SetTransObject(sqlca)
  760. uo_sale = CREATE uo_outware_sale
  761. uo_sale.commit_transaction = sqlca
  762. uo_buy = CREATE uo_inware_buy
  763. uo_buy.commit_transaction = sqlca
  764. uo_wfjg = CREATE uo_inware_wfjg
  765. uo_wfjg.commit_transaction = sqlca
  766. uo_take = CREATE uo_cusamt
  767. uo_ie = CREATE uo_income_expenses
  768. uo_ie.commit_transaction = sqlca
  769. uo_output = CREATE uo_rap_money_transfer
  770. uo_ware = CREATE uo_invoice
  771. uo_ware.commit_transaction = sqlca
  772. IF Not (f_power_ind(267) OR f_power_ind(539)) THEN
  773. tab_1.tabpage_1.Enabled = FALSE
  774. END IF
  775. IF Not (f_power_ind(304) OR f_power_ind(542)) THEN
  776. tab_1.tabpage_2.Enabled = FALSE
  777. END IF
  778. IF Not (f_power_ind(355) OR f_power_ind(550) ) THEN
  779. tab_1.tabpage_3.Enabled = FALSE
  780. END IF
  781. IF Not (f_power_ind(739) OR f_power_ind(744) ) THEN
  782. tab_1.tabpage_9.Enabled = FALSE
  783. END IF
  784. IF Not (f_power_ind(919) ) THEN
  785. tab_1.tabpage_4.Enabled = FALSE
  786. END IF
  787. IF Not (f_power_ind(920) ) THEN
  788. tab_1.tabpage_5.Enabled = FALSE
  789. END IF
  790. IF Not (f_power_ind(988) ) THEN
  791. tab_1.tabpage_6.Enabled = FALSE
  792. END IF
  793. IF Not (f_power_ind(921) ) THEN
  794. tab_1.tabpage_7.Enabled = FALSE
  795. END IF
  796. IF Not (f_power_ind(523) ) THEN
  797. tab_1.tabpage_8.Enabled = FALSE
  798. END IF
  799. end event
  800. event resize;call super::resize;tab_1.Width = THIS.Width - tab_1.X - 40
  801. tab_1.Height = THIS.Height - tab_1.Y - 150
  802. dw_sale.Width = tab_1.Width - 30
  803. dw_salemx.Width = tab_1.Width - 30
  804. dw_salemx.Height = tab_1.Height - dw_sale.Height - 120
  805. dw_buy.Width = tab_1.Width - 30
  806. dw_buymx.Width = tab_1.Width - 30
  807. dw_buymx.Height = tab_1.Height - dw_buy.Height - 120
  808. dw_wfjg.Width = tab_1.Width - 30
  809. dw_wfjgmx.Width = tab_1.Width - 30
  810. dw_wfjgmx.Height = tab_1.Height - dw_wfjg.Height - 120
  811. dw_wfjg_cj.Width = tab_1.Width - 30
  812. dw_wfjgmx_cj.Width = tab_1.Width - 30
  813. dw_wfjgmx_cj.Height = tab_1.Height - dw_wfjg_cj.Height - 120
  814. dw_cusamt.Width = tab_1.Width - 30
  815. dw_cusamtmx.Width = tab_1.Width - 30
  816. dw_cusamtmx.Height = tab_1.Height - dw_cusamt.Height - 120
  817. dw_sptamt.Width = tab_1.Width - 30
  818. dw_sptamtmx.Width = tab_1.Width - 30
  819. dw_sptamtmx.Height = tab_1.Height - dw_sptamt.Height - 120
  820. dw_income_expenses.Width = tab_1.Width - 30
  821. dw_income_expenses.Height = tab_1.Height - 120
  822. dw_rap_money_transfer.Width = tab_1.Width - 30
  823. dw_rap_money_transfer.Height = tab_1.Height - 120
  824. dw_invoice.Width = tab_1.Width - 30
  825. dw_invoicemx.Width = tab_1.Width - 30
  826. dw_invoicemx.Height = tab_1.Height - dw_invoice.Height - 120
  827. end event
  828. type cb_func from w_publ_base`cb_func within w_permit_bill
  829. boolean visible = false
  830. end type
  831. type cb_exit from w_publ_base`cb_exit within w_permit_bill
  832. boolean visible = false
  833. end type
  834. type tab_1 from tab within w_permit_bill
  835. integer y = 108
  836. integer width = 3584
  837. integer height = 2152
  838. integer taborder = 20
  839. boolean bringtotop = true
  840. integer textsize = -9
  841. integer weight = 400
  842. fontcharset fontcharset = gb2312charset!
  843. fontpitch fontpitch = variable!
  844. string facename = "宋体"
  845. long backcolor = 134217739
  846. boolean raggedright = true
  847. boolean focusonbuttondown = true
  848. integer selectedtab = 1
  849. tabpage_1 tabpage_1
  850. tabpage_2 tabpage_2
  851. tabpage_3 tabpage_3
  852. tabpage_9 tabpage_9
  853. tabpage_4 tabpage_4
  854. tabpage_5 tabpage_5
  855. tabpage_6 tabpage_6
  856. tabpage_7 tabpage_7
  857. tabpage_8 tabpage_8
  858. end type
  859. on tab_1.create
  860. this.tabpage_1=create tabpage_1
  861. this.tabpage_2=create tabpage_2
  862. this.tabpage_3=create tabpage_3
  863. this.tabpage_9=create tabpage_9
  864. this.tabpage_4=create tabpage_4
  865. this.tabpage_5=create tabpage_5
  866. this.tabpage_6=create tabpage_6
  867. this.tabpage_7=create tabpage_7
  868. this.tabpage_8=create tabpage_8
  869. this.Control[]={this.tabpage_1,&
  870. this.tabpage_2,&
  871. this.tabpage_3,&
  872. this.tabpage_9,&
  873. this.tabpage_4,&
  874. this.tabpage_5,&
  875. this.tabpage_6,&
  876. this.tabpage_7,&
  877. this.tabpage_8}
  878. end on
  879. on tab_1.destroy
  880. destroy(this.tabpage_1)
  881. destroy(this.tabpage_2)
  882. destroy(this.tabpage_3)
  883. destroy(this.tabpage_9)
  884. destroy(this.tabpage_4)
  885. destroy(this.tabpage_5)
  886. destroy(this.tabpage_6)
  887. destroy(this.tabpage_7)
  888. destroy(this.tabpage_8)
  889. end on
  890. event selectionchanged;PARENT.TriggerEvent('retrieve_pageretr')
  891. end event
  892. type tabpage_1 from userobject within tab_1
  893. event create ( )
  894. event destroy ( )
  895. integer x = 18
  896. integer y = 96
  897. integer width = 3547
  898. integer height = 2040
  899. long backcolor = 134217739
  900. string text = "销售发货单/退货单"
  901. long tabtextcolor = 33554432
  902. long tabbackcolor = 134217739
  903. long picturemaskcolor = 536870912
  904. dw_salemx dw_salemx
  905. dw_sale dw_sale
  906. end type
  907. on tabpage_1.create
  908. this.dw_salemx=create dw_salemx
  909. this.dw_sale=create dw_sale
  910. this.Control[]={this.dw_salemx,&
  911. this.dw_sale}
  912. end on
  913. on tabpage_1.destroy
  914. destroy(this.dw_salemx)
  915. destroy(this.dw_sale)
  916. end on
  917. type dw_salemx from u_dw_rbtnfilter within tabpage_1
  918. integer y = 1252
  919. integer width = 3543
  920. integer height = 764
  921. integer taborder = 20
  922. string title = "明细内容"
  923. string dataobject = "dw_outwaremx_sale_permit"
  924. boolean hscrollbar = true
  925. boolean vscrollbar = true
  926. boolean rbutton_filter_use = true
  927. boolean rbutton_setposition_use = true
  928. boolean titleclick_sort_use = true
  929. end type
  930. type dw_sale from u_dw_rbtnfilter within tabpage_1
  931. integer width = 3543
  932. integer height = 1240
  933. integer taborder = 20
  934. string title = "单据摘要内容"
  935. string dataobject = "dw_outware_sale_premit"
  936. boolean hscrollbar = true
  937. boolean vscrollbar = true
  938. boolean rbutton_filter_use = true
  939. boolean rbutton_setposition_use = true
  940. boolean titleclick_sort_use = true
  941. end type
  942. event rowfocuschanged;call super::rowfocuschanged;IF currentrow > 0 THEN
  943. THIS.SelectRow(0,FALSE)
  944. THIS.SelectRow(currentrow,TRUE)
  945. END IF
  946. Long row,uc_relid,ll_scid
  947. row = dw_sale.GetRow()
  948. IF row > 0 THEN
  949. ll_scid = this.Object.u_outware_scid[row]
  950. uc_relid = this.Object.u_outware_outwareid[row]
  951. dw_salemx.SetRedraw (FALSE)
  952. dw_salemx.Retrieve(ll_scid,uc_relid)
  953. dw_salemx.SetRedraw (TRUE)
  954. ELSE
  955. dw_salemx.Reset()
  956. END IF
  957. end event
  958. type tabpage_2 from userobject within tab_1
  959. integer x = 18
  960. integer y = 96
  961. integer width = 3547
  962. integer height = 2040
  963. long backcolor = 134217739
  964. string text = "采购收货单/退货单"
  965. long tabtextcolor = 33554432
  966. long tabbackcolor = 134217739
  967. long picturemaskcolor = 536870912
  968. dw_buymx dw_buymx
  969. dw_buy dw_buy
  970. end type
  971. on tabpage_2.create
  972. this.dw_buymx=create dw_buymx
  973. this.dw_buy=create dw_buy
  974. this.Control[]={this.dw_buymx,&
  975. this.dw_buy}
  976. end on
  977. on tabpage_2.destroy
  978. destroy(this.dw_buymx)
  979. destroy(this.dw_buy)
  980. end on
  981. type dw_buymx from u_dw_rbtnfilter within tabpage_2
  982. integer y = 1252
  983. integer width = 3543
  984. integer height = 764
  985. integer taborder = 30
  986. string title = "明细内容"
  987. string dataobject = "dw_inwaremx_buy_permit"
  988. boolean hscrollbar = true
  989. boolean vscrollbar = true
  990. boolean rbutton_filter_use = true
  991. boolean rbutton_setposition_use = true
  992. boolean titleclick_sort_use = true
  993. end type
  994. type dw_buy from u_dw_rbtnfilter within tabpage_2
  995. integer width = 3543
  996. integer height = 1240
  997. integer taborder = 30
  998. string title = "单据摘要内容"
  999. string dataobject = "dw_inware_buy_permit"
  1000. boolean hscrollbar = true
  1001. boolean vscrollbar = true
  1002. boolean rbutton_filter_use = true
  1003. boolean rbutton_setposition_use = true
  1004. boolean titleclick_sort_use = true
  1005. end type
  1006. event rowfocuschanged;call super::rowfocuschanged;IF currentrow > 0 THEN
  1007. THIS.SelectRow(0,FALSE)
  1008. THIS.SelectRow(currentrow,TRUE)
  1009. END IF
  1010. Long row,uc_relid,ll_scid
  1011. row = dw_buy.GetRow()
  1012. IF row > 0 THEN
  1013. ll_scid = this.Object.u_inware_scid[row]
  1014. uc_relid = this.Object.inwareid[row]
  1015. dw_buymx.SetRedraw (FALSE)
  1016. dw_buymx.Retrieve(ll_scid,uc_relid)
  1017. dw_buymx.SetRedraw (TRUE)
  1018. ELSE
  1019. dw_buymx.Reset()
  1020. END IF
  1021. end event
  1022. type tabpage_3 from userobject within tab_1
  1023. integer x = 18
  1024. integer y = 96
  1025. integer width = 3547
  1026. integer height = 2040
  1027. long backcolor = 134217739
  1028. string text = "仓库外协收货单/返工单"
  1029. long tabtextcolor = 33554432
  1030. long tabbackcolor = 134217739
  1031. long picturemaskcolor = 536870912
  1032. dw_wfjgmx dw_wfjgmx
  1033. dw_wfjg dw_wfjg
  1034. end type
  1035. on tabpage_3.create
  1036. this.dw_wfjgmx=create dw_wfjgmx
  1037. this.dw_wfjg=create dw_wfjg
  1038. this.Control[]={this.dw_wfjgmx,&
  1039. this.dw_wfjg}
  1040. end on
  1041. on tabpage_3.destroy
  1042. destroy(this.dw_wfjgmx)
  1043. destroy(this.dw_wfjg)
  1044. end on
  1045. type dw_wfjgmx from u_dw_rbtnfilter within tabpage_3
  1046. integer y = 1252
  1047. integer width = 3543
  1048. integer height = 764
  1049. integer taborder = 40
  1050. string title = "明细内容"
  1051. string dataobject = "dw_wfjgmx_in_aft_permit"
  1052. boolean hscrollbar = true
  1053. boolean vscrollbar = true
  1054. boolean rbutton_filter_use = true
  1055. boolean rbutton_setposition_use = true
  1056. boolean titleclick_sort_use = true
  1057. end type
  1058. type dw_wfjg from u_dw_rbtnfilter within tabpage_3
  1059. integer width = 3543
  1060. integer height = 1240
  1061. string title = "单据摘要内容"
  1062. string dataobject = "dw_inware_wfjg_permit"
  1063. boolean hscrollbar = true
  1064. boolean vscrollbar = true
  1065. boolean rbutton_filter_use = true
  1066. boolean rbutton_setposition_use = true
  1067. boolean titleclick_sort_use = true
  1068. end type
  1069. event rowfocuschanged;call super::rowfocuschanged;IF currentrow > 0 THEN
  1070. THIS.SelectRow(0,FALSE)
  1071. THIS.SelectRow(currentrow,TRUE)
  1072. END IF
  1073. Long row,uc_relid,ll_scid
  1074. row = dw_wfjg.GetRow()
  1075. IF row > 0 THEN
  1076. ll_scid = this.Object.ow_wfjg_in_scid[row]
  1077. uc_relid = this.Object.inwareid[row]
  1078. dw_wfjgmx.SetRedraw (FALSE)
  1079. dw_wfjgmx.Retrieve(ll_scid,uc_relid)
  1080. dw_wfjgmx.SetRedraw (TRUE)
  1081. ELSE
  1082. dw_wfjgmx.Reset()
  1083. END IF
  1084. end event
  1085. type tabpage_9 from userobject within tab_1
  1086. integer x = 18
  1087. integer y = 96
  1088. integer width = 3547
  1089. integer height = 2040
  1090. long backcolor = 134217739
  1091. string text = "车间外协收货单/返工单"
  1092. long tabtextcolor = 33554432
  1093. long tabbackcolor = 134217739
  1094. long picturemaskcolor = 536870912
  1095. dw_wfjgmx_cj dw_wfjgmx_cj
  1096. dw_wfjg_cj dw_wfjg_cj
  1097. end type
  1098. on tabpage_9.create
  1099. this.dw_wfjgmx_cj=create dw_wfjgmx_cj
  1100. this.dw_wfjg_cj=create dw_wfjg_cj
  1101. this.Control[]={this.dw_wfjgmx_cj,&
  1102. this.dw_wfjg_cj}
  1103. end on
  1104. on tabpage_9.destroy
  1105. destroy(this.dw_wfjgmx_cj)
  1106. destroy(this.dw_wfjg_cj)
  1107. end on
  1108. type dw_wfjgmx_cj from u_dw_rbtnfilter within tabpage_9
  1109. integer y = 1252
  1110. integer width = 3543
  1111. integer height = 764
  1112. integer taborder = 30
  1113. string title = "明细内容"
  1114. string dataobject = "dw_wfjgmx_in_aft_permit"
  1115. boolean hscrollbar = true
  1116. boolean vscrollbar = true
  1117. boolean rbutton_filter_use = true
  1118. boolean rbutton_setposition_use = true
  1119. boolean titleclick_sort_use = true
  1120. end type
  1121. type dw_wfjg_cj from u_dw_rbtnfilter within tabpage_9
  1122. integer width = 3543
  1123. integer height = 1240
  1124. string title = "单据摘要内容"
  1125. string dataobject = "dw_inware_wfjg_cj_permit"
  1126. boolean hscrollbar = true
  1127. boolean vscrollbar = true
  1128. boolean rbutton_filter_use = true
  1129. boolean rbutton_setposition_use = true
  1130. boolean titleclick_sort_use = true
  1131. end type
  1132. event rowfocuschanged;call super::rowfocuschanged;IF currentrow > 0 THEN
  1133. THIS.SelectRow(0,FALSE)
  1134. THIS.SelectRow(currentrow,TRUE)
  1135. END IF
  1136. Long row,uc_relid,ll_scid
  1137. row = dw_wfjg_cj.GetRow()
  1138. IF row > 0 THEN
  1139. ll_scid = this.Object.ow_wfjg_in_scid[row]
  1140. uc_relid = this.Object.inwareid[row]
  1141. dw_wfjgmx_cj.SetRedraw (FALSE)
  1142. dw_wfjgmx_cj.Retrieve(ll_scid,uc_relid)
  1143. dw_wfjgmx_cj.SetRedraw (TRUE)
  1144. ELSE
  1145. dw_wfjgmx_cj.Reset()
  1146. END IF
  1147. end event
  1148. type tabpage_4 from userobject within tab_1
  1149. integer x = 18
  1150. integer y = 96
  1151. integer width = 3547
  1152. integer height = 2040
  1153. long backcolor = 134217739
  1154. string text = "客户收款单"
  1155. long tabtextcolor = 33554432
  1156. long tabbackcolor = 134217739
  1157. long picturemaskcolor = 536870912
  1158. dw_cusamtmx dw_cusamtmx
  1159. dw_cusamt dw_cusamt
  1160. end type
  1161. on tabpage_4.create
  1162. this.dw_cusamtmx=create dw_cusamtmx
  1163. this.dw_cusamt=create dw_cusamt
  1164. this.Control[]={this.dw_cusamtmx,&
  1165. this.dw_cusamt}
  1166. end on
  1167. on tabpage_4.destroy
  1168. destroy(this.dw_cusamtmx)
  1169. destroy(this.dw_cusamt)
  1170. end on
  1171. type dw_cusamtmx from u_dw_rbtnfilter within tabpage_4
  1172. integer y = 1252
  1173. integer width = 3543
  1174. integer height = 764
  1175. integer taborder = 30
  1176. string title = "收款对单明细内容"
  1177. string dataobject = "dw_cusamt_mx_permit"
  1178. boolean hscrollbar = true
  1179. boolean vscrollbar = true
  1180. boolean rbutton_filter_use = true
  1181. boolean rbutton_setposition_use = true
  1182. boolean titleclick_sort_use = true
  1183. end type
  1184. type dw_cusamt from u_dw_rbtnfilter within tabpage_4
  1185. integer width = 3543
  1186. integer height = 1240
  1187. string title = "单据摘要内容"
  1188. string dataobject = "dw_cusamt_permit"
  1189. boolean hscrollbar = true
  1190. boolean vscrollbar = true
  1191. boolean rbutton_filter_use = true
  1192. boolean rbutton_setposition_use = true
  1193. boolean titleclick_sort_use = true
  1194. end type
  1195. event rowfocuschanged;call super::rowfocuschanged;IF currentrow > 0 THEN
  1196. THIS.SelectRow(0,FALSE)
  1197. THIS.SelectRow(currentrow,TRUE)
  1198. END IF
  1199. Long row,uc_relid
  1200. row = THIS.GetRow()
  1201. IF row > 0 THEN
  1202. uc_relid = THIS.Object.u_cusamt_refrapid[row]
  1203. dw_cusamtmx.SetRedraw (FALSE)
  1204. dw_cusamtmx.Retrieve(uc_relid)
  1205. dw_cusamtmx.SetRedraw (TRUE)
  1206. ELSE
  1207. dw_cusamtmx.Reset()
  1208. END IF
  1209. end event
  1210. type tabpage_5 from userobject within tab_1
  1211. integer x = 18
  1212. integer y = 96
  1213. integer width = 3547
  1214. integer height = 2040
  1215. long backcolor = 134217739
  1216. string text = "供应商付款单"
  1217. long tabtextcolor = 33554432
  1218. long tabbackcolor = 134217739
  1219. long picturemaskcolor = 536870912
  1220. dw_sptamtmx dw_sptamtmx
  1221. dw_sptamt dw_sptamt
  1222. end type
  1223. on tabpage_5.create
  1224. this.dw_sptamtmx=create dw_sptamtmx
  1225. this.dw_sptamt=create dw_sptamt
  1226. this.Control[]={this.dw_sptamtmx,&
  1227. this.dw_sptamt}
  1228. end on
  1229. on tabpage_5.destroy
  1230. destroy(this.dw_sptamtmx)
  1231. destroy(this.dw_sptamt)
  1232. end on
  1233. type dw_sptamtmx from u_dw_rbtnfilter within tabpage_5
  1234. integer y = 1252
  1235. integer width = 3543
  1236. integer height = 764
  1237. integer taborder = 30
  1238. string title = "付款对单明细内容"
  1239. string dataobject = "dw_sptamt_mx_permit"
  1240. boolean hscrollbar = true
  1241. boolean vscrollbar = true
  1242. boolean rbutton_filter_use = true
  1243. boolean rbutton_setposition_use = true
  1244. boolean titleclick_sort_use = true
  1245. end type
  1246. type dw_sptamt from u_dw_rbtnfilter within tabpage_5
  1247. integer width = 3543
  1248. integer height = 1240
  1249. string title = "单据摘要内容"
  1250. string dataobject = "dw_sptamt_permit"
  1251. boolean hscrollbar = true
  1252. boolean vscrollbar = true
  1253. boolean rbutton_filter_use = true
  1254. boolean rbutton_setposition_use = true
  1255. boolean titleclick_sort_use = true
  1256. end type
  1257. event rowfocuschanged;call super::rowfocuschanged;IF currentrow > 0 THEN
  1258. THIS.SelectRow(0,FALSE)
  1259. THIS.SelectRow(currentrow,TRUE)
  1260. END IF
  1261. Long row,uc_relid
  1262. row = THIS.GetRow()
  1263. IF row > 0 THEN
  1264. uc_relid = THIS.Object.u_cusamt_refrapid[row]
  1265. dw_sptamtmx.SetRedraw (FALSE)
  1266. dw_sptamtmx.Retrieve(uc_relid)
  1267. dw_sptamtmx.SetRedraw (TRUE)
  1268. ELSE
  1269. dw_sptamtmx.Reset()
  1270. END IF
  1271. end event
  1272. type tabpage_6 from userobject within tab_1
  1273. integer x = 18
  1274. integer y = 96
  1275. integer width = 3547
  1276. integer height = 2040
  1277. long backcolor = 134217739
  1278. string text = "收入支出单"
  1279. long tabtextcolor = 33554432
  1280. long tabbackcolor = 134217739
  1281. long picturemaskcolor = 536870912
  1282. dw_income_expenses dw_income_expenses
  1283. end type
  1284. on tabpage_6.create
  1285. this.dw_income_expenses=create dw_income_expenses
  1286. this.Control[]={this.dw_income_expenses}
  1287. end on
  1288. on tabpage_6.destroy
  1289. destroy(this.dw_income_expenses)
  1290. end on
  1291. type dw_income_expenses from u_dw_rbtnfilter within tabpage_6
  1292. integer width = 3543
  1293. integer height = 2024
  1294. integer taborder = 20
  1295. string dataobject = "dw_income_expenses_permit"
  1296. boolean hscrollbar = true
  1297. boolean vscrollbar = true
  1298. boolean rbutton_filter_use = true
  1299. boolean rbutton_setposition_use = true
  1300. boolean titleclick_sort_use = true
  1301. end type
  1302. event rowfocuschanged;call super::rowfocuschanged;IF currentrow > 0 THEN
  1303. THIS.SelectRow(0,FALSE)
  1304. THIS.SelectRow(currentrow,TRUE)
  1305. END IF
  1306. end event
  1307. type tabpage_7 from userobject within tab_1
  1308. integer x = 18
  1309. integer y = 96
  1310. integer width = 3547
  1311. integer height = 2040
  1312. long backcolor = 134217739
  1313. string text = "转账单"
  1314. long tabtextcolor = 33554432
  1315. long tabbackcolor = 134217739
  1316. long picturemaskcolor = 536870912
  1317. dw_rap_money_transfer dw_rap_money_transfer
  1318. end type
  1319. on tabpage_7.create
  1320. this.dw_rap_money_transfer=create dw_rap_money_transfer
  1321. this.Control[]={this.dw_rap_money_transfer}
  1322. end on
  1323. on tabpage_7.destroy
  1324. destroy(this.dw_rap_money_transfer)
  1325. end on
  1326. type dw_rap_money_transfer from u_dw_rbtnfilter within tabpage_7
  1327. integer width = 3543
  1328. integer height = 2024
  1329. string title = "单据摘要内容"
  1330. string dataobject = "dw_rap_money_transfer_permit"
  1331. boolean hscrollbar = true
  1332. boolean vscrollbar = true
  1333. boolean rbutton_filter_use = true
  1334. boolean rbutton_setposition_use = true
  1335. boolean titleclick_sort_use = true
  1336. end type
  1337. event rowfocuschanged;call super::rowfocuschanged;IF currentrow > 0 THEN
  1338. THIS.SelectRow(0,FALSE)
  1339. THIS.SelectRow(currentrow,TRUE)
  1340. END IF
  1341. end event
  1342. type tabpage_8 from userobject within tab_1
  1343. integer x = 18
  1344. integer y = 96
  1345. integer width = 3547
  1346. integer height = 2040
  1347. long backcolor = 134217739
  1348. string text = "发票单"
  1349. long tabtextcolor = 33554432
  1350. long tabbackcolor = 134217739
  1351. long picturemaskcolor = 536870912
  1352. dw_invoicemx dw_invoicemx
  1353. dw_invoice dw_invoice
  1354. end type
  1355. on tabpage_8.create
  1356. this.dw_invoicemx=create dw_invoicemx
  1357. this.dw_invoice=create dw_invoice
  1358. this.Control[]={this.dw_invoicemx,&
  1359. this.dw_invoice}
  1360. end on
  1361. on tabpage_8.destroy
  1362. destroy(this.dw_invoicemx)
  1363. destroy(this.dw_invoice)
  1364. end on
  1365. type dw_invoicemx from u_dw_rbtnfilter within tabpage_8
  1366. integer y = 1252
  1367. integer width = 3543
  1368. integer height = 764
  1369. integer taborder = 30
  1370. string title = "明细内容"
  1371. string dataobject = "dw_invoicemx_permit"
  1372. boolean hscrollbar = true
  1373. boolean vscrollbar = true
  1374. boolean rbutton_filter_use = true
  1375. boolean rbutton_setposition_use = true
  1376. boolean titleclick_sort_use = true
  1377. end type
  1378. type dw_invoice from u_dw_rbtnfilter within tabpage_8
  1379. integer width = 3543
  1380. integer height = 1240
  1381. string title = "单据摘要内容"
  1382. string dataobject = "dw_invoice_permit"
  1383. boolean hscrollbar = true
  1384. boolean vscrollbar = true
  1385. boolean rbutton_filter_use = true
  1386. boolean rbutton_setposition_use = true
  1387. boolean titleclick_sort_use = true
  1388. end type
  1389. event rowfocuschanged;call super::rowfocuschanged;IF currentrow > 0 THEN
  1390. THIS.SelectRow(0,FALSE)
  1391. THIS.SelectRow(currentrow,TRUE)
  1392. END IF
  1393. Long row,uc_relid
  1394. row = THIS.GetRow()
  1395. if row>0 then
  1396. uc_relid=this.object.invoiceid[row]
  1397. dw_invoicemx.SetRedraw (false)
  1398. dw_invoicemx.retrieve(cur_scid,uc_relid)
  1399. dw_invoicemx.SetRedraw (true)
  1400. else
  1401. dw_invoicemx.reset()
  1402. end if
  1403. end event
  1404. type st_1 from statictext within w_permit_bill
  1405. integer x = 27
  1406. integer y = 24
  1407. integer width = 201
  1408. integer height = 48
  1409. boolean bringtotop = true
  1410. integer textsize = -9
  1411. integer weight = 400
  1412. fontcharset fontcharset = gb2312charset!
  1413. fontpitch fontpitch = variable!
  1414. string facename = "宋体"
  1415. long textcolor = 33554432
  1416. long backcolor = 134217739
  1417. string text = "单号含:"
  1418. boolean focusrectangle = false
  1419. end type
  1420. type sle_usual_query1 from u_sleedit within w_permit_bill
  1421. integer x = 229
  1422. integer y = 4
  1423. integer height = 92
  1424. integer taborder = 30
  1425. boolean bringtotop = true
  1426. end type
  1427. event modified;call super::modified;PARENT.TRIGGEREVENT("ue_usual_query_RETR")
  1428. end event
  1429. event keyup;call super::keyup;//IF NOT dw_edit_mode THEN
  1430. // If Key = KeyDownArrow! Then //
  1431. // dw_pageretr.ScrollNextRow()
  1432. // End If
  1433. // If Key = KeyUPArrow! Then //
  1434. // dw_pageretr.ScrollPriorRow()
  1435. // End If
  1436. //END IF
  1437. end event
  1438. event inputchanged;call super::inputchanged;PARENT.TRIGGEREVENT("ue_usual_query_RETR")
  1439. end event
  1440. type st_2 from statictext within w_permit_bill
  1441. integer x = 1531
  1442. integer y = 24
  1443. integer width = 128
  1444. integer height = 48
  1445. boolean bringtotop = true
  1446. integer textsize = -9
  1447. integer weight = 400
  1448. fontcharset fontcharset = gb2312charset!
  1449. fontpitch fontpitch = variable!
  1450. string facename = "宋体"
  1451. long textcolor = 33554432
  1452. long backcolor = 134217739
  1453. string text = "分部"
  1454. boolean focusrectangle = false
  1455. end type
  1456. type ddlb_scid from uo_ddlb_scid within w_permit_bill
  1457. integer x = 1659
  1458. integer y = 8
  1459. integer width = 549
  1460. integer height = 620
  1461. integer taborder = 50
  1462. boolean bringtotop = true
  1463. end type
  1464. event constructor;call super::constructor;cur_scid=this.uo_scid
  1465. end event
  1466. event selectionchanged;call super::selectionchanged;cur_scid=this.uo_scid
  1467. parent.triggerevent("retrieve_pageretr")
  1468. end event
  1469. type st_3 from statictext within w_permit_bill
  1470. integer x = 2240
  1471. integer y = 24
  1472. integer width = 128
  1473. integer height = 52
  1474. boolean bringtotop = true
  1475. integer textsize = -9
  1476. integer weight = 400
  1477. fontcharset fontcharset = gb2312charset!
  1478. fontpitch fontpitch = variable!
  1479. string facename = "宋体"
  1480. long textcolor = 33554432
  1481. long backcolor = 134217739
  1482. string text = "状态"
  1483. boolean focusrectangle = false
  1484. end type
  1485. type ddlb_1 from dropdownlistbox within w_permit_bill
  1486. integer x = 2377
  1487. integer y = 8
  1488. integer width = 325
  1489. integer height = 452
  1490. integer taborder = 60
  1491. boolean bringtotop = true
  1492. integer textsize = -9
  1493. integer weight = 400
  1494. fontcharset fontcharset = gb2312charset!
  1495. fontpitch fontpitch = variable!
  1496. string facename = "宋体"
  1497. long textcolor = 33554432
  1498. string text = "待终审"
  1499. string item[] = {"待终审","已终审","[全部]"}
  1500. borderstyle borderstyle = stylelowered!
  1501. end type
  1502. event selectionchanged;IF Index = 1 THEN
  1503. cur_secflag = 0
  1504. ELSEIF Index = 2 THEN
  1505. cur_secflag = 1
  1506. ELSEIF Index = 3 THEN
  1507. cur_secflag = -1
  1508. END IF
  1509. PARENT.TriggerEvent('retrieve_pageretr')
  1510. end event
  1511. type cb_permit from commandbutton within w_permit_bill
  1512. integer x = 2816
  1513. integer y = 8
  1514. integer width = 219
  1515. integer height = 84
  1516. integer taborder = 70
  1517. boolean bringtotop = true
  1518. integer textsize = -9
  1519. integer weight = 400
  1520. fontcharset fontcharset = gb2312charset!
  1521. fontpitch fontpitch = variable!
  1522. string facename = "宋体"
  1523. string text = "审核&F"
  1524. end type
  1525. event clicked;Long pagerert_row,ls_id
  1526. String arg_msg
  1527. CHOOSE CASE tab_1.SelectedTab
  1528. CASE 1
  1529. pagerert_row = dw_sale.GetRow()
  1530. if pagerert_row = 0 then return
  1531. IF dw_sale.Object.flag[pagerert_row] = 1 AND dw_sale.Object.secflag[pagerert_row] = 0 THEN
  1532. IF uo_sale.getinfo(dw_sale.Object.u_outware_scid[pagerert_row],dw_sale.Object.u_outware_outwareid[pagerert_row],arg_msg) = 0 THEN
  1533. MessageBox('错误',arg_msg,stopsign!,ok!)
  1534. RETURN
  1535. END IF
  1536. IF uo_sale.secauditing(TRUE,arg_msg) = 0 THEN
  1537. MessageBox('错误',arg_msg,stopsign!,ok!)
  1538. ELSE
  1539. MessageBox('提示','财务审核成功!',information!,ok!)
  1540. IF wf_refresh_curuc(arg_msg) = 0 THEN
  1541. MessageBox('错误',arg_msg,stopsign!,ok!)
  1542. END IF
  1543. END IF
  1544. END IF
  1545. CASE 2
  1546. pagerert_row = dw_buy.GetRow()
  1547. if pagerert_row = 0 then return
  1548. IF dw_buy.Object.flag[pagerert_row] = 1 AND dw_buy.Object.u_inware_secflag[pagerert_row] = 0 THEN
  1549. IF uo_buy.getinfo(dw_buy.Object.u_inware_scid[pagerert_row],dw_buy.Object.inwareid[pagerert_row],arg_msg) = 0 THEN
  1550. MessageBox('错误',arg_msg,stopsign!,ok!)
  1551. RETURN
  1552. END IF
  1553. IF uo_buy.secauditing(TRUE,arg_msg) = 0 THEN
  1554. MessageBox('错误',arg_msg,stopsign!,ok!)
  1555. ELSE
  1556. MessageBox('提示','财务审核成功!',information!,ok!)
  1557. IF wf_refresh_curuc(arg_msg) = 0 THEN
  1558. MessageBox('错误',arg_msg,stopsign!,ok!)
  1559. END IF
  1560. END IF
  1561. END IF
  1562. CASE 3
  1563. pagerert_row = dw_wfjg.GetRow()
  1564. if pagerert_row = 0 then return
  1565. IF dw_wfjg.Object.flag[pagerert_row] = 1 AND dw_wfjg.Object.secflag[pagerert_row] = 0 THEN
  1566. IF uo_wfjg.getinfo(dw_wfjg.Object.ow_wfjg_in_scid[pagerert_row],dw_wfjg.Object.inwareid[pagerert_row],arg_msg) = 0 THEN
  1567. MessageBox('错误',arg_msg,stopsign!,ok!)
  1568. RETURN
  1569. END IF
  1570. IF uo_wfjg.secauditing(TRUE,arg_msg) = 0 THEN
  1571. MessageBox('错误',arg_msg,stopsign!,ok!)
  1572. ELSE
  1573. MessageBox('提示','财务审核成功!',information!,ok!)
  1574. IF wf_refresh_curuc(arg_msg) = 0 THEN
  1575. MessageBox('错误',arg_msg,stopsign!,ok!)
  1576. END IF
  1577. END IF
  1578. END IF
  1579. CASE 4
  1580. pagerert_row = dw_wfjg_cj.GetRow()
  1581. if pagerert_row = 0 then return
  1582. IF dw_wfjg_cj.Object.flag[pagerert_row] = 1 AND dw_wfjg_cj.Object.secflag[pagerert_row] = 0 THEN
  1583. IF uo_wfjg.getinfo(dw_wfjg_cj.Object.ow_wfjg_in_scid[pagerert_row],dw_wfjg_cj.Object.inwareid[pagerert_row],arg_msg) = 0 THEN
  1584. MessageBox('错误',arg_msg,stopsign!,ok!)
  1585. RETURN
  1586. END IF
  1587. IF uo_wfjg.secauditing(TRUE,arg_msg) = 0 THEN
  1588. MessageBox('错误',arg_msg,stopsign!,ok!)
  1589. ELSE
  1590. MessageBox('提示','财务审核成功!',information!,ok!)
  1591. IF wf_refresh_curuc(arg_msg) = 0 THEN
  1592. MessageBox('错误',arg_msg,stopsign!,ok!)
  1593. END IF
  1594. END IF
  1595. END IF
  1596. CASE 5
  1597. pagerert_row = dw_cusamt.GetRow()
  1598. if pagerert_row = 0 then return
  1599. IF dw_cusamt.Object.flag[pagerert_row] = 1 AND dw_cusamt.Object.secflag[pagerert_row] = 0 THEN
  1600. IF uo_take.secauditing(dw_cusamt.Object.u_cusamt_cusmonid[pagerert_row],publ_operator,arg_msg,TRUE) = 0 THEN
  1601. MessageBox('错误',arg_msg,stopsign!,ok!)
  1602. ELSE
  1603. MessageBox('提示','审核成功!',information!,ok!)
  1604. IF wf_refresh_curuc(arg_msg) = 0 THEN
  1605. MessageBox('错误',arg_msg,stopsign!,ok!)
  1606. END IF
  1607. END IF
  1608. END IF
  1609. CASE 6
  1610. pagerert_row = dw_sptamt.GetRow()
  1611. if pagerert_row = 0 then return
  1612. IF dw_sptamt.Object.flag[pagerert_row] = 1 AND dw_sptamt.Object.secflag[pagerert_row] = 0 THEN
  1613. IF uo_take.secauditing(dw_sptamt.Object.u_cusamt_cusmonid[pagerert_row],publ_operator,arg_msg,TRUE) = 0 THEN
  1614. MessageBox('错误',arg_msg,stopsign!,ok!)
  1615. ELSE
  1616. MessageBox('提示','审核成功!',information!,ok!)
  1617. IF wf_refresh_curuc(arg_msg) = 0 THEN
  1618. MessageBox('错误',arg_msg,stopsign!,ok!)
  1619. END IF
  1620. END IF
  1621. END IF
  1622. CASE 7
  1623. pagerert_row = dw_income_expenses.GetRow()
  1624. if pagerert_row = 0 then return
  1625. IF dw_income_expenses.Object.flag[pagerert_row] = 1 AND dw_income_expenses.Object.secflag[pagerert_row] = 0 THEN
  1626. IF uo_ie.permit2(dw_income_expenses.Object.u_income_expenses_billid[pagerert_row],publ_operator,arg_msg,TRUE) = 0 THEN
  1627. MessageBox('错误',arg_msg,stopsign!,ok!)
  1628. ELSE
  1629. MessageBox('提示','审核成功!',information!,ok!)
  1630. IF wf_refresh_curuc(arg_msg) = 0 THEN
  1631. MessageBox('错误',arg_msg,stopsign!,ok!)
  1632. END IF
  1633. END IF
  1634. END IF
  1635. CASE 8
  1636. pagerert_row = dw_rap_money_transfer.GetRow()
  1637. if pagerert_row = 0 then return
  1638. IF dw_rap_money_transfer.Object.flag[pagerert_row] = 1 AND dw_rap_money_transfer.Object.secflag[pagerert_row] = 0 THEN
  1639. IF uo_output.secaudit(dw_rap_money_transfer.Object.billid[pagerert_row],publ_operator,arg_msg,TRUE) = 0 THEN
  1640. MessageBox('错误',arg_msg,stopsign!,ok!)
  1641. ELSE
  1642. MessageBox('提示','审核成功!',information!,ok!)
  1643. IF wf_refresh_curuc(arg_msg) = 0 THEN
  1644. MessageBox('错误',arg_msg,stopsign!,ok!)
  1645. END IF
  1646. END IF
  1647. END IF
  1648. CASE 9
  1649. pagerert_row = dw_invoice.GetRow()
  1650. if pagerert_row = 0 then return
  1651. IF dw_invoice.Object.flag[pagerert_row] = 1 AND dw_invoice.Object.secflag[pagerert_row] = 0 THEN
  1652. IF uo_ware.getinfo(dw_invoice.Object.scid[pagerert_row],dw_invoice.Object.invoiceid[pagerert_row],arg_msg) = 0 THEN
  1653. MessageBox('错误',arg_msg,stopsign!,ok!)
  1654. RETURN
  1655. END IF
  1656. IF uo_ware.secauditing(TRUE,arg_msg) = 0 THEN
  1657. MessageBox('错误',arg_msg,stopsign!,ok!)
  1658. ELSE
  1659. MessageBox('提示','审核成功!',information!,ok!)
  1660. IF wf_refresh_curuc(arg_msg) = 0 THEN
  1661. MessageBox('错误',arg_msg,stopsign!,ok!)
  1662. END IF
  1663. END IF
  1664. END IF
  1665. END CHOOSE
  1666. end event
  1667. type cb_c_permit from commandbutton within w_permit_bill
  1668. integer x = 3035
  1669. integer y = 8
  1670. integer width = 219
  1671. integer height = 84
  1672. integer taborder = 80
  1673. boolean bringtotop = true
  1674. integer textsize = -9
  1675. integer weight = 400
  1676. fontcharset fontcharset = gb2312charset!
  1677. fontpitch fontpitch = variable!
  1678. string facename = "宋体"
  1679. string text = "撤审&B"
  1680. end type
  1681. event clicked;Long pagerert_row,ls_id
  1682. String arg_msg
  1683. CHOOSE CASE tab_1.SelectedTab
  1684. CASE 1
  1685. pagerert_row = dw_sale.GetRow()
  1686. IF dw_sale.Object.flag[pagerert_row] = 1 AND dw_sale.Object.secflag[pagerert_row] = 1 THEN
  1687. IF uo_sale.getinfo(dw_sale.Object.u_outware_scid[pagerert_row],dw_sale.Object.u_outware_outwareid[pagerert_row],arg_msg) = 0 THEN
  1688. MessageBox('错误',arg_msg,stopsign!,ok!)
  1689. RETURN
  1690. END IF
  1691. IF uo_sale.c_secauditing(TRUE,arg_msg) = 0 THEN
  1692. MessageBox('错误',arg_msg,stopsign!,ok!)
  1693. ELSE
  1694. MessageBox('提示','财务撤销审核成功!',information!,ok!)
  1695. IF wf_refresh_curuc(arg_msg) = 0 THEN
  1696. MessageBox('错误',arg_msg,stopsign!,ok!)
  1697. END IF
  1698. END IF
  1699. END IF
  1700. CASE 2
  1701. pagerert_row = dw_buy.GetRow()
  1702. IF dw_buy.Object.flag[pagerert_row] = 1 AND dw_buy.Object.u_inware_secflag[pagerert_row] = 1 THEN
  1703. IF uo_buy.getinfo(dw_buy.Object.u_inware_scid[pagerert_row],dw_buy.Object.inwareid[pagerert_row],arg_msg) = 0 THEN
  1704. MessageBox('错误',arg_msg,stopsign!,ok!)
  1705. RETURN
  1706. END IF
  1707. IF uo_buy.c_secauditing(TRUE,arg_msg) = 0 THEN
  1708. MessageBox('错误',arg_msg,stopsign!,ok!)
  1709. ELSE
  1710. MessageBox('提示','财务撤销审核成功!',information!,ok!)
  1711. IF wf_refresh_curuc(arg_msg) = 0 THEN
  1712. MessageBox('错误',arg_msg,stopsign!,ok!)
  1713. END IF
  1714. END IF
  1715. END IF
  1716. CASE 3
  1717. pagerert_row = dw_wfjg.GetRow()
  1718. IF dw_wfjg.Object.flag[pagerert_row] = 1 AND dw_wfjg.Object.secflag[pagerert_row] = 1 THEN
  1719. IF uo_wfjg.getinfo(dw_wfjg.Object.ow_wfjg_in_scid[pagerert_row],dw_wfjg.Object.inwareid[pagerert_row],arg_msg) = 0 THEN
  1720. MessageBox('错误',arg_msg,stopsign!,ok!)
  1721. RETURN
  1722. END IF
  1723. IF uo_wfjg.c_secauditing(TRUE,arg_msg) = 0 THEN
  1724. MessageBox('错误',arg_msg,stopsign!,ok!)
  1725. ELSE
  1726. MessageBox('提示','财务撤销审核成功!',information!,ok!)
  1727. IF wf_refresh_curuc(arg_msg) = 0 THEN
  1728. MessageBox('错误',arg_msg,stopsign!,ok!)
  1729. END IF
  1730. END IF
  1731. END IF
  1732. CASE 4
  1733. pagerert_row = dw_wfjg_cj.GetRow()
  1734. IF dw_wfjg_cj.Object.flag[pagerert_row] = 1 AND dw_wfjg_cj.Object.secflag[pagerert_row] = 1 THEN
  1735. IF uo_wfjg.getinfo(dw_wfjg_cj.Object.ow_wfjg_in_scid[pagerert_row],dw_wfjg_cj.Object.inwareid[pagerert_row],arg_msg) = 0 THEN
  1736. MessageBox('错误',arg_msg,stopsign!,ok!)
  1737. RETURN
  1738. END IF
  1739. IF uo_wfjg.c_secauditing(TRUE,arg_msg) = 0 THEN
  1740. MessageBox('错误',arg_msg,stopsign!,ok!)
  1741. ELSE
  1742. MessageBox('提示','财务撤销审核成功!',information!,ok!)
  1743. IF wf_refresh_curuc(arg_msg) = 0 THEN
  1744. MessageBox('错误',arg_msg,stopsign!,ok!)
  1745. END IF
  1746. END IF
  1747. END IF
  1748. CASE 5
  1749. pagerert_row = dw_cusamt.GetRow()
  1750. IF dw_cusamt.Object.flag[pagerert_row] = 1 AND dw_cusamt.Object.secflag[pagerert_row] = 1 THEN
  1751. IF uo_take.c_secauditing(dw_cusamt.Object.u_cusamt_cusmonid[pagerert_row],arg_msg,TRUE) = 0 THEN
  1752. MessageBox('错误',arg_msg,stopsign!,ok!)
  1753. ELSE
  1754. MessageBox('提示','撤销审核成功!',information!,ok!)
  1755. IF wf_refresh_curuc(arg_msg) = 0 THEN
  1756. MessageBox('错误',arg_msg,stopsign!,ok!)
  1757. END IF
  1758. END IF
  1759. END IF
  1760. CASE 6
  1761. pagerert_row = dw_sptamt.GetRow()
  1762. IF dw_sptamt.Object.flag[pagerert_row] = 1 AND dw_sptamt.Object.secflag[pagerert_row] = 1 THEN
  1763. IF uo_take.c_secauditing(dw_sptamt.Object.u_cusamt_cusmonid[pagerert_row],arg_msg,TRUE) = 0 THEN
  1764. MessageBox('错误',arg_msg,stopsign!,ok!)
  1765. ELSE
  1766. MessageBox('提示','撤销审核成功!',information!,ok!)
  1767. IF wf_refresh_curuc(arg_msg) = 0 THEN
  1768. MessageBox('错误',arg_msg,stopsign!,ok!)
  1769. END IF
  1770. END IF
  1771. END IF
  1772. CASE 7
  1773. pagerert_row = dw_income_expenses.GetRow()
  1774. IF dw_income_expenses.Object.flag[pagerert_row] = 1 AND dw_income_expenses.Object.secflag[pagerert_row] = 1 THEN
  1775. IF uo_ie.cancelpermit2(dw_income_expenses.Object.u_income_expenses_billid[pagerert_row],arg_msg,TRUE) = 0 THEN
  1776. MessageBox('错误',arg_msg,stopsign!,ok!)
  1777. ELSE
  1778. MessageBox('提示','撤销审核成功!',information!,ok!)
  1779. IF wf_refresh_curuc(arg_msg) = 0 THEN
  1780. MessageBox('错误',arg_msg,stopsign!,ok!)
  1781. END IF
  1782. END IF
  1783. END IF
  1784. CASE 8
  1785. pagerert_row = dw_rap_money_transfer.GetRow()
  1786. IF dw_rap_money_transfer.Object.flag[pagerert_row] = 1 AND dw_rap_money_transfer.Object.secflag[pagerert_row] = 1 THEN
  1787. IF uo_output.csecaudit(dw_rap_money_transfer.Object.billid[pagerert_row],arg_msg,TRUE) = 0 THEN
  1788. MessageBox('错误',arg_msg,stopsign!,ok!)
  1789. ELSE
  1790. MessageBox('提示','撤销审核成功!',information!,ok!)
  1791. IF wf_refresh_curuc(arg_msg) = 0 THEN
  1792. MessageBox('错误',arg_msg,stopsign!,ok!)
  1793. END IF
  1794. END IF
  1795. END IF
  1796. CASE 9
  1797. pagerert_row = dw_invoice.GetRow()
  1798. IF dw_invoice.Object.flag[pagerert_row] = 1 AND dw_invoice.Object.secflag[pagerert_row] = 1 THEN
  1799. IF uo_ware.getinfo(dw_invoice.Object.scid[pagerert_row],dw_invoice.Object.invoiceid[pagerert_row],arg_msg) = 0 THEN
  1800. MessageBox('错误',arg_msg,stopsign!,ok!)
  1801. RETURN
  1802. END IF
  1803. IF uo_ware.c_secauditing(TRUE,arg_msg) = 0 THEN
  1804. MessageBox('错误',arg_msg,stopsign!,ok!)
  1805. ELSE
  1806. MessageBox('提示','撤销审核成功!',information!,ok!)
  1807. IF wf_refresh_curuc(arg_msg) = 0 THEN
  1808. MessageBox('错误',arg_msg,stopsign!,ok!)
  1809. END IF
  1810. END IF
  1811. END IF
  1812. END CHOOSE
  1813. end event
  1814. type cb_retr from commandbutton within w_permit_bill
  1815. integer x = 3255
  1816. integer y = 8
  1817. integer width = 219
  1818. integer height = 84
  1819. integer taborder = 90
  1820. boolean bringtotop = true
  1821. integer textsize = -9
  1822. integer weight = 400
  1823. fontcharset fontcharset = gb2312charset!
  1824. fontpitch fontpitch = variable!
  1825. string facename = "宋体"
  1826. string text = "刷新"
  1827. end type
  1828. event clicked;PARENT.TriggerEvent('retrieve_pageretr')
  1829. end event
  1830. type st_4 from statictext within w_permit_bill
  1831. integer x = 786
  1832. integer y = 24
  1833. integer width = 206
  1834. integer height = 48
  1835. boolean bringtotop = true
  1836. integer textsize = -9
  1837. integer weight = 400
  1838. fontcharset fontcharset = gb2312charset!
  1839. fontpitch fontpitch = variable!
  1840. string facename = "宋体"
  1841. long textcolor = 33554432
  1842. long backcolor = 134217739
  1843. string text = "相关号:"
  1844. boolean focusrectangle = false
  1845. end type
  1846. type sle_usual_query2 from u_sleedit within w_permit_bill
  1847. integer x = 987
  1848. integer y = 4
  1849. integer height = 92
  1850. integer taborder = 40
  1851. boolean bringtotop = true
  1852. end type
  1853. event modified;call super::modified;PARENT.TRIGGEREVENT("ue_usual_query_RETR")
  1854. end event
  1855. event keyup;call super::keyup;//IF NOT dw_edit_mode THEN
  1856. // If Key = KeyDownArrow! Then //
  1857. // dw_pageretr.ScrollNextRow()
  1858. // End If
  1859. // If Key = KeyUPArrow! Then //
  1860. // dw_pageretr.ScrollPriorRow()
  1861. // End If
  1862. //END IF
  1863. end event
  1864. event inputchanged;call super::inputchanged;PARENT.TRIGGEREVENT("ue_usual_query_RETR")
  1865. end event