Q5/ws_objects/Ew_report.pbl.src/w_rp_sptamt_mx.srw

$PBExportHeader$w_rp_sptamt_mx.srw
forward
global type w_rp_sptamt_mx from w_publ_easyq
end type
type st_2 from statictext within w_rp_sptamt_mx
end type
type ddlb_scid from uo_ddlb_scid within w_rp_sptamt_mx
end type
type st_5 from statictext within w_rp_sptamt_mx
end type
type ddlb_status from dropdownlistbox within w_rp_sptamt_mx
end type
end forward

global type w_rp_sptamt_mx from w_publ_easyq
integer x = 9
integer y = 12
string title = "供应商付款单统计表"
st_2 st_2
ddlb_scid ddlb_scid
st_5 st_5
ddlb_status ddlb_status
end type
global w_rp_sptamt_mx w_rp_sptamt_mx

type variables
Int cur_flag = -1,cur_confirmflag = -1,cur_secflag = -1

Long cur_scid_arr[]

long il_moneyid_native

end variables

forward prototypes
public subroutine wf_retr_billdscrp ()
end prototypes

public subroutine wf_retr_billdscrp ();Long ll_i,ll_refrapid
String ls_billdscrp,ls_billcode,ls_cusmoncode
decimal ld_takeamt

dw_1.AcceptText()

Open(w_sys_wait_jdt) //初始化进度条
w_sys_wait_jdt.Show()
w_sys_wait_jdt.wf_accepttol(dw_1.RowCount())

FOR ll_i = 1 TO dw_1.RowCount()
	
	ll_refrapid = dw_1.Object.u_cusamt_refrapid[ll_i]
	ls_cusmoncode = dw_1.Object.u_cusamt_cusmoncode[ll_i]
	
	
	
	w_sys_wait_jdt.wf_inc(ll_i)
	w_sys_wait_jdt.st_msg.Text = "正在统计:"+ls_cusmoncode+'...'
		
	DECLARE cur_billcode CURSOR FOR
		SELECT u_Bmsttakemx.Billcode,u_Bmsttakemx.takeamt
		FROM u_Bmsttakemx
		WHERE u_Bmsttakemx.takeid = :ll_refrapid
		AND u_Bmsttakemx.buildtype = 2;
		
	OPEN cur_billcode;
	FETCH cur_billcode INTO :ls_billcode,:ld_takeamt;
	DO WHILE sqlca.SQLCode = 0
		ls_billdscrp = ls_billdscrp + '单(' + ls_billcode + ','+string(0 - ld_takeamt,'#,#0.00')+'), '
		FETCH cur_billcode INTO :ls_billcode,:ld_takeamt;
	LOOP
	
	CLOSE cur_billcode;
	
	ls_billdscrp = Left(ls_billdscrp,Len(ls_billdscrp) - 1)
	
	dw_1.Object.billdscrp[ll_i] = ls_billdscrp
	
	ls_billdscrp = ''
NEXT

Close(w_sys_wait_jdt)




end subroutine

on w_rp_sptamt_mx.create
int iCurrent
call super::create
this.st_2=create st_2
this.ddlb_scid=create ddlb_scid
this.st_5=create st_5
this.ddlb_status=create ddlb_status
iCurrent=UpperBound(this.Control)
this.Control[iCurrent+1]=this.st_2
this.Control[iCurrent+2]=this.ddlb_scid
this.Control[iCurrent+3]=this.st_5
this.Control[iCurrent+4]=this.ddlb_status
end on

on w_rp_sptamt_mx.destroy
call super::destroy
destroy(this.st_2)
destroy(this.ddlb_scid)
destroy(this.st_5)
destroy(this.ddlb_status)
end on

event open;call super::open;EM_1.Text = String(Today(),'yyyy-mm')+'-01'
EM_2.Text = String(Today(),'YYYY-MM-DD')

SELECT moneyid INTO :il_moneyid_native
	FROM cw_currency
	Where native = 1;
IF sqlca.SQLCode <> 0 THEN
	il_moneyid_native = 0
	MessageBox('提示','查询本位币资料失败,请检查币种资料')
END IF

IF cbx_loginretr.Checked THEN
	cb_1.TriggerEvent(Clicked!)
END IF



end event

event ue_before_open;call super::ue_before_open;if_ue_retr = TRUE
if_ue_filter = TRUE
if_ue_sort = TRUE
//if_ue_sentdataout = TRUE
end event

type cb_func from w_publ_easyq`cb_func within w_rp_sptamt_mx
end type

type cb_exit from w_publ_easyq`cb_exit within w_rp_sptamt_mx
end type

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

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

type cb_1 from w_publ_easyq`cb_1 within w_rp_sptamt_mx
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'))

Int li_option_outrep  //业务员权限
IF sys_power_issuper THEN
	li_option_outrep = 0
ELSE
	li_option_outrep = sys_option_outrep
END IF

dw_1.Retrieve(cur_scid_arr,cur_flag,cur_secflag,cur_confirmflag,sys_user_spttype,firstdate,enddate)


end event

type st_3 from w_publ_easyq`st_3 within w_rp_sptamt_mx
integer x = 1307
integer y = 204
end type

