Q5/ws_objects/cw_account.pbl.src/w_rp_spt_sub_hz2.srw

$PBExportHeader$w_rp_spt_sub_hz2.srw
forward
global type w_rp_spt_sub_hz2 from w_publ_easyq
end type
type ddlb_1 from dropdownlistbox within w_rp_spt_sub_hz2
end type
type ddlb_2 from dropdownlistbox within w_rp_spt_sub_hz2
end type
type st_1 from statictext within w_rp_spt_sub_hz2
end type
type cbx_ifpost from checkbox within w_rp_spt_sub_hz2
end type
type dw_2 from u_dw_rbtnfilter within w_rp_spt_sub_hz2
end type
type cbx_ifspt from checkbox within w_rp_spt_sub_hz2
end type
end forward

global type w_rp_spt_sub_hz2 from w_publ_easyq
string title = "供应商科目汇总表"
long backcolor = 81324524
boolean if_ue_sentdataout = true
ddlb_1 ddlb_1
ddlb_2 ddlb_2
st_1 st_1
cbx_ifpost cbx_ifpost
dw_2 dw_2
cbx_ifspt cbx_ifspt
end type
global w_rp_spt_sub_hz2 w_rp_spt_sub_hz2

on w_rp_spt_sub_hz2.create
int iCurrent
call super::create
this.ddlb_1=create ddlb_1
this.ddlb_2=create ddlb_2
this.st_1=create st_1
this.cbx_ifpost=create cbx_ifpost
this.dw_2=create dw_2
this.cbx_ifspt=create cbx_ifspt
iCurrent=UpperBound(this.Control)
this.Control[iCurrent+1]=this.ddlb_1
this.Control[iCurrent+2]=this.ddlb_2
this.Control[iCurrent+3]=this.st_1
this.Control[iCurrent+4]=this.cbx_ifpost
this.Control[iCurrent+5]=this.dw_2
this.Control[iCurrent+6]=this.cbx_ifspt
end on

on w_rp_spt_sub_hz2.destroy
call super::destroy
destroy(this.ddlb_1)
destroy(this.ddlb_2)
destroy(this.st_1)
destroy(this.cbx_ifpost)
destroy(this.dw_2)
destroy(this.cbx_ifspt)
end on

event open;THIS.TriggerEvent('ue_before_open')
wf_movetocenter()


dw_1.RBUTTON_FILTER_USE = TRUE //右键查询功能开关

IF Trim(dw_1.DataObject) <> '' THEN
	dw_1.Object.DataWindow.Print.MARGIN.Top = Integer(ProfileString(sys_inifilename,dw_1.DataObject, "MARGIN_TOP",   "110"))
	dw_1.Object.DataWindow.Print.MARGIN.Left = Integer(ProfileString(sys_inifilename,dw_1.DataObject, "MARGIN_LEFT", "96" ))
	
	dw_1.Object.DataWindow.Print.MARGIN.bottom = Integer(ProfileString(sys_inifilename,dw_1.DataObject, "MARGIN_BOTTOM",   "110"))
	dw_1.Object.DataWindow.Print.MARGIN.Right = Integer(ProfileString(sys_inifilename,dw_1.DataObject, "MARGIN_RIGHT", "96" ))
END IF


cb_1.TriggerEvent(Clicked!)



end event

event ue_before_open;call super::ue_before_open;dw_1.SetTransObject (sqlca)
dw_2.SetTransObject(sqlca)
IF dw_2.Retrieve(sys_accsetid) > 0 THEN
	dw_2.SelectRow(0,FALSE)
	dw_2.SetRow(1)
	dw_2.SelectRow(1,TRUE)
END IF


end event

event resize;call super::resize;dw_2.Height = dw_1.Height

end event

type cb_func from w_publ_easyq`cb_func within w_rp_spt_sub_hz2
end type

type cb_exit from w_publ_easyq`cb_exit within w_rp_spt_sub_hz2
end type

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

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

