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

$PBExportHeader$w_rp_musttake_balc.srw
forward
global type w_rp_musttake_balc from w_publ_easyq
end type
type cbx_1 from checkbox within w_rp_musttake_balc
end type
type ddlb_1 from dropdownlistbox within w_rp_musttake_balc
end type
type tv_1 from uo_tv_cusarea within w_rp_musttake_balc
end type
type st_1 from statictext within w_rp_musttake_balc
end type
type ddlb_3 from uo_ddlb_scid within w_rp_musttake_balc
end type
type st_2 from statictext within w_rp_musttake_balc
end type
type ddlb_4 from dropdownlistbox within w_rp_musttake_balc
end type
type ddlb_money from uo_ddlb_moneyid within w_rp_musttake_balc
end type
end forward

global type w_rp_musttake_balc from w_publ_easyq
integer x = 9
integer y = 12
string title = "应收汇总表"
cbx_1 cbx_1
ddlb_1 ddlb_1
tv_1 tv_1
st_1 st_1
ddlb_3 ddlb_3
st_2 st_2
ddlb_4 ddlb_4
ddlb_money ddlb_money
end type
global w_rp_musttake_balc w_rp_musttake_balc

type variables
long ins_moneyid=0
String ls_areaname = ''
long cur_scid
long cur_scid_arr[]
end variables

on w_rp_musttake_balc.create
int iCurrent
call super::create
this.cbx_1=create cbx_1
this.ddlb_1=create ddlb_1
this.tv_1=create tv_1
this.st_1=create st_1
this.ddlb_3=create ddlb_3
this.st_2=create st_2
this.ddlb_4=create ddlb_4
this.ddlb_money=create ddlb_money
iCurrent=UpperBound(this.Control)
this.Control[iCurrent+1]=this.cbx_1
this.Control[iCurrent+2]=this.ddlb_1
this.Control[iCurrent+3]=this.tv_1
this.Control[iCurrent+4]=this.st_1
this.Control[iCurrent+5]=this.ddlb_3
this.Control[iCurrent+6]=this.st_2
this.Control[iCurrent+7]=this.ddlb_4
this.Control[iCurrent+8]=this.ddlb_money
end on

on w_rp_musttake_balc.destroy
call super::destroy
destroy(this.cbx_1)
destroy(this.ddlb_1)
destroy(this.tv_1)
destroy(this.st_1)
destroy(this.ddlb_3)
destroy(this.st_2)
destroy(this.ddlb_4)
destroy(this.ddlb_money)
end on

event ue_before_open;IF sys_option_scid_msttake_mstpay = 1 THEN
	dw_1.DataObject = 'dw_rp_musttake_balc'
ELSE
	dw_1.DataObject = 'dw_rp_musttake_balc_not_scid'
END IF

CALL Super :: ue_before_open ;

end event

event resize;call super::resize;tv_1.height=this.height - dw_1.y - 115
end event

type cb_func from w_publ_easyq`cb_func within w_rp_musttake_balc
end type

type cb_exit from w_publ_easyq`cb_exit within w_rp_musttake_balc
end type

type cb_2 from w_publ_easyq`cb_2 within w_rp_musttake_balc
boolean bringtotop = true
end type

type cb_psetup from w_publ_easyq`cb_psetup within w_rp_musttake_balc
boolean bringtotop = true
end type

type cb_1 from w_publ_easyq`cb_1 within w_rp_musttake_balc
boolean bringtotop = true
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'))

DELETE From u_parm_pay Where id = 2 ;
IF sqlca.SQLCode <> 0 THEN
	MessageBox('错误','数据库操作失败！'+sqlca.SQLErrText,stopsign!,ok!)
	ROLLBACK;
	RETURN
END IF

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

COMMIT;

Int arg_flag

IF cbx_1.Checked THEN
	arg_flag = 0
ELSE
	arg_flag = 1
END IF


IF sys_option_scid_msttake_mstpay = 1 THEN
	dw_1.Retrieve(ls_areaname,arg_flag,ins_moneyid,cur_scid_arr)
ELSE
	dw_1.Retrieve(ls_areaname,arg_flag,ins_moneyid)
END IF

dw_1.Object.dt_ar.Text = "日期范围: "+String(Date(firstdate))+" 到 "+em_2.Text



end event

type st_3 from w_publ_easyq`st_3 within w_rp_musttake_balc
integer x = 9
integer y = 324
integer width = 315
integer height = 64
string text = "发生日期从:"
alignment alignment = left!
end type

