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

$PBExportHeader$w_rp_mtrlware_warebalc.srw
forward
global type w_rp_mtrlware_warebalc from w_publ_easyq
end type
type ddlb_2 from uo_ddlb_storageid within w_rp_mtrlware_warebalc
end type
type ddlb_storageid from uo_ddlb_storageid within w_rp_mtrlware_warebalc
end type
type tv_1 from uo_tv_mtrltype within w_rp_mtrlware_warebalc
end type
type ddlb_1 from dropdownlistbox within w_rp_mtrlware_warebalc
end type
end forward

global type w_rp_mtrlware_warebalc from w_publ_easyq
string title = "仓库历史库存表"
ddlb_2 ddlb_2
ddlb_storageid ddlb_storageid
tv_1 tv_1
ddlb_1 ddlb_1
end type
global w_rp_mtrlware_warebalc w_rp_mtrlware_warebalc

type variables
Long cur_storageid_arr[]

Long cur_storageid = -1
String ls_handtype = ''

end variables

forward prototypes
public subroutine wf_hidecol ()
end prototypes

public subroutine wf_hidecol ();s_hide_col s_col


IF ddlb_1.Text = '明细表' Or ddlb_1.Text = '汇总表'  THEN
	s_col.col_1 = 'v_ware_day_bgamt'
	s_col.col_2 = 'v_ware_day_incamt'
	s_col.col_3 = 'v_ware_day_desamt'
	s_col.col_4 = 'v_ware_day_balcamt'
	s_col.col_5 = 'v_ware_day_balccost'
	
	f_hide_col(123,dw_1,s_col)
END IF
end subroutine

on w_rp_mtrlware_warebalc.create
int iCurrent
call super::create
this.ddlb_2=create ddlb_2
this.ddlb_storageid=create ddlb_storageid
this.tv_1=create tv_1
this.ddlb_1=create ddlb_1
iCurrent=UpperBound(this.Control)
this.Control[iCurrent+1]=this.ddlb_2
this.Control[iCurrent+2]=this.ddlb_storageid
this.Control[iCurrent+3]=this.tv_1
this.Control[iCurrent+4]=this.ddlb_1
end on

on w_rp_mtrlware_warebalc.destroy
call super::destroy
destroy(this.ddlb_2)
destroy(this.ddlb_storageid)
destroy(this.tv_1)
destroy(this.ddlb_1)
end on

event ue_before_openretrieve;call super::ue_before_openretrieve;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 event

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_mtrlware_warebalc
end type

type cb_exit from w_publ_easyq`cb_exit within w_rp_mtrlware_warebalc
end type

type cb_2 from w_publ_easyq`cb_2 within w_rp_mtrlware_warebalc
integer taborder = 100
boolean bringtotop = true
end type

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

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

event cb_1::clicked;DateTime firstdate,enddate

firstdate = DateTime(Date(em_1.Text),Time(0))
enddate = DateTime(Date(em_2.Text),Time('23:59:59'))

//IF cur_storageid <= 0 THEN
//	MessageBox('提示','请选择仓库')
//	dw_1.Reset()
//	RETURN
//END IF

DELETE u_parm_batchtake 
Where cusid = :cur_storageid Or :cur_storageid = -1 ;
IF sqlca.SQLCode <> 0 THEN
	ROLLBACK ;
	MessageBox(publ_operator,"更新查询时间失败！"+sqlca.SQLErrText)
	RETURN
END IF

INSERT INTO u_parm_batchtake
	(cusid,firstdate,enddate,balcdateint)
	SELECT storageid,:firstdate,:enddate,0
	FROM u_storage
	Where storageid = :cur_storageid Or :cur_storageid = -1;
IF sqlca.SQLCode <> 0 THEN
	ROLLBACK ;
	MessageBox(publ_operator,"更新查询时间失败！"+sqlca.SQLErrText)
	RETURN
END IF
	COMMIT ;


SetPointer(HourGlass!)


dw_1.Retrieve(cur_storageid_arr,ls_handtype)
IF ddlb_1.Text = '汇总表' THEN
	dw_1.Object.Title.Text = f_rst_storagename(cur_storageid)+'历史库存表(汇总表)'
ELSE
	dw_1.Object.Title.Text = f_rst_storagename(cur_storageid)+'历史库存表'
END IF
SetPointer(Arrow!)

//IF retrieve_all THEN
//	THIS.TriggerEvent("ue_usual_query_filt")
//END IF




end event

type st_3 from w_publ_easyq`st_3 within w_rp_mtrlware_warebalc
integer x = 754
integer y = 216
end type

type st_4 from w_publ_easyq`st_4 within w_rp_mtrlware_warebalc
integer x = 1504
integer y = 212
end type

