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

$PBExportHeader$w_rp_ware_outware.srw
forward
global type w_rp_ware_outware from w_publ_easyq
end type
type ddlb_1 from dropdownlistbox within w_rp_ware_outware
end type
type ddlb_2 from dropdownlistbox within w_rp_ware_outware
end type
type ddlb_3 from uo_ddlb_storageid within w_rp_ware_outware
end type
type cb_other from uo_imflatbutton within w_rp_ware_outware
end type
type tv_1 from uo_tv_mtrltype within w_rp_ware_outware
end type
type ddlb_4 from uo_ddlb_status within w_rp_ware_outware
end type
end forward

global type w_rp_ware_outware from w_publ_easyq
string title = "出仓统计表"
event ue_retrieve_info ( )
ddlb_1 ddlb_1
ddlb_2 ddlb_2
ddlb_3 ddlb_3
cb_other cb_other
tv_1 tv_1
ddlb_4 ddlb_4
end type
global w_rp_ware_outware w_rp_ware_outware

type variables
Long cur_billtype = 0
Long cur_storageid_arr[]
Int cur_mtrlorigin = -1
String ls_handtype = ''
string ls_mtrltype = ''
long cur_flag = -1

end variables

forward prototypes
public subroutine wf_hidecol ()
end prototypes

event ue_retrieve_info();Long ll_row
Long ll_mtrlid

ll_row = dw_1.GetRow()

IF ll_row <= 0 THEN
	ll_mtrlid = 0
ELSE
	ll_mtrlid = dw_1.Object.mtrlid[ll_row]
END IF

IF IsValid(w_mtrl_info) THEN
	w_mtrl_info.WindowState = Normal!
	w_mtrl_info.ins_mtrlid = ll_mtrlid
	w_mtrl_info.wf_retrieve(ll_mtrlid)
END IF


end event

public subroutine wf_hidecol ();s_hide_col s_col,s_col2

IF dw_1.DataObject = 'dw_rp_ware_outware' THEN
	s_col.col_1 = 'amt'
	s_col.col_2 = 'cost'
	s_col.col_3 = 'u_outwaremx_costamt'
	s_col.col_4 = 'u_outwaremx_ware_price'
	
	s_col2.col_1 = 'u_mtrldef_planprice'
	s_col2.col_2 = 'planamt'
ELSEIF dw_1.DataObject = 'dw_rp_ware_outware_hz' THEN
	s_col.col_1 = 'price'
	s_col.col_2 = 'amt'
	s_col.col_3 = 'cost'
	s_col.col_4 = 'costamt'
	
	s_col2.col_1 = 'u_mtrldef_planprice'
	s_col2.col_2 = 'planamt'
ELSEIF dw_1.DataObject = 'dw_rp_ware_outware_hz_mtrltype' THEN
	s_col.col_1 = 'amt'
	s_col.col_2 = 'costamt'
	
	s_col2.col_1 = 'planamt'	
ELSE
	s_col.col_1 = 'amt'
	s_col.col_2 = 'costamt'
	
	s_col2.col_1 = 'planamt'	
END IF
f_hide_col(490,dw_1,s_col) //隐藏出仓成本价
f_hide_col(1451,dw_1,s_col2) //隐藏计划价

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)

end subroutine

on w_rp_ware_outware.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.cb_other=create cb_other
this.tv_1=create tv_1
this.ddlb_4=create ddlb_4
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.cb_other
this.Control[iCurrent+5]=this.tv_1
this.Control[iCurrent+6]=this.ddlb_4
end on

on w_rp_ware_outware.destroy
call super::destroy
destroy(this.ddlb_1)
destroy(this.ddlb_2)
destroy(this.ddlb_3)
destroy(this.cb_other)
destroy(this.tv_1)
destroy(this.ddlb_4)
end on

event resize;call super::resize;tv_1.height=dw_1.height
end event

type cb_func from w_publ_easyq`cb_func within w_rp_ware_outware
end type

type cb_exit from w_publ_easyq`cb_exit within w_rp_ware_outware
integer x = 1477
end type

type cb_2 from w_publ_easyq`cb_2 within w_rp_ware_outware
integer x = 1175
boolean bringtotop = true
end type

type cb_psetup from w_publ_easyq`cb_psetup within w_rp_ware_outware
integer x = 919
boolean bringtotop = true
end type

