w_sptamt_edit.srw 54 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206
  1. $PBExportHeader$w_sptamt_edit.srw
  2. forward
  3. global type w_sptamt_edit from w_publ_1ton_share_detail
  4. end type
  5. type ddlb_status from dropdownlistbox within w_sptamt_edit
  6. end type
  7. type ddlb_scid from uo_ddlb_scid within w_sptamt_edit
  8. end type
  9. type st_3 from statictext within w_sptamt_edit
  10. end type
  11. type st_2 from statictext within w_sptamt_edit
  12. end type
  13. type cb_2 from uo_imflatbutton within w_sptamt_edit
  14. end type
  15. type cb_confirm from uo_imflatbutton within w_sptamt_edit
  16. end type
  17. type cb_cconfirm from uo_imflatbutton within w_sptamt_edit
  18. end type
  19. type cbx_1 from checkbox within w_sptamt_edit
  20. end type
  21. end forward
  22. global type w_sptamt_edit from w_publ_1ton_share_detail
  23. string title = "供应商付款单"
  24. boolean maxbox = true
  25. windowstate windowstate = maximized!
  26. event ue_fj_view ( )
  27. event ue_fj_edit ( )
  28. event ue_p_auditing ( )
  29. event ue_c_p_auditing ( )
  30. event ue_p_secauditing ( )
  31. event ue_c_p_secauditing ( )
  32. event ue_p_confirm ( )
  33. event ue_c_p_confirm ( )
  34. ddlb_status ddlb_status
  35. ddlb_scid ddlb_scid
  36. st_3 st_3
  37. st_2 st_2
  38. cb_2 cb_2
  39. cb_confirm cb_confirm
  40. cb_cconfirm cb_cconfirm
  41. cbx_1 cbx_1
  42. end type
  43. global w_sptamt_edit w_sptamt_edit
  44. type variables
  45. uo_cusamt uo_take
  46. Int cur_flag = -1
  47. int cur_secflag = -1
  48. Long cur_scid //分店ID
  49. int cur_confirmflag = -1
  50. end variables
  51. forward prototypes
  52. public function integer wf_refresh_curuc (long arg_billid)
  53. public function integer wf_flagstatus_rf ()
  54. end prototypes
  55. event ue_fj_view();IF dw_edit_mode THEN
  56. MessageBox('提示','编辑状态下不可用',information!,OK!)
  57. RETURN
  58. END IF
  59. s_edit_index_tran s_pic
  60. Long ll_ConnectionID
  61. String arg_msg
  62. Long ls_row
  63. ls_row = dw_pageretr.GetRow()
  64. IF ls_row <= 0 THEN
  65. RETURN
  66. END IF
  67. IF f_get_outerconnection(ll_ConnectionID,arg_msg) = 0 THEN
  68. MessageBox('提示','没有指定附件数据库连接'+arg_msg,information!,OK!)
  69. RETURN
  70. END IF
  71. s_pic.f_long = 544 //
  72. s_pic.f_string = dw_pageretr.Object.u_cusamt_cusmoncode[ls_row]
  73. s_pic.g_long = dw_pageretr.Object.u_cusamt_cusmonid[ls_row]
  74. s_pic.e_long = dw_pageretr.Object.u_cusamt_scid[ls_row]
  75. s_pic.sqltransaction = sys_filedb_sqlca
  76. OpenWithParm(w_fj_bill_view,s_pic)
  77. end event
  78. event ue_fj_edit();IF dw_edit_mode THEN
  79. MessageBox('提示','编辑状态下不可用',information!,OK!)
  80. RETURN
  81. END IF
  82. //IF NOT f_power_ind(1098) THEN
  83. // MessageBox(publ_operator,sys_msg_pow)
  84. // RETURN
  85. //END IF
  86. s_edit_index_tran s_pic
  87. Long ll_ConnectionID
  88. String arg_msg
  89. Long ls_row
  90. ls_row = dw_pageretr.GetRow()
  91. IF ls_row <= 0 THEN
  92. RETURN
  93. END IF
  94. IF f_get_outerconnection(ll_ConnectionID,arg_msg) = 0 THEN
  95. MessageBox('提示','没有指定附件数据库连接'+arg_msg,information!,OK!)
  96. RETURN
  97. END IF
  98. s_pic.f_long = 544
  99. s_pic.f_string = dw_pageretr.Object.u_cusamt_cusmoncode[ls_row]
  100. s_pic.g_long = dw_pageretr.Object.u_cusamt_cusmonid[ls_row]
  101. s_pic.e_long = dw_pageretr.Object.u_cusamt_scid[ls_row]
  102. s_pic.sqltransaction = sys_filedb_sqlca
  103. OpenWithParm(w_fj_bill_mng,s_pic)
  104. end event
  105. event ue_p_auditing();//批初审
  106. Long i
  107. String arg_msg,ls_msg2
  108. String ls_taskcode
  109. IF dw_edit_mode THEN RETURN
  110. IF Not f_power_ind(932) THEN
  111. MessageBox('提示','你没有使用权限!',information!,ok!)
  112. RETURN
  113. END IF
  114. IF dw_pageretr.Find('ch = 1',1,dw_pageretr.RowCount()) = 0 THEN
  115. MessageBox('系统提示','请先勾选要批初审的单据!')
  116. RETURN
  117. END IF
  118. IF MessageBox ("询问","是否确定要对已选择的单据批初审核?",Question!,YesNo! ) = 2 THEN RETURN
  119. Close(w_sys_wait)
  120. Open(w_sys_wait)
  121. FOR i = 1 To dw_pageretr.RowCount()
  122. ls_taskcode = ''
  123. arg_msg = ''
  124. ls_taskcode = dw_pageretr.Object.u_cusamt_cusmoncode[i]
  125. IF dw_pageretr.Object.ch[i] = 1 THEN
  126. IF dw_pageretr.Object.u_cusamt_flag[i] = 1 THEN
  127. arg_msg = ls_taskcode + ',已经初审' +'~r~n'
  128. ls_msg2 = ls_msg2 + arg_msg
  129. CONTINUE
  130. END IF
  131. IF uo_take.auditing(dw_pageretr.Object.u_cusamt_cusmonid[i],publ_operator,arg_msg,True) = 0 THEN
  132. arg_msg = ls_taskcode + ',初审失败,' +arg_msg +'~r~n'
  133. ls_msg2 = ls_msg2 + arg_msg
  134. END IF
  135. END IF
  136. NEXT
  137. Close(w_sys_wait)
  138. IF ls_msg2 <> '' THEN
  139. OpenWithParm(w_message_err,ls_msg2)
  140. ELSE
  141. MessageBox('提示','全部初审成功!')
  142. END IF
  143. cb_retrieve.TriggerEvent('clicked')
  144. end event
  145. event ue_c_p_auditing();// 批初撤审
  146. Long i
  147. String arg_msg,ls_msg2
  148. String ls_taskcode
  149. IF dw_edit_mode THEN RETURN
  150. IF Not f_power_ind(933) THEN
  151. MessageBox('提示','你没有使用权限!',information!,ok!)
  152. RETURN
  153. END IF
  154. IF dw_pageretr.Find('ch = 1',1,dw_pageretr.RowCount()) = 0 THEN
  155. MessageBox('系统提示','请先勾选要批初审的单据!')
  156. RETURN
  157. END IF
  158. IF MessageBox ("询问","是否确定要对已选择的单据批初审核?",Question!,YesNo! ) = 2 THEN RETURN
  159. Close(w_sys_wait)
  160. Open(w_sys_wait)
  161. FOR i = 1 To dw_pageretr.RowCount()
  162. ls_taskcode = ''
  163. arg_msg = ''
  164. ls_taskcode = dw_pageretr.Object.u_cusamt_cusmoncode[i]
  165. IF dw_pageretr.Object.ch[i] = 1 THEN
  166. IF dw_pageretr.Object.u_cusamt_flag[i] = 0 THEN
  167. arg_msg = ls_taskcode + ',未初审,不能初撤' +'~r~n'
  168. ls_msg2 = ls_msg2 + arg_msg
  169. CONTINUE
  170. END IF
  171. IF dw_pageretr.Object.u_cusamt_secflag[i] = 1 THEN
  172. arg_msg = ls_taskcode + ',已终审,不能初撤' +'~r~n'
  173. ls_msg2 = ls_msg2 + arg_msg
  174. CONTINUE
  175. END IF
  176. IF uo_take.c_auditing(dw_pageretr.Object.u_cusamt_cusmonid[i],arg_msg,True) = 0 THEN
  177. arg_msg = ls_taskcode + ',初撤审失败,' +arg_msg +'~r~n'
  178. ls_msg2 = ls_msg2 + arg_msg
  179. END IF
  180. END IF
  181. NEXT
  182. Close(w_sys_wait)
  183. IF ls_msg2 <> '' THEN
  184. OpenWithParm(w_message_err,ls_msg2)
  185. ELSE
  186. MessageBox('提示','全部初撤审成功!')
  187. END IF
  188. cb_retrieve.TriggerEvent('clicked')
  189. end event
  190. event ue_p_secauditing();//批终审
  191. Long i
  192. String arg_msg,ls_msg2
  193. String ls_taskcode
  194. IF dw_edit_mode THEN RETURN
  195. IF Not f_power_ind(999) THEN
  196. MessageBox('提示','你没有使用权限!',information!,ok!)
  197. RETURN
  198. END IF
  199. IF dw_pageretr.Find('ch = 1',1,dw_pageretr.RowCount()) = 0 THEN
  200. MessageBox('系统提示','请先勾选要批终审的单据!')
  201. RETURN
  202. END IF
  203. IF MessageBox ("询问","是否确定要对已选择的单据批终审核?",Question!,YesNo! ) = 2 THEN RETURN
  204. Close(w_sys_wait)
  205. Open(w_sys_wait)
  206. FOR i = 1 To dw_pageretr.RowCount()
  207. ls_taskcode = ''
  208. arg_msg = ''
  209. ls_taskcode = dw_pageretr.Object.u_cusamt_cusmoncode[i]
  210. IF dw_pageretr.Object.ch[i] = 1 THEN
  211. IF dw_pageretr.Object.u_cusamt_secflag[i] = 1 THEN
  212. arg_msg = ls_taskcode + ',已经终审' +'~r~n'
  213. ls_msg2 = ls_msg2 + arg_msg
  214. CONTINUE
  215. END IF
  216. IF uo_take.secauditing(dw_pageretr.Object.u_cusamt_cusmonid[i],publ_operator,arg_msg,True) = 0 THEN
  217. arg_msg = ls_taskcode + ',终审失败,' +arg_msg +'~r~n'
  218. ls_msg2 = ls_msg2 + arg_msg
  219. END IF
  220. END IF
  221. NEXT
  222. Close(w_sys_wait)
  223. IF ls_msg2 <> '' THEN
  224. OpenWithParm(w_message_err,ls_msg2)
  225. ELSE
  226. MessageBox('提示','全部终审成功!')
  227. END IF
  228. cb_retrieve.TriggerEvent('clicked')
  229. end event
  230. event ue_c_p_secauditing();//批终撤
  231. Long i
  232. String arg_msg,ls_msg2
  233. String ls_taskcode
  234. IF dw_edit_mode THEN RETURN
  235. IF Not f_power_ind(1000) THEN
  236. MessageBox('提示','你没有使用权限!',information!,ok!)
  237. RETURN
  238. END IF
  239. IF dw_pageretr.Find('ch = 1',1,dw_pageretr.RowCount()) = 0 THEN
  240. MessageBox('系统提示','请先勾选要批终撤的单据!')
  241. RETURN
  242. END IF
  243. IF MessageBox ("询问","是否确定要对已选择的单据批终撤?",Question!,YesNo! ) = 2 THEN RETURN
  244. Close(w_sys_wait)
  245. Open(w_sys_wait)
  246. FOR i = 1 To dw_pageretr.RowCount()
  247. ls_taskcode = ''
  248. arg_msg = ''
  249. ls_taskcode = dw_pageretr.Object.u_cusamt_cusmoncode[i]
  250. IF dw_pageretr.Object.ch[i] = 1 THEN
  251. IF dw_pageretr.Object.u_cusamt_secflag[i] = 0 THEN
  252. arg_msg = ls_taskcode + ',没有终审' +'~r~n'
  253. ls_msg2 = ls_msg2 + arg_msg
  254. CONTINUE
  255. END IF
  256. IF uo_take.c_secauditing(dw_pageretr.Object.u_cusamt_cusmonid[i],arg_msg,True) = 0 THEN
  257. arg_msg = ls_taskcode + ',终撤失败,' +arg_msg +'~r~n'
  258. ls_msg2 = ls_msg2 + arg_msg
  259. END IF
  260. END IF
  261. NEXT
  262. Close(w_sys_wait)
  263. IF ls_msg2 <> '' THEN
  264. OpenWithParm(w_message_err,ls_msg2)
  265. ELSE
  266. MessageBox('提示','全部终撤成功!')
  267. END IF
  268. cb_retrieve.TriggerEvent('clicked')
  269. end event
  270. event ue_p_confirm();//批确认
  271. Long i
  272. String arg_msg,ls_msg2
  273. String ls_taskcode
  274. IF dw_edit_mode THEN RETURN
  275. IF Not f_power_ind(926) THEN
  276. MessageBox('提示','你没有使用权限!',information!,ok!)
  277. RETURN
  278. END IF
  279. IF dw_pageretr.Find('ch = 1',1,dw_pageretr.RowCount()) = 0 THEN
  280. MessageBox('系统提示','请先勾选要批确认的单据!')
  281. RETURN
  282. END IF
  283. IF MessageBox ("询问","是否确定要对已选择的单据批确认?",Question!,YesNo! ) = 2 THEN RETURN
  284. Close(w_sys_wait)
  285. Open(w_sys_wait)
  286. FOR i = 1 To dw_pageretr.RowCount()
  287. ls_taskcode = ''
  288. arg_msg = ''
  289. ls_taskcode = dw_pageretr.Object.u_cusamt_cusmoncode[i]
  290. IF dw_pageretr.Object.ch[i] = 1 THEN
  291. IF dw_pageretr.Object.u_cusamt_confirmflag[i] = 1 THEN
  292. arg_msg = ls_taskcode + ',已经确认' +'~r~n'
  293. ls_msg2 = ls_msg2 + arg_msg
  294. CONTINUE
  295. END IF
  296. If dw_pageretr.Object.u_cusamt_secflag[i] = 0 Then
  297. arg_msg = ls_taskcode + ',未终审' +'~r~n'
  298. ls_msg2 = ls_msg2 + arg_msg
  299. CONTINUE
  300. END IF
  301. IF uo_take.confirm(dw_pageretr.Object.u_cusamt_cusmonid[i],publ_operator,arg_msg,True) = 0 THEN
  302. arg_msg = ls_taskcode + ',确认失败,' +arg_msg +'~r~n'
  303. ls_msg2 = ls_msg2 + arg_msg
  304. END IF
  305. END IF
  306. NEXT
  307. Close(w_sys_wait)
  308. IF ls_msg2 <> '' THEN
  309. OpenWithParm(w_message_err,ls_msg2)
  310. ELSE
  311. MessageBox('提示','全部确认成功!')
  312. END IF
  313. cb_retrieve.TriggerEvent('clicked')
  314. end event
  315. event ue_c_p_confirm();//批反确认
  316. Long i
  317. String arg_msg,ls_msg2
  318. String ls_taskcode
  319. IF dw_edit_mode THEN RETURN
  320. IF Not f_power_ind(927) THEN
  321. MessageBox('提示','你没有使用权限!',information!,ok!)
  322. RETURN
  323. END IF
  324. IF dw_pageretr.Find('ch = 1',1,dw_pageretr.RowCount()) = 0 THEN
  325. MessageBox('系统提示','请先勾选要批反确认的单据!')
  326. RETURN
  327. END IF
  328. IF MessageBox ("询问","是否确定要对已选择的单据批反确认?",Question!,YesNo! ) = 2 THEN RETURN
  329. Close(w_sys_wait)
  330. Open(w_sys_wait)
  331. FOR i = 1 To dw_pageretr.RowCount()
  332. ls_taskcode = ''
  333. arg_msg = ''
  334. ls_taskcode = dw_pageretr.Object.u_cusamt_cusmoncode[i]
  335. IF dw_pageretr.Object.ch[i] = 1 THEN
  336. IF dw_pageretr.Object.u_cusamt_confirmflag[i] = 0 THEN
  337. arg_msg = ls_taskcode + ',未确认,' +'~r~n'
  338. ls_msg2 = ls_msg2 + arg_msg
  339. CONTINUE
  340. END IF
  341. IF uo_take.cconfirm(dw_pageretr.Object.u_cusamt_cusmonid[i],publ_operator,arg_msg,True) = 0 THEN
  342. arg_msg = ls_taskcode + ',反确认失败,' +arg_msg +'~r~n'
  343. ls_msg2 = ls_msg2 + arg_msg
  344. END IF
  345. END IF
  346. NEXT
  347. Close(w_sys_wait)
  348. IF ls_msg2 <> '' THEN
  349. OpenWithParm(w_message_err,ls_msg2)
  350. ELSE
  351. MessageBox('提示','全部反确认成功!')
  352. END IF
  353. cb_retrieve.TriggerEvent('clicked')
  354. end event
  355. public function integer wf_refresh_curuc (long arg_billid);IF arg_billid <= 0 OR IsNull(arg_billid) THEN RETURN 0
  356. Long uc_row
  357. uc_row = dw_pageretr.GetRow()
  358. IF uc_row <= 0 THEN RETURN 0
  359. Long scid
  360. String sptcode
  361. Long accountid
  362. DateTime cusdate
  363. Decimal cusamt
  364. String dscrp
  365. Long cusid
  366. String cusmoncode
  367. Int flag
  368. DateTime opdate
  369. String opemp
  370. String Name
  371. String audopemp
  372. DateTime audopdate
  373. Long cusmonid
  374. String cusrep
  375. Long itemid
  376. String itemcode
  377. String itemname
  378. String accountsname
  379. string relcode
  380. long banktypeid
  381. long secflag
  382. string secemp
  383. datetime secdate
  384. long moneyid
  385. long u_accounts_moneyid
  386. decimal mrate
  387. long confirmflag
  388. datetime confirmdate
  389. string confirmemp
  390. datetime viewdate
  391. string bankstr
  392. string idcode
  393. string ls_dscrp
  394. string accountrep
  395. SELECT u_cusamt.scid,
  396. u_spt.sptcode,
  397. u_cusamt.accountid,
  398. u_cusamt.cusdate,
  399. u_cusamt.cusamt,
  400. u_cusamt.dscrp,
  401. u_cusamt.cusid,
  402. u_cusamt.cusmoncode,
  403. u_cusamt.flag,
  404. u_cusamt.opdate,
  405. u_cusamt.opemp,
  406. u_spt.name,
  407. u_cusamt.audopemp,
  408. u_cusamt.audopdate,
  409. u_cusamt.cusmonid,
  410. u_cusamt.cusrep,
  411. u_cusamt.itemid,
  412. u_itemdef.itemcode,
  413. u_itemdef.itemname,
  414. u_accounts.accountsname,
  415. u_cusamt.relcode,
  416. u_cusamt.banktypeid,
  417. u_cusamt.secflag,
  418. u_cusamt.secemp,
  419. u_cusamt.secdate,
  420. u_cusamt.moneyid,
  421. u_accounts.moneyid,
  422. u_cusamt.mrate,
  423. u_cusamt.confirmflag,
  424. u_cusamt.confirmdate,
  425. u_cusamt.confirmemp ,
  426. u_cusamt.viewdate,
  427. u_accounts.bankstr,
  428. u_accounts.idcode,
  429. u_accounts.dscrp,
  430. u_accounts.accountrep
  431. INTO :scid,
  432. :sptcode,
  433. :accountid,
  434. :cusdate,
  435. :cusamt,
  436. :dscrp,
  437. :cusid,
  438. :cusmoncode,
  439. :flag,
  440. :opdate,
  441. :opemp,
  442. :Name,
  443. :audopemp ,
  444. :audopdate,
  445. :cusmonid,
  446. :cusrep,
  447. :itemid,
  448. :itemcode,
  449. :itemname,
  450. :accountsname,
  451. :relcode,
  452. :banktypeid,
  453. :secflag,
  454. :secemp,
  455. :secdate,
  456. :moneyid,
  457. :u_accounts_moneyid,
  458. :mrate,
  459. :confirmflag ,
  460. :confirmdate ,
  461. :confirmemp,
  462. :viewdate,
  463. :bankstr,
  464. :idcode,
  465. :ls_dscrp,
  466. :accountrep
  467. FROM u_cusamt LEFT OUTER JOIN u_itemdef ON u_cusamt.itemid = u_itemdef.itemid LEFT OUTER JOIN u_accounts ON u_cusamt.accountid = u_accounts.accountsid LEFT OUTER JOIN cw_currency ON u_cusamt.moneyid = cw_currency.moneyid,
  468. u_spt
  469. WHERE ( u_cusamt.cusid = u_spt.sptid )
  470. And ( u_cusamt.cusmonid = :arg_billid );
  471. IF sqlca.SQLCode <> 0 THEN
  472. MessageBox('错误',"查询单据操作失败"+sqlca.SQLErrText,stopsign!,ok!)
  473. RETURN 0
  474. END IF
  475. dw_pageretr.SetRedraw(FALSE)
  476. dw_pageretr.Object.u_cusamt_scid[uc_row] = scid
  477. dw_pageretr.Object.u_spt_sptcode[uc_row] = sptcode
  478. dw_pageretr.Object.u_spt_name[uc_row] = Name
  479. dw_pageretr.Object.u_cusamt_accountid[uc_row] = accountid
  480. dw_pageretr.Object.u_cusamt_cusdate[uc_row] = cusdate
  481. dw_pageretr.Object.u_cusamt_cusamt[uc_row] = cusamt
  482. dw_pageretr.Object.u_cusamt_dscrp[uc_row] = dscrp
  483. dw_pageretr.Object.u_cusamt_cusid[uc_row] = cusid
  484. dw_pageretr.Object.u_cusamt_cusmoncode[uc_row] = cusmoncode
  485. dw_pageretr.Object.u_cusamt_flag[uc_row] = flag
  486. dw_pageretr.Object.u_cusamt_opemp[uc_row] = opemp
  487. dw_pageretr.Object.u_cusamt_opdate[uc_row] = opdate
  488. dw_pageretr.Object.u_cusamt_audopemp[uc_row] = audopemp
  489. dw_pageretr.Object.u_cusamt_audopemp[uc_row] = audopemp
  490. dw_pageretr.Object.u_cusamt_audopdate[uc_row] = audopdate
  491. dw_pageretr.Object.u_cusamt_cusrep[uc_row] = cusrep
  492. dw_pageretr.Object.u_itemdef_itemcode[uc_row] = itemcode
  493. dw_pageretr.Object.u_itemdef_itemname[uc_row] = itemname
  494. dw_pageretr.Object.u_cusamt_itemid[uc_row] = itemid
  495. dw_pageretr.Object.u_accounts_accountsname[uc_row] = accountsname
  496. dw_pageretr.Object.u_cusamt_cusmonid[uc_row] = arg_billid
  497. dw_pageretr.Object.u_cusamt_relcode[uc_row] = relcode
  498. dw_pageretr.Object.u_cusamt_banktypeid[uc_row] = banktypeid
  499. dw_pageretr.Object.u_cusamt_secflag[uc_row] = secflag
  500. dw_pageretr.Object.u_cusamt_secemp[uc_row] = secemp
  501. dw_pageretr.Object.u_cusamt_secdate[uc_row] = secdate
  502. dw_pageretr.Object.u_cusamt_moneyid[uc_row] = moneyid
  503. dw_pageretr.Object.u_cusamt_mrate[uc_row] = mrate
  504. dw_pageretr.Object.u_accounts_moneyid[uc_row] = u_accounts_moneyid
  505. dw_pageretr.Object.u_cusamt_confirmflag[uc_row] = confirmflag
  506. dw_pageretr.Object.u_cusamt_confirmdate[uc_row] = confirmdate
  507. dw_pageretr.Object.u_cusamt_confirmemp[uc_row] = confirmemp
  508. dw_pageretr.Object.u_cusamt_viewdate[uc_row] =viewdate
  509. dw_pageretr.Object.u_accounts_bankstr[uc_row] = bankstr
  510. dw_pageretr.Object.u_accounts_idcode[uc_row] = idcode
  511. dw_pageretr.Object.u_accounts_dscrp[uc_row] = ls_dscrp
  512. dw_pageretr.Object.u_accounts_accountrep[uc_row] = accountrep
  513. dw_pageretr.SetRedraw(TRUE)
  514. dw_uc.Reset()
  515. dw_pageretr.RowsCopy(dw_pageretr.GetRow(), dw_pageretr.GetRow(), Primary!, dw_uc, 1, Primary!)
  516. wf_flagstatus_rf()
  517. RETURN 1
  518. end function
  519. public function integer wf_flagstatus_rf ();
  520. Long pagerert_row
  521. long li_confirmflag
  522. long li_flag
  523. long li_secflag
  524. pagerert_row = dw_pageretr.GetRow()
  525. IF pagerert_row <= 0 THEN
  526. cb_auditing.Text = '审核&F'
  527. cb_auditing.Enabled = FALSE
  528. cb_auditing_cancel.Text = '撤审'
  529. cb_auditing_cancel.Enabled = FALSE
  530. // cur_flag = -1
  531. // cur_secflag = -1
  532. GOTO ext
  533. END IF
  534. li_flag = dw_pageretr.Object.u_cusamt_flag[pagerert_row]
  535. li_secflag = dw_pageretr.Object.u_cusamt_secflag[pagerert_row]
  536. li_confirmflag = dw_pageretr.Object.u_cusamt_confirmflag[pagerert_row]
  537. IF dw_edit_mode THEN
  538. cb_auditing.Text = '初审&F'
  539. cb_auditing.Enabled = FALSE
  540. cb_auditing_cancel.Enabled = FALSE
  541. cb_confirm.Enabled = FALSE
  542. cb_cconfirm.Enabled = FALSE
  543. ELSE
  544. IF li_flag = 0 THEN
  545. cb_auditing.Enabled = TRUE
  546. cb_auditing.Text = '初审&F'
  547. cb_auditing_cancel.Enabled = FALSE
  548. cb_confirm.Enabled = FALSE
  549. cb_cconfirm.Enabled = FALSE
  550. ELSEIF li_flag = 1 AND li_secflag = 0 AND li_confirmflag = 0 THEN
  551. cb_auditing.Enabled = TRUE
  552. cb_auditing.Text = '终审&F'
  553. cb_auditing_cancel.Enabled = TRUE
  554. cb_auditing_cancel.Text = '初撤'
  555. cb_confirm.Enabled = FALSE
  556. cb_cconfirm.Enabled = FALSE
  557. ELSEIF li_flag = 1 AND li_secflag = 1 AND li_confirmflag = 0 THEN
  558. cb_auditing.Text = '初审&F'
  559. cb_auditing.Enabled = FALSE
  560. cb_auditing_cancel.Enabled = TRUE
  561. cb_auditing_cancel.Text = '终撤'
  562. cb_confirm.Enabled = TRUE
  563. cb_cconfirm.Enabled = FALSE
  564. ELSEIF li_flag = 1 AND li_flag = 1 AND li_confirmflag = 1 THEN
  565. cb_auditing.Enabled = FALSE
  566. cb_auditing_cancel.Enabled = FALSE
  567. cb_confirm.Enabled = FALSE
  568. cb_cconfirm.Enabled = TRUE
  569. END IF
  570. END IF
  571. cb_auditing.TriggerEvent('ue_textchange')
  572. cb_auditing_cancel.TriggerEvent('ue_textchange')
  573. ext:
  574. RETURN 0
  575. end function
  576. on w_sptamt_edit.create
  577. int iCurrent
  578. call super::create
  579. this.ddlb_status=create ddlb_status
  580. this.ddlb_scid=create ddlb_scid
  581. this.st_3=create st_3
  582. this.st_2=create st_2
  583. this.cb_2=create cb_2
  584. this.cb_confirm=create cb_confirm
  585. this.cb_cconfirm=create cb_cconfirm
  586. this.cbx_1=create cbx_1
  587. iCurrent=UpperBound(this.Control)
  588. this.Control[iCurrent+1]=this.ddlb_status
  589. this.Control[iCurrent+2]=this.ddlb_scid
  590. this.Control[iCurrent+3]=this.st_3
  591. this.Control[iCurrent+4]=this.st_2
  592. this.Control[iCurrent+5]=this.cb_2
  593. this.Control[iCurrent+6]=this.cb_confirm
  594. this.Control[iCurrent+7]=this.cb_cconfirm
  595. this.Control[iCurrent+8]=this.cbx_1
  596. end on
  597. on w_sptamt_edit.destroy
  598. call super::destroy
  599. destroy(this.ddlb_status)
  600. destroy(this.ddlb_scid)
  601. destroy(this.st_3)
  602. destroy(this.st_2)
  603. destroy(this.cb_2)
  604. destroy(this.cb_confirm)
  605. destroy(this.cb_cconfirm)
  606. destroy(this.cbx_1)
  607. end on
  608. event ue_usual_query_retr;call super::ue_usual_query_retr;String ls_querystrpart = ''
  609. ls_newselect = Lower(ori_oldselect)
  610. IF Trim(sle_usual_query.Text) <> '' THEN
  611. IF Pos(Trim(sle_usual_query.Text),'%') = 0 THEN
  612. ls_querystrpart = "(u_cusamt.cusmoncode like '%"+Trim(sle_usual_query.Text)+"%')"
  613. ELSE
  614. ls_querystrpart = "(u_cusamt.cusmoncode like '"+Trim(sle_usual_query.Text)+"')"
  615. END IF
  616. IF Pos(ls_newselect," where ") <> 0 THEN
  617. ls_newselect = ls_newselect+" and ("+ls_querystrpart+')'
  618. ELSE
  619. ls_newselect = ls_newselect+" where ("+ls_querystrpart+')'
  620. END IF
  621. END IF
  622. wf_retrieveuc(dw_pageretr,ls_newselect,1)
  623. THIS.TriggerEvent('retrieve_pageretr')
  624. end event
  625. event ue_usual_query_filt;call super::ue_usual_query_filt;string obj_expr=''
  626. if trim(sle_usual_query.text)<>'' then
  627. if pos(trim(sle_usual_query.text),'%')=0 then
  628. obj_expr=obj_expr+'( u_cusamt_cusmoncode like "%'+trim(sle_usual_query.text)+'%" )'
  629. else
  630. obj_expr=obj_expr+'( u_cusamt_cusmoncode like "'+trim(sle_usual_query.text)+'" )'
  631. end if
  632. end if
  633. dw_pageretr.setfilter(obj_expr)
  634. dw_pageretr.SetRedraw(False)
  635. dw_pageretr.Filter()
  636. IF dw_pageretr.RowCount() >= 1 THEN
  637. dw_pageretr.SelectRow(0,False)
  638. dw_pageretr.SetRow(1)
  639. dw_pageretr.SelectRow(1,True)
  640. END IF
  641. dw_pageretr.TriggerEvent(RowFocusChanged!)
  642. dw_pageretr.SetRedraw(True)
  643. end event
  644. event close;call super::close;destroy uo_take
  645. end event
  646. event open;call super::open;uc_column_int = 13 //uc dw前6列可以编辑
  647. uo_take = CREATE uo_cusamt
  648. IF s_tran.d_long = 1 THEN
  649. cur_scid = s_tran.c_long
  650. Int li_item
  651. li_item = ddlb_scid.FindItem(s_tran.d_string,0)
  652. IF li_item > 0 THEN
  653. ddlb_scid.SelectItem(li_item)
  654. END IF
  655. String arg_msg
  656. cb_add.TriggerEvent(Clicked!)
  657. IF dw_uc.GetRow() > 0 THEN
  658. IF s_tran.e_long > 0 THEN
  659. String ls_sptcode,ls_sptname
  660. SELECT sptcode,name
  661. INTO :ls_sptcode,:ls_sptname
  662. FROM u_spt
  663. Where sptid = :s_tran.e_long;
  664. IF sqlca.SQLCode = 0 THEN
  665. dw_uc.Object.cusid[dw_uc.GetRow()] = s_tran.e_long
  666. dw_uc.Object.u_spt_name[dw_uc.GetRow()] = ls_sptname
  667. dw_uc.Object.u_spt_sptcode[dw_uc.GetRow()] = ls_sptcode
  668. END IF
  669. END IF
  670. END IF
  671. END IF
  672. end event
  673. event refresh_interface;call super::refresh_interface;ddlb_status.enabled=not dw_edit_mode
  674. ddlb_scid.enabled=not dw_edit_mode
  675. cb_auditing_cancel.enabled=not dw_edit_mode
  676. end event
  677. event retrieve_pageretr;Boolean cb_nextpage_enabled,cb_retrieveall_enabled
  678. Boolean cb_func_enabled,cb_retrieve_enabled
  679. cb_nextpage_enabled = cb_nextpage.Enabled
  680. cb_retrieveall_enabled = cb_retrieveall.Enabled
  681. cb_func_enabled = cb_func.Enabled
  682. cb_nextpage.Enabled = FALSE
  683. cb_retrieveall.Enabled = FALSE
  684. cb_func.Enabled = FALSE
  685. datawindowchild childdw
  686. dw_uc.SetTransObject (sqlca)
  687. dw_uc.GetChild("accountid",childdw)
  688. childdw.SetTransObject (sqlca)
  689. IF childdw.Retrieve(sys_user_account) = 0 THEN
  690. childdw.InsertRow(0)
  691. END IF
  692. dw_uc.Retrieve()
  693. dw_pageretr.Retrieve(cur_scid,cur_flag,cur_secflag,cur_confirmflag )
  694. IF dw_pageretr.RowCount() > 0 THEN
  695. dw_pageretr.SetRow(1)
  696. dw_pageretr.triggerevent(rowfocuschanged!)
  697. end if
  698. wf_flagstatus_rf()
  699. THIS.TriggerEvent('retrieve_childdw')
  700. cb_nextpage.Enabled = cb_nextpage_enabled
  701. cb_retrieveall.Enabled = cb_retrieveall_enabled
  702. cb_func.Enabled = cb_func_enabled
  703. end event
  704. event ue_f9;call super::ue_f9;//用于选择明细内容,被F9[默认]
  705. IF NOT dw_edit_mode THEN RETURN
  706. Long uc_row
  707. uc_row = dw_uc.GetRow()
  708. IF uc_row = 0 THEN
  709. MessageBox('提示','请选定进仓单!',information!,ok!)
  710. RETURN
  711. END IF
  712. dw_uc.AcceptText()
  713. IF NOT IsValid(w_spt_edit) THEN
  714. s_edit_index_tran s_ch_tran //传递参数使用
  715. s_ch_tran.if_retrieve_all = FALSE //是否一次RETRIEVE所有行
  716. s_ch_tran.work_mode = 1 //0-单纯编辑模式 1-选择\编辑模式
  717. s_ch_tran.arg_pkid = 0 //目标定位PKID (备用)
  718. //查询列(物料编码)部分内容,用于初步筛选
  719. dw_uc.AcceptText()
  720. s_ch_tran.arg_string_code = Upper(Trim(dw_uc.Object.u_spt_sptcode[dw_uc.GetRow()]))
  721. OpenWithParm(w_spt_edit,s_ch_tran) //调用
  722. s_spt S_INSCUST
  723. S_INSCUST = Message.PowerObjectParm //接受返回结构
  724. IF S_INSCUST.sptid > 0 THEN //正常返回值则可以取以下值
  725. dw_uc.SetRedraw(FALSE)
  726. dw_uc.Object.cusid[uc_row] = S_INSCUST.sptid
  727. dw_uc.Object.u_spt_sptcode[uc_row] = S_INSCUST.sptcode
  728. dw_uc.Object.u_spt_name[uc_row] = S_INSCUST.Name
  729. //dw_uc.Object.u_cusamt_banktypeid[uc_row] = S_INSCUST.dftbanktypeid
  730. dw_uc.Object.u_cusamt_moneyid[uc_row] = S_INSCUST.dftmoneyid
  731. dw_uc.Object.u_cusamt_mrate[uc_row] = f_get_mrate(S_INSCUST.dftmoneyid)
  732. dw_uc.SetRedraw(TRUE)
  733. dw_uc.SetColumn("accountid")
  734. END IF
  735. END IF
  736. end event
  737. event ue_viewprint;call super::ue_viewprint;
  738. IF Not f_power_ind(934) THEN
  739. MessageBox('提示','你没有使用权限!',information!,OK!)
  740. RETURN
  741. END IF
  742. Long LS_ROW
  743. LS_ROW = dw_pageretr.GetRow()
  744. IF LS_ROW <= 0 THEN
  745. MessageBox('提示','没有打印目标单据!',information!,OK!)
  746. RETURN
  747. END IF
  748. S_print_MSG LS_PRMSG
  749. IF ls_newname <> '' THEN
  750. IF li_auditprint = 1 THEN
  751. IF dw_pageretr.Object.u_cusamt_flag[dw_pageretr.GetRow()] = 0 THEN
  752. MessageBox('提示','目标单据还未审核,不能打印!',information!,OK!)
  753. RETURN
  754. END IF
  755. END IF
  756. LS_PRMSG.obj_dwNAME = ls_newname
  757. ELSE
  758. IF Not f_power_ind(934) THEN
  759. MessageBox('提示','你没有使用权限!',information!,OK!)
  760. RETURN
  761. END IF
  762. LS_PRMSG.obj_dwNAME = 'dw_rp_sptamt_print'
  763. END IF
  764. IF LS_PRMSG.obj_dwNAME = '' THEN RETURN
  765. LS_PRMSG.printrow = ll_prownum
  766. LS_PRMSG.TAG_TEXT = '付款单'
  767. LS_PRMSG.FILTER_STRING = ''
  768. LS_PRMSG.retr_pram_falg = 15
  769. LS_PRMSG.PAGECH_FLAG = 0
  770. LS_PRMSG.retr_scid = dw_pageretr.Object.u_cusamt_scid[LS_ROW]
  771. LS_PRMSG.retr_pramnmb = dw_pageretr.Object.u_cusamt_cusmonid[LS_ROW]
  772. LS_PRMSG.rowcnt = dw_child.RowCount()
  773. OpenWithParm(w_publ_preview,LS_PRMSG)
  774. //**更新打印次料
  775. String arg_msg
  776. printnum = Message.DoubleParm
  777. Long ll_scid
  778. ll_scid = dw_pageretr.Object.u_cusamt_scid[dw_pageretr.GetRow()]
  779. f_update_printnum('u_cusamt',printnum,ll_scid,dw_pageretr.Object.u_cusamt_cusmonid[LS_ROW],'','',arg_msg,True)
  780. String ls_taskcode
  781. ls_taskcode = dw_pageretr.Object.u_cusamt_cusmoncode[dw_pageretr.GetRow()]
  782. IF f_billevent_trigger (540, 1, ls_taskcode, arg_msg) = 0 THEN
  783. MessageBox('Error',arg_msg)
  784. END IF
  785. end event
  786. event ue_print;call super::ue_print;//--直接打印
  787. IF NOT f_power_ind(934) THEN
  788. MessageBox('提示','你没有使用权限!',information!,OK!)
  789. RETURN
  790. END IF
  791. uo_print_preview uo_print
  792. IF MessageBox ("询问","是否确定要打印当前单据吗?",Question!,YesNo! ) = 2 THEN RETURN
  793. S_print_MSG LS_PRMSG
  794. Long LS_ROW
  795. LS_ROW = dw_pageretr.GetRow()
  796. IF LS_ROW <= 0 THEN
  797. MessageBox('提示','没有打印目标单据!',information!,ok!)
  798. RETURN
  799. END IF
  800. IF ls_newname <> '' THEN
  801. IF li_auditprint = 1 THEN
  802. IF dw_pageretr.Object.u_cusamt_flag[dw_pageretr.GetRow()] = 0 THEN
  803. MessageBox('提示','目标单据还未审核,不能打印!',information!,ok!)
  804. RETURN
  805. END IF
  806. END IF
  807. LS_PRMSG.obj_dwNAME = ls_newname
  808. ELSE
  809. IF NOT f_power_ind(934) THEN
  810. MessageBox('提示','你没有使用权限!',information!,ok!)
  811. RETURN
  812. END IF
  813. LS_PRMSG.obj_dwNAME = 'dw_rp_sptamt_print'
  814. END IF
  815. if LS_PRMSG.obj_dwNAME = '' then return
  816. LS_PRMSG.retr_pram_falg = 2
  817. LS_PRMSG.printrow = ll_prownum
  818. LS_PRMSG.TAG_TEXT = '收款单'
  819. LS_PRMSG.FILTER_STRING = ''
  820. LS_PRMSG.PAGECH_FLAG = 0
  821. LS_PRMSG.retr_pramnmb = dw_pageretr.Object.u_cusamt_cusmonid[LS_ROW]
  822. LS_PRMSG.rowcnt = dw_child.RowCount()
  823. uo_print.FACT_PRINT_MSG = LS_PRMSG
  824. String arg_msg
  825. IF uo_print.uof_print_begin(arg_msg) = 0 THEN
  826. MessageBox("错误",arg_msg,stopsign!,ok!)
  827. RETURN
  828. END IF
  829. uo_print.ds_print()
  830. //**更新打印次料
  831. printnum = 1
  832. Long ll_scid
  833. ll_scid = dw_pageretr.Object.u_cusamt_scid[dw_pageretr.GetRow()]
  834. f_update_printnum('u_cusamt',printnum,ll_scid,dw_pageretr.Object.u_cusamt_cusmonid[LS_ROW],'','',arg_msg,TRUE)
  835. String ls_taskcode
  836. ls_taskcode = dw_pageretr.Object.u_cusamt_cusmoncode[dw_pageretr.GetRow()]
  837. IF f_billevent_trigger (540, 1, ls_taskcode, arg_msg) = 0 THEN
  838. MessageBox('Error',arg_msg)
  839. END IF
  840. end event
  841. event ue_f7;call super::ue_f7;//用于选择明细内容,被F9[默认]
  842. IF NOT dw_edit_mode THEN RETURN
  843. Long uc_row
  844. String ls_itemcode
  845. uc_row = dw_uc.GetRow()
  846. ls_itemcode = Trim(dw_uc.Object.u_itemdef_itemcode[uc_row])
  847. IF uc_row = 0 THEN
  848. MessageBox('提示','请选定单据!',information!,ok!)
  849. RETURN
  850. END IF
  851. dw_uc.AcceptText()
  852. IF NOT IsValid(w_itemdef_response) THEN
  853. s_edit_index_tran s_ch_tran //传递参数使用
  854. s_ch_tran.if_retrieve_all = local_retrieve_all //是否一次retrieve所有行
  855. s_ch_tran.work_mode = 1 //0-单纯编辑模式 1-选择\编辑模式
  856. s_ch_tran.arg_pkid = 0 //目标定位pkid (备用)
  857. s_ch_tran.arg_string_code = ls_itemcode //查询列(物料编码)部分内容,用于初步筛选
  858. OpenWithParm(w_itemdef_response,s_ch_tran) //调用
  859. s_itemdef s_inscust
  860. s_inscust = Message.PowerObjectParm //接受返回结构
  861. IF s_inscust.itemid > 0 THEN //正常返回值则可以取以下值
  862. dw_uc.SetRedraw(FALSE)
  863. dw_uc.Object.u_cusamt_itemid[uc_row] = s_inscust.itemid
  864. dw_uc.Object.u_itemdef_itemcode[uc_row] = s_inscust.itemcode
  865. dw_uc.Object.u_itemdef_itemname[uc_row] = s_inscust.itemname
  866. dw_uc.SetColumn("dscrp")
  867. dw_uc.SetRedraw(TRUE)
  868. END IF
  869. END IF
  870. end event
  871. event ue_rpt_viewprint;call super::ue_rpt_viewprint;
  872. Long row,uc_relid,ll_scid
  873. row = dw_pageretr.GetRow()
  874. IF row = 0 THEN RETURN
  875. IF ls_rpname = '' THEN RETURN
  876. IF li_auditprint = 1 THEN
  877. IF dw_pageretr.Object.u_cusamt_flag[row] = 0 THEN
  878. MessageBox('提示','目标单据还未审核,不能打印!',information!,ok!)
  879. RETURN
  880. END IF
  881. END IF
  882. s_rpt_print_msg s_print
  883. s_print.retr_pram_falg = 2
  884. s_print.rpid = ls_msgprintid_rpt
  885. s_print.retr_flag = TRUE
  886. s_print.tag_text = THIS.Title
  887. s_print.rpname = ls_rpname
  888. s_print.retr_pramnmb = dw_pageretr.Object.u_cusamt_cusmonid[row]
  889. s_print.rowcnt = dw_child.RowCount()
  890. OpenWithParm(w_rpt_preview,s_print)
  891. //**更新打印次料
  892. String arg_msg
  893. printnum = Message.DoubleParm
  894. String ls_code
  895. ll_scid = 0
  896. ls_code = dw_pageretr.Object.u_cusamt_cusmoncode[row]
  897. f_update_printnum('u_cusamt',printnum,ll_scid,dw_pageretr.Object.u_cusamt_cusmonid[ ROW],'','',arg_msg,TRUE)
  898. //f_update_printnum(ll_scid,ls_code,TRUE,printnum,arg_msg,TRUE)
  899. end event
  900. event ue_rpt_print;call super::ue_rpt_print;Long row,uc_relid,ll_scid
  901. row = dw_pageretr.GetRow()
  902. IF row = 0 THEN RETURN
  903. uo_rpt_print_preview uo_print
  904. S_rpt_print_MSG LS_PRMSG
  905. IF dw_pageretr.RowCount() = 0 THEN
  906. MessageBox('提示','没有可打印的单据!',information!,ok!)
  907. RETURN
  908. END IF
  909. IF ls_rpname = '' THEN RETURN
  910. IF li_auditprint = 1 THEN
  911. IF dw_pageretr.Object.u_cusamt_flag[row] = 0 THEN
  912. MessageBox('提示','目标单据还未审核,不能打印!',information!,ok!)
  913. RETURN
  914. END IF
  915. END IF
  916. IF MessageBox ("询问","是否确定要打印当前单据吗?",Question!,YesNo! ) = 2 THEN RETURN
  917. LS_PRMSG.retr_pram_falg = 2
  918. LS_PRMSG.TAG_TEXT = THIS.Title
  919. LS_PRMSG.rpname = ls_rpname
  920. LS_PRMSG.FILTER_STRING = ''
  921. LS_PRMSG.PAGECH_FLAG = 0
  922. LS_PRMSG.rpid = ls_msgprintid_rpt
  923. LS_PRMSG.retr_pramnmb = dw_pageretr.Object.u_cusamt_cusmonid[row]
  924. LS_PRMSG.rowcnt = dw_child.RowCount()
  925. uo_print.FACT_PRINT_MSG = LS_PRMSG
  926. String arg_msg
  927. IF uo_print.uof_print_begin(arg_msg) = 0 THEN
  928. MessageBox("错误",arg_msg,stopsign!,ok!)
  929. RETURN
  930. END IF
  931. uo_print.ds_print()
  932. //**更新打印次料
  933. printnum = Message.DoubleParm
  934. String ls_code
  935. ll_scid = 0
  936. ls_code = dw_pageretr.Object.u_cusamt_cusmoncode[row]
  937. f_update_printnum('u_cusamt',printnum,ll_scid,dw_pageretr.Object.u_cusamt_cusmonid[ ROW],'','',arg_msg,TRUE)
  938. //f_update_printnum(ll_scid,ls_code,TRUE,printnum,arg_msg,TRUE)
  939. end event
  940. event ue_addzy;call super::ue_addzy;IF NOT f_power_ind(935) THEN
  941. MessageBox('提示','你没有使用权限!',information!,ok!)
  942. RETURN
  943. END IF
  944. IF dw_edit_mode THEN RETURN
  945. String arg_msg = '',LS_STR
  946. Long uc_row
  947. s_inputbox S_SREU
  948. uc_row = dw_pageretr.GetRow()
  949. IF uc_row <= 0 THEN
  950. MessageBox('提示','请选定当前目标单据!',information!,ok!)
  951. RETURN
  952. END IF
  953. S_SREU.Title = '请输入要补充到备注的内容'
  954. S_SREU.OLD_TEXT = ''
  955. OpenWithParm(w_inputbox,S_SREU)
  956. LS_STR = Message.StringParm
  957. IF Trim(LS_STR) = '' OR IsNull(LS_STR) THEN RETURN
  958. IF uo_take.add_dscrp(dw_pageretr.Object.u_cusamt_cusmonid[uc_row],LS_STR,arg_msg,TRUE) = 0 THEN
  959. MessageBox('错误',arg_msg,stopsign!,ok!)
  960. RETURN
  961. ELSE
  962. MessageBox('提示','添加备注操作成功!',information!,ok!)
  963. wf_refresh_curuc(dw_pageretr.Object.u_cusamt_cusmonid[uc_row])
  964. END IF
  965. end event
  966. event retrieve_childdw;call super::retrieve_childdw;Long row,uc_relid
  967. row = dw_pageretr.GetRow()
  968. IF row > 0 THEN
  969. uc_relid = dw_pageretr.Object.u_cusamt_refrapid[row]
  970. dw_child.SetRedraw (FALSE)
  971. dw_child.Retrieve(uc_relid)
  972. dw_child.SetRedraw (TRUE)
  973. ELSE
  974. dw_child.Reset()
  975. END IF
  976. end event
  977. event resize;ln_bar.EndX = THIS.Width
  978. ln_bar2.EndX = THIS.Width
  979. ln_1.EndX = THIS.Width
  980. ln_2.EndX = THIS.Width
  981. r_bar.Width = THIS.Width
  982. Long w_width,w_height
  983. w_width = 3600
  984. w_height = 2300
  985. IF newwidth < w_width THEN THIS.Width = w_width
  986. IF newheight < w_height THEN THIS.Height = w_height
  987. dw_pageretr.Width = THIS.Width - (w_width - dw_pageretr_w)
  988. dw_pageretr.Height = THIS.Height - (w_height - dw_pageretr_h)
  989. dw_child.Height = THIS.Height - (w_height - dw_child_h)
  990. this.triggerevent('resize_p')
  991. end event
  992. event ue_f10;call super::ue_f10;//用于选择明细内容,被F10[默认]
  993. If Not dw_edit_mode Then Return
  994. Long uc_row
  995. Long ll_rst_accountsid,ll_accountid,ll_moneyid,ll_moneyid_account
  996. uc_row = dw_uc.GetRow()
  997. If uc_row = 0 Then
  998. MessageBox('系统提示','请选定单据!')
  999. Return
  1000. End If
  1001. dw_uc.AcceptText()
  1002. If Not IsValid(w_accounts_ch) Then
  1003. s_edit_index_tran s_ch_tran //传递参数使用
  1004. s_ch_tran.if_retrieve_all = True //是否一次retrieve所有行
  1005. s_ch_tran.work_mode = 1 //0-单纯编辑模式 1-选择\编辑模式
  1006. s_ch_tran.arg_pkid = 0 //目标定位pkid (备用)
  1007. s_ch_tran.arg_string_code = '' //查询列(物料编码)部分内容,用于初步筛选
  1008. OpenWithParm(w_accounts_ch,s_ch_tran) //调用
  1009. ll_rst_accountsid = Message.DoubleParm //接受返回结构
  1010. If ll_rst_accountsid > 0 Then //正常返回值则可以取以下值
  1011. dw_uc.SetRedraw(False)
  1012. ll_moneyid = dw_uc.Object.u_cusamt_moneyid[uc_row]
  1013. dw_uc.Object.accountid[uc_row] = ll_rst_accountsid
  1014. Select moneyid Into :ll_moneyid_account
  1015. From u_accounts
  1016. Where accountsid = :ll_rst_accountsid;
  1017. If sqlca.SQLCode <> 0 Then
  1018. ll_moneyid_account = 0
  1019. Return
  1020. End If
  1021. dw_uc.Object.u_accounts_moneyid[uc_row] = ll_moneyid_account
  1022. If ll_moneyid = ll_moneyid_account Then
  1023. dw_uc.Object.u_cusamt_mrate[uc_row] = 1
  1024. Else
  1025. dw_uc.Object.u_cusamt_mrate[dw_uc.GetRow()] = f_get_mrate(ll_moneyid)
  1026. End If
  1027. dw_uc.SetColumn("accountid")
  1028. dw_uc.SetRedraw(True)
  1029. End If
  1030. End If
  1031. end event
  1032. type cb_func from w_publ_1ton_share_detail`cb_func within w_sptamt_edit
  1033. end type
  1034. type cb_exit from w_publ_1ton_share_detail`cb_exit within w_sptamt_edit
  1035. integer x = 2661
  1036. end type
  1037. type sle_usual_query from w_publ_1ton_share_detail`sle_usual_query within w_sptamt_edit
  1038. integer width = 549
  1039. end type
  1040. type cb_retrieveall from w_publ_1ton_share_detail`cb_retrieveall within w_sptamt_edit
  1041. integer x = 3113
  1042. integer width = 142
  1043. end type
  1044. type em_pagerowno from w_publ_1ton_share_detail`em_pagerowno within w_sptamt_edit
  1045. integer x = 2811
  1046. end type
  1047. type dw_pageretr from w_publ_1ton_share_detail`dw_pageretr within w_sptamt_edit
  1048. event dwnkey pbm_dwnkey
  1049. integer x = 1851
  1050. integer width = 1742
  1051. integer height = 1876
  1052. string dataobject = "dw_sptamt_index"
  1053. boolean rbutton_filter_use = true
  1054. boolean titleclick_sort_use = true
  1055. end type
  1056. event dw_pageretr::dwnkey;call super::dwnkey;//int i = 0
  1057. end event
  1058. event dw_pageretr::rowfocuschanged;call super::rowfocuschanged;wf_flagstatus_rf()
  1059. end event
  1060. type st_1 from w_publ_1ton_share_detail`st_1 within w_sptamt_edit
  1061. integer x = 18
  1062. end type
  1063. type cb_nextpage from w_publ_1ton_share_detail`cb_nextpage within w_sptamt_edit
  1064. integer x = 3255
  1065. end type
  1066. type dw_uc from w_publ_1ton_share_detail`dw_uc within w_sptamt_edit
  1067. integer width = 1842
  1068. integer height = 1560
  1069. string dataobject = "dw_sptamt_edit"
  1070. end type
  1071. event dw_uc::dwnkey;Parent.TriggerEvent('user_key')
  1072. IF Key = KeyDownArrow! THEN RETURN 1
  1073. IF dw_edit_mode THEN
  1074. IF dw_uc.GetColumnName ( ) = 'u_spt_sptcode' And Key = KeyEnter! THEN
  1075. String ls_code,ls_name
  1076. Long ls_sptid
  1077. dw_uc.AcceptText()
  1078. ls_code = Upper(Trim(dw_uc.Object.u_spt_sptcode[dw_uc.GetRow()]))
  1079. SELECT sptid,
  1080. name
  1081. INTO :ls_sptid,:ls_name
  1082. FROM u_spt
  1083. Where charindex(:ls_code,sptcode)>0 or charindex(:ls_code,name)>0;
  1084. IF sqlca.SQLCode <> 0 THEN
  1085. Parent.TriggerEvent('ue_f9')
  1086. RETURN 1
  1087. ELSE
  1088. dw_uc.SetRedraw(False)
  1089. dw_uc.Object.cusid[dw_uc.GetRow()] = ls_sptid
  1090. dw_uc.Object.u_spt_name[dw_uc.GetRow()] = ls_name
  1091. dw_uc.SetRedraw(True)
  1092. dw_uc.SetColumn("accountid")
  1093. RETURN 1
  1094. END IF
  1095. ELSEIF dw_uc.GetColumnName ( ) = 'u_itemdef_itemcode' And Key = KeyEnter! THEN
  1096. String ls_itemcode,ls_itemname
  1097. Long ls_itemid
  1098. dw_uc.AcceptText()
  1099. ls_itemcode = Upper(Trim(dw_uc.Object.u_itemdef_itemcode[dw_uc.GetRow()]))
  1100. SELECT
  1101. u_itemdef.itemid,
  1102. u_itemdef.itemname
  1103. Into
  1104. :ls_itemid,
  1105. :ls_itemname
  1106. From u_itemdef
  1107. Where ( u_itemdef.itemcode = :ls_itemcode );
  1108. IF sqlca.SQLCode <> 0 THEN
  1109. Parent.TriggerEvent('ue_f7')
  1110. RETURN 1
  1111. ELSE
  1112. dw_uc.SetRedraw(False)
  1113. dw_uc.Object.u_cusamt_itemid[dw_uc.GetRow()] = ls_itemid
  1114. dw_uc.Object.u_itemdef_itemname[dw_uc.GetRow()] = ls_itemname
  1115. dw_uc.SetRedraw(True)
  1116. dw_uc.SetColumn("dscrp")
  1117. RETURN 1
  1118. END IF
  1119. ELSE
  1120. IF Key = KeyEnter! And dw_uc.GetColumnName ( ) <> 'dscrp' THEN //
  1121. keybd_event ( 9, 0, 0 , 0 ) // 按下tab
  1122. keybd_event ( 9, 0, 2, 0 ) // 释放tab
  1123. RETURN 1
  1124. END IF
  1125. END IF
  1126. END IF
  1127. end event
  1128. event dw_uc::doubleclicked;IF dw_edit_mode AND row > 0 THEN
  1129. IF dwo.Name = 'u_itemdef_itemcode' or dwo.Name = 'u_itemdef_itemname' THEN
  1130. PARENT.TriggerEvent('ue_f7')
  1131. ELSEIF dwo.Name = 'accountid' THEN
  1132. PARENT.TriggerEvent('ue_f10')
  1133. ELSE
  1134. PARENT.TriggerEvent('ue_f9')
  1135. END IF
  1136. END IF
  1137. end event
  1138. event dw_uc::itemchanged;call super::itemchanged;IF NOT dw_edit_mode THEN RETURN
  1139. THIS.AcceptText()
  1140. Long ll_moneyid_account,ll_moneyid
  1141. Long ll_accountid
  1142. IF (dwo.Name = 'u_cusamt_moneyid' OR dwo.Name = 'accountid') and THIS.Object.accountid[row] > 0 THEN
  1143. THIS.SetRedraw(FALSE)
  1144. ll_accountid = THIS.Object.accountid[row]
  1145. ll_moneyid = THIS.Object.u_cusamt_moneyid[row]
  1146. SELECT moneyid INTO :ll_moneyid_account
  1147. FROM u_accounts
  1148. Where accountsid = :ll_accountid;
  1149. IF sqlca.SQLCode <> 0 THEN
  1150. ll_moneyid_account = 0
  1151. RETURN
  1152. END IF
  1153. THIS.Object.u_accounts_moneyid[row] = ll_moneyid_account
  1154. IF ll_moneyid = ll_moneyid_account THEN
  1155. THIS.Object.u_cusamt_mrate[row] = 1
  1156. else
  1157. THIS.object.u_cusamt_mrate[dw_uc.getrow()]=f_get_mrate(ll_moneyid)
  1158. END IF
  1159. THIS.SetRedraw(TRUE)
  1160. END IF
  1161. end event
  1162. type gb_2 from w_publ_1ton_share_detail`gb_2 within w_sptamt_edit
  1163. integer x = 1358
  1164. integer y = 332
  1165. integer width = 311
  1166. integer height = 1104
  1167. end type
  1168. type dw_child from w_publ_1ton_share_detail`dw_child within w_sptamt_edit
  1169. integer y = 1868
  1170. integer width = 1851
  1171. integer height = 300
  1172. string title = "付款对单明细内容"
  1173. string dataobject = "dw_sptamt_mx"
  1174. end type
  1175. type cb_viewprint from w_publ_1ton_share_detail`cb_viewprint within w_sptamt_edit
  1176. integer x = 2016
  1177. end type
  1178. type cb_print from w_publ_1ton_share_detail`cb_print within w_sptamt_edit
  1179. integer x = 1824
  1180. end type
  1181. type cb_add from w_publ_1ton_share_detail`cb_add within w_sptamt_edit
  1182. end type
  1183. event cb_add::clicked;IF NOT f_power_ind(930) THEN
  1184. MessageBox('提示','你没有使用权限!',information!,ok!)
  1185. RETURN
  1186. END IF
  1187. String arg_msg = ''
  1188. Long uc_row
  1189. IF dw_edit_mode THEN
  1190. dw_uc.AcceptText()
  1191. uc_row = dw_uc.GetRow()
  1192. IF uc_row <= 0 THEN
  1193. MessageBox('提示','请选定当前目标单据!',information!,ok!)
  1194. RETURN
  1195. END IF
  1196. IF NOT dw_uc.Object.cusdate[uc_row] > DateTime(2000-01-01,Now()) THEN
  1197. MessageBox('提示','不合理日期',information!,ok!)
  1198. dw_uc.setfocus()
  1199. dw_uc.setcolumn('cusdate')
  1200. RETURN
  1201. END IF
  1202. IF dw_uc.Object.accountid[uc_row] = 0 THEN
  1203. MessageBox('提示','请选择帐号!',information!,ok!)
  1204. dw_uc.setfocus()
  1205. dw_uc.setcolumn('accountid')
  1206. RETURN
  1207. END IF
  1208. IF dw_uc.Object.u_cusamt_banktypeid[uc_row] = 0 THEN
  1209. MessageBox('提示','请选择结算方式!',information!,ok!)
  1210. dw_uc.setfocus()
  1211. dw_uc.setcolumn('u_cusamt_banktypeid')
  1212. RETURN
  1213. END IF
  1214. IF dw_uc.Object.u_cusamt_moneyid[uc_row] = 0 THEN
  1215. MessageBox('提示','请选择应付帐币种!',information!,ok!)
  1216. dw_uc.setfocus()
  1217. dw_uc.setcolumn('u_cusamt_moneyid')
  1218. RETURN
  1219. END IF
  1220. IF trim(dw_uc.Object.u_cusamt_cusrep[uc_row]) = '' THEN
  1221. MessageBox('提示','请输入经手人!',information!,ok!)
  1222. dw_uc.setfocus()
  1223. dw_uc.setcolumn('u_cusamt_cusrep')
  1224. RETURN
  1225. END IF
  1226. IF dw_uc.Object.cusid[uc_row] = 0 THEN
  1227. MessageBox('提示','请选择供应商!',information!,ok!)
  1228. dw_uc.SetFocus()
  1229. dw_uc.SetColumn('u_spt_sptcode')
  1230. RETURN
  1231. END IF
  1232. uo_take.scid = dw_uc.Object.scid[uc_row]
  1233. uo_take.accountid = dw_uc.Object.accountid[uc_row]
  1234. uo_take.cusid = dw_uc.Object.cusid[uc_row]
  1235. uo_take.cusamt = dw_uc.Object.cusamt[uc_row]
  1236. uo_take.dscrp = trim(dw_uc.Object.dscrp[uc_row])
  1237. uo_take.cusdate = dw_uc.Object.cusdate[uc_row]
  1238. uo_take.banktypeid = dw_uc.Object.u_cusamt_banktypeid[uc_row]
  1239. uo_take.itemid = dw_uc.Object.u_cusamt_itemid[uc_row]
  1240. uo_take.cusrep = trim(dw_uc.Object.u_cusamt_cusrep[uc_row])
  1241. uo_take.relcode = trim(dw_uc.Object.u_cusamt_relcode[uc_row])
  1242. uo_take.billtype = 1
  1243. uo_take.moneyid = dw_uc.Object.u_cusamt_moneyid[uc_row]
  1244. uo_take.mrate = dw_uc.Object.u_cusamt_mrate[uc_row]
  1245. uo_take.viewdate = dw_uc.Object.u_cusamt_viewdate[uc_row]
  1246. IF uo_take.Save(arg_msg,TRUE) = 0 THEN
  1247. MessageBox('错误',arg_msg,stopsign!,ok!)
  1248. RETURN
  1249. END IF
  1250. //MessageBox('提示','保存操作成功!',information!,ok!)
  1251. //write ini
  1252. f_SetProfileString (sys_empid,publ_userid+'_'+dw_uc.DataObject, "moneyid",String(dw_uc.Object.u_cusamt_moneyid[dw_uc.GetRow()]))
  1253. f_SetProfileString (sys_empid,dw_uc.DataObject, "dft_banktype",String(dw_uc.Object.u_cusamt_banktypeid[dw_uc.GetRow()]))
  1254. f_SetProfileString (sys_empid,dw_uc.DataObject, "itemid",String(dw_uc.Object.u_cusamt_itemid[dw_uc.GetRow()]))
  1255. long ll_row
  1256. ll_row = dw_pageretr.getrow()
  1257. dw_pageretr.SelectRow(0,FALSE)
  1258. dw_pageretr.SelectRow(ll_row,TRUE)
  1259. wf_refresh_curuc(uo_take.cusmonid)
  1260. String ls_taskcode
  1261. ls_taskcode = dw_pageretr.Object.u_cusamt_cusmoncode[dw_pageretr.GetRow()]
  1262. IF f_billevent_trigger (540, 2, ls_taskcode, arg_msg) = 0 THEN
  1263. MessageBox('Error',arg_msg)
  1264. END IF
  1265. ELSE
  1266. IF uo_take.newbegin(cur_scid,arg_msg) = 0 THEN
  1267. MessageBox('错误',arg_msg,stopsign!,ok!)
  1268. RETURN
  1269. END IF
  1270. END IF
  1271. //IF not dw_edit_mode THEN
  1272. // int li_row
  1273. // li_row = dw_pageretr.InsertRow (1)
  1274. // dw_pageretr.ScrollToRow(li_row)
  1275. // dw_child.RESET()
  1276. // dw_uc.reset()
  1277. // dw_UC.SetFocus()
  1278. // dw_pageretr.Object.u_cusamt_scid[li_row] = cur_scid
  1279. // dw_pageretr.RowsCopy(li_row,li_row, Primary!, dw_uc, 1, Primary!)
  1280. //END IF
  1281. //dw_edit_mode= NOT dw_edit_mode
  1282. //wf_refresh_interface()
  1283. CALL Super::Clicked
  1284. IF dw_edit_mode THEN
  1285. Parent.TriggerEvent("insert_childrow")
  1286. String ls_moneyid,ls_banktype, ls_itemid
  1287. ls_moneyid = f_ProfileString (sys_empid,publ_userid+'_'+dw_uc.DataObject, "moneyid",'0')
  1288. ls_banktype = f_ProfileString (sys_empid,dw_uc.DataObject, "dft_banktype",'0')
  1289. ls_itemid = f_ProfileString (sys_empid,dw_uc.DataObject, "itemid",'0')
  1290. dw_uc.SetRedraw(False)
  1291. dw_uc.Object.u_cusamt_moneyid[dw_uc.GetRow()] = Long(ls_moneyid)
  1292. dw_uc.Object.u_cusamt_mrate[dw_uc.GetRow()] = f_get_mrate(Long(ls_moneyid))
  1293. dw_uc.Object.u_cusamt_banktypeid[dw_uc.GetRow()] = Long(ls_banktype)
  1294. dw_uc.Object.scid[dw_uc.GetRow()] = cur_scid
  1295. dw_uc.Object.u_cusamt_itemid[dw_uc.GetRow()] = Long(ls_itemid)
  1296. dw_uc.Object.u_itemdef_itemcode[dw_uc.GetRow()] = f_get_itemcode(Long(ls_itemid))
  1297. dw_uc.Object.u_itemdef_itemname[dw_uc.GetRow()] = f_get_itemname(Long(ls_itemid))
  1298. dw_uc.Object.u_cusamt_cusrep[dw_uc.GetRow()] = publ_operator
  1299. dw_uc.SetColumn("u_cusamt_relcode")
  1300. dw_uc.SetRedraw(True)
  1301. ELSE
  1302. Parent.TriggerEvent("retrieve_childdw")
  1303. END IF
  1304. end event
  1305. type cb_edit from w_publ_1ton_share_detail`cb_edit within w_sptamt_edit
  1306. end type
  1307. event cb_edit::clicked;IF NOT f_power_ind(930) THEN
  1308. MessageBox('提示','你没有使用权限!',information!,ok!)
  1309. RETURN
  1310. END IF
  1311. String arg_msg = ''
  1312. Long uc_row
  1313. uc_row = dw_pageretr.GetRow()
  1314. IF uc_row <= 0 THEN
  1315. MessageBox('提示','请选定当前目标单据!',information!,ok!)
  1316. RETURN
  1317. END IF
  1318. IF NOT dw_edit_mode THEN
  1319. IF uo_take.updatebegin(cur_scid,dw_pageretr.Object.u_cusamt_cusmonid[uc_row],arg_msg) = 0 THEN
  1320. MessageBox('错误',arg_msg,stopsign!,ok!)
  1321. RETURN
  1322. END IF
  1323. wf_refresh_curuc(dw_pageretr.Object.u_cusamt_cusmonid[uc_row])
  1324. END IF
  1325. CALL SUPER::Clicked
  1326. end event
  1327. type cb_delet from w_publ_1ton_share_detail`cb_delet within w_sptamt_edit
  1328. end type
  1329. event cb_delet::clicked;call super::clicked;if not f_power_ind(931) then
  1330. messagebox('提示','你没有使用权限!',information!,ok!)
  1331. return
  1332. end if
  1333. if dw_edit_mode then return
  1334. string arg_msg=''
  1335. long uc_row
  1336. uc_row=dw_pageretr.getrow()
  1337. if uc_row<=0 then
  1338. messagebox('提示','请选定当前目标单据!',information!,ok!)
  1339. return
  1340. end if
  1341. IF MessageBox ("询问","是否确定要删除当前单据吗?",Question!,YesNo! ) = 2 THEN RETURN
  1342. if uo_take.del(cur_scid,dw_pageretr.object.u_cusamt_cusmonid[uc_row],arg_msg)=0 then
  1343. messagebox('错误',arg_msg,stopsign!,ok!)
  1344. ELSE
  1345. //日志
  1346. long ls_id
  1347. string ls_code
  1348. ls_id=dw_pageretr.object.u_cusamt_cusmonid[uc_row]
  1349. ls_code=dw_pageretr.object.u_cusamt_cusmoncode[uc_row]
  1350. f_setsysoplog('付款单','付款单删除,id:'+string(ls_id)+',code:'+ls_code,arg_msg,true)
  1351. //--
  1352. MESSAGEBOX('提示','删除单据'+string(dw_pageretr.object.u_cusamt_cusmoncode[uc_row])+'成功!',information!,ok!)
  1353. dw_pageretr.deleterow(uc_row)
  1354. dw_pageretr.Triggerevent(rowfocuschanged!)
  1355. end if
  1356. end event
  1357. type cb_addzy from w_publ_1ton_share_detail`cb_addzy within w_sptamt_edit
  1358. integer x = 1573
  1359. end type
  1360. event cb_addzy::clicked;call super::clicked;m_Dfc_Control_PopupMenu dmPopupMenu
  1361. string menustr
  1362. menustr="Text=增加备注~tEvent=ue_addzy"
  1363. menustr += "|" + "Text=-"
  1364. menustr += "|" + "Text=批初审~tEvent=ue_p_auditing"
  1365. menustr += "|" + "Text=批初撤~tEvent=ue_c_p_auditing"
  1366. menustr += "|" + "Text=-"
  1367. menustr += "|" + "Text=批终审~tEvent=ue_p_secauditing"
  1368. menustr += "|" + "Text=批终撤~tEvent=ue_c_p_secauditing"
  1369. menustr += "|" + "Text=-"
  1370. menustr += "|" + "Text=查看附件~tEvent=ue_fj_view"
  1371. menustr += "|" + "Text=添加附件~tEvent=ue_fj_edit"
  1372. menustr += "|" + "Text=-"
  1373. menustr += "|" + "Text=批确认~tEvent=ue_p_confirm"
  1374. menustr += "|" + "Text=批反确认~tEvent=ue_c_p_confirm"
  1375. if len(trim(menustr))<>0 then
  1376. dmPopupMenu = Create m_Dfc_Control_PopupMenu
  1377. dmPopupMenu.mf_BuildMenu(This, menustr)
  1378. dmPopupMenu.mf_PopMenu()
  1379. Destroy dmPopupMenu
  1380. end if
  1381. end event
  1382. type cb_auditing from w_publ_1ton_share_detail`cb_auditing within w_sptamt_edit
  1383. end type
  1384. event cb_auditing::clicked;call super::clicked;
  1385. IF dw_edit_mode THEN RETURN
  1386. String arg_msg = ''
  1387. Long pagerert_row
  1388. pagerert_row = dw_pageretr.GetRow()
  1389. IF pagerert_row <= 0 THEN
  1390. MessageBox('提示','请选定当前目标单据!',information!,ok!)
  1391. RETURN
  1392. END IF
  1393. IF MessageBox ("询问","是否确定要审核当前单据?",question!,yesno! ) = 2 THEN RETURN
  1394. IF dw_pageretr.Object.u_cusamt_flag[pagerert_row] = 0 THEN
  1395. IF Not f_power_ind(932) THEN
  1396. MessageBox('提示','你没有使用权限!',information!,ok!)
  1397. RETURN
  1398. END IF
  1399. IF uo_take.auditing(dw_pageretr.Object.u_cusamt_cusmonid[pagerert_row],publ_operator,arg_msg,True) = 0 THEN
  1400. MessageBox('错误',arg_msg,stopsign!,ok!)
  1401. ELSE
  1402. MessageBox('提示','初审成功!',information!,ok!)
  1403. wf_refresh_curuc(dw_pageretr.Object.u_cusamt_cusmonid[pagerert_row])
  1404. END IF
  1405. ELSE
  1406. IF Not f_power_ind(999) THEN
  1407. MessageBox('提示','你没有使用权限!',information!,ok!)
  1408. RETURN
  1409. END IF
  1410. IF uo_take.secauditing(dw_pageretr.Object.u_cusamt_cusmonid[pagerert_row],publ_operator,arg_msg,True) = 0 THEN
  1411. MessageBox('错误',arg_msg,stopsign!,ok!)
  1412. ELSE
  1413. MessageBox('提示','终审成功!',information!,ok!)
  1414. wf_refresh_curuc(dw_pageretr.Object.u_cusamt_cusmonid[pagerert_row])
  1415. String ls_taskcode
  1416. ls_taskcode = dw_pageretr.Object.u_cusamt_cusmoncode[dw_pageretr.GetRow()]
  1417. IF f_billevent_trigger (540, 3, ls_taskcode, arg_msg) = 0 THEN
  1418. MessageBox('Error',arg_msg)
  1419. END IF
  1420. END IF
  1421. END IF
  1422. end event
  1423. type cb_xm from w_publ_1ton_share_detail`cb_xm within w_sptamt_edit
  1424. boolean visible = false
  1425. integer x = 3246
  1426. end type
  1427. type cb_retrieve from w_publ_1ton_share_detail`cb_retrieve within w_sptamt_edit
  1428. end type
  1429. type cb_xls from w_publ_1ton_share_detail`cb_xls within w_sptamt_edit
  1430. integer x = 2208
  1431. end type
  1432. type cb_help from w_publ_1ton_share_detail`cb_help within w_sptamt_edit
  1433. integer x = 2510
  1434. end type
  1435. type cb_auditing_cancel from w_publ_1ton_share_detail`cb_auditing_cancel within w_sptamt_edit
  1436. end type
  1437. event cb_auditing_cancel::clicked;call super::clicked;
  1438. IF dw_edit_mode THEN RETURN
  1439. String arg_msg = ''
  1440. Long pagerert_row
  1441. pagerert_row = dw_pageretr.GetRow()
  1442. IF pagerert_row <= 0 THEN
  1443. MessageBox('提示','请选定当前目标单据!',information!,ok!)
  1444. RETURN
  1445. END IF
  1446. IF MessageBox ("询问","是否确定要撤消审核当前单据?",question!,yesno! ) = 2 THEN RETURN
  1447. IF dw_pageretr.Object.u_cusamt_secflag[pagerert_row] = 0 THEN
  1448. IF NOT f_power_ind(933) THEN
  1449. MessageBox('提示','你没有使用权限!',information!,ok!)
  1450. RETURN
  1451. END IF
  1452. IF uo_take.c_auditing(dw_pageretr.Object.u_cusamt_cusmonid[pagerert_row],arg_msg,TRUE) = 0 THEN
  1453. MessageBox('错误',arg_msg,stopsign!,ok!)
  1454. ELSE
  1455. MessageBox('提示','撤消审核成功!',information!,ok!)
  1456. wf_refresh_curuc(dw_pageretr.Object.u_cusamt_cusmonid[pagerert_row])
  1457. END IF
  1458. ELSE
  1459. IF NOT f_power_ind(1000) THEN
  1460. MessageBox('提示','你没有使用权限!',information!,ok!)
  1461. RETURN
  1462. END IF
  1463. IF uo_take.c_secauditing(dw_pageretr.Object.u_cusamt_cusmonid[pagerert_row],arg_msg,TRUE) = 0 THEN
  1464. MessageBox('错误',arg_msg,stopsign!,ok!)
  1465. ELSE
  1466. MessageBox('提示','撤消审核成功!',information!,ok!)
  1467. wf_refresh_curuc(dw_pageretr.Object.u_cusamt_cusmonid[pagerert_row])
  1468. END IF
  1469. END IF
  1470. end event
  1471. type p_msg from w_publ_1ton_share_detail`p_msg within w_sptamt_edit
  1472. end type
  1473. type p_help from w_publ_1ton_share_detail`p_help within w_sptamt_edit
  1474. end type
  1475. type p_encl from w_publ_1ton_share_detail`p_encl within w_sptamt_edit
  1476. end type
  1477. type p_other from w_publ_1ton_share_detail`p_other within w_sptamt_edit
  1478. end type
  1479. type gb_3 from w_publ_1ton_share_detail`gb_3 within w_sptamt_edit
  1480. end type
  1481. type ln_bar from w_publ_1ton_share_detail`ln_bar within w_sptamt_edit
  1482. end type
  1483. type ln_bar2 from w_publ_1ton_share_detail`ln_bar2 within w_sptamt_edit
  1484. end type
  1485. type r_bar from w_publ_1ton_share_detail`r_bar within w_sptamt_edit
  1486. integer x = 3223
  1487. integer height = 148
  1488. end type
  1489. type ln_1 from w_publ_1ton_share_detail`ln_1 within w_sptamt_edit
  1490. end type
  1491. type ln_2 from w_publ_1ton_share_detail`ln_2 within w_sptamt_edit
  1492. end type
  1493. type ddlb_status from dropdownlistbox within w_sptamt_edit
  1494. integer x = 1563
  1495. integer y = 188
  1496. integer width = 393
  1497. integer height = 400
  1498. integer taborder = 10
  1499. boolean bringtotop = true
  1500. integer textsize = -9
  1501. integer weight = 400
  1502. fontcharset fontcharset = gb2312charset!
  1503. fontpitch fontpitch = variable!
  1504. string facename = "宋体"
  1505. long textcolor = 33554432
  1506. string text = "[全部]"
  1507. boolean sorted = false
  1508. string item[] = {"[全部]","待初审","待终审","待确认","审核完毕"}
  1509. borderstyle borderstyle = stylelowered!
  1510. end type
  1511. event selectionchanged;IF Index = 1 THEN
  1512. cur_flag = -1
  1513. cur_confirmflag = -1
  1514. cur_secflag = -1
  1515. ELSEIF Index = 2 THEN
  1516. cur_flag = 0
  1517. cur_secflag = 0
  1518. cur_confirmflag = -1
  1519. ELSEIF Index = 3 THEN
  1520. cur_flag = 1
  1521. cur_secflag = 0
  1522. cur_confirmflag = -1
  1523. ELSEIF Index = 4 THEN
  1524. cur_flag = -1
  1525. cur_secflag = -1
  1526. cur_confirmflag = 0
  1527. ELSE
  1528. cur_flag = 1
  1529. cur_secflag = 1
  1530. cur_confirmflag = 1
  1531. END IF
  1532. PARENT.TriggerEvent('retrieve_pageretr')
  1533. end event
  1534. type ddlb_scid from uo_ddlb_scid within w_sptamt_edit
  1535. integer x = 887
  1536. integer y = 188
  1537. integer width = 549
  1538. integer height = 1120
  1539. end type
  1540. event constructor;call super::constructor;cur_scid=this.uo_scid
  1541. end event
  1542. event selectionchanged;call super::selectionchanged;cur_scid=this.uo_scid
  1543. parent.triggerevent("retrieve_pageretr")
  1544. end event
  1545. type st_3 from statictext within w_sptamt_edit
  1546. integer x = 1403
  1547. integer y = 204
  1548. integer width = 155
  1549. integer height = 48
  1550. integer textsize = -9
  1551. integer weight = 400
  1552. fontcharset fontcharset = gb2312charset!
  1553. fontpitch fontpitch = variable!
  1554. string facename = "宋体"
  1555. long textcolor = 33554432
  1556. long backcolor = 134217739
  1557. string text = "状态"
  1558. alignment alignment = right!
  1559. boolean focusrectangle = false
  1560. end type
  1561. type st_2 from statictext within w_sptamt_edit
  1562. integer x = 722
  1563. integer y = 204
  1564. integer width = 155
  1565. integer height = 48
  1566. integer textsize = -9
  1567. integer weight = 400
  1568. fontcharset fontcharset = gb2312charset!
  1569. fontpitch fontpitch = variable!
  1570. string facename = "宋体"
  1571. long textcolor = 33554432
  1572. long backcolor = 134217739
  1573. string text = "分部"
  1574. alignment alignment = right!
  1575. boolean focusrectangle = false
  1576. end type
  1577. type cb_2 from uo_imflatbutton within w_sptamt_edit
  1578. boolean visible = false
  1579. integer x = 3191
  1580. integer width = 128
  1581. integer height = 164
  1582. integer taborder = 230
  1583. boolean bringtotop = true
  1584. boolean enabled = false
  1585. string text = "收据删除"
  1586. string normalpicname = "delete.bmp"
  1587. integer picsize = 16
  1588. toolbaralignment pic_align = alignattop!
  1589. boolean border = false
  1590. end type
  1591. event clicked;call super::clicked;IF NOT (f_power_ind(136) or f_power_ind(142)) THEN
  1592. MessageBox('提示','你没有使用权限!',information!,ok!)
  1593. RETURN
  1594. END IF
  1595. openwithparm(w_del_data,0)
  1596. end event
  1597. type cb_confirm from uo_imflatbutton within w_sptamt_edit
  1598. integer x = 1179
  1599. integer width = 192
  1600. integer height = 164
  1601. integer taborder = 240
  1602. boolean bringtotop = true
  1603. string text = "确认&D"
  1604. string normalpicname = "audit.bmp"
  1605. integer picsize = 16
  1606. toolbaralignment pic_align = alignattop!
  1607. boolean border = false
  1608. end type
  1609. event clicked;call super::clicked;IF NOT f_power_ind(926) THEN
  1610. MessageBox('提示','你没有使用权限!',information!,ok!)
  1611. RETURN
  1612. END IF
  1613. IF dw_edit_mode THEN RETURN
  1614. String arg_msg = ''
  1615. Long pagerert_row
  1616. pagerert_row = dw_pageretr.GetRow()
  1617. IF pagerert_row <= 0 THEN
  1618. MessageBox('提示','请选定当前目标单据!',information!,ok!)
  1619. RETURN
  1620. END IF
  1621. IF MessageBox ("询问","是否确定要确认当前单据?",question!,yesno! ) = 2 THEN RETURN
  1622. IF uo_take.confirm(dw_pageretr.Object.u_cusamt_cusmonid[pagerert_row],publ_operator,arg_msg,TRUE) = 0 THEN
  1623. MessageBox('错误',arg_msg,stopsign!,ok!)
  1624. ELSE
  1625. MessageBox('提示','确认成功!',information!,ok!)
  1626. wf_refresh_curuc(dw_pageretr.Object.u_cusamt_cusmonid[pagerert_row])
  1627. END IF
  1628. end event
  1629. type cb_cconfirm from uo_imflatbutton within w_sptamt_edit
  1630. integer x = 1371
  1631. integer width = 201
  1632. integer height = 164
  1633. integer taborder = 250
  1634. boolean bringtotop = true
  1635. string text = "反确认"
  1636. string normalpicname = "caudit.bmp"
  1637. integer picsize = 16
  1638. toolbaralignment pic_align = alignattop!
  1639. boolean border = false
  1640. end type
  1641. event clicked;call super::clicked;IF NOT f_power_ind(927) THEN
  1642. MessageBox('提示','你没有使用权限!',information!,ok!)
  1643. RETURN
  1644. END IF
  1645. IF dw_edit_mode THEN RETURN
  1646. String arg_msg = ''
  1647. Long pagerert_row
  1648. pagerert_row = dw_pageretr.GetRow()
  1649. IF pagerert_row <= 0 THEN
  1650. MessageBox('提示','请选定当前目标单据!',information!,ok!)
  1651. RETURN
  1652. END IF
  1653. IF MessageBox ("询问","是否确定要反确认当前单据?",question!,yesno! ) = 2 THEN RETURN
  1654. IF uo_take.cconfirm(dw_pageretr.Object.u_cusamt_cusmonid[pagerert_row],publ_operator,arg_msg,TRUE) = 0 THEN
  1655. MessageBox('错误',arg_msg,stopsign!,ok!)
  1656. ELSE
  1657. MessageBox('提示','反确认成功!',information!,ok!)
  1658. wf_refresh_curuc(dw_pageretr.Object.u_cusamt_cusmonid[pagerert_row])
  1659. END IF
  1660. end event
  1661. type cbx_1 from checkbox within w_sptamt_edit
  1662. integer x = 2057
  1663. integer y = 208
  1664. integer width = 183
  1665. integer height = 60
  1666. boolean bringtotop = true
  1667. integer textsize = -9
  1668. integer weight = 400
  1669. fontcharset fontcharset = gb2312charset!
  1670. fontpitch fontpitch = variable!
  1671. string facename = "宋体"
  1672. long textcolor = 33554432
  1673. long backcolor = 134217739
  1674. string text = "全选"
  1675. end type
  1676. event clicked;Long i
  1677. dw_pageretr.SetRedraw(False)
  1678. FOR i = 1 To dw_pageretr.RowCount()
  1679. IF Checked THEN
  1680. dw_pageretr.Object.ch[i] = 1
  1681. ELSE
  1682. dw_pageretr.Object.ch[i] = 0
  1683. END IF
  1684. NEXT
  1685. dw_pageretr.SetRedraw(True)
  1686. end event