w_wfjg_py.srw 48 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823
  1. $PBExportHeader$w_wfjg_py.srw
  2. forward
  3. global type w_wfjg_py from w_publ_1ton_share_detail
  4. end type
  5. type ddlb_status from dropdownlistbox within w_wfjg_py
  6. end type
  7. type st_2 from statictext within w_wfjg_py
  8. end type
  9. type st_3 from statictext within w_wfjg_py
  10. end type
  11. type ddlb_scid from uo_ddlb_scid within w_wfjg_py
  12. end type
  13. type cbx_1 from checkbox within w_wfjg_py
  14. end type
  15. type cbx_cmpl from checkbox within w_wfjg_py
  16. end type
  17. type cb_cmpl from commandbutton within w_wfjg_py
  18. end type
  19. end forward
  20. global type w_wfjg_py from w_publ_1ton_share_detail
  21. string title = "外协商盘盈单"
  22. boolean maxbox = true
  23. windowstate windowstate = maximized!
  24. event insert_childrow ( )
  25. event ue_cmp_uqty ( )
  26. event ue_cmp_qty ( )
  27. ddlb_status ddlb_status
  28. st_2 st_2
  29. st_3 st_3
  30. ddlb_scid ddlb_scid
  31. cbx_1 cbx_1
  32. cbx_cmpl cbx_cmpl
  33. cb_cmpl cb_cmpl
  34. end type
  35. global w_wfjg_py w_wfjg_py
  36. type variables
  37. uo_outware_wfjg uo_ware
  38. long cur_flag= -1 //-1:全部,0未审
  39. long cur_scid //分店ID
  40. string ol_cdw_str=''
  41. uo_spt_price uo_sptprice
  42. Int cur_editfocus = 0 //1:新建2:修改
  43. end variables
  44. forward prototypes
  45. public function integer wf_flagstatus_rf ()
  46. public function integer wf_refresh_curuc (long arg_scid, long arg_outwareid)
  47. public function integer wf_xls_retrievedata (long arg_ationid, ref s_xls_billlist arg_str_billlist, ref uo_sendtoexcel arg_obj_st, ref string arg_msg)
  48. public function integer wf_print_retrievedata (ref s_print_pic_list arg_s_pic, ref string arg_msg)
  49. end prototypes
  50. event insert_childrow();long li_row
  51. li_row=dw_child.insertrow(0)
  52. dw_child.scrolltorow(li_row)
  53. dw_child.object.ow_wfjgmx_out_ifrel[li_row] = sys_option_autoyes
  54. dw_child.SetColumn ('ow_wfjgmx_out_ifrel')
  55. end event
  56. event ue_cmp_uqty();IF NOT dw_edit_mode THEN RETURN
  57. Long ll_i
  58. dw_child.accepttext()
  59. dw_child.SetRedraw(FALSE)
  60. FOR ll_i = 1 TO dw_child.RowCount()
  61. IF dw_child.Object.ow_wfjgmx_out_qty[ll_i] > 0 AND dw_child.Object.ow_wfjgmx_out_rate[ll_i] > 0 THEN
  62. dw_child.Object.ow_wfjgmx_out_uqty[ll_i] = dw_child.Object.ow_wfjgmx_out_qty[ll_i] / dw_child.Object.ow_wfjgmx_out_rate[ll_i]
  63. END IF
  64. NEXT
  65. dw_child.SetRedraw(TRUE)
  66. end event
  67. event ue_cmp_qty();IF NOT dw_edit_mode THEN RETURN
  68. Long ll_i
  69. dw_child.accepttext()
  70. dw_child.SetRedraw(FALSE)
  71. FOR ll_i = 1 TO dw_child.RowCount()
  72. IF dw_child.Object.ow_wfjgmx_out_uqty[ll_i] > 0 AND dw_child.Object.ow_wfjgmx_out_rate[ll_i] > 0 THEN
  73. dw_child.Object.ow_wfjgmx_out_qty[ll_i] = dw_child.Object.ow_wfjgmx_out_uqty[ll_i] * dw_child.Object.ow_wfjgmx_out_rate[ll_i]
  74. END IF
  75. NEXT
  76. dw_child.SetRedraw(TRUE)
  77. end event
  78. public function integer wf_flagstatus_rf ();//====================================================================
  79. // Function: wf_flagstatus_rf()
  80. //--------------------------------------------------------------------
  81. // Description:
  82. //--------------------------------------------------------------------
  83. // Arguments:(None)
  84. //--------------------------------------------------------------------
  85. // Returns: integer
  86. //--------------------------------------------------------------------
  87. // Author: yyx Date: 2003.12.26
  88. //--------------------------------------------------------------------
  89. // Modify History:
  90. //
  91. //====================================================================
  92. Long pagerert_row
  93. pagerert_row = dw_pageretr.GetRow()
  94. IF pagerert_row <= 0 THEN
  95. cb_auditing.Enabled = FALSE
  96. GOTO ext
  97. END IF
  98. IF dw_edit_mode THEN
  99. cb_auditing.Enabled = FALSE
  100. cb_auditing_cancel.Enabled = FALSE
  101. ELSE
  102. IF dw_pageretr.Object.ow_wfjg_out_flag[pagerert_row] = 0 THEN
  103. cb_auditing.Enabled = TRUE
  104. cb_auditing_cancel.Enabled = FALSE
  105. ELSEIF dw_pageretr.Object.ow_wfjg_out_flag[pagerert_row] = 1 THEN
  106. cb_auditing.Enabled = FALSE
  107. cb_auditing_cancel.Enabled = TRUE
  108. END IF
  109. END IF
  110. ext:
  111. RETURN 0
  112. end function
  113. public function integer wf_refresh_curuc (long arg_scid, long arg_outwareid);//wf_refresh_curuc
  114. IF arg_outwareid <= 0 OR IsNull(arg_outwareid) THEN RETURN 0
  115. Long uc_row
  116. uc_row = dw_pageretr.GetRow()
  117. IF uc_row <= 0 THEN RETURN 0
  118. DateTime outdate
  119. String outrep
  120. String cusname
  121. String part
  122. String dscrp
  123. String outwarecode
  124. DateTime opdate
  125. String opemp
  126. DateTime auditingdate
  127. Int flag
  128. String auditingrep
  129. String storagename
  130. String Modemp
  131. DateTime moddate
  132. String sptcode
  133. String sptname
  134. Long thflag
  135. Long ll_printnum
  136. Long balcflag
  137. Long balcdateint
  138. Long ctmint
  139. long sptid
  140. SELECT ow_wfjg_out.outdate,
  141. ow_wfjg_out.outrep,
  142. ow_wfjg_out.part,
  143. ow_wfjg_out.dscrp,
  144. ow_wfjg_out.outwarecode,
  145. ow_wfjg_out.opdate,
  146. ow_wfjg_out.opemp,
  147. ow_wfjg_out.auditingdate,
  148. ow_wfjg_out.flag,
  149. ow_wfjg_out.auditingemp,
  150. ow_wfjg_out.Modemp,
  151. ow_wfjg_out.moddate,
  152. u_spt.sptcode,
  153. u_spt.name,
  154. ow_wfjg_out.thflag,
  155. ow_wfjg_out.printnum,
  156. ow_wfjg_out.balcflag,
  157. ow_wfjg_out.balcdateint,
  158. ow_wfjg_out.ctmint,
  159. ow_wfjg_out.sptid
  160. INTO :outdate,
  161. :outrep,
  162. :part,
  163. :dscrp,
  164. :outwarecode,
  165. :opdate,
  166. :opemp,
  167. :auditingdate,
  168. :flag,
  169. :auditingrep,
  170. :Modemp,
  171. :moddate,
  172. :sptcode,
  173. :sptname,
  174. :thflag,
  175. :ll_printnum ,
  176. :balcflag,
  177. :balcdateint ,
  178. :ctmint,
  179. :sptid
  180. FROM ow_wfjg_out INNER JOIN
  181. u_spt ON ow_wfjg_out.sptid = u_spt.sptid
  182. WHERE ( ow_wfjg_out.outwareid = :arg_outwareid )
  183. And ( ow_wfjg_out.scid = :arg_scid );
  184. IF sqlca.SQLCode <> 0 THEN
  185. MessageBox('系统提示',"查询操作失败(错误单据唯一码)")
  186. RETURN 0
  187. END IF
  188. dw_pageretr.Object.ow_wfjg_out_scid[uc_row] = arg_scid
  189. dw_pageretr.Object.ow_wfjg_out_outwareid[uc_row] = arg_outwareid
  190. dw_pageretr.Object.ow_wfjg_out_outdate[uc_row] = outdate
  191. dw_pageretr.Object.ow_wfjg_out_outrep[uc_row] = outrep
  192. dw_pageretr.Object.ow_wfjg_out_part[uc_row] = part
  193. dw_pageretr.Object.ow_wfjg_out_dscrp[uc_row] = dscrp
  194. dw_pageretr.Object.ow_wfjg_out_outwarecode[uc_row] = outwarecode
  195. dw_pageretr.Object.ow_wfjg_out_opdate[uc_row] = opdate
  196. dw_pageretr.Object.ow_wfjg_out_opemp[uc_row] = opemp
  197. dw_pageretr.Object.ow_wfjg_out_Auditingdate[uc_row] = auditingdate
  198. dw_pageretr.Object.ow_wfjg_out_flag[uc_row] = flag
  199. dw_pageretr.Object.ow_wfjg_out_Auditingemp[uc_row] = auditingrep
  200. dw_pageretr.Object.ow_wfjg_out_moddate[uc_row] = moddate
  201. dw_pageretr.Object.ow_wfjg_out_modemp[uc_row] = Modemp
  202. dw_pageretr.Object.u_spt_code[uc_row] = sptcode
  203. dw_pageretr.Object.u_spt_name[uc_row] = sptname
  204. dw_pageretr.Object.ow_wfjg_out_thflag[uc_row] = thflag
  205. dw_pageretr.Object.ow_wfjg_out_printnum [uc_row] = ll_printnum
  206. dw_pageretr.Object.ow_wfjg_out_balcflag [uc_row] = balcflag
  207. dw_pageretr.Object.ow_wfjg_out_balcdateint [uc_row] = balcdateint
  208. dw_pageretr.Object.ow_wfjg_out_ctmint [uc_row] = ctmint
  209. dw_pageretr.Object.ow_wfjg_out_sptid[uc_row] = sptid
  210. dw_uc.Reset()
  211. dw_pageretr.RowsCopy(dw_pageretr.GetRow(), dw_pageretr.GetRow(), Primary!, dw_uc, 1, Primary!)
  212. dw_uc.ResetUpdate()
  213. dw_uc.SetRedraw(TRUE)
  214. wf_flagstatus_rf()
  215. RETURN 1
  216. end function
  217. public function integer wf_xls_retrievedata (long arg_ationid, ref s_xls_billlist arg_str_billlist, ref uo_sendtoexcel arg_obj_st, ref string arg_msg);//==============================================================================
  218. // 函数: w_publ_1ton_share_detail::wf_xls_retrievedata()
  219. //------------------------------------------------------------------------------
  220. // 描述: 此函数需要 重载,复制祖先范例代码,然后修改retrieve参数部分两处即可
  221. //------------------------------------------------------------------------------
  222. Long LS_ROW,ll_id,i,ll_scid
  223. LS_ROW = dw_pageretr.GetRow()
  224. IF LS_ROW <= 0 THEN
  225. arg_msg = '没有目标单据!'
  226. RETURN 0
  227. END IF
  228. //修改点:获取 指定retriev参数
  229. ll_id = dw_pageretr.Object.#1[LS_ROW]
  230. ll_scid = dw_pageretr.Object.ow_wfjg_out_scid[LS_ROW]
  231. ////可选设置///
  232. arg_obj_st.uo_const.create_new_pwd( ) //创建随机密码
  233. if sys_option_xls_ifuse_passwd = 1 then arg_obj_st.uo_const.pwd = trim(sys_option_xls_user_passwd) //默认加密密码 默认为随即密码
  234. boolean xls_locked
  235. xls_locked = not (sys_option_xls_lock = 1)
  236. /// Excel 的可选设置
  237. if arg_obj_st.of_setoption(arg_ationid, xls_locked,true,arg_msg) <> 1 then
  238. return 0
  239. end if
  240. for i = 1 to arg_str_billlist.count
  241. ////可选操作///
  242. arg_str_billlist.bill[i].ds_data = create datastore //
  243. arg_str_billlist.bill[i].ds_data.dataobject = arg_str_billlist.bill[i].datawindow //
  244. arg_str_billlist.bill[i].ds_data.settransobject(sqlca)
  245. //修改点:注意retrieve 参数与上文对应
  246. arg_str_billlist.bill[i].ds_data.retrieve(ll_scid,ll_id)
  247. next
  248. return 1
  249. end function
  250. public function integer wf_print_retrievedata (ref s_print_pic_list arg_s_pic, ref string arg_msg);Long LS_ROW,ll_id,i,ll_scid
  251. LS_ROW = dw_pageretr.GetRow()
  252. IF LS_ROW <= 0 THEN
  253. arg_msg = '没有目标单据!'
  254. RETURN 0
  255. END IF
  256. //修改点:获取 指定retriev参数
  257. ll_id = dw_pageretr.Object.#1[LS_ROW]
  258. ll_scid = dw_pageretr.Object.ow_wfjg_out_scid[LS_ROW]
  259. Long ll_i,ll_j
  260. Long ll_mtrlid
  261. Long ll_fileid
  262. Blob ls_filedata
  263. SetNull(ls_filedata)
  264. String Pathname,ls_filename,ls_filetype
  265. String errmsg
  266. uo_fj_mng_billtype ls_uo_fjbt
  267. ls_uo_fjbt = CREATE uo_fj_mng_billtype
  268. Long ll_classid
  269. SELECT classid
  270. INTO :ll_classid
  271. FROM u_billpic_fileclass
  272. Where (billtype = 102);
  273. IF sqlca.SQLCode <> 0 THEN
  274. ll_classid = 0
  275. END IF
  276. IF ll_classid > 0 THEN //如果已经指定好附件类型,则循环明细表查询每个明细的图片信息.
  277. FOR ll_i = 1 TO dw_child.RowCount()
  278. ll_mtrlid = dw_child.Object.ow_wfjgmx_out_mtrlid[ll_i]
  279. arg_s_pic.mtrlid[ll_i] = ll_mtrlid
  280. //取该附件类型中的第一个附件.
  281. SELECT top 1 fileid,DisplayName,FileType INTO :ll_fileid,:ls_filename,:ls_filetype
  282. FROM u_file
  283. WHERE relid = :ll_mtrlid
  284. AND classid = :ll_classid
  285. AND (filetype = 'bmp' OR filetype = 'rle' OR filetype = 'wmf'
  286. OR filetype = 'tif' OR filetype = 'jpg' OR filetype = 'gif' OR filetype = 'jpeg')
  287. USING sys_fileDB_sqlca;
  288. IF sys_fileDB_sqlca.SQLCode <> 0 THEN
  289. ll_fileid = 0
  290. END IF
  291. IF ll_fileid > 0 THEN
  292. Pathname = sys_cur_path+ins_fjtemppath+'\'+String(Today(),'yymmdd')+String(Now(),'hhmmss')+'_'+ls_filename+'.'+ls_filetype
  293. IF Trim(Pathname) <> '' THEN
  294. IF ls_uo_fjbt.uf_getfjbolb_fromdb( ll_fileid, ls_filedata, sys_fileDB_sqlca, arg_msg) = 0 THEN
  295. RETURN 0
  296. END IF
  297. IF f_saveblobtofile(ls_filedata,Pathname,errmsg) = 0 THEN
  298. RETURN 0
  299. ELSE
  300. arg_s_pic.path[ll_i] = Pathname
  301. //记录临时文件位置,本窗口退出后删除
  302. wf_addlog_tempfilepathname(Pathname)
  303. END IF
  304. ELSE
  305. arg_s_pic.path[ll_i] = ''
  306. END IF
  307. ELSE
  308. arg_s_pic.path[ll_i] = ''
  309. END IF
  310. NEXT
  311. END IF
  312. RETURN 1
  313. end function
  314. on w_wfjg_py.create
  315. int iCurrent
  316. call super::create
  317. this.ddlb_status=create ddlb_status
  318. this.st_2=create st_2
  319. this.st_3=create st_3
  320. this.ddlb_scid=create ddlb_scid
  321. this.cbx_1=create cbx_1
  322. this.cbx_cmpl=create cbx_cmpl
  323. this.cb_cmpl=create cb_cmpl
  324. iCurrent=UpperBound(this.Control)
  325. this.Control[iCurrent+1]=this.ddlb_status
  326. this.Control[iCurrent+2]=this.st_2
  327. this.Control[iCurrent+3]=this.st_3
  328. this.Control[iCurrent+4]=this.ddlb_scid
  329. this.Control[iCurrent+5]=this.cbx_1
  330. this.Control[iCurrent+6]=this.cbx_cmpl
  331. this.Control[iCurrent+7]=this.cb_cmpl
  332. end on
  333. on w_wfjg_py.destroy
  334. call super::destroy
  335. destroy(this.ddlb_status)
  336. destroy(this.st_2)
  337. destroy(this.st_3)
  338. destroy(this.ddlb_scid)
  339. destroy(this.cbx_1)
  340. destroy(this.cbx_cmpl)
  341. destroy(this.cb_cmpl)
  342. end on
  343. event open;THIS.TriggerEvent('ue_before_open')
  344. wf_movetocenter()
  345. OLD_TITLE = THIS.Title
  346. s_tran = Message.PowerObjectParm
  347. IF NOT IsNull(s_tran) THEN
  348. retrieve_all = s_tran.if_retrieve_all
  349. mode = s_tran.work_mode
  350. arg_pkid = s_tran.arg_pkid
  351. arg_string_code = s_tran.arg_string_code
  352. if_sharedata = s_tran.if_sharedata //是否应用sharedata,当retrieve_all=true是生效
  353. ds_share = s_tran.ds_share
  354. END IF
  355. dw_pageretr.RBUTTON_FILTER_USE = TRUE //右键查询功能开关
  356. dw_pageretr.titleclick_sort_use = TRUE //单击标题排序功能开关
  357. dw_pageretr.SetTransObject (sqlca)
  358. pkcolumndbtname = wf_get_pkcolumndbtname(dw_pageretr) //取第一列为关键字
  359. ori_oldselect = dw_pageretr.Describe("DataWindow.Table.Select")
  360. ls_newselect = ori_oldselect
  361. ds_curquery = CREATE DATASTORE
  362. ds_curquery.DataObject = 'd_extr_find'
  363. ds_curquery.SetTransObject (sqlca)
  364. wf_editindex_lockf()
  365. IF s_tran.d_long = 2 THEN
  366. cur_scid = s_tran.c_long
  367. Int li_item
  368. li_item = ddlb_scid.FindItem(s_tran.d_string,0)
  369. IF li_item > 0 THEN
  370. ddlb_scid.SelectItem(li_item)
  371. END IF
  372. END IF
  373. sle_usual_query.Text = Trim(arg_string_code)
  374. IF NOT retrieve_all THEN
  375. THIS.TriggerEvent("ue_usual_query_RETR") //修改ls_newselect,retrieve
  376. ELSE
  377. IF if_sharedata THEN
  378. ds_share.ShareData(dw_pageretr)
  379. ELSE
  380. wf_retrieveuc(dw_pageretr,ls_newselect,1)
  381. THIS.TriggerEvent('RETRIEVE_pageretr')
  382. END IF
  383. END IF
  384. IF retrieve_all THEN
  385. THIS.TriggerEvent("ue_usual_query_filt")
  386. END IF
  387. uc_column_int = 8 //uc dw前5列可以编辑
  388. child_column_int =14 //子dw前5列可以编辑
  389. uo_ware = CREATE uo_outware_wfjg
  390. uo_ware.commit_transaction = sqlca
  391. uo_sptprice = CREATE uo_spt_price
  392. s_hide_col s_col
  393. s_col.col_1 = 'u_outwaremx_fprice'
  394. s_col.col_2 = 'amt'
  395. s_col.col_3 = 'u_outwaremx_uprice'
  396. f_hide_col(1473,dw_child,s_col)
  397. end event
  398. event close;call super::close;int li_auto
  399. if cbx_1.checked then
  400. li_auto = 1
  401. else
  402. li_auto = 0
  403. end if
  404. SetProfileString(SYS_INIFILENAME, "outware_wfjg", "auto_add", string(li_auto))
  405. destroy uo_ware
  406. destroy uo_sptprice
  407. end event
  408. event refresh_interface;call super::refresh_interface;wf_flagstatus_rf()
  409. ddlb_status.enabled=not dw_edit_mode
  410. ddlb_scid.enabled=not dw_edit_mode
  411. cbx_cmpl.Enabled = dw_edit_mode
  412. cb_cmpl.Enabled = dw_edit_mode
  413. end event
  414. event retrieve_childdw;call super::retrieve_childdw;long row,uc_relid,ll_scid
  415. row=dw_pageretr.getrow()
  416. if row>0 then
  417. uc_relid=dw_pageretr.object.ow_wfjg_out_outwareid[row]
  418. ll_scid = dw_pageretr.object.ow_wfjg_out_scid[row]
  419. dw_child.SetRedraw (false)
  420. dw_child.retrieve(ll_scid,uc_relid)
  421. dw_child.SetRedraw (true)
  422. else
  423. dw_child.reset()
  424. end if
  425. end event
  426. event retrieve_pageretr;boolean cb_nextpage_enabled,cb_retrieveall_enabled
  427. boolean cb_func_enabled,cb_retrieve_enabled
  428. cb_nextpage_enabled=cb_nextpage.enabled
  429. cb_retrieveall_enabled=cb_retrieveall.enabled
  430. cb_func_enabled=cb_func.enabled
  431. cb_nextpage.enabled=false
  432. cb_retrieveall.enabled=false
  433. cb_func.enabled=false
  434. dw_uc.retrieve()
  435. dw_pageretr.retrieve(cur_scid,cur_flag)
  436. if dw_pageretr.rowcount()>0 and dw_pageretr.getrow()=0 then dw_pageretr.setrow(1)
  437. wf_flagstatus_rf()
  438. this.triggerevent('retrieve_childdw')
  439. cb_nextpage.enabled=cb_nextpage_enabled
  440. cb_retrieveall.enabled=cb_retrieveall_enabled
  441. cb_func.enabled=cb_func_enabled
  442. end event
  443. event ue_usual_query_filt;call super::ue_usual_query_filt;string obj_expr=''
  444. if trim(sle_usual_query.text)<>'' then
  445. IF POS(trim(sle_usual_query.text),'%')=0 THEN
  446. obj_expr=obj_expr+'( u_outware_outwarecode LIKE "%'+trim(sle_usual_query.text)+'%" )'
  447. ELSE
  448. obj_expr=obj_expr+'( u_outware_outwarecode LIKE "'+trim(sle_usual_query.text)+'" )'
  449. END IF
  450. end if
  451. dw_pageretr.setfilter(obj_expr)
  452. dw_pageretr.SetRedraw(False)
  453. dw_pageretr.filter()
  454. if dw_pageretr.rowcount()>=1 then
  455. dw_pageretr.selectrow(0,false)
  456. dw_pageretr.selectrow(1,true)
  457. end if
  458. dw_pageretr.SetRedraw(TRUE)
  459. end event
  460. event ue_usual_query_retr;call super::ue_usual_query_retr;string ls_querystrpart=''
  461. ls_newselect=lower(ori_oldselect)
  462. if trim(sle_usual_query.text)<>'' then
  463. if pos(trim(sle_usual_query.text),'%')=0 then
  464. ls_querystrpart="(ow_wfjg_out.outwarecode like '%"+trim(sle_usual_query.text)+"%')"
  465. else
  466. ls_querystrpart="(ow_wfjg_out.outwarecode like '"+trim(sle_usual_query.text)+"')"
  467. end if
  468. if Pos(ls_newselect," where ") <> 0 then
  469. ls_newselect=ls_newselect+" AND ("+ls_querystrpart+')'
  470. else
  471. ls_newselect=ls_newselect+" where ("+ls_querystrpart+')'
  472. end if
  473. end if
  474. wf_retrieveuc(dw_pageretr,ls_newselect,1)
  475. this.triggerevent('retrieve_pageretr')
  476. end event
  477. event ue_f8;call super::ue_f8;//用于选择明细内容,被f8[默认]\dw_child.doubleclicked调用
  478. IF NOT dw_edit_mode THEN RETURN
  479. Long child_row,ls_j,ls_sptid
  480. dw_child.AcceptText()
  481. child_row = dw_child.GetRow()
  482. ls_sptid = dw_uc.Object.ow_wfjg_out_sptid[dw_uc.GetRow()]
  483. IF IsNull(ls_sptid) OR ls_sptid = 0 THEN
  484. THIS.TriggerEvent("ue_f9")
  485. END IF
  486. IF NOT IsValid(w_mtrldef_edit) THEN
  487. s_edit_index_tran s_ch_tran
  488. s_ch_tran.if_retrieve_all = FALSE
  489. s_ch_tran.work_mode = 1
  490. s_ch_tran.arg_pkid = 0
  491. s_ch_tran.arg_string_code = ''
  492. s_ch_tran.b_long = 3
  493. s_ch_tran.c_long = - 1
  494. s_ch_tran.f_long = -1
  495. s_ch_tran.if_select_all = TRUE
  496. dw_child.AcceptText()
  497. IF dw_child.GetRow() > 0 THEN s_ch_tran.arg_string_code = Trim(dw_child.Object.u_mtrldef_mtrlcode[dw_child.GetRow()])
  498. OpenWithParm(w_mtrldef_edit,s_ch_tran) //调用
  499. s_mtrldef_array s_inscust
  500. s_inscust = Message.PowerObjectParm //接受返回结构
  501. FOR ls_j = 1 TO UpperBound(s_inscust.mtrlid)
  502. IF s_inscust.mtrlid[ls_j] > 0 THEN //正常返回值则可以取以下值
  503. IF dw_child.GetRow() > 0 THEN
  504. IF dw_child.Object.ow_wfjgmx_out_mtrlid[child_row] <> 0 THEN
  505. child_row = dw_child.InsertRow (0)
  506. ELSE
  507. child_row = dw_child.GetRow()
  508. END IF
  509. ELSE
  510. child_row = dw_child.InsertRow (0)
  511. END IF
  512. dw_child.Object.ow_wfjgmx_out_mtrlid[child_row] = s_inscust.mtrlid[ls_j]
  513. dw_child.Object.u_mtrldef_mtrlcode[child_row] = s_inscust.mtrlcode[ls_j]
  514. dw_child.Object.u_mtrldef_mtrlname[child_row] = s_inscust.mtrlname[ls_j]
  515. dw_child.Object.u_mtrldef_mtrlmode[child_row] = s_inscust.mtrlmode[ls_j]
  516. dw_child.Object.u_mtrldef_unit[child_row] = s_inscust.unit[ls_j]
  517. dw_child.Object.ow_wfjgmx_out_uunit[child_row] = s_inscust.unit[ls_j]
  518. // dw_child.Object.ow_wfjgmx_out_uqty[child_row] = 0
  519. dw_child.Object.ow_wfjgmx_out_rate[child_row] = 1
  520. dw_child.Object.u_mtrldef_mtrlsectype[child_row] = s_inscust.mtrlsectype[ls_j]
  521. dw_child.Object.u_mtrldef_zxmtrlmode[child_row] = s_inscust.zxmtrlmode[ls_j]
  522. dw_child.Object.ow_wfjgmx_out_fprice[child_row] = s_inscust.planprice[ls_j]
  523. END IF
  524. NEXT
  525. dw_child.SetColumn('ow_wfjgmx_out_uqty')
  526. END IF
  527. dw_child.SetRedraw(TRUE)
  528. dw_child.SetFocus()
  529. end event
  530. event ue_viewprint;call super::ue_viewprint;
  531. IF NOT f_power_ind(1422) THEN
  532. MessageBox('提示','你没有使用权限!',information!,OK!)
  533. RETURN
  534. END IF
  535. Long LS_ROW
  536. LS_ROW = dw_pageretr.GetRow()
  537. IF LS_ROW <= 0 THEN
  538. MessageBox('NO','没有打印目标单据!')
  539. RETURN
  540. END IF
  541. S_print_MSG LS_PRMSG
  542. IF ls_newname <> '' THEN
  543. IF li_auditprint = 1 THEN
  544. IF dw_pageretr.Object.ow_wfjg_out_flag[dw_pageretr.GetRow()] = 0 THEN
  545. MessageBox('NO','目标单据还未审核,不能打印!')
  546. RETURN
  547. END IF
  548. END IF
  549. LS_PRMSG.obj_dwNAME = ls_newname
  550. ELSE
  551. IF Not f_power_ind(1422) THEN
  552. MessageBox(publ_operator,'你没有使用权限!')
  553. RETURN
  554. END IF
  555. LS_PRMSG.obj_dwNAME = 'dw_rp_wfjg_py_edit'
  556. END IF
  557. IF LS_PRMSG.obj_dwNAME = '' THEN RETURN
  558. LS_PRMSG.printrow = ll_prownum
  559. LS_PRMSG.TAG_TEXT = '外协商盘盈单'
  560. LS_PRMSG.FILTER_STRING = ''
  561. LS_PRMSG.retr_pram_falg = 15
  562. LS_PRMSG.PAGECH_FLAG = 0
  563. LS_PRMSG.retr_scid = dw_pageretr.Object.ow_wfjg_out_scid[LS_ROW]
  564. LS_PRMSG.retr_pramnmb = dw_pageretr.Object.ow_wfjg_out_outwareid[LS_ROW]
  565. LS_PRMSG.rowcnt = dw_child.RowCount()
  566. IF ifpic = 1 THEN
  567. String ls_msg
  568. IF wf_print_retrievedata(LS_PRMSG.s_pic,ls_msg) = 0 THEN
  569. MessageBox('提示','下载图片失败!',information!,OK!)
  570. RETURN
  571. END IF
  572. END IF
  573. OpenWithParm(w_publ_preview,LS_PRMSG)
  574. IF ifpic = 1 THEN
  575. Long li
  576. FOR li = 1 TO UpperBound(LS_PRMSG.s_pic.path)
  577. IF Len(Trim(LS_PRMSG.s_pic.path[li])) > 0 THEN
  578. FileDelete(LS_PRMSG.s_pic.path[li])
  579. END IF
  580. NEXT
  581. END IF
  582. //更新打印次数
  583. String arg_msg
  584. printnum = Message.DoubleParm
  585. f_update_printnum('ow_wfjg_out',printnum,dw_pageretr.Object.ow_wfjg_out_scid[LS_ROW],dw_pageretr.Object.ow_wfjg_out_outwareid[LS_ROW],'','',arg_msg,TRUE)
  586. end event
  587. event ue_print;call super::ue_print;//--直接打印
  588. IF NOT f_power_ind(1422) THEN
  589. MessageBox('提示','你没有使用权限!',information!,OK!)
  590. RETURN
  591. END IF
  592. uo_print_preview uo_print
  593. IF MessageBox ("IF","是否确定要打印当前单据吗?",Question!,YesNo! ) = 2 THEN RETURN
  594. S_print_MSG LS_PRMSG
  595. Long LS_ROW
  596. LS_ROW = dw_pageretr.GetRow()
  597. IF LS_ROW <= 0 THEN
  598. MessageBox('NO','没有打印目标单据!')
  599. RETURN
  600. END IF
  601. IF ls_newname <> '' THEN
  602. IF li_auditprint = 1 THEN
  603. IF dw_pageretr.Object.ow_wfjg_out_flag[dw_pageretr.GetRow()] = 0 THEN
  604. MessageBox('NO','目标单据还未审核,不能打印!')
  605. RETURN
  606. END IF
  607. END IF
  608. LS_PRMSG.obj_dwNAME = ls_newname
  609. ELSE
  610. IF Not f_power_ind(1422) THEN
  611. MessageBox(publ_operator,'你没有使用权限!')
  612. RETURN
  613. END IF
  614. LS_PRMSG.obj_dwNAME = 'dw_rp_wfjg_py_edit'
  615. END IF
  616. IF LS_PRMSG.obj_dwNAME = '' THEN RETURN
  617. LS_PRMSG.retr_pram_falg = 15
  618. LS_PRMSG.printrow = ll_prownum
  619. LS_PRMSG.TAG_TEXT = '外协商盘盈单'
  620. LS_PRMSG.FILTER_STRING = ''
  621. LS_PRMSG.PAGECH_FLAG = 0
  622. LS_PRMSG.retr_scid = dw_pageretr.Object.ow_wfjg_out_scid[LS_ROW]
  623. LS_PRMSG.retr_pramnmb = dw_pageretr.Object.ow_wfjg_out_outwareid[LS_ROW]
  624. LS_PRMSG.rowcnt = dw_child.RowCount()
  625. IF ifpic = 1 THEN
  626. String ls_msg
  627. IF wf_print_retrievedata(LS_PRMSG.s_pic,ls_msg) = 0 THEN
  628. MessageBox('提示','下载图片失败!',information!,OK!)
  629. RETURN
  630. END IF
  631. END IF
  632. uo_print.FACT_PRINT_MSG = LS_PRMSG
  633. String arg_msg
  634. IF uo_print.uof_print_begin(arg_msg) = 0 THEN
  635. MessageBox("系统提示",arg_msg)
  636. RETURN
  637. END IF
  638. uo_print.ds_print()
  639. IF ifpic = 1 THEN
  640. Long li
  641. FOR li = 1 TO UpperBound(LS_PRMSG.s_pic.path)
  642. IF Len(Trim(LS_PRMSG.s_pic.path[li])) > 0 THEN
  643. FileDelete(LS_PRMSG.s_pic.path[li])
  644. END IF
  645. NEXT
  646. END IF
  647. //更新打印次数
  648. printnum = 1
  649. f_update_printnum('ow_wfjg_out',printnum,dw_pageretr.Object.ow_wfjg_out_scid[LS_ROW],dw_pageretr.Object.ow_wfjg_out_outwareid[LS_ROW],'','',arg_msg,TRUE)
  650. end event
  651. event ue_f9;call super::ue_f9;//用于选择明细内容,被F10[默认]
  652. if not dw_edit_mode then return
  653. long uc_row
  654. uc_row=dw_uc.getrow()
  655. if uc_row=0 then
  656. messagebox('系统提示','请选定出仓单!')
  657. return
  658. end if
  659. dw_uc.accepttext()
  660. if not isvalid(W_spt_edit) then
  661. s_edit_index_tran s_ch_tran //传递参数使用
  662. s_ch_tran.if_retrieve_all=false //是否一次RETRIEVE所有行
  663. s_ch_tran.work_mode=1 //0-单纯编辑模式 1-选择\编辑模式
  664. s_ch_tran.arg_pkid=0 //目标定位PKID (备用)
  665. //查询列(物料编码)部分内容,用于初步筛选
  666. s_ch_tran.arg_string_code=upper(trim(dw_uc.object.u_spt_code[dw_uc.getrow()]))
  667. OPENwithparm(W_spt_edit,s_ch_tran) //调用
  668. S_spt S_INSCUST
  669. S_INSCUST=Message.PowerObjectParm //接受返回结构
  670. IF S_INSCUST.sptid>0 THEN //正常返回值则可以取以下值
  671. dw_uc.setredraw(false)
  672. dw_uc.object.ow_wfjg_out_sptid[uc_row]=S_INSCUST.sptid
  673. dw_uc.object.u_spt_name[uc_row]=S_INSCUST.name
  674. dw_uc.object.u_spt_code[uc_row]=S_INSCUST.sptcode
  675. dw_uc.setredraw(true)
  676. dw_uc.setcolumn("ow_wfjg_out_outdate")
  677. END IF
  678. end if
  679. end event
  680. event ue_addzy;call super::ue_addzy;IF NOT f_power_ind(1421) THEN
  681. MessageBox(publ_operator,'你没有使用权限!')
  682. RETURN
  683. END IF
  684. IF dw_edit_mode THEN RETURN
  685. String arg_msg = '',LS_STR
  686. Long uc_row
  687. s_inputbox S_SREU
  688. uc_row = dw_pageretr.GetRow()
  689. IF uc_row <= 0 THEN
  690. MessageBox('系统提示','请选定当前目标单据!')
  691. RETURN
  692. END IF
  693. S_SREU.Title = '请输入要补充到备注的内容'
  694. S_SREU.OLD_TEXT = ''
  695. OpenWithParm(w_inputbox,S_SREU)
  696. LS_STR = Message.StringParm
  697. IF Trim(LS_STR) = '' OR IsNull(LS_STR) THEN RETURN
  698. IF uo_ware.add_dscrp(dw_pageretr.Object.ow_wfjg_out_scid[uc_row],dw_pageretr.Object.ow_wfjg_out_outwareid[uc_row],LS_STR,arg_msg) = 0 THEN
  699. MessageBox('Error!',arg_msg)
  700. RETURN
  701. ELSE
  702. MessageBox(publ_operator,'添加备注操作成功!')
  703. wf_refresh_curuc(dw_pageretr.Object.ow_wfjg_out_scid[uc_row],dw_pageretr.Object.ow_wfjg_out_outwareid[uc_row])
  704. END IF
  705. end event
  706. event ue_rpt_viewprint;call super::ue_rpt_viewprint;
  707. Long row,uc_relid,ll_scid
  708. row = dw_pageretr.GetRow()
  709. IF row = 0 THEN RETURN
  710. IF ls_rpname = '' THEN RETURN
  711. IF li_auditprint = 1 THEN
  712. IF dw_pageretr.Object.ow_wfjg_out_flag[row] = 0 THEN
  713. MessageBox('NO','目标单据还未审核,不能打印!')
  714. RETURN
  715. END IF
  716. END IF
  717. s_rpt_print_msg s_print
  718. s_print.retr_pram_falg = 15
  719. s_print.rpid = ls_msgprintid_rpt
  720. s_print.retr_flag = TRUE
  721. s_print.tag_text = THIS.Title
  722. s_print.rpname = ls_rpname
  723. s_print.retr_scid = dw_pageretr.Object.ow_wfjg_out_scid[row]
  724. s_print.retr_pramnmb = dw_pageretr.Object.ow_wfjg_out_outwareid[row]
  725. s_print.rowcnt = dw_child.RowCount()
  726. OpenWithParm(w_rpt_preview,s_print)
  727. //**更新打印次料
  728. String arg_msg
  729. printnum = Message.DoubleParm
  730. String ls_code
  731. ll_scid = dw_pageretr.Object.ow_wfjg_out_scid[row]
  732. ls_code = dw_pageretr.Object.ow_wfjg_out_outwarecode[row]
  733. //f_update_printnum(ll_scid,ls_code,TRUE,printnum,arg_msg,TRUE)
  734. end event
  735. event ue_rpt_print;call super::ue_rpt_print;Long row,uc_relid,ll_scid
  736. row = dw_pageretr.GetRow()
  737. IF row = 0 THEN RETURN
  738. uo_rpt_print_preview uo_print
  739. S_rpt_print_MSG LS_PRMSG
  740. IF dw_pageretr.RowCount() = 0 THEN
  741. MessageBox('系统信息','没有可打印的单据!')
  742. RETURN
  743. END IF
  744. IF ls_rpname = '' THEN RETURN
  745. IF li_auditprint = 1 THEN
  746. IF dw_pageretr.Object.ow_wfjg_out_flag[row] = 0 THEN
  747. MessageBox('NO','目标单据还未审核,不能打印!')
  748. RETURN
  749. END IF
  750. END IF
  751. IF MessageBox ("IF","是否确定要打印当前单据吗?",Question!,YesNo! ) = 2 THEN RETURN
  752. LS_PRMSG.retr_pram_falg = 15
  753. LS_PRMSG.TAG_TEXT = THIS.Title
  754. LS_PRMSG.rpname = ls_rpname
  755. LS_PRMSG.FILTER_STRING = ''
  756. LS_PRMSG.PAGECH_FLAG = 0
  757. LS_PRMSG.rpid = ls_msgprintid_rpt
  758. LS_PRMSG.retr_scid = dw_pageretr.Object.ow_wfjg_out_scid[row]
  759. LS_PRMSG.retr_pramnmb = dw_pageretr.Object.ow_wfjg_out_outwareid[row]
  760. LS_PRMSG.rowcnt = dw_child.RowCount()
  761. uo_print.FACT_PRINT_MSG = LS_PRMSG
  762. String arg_msg
  763. IF uo_print.uof_print_begin(arg_msg) = 0 THEN
  764. MessageBox("系统提示",arg_msg)
  765. RETURN
  766. END IF
  767. uo_print.ds_print()
  768. //**更新打印次料
  769. printnum = Message.DoubleParm
  770. String ls_code
  771. ll_scid = dw_pageretr.Object.ow_wfjg_out_scid[row]
  772. ls_code = dw_pageretr.Object.ow_wfjg_out_outwarecode[row]
  773. //f_update_printnum(ll_scid,ls_code,TRUE,printnum,arg_msg,TRUE)
  774. end event
  775. event ue_f6;call super::ue_f6;IF NOT dw_edit_mode THEN RETURN
  776. IF dw_child.GetRow() < 1 THEN RETURN
  777. IF dw_child.Object.u_mtrldef_ifunit[dw_child.GetRow()] = 0 THEN RETURN
  778. Long ls_mtrlid
  779. s_unit s_inscust
  780. s_edit_index_tran s_tran_unit
  781. IF sys_option_2unit_ch = 1 THEN
  782. IF NOT IsValid(w_unit_ch) THEN
  783. ls_mtrlid = dw_child.Object.ow_wfjgmx_out_mtrlid[dw_child.GetRow()]
  784. s_tran_unit.c_long = ls_mtrlid
  785. s_tran_unit.d_long = 1 //是否可选方向
  786. s_tran_unit.e_long = -1 //不可选方向的情况下,强行设定方向. 0 - 计价->库存; 1 - 库存->计价
  787. OpenWithParm(w_unit_ch,s_tran_unit)
  788. s_inscust = Message.PowerObjectParm //接受返回结构
  789. IF s_inscust.unit <> '' THEN
  790. dw_child.Object.ow_wfjgmx_out_uunit[dw_child.GetRow()] = s_inscust.unit
  791. dw_child.Object.ow_wfjgmx_out_rate[dw_child.GetRow()] = s_inscust.rate
  792. IF s_inscust.ReturnType = 0 THEN
  793. IF dw_child.Object.ow_wfjgmx_out_uqty[dw_child.GetRow()] > 0 THEN
  794. dw_child.Object.ow_wfjgmx_out_qty[dw_child.GetRow()] = Round(s_inscust.rate * dw_child.Object.ow_wfjgmx_out_uqty[dw_child.GetRow()],sys_option_unit_dec)
  795. END IF
  796. dw_child.SetColumn( 'ow_wfjgmx_out_qty')
  797. ELSE
  798. IF dw_child.Object.ow_wfjgmx_out_uqty[dw_child.GetRow()] > 0 THEN
  799. dw_child.Object.ow_wfjgmx_out_uqty[dw_child.GetRow()] = Round(dw_child.Object.ow_wfjgmx_out_uqty[dw_child.GetRow()] / s_inscust.rate ,sys_option_unit_dec)
  800. END IF
  801. dw_child.SetColumn( 'ow_wfjgmx_out_uqty')
  802. END IF
  803. END IF
  804. END IF
  805. ELSE
  806. IF NOT IsValid(w_unit_def_ch) THEN
  807. IF dw_child.GetRow() < 1 THEN RETURN
  808. Open(w_unit_def_ch)
  809. s_inscust = Message.PowerObjectParm //接受返回结构
  810. IF s_inscust.unit <> '' THEN
  811. dw_child.Object.ow_wfjgmx_out_uunit[dw_child.GetRow()] = s_inscust.unit
  812. dw_child.SetColumn( 'ow_wfjgmx_out_qty')
  813. END IF
  814. END IF
  815. END IF
  816. end event
  817. type cb_func from w_publ_1ton_share_detail`cb_func within w_wfjg_py
  818. end type
  819. type cb_exit from w_publ_1ton_share_detail`cb_exit within w_wfjg_py
  820. end type
  821. type sle_usual_query from w_publ_1ton_share_detail`sle_usual_query within w_wfjg_py
  822. integer width = 549
  823. end type
  824. type cb_retrieveall from w_publ_1ton_share_detail`cb_retrieveall within w_wfjg_py
  825. integer x = 3017
  826. end type
  827. type em_pagerowno from w_publ_1ton_share_detail`em_pagerowno within w_wfjg_py
  828. integer x = 2715
  829. end type
  830. type dw_pageretr from w_publ_1ton_share_detail`dw_pageretr within w_wfjg_py
  831. integer x = 2043
  832. integer width = 1504
  833. integer height = 872
  834. string dataobject = "dw_wfjg_py_index"
  835. end type
  836. event dw_pageretr::rowfocuschanged;call super::rowfocuschanged;wf_flagstatus_rf()
  837. end event
  838. type st_1 from w_publ_1ton_share_detail`st_1 within w_wfjg_py
  839. integer x = 14
  840. end type
  841. type cb_nextpage from w_publ_1ton_share_detail`cb_nextpage within w_wfjg_py
  842. integer x = 3168
  843. end type
  844. type dw_uc from w_publ_1ton_share_detail`dw_uc within w_wfjg_py
  845. integer width = 2039
  846. integer height = 872
  847. string dataobject = "dw_wfjg_py_edit"
  848. end type
  849. event dw_uc::dwnkey;PARENT.TriggerEvent('user_key')
  850. IF Key = KeyDownArrow! THEN RETURN 1
  851. IF dw_edit_mode THEN
  852. IF dw_uc.GetColumnName ( ) = 'ow_wfjg_out_dscrp' AND Key = KeyEnter! THEN
  853. dw_child.SetFocus()
  854. dw_child.ScrollToRow(1)
  855. dw_child.SetColumn ('ow_wfjgmx_out_ifrel')
  856. RETURN 1
  857. ELSEIF dw_uc.GetColumnName ( ) = 'u_spt_code' AND Key = KeyEnter! THEN
  858. String ls_code
  859. dw_uc.AcceptText()
  860. ls_code = Trim(dw_uc.Object.u_spt_code[dw_uc.GetRow()])
  861. s_spt arg_s_spt
  862. IF f_find_spt(ls_code,arg_s_spt) = 0 THEN
  863. PARENT.TriggerEvent('ue_f9')
  864. RETURN 1
  865. ELSE
  866. dw_uc.SetRedraw(FALSE)
  867. dw_uc.Object.ow_wfjg_out_sptid[dw_uc.GetRow()] = arg_s_spt.sptid
  868. dw_uc.Object.u_spt_code[dw_uc.GetRow()] = arg_s_spt.sptcode
  869. dw_uc.Object.u_spt_name[dw_uc.GetRow()] = arg_s_spt.Name
  870. dw_uc.SetRedraw(TRUE)
  871. dw_uc.SetColumn("ow_wfjg_out_outdate")
  872. RETURN 1
  873. END IF
  874. ELSE
  875. IF Key = KeyEnter! THEN //
  876. keybd_event ( 9, 0, 0 , 0 ) // 按下tab
  877. keybd_event ( 9, 0, 2, 0 ) // 释放tab
  878. RETURN 1
  879. END IF
  880. END IF
  881. END IF
  882. end event
  883. event dw_uc::buttonclicked;call super::buttonclicked;IF NOT dw_edit_mode THEN RETURN
  884. if dwo.Name = 'b_spt' then
  885. PARENT.TriggerEvent("ue_f9")
  886. END IF
  887. end event
  888. type gb_2 from w_publ_1ton_share_detail`gb_2 within w_wfjg_py
  889. integer x = 219
  890. integer y = 416
  891. integer width = 238
  892. integer height = 264
  893. end type
  894. type dw_child from w_publ_1ton_share_detail`dw_child within w_wfjg_py
  895. integer y = 1168
  896. integer width = 3552
  897. integer height = 1004
  898. string dataobject = "dw_wfjgmx_py_edit"
  899. end type
  900. event dw_child::dwnkey;call super::dwnkey;PARENT.TriggerEvent('user_key')
  901. String ls_mtrlcode,ls_mtrlname,ls_unit,ls_mtrlmode
  902. String ls_plancode,ls_status,ls_woodcode,ls_pcode
  903. Long ls_mtrlid,ls_orderid
  904. Dec ls_planprice
  905. String ls_mtrlsectype,ls_zxmtrlmode
  906. s_mtrldef_array arg_s_mtrldef
  907. Long child_row
  908. Long ls_sptid
  909. IF dw_edit_mode THEN
  910. dw_uc.AcceptText()
  911. dw_child.AcceptText()
  912. child_row = dw_child.GetRow()
  913. ls_orderid = dw_child.Object.ow_wfjgmx_out_relid[child_row]
  914. ls_sptid = dw_uc.Object.ow_wfjg_out_sptid[dw_uc.GetRow()]
  915. IF IsNull(ls_sptid) OR ls_sptid = 0 THEN
  916. THIS.TriggerEvent("ue_f10")
  917. END IF
  918. IF KeyDown(Keydownarrow!) THEN
  919. Long li_row
  920. IF dw_child.GetRow() = dw_child.RowCount() THEN
  921. PARENT.TriggerEvent("insert_childrow")
  922. END IF
  923. ELSE
  924. IF KeyDown(KeyEnter!) AND NOT KeyDown(KeyControl!) AND NOT KeyDown(KeyShift!) THEN
  925. IF dw_child.GetColumnName( ) = 'u_mtrldef_mtrlcode' THEN
  926. dw_child.AcceptText()
  927. child_row = dw_child.GetRow()
  928. IF dw_child.Object.ow_wfjgmx_out_ifrel[child_row] = 1 THEN
  929. PARENT.TriggerEvent('ue_f8')
  930. RETURN 1
  931. END IF
  932. ls_mtrlcode = dw_child.Object.u_mtrldef_mtrlcode[child_row]
  933. IF f_find_mtrl(ls_mtrlcode, -1,arg_s_mtrldef) = 0 THEN
  934. PARENT.TriggerEvent('ue_f8')
  935. RETURN 1
  936. ELSE
  937. ls_mtrlid = arg_s_mtrldef.mtrlid[1]
  938. ls_mtrlcode = arg_s_mtrldef.mtrlcode[1]
  939. ls_mtrlname = arg_s_mtrldef.mtrlname[1]
  940. ls_unit = arg_s_mtrldef.unit[1]
  941. ls_mtrlmode = arg_s_mtrldef.mtrlmode[1]
  942. ls_planprice = arg_s_mtrldef.planprice[1]
  943. ls_mtrlsectype = arg_s_mtrldef.mtrlsectype[1]
  944. ls_zxmtrlmode = arg_s_mtrldef.zxmtrlmode[1]
  945. END IF
  946. dw_child.Object.ow_wfjgmx_out_mtrlid[child_row] = ls_mtrlid
  947. dw_child.Object.u_mtrldef_mtrlname[child_row] = ls_mtrlname
  948. dw_child.Object.u_mtrldef_mtrlmode[child_row] = ls_mtrlmode
  949. dw_child.Object.u_mtrldef_unit[child_row] = ls_unit
  950. dw_child.Object.ow_wfjgmx_out_qty[child_row] = 0
  951. dw_child.Object.ow_wfjgmx_out_fprice[child_row] = ls_planprice
  952. dw_child.Object.u_mtrldef_mtrlcode[child_row] = ls_mtrlcode
  953. dw_child.Object.u_mtrldef_mtrlsectype[child_row] = ls_mtrlsectype
  954. dw_child.Object.u_mtrldef_zxmtrlmode[child_row] = ls_zxmtrlmode
  955. IF dw_child.Object.ow_wfjgmx_out_uunit[child_row] = '' THEN
  956. dw_child.Object.ow_wfjgmx_out_uunit[child_row] = ls_unit
  957. dw_child.Object.ow_wfjgmx_out_uqty[child_row] = 0
  958. dw_child.Object.ow_wfjgmx_out_rate[child_row] = 1
  959. END IF
  960. IF Key = KeyEnter! THEN //
  961. keybd_event ( 9, 0, 0 , 0 ) // 按下tab
  962. keybd_event ( 9, 0, 2, 0 ) // 释放tab
  963. RETURN 1
  964. END IF
  965. ELSEIF dw_child.GetColumnName( ) = 'ow_wfjgmx_out_rate' THEN
  966. dw_child.AcceptText()
  967. child_row = dw_child.GetRow()
  968. dw_child.Object.ow_wfjgmx_out_qty[child_row] = dw_child.Object.ow_wfjgmx_out_uqty[child_row] * dw_child.Object.ow_wfjgmx_out_rate[child_row]
  969. IF Key = KeyEnter! THEN //
  970. keybd_event ( 9, 0, 0 , 0 ) // 按下tab
  971. keybd_event ( 9, 0, 2, 0 ) // 释放tab
  972. RETURN 1
  973. END IF
  974. ELSEIF dw_child.GetColumnName( ) = 'ow_wfjgmx_out_uqty' THEN
  975. dw_child.AcceptText()
  976. child_row = dw_child.GetRow()
  977. dw_child.Object.ow_wfjgmx_out_qty[child_row] = dw_child.Object.ow_wfjgmx_out_uqty[child_row] * dw_child.Object.ow_wfjgmx_out_rate[child_row]
  978. IF Key = KeyEnter! THEN //
  979. keybd_event ( 9, 0, 0 , 0 ) // 按下tab
  980. keybd_event ( 9, 0, 2, 0 ) // 释放tab
  981. RETURN 1
  982. END IF
  983. ELSEIF dw_child.GetColumnName( ) = 'ow_wfjgmx_out_mxdscrp' AND dw_child.GetRow() = dw_child.RowCount() THEN
  984. PARENT.TriggerEvent("insert_childrow")
  985. RETURN 1
  986. ELSE
  987. IF Key = KeyEnter! THEN //
  988. keybd_event ( 9, 0, 0 , 0 ) // 按下tab
  989. keybd_event ( 9, 0, 2, 0 ) // 释放tab
  990. RETURN 1
  991. END IF
  992. END IF
  993. END IF
  994. END IF
  995. END IF
  996. end event
  997. event dw_child::itemchanged;call super::itemchanged;if not dw_edit_mode then return
  998. this.accepttext()
  999. if dwo.name = 'ow_wfjgmx_out_ifrel' then
  1000. if this.object.ow_wfjgmx_out_ifrel[row] = 1 then
  1001. this.object.ow_wfjgmx_out_relid[row] = 0
  1002. this.object.ow_wfjgmx_out_relcode[row] = ''
  1003. end if
  1004. end if
  1005. end event
  1006. event dw_child::doubleclicked;IF dw_edit_mode THEN
  1007. IF dwo.Name = 'ow_wfjgmx_out_uunit' THEN
  1008. PARENT.TriggerEvent('ue_f6')
  1009. ELSE
  1010. PARENT.TriggerEvent('ue_f8')
  1011. END IF
  1012. END IF
  1013. end event
  1014. type cb_viewprint from w_publ_1ton_share_detail`cb_viewprint within w_wfjg_py
  1015. end type
  1016. type cb_print from w_publ_1ton_share_detail`cb_print within w_wfjg_py
  1017. end type
  1018. type cb_add from w_publ_1ton_share_detail`cb_add within w_wfjg_py
  1019. end type
  1020. event cb_add::clicked;IF NOT f_power_ind(1417) THEN
  1021. MessageBox(publ_operator,'你没有使用权限!')
  1022. RETURN
  1023. END IF
  1024. String arg_msg = ''
  1025. Long uc_row,i,j
  1026. IF dw_edit_mode THEN
  1027. dw_uc.AcceptText()
  1028. dw_child.AcceptText()
  1029. uc_row = dw_uc.GetRow()
  1030. IF uc_row <= 0 THEN
  1031. MessageBox('系统提示','请选定当前目标单据!')
  1032. RETURN
  1033. END IF
  1034. IF NOT dw_uc.Object.ow_wfjg_out_outdate[uc_row] > DateTime(2000-01-01,Now()) THEN
  1035. MessageBox('系统提示','不合理发生时间')
  1036. dw_uc.SetFocus()
  1037. dw_uc.SetColumn('u_outware_outdate')
  1038. RETURN
  1039. END IF
  1040. IF NOT Len(String(dw_uc.Object.ow_wfjg_out_outrep[uc_row])) > 0 THEN
  1041. MessageBox('系统提示','请填写经手人')
  1042. dw_uc.SetFocus()
  1043. dw_uc.SetColumn('ow_wfjg_out_outrep')
  1044. RETURN
  1045. END IF
  1046. FOR j = 1 TO dw_child.RowCount()
  1047. IF dw_child.Object.ow_wfjgmx_out_qty[j] = 0 THEN CONTINUE
  1048. IF dw_child.Object.ow_wfjgmx_out_mtrlwareid[j] > 0 AND dw_child.Object.ow_wfjgmx_out_qty[j] < 0 THEN
  1049. MessageBox(publ_operator,'出仓单的数量一定要为正数')
  1050. RETURN
  1051. END IF
  1052. // IF dw_child.Object.u_mtrldef_ifunit[j] = 1 THEN
  1053. // IF dw_child.Object.ow_wfjgmx_out_mtrlwareid[j] > 0 AND dw_child.Object.ow_wfjgmx_out_uqty[j] < 0 THEN
  1054. // MessageBox(publ_operator,'出仓单的计价单位数量一定要为正数')
  1055. // RETURN
  1056. // END IF
  1057. // END IF
  1058. NEXT
  1059. IF cbx_cmpl.Checked THEN cb_cmpl.TriggerEvent(Clicked!)
  1060. uo_ware.outdate = dw_uc.Object.ow_wfjg_out_outdate[uc_row]
  1061. uo_ware.outrep = dw_uc.Object.ow_wfjg_out_outrep[uc_row]
  1062. uo_ware.dscrp = dw_uc.Object.ow_wfjg_out_dscrp[uc_row]
  1063. uo_ware.sptid = dw_uc.Object.ow_wfjg_out_sptid[uc_row]
  1064. uo_ware.part = dw_uc.Object.ow_wfjg_out_part[uc_row]
  1065. FOR i = 1 TO dw_child.RowCount()
  1066. IF dw_child.Object.ow_wfjgmx_out_mtrlid[i] > 0 THEN
  1067. dw_child.Object.ow_wfjgmx_out_qty[i] = dw_child.Object.ow_wfjgmx_out_uqty[i] * dw_child.Object.ow_wfjgmx_out_rate[i]
  1068. IF uo_ware.acceptmx(0,&
  1069. dw_child.Object.ow_wfjgmx_out_uqty[i],&
  1070. dw_child.Object.ow_wfjgmx_out_uunit[i],&
  1071. dw_child.Object.ow_wfjgmx_out_qty[i],&
  1072. dw_child.Object.ow_wfjgmx_out_mxdscrp[i],&
  1073. dw_child.Object.printid[i],&
  1074. arg_msg,&
  1075. 0,&
  1076. 0,&
  1077. 0,&
  1078. dw_child.Object.ow_wfjgmx_out_mtrlid[i],&
  1079. 0,&
  1080. 0,&
  1081. dw_child.Object.ow_wfjgmx_out_plancode[i],&
  1082. dw_child.Object.u_mtrldef_mtrlcode[i],&
  1083. dw_child.Object.ow_wfjgmx_out_status[i],&
  1084. dw_child.Object.ow_wfjgmx_out_woodcode[i],&
  1085. dw_child.Object.ow_wfjgmx_out_pcode[i],&
  1086. dw_child.Object.ow_wfjgmx_out_fprice[i],&
  1087. dw_child.Object.ow_wfjgmx_out_rebate[i],&
  1088. dw_child.Object.ow_wfjgmx_out_olmtrlid[i],&
  1089. dw_child.Object.ow_wfjgmx_out_rate[i],'','') = 0 THEN
  1090. MessageBox('error!',arg_msg)
  1091. RETURN
  1092. END IF
  1093. END IF
  1094. NEXT
  1095. IF uo_ware.Save(TRUE,arg_msg) = 0 THEN
  1096. MessageBox('error!',arg_msg)
  1097. RETURN
  1098. END IF
  1099. MessageBox(publ_operator,'保存操作成功!')
  1100. Long ll_row
  1101. ll_row = dw_pageretr.GetRow()
  1102. dw_pageretr.SelectRow(0,FALSE)
  1103. dw_pageretr.SelectRow(ll_row,TRUE)
  1104. wf_refresh_curuc(cur_scid,uo_ware.outwareid)
  1105. ELSE
  1106. IF uo_ware.newbegin(cur_scid,9,arg_msg) = 0 THEN
  1107. MessageBox('error!',arg_msg)
  1108. RETURN
  1109. END IF
  1110. END IF
  1111. CALL SUPER::Clicked
  1112. //read ini
  1113. IF dw_edit_mode THEN
  1114. PARENT.TriggerEvent("insert_childrow")
  1115. dw_uc.SetRedraw(FALSE)
  1116. dw_uc.SetColumn("u_spt_code")
  1117. dw_uc.SetRedraw(TRUE)
  1118. cur_editfocus = 1
  1119. ELSE
  1120. PARENT.TriggerEvent("retrieve_childdw")
  1121. cur_editfocus = 0
  1122. IF cbx_1.Checked THEN cb_add.TriggerEvent(Clicked!)
  1123. END IF
  1124. //
  1125. end event
  1126. type cb_edit from w_publ_1ton_share_detail`cb_edit within w_wfjg_py
  1127. end type
  1128. event cb_edit::clicked;IF NOT f_power_ind(1417) THEN
  1129. MessageBox(publ_operator,'你没有使用权限!')
  1130. RETURN
  1131. END IF
  1132. String arg_msg = ''
  1133. Long uc_row
  1134. uc_row = dw_pageretr.GetRow()
  1135. IF uc_row <= 0 THEN
  1136. MessageBox('系统提示','请选定当前目标单据!')
  1137. RETURN
  1138. END IF
  1139. IF NOT dw_edit_mode THEN
  1140. IF uo_ware.updatebegin(dw_pageretr.Object.ow_wfjg_out_scid[uc_row],dw_pageretr.Object.ow_wfjg_out_outwareid[uc_row],9,arg_msg) = 0 THEN
  1141. MessageBox('Error!',arg_msg)
  1142. RETURN
  1143. END IF
  1144. wf_refresh_curuc(dw_pageretr.Object.ow_wfjg_out_scid[uc_row],dw_pageretr.Object.ow_wfjg_out_outwareid[uc_row])
  1145. PARENT.TriggerEvent("retrieve_childdw")
  1146. END IF
  1147. CALL SUPER::Clicked
  1148. IF dw_edit_mode THEN
  1149. cur_editfocus = 2
  1150. ELSE
  1151. cur_editfocus = 0
  1152. END IF
  1153. end event
  1154. type cb_delet from w_publ_1ton_share_detail`cb_delet within w_wfjg_py
  1155. end type
  1156. event cb_delet::clicked;IF NOT f_power_ind(1418) THEN
  1157. MessageBox(publ_operator,'你没有使用权限!')
  1158. RETURN
  1159. END IF
  1160. IF dw_edit_mode THEN RETURN
  1161. String arg_msg = ''
  1162. Long uc_row
  1163. uc_row = dw_pageretr.GetRow()
  1164. IF uc_row <= 0 THEN
  1165. MessageBox('系统提示','请选定当前目标单据!')
  1166. RETURN
  1167. END IF
  1168. IF MessageBox ("IF","是否确定要删除当前单据吗?",Question!,YesNo! ) = 2 THEN RETURN
  1169. IF uo_ware.del(dw_pageretr.Object.ow_wfjg_out_scid[uc_row],dw_pageretr.Object.ow_wfjg_out_outwareid[uc_row],arg_msg,TRUE) = 0 THEN
  1170. MessageBox('Error!',arg_msg)
  1171. ELSE
  1172. //日志
  1173. Long ls_id
  1174. String ls_code
  1175. ls_id = dw_pageretr.Object.ow_wfjg_out_outwareid[uc_row]
  1176. ls_code = dw_pageretr.Object.ow_wfjg_out_outwarecode[uc_row]
  1177. f_setsysoplog('外协商盘盈单','外协商盘盈单删除,ID:'+String(ls_id)+',code:'+ls_code,arg_msg,TRUE)
  1178. //--
  1179. MessageBox(publ_operator,'删除单据'+String(dw_pageretr.Object.ow_wfjg_out_outwarecode[uc_row])+'成功!')
  1180. dw_pageretr.DeleteRow(uc_row)
  1181. dw_pageretr.TriggerEvent(RowFocusChanged!)
  1182. END IF
  1183. end event
  1184. type cb_addzy from w_publ_1ton_share_detail`cb_addzy within w_wfjg_py
  1185. end type
  1186. event cb_addzy::clicked;call super::clicked;m_Dfc_Control_PopupMenu dmPopupMenu
  1187. string menustr
  1188. menustr="Text=增加备注~tEvent=ue_addzy"
  1189. if len(trim(menustr))<>0 then
  1190. dmPopupMenu = Create m_Dfc_Control_PopupMenu
  1191. dmPopupMenu.mf_BuildMenu(This, menustr)
  1192. dmPopupMenu.mf_PopMenu()
  1193. Destroy dmPopupMenu
  1194. end if
  1195. end event
  1196. type cb_auditing from w_publ_1ton_share_detail`cb_auditing within w_wfjg_py
  1197. end type
  1198. event cb_auditing::clicked;call super::clicked;IF NOT f_power_ind(1419) THEN
  1199. MessageBox(publ_operator,'你没有使用权限!')
  1200. RETURN
  1201. END IF
  1202. IF dw_edit_mode THEN RETURN
  1203. String arg_msg = ''
  1204. Long pagerert_row
  1205. pagerert_row = dw_pageretr.GetRow()
  1206. IF pagerert_row <= 0 THEN
  1207. MessageBox('系统提示','请选定当前目标单据!')
  1208. RETURN
  1209. END IF
  1210. IF MessageBox ("IF","是否确定要审核当前单据吗?",Question!,YesNo! ) = 2 THEN RETURN
  1211. IF uo_ware.getinfo(dw_pageretr.Object.ow_wfjg_out_scid[pagerert_row],dw_pageretr.Object.ow_wfjg_out_outwareid[pagerert_row],arg_msg) = 0 THEN
  1212. MessageBox('Error!',arg_msg)
  1213. RETURN
  1214. END IF
  1215. IF uo_ware.auditing(TRUE,arg_msg) = 0 THEN
  1216. MessageBox('Error!',arg_msg)
  1217. ELSE
  1218. MessageBox(publ_operator,'审核成功!')
  1219. wf_refresh_curuc(dw_pageretr.Object.ow_wfjg_out_scid[pagerert_row],dw_pageretr.Object.ow_wfjg_out_outwareid[pagerert_row])
  1220. END IF
  1221. end event
  1222. type cb_xm from w_publ_1ton_share_detail`cb_xm within w_wfjg_py
  1223. end type
  1224. event cb_xm::clicked;is_mx_menustr = ''
  1225. is_mx_menustr = is_mx_menustr + "|" + "Text=按转换率计算库存数量~tEvent=ue_cmp_qty"
  1226. is_mx_menustr = is_mx_menustr + "|" + "Text=按转换率计算计价数量~tEvent=ue_cmp_uqty"
  1227. call super::clicked
  1228. end event
  1229. type cb_retrieve from w_publ_1ton_share_detail`cb_retrieve within w_wfjg_py
  1230. end type
  1231. type cb_xls from w_publ_1ton_share_detail`cb_xls within w_wfjg_py
  1232. end type
  1233. type cb_help from w_publ_1ton_share_detail`cb_help within w_wfjg_py
  1234. end type
  1235. type cb_auditing_cancel from w_publ_1ton_share_detail`cb_auditing_cancel within w_wfjg_py
  1236. end type
  1237. event cb_auditing_cancel::clicked;call super::clicked;IF NOT f_power_ind(1420) THEN
  1238. MessageBox(publ_operator,'你没有使用权限!')
  1239. RETURN
  1240. END IF
  1241. IF dw_edit_mode THEN RETURN
  1242. String arg_msg = ''
  1243. Long pagerert_row
  1244. pagerert_row = dw_pageretr.GetRow()
  1245. IF pagerert_row <= 0 THEN
  1246. MessageBox('系统提示','请选定当前目标单据!')
  1247. RETURN
  1248. END IF
  1249. IF MessageBox ("IF","是否确定要撤消审核当前单据吗?",Question!,YesNo! ) = 2 THEN RETURN
  1250. IF uo_ware.getinfo(dw_pageretr.Object.ow_wfjg_out_scid[pagerert_row],dw_pageretr.Object.ow_wfjg_out_outwareid[pagerert_row],arg_msg) = 0 THEN
  1251. MessageBox('Error!',arg_msg)
  1252. RETURN
  1253. END IF
  1254. IF uo_ware.c_auditing(TRUE,arg_msg) = 0 THEN
  1255. MessageBox('Error!',arg_msg)
  1256. ELSE
  1257. MessageBox(publ_operator,'撤消审核成功!')
  1258. //日志
  1259. String ls_code,ls_opemp,ls_outpart
  1260. ls_code = dw_pageretr.Object.ow_wfjg_out_outwarecode[pagerert_row]
  1261. ls_opemp = dw_pageretr.Object.ow_wfjg_out_opemp[pagerert_row]
  1262. ls_outpart = dw_pageretr.Object.ow_wfjg_out_part[pagerert_row]
  1263. f_setsysoplog('外协商盘盈单','撤审'+',code:'+ls_code+',相关号码:'+ls_outpart+',建立人:'+ls_opemp,arg_msg,TRUE)
  1264. //--
  1265. wf_refresh_curuc(dw_pageretr.Object.ow_wfjg_out_scid[pagerert_row],dw_pageretr.Object.ow_wfjg_out_outwareid[pagerert_row])
  1266. END IF
  1267. end event
  1268. type p_msg from w_publ_1ton_share_detail`p_msg within w_wfjg_py
  1269. end type
  1270. type p_help from w_publ_1ton_share_detail`p_help within w_wfjg_py
  1271. end type
  1272. type p_encl from w_publ_1ton_share_detail`p_encl within w_wfjg_py
  1273. end type
  1274. type p_other from w_publ_1ton_share_detail`p_other within w_wfjg_py
  1275. end type
  1276. type gb_3 from w_publ_1ton_share_detail`gb_3 within w_wfjg_py
  1277. end type
  1278. type ln_bar from w_publ_1ton_share_detail`ln_bar within w_wfjg_py
  1279. end type
  1280. type ln_bar2 from w_publ_1ton_share_detail`ln_bar2 within w_wfjg_py
  1281. end type
  1282. type r_bar from w_publ_1ton_share_detail`r_bar within w_wfjg_py
  1283. end type
  1284. type ln_1 from w_publ_1ton_share_detail`ln_1 within w_wfjg_py
  1285. end type
  1286. type ln_2 from w_publ_1ton_share_detail`ln_2 within w_wfjg_py
  1287. end type
  1288. type ddlb_status from dropdownlistbox within w_wfjg_py
  1289. integer x = 1600
  1290. integer y = 188
  1291. integer width = 320
  1292. integer height = 300
  1293. integer taborder = 30
  1294. boolean bringtotop = true
  1295. integer textsize = -9
  1296. integer weight = 400
  1297. fontcharset fontcharset = gb2312charset!
  1298. fontpitch fontpitch = variable!
  1299. string facename = "宋体"
  1300. long textcolor = 33554432
  1301. string text = "[全部]"
  1302. boolean sorted = false
  1303. string item[] = {"[全部]","待审核","已审核"}
  1304. borderstyle borderstyle = stylelowered!
  1305. end type
  1306. event selectionchanged;if index=1 then
  1307. cur_flag=-1
  1308. elseif index=2 then
  1309. cur_flag= 0
  1310. elseif index=3 then
  1311. cur_flag= 1
  1312. end if
  1313. parent.triggerevent("retrieve_pageretr")
  1314. end event
  1315. type st_2 from statictext within w_wfjg_py
  1316. integer x = 1449
  1317. integer y = 204
  1318. integer width = 137
  1319. integer height = 48
  1320. integer textsize = -9
  1321. integer weight = 400
  1322. fontcharset fontcharset = gb2312charset!
  1323. fontpitch fontpitch = variable!
  1324. string facename = "宋体"
  1325. long textcolor = 33554432
  1326. long backcolor = 134217739
  1327. string text = "状态"
  1328. alignment alignment = right!
  1329. boolean focusrectangle = false
  1330. end type
  1331. type st_3 from statictext within w_wfjg_py
  1332. integer x = 754
  1333. integer y = 204
  1334. integer width = 137
  1335. integer height = 48
  1336. boolean bringtotop = true
  1337. integer textsize = -9
  1338. integer weight = 400
  1339. fontcharset fontcharset = gb2312charset!
  1340. fontpitch fontpitch = variable!
  1341. string facename = "宋体"
  1342. long textcolor = 33554432
  1343. long backcolor = 134217739
  1344. string text = "分部"
  1345. alignment alignment = right!
  1346. boolean focusrectangle = false
  1347. end type
  1348. type ddlb_scid from uo_ddlb_scid within w_wfjg_py
  1349. integer x = 905
  1350. integer y = 188
  1351. integer width = 549
  1352. integer height = 1120
  1353. boolean bringtotop = true
  1354. end type
  1355. event constructor;call super::constructor;cur_scid=this.uo_scid
  1356. end event
  1357. event selectionchanged;call super::selectionchanged;cur_scid=this.uo_scid
  1358. parent.triggerevent("retrieve_pageretr")
  1359. end event
  1360. type cbx_1 from checkbox within w_wfjg_py
  1361. integer x = 1952
  1362. integer y = 204
  1363. integer width = 457
  1364. integer height = 52
  1365. boolean bringtotop = true
  1366. integer textsize = -9
  1367. integer weight = 400
  1368. fontcharset fontcharset = gb2312charset!
  1369. fontpitch fontpitch = variable!
  1370. string facename = "宋体"
  1371. long textcolor = 33554432
  1372. long backcolor = 134217739
  1373. string text = "保存自动新建"
  1374. end type
  1375. event constructor;int li_auto
  1376. li_auto =long(ProfileString(SYS_INIFILENAME, "outware_wfjg", "auto_add", string(0)))
  1377. if li_auto = 1 then
  1378. cbx_1.checked = true
  1379. else
  1380. cbx_1.checked = false
  1381. end if
  1382. end event
  1383. type cbx_cmpl from checkbox within w_wfjg_py
  1384. integer x = 2514
  1385. integer y = 204
  1386. integer width = 576
  1387. integer height = 52
  1388. boolean bringtotop = true
  1389. integer textsize = -9
  1390. integer weight = 400
  1391. fontcharset fontcharset = gb2312charset!
  1392. fontpitch fontpitch = variable!
  1393. string facename = "宋体"
  1394. long textcolor = 33554432
  1395. long backcolor = 134217739
  1396. boolean enabled = false
  1397. string text = "外协件自动计成本价"
  1398. end type
  1399. event clicked;Int use_cmpl
  1400. IF THIS.Checked THEN
  1401. use_cmpl = 1
  1402. ELSE
  1403. use_cmpl = 0
  1404. END IF
  1405. SetProfileString (sys_inifilename,dw_pageretr.DataObject, "use_cmpl", String(use_cmpl))
  1406. end event
  1407. event constructor;Int use_cmpl
  1408. use_cmpl = Integer(ProfileString (sys_inifilename,dw_pageretr.DataObject, "use_cmpl", '0'))
  1409. IF use_cmpl = 0 THEN
  1410. THIS.Checked = FALSE
  1411. ELSE
  1412. THIS.Checked = TRUE
  1413. END IF
  1414. end event
  1415. type cb_cmpl from commandbutton within w_wfjg_py
  1416. integer x = 3118
  1417. integer y = 192
  1418. integer width = 206
  1419. integer height = 72
  1420. integer taborder = 70
  1421. boolean bringtotop = true
  1422. integer textsize = -9
  1423. integer weight = 400
  1424. fontcharset fontcharset = gb2312charset!
  1425. fontpitch fontpitch = variable!
  1426. string facename = "宋体"
  1427. boolean enabled = false
  1428. string text = "计算"
  1429. end type
  1430. event clicked;Long ll_i,ll_mtrlid,ll_scid
  1431. String ls_mtrlcode,ls_pfcode,arg_msg
  1432. Decimal ld_price,ld_mprice,ld_outcost,ld_wagecost
  1433. dw_uc.AcceptText()
  1434. Long ll_row
  1435. ll_row = dw_uc.GetRow()
  1436. IF ll_row <= 0 THEN
  1437. MessageBox('系统提示','请选择单据')
  1438. RETURN
  1439. END IF
  1440. IF dw_uc.Object.ow_wfjg_out_outwareid[ll_row] = 0 THEN
  1441. ll_scid = cur_scid
  1442. ELSE
  1443. ll_scid = dw_uc.Object.ow_wfjg_out_scid[ll_row]
  1444. END IF
  1445. uo_cmplcost uo_cmpl
  1446. uo_cmpl = CREATE uo_cmplcost
  1447. dw_child.AcceptText()
  1448. FOR ll_i = 1 TO dw_child.RowCount()
  1449. ld_price = 0
  1450. ld_mprice = 0
  1451. ld_outcost = 0
  1452. uo_cmpl.deep = 0
  1453. ll_mtrlid = dw_child.Object.ow_wfjgmx_out_mtrlid[ll_i]
  1454. ls_mtrlcode = dw_child.Object.u_mtrldef_mtrlcode[ll_i]
  1455. ls_pfcode = f_get_dft_pf(ll_mtrlid)
  1456. IF ls_pfcode = '' THEN
  1457. MessageBox('提示','查询物料:'+ls_mtrlcode+'默认BOM失败,'+arg_msg)
  1458. RETURN
  1459. END IF
  1460. IF uo_cmpl.uof_get_cost(ll_scid,ll_mtrlid,ls_mtrlcode,ls_pfcode,1,1,ld_price,ld_mprice,ld_outcost,ld_wagecost,arg_msg) = 0 THEN
  1461. MessageBox('提示','取物料:'+ls_mtrlcode+'单价失败'+arg_msg)
  1462. RETURN
  1463. END IF
  1464. dw_child.Object.ow_wfjgmx_out_fprice[ll_i] = ld_price + ld_mprice + ld_outcost
  1465. NEXT
  1466. DESTROY uo_cmpl
  1467. end event