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

$PBExportHeader$w_rp_outware_other.srw
forward
global type w_rp_outware_other from w_publ_easyq
end type
type ddlb_storageid from uo_ddlb_storageid within w_rp_outware_other
end type
type ddlb_status from dropdownlistbox within w_rp_outware_other
end type
type st_1 from statictext within w_rp_outware_other
end type
type st_2 from statictext within w_rp_outware_other
end type
type ddlb_1 from dropdownlistbox within w_rp_outware_other
end type
type tv_1 from uo_tv_mtrltype within w_rp_outware_other
end type
end forward

global type w_rp_outware_other from w_publ_easyq
integer x = 123
integer height = 2504
string title = "其他出仓分类统计表"
ddlb_storageid ddlb_storageid
ddlb_status ddlb_status
st_1 st_1
st_2 st_2
ddlb_1 ddlb_1
tv_1 tv_1
end type
global w_rp_outware_other w_rp_outware_other

type variables
Long cur_storageid
Long cur_flag = -1

String ls_handtype = '',ls_mtrltype = ''
Int ls_sonflag
Int cur_mtrlorigin = -1

end variables

forward prototypes
public function integer wf_hide_col ()
end prototypes

public function integer wf_hide_col ();s_hide_col s_col
                
if dw_1.dataobject = 'dw_rp_inware_sc_mx' then
	s_col.col_1 = 'u_inwaremx_planprice'
	s_col.col_2 = 'u_inwaremx_price'	
	s_col.col_3 = 'planamt'
	s_col.col_4 = 'amt_1'
	s_col.col_5 = 'saleprice'
	s_col.col_6 = 'saleamt'
else	
	s_col.col_1 = 'amt'
	s_col.col_2 = 'price'
	s_col.col_3 = 'planamt'
	s_col.col_4 = 'u_mtrldef_planprice'
	s_col.col_5 = 'u_mtrldef_lmsaleprice'
	s_col.col_6 = 'lmsaleamt'
end if

//f_hide_col(121,dw_1,s_col)
f_hide_col(1449,dw_1,s_col)
s_hide_col s_col_mtrlsectype
s_col_mtrlsectype.col_1 = 'u_mtrldef_mtrlsectype' 
f_hide_col(1308,dw_1,s_col_mtrlsectype) 

s_hide_col s_col_zxmtrlmode
s_col_zxmtrlmode.col_1 = 'u_mtrldef_zxmtrlmode' 
f_hide_col(1309,dw_1,s_col_zxmtrlmode)
return 1
        
   
end function

on w_rp_outware_other.create
int iCurrent
call super::create
this.ddlb_storageid=create ddlb_storageid
this.ddlb_status=create ddlb_status
this.st_1=create st_1
this.st_2=create st_2
this.ddlb_1=create ddlb_1
this.tv_1=create tv_1
iCurrent=UpperBound(this.Control)
this.Control[iCurrent+1]=this.ddlb_storageid
this.Control[iCurrent+2]=this.ddlb_status
this.Control[iCurrent+3]=this.st_1
this.Control[iCurrent+4]=this.st_2
this.Control[iCurrent+5]=this.ddlb_1
this.Control[iCurrent+6]=this.tv_1
end on

on w_rp_outware_other.destroy
call super::destroy
destroy(this.ddlb_storageid)
destroy(this.ddlb_status)
destroy(this.st_1)
destroy(this.st_2)
destroy(this.ddlb_1)
destroy(this.tv_1)
end on

event resize;call super::resize;tv_1.height=this.height - dw_1.y - 150
end event

event ue_before_openretrieve;call super::ue_before_openretrieve;wf_hide_col()
end event

type cb_func from w_publ_easyq`cb_func within w_rp_outware_other
end type

type cb_exit from w_publ_easyq`cb_exit within w_rp_outware_other
end type

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

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

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

event cb_1::clicked;DateTime first_date,end_date
first_date = DateTime(Date(em_1.Text),Time(0))
end_date = DateTime(Date(em_2.Text),Time('23:59:59'))

string ls_storage
if cur_storageid<>-1 then
ls_storage=trim(mid(ddlb_storageid.text,1,pos(ddlb_storageid.text,'[')-1))
else
	ls_storage='全部仓库'
end if
//f_title_change(dw_1)

//wf_hide_col()
//dw_1.SetTransObject(sqlca)
IF ls_handtype <> '' THEN
		ls_mtrltype = ls_handtype+'%'
	ELSE
		ls_mtrltype = ""
	END IF
	
IF ddlb_1.Text = '按产品汇总' THEN
//	ls_handtype=ls_handtype+'%'
	dw_1.Retrieve(cur_storageid,cur_flag,first_date,end_date,ls_handtype,cur_mtrlorigin)
ELSE
	dw_1.Retrieve(cur_storageid,cur_flag,first_date,end_date,ls_handtype,ls_mtrltype,cur_mtrlorigin)
END IF

dw_1.Object.t_6.Text = '仓库:'+ls_storage
end event

