w_rp_salebill.srw 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207
  1. $PBExportHeader$w_rp_salebill.srw
  2. forward
  3. global type w_rp_salebill from w_publ_easyq
  4. end type
  5. end forward
  6. global type w_rp_salebill from w_publ_easyq
  7. integer width = 3575
  8. integer height = 2192
  9. string title = "销售对数单明细表"
  10. end type
  11. global w_rp_salebill w_rp_salebill
  12. type variables
  13. String ins_accountname = ''
  14. end variables
  15. on w_rp_salebill.create
  16. call super::create
  17. end on
  18. on w_rp_salebill.destroy
  19. call super::destroy
  20. end on
  21. event open;call super::open;EM_1.TEXT=STRING(TODAY(),'YYYY-MM-01')
  22. IF cbx_loginretr.Checked THEN
  23. cb_1.TriggerEvent(Clicked!)
  24. END IF
  25. end event
  26. event ue_before_open;call super::ue_before_open;if_ue_retr=true
  27. if_ue_filter=true
  28. if_ue_sort=true
  29. if_ue_sentdataout=true
  30. end event
  31. type cb_func from w_publ_easyq`cb_func within w_rp_salebill
  32. end type
  33. type cb_exit from w_publ_easyq`cb_exit within w_rp_salebill
  34. integer x = 1157
  35. end type
  36. type cb_2 from w_publ_easyq`cb_2 within w_rp_salebill
  37. integer width = 192
  38. string text = "打印&P"
  39. end type
  40. type cb_psetup from w_publ_easyq`cb_psetup within w_rp_salebill
  41. end type
  42. type cb_1 from w_publ_easyq`cb_1 within w_rp_salebill
  43. end type
  44. event cb_1::clicked;call super::clicked;DateTime firstdate,enddate
  45. firstdate = DateTime(Date(em_1.Text),Time(0))
  46. enddate = DateTime(Date(em_2.Text),Time('23:59:59'))
  47. //UPDATE u_parm_pay
  48. //Set firstdate = :firstdate,
  49. //enddate = :enddate Where id = 3;
  50. //
  51. //
  52. //IF sqlca.SQLCode = 0 THEN
  53. // IF sqlca.SQLNRows = 0 THEN
  54. //
  55. // INSERT INTO u_parm_pay (firstdate,enddate,id) Values (:firstdate,:enddate,3);
  56. //
  57. // IF sqlca.SQLCode <> 0 THEN
  58. // ROLLBACK;
  59. // MessageBox('系统提示','数据库操作失败!I')
  60. // RETURN
  61. // END IF
  62. // END IF
  63. //ELSE
  64. // ROLLBACK;
  65. // MessageBox('系统提示','数据库操作失败!U')
  66. // RETURN
  67. //END IF
  68. //
  69. //COMMIT;
  70. dw_1.Retrieve(firstdate,enddate,sys_areaid)
  71. end event
  72. type st_3 from w_publ_easyq`st_3 within w_rp_salebill
  73. integer y = 216
  74. end type
  75. type st_4 from w_publ_easyq`st_4 within w_rp_salebill
  76. integer x = 736
  77. integer y = 216
  78. end type
  79. type em_1 from w_publ_easyq`em_1 within w_rp_salebill
  80. integer y = 200
  81. end type
  82. type em_2 from w_publ_easyq`em_2 within w_rp_salebill
  83. integer x = 841
  84. integer y = 200
  85. end type
  86. type ddlb_yl from w_publ_easyq`ddlb_yl within w_rp_salebill
  87. integer x = 1609
  88. end type
  89. type cbx_yl from w_publ_easyq`cbx_yl within w_rp_salebill
  90. integer x = 1390
  91. integer y = 16
  92. end type
  93. event cbx_yl::clicked;call super::clicked;if this.checked then
  94. dw_1.selectrow(0,false)
  95. end if
  96. end event
  97. type dw_1 from w_publ_easyq`dw_1 within w_rp_salebill
  98. integer y = 312
  99. integer height = 1024
  100. string dataobject = "dw_rp_salebill"
  101. end type
  102. event dw_1::rowfocuschanged;call super::rowfocuschanged;IF currentrow <=0 THEN RETURN
  103. this.selectrow(0,false)
  104. this.selectrow(currentrow,true)
  105. end event
  106. event dw_1::doubleclicked;call super::doubleclicked;IF row > 0 THEN
  107. String ls_code,ls_relcode
  108. Long ll_scid
  109. ll_scid = 0
  110. ls_code = THIS.Object.u_salebill_salebillcode[row]
  111. f_open_win(ll_scid,ls_code)
  112. END IF
  113. end event
  114. type sle_mtrl from w_publ_easyq`sle_mtrl within w_rp_salebill
  115. end type
  116. type sle_cust from w_publ_easyq`sle_cust within w_rp_salebill
  117. end type
  118. type st_mtrl from w_publ_easyq`st_mtrl within w_rp_salebill
  119. end type
  120. type st_cust from w_publ_easyq`st_cust within w_rp_salebill
  121. end type
  122. type cbx_loginretr from w_publ_easyq`cbx_loginretr within w_rp_salebill
  123. boolean visible = true
  124. integer x = 1390
  125. end type
  126. type pb_em1 from w_publ_easyq`pb_em1 within w_rp_salebill
  127. end type
  128. type pb_em2 from w_publ_easyq`pb_em2 within w_rp_salebill
  129. integer x = 1253
  130. end type
  131. type pb_2 from w_publ_easyq`pb_2 within w_rp_salebill
  132. integer x = 1362
  133. end type
  134. type cb_help from w_publ_easyq`cb_help within w_rp_salebill
  135. integer x = 1006
  136. end type
  137. type cb_copyself from w_publ_easyq`cb_copyself within w_rp_salebill
  138. end type
  139. type gb_1 from w_publ_easyq`gb_1 within w_rp_salebill
  140. end type
  141. type ln_bar from w_publ_easyq`ln_bar within w_rp_salebill
  142. end type
  143. type ln_bar2 from w_publ_easyq`ln_bar2 within w_rp_salebill
  144. end type
  145. type r_bar from w_publ_easyq`r_bar within w_rp_salebill
  146. end type
  147. type ln_1 from w_publ_easyq`ln_1 within w_rp_salebill
  148. end type
  149. type ln_2 from w_publ_easyq`ln_2 within w_rp_salebill
  150. end type
  151. type ln_3 from w_publ_easyq`ln_3 within w_rp_salebill
  152. end type
  153. type ln_4 from w_publ_easyq`ln_4 within w_rp_salebill
  154. end type