type st_4 from w_publ_easyq`st_4 within w_rp_musttake_balc
integer x = 873
integer y = 328
end type

type em_1 from w_publ_easyq`em_1 within w_rp_musttake_balc
integer x = 315
integer y = 304
integer width = 453
integer textsize = -10
end type

type em_2 from w_publ_easyq`em_2 within w_rp_musttake_balc
integer x = 974
integer y = 304
integer width = 453
integer textsize = -10
end type

type ddlb_yl from w_publ_easyq`ddlb_yl within w_rp_musttake_balc
integer x = 1559
integer y = 0
integer height = 668
end type

type cbx_yl from w_publ_easyq`cbx_yl within w_rp_musttake_balc
integer x = 1339
integer y = 8
end type

type dw_1 from w_publ_easyq`dw_1 within w_rp_musttake_balc
integer x = 850
integer y = 416
integer width = 2546
integer height = 1520
string dataobject = "dw_rp_musttake_balc"
end type

type sle_mtrl from w_publ_easyq`sle_mtrl within w_rp_musttake_balc
end type

type sle_cust from w_publ_easyq`sle_cust within w_rp_musttake_balc
end type

type st_mtrl from w_publ_easyq`st_mtrl within w_rp_musttake_balc
end type

type st_cust from w_publ_easyq`st_cust within w_rp_musttake_balc
end type

type cbx_loginretr from w_publ_easyq`cbx_loginretr within w_rp_musttake_balc
boolean visible = true
integer x = 1339
end type

type pb_em1 from w_publ_easyq`pb_em1 within w_rp_musttake_balc
integer x = 768
integer y = 300
end type

type pb_em2 from w_publ_easyq`pb_em2 within w_rp_musttake_balc
integer x = 1431
integer y = 304
end type

type pb_2 from w_publ_easyq`pb_2 within w_rp_musttake_balc
integer x = 1531
integer y = 304
end type

type cb_help from w_publ_easyq`cb_help within w_rp_musttake_balc
end type

type cb_copyself from w_publ_easyq`cb_copyself within w_rp_musttake_balc
end type

type gb_1 from w_publ_easyq`gb_1 within w_rp_musttake_balc
end type

type ln_bar from w_publ_easyq`ln_bar within w_rp_musttake_balc
end type

type ln_bar2 from w_publ_easyq`ln_bar2 within w_rp_musttake_balc
end type

type r_bar from w_publ_easyq`r_bar within w_rp_musttake_balc
end type

type ln_1 from w_publ_easyq`ln_1 within w_rp_musttake_balc
integer beginx = -46
integer endx = 1970
end type

type ln_2 from w_publ_easyq`ln_2 within w_rp_musttake_balc
integer beginx = -46
integer endx = 2002
end type

type ln_3 from w_publ_easyq`ln_3 within w_rp_musttake_balc
end type

type ln_4 from w_publ_easyq`ln_4 within w_rp_musttake_balc
end type

type cbx_1 from checkbox within w_rp_musttake_balc
integer x = 1339
integer y = 200
integer width = 585
integer height = 76
boolean bringtotop = true
integer textsize = -9
integer weight = 400
fontcharset fontcharset = gb2312charset!
fontpitch fontpitch = variable!
string facename = "宋体"
long textcolor = 16711680
long backcolor = 134217739
string text = "不显示无交易的客户"
boolean checked = true
end type

type ddlb_1 from dropdownlistbox within w_rp_musttake_balc
boolean visible = false
integer x = 2834
integer y = 204
integer width = 494
integer height = 564
integer taborder = 20
boolean bringtotop = true
integer textsize = -9
integer weight = 400
fontcharset fontcharset = gb2312charset!
fontpitch fontpitch = variable!
string facename = "宋体"
long textcolor = 33554432
boolean enabled = false
string text = "格式一"
boolean sorted = false
string item[] = {"格式一","格式二"}
borderstyle borderstyle = stylelowered!
end type