type st_3 from w_publ_easyq`st_3 within w_rp_outware_other
integer x = 841
integer y = 216
end type

type st_4 from w_publ_easyq`st_4 within w_rp_outware_other
integer x = 1554
integer y = 224
end type

type em_1 from w_publ_easyq`em_1 within w_rp_outware_other
integer x = 1047
integer y = 196
integer taborder = 120
end type

type em_2 from w_publ_easyq`em_2 within w_rp_outware_other
integer x = 1659
integer y = 200
integer taborder = 130
end type

type ddlb_yl from w_publ_easyq`ddlb_yl within w_rp_outware_other
integer x = 1568
integer y = 4
end type

type cbx_yl from w_publ_easyq`cbx_yl within w_rp_outware_other
integer x = 1349
integer y = 4
end type

type dw_1 from w_publ_easyq`dw_1 within w_rp_outware_other
integer x = 805
integer y = 312
integer width = 2427
string dataobject = "dw_rp_other_outware"
end type

type sle_mtrl from w_publ_easyq`sle_mtrl within w_rp_outware_other
end type

type sle_cust from w_publ_easyq`sle_cust within w_rp_outware_other
end type

type st_mtrl from w_publ_easyq`st_mtrl within w_rp_outware_other
end type

type st_cust from w_publ_easyq`st_cust within w_rp_outware_other
end type

type cbx_loginretr from w_publ_easyq`cbx_loginretr within w_rp_outware_other
boolean visible = true
integer x = 1349
integer y = 100
end type

type pb_em1 from w_publ_easyq`pb_em1 within w_rp_outware_other
integer x = 1458
end type

type pb_em2 from w_publ_easyq`pb_em2 within w_rp_outware_other
integer x = 2071
integer y = 196
end type

type pb_2 from w_publ_easyq`pb_2 within w_rp_outware_other
integer x = 2181
integer y = 196
end type

type cb_help from w_publ_easyq`cb_help within w_rp_outware_other
end type

type cb_copyself from w_publ_easyq`cb_copyself within w_rp_outware_other
end type

type gb_1 from w_publ_easyq`gb_1 within w_rp_outware_other
end type

type ln_bar from w_publ_easyq`ln_bar within w_rp_outware_other
end type

type ln_bar2 from w_publ_easyq`ln_bar2 within w_rp_outware_other
end type

type r_bar from w_publ_easyq`r_bar within w_rp_outware_other
end type

type ln_1 from w_publ_easyq`ln_1 within w_rp_outware_other
end type

type ln_2 from w_publ_easyq`ln_2 within w_rp_outware_other
end type

type ln_3 from w_publ_easyq`ln_3 within w_rp_outware_other
end type

type ln_4 from w_publ_easyq`ln_4 within w_rp_outware_other
end type

type ddlb_storageid from uo_ddlb_storageid within w_rp_outware_other
integer x = 146
integer y = 204
integer width = 681
integer height = 976
integer taborder = 130
boolean bringtotop = true
end type

event constructor;call super::constructor;cur_storageid= this.uo_storageid

end event

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

type ddlb_status from dropdownlistbox within w_rp_outware_other
integer x = 2295
integer y = 200
integer width = 325
integer height = 976
integer taborder = 80
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
ELSEIF Index = 2 THEN
	cur_flag = 0
ELSEIF Index = 3 THEN
	cur_flag = 1
END IF
cb_1.TriggerEvent(clicked!)

end event

type st_1 from statictext within w_rp_outware_other
integer y = 220
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 = "仓库"
boolean focusrectangle = false
end type

type st_2 from statictext within w_rp_outware_other
integer x = 2295
integer y = 56
integer width = 155
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

event constructor;this.backcolor = 14215660
end event

type ddlb_1 from dropdownlistbox within w_rp_outware_other
integer x = 2423
integer y = 40
integer width = 567
integer height = 956
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 = "按产品汇总"
string item[] = {"按产品汇总","按物料类别汇总"}
borderstyle borderstyle = stylelowered!
end type

event selectionchanged;dw_1.uf_save_profile_layout()

if index=1 then 
	dw_1.dataobject='dw_rp_other_outware'
else
	dw_1.dataobject='dw_rp_other_outware_mtrltype'	
end if 

dw_1.SetTransObject(sqlca)

dw_1.ins_INIfile_name = sys_inifilename
dw_1.ins_opemp = publ_operator
dw_1.cardw_empid = sys_empid
dw_1.cur_DataObject = dw_1.DataObject

dw_1.uf_read_profile_layout()
wf_hide_col()

cb_1.TriggerEvent(Clicked!)
end event

type tv_1 from uo_tv_mtrltype within w_rp_outware_other
integer y = 300
integer width = 800
integer height = 1820
integer taborder = 90
boolean bringtotop = true
integer textsize = -9
fontcharset fontcharset = gb2312charset!
fontfamily fontfamily = anyfont!
string facename = "宋体"
end type

event selectionchanged;call super::selectionchanged;ls_handtype = THIS.uo_cur_info.handtype
ls_mtrltype = THIS.uo_cur_info.mtrltype
ls_sonflag = THIS.uo_cur_info.sonflag
cb_1.triggerevent(clicked!)

end event