type cb_1 from w_publ_easyq`cb_1 within w_rp_ware_outware
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'))
//f_title_change(dw_1)
IF ddlb_2.Text = '分类汇总表' THEN
	dw_1.Retrieve(cur_storageid_arr,first_date,end_date,cur_flag,cur_billtype,ls_handtype,ls_mtrltype,cur_mtrlorigin)
ELSE
	dw_1.Retrieve(cur_storageid_arr,first_date,end_date,cur_flag,cur_billtype,ls_handtype,cur_mtrlorigin)
END IF


end event

type st_3 from w_publ_easyq`st_3 within w_rp_ware_outware
integer x = 1120
integer y = 204
end type

type st_4 from w_publ_easyq`st_4 within w_rp_ware_outware
integer x = 1801
integer y = 204
end type

type em_1 from w_publ_easyq`em_1 within w_rp_ware_outware
integer x = 1307
integer y = 188
integer taborder = 120
end type

type em_2 from w_publ_easyq`em_2 within w_rp_ware_outware
integer x = 1897
integer y = 188
integer taborder = 130
end type

type ddlb_yl from w_publ_easyq`ddlb_yl within w_rp_ware_outware
integer x = 2066
integer y = 4
end type

type cbx_yl from w_publ_easyq`cbx_yl within w_rp_ware_outware
integer x = 1856
integer y = 8
end type

type dw_1 from w_publ_easyq`dw_1 within w_rp_ware_outware
integer x = 805
integer y = 300
integer width = 2386
integer height = 1808
string dataobject = "dw_rp_ware_outware"
end type

event dw_1::doubleclicked;call super::doubleclicked;IF dw_1.DataObject = 'dw_rp_ware_outware' THEN
	IF row > 0 THEN
		String ls_code,ls_relcode
		Long ll_scid
//		int li_thflag,li_billtype
		
		ll_scid = THIS.Object.u_outware_scid[row]
		ls_code = THIS.Object.u_outware_outwarecode[row]
//		ls_relcode = THIS.Object.u_outware_part[row]
//		li_billtype = THIS.Object.u_outware_billtype[row]
		

//		CHOOSE CASE li_billtype
//			CASE 4,12,15			
//				f_open_win(ll_scid,ls_relcode)
//			CASE ELSE				
				f_open_win(ll_scid,ls_code)
//		END CHOOSE
				
	END IF
END IF

end event

event dw_1::rowfocuschanged;call super::rowfocuschanged;IF ddlb_2.Text = '明细表' OR ddlb_2.Text = '汇总表' THEN
	PARENT.TriggerEvent('ue_retrieve_info')
END IF


end event

type sle_mtrl from w_publ_easyq`sle_mtrl within w_rp_ware_outware
end type

type sle_cust from w_publ_easyq`sle_cust within w_rp_ware_outware
end type

type st_mtrl from w_publ_easyq`st_mtrl within w_rp_ware_outware
end type

type st_cust from w_publ_easyq`st_cust within w_rp_ware_outware
end type

type cbx_loginretr from w_publ_easyq`cbx_loginretr within w_rp_ware_outware
integer x = 1856
integer y = 100
end type

type pb_em1 from w_publ_easyq`pb_em1 within w_rp_ware_outware
integer x = 1719
integer y = 188
end type

type pb_em2 from w_publ_easyq`pb_em2 within w_rp_ware_outware
integer x = 2309
integer y = 188
end type

type pb_2 from w_publ_easyq`pb_2 within w_rp_ware_outware
integer x = 2418
integer y = 188
end type

type cb_help from w_publ_easyq`cb_help within w_rp_ware_outware
integer x = 1326
end type

type cb_copyself from w_publ_easyq`cb_copyself within w_rp_ware_outware
end type

type gb_1 from w_publ_easyq`gb_1 within w_rp_ware_outware
end type

type ln_bar from w_publ_easyq`ln_bar within w_rp_ware_outware
end type

type ln_bar2 from w_publ_easyq`ln_bar2 within w_rp_ware_outware
end type

type r_bar from w_publ_easyq`r_bar within w_rp_ware_outware
integer x = 2501
end type

type ln_1 from w_publ_easyq`ln_1 within w_rp_ware_outware
end type

type ln_2 from w_publ_easyq`ln_2 within w_rp_ware_outware
end type

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

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

