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

$PBExportHeader$w_rp_mx.srw
forward
global type w_rp_mx from w_publ_easyq
end type
type st_2 from statictext within w_rp_mx
end type
type ddlb_1 from dropdownlistbox within w_rp_mx
end type
type dw_2 from u_dw_rbtnfilter within w_rp_mx
end type
type cbx_1 from checkbox within w_rp_mx
end type
type cb_3 from uo_imflatbutton within w_rp_mx
end type
type cb_4 from uo_imflatbutton within w_rp_mx
end type
type cb_5 from uo_imflatbutton within w_rp_mx
end type
type st_5 from statictext within w_rp_mx
end type
type em_month from editmask within w_rp_mx
end type
type st_6 from statictext within w_rp_mx
end type
type ddlb_2 from dropdownlistbox within w_rp_mx
end type
type ddlb_3 from dropdownlistbox within w_rp_mx
end type
type cbx_ifpost from checkbox within w_rp_mx
end type
type st_1 from statictext within w_rp_mx
end type
end forward

global type w_rp_mx from w_publ_easyq
string title = "科目明细表"
long backcolor = 80269524
boolean if_ue_sentdataout = true
st_2 st_2
ddlb_1 ddlb_1
dw_2 dw_2
cbx_1 cbx_1
cb_3 cb_3
cb_4 cb_4
cb_5 cb_5
st_5 st_5
em_month em_month
st_6 st_6
ddlb_2 ddlb_2
ddlb_3 ddlb_3
cbx_ifpost cbx_ifpost
st_1 st_1
end type
global w_rp_mx w_rp_mx

type variables
s_rp_type s_rp_type_hz
boolean is_display=false

end variables

forward prototypes
public function integer wf_dw ()
end prototypes

public function integer wf_dw ();if ddlb_1.text = '金额式' then
	if ddlb_2.text = '月统计' then
		dw_1.dataobject='dw_rp_mx'
	else
		dw_1.dataobject='dw_rp_mx_year'
	end if
else	
	if ddlb_2.text = '月统计' then
		dw_1.dataobject='dw_rp_mx_wb'
	else
		dw_1.dataobject='dw_rp_mx_wb_year'
	end if
end if

dw_1.settransobject(sqlca)

return 1



end function

on w_rp_mx.create
int iCurrent
call super::create
this.st_2=create st_2
this.ddlb_1=create ddlb_1
this.dw_2=create dw_2
this.cbx_1=create cbx_1
this.cb_3=create cb_3
this.cb_4=create cb_4
this.cb_5=create cb_5
this.st_5=create st_5
this.em_month=create em_month
this.st_6=create st_6
this.ddlb_2=create ddlb_2
this.ddlb_3=create ddlb_3
this.cbx_ifpost=create cbx_ifpost
this.st_1=create st_1
iCurrent=UpperBound(this.Control)
this.Control[iCurrent+1]=this.st_2
this.Control[iCurrent+2]=this.ddlb_1
this.Control[iCurrent+3]=this.dw_2
this.Control[iCurrent+4]=this.cbx_1
this.Control[iCurrent+5]=this.cb_3
this.Control[iCurrent+6]=this.cb_4
this.Control[iCurrent+7]=this.cb_5
this.Control[iCurrent+8]=this.st_5
this.Control[iCurrent+9]=this.em_month
this.Control[iCurrent+10]=this.st_6
this.Control[iCurrent+11]=this.ddlb_2
this.Control[iCurrent+12]=this.ddlb_3
this.Control[iCurrent+13]=this.cbx_ifpost
this.Control[iCurrent+14]=this.st_1
end on

on w_rp_mx.destroy
call super::destroy
destroy(this.st_2)
destroy(this.ddlb_1)
destroy(this.dw_2)
destroy(this.cbx_1)
destroy(this.cb_3)
destroy(this.cb_4)
destroy(this.cb_5)
destroy(this.st_5)
destroy(this.em_month)
destroy(this.st_6)
destroy(this.ddlb_2)
destroy(this.ddlb_3)
destroy(this.cbx_ifpost)
destroy(this.st_1)
end on

event open;this.triggerevent('ue_before_open')
wf_movetocenter()
dw_2.SetTransObject (sqlca)
dw_1.SetTransObject (sqlca)
dw_1.titleclick_sort_use=false



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
dw_2.retrieve(sys_accsetid)
cb_1.triggerevent(clicked!)

end event

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

end event

event ue_before_open;call super::ue_before_open;if_ue_sort = TRUE
if_ue_sentdataout = TRUE

end event

type cb_func from w_publ_easyq`cb_func within w_rp_mx
end type

type cb_exit from w_publ_easyq`cb_exit within w_rp_mx
integer x = 1701
integer taborder = 50
end type

type cb_2 from w_publ_easyq`cb_2 within w_rp_mx
integer x = 1426
integer width = 274
integer taborder = 170
boolean bringtotop = true
string text = "选择打印"
end type

type cb_psetup from w_publ_easyq`cb_psetup within w_rp_mx
integer x = 1006
integer taborder = 150
boolean bringtotop = true
end type

