w_outware_receive_ljfieb.srw 24 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973
  1. $PBExportHeader$w_outware_receive_ljfieb.srw
  2. forward
  3. global type w_outware_receive_ljfieb from w_publ_base
  4. end type
  5. type dw_uc from datawindow within w_outware_receive_ljfieb
  6. end type
  7. type mle_1 from multilineedit within w_outware_receive_ljfieb
  8. end type
  9. type st_1 from statictext within w_outware_receive_ljfieb
  10. end type
  11. type st_2 from statictext within w_outware_receive_ljfieb
  12. end type
  13. type sle_scname from singlelineedit within w_outware_receive_ljfieb
  14. end type
  15. type st_remark from statictext within w_outware_receive_ljfieb
  16. end type
  17. type cb_accept from uo_imflatbutton within w_outware_receive_ljfieb
  18. end type
  19. type ln_bar from line within w_outware_receive_ljfieb
  20. end type
  21. type ln_bar2 from line within w_outware_receive_ljfieb
  22. end type
  23. type ln_1 from line within w_outware_receive_ljfieb
  24. end type
  25. type ln_2 from line within w_outware_receive_ljfieb
  26. end type
  27. type r_bar from rectangle within w_outware_receive_ljfieb
  28. end type
  29. type cb_bill from uo_imflatbutton within w_outware_receive_ljfieb
  30. end type
  31. type cb_feedback from uo_imflatbutton within w_outware_receive_ljfieb
  32. end type
  33. type dw_child from u_dw_rbtnfilter within w_outware_receive_ljfieb
  34. end type
  35. type cb_reject from uo_imflatbutton within w_outware_receive_ljfieb
  36. end type
  37. end forward
  38. global type w_outware_receive_ljfieb from w_publ_base
  39. integer width = 3611
  40. integer height = 2380
  41. string title = "供应商销售发货单"
  42. boolean minbox = false
  43. windowtype windowtype = response!
  44. windowstate windowstate = maximized!
  45. dw_uc dw_uc
  46. mle_1 mle_1
  47. st_1 st_1
  48. st_2 st_2
  49. sle_scname sle_scname
  50. st_remark st_remark
  51. cb_accept cb_accept
  52. ln_bar ln_bar
  53. ln_bar2 ln_bar2
  54. ln_1 ln_1
  55. ln_2 ln_2
  56. r_bar r_bar
  57. cb_bill cb_bill
  58. cb_feedback cb_feedback
  59. dw_child dw_child
  60. cb_reject cb_reject
  61. end type
  62. global w_outware_receive_ljfieb w_outware_receive_ljfieb
  63. type variables
  64. Transaction tr_eb_sqlca
  65. s_packet_ljfieb s_inscust
  66. long ins_scid
  67. string ins_sn
  68. uo_saletask obj_saletask
  69. uo_cusprice uo_price
  70. uo_ljfieb uo_fieb
  71. long ins_sendid,ins_receid
  72. string ins_sendsccode,ins_reccesccode
  73. string ins_RelatedCode
  74. datetime ins_addtime
  75. string ins_adduser
  76. long ins_sptid
  77. string ins_relreissuecode
  78. end variables
  79. forward prototypes
  80. public function integer wf_retrieve (string arg_sn, long arg_sendcuscommid, string arg_sendsccode, ref string arg_msg)
  81. public function integer wf_importnewbj (long arg_cusid, long arg_moneyid, long arg_mtrlid, string arg_status, string arg_woodcode, string arg_pcode, ref decimal arg_price, ref decimal arg_rebate, ref string arg_msg)
  82. public function integer wf_importnewprice (long arg_cusid, long arg_moneyid, long arg_mtrlid, string arg_status, string arg_woodcode, string arg_pcode, ref decimal arg_price, ref decimal arg_rebate, ref string arg_msg)
  83. end prototypes
  84. public function integer wf_retrieve (string arg_sn, long arg_sendcuscommid, string arg_sendsccode, ref string arg_msg);Int rslt = 1
  85. String ls_cuscode
  86. Long uc_row
  87. Long ll_sptid
  88. String ls_sptcode,ls_sptname
  89. Long ll_i
  90. String ls_sptmtrlcode
  91. String ls_mtrlcode_my,ls_mtrlname_my,ls_mtrlmode_my
  92. Long ll_mtrlid
  93. dw_uc.Retrieve(arg_sn)
  94. dw_child.Retrieve(arg_sn)
  95. //dw_mxmx.Retrieve(arg_sn)
  96. //dw_barcodemx.Retrieve(arg_sn)
  97. //dw_fymx.Retrieve(arg_sn)
  98. uc_row = dw_uc.GetRow()
  99. IF uc_row <= 0 THEN
  100. rslt = 0
  101. arg_msg = '没有对应的单据信息'
  102. GOTO ext
  103. END IF
  104. SELECT CusCode
  105. INTO :ls_cuscode
  106. FROM LJFIEB_CusComm
  107. Where CusCommID = :arg_sendcuscommid Using tr_eb_sqlca;
  108. IF tr_eb_sqlca.SQLCode <> 0 THEN
  109. ls_cuscode = ''
  110. END IF
  111. IF Trim(ls_cuscode) = '' THEN
  112. rslt = 0
  113. arg_msg = '供应商信息不明确,请检查'
  114. GOTO ext
  115. END IF
  116. SELECT sptid, sptcode, name
  117. INTO :ll_sptid,:ls_sptcode,:ls_sptname
  118. FROM u_spt
  119. WHERE commcode = :ls_cuscode
  120. And commsccode = :arg_sendsccode Using sqlca;
  121. IF sqlca.SQLCode <> 0 THEN
  122. rslt = 0
  123. arg_msg = '查询供应商信息失败,请检查通信设置是否正确,'+sqlca.SQLErrText
  124. GOTO ext
  125. END IF
  126. ins_sptid = ll_sptid
  127. dw_uc.Object.sptid[uc_row] = ll_sptid
  128. dw_uc.Object.CusCode[uc_row] = ls_sptcode
  129. dw_uc.Object.cusname[uc_row] = ls_sptname
  130. FOR ll_i = 1 To dw_child.RowCount()
  131. ls_sptmtrlcode = dw_child.Object.sptmtrlcode[ll_i]
  132. SELECT u_sptmtrlname.mtrlid,
  133. u_mtrldef.mtrlcode,
  134. u_mtrldef.mtrlname,
  135. u_mtrldef.mtrlmode
  136. INTO :ll_mtrlid,
  137. :ls_mtrlcode_my,
  138. :ls_mtrlname_my,
  139. :ls_mtrlmode_my
  140. FROM u_sptmtrlname INNER JOIN
  141. u_mtrldef ON u_sptmtrlname.mtrlid = u_mtrldef.mtrlid
  142. WHERE u_sptmtrlname.sptid = :ll_sptid
  143. And u_sptmtrlname.sptmtrlcode = :ls_sptmtrlcode using sqlca;
  144. IF sqlca.SQLCode <> 0 THEN
  145. rslt = 0
  146. arg_msg = '第'+string(ll_i)+'行,查询本地产品信息失败,'+sqlca.sqlerrtext
  147. GOTO ext
  148. END IF
  149. dw_child.Object.mtrlcode_my[ll_i] = ls_mtrlcode_my
  150. dw_child.Object.mtrlname_my[ll_i] = ls_mtrlname_my
  151. dw_child.Object.mtrlmode_my[ll_i] = ls_mtrlmode_my
  152. dw_child.Object.mtrlid_my[ll_i] = ll_mtrlid
  153. NEXT
  154. ext:
  155. RETURN rslt
  156. end function
  157. public function integer wf_importnewbj (long arg_cusid, long arg_moneyid, long arg_mtrlid, string arg_status, string arg_woodcode, string arg_pcode, ref decimal arg_price, ref decimal arg_rebate, ref string arg_msg);Int rslt = 1
  158. IF arg_moneyid = 0 THEN
  159. rslt = 0
  160. arg_msg = '请先选择币种'
  161. GOTO ext
  162. END IF
  163. IF IsNull(arg_cusid) THEN arg_cusid = 0
  164. IF arg_cusid = 0 THEN
  165. rslt = 0
  166. arg_msg = "请选择销售客户!"
  167. GOTO ext
  168. END IF
  169. SELECT u_cus_price.fprice_bj,u_cus_price.zqrate_bj
  170. INTO :arg_price,:arg_rebate
  171. FROM u_cus_price
  172. WHERE ( u_cus_price.cusid = :arg_cusid ) AND
  173. ( u_cus_price.mtrlid = :arg_mtrlid ) AND
  174. ( u_cus_price.status = :arg_status ) AND
  175. ( u_cus_price.pcode = :arg_pcode ) AND
  176. ( u_cus_price.woodcode = :arg_woodcode ) and
  177. ( u_cus_price.moneyid = :arg_moneyid);
  178. IF sqlca.SQLCode <> 0 THEN
  179. rslt = 0
  180. arg_msg = "没有最新销售价!"
  181. GOTO ext
  182. END IF
  183. ext:
  184. IF rslt = 0 THEN
  185. arg_price = 0
  186. arg_rebate = 0
  187. END IF
  188. RETURN rslt
  189. end function
  190. public function integer wf_importnewprice (long arg_cusid, long arg_moneyid, long arg_mtrlid, string arg_status, string arg_woodcode, string arg_pcode, ref decimal arg_price, ref decimal arg_rebate, ref string arg_msg);Int rslt = 1
  191. IF arg_moneyid = 0 THEN
  192. rslt = 0
  193. arg_msg = '请先选择币种'
  194. GOTO ext
  195. END IF
  196. IF IsNull(arg_cusid) THEN arg_cusid = 0
  197. IF arg_cusid = 0 THEN
  198. rslt = 0
  199. arg_msg = "请选择销售客户!"
  200. GOTO ext
  201. END IF
  202. SELECT u_cus_price.fprice,u_cus_price.zqrate
  203. INTO :arg_price,:arg_rebate
  204. FROM u_cus_price
  205. WHERE ( u_cus_price.cusid = :arg_cusid ) AND
  206. ( u_cus_price.mtrlid = :arg_mtrlid ) AND
  207. ( u_cus_price.status = :arg_status ) AND
  208. ( u_cus_price.pcode = :arg_pcode ) AND
  209. ( u_cus_price.woodcode = :arg_woodcode ) and
  210. ( u_cus_price.moneyid = :arg_moneyid);
  211. IF sqlca.SQLCode <> 0 THEN
  212. rslt = 0
  213. arg_msg = "没有最新销售价!"
  214. GOTO ext
  215. END IF
  216. ext:
  217. IF rslt = 0 THEN
  218. arg_price = 0
  219. arg_rebate = 0
  220. END IF
  221. RETURN rslt
  222. end function
  223. on w_outware_receive_ljfieb.create
  224. int iCurrent
  225. call super::create
  226. this.dw_uc=create dw_uc
  227. this.mle_1=create mle_1
  228. this.st_1=create st_1
  229. this.st_2=create st_2
  230. this.sle_scname=create sle_scname
  231. this.st_remark=create st_remark
  232. this.cb_accept=create cb_accept
  233. this.ln_bar=create ln_bar
  234. this.ln_bar2=create ln_bar2
  235. this.ln_1=create ln_1
  236. this.ln_2=create ln_2
  237. this.r_bar=create r_bar
  238. this.cb_bill=create cb_bill
  239. this.cb_feedback=create cb_feedback
  240. this.dw_child=create dw_child
  241. this.cb_reject=create cb_reject
  242. iCurrent=UpperBound(this.Control)
  243. this.Control[iCurrent+1]=this.dw_uc
  244. this.Control[iCurrent+2]=this.mle_1
  245. this.Control[iCurrent+3]=this.st_1
  246. this.Control[iCurrent+4]=this.st_2
  247. this.Control[iCurrent+5]=this.sle_scname
  248. this.Control[iCurrent+6]=this.st_remark
  249. this.Control[iCurrent+7]=this.cb_accept
  250. this.Control[iCurrent+8]=this.ln_bar
  251. this.Control[iCurrent+9]=this.ln_bar2
  252. this.Control[iCurrent+10]=this.ln_1
  253. this.Control[iCurrent+11]=this.ln_2
  254. this.Control[iCurrent+12]=this.r_bar
  255. this.Control[iCurrent+13]=this.cb_bill
  256. this.Control[iCurrent+14]=this.cb_feedback
  257. this.Control[iCurrent+15]=this.dw_child
  258. this.Control[iCurrent+16]=this.cb_reject
  259. end on
  260. on w_outware_receive_ljfieb.destroy
  261. call super::destroy
  262. destroy(this.dw_uc)
  263. destroy(this.mle_1)
  264. destroy(this.st_1)
  265. destroy(this.st_2)
  266. destroy(this.sle_scname)
  267. destroy(this.st_remark)
  268. destroy(this.cb_accept)
  269. destroy(this.ln_bar)
  270. destroy(this.ln_bar2)
  271. destroy(this.ln_1)
  272. destroy(this.ln_2)
  273. destroy(this.r_bar)
  274. destroy(this.cb_bill)
  275. destroy(this.cb_feedback)
  276. destroy(this.dw_child)
  277. destroy(this.cb_reject)
  278. end on
  279. event open;call super::open;tr_eb_sqlca = sys_email_sqlca // 电子商务连接
  280. IF sys_email_sqlca.DBHandle() = 0 THEN
  281. MessageBox('Error','电子商务数据库连接失败,请检查')
  282. RETURN
  283. END IF
  284. dw_uc.settransobject(tr_eb_sqlca)
  285. dw_child.settransobject(tr_eb_sqlca)
  286. //dw_mxmx.settransobject(tr_eb_sqlca)
  287. //dw_fymx.settransobject(tr_eb_sqlca)
  288. //dw_barcodemx.settransobject(tr_eb_sqlca)
  289. obj_saletask = Create uo_saletask
  290. obj_saletask.commit_transaction = sqlca
  291. uo_price = Create uo_cusprice
  292. uo_fieb = Create uo_ljfieb
  293. uo_fieb.commit_transaction = tr_eb_sqlca
  294. s_inscust = Message.PowerObjectParm
  295. ins_sn = s_inscust.serialnum
  296. ins_sendid = s_inscust.sendcuscommid
  297. ins_receid = s_inscust.receivecuscommid
  298. ins_sendsccode = s_inscust.sendsccode
  299. ins_reccesccode = s_inscust.receivesccode
  300. ins_RelatedCode = s_inscust.RelatedCode
  301. ins_addtime = s_inscust.addtime
  302. ins_adduser = s_inscust.adduser
  303. String ls_sccode,ls_scname
  304. String arg_msg
  305. ls_sccode = s_inscust.receivesccode
  306. SELECT scid,scname
  307. INTO :ins_scid,:ls_scname
  308. FROM u_scdef
  309. Where sccode = :ls_sccode;
  310. IF sqlca.SQLCode <> 0 THEN
  311. MessageBox('Error','查询分部信息失败,'+sqlca.SQLErrText)
  312. RETURN
  313. END IF
  314. sle_scname.Text = ls_scname
  315. st_remark.Text = '备注:'+s_inscust.remark
  316. mle_1.Text = s_inscust.postscript
  317. long ll_status
  318. SELECT status INTO :ll_status
  319. FROM LJFIEB_packet
  320. Where serialnum = :ins_sn Using tr_eb_sqlca;
  321. IF tr_eb_sqlca.SQLCode <> 0 THEN
  322. MessageBox('Error','查询通信数据失败,'+sqlca.SQLErrText)
  323. RETURN
  324. END IF
  325. if ll_status <> 5 then
  326. cb_accept.enabled = false
  327. cb_bill.enabled = false
  328. end if
  329. IF wf_retrieve(ins_sn,ins_sendid,ins_sendsccode,arg_msg) = 0 THEN
  330. MessageBox('Error',arg_msg)
  331. RETURN
  332. END IF
  333. //更新对方状态-已打开
  334. string ls_SerialNum
  335. SELECT TOP 1 NEWID() INTO :ls_SerialNum
  336. From u_user Using sqlca;
  337. IF sqlca.SQLCode <> 0 THEN
  338. return
  339. END IF
  340. IF IsNull(ls_SerialNum) THEN ls_SerialNum = ''
  341. IF ls_SerialNum = '' THEN
  342. return
  343. END IF
  344. IF uo_fieb.add_packet(ls_SerialNum,'',ins_receid,ins_reccesccode,ins_sendid,ins_sendsccode,5,'打开消息','','',ins_sn,'',0,arg_msg,True) = 0 THEN
  345. return
  346. END IF
  347. dw_child.BringToTop = TRUE
  348. end event
  349. event resize;call super::resize;ln_bar.EndX = This.Width
  350. ln_bar2.EndX = This.Width
  351. r_bar.Width = This.Width
  352. ln_1.EndX = This.Width
  353. ln_2.EndX = This.Width
  354. dw_child.Width = This.WorkSpaceWidth() - 10
  355. mle_1.Width = dw_child.Width - dw_uc.Width - 4
  356. //dw_child.Y = cb_fhmx.Y + 88
  357. dw_child.Y = dw_uc.Y + dw_uc.height + 5
  358. dw_child.Width = This.Width - dw_child.X - 40
  359. dw_child.Height = This.WorkSpaceHeight() - dw_child.Y - 120
  360. //dw_mxmx.X = dw_child.X
  361. //dw_mxmx.Y = dw_child.Y
  362. //dw_mxmx.Height = dw_child.Height
  363. //dw_mxmx.Width = dw_child.Width
  364. //
  365. //dw_barcodemx.X = dw_child.X
  366. //dw_barcodemx.Y = dw_child.Y
  367. //dw_barcodemx.Height = dw_child.Height
  368. //dw_barcodemx.Width = dw_child.Width
  369. //
  370. //dw_fymx.X = dw_child.X
  371. //dw_fymx.Y = dw_child.Y
  372. //dw_fymx.Height = dw_child.Height
  373. //dw_fymx.Width = dw_child.Width
  374. end event
  375. event close;call super::close;destroy uo_fieb
  376. destroy obj_saletask
  377. destroy uo_price
  378. closewithreturn(this,ins_relreissuecode)
  379. end event
  380. type cb_func from w_publ_base`cb_func within w_outware_receive_ljfieb
  381. boolean visible = false
  382. integer width = 311
  383. integer height = 96
  384. string text = "功能"
  385. string normalpicname = ""
  386. integer picsize = 0
  387. toolbaralignment pic_align = alignatleft!
  388. boolean border = true
  389. end type
  390. type cb_exit from w_publ_base`cb_exit within w_outware_receive_ljfieb
  391. integer x = 1097
  392. integer width = 183
  393. integer height = 164
  394. integer picsize = 16
  395. toolbaralignment pic_align = alignattop!
  396. boolean border = false
  397. end type
  398. type dw_uc from datawindow within w_outware_receive_ljfieb
  399. integer y = 296
  400. integer width = 2373
  401. integer height = 1156
  402. integer taborder = 30
  403. boolean bringtotop = true
  404. string title = "none"
  405. string dataobject = "dw_outware_sale_ljfieb"
  406. boolean livescroll = true
  407. borderstyle borderstyle = stylelowered!
  408. end type
  409. type mle_1 from multilineedit within w_outware_receive_ljfieb
  410. integer x = 2377
  411. integer y = 364
  412. integer width = 1193
  413. integer height = 1080
  414. integer taborder = 40
  415. boolean bringtotop = true
  416. integer textsize = -9
  417. integer weight = 400
  418. fontcharset fontcharset = gb2312charset!
  419. fontpitch fontpitch = variable!
  420. string facename = "宋体"
  421. long textcolor = 33554432
  422. boolean vscrollbar = true
  423. boolean autovscroll = true
  424. boolean displayonly = true
  425. borderstyle borderstyle = stylelowered!
  426. end type
  427. type st_1 from statictext within w_outware_receive_ljfieb
  428. integer x = 2386
  429. integer y = 300
  430. integer width = 142
  431. integer height = 56
  432. boolean bringtotop = true
  433. integer textsize = -9
  434. integer weight = 400
  435. fontcharset fontcharset = gb2312charset!
  436. fontpitch fontpitch = variable!
  437. string facename = "宋体"
  438. long textcolor = 33554432
  439. long backcolor = 134217739
  440. string text = "附言"
  441. boolean focusrectangle = false
  442. end type
  443. type st_2 from statictext within w_outware_receive_ljfieb
  444. integer x = 23
  445. integer y = 204
  446. integer width = 155
  447. integer height = 48
  448. boolean bringtotop = true
  449. integer textsize = -9
  450. integer weight = 400
  451. fontcharset fontcharset = gb2312charset!
  452. fontpitch fontpitch = variable!
  453. string facename = "宋体"
  454. long textcolor = 33554432
  455. long backcolor = 134217739
  456. string text = "分部"
  457. alignment alignment = right!
  458. boolean focusrectangle = false
  459. end type
  460. type sle_scname from singlelineedit within w_outware_receive_ljfieb
  461. integer x = 210
  462. integer y = 188
  463. integer width = 443
  464. integer height = 84
  465. integer taborder = 30
  466. boolean bringtotop = true
  467. integer textsize = -9
  468. integer weight = 400
  469. fontcharset fontcharset = gb2312charset!
  470. fontpitch fontpitch = variable!
  471. string facename = "宋体"
  472. long textcolor = 33554432
  473. boolean displayonly = true
  474. borderstyle borderstyle = stylelowered!
  475. end type
  476. type st_remark from statictext within w_outware_receive_ljfieb
  477. integer x = 727
  478. integer y = 200
  479. integer width = 2848
  480. integer height = 52
  481. boolean bringtotop = true
  482. integer textsize = -9
  483. integer weight = 400
  484. fontcharset fontcharset = gb2312charset!
  485. fontpitch fontpitch = variable!
  486. string facename = "宋体"
  487. long textcolor = 33554432
  488. long backcolor = 134217739
  489. string text = "备注:"
  490. boolean focusrectangle = false
  491. end type
  492. type cb_accept from uo_imflatbutton within w_outware_receive_ljfieb
  493. boolean visible = false
  494. integer width = 192
  495. integer height = 164
  496. integer taborder = 30
  497. boolean bringtotop = true
  498. string text = "确认"
  499. string normalpicname = "ok.bmp"
  500. integer picsize = 16
  501. toolbaralignment pic_align = alignattop!
  502. boolean border = false
  503. end type
  504. event clicked;call super::clicked;if messagebox('询问','是否要确认本消息?',question!,yesno!) = 2 then return
  505. UPDATE LJFIEB_packet
  506. SET Complete = 1 ,
  507. status = 6,
  508. ConfirmTime = getdate(),
  509. ConfirmUser = :publ_operator
  510. Where SerialNum = :ins_sn Using tr_eb_sqlca;
  511. IF tr_eb_sqlca.SQLCode <> 0 THEN
  512. ROLLBACK Using tr_eb_sqlca;
  513. MessageBox('Errr','更新通信记录状态失败,'+tr_eb_sqlca.SQLErrText)
  514. RETURN
  515. END IF
  516. commit Using tr_eb_sqlca;
  517. messagebox('系统提示','消息已确认')
  518. close(parent)
  519. end event
  520. type ln_bar from line within w_outware_receive_ljfieb
  521. long linecolor = 268435456
  522. integer linethickness = 4
  523. integer beginy = 172
  524. integer endx = 3200
  525. integer endy = 172
  526. end type
  527. type ln_bar2 from line within w_outware_receive_ljfieb
  528. long linecolor = 16777215
  529. integer linethickness = 4
  530. integer beginx = 9
  531. integer beginy = 176
  532. integer endx = 3273
  533. integer endy = 176
  534. end type
  535. type ln_1 from line within w_outware_receive_ljfieb
  536. long linecolor = 268435456
  537. integer linethickness = 4
  538. integer beginy = 284
  539. integer endx = 3250
  540. integer endy = 284
  541. end type
  542. type ln_2 from line within w_outware_receive_ljfieb
  543. long linecolor = 16777215
  544. integer linethickness = 4
  545. integer beginy = 288
  546. integer endx = 3282
  547. integer endy = 288
  548. end type
  549. type r_bar from rectangle within w_outware_receive_ljfieb
  550. long linecolor = 16777215
  551. integer linethickness = 4
  552. long fillcolor = 1073741824
  553. integer x = 3351
  554. integer width = 87
  555. integer height = 68
  556. end type
  557. event constructor;this.fillcolor = 14215660
  558. this.linecolor = 14215660
  559. this.x = -1
  560. this.y = -1
  561. this.height = ln_bar.beginy - 5
  562. end event
  563. type cb_bill from uo_imflatbutton within w_outware_receive_ljfieb
  564. integer width = 439
  565. integer height = 164
  566. integer taborder = 10
  567. boolean bringtotop = true
  568. string text = "转为采购收货单"
  569. string normalpicname = "ok.bmp"
  570. integer picsize = 16
  571. toolbaralignment pic_align = alignattop!
  572. boolean border = false
  573. end type
  574. event clicked;call super::clicked;If Not f_power_ind(3471) Then
  575. MessageBox(publ_operator,sys_msg_pow)
  576. Return
  577. End If
  578. If MessageBox('询问','确定要将当前供应商发货单转为正式采购收货单吗?',question!,yesno!) = 2 Then Return
  579. If ins_sptid = 0 Then
  580. MessageBox('系统提示','供应商信息不明确,不能建立采购收货单,请检查')
  581. Return
  582. End If
  583. s_packet_ljfieb s_edit_tran
  584. s_edit_tran.serialnum = ins_sn
  585. s_edit_tran.sendcuscommid = ins_sendid
  586. s_edit_tran.scid = ins_scid
  587. s_edit_tran.sendsccode = ins_sendsccode
  588. OpenWithParm(w_outware_to_inwarebuy_edit,s_edit_tran)
  589. string ls_relreissuecode
  590. ls_relreissuecode = message.stringparm
  591. if ls_relreissuecode = '' then return
  592. ins_relreissuecode = ls_relreissuecode
  593. String arg_msg
  594. String ls_SerialNum
  595. SELECT TOP 1 NEWID() INTO :ls_SerialNum
  596. From u_user Using sqlca;
  597. IF sqlca.SQLCode <> 0 THEN
  598. ROLLBACK Using sqlca;
  599. MessageBox('Error','生成序列号失败,'+sqlca.SQLErrText)
  600. RETURN
  601. END IF
  602. IF IsNull(ls_SerialNum) THEN ls_SerialNum = ''
  603. IF ls_SerialNum = '' THEN
  604. MessageBox('Error','错误的发送序列号')
  605. RETURN
  606. END IF
  607. IF uo_fieb.add_packet(ls_SerialNum,'',ins_receid,ins_reccesccode,ins_sendid,ins_sendsccode,6,'已收货','','',ins_sn,ins_RelatedCode,0,arg_msg,True) = 0 THEN
  608. MessageBox('系统提示','发送确认指令失败 '+arg_msg)
  609. RETURN
  610. END IF
  611. IF MessageBox('系统提示','成功生成采购收货单:'+ins_relreissuecode+',是否马上打开?',question!,yesno!) = 2 THEN ins_relreissuecode = ''
  612. Close(Parent)
  613. //
  614. //
  615. //
  616. end event
  617. type cb_feedback from uo_imflatbutton within w_outware_receive_ljfieb
  618. integer x = 439
  619. integer width = 439
  620. integer height = 164
  621. integer taborder = 30
  622. boolean bringtotop = true
  623. string text = "相关采购收货单"
  624. string normalpicname = "open.BMP"
  625. integer picsize = 16
  626. toolbaralignment pic_align = alignattop!
  627. boolean border = false
  628. end type
  629. event clicked;call super::clicked;Long ll_row
  630. String ls_code
  631. Long cnt
  632. String ls_relreissuecode
  633. ll_row = dw_uc.GetRow()
  634. If ll_row <= 0 Then Return
  635. If dw_uc.Object.flag[ll_row] = 0 Then
  636. MessageBox('系统提示','本供应商发货单尚未进行处理')
  637. Return
  638. End If
  639. ls_code = dw_uc.Object.relreissuecode[ll_row]
  640. Select count(*)
  641. Into :cnt
  642. From u_inware
  643. Where inwarecode = :ls_code Using sqlca;
  644. If sqlca.SQLCode <> 0 Then
  645. MessageBox('Error','查询采购收货单信息失败,'+sqlca.SQLErrText)
  646. Return
  647. End If
  648. If cnt = 0 Then
  649. If Not f_power_ind(3471) Then
  650. MessageBox('系统提示','无法查询相关收货单,可能已被删除')
  651. Return
  652. Else
  653. If MessageBox('询问','无法查询相关收货单,可能已被删除,是否重新生成新的采购收货单?',question!,yesno!) = 2 Then Return
  654. If ins_sptid = 0 Then
  655. MessageBox('系统提示','供应商信息不明确,不能建立采购收货单,请检查')
  656. Return
  657. End If
  658. s_packet_ljfieb s_edit_tran
  659. s_edit_tran.serialnum = ins_sn
  660. s_edit_tran.sendcuscommid = ins_sendid
  661. s_edit_tran.scid = ins_scid
  662. OpenWithParm(w_outware_to_inwarebuy_edit,s_edit_tran)
  663. ls_relreissuecode = Message.StringParm
  664. If ls_relreissuecode = '' Then Return
  665. dw_uc.Object.relreissuecode[ll_row] = ls_relreissuecode
  666. f_open_win(ins_scid,ls_relreissuecode)
  667. End If
  668. Else
  669. f_open_win(ins_scid,ls_code)
  670. End If
  671. end event
  672. type dw_child from u_dw_rbtnfilter within w_outware_receive_ljfieb
  673. integer y = 1552
  674. integer width = 3218
  675. integer height = 656
  676. integer taborder = 20
  677. boolean bringtotop = true
  678. boolean titlebar = true
  679. string title = "单据明细内容"
  680. string dataobject = "dw_outwaremx_sale_ljfieb"
  681. boolean maxbox = true
  682. boolean hscrollbar = true
  683. boolean vscrollbar = true
  684. boolean hsplitscroll = true
  685. end type
  686. event rowfocuschanged;call super::rowfocuschanged; IF currentrow <= 0 THEN RETURN
  687. THIS.SelectRow(0,FALSE)
  688. THIS.SelectRow(currentrow,TRUE)
  689. this.setrow(currentrow)
  690. end event
  691. event clicked;call super::clicked; IF row <= 0 THEN RETURN
  692. THIS.SelectRow(0,FALSE)
  693. THIS.SelectRow(row,TRUE)
  694. this.setrow(row)
  695. end event
  696. event rbuttondown;call super::rbuttondown;Long ll_row,ll_column
  697. ll_row = This.GetRow()
  698. ll_column = This.GetColumn()
  699. IF ll_row <= 0 THEN RETURN
  700. IF ll_column <= 0 THEN RETURN
  701. IF Left( This.Describe( dwo.Name+ ".coltype"),4) = 'date' THEN
  702. s_calender_arg s_calender
  703. s_calender.PointerX = This.PointerX()
  704. s_calender.PointerY = This.PointerY()
  705. s_calender.X = This.X + Parent.X
  706. s_calender.Y = This.Y + Parent.Y
  707. OpenWithParm(w_calendar,s_calender)
  708. This.SetItem(ll_row,ll_column,id_date_selected)
  709. END IF
  710. end event
  711. type cb_reject from uo_imflatbutton within w_outware_receive_ljfieb
  712. integer x = 878
  713. integer width = 219
  714. integer height = 164
  715. integer taborder = 40
  716. boolean bringtotop = true
  717. string text = "拒绝"
  718. string normalpicname = "DELETE.BMP"
  719. integer picsize = 16
  720. toolbaralignment pic_align = alignattop!
  721. boolean border = false
  722. end type
  723. event clicked;call super::clicked;//IF Not f_power_ind(3150,sys_msg_pow) THEN
  724. // MessageBox(publ_operator,sys_msg_pow)
  725. // RETURN
  726. //END IF
  727. String arg_summary,arg_postscript,arg_remark
  728. s_packet_ljfieb s_pack,s_return
  729. Int rslt = 1
  730. String arg_msg
  731. String ls_SerialNum
  732. //s_pack.summary = '拒绝订单:'+ins_RelatedCode
  733. OpenWithParm(w_dscrp_edit_ljfieb,s_pack)
  734. s_return = Message.PowerObjectParm
  735. IF s_return.returnflag <> 1 THEN RETURN
  736. //arg_summary = s_return.summary
  737. arg_postscript = s_return.postscript
  738. arg_remark = s_return.remark
  739. ////更新本地通信记录
  740. UPDATE LJFIEB_packet
  741. SET status = 10,
  742. Complete = 1,
  743. ConfirmTime = getdate(),
  744. ConfirmUser = :publ_operator
  745. Where SerialNum = :ins_sn Using tr_eb_sqlca;
  746. IF tr_eb_sqlca.SQLCode <> 0 THEN
  747. rslt = 0
  748. arg_msg = '更新本地通信记录失败,'+tr_eb_sqlca.SQLErrText
  749. GOTO ext
  750. END IF
  751. SELECT TOP 1 NEWID() INTO :ls_SerialNum
  752. From u_user Using sqlca;
  753. IF sqlca.SQLCode <> 0 THEN
  754. rslt = 0
  755. arg_msg = '生成序列号失败,'+sqlca.SQLErrText
  756. GOTO ext
  757. END IF
  758. IF IsNull(ls_SerialNum) THEN ls_SerialNum = ''
  759. IF ls_SerialNum = '' THEN
  760. rslt = 0
  761. arg_msg = '错误的发送序列号'
  762. GOTO ext
  763. END IF
  764. //INSERT INTO LJFIEB_tempbuyTask
  765. // (scid, TaskID, TaskCode, orderid, kind, sptID, requiredate, accomplishdate, finishemp,
  766. // Status, Opemp, Modemp, moddate, Assign_Emp, Permit_Emp, Permit_date, Dscrp,
  767. // opdate, stopemp, ctmint, printnum, relcode, banktypeid, train, reason, billtype,
  768. // firpermitemp, firpermitdate, billamt, moneyid, mrate, serialnum,banktypename,moneyname,cusid)
  769. // SELECT scid, TaskID, TaskCode, orderid, kind, sptID, requiredate, accomplishdate,
  770. // finishemp, 11, Opemp, Modemp, moddate, Assign_Emp, Permit_Emp,
  771. // Permit_date, Dscrp, opdate, stopemp, ctmint, printnum, relcode, banktypeid, train,
  772. // reason, billtype, firpermitemp, firpermitdate, billamt, moneyid, mrate, :ls_SerialNum,banktypename,moneyname,cusid
  773. // FROM LJFIEB_tempbuyTask
  774. // Where SerialNum = :ins_sn Using tr_eb_sqlca;
  775. //IF tr_eb_sqlca.SQLCode <> 0 THEN
  776. // rslt = 0
  777. // arg_msg = '插入临时采购订单表失败,'+tr_eb_sqlca.SQLErrText
  778. // GOTO ext
  779. //END IF
  780. IF uo_fieb.add_packet(ls_SerialNum,'',ins_receid,ins_reccesccode,ins_sendid,ins_sendsccode,11,arg_summary,arg_postscript,arg_remark,ins_sn,ins_RelatedCode,0,arg_msg,False) = 0 THEN
  781. rslt = 0
  782. arg_msg = '发送确认指令失败 '+arg_msg
  783. GOTO ext
  784. END IF
  785. ext:
  786. IF rslt = 1 THEN
  787. COMMIT Using tr_eb_sqlca;
  788. MessageBox('系统提示','操作成功')
  789. Close(Parent)
  790. ELSE
  791. ROLLBACK Using tr_eb_sqlca;
  792. MessageBox('系统提示',arg_msg)
  793. END IF
  794. end event