w_saletask_sc.srw 72 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518
  1. $PBExportHeader$w_saletask_sc.srw
  2. forward
  3. global type w_saletask_sc from w_publ_1ton_share_detail
  4. end type
  5. type ddlb_retrstatus from dropdownlistbox within w_saletask_sc
  6. end type
  7. type ddlb_scid from uo_ddlb_scid within w_saletask_sc
  8. end type
  9. type st_2 from statictext within w_saletask_sc
  10. end type
  11. type st_3 from statictext within w_saletask_sc
  12. end type
  13. end forward
  14. global type w_saletask_sc from w_publ_1ton_share_detail
  15. integer height = 2480
  16. string title = "销售排产打印单"
  17. boolean maxbox = true
  18. windowstate windowstate = maximized!
  19. long dw_pageretr_w = 52828948
  20. long dw_child_h = 34912024
  21. long dw_child_w = 34817496
  22. event insert_childrow ( )
  23. event ue_tempstoptask ( )
  24. event ue_stopsaletask ( )
  25. event ue_finishtask ( )
  26. event ue_importseleprice ( )
  27. event ue_ctempstoptask ( )
  28. event ue_importcusseleprice ( )
  29. event ue_importcusseleprice_his ( )
  30. event ue_fj_edit ( )
  31. event ue_fj_view ( )
  32. event ue_f13 ( )
  33. event ue_f14 ( )
  34. ddlb_retrstatus ddlb_retrstatus
  35. ddlb_scid ddlb_scid
  36. st_2 st_2
  37. st_3 st_3
  38. end type
  39. global w_saletask_sc w_saletask_sc
  40. type variables
  41. int cur_status=0 //当前查询订单状态// -1 所有
  42. uo_saletask obj_saletask
  43. long cur_scid
  44. long cur_scid_arr[]
  45. uo_cusprice uo_cus_price
  46. end variables
  47. forward prototypes
  48. public function integer wf_cusdetail ()
  49. public function integer wf_statusbtn_fc ()
  50. public function integer wf_refresh_curuc (long arg_scid, long arg_taskid)
  51. public subroutine wf_check_billfj ()
  52. 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)
  53. end prototypes
  54. event insert_childrow();long li_row
  55. li_row=dw_child.insertrow(0)
  56. dw_child.scrolltorow(li_row)
  57. dw_child.SetColumn ('u_saletaskmx_outtype')
  58. end event
  59. event ue_tempstoptask();//IF dw_edit_mode THEN
  60. // MessageBox('系统提示',"编辑状态下不可以使用!")
  61. // return
  62. //END IF
  63. //
  64. //if not f_power_ind(9) then
  65. // messagebox(publ_operator,'你没有使用权限!')
  66. // return
  67. //end if
  68. //
  69. //string arg_msg=''
  70. //long pagerert_row
  71. //
  72. //pagerert_row=dw_pageretr.getrow()
  73. //if pagerert_row<=0 then
  74. // messagebox('系统提示','请选定当前目标订单!')
  75. // return
  76. //end if
  77. //IF MessageBox ("IF","是否确定要对当前订单作暂停操作吗?",Question!,YesNo! ) = 2 THEN RETURN
  78. //
  79. //if obj_saletask.tempstoptask(dw_pageretr.Object.u_saletask_scid[pagerert_row],dw_pageretr.object.taskid[pagerert_row],arg_msg,true)=0 then
  80. // messagebox('Error!',arg_msg)
  81. //ELSE
  82. // messagebox(publ_operator,"订单作暂停操作成功!")
  83. // if cur_status <> -1 then
  84. // dw_uc.deleterow(pagerert_row)
  85. // else
  86. // wf_refresh_curuc(dw_pageretr.Object.u_saletask_scid[pagerert_row],dw_pageretr.object.taskid[pagerert_row])
  87. // end if
  88. //end if
  89. end event
  90. event ue_stopsaletask();//IF dw_edit_mode THEN
  91. // MessageBox('系统提示',"编辑状态下不可以使用!")
  92. // return
  93. //END IF
  94. //
  95. //IF NOT f_power_ind(10) THEN
  96. // MessageBox(publ_operator,'你没有使用权限!')
  97. // RETURN
  98. //END IF
  99. //
  100. //String arg_msg = ''
  101. //Long pagerert_row
  102. //
  103. //pagerert_row = dw_pageretr.GetRow()
  104. //IF pagerert_row <= 0 THEN
  105. // MessageBox('系统提示','请选定当前目标订单!')
  106. // RETURN
  107. //END IF
  108. //IF MessageBox ("警告","是否确定要对当前订单作终止吗? (终止后订单将归档只读)",Question!,YesNo! ) = 2 THEN RETURN
  109. //
  110. //
  111. //IF obj_saletask.stopsaletask(dw_pageretr.Object.u_saletask_scid[pagerert_row],dw_pageretr.Object.taskid[pagerert_row],arg_msg,TRUE) = 0 THEN
  112. // MessageBox('Error!',arg_msg)
  113. //ELSE
  114. // MessageBox(publ_operator,'订单终止操作成功!')
  115. // IF cur_status <> -1 THEN
  116. // dw_uc.DeleteRow(pagerert_row)
  117. // ELSE
  118. // wf_refresh_curuc(dw_pageretr.Object.u_saletask_scid[pagerert_row],dw_pageretr.Object.taskid[pagerert_row])
  119. // END IF
  120. //END IF
  121. //
  122. end event
  123. event ue_finishtask();//IF dw_edit_mode THEN
  124. // MessageBox('系统提示',"编辑状态下不可以使用!")
  125. // RETURN
  126. //END IF
  127. //
  128. //IF NOT f_power_ind(10) THEN
  129. // MessageBox(publ_operator,'你没有使用权限!')
  130. // RETURN
  131. //END IF
  132. //
  133. //String arg_msg = ''
  134. //Long pagerert_row
  135. //
  136. //pagerert_row = dw_pageretr.GetRow()
  137. //IF pagerert_row <= 0 THEN
  138. // MessageBox('系统提示','请选定当前目标销售订单!')
  139. // RETURN
  140. //END IF
  141. //IF MessageBox ("警告","是否确定要对当前销售订单作完成吗? (完成后销售订单将归档只读)",Question!,YesNo! ) = 2 THEN RETURN
  142. //
  143. //
  144. //Long ls_taskid
  145. //ls_taskid = dw_pageretr.Object.taskid[pagerert_row]
  146. //
  147. //IF obj_saletask.finishtask(dw_pageretr.Object.u_saletask_scid[pagerert_row],ls_taskid,arg_msg,TRUE) = 0 THEN
  148. // MessageBox('Error!',arg_msg)
  149. //ELSE
  150. // MessageBox(publ_operator,'销售订单完成操作成功!')
  151. // IF cur_status <> -1 THEN
  152. // dw_uc.DeleteRow(pagerert_row)
  153. // ELSE
  154. // wf_refresh_curuc(dw_pageretr.Object.u_saletask_scid[pagerert_row],dw_pageretr.Object.taskid[pagerert_row])
  155. // END IF
  156. //END IF
  157. //
  158. //
  159. end event
  160. event ue_importseleprice();//IF NOT dw_edit_mode THEN
  161. // MessageBox('系统提示',"非编辑状态下不可以使用!")
  162. // RETURN
  163. //END IF
  164. //
  165. //Long ls_row,ls_cusid,ls_mtrlid
  166. //String ls_cuscode,ls_cusname,arg_msg
  167. //Long uc_row
  168. //Decimal obj_price ,obj_rebate
  169. //String err_str = ''
  170. //Boolean if_exist_price = TRUE
  171. //Long ls_pricelistid,ll_moneyid
  172. //String ls_status,ls_pcode,ls_woodcode,ls_unit
  173. //s_pricelist_ch s_pricelist
  174. //
  175. //ll_moneyid = dw_uc.Object.u_saletask_moneyid[dw_uc.GetRow()]
  176. //IF ll_moneyid = 0 OR IsNull(ll_moneyid) THEN
  177. // MessageBox(publ_operator,'请先选择币种')
  178. // RETURN
  179. //END IF
  180. //
  181. ////直接查询价格表
  182. //// IF MessageBox (publ_operator,"是否直接选择价格表?",Question!,YesNo! ) = 2 THEN RETURN
  183. //
  184. //Open(w_sale_price_list_ch)
  185. //s_pricelist = Message.PowerObjectParm
  186. //IF s_pricelist.pricelistid <= 0 THEN RETURN
  187. //FOR ls_row = 1 TO dw_child.RowCount()
  188. // ls_mtrlid = dw_child.Object.mtrlid[ls_row]
  189. // ls_status = dw_child.Object.u_saletaskmx_status[ls_row]
  190. // ls_pcode = dw_child.Object.u_saletaskmx_pcode[ls_row]
  191. // ls_woodcode = dw_child.Object.u_saletaskmx_woodcode[ls_row]
  192. // ls_unit = dw_child.Object.u_saletaskmx_unit[ls_row]
  193. //
  194. // IF sys_option_price_if_status = 0 THEN
  195. // ls_status = ''
  196. // ls_pcode = ''
  197. // ls_woodcode = ''
  198. // END IF
  199. //
  200. //
  201. // SELECT u_sale_price_mx.price
  202. // INTO :obj_price
  203. // FROM u_sale_price_mx
  204. // WHERE (u_sale_price_mx.pricelistid = :s_pricelist.pricelistid) AND
  205. // ( u_sale_price_mx.mtrlid = :ls_mtrlid ) AND
  206. // ( u_sale_price_mx.status = :ls_status ) AND
  207. // ( u_sale_price_mx.pcode = :ls_pcode ) AND
  208. // ( u_sale_price_mx.woodcode = :ls_woodcode ) AND
  209. // ( u_sale_price_mx.unit = :ls_unit );
  210. // IF sqlca.SQLCode <> 0 THEN
  211. // err_str = err_str + "当前价格表的 "+String(dw_child.Object.mtrlname[ls_row])+" 的计划售价尚未设定! ~n"
  212. // ELSE
  213. // dw_child.Object.u_saletaskmx_enprice[ls_row] = obj_price
  214. // END IF
  215. //NEXT
  216. //
  217. //
  218. //IF err_str <> '' THEN
  219. // MessageBox('系统提示',err_str)
  220. //END IF
  221. //
  222. end event
  223. event ue_ctempstoptask();//IF dw_edit_mode THEN
  224. // MessageBox('系统提示',"编辑状态下不可以使用!")
  225. // RETURN
  226. //END IF
  227. //
  228. //IF NOT f_power_ind(9) THEN
  229. // MessageBox(publ_operator,'你没有使用权限!')
  230. // RETURN
  231. //END IF
  232. //
  233. //String arg_msg = ''
  234. //Long pagerert_row
  235. //
  236. //pagerert_row = dw_pageretr.GetRow()
  237. //IF pagerert_row <= 0 THEN
  238. // MessageBox('系统提示','请选定当前目标订单!')
  239. // RETURN
  240. //END IF
  241. //IF MessageBox ("IF","是否确定要对当前订单作取消暂停操作吗?",Question!,YesNo! ) = 2 THEN RETURN
  242. //
  243. //IF obj_saletask.tempstoptask(dw_pageretr.Object.u_saletask_scid[pagerert_row],dw_pageretr.Object.taskid[pagerert_row],arg_msg,TRUE) = 0 THEN
  244. // MessageBox('Error!',arg_msg)
  245. //ELSE
  246. // MessageBox(publ_operator,"订单作取消暂停操作成功!")
  247. // IF cur_status <> -1 THEN
  248. // dw_uc.DeleteRow(pagerert_row)
  249. // ELSE
  250. // wf_refresh_curuc(dw_pageretr.Object.u_saletask_scid[pagerert_row],dw_pageretr.Object.taskid[pagerert_row])
  251. // END IF
  252. //END IF
  253. //
  254. end event
  255. event ue_importcusseleprice();////查询客户价格表
  256. ////如果客户无价格表则提示是否直接查询价格表
  257. //Long ls_row,ls_cusid,ls_mtrlid
  258. //String ls_cuscode,ls_cusname,arg_msg
  259. //Long uc_row
  260. //Decimal obj_price ,obj_rebate
  261. //String err_str = ''
  262. //Boolean if_exist_price = TRUE
  263. //Long ls_pricelistid,ll_moneyid
  264. //String ls_status,ls_pcode,ls_woodcode,ls_unit
  265. //s_pricelist_ch s_pricelist
  266. //
  267. //uc_row = dw_uc.GetRow()
  268. //
  269. //ll_moneyid = dw_uc.Object.u_saletask_moneyid[dw_uc.GetRow()]
  270. //
  271. //IF ll_moneyid = 0 OR IsNull(ll_moneyid) THEN
  272. // MessageBox(publ_operator,'请先选择币种')
  273. // RETURN
  274. //END IF
  275. //
  276. //IF dw_uc.Object.cusid[uc_row] = 0 OR IsNull(dw_uc.Object.cusid[uc_row]) THEN
  277. // MessageBox('系统提示',"请选择销售客户!")
  278. // RETURN
  279. //END IF
  280. //
  281. //ls_cusid = dw_uc.Object.cusid[uc_row]
  282. //
  283. //SELECT u_cust.pricelistid INTO :ls_pricelistid FROM u_cust Where u_cust.cusid = :ls_cusid;
  284. //IF sqlca.SQLCode <> 0 OR ls_pricelistid <= 0 THEN
  285. // if_exist_price = FALSE
  286. //END IF
  287. //
  288. //
  289. //IF if_exist_price = FALSE THEN
  290. // IF MessageBox('系统提示',"当前客户的计划售价尚未设定!是否查询价格列表?",Question!,YesNo!) = 2 THEN RETURN
  291. // Open(w_sale_price_list_ch)
  292. // s_pricelist = Message.PowerObjectParm
  293. // IF s_pricelist.pricelistid <= 0 THEN RETURN
  294. //END IF
  295. //
  296. //FOR ls_row = 1 TO dw_child.RowCount()
  297. //
  298. // ls_mtrlid = dw_child.Object.mtrlid[ls_row]
  299. // ls_status = dw_child.Object.u_saletaskmx_status[ls_row]
  300. // ls_pcode = dw_child.Object.u_saletaskmx_pcode[ls_row]
  301. // ls_woodcode = dw_child.Object.u_saletaskmx_woodcode[ls_row]
  302. // ls_unit = dw_child.Object.u_saletaskmx_unit[ls_row]
  303. //
  304. // IF sys_option_price_if_status = 0 THEN
  305. // ls_status = ''
  306. // ls_pcode = ''
  307. // ls_woodcode = ''
  308. // END IF
  309. //
  310. // IF if_exist_price THEN //查询客户价格表
  311. // IF Not (IsNull(ls_mtrlid) OR ls_mtrlid = 0 ) THEN
  312. // SELECT u_sale_price_mx.price
  313. // INTO :obj_price
  314. // FROM u_sale_price_list ,u_cust,u_sale_price_mx
  315. // WHERE (u_sale_price_list.pricelistid = u_cust.pricelistid) AND
  316. // (u_sale_price_mx.pricelistid = u_sale_price_list.pricelistid) AND
  317. // ( u_sale_price_mx.mtrlid = :ls_mtrlid ) AND
  318. // ( u_cust.cusid = :ls_cusid ) AND
  319. // ( u_sale_price_mx.status = :ls_status ) AND
  320. // ( u_sale_price_mx.pcode = :ls_pcode ) AND
  321. // ( u_sale_price_mx.woodcode = :ls_woodcode ) and
  322. // ( u_sale_price_list.moneyid=:ll_moneyid ) and
  323. // ( u_sale_price_mx.unit =:ls_unit );
  324. // IF sqlca.SQLCode <> 0 THEN
  325. // err_str = err_str + "当前客户的 "+String(dw_child.Object.mtrlname[ls_row])+" 的计划售价尚未设定! ~n"
  326. // ELSE
  327. // dw_child.Object.u_saletaskmx_enprice[ls_row] = obj_price
  328. // END IF
  329. // END IF
  330. // ELSE //查询价格列表
  331. // SELECT u_sale_price_mx.price
  332. // INTO :obj_price
  333. // FROM u_sale_price_mx
  334. // WHERE ( u_sale_price_mx.pricelistid = :s_pricelist.pricelistid ) AND
  335. // ( u_sale_price_mx.mtrlid = :ls_mtrlid ) AND
  336. // ( u_sale_price_mx.status = :ls_status ) AND
  337. // ( u_sale_price_mx.pcode = :ls_pcode ) AND
  338. // ( u_sale_price_mx.woodcode = :ls_woodcode ) AND
  339. // ( u_sale_price_mx.unit = :ls_unit );
  340. // IF sqlca.SQLCode <> 0 THEN
  341. // err_str = err_str + "当前价格表的 "+String(dw_child.Object.mtrlname[ls_row])+" 的计划售价尚未设定! ~n"
  342. // ELSE
  343. // dw_child.Object.u_saletaskmx_enprice[ls_row] = obj_price
  344. // END IF
  345. // END IF
  346. //NEXT
  347. //IF err_str <> '' THEN
  348. // MessageBox('系统提示',err_str)
  349. //END IF
  350. //
  351. //
  352. //
  353. end event
  354. event ue_importcusseleprice_his();//// //导入客户历史售价
  355. //Long ls_row,ls_cusid,ls_mtrlid
  356. //String ls_cuscode,ls_cusname,arg_msg
  357. //Long uc_row
  358. //Decimal obj_price ,obj_rebate,obj_rate
  359. //String err_str = ''
  360. //Boolean if_exist_price = TRUE
  361. //Long ls_pricelistid,ll_moneyid
  362. //String ls_status,ls_pcode,ls_woodcode,ls_unit
  363. //s_pricelist_ch s_pricelist
  364. //uc_row = dw_uc.GetRow()
  365. //
  366. //ll_moneyid = dw_uc.Object.u_saletask_moneyid[dw_uc.GetRow()]
  367. //IF ll_moneyid = 0 OR IsNull(ll_moneyid) THEN
  368. // MessageBox(publ_operator,'请先选择币种')
  369. // RETURN
  370. //END IF
  371. //
  372. //IF dw_uc.Object.cusid[uc_row] = 0 OR IsNull(dw_uc.Object.cusid[uc_row]) THEN
  373. // MessageBox('系统提示',"请选择销售客户!")
  374. // RETURN
  375. //END IF
  376. //ls_cusid = dw_uc.Object.cusid[uc_row]
  377. //ls_cuscode = dw_uc.Object.u_cust_cuscode[uc_row]
  378. //ls_cusname = dw_uc.Object.u_cust_name[uc_row]
  379. //
  380. //IF dw_child.RowCount() <= 0 THEN
  381. // MessageBox('系统提示',"请选择产品!")
  382. // RETURN
  383. //END IF
  384. //
  385. //FOR ls_row = 1 TO dw_child.RowCount()
  386. // ls_mtrlid = dw_child.Object.mtrlid[ls_row]
  387. // ls_status = dw_child.Object.u_saletaskmx_status[ls_row]
  388. // ls_pcode = dw_child.Object.u_saletaskmx_pcode[ls_row]
  389. // ls_woodcode = dw_child.Object.u_saletaskmx_woodcode[ls_row]
  390. // ls_unit = dw_child.Object.u_saletaskmx_unit[ls_row]
  391. //
  392. // IF f_getmtrlcusprice(ll_moneyid,ls_mtrlid,ls_cusid,ls_unit,ls_woodcode,ls_status,ls_pcode,0,obj_price,obj_rebate,obj_rate,arg_msg) <> 1 THEN
  393. // err_str = err_str + "导入客户["+ls_cuscode+ls_cusname+"]的 "+String(dw_child.Object.mtrlname[ls_row])+" 的最新售价失败,或没有最新售价! ~n "
  394. // ELSE
  395. // dw_child.Object.u_saletaskmx_enprice[ls_row] = obj_price
  396. // dw_child.Object.u_saletaskmx_rebate[ls_row] = obj_rebate
  397. // dw_child.Object.u_saletaskmx_rate[ls_row] = obj_rate
  398. // END IF
  399. //NEXT
  400. //
  401. //
  402. //IF err_str <> '' THEN
  403. // MessageBox('系统提示',err_str)
  404. //END IF
  405. //
  406. end event
  407. event ue_fj_edit();IF dw_edit_mode THEN
  408. MessageBox('提示','编辑状态下不可用',information!,OK!)
  409. RETURN
  410. END IF
  411. //IF NOT f_power_ind(1098) THEN
  412. // MessageBox(publ_operator,'你没有使用权限!')
  413. // RETURN
  414. //END IF
  415. s_edit_index_tran s_pic
  416. Long ll_ConnectionID
  417. String arg_msg
  418. Long ls_row
  419. ls_row = dw_pageretr.GetRow()
  420. IF ls_row <= 0 THEN
  421. RETURN
  422. END IF
  423. IF f_get_outerconnection(ll_ConnectionID,arg_msg) = 0 THEN
  424. MessageBox('提示','没有指定附件数据库连接'+arg_msg,information!,OK!)
  425. RETURN
  426. END IF
  427. s_pic.f_long = 102 //销售订单的mainID
  428. s_pic.f_string = dw_pageretr.Object.taskcode[ls_row]
  429. s_pic.g_long = dw_pageretr.Object.taskid[ls_row]
  430. s_pic.e_long = dw_pageretr.Object.u_saletask_scid[ls_row]
  431. s_pic.sqltransaction = sys_filedb_sqlca
  432. OpenWithParm(w_fj_bill_mng,s_pic)
  433. wf_check_billfj()
  434. end event
  435. event ue_fj_view();IF dw_edit_mode THEN
  436. MessageBox('提示','编辑状态下不可用',information!,OK!)
  437. RETURN
  438. END IF
  439. s_edit_index_tran s_pic
  440. Long ll_ConnectionID
  441. String arg_msg
  442. Long ls_row
  443. ls_row = dw_pageretr.GetRow()
  444. IF ls_row <= 0 THEN
  445. RETURN
  446. END IF
  447. IF f_get_outerconnection(ll_ConnectionID,arg_msg) = 0 THEN
  448. MessageBox('提示','没有指定附件数据库连接'+arg_msg,information!,OK!)
  449. RETURN
  450. END IF
  451. s_pic.f_long = 102 //销售订单的mainID
  452. s_pic.f_string = dw_pageretr.Object.taskcode[ls_row]
  453. s_pic.g_long = dw_pageretr.Object.taskid[ls_row]
  454. s_pic.e_long = dw_pageretr.Object.u_saletask_scid[ls_row]
  455. s_pic.sqltransaction = sys_filedb_sqlca
  456. OpenWithParm(w_fj_bill_view,s_pic)
  457. end event
  458. event ue_f13();//s_view_dscrp s_view,s_return
  459. //String ls_dscrp
  460. //dw_uc.AcceptText()
  461. //
  462. //ls_dscrp = dw_uc.Object.dscrp[dw_uc.GetRow()]
  463. //s_view.Title = '销售订单备注'
  464. //s_view.dscrp = ls_dscrp
  465. //s_view.editmode = dw_edit_mode
  466. //OpenWithParm(w_view_dscrp,s_view)
  467. //IF dw_edit_mode THEN
  468. // s_return = Message.PowerObjectParm
  469. // dw_uc.Object.dscrp[dw_uc.GetRow()] = s_return.dscrp
  470. //END IF
  471. //
  472. //
  473. //
  474. //
  475. end event
  476. event ue_f14();//s_view_dscrp s_view,s_return
  477. //String ls_dscrp
  478. //dw_uc.AcceptText()
  479. //
  480. //ls_dscrp = dw_uc.Object.u_saletask_dscrp2[dw_uc.GetRow()]
  481. //s_view.Title = '销售订单辅助备注'
  482. //s_view.dscrp = ls_dscrp
  483. //s_view.editmode = dw_edit_mode
  484. //OpenWithParm(w_view_dscrp,s_view)
  485. //IF dw_edit_mode THEN
  486. // s_return = Message.PowerObjectParm
  487. // dw_uc.Object.u_saletask_dscrp2[dw_uc.GetRow()] = s_return.dscrp
  488. //END IF
  489. //
  490. //
  491. //
  492. //
  493. end event
  494. public function integer wf_cusdetail ();////wf_cusdetail
  495. //
  496. //long ls_row,ls_cusid
  497. //
  498. //ls_row=dw_uc.getrow()
  499. //if ls_row=0 then
  500. // messagebox('系统提示','没有选定当前行!')
  501. // if isvalid(w_cust_mtrlprice) then close(w_cust_mtrlprice)
  502. // return 0
  503. //else
  504. // ls_cusid=dw_uc.object.cusid[ls_row]
  505. // if isnull(ls_cusid) or ls_cusid<=0 then
  506. // messagebox('系统提示','没有选定当前客户,请在编辑状态双击或按F9选择客户!')
  507. // if isvalid(w_cust_mtrlprice) then close(w_cust_mtrlprice)
  508. // return 0
  509. // end if
  510. //end if
  511. //
  512. //if isvalid(w_cust_mtrlprice) then
  513. // Send(Handle(w_cust_mtrlprice), 274, 61728, 0)
  514. //else
  515. // open(w_cust_mtrlprice)
  516. //end if
  517. // w_cust_mtrlprice.wf_refresh(ls_cusid)
  518. //
  519. return 1
  520. end function
  521. public function integer wf_statusbtn_fc ();//wf_statusbtn_fc
  522. if dw_edit_mode then
  523. cb_auditing_cancel.enabled=false
  524. cb_auditing.enabled=false
  525. return 0
  526. end if
  527. long ls_row,status
  528. ls_row=dw_pageretr.getrow()
  529. if not ls_row>0 then
  530. cb_auditing_cancel.enabled=false
  531. cb_auditing.enabled=false
  532. return 0
  533. end if
  534. status=dw_pageretr.object.u_saletask_status[ls_row]
  535. CHOOSE CASE status
  536. CASE 0
  537. cb_auditing_cancel.enabled=false
  538. cb_auditing.enabled=true
  539. CASE 1
  540. cb_auditing_cancel.enabled=true
  541. cb_auditing.enabled=false
  542. CASE 2
  543. cb_auditing_cancel.enabled=false
  544. cb_auditing.enabled=false
  545. CASE 3
  546. cb_auditing_cancel.enabled=false
  547. cb_auditing.enabled=false
  548. CASE 4
  549. cb_auditing_cancel.enabled=false
  550. cb_auditing.enabled=false
  551. CASE 5
  552. cb_auditing_cancel.enabled=false
  553. cb_auditing.enabled=false
  554. CASE else
  555. cb_auditing_cancel.enabled=true
  556. cb_auditing.enabled=true
  557. END CHOOSE
  558. return 0
  559. end function
  560. public function integer wf_refresh_curuc (long arg_scid, long arg_taskid);//wf_refresh_curuc
  561. Int rslt = 1
  562. IF arg_taskid <= 0 OR IsNull(arg_taskid) THEN
  563. rslt = 0
  564. GOTO ext
  565. END IF
  566. Long uc_row
  567. uc_row = dw_pageretr.GetRow()
  568. IF uc_row <= 0 THEN
  569. rslt = 0
  570. GOTO ext
  571. END IF
  572. Int Kind
  573. DateTime requiredate
  574. String assign_emp
  575. String dscrp
  576. String dscrp2
  577. string paytype
  578. String taskcode
  579. Long cusid
  580. DateTime accomplishdate
  581. Int status
  582. String operator
  583. String permit_emp
  584. DateTime opdate
  585. String last_emp
  586. String u_cust_name
  587. String u_cust_cuscode
  588. long moneyid
  589. long banktypeid
  590. decimal mrate
  591. string relcode
  592. decimal damt
  593. decimal otheramt
  594. string cus_address
  595. string cus_tele
  596. string freight
  597. string cus_fax
  598. string freight_tele
  599. SELECT u_saletask.kind,
  600. u_saletask.requiredate,
  601. u_saletask.assign_emp,
  602. u_saletask.dscrp,
  603. u_saletask.dscrp2,
  604. u_saletask.paytype,
  605. u_saletask.taskcode,
  606. u_saletask.cusid,
  607. u_saletask.accomplishdate,
  608. u_saletask.status,
  609. u_saletask.opemp,
  610. u_saletask.permit_emp,
  611. u_saletask.opdate,
  612. u_cust.name,
  613. u_cust.cuscode,
  614. u_saletask.moneyid,
  615. u_saletask.banktypeid,
  616. u_saletask.mrate,
  617. u_saletask.relcode,
  618. u_saletask.damt,
  619. u_saletask.otheramt,
  620. u_saletask.cus_address,
  621. u_saletask.cus_tele,
  622. u_saletask.freight,
  623. u_saletask.cus_fax,
  624. u_saletask.freight_tele
  625. INTO :Kind,
  626. :requiredate,
  627. :assign_emp,
  628. :dscrp,
  629. :dscrp2,
  630. :paytype,
  631. :taskcode,
  632. :cusid,
  633. :accomplishdate,
  634. :status,
  635. :operator,
  636. :permit_emp,
  637. :opdate,
  638. :u_cust_name,
  639. :u_cust_cuscode,
  640. :moneyid,
  641. :banktypeid,
  642. :mrate,
  643. :relcode,
  644. :damt,
  645. :otheramt,
  646. :cus_address,
  647. :cus_tele,
  648. :freight,
  649. :cus_fax,
  650. :freight_tele
  651. FROM u_saletask left OUTER join
  652. u_cust on ( u_saletask.cusid = u_cust.cusid )
  653. WHERE ( u_saletask.taskid = :arg_taskid )
  654. AND ( scid = :arg_scid );
  655. IF sqlca.SQLCode <> 0 THEN
  656. MessageBox('错误',"查询操作失败(错误订单唯一码)",stopsign!,OK!)
  657. rslt = 0
  658. GOTO ext
  659. END IF
  660. dw_pageretr.Object.u_saletask_scid [uc_row] = arg_scid
  661. dw_pageretr.Object.taskid[uc_row] = arg_taskid
  662. dw_pageretr.Object.Kind[uc_row] = Kind
  663. dw_pageretr.Object.requiredate[uc_row] = requiredate
  664. dw_pageretr.Object.assign_emp[uc_row] = assign_emp
  665. dw_pageretr.Object.dscrp[uc_row] = dscrp
  666. dw_pageretr.Object.u_saletask_dscrp2[uc_row] = dscrp2
  667. dw_pageretr.Object.u_saletask_paytype[uc_row] = paytype
  668. dw_pageretr.Object.taskcode[uc_row] = taskcode
  669. dw_pageretr.Object.u_saletask_cusid[uc_row] = cusid
  670. dw_pageretr.Object.accomplishdate[uc_row] = accomplishdate
  671. dw_pageretr.Object.u_saletask_status[uc_row] = status
  672. dw_pageretr.Object.u_saletask_opemp[uc_row] = operator
  673. dw_pageretr.Object.permit_emp[uc_row] = permit_emp
  674. dw_pageretr.Object.u_saletask_opdate[uc_row] = opdate
  675. dw_pageretr.Object.u_cust_name[uc_row] = u_cust_name
  676. dw_pageretr.Object.u_cust_cuscode[uc_row] = u_cust_cuscode
  677. dw_pageretr.Object.u_saletask_moneyid[uc_row] = moneyid
  678. dw_pageretr.Object.u_saletask_banktypeid[uc_row] = banktypeid
  679. dw_pageretr.Object.u_saletask_mrate[uc_row] = mrate
  680. dw_pageretr.Object.u_saletask_relcode[uc_row] = relcode
  681. dw_pageretr.Object.u_saletask_damt[uc_row] = damt
  682. dw_pageretr.Object.u_saletask_otheramt[uc_row] = otheramt
  683. dw_pageretr.Object.u_saletask_cus_address[uc_row] = cus_address
  684. dw_pageretr.Object.u_saletask_cus_tele[uc_row] = cus_tele
  685. dw_pageretr.Object.u_saletask_freight[uc_row] = freight
  686. dw_pageretr.Object.u_saletask_cus_fax[uc_row] = cus_fax
  687. dw_pageretr.Object.u_saletask_freight_tele[uc_row] = freight_tele
  688. dw_pageretr.ResetUpdate()
  689. dw_pageretr.SetRedraw(TRUE)
  690. dw_uc.Reset()
  691. dw_pageretr.RowsCopy(dw_pageretr.GetRow(), dw_pageretr.GetRow(), Primary!, dw_uc, 1, Primary!)
  692. dw_uc.ResetUpdate()
  693. dw_uc.SetRedraw(TRUE)
  694. THIS.PostEvent('retrieve_childdw')
  695. ext:
  696. wf_statusbtn_fc()
  697. RETURN rslt
  698. end function
  699. public subroutine wf_check_billfj ();String arg_msg
  700. Long ll_ConnectionID
  701. Long cur_billtype
  702. long ll_relid,ll_relid_mx,ll_scid
  703. Long ls_filecount = 0
  704. Int rslt = 1
  705. uo_fj_mng_billtype ls_uo_fjbt
  706. ls_uo_fjbt = CREATE uo_fj_mng_billtype
  707. Long row,uc_relid
  708. row = dw_pageretr.GetRow()
  709. IF row > 0 THEN
  710. ll_relid = dw_pageretr.Object.taskid[row]
  711. ll_scid = dw_pageretr.Object.u_saletask_scid[row]
  712. ll_relid_mx = 0
  713. ELSE
  714. rslt = 0
  715. GOTO ext
  716. END IF
  717. IF f_get_outerconnection(ll_ConnectionID,arg_msg) = 0 THEN
  718. rslt = 0
  719. GOTO ext
  720. END IF
  721. cur_billtype = 102 //客户投拆单的 mainiD
  722. ls_uo_fjbt.uf_check_billfj( cur_billtype, ll_relid,ll_relid_mx,ll_scid, sys_fileDB_sqlca, arg_msg, ls_filecount)
  723. IF ls_filecount > 0 THEN
  724. rslt = 1
  725. GOTO ext
  726. ELSE
  727. rslt = 0
  728. GOTO ext
  729. END IF
  730. ext:
  731. wf_encl(rslt)
  732. DESTROY ls_uo_fjbt
  733. end subroutine
  734. 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);Long LS_ROW,ll_id,i,ll_scid
  735. LS_ROW = dw_pageretr.GetRow()
  736. IF LS_ROW <= 0 THEN
  737. arg_msg = '没有目标单据!'
  738. RETURN 0
  739. END IF
  740. //修改点:获取 指定retriev参数
  741. ll_id = dw_pageretr.Object.#1[LS_ROW]
  742. ll_scid = dw_pageretr.Object.u_saletask_scid[LS_ROW]
  743. //查询所选模版是否含有图片信息
  744. Long ll_ifpic
  745. Long ll_classid
  746. SELECT ifpic
  747. INTO :ll_ifpic
  748. FROM U_XLS_Templates
  749. Where id = :ll_xls_Templatesid;
  750. IF sqlca.SQLCode <> 0 THEN
  751. ll_ifpic = 0
  752. END IF
  753. Long ll_i,ll_j
  754. Long ll_mtrlid
  755. Long ll_fileid
  756. Blob ls_filedata
  757. SetNull(ls_filedata)
  758. String Pathname,ls_filename,ls_filetype
  759. String errmsg
  760. uo_fj_mng_billtype ls_uo_fjbt
  761. ls_uo_fjbt = CREATE uo_fj_mng_billtype
  762. s_xls_pic_list s_pic //结构数组-用于保存图片路径
  763. IF ll_ifpic = 1 THEN //如果含有图片信息,则查询本类型单据需要带出哪类附件
  764. SELECT classid
  765. INTO :ll_classid
  766. FROM u_billpic_fileclass
  767. Where (billtype = 102);
  768. IF sqlca.SQLCode <> 0 THEN
  769. ll_classid = 0
  770. END IF
  771. IF ll_classid > 0 THEN //如果已经指定好附件类型,则循环明细表查询每个明细的图片信息.
  772. FOR ll_i = 1 TO dw_child.RowCount()
  773. ll_mtrlid = dw_child.Object.mtrlid[ll_i]
  774. //取该附件类型中的第一个附件.
  775. SELECT top 1 fileid,DisplayName,FileType INTO :ll_fileid,:ls_filename,:ls_filetype
  776. FROM u_file
  777. WHERE relid = :ll_mtrlid
  778. AND classid = :ll_classid
  779. AND (filetype = 'bmp' OR filetype = 'rle' OR filetype = 'wmf'
  780. OR filetype = 'tif' OR filetype = 'jpg' OR filetype = 'gif' OR filetype = 'jpeg')
  781. USING sys_fileDB_sqlca;
  782. IF sys_fileDB_sqlca.SQLCode <> 0 THEN
  783. ll_fileid = 0
  784. END IF
  785. IF ll_fileid > 0 THEN
  786. Pathname = sys_cur_path+ins_fjtemppath+'\'+String(Today(),'yymmdd')+String(Now(),'hhmmss')+'_'+ls_filename+'.'+ls_filetype
  787. IF Trim(Pathname) <> '' THEN
  788. IF ls_uo_fjbt.uf_getfjbolb_fromdb( ll_fileid, ls_filedata, sys_fileDB_sqlca, arg_msg) = 0 THEN
  789. RETURN 0
  790. END IF
  791. IF f_saveblobtofile(ls_filedata,Pathname,errmsg) = 0 THEN
  792. RETURN 0
  793. ELSE
  794. s_pic.path[ll_i] = Pathname
  795. //记录临时文件位置,本窗口退出后删除
  796. wf_addlog_tempfilepathname(Pathname)
  797. END IF
  798. ELSE
  799. s_pic.path[ll_i] = ''
  800. END IF
  801. ELSE
  802. s_pic.path[ll_i] = ''
  803. END IF
  804. NEXT
  805. END IF
  806. //
  807. END IF
  808. ////可选设置/ //
  809. arg_obj_st.uo_const.create_new_pwd( ) //创建随机密码
  810. IF sys_option_xls_ifuse_passwd = 1 THEN arg_obj_st.uo_const.pwd = Trim(sys_option_xls_user_passwd) //默认加密密码 默认为随即密码
  811. Boolean xls_locked
  812. xls_locked = Not (sys_option_xls_lock = 1)
  813. // Excel 的可选设置
  814. IF arg_obj_st.of_setoption(arg_ationid, xls_locked,TRUE,arg_msg) <> 1 THEN
  815. RETURN 0
  816. END IF
  817. FOR i = 1 TO arg_str_billlist.count
  818. ////可选操作/ //
  819. arg_str_billlist.bill[i].ds_data = CREATE datastore //
  820. arg_str_billlist.bill[i].ds_data.DataObject = arg_str_billlist.bill[i].datawindow //
  821. arg_str_billlist.bill[i].ds_data.SetTransObject(sqlca)
  822. //修改点:注意retrieve 参数与上文对应
  823. arg_str_billlist.bill[i].ds_data.Retrieve(ll_scid,ll_id)
  824. IF ll_ifpic = 1 and ll_classid > 0 THEN
  825. IF arg_str_billlist.bill[i].datawindow = 'dw_xls_saletaskmx' AND arg_str_billlist.bill[i].ds_data.RowCount() > 0 THEN //设置图片路径
  826. FOR ll_j = 1 TO arg_str_billlist.bill[i].ds_data.RowCount()
  827. arg_str_billlist.bill[i].ds_data.Object.pic[ll_j] = s_pic.path[ll_j]
  828. NEXT
  829. END IF
  830. END IF
  831. NEXT
  832. DESTROY ls_uo_fjbt
  833. RETURN 1
  834. end function
  835. on w_saletask_sc.create
  836. int iCurrent
  837. call super::create
  838. this.ddlb_retrstatus=create ddlb_retrstatus
  839. this.ddlb_scid=create ddlb_scid
  840. this.st_2=create st_2
  841. this.st_3=create st_3
  842. iCurrent=UpperBound(this.Control)
  843. this.Control[iCurrent+1]=this.ddlb_retrstatus
  844. this.Control[iCurrent+2]=this.ddlb_scid
  845. this.Control[iCurrent+3]=this.st_2
  846. this.Control[iCurrent+4]=this.st_3
  847. end on
  848. on w_saletask_sc.destroy
  849. call super::destroy
  850. destroy(this.ddlb_retrstatus)
  851. destroy(this.ddlb_scid)
  852. destroy(this.st_2)
  853. destroy(this.st_3)
  854. end on
  855. event retrieve_pageretr;boolean cb_firstpage_enabled,cb_nextpage_enabled,cb_retrieveall_enabled
  856. boolean cb_priorpage_enabled,cb_func_enabled,cb_retrieve_enabled
  857. cb_nextpage_enabled=cb_nextpage.enabled
  858. cb_retrieveall_enabled=cb_retrieveall.enabled
  859. cb_func_enabled=cb_func.enabled
  860. cb_nextpage.enabled=false
  861. cb_retrieveall.enabled=false
  862. cb_func.enabled=false
  863. dw_uc.Retrieve() //dw_uc的dw改左select top 0 并肯不带参数
  864. dw_pageretr.Retrieve(cur_scid_arr,cur_status,sys_areaid)
  865. IF dw_pageretr.RowCount() > 0 THEN
  866. dw_pageretr.SetRow(1)
  867. dw_pageretr.triggerevent(rowfocuschanged!)
  868. end if
  869. this.triggerevent('retrieve_childdw')
  870. cb_nextpage.enabled=cb_nextpage_enabled
  871. cb_retrieveall.enabled=cb_retrieveall_enabled
  872. cb_func.enabled=cb_func_enabled
  873. end event
  874. event open;THIS.TriggerEvent('ue_before_open')
  875. wf_movetocenter()
  876. ds_copy_bill = CREATE datastore
  877. ds_copy_bill.DataObject = dw_child.dataobject
  878. ds_copy_bill.SetTransObject(sqlca)
  879. OLD_TITLE = THIS.Title
  880. s_tran = Message.PowerObjectParm
  881. IF NOT IsNull(s_tran) THEN
  882. retrieve_all = s_tran.if_retrieve_all
  883. mode = s_tran.work_mode
  884. arg_pkid = s_tran.arg_pkid
  885. arg_string_code = s_tran.arg_string_code
  886. if_sharedata = s_tran.if_sharedata //是否应用sharedata,当retrieve_all=true是生效
  887. ds_share = s_tran.ds_share
  888. END IF
  889. dw_pageretr.RBUTTON_FILTER_USE = TRUE //右键查询功能开关
  890. dw_pageretr.titleclick_sort_use = TRUE //单击标题排序功能开关
  891. dw_pageretr.SetTransObject (sqlca)
  892. pkcolumndbtname = wf_get_pkcolumndbtname(dw_pageretr) //取第一列为关键字
  893. ori_oldselect = dw_pageretr.Describe("DataWindow.Table.Select")
  894. ls_newselect = ori_oldselect
  895. ds_curquery = CREATE DATASTORE
  896. ds_curquery.DataObject = 'd_extr_find'
  897. ds_curquery.SetTransObject (sqlca)
  898. wf_editindex_lockf()
  899. IF s_tran.d_long = 2 THEN
  900. cur_scid = s_tran.c_long
  901. Int li_item
  902. li_item = ddlb_scid.FindItem(s_tran.d_string,0)
  903. IF li_item > 0 THEN
  904. ddlb_scid.SelectItem(li_item)
  905. END IF
  906. END IF
  907. sle_usual_query.Text = Trim(arg_string_code)
  908. IF NOT retrieve_all THEN
  909. THIS.TriggerEvent("ue_usual_query_RETR") //修改ls_newselect,retrieve
  910. ELSE
  911. IF if_sharedata THEN
  912. ds_share.ShareData(dw_pageretr)
  913. ELSE
  914. wf_retrieveuc(dw_pageretr,ls_newselect,1)
  915. THIS.TriggerEvent('RETRIEVE_pageretr')
  916. END IF
  917. END IF
  918. IF retrieve_all THEN
  919. THIS.TriggerEvent("ue_usual_query_filt")
  920. END IF
  921. uc_column_int = 19 //uc dw前5列可以编辑
  922. child_column_int = 13 //子dw前3列可以编辑
  923. obj_saletask = CREATE uo_saletask
  924. obj_saletask.commit_transaction = sqlca
  925. s_hide_col s_col_mtrlsectype
  926. s_col_mtrlsectype.col_1 = 'u_mtrldef_mtrlsectype'
  927. f_hide_col(1308,dw_child,s_col_mtrlsectype)
  928. s_hide_col s_col_zxmtrlmode
  929. s_col_zxmtrlmode.col_1 = 'u_mtrldef_zxmtrlmode'
  930. f_hide_col(1309,dw_child,s_col_zxmtrlmode)
  931. end event
  932. event ue_f9;//
  933. //IF NOT dw_edit_mode THEN RETURN
  934. //Long child_row
  935. //child_row = dw_uc.GetRow()
  936. //IF child_row = 0 THEN
  937. // MessageBox('提示','请选定订单!',information!,OK!)
  938. // RETURN
  939. //END IF
  940. //dw_uc.AcceptText()
  941. //
  942. //
  943. //
  944. //IF NOT IsValid(W_cust_edit) THEN
  945. // s_edit_index_tran s_ch_tran //传递参数使用
  946. // s_ch_tran.if_retrieve_all = FALSE //是否一次RETRIEVE所有行
  947. // s_ch_tran.work_mode = 1 //0-单纯编辑模式 1-选择\编辑模式
  948. // s_ch_tran.arg_pkid = 0 //目标定位PKID (备用)
  949. // //查询列(物料编码)部分内容,用于初步筛选
  950. // s_ch_tran.arg_string_code = Upper(Trim(dw_uc.Object.u_cust_cuscode[dw_uc.GetRow()]))
  951. //
  952. // OpenWithParm(W_cust_edit,s_ch_tran) //调用
  953. //
  954. // s_custom S_INSCUST
  955. // S_INSCUST = Message.PowerObjectParm //接受返回结构
  956. //
  957. // IF S_INSCUST.cusid > 0 THEN //正常返回值则可以取以下值
  958. // dw_uc.Object.cusid[child_row] = S_INSCUST.cusid
  959. // dw_uc.Object.u_cust_name[child_row] = S_INSCUST.Name
  960. // dw_uc.Object.u_cust_cuscode[child_row] = S_INSCUST.cuscode
  961. // dw_uc.Object.assign_emp[child_row] = S_INSCUST.bsntype
  962. // dw_uc.Object.u_saletask_freight[child_row] = S_INSCUST.freight
  963. // dw_uc.Object.u_saletask_freight_tele[child_row] = S_INSCUST.freight_tele
  964. // dw_uc.Object.u_saletask_cus_address[dw_uc.GetRow()] = S_INSCUST.Address
  965. // dw_uc.Object.u_saletask_cus_tele[dw_uc.GetRow()] = S_INSCUST.tele
  966. // dw_uc.Object.u_saletask_cus_fax[dw_uc.GetRow()] = S_INSCUST.faxno
  967. // dw_uc.SetRedraw(TRUE)
  968. // dw_uc.setfocus()
  969. // dw_uc.SetColumn("u_saletask_cus_address")
  970. // END IF
  971. //END IF
  972. //
  973. ////this.enabled = true
  974. //
  975. //
  976. end event
  977. event ue_f8;call super::ue_f8;////用于选择明细内容,被f8[默认]\dw_child.doubleclicked调用
  978. //IF NOT dw_edit_mode THEN RETURN
  979. //Long child_row
  980. //Long ls_cusid,ll_moneyid
  981. //child_row = dw_child.GetRow()
  982. //
  983. //ll_moneyid = dw_uc.Object.u_saletask_moneyid[dw_uc.GetRow()]
  984. //IF ll_moneyid = 0 OR IsNull(ll_moneyid) THEN
  985. // MessageBox('提示','请先选择币种',information!,OK!)
  986. // RETURN
  987. //END IF
  988. //
  989. //ls_cusid = dw_uc.Object.cusid[dw_uc.GetRow()]
  990. //IF IsNull(ls_cusid) OR ls_cusid = 0 THEN
  991. // THIS.TriggerEvent("ue_f9")
  992. //END IF
  993. //
  994. //IF NOT IsValid(w_mtrlware_storageid_ch_saletask) THEN
  995. // s_edit_index_tran s_tranf8 //传递参数使用
  996. // s_tranf8.if_retrieve_all = FALSE //是否一次retrieve所有行
  997. // s_tranf8.work_mode = 1 //0-单纯编辑模式 1-选择\编辑模式
  998. // s_tranf8.arg_pkid = 0 //目标定位pkid (备用)
  999. // s_tranf8.arg_string_code = '' //查询列(物料编码)部分内容,用于初步筛选
  1000. // s_tranf8.if_select_all = TRUE //多选
  1001. // s_tranf8.b_long = 0 //选产品
  1002. // s_tranf8.d_long = -1
  1003. //
  1004. // Long ls_j
  1005. // IF dw_child.GetRow() > 0 THEN s_tranf8.arg_string_code = Trim(dw_child.Object.u_mtrldef_mtrlcode[dw_child.GetRow()])
  1006. // OpenWithParm(w_mtrlware_storageid_ch_saletask,s_tranf8) //调用
  1007. //
  1008. // s_mtrldef_array s_inscust
  1009. // s_inscust = Message.PowerObjectParm //接受返回结构
  1010. // FOR ls_j = 1 TO UpperBound(s_inscust.mtrlid)
  1011. // IF s_inscust.mtrlid[ls_j] > 0 THEN //正常返回值则可以取以下值
  1012. // IF dw_child.GetRow() > 0 THEN
  1013. // IF dw_child.Object.mtrlid[child_row] <> 0 THEN
  1014. // child_row = dw_child.InsertRow (0)
  1015. // ELSE
  1016. // child_row = dw_child.GetRow()
  1017. // END IF
  1018. // ELSE
  1019. // child_row = dw_child.InsertRow (0)
  1020. // END IF
  1021. //
  1022. // dw_child.Object.mtrlid[child_row] = s_inscust.mtrlid[ls_j]
  1023. // dw_child.Object.u_mtrldef_mtrlcode[child_row] = s_inscust.mtrlcode[ls_j]
  1024. // dw_child.Object.mtrlname[child_row] = s_inscust.mtrlname[ls_j]
  1025. // dw_child.Object.saleqty[child_row] = 0
  1026. // dw_child.Object.plprice[child_row] = s_inscust.planprice[ls_j]
  1027. // dw_child.Object.u_mtrldef_mtrlmode[child_row] = s_inscust.mtrlmode[ls_j]
  1028. // dw_child.Object.u_mtrldef_mtrlsectype[child_row] = s_inscust.mtrlsectype[ls_j]
  1029. // dw_child.Object.u_mtrldef_zxmtrlmode[child_row] = s_inscust.zxmtrlmode[ls_j]
  1030. // dw_child.Object.u_saletaskmx_unit[child_row] = s_inscust.unit[ls_j]
  1031. //
  1032. // IF sys_option_price_if_status = 0 THEN
  1033. // Decimal ls_1stnewprice,ls_1stzqrate,ls_1strate
  1034. // String arg_msg
  1035. // IF f_getmtrlcusprice(ll_moneyid,s_inscust.mtrlid[ls_j],ls_cusid,s_inscust.unit[ls_j],'','','',0,ls_1stnewprice,ls_1stzqrate,ls_1strate,arg_msg) <> 1 THEN
  1036. // dw_child.Object.u_saletaskmx_enprice[child_row] = 0
  1037. // dw_child.Object.u_saletaskmx_rebate[child_row] = 1
  1038. // ELSE
  1039. // dw_child.Object.u_saletaskmx_enprice[child_row] = ls_1stnewprice
  1040. // dw_child.Object.u_saletaskmx_rebate[child_row] = ls_1stzqrate
  1041. // dw_child.Object.u_saletaskmx_rate[child_row] = ls_1strate
  1042. // END IF
  1043. // END IF
  1044. // dw_child.SetColumn('usaleqty')
  1045. // END IF
  1046. // NEXT
  1047. //END IF
  1048. //dw_child.SetFocus()
  1049. //
  1050. //
  1051. //
  1052. end event
  1053. event refresh_interface;call super::refresh_interface;ddlb_retrstatus.enabled=not dw_edit_mode
  1054. wf_statusbtn_fc()
  1055. if dw_edit_mode then
  1056. ddlb_scid.enabled=false
  1057. else
  1058. if sys_scid > 0 then
  1059. ddlb_scid.enabled=false
  1060. else
  1061. ddlb_scid.enabled=true
  1062. end if
  1063. end if
  1064. end event
  1065. event retrieve_childdw;call super::retrieve_childdw;long row,uc_relid,ll_scid
  1066. row=dw_pageretr.getrow()
  1067. if row>0 then
  1068. ll_scid=dw_pageretr.object.u_saletask_scid[row]
  1069. uc_relid=dw_pageretr.object.taskid[row]
  1070. dw_child.SetRedraw (false)
  1071. dw_child.retrieve(ll_scid,uc_relid)
  1072. dw_child.SetRedraw (true)
  1073. else
  1074. dw_child.reset()
  1075. end if
  1076. end event
  1077. event close;f_SetProfileString (sys_empid, "saletask", "status", string(cur_status))
  1078. wf_del_tempfilepathname()
  1079. end event
  1080. event ue_usual_query_retr;call super::ue_usual_query_retr;string ls_querystrpart=''
  1081. ls_newselect=lower(ori_oldselect)
  1082. if trim(sle_usual_query.text)<>'' then
  1083. if pos(trim(sle_usual_query.text),'%')=0 then
  1084. ls_querystrpart="(u_saletask.taskcode like '%"+trim(sle_usual_query.text)+"%')"
  1085. else
  1086. ls_querystrpart="(u_saletask.taskcode like '"+trim(sle_usual_query.text)+"')"
  1087. end if
  1088. if Pos(ls_newselect," where ") <> 0 then
  1089. ls_newselect=ls_newselect+" AND ("+ls_querystrpart+')'
  1090. else
  1091. ls_newselect=ls_newselect+" where ("+ls_querystrpart+')'
  1092. end if
  1093. end if
  1094. wf_retrieveuc(dw_pageretr,ls_newselect,1)
  1095. this.triggerevent('retrieve_pageretr')
  1096. end event
  1097. event ue_usual_query_filt;call super::ue_usual_query_filt;string obj_expr=''
  1098. if trim(sle_usual_query.text)<>'' then
  1099. IF POS(trim(sle_usual_query.text),'%')=0 THEN
  1100. obj_expr=obj_expr+'( taskcode LIKE "%'+trim(sle_usual_query.text)+'%" )'
  1101. ELSE
  1102. obj_expr=obj_expr+'( taskcode LIKE "'+trim(sle_usual_query.text)+'" )'
  1103. END IF
  1104. end if
  1105. dw_pageretr.setfilter(obj_expr)
  1106. dw_pageretr.SetRedraw(False)
  1107. dw_pageretr.filter()
  1108. if dw_pageretr.rowcount()>=1 then
  1109. dw_pageretr.selectrow(0,false)
  1110. dw_pageretr.selectrow(1,true)
  1111. dw_pageretr.SetRow(1)
  1112. dw_pageretr.triggerevent(rowfocuschanged!)
  1113. end if
  1114. dw_pageretr.SetRedraw(TRUE)
  1115. end event
  1116. event ue_viewprint;call super::ue_viewprint;IF NOT f_power_ind(984) THEN
  1117. MessageBox('提示','你没有使用权限!',information!,OK!)
  1118. RETURN
  1119. END IF
  1120. Long LS_ROW
  1121. LS_ROW = dw_pageretr.GetRow()
  1122. IF LS_ROW <= 0 THEN
  1123. MessageBox('提示','没有打印目标单据!',information!,OK!)
  1124. RETURN
  1125. END IF
  1126. S_print_MSG LS_PRMSG
  1127. IF ls_newname <> '' THEN
  1128. IF li_auditprint = 1 THEN
  1129. IF dw_pageretr.Object.u_SaleTask_Status[dw_pageretr.GetRow()] = 0 THEN
  1130. MessageBox('提示','目标单据还未审核,不能打印!',information!,OK!)
  1131. RETURN
  1132. END IF
  1133. END IF
  1134. LS_PRMSG.obj_dwNAME = ls_newname
  1135. ELSE
  1136. LS_PRMSG.obj_dwNAME = 'dw_rp_saletask_print_sc'
  1137. END IF
  1138. IF LS_PRMSG.obj_dwNAME = 'dw_rp_saletask_day_print' THEN
  1139. datetime ld_fdt,ld_edt
  1140. String ls_print_day
  1141. Open(w_saletask_print_day)
  1142. ls_print_day = message.stringparm
  1143. IF ls_print_day = '1900-01-01' THEN RETURN
  1144. ld_fdt = datetime(date(ls_print_day),time(0))
  1145. ld_edt = datetime(date(ls_print_day),time('23:59:59'))
  1146. LS_PRMSG.TAG_TEXT = '销售订单'
  1147. LS_PRMSG.FILTER_STRING = ''
  1148. LS_PRMSG.retr_pram_falg = 6
  1149. LS_PRMSG.PAGECH_FLAG = 0
  1150. LS_PRMSG.retr_pramfdt = ld_fdt
  1151. LS_PRMSG.retr_pramedt = ld_edt
  1152. ELSE
  1153. LS_PRMSG.TAG_TEXT = '销售订单'
  1154. LS_PRMSG.FILTER_STRING = ''
  1155. LS_PRMSG.retr_pram_falg = 15
  1156. LS_PRMSG.PAGECH_FLAG = 0
  1157. LS_PRMSG.retr_scid = dw_pageretr.Object.u_saletask_scid[dw_pageretr.GetRow()]
  1158. LS_PRMSG.retr_pramnmb = dw_pageretr.Object.taskid[LS_ROW]
  1159. LS_PRMSG.rowcnt = dw_child.RowCount()
  1160. END IF
  1161. OpenWithParm(w_publ_preview,LS_PRMSG)
  1162. //**更新打印次料
  1163. String arg_msg
  1164. printnum = Message.DoubleParm
  1165. f_update_printnum('u_saletask',printnum,dw_pageretr.Object.u_saletask_scid[dw_pageretr.GetRow()],dw_pageretr.Object.taskid[dw_pageretr.GetRow()],'','',arg_msg,TRUE)
  1166. end event
  1167. event ue_print;call super::ue_print;
  1168. //--直接打印
  1169. IF NOT f_power_ind(984) THEN
  1170. MessageBox('提示','你没有使用权限!',information!,OK!)
  1171. RETURN
  1172. END IF
  1173. uo_print_preview uo_print
  1174. IF MessageBox ("询问","是否确定要打印当前单据吗?",Question!,YesNo! ) = 2 THEN RETURN
  1175. S_print_MSG LS_PRMSG
  1176. Long LS_ROW
  1177. LS_ROW = dw_pageretr.GetRow()
  1178. IF LS_ROW <= 0 THEN
  1179. MessageBox('提示','没有打印目标单据!',information!,OK!)
  1180. RETURN
  1181. END IF
  1182. LS_PRMSG.retr_pram_falg = 15
  1183. IF ls_newname <> '' THEN
  1184. IF li_auditprint = 1 THEN
  1185. IF dw_pageretr.Object.u_SaleTask_Status[dw_pageretr.GetRow()] = 0 THEN
  1186. MessageBox('提示','目标单据还未审核,不能打印!',information!,OK!)
  1187. RETURN
  1188. END IF
  1189. END IF
  1190. LS_PRMSG.obj_dwNAME = ls_newname
  1191. ELSE
  1192. LS_PRMSG.obj_dwNAME = 'dw_rp_saletask_print_sc'
  1193. END IF
  1194. LS_PRMSG.TAG_TEXT = '销售订单'
  1195. LS_PRMSG.FILTER_STRING = ''
  1196. LS_PRMSG.PAGECH_FLAG = 0
  1197. LS_PRMSG.retr_pramnmb = dw_pageretr.Object.taskid[LS_ROW]
  1198. uo_print.FACT_PRINT_MSG = LS_PRMSG
  1199. String arg_msg
  1200. IF uo_print.uof_print_begin(arg_msg) = 0 THEN
  1201. MessageBox("错误",arg_msg,stopsign!,OK!)
  1202. RETURN
  1203. END IF
  1204. uo_print.ds_print()
  1205. //**更新打印次料
  1206. f_update_printnum('u_saletask',1,cur_scid,dw_pageretr.Object.taskid[dw_pageretr.GetRow()],'','',arg_msg,TRUE)
  1207. end event
  1208. event ue_f10;call super::ue_f10;//IF NOT dw_edit_mode THEN RETURN
  1209. //Long child_row
  1210. //String ls_colorname
  1211. //
  1212. //child_row = dw_child.GetRow()
  1213. //
  1214. //IF child_row <= 0 THEN RETURN
  1215. //
  1216. //IF NOT IsValid(w_color_edit) THEN
  1217. // Open(w_color_edit)
  1218. // ls_colorname = Message.StringParm
  1219. // IF ls_colorname = '' THEN RETURN
  1220. // dw_child.Object.u_saletaskmx_status[child_row] = ls_colorname
  1221. // dw_child.SetFocus()
  1222. //END IF
  1223. //
  1224. //
  1225. end event
  1226. event ue_addzy;call super::ue_addzy;//IF dw_edit_mode THEN
  1227. // MessageBox('系统提示',"编辑状态下不可以使用!")
  1228. // RETURN
  1229. //END IF
  1230. //
  1231. //IF NOT f_power_ind(698) THEN
  1232. // MessageBox(publ_operator,'你没有使用权限!')
  1233. // RETURN
  1234. //END IF
  1235. //
  1236. //String arg_msg = '',LS_STR
  1237. //Long uc_row
  1238. //s_inputbox S_SREU
  1239. //
  1240. //uc_row = dw_pageretr.GetRow()
  1241. //IF uc_row <= 0 THEN
  1242. // MessageBox('系统提示','请选定当前目标订单!')
  1243. // RETURN
  1244. //END IF
  1245. //S_SREU.Title = '请输入要补充到备注的内容'
  1246. //S_SREU.OLD_TEXT = ''
  1247. //OpenWithParm(w_inputbox,S_SREU)
  1248. //LS_STR = Message.StringParm
  1249. //IF Trim(LS_STR) = '' OR IsNull(LS_STR) THEN RETURN
  1250. //
  1251. //IF obj_saletask.add_dscrp(dw_pageretr.Object.u_saletask_scid[uc_row],dw_pageretr.Object.taskid[uc_row],LS_STR,arg_msg,TRUE) = 0 THEN
  1252. // MessageBox('Error!',arg_msg)
  1253. // RETURN
  1254. //ELSE
  1255. // MessageBox(publ_operator,'添加备注操作成功!')
  1256. // wf_refresh_curuc(cur_scid,dw_pageretr.Object.taskid[uc_row])
  1257. //END IF
  1258. //
  1259. //
  1260. end event
  1261. event ue_f11;call super::ue_f11;//IF NOT dw_edit_mode THEN RETURN
  1262. //Long child_row
  1263. //Long ls_outtypeid
  1264. //
  1265. //child_row = dw_child.GetRow()
  1266. //
  1267. //IF child_row <= 0 THEN RETURN
  1268. //
  1269. //IF NOT IsValid(w_outtype_edit) THEN
  1270. // Open(w_outtype_edit)
  1271. // ls_outtypeid = Message.doubleparm
  1272. //
  1273. // datawindowchild childdw
  1274. // dw_child.getchild("u_saletaskmx_outtype",childdw)
  1275. // childdw.SetTransObject (sqlca)
  1276. // IF childdw.retrieve() = 0 then
  1277. // childdw.insertrow(0)
  1278. // end if
  1279. //
  1280. // IF ls_outtypeid = 0 THEN RETURN
  1281. //
  1282. // dw_child.Object.u_saletaskmx_outtype[child_row] = ls_outtypeid
  1283. // dw_child.SetFocus()
  1284. //END IF
  1285. //
  1286. end event
  1287. event ue_f12;call super::ue_f12;//IF NOT IsValid(w_unit_ch) THEN
  1288. // IF dw_child.GetRow() < 1 THEN RETURN
  1289. // Long ls_mtrlid,ls_cusid,ls_moneyid
  1290. // string ls_1stunit,arg_msg,ls_status,ls_woodcode,ls_pcode
  1291. // Decimal rtn_price,rtn_zqrate,rtn_rate
  1292. //
  1293. // ls_mtrlid = dw_child.Object.mtrlid[dw_child.GetRow()]
  1294. // ls_cusid = dw_uc.Object.cusid[dw_uc.GetRow()]
  1295. // ls_moneyid = dw_uc.Object.u_saletask_moneyid[dw_uc.GetRow()]
  1296. // ls_status = dw_child.object.u_saletaskmx_status[dw_child.GetRow()]
  1297. // ls_woodcode = dw_child.object.u_saletaskmx_woodcode[dw_child.GetRow()]
  1298. // ls_pcode = dw_child.object.u_saletaskmx_pcode[dw_child.GetRow()]
  1299. //
  1300. // IF IsNull(ls_cusid) OR ls_cusid = 0 THEN
  1301. // THIS.TriggerEvent("ue_f9")
  1302. // END IF
  1303. //
  1304. // OpenWithParm(w_unit_ch,ls_mtrlid)
  1305. // s_unit s_inscust
  1306. // s_inscust = Message.PowerObjectParm //接受返回结构
  1307. //
  1308. // IF s_inscust.unit <> '' THEN
  1309. // dw_child.Object.u_saletaskmx_unit[dw_child.GetRow()] = s_inscust.unit
  1310. // ls_cusid = dw_uc.Object.cusid[dw_uc.GetRow()]
  1311. // ls_1stunit = s_inscust.unit
  1312. // IF f_getmtrlcusprice(ls_moneyid,ls_mtrlid,ls_cusid,ls_1stunit,'','','',0,rtn_price,rtn_zqrate,rtn_rate,arg_msg) <> 1 THEN
  1313. // dw_child.Object.u_saletaskmx_rate[dw_child.GetRow()] = s_inscust.rate
  1314. // ELSE
  1315. // dw_child.Object.u_saletaskmx_enprice[dw_child.GetRow()]= rtn_price
  1316. // dw_child.Object.u_saletaskmx_rebate[dw_child.GetRow()] = rtn_zqrate
  1317. // dw_child.Object.u_saletaskmx_rate[dw_child.GetRow()] = rtn_rate
  1318. // END IF
  1319. // END IF
  1320. //END IF
  1321. //
  1322. //
  1323. //
  1324. end event
  1325. event ue_f6;call super::ue_f6;////用于选择明细内容,被f8[默认]\dw_child.doubleclicked调用
  1326. //IF NOT dw_edit_mode THEN RETURN
  1327. //Long child_row
  1328. //Long ls_cusid,ll_moneyid
  1329. //child_row = dw_child.GetRow()
  1330. //dw_uc.accepttext()
  1331. //
  1332. //ll_moneyid = dw_uc.Object.u_saletask_moneyid[dw_uc.GetRow()]
  1333. //IF ll_moneyid = 0 OR IsNull(ll_moneyid) THEN
  1334. // MessageBox('提示','请先选择币种',information!,OK!)
  1335. // RETURN
  1336. //END IF
  1337. //
  1338. //ls_cusid = dw_uc.Object.cusid[dw_uc.GetRow()]
  1339. //IF IsNull(ls_cusid) OR ls_cusid = 0 THEN
  1340. // THIS.TriggerEvent("ue_f9")
  1341. //END IF
  1342. //
  1343. //IF NOT IsValid(w_saletask_mtrl_his_ch) THEN
  1344. // s_edit_index_tran s_tranf8 //传递参数使用
  1345. // s_tranf8.if_retrieve_all = FALSE //是否一次retrieve所有行
  1346. // s_tranf8.work_mode = 1 //0-单纯编辑模式 1-选择\编辑模式
  1347. // s_tranf8.arg_pkid = 0 //目标定位pkid (备用)
  1348. // s_tranf8.arg_string_code = '' //查询列(物料编码)部分内容,用于初步筛选
  1349. // s_tranf8.if_select_all = TRUE //多选
  1350. // s_tranf8.b_long = 0
  1351. // s_tranf8.d_long = ls_cusid
  1352. //
  1353. // Long ls_j
  1354. // OpenWithParm(w_saletask_mtrl_his_ch,s_tranf8) //调用
  1355. //
  1356. // s_saletask_mtrl s_inscust
  1357. // s_inscust = Message.PowerObjectParm //接受返回结构
  1358. // FOR ls_j = 1 TO UpperBound(s_inscust.mtrlid)
  1359. // IF s_inscust.mtrlid[ls_j] > 0 THEN //正常返回值则可以取以下值
  1360. // IF dw_child.GetRow() > 0 THEN
  1361. // IF dw_child.Object.mtrlid[child_row] <> 0 THEN
  1362. // child_row = dw_child.InsertRow (0)
  1363. // ELSE
  1364. // child_row = dw_child.GetRow()
  1365. // END IF
  1366. // ELSE
  1367. // child_row = dw_child.InsertRow (0)
  1368. // END IF
  1369. //
  1370. // dw_child.Object.mtrlid[child_row] = s_inscust.mtrlid[ls_j]
  1371. // dw_child.Object.u_mtrldef_mtrlcode[child_row] = s_inscust.mtrlcode[ls_j]
  1372. // dw_child.Object.mtrlname[child_row] = s_inscust.mtrlname[ls_j]
  1373. // dw_child.Object.saleqty[child_row] = 0
  1374. // dw_child.Object.plprice[child_row] = s_inscust.planprice[ls_j]
  1375. // dw_child.Object.u_mtrldef_mtrlmode[child_row] = s_inscust.mtrlmode[ls_j]
  1376. // dw_child.Object.u_mtrldef_mtrlsectype[child_row] = s_inscust.mtrlsectype[ls_j]
  1377. // dw_child.Object.u_mtrldef_zxmtrlmode[child_row] = s_inscust.zxmtrlmode[ls_j]
  1378. // dw_child.Object.u_saletaskmx_unit[child_row] = s_inscust.unit[ls_j]
  1379. // dw_child.Object.u_saletaskmx_enprice[child_row] = s_inscust.price[ls_j]
  1380. // dw_child.Object.u_saletaskmx_rebate[child_row] = s_inscust.rebate[ls_j]
  1381. // dw_child.Object.u_saletaskmx_status[child_row] = s_inscust.status[ls_j]
  1382. // dw_child.Object.u_saletaskmx_woodcode[child_row] = s_inscust.woodcode[ls_j]
  1383. // dw_child.Object.u_saletaskmx_pcode [child_row] = s_inscust.pcode[ls_j]
  1384. //
  1385. //
  1386. // dw_child.SetColumn('usaleqty')
  1387. // END IF
  1388. // NEXT
  1389. //END IF
  1390. //dw_child.SetFocus()
  1391. //
  1392. //
  1393. //
  1394. //
  1395. end event
  1396. event ue_rpt_viewprint;call super::ue_rpt_viewprint;IF NOT f_power_ind(984) THEN
  1397. MessageBox('提示','你没有使用权限!',information!,OK!)
  1398. RETURN
  1399. END IF
  1400. Long row,uc_relid,ll_scid
  1401. row = dw_pageretr.GetRow()
  1402. IF row = 0 THEN
  1403. RETURN
  1404. END IF
  1405. s_rpt_print_msg s_print
  1406. s_print.retr_pram_falg = 15
  1407. s_print.rpid = ls_msgprintid_rpt
  1408. s_print.retr_flag = TRUE
  1409. s_print.tag_text = THIS.Title
  1410. s_print.rpname = ls_rpname
  1411. s_print.retr_scid = dw_pageretr.Object.u_saletask_scid[row]
  1412. s_print.retr_pramnmb = dw_pageretr.Object.taskid[row]
  1413. s_print.rowcnt = dw_child.RowCount()
  1414. OpenWithParm(w_rpt_preview,s_print)
  1415. //**更新打印次料
  1416. String arg_msg
  1417. printnum = Message.DoubleParm
  1418. f_update_printnum('u_saletask',printnum,dw_pageretr.Object.u_saletask_scid[dw_pageretr.GetRow()],dw_pageretr.Object.taskid[dw_pageretr.GetRow()],'','',arg_msg,TRUE)
  1419. end event
  1420. event ue_rpt_print;call super::ue_rpt_print;IF NOT f_power_ind(984) THEN
  1421. MessageBox('提示','你没有使用权限!',information!,OK!)
  1422. RETURN
  1423. END IF
  1424. Long row,uc_relid,ll_scid
  1425. row = dw_pageretr.GetRow()
  1426. uo_rpt_print_preview uo_print
  1427. S_rpt_print_MSG LS_PRMSG
  1428. IF dw_uc.RowCount() = 0 THEN
  1429. MessageBox('提示','没有可打印的单据!',information!,OK!)
  1430. RETURN
  1431. END IF
  1432. IF MessageBox ("询问","是否确定要打印当前单据吗?",Question!,YesNo! ) = 2 THEN RETURN
  1433. LS_PRMSG.retr_pram_falg = 15
  1434. LS_PRMSG.TAG_TEXT = '销售订单'
  1435. LS_PRMSG.rpname = ls_rpname
  1436. LS_PRMSG.FILTER_STRING = ''
  1437. LS_PRMSG.PAGECH_FLAG = 0
  1438. LS_PRMSG.rpid = ls_msgprintid_rpt
  1439. LS_PRMSG.retr_scid = dw_pageretr.Object.u_saletask_scid[dw_pageretr.GetRow()]
  1440. LS_PRMSG.retr_pramnmb = dw_pageretr.Object.taskid[dw_pageretr.GetRow()]
  1441. LS_PRMSG.rowcnt = dw_child.RowCount()
  1442. uo_print.FACT_PRINT_MSG = LS_PRMSG
  1443. String arg_msg
  1444. IF uo_print.uof_print_begin(arg_msg) = 0 THEN
  1445. MessageBox("错误",arg_msg,stopsign!,OK!)
  1446. RETURN
  1447. END IF
  1448. uo_print.ds_print()
  1449. //**更新打印次料
  1450. printnum = Message.DoubleParm
  1451. f_update_printnum('u_saletask',1,cur_scid,dw_pageretr.Object.taskid[dw_pageretr.GetRow()],'','',arg_msg,TRUE)
  1452. end event
  1453. type cb_func from w_publ_1ton_share_detail`cb_func within w_saletask_sc
  1454. integer taborder = 20
  1455. end type
  1456. type cb_exit from w_publ_1ton_share_detail`cb_exit within w_saletask_sc
  1457. integer x = 1138
  1458. integer taborder = 240
  1459. end type
  1460. type sle_usual_query from w_publ_1ton_share_detail`sle_usual_query within w_saletask_sc
  1461. integer x = 206
  1462. integer y = 188
  1463. integer width = 549
  1464. end type
  1465. type cb_retrieveall from w_publ_1ton_share_detail`cb_retrieveall within w_saletask_sc
  1466. integer x = 1605
  1467. integer taborder = 200
  1468. end type
  1469. type em_pagerowno from w_publ_1ton_share_detail`em_pagerowno within w_saletask_sc
  1470. integer x = 1289
  1471. integer width = 320
  1472. integer taborder = 180
  1473. end type
  1474. type dw_pageretr from w_publ_1ton_share_detail`dw_pageretr within w_saletask_sc
  1475. integer x = 2117
  1476. integer y = 296
  1477. integer width = 1445
  1478. integer height = 736
  1479. integer taborder = 30
  1480. string title = "销售订单摘要内容"
  1481. string dataobject = "dw_saletask_index_sc"
  1482. boolean hscrollbar = false
  1483. boolean border = true
  1484. borderstyle borderstyle = stylebox!
  1485. end type
  1486. event dw_pageretr::rowfocuschanged;call super::rowfocuschanged;wf_statusbtn_fc()
  1487. wf_check_billfj()
  1488. if currentrow<=0 then dw_child.reset()
  1489. end event
  1490. event dw_pageretr::retrieveend;wf_statusbtn_fc()
  1491. end event
  1492. type st_1 from w_publ_1ton_share_detail`st_1 within w_saletask_sc
  1493. integer y = 208
  1494. integer width = 178
  1495. alignment alignment = right!
  1496. end type
  1497. type cb_nextpage from w_publ_1ton_share_detail`cb_nextpage within w_saletask_sc
  1498. integer x = 1755
  1499. integer taborder = 230
  1500. end type
  1501. type dw_uc from w_publ_1ton_share_detail`dw_uc within w_saletask_sc
  1502. integer y = 296
  1503. integer width = 2112
  1504. integer height = 736
  1505. integer taborder = 120
  1506. string dataobject = "dw_saletask_input_sc"
  1507. end type
  1508. event dw_uc::dwnkey;PARENT.TriggerEvent('user_key')
  1509. IF Key = KeyDownArrow! THEN RETURN 1
  1510. IF dw_edit_mode THEN
  1511. IF dw_uc.GetColumnName ( ) = 'dscrp' AND Key = KeyEnter! THEN
  1512. dw_child.ScrollToRow(1)
  1513. dw_child.SetFocus()
  1514. dw_child.SetColumn ('u_saletaskmx_outtype')
  1515. RETURN 1
  1516. ELSEIF dw_uc.GetColumnName ( ) = 'u_cust_cuscode' AND Key = KeyEnter! THEN
  1517. String ls_code,ls_name,ls_custype,ls_find_code
  1518. String ls_freight,ls_freight_tele
  1519. String ls_cus_address,ls_cus_tele,ls_cus_fax
  1520. Long ls_cusid
  1521. Long cnt = 0
  1522. Boolean if_find = FALSE
  1523. dw_uc.AcceptText()
  1524. ls_code = Trim(dw_uc.Object.u_cust_cuscode[dw_uc.GetRow()])
  1525. SELECT u_cust.cusid,
  1526. u_cust.name,
  1527. u_cust.custype,
  1528. u_cust.cuscode,
  1529. u_cust.freight,
  1530. u_cust.freight_tele,
  1531. u_cust.address,
  1532. u_cust.tele,
  1533. u_cust.faxno
  1534. INTO :ls_cusid,:ls_name,:ls_custype,:ls_code,
  1535. :ls_freight,:ls_freight_tele,
  1536. :ls_cus_address,:ls_cus_tele,:ls_cus_fax
  1537. FROM u_cust
  1538. Where (cuscode = :ls_code OR Name = :ls_code);
  1539. IF sqlca.SQLCode <> 0 THEN
  1540. IF Pos(Trim(ls_code),'%') = 0 THEN
  1541. ls_find_code = '%'+ Trim(ls_code) + '%'
  1542. ELSE
  1543. ls_find_code = Trim(ls_code)
  1544. END IF
  1545. SELECT count(*) INTO :cnt
  1546. FROM u_cust
  1547. Where ( cuscode Like :ls_find_code OR Name Like :ls_find_code );
  1548. IF sqlca.SQLCode <> 0 THEN
  1549. PARENT.TriggerEvent('ue_f9')
  1550. RETURN 1
  1551. END IF
  1552. IF cnt <> 1 THEN
  1553. PARENT.TriggerEvent('ue_f9')
  1554. RETURN 1
  1555. ELSE
  1556. SELECT u_cust.cusid,
  1557. u_cust.cuscode,
  1558. u_cust.name,
  1559. u_cust.freight,
  1560. u_cust.freight_tele,
  1561. u_cust.address,
  1562. u_cust.tele,
  1563. u_cust.faxno
  1564. INTO :ls_cusid,:ls_code,:ls_name,
  1565. :ls_freight,:ls_freight_tele,
  1566. :ls_cus_address,:ls_cus_tele,:ls_cus_fax
  1567. FROM u_cust
  1568. Where ( cuscode Like :ls_find_code OR Name Like :ls_find_code );
  1569. IF sqlca.SQLCode <> 0 THEN
  1570. PARENT.TriggerEvent('ue_f9')
  1571. RETURN 1
  1572. ELSE
  1573. if_find = TRUE
  1574. END IF
  1575. END IF
  1576. ELSE
  1577. if_find = TRUE
  1578. END IF
  1579. IF if_find THEN
  1580. dw_uc.SetRedraw(FALSE)
  1581. dw_uc.Object.cusid[dw_uc.GetRow()] = ls_cusid
  1582. dw_uc.Object.u_cust_cuscode[dw_uc.GetRow()] = ls_code
  1583. dw_uc.Object.u_cust_name[dw_uc.GetRow()] = ls_name
  1584. dw_uc.Object.assign_emp[dw_uc.GetRow()] = ls_custype
  1585. dw_uc.Object.u_saletask_freight[dw_uc.GetRow()] = ls_freight
  1586. dw_uc.Object.u_saletask_freight_tele[dw_uc.GetRow()] = ls_freight_tele
  1587. dw_uc.Object.u_saletask_cus_address[dw_uc.GetRow()] = ls_cus_address
  1588. dw_uc.Object.u_saletask_cus_tele[dw_uc.GetRow()] = ls_cus_tele
  1589. dw_uc.Object.u_saletask_cus_fax[dw_uc.GetRow()] = ls_cus_fax
  1590. dw_uc.SetRedraw(TRUE)
  1591. dw_uc.SetColumn("u_saletask_cus_address")
  1592. RETURN 1
  1593. END IF
  1594. ELSE
  1595. IF Key = KeyEnter! THEN //
  1596. keybd_event ( 9, 0, 0 , 0 ) // 按下tab
  1597. keybd_event ( 9, 0, 2, 0 ) // 释放tab
  1598. RETURN 1
  1599. END IF
  1600. END IF
  1601. END IF
  1602. end event
  1603. event dw_uc::itemchanged;call super::itemchanged;if not dw_edit_mode then return
  1604. dw_uc.accepttext()
  1605. if dw_uc.getrow() <= 0 then return
  1606. if dwo.name <> 'u_saletask_moneyid' then return
  1607. long ll_moneyid
  1608. ll_moneyid = dw_uc.object.u_saletask_moneyid[dw_uc.getrow()]
  1609. dw_uc.setredraw(false)
  1610. dw_uc.object.u_saletask_mrate[dw_uc.getrow()]=f_get_mrate(ll_moneyid)
  1611. dw_uc.setredraw(true)
  1612. end event
  1613. event dw_uc::clicked;call super::clicked;
  1614. IF row <= 0 THEN RETURN
  1615. IF dwo.Name = 'p_dview1' THEN
  1616. PARENT.TriggerEvent('ue_f13')
  1617. elseIF dwo.Name = 'p_dview2' THEN
  1618. PARENT.TriggerEvent('ue_f14')
  1619. END IF
  1620. IF NOT dw_edit_mode THEN RETURN
  1621. IF dwo.Name = 'p_p' THEN
  1622. PARENT.TriggerEvent('ue_f9')
  1623. //ELSEIF dwo.Name = 'b_1' THEN
  1624. // IF NOT IsValid(w_outrepdef_edit_ch) THEN
  1625. // Open(w_outrepdef_edit_ch)
  1626. // s_outrepdef s_outrep_ch
  1627. // s_outrep_ch = Message.PowerObjectParm
  1628. // IF s_outrep_ch.outrepname <> '' THEN
  1629. // dw_uc.Object.assign_emp[dw_uc.GetRow()] = s_outrep_ch.outrepname
  1630. // END IF
  1631. // END IF
  1632. ELSEIF dwo.Name = 'b_2' THEN
  1633. PARENT.TriggerEvent ('ue_f6')
  1634. END IF
  1635. end event
  1636. event dw_uc::doubleclicked;IF dw_edit_mode AND row > 0 THEN
  1637. IF dwo.Name = 'u_cust_cuscode' OR dwo.Name = 'u_cust_name' THEN
  1638. PARENT.TriggerEvent('ue_f9')
  1639. END IF
  1640. END IF
  1641. end event
  1642. type gb_2 from w_publ_1ton_share_detail`gb_2 within w_saletask_sc
  1643. end type
  1644. type dw_child from w_publ_1ton_share_detail`dw_child within w_saletask_sc
  1645. integer y = 1032
  1646. integer width = 3570
  1647. integer height = 1220
  1648. integer taborder = 160
  1649. string title = "销售订单明细"
  1650. string dataobject = "dw_saletaskmx_sc"
  1651. end type
  1652. event dw_child::dwnkey;call super::dwnkey;//PARENT.TriggerEvent('user_key')
  1653. //
  1654. //String ls_mtrlcode,ls_mtrlname,ls_unit,ls_mtrlmode,ls_mtrlsectype,ls_zxmtrlmode
  1655. //Long ls_mtrlid,ls_cusid
  1656. //Dec ls_planprice,ls_lmsaleprice,ls_price,ls_rebate
  1657. //
  1658. //s_mtrldef_array arg_s_mtrldef
  1659. //
  1660. //Long child_row
  1661. //Long ls_null,ll_moneyid
  1662. //SetNull(ls_null)
  1663. //String arg_msg = ''
  1664. //string ls_woodcode,ls_status,ls_pcode
  1665. //IF dw_edit_mode THEN
  1666. // dw_uc.AcceptText()
  1667. //
  1668. // ll_moneyid = dw_uc.Object.u_saletask_moneyid[dw_uc.GetRow()]
  1669. // IF ll_moneyid = 0 OR IsNull(ll_moneyid) THEN
  1670. // MessageBox('提示','请先选择币种',information!,OK!)
  1671. // RETURN
  1672. // END IF
  1673. //
  1674. //
  1675. // ls_cusid = dw_uc.Object.cusid[dw_uc.GetRow()]
  1676. // IF IsNull(ls_cusid) OR ls_cusid = 0 THEN
  1677. // THIS.TriggerEvent("ue_f9")
  1678. // END IF
  1679. //
  1680. // IF KeyDown(keydownarrow!) THEN
  1681. // Long li_row
  1682. // IF dw_child.GetRow() = dw_child.RowCount() THEN
  1683. // PARENT.TriggerEvent("insert_childrow")
  1684. // END IF
  1685. // ELSE
  1686. // IF KeyDown(keyenter!) AND NOT KeyDown(keycontrol!) AND NOT KeyDown(keyshift!) THEN
  1687. // IF dw_child.GetColumnName() = 'u_mtrldef_mtrlcode' THEN
  1688. // dw_child.AcceptText()
  1689. // child_row = dw_child.GetRow()
  1690. //
  1691. // ls_mtrlcode = dw_child.Object.u_mtrldef_mtrlcode[child_row]
  1692. //
  1693. // IF f_find_mtrl(ls_mtrlcode,-1,arg_s_mtrldef) = 0 THEN
  1694. // PARENT.TriggerEvent('ue_f8')
  1695. // RETURN 1
  1696. // ELSE
  1697. // ls_mtrlid = arg_s_mtrldef.mtrlid[1]
  1698. // ls_mtrlcode = arg_s_mtrldef.mtrlcode[1]
  1699. // ls_mtrlname = arg_s_mtrldef.mtrlname[1]
  1700. // ls_unit = arg_s_mtrldef.unit[1]
  1701. // ls_mtrlmode = arg_s_mtrldef.mtrlmode[1]
  1702. // ls_planprice = arg_s_mtrldef.planprice[1]
  1703. // ls_lmsaleprice = arg_s_mtrldef.lmsaleprice[1]
  1704. // ls_mtrlsectype=arg_s_mtrldef.mtrlsectype[1]
  1705. // ls_zxmtrlmode=arg_s_mtrldef.zxmtrlmode[1]
  1706. // END IF
  1707. // dw_child.Object.mtrlid[child_row] = ls_mtrlid
  1708. // dw_child.Object.mtrlname[child_row] = ls_mtrlname
  1709. // dw_child.Object.u_mtrldef_unit[child_row] = ls_unit
  1710. // dw_child.Object.u_mtrldef_mtrlmode[child_row] = ls_mtrlmode
  1711. // dw_child.Object.u_mtrldef_mtrlcode[child_row] = ls_mtrlcode
  1712. // dw_child.Object.u_mtrldef_zxmtrlmode[child_row] = ls_zxmtrlmode
  1713. // dw_child.Object.u_mtrldef_mtrlsectype[child_row] = ls_mtrlsectype
  1714. // dw_child.Object.u_saletaskmx_unit[child_row] = ls_unit
  1715. //
  1716. // IF sys_option_price_if_status = 0 THEN
  1717. // Decimal ls_1stnewprice,ls_1stzqrate,ls_1strate
  1718. // IF f_getmtrlcusprice(ll_moneyid,ls_mtrlid,ls_cusid,ls_unit,'','','',0,ls_1stnewprice,ls_1stzqrate,ls_1strate,arg_msg) <> 1 THEN
  1719. // dw_child.Object.u_saletaskmx_enprice[child_row] = 0
  1720. // dw_child.Object.u_saletaskmx_rebate[child_row] = 1
  1721. // ELSE
  1722. // dw_child.Object.u_saletaskmx_enprice[child_row] = ls_1stnewprice
  1723. // dw_child.Object.u_saletaskmx_rebate[child_row] = ls_1stzqrate
  1724. // dw_child.Object.u_saletaskmx_rate[child_row] = ls_1strate
  1725. // END IF
  1726. // END IF
  1727. //
  1728. // IF Key = keyenter! THEN
  1729. // keybd_event ( 9, 0, 0 , 0 ) // 按下tab
  1730. // keybd_event ( 9, 0, 2, 0 ) // 释放tab
  1731. // RETURN 1
  1732. // END IF
  1733. // ELSEIF dw_child.GetColumnName( ) = 'u_saletaskmx_rebate' THEN
  1734. // Long i_mtrlid
  1735. // String i_mtrlcode
  1736. // Decimal i_price,i_zqrate
  1737. // dw_child.AcceptText()
  1738. //
  1739. // i_mtrlid = dw_child.Object.mtrlid[dw_child.GetRow()]
  1740. // i_mtrlcode = dw_child.Object.u_mtrldef_mtrlcode[dw_child.GetRow()]
  1741. // i_price = dw_child.Object.u_saletaskmx_fprice[dw_child.GetRow()]
  1742. // i_zqrate = dw_child.Object.u_saletaskmx_rebate[dw_child.GetRow()]
  1743. //
  1744. //// if uo_mtrl_cus_p.uf_check_price(ls_cusid,i_mtrlid,i_price * i_zqrate,0,arg_msg)=0 then
  1745. //// messagebox("系统提示",arg_msg)
  1746. //// dw_child.setfocus()
  1747. //// dw_child.setcolumn("u_saletaskmx_fprice")
  1748. //// return 1
  1749. //// else
  1750. // IF Key = keyenter! THEN
  1751. // keybd_event ( 9, 0, 0 , 0 ) // 按下tab
  1752. // keybd_event ( 9, 0, 2, 0 ) // 释放tab
  1753. // RETURN 1
  1754. // END IF
  1755. // // end if
  1756. //
  1757. // ELSEIF dw_child.GetColumnName( ) = 'u_saletaskmx_mxdscrp' AND dw_child.GetRow() = dw_child.RowCount() THEN
  1758. // PARENT.TriggerEvent("insert_childrow")
  1759. // RETURN 1
  1760. // ELSE
  1761. // IF Key = keyenter! THEN
  1762. // keybd_event ( 9, 0, 0 , 0 ) // 按下tab
  1763. // keybd_event ( 9, 0, 2, 0 ) // 释放tab
  1764. // RETURN 1
  1765. // END IF
  1766. // END IF
  1767. // END IF
  1768. // END IF
  1769. //END IF
  1770. //
  1771. //// u_mtrldef_mtrlcode
  1772. //// acprice
  1773. //// mtrlid
  1774. //// mtrlname
  1775. //// plprice
  1776. //
  1777. //
  1778. //
  1779. //
  1780. //
  1781. //
  1782. //
  1783. //
  1784. end event
  1785. event dw_child::doubleclicked;IF dw_edit_mode THEN
  1786. IF dwo.Name = 'u_saletaskmx_status' THEN
  1787. PARENT.TriggerEvent('ue_f10')
  1788. ELSEIF dwo.Name = 'u_saletaskmx_outtype' THEN
  1789. PARENT.TriggerEvent('ue_f11')
  1790. ELSEIF dwo.Name = 'u_saletaskmx_unit' THEN
  1791. PARENT.TriggerEvent('ue_f12')
  1792. ELSE
  1793. PARENT.TriggerEvent('ue_f8')
  1794. END IF
  1795. END IF
  1796. end event
  1797. type cb_viewprint from w_publ_1ton_share_detail`cb_viewprint within w_saletask_sc
  1798. integer x = 494
  1799. integer taborder = 40
  1800. end type
  1801. type cb_print from w_publ_1ton_share_detail`cb_print within w_saletask_sc
  1802. integer x = 302
  1803. integer taborder = 150
  1804. end type
  1805. type cb_add from w_publ_1ton_share_detail`cb_add within w_saletask_sc
  1806. boolean visible = false
  1807. integer taborder = 140
  1808. end type
  1809. event cb_add::clicked;//IF NOT f_power_ind(5) THEN
  1810. // MessageBox(publ_operator,'你没有使用权限!')
  1811. // RETURN
  1812. //END IF
  1813. //
  1814. //String arg_msg = ''
  1815. //Long uc_row,pagerert_row,i
  1816. //Long relid_pageretr,reld_uc
  1817. //
  1818. //IF dw_edit_mode THEN
  1819. // dw_uc.AcceptText()
  1820. // dw_child.AcceptText()
  1821. // uc_row = dw_uc.GetRow()
  1822. // IF uc_row <= 0 THEN
  1823. // MessageBox('系统提示','请选定当前目标单据!')
  1824. // RETURN
  1825. // END IF
  1826. //
  1827. // IF dw_uc.Object.u_saletask_moneyid[uc_row] = 0 THEN
  1828. // MessageBox('系统提示','请选择币种!')
  1829. // dw_uc.SetFocus()
  1830. // dw_uc.SetColumn("u_saletask_moneyid")
  1831. // RETURN
  1832. // END IF
  1833. //
  1834. // IF dw_uc.Object.u_saletask_banktypeid[uc_row] = 0 THEN
  1835. // MessageBox('系统提示','请选择结算方式!')
  1836. // dw_uc.SetFocus()
  1837. // dw_uc.SetColumn("u_saletask_banktypeid")
  1838. // RETURN
  1839. // END IF
  1840. //
  1841. // IF Year(Date(dw_uc.Object.requiredate[uc_row])) < 2000 THEN
  1842. // MessageBox('系统提示','要求完成日期为空或不合理!')
  1843. // dw_uc.SetFocus()
  1844. // dw_uc.SetColumn("requiredate")
  1845. // RETURN
  1846. // END IF
  1847. // IF NOT Len(String(dw_uc.Object.assign_emp[uc_row])) > 0 THEN
  1848. // MessageBox('系统提示','请选择业务员!')
  1849. // dw_uc.SetFocus()
  1850. // dw_uc.SetColumn("assign_emp")
  1851. // RETURN
  1852. // END IF
  1853. //
  1854. // IF NOT sys_power_issuper AND f_power_ind(977) THEN
  1855. // arg_msg = ''
  1856. // FOR i = 1 TO dw_child.RowCount()
  1857. // IF dw_child.Object.u_saletaskmx_enprice[i] = 0 THEN
  1858. // arg_msg = arg_msg + '第' + String(i) + '行,产品:' + dw_child.Object.u_mtrldef_mtrlcode[i] + ',单价为零!~n '
  1859. // END IF
  1860. // NEXT
  1861. // IF arg_msg <> '' THEN
  1862. // MessageBox('系统提示',arg_msg + '受系统限制,不能保存!')
  1863. // RETURN
  1864. // END IF
  1865. // END IF
  1866. //
  1867. // obj_saletask.requiredate = dw_uc.Object.requiredate[uc_row]
  1868. // obj_saletask.assign_emp = dw_uc.Object.assign_emp[uc_row]
  1869. // obj_saletask.Kind = dw_uc.Object.Kind[uc_row]
  1870. // obj_saletask.cusid = dw_uc.Object.cusid[uc_row]
  1871. // obj_saletask.dscrp = dw_uc.Object.dscrp[uc_row]
  1872. // obj_saletask.dscrp2 = dw_uc.Object.u_saletask_dscrp2[uc_row]
  1873. // obj_saletask.taskdate = dw_uc.Object.u_saletask_taskdate[uc_row]
  1874. // obj_saletask.banktypeid = dw_uc.Object.u_saletask_banktypeid[uc_row]
  1875. // obj_saletask.moneyid = dw_uc.Object.u_saletask_moneyid[uc_row]
  1876. // obj_saletask.damt = dw_uc.Object.u_saletask_damt[uc_row]
  1877. // obj_saletask.otheramt = dw_uc.Object.u_saletask_otheramt[uc_row]
  1878. // obj_saletask.relcode = dw_uc.Object.u_saletask_relcode[uc_row]
  1879. // obj_saletask.paytype = dw_uc.Object.u_saletask_paytype[uc_row]
  1880. // obj_saletask.freight = dw_uc.Object.u_saletask_freight[uc_row]
  1881. // obj_saletask.freight_tele = dw_uc.Object.u_saletask_freight_tele[uc_row]
  1882. // obj_saletask.cus_address = dw_uc.Object.u_saletask_cus_address[uc_row]
  1883. // obj_saletask.cus_tele = dw_uc.Object.u_saletask_cus_tele[uc_row]
  1884. // obj_saletask.cus_fax = dw_uc.Object.u_saletask_cus_fax[uc_row]
  1885. // obj_saletask.mrate = dw_uc.Object.u_saletask_mrate[uc_row]
  1886. //
  1887. //
  1888. // FOR i = 1 TO dw_child.RowCount()
  1889. // IF dw_child.Object.mtrlid[i] > 0 THEN
  1890. // IF obj_saletask.acceptmx(dw_child.Object.mtrlid[i],&
  1891. // dw_child.Object.usaleqty[i],&
  1892. // dw_child.Object.u_saletaskmx_orderqty[i],&
  1893. // dw_child.Object.u_saletaskmx_needbuyqty[i],&
  1894. // dw_child.Object.u_saletaskmx_enprice[i],&
  1895. // dw_child.Object.u_saletaskmx_rebate[i],&
  1896. // dw_child.Object.plprice[i],&
  1897. // dw_child.Object.u_saletaskmx_mxdscrp[i],&
  1898. // dw_child.Object.u_mtrldef_mtrlcode[i],&
  1899. // dw_child.Object.u_saletaskmx_status[i],&
  1900. // dw_child.Object.u_saletaskmx_woodcode[i],&
  1901. // dw_child.Object.u_saletaskmx_pcode[i],&
  1902. // dw_child.Object.u_saletaskmx_mtrlcuscode[i],&
  1903. // dw_child.Object.pid[i],&
  1904. // dw_child.Object.u_saletaskmx_outtype[i],&
  1905. // arg_msg,&
  1906. // dw_child.Object.u_saletaskmx_unit[i],&
  1907. // dw_child.Object.u_saletaskmx_rate[i],&
  1908. // '',dw_child.Object.u_saletaskmx_addqty[i]) = 0 THEN
  1909. // MessageBox('error!',arg_msg)
  1910. // RETURN
  1911. // END IF
  1912. // END IF
  1913. // NEXT
  1914. //
  1915. // IF obj_saletask.savesubmit(publ_operator,arg_msg,TRUE) = 0 THEN
  1916. // MessageBox('error!',arg_msg)
  1917. // RETURN
  1918. // END IF
  1919. // // messagebox(publ_operator,'保存操作成功!')
  1920. // //write ini
  1921. // f_SetProfileString (sys_empid,publ_userid+'_'+dw_uc.DataObject, "moneyid",String(dw_uc.Object.u_saletask_moneyid[dw_uc.GetRow()]))
  1922. // f_SetProfileString (sys_empid,dw_uc.DataObject, "dft_banktype",String(dw_uc.Object.u_saletask_banktypeid[dw_uc.GetRow()]))
  1923. //
  1924. // //
  1925. // Long ll_row
  1926. // ll_row = dw_pageretr.GetRow()
  1927. // dw_pageretr.SelectRow(0,FALSE)
  1928. // dw_pageretr.SelectRow(ll_row,TRUE)
  1929. // wf_refresh_curuc(cur_scid,obj_saletask.taskid) //刷新uc
  1930. //
  1931. //ELSE
  1932. // IF obj_saletask.newbegin(cur_scid,arg_msg) = 0 THEN //生产令领料
  1933. // MessageBox('error!',arg_msg)
  1934. // RETURN
  1935. // END IF
  1936. //END IF
  1937. //
  1938. //CALL SUPER::Clicked
  1939. //
  1940. //IF dw_edit_mode THEN
  1941. // PARENT.TriggerEvent("insert_childrow")
  1942. // String ls_moneyid,ls_banktype
  1943. //
  1944. // ls_moneyid = f_ProfileString (sys_empid,publ_userid+'_'+dw_uc.DataObject, "moneyid",'0')
  1945. // ls_banktype = f_ProfileString (sys_empid,dw_uc.DataObject, "dft_banktype",'0')
  1946. // dw_uc.SetRedraw(FALSE)
  1947. // dw_uc.Object.u_saletask_moneyid[dw_uc.GetRow()] = Long(ls_moneyid)
  1948. // dw_uc.Object.u_saletask_mrate[dw_uc.GetRow()] = f_get_mrate(Long(ls_moneyid))
  1949. // dw_uc.Object.u_saletask_banktypeid[dw_uc.GetRow()] = Long(ls_banktype)
  1950. // dw_uc.SetColumn("u_saletask_moneyid")
  1951. // dw_uc.SetRedraw(TRUE)
  1952. //ELSE
  1953. // PARENT.TriggerEvent("retrieve_childdw")
  1954. //END IF
  1955. //
  1956. //
  1957. //
  1958. //
  1959. //
  1960. //
  1961. //
  1962. end event
  1963. type cb_edit from w_publ_1ton_share_detail`cb_edit within w_saletask_sc
  1964. boolean visible = false
  1965. integer taborder = 110
  1966. end type
  1967. event cb_edit::clicked;//if not f_power_ind(5) then
  1968. // messagebox(publ_operator,'你没有使用权限!')
  1969. // return
  1970. //end if
  1971. //
  1972. //string arg_msg=''
  1973. //long uc_row
  1974. //
  1975. //if not dw_edit_mode then
  1976. // uc_row=dw_pageretr.getrow()
  1977. // if uc_row<=0 then
  1978. // messagebox('系统提示','请选定当前目标单据!')
  1979. // return
  1980. // end if
  1981. //end if
  1982. //
  1983. //if not dw_edit_mode then
  1984. // if obj_saletask.updatebegin(dw_pageretr.Object.u_saletask_scid[uc_row],dw_pageretr.object.taskid[uc_row],arg_msg)=0 then
  1985. // messagebox('Error!',arg_msg)
  1986. // return
  1987. // end if
  1988. //end if
  1989. //
  1990. //call super::clicked
  1991. end event
  1992. type cb_delet from w_publ_1ton_share_detail`cb_delet within w_saletask_sc
  1993. boolean visible = false
  1994. integer taborder = 170
  1995. end type
  1996. event cb_delet::clicked;call super::clicked;//if not f_power_ind(579) then
  1997. // messagebox(publ_operator,'你没有使用权限!')
  1998. // return
  1999. //end if
  2000. //
  2001. //if dw_edit_mode then return
  2002. //
  2003. //string arg_msg=''
  2004. //long uc_row
  2005. //
  2006. //uc_row=dw_pageretr.getrow()
  2007. //if uc_row<=0 then
  2008. // messagebox('系统提示','请选定当前目标订单!')
  2009. // return
  2010. //end if
  2011. //
  2012. //IF MessageBox ("IF","是否确定要删除当前吗",Question!,YesNo! ) = 2 THEN RETURN
  2013. //
  2014. //
  2015. //if obj_saletask.cancel(dw_pageretr.Object.u_saletask_scid[uc_row],dw_pageretr.object.taskid[uc_row],arg_msg,true)=0 then
  2016. // messagebox('Error!',arg_msg)
  2017. //ELSE
  2018. // //日志
  2019. // long ls_id
  2020. // string ls_code
  2021. // ls_id=dw_pageretr.object.taskid[uc_row]
  2022. // ls_code=dw_pageretr.object.taskCODE[uc_row]
  2023. // f_setsysoplog('销售订单','删除,ID:'+string(LS_id)+',code:'+ls_code,arg_msg,true)
  2024. // //--
  2025. // MESSAGEBOX(publ_operator,'删除单据'+string(dw_pageretr.object.taskCODE[uc_row])+'成功!')
  2026. //
  2027. //
  2028. // dw_pageretr.deleterow(uc_row)
  2029. // dw_pageretr.postevent(rowfocuschanged!)
  2030. //end if
  2031. end event
  2032. type cb_addzy from w_publ_1ton_share_detail`cb_addzy within w_saletask_sc
  2033. boolean visible = false
  2034. end type
  2035. event cb_addzy::clicked;call super::clicked;m_Dfc_Control_PopupMenu dmPopupMenu
  2036. string menustr
  2037. menustr="Text=增加备注~tEvent=ue_addzy"
  2038. menustr=menustr + "|" + "Text=-"
  2039. menustr=menustr + "|" + "Text=暂停订单~tEvent=ue_tempstoptask"
  2040. menustr=menustr + "|" + "Text=取消暂停~tEvent=ue_ctempstoptask"
  2041. menustr=menustr + "|" + "Text=终止订单~tEvent=ue_stopsaletask"
  2042. menustr=menustr + "|" + "Text=完成订单~tEvent=ue_finishtask"
  2043. menustr=menustr + "|" + "Text=-"
  2044. menustr=menustr + "|" + "Text=导入单价~tEvent=ue_importseleprice"
  2045. menustr=menustr + "|" + "Text=导入客户历史售价~tEvent=ue_importcusseleprice_his"
  2046. menustr=menustr + "|" + "Text=导入客户单价~tEvent=ue_importcusseleprice"
  2047. menustr = menustr + "|" + "Text=-"
  2048. menustr = menustr + "|" + "Text=查看附件~tEvent=ue_fj_view"
  2049. menustr = menustr + "|" + "Text=添加附件~tEvent=ue_fj_edit"
  2050. if len(trim(menustr))<>0 then
  2051. dmPopupMenu = Create m_Dfc_Control_PopupMenu
  2052. dmPopupMenu.mf_BuildMenu(This, menustr)
  2053. dmPopupMenu.mf_PopMenu()
  2054. Destroy dmPopupMenu
  2055. end if
  2056. end event
  2057. type cb_auditing from w_publ_1ton_share_detail`cb_auditing within w_saletask_sc
  2058. boolean visible = false
  2059. integer taborder = 190
  2060. end type
  2061. event cb_auditing::clicked;call super::clicked;//if not f_power_ind(6) then
  2062. // messagebox(publ_operator,'你没有使用权限!')
  2063. // return
  2064. //end if
  2065. //
  2066. //if dw_edit_mode then return
  2067. //string arg_msg=''
  2068. //long pagerert_row
  2069. //
  2070. //pagerert_row=dw_pageretr.getrow()
  2071. //if pagerert_row<=0 then
  2072. // messagebox('系统提示','请选定当前目标订单!')
  2073. // return
  2074. //end if
  2075. //IF MessageBox ("IF","是否确定要对当前订单作销售审核吗?",Question!,YesNo! ) = 2 THEN RETURN
  2076. //
  2077. //if obj_saletask.salepermit(dw_pageretr.Object.u_saletask_scid[pagerert_row],dw_pageretr.object.taskid[pagerert_row],publ_operator,arg_msg,true)=0 then
  2078. // messagebox('Error!',arg_msg)
  2079. //ELSE
  2080. // messagebox(publ_operator,'订单销售审核成功!')
  2081. // if cur_status <> -1 then
  2082. // dw_uc.deleterow(pagerert_row)
  2083. // else
  2084. // wf_refresh_curuc(dw_pageretr.Object.u_saletask_scid[pagerert_row],dw_pageretr.object.taskid[pagerert_row])
  2085. // end if
  2086. //end if
  2087. end event
  2088. type cb_xm from w_publ_1ton_share_detail`cb_xm within w_saletask_sc
  2089. boolean visible = false
  2090. integer taborder = 70
  2091. end type
  2092. type cb_retrieve from w_publ_1ton_share_detail`cb_retrieve within w_saletask_sc
  2093. integer taborder = 130
  2094. end type
  2095. type cb_xls from w_publ_1ton_share_detail`cb_xls within w_saletask_sc
  2096. integer x = 686
  2097. end type
  2098. type cb_help from w_publ_1ton_share_detail`cb_help within w_saletask_sc
  2099. integer x = 987
  2100. integer taborder = 100
  2101. end type
  2102. type cb_auditing_cancel from w_publ_1ton_share_detail`cb_auditing_cancel within w_saletask_sc
  2103. boolean visible = false
  2104. end type
  2105. event cb_auditing_cancel::clicked;call super::clicked;//IF NOT f_power_ind(8) THEN
  2106. // MessageBox(publ_operator,'你没有使用权限!')
  2107. // RETURN
  2108. //END IF
  2109. //
  2110. //IF dw_edit_mode THEN RETURN
  2111. //String arg_msg = ''
  2112. //Long pagerert_row
  2113. //
  2114. //pagerert_row = dw_pageretr.GetRow()
  2115. //IF pagerert_row <= 0 THEN
  2116. // MessageBox('系统提示','请选定当前目标订单!')
  2117. // RETURN
  2118. //END IF
  2119. //IF MessageBox ("IF","是否确定要对当前订单作取消审核吗?",Question!,YesNo! ) = 2 THEN RETURN
  2120. //
  2121. //IF obj_saletask.cancelpermit(dw_pageretr.Object.u_saletask_scid[pagerert_row],dw_pageretr.Object.taskid[pagerert_row],arg_msg,TRUE) = 0 THEN
  2122. // MessageBox('Error!',arg_msg)
  2123. //ELSE
  2124. // MessageBox(publ_operator,'订单取消审核成功!')
  2125. //
  2126. // //日志
  2127. // String ls_code,ls_opemp,ls_relcode
  2128. // ls_code = dw_pageretr.Object.taskcode[pagerert_row]
  2129. // ls_opemp = dw_pageretr.Object.u_saletask_opemp[pagerert_row]
  2130. // ls_relcode = dw_pageretr.Object.u_saletask_relcode[pagerert_row]
  2131. // f_setsysoplog('销售订单','撤审'+',code:'+ls_code+',相关号码:'+ls_relcode+',建立人:'+ls_opemp,arg_msg,TRUE)
  2132. // //--
  2133. //
  2134. // IF cur_status <> -1 THEN
  2135. //
  2136. // dw_uc.DeleteRow(pagerert_row)
  2137. // ELSE
  2138. // wf_refresh_curuc(dw_pageretr.Object.u_saletask_scid[pagerert_row],dw_pageretr.Object.taskid[pagerert_row])
  2139. // END IF
  2140. //END IF
  2141. end event
  2142. type p_msg from w_publ_1ton_share_detail`p_msg within w_saletask_sc
  2143. end type
  2144. type p_help from w_publ_1ton_share_detail`p_help within w_saletask_sc
  2145. end type
  2146. type p_encl from w_publ_1ton_share_detail`p_encl within w_saletask_sc
  2147. end type
  2148. type p_other from w_publ_1ton_share_detail`p_other within w_saletask_sc
  2149. end type
  2150. type gb_3 from w_publ_1ton_share_detail`gb_3 within w_saletask_sc
  2151. end type
  2152. type ln_bar from w_publ_1ton_share_detail`ln_bar within w_saletask_sc
  2153. end type
  2154. type ln_bar2 from w_publ_1ton_share_detail`ln_bar2 within w_saletask_sc
  2155. end type
  2156. type r_bar from w_publ_1ton_share_detail`r_bar within w_saletask_sc
  2157. integer height = 168
  2158. end type
  2159. type ln_1 from w_publ_1ton_share_detail`ln_1 within w_saletask_sc
  2160. integer endx = 3227
  2161. end type
  2162. type ln_2 from w_publ_1ton_share_detail`ln_2 within w_saletask_sc
  2163. integer endx = 3227
  2164. end type
  2165. type ddlb_retrstatus from dropdownlistbox within w_saletask_sc
  2166. integer x = 1787
  2167. integer y = 192
  2168. integer width = 489
  2169. integer height = 856
  2170. integer taborder = 80
  2171. integer textsize = -9
  2172. integer weight = 400
  2173. fontcharset fontcharset = gb2312charset!
  2174. fontpitch fontpitch = variable!
  2175. string facename = "宋体"
  2176. long textcolor = 33554432
  2177. string text = "待审批"
  2178. boolean sorted = false
  2179. boolean vscrollbar = true
  2180. string item[] = {"待审批","在进行","已暂停","已终止","已完成","[所有]",""}
  2181. borderstyle borderstyle = stylelowered!
  2182. end type
  2183. event selectionchanged;choose case index
  2184. case 1 //待销售审批
  2185. cur_status=0
  2186. case 2 //在进行
  2187. cur_status=1
  2188. case 3 //'已暂停'
  2189. cur_status=2
  2190. case 4 //'已终止'
  2191. cur_status=3
  2192. case 5 //'已完成'
  2193. cur_status=5
  2194. case else
  2195. cur_status= -1
  2196. end choose
  2197. parent.triggerevent("retrieve_pageretr")
  2198. end event
  2199. event constructor;cur_status=long(f_ProfileString (sys_empid, "saletask", "status", "-1"))
  2200. choose case cur_status
  2201. case 0
  2202. ddlb_retrstatus.text="待审核"
  2203. case 1
  2204. ddlb_retrstatus.text="在进行"
  2205. case 2
  2206. ddlb_retrstatus.text="已暂停"
  2207. case 3
  2208. ddlb_retrstatus.text="已终止"
  2209. case 5
  2210. ddlb_retrstatus.text="已完成"
  2211. case -1
  2212. ddlb_retrstatus.text="[所有]"
  2213. end choose
  2214. end event
  2215. type ddlb_scid from uo_ddlb_scid within w_saletask_sc
  2216. integer x = 1015
  2217. integer y = 192
  2218. integer width = 549
  2219. integer height = 620
  2220. integer taborder = 50
  2221. boolean bringtotop = true
  2222. end type
  2223. event constructor;call super::constructor;cur_scid=this.uo_scid
  2224. cur_scid_arr = THIS.uo_scid_arr
  2225. end event
  2226. event selectionchanged;call super::selectionchanged;cur_scid=this.uo_scid
  2227. cur_scid_arr = THIS.uo_scid_arr
  2228. parent.triggerevent("retrieve_pageretr")
  2229. end event
  2230. type st_2 from statictext within w_saletask_sc
  2231. integer x = 818
  2232. integer y = 208
  2233. integer width = 174
  2234. integer height = 48
  2235. boolean bringtotop = true
  2236. integer textsize = -9
  2237. integer weight = 400
  2238. fontcharset fontcharset = gb2312charset!
  2239. fontpitch fontpitch = variable!
  2240. string facename = "宋体"
  2241. long textcolor = 33554432
  2242. long backcolor = 134217739
  2243. string text = "分 部"
  2244. alignment alignment = right!
  2245. boolean focusrectangle = false
  2246. end type
  2247. type st_3 from statictext within w_saletask_sc
  2248. integer x = 1591
  2249. integer y = 208
  2250. integer width = 174
  2251. integer height = 48
  2252. boolean bringtotop = true
  2253. integer textsize = -9
  2254. integer weight = 400
  2255. fontcharset fontcharset = gb2312charset!
  2256. fontpitch fontpitch = variable!
  2257. string facename = "宋体"
  2258. long textcolor = 33554432
  2259. long backcolor = 134217739
  2260. string text = "状 态"
  2261. alignment alignment = right!
  2262. boolean focusrectangle = false
  2263. end type