type em_1 from w_publ_easyq`em_1 within w_rp_mtrlware_warebalc
integer x = 960
integer y = 200
integer taborder = 110
end type

type em_2 from w_publ_easyq`em_2 within w_rp_mtrlware_warebalc
integer x = 1609
integer y = 196
integer taborder = 120
end type

type ddlb_yl from w_publ_easyq`ddlb_yl within w_rp_mtrlware_warebalc
integer x = 1595
integer y = 8
end type

type cbx_yl from w_publ_easyq`cbx_yl within w_rp_mtrlware_warebalc
integer x = 1385
integer y = 8
end type

type dw_1 from w_publ_easyq`dw_1 within w_rp_mtrlware_warebalc
integer x = 805
integer y = 308
integer width = 2181
integer height = 940
string dataobject = "dw_rp_mtrlware_warebalc"
end type

type sle_mtrl from w_publ_easyq`sle_mtrl within w_rp_mtrlware_warebalc
end type

type sle_cust from w_publ_easyq`sle_cust within w_rp_mtrlware_warebalc
end type

type st_mtrl from w_publ_easyq`st_mtrl within w_rp_mtrlware_warebalc
end type

type st_cust from w_publ_easyq`st_cust within w_rp_mtrlware_warebalc
end type

type cbx_loginretr from w_publ_easyq`cbx_loginretr within w_rp_mtrlware_warebalc
boolean visible = true
integer x = 1385
integer y = 100
end type

type pb_em1 from w_publ_easyq`pb_em1 within w_rp_mtrlware_warebalc
integer x = 1376
end type

type pb_em2 from w_publ_easyq`pb_em2 within w_rp_mtrlware_warebalc
integer x = 2034
end type

type pb_2 from w_publ_easyq`pb_2 within w_rp_mtrlware_warebalc
integer x = 2144
end type

type cb_help from w_publ_easyq`cb_help within w_rp_mtrlware_warebalc
end type

type cb_copyself from w_publ_easyq`cb_copyself within w_rp_mtrlware_warebalc
end type

type gb_1 from w_publ_easyq`gb_1 within w_rp_mtrlware_warebalc
end type

type ln_bar from w_publ_easyq`ln_bar within w_rp_mtrlware_warebalc
end type

type ln_bar2 from w_publ_easyq`ln_bar2 within w_rp_mtrlware_warebalc
end type

type r_bar from w_publ_easyq`r_bar within w_rp_mtrlware_warebalc
end type

type ln_1 from w_publ_easyq`ln_1 within w_rp_mtrlware_warebalc
end type

type ln_2 from w_publ_easyq`ln_2 within w_rp_mtrlware_warebalc
end type

type ln_3 from w_publ_easyq`ln_3 within w_rp_mtrlware_warebalc
end type

type ln_4 from w_publ_easyq`ln_4 within w_rp_mtrlware_warebalc
end type

type ddlb_2 from uo_ddlb_storageid within w_rp_mtrlware_warebalc
boolean visible = false
integer x = 14
integer y = 208
integer width = 681
integer height = 1108
integer taborder = 40
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_storageid from uo_ddlb_storageid within w_rp_mtrlware_warebalc
integer x = 5
integer y = 200
integer width = 681
integer height = 1108
integer taborder = 30
boolean bringtotop = true
end type

event constructor;call super::constructor;cur_storageid_arr  = THIS.uo_storageid_arr
cur_storageid = THIS.uo_storageid

end event

event selectionchanged;call super::selectionchanged;cur_storageid_arr = THIS.uo_storageid_arr
cur_storageid = THIS.uo_storageid
cb_1.TriggerEvent(Clicked!)


end event

type tv_1 from uo_tv_mtrltype within w_rp_mtrlware_warebalc
integer y = 304
integer width = 805
integer height = 1312
integer taborder = 60
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_handtype = ls_handtype + '%'

cb_1.TriggerEvent(Clicked!)


end event

type ddlb_1 from dropdownlistbox within w_rp_mtrlware_warebalc
integer x = 1943
integer y = 48
integer width = 398
integer height = 356
integer taborder = 100
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;dw_1.uf_save_profile_layout()
IF THIS.Text = '明细表' THEN
	dw_1.DataObject = 'dw_rp_mtrlware_warebalc'
ELSEIF THIS.Text = '汇总表' THEN
	dw_1.DataObject = 'dw_rp_mtrlware_warebalc_hz'
//ELSEIF THIS.Text = '明细表[带计划价]' THEN
//	dw_1.DataObject = 'dw_ware_day_1'
END IF

wf_replacedw()
cb_1.TriggerEvent(Clicked!)

//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()
//f_title_change(dw_1)
//wf_hide_col()
//cb_refresh.TriggerEvent(Clicked!)

end event