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

$PBExportHeader$w_rp_sale_cusarea.srw
forward
global type w_rp_sale_cusarea from w_publ_easyq
end type
type ddlb_1 from uo_ddlb_storageid within w_rp_sale_cusarea
end type
type ddlb_flag from dropdownlistbox within w_rp_sale_cusarea
end type
type tv_1 from uo_tv_cusarea within w_rp_sale_cusarea
end type
type st_1 from statictext within w_rp_sale_cusarea
end type
type st_2 from statictext within w_rp_sale_cusarea
end type
type st_5 from statictext within w_rp_sale_cusarea
end type
type st_6 from statictext within w_rp_sale_cusarea
end type
type cbx_showmx from checkbox within w_rp_sale_cusarea
end type
end forward

global type w_rp_sale_cusarea from w_publ_easyq
string title = "区域销售统计表"
ddlb_1 ddlb_1
ddlb_flag ddlb_flag
tv_1 tv_1
st_1 st_1
st_2 st_2
st_5 st_5
st_6 st_6
cbx_showmx cbx_showmx
end type
global w_rp_sale_cusarea w_rp_sale_cusarea

type variables
string ls_areaname=''
 
long ls_sonflag, il_sonflag_ori = -1

Long cur_flag = -1 //-1：全部，0仓库未审,1仓库已审核
Long cur_secflag = -1 //-1：全部，0财务未审
Long cur_storageid_arr[]

end variables

forward prototypes
public subroutine wf_selectionchanged (string arg_type)
public subroutine wf_hidecol ()
end prototypes

public subroutine wf_selectionchanged (string arg_type);dw_1.uf_save_profile_layout()
IF arg_type = 'HZ'  THEN //'区域汇总'
	dw_1.DataObject = 'dw_rp_sale_cusarea_1'
ELSE //MX
	dw_1.DataObject = 'dw_rp_sale_cusarea_2'
END IF

wf_replacedw()

//cb_1.TriggerEvent(Clicked!)

end subroutine

public subroutine wf_hidecol ();

s_hide_col s_col1,s_col2,s_col3

s_col1.col_1 = 'costamt'
f_hide_col(490,dw_1,s_col1)

s_col2.col_1 = 'gpamt'
s_col2.col_2 = 'gpr'
f_hide_col(843,dw_1,s_col2)

s_hide_col s_col_plan
s_col_plan.col_1 = 'u_mtrldef_planprice'
s_col_plan.col_2 = 'enamt_plan'
s_col_plan.col_3 = 'gpamt_plan'
f_hide_col(1451,dw_1,s_col_plan)

s_col3.col_1 = 'amt'
s_col3.col_2 = 'otheramt'
s_col3.col_3 = 'gpamt'
s_col3.col_4 = 'enamt_notax'
s_col3.col_5 = 'gpamt_notax'
s_col3.col_6 = 'costamt_notax'
f_hide_col(122,dw_1,s_col3)

end subroutine

on w_rp_sale_cusarea.create
int iCurrent
call super::create
this.ddlb_1=create ddlb_1
this.ddlb_flag=create ddlb_flag
this.tv_1=create tv_1
this.st_1=create st_1
this.st_2=create st_2
this.st_5=create st_5
this.st_6=create st_6
this.cbx_showmx=create cbx_showmx
iCurrent=UpperBound(this.Control)
this.Control[iCurrent+1]=this.ddlb_1
this.Control[iCurrent+2]=this.ddlb_flag
this.Control[iCurrent+3]=this.tv_1
this.Control[iCurrent+4]=this.st_1
this.Control[iCurrent+5]=this.st_2
this.Control[iCurrent+6]=this.st_5
this.Control[iCurrent+7]=this.st_6
this.Control[iCurrent+8]=this.cbx_showmx
end on

