w_taobao_outware_send.srw 51 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996
  1. $PBExportHeader$w_taobao_outware_send.srw
  2. forward
  3. global type w_taobao_outware_send from w_publ_base
  4. end type
  5. type cb_reflash from uo_imflatbutton within w_taobao_outware_send
  6. end type
  7. type dw_1 from u_dw_rbtnfilter within w_taobao_outware_send
  8. end type
  9. type cbx_1 from checkbox within w_taobao_outware_send
  10. end type
  11. type cb_edit from uo_imflatbutton within w_taobao_outware_send
  12. end type
  13. type cb_del from uo_imflatbutton within w_taobao_outware_send
  14. end type
  15. type cb_upload from uo_imflatbutton within w_taobao_outware_send
  16. end type
  17. type cb_print from uo_imflatbutton within w_taobao_outware_send
  18. end type
  19. type cb_edit_relstr_1 from commandbutton within w_taobao_outware_send
  20. end type
  21. type ddlb_im_type from dropdownlistbox within w_taobao_outware_send
  22. end type
  23. type st_2 from statictext within w_taobao_outware_send
  24. end type
  25. type sle_userid from singlelineedit within w_taobao_outware_send
  26. end type
  27. type cb_selectuser from uo_imflatbutton within w_taobao_outware_send
  28. end type
  29. type cb_export from uo_imflatbutton within w_taobao_outware_send
  30. end type
  31. type cb_fy from uo_imflatbutton within w_taobao_outware_send
  32. end type
  33. type cb_print_dir from uo_imflatbutton within w_taobao_outware_send
  34. end type
  35. type dw_2 from u_dw_rbtnfilter within w_taobao_outware_send
  36. end type
  37. type cb_amt_edit from uo_imflatbutton within w_taobao_outware_send
  38. end type
  39. type cb_amt_cancel from uo_imflatbutton within w_taobao_outware_send
  40. end type
  41. type cb_1 from uo_imflatbutton within w_taobao_outware_send
  42. end type
  43. type ln_bar from line within w_taobao_outware_send
  44. end type
  45. type ln_bar2 from line within w_taobao_outware_send
  46. end type
  47. type r_bar from rectangle within w_taobao_outware_send
  48. end type
  49. type ln_1 from line within w_taobao_outware_send
  50. end type
  51. type ln_2 from line within w_taobao_outware_send
  52. end type
  53. end forward
  54. global type w_taobao_outware_send from w_publ_base
  55. integer width = 3063
  56. integer height = 2084
  57. string title = "网店运输单打印"
  58. boolean maxbox = true
  59. boolean resizable = true
  60. windowstate windowstate = maximized!
  61. event ue_taobao_upload ( )
  62. event ue_print ( )
  63. event ue_p_edit_relstr_1 ( )
  64. event ue_select_user ( )
  65. event ue_xls_export ( )
  66. event ue_input_fy ( )
  67. event ue_input_fy_order ( )
  68. event ue_retrieve_mx ( )
  69. event ue_import_fy_xls ( )
  70. cb_reflash cb_reflash
  71. dw_1 dw_1
  72. cbx_1 cbx_1
  73. cb_edit cb_edit
  74. cb_del cb_del
  75. cb_upload cb_upload
  76. cb_print cb_print
  77. cb_edit_relstr_1 cb_edit_relstr_1
  78. ddlb_im_type ddlb_im_type
  79. st_2 st_2
  80. sle_userid sle_userid
  81. cb_selectuser cb_selectuser
  82. cb_export cb_export
  83. cb_fy cb_fy
  84. cb_print_dir cb_print_dir
  85. dw_2 dw_2
  86. cb_amt_edit cb_amt_edit
  87. cb_amt_cancel cb_amt_cancel
  88. cb_1 cb_1
  89. ln_bar ln_bar
  90. ln_bar2 ln_bar2
  91. r_bar r_bar
  92. ln_1 ln_1
  93. ln_2 ln_2
  94. end type
  95. global w_taobao_outware_send w_taobao_outware_send
  96. type variables
  97. long ins_child = 4
  98. long ins_child_min = 2
  99. uo_saletask_import ins_saletask_import
  100. //uo_ljlib_taobao_comapp ins_comapp
  101. ///////////////////////////////////////////////
  102. //oleobject ins_taobao
  103. boolean ins_create = false
  104. boolean ins_connected = false
  105. boolean ins_inited = false
  106. s_eb_user ins_user
  107. boolean ins_print_flag = false
  108. boolean ins_print_hz = false
  109. boolean dw_amt_edit_mode = false
  110. end variables
  111. forward prototypes
  112. public subroutine wf_face ()
  113. public subroutine wf_selectall ()
  114. public function integer wf_save (ref string arg_msg)
  115. public function integer wf_save_amt (ref string arg_msg)
  116. public function integer wf_check ()
  117. end prototypes
  118. event ue_taobao_upload();IF Not uo_power_spi.f_taobao_outware_send_upload(sys_msg_pow) THEN
  119. MessageBox(publ_operator,sys_msg_pow)
  120. RETURN
  121. END IF
  122. Int rslt = 1
  123. String arg_msg = ''
  124. String arr_outwarecode[], ls_lastcode = ''
  125. Long cnt = 0
  126. Long i
  127. dw_1.SetSort("eb_saletask_import_sendflag A u_outware_outwarecode A eb_saletask_import_tid A")
  128. dw_1.Sort()
  129. IF wf_check() = 0 THEN
  130. RETURN
  131. END IF
  132. FOR i = 1 To dw_1.RowCount()
  133. IF dw_1.Object.ch[i] <> 1 THEN CONTINUE
  134. IF dw_1.Object.u_outware_outwarecode[i] = ls_lastcode THEN CONTINUE
  135. cnt++
  136. arr_outwarecode[cnt] = dw_1.Object.u_outware_outwarecode[i]
  137. NEXT
  138. IF cnt <= 0 THEN
  139. MessageBox('提示', '请选择要淘宝发货的对象')
  140. RETURN
  141. END IF
  142. FOR i = 1 To cnt
  143. UPDATE eb_saletask_import
  144. SET out_freight = CASE WHEN ISNULL(u_station.taobao_code, '') <> '' THEN u_station.taobao_code ELSE u_outware.relstr_1 END,
  145. out_freight_code = u_outware.transcode, sendflag = 1
  146. FROM u_outwaremx INNER JOIN
  147. u_outware ON u_outwaremx.scid = u_outware.scid AND u_outwaremx.outwareid = u_outware.outwareid INNER JOIN
  148. u_SaleTaskMx ON u_outwaremx.relid = u_SaleTaskMx.TaskID AND u_outwaremx.scid = u_SaleTaskMx.scid AND
  149. u_outwaremx.relprintid = u_SaleTaskMx.printid INNER JOIN
  150. u_SaleTask ON u_SaleTaskMx.scid = u_SaleTask.scid AND u_SaleTaskMx.TaskID = u_SaleTask.TaskID INNER JOIN
  151. eb_saletask_import ON u_SaleTask.TaskCode = eb_saletask_import.taskcode LEFT OUTER JOIN
  152. u_station ON u_outware.relstr_1 = u_station.stationname
  153. WHERE (u_outwaremx.ifrel = 1)
  154. AND (eb_saletask_import.t_sendflag = 0)
  155. AND (u_outware.relstr_1 <> '')
  156. And (u_outware.outwarecode = :arr_outwarecode[i]);
  157. IF sqlca.SQLCode <> 0 THEN
  158. rslt = 0
  159. arg_msg = '提交上传淘宝发货单信息失败,' + sqlca.SQLErrText
  160. GOTO ext
  161. END IF
  162. NEXT
  163. ext:
  164. IF rslt = 1 THEN
  165. COMMIT;
  166. MessageBox('OK', '淘宝发货单信息更新成功,后台将自动上传淘宝')
  167. cb_reflash.TriggerEvent(Clicked!)
  168. ELSE
  169. ROLLBACK;
  170. MessageBox('ERROR', arg_msg)
  171. END IF
  172. end event
  173. event ue_print();//--直接打印
  174. Long ls_msgprintid
  175. String ls_newname
  176. Long ls_powerid
  177. Long pcnt = 0
  178. String ls_dwname = ''
  179. String ls_chname
  180. Long i
  181. s_taobao_outware_print s_tran
  182. s_taobao_outware_print_rslt s_rslt
  183. uo_print_preview uo_print
  184. String arg_msg
  185. s_print_msg ls_prmsg
  186. Boolean lb_first = True
  187. String arr_outwarecode[], ls_parm
  188. Long cnt = 0
  189. Long Pos = 0
  190. String ls_lastcode = ''
  191. Long lastprintnum = 0
  192. ls_msgprintid = Message.LongParm
  193. //messagebox('', string(ls_msgprintid))
  194. IF Not uo_power_spi.f_taobao_outware_send_print_save(sys_msg_pow) THEN
  195. MessageBox(publ_operator,sys_msg_pow)
  196. RETURN
  197. END IF
  198. SELECT dft_new_dwname,powerid,chnname
  199. INTO :ls_newname,:ls_powerid,:ls_chname
  200. FROM sys_dft_dwprint_dynamic
  201. Where sys_dft_dwprint_dynamic.dwprintid = :ls_msgprintid Using sqlca;
  202. IF sqlca.SQLCode <> 0 THEN
  203. ls_newname = ''
  204. ls_powerid = 0
  205. END IF
  206. IF ls_newname <> '' THEN
  207. IF Not uo_power_spi.uf_power_ind(ls_powerid,sys_msg_pow) THEN
  208. MessageBox(publ_operator,sys_msg_pow)
  209. RETURN
  210. END IF
  211. ls_dwname = ls_newname
  212. ELSE
  213. // TODO: 默认打印格式
  214. ls_dwname = ''
  215. END IF
  216. dw_1.SetSort("eb_saletask_import_sendflag A u_outware_outwarecode A eb_saletask_import_tid A")
  217. dw_1.Sort()
  218. IF wf_check() = 0 THEN
  219. RETURN
  220. END IF
  221. IF ins_print_hz THEN
  222. IF ls_dwname = '' THEN
  223. MessageBox('提示', '请定义自定义打印格式,所属窗口:w_taobao_outware_send_hz')
  224. ls_dwname = 'dw_rp_taobao_hz_outware'
  225. END IF
  226. FOR i = 1 To dw_1.RowCount()
  227. IF dw_1.Object.ch[i] <> 1 THEN CONTINUE
  228. IF dw_1.Object.u_outware_outwarecode[i] = ls_lastcode THEN CONTINUE
  229. ls_lastcode = dw_1.Object.u_outware_outwarecode[i]
  230. cnt++
  231. arr_outwarecode[cnt] = dw_1.Object.u_outware_outwarecode[i]
  232. NEXT
  233. IF cnt <= 0 THEN
  234. MessageBox('提示', '请勾选汇总打印的发货单')
  235. RETURN
  236. END IF
  237. ls_parm = ''
  238. FOR i = 1 To UpperBound(arr_outwarecode)
  239. ls_parm += ',' + arr_outwarecode[i]
  240. NEXT
  241. ls_parm += ','
  242. ls_prmsg.retr_pram_falg = 1
  243. ls_prmsg.obj_dwNAME = ls_dwname
  244. ls_prmsg.printrow = 0
  245. ls_prmsg.tag_text = '销售发货单汇总'
  246. ls_prmsg.filter_string = ''
  247. ls_prmsg.pagech_flag = 0
  248. ls_prmsg.retr_pramstr = ls_parm
  249. MessageBox('', ls_prmsg.retr_pramstr)
  250. ls_prmsg.rowcnt = 0
  251. OpenWithParm(w_publ_preview,ls_prmsg)
  252. printnum = Message.DoubleParm
  253. ELSE
  254. IF ls_dwname = '' THEN
  255. MessageBox('提示', '请定义自定义打印格式,所属窗口:w_taobao_outware_send')
  256. ls_dwname = 'dw_rp_taobao_trans'
  257. END IF
  258. cnt = 0
  259. FOR i = 1 To dw_1.RowCount()
  260. IF dw_1.Object.ch[i] <> 1 THEN CONTINUE
  261. IF dw_1.Object.u_outware_outwarecode[i] = ls_lastcode THEN CONTINUE
  262. ls_lastcode = dw_1.Object.u_outware_outwarecode[i]
  263. cnt++
  264. NEXT
  265. ls_lastcode = ''
  266. IF ins_print_flag THEN // 直接打印
  267. FOR i = 1 To dw_1.RowCount()
  268. IF dw_1.Object.ch[i] <> 1 THEN CONTINUE
  269. IF dw_1.Object.u_outware_outwarecode[i] = ls_lastcode THEN
  270. dw_1.Object.eb_saletask_import_printnum[i] = lastprintnum
  271. CONTINUE
  272. END IF
  273. ls_lastcode = dw_1.Object.u_outware_outwarecode[i]
  274. ls_prmsg.retr_pram_falg = 12
  275. ls_prmsg.obj_dwNAME = ls_dwname
  276. ls_prmsg.printrow = 0
  277. ls_prmsg.tag_text = '销售发货单'
  278. ls_prmsg.filter_string = ''
  279. ls_prmsg.pagech_flag = 0
  280. ls_prmsg.retr_scid = dw_1.Object.scid[i]
  281. ls_prmsg.retr_pramnmb = dw_1.Object.outwareid[i]
  282. ls_prmsg.rowcnt = 0
  283. IF lb_first THEN
  284. OpenWithParm(w_publ_preview,ls_prmsg)
  285. printnum = Message.DoubleParm
  286. IF printnum <= 0 THEN
  287. RETURN
  288. END IF
  289. //**更新打印次料
  290. UPDATE eb_saletask_import
  291. SET printnum = eb_saletask_import.printnum + :printnum
  292. FROM u_outwaremx INNER JOIN
  293. u_outware ON u_outwaremx.scid = u_outware.scid AND u_outwaremx.outwareid = u_outware.outwareid INNER JOIN
  294. u_SaleTaskMx ON u_outwaremx.relid = u_SaleTaskMx.TaskID AND u_outwaremx.scid = u_SaleTaskMx.scid AND
  295. u_outwaremx.relprintid = u_SaleTaskMx.printid INNER JOIN
  296. u_SaleTask ON u_SaleTaskMx.scid = u_SaleTask.scid AND u_SaleTaskMx.TaskID = u_SaleTask.TaskID INNER JOIN
  297. eb_saletask_import ON u_SaleTask.TaskCode = eb_saletask_import.taskcode
  298. Where (u_outwaremx.ifrel = 1) And (u_outware.outwarecode = :ls_lastcode);
  299. COMMIT;
  300. dw_1.Object.eb_saletask_import_printnum[i] = dw_1.Object.eb_saletask_import_printnum[i] + printnum
  301. lastprintnum = dw_1.Object.eb_saletask_import_printnum[i]
  302. lb_first = False
  303. cnt --
  304. IF cnt > 0 THEN
  305. Open(w_sys_wait_jdt) //初始化进度条
  306. w_sys_wait_jdt.Show()
  307. w_sys_wait_jdt.wf_accepttol(cnt)
  308. w_sys_wait_jdt.wf_inc(0)
  309. w_sys_wait_jdt.st_msg.Text = "正在打印快递单..."
  310. END IF
  311. ELSE
  312. Pos++
  313. w_sys_wait_jdt.wf_inc(Pos)
  314. w_sys_wait_jdt.st_msg.Text = "正在打印快递单["+dw_1.Object.u_outware_transcode[i]+"]..."
  315. uo_print.FACT_PRINT_MSG = ls_prmsg
  316. IF uo_print.uof_print_begin(arg_msg) = 0 THEN
  317. Close(w_sys_wait_jdt)
  318. MessageBox("系统提示",arg_msg)
  319. RETURN
  320. END IF
  321. uo_print.ds_print()
  322. //**更新打印次料
  323. printnum = Message.DoubleParm
  324. UPDATE eb_saletask_import
  325. SET printnum = eb_saletask_import.printnum + :printnum
  326. FROM u_outwaremx INNER JOIN
  327. u_outware ON u_outwaremx.scid = u_outware.scid AND u_outwaremx.outwareid = u_outware.outwareid INNER JOIN
  328. u_SaleTaskMx ON u_outwaremx.relid = u_SaleTaskMx.TaskID AND u_outwaremx.scid = u_SaleTaskMx.scid AND
  329. u_outwaremx.relprintid = u_SaleTaskMx.printid INNER JOIN
  330. u_SaleTask ON u_SaleTaskMx.scid = u_SaleTask.scid AND u_SaleTaskMx.TaskID = u_SaleTask.TaskID INNER JOIN
  331. eb_saletask_import ON u_SaleTask.TaskCode = eb_saletask_import.taskcode
  332. Where (u_outwaremx.ifrel = 1) And (u_outware.outwarecode = :ls_lastcode);
  333. COMMIT;
  334. dw_1.Object.eb_saletask_import_printnum[i] = dw_1.Object.eb_saletask_import_printnum[i] + printnum
  335. lastprintnum = dw_1.Object.eb_saletask_import_printnum[i]
  336. END IF
  337. NEXT
  338. IF cnt > 0 THEN
  339. Close(w_sys_wait_jdt)
  340. END IF
  341. ELSE
  342. FOR i = 1 To dw_1.RowCount()
  343. IF dw_1.Object.ch[i] <> 1 THEN CONTINUE
  344. IF dw_1.Object.u_outware_outwarecode[i] = ls_lastcode THEN CONTINUE
  345. ls_lastcode = dw_1.Object.u_outware_outwarecode[i]
  346. dw_1.SetRow(i)
  347. dw_1.ScrollToRow(i)
  348. s_tran.outwarecode = dw_1.Object.u_outware_outwarecode[i]
  349. s_tran.dwname = ls_dwname
  350. s_tran.chname = ls_chname
  351. OpenWithParm(w_taobao_outware_print, s_tran)
  352. s_rslt = Message.PowerObjectParm
  353. IF s_rslt.ifcontinue <> 1 THEN
  354. EXIT
  355. END IF
  356. dw_1.Object.u_outware_relstr_1[i] = s_rslt.relstr_1
  357. dw_1.Object.u_outware_transcode[i] = s_rslt.transcode
  358. NEXT
  359. END IF
  360. END IF
  361. end event
  362. event ue_p_edit_relstr_1();IF Not dw_edit_mode THEN RETURN
  363. Long i
  364. Long cnt = 0
  365. s_outware_rel_str_ch s_tran
  366. FOR i = 1 To dw_1.RowCount()
  367. IF dw_1.Object.ch[i] = 1 THEN
  368. cnt++
  369. s_tran.rel_str1 = dw_1.Object.u_outware_relstr_1[i]
  370. EXIT
  371. END IF
  372. NEXT
  373. IF cnt <= 0 THEN
  374. MessageBox('提示', '请选择批修改的发货单')
  375. RETURN
  376. END IF
  377. //s_tran.ins_taobao = ins_taobao
  378. OpenWithParm(w_outware_rel_str_ch, s_tran)
  379. s_tran = Message.PowerObjectParm
  380. IF s_tran.ifok <> 1 THEN RETURN
  381. longlong ll_pos = 0
  382. String ls_lastcode = ''
  383. FOR i = 1 To dw_1.RowCount()
  384. IF dw_1.Object.ch[i] = 1 THEN
  385. dw_1.Object.u_outware_relstr_1[i] = s_tran.rel_str1
  386. IF Not IsNull(s_tran.fcode) THEN
  387. IF ll_pos = 0 THEN
  388. ll_pos = Long(s_tran.fcode)
  389. s_tran.fcode = Fill("0", Len(s_tran.fcode))
  390. END IF
  391. IF dw_1.Object.u_outware_outwarecode[i] = ls_lastcode THEN
  392. dw_1.Object.u_outware_transcode[i] = f_cmpl_trancode(s_tran.rel_str1, s_tran.pre_str, String(ll_pos - 1,s_tran.fcode), s_tran.post_str)
  393. ELSE
  394. dw_1.Object.u_outware_transcode[i] = f_cmpl_trancode(s_tran.rel_str1, s_tran.pre_str, String(ll_pos,s_tran.fcode), s_tran.post_str)
  395. ll_pos++
  396. ls_lastcode = dw_1.Object.u_outware_outwarecode[i]
  397. END IF
  398. END IF
  399. END IF
  400. NEXT
  401. end event
  402. event ue_select_user();Long ins_im_type
  403. IF ddlb_im_type.Text = '其它' THEN
  404. ins_im_type = 0
  405. ELSEIF ddlb_im_type.Text = '亚洲国际电商' THEN
  406. ins_im_type = 1
  407. ELSEIF ddlb_im_type.Text = '淘宝' THEN
  408. ins_im_type = 5
  409. ELSEIF ddlb_im_type.Text = '京东' THEN
  410. ins_im_type = 6
  411. ELSE
  412. ins_im_type = -1
  413. END IF
  414. s_eb_user s_ch
  415. OpenWithParm(w_eb_user_define_ch, ins_im_type)
  416. s_ch = Message.PowerObjectParm
  417. IF s_ch.UserID > 0 THEN
  418. ins_user = s_ch
  419. END IF
  420. f_setprofilestring(sys_empid, 'w_taobao_outware_send', 'im_type', String(ins_user.im_type))
  421. f_setprofilestring(sys_empid, 'w_taobao_outware_send', 'im_userid', ins_user.im_userid)
  422. IF ins_user.im_type = 0 THEN
  423. ddlb_im_type.Text = '其它'
  424. ELSEIF ins_user.im_type = 1 THEN
  425. ddlb_im_type.Text = '亚洲国际电商'
  426. ELSEIF ins_user.im_type = 5 THEN
  427. ddlb_im_type.Text = '淘宝'
  428. ELSEIF ins_user.im_type = 6 THEN
  429. ddlb_im_type.Text = '京东'
  430. ELSE
  431. ddlb_im_type.Text = '全部'
  432. END IF
  433. sle_userid.Text = ins_user.im_userid
  434. cb_reflash.TriggerEvent(Clicked!)
  435. end event
  436. event ue_xls_export();IF Not uo_power_spi.f_taobao_outware_send_export(sys_msg_pow) THEN
  437. MessageBox(publ_operator,sys_msg_pow)
  438. RETURN
  439. END IF
  440. Integer i
  441. String Pathname,Filename
  442. String arg_filename,arg_msg
  443. Blob arg_blob
  444. IF GetFileSaveName("选择备份文件",Pathname,Filename,'xls',"Excel,*.xls") <> 1 THEN RETURN
  445. arg_filename = Trim(Pathname)
  446. IF arg_filename = '' THEN
  447. MessageBox('提示','请输入文件名称', Information!, OK! )
  448. RETURN
  449. END IF
  450. IF FileExists(arg_filename) THEN
  451. IF MessageBox("询问","指定文件已经存在,是否覆盖该文件?",question!,yesno!,2) = 2 THEN
  452. RETURN
  453. END IF
  454. END IF
  455. //gf_dw_to_excel(dw_1, arg_filename)
  456. dw_1.SaveAsAscii(arg_filename)
  457. MessageBox('OK', '导出成功!')
  458. end event
  459. event ue_input_fy();IF Not uo_power_spi.uf_power_ind(3795,sys_msg_pow) THEN
  460. MessageBox(publ_operator,sys_msg_pow)
  461. RETURN
  462. END IF
  463. Open(w_taobao_fy_input)
  464. cb_reflash.TriggerEvent(Clicked!)
  465. end event
  466. event ue_input_fy_order();IF Not uo_power_spi.uf_power_ind(3795,sys_msg_pow) THEN
  467. MessageBox(publ_operator,sys_msg_pow)
  468. RETURN
  469. END IF
  470. Long i
  471. s_taobao_fy_order_input_parm s_parm
  472. s_taobao_fy_order_input_rslt s_rslt
  473. FOR i = 1 To dw_1.RowCount()
  474. IF dw_1.Object.ch[i] <> 1 THEN CONTINUE
  475. dw_1.SetRow(i)
  476. dw_1.ScrollToRow(i)
  477. s_parm.scid = dw_1.Object.scid[i]
  478. s_parm.outwareid = dw_1.Object.outwareid[i]
  479. OpenWithParm(w_taobao_fy_order_input, s_parm)
  480. s_rslt = Message.PowerObjectParm
  481. IF s_rslt.ifcontinue <> 1 THEN
  482. EXIT
  483. END IF
  484. NEXT
  485. cb_reflash.TriggerEvent(Clicked!)
  486. end event
  487. event ue_retrieve_mx();Long ll_row
  488. ll_row = dw_1.GetRow()
  489. IF ll_row <= 0 THEN
  490. dw_2.Reset()
  491. RETURN
  492. END IF
  493. dw_2.Retrieve(dw_1.Object.scid[ll_row], dw_1.Object.outwareid[ll_row])
  494. end event
  495. event ue_import_fy_xls();// DONE: 导入xls
  496. String ls_path, ls_filename
  497. IF GetFileOpenName("请选择要导入的Excel文件", ls_path, ls_filename, "XLS","Excel文件(*.XLS),*.XLS") <> 1 THEN
  498. RETURN
  499. END IF
  500. Long itemid
  501. String itemcode,itemname, itemtype
  502. String arg_msg = ''
  503. IF uo_saletask_spi.wf_itemdef_ch(Ref itemid, Ref itemcode, Ref itemname, Ref itemtype, Ref arg_msg) <> 1 THEN
  504. RETURN
  505. END IF
  506. Int rslt = 1
  507. arg_msg = ''
  508. DataStore ds_import
  509. ds_import = Create DataStore
  510. ds_import.DataObject = 'ds_taobao_outware_amt_import'
  511. uo_taobao_outware uo_taobao
  512. uo_taobao = Create uo_taobao_outware
  513. IF f_xls_import_to_dw(ls_path, ds_import, arg_msg) <> 1 THEN
  514. rslt = 0
  515. GOTO ext
  516. END IF
  517. Long i
  518. String ls_transcode
  519. Long scid, outwareid, cnt
  520. Decimal amt
  521. String ls_msg
  522. FOR i = 1 To ds_import.RowCount()
  523. ls_transcode = Trim(ds_import.Object.transcode[i], True)
  524. amt = ds_import.Object.amt[i]
  525. IF ls_transcode = '' THEN CONTINUE
  526. SELECT count(0)
  527. INTO :cnt
  528. FROM u_outware
  529. Where transcode = :ls_transcode;
  530. IF sqlca.SQLCode <> 0 THEN
  531. IF arg_msg <> '' THEN arg_msg += '~r~n'
  532. arg_msg += '第'+String(i)+'行,货运单号:'+ls_transcode+',查询对应发货单数失败,' + sqlca.SQLErrText
  533. CONTINUE
  534. END IF
  535. IF cnt = 0 THEN
  536. IF arg_msg <> '' THEN arg_msg += '~r~n'
  537. arg_msg += '第'+String(i)+'行,货运单号:'+ls_transcode+',找不能对应发货单'
  538. CONTINUE
  539. END IF
  540. IF cnt > 1 THEN
  541. IF arg_msg <> '' THEN arg_msg += '~r~n'
  542. arg_msg += '第'+String(i)+'行,货运单号:'+ls_transcode+',找到多条发货单记录'
  543. CONTINUE
  544. END IF
  545. SELECT top 1 scid, outwareid
  546. INTO :scid, :outwareid
  547. FROM u_outware
  548. Where transcode = :ls_transcode;
  549. IF sqlca.SQLCode <> 0 THEN
  550. IF arg_msg <> '' THEN arg_msg += '~r~n'
  551. arg_msg += '第'+String(i)+'行,货运单号:'+ls_transcode+',查询对应发货单信息失败,' + sqlca.SQLErrText
  552. CONTINUE
  553. END IF
  554. IF uo_taobao.add_tranfy(scid, outwareid, itemid, amt, ls_msg, True) <> 1 THEN
  555. IF arg_msg <> '' THEN arg_msg += '~r~n'
  556. arg_msg += '第'+String(i)+'行,货运单号:'+ls_transcode+',' + ls_msg
  557. CONTINUE
  558. END IF
  559. NEXT
  560. ext:
  561. Destroy ds_import
  562. Destroy uo_taobao
  563. IF rslt = 0 Or arg_msg <> '' THEN
  564. MessageBox('ERROR', arg_msg)
  565. ELSE
  566. MessageBox('OK', '导入成功')
  567. END IF
  568. end event
  569. public subroutine wf_face ();// DONE: 刷新界面
  570. Long i
  571. ddlb_im_type.Enabled = Not (dw_edit_mode Or dw_amt_edit_mode)
  572. cb_selectuser.Enabled = Not (dw_edit_mode Or dw_amt_edit_mode)
  573. cb_reflash.Enabled = Not (dw_edit_mode Or dw_amt_edit_mode)
  574. cb_del.Enabled = dw_edit_mode
  575. cb_amt_cancel.Enabled = dw_amt_edit_mode
  576. cb_upload.Enabled = Not (dw_edit_mode Or dw_amt_edit_mode)
  577. cb_print.Enabled = Not (dw_edit_mode Or dw_amt_edit_mode)
  578. cb_export.Enabled = Not (dw_edit_mode Or dw_amt_edit_mode)
  579. cb_fy.Enabled = Not (dw_edit_mode Or dw_amt_edit_mode)
  580. cb_edit_relstr_1.Enabled = dw_edit_mode
  581. cb_edit.Enabled = Not dw_amt_edit_mode
  582. cb_amt_edit.Enabled = Not dw_edit_mode
  583. cb_print_dir.Enabled = Not dw_edit_mode
  584. cb_1.Enabled = not dw_edit_mode
  585. dw_1.titleclick_sort_use = not dw_edit_mode
  586. IF dw_amt_edit_mode THEN
  587. dw_1.SetTabOrder('inputamt', 10)
  588. cb_amt_edit.Text = '保存'
  589. cb_amt_edit.normalpicname = 'Save.bmp'
  590. ELSE
  591. dw_1.SetTabOrder('inputamt', 0)
  592. cb_amt_edit.Text = '修改'
  593. cb_amt_edit.normalpicname = 'OPEN.bmp'
  594. END IF
  595. IF dw_edit_mode THEN
  596. dw_1.SetSort("eb_saletask_import_sendflag A u_outware_outwarecode A eb_saletask_import_tid A")
  597. dw_1.Sort()
  598. FOR i = 1 To ins_child
  599. dw_1.SetTabOrder(i, i * 10)
  600. NEXT
  601. cb_edit.Text = '保存'
  602. cb_edit.normalpicname = 'Save.bmp'
  603. ELSE
  604. FOR i = 1 To ins_child_min - 1
  605. dw_1.SetTabOrder(i, i * 10)
  606. NEXT
  607. FOR i = ins_child_min To ins_child
  608. dw_1.SetTabOrder(i, 0)
  609. NEXT
  610. cb_edit.Text = '修改'
  611. cb_edit.normalpicname = 'OPEN.bmp'
  612. END IF
  613. cb_edit.of_init_draw()
  614. cb_edit.of_paint()
  615. cb_edit.TriggerEvent('ue_textchange')
  616. cb_amt_edit.of_init_draw()
  617. cb_amt_edit.of_paint()
  618. cb_amt_edit.TriggerEvent('ue_textchange')
  619. end subroutine
  620. public subroutine wf_selectall ();Long ll_check
  621. IF cbx_1.Checked THEN
  622. ll_check = 1
  623. ELSE
  624. ll_check = 0
  625. END IF
  626. Long i
  627. FOR i = 1 To dw_1.RowCount()
  628. dw_1.Object.ch[i] = ll_check
  629. NEXT
  630. end subroutine
  631. public function integer wf_save (ref string arg_msg);Int rslt = 1
  632. uo_taobao_outware = Create uo_taobao_outware
  633. // DONE: 保存货运单号
  634. Long i, j
  635. String arr_outwarecode[], arr_relstr_1[], arr_transcode[]
  636. decimal arr_tb_weight[]
  637. Long cnt = 0
  638. String ls_outwarecode
  639. FOR i = 1 To dw_1.RowCount()
  640. IF dw_1.Object.ch[i] <> 1 THEN CONTINUE
  641. ls_outwarecode = dw_1.Object.u_outware_outwarecode[i]
  642. FOR j = 1 To cnt
  643. IF arr_outwarecode[j] = ls_outwarecode THEN
  644. EXIT
  645. END IF
  646. NEXT
  647. IF j > cnt THEN
  648. cnt++
  649. arr_outwarecode[cnt] = dw_1.Object.u_outware_outwarecode[i]
  650. arr_relstr_1[cnt] = dw_1.Object.u_outware_relstr_1[i]
  651. arr_transcode[cnt] = dw_1.Object.u_outware_transcode[i]
  652. arr_tb_weight[cnt] = dw_1.Object.u_outware_tb_weight[i]
  653. END IF
  654. NEXT
  655. IF cnt <= 0 THEN
  656. rslt = 0
  657. arg_msg = '请选择要保存的发货单'
  658. GOTO ext
  659. END IF
  660. FOR i = 1 To cnt
  661. IF uo_taobao_outware.save_transcode(arr_outwarecode[i], arr_relstr_1[i], arr_transcode[i], arr_tb_weight[i], arg_msg, False) <> 1 THEN
  662. rslt = 0
  663. GOTO ext
  664. END IF
  665. NEXT
  666. ext:
  667. Destroy uo_taobao_outware
  668. IF rslt = 1 THEN
  669. COMMIT;
  670. ELSE
  671. ROLLBACK;
  672. END IF
  673. RETURN rslt
  674. end function
  675. public function integer wf_save_amt (ref string arg_msg);Int rslt = 1
  676. uo_taobao_outware = Create uo_taobao_outware
  677. // DONE: 保存货运单号
  678. Long i, j, cnt = 0
  679. Long itemid
  680. String itemcode,itemname, itemtype
  681. arg_msg = ''
  682. IF uo_saletask_spi.wf_itemdef_ch(Ref itemid, Ref itemcode, Ref itemname, Ref itemtype, Ref arg_msg) <> 1 THEN
  683. rslt = 0
  684. goto ext
  685. END IF
  686. Long ll_itemid
  687. ll_itemid = itemid
  688. String arr_outwarecode[]
  689. Long arr_scid[], arr_outwareid[]
  690. Long arr_itemid[]
  691. Decimal arr_amt[]
  692. FOR i = 1 To dw_1.RowCount()
  693. IF dw_1.Object.ch[i] <> 1 THEN CONTINUE
  694. FOR j = 1 To cnt
  695. IF arr_scid[j] = dw_1.Object.scid[i] And arr_outwareid[j] = dw_1.Object.outwareid[i] THEN
  696. EXIT
  697. END IF
  698. NEXT
  699. IF j > cnt THEN
  700. cnt++
  701. arr_scid[cnt] = dw_1.Object.scid[i]
  702. arr_outwareid[cnt] = dw_1.Object.outwareid[i]
  703. arr_itemid[cnt] = ll_itemid
  704. arr_amt[cnt] = dw_1.Object.inputamt[i]
  705. arr_outwarecode[cnt] = dw_1.Object.u_outware_outwarecode[i]
  706. END IF
  707. NEXT
  708. IF cnt <= 0 THEN
  709. rslt = 0
  710. arg_msg = '请选择要保存的发货单'
  711. GOTO ext
  712. END IF
  713. FOR i = 1 To cnt
  714. IF uo_taobao_outware.add_tranfy(arr_scid[i], arr_outwareid[i], ll_itemid, arr_amt[i], arg_msg, False) <> 1 THEN
  715. rslt = 0
  716. arg_msg = '发货单' + arr_outwarecode[i] + ':' + arg_msg
  717. GOTO ext
  718. END IF
  719. NEXT
  720. ext:
  721. Destroy uo_taobao_outware
  722. IF rslt = 1 THEN
  723. COMMIT;
  724. ELSE
  725. ROLLBACK;
  726. END IF
  727. RETURN rslt
  728. end function
  729. public function integer wf_check ();// 检查订单是否已经关闭或申请退款
  730. Long i = 0, cnt = 0
  731. String ls_lastcode = ''
  732. String arr_outwarecode[], ls_parm
  733. FOR i = 1 To dw_1.RowCount()
  734. IF dw_1.Object.ch[i] <> 1 THEN CONTINUE
  735. IF dw_1.Object.u_outware_outwarecode[i] = ls_lastcode THEN CONTINUE
  736. ls_lastcode = dw_1.Object.u_outware_outwarecode[i]
  737. cnt++
  738. arr_outwarecode[cnt] = dw_1.Object.u_outware_outwarecode[i]
  739. NEXT
  740. IF cnt <= 0 THEN
  741. MessageBox('提示', '请勾选汇总打印的发货单')
  742. RETURN 0
  743. END IF
  744. ls_parm = ''
  745. FOR i = 1 To UpperBound(arr_outwarecode)
  746. ls_parm += ',' + arr_outwarecode[i]
  747. NEXT
  748. ls_parm += ','
  749. String ls_outwarecode, ls_tid, ls_status, ls_msg
  750. ls_msg = ''
  751. DECLARE cur1 CURSOR FOR
  752. SELECT u_outware.outwarecode, eb_saletask_import.tid,tb_order.status
  753. FROM u_outwaremx INNER JOIN
  754. u_outware ON u_outwaremx.scid = u_outware.scid AND u_outwaremx.outwareid = u_outware.outwareid INNER JOIN
  755. u_SaleTaskMx ON u_outwaremx.relid = u_SaleTaskMx.TaskID AND u_outwaremx.scid = u_SaleTaskMx.scid AND
  756. u_outwaremx.relprintid = u_SaleTaskMx.printid INNER JOIN
  757. u_SaleTask ON u_SaleTaskMx.scid = u_SaleTask.scid AND u_SaleTaskMx.TaskID = u_SaleTask.TaskID INNER JOIN
  758. eb_saletask_import ON u_SaleTask.TaskCode = eb_saletask_import.taskcode AND u_SaleTaskMx.MtrlID = eb_saletask_import.mtrlid AND
  759. u_SaleTaskMx.status = eb_saletask_import.status AND u_SaleTaskMx.woodcode = eb_saletask_import.woodcode AND
  760. u_SaleTaskMx.pcode = eb_saletask_import.pcode INNER JOIN
  761. tb_order ON eb_saletask_import.im_id = tb_order.oid
  762. WHERE (tb_order.status <> 'WAIT_SELLER_SEND_GOODS')
  763. AND (:ls_parm LIKE '%,' + RTRIM(u_outware.outwarecode) + ',%')
  764. Order By u_outware.outwarecode, eb_saletask_import.tid;
  765. OPEN cur1;
  766. FETCH cur1 Into :ls_outwarecode, :ls_tid, :ls_status;
  767. DO WHILE sqlca.SQLCode = 0
  768. ls_msg += ls_outwarecode+','+ls_tid+','+ls_status+';'
  769. FETCH cur1 Into :ls_outwarecode, :ls_tid, :ls_status;
  770. LOOP
  771. CLOSE cur1;
  772. IF ls_msg <> '' THEN
  773. ls_msg = '以下单据不在等待卖家发货状态,请检查:' + ls_msg
  774. MessageBox('提示', ls_msg)
  775. RETURN 0
  776. END IF
  777. ls_msg = ''
  778. DECLARE cur2 CURSOR FOR
  779. SELECT u_outware.outwarecode, eb_saletask_import.tid
  780. FROM u_outwaremx INNER JOIN
  781. u_outware ON u_outwaremx.scid = u_outware.scid AND u_outwaremx.outwareid = u_outware.outwareid INNER JOIN
  782. u_SaleTaskMx ON u_outwaremx.relid = u_SaleTaskMx.TaskID AND u_outwaremx.scid = u_SaleTaskMx.scid AND
  783. u_outwaremx.relprintid = u_SaleTaskMx.printid INNER JOIN
  784. u_SaleTask ON u_SaleTaskMx.scid = u_SaleTask.scid AND u_SaleTaskMx.TaskID = u_SaleTask.TaskID INNER JOIN
  785. eb_saletask_import ON u_SaleTask.TaskCode = eb_saletask_import.taskcode AND u_SaleTaskMx.MtrlID = eb_saletask_import.mtrlid AND
  786. u_SaleTaskMx.status = eb_saletask_import.status AND u_SaleTaskMx.woodcode = eb_saletask_import.woodcode AND
  787. u_SaleTaskMx.pcode = eb_saletask_import.pcode INNER JOIN
  788. tb_order ON eb_saletask_import.im_id = tb_order.oid
  789. WHERE (tb_order.status = 'WAIT_SELLER_SEND_GOODS')
  790. AND (tb_order.refund_status = 'WAIT_SELLER_AGREE')
  791. AND (:ls_parm LIKE '%,' + RTRIM(u_outware.outwarecode) + ',%')
  792. Order By u_outware.outwarecode, eb_saletask_import.tid;
  793. OPEN cur2;
  794. FETCH cur2 Into :ls_outwarecode, :ls_tid;
  795. DO WHILE sqlca.SQLCode = 0
  796. ls_msg += ls_outwarecode+','+ls_tid+';'
  797. FETCH cur2 Into :ls_outwarecode, :ls_tid;
  798. LOOP
  799. CLOSE cur2;
  800. IF ls_msg <> '' THEN
  801. ls_msg = '以下单据买家已经申请退款,是否继续?~r~n' + ls_msg
  802. If (MessageBox('提问', ls_msg,Question!,YesNo!,2) <> 1) THEN
  803. RETURN 0
  804. END IF
  805. END IF
  806. ls_msg = ''
  807. DECLARE cur3 CURSOR FOR
  808. SELECT u_outware.outwarecode, eb_saletask_import.tid
  809. FROM u_outwaremx INNER JOIN
  810. u_outware ON u_outwaremx.scid = u_outware.scid AND u_outwaremx.outwareid = u_outware.outwareid INNER JOIN
  811. u_SaleTaskMx ON u_outwaremx.relid = u_SaleTaskMx.TaskID AND u_outwaremx.scid = u_SaleTaskMx.scid AND
  812. u_outwaremx.relprintid = u_SaleTaskMx.printid INNER JOIN
  813. u_SaleTask ON u_SaleTaskMx.scid = u_SaleTask.scid AND u_SaleTaskMx.TaskID = u_SaleTask.TaskID INNER JOIN
  814. eb_saletask_import ON u_SaleTask.TaskCode = eb_saletask_import.taskcode AND u_SaleTaskMx.MtrlID = eb_saletask_import.mtrlid AND
  815. u_SaleTaskMx.status = eb_saletask_import.status AND u_SaleTaskMx.woodcode = eb_saletask_import.woodcode AND
  816. u_SaleTaskMx.pcode = eb_saletask_import.pcode INNER JOIN
  817. tb_order ON eb_saletask_import.im_id = tb_order.oid
  818. WHERE (tb_order.status = 'WAIT_SELLER_SEND_GOODS')
  819. AND (u_SaleTask.relcode <> eb_saletask_import.tid
  820. OR u_outware.rel_rep <> eb_saletask_import.rel_rep
  821. OR u_SaleTask.cus_tele <> eb_saletask_import.cus_tele)
  822. AND (:ls_parm LIKE '%,' + RTRIM(u_outware.outwarecode) + ',%')
  823. ORDER BY u_outware.outwarecode, eb_saletask_import.tid
  824. OPEN cur3;
  825. FETCH cur3 Into :ls_outwarecode, :ls_tid;
  826. DO WHILE sqlca.SQLCode = 0
  827. ls_msg += ls_outwarecode+','+ls_tid+';'
  828. FETCH cur3 Into :ls_outwarecode, :ls_tid;
  829. LOOP
  830. CLOSE cur3;
  831. IF ls_msg <> '' THEN
  832. ls_msg = '以下单据收货人信息与淘宝订单收货人信息不符,是否继续?~r~n' + ls_msg
  833. If (MessageBox('提问', ls_msg,Question!,YesNo!,2) <> 1) THEN
  834. RETURN 0
  835. END IF
  836. END IF
  837. RETURN 1
  838. end function
  839. on w_taobao_outware_send.create
  840. int iCurrent
  841. call super::create
  842. this.cb_reflash=create cb_reflash
  843. this.dw_1=create dw_1
  844. this.cbx_1=create cbx_1
  845. this.cb_edit=create cb_edit
  846. this.cb_del=create cb_del
  847. this.cb_upload=create cb_upload
  848. this.cb_print=create cb_print
  849. this.cb_edit_relstr_1=create cb_edit_relstr_1
  850. this.ddlb_im_type=create ddlb_im_type
  851. this.st_2=create st_2
  852. this.sle_userid=create sle_userid
  853. this.cb_selectuser=create cb_selectuser
  854. this.cb_export=create cb_export
  855. this.cb_fy=create cb_fy
  856. this.cb_print_dir=create cb_print_dir
  857. this.dw_2=create dw_2
  858. this.cb_amt_edit=create cb_amt_edit
  859. this.cb_amt_cancel=create cb_amt_cancel
  860. this.cb_1=create cb_1
  861. this.ln_bar=create ln_bar
  862. this.ln_bar2=create ln_bar2
  863. this.r_bar=create r_bar
  864. this.ln_1=create ln_1
  865. this.ln_2=create ln_2
  866. iCurrent=UpperBound(this.Control)
  867. this.Control[iCurrent+1]=this.cb_reflash
  868. this.Control[iCurrent+2]=this.dw_1
  869. this.Control[iCurrent+3]=this.cbx_1
  870. this.Control[iCurrent+4]=this.cb_edit
  871. this.Control[iCurrent+5]=this.cb_del
  872. this.Control[iCurrent+6]=this.cb_upload
  873. this.Control[iCurrent+7]=this.cb_print
  874. this.Control[iCurrent+8]=this.cb_edit_relstr_1
  875. this.Control[iCurrent+9]=this.ddlb_im_type
  876. this.Control[iCurrent+10]=this.st_2
  877. this.Control[iCurrent+11]=this.sle_userid
  878. this.Control[iCurrent+12]=this.cb_selectuser
  879. this.Control[iCurrent+13]=this.cb_export
  880. this.Control[iCurrent+14]=this.cb_fy
  881. this.Control[iCurrent+15]=this.cb_print_dir
  882. this.Control[iCurrent+16]=this.dw_2
  883. this.Control[iCurrent+17]=this.cb_amt_edit
  884. this.Control[iCurrent+18]=this.cb_amt_cancel
  885. this.Control[iCurrent+19]=this.cb_1
  886. this.Control[iCurrent+20]=this.ln_bar
  887. this.Control[iCurrent+21]=this.ln_bar2
  888. this.Control[iCurrent+22]=this.r_bar
  889. this.Control[iCurrent+23]=this.ln_1
  890. this.Control[iCurrent+24]=this.ln_2
  891. end on
  892. on w_taobao_outware_send.destroy
  893. call super::destroy
  894. destroy(this.cb_reflash)
  895. destroy(this.dw_1)
  896. destroy(this.cbx_1)
  897. destroy(this.cb_edit)
  898. destroy(this.cb_del)
  899. destroy(this.cb_upload)
  900. destroy(this.cb_print)
  901. destroy(this.cb_edit_relstr_1)
  902. destroy(this.ddlb_im_type)
  903. destroy(this.st_2)
  904. destroy(this.sle_userid)
  905. destroy(this.cb_selectuser)
  906. destroy(this.cb_export)
  907. destroy(this.cb_fy)
  908. destroy(this.cb_print_dir)
  909. destroy(this.dw_2)
  910. destroy(this.cb_amt_edit)
  911. destroy(this.cb_amt_cancel)
  912. destroy(this.cb_1)
  913. destroy(this.ln_bar)
  914. destroy(this.ln_bar2)
  915. destroy(this.r_bar)
  916. destroy(this.ln_1)
  917. destroy(this.ln_2)
  918. end on
  919. event open;call super::open;String arg_msg
  920. ins_saletask_import = Create uo_saletask_import
  921. //ins_comapp = Create uo_ljlib_taobao_comapp
  922. //ins_comapp.uf_init(ins_taobao, ins_create, ins_connected, ins_inited, arg_msg)
  923. dw_1.SetTransObject(sqlca)
  924. dw_2.SetTransObject(sqlca)
  925. //wf_retrieve_child()
  926. // 选择电商帐号
  927. IF sys_power_issuper THEN
  928. ddlb_im_type.AddItem('全部')
  929. END IF
  930. ins_user.im_type = long(f_profilestring(sys_empid, 'w_taobao_outware_send', 'im_type', '0'))
  931. ins_user.im_userid = f_profilestring(sys_empid, 'w_taobao_outware_send', 'im_userid', '')
  932. IF ins_user.im_type = 0 THEN
  933. ddlb_im_type.Text = '其它'
  934. ELSEIF ins_user.im_type = 1 THEN
  935. ddlb_im_type.Text = '亚洲国际电商'
  936. ELSEIF ins_user.im_type = 5 THEN
  937. ddlb_im_type.Text = '淘宝'
  938. ELSEIF ins_user.im_type = 6 THEN
  939. ddlb_im_type.Text = '京东'
  940. ELSE
  941. ddlb_im_type.Text = '全部'
  942. END IF
  943. sle_userid.Text = ins_user.im_userid
  944. cb_reflash.TriggerEvent(Clicked!)
  945. wf_face()
  946. end event
  947. event resize;call super::resize;r_bar.Width = this.width
  948. ln_bar.endx = this.width
  949. ln_bar2.endx = this.width
  950. ln_1.endx = this.width
  951. ln_2.endx = this.width
  952. dw_1.height = this.WorkSpaceHeight() - dw_1.Y - dw_2.Height
  953. dw_1.Width = this.WorkSpaceWidth() - dw_1.X
  954. dw_2.Y = dw_1.Y + dw_1.height
  955. dw_2.Width = this.WorkSpaceWidth() - dw_2.X
  956. end event
  957. event close;call super::close;destroy ins_saletask_import
  958. end event
  959. type cb_func from w_publ_base`cb_func within w_taobao_outware_send
  960. boolean visible = false
  961. end type
  962. type cb_exit from w_publ_base`cb_exit within w_taobao_outware_send
  963. integer x = 1801
  964. integer width = 151
  965. integer height = 164
  966. integer picsize = 16
  967. toolbaralignment pic_align = alignattop!
  968. boolean border = false
  969. end type
  970. type cb_reflash from uo_imflatbutton within w_taobao_outware_send
  971. integer width = 151
  972. integer height = 164
  973. integer taborder = 30
  974. boolean bringtotop = true
  975. string text = "刷新"
  976. string normalpicname = "refresh.BMP"
  977. integer picsize = 16
  978. toolbaralignment pic_align = alignattop!
  979. boolean border = false
  980. end type
  981. event clicked;call super::clicked;Long ins_im_type
  982. IF ddlb_im_type.Text = '其它' THEN
  983. ins_im_type = 0
  984. ELSEIF ddlb_im_type.Text = '亚洲国际电商' THEN
  985. ins_im_type = 1
  986. ELSEIF ddlb_im_type.Text = '淘宝' THEN
  987. ins_im_type = 5
  988. ELSEIF ddlb_im_type.Text = '京东' THEN
  989. ins_im_type = 6
  990. ELSE
  991. ins_im_type = -1
  992. END IF
  993. Long ll_is_super = 0
  994. IF sys_power_issuper THEN
  995. ll_is_super = 1
  996. END IF
  997. long ll_haspower = 0
  998. if uo_power_spi.uf_power_ind(3796,sys_msg_pow) then
  999. ll_haspower = 1
  1000. end if
  1001. dw_1.Retrieve(ins_im_type, ins_user.im_userid, ll_is_super, ll_haspower)
  1002. wf_selectall()
  1003. end event
  1004. type dw_1 from u_dw_rbtnfilter within w_taobao_outware_send
  1005. integer y = 296
  1006. integer width = 2862
  1007. integer height = 1068
  1008. integer taborder = 30
  1009. boolean bringtotop = true
  1010. string dataobject = "dw_taobao_outware_send"
  1011. boolean hscrollbar = true
  1012. boolean vscrollbar = true
  1013. boolean hsplitscroll = true
  1014. boolean rbutton_filter_use = true
  1015. boolean rbutton_setposition_use = true
  1016. boolean autosave_sort_use = false
  1017. end type
  1018. event clicked;call super::clicked;IF row > 0 THEN
  1019. dw_1.SetRow(row)
  1020. END IF
  1021. Long ll_row
  1022. String lpo_object
  1023. IF dwo.Name = "u_outware_relstr_1" And dw_edit_mode And row > 0 THEN
  1024. s_edit_index_tran s_ch_tran //传递参数使用
  1025. s_ch_tran.if_retrieve_all = False //是否一次RETRIEVE所有行
  1026. s_ch_tran.work_mode = 1 //0-单纯编辑模式 1-选择\编辑模式
  1027. s_ch_tran.arg_pkid = 0 //目标定位PKID (备用)
  1028. OpenWithParm(w_station_edit,s_ch_tran) //调用
  1029. s_station S_INSCUST
  1030. S_INSCUST = Message.PowerObjectParm //接受返回结构
  1031. IF S_INSCUST.stationid > 0 THEN //正常返回值则可以取以下值
  1032. dw_1.SetRedraw(False)
  1033. dw_1.Object.u_outware_relstr_1[row] = S_INSCUST.stationname
  1034. dw_1.SetRedraw(True)
  1035. END IF
  1036. END IF
  1037. end event
  1038. event rowfocuschanged;call super::rowfocuschanged;This.SelectRow(0, False)
  1039. IF currentrow > 0 THEN
  1040. This.SelectRow(currentrow, True)
  1041. END IF
  1042. Parent.TriggerEvent('ue_retrieve_mx')
  1043. end event
  1044. event itemchanged;call super::itemchanged;IF Not dw_edit_mode THEN RETURN
  1045. IF row <= 0 THEN RETURN
  1046. IF dw_1.AcceptText() <> 1 THEN RETURN
  1047. String ls_outwarecode
  1048. String ls_type
  1049. String ls_name
  1050. Any ll_value
  1051. Long i
  1052. ls_outwarecode = dw_1.Object.u_outware_outwarecode[row]
  1053. ls_name = dwo.Name
  1054. ls_type = Lower(dw_1.Describe(ls_name + ".ColType"))
  1055. IF ls_type = 'date' THEN
  1056. ll_value = dw_1.GetItemDate(row, ls_name)
  1057. ELSEIF ls_type = 'datetime' THEN
  1058. ll_value = dw_1.GetItemDateTime(row, ls_name)
  1059. ELSEIF ls_type = 'time' Or Pos(ls_type, 'time') > 0 THEN
  1060. ll_value = dw_1.GetItemTime(row, ls_name)
  1061. ELSEIF Pos(ls_type, 'dec') > 0 THEN
  1062. ll_value = dw_1.GetItemDecimal(row, ls_name)
  1063. ELSEIF Pos(ls_type, 'char') > 0 THEN
  1064. ll_value = dw_1.GetItemString(row, ls_name)
  1065. ELSE
  1066. ll_value = dw_1.GetItemNumber(row, ls_name)
  1067. END IF
  1068. FOR i = 1 To dw_1.RowCount()
  1069. IF i = row THEN CONTINUE
  1070. IF dw_1.Object.u_outware_outwarecode[i] <> ls_outwarecode THEN CONTINUE
  1071. dw_1.SetItem(i, ls_name, ll_value)
  1072. NEXT
  1073. end event
  1074. type cbx_1 from checkbox within w_taobao_outware_send
  1075. integer x = 1550
  1076. integer y = 196
  1077. integer width = 402
  1078. integer height = 60
  1079. boolean bringtotop = true
  1080. integer textsize = -9
  1081. integer weight = 400
  1082. fontcharset fontcharset = gb2312charset!
  1083. fontpitch fontpitch = variable!
  1084. string facename = "宋体"
  1085. long textcolor = 33554432
  1086. long backcolor = 67108864
  1087. string text = "全部"
  1088. end type
  1089. event constructor;this.backcolor = 14215660
  1090. end event
  1091. event clicked;wf_selectall()
  1092. end event
  1093. type cb_edit from uo_imflatbutton within w_taobao_outware_send
  1094. integer x = 155
  1095. integer width = 151
  1096. integer height = 164
  1097. integer taborder = 70
  1098. boolean bringtotop = true
  1099. string text = "修改"
  1100. string normalpicname = "OPEN.bmp"
  1101. integer picsize = 16
  1102. toolbaralignment pic_align = alignattop!
  1103. boolean border = false
  1104. end type
  1105. event clicked;call super::clicked;IF Not uo_power_spi.f_taobao_outware_send_print_save(sys_msg_pow) THEN
  1106. MessageBox(publ_operator,sys_msg_pow)
  1107. RETURN
  1108. END IF
  1109. String arg_msg
  1110. IF dw_edit_mode THEN
  1111. IF dw_1.AcceptText() <> 1 THEN RETURN
  1112. IF wf_save(arg_msg) <> 1 THEN
  1113. MessageBox('错误', arg_msg)
  1114. RETURN
  1115. END IF
  1116. END IF
  1117. dw_edit_mode = Not dw_edit_mode
  1118. IF dw_edit_mode THEN
  1119. cbx_1.Checked = True
  1120. wf_selectall()
  1121. ELSE
  1122. cb_reflash.TriggerEvent(Clicked!)
  1123. END IF
  1124. wf_face()
  1125. end event
  1126. type cb_del from uo_imflatbutton within w_taobao_outware_send
  1127. integer x = 311
  1128. integer width = 151
  1129. integer height = 164
  1130. integer taborder = 60
  1131. boolean bringtotop = true
  1132. string text = "放弃"
  1133. string normalpicname = "Undo.bmp"
  1134. integer picsize = 16
  1135. toolbaralignment pic_align = alignattop!
  1136. boolean border = false
  1137. end type
  1138. event clicked;call super::clicked;String ls_msg
  1139. IF dw_edit_mode THEN
  1140. dw_edit_mode = Not dw_edit_mode
  1141. cb_reflash.TriggerEvent(Clicked!)
  1142. wf_face()
  1143. END IF
  1144. end event
  1145. type cb_upload from uo_imflatbutton within w_taobao_outware_send
  1146. integer x = 1024
  1147. integer width = 151
  1148. integer height = 164
  1149. integer taborder = 80
  1150. boolean bringtotop = true
  1151. string text = "上传"
  1152. string normalpicname = "imexport.BMP"
  1153. integer picsize = 16
  1154. toolbaralignment pic_align = alignattop!
  1155. boolean border = false
  1156. end type
  1157. event clicked;call super::clicked;parent.triggerevent('ue_taobao_upload')
  1158. end event
  1159. type cb_print from uo_imflatbutton within w_taobao_outware_send
  1160. boolean visible = false
  1161. integer x = 2574
  1162. integer width = 151
  1163. integer height = 164
  1164. integer taborder = 30
  1165. boolean bringtotop = true
  1166. string text = "打印"
  1167. string normalpicname = "print.bmp"
  1168. integer picsize = 16
  1169. toolbaralignment pic_align = alignattop!
  1170. boolean border = false
  1171. end type
  1172. event clicked;call super::clicked;String ls_dft_old_dwname, ls_dft_new_dwname,ls_chnname,ls_dwtype
  1173. Long ls_dwprintid
  1174. String ls_windowname
  1175. Int ls_i
  1176. Long ll_billid
  1177. Int li_ifuse
  1178. Long ll_row
  1179. String Name,ll_rpname
  1180. Long ll_RpID,ll_flag,ll_ifuse
  1181. ins_print_flag = False
  1182. ins_print_hz = False
  1183. w_curwin = Parent
  1184. ls_windowname = Parent.ClassName ( )
  1185. SELECT billid,ifuse
  1186. INTO :ll_billid,
  1187. :li_ifuse
  1188. FROM u_report_bill
  1189. Where winName = :ls_windowname;
  1190. IF sqlca.SQLCode <> 0 THEN
  1191. li_ifuse = 0
  1192. END IF
  1193. IF li_ifuse = 0 THEN
  1194. DECLARE dft_dwprint CURSOR FOR
  1195. SELECT dwprintid,dft_old_dwname, dft_new_dwname, chnname, dwtype
  1196. FROM sys_dft_dwprint_dynamic
  1197. WHERE dwtype = :ls_windowname
  1198. And ptype = 0;
  1199. OPEN dft_dwprint;
  1200. FETCH dft_dwprint Into :ls_dwprintid,:ls_dft_old_dwname, :ls_dft_new_dwname,:ls_chnname, :ls_dwtype;
  1201. IF sqlca.SQLCode <> 0 THEN
  1202. Parent.TriggerEvent('ue_print',0,0)
  1203. ELSE
  1204. m_dft_dwprint_item m_1
  1205. m_1 = Create m_dft_dwprint_item
  1206. ls_i = 1
  1207. DO WHILE sqlca.SQLCode = 0
  1208. f_add_menuitem_print_dft(m_1,ls_i,ls_chnname,String(ls_dwprintid))
  1209. FETCH dft_dwprint Into :ls_dwprintid,:ls_dft_old_dwname, :ls_dft_new_dwname,:ls_chnname, :ls_dwtype;
  1210. ls_i++
  1211. LOOP
  1212. CLOSE dft_dwprint;
  1213. m_1.PopMenu(This.X+50,This.Y+50)
  1214. END IF
  1215. ELSE
  1216. DECLARE rpt_dwprint CURSOR FOR
  1217. SELECT RpID,RpName,Flag,Ifuse
  1218. FROM U_report_list
  1219. WHERE billid = :ll_billid
  1220. Order By RpName;
  1221. OPEN rpt_dwprint;
  1222. FETCH rpt_dwprint Into :ll_RpID,:ll_rpname,:ll_flag,:ll_ifuse;
  1223. IF sqlca.SQLCode <> 0 THEN
  1224. Parent.TriggerEvent('ue_print',0,0)
  1225. ELSE
  1226. m_rpt_dwprint_print_item m_2
  1227. m_2 = Create m_rpt_dwprint_print_item
  1228. ls_i = 1
  1229. DO WHILE sqlca.SQLCode = 0
  1230. IF ll_ifuse = 1 And ll_flag = 1 And f_pow_rpt(ll_RpID) THEN //需添加权限
  1231. f_add_menuItem_print_rpt(m_2,ls_i,ll_rpname,String(ll_RpID))
  1232. END IF
  1233. FETCH rpt_dwprint Into :ll_RpID,:ll_rpname,:ll_flag,:ll_ifuse;
  1234. ls_i++
  1235. LOOP
  1236. CLOSE rpt_dwprint;
  1237. m_2.Item[1].Visible = False
  1238. m_2.PopMenu(This.X+50,This.Y+50)
  1239. END IF
  1240. END IF
  1241. end event
  1242. type cb_edit_relstr_1 from commandbutton within w_taobao_outware_send
  1243. integer x = 1989
  1244. integer y = 180
  1245. integer width = 430
  1246. integer height = 92
  1247. integer taborder = 40
  1248. boolean bringtotop = true
  1249. integer textsize = -9
  1250. integer weight = 400
  1251. fontcharset fontcharset = gb2312charset!
  1252. fontpitch fontpitch = variable!
  1253. string facename = "宋体"
  1254. string text = "批修改货运部"
  1255. end type
  1256. event clicked;parent.triggerevent('ue_p_edit_relstr_1')
  1257. end event
  1258. type ddlb_im_type from dropdownlistbox within w_taobao_outware_send
  1259. integer y = 184
  1260. integer width = 480
  1261. integer height = 792
  1262. integer taborder = 50
  1263. boolean bringtotop = true
  1264. integer textsize = -9
  1265. integer weight = 400
  1266. fontcharset fontcharset = gb2312charset!
  1267. fontpitch fontpitch = variable!
  1268. string facename = "宋体"
  1269. long textcolor = 33554432
  1270. string text = "其它"
  1271. boolean sorted = false
  1272. string item[] = {"其它","亚洲国际电商","淘宝","京东"}
  1273. borderstyle borderstyle = stylelowered!
  1274. end type
  1275. event selectionchanged;Long ins_im_type
  1276. IF ddlb_im_type.Text = '其它' THEN
  1277. ins_im_type = 0
  1278. ELSEIF ddlb_im_type.Text = '亚洲国际电商' THEN
  1279. ins_im_type = 1
  1280. ELSEIF ddlb_im_type.Text = '淘宝' THEN
  1281. ins_im_type = 5
  1282. ELSEIF ddlb_im_type.Text = '京东' THEN
  1283. ins_im_type = 6
  1284. ELSE
  1285. ins_im_type = -1
  1286. END IF
  1287. IF ins_im_type <> ins_user.im_type THEN
  1288. IF ins_im_type = 1 Or ins_im_type = 5 Or ins_im_type = 6 THEN
  1289. Parent.TriggerEvent('ue_select_user')
  1290. RETURN
  1291. END IF
  1292. END IF
  1293. IF ins_im_type = 0 THEN
  1294. ins_user.UserID = 0
  1295. ins_user.im_type = 0
  1296. ins_user.im_userid = ''
  1297. sle_userid.Text = ''
  1298. END IF
  1299. f_setprofilestring(sys_empid, 'w_taobao_outware_send', 'im_type', String(ins_user.im_type))
  1300. f_setprofilestring(sys_empid, 'w_taobao_outware_send', 'im_userid', ins_user.im_userid)
  1301. cb_reflash.TriggerEvent(Clicked!)
  1302. end event
  1303. type st_2 from statictext within w_taobao_outware_send
  1304. integer x = 489
  1305. integer y = 200
  1306. integer width = 274
  1307. integer height = 48
  1308. boolean bringtotop = true
  1309. integer textsize = -9
  1310. integer weight = 400
  1311. fontcharset fontcharset = gb2312charset!
  1312. fontpitch fontpitch = variable!
  1313. string facename = "宋体"
  1314. long textcolor = 33554432
  1315. long backcolor = 67108864
  1316. string text = "当前用户:"
  1317. boolean focusrectangle = false
  1318. end type
  1319. event constructor;this.backcolor = 14215660
  1320. end event
  1321. type sle_userid from singlelineedit within w_taobao_outware_send
  1322. integer x = 773
  1323. integer y = 184
  1324. integer width = 494
  1325. integer height = 84
  1326. integer taborder = 60
  1327. boolean bringtotop = true
  1328. integer textsize = -9
  1329. integer weight = 400
  1330. fontcharset fontcharset = gb2312charset!
  1331. fontpitch fontpitch = variable!
  1332. string facename = "宋体"
  1333. long textcolor = 33554432
  1334. boolean displayonly = true
  1335. borderstyle borderstyle = stylelowered!
  1336. end type
  1337. type cb_selectuser from uo_imflatbutton within w_taobao_outware_send
  1338. integer x = 1280
  1339. integer y = 180
  1340. integer width = 256
  1341. integer height = 88
  1342. integer taborder = 40
  1343. boolean bringtotop = true
  1344. string text = "选择"
  1345. string normalpicname = "FIND.BMP"
  1346. integer picsize = 16
  1347. end type
  1348. event clicked;call super::clicked;parent.triggerevent('ue_select_user')
  1349. end event
  1350. type cb_export from uo_imflatbutton within w_taobao_outware_send
  1351. integer x = 1179
  1352. integer width = 151
  1353. integer height = 164
  1354. integer taborder = 40
  1355. boolean bringtotop = true
  1356. string text = "导出"
  1357. string normalpicname = "excel.bmp"
  1358. integer picsize = 16
  1359. toolbaralignment pic_align = alignattop!
  1360. boolean border = false
  1361. end type
  1362. event clicked;call super::clicked;parent.triggerevent('ue_xls_export')
  1363. end event
  1364. type cb_fy from uo_imflatbutton within w_taobao_outware_send
  1365. integer x = 1335
  1366. integer width = 151
  1367. integer height = 164
  1368. integer taborder = 50
  1369. boolean bringtotop = true
  1370. string text = "运费"
  1371. string normalpicname = "imexport.BMP"
  1372. integer picsize = 16
  1373. toolbaralignment pic_align = alignattop!
  1374. boolean border = false
  1375. end type
  1376. event clicked;call super::clicked;IF Not uo_power_spi.uf_power_ind(3795,sys_msg_pow) THEN
  1377. MessageBox(publ_operator,sys_msg_pow)
  1378. RETURN
  1379. END IF
  1380. m_Dfc_Control_PopupMenu dmPopupMenu
  1381. String menustr
  1382. menustr = "Text=按运输单号录入~tEvent=ue_input_fy"
  1383. menustr = menustr + "|" + "Text=按顺序录入~tEvent=ue_input_fy_order"
  1384. menustr = menustr + "|" + "Text=xls导入~tEvent=ue_import_fy_xls"
  1385. IF Len(Trim(menustr)) <> 0 THEN
  1386. dmPopupMenu = Create m_Dfc_Control_PopupMenu
  1387. dmPopupMenu.mf_BuildMenu(This, menustr)
  1388. dmPopupMenu.mf_PopMenu()
  1389. Destroy dmPopupMenu
  1390. END IF
  1391. end event
  1392. type cb_print_dir from uo_imflatbutton within w_taobao_outware_send
  1393. integer x = 466
  1394. integer width = 274
  1395. integer height = 164
  1396. integer taborder = 40
  1397. boolean bringtotop = true
  1398. string text = "多选打印"
  1399. string normalpicname = "print.bmp"
  1400. integer picsize = 16
  1401. toolbaralignment pic_align = alignattop!
  1402. boolean border = false
  1403. end type
  1404. event clicked;call super::clicked;String ls_dft_old_dwname, ls_dft_new_dwname,ls_chnname,ls_dwtype
  1405. Long ls_dwprintid
  1406. String ls_windowname
  1407. Int ls_i
  1408. Long ll_billid
  1409. Int li_ifuse
  1410. Long ll_row
  1411. String Name,ll_rpname
  1412. Long ll_RpID,ll_flag,ll_ifuse
  1413. ins_print_flag = True
  1414. ins_print_hz = False
  1415. w_curwin = Parent
  1416. ls_windowname = Parent.ClassName ( )
  1417. SELECT billid,ifuse
  1418. INTO :ll_billid,
  1419. :li_ifuse
  1420. FROM u_report_bill
  1421. Where winName = :ls_windowname;
  1422. IF sqlca.SQLCode <> 0 THEN
  1423. li_ifuse = 0
  1424. END IF
  1425. IF li_ifuse = 0 THEN
  1426. DECLARE dft_dwprint CURSOR FOR
  1427. SELECT dwprintid,dft_old_dwname, dft_new_dwname, chnname, dwtype
  1428. FROM sys_dft_dwprint_dynamic
  1429. WHERE dwtype = :ls_windowname
  1430. And ptype = 0;
  1431. OPEN dft_dwprint;
  1432. FETCH dft_dwprint Into :ls_dwprintid,:ls_dft_old_dwname, :ls_dft_new_dwname,:ls_chnname, :ls_dwtype;
  1433. IF sqlca.SQLCode <> 0 THEN
  1434. Parent.TriggerEvent('ue_print',0,0)
  1435. ELSE
  1436. m_dft_dwprint_print_item m_1
  1437. m_1 = Create m_dft_dwprint_print_item
  1438. ls_i = 1
  1439. DO WHILE sqlca.SQLCode = 0
  1440. f_add_menuitem_print_dft(m_1,ls_i,ls_chnname,String(ls_dwprintid))
  1441. FETCH dft_dwprint Into :ls_dwprintid,:ls_dft_old_dwname, :ls_dft_new_dwname,:ls_chnname, :ls_dwtype;
  1442. ls_i++
  1443. LOOP
  1444. CLOSE dft_dwprint;
  1445. m_1.PopMenu(This.X+50,This.Y+50)
  1446. END IF
  1447. ELSE
  1448. DECLARE rpt_dwprint CURSOR FOR
  1449. SELECT RpID,RpName,Flag,Ifuse
  1450. FROM U_report_list
  1451. WHERE billid = :ll_billid
  1452. Order By RpName;
  1453. OPEN rpt_dwprint;
  1454. FETCH rpt_dwprint Into :ll_RpID,:ll_rpname,:ll_flag,:ll_ifuse;
  1455. IF sqlca.SQLCode <> 0 THEN
  1456. Parent.TriggerEvent('ue_print',0,0)
  1457. ELSE
  1458. m_rpt_dwprint_print_item m_2
  1459. m_2 = Create m_rpt_dwprint_print_item
  1460. ls_i = 1
  1461. DO WHILE sqlca.SQLCode = 0
  1462. IF ll_ifuse = 1 And ll_flag = 1 And f_pow_rpt(ll_RpID) THEN //需添加权限
  1463. f_add_menuItem_print_rpt(m_2,ls_i,ll_rpname,String(ll_RpID))
  1464. END IF
  1465. FETCH rpt_dwprint Into :ll_RpID,:ll_rpname,:ll_flag,:ll_ifuse;
  1466. ls_i++
  1467. LOOP
  1468. CLOSE rpt_dwprint;
  1469. m_2.Item[1].Visible = False
  1470. m_2.PopMenu(This.X+50,This.Y+50)
  1471. END IF
  1472. END IF
  1473. end event
  1474. type dw_2 from u_dw_rbtnfilter within w_taobao_outware_send
  1475. integer y = 1448
  1476. integer width = 3022
  1477. integer height = 512
  1478. integer taborder = 40
  1479. boolean bringtotop = true
  1480. string dataobject = "dw_taobao_outware_sendmx"
  1481. boolean hscrollbar = true
  1482. boolean vscrollbar = true
  1483. boolean hsplitscroll = true
  1484. boolean rbutton_filter_use = true
  1485. boolean rbutton_setposition_use = true
  1486. boolean titleclick_sort_use = true
  1487. end type
  1488. event clicked;call super::clicked;IF row > 0 THEN
  1489. dw_1.SetRow(row)
  1490. END IF
  1491. end event
  1492. event rowfocuschanged;call super::rowfocuschanged;This.SelectRow(0, False)
  1493. IF currentrow > 0 THEN
  1494. This.SelectRow(currentrow, True)
  1495. END IF
  1496. end event
  1497. type cb_amt_edit from uo_imflatbutton within w_taobao_outware_send
  1498. integer x = 1490
  1499. integer width = 151
  1500. integer height = 164
  1501. integer taborder = 80
  1502. boolean bringtotop = true
  1503. string text = "修改"
  1504. string normalpicname = "OPEN.bmp"
  1505. integer picsize = 16
  1506. toolbaralignment pic_align = alignattop!
  1507. boolean border = false
  1508. end type
  1509. event clicked;call super::clicked;IF Not uo_power_spi.uf_power_ind(3793,sys_msg_pow) THEN
  1510. MessageBox(publ_operator,sys_msg_pow)
  1511. RETURN
  1512. END IF
  1513. String arg_msg
  1514. IF dw_amt_edit_mode THEN
  1515. IF dw_1.AcceptText() <> 1 THEN RETURN
  1516. IF wf_save_amt(arg_msg) <> 1 THEN
  1517. MessageBox('错误', arg_msg)
  1518. RETURN
  1519. END IF
  1520. END IF
  1521. dw_amt_edit_mode = Not dw_amt_edit_mode
  1522. IF dw_amt_edit_mode THEN
  1523. cbx_1.Checked = True
  1524. wf_selectall()
  1525. ELSE
  1526. cb_reflash.TriggerEvent(Clicked!)
  1527. END IF
  1528. wf_face()
  1529. end event
  1530. type cb_amt_cancel from uo_imflatbutton within w_taobao_outware_send
  1531. integer x = 1646
  1532. integer width = 151
  1533. integer height = 164
  1534. integer taborder = 70
  1535. boolean bringtotop = true
  1536. string text = "放弃"
  1537. string normalpicname = "Undo.bmp"
  1538. integer picsize = 16
  1539. toolbaralignment pic_align = alignattop!
  1540. boolean border = false
  1541. end type
  1542. event clicked;call super::clicked;String ls_msg
  1543. IF dw_amt_edit_mode THEN
  1544. dw_amt_edit_mode = Not dw_amt_edit_mode
  1545. cb_reflash.TriggerEvent(Clicked!)
  1546. wf_face()
  1547. END IF
  1548. end event
  1549. type cb_1 from uo_imflatbutton within w_taobao_outware_send
  1550. integer x = 745
  1551. integer width = 274
  1552. integer height = 164
  1553. integer taborder = 50
  1554. boolean bringtotop = true
  1555. string text = "汇总打印"
  1556. string normalpicname = "print.bmp"
  1557. integer picsize = 16
  1558. toolbaralignment pic_align = alignattop!
  1559. boolean border = false
  1560. end type
  1561. event clicked;call super::clicked;String ls_dft_old_dwname, ls_dft_new_dwname,ls_chnname,ls_dwtype
  1562. Long ls_dwprintid
  1563. String ls_windowname
  1564. Int ls_i
  1565. Long ll_billid
  1566. Int li_ifuse
  1567. Long ll_row
  1568. String Name,ll_rpname
  1569. Long ll_RpID,ll_flag,ll_ifuse
  1570. ins_print_flag = False
  1571. ins_print_hz = True
  1572. w_curwin = Parent
  1573. ls_windowname = Parent.ClassName ( ) + '_hz'
  1574. SELECT billid,ifuse
  1575. INTO :ll_billid,
  1576. :li_ifuse
  1577. FROM u_report_bill
  1578. Where winName = :ls_windowname;
  1579. IF sqlca.SQLCode <> 0 THEN
  1580. li_ifuse = 0
  1581. END IF
  1582. IF li_ifuse = 0 THEN
  1583. DECLARE dft_dwprint CURSOR FOR
  1584. SELECT dwprintid,dft_old_dwname, dft_new_dwname, chnname, dwtype
  1585. FROM sys_dft_dwprint_dynamic
  1586. WHERE dwtype = :ls_windowname
  1587. And ptype = 0;
  1588. OPEN dft_dwprint;
  1589. FETCH dft_dwprint Into :ls_dwprintid,:ls_dft_old_dwname, :ls_dft_new_dwname,:ls_chnname, :ls_dwtype;
  1590. IF sqlca.SQLCode <> 0 THEN
  1591. Parent.TriggerEvent('ue_print',0,0)
  1592. ELSE
  1593. m_dft_dwprint_print_item m_1
  1594. m_1 = Create m_dft_dwprint_print_item
  1595. ls_i = 1
  1596. DO WHILE sqlca.SQLCode = 0
  1597. f_add_menuitem_print_dft(m_1,ls_i,ls_chnname,String(ls_dwprintid))
  1598. FETCH dft_dwprint Into :ls_dwprintid,:ls_dft_old_dwname, :ls_dft_new_dwname,:ls_chnname, :ls_dwtype;
  1599. ls_i++
  1600. LOOP
  1601. CLOSE dft_dwprint;
  1602. m_1.PopMenu(This.X+50,This.Y+50)
  1603. END IF
  1604. ELSE
  1605. DECLARE rpt_dwprint CURSOR FOR
  1606. SELECT RpID,RpName,Flag,Ifuse
  1607. FROM U_report_list
  1608. WHERE billid = :ll_billid
  1609. Order By RpName;
  1610. OPEN rpt_dwprint;
  1611. FETCH rpt_dwprint Into :ll_RpID,:ll_rpname,:ll_flag,:ll_ifuse;
  1612. IF sqlca.SQLCode <> 0 THEN
  1613. Parent.TriggerEvent('ue_print',0,0)
  1614. ELSE
  1615. m_rpt_dwprint_print_item m_2
  1616. m_2 = Create m_rpt_dwprint_print_item
  1617. ls_i = 1
  1618. DO WHILE sqlca.SQLCode = 0
  1619. IF ll_ifuse = 1 And ll_flag = 1 And f_pow_rpt(ll_RpID) THEN //需添加权限
  1620. f_add_menuItem_print_rpt(m_2,ls_i,ll_rpname,String(ll_RpID))
  1621. END IF
  1622. FETCH rpt_dwprint Into :ll_RpID,:ll_rpname,:ll_flag,:ll_ifuse;
  1623. ls_i++
  1624. LOOP
  1625. CLOSE rpt_dwprint;
  1626. m_2.Item[1].Visible = False
  1627. m_2.PopMenu(This.X+50,This.Y+50)
  1628. END IF
  1629. END IF
  1630. end event
  1631. type ln_bar from line within w_taobao_outware_send
  1632. long linecolor = 268435456
  1633. integer linethickness = 4
  1634. integer beginy = 280
  1635. integer endx = 2007
  1636. integer endy = 280
  1637. end type
  1638. type ln_bar2 from line within w_taobao_outware_send
  1639. long linecolor = 16777215
  1640. integer linethickness = 4
  1641. integer beginy = 284
  1642. integer endx = 2039
  1643. integer endy = 284
  1644. end type
  1645. type r_bar from rectangle within w_taobao_outware_send
  1646. long linecolor = 16777215
  1647. integer linethickness = 4
  1648. long fillcolor = 1073741824
  1649. integer x = 1874
  1650. integer width = 146
  1651. integer height = 68
  1652. end type
  1653. event constructor;this.fillcolor = 14215660
  1654. this.linecolor = 14215660
  1655. this.x = -1
  1656. this.y = -1
  1657. this.height = ln_bar.beginy - 5
  1658. end event
  1659. type ln_1 from line within w_taobao_outware_send
  1660. long linecolor = 268435456
  1661. integer linethickness = 4
  1662. integer beginy = 168
  1663. integer endx = 2007
  1664. integer endy = 168
  1665. end type
  1666. type ln_2 from line within w_taobao_outware_send
  1667. long linecolor = 16777215
  1668. integer linethickness = 4
  1669. integer beginy = 172
  1670. integer endx = 2039
  1671. integer endy = 172
  1672. end type