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

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

global type w_rp_musttake_balc_other 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_money ddlb_money
ddlb_2 ddlb_2
cbx_show cbx_show
end type
global w_rp_musttake_balc_other w_rp_musttake_balc_other

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

on w_rp_musttake_balc_other.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_money=create ddlb_money
this.ddlb_2=create ddlb_2
this.cbx_show=create cbx_show
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_money
this.Control[iCurrent+8]=this.ddlb_2
this.Control[iCurrent+9]=this.cbx_show
end on

on w_rp_musttake_balc_other.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_money)
destroy(this.ddlb_2)
destroy(this.cbx_show)
end on

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

event open;call super::open;ddlb_2.text = '明细表'
end event

type cb_func from w_publ_easyq`cb_func within w_rp_musttake_balc_other
end type

type cb_exit from w_publ_easyq`cb_exit within w_rp_musttake_balc_other
end type

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

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

type cb_1 from w_publ_easyq`cb_1 within w_rp_musttake_balc_other
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_ifshow
IF cbx_show.Checked THEN
	arg_ifshow = 1
ELSE
	arg_ifshow = 0
END IF

If dw_1.DataObject = 'dw_rp_musttake_balc_other_hz_1' Then
	
	dw_1.Retrieve(firstdate,enddate,cur_scid,ins_moneyid)
	
Else
	dw_1.Retrieve(firstdate,enddate,cur_scid,ins_moneyid,ls_areaname,arg_ifshow)

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_other
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_other
integer x = 873
integer y = 328
end type

type em_1 from w_publ_easyq`em_1 within w_rp_musttake_balc_other
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_other
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_other
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_other
integer x = 1339
integer y = 8
end type

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

type sle_mtrl from w_publ_easyq`sle_mtrl within w_rp_musttake_balc_other
end type

type sle_cust from w_publ_easyq`sle_cust within w_rp_musttake_balc_other
end type

type st_mtrl from w_publ_easyq`st_mtrl within w_rp_musttake_balc_other
end type

type st_cust from w_publ_easyq`st_cust within w_rp_musttake_balc_other
end type

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

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

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

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

type cb_help from w_publ_easyq`cb_help within w_rp_musttake_balc_other
end type

type cb_copyself from w_publ_easyq`cb_copyself within w_rp_musttake_balc_other
end type

type gb_1 from w_publ_easyq`gb_1 within w_rp_musttake_balc_other
end type

type ln_bar from w_publ_easyq`ln_bar within w_rp_musttake_balc_other
end type

type ln_bar2 from w_publ_easyq`ln_bar2 within w_rp_musttake_balc_other
end type

type r_bar from w_publ_easyq`r_bar within w_rp_musttake_balc_other
end type

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

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

type ln_3 from w_publ_easyq`ln_3 within w_rp_musttake_balc_other
end type

type ln_4 from w_publ_easyq`ln_4 within w_rp_musttake_balc_other
end type

type cbx_1 from checkbox within w_rp_musttake_balc_other
boolean visible = false
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_other
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_other
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_other
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_other
integer x = 155
integer y = 196
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_other
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_money from uo_ddlb_moneyid within w_rp_musttake_balc_other
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

type ddlb_2 from dropdownlistbox within w_rp_musttake_balc_other
integer x = 1915
integer y = 72
integer width = 699
integer height = 368
integer taborder = 80
boolean bringtotop = true
integer textsize = -8
integer weight = 400
fontcharset fontcharset = ansi!
fontpitch fontpitch = variable!
fontfamily fontfamily = swiss!
string facename = "Arial"
long textcolor = 33554432
boolean sorted = false
boolean vscrollbar = true
string item[] = {"明细表","汇总表[按客户项目]","汇总表[按项目]"}
borderstyle borderstyle = stylelowered!
end type

event selectionchanged;dw_1.uf_save_profile_layout()

IF ddlb_2.Text = '明细表' THEN
	dw_1.DataObject = 'dw_rp_musttake_balc_other'
ELSEIF ddlb_2.Text = '汇总表[按客户项目]' THEN
	dw_1.DataObject = 'dw_rp_musttake_balc_other_hz'
ELSEIF ddlb_2.Text = '汇总表[按项目]' THEN
	dw_1.DataObject = 'dw_rp_musttake_balc_other_hz_1'
END IF

wf_replacedw()

cb_1.TriggerEvent(Clicked!)
end event

type cbx_show from checkbox within w_rp_musttake_balc_other
integer x = 1371
integer y = 196
integer width = 631
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

event clicked;cb_1.triggerevent(clicked!)
end event