on w_rp_sale_cusarea.destroy
call super::destroy
destroy(this.ddlb_1)
destroy(this.ddlb_flag)
destroy(this.tv_1)
destroy(this.st_1)
destroy(this.st_2)
destroy(this.st_5)
destroy(this.st_6)
destroy(this.cbx_showmx)
end on

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

event ue_before_open;call super::ue_before_open;st_5.visible = false
st_6.visible = false
end event

type cb_func from w_publ_easyq`cb_func within w_rp_sale_cusarea
end type

type cb_exit from w_publ_easyq`cb_exit within w_rp_sale_cusarea
end type

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

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

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

event cb_1::clicked;call super::clicked;IF ls_areaname <> '' THEN
	ls_areaname = '%'+ls_areaname+'%'
ELSE
	ls_areaname = ""
END IF

DateTime firstdate,enddate
firstdate = DateTime(Date(Trim(em_1.Text)),Time("00:00:00"))
enddate = DateTime(Date(Trim(em_2.Text)),Time("23:59:59"))

//IF cbx_showmx.Checked THEN
//	dw_1.DataObject = "dw_rp_sale_cusarea_2"
//ELSE
//	IF ls_sonflag = 0 THEN
//		dw_1.DataObject = "dw_rp_sale_cusarea_1"
//	ELSEIF  ls_sonflag = 1 THEN
//		dw_1.DataObject = "dw_rp_sale_cusarea_2"
//	END IF
//END IF
//
//dw_1.SetTransObject(sqlca)

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_storageid_arr,firstdate,enddate,cur_flag,cur_secflag,sys_areaid,ls_areaname, sys_user_outrep, li_option_outrep)

wf_hidecol()










end event

type st_3 from w_publ_easyq`st_3 within w_rp_sale_cusarea
integer x = 1413
end type

type st_4 from w_publ_easyq`st_4 within w_rp_sale_cusarea
integer x = 2112
end type

type em_1 from w_publ_easyq`em_1 within w_rp_sale_cusarea
integer x = 1614
integer taborder = 120
end type

type em_2 from w_publ_easyq`em_2 within w_rp_sale_cusarea
integer x = 2222
integer taborder = 130
end type

type ddlb_yl from w_publ_easyq`ddlb_yl within w_rp_sale_cusarea
integer x = 1618
integer y = 12
end type

type cbx_yl from w_publ_easyq`cbx_yl within w_rp_sale_cusarea
integer x = 1408
integer y = 12
end type

type dw_1 from w_publ_easyq`dw_1 within w_rp_sale_cusarea
integer x = 859
integer y = 300
integer width = 2185
integer height = 1464
string dataobject = "dw_rp_sale_cusarea_1"
end type

type sle_mtrl from w_publ_easyq`sle_mtrl within w_rp_sale_cusarea
end type

type sle_cust from w_publ_easyq`sle_cust within w_rp_sale_cusarea
end type

type st_mtrl from w_publ_easyq`st_mtrl within w_rp_sale_cusarea
end type

type st_cust from w_publ_easyq`st_cust within w_rp_sale_cusarea
end type

type cbx_loginretr from w_publ_easyq`cbx_loginretr within w_rp_sale_cusarea
boolean visible = true
integer x = 1408
end type

type pb_em1 from w_publ_easyq`pb_em1 within w_rp_sale_cusarea
integer x = 2025
end type

type pb_em2 from w_publ_easyq`pb_em2 within w_rp_sale_cusarea
integer x = 2633
end type

type pb_2 from w_publ_easyq`pb_2 within w_rp_sale_cusarea
integer x = 2738
end type

type cb_help from w_publ_easyq`cb_help within w_rp_sale_cusarea
end type

type cb_copyself from w_publ_easyq`cb_copyself within w_rp_sale_cusarea
end type

type gb_1 from w_publ_easyq`gb_1 within w_rp_sale_cusarea
end type

type ln_bar from w_publ_easyq`ln_bar within w_rp_sale_cusarea
end type

type ln_bar2 from w_publ_easyq`ln_bar2 within w_rp_sale_cusarea
end type