type st_4 from w_publ_easyq`st_4 within w_rp_sptamt_mx
integer x = 2034
integer y = 204
end type

type em_1 from w_publ_easyq`em_1 within w_rp_sptamt_mx
integer x = 1509
integer y = 188
end type

type em_2 from w_publ_easyq`em_2 within w_rp_sptamt_mx
integer x = 2139
integer y = 188
end type

type ddlb_yl from w_publ_easyq`ddlb_yl within w_rp_sptamt_mx
end type

type cbx_yl from w_publ_easyq`cbx_yl within w_rp_sptamt_mx
end type

event cbx_yl::clicked;call super::clicked;IF THIS.Checked THEN
	dw_1.SelectRow(0,FALSE)
END IF

end event

type dw_1 from w_publ_easyq`dw_1 within w_rp_sptamt_mx
integer y = 300
integer width = 2208
string dataobject = "dw_rp_sptamt_mx"
end type

event dw_1::doubleclicked;call super::doubleclicked;
	IF row > 0 THEN
		String ls_code
		Long ll_scid
		
		ll_scid = This.Object.u_cusamt_scid[row]
		ls_code = This.Object.u_cusamt_cusmoncode[row]
		
		f_open_win(ll_scid,ls_code)		
	END IF

    
end event

type sle_mtrl from w_publ_easyq`sle_mtrl within w_rp_sptamt_mx
integer y = 492
end type

type sle_cust from w_publ_easyq`sle_cust within w_rp_sptamt_mx
integer y = 492
end type

type st_mtrl from w_publ_easyq`st_mtrl within w_rp_sptamt_mx
integer y = 508
end type

type st_cust from w_publ_easyq`st_cust within w_rp_sptamt_mx
integer y = 508
end type

type cbx_loginretr from w_publ_easyq`cbx_loginretr within w_rp_sptamt_mx
boolean visible = true
end type

type pb_em1 from w_publ_easyq`pb_em1 within w_rp_sptamt_mx
integer x = 1915
integer y = 188
end type

type pb_em2 from w_publ_easyq`pb_em2 within w_rp_sptamt_mx
integer x = 2555
integer y = 188
end type

type pb_2 from w_publ_easyq`pb_2 within w_rp_sptamt_mx
integer x = 2665
integer y = 188
end type

type cb_help from w_publ_easyq`cb_help within w_rp_sptamt_mx
end type

type cb_copyself from w_publ_easyq`cb_copyself within w_rp_sptamt_mx
end type

type gb_1 from w_publ_easyq`gb_1 within w_rp_sptamt_mx
integer x = 2418
integer y = 560
integer width = 87
integer height = 172
end type

type ln_bar from w_publ_easyq`ln_bar within w_rp_sptamt_mx
end type

type ln_bar2 from w_publ_easyq`ln_bar2 within w_rp_sptamt_mx
end type

type r_bar from w_publ_easyq`r_bar within w_rp_sptamt_mx
end type

type ln_1 from w_publ_easyq`ln_1 within w_rp_sptamt_mx
end type

type ln_2 from w_publ_easyq`ln_2 within w_rp_sptamt_mx
end type

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

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

type st_2 from statictext within w_rp_sptamt_mx
integer x = 27
integer y = 208
integer width = 137
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_scid from uo_ddlb_scid within w_rp_sptamt_mx
integer x = 160
integer y = 192
integer width = 549
integer height = 1120
integer taborder = 20
boolean bringtotop = true
end type

event constructor;call super::constructor;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_5 from statictext within w_rp_sptamt_mx
integer x = 745
integer y = 208
integer width = 146
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 = 134217739
string text = "状态"
alignment alignment = center!
boolean focusrectangle = false
end type

type ddlb_status from dropdownlistbox within w_rp_sptamt_mx
integer x = 914
integer y = 196
integer width = 393
integer height = 400
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
string item[] = {"[全部]","待初审","待终审","待确认","审核完毕"}
borderstyle borderstyle = stylelowered!
end type

event selectionchanged;IF Index = 1 THEN
	cur_flag = -1
	cur_confirmflag = -1
	cur_secflag = -1
ELSEIF Index = 2 THEN
	cur_flag = 0
	cur_secflag = 0
	cur_confirmflag = -1
ELSEIF Index = 3 THEN
	cur_flag = 1
	cur_secflag = 0
	cur_confirmflag = -1
ELSEIF Index = 4 THEN
	cur_flag = -1
	cur_secflag = -1
	cur_confirmflag = 0
ELSE
	cur_flag = 1
	cur_secflag = 1
	cur_confirmflag = 1
END IF

cb_1.TriggerEvent(Clicked!)


end event