type cb_1 from w_publ_easyq`cb_1 within w_rp_spt_sub_hz2
boolean bringtotop = true
end type

event cb_1::clicked;call super::clicked;Long ls_firstcmon,ls_lastmon,ll_row
String ls_subid,ls_subname,ls_subid_like
Int li_ifpost,li_ifspt

ll_row = dw_2.GetRow()

IF cbx_ifpost.Checked THEN
	li_ifpost = -1
ELSE
	li_ifpost = 1
END IF

IF cbx_ifspt.Checked THEN
	li_ifspt = 1
ELSE
	li_ifspt = -1
END IF

ls_firstcmon = Long(em_1.Text) * 100 + Long(ddlb_1.Text)
ls_lastmon = Long(em_1.Text) * 100 + Long(ddlb_2.Text)

IF ll_row > 0 THEN
	ls_subid = dw_2.Object.subid[ll_row]
	ls_subid_like = ls_subid + '%'
	ls_subname = dw_2.Object.name[ll_row]
	dw_1.Retrieve(sys_accsetid,ls_subid,ls_subid_like,ls_firstcmon,ls_lastmon,li_ifpost,li_ifspt)
	dw_1.Object.t_subid.Text = ls_subname
ELSE
	dw_1.Reset()
END IF




end event

type st_3 from w_publ_easyq`st_3 within w_rp_spt_sub_hz2
integer x = 9
integer width = 288
string text = "会计年度："
end type

type st_4 from w_publ_easyq`st_4 within w_rp_spt_sub_hz2
integer x = 1074
integer width = 78
string text = "至"
end type

type em_1 from w_publ_easyq`em_1 within w_rp_spt_sub_hz2
integer x = 288
integer width = 242
string mask = "yyyy"
end type

event em_1::constructor;this.text=left(string(sys_curyearmon),4)
end event

type em_2 from w_publ_easyq`em_2 within w_rp_spt_sub_hz2
integer x = 1856
integer y = 468
end type

type ddlb_yl from w_publ_easyq`ddlb_yl within w_rp_spt_sub_hz2
end type

type cbx_yl from w_publ_easyq`cbx_yl within w_rp_spt_sub_hz2
integer x = 951
integer y = 44
end type

type dw_1 from w_publ_easyq`dw_1 within w_rp_spt_sub_hz2
integer x = 1239
integer width = 2190
string dataobject = "dw_rp_spt_sub_hz2"
end type

event dw_1::doubleclicked;call super::doubleclicked;s_edit_index_tran s_open //翻页功能窗口 传递参数使用
s_open.if_retrieve_all = TRUE  //是否一次RETRIEVE所有行
s_open.work_mode = 0            //0-单纯编辑模式, 1-选择模式
s_open.arg_pkid = 0             //目标定位PKID (备用)
s_open.arg_string_code = ''     //查询列部分内容,用于初步筛选 

Long li_row,li_row2

li_row = THIS.GetRow()
li_row2 = dw_2.GetRow()

IF li_row <= 0 THEN RETURN
IF li_row2 <= 0 THEN RETURN

s_open.b_string = dw_2.Object.subid[li_row2]
s_open.b_long = THIS.Object.uv_dept_bala_sptid[li_row]
s_open.c_long = Long(em_1.Text) * 100 + Long(ddlb_1.Text)
s_open.d_long = Long(em_1.Text) * 100 + Long(ddlb_2.Text)

IF cbx_ifpost.Checked THEN
	s_open.e_long = -1
ELSE
	s_open.e_long = 1
END IF

OpenWithParm(w_rp_spt_sub_hz2_mx,s_open)


end event

type ln_bar from w_publ_easyq`ln_bar within w_rp_spt_sub_hz2
end type

type ln_bar2 from w_publ_easyq`ln_bar2 within w_rp_spt_sub_hz2
end type

type r_bar from w_publ_easyq`r_bar within w_rp_spt_sub_hz2
end type

type ln_1 from w_publ_easyq`ln_1 within w_rp_spt_sub_hz2
end type

type ln_2 from w_publ_easyq`ln_2 within w_rp_spt_sub_hz2
end type

type ddlb_1 from dropdownlistbox within w_rp_spt_sub_hz2
integer x = 832
integer y = 200
integer width = 229
integer height = 908
integer taborder = 130
boolean bringtotop = true
integer textsize = -9
integer weight = 400
fontcharset fontcharset = gb2312charset!
fontpitch fontpitch = variable!
string facename = "宋体"
long textcolor = 33554432
boolean sorted = false
boolean vscrollbar = true
string item[] = {"1","2","3","4","5","6","7","8","9","10","11","12"}
borderstyle borderstyle = stylelowered!
end type

event constructor;THIS.Text = String(s_sys_accset.currmon)

end event

event selectionchanged;cb_1.TriggerEvent(Clicked!)

end event

type ddlb_2 from dropdownlistbox within w_rp_spt_sub_hz2
integer x = 1202
integer y = 200
integer width = 229
integer height = 908
integer taborder = 140
boolean bringtotop = true
integer textsize = -9
integer weight = 400
fontcharset fontcharset = gb2312charset!
fontpitch fontpitch = variable!
string facename = "宋体"
long textcolor = 33554432
boolean sorted = false
boolean vscrollbar = true
string item[] = {"1","2","3","4","5","6","7","8","9","10","11","12"}
borderstyle borderstyle = stylelowered!
end type

event constructor;THIS.Text = String(s_sys_accset.currmon)

end event

event selectionchanged;IF Long(ddlb_2.Text) < Long(ddlb_1.Text) THEN
	ddlb_1.Text = ddlb_2.Text
END IF

cb_1.TriggerEvent(Clicked!)

end event

type st_1 from statictext within w_rp_spt_sub_hz2
integer x = 539
integer y = 216
integer width = 288
integer height = 52
boolean bringtotop = true
integer textsize = -9
integer weight = 400
fontcharset fontcharset = gb2312charset!
fontpitch fontpitch = variable!
string facename = "宋体"
long textcolor = 33554432
long backcolor = 67108864
string text = "会计期间："
alignment alignment = right!
boolean focusrectangle = false
end type

type cbx_ifpost from checkbox within w_rp_spt_sub_hz2
integer x = 1463
integer y = 200
integer width = 466
integer height = 80
boolean bringtotop = true
integer textsize = -9
integer weight = 400
fontcharset fontcharset = gb2312charset!
fontpitch fontpitch = variable!
string facename = "宋体"
long textcolor = 33554432
long backcolor = 67108864
string text = "包括未登帐凭证"
end type

event clicked;Int li_ifpost

IF THIS.Checked THEN
	li_ifpost = 1
ELSE
	li_ifpost = 0
END IF
SetProfileString (sys_inifilename,dw_1.DataObject, "ifpost", String(li_ifpost))


cb_1.TriggerEvent(Clicked!)
end event

event constructor;Int li_ifpost
li_ifpost = Integer(ProfileString (sys_inifilename,dw_1.DataObject, "ifpost", '0'))
IF li_ifpost = 0 THEN
	THIS.Checked = FALSE
ELSE
	THIS.Checked = TRUE
END IF
end event

type dw_2 from u_dw_rbtnfilter within w_rp_spt_sub_hz2
integer y = 308
integer width = 1234
integer height = 928
integer taborder = 40
boolean bringtotop = true
string dataobject = "dw_rp_subid_hsspt_index"
boolean hscrollbar = true
boolean vscrollbar = true
boolean hsplitscroll = true
end type

event rowfocuschanged;IF currentrow > 0 THEN
	THIS.SelectRow(0,FALSE)
	THIS.SelectRow(currentrow,TRUE)
END IF

cb_1.TriggerEvent(Clicked!)


end event

type cbx_ifspt from checkbox within w_rp_spt_sub_hz2
integer x = 2002
integer y = 200
integer width = 741
integer height = 80
boolean bringtotop = true
integer textsize = -9
integer weight = 400
fontcharset fontcharset = gb2312charset!
fontpitch fontpitch = variable!
string facename = "宋体"
long textcolor = 33554432
long backcolor = 67108864
string text = "不显示无发生业务的供应商"
boolean checked = true
end type

event clicked;Int li_ifspt

IF THIS.Checked THEN
	li_ifspt = 1
ELSE
	li_ifspt = 0
END IF
SetProfileString (sys_inifilename,dw_1.DataObject, "ifspt", String(li_ifspt))


cb_1.TriggerEvent(Clicked!)
end event

event constructor;Int li_ifspt
li_ifspt = Integer(ProfileString (sys_inifilename,dw_1.DataObject, "ifspt", '0'))
IF li_ifspt = 0 THEN
	THIS.Checked = FALSE
ELSE
	THIS.Checked = TRUE
END IF
end event