type ddlb_1 from dropdownlistbox within w_rp_ware_outware
integer x = 2866
integer y = 196
integer width = 681
integer height = 816
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 = "全    部[0]"
boolean sorted = false
boolean vscrollbar = true
string item[] = {"全    部[0]","现货销售[1]","领    料[3]","外加工出仓[4]","其    它[8]","盘    亏[9]","调拨出仓[12]","拆装出仓[15]"}
borderstyle borderstyle = stylelowered!
end type

event selectionchanged;cur_billtype=long(Mid ( ddlb_1.text,pos(ddlb_1.text,'[') + 1,len(ddlb_1.text) - pos(ddlb_1.text,'[') - 1 ))

cb_1.triggerevent(clicked!)

end event

event constructor;Long Index
String ls_txt
ls_txt = f_ProfileString(sys_empid, String(Parent.ClassName()), "dft_billtype",'全    部[0]')

Index = This.FindItem(ls_txt, 0)

IF Index > 0 THEN
//	This.SelectItem(Index)
	this.text = ls_txt
	cur_billtype=long(Mid ( this.text,pos(this.text,'[') + 1,len(this.text) - pos(this.text,'[') - 1 ))
END IF
end event

event destructor;f_SetProfileString(sys_empid, String(Parent.ClassName()), "dft_billtype", This.Text)
end event

type ddlb_2 from dropdownlistbox within w_rp_ware_outware
integer x = 2866
integer y = 32
integer width = 681
integer height = 448
integer taborder = 70
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;dw_1.uf_save_profile_layout()

IF ddlb_2.Text = '明细表' THEN
	dw_1.DataObject = 'dw_rp_ware_outware'
ELSEIF ddlb_2.Text = '汇总表' THEN
	dw_1.DataObject = 'dw_rp_ware_outware_hz'
ELSEIF ddlb_2.Text = '出仓类别统计表' THEN
	dw_1.DataObject = 'dw_rp_ware_outware_hz_type'
ELSE
	dw_1.DataObject = 'dw_rp_ware_outware_hz_mtrltype'
	
END IF

wf_replacedw()
//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 ddlb_3 from uo_ddlb_storageid within w_rp_ware_outware
integer y = 192
integer width = 1093
integer height = 1108
integer taborder = 130
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 cb_other from uo_imflatbutton within w_rp_ware_outware
integer x = 558
integer width = 361
integer height = 164
integer taborder = 140
boolean bringtotop = true
string text = "物料相关查询"
string normalpicname = "imexport.BMP"
integer picsize = 16
toolbaralignment pic_align = alignattop!
boolean border = false
end type

event clicked;call super::clicked;Long ll_row
ll_row = dw_1.GetRow()

IF ll_row <= 0 THEN
	MessageBox('提示','请选择物料',information!,OK!)
	RETURN
END IF

Long ll_mtrlid

IF ddlb_2.Text = '明细表' THEN
	ll_mtrlid = dw_1.Object.u_outwaremx_mtrlid[ll_row]
ELSEIF ddlb_2.Text = '汇总表' THEN 
	ll_mtrlid = dw_1.Object.u_mtrldef_mtrlid[ll_row]
ELSE
	RETURN
END IF

IF IsValid(w_mtrl_info) THEN
	w_mtrl_info.WindowState = Normal!
	w_mtrl_info.ins_mtrlid = ll_mtrlid
	w_mtrl_info.wf_retrieve(ll_mtrlid)
ELSE
	OpenWithParm(w_mtrl_info,ll_mtrlid)
END IF


end event

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

event selectionchanged;call super::selectionchanged;IF ddlb_2.Text = '分类汇总表' THEN
	
	ls_handtype = THIS.uo_cur_info.handtype
	ls_mtrltype = THIS.uo_cur_info.mtrltype
	
	IF ls_handtype <> '' THEN
		ls_mtrltype =  ls_handtype+'%'
	ELSE
		ls_mtrltype = ""
	END IF
ELSE
	ls_handtype = THIS.uo_cur_info.handtype
	ls_handtype = ls_handtype + '%'
END IF
cb_1.TriggerEvent(Clicked!)

end event

type ddlb_4 from uo_ddlb_status within w_rp_ware_outware
integer x = 2523
integer y = 196
integer width = 338
integer taborder = 130
boolean bringtotop = true
end type

event selectionchanged;call super::selectionchanged;cb_1.TriggerEvent(Clicked!)
end event

event uof_getvalue;call super::uof_getvalue;cur_flag = this.uo_status
end event