w_rp_money_scidsum.srw 4.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184
  1. $PBExportHeader$w_rp_money_scidsum.srw
  2. forward
  3. global type w_rp_money_scidsum from w_publ_easyq
  4. end type
  5. end forward
  6. global type w_rp_money_scidsum from w_publ_easyq
  7. integer width = 3575
  8. integer height = 2192
  9. string title = "分部销售费用统计表"
  10. boolean if_ue_retr = true
  11. boolean if_ue_filter = true
  12. boolean if_ue_sort = true
  13. boolean if_ue_sentdataout = true
  14. end type
  15. global w_rp_money_scidsum w_rp_money_scidsum
  16. type variables
  17. long cur_itemCnt = 10
  18. long cur_itemid[]
  19. end variables
  20. forward prototypes
  21. public function integer wf_get_itemamt ()
  22. end prototypes
  23. public function integer wf_get_itemamt ();//SELECT scid, SUM(amt) AS itemamt, itemid
  24. //FROM u_income_expenses
  25. //WHERE (flag = 1)
  26. //and outdate between (:arg_firstdate and :arg_enddate)
  27. //GROUP BY scid, itemid
  28. return 1
  29. end function
  30. on w_rp_money_scidsum.create
  31. call super::create
  32. end on
  33. on w_rp_money_scidsum.destroy
  34. call super::destroy
  35. end on
  36. event open;call super::open;//菜单打开
  37. if_ue_retr=true
  38. if_ue_filter=true
  39. if_ue_sort=true
  40. if_ue_sentdataout=true
  41. IF cbx_loginretr.Checked THEN
  42. cb_1.TriggerEvent(Clicked!)
  43. END IF
  44. end event
  45. type cb_func from w_publ_easyq`cb_func within w_rp_money_scidsum
  46. end type
  47. type cb_exit from w_publ_easyq`cb_exit within w_rp_money_scidsum
  48. integer x = 1157
  49. end type
  50. type cb_2 from w_publ_easyq`cb_2 within w_rp_money_scidsum
  51. integer width = 192
  52. string text = "打印&P"
  53. end type
  54. type cb_psetup from w_publ_easyq`cb_psetup within w_rp_money_scidsum
  55. end type
  56. type cb_1 from w_publ_easyq`cb_1 within w_rp_money_scidsum
  57. end type
  58. event cb_1::clicked;call super::clicked;DateTime firstdate,enddate
  59. firstdate = DateTime(Date(em_1.Text),Time(0))
  60. enddate = DateTime(Date(em_2.Text),Time('23:59:59'))
  61. dw_1.Retrieve(firstdate,enddate,sys_user_scid)
  62. end event
  63. type st_3 from w_publ_easyq`st_3 within w_rp_money_scidsum
  64. integer y = 216
  65. end type
  66. type st_4 from w_publ_easyq`st_4 within w_rp_money_scidsum
  67. integer x = 731
  68. integer y = 216
  69. end type
  70. type em_1 from w_publ_easyq`em_1 within w_rp_money_scidsum
  71. integer y = 200
  72. end type
  73. type em_2 from w_publ_easyq`em_2 within w_rp_money_scidsum
  74. integer x = 837
  75. integer y = 200
  76. end type
  77. type ddlb_yl from w_publ_easyq`ddlb_yl within w_rp_money_scidsum
  78. integer x = 1609
  79. integer y = 12
  80. end type
  81. type cbx_yl from w_publ_easyq`cbx_yl within w_rp_money_scidsum
  82. integer x = 1390
  83. integer y = 12
  84. end type
  85. event cbx_yl::clicked;call super::clicked;if this.checked then
  86. dw_1.selectrow(0,false)
  87. end if
  88. end event
  89. type dw_1 from w_publ_easyq`dw_1 within w_rp_money_scidsum
  90. integer y = 312
  91. integer height = 1024
  92. string dataobject = "dw_rp_money_scidsum"
  93. end type
  94. event dw_1::rowfocuschanged;call super::rowfocuschanged;IF currentrow <=0 THEN RETURN
  95. this.selectrow(0,false)
  96. this.selectrow(currentrow,true)
  97. end event
  98. type sle_mtrl from w_publ_easyq`sle_mtrl within w_rp_money_scidsum
  99. end type
  100. type sle_cust from w_publ_easyq`sle_cust within w_rp_money_scidsum
  101. end type
  102. type st_mtrl from w_publ_easyq`st_mtrl within w_rp_money_scidsum
  103. end type
  104. type st_cust from w_publ_easyq`st_cust within w_rp_money_scidsum
  105. end type
  106. type cbx_loginretr from w_publ_easyq`cbx_loginretr within w_rp_money_scidsum
  107. boolean visible = true
  108. integer x = 1390
  109. integer y = 96
  110. end type
  111. type pb_em1 from w_publ_easyq`pb_em1 within w_rp_money_scidsum
  112. end type
  113. type pb_em2 from w_publ_easyq`pb_em2 within w_rp_money_scidsum
  114. end type
  115. type pb_2 from w_publ_easyq`pb_2 within w_rp_money_scidsum
  116. end type
  117. type cb_help from w_publ_easyq`cb_help within w_rp_money_scidsum
  118. integer x = 1006
  119. end type
  120. type cb_copyself from w_publ_easyq`cb_copyself within w_rp_money_scidsum
  121. end type
  122. type gb_1 from w_publ_easyq`gb_1 within w_rp_money_scidsum
  123. end type
  124. type ln_bar from w_publ_easyq`ln_bar within w_rp_money_scidsum
  125. end type
  126. type ln_bar2 from w_publ_easyq`ln_bar2 within w_rp_money_scidsum
  127. end type
  128. type r_bar from w_publ_easyq`r_bar within w_rp_money_scidsum
  129. end type
  130. type ln_1 from w_publ_easyq`ln_1 within w_rp_money_scidsum
  131. end type
  132. type ln_2 from w_publ_easyq`ln_2 within w_rp_money_scidsum
  133. end type
  134. type ln_3 from w_publ_easyq`ln_3 within w_rp_money_scidsum
  135. end type
  136. type ln_4 from w_publ_easyq`ln_4 within w_rp_money_scidsum
  137. end type