type cb_1 from w_publ_easyq`cb_1 within w_rp_mx
integer taborder = 60
boolean bringtotop = true
end type

event cb_1::clicked;long ls_month
string ls_subid,ls_subname
int li_ifpost

if dw_2.getrow()<=0 then return

if cbx_ifpost.checked then
	li_ifpost = 1
else
	li_ifpost = 0
end if

ls_subid = dw_2.object.subid[dw_2.getrow()]
ls_subname=dw_2.object.name[dw_2.getrow()]
ls_subid = ls_subid + '%'
ls_month = long(em_month.text)
dw_1.retrieve(sys_accsetid,sys_subaccsetid,ls_subid,ls_month,li_ifpost)

if ddlb_2.text = '月统计' then 
	dw_1.object.title.text=ls_subname+' '+em_month.text+'月明细表'
else	
	dw_1.object.title.text=ls_subname+' '+em_month.text+'月统计表'
end if






end event

type st_3 from w_publ_easyq`st_3 within w_rp_mx
integer x = 261
integer y = 488
integer width = 448
integer weight = 700
long backcolor = 16776960
string text = "会计年度：2002"
alignment alignment = left!
boolean border = true
end type

type st_4 from w_publ_easyq`st_4 within w_rp_mx
integer x = 2423
integer y = 204
integer width = 462
integer height = 64
integer weight = 700
long backcolor = 16776960
string text = ""
alignment alignment = left!
boolean border = true
end type

type em_1 from w_publ_easyq`em_1 within w_rp_mx
integer x = 142
integer y = 576
integer taborder = 180
end type

type em_2 from w_publ_easyq`em_2 within w_rp_mx
integer x = 521
integer y = 576
integer taborder = 190
end type

type ddlb_yl from w_publ_easyq`ddlb_yl within w_rp_mx
integer x = 2071
integer y = 52
integer taborder = 100
end type

type cbx_yl from w_publ_easyq`cbx_yl within w_rp_mx
integer x = 1865
integer y = 52
integer taborder = 130
long backcolor = 67108864
end type

type dw_1 from w_publ_easyq`dw_1 within w_rp_mx
integer x = 1381
integer y = 300
integer width = 1943
integer height = 1100
string dataobject = "dw_rp_mx"
end type

type sle_mtrl from w_publ_easyq`sle_mtrl within w_rp_mx
integer x = 1778
integer y = 932
end type

type sle_cust from w_publ_easyq`sle_cust within w_rp_mx
integer x = 617
integer y = 932
end type

type st_mtrl from w_publ_easyq`st_mtrl within w_rp_mx
integer x = 1321
integer y = 948
end type

type st_cust from w_publ_easyq`st_cust within w_rp_mx
integer x = 155
integer y = 948
end type

type cbx_loginretr from w_publ_easyq`cbx_loginretr within w_rp_mx
integer x = 2409
integer y = 768
end type

type pb_em1 from w_publ_easyq`pb_em1 within w_rp_mx
boolean visible = false
integer y = 400
end type

type pb_em2 from w_publ_easyq`pb_em2 within w_rp_mx
boolean visible = false
integer y = 400
end type

type pb_2 from w_publ_easyq`pb_2 within w_rp_mx
boolean visible = false
integer x = 1691
integer y = 444
end type

type cb_help from w_publ_easyq`cb_help within w_rp_mx
boolean visible = false
integer x = 1925
integer y = 612
end type

type cb_copyself from w_publ_easyq`cb_copyself within w_rp_mx
integer x = 750
end type

type gb_1 from w_publ_easyq`gb_1 within w_rp_mx
end type

type ln_bar from w_publ_easyq`ln_bar within w_rp_mx
end type

type ln_bar2 from w_publ_easyq`ln_bar2 within w_rp_mx
end type

type r_bar from w_publ_easyq`r_bar within w_rp_mx
end type

type ln_1 from w_publ_easyq`ln_1 within w_rp_mx
end type

type ln_2 from w_publ_easyq`ln_2 within w_rp_mx
end type

type ln_3 from w_publ_easyq`ln_3 within w_rp_mx
boolean visible = false
end type

type ln_4 from w_publ_easyq`ln_4 within w_rp_mx
boolean visible = false
end type

type st_2 from statictext within w_rp_mx
integer x = 14
integer y = 212
integer width = 178
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
boolean enabled = false
string text = "格式："
boolean focusrectangle = false
end type

type ddlb_1 from dropdownlistbox within w_rp_mx
integer x = 201
integer y = 200
integer width = 416
integer height = 268
integer taborder = 20
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;wf_dw()

end event

type dw_2 from u_dw_rbtnfilter within w_rp_mx
integer x = 5
integer y = 300
integer width = 1376
integer height = 844
integer taborder = 40
boolean bringtotop = true
string dataobject = "dw_rp_mx_subidlist"
boolean hscrollbar = true
boolean vscrollbar = true
end type