event selectionchanged;IF THIS.Text = '格式二' THEN
	dw_1.uf_save_profile_layout()
END IF


IF THIS.Text = '格式一' THEN
	dw_1.DataObject = 'dw_rp_musttake_balc'
ELSE
	dw_1.DataObject = 'dw_rp_musttake_balc_2'
END IF

dw_1.SetTransObject(sqlca)

IF THIS.Text = '格式一' THEN
	dw_1.ins_INIfile_name = sys_inifilename
	dw_1.ins_opemp = publ_operator
	dw_1.cardw_empid = sys_empid
	dw_1.cur_DataObject = dw_1.DataObject
	dw_1.uf_read_profile_layout()
END IF







end event

type tv_1 from uo_tv_cusarea within w_rp_musttake_balc
integer y = 416
integer width = 850
integer height = 1520
integer taborder = 60
boolean bringtotop = true
integer textsize = -9
fontcharset fontcharset = gb2312charset!
fontfamily fontfamily = anyfont!
string facename = "宋体"
end type

event selectionchanged;call super::selectionchanged;ls_areaname = THIS.uo_cur_info.areaname
ls_areaname = ls_areaname + '%'
cb_1.TriggerEvent(Clicked!)


end event

type st_1 from statictext within w_rp_musttake_balc
integer x = 695
integer y = 216
integer width = 128
integer height = 48
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 = "币种"
boolean focusrectangle = false
end type

type ddlb_3 from uo_ddlb_scid within w_rp_musttake_balc
integer x = 155
integer y = 204
integer width = 526
integer height = 768
integer taborder = 30
boolean bringtotop = true
end type

event constructor;call super::constructor;THIS.Enabled = (sys_option_scid_msttake_mstpay = 1)
cur_scid_arr = THIS.uo_scid_arr





end event

event selectionchanged;call super::selectionchanged;cur_scid_arr = THIS.uo_scid_arr
cb_1.TriggerEvent(Clicked!)


end event

type st_2 from statictext within w_rp_musttake_balc
integer x = 18
integer y = 216
integer width = 133
integer height = 48
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 = "分部"
boolean focusrectangle = false
end type

type ddlb_4 from dropdownlistbox within w_rp_musttake_balc
integer x = 1961
integer y = 48
integer width = 645
integer height = 448
integer taborder = 100
boolean bringtotop = true
integer textsize = -9
integer weight = 400
fontcharset fontcharset = gb2312charset!
fontpitch fontpitch = variable!
string facename = "宋体"
long textcolor = 33554432
string text = "汇总统计"
boolean sorted = false
boolean vscrollbar = true
string item[] = {"汇总统计","分项目统计"}
borderstyle borderstyle = stylelowered!
end type

event selectionchanged;IF This.Text <> '分项目统计' THEN
	dw_1.uf_save_profile_layout()
END IF

IF sys_option_scid_msttake_mstpay = 1 THEN
	IF This.Text = '汇总统计' THEN
		dw_1.DataObject = 'dw_rp_musttake_balc'
	ELSE //分项目统计
		dw_1.DataObject = 'dw_rp_musttake_balc_2'
	END IF
ELSE
	IF This.Text = '汇总统计' THEN
		dw_1.DataObject = 'dw_rp_musttake_balc_not_scid'
	ELSE //分项目统计
		dw_1.DataObject = 'dw_rp_musttake_balc_2_not_scid'
	END IF
END IF

dw_1.SetTransObject(sqlca)

IF This.Text <> '分项目统计' THEN
	dw_1.ins_INIfile_name = sys_inifilename
	dw_1.ins_opemp = publ_operator
	dw_1.cardw_empid = sys_empid
	dw_1.cur_DataObject = dw_1.DataObject
	
	dw_1.uf_read_profile_layout()
END IF

cb_1.TriggerEvent(Clicked!)



end event

type ddlb_money from uo_ddlb_moneyid within w_rp_musttake_balc
integer x = 827
integer y = 196
integer taborder = 30
boolean bringtotop = true
end type

event constructor;call super::constructor;ins_moneyid = THIS.uo_moneyid
end event

event selectionchanged;call super::selectionchanged;ins_moneyid = THIS.uo_moneyid
cb_1.TriggerEvent(Clicked!)

end event