Q5/ws_objects/Ew_money.pbl.src/w_rp_rapmoney_sum.srw

$PBExportHeader$w_rp_rapmoney_sum.srw
forward
global type w_rp_rapmoney_sum from w_publ_easyq
end type
type cbx_1 from checkbox within w_rp_rapmoney_sum
end type
end forward

global type w_rp_rapmoney_sum from w_publ_easyq
integer x = 270
integer y = 136
integer width = 3577
integer height = 2192
string title = "出纳帐汇总表"
cbx_1 cbx_1
end type
global w_rp_rapmoney_sum w_rp_rapmoney_sum

type variables

String ins_accountname = ''
long ll_use = 0
end variables

on w_rp_rapmoney_sum.create
int iCurrent
call super::create
this.cbx_1=create cbx_1
iCurrent=UpperBound(this.Control)
this.Control[iCurrent+1]=this.cbx_1
end on

on w_rp_rapmoney_sum.destroy
call super::destroy
destroy(this.cbx_1)
end on

event open;call super::open;//菜单打开
if_ue_retr=true
if_ue_filter=true
if_ue_sort=true
if_ue_sentdataout=true

if cbx_1.checked then
	ll_use = 0
else 
	ll_use = 1
end if

IF cbx_loginretr.Checked THEN
	cb_1.TriggerEvent(Clicked!)
END IF
end event

type cb_func from w_publ_easyq`cb_func within w_rp_rapmoney_sum
end type

type cb_exit from w_publ_easyq`cb_exit within w_rp_rapmoney_sum
integer x = 1156
end type

type cb_2 from w_publ_easyq`cb_2 within w_rp_rapmoney_sum
integer width = 194
string text = "打印&P"
end type

type cb_psetup from w_publ_easyq`cb_psetup within w_rp_rapmoney_sum
end type

type cb_1 from w_publ_easyq`cb_1 within w_rp_rapmoney_sum
end type

event cb_1::clicked;call super::clicked;DateTime firstdate,enddate
firstdate = DateTime(Date(em_1.Text),Time(0))
enddate = DateTime(Date(em_2.Text),Time('23:59:59'))


UPDATE u_parm_pay 
Set firstdate = :firstdate,
enddate = :enddate Where id = 3;


IF sqlca.SQLCode = 0 THEN
	IF sqlca.SQLNRows = 0 THEN
		
		INSERT INTO u_parm_pay (firstdate,enddate,id) Values (:firstdate,:enddate,3);
		
		IF sqlca.SQLCode <> 0 THEN
			ROLLBACK;
			MessageBox('错误','数据库操作失败！I',stopsign!,ok!)
			RETURN
		END IF
	END IF
ELSE
	ROLLBACK;
	MessageBox('错误','数据库操作失败！U',stopsign!,ok!)
	RETURN
END IF

COMMIT;
dw_1.Retrieve(firstdate,enddate,ll_use)

end event

type st_3 from w_publ_easyq`st_3 within w_rp_rapmoney_sum
integer y = 218
end type

type st_4 from w_publ_easyq`st_4 within w_rp_rapmoney_sum
integer x = 731
integer y = 218
end type

type em_1 from w_publ_easyq`em_1 within w_rp_rapmoney_sum
integer y = 202
end type

type em_2 from w_publ_easyq`em_2 within w_rp_rapmoney_sum
integer x = 837
integer y = 202
end type

type ddlb_yl from w_publ_easyq`ddlb_yl within w_rp_rapmoney_sum
integer x = 1609
integer y = 13
end type

type cbx_yl from w_publ_easyq`cbx_yl within w_rp_rapmoney_sum
integer x = 1390
integer y = 13
end type

event cbx_yl::clicked;call super::clicked;if this.checked then
	dw_1.selectrow(0,false)
end if
end event

type dw_1 from w_publ_easyq`dw_1 within w_rp_rapmoney_sum
integer y = 314
integer height = 1024
string dataobject = "dw_rp_rap_sum"
end type

event dw_1::rowfocuschanged;call super::rowfocuschanged;IF currentrow <=0 THEN RETURN
this.selectrow(0,false)
this.selectrow(currentrow,true)
end event

type sle_mtrl from w_publ_easyq`sle_mtrl within w_rp_rapmoney_sum
end type

type sle_cust from w_publ_easyq`sle_cust within w_rp_rapmoney_sum
end type

type st_mtrl from w_publ_easyq`st_mtrl within w_rp_rapmoney_sum
end type

type st_cust from w_publ_easyq`st_cust within w_rp_rapmoney_sum
end type

type cbx_loginretr from w_publ_easyq`cbx_loginretr within w_rp_rapmoney_sum
boolean visible = true
integer x = 1390
integer y = 96
end type

type pb_em1 from w_publ_easyq`pb_em1 within w_rp_rapmoney_sum
end type

type pb_em2 from w_publ_easyq`pb_em2 within w_rp_rapmoney_sum
end type

type pb_2 from w_publ_easyq`pb_2 within w_rp_rapmoney_sum
end type

type cb_help from w_publ_easyq`cb_help within w_rp_rapmoney_sum
integer x = 1006
end type

type cb_copyself from w_publ_easyq`cb_copyself within w_rp_rapmoney_sum
end type

type gb_1 from w_publ_easyq`gb_1 within w_rp_rapmoney_sum
end type

type ln_bar from w_publ_easyq`ln_bar within w_rp_rapmoney_sum
end type

type ln_bar2 from w_publ_easyq`ln_bar2 within w_rp_rapmoney_sum
end type

type r_bar from w_publ_easyq`r_bar within w_rp_rapmoney_sum
end type

type ln_1 from w_publ_easyq`ln_1 within w_rp_rapmoney_sum
end type

type ln_2 from w_publ_easyq`ln_2 within w_rp_rapmoney_sum
end type

type ln_3 from w_publ_easyq`ln_3 within w_rp_rapmoney_sum
end type

type ln_4 from w_publ_easyq`ln_4 within w_rp_rapmoney_sum
end type

type cbx_1 from checkbox within w_rp_rapmoney_sum
integer x = 1532
integer y = 221
integer width = 527
integer height = 61
boolean bringtotop = true
integer textsize = -9
integer weight = 400
fontcharset fontcharset = gb2312charset!
fontpitch fontpitch = variable!
string facename = "宋体"
long textcolor = 33554432
long backcolor = 134217739
string text = "显示无效出纳账号"
end type

event clicked;if this.checked then
	ll_use = 0
else 
	ll_use = 1
end if

cb_1.TriggerEvent(Clicked!)
end event