type r_bar from w_publ_easyq`r_bar within w_rp_sale_cusarea
end type

type ln_1 from w_publ_easyq`ln_1 within w_rp_sale_cusarea
end type

type ln_2 from w_publ_easyq`ln_2 within w_rp_sale_cusarea
end type

type ln_3 from w_publ_easyq`ln_3 within w_rp_sale_cusarea
end type

type ln_4 from w_publ_easyq`ln_4 within w_rp_sale_cusarea
end type

type ddlb_1 from uo_ddlb_storageid within w_rp_sale_cusarea
integer x = 165
integer y = 192
integer width = 681
integer height = 1108
integer taborder = 50
boolean bringtotop = true
end type

event constructor;call super::constructor;cur_storageid_arr = this.uo_storageid_arr
end event

event selectionchanged;call super::selectionchanged;cur_storageid_arr = this.uo_storageid_arr
cb_1.triggerevent(clicked!)
end event

type ddlb_flag from dropdownlistbox within w_rp_sale_cusarea
integer x = 1001
integer y = 192
integer width = 389
integer height = 484
integer taborder = 90
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;if index=1 then
	cur_flag=-1
	cur_secflag= -1
elseif index=2 then
	cur_flag= 0 
	cur_secflag= -1
elseif index=3 then
	cur_flag= 1	
	cur_secflag= 0
elseif index=4 then
	cur_flag= 1	
	cur_secflag= 1
end if

cb_1.triggerevent(clicked!)


end event

type tv_1 from uo_tv_cusarea within w_rp_sale_cusarea
integer x = 5
integer y = 300
integer width = 855
integer height = 1464
integer taborder = 20
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 + '%'
ls_sonflag = This.uo_cur_info.sonflag

IF ls_sonflag <> il_sonflag_ori THEN
	IF Not cbx_showmx.Checked THEN
		IF ls_sonflag = 0 THEN
			wf_selectionchanged("HZ")
		ELSE
			wf_selectionchanged("MX")
		END IF
	END IF
	il_sonflag_ori = ls_sonflag
END IF
cb_1.TriggerEvent(Clicked!)




end event

type st_1 from statictext within w_rp_sale_cusarea
integer x = 5
integer y = 208
integer width = 146
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 = "仓库"
alignment alignment = right!
boolean focusrectangle = false
end type

type st_2 from statictext within w_rp_sale_cusarea
integer x = 855
integer y = 208
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 = "状态"
alignment alignment = right!
boolean focusrectangle = false
end type

type st_5 from statictext within w_rp_sale_cusarea
integer x = 2345
integer y = 40
integer width = 562
integer height = 48
boolean bringtotop = true
integer textsize = -9
integer weight = 400
fontcharset fontcharset = gb2312charset!
fontpitch fontpitch = variable!
string facename = "宋体"
long textcolor = 255
long backcolor = 67108864
string text = "dw_rp_sale_cusarea_1"
boolean focusrectangle = false
end type

type st_6 from statictext within w_rp_sale_cusarea
integer x = 2345
integer y = 116
integer width = 562
integer height = 48
boolean bringtotop = true
integer textsize = -9
integer weight = 400
fontcharset fontcharset = gb2312charset!
fontpitch fontpitch = variable!
string facename = "宋体"
long textcolor = 255
long backcolor = 67108864
string text = "dw_rp_sale_cusarea_2"
boolean focusrectangle = false
end type

type cbx_showmx from checkbox within w_rp_sale_cusarea
integer x = 2894
integer y = 208
integer width = 411
integer height = 60
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 = "显示区域明细"
end type

event clicked;IF This.Checked THEN
	wf_selectionchanged("MX")
ELSE
	IF il_sonflag_ori = 0 THEN
		wf_selectionchanged("HZ")
	ELSE
		wf_selectionchanged("MX")
	END IF
END IF
cb_1.TriggerEvent(Clicked!)

end event