event rowfocuschanged;if currentrow<=0 then return 
this.selectrow(0,false)
this.selectrow(currentrow,true)

string ls_subid,moneyname
long ls_moneyid=0

ls_subid=this.object.subid[currentrow]

select moneyid into :ls_moneyid from cw_subject 
where cw_subject.subid=:ls_subid
  and cw_subject.accsetid=:sys_accsetid;
if sqlca.sqlcode<>0 then
	ls_moneyid=0
end if

if ls_moneyid=0 then
	select name into :moneyname from cw_currency 
	where cw_currency.accsetid =:sys_accsetid
	  and cw_currency.native=1;
else
	select name into :moneyname from cw_currency 
	where cw_currency.accsetid =:sys_accsetid
	  and cw_currency.native=0
	  and cw_currency.moneyid=:ls_moneyid;
end if

st_4.text='币种：'+moneyname
cb_1.triggerevent(clicked!)


end event

type cbx_1 from checkbox within w_rp_mx
integer x = 2094
integer y = 204
integer width = 320
integer height = 64
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;long i
int k=0
if this.checked then k=1
for i= 1 to dw_2.rowcount()
	 dw_2.object.selectflag[i]=k
next
end event

type cb_3 from uo_imflatbutton within w_rp_mx
integer x = 1262
integer width = 165
integer height = 164
integer taborder = 140
boolean bringtotop = true
string text = "打印"
string normalpicname = "print.bmp"
integer picsize = 16
toolbaralignment pic_align = alignattop!
boolean border = false
end type

event clicked;IF NOT f_power_ind(153,sys_msg_pow) THEN
	MessageBox(publ_operator,'你没有使用权限！')
	RETURN
END IF

dw_1.Object.datawindow.Print.page.range = ''
dw_1.Object.datawindow.Print.copies = 1
Long i
Boolean printflag = FALSE
FOR i = 1 TO dw_2.RowCount()
	IF dw_2.Object.selectflag[i] = 1 THEN
		dw_2.ScrollToRow(i)
		printflag = TRUE
		dw_1.Print()
	END IF
NEXT

IF printflag = FALSE THEN
	MessageBox('系统提示','没有可打印的产品，请选择产品!')
	RETURN
END IF


end event

type cb_4 from uo_imflatbutton within w_rp_mx
integer x = 302
integer width = 224
integer height = 164
integer taborder = 80
boolean bringtotop = true
string text = "上一个"
string normalpicname = "p5.bmp"
integer picsize = 16
toolbaralignment pic_align = alignattop!
boolean border = false
end type

event clicked;dw_2.ScrollPriorRow()
end event

type cb_5 from uo_imflatbutton within w_rp_mx
integer x = 526
integer width = 224
integer height = 164
integer taborder = 120
boolean bringtotop = true
string text = "下一个"
string normalpicname = "p6.bmp"
integer picsize = 16
toolbaralignment pic_align = alignattop!
boolean border = false
end type

event clicked;dw_2.ScrollNextRow()
end event

type st_5 from statictext within w_rp_mx
integer x = 1216
integer y = 212
integer width = 178
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
boolean enabled = false
string text = "月份："
boolean focusrectangle = false
end type

type em_month from editmask within w_rp_mx
integer x = 1413
integer y = 200
integer width = 288
integer height = 84
integer taborder = 30
boolean bringtotop = true
integer textsize = -9
integer weight = 400
fontcharset fontcharset = gb2312charset!
fontpitch fontpitch = variable!
string facename = "宋体"
long textcolor = 33554432
alignment alignment = center!
borderstyle borderstyle = stylelowered!
maskdatatype maskdatatype = datemask!
string mask = "yyyymm"
boolean spin = true
end type

event constructor;this.text = string(sys_curyearmon)
end event

type st_6 from statictext within w_rp_mx
integer x = 626
integer y = 212
integer width = 178
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
boolean enabled = false
string text = "类型："
boolean focusrectangle = false
end type

type ddlb_2 from dropdownlistbox within w_rp_mx
integer x = 791
integer y = 200
integer width = 416
integer height = 268
integer taborder = 110
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;wf_dw()
end event

type ddlb_3 from dropdownlistbox within w_rp_mx
integer x = 1710
integer y = 200
integer width = 347
integer height = 228
integer taborder = 40
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

type cbx_ifpost from checkbox within w_rp_mx
integer x = 2359
integer y = 52
integer width = 466
integer height = 76
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

type st_1 from statictext within w_rp_mx
integer x = 2071
integer y = 188
integer width = 837
integer height = 96
integer textsize = -9
integer weight = 400
fontcharset fontcharset = gb2312charset!
fontpitch fontpitch = variable!
string facename = "宋体"
long textcolor = 33554432
long backcolor = 67108864
boolean border = true
boolean focusrectangle = false
end type