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

$PBExportHeader$w_rp_item_sub_hz.srw
forward
global type w_rp_item_sub_hz from w_publ_easyq
end type
type ddlb_1 from dropdownlistbox within w_rp_item_sub_hz
end type
type ddlb_2 from dropdownlistbox within w_rp_item_sub_hz
end type
type ddlb_3 from dropdownlistbox within w_rp_item_sub_hz
end type
type st_2 from statictext within w_rp_item_sub_hz
end type
end forward

global type w_rp_item_sub_hz from w_publ_easyq
boolean TitleBar=true
string Title="项目科目总帐"
long BackColor=81324524
ddlb_1 ddlb_1
ddlb_2 ddlb_2
ddlb_3 ddlb_3
st_2 st_2
end type
global w_rp_item_sub_hz w_rp_item_sub_hz

on w_rp_item_sub_hz.create
int iCurrent
call super::create
this.ddlb_1=create ddlb_1
this.ddlb_2=create ddlb_2
this.ddlb_3=create ddlb_3
this.st_2=create st_2
iCurrent=UpperBound(this.Control)
this.Control[iCurrent+1]=this.ddlb_1
this.Control[iCurrent+2]=this.ddlb_2
this.Control[iCurrent+3]=this.ddlb_3
this.Control[iCurrent+4]=this.st_2
end on

on w_rp_item_sub_hz.destroy
call super::destroy
destroy(this.ddlb_1)
destroy(this.ddlb_2)
destroy(this.ddlb_3)
destroy(this.st_2)
end on

event open;this.triggerevent('ue_before_open')
wf_movetocenter()

dw_1.SetTransObject (sqlca)
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

string  ls_subname,ins_subname
string ls_subid,ins_subid

 DECLARE sub_cur CURSOR FOR  
  SELECT DISTINCT
         cw_subject.subid,   
         cw_subject.name  
    FROM cw_subject,uv_dept_bala 
	WHERE	uv_dept_bala.accsetid = cw_subject.accsetid
	  AND uv_dept_bala.subid = cw_subject.subid
	  AND uv_dept_bala.accsetid = :sys_accsetid	
	  AND uv_dept_bala.itemid <> 0
ORDER BY cw_subject.subid ASC  ;

OPEN sub_cur;
fetch sub_cur into :ls_subid,:ls_subname;
ins_subid=ls_subid
ins_subname=ls_subname
do while sqlca.sqlcode=0
	ddlb_3.additem('['+string(ls_subid)+']' + ls_subname)
	fetch sub_cur into :ls_subid,:ls_subname;
loop

ddlb_3.text='['+string(ins_subid)+']' + ins_subname
close sub_cur;

cb_1.triggerevent(clicked!)


end event

type cb_2 from w_publ_easyq`cb_2 within w_rp_item_sub_hz
boolean BringToTop=true
end type

type cb_psetup from w_publ_easyq`cb_psetup within w_rp_item_sub_hz
boolean BringToTop=true
end type

type cb_1 from w_publ_easyq`cb_1 within w_rp_item_sub_hz
boolean BringToTop=true
end type

event cb_1::clicked;call super::clicked;Long ls_firstcmon,ls_lastmon
String ls_subid
ls_firstcmon = Long(em_1.Text) * 100 + Long(ddlb_1.Text)
ls_lastmon = Long(em_1.Text) * 100 + Long(ddlb_2.Text)

ls_subid = Mid (ddlb_3.Text,Pos(ddlb_3.Text,'[') + 1,Pos(ddlb_3.Text,']') - 2 )

dw_1.Retrieve(sys_accsetid,ls_subid,ls_firstcmon,ls_lastmon)

end event

type st_3 from w_publ_easyq`st_3 within w_rp_item_sub_hz
int X=9
int Y=164
int Width=288
boolean BringToTop=true
string Text="会计年度："
end type

type st_4 from w_publ_easyq`st_4 within w_rp_item_sub_hz
int X=1015
int Y=164
int Width=78
boolean BringToTop=true
string Text="至"
end type

type em_1 from w_publ_easyq`em_1 within w_rp_item_sub_hz
int X=288
int Width=219
boolean BringToTop=true
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_item_sub_hz
int X=1559
int Y=300
boolean BringToTop=true
end type

type cbx_yl from w_publ_easyq`cbx_yl within w_rp_item_sub_hz
int X=1650
boolean BringToTop=true
end type

type dw_1 from w_publ_easyq`dw_1 within w_rp_item_sub_hz
int Width=2455
boolean BringToTop=true
string DataObject="dw_rp_item_sub_hz"
end type

type ddlb_1 from dropdownlistbox within w_rp_item_sub_hz
int X=773
int Y=148
int Width=229
int Height=908
int TabOrder=130
boolean BringToTop=true
BorderStyle BorderStyle=StyleLowered!
boolean Sorted=false
boolean VScrollBar=true
long TextColor=33554432
int TextSize=-9
int Weight=400
string FaceName="宋体"
FontCharSet FontCharSet=GB2312CharSet!
FontPitch FontPitch=Variable!
string Item[]={"1",&
"2",&
"3",&
"4",&
"5",&
"6",&
"7",&
"8",&
"9",&
"10",&
"11",&
"12"}
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_item_sub_hz
int X=1143
int Y=148
int Width=229
int Height=908
int TabOrder=140
boolean BringToTop=true
BorderStyle BorderStyle=StyleLowered!
boolean Sorted=false
boolean VScrollBar=true
long TextColor=33554432
int TextSize=-9
int Weight=400
string FaceName="宋体"
FontCharSet FontCharSet=GB2312CharSet!
FontPitch FontPitch=Variable!
string Item[]={"1",&
"2",&
"3",&
"4",&
"5",&
"6",&
"7",&
"8",&
"9",&
"10",&
"11",&
"12"}
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 ddlb_3 from dropdownlistbox within w_rp_item_sub_hz
int X=1650
int Y=148
int Width=1399
int Height=1012
int TabOrder=40
boolean BringToTop=true
BorderStyle BorderStyle=StyleLowered!
boolean Sorted=false
boolean VScrollBar=true
long TextColor=33554432
int TextSize=-9
int Weight=400
string FaceName="宋体"
FontCharSet FontCharSet=GB2312CharSet!
FontPitch FontPitch=Variable!
end type

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

type st_2 from statictext within w_rp_item_sub_hz
int X=1385
int Y=164
int Width=288
int Height=60
boolean Enabled=false
string Text="会计科目："
boolean FocusRectangle=false
long TextColor=33554432
long BackColor=67108864
int TextSize=-9
int Weight=400
string FaceName="宋体"
FontCharSet FontCharSet=GB2312CharSet!
FontPitch FontPitch=Variable!
end type