Q5/ws_objects/Ew_sale.pbl.src/w_incase.srw

$PBExportHeader$w_incase.srw
forward
global type w_incase from w_publ_1ton_share_detail
end type
type st_2 from statictext within w_incase
end type
type ddlb_scid from uo_ddlb_scid within w_incase
end type
type st_3 from statictext within w_incase
end type
type ddlb_status from dropdownlistbox within w_incase
end type
end forward

global type w_incase from w_publ_1ton_share_detail
integer width = 3863
string title = "装箱单"
boolean maxbox = true
windowstate windowstate = maximized!
long dw_child_h = 12681084
long dw_child_w = 47087720
event insert_childrow ( )
event ue_find_pf ( )
event ue_fj_edit ( )
event ue_fj_view ( )
st_2 st_2
ddlb_scid ddlb_scid
st_3 st_3
ddlb_status ddlb_status
end type
global w_incase w_incase

type variables
long cur_scid =0 //分店ID
long cur_flag= -1 //-1：全部，0未审,1已审核


int cur_editfocus=0 //1:新建2:修改
uo_incase uo_incase_mtrl
end variables

forward prototypes
public function integer wf_refresh_curuc (long arg_scid, long arg_incaseid)
public function integer wf_autoaddmx (long arg_outwareid, string arg_outwarecode, long arg_scid, ref string arg_msg)
public function integer wf_find_pf (long arg_outwareid, string arg_outwarecode, long arg_mtrlid, long arg_qty)
public subroutine wf_change_color ()
public subroutine wf_check_billfj ()
public function integer wf_xls_retrievedata (long arg_ationid, ref s_xls_billlist arg_str_billlist, ref uo_sendtoexcel arg_obj_st, ref string arg_msg)
public function integer wf_flagstatus_rf ()
public function integer wf_print_retrievedata (ref s_print_pic_list arg_s_pic, ref string arg_msg)
end prototypes

event insert_childrow();long li_row
li_row=dw_child.insertrow(0)
dw_child.scrolltorow(li_row)

if li_row > 1 then
	dw_child.accepttext()	
	dw_child.object.u_incasemx_cusid[li_row] = dw_child.object.u_incasemx_cusid[1]
	dw_child.object.u_cust_cuscode[li_row] = dw_child.object.u_cust_cuscode[1]
	dw_child.object.u_cust_name[li_row] = dw_child.object.u_cust_name[1]
end if

dw_child.SetColumn ('mtrlstatus')	
end event

event ue_find_pf();IF not dw_edit_mode THEN RETURN

Int ls_i = 1,ls_j
Long ll_fathermtrlid
String ls_mtrlstatus
Int ls_rowcount
Decimal ls_qty

dw_child.AcceptText()
ls_rowcount = dw_child.RowCount()
IF ls_rowcount <= 0 THEN
	MessageBox('提示','没有计算项',information!,ok!)
	RETURN
END IF

DO WHILE  ls_i <= ls_rowcount AND dw_child.Object.u_incasemx_ifson_flag[ls_i] = 0
	
	ls_qty = dw_child.Object.u_incasemx_qty[ls_i]
	ls_mtrlstatus = dw_child.Object.mtrlstatus[ls_i]
	ll_fathermtrlid = dw_child.Object.u_incasemx_mtrlid[ls_i]
	
	IF ls_qty <= 0 THEN
		MessageBox('提示', '数量不正确,在'+ls_mtrlstatus,information!,ok!)
		RETURN
	END IF
	
	ls_i++
	IF ls_i > ls_rowcount THEN
		dw_child.Object.u_incasemx_packqty[ls_i - 1] = ls_qty
		goto ext
	END IF
	
	ls_j = 0
	
	DO WHILE  dw_child.Object.u_incasemx_ifson_flag[ls_i] = 1 AND dw_child.Object.fathermtrlid[ls_i] = ll_fathermtrlid
		
		dw_child.Object.u_incasemx_packqty[ls_i] = ls_qty
		ls_mtrlstatus = dw_child.Object.mtrlstatus[ls_i]
		
		ls_j++
		ls_i++
		IF ls_i > ls_rowcount THEN
			dw_child.Object.u_incasemx_packqty[ls_i - ls_j - 1] = ls_qty*ls_j
			goto ext
		END IF
				
	LOOP
	
	IF ls_j = 0 THEN
		dw_child.Object.u_incasemx_packqty[ls_i - 1] = ls_qty
	ELSE
		dw_child.Object.u_incasemx_packqty[ls_i - ls_j - 1] = ls_qty*ls_j
	END IF
LOOP

ls_i = ls_i - 1
IF ls_i <> ls_rowcount THEN
	MessageBox('提示', ' 循环计算出错,可能是明细内容出错',information!,ok!)
	this.TriggerEvent('retrieve_pageretr')
	RETURN
END IF
ext:
dw_child.AcceptText()

//计算包装
long ll_mtrlid,ll_father_mtrlid
string ls_prdpackcode
decimal ld_packqty
long ls_k
decimal ld_caseqty
decimal ld_Sonscale
decimal ld_fatherqty
for ls_k = 1 to dw_child.rowcount()
	ll_mtrlid = dw_child.object.u_incasemx_mtrlid[ls_k]			
	ll_father_mtrlid =  dw_child.object.fathermtrlid[ls_k]
	
	if dw_child.Object.u_incasemx_ifson_flag[ls_k] = 0 then
		ld_fatherqty=dw_child.Object.u_incasemx_qty[ls_k]
	else
		SELECT Sonscale
		into :ld_Sonscale
		FROM u_PrdPF
		where Mtrlid=:ll_father_mtrlid and Sonmtrlid=:ll_mtrlid and pfcode='包件BOM';
		if sqlca.sqlcode<>0 then
			messagebox('错误','查询操作失败：产品包装耗料量：'+sqlca.sqlerrtext,stopsign!,ok!)
			continue
		end if
		dw_child.Object.u_incasemx_qty[ls_k] = ld_Sonscale*ld_fatherqty
	end if
		
	select prdpackcode,packqty
	into :ls_prdpackcode,:ld_packqty
	from u_mtrldef
	where u_mtrldef.mtrlid=:ll_mtrlid using sqlca;
	if sqlca.sqlcode<>0 then
		messagebox('错误','查询操作失败：包装件数'+sqlca.sqlerrtext,stopsign!,ok!)
		continue
	end if
	
	if ld_packqty=0 then
		continue
	end if
	dw_child.accepttext()
//	if dw_child.object.u_incasemx_ifson_flag[ls_k] = 0 then
		ld_caseqty = dw_child.Object.u_incasemx_qty[ls_k]
//	else
//		ld_caseqty = dw_child.Object.u_incasemx_packqty[ls_k]
//	end if
   
	if mod(ld_caseqty,ld_packqty) = 0 then
		dw_child.Object.packqty_1[ls_k]= ld_caseqty/ld_packqty
	else
		dw_child.Object.packqty_1[ls_k]=Truncate(ld_caseqty/ld_packqty,0)+1
	end if
	
	dw_child.Object.u_incasemx_packunit[ls_k] = ls_prdpackcode
	dw_child.Object.u_mtrldef_packqty[ls_k] = ld_packqty
next
dw_child.AcceptText()

//循环计算成品的包装箱数
decimal ld_sumcpqty
ld_sumcpqty=0
for ls_k=ls_rowcount to 1 STEP -1
	if dw_child.Object.u_incasemx_ifson_flag[ls_k] = 0 then
		if ld_sumcpqty<>0 then
			
			dw_child.Object.packqty_1[ls_k] = ld_sumcpqty
			ld_sumcpqty=0
			
		end if
	else
		ld_sumcpqty = ld_sumcpqty+dw_child.Object.packqty_1[ls_k]
		
	end if
next

wf_change_color()
end event

event ue_fj_edit();IF dw_edit_mode THEN
	MessageBox('提示','编辑状态下不可用',information!,ok!)
	RETURN
END IF

//IF NOT f_power_ind(1098) THEN
//	MessageBox(publ_operator,'你没有使用权限！')
//	RETURN
//END IF

s_edit_index_tran s_pic
Long ll_ConnectionID
String arg_msg
Long ls_row
ls_row = dw_pageretr.GetRow()
IF ls_row <= 0 THEN
	RETURN
END IF

IF f_get_outerconnection(ll_ConnectionID,arg_msg) = 0 THEN
	MessageBox('提示','没有指定附件数据库连接'+arg_msg,information!,ok!)
	RETURN
END IF

s_pic.f_long = 130 //销售订单的mainID
s_pic.f_string = dw_pageretr.Object.u_incase_incasecode[ls_row]
s_pic.g_long = dw_pageretr.Object.u_incase_incaseid[ls_row]
s_pic.e_long = dw_pageretr.Object.u_incase_scid[ls_row]
s_pic.sqltransaction = sys_filedb_sqlca


OpenWithParm(w_fj_bill_mng,s_pic)
wf_check_billfj()
end event

event ue_fj_view();IF dw_edit_mode THEN
	MessageBox('提示','编辑状态下不可用',information!,ok!)
	RETURN
END IF

s_edit_index_tran s_pic
Long ll_ConnectionID
String arg_msg
Long ls_row
ls_row = dw_pageretr.GetRow()
IF ls_row <= 0 THEN
	RETURN
END IF

IF f_get_outerconnection(ll_ConnectionID,arg_msg) = 0 THEN
	MessageBox('提示','没有指定附件数据库连接'+arg_msg,information!,ok!)
	RETURN
END IF

s_pic.f_long = 130 //销售订单的mainID
s_pic.f_string = dw_pageretr.Object.u_incase_incasecode[ls_row]
s_pic.g_long = dw_pageretr.Object.u_incase_incaseid[ls_row]
s_pic.e_long = dw_pageretr.Object.u_incase_scid[ls_row]
s_pic.sqltransaction = sys_filedb_sqlca

OpenWithParm(w_fj_bill_view,s_pic)



end event

public function integer wf_refresh_curuc (long arg_scid, long arg_incaseid);if arg_incaseid<=0 or isnull(arg_incaseid) then return 0
long uc_row
uc_row=dw_pageretr.getrow()
if uc_row<=0 then return 0

datetime incasedate
string   incaserep   
string   dscrp   
string   incasecode
datetime opdate   
string   opemp
string modemp
datetime moddate
int      flag   
datetime Auditingdate   
string   Auditingrep  
long custid
string relcode
long relid
string assign_emp

SELECT u_incase.incasecode, 
		u_incase.cusid, 
		u_incase.incasedate, 
      u_incase.assign_emp,
		u_incase.relcode, 
		u_incase.dscrp, 
		u_incase.opemp, 
      u_incase.opdate,
		u_incase.modemp,
		u_incase.moddate, 
		u_incase.relid, 
      u_incase.auditingrep,
		u_incase.auditingdate,
		u_incase.flag
	into  :incasecode,
			:custid,   
         :incasedate,  
			:assign_emp, 
         :relcode, 
			:dscrp, 
			:opemp,
			:opdate,
			:modemp,
			:moddate,
			:relid,            
         :Auditingrep,
			:Auditingdate,			
			:flag
FROM u_incase 
   WHERE ( u_incase.incaseid = :arg_incaseid )
	and ( u_incase.scid=:arg_scid );
if sqlca.sqlcode<>0 then 
   messagebox('错误',"查询操作失败(错误单据唯一码)",stopsign!,ok!)
	return 0
end if

dw_pageretr.object.u_incase_scid[uc_row]=arg_scid
dw_pageretr.object.u_incase_incaseid[uc_row]=arg_incaseid
dw_pageretr.object.u_incase_incasedate[uc_row]=incasedate 
dw_pageretr.object.u_incase_incasecode[uc_row]=incasecode 
dw_pageretr.object.u_incase_cusid[uc_row]=  custid 
dw_pageretr.object.u_incase_assign_emp[uc_row]=assign_emp
dw_pageretr.object.u_incase_dscrp[uc_row]=  dscrp 
dw_pageretr.object.u_incase_relcode[uc_row]=  relcode 
dw_pageretr.object.u_incase_opdate[uc_row]=  opdate 
dw_pageretr.object.u_incase_opemp[uc_row]= opemp  
dw_pageretr.object.u_incase_moddate[uc_row]=  moddate 
dw_pageretr.object.u_incase_modemp[uc_row]= modemp  
dw_pageretr.object.u_incase_flag[uc_row]= flag  
dw_pageretr.object.u_incase_auditingdate[uc_row]= Auditingdate  
dw_pageretr.object.u_incase_Auditingrep[uc_row]=Auditingrep
dw_pageretr.object.u_incase_relid[uc_row]=relid

dw_pageretr.resetupdate()
dw_pageretr.setredraw(true)

dw_uc.Reset()
dw_pageretr.RowsCopy(dw_pageretr.GetRow(), dw_pageretr.GetRow(), Primary!, dw_uc, 1, Primary!)

dw_uc.ResetUpdate()
dw_uc.SetRedraw(TRUE)

wf_flagstatus_rf()
return 1
end function

public function integer wf_autoaddmx (long arg_outwareid, string arg_outwarecode, long arg_scid, ref string arg_msg);long rslt=1
long child_row,uc_row
child_row=dw_child.getrow()
uc_row=dw_pageretr.getrow()

long ll_mtrlid,ll_cusid
string ls_mtrlname,ls_mtrlmode,ls_cuscode,ls_cusname,ls_mtrlcode,ls_unit,ls_freight
decimal ls_gross_weight,ls_net_weight,ls_cubage
decimal ls_qty
DECLARE sale_incase CURSOR FOR
SELECT u_outwaremx.mtrlid, u_mtrldef.mtrlcode,u_mtrldef.mtrlname, u_mtrldef.mtrlmode, u_mtrldef.unit,u_outware.cusid, 
      u_cust.cuscode, u_cust.name, u_outwaremx.qty,u_cust.freight
FROM u_outware INNER JOIN
      u_outwaremx ON u_outware.scid = u_outwaremx.scid AND 
      u_outware.outwareid = u_outwaremx.outwareid INNER JOIN
      u_mtrldef ON u_outwaremx.mtrlid = u_mtrldef.mtrlid INNER JOIN
      u_cust ON u_outware.cusid = u_cust.cusid
where u_outware.outwareid=:arg_outwareid and u_outware.scid=:arg_scid;

open sale_incase;
fetch sale_incase into :ll_mtrlid,:ls_mtrlcode,:ls_mtrlname,:ls_mtrlmode,:ls_unit,:ll_cusid,:ls_cuscode,:ls_cusname,:ls_qty,:ls_freight;

do while sqlca.sqlcode=0 
	IF dw_child.GetRow() > 0 THEN
		IF dw_child.Object.u_incasemx_mtrlid[child_row] <> 0 THEN
			child_row = dw_child.InsertRow (0)
			ELSE
				child_row = dw_child.GetRow()
			END IF
		ELSE
			child_row = dw_child.InsertRow (0)
		END IF
		dw_child.Object.u_incasemx_relid_outware[child_row] = arg_outwareid
		dw_child.Object.u_incasemx_relcode_outware[child_row] = arg_outwarecode
		dw_child.Object.u_incasemx_mtrlid[child_row] = ll_mtrlid
		dw_child.Object.mtrlstatus [child_row]    = ls_mtrlname+ls_mtrlmode
		dw_child.Object.fathermtrlid[child_row] = ll_mtrlid			
		dw_child.Object.u_incasemx_cusid[child_row] = ll_cusid
		dw_child.Object.u_cust_cuscode[child_row] = ls_cuscode
		dw_child.Object.u_cust_name[child_row] = ls_cusname
		
		dw_uc.Object.prdship[uc_row] = ls_freight
		
		dw_child.Object.u_incasemx_qty[child_row] = ls_qty
		dw_child.Object.u_mtrldef_mtrlcode[child_row] = ls_mtrlcode
		dw_child.Object.u_mtrldef_mtrlname[child_row] = ls_mtrlname
		dw_child.Object.u_mtrldef_mtrlmode[child_row] = ls_mtrlmode
		dw_child.Object.u_mtrldef_unit[child_row] = ls_unit
		SELECT u_mtrldef.gross_weight,
			u_mtrldef.net_weight,
			u_mtrldef.cubage
			INTO	:ls_gross_weight,:ls_net_weight,:ls_cubage
			FROM 	u_mtrldef
			Where	( u_mtrldef.mtrlid = :ll_mtrlid);
				
		IF sqlca.SQLCode <> 0 THEN
			MessageBox('错误','错误的产品，在'+ls_mtrlcode,stopsign!,ok!)
			rslt=0
			goto ext
		END IF
			
		IF wf_find_pf(arg_outwareid,arg_outwarecode,ll_mtrlid,0) = 0 THEN
			dw_child.Object.u_incasemx_grossweight[child_row] = ls_gross_weight
			dw_child.Object.u_incasemx_netweight[child_row] = ls_net_weight
			dw_child.Object.u_incasemx_cubage[child_row] = ls_cubage
		END IF

	fetch sale_incase into :ll_mtrlid,:ls_mtrlcode,:ls_mtrlname,:ls_mtrlmode,:ls_unit,:ll_cusid,:ls_cuscode,:ls_cusname,:ls_qty,:ls_freight;

loop
close sale_incase;

ext:

return rslt
end function

public function integer wf_find_pf (long arg_outwareid, string arg_outwarecode, long arg_mtrlid, long arg_qty);Long ll_sonmtrlid
Int ls_i = 0,li_rownum,row_count
String ls_mtrlname,ls_nowcode,ls_mtrlmode,ls_zxmtrlmode
Decimal ld_gross_weight,ld_net_weight,ld_cubage,LD_Sonscale
string ls_mtrlcode,ls_unit

DECLARE find_sonmtrlid CURSOR FOR
	SELECT DISTINCT (u_PrdPF.SonMtrlid),
	u_mtrldef.mtrlname,
	u_mtrldef.gross_weight,
	u_mtrldef.net_weight,
	u_mtrldef.cubage,
	u_mtrldef.mtrlmode,
	u_mtrldef.zxmtrlmode,
	u_mtrldef.mtrlcode,
	u_mtrldef.unit,
	u_PrdPF.Sonscale
	FROM u_PrdPF INNER JOIN
	u_mtrldef ON u_PrdPF.SonMtrlid = u_mtrldef.mtrlid
	WHERE u_PrdPF.mtrlid = :arg_mtrlid 
	Order By u_PrdPF.SonMtrlid;
	
OPEN find_sonmtrlid;
FETCH find_sonmtrlid INTO :ll_sonmtrlid,:ls_mtrlname,:ld_gross_weight,:ld_net_weight,:ld_cubage,:ls_mtrlmode,:ls_zxmtrlmode,:ls_mtrlcode,:ls_unit,:LD_Sonscale;

DO WHILE sqlca.SQLCode = 0
	ls_i++
	li_rownum = dw_child.InsertRow(0)
	dw_child.Object.u_incasemx_mtrlid[li_rownum] = ll_sonmtrlid
	dw_child.Object.mtrlstatus[li_rownum] = ls_mtrlname
	//增加编号
	dw_child.Object.u_incasemx_relcode_outware[li_rownum] = arg_outwarecode
	dw_child.Object.u_incasemx_relid_outware[li_rownum] = arg_outwareid
	dw_child.Object.u_incasemx_pfcode[li_rownum] = String(ls_i)
	dw_child.Object.u_incasemx_grossweight[li_rownum] = ld_gross_weight
	dw_child.Object.u_incasemx_netweight[li_rownum] = ld_net_weight
	dw_child.Object.u_incasemx_cubage[li_rownum] = ld_cubage
	dw_child.Object.u_incasemx_packqty[li_rownum] = arg_qty
	dw_child.Object.u_incasemx_ifson_flag[li_rownum] = 1
	dw_child.Object.fathermtrlid[li_rownum] = arg_mtrlid
	dw_child.Object.u_incasemx_packsize[li_rownum] = ls_zxmtrlmode
	dw_child.Object.u_mtrldef_mtrlcode[li_rownum] = ls_mtrlcode
	dw_child.Object.u_mtrldef_unit[li_rownum] = ls_unit
	dw_child.Object.u_mtrldef_mtrlmode[li_rownum] = ls_mtrlmode
	dw_child.Object.u_mtrldef_mtrlname[li_rownum] = ls_mtrlname
	dw_child.Object.u_incasemx_sonscale[li_rownum] = LD_Sonscale
	dw_child.accepttext()
	if li_rownum<=1 then
		dw_child.object.u_incasemx_cusid[li_rownum] = dw_child.object.u_incasemx_cusid[1]
		dw_child.object.u_cust_cuscode[li_rownum] = dw_child.object.u_cust_cuscode[1]
		dw_child.object.u_cust_name[li_rownum] = dw_child.object.u_cust_name[1]
	else
		dw_child.object.u_incasemx_cusid[li_rownum] = dw_child.object.u_incasemx_cusid[li_rownum - 1]
		dw_child.object.u_cust_cuscode[li_rownum] = dw_child.object.u_cust_cuscode[li_rownum - 1]
		dw_child.object.u_cust_name[li_rownum] = dw_child.object.u_cust_name[li_rownum - 1]
	end if
	FETCH find_sonmtrlid INTO :ll_sonmtrlid,:ls_mtrlname,:ld_gross_weight,:ld_net_weight,:ld_cubage,:ls_mtrlmode,:ls_zxmtrlmode,:ls_mtrlcode,:ls_unit,:LD_Sonscale;
LOOP

CLOSE find_sonmtrlid;

dw_child.AcceptText()
row_count = ls_i

DO WHILE ls_i > 0
	ls_nowcode = dw_child.Object.u_incasemx_pfcode[li_rownum]
	ls_nowcode = ls_nowcode+'/'+String(row_count)
	dw_child.Object.u_incasemx_pfcode[li_rownum] = ls_nowcode
	ls_i = ls_i - 1
	li_rownum = li_rownum - 1
LOOP

RETURN row_count

end function

public subroutine wf_change_color ();long ls_rowcount
ls_rowcount = dw_child.rowcount( )

if ls_rowcount <=0 then return

long ls_i 
for ls_i=2 to ls_rowcount
	if dw_child.object.u_incasemx_ifson_flag[ls_i] = 1 and dw_child.object.u_incasemx_ifson_flag[ls_i - 1] = 0 then
		dw_child.object.ifover[ls_i - 1] = 1
	end if
next

dw_child.accepttext( )

dw_child.Modify( "u_cust_cuscode.Color='0~tIf(ifover=1,255,0)'")
dw_child.Modify( "u_incasemx_pfcode.Color='0~tIf(ifover=1,255,0)'")
dw_child.Modify( "u_incasemx_relcode_outware.Color='0~tIf(ifover=1,255,0)'")
dw_child.Modify( "u_cust_name.Color='0~tIf(ifover=1,255,0)'")
dw_child.Modify( "u_mtrldef_mtrlcode.Color='0~tIf(ifover=1,255,0)'")
dw_child.Modify( "u_mtrldef_mtrlname.Color='0~tIf(ifover=1,255,0)'")
dw_child.Modify( "u_mtrldef_mtrlmode.Color='0~tIf(ifover=1,255,0)'")
dw_child.Modify( "u_mtrldef_unit.Color='0~tIf(ifover=1,255,0)'")
dw_child.Modify( "u_mtrldef_packqty.Color='0~tIf(ifover=1,255,0)'")
dw_child.Modify( "mtrlstatus.Color='0~tIf(ifover=1,255,0)'")
//dw_child.Modify( "u_cust_cuscode.Color='0~tIf(ifover=1,255,0)'")
//dw_child.Modify( "u_cust_cuscode.Color='0~tIf(ifover=1,255,0)'")

end subroutine

public subroutine wf_check_billfj ();String arg_msg
Long ll_ConnectionID
Long cur_billtype
long ll_relid,ll_relid_mx,ll_scid
Long ls_filecount = 0
Int rslt = 1

uo_fj_mng_billtype ls_uo_fjbt
ls_uo_fjbt = CREATE uo_fj_mng_billtype
 
Long row,uc_relid
row = dw_pageretr.GetRow()
IF row > 0 THEN
	ll_relid = dw_pageretr.Object.u_incase_incaseid[row]
	ll_scid = dw_pageretr.Object.u_incase_scid[row]
	ll_relid_mx = 0
ELSE
	rslt = 0
	GOTO ext
END IF

IF f_get_outerconnection(ll_ConnectionID,arg_msg) = 0 THEN
	rslt = 0
	GOTO ext
END IF

cur_billtype = 130 //客户投拆单的 mainiD

ls_uo_fjbt.uf_check_billfj( cur_billtype, ll_relid,ll_relid_mx,ll_scid, sys_fileDB_sqlca, arg_msg, ls_filecount)

IF ls_filecount > 0 THEN
	rslt = 1
	GOTO ext
ELSE
	rslt = 0
	GOTO ext
END IF

ext:

wf_encl(rslt)

DESTROY ls_uo_fjbt
end subroutine

public function integer wf_xls_retrievedata (long arg_ationid, ref s_xls_billlist arg_str_billlist, ref uo_sendtoexcel arg_obj_st, ref string arg_msg);//==============================================================================
// 函数: w_publ_1ton_share_detail::wf_xls_retrievedata()
//------------------------------------------------------------------------------
// 描述:  此函数需要 重载,复制祖先范例代码,然后修改retrieve参数部分两处即可
//------------------------------------------------------------------------------

Long LS_ROW,ll_id,i,ll_scid
LS_ROW = dw_pageretr.GetRow()
IF LS_ROW <= 0 THEN
	arg_msg = '没有目标单据!'
	RETURN 0
END IF

//修改点:获取 指定retriev参数
ll_id = dw_pageretr.Object.#1[LS_ROW]
ll_scid = dw_pageretr.Object.u_incase_scid[LS_ROW]

//查询所选模版是否含有图片信息
Long ll_ifpic
Long ll_classid
SELECT ifpic
	INTO :ll_ifpic
	FROM U_XLS_Templates
	Where id = :ll_xls_Templatesid;
IF sqlca.SQLCode <> 0 THEN
	ll_ifpic = 0
END IF

Long ll_i,ll_j
Long ll_mtrlid
Long ll_fileid

Blob ls_filedata
SetNull(ls_filedata)
String Pathname,ls_filename,ls_filetype
String errmsg
uo_fj_mng_billtype  ls_uo_fjbt
ls_uo_fjbt = CREATE uo_fj_mng_billtype

s_xls_pic_list s_pic //结构数组-用于保存图片路径

IF ll_ifpic = 1 THEN //如果含有图片信息,则查询本类型单据需要带出哪类附件

	SELECT classid
		INTO :ll_classid
		FROM u_billpic_fileclass
		Where (billtype = 130);
	IF sqlca.SQLCode <> 0 THEN
		ll_classid = 0
	END IF
	
	IF ll_classid > 0 THEN //如果已经指定好附件类型,则循环明细表查询每个明细的图片信息.
		FOR ll_i = 1 TO dw_child.RowCount()
			ll_mtrlid = dw_child.Object.u_incasemx_mtrlid[ll_i]
			//取该附件类型中的第一个附件.
			SELECT top 1 fileid,DisplayName,FileType INTO :ll_fileid,:ls_filename,:ls_filetype
				FROM u_file
				WHERE relid = :ll_mtrlid
				AND classid = :ll_classid
				AND (filetype = 'bmp' OR filetype = 'rle' OR filetype = 'wmf'
				OR filetype = 'tif' OR filetype = 'jpg' OR filetype = 'gif' OR filetype = 'jpeg')
				USING sys_fileDB_sqlca;
			IF sys_fileDB_sqlca.SQLCode <> 0 THEN
				ll_fileid = 0
			END IF
			IF ll_fileid > 0 THEN
				Pathname = sys_cur_path+ins_fjtemppath+'\'+String(Today(),'yymmdd')+String(Now(),'hhmmss')+'_'+ls_filename+'.'+ls_filetype
				IF Trim(Pathname) <> '' THEN
					IF ls_uo_fjbt.uf_getfjbolb_fromdb( ll_fileid, ls_filedata, sys_fileDB_sqlca, arg_msg) = 0 THEN
						RETURN  0
					END IF
					
					IF f_saveblobtofile(ls_filedata,Pathname,errmsg) = 0 THEN
						RETURN 0
					ELSE
						
						s_pic.path[ll_i] = Pathname
						//记录临时文件位置,本窗口退出后删除
						wf_addlog_tempfilepathname(Pathname)
						
					END IF
				ELSE
					s_pic.path[ll_i] = ''
				END IF
			ELSE
				s_pic.path[ll_i] = ''
			END IF
		NEXT
	END IF
	//
END IF

////可选设置///
arg_obj_st.uo_const.create_new_pwd( )  //创建随机密码 
if sys_option_xls_ifuse_passwd = 1 then arg_obj_st.uo_const.pwd = trim(sys_option_xls_user_passwd)   //默认加密密码    默认为随即密码


boolean xls_locked
xls_locked = not (sys_option_xls_lock = 1)

/// Excel 的可选设置
if arg_obj_st.of_setoption(arg_ationid,  xls_locked,true,arg_msg) <> 1 then
		return 0
end if


for i = 1 to arg_str_billlist.count
	////可选操作///
	arg_str_billlist.bill[i].ds_data = create datastore                                  //
	arg_str_billlist.bill[i].ds_data.dataobject = arg_str_billlist.bill[i].datawindow       //
	arg_str_billlist.bill[i].ds_data.settransobject(sqlca)
	
	//修改点:注意retrieve 参数与上文对应
	arg_str_billlist.bill[i].ds_data.retrieve(ll_scid,ll_id)

next 

return 1
end function

public function integer wf_flagstatus_rf ();//====================================================================
// Function: wf_flagstatus_rf()
//--------------------------------------------------------------------
// Description: 
//--------------------------------------------------------------------
// Arguments:(None)
//--------------------------------------------------------------------
// Returns:  integer
//--------------------------------------------------------------------
// Author:	yyx		Date: 2003.12.26
//--------------------------------------------------------------------
// Modify History: 
//	
//====================================================================


long pagerert_row

pagerert_row=dw_pageretr.getrow()
if pagerert_row<=0 then	
	cb_auditing.enabled=false
	goto ext
end if

if dw_edit_mode then
	cb_auditing.enabled=false
	cb_auditing_cancel.enabled=false
else
	if dw_pageretr.object.u_incase_flag[pagerert_row]=0 then
		cb_auditing.enabled=true
		cb_auditing_cancel.enabled=false
	elseif dw_pageretr.object.u_incase_flag[pagerert_row]=1 then
		cb_auditing.enabled=false
		cb_auditing_cancel.enabled=true
	end if
end if

ext:
return 0
end function

public function integer wf_print_retrievedata (ref s_print_pic_list arg_s_pic, ref string arg_msg);Long LS_ROW,ll_id,i,ll_scid
LS_ROW = dw_pageretr.GetRow()
IF LS_ROW <= 0 THEN
	arg_msg = '没有目标单据!'
	RETURN 0
END IF

//修改点:获取 指定retriev参数
ll_id = dw_pageretr.Object.#1[LS_ROW]
ll_scid = dw_pageretr.Object.u_incase_scid[LS_ROW]


Long ll_i,ll_j
Long ll_mtrlid
Long ll_fileid

Blob ls_filedata
SetNull(ls_filedata)
String Pathname,ls_filename,ls_filetype
String errmsg
uo_fj_mng_billtype  ls_uo_fjbt
ls_uo_fjbt = CREATE uo_fj_mng_billtype

Long ll_classid
SELECT classid
	INTO :ll_classid
	FROM u_billpic_fileclass
	Where (billtype = 102);
IF sqlca.SQLCode <> 0 THEN
	ll_classid = 0
END IF

IF ll_classid > 0 THEN //如果已经指定好附件类型,则循环明细表查询每个明细的图片信息.
	FOR ll_i = 1 TO dw_child.RowCount()
		ll_mtrlid = dw_child.Object.u_incasemx_mtrlid[ll_i]
		arg_s_pic.mtrlid[ll_i] = ll_mtrlid
		//取该附件类型中的第一个附件.
		SELECT top 1 fileid,DisplayName,FileType INTO :ll_fileid,:ls_filename,:ls_filetype
			FROM u_file
			WHERE relid = :ll_mtrlid
			AND classid = :ll_classid
			AND (filetype = 'bmp' OR filetype = 'rle' OR filetype = 'wmf'
			OR filetype = 'tif' OR filetype = 'jpg' OR filetype = 'gif' OR filetype = 'jpeg')
			USING sys_fileDB_sqlca;
		IF sys_fileDB_sqlca.SQLCode <> 0 THEN
			ll_fileid = 0
		END IF
		IF ll_fileid > 0 THEN
			Pathname = sys_cur_path+ins_fjtemppath+'\'+String(Today(),'yymmdd')+String(Now(),'hhmmss')+'_'+ls_filename+'.'+ls_filetype
			IF Trim(Pathname) <> '' THEN
				IF ls_uo_fjbt.uf_getfjbolb_fromdb( ll_fileid, ls_filedata, sys_fileDB_sqlca, arg_msg) = 0 THEN
					RETURN  0
				END IF
				
				IF f_saveblobtofile(ls_filedata,Pathname,errmsg) = 0 THEN
					RETURN 0
				ELSE
					
					arg_s_pic.path[ll_i] = Pathname
					//记录临时文件位置,本窗口退出后删除
					wf_addlog_tempfilepathname(Pathname) 
				END IF
			ELSE
				arg_s_pic.path[ll_i] = ''
			END IF
		ELSE
			arg_s_pic.path[ll_i] = ''
		END IF
	NEXT
END IF
RETURN 1 
end function

on w_incase.create
int iCurrent
call super::create
this.st_2=create st_2
this.ddlb_scid=create ddlb_scid
this.st_3=create st_3
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_3
this.Control[iCurrent+4]=this.ddlb_status
end on

on w_incase.destroy
call super::destroy
destroy(this.st_2)
destroy(this.ddlb_scid)
destroy(this.st_3)
destroy(this.ddlb_status)
end on

event open;THIS.TriggerEvent('ue_before_open')
wf_movetocenter()
ds_copy_bill = CREATE datastore
ds_copy_bill.DataObject = dw_child.dataobject
ds_copy_bill.SetTransObject(sqlca)
OLD_TITLE = THIS.Title

s_tran = Message.PowerObjectParm
IF NOT IsNull(s_tran) THEN
	retrieve_all = s_tran.if_retrieve_all
	mode = s_tran.work_mode
	arg_pkid = s_tran.arg_pkid
	arg_string_code = s_tran.arg_string_code
	if_sharedata = s_tran.if_sharedata //是否应用sharedata，当retrieve_all＝true是生效
	ds_share = s_tran.ds_share
END IF

dw_pageretr.RBUTTON_FILTER_USE = TRUE //右键查询功能开关
dw_pageretr.titleclick_sort_use = TRUE  //单击标题排序功能开关

dw_pageretr.SetTransObject (sqlca)
pkcolumndbtname = wf_get_pkcolumndbtname(dw_pageretr) //取第一列为关键字

ori_oldselect = dw_pageretr.Describe("DataWindow.Table.Select")

ls_newselect = ori_oldselect
ds_curquery = CREATE DATASTORE
ds_curquery.DataObject = 'd_extr_find'
ds_curquery.SetTransObject (sqlca)

wf_editindex_lockf()

sle_usual_query.Text = Trim(arg_string_code)
IF NOT retrieve_all THEN
	THIS.TriggerEvent("ue_usual_query_RETR") //修改ls_newselect,retrieve
ELSE
	IF  if_sharedata THEN
		ds_share.ShareData(dw_pageretr)
	ELSE
		wf_retrieveuc(dw_pageretr,ls_newselect,1)
		THIS.TriggerEvent('RETRIEVE_pageretr')
	END IF
END IF

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


uc_column_int = 6 //uc dw前7列可以编辑
child_column_int = 13 //子dw前8列可以编辑
uo_incase_mtrl = CREATE uo_incase
uo_incase_mtrl.commit_transaction = sqlca

s_hide_col s_col_mtrlsectype
s_col_mtrlsectype.col_1 = 'u_mtrldef_mtrlsectype'
f_hide_col(1308,dw_child,s_col_mtrlsectype) 

s_hide_col s_col_zxmtrlmode
s_col_zxmtrlmode.col_1 = 'u_mtrldef_zxmtrlmode'
f_hide_col(1309,dw_child,s_col_zxmtrlmode) 

end event

event close;call super::close;destroy uo_incase_mtrl
wf_del_tempfilepathname()
end event

event retrieve_childdw;long row,uc_relid
row=dw_pageretr.getrow()

if row>0 then	
	uc_relid=dw_pageretr.object.u_incase_incaseid[row]
	dw_child.SetRedraw (false)
	dw_child.retrieve(cur_scid,uc_relid)
	dw_child.SetRedraw (true)
else
	dw_child.reset()
end if

end event

event retrieve_pageretr;boolean cb_firstpage_enabled,cb_nextpage_enabled,cb_retrieveall_enabled
boolean cb_priorpage_enabled,cb_func_enabled,cb_retrieve_enabled

cb_nextpage_enabled=cb_nextpage.enabled
cb_retrieveall_enabled=cb_retrieveall.enabled
cb_func_enabled=cb_func.enabled

cb_nextpage.enabled=false
cb_retrieveall.enabled=false
cb_func.enabled=false

dw_uc.Retrieve() //dw_uc的dw改左select top 0 并肯不带参数
dw_pageretr.Retrieve(cur_scid,cur_flag)
IF dw_pageretr.RowCount() > 0 THEN 
	dw_pageretr.SetRow(1)
	dw_pageretr.triggerevent(rowfocuschanged!)
end if
this.triggerevent('retrieve_childdw')

cb_nextpage.enabled=cb_nextpage_enabled
cb_retrieveall.enabled=cb_retrieveall_enabled
cb_func.enabled=cb_func_enabled


end event

event ue_usual_query_filt;string obj_expr=''  
if trim(sle_usual_query.text)<>'' then 
	IF POS(trim(sle_usual_query.text),'%')=0 THEN
		obj_expr=obj_expr+'( incasecode LIKE "%'+trim(sle_usual_query.text)+'%" )'
	ELSE
		obj_expr=obj_expr+'( incasecode LIKE "'+trim(sle_usual_query.text)+'" )'
	END IF 
end if

dw_pageretr.setfilter(obj_expr)

dw_pageretr.SetRedraw(False)
dw_pageretr.filter()
if dw_pageretr.rowcount()>=1 then
	dw_pageretr.selectrow(0,false)
	dw_pageretr.selectrow(1,true)
end if
dw_pageretr.SetRedraw(TRUE)
end event

event ue_usual_query_retr;string ls_querystrpart=''
ls_newselect=lower(ori_oldselect)
if trim(sle_usual_query.text)<>'' then
	if pos(trim(sle_usual_query.text),'%')=0 then
		ls_querystrpart="( incasecode like '%"+trim(sle_usual_query.text)+"%')"
	else
		ls_querystrpart="( incasecode like '"+trim(sle_usual_query.text)+"')"
	end if

	if Pos(ls_newselect," where ") <> 0 then
	   ls_newselect=ls_newselect+" AND ("+ls_querystrpart+')'
	else
		ls_newselect=ls_newselect+" where ("+ls_querystrpart+')'
	end if
end if
wf_retrieveuc(dw_pageretr,ls_newselect,1)  
this.triggerevent('retrieve_pageretr')

end event

event ue_f9;call super::ue_f9;//
//if not dw_edit_mode then return
//long child_row
//child_row=dw_uc.getrow()
//if child_row=0 then
//	messagebox('系统提示','请选定装箱单!')
//	return 
//end if
//dw_uc.accepttext() 
//if not isvalid(W_cust_edit) then 
//	s_edit_index_tran s_ch_tran  //传递参数使用
//	s_ch_tran.if_retrieve_all=false  //是否一次RETRIEVE所有行
//	s_ch_tran.work_mode=1            //0-单纯编辑模式 1-选择\编辑模式
//	s_ch_tran.arg_pkid=0             //目标定位PKID (备用)
//	//查询列(物料编码)部分内容,用于初步筛选
//	s_ch_tran.arg_string_code=upper(trim(dw_uc.object.u_cust_cuscode[dw_uc.getrow()]))
//
//	OPENwithparm(W_cust_edit,s_ch_tran)  //调用
//
//	s_custom S_INSCUST
//	S_INSCUST=Message.PowerObjectParm  //接受返回结构
//
//	IF S_INSCUST.cusid>0 THEN //正常返回值则可以取以下值
//		dw_uc.object.u_incase_cusid[child_row]=S_INSCUST.cusid
//		dw_uc.object.u_cust_name[child_row]=S_INSCUST.name
//		dw_uc.object.u_cust_cuscode[child_row]=S_INSCUST.cuscode
//		dw_uc.object.u_incase_assign_emp[child_row]=S_INSCUST.bsntype
//		dw_uc.setredraw(true)
//		dw_uc.setcolumn("u_incase_incasedate")
//	END IF
//end if
end event

event ue_f8;call super::ue_f8;//用于选择明细内容,被f8[默认]\dw_child.doubleclicked调用
IF NOT dw_edit_mode THEN RETURN
Long child_row
Long ls_cusid
String ls_sonmtrlname
child_row = dw_child.GetRow()
Dec ls_gross_weight,ls_net_weight,ls_cubage
ls_cusid = dw_uc.Object.u_incase_cusid[dw_uc.GetRow()]
IF IsNull(ls_cusid) OR ls_cusid = 0 THEN
	THIS.TriggerEvent("ue_f9")
END IF


IF NOT IsValid(w_mtrldef_edit) THEN
	s_edit_index_tran s_tranf8 //传递参数使用
	s_tranf8.if_retrieve_all = FALSE  //是否一次retrieve所有行
	s_tranf8.work_mode = 1            //0-单纯编辑模式 1-选择\编辑模式
	s_tranf8.arg_pkid = 0             //目标定位pkid (备用)
	s_tranf8.arg_string_code = ''     //查询列(物料编码)部分内容,用于初步筛选 
	s_tranf8.if_select_all = TRUE     //多选
	s_tranf8.b_long = 0               //选产品
	
	Long ls_j
	IF dw_child.GetRow() > 0 THEN s_tranf8.arg_string_code = Trim(dw_child.Object.mtrlstatus[dw_child.GetRow()])
	OpenWithParm(w_mtrldef_edit,s_tranf8) //调用
	
	s_mtrldef_array s_inscust
	s_inscust = Message.PowerObjectParm //接受返回结构
	FOR ls_j = 1 TO  UpperBound(s_inscust.mtrlid)
		IF s_inscust.mtrlid[ls_j] > 0 THEN //正常返回值则可以取以下值
			IF dw_child.GetRow() > 0 THEN
				IF dw_child.Object.u_incasemx_mtrlid[child_row] <> 0 THEN
					child_row = dw_child.InsertRow (0)
				ELSE
					child_row = dw_child.GetRow()
				END IF
			ELSE
				child_row = dw_child.InsertRow (0)
			END IF
			
			dw_child.Object.u_incasemx_mtrlid[child_row] = s_inscust.mtrlid[ls_j]
			dw_child.Object.mtrlstatus [child_row]    = s_inscust.mtrlname[ls_j]+s_inscust.mtrlmode[ls_j]
			dw_child.Object.fathermtrlid[child_row] = s_inscust.mtrlid[ls_j]
			SELECT u_mtrldef.gross_weight,
				u_mtrldef.net_weight,
				u_mtrldef.cubage
				INTO	:ls_gross_weight,:ls_net_weight,:ls_cubage
				FROM 	u_mtrldef
				Where	( u_mtrldef.mtrlid = :s_inscust.mtrlid[ls_j]);
				
			IF sqlca.SQLCode <> 0 THEN
				MessageBox('错误','错误的产品，在'+s_inscust.mtrlcode[ls_j],stopsign!,ok!)
				RETURN
			END IF
			
			IF wf_find_pf(0,'',s_inscust.mtrlid[ls_j],0) = 0 THEN
				dw_child.Object.u_incasemx_grossweight[child_row] = ls_gross_weight
				dw_child.Object.u_incasemx_netweight[child_row] = ls_net_weight
				dw_child.Object.u_incasemx_cubage[child_row] = ls_cubage
			END IF
			
			dw_child.SetColumn ('mtrlstatus')
		END IF
		
	NEXT
	dw_child.SetFocus()
END IF





end event

event ue_viewprint;call super::ue_viewprint;
//if not (f_power_ind(ls_powerid))  then
//	messagebox('提示','你没有使用权限！',information!,ok!)
//	return
//end if
	
lONG LS_ROW
LS_ROW=dw_pageretr.getrow()
IF LS_ROW<=0 THEN 
	MESSAGEBOX('提示','没有打印目标单据!',information!,ok!)
	RETURN
END IF

S_print_MSG LS_PRMSG
if ls_newname<>'' then
	IF li_auditprint = 1 THEN
		IF dw_pageretr.Object.u_incase_flag[dw_pageretr.GetRow()] = 0 THEN
			MessageBox('提示','目标单据还未审核,不能打印!',information!,ok!)
			RETURN
		END IF
	END IF
	LS_PRMSG.obj_dwNAME = ls_newname
else
	LS_PRMSG.obj_dwNAME = 'dw_rp_incase_printview'
end if


LS_PRMSG.TAG_TEXT='出口装箱明细单'
LS_PRMSG.FILTER_STRING = ''
LS_PRMSG.retr_pram_falg=15
LS_PRMSG.PAGECH_FLAG=0
LS_PRMSG.retr_scid=dw_pageretr.object.u_incase_scid[LS_ROW]
LS_PRMSG.retr_pramnmb=dw_pageretr.object.u_incase_incaseid[LS_ROW]


IF ifpic = 1 THEN
	String ls_msg
	IF wf_print_retrievedata(LS_PRMSG.s_pic,ls_msg) = 0 THEN
		MessageBox('提示','下载图片失败!',information!,OK!)
		RETURN
	END IF 
END IF

Openwithparm(w_publ_preview,LS_PRMSG)

IF ifpic = 1 THEN
	Long li
	FOR li = 1 TO  UpperBound(LS_PRMSG.s_pic.path)
		IF Len(Trim(LS_PRMSG.s_pic.path[li])) > 0  THEN
			FileDelete(LS_PRMSG.s_pic.path[li])
		END IF
	NEXT
END IF

//**更新打印次料
string arg_msg
printnum = message.doubleparm
f_update_printnum('u_incase',printnum,dw_pageretr.object.u_incase_scid[LS_ROW],dw_pageretr.object.u_incase_incaseid[LS_ROW],'','',arg_msg,true)
end event

event resize;call super::resize;//long w_width,w_height
//w_width = 3611
//w_height = 2332
//
//
//if newwidth < w_width then this.width = w_width
//if newheight < w_height then  this.height = w_height
//
//
//dw_child.width=this.width - (w_width - 3575)
//dw_child.height=this.height - (w_height - 912)
//
//
//cb_add.y=this.height - (w_height - 2128)
//cb_edit.y=this.height - (w_height - 2128)
//cb_delet.y=this.height - (w_height - 2128)
//cb_addzy.y=this.height - (w_height - 2128)
//cb_add_xm.y=this.height - (w_height - 2128)
//cb_dele_xm.y=this.height - (w_height - 2128)
//cb_exit.y=this.height - (w_height - 2128)
//cb_auditing.y=this.height - (w_height - 2128)
//cb_1.y=this.height - (w_height - 2128)
//cb_2.y=this.height - (w_height - 2128)
end event

event ue_print;call super::ue_print;//--直接打印
//IF Not (f_power_ind(ls_powerid))  THEN
//	MessageBox('提示','你没有使用权限！',information!,ok!)
//	RETURN
//END IF

uo_print_preview uo_print
IF MessageBox ("询问","是否确定要打印当前单据吗?",Question!,YesNo! ) = 2 THEN RETURN
S_print_MSG LS_PRMSG

IF dw_uc.RowCount() = 0 THEN
	MessageBox('提示','没有可打印的单据！',information!,ok!)
	RETURN
END IF
LS_PRMSG.retr_pram_falg = 15

IF ls_newname <> '' THEN
	
	IF li_auditprint = 1 THEN
		IF dw_pageretr.Object.u_incase_flag[dw_pageretr.GetRow()] = 0 THEN
			MessageBox('提示','目标单据还未审核,不能打印!',information!,ok!)
			RETURN
		END IF
	END IF
	
	LS_PRMSG.obj_dwNAME = ls_newname
ELSE
	LS_PRMSG.obj_dwNAME = 'dw_rp_incase_printview'
END IF

LS_PRMSG.TAG_TEXT = '装箱单'

LS_PRMSG.FILTER_STRING = ''

LS_PRMSG.PAGECH_FLAG = 0
LS_PRMSG.retr_scid = dw_pageretr.Object.u_incase_scid[dw_pageretr.GetRow()]
LS_PRMSG.retr_pramnmb = dw_pageretr.Object.u_incase_incaseid[dw_pageretr.GetRow()]

IF ifpic = 1 THEN
	String ls_msg
	IF wf_print_retrievedata(LS_PRMSG.s_pic,ls_msg) = 0 THEN
		MessageBox('提示','下载图片失败!',information!,OK!)
		RETURN
	END IF 
END IF


uo_print.FACT_PRINT_MSG = LS_PRMSG

String arg_msg
IF uo_print.uof_print_begin(arg_msg) = 0 THEN
	MessageBox("错误",arg_msg,stopsign!,ok!)
	RETURN
END IF
uo_print.ds_print()
IF ifpic = 1 THEN
	Long li
	FOR li = 1 TO  UpperBound(LS_PRMSG.s_pic.path)
		IF Len(Trim(LS_PRMSG.s_pic.path[li])) > 0  THEN
			FileDelete(LS_PRMSG.s_pic.path[li])
		END IF
	NEXT
END IF
//**更新打印次料
printnum = Message.DoubleParm
f_update_printnum('u_incase',1,dw_pageretr.Object.u_incase_scid[dw_pageretr.GetRow()],dw_pageretr.Object.u_incase_incaseid[dw_pageretr.GetRow()],'','',arg_msg,TRUE)

end event

event ue_f11;call super::ue_f11;
if not dw_edit_mode then return
long child_row
child_row=dw_child.getrow()
if child_row=0 then
	messagebox('提示','请选定装箱单!',information!,ok!)
	return 
end if
dw_child.accepttext() 
if not isvalid(W_cust_edit) then 
	s_edit_index_tran s_ch_tran  //传递参数使用
	s_ch_tran.if_retrieve_all=false  //是否一次RETRIEVE所有行
	s_ch_tran.work_mode=1            //0-单纯编辑模式 1-选择\编辑模式
	s_ch_tran.arg_pkid=0             //目标定位PKID (备用)
	//查询列(物料编码)部分内容,用于初步筛选
	s_ch_tran.arg_string_code=upper(trim(dw_child.object.u_cust_cuscode[child_row]))

	OPENwithparm(W_cust_edit,s_ch_tran)  //调用

	s_custom S_INSCUST
	S_INSCUST=Message.PowerObjectParm  //接受返回结构

	IF S_INSCUST.cusid>0 THEN //正常返回值则可以取以下值
		dw_child.object.u_incasemx_cusid[child_row]=S_INSCUST.cusid
		dw_child.object.u_cust_name[child_row]=S_INSCUST.name
		dw_child.object.u_cust_cuscode[child_row]=S_INSCUST.cuscode		
		dw_child.setredraw(true)
		dw_child.setcolumn("mtrlstatus")
	END IF
		dw_child.SetFocus()
end if
end event

event ue_f7;Long child_row
Long ls_j
Dec ls_gross_weight,ls_net_weight,ls_cubage
child_row = dw_child.GetRow()
string arg_msg=''
IF NOT IsValid(w_outware_incase_ch) THEN
	s_edit_index_tran s_tranf7 
	s_tranf7.if_retrieve_all = FALSE  
	s_tranf7.work_mode = 1            
	s_tranf7.arg_pkid = 0     
 	s_tranf7.if_select_all = true     //多选
//	s_tranf7.arg_string_code = dw_child.object.u_mtrldef_mtrlcode [child_row]
	
	OpenWithParm(w_outware_incase_ch,s_tranf7) //调用
	s_outware_incase_array  S_INSCUST
	
	S_INSCUST = Message.PowerObjectParm //接受返回结构
	
	FOR ls_j = 1 TO  UpperBound(S_INSCUST.outwareid)
		IF S_INSCUST.outwareid[ls_j] > 0 THEN //正常返回值则可以取以下值
			if wf_autoaddmx(S_INSCUST.outwareid[ls_j],S_INSCUST.outwarecode[ls_j],cur_scid,arg_msg)=0 then
				messagebox('错误',arg_msg,stopsign!,ok!)
				return
			end if
			dw_child.SetColumn ('mtrlstatus')
		end if
	NEXT
	dw_child.SetFocus()
END IF

end event

event ue_addzy;call super::ue_addzy;IF NOT (f_power_ind(832) or f_power_ind(835)) THEN
	MessageBox('提示','你没有使用权限！',information!,ok!)
	RETURN
END IF


if dw_edit_mode then return

string arg_msg='',LS_STR
long uc_row
s_inputbox S_SREU

uc_row=dw_pageretr.getrow()
if uc_row<=0 then
	messagebox('提示','请选定当前目标单据!',information!,ok!)
	return
end if
S_SREU.TITLE='请输入要补充到备注的内容'
S_SREU.OLD_TEXT=''
openwithparm(w_inputbox,S_SREU)
LS_STR=Message.StringParm
if trim(LS_STR)='' or isnull(LS_STR) then return

if uo_incase_mtrl.p_getinfo(dw_pageretr.object.u_incase_scid[uc_row],dw_pageretr.object.u_incase_incaseid[uc_row],arg_msg)=0 then
	messagebox('错误',arg_msg,stopsign!,ok!)
	return
end if
if uo_incase_mtrl.add_dscrp(dw_pageretr.object.u_incase_scid[uc_row],dw_pageretr.object.u_incase_incaseid[uc_row],LS_STR,arg_msg,true)=0 then
	messagebox('错误',arg_msg,stopsign!,ok!)
	return
else
	messagebox('提示','添加备注操作成功!',information!,ok!)
	wf_refresh_curuc(dw_pageretr.object.u_incase_scid[uc_row],dw_pageretr.object.u_incase_incaseid[uc_row])
end if

end event

type cb_func from w_publ_1ton_share_detail`cb_func within w_incase
end type

type cb_exit from w_publ_1ton_share_detail`cb_exit within w_incase
end type

type sle_usual_query from w_publ_1ton_share_detail`sle_usual_query within w_incase
integer x = 174
integer width = 549
end type

type cb_retrieveall from w_publ_1ton_share_detail`cb_retrieveall within w_incase
integer x = 2930
integer width = 146
end type

type em_pagerowno from w_publ_1ton_share_detail`em_pagerowno within w_incase
integer y = 36
integer width = 265
end type

type dw_pageretr from w_publ_1ton_share_detail`dw_pageretr within w_incase
integer x = 2021
integer width = 1595
integer height = 972
string dataobject = "dw_incase_index"
end type

event dw_pageretr::rowfocuschanged;call super::rowfocuschanged;wf_check_billfj()
wf_flagstatus_rf()
end event

type st_1 from w_publ_1ton_share_detail`st_1 within w_incase
integer x = 0
end type

type cb_nextpage from w_publ_1ton_share_detail`cb_nextpage within w_incase
integer x = 3077
end type

type dw_uc from w_publ_1ton_share_detail`dw_uc within w_incase
integer x = 9
integer width = 2007
integer height = 960
string dataobject = "dw_incase_edit"
end type

event dw_uc::dwnkey;PARENT.TriggerEvent('user_key')

IF Key = KeyDownArrow! THEN RETURN 1

IF dw_edit_mode THEN
	IF dw_uc.GetColumnName ( ) = 'u_incase_dscrp' AND Key = KeyEnter! THEN
		dw_child.ScrollToRow(1)
		dw_child.SetFocus()
		dw_child.SetColumn ('mtrlstatus')
		RETURN 1
	ELSEIF dw_uc.GetColumnName ( ) = 'u_cust_cuscode' AND Key = KeyEnter! THEN
		String ls_code,ls_name,ls_custype,ls_find_code,ls_freight
		Long ls_cusid
		Long cnt = 0
		Boolean if_find = FALSE
		
		
		dw_uc.AcceptText()
		ls_code = Trim(dw_uc.Object.u_cust_cuscode[dw_uc.GetRow()])
		
		SELECT   u_cust.cusid,
				u_cust.name,
			u_cust.custype,
			u_cust.cuscode,
			u_cust.freight
			INTO	:ls_cusid,:ls_name,:ls_custype,:ls_code,:ls_freight
			FROM u_cust
			Where (cuscode = :ls_code OR Name = :ls_code);
		IF sqlca.SQLCode <> 0 THEN
			
			IF Pos(Trim(ls_code),'%') = 0 THEN
				ls_find_code = '%'+ Trim(ls_code) + '%'
			ELSE
				ls_find_code = Trim(ls_code)
			END IF
			
			SELECT count(*) INTO :cnt
				FROM u_cust
				Where ( cuscode Like :ls_find_code OR Name Like :ls_find_code );
			IF sqlca.SQLCode <> 0 THEN
				PARENT.TriggerEvent('ue_f9')
				RETURN 1
			END IF
			IF cnt <> 1 THEN
				PARENT.TriggerEvent('ue_f9')
				RETURN 1
			ELSE
				SELECT u_cust.cusid,
					u_cust.cuscode,
					u_cust.name
					INTO	:ls_cusid,:ls_code,:ls_name
					FROM u_cust
					Where ( cuscode Like :ls_find_code OR Name Like :ls_find_code );
				IF sqlca.SQLCode <> 0 THEN
					PARENT.TriggerEvent('ue_f9')
					RETURN 1
				ELSE
					if_find = TRUE
				END IF
			END IF
		ELSE
			if_find = TRUE
		END IF
		
		IF if_find THEN
			dw_uc.SetRedraw(FALSE)
			dw_uc.Object.u_incase_cusid[dw_uc.GetRow()] = ls_cusid
			dw_uc.Object.u_cust_cuscode[dw_uc.GetRow()] = ls_code
			dw_uc.Object.u_cust_name[dw_uc.GetRow()] = ls_name
			dw_uc.Object.u_incase_assign_emp[dw_uc.GetRow()] = ls_custype
			dw_uc.Object.prdship[dw_uc.GetRow()] = ls_freight
			dw_uc.SetRedraw(TRUE)
			dw_uc.SetColumn("u_incase_incasedate")
			RETURN 1
		END IF
	ELSE
		IF  Key = KeyEnter! THEN //
			keybd_event ( 9, 0, 0 , 0 ) // 按下tab 
			keybd_event ( 9, 0, 2, 0 ) // 释放tab 
			RETURN 1
		END IF
	END IF
END IF

end event

event dw_uc::buttonclicked;call super::buttonclicked;if not dw_edit_mode then return

if row <= 0 then return

if dwo.name='b_sale' then
	parent.TRIGGEREVENT('ue_f7')	
end if
end event

type gb_2 from w_publ_1ton_share_detail`gb_2 within w_incase
end type

type dw_child from w_publ_1ton_share_detail`dw_child within w_incase
integer y = 1256
integer width = 3575
integer height = 952
string dataobject = "dw_incasemx_index"
end type

event dw_child::dwnkey;call super::dwnkey;PARENT.TriggerEvent('user_key')
String ls_mtrlcode,ls_mtrlname,ls_mtrlmode,ls_unit
Long ls_mtrlid,ls_cusid
Dec ls_gross_weight,ls_net_weight,ls_cubage
Long child_row
Long ls_null
SetNull(ls_null)
String arg_msg = ''

IF dw_edit_mode THEN
	ls_cusid = dw_child.Object.u_incasemx_cusid[dw_uc.GetRow()]
	IF IsNull(ls_cusid) OR ls_cusid = 0 THEN
		THIS.TriggerEvent("ue_f11")
	END IF
	
	IF KeyDown(keydownarrow!) THEN
		Long li_row
		IF dw_child.GetRow() = dw_child.RowCount() THEN
			PARENT.TriggerEvent("insert_childrow")
		END IF
	ELSE
		If (KeyDown(keyenter!) OR KeyDown(keytab!)) AND NOT KeyDown(keycontrol!) AND NOT KeyDown(keyshift!) THEN
			IF dw_child.GetColumnName() = 'u_mtrldef_mtrlcode' THEN
				IF dw_child.Object.u_incasemx_ifson_flag[dw_child.GetRow()] = 0 THEN
					dw_child.AcceptText()
					child_row = dw_child.GetRow()
					
					ls_mtrlcode = dw_child.Object.mtrlstatus[child_row]
					
					SELECT u_mtrldef.mtrlid,
						u_mtrldef.mtrlname,
						u_mtrldef.gross_weight,
						u_mtrldef.net_weight,
						u_mtrldef.cubage,
						u_mtrldef.mtrlmode,
					   u_mtrldef.mtrlcode,
						u_mtrldef.unit
						INTO	:ls_mtrlid,:ls_mtrlname,:ls_gross_weight,:ls_net_weight,:ls_cubage,:ls_mtrlmode,:ls_mtrlcode,:ls_unit
						FROM 	u_mtrldef
						Where	( u_mtrldef.mtrlcode = :ls_mtrlcode);
						
					IF sqlca.SQLCode = 100 THEN
						dw_child.Object.u_incasemx_mtrlid[child_row] = 0
						PARENT.TriggerEvent('ue_f8')
						RETURN 1
					END IF
					dw_child.Object.u_incasemx_mtrlid[child_row]    = ls_mtrlid
					dw_child.Object.mtrlstatus[child_row]    = ls_mtrlname+ls_mtrlmode //（编号+名称+规格）作为品种规格
					dw_child.Object.u_incasemx_ifson_flag[child_row] = 0
					dw_child.Object.fathermtrlid[child_row]=ls_mtrlid
					dw_child.Object.u_mtrldef_mtrlcode[child_row]=ls_mtrlcode
					dw_child.Object.u_mtrldef_mtrlmode[child_row]=ls_mtrlmode
					dw_child.Object.u_mtrldef_mtrlname[child_row]=ls_mtrlname
					dw_child.Object.u_mtrldef_mtrlcode[child_row]=ls_mtrlcode
					dw_child.Object.u_mtrldef_unit[child_row]=ls_unit
					IF wf_find_pf(0,'',ls_mtrlid,0) = 0 THEN
						dw_child.Object.u_incasemx_grossweight[child_row] = ls_gross_weight
						dw_child.Object.u_incasemx_netweight[child_row] = ls_net_weight
						dw_child.Object.u_incasemx_cubage[child_row] = ls_cubage
						dw_child.Object.u_incasemx_packsize[child_row] = ls_mtrlmode
					END IF
					dw_child.SetColumn ('mtrlstatus')
					//				if key = keyenter!  then
					//					keybd_event ( 9, 0, 0 , 0 ) // 按下tab 
					//					keybd_event ( 9, 0, 2, 0 ) // 释放tab 	
					//					return 1
					//				end if
				ELSE
					
					IF Key = keyenter!  THEN
						keybd_event ( 9, 0, 0 , 0 ) // 按下tab 
						keybd_event ( 9, 0, 2, 0 ) // 释放tab 	
						RETURN 1
					END IF
				END IF
		ELSEIF dw_child.GetColumnName ( ) = 'u_cust_cuscode' AND Key = KeyEnter! THEN
		String ls_code,ls_name,ls_custype,ls_find_code
		Long ls_cusid_1
		Long cnt = 0
		Boolean if_find = FALSE
		
		
		dw_child.AcceptText()
		ls_code = Trim(dw_child.Object.u_cust_cuscode[dw_child.GetRow()])
		
		SELECT   u_cust.cusid,
				u_cust.name,
			u_cust.custype,
			u_cust.cuscode
			INTO	:ls_cusid_1,:ls_name,:ls_custype,:ls_code
			FROM u_cust
			Where (cuscode = :ls_code OR Name = :ls_code);
		IF sqlca.SQLCode <> 0 THEN
			
			IF Pos(Trim(ls_code),'%') = 0 THEN
				ls_find_code = '%'+ Trim(ls_code) + '%'
			ELSE
				ls_find_code = Trim(ls_code)
			END IF
			
			SELECT count(*) INTO :cnt
				FROM u_cust
				Where ( cuscode Like :ls_find_code OR Name Like :ls_find_code );
			IF sqlca.SQLCode <> 0 THEN
				PARENT.TriggerEvent('ue_f11')
				RETURN 1
			END IF
			IF cnt <> 1 THEN
				PARENT.TriggerEvent('ue_f11')
				RETURN 1
			ELSE
				SELECT u_cust.cusid,
					u_cust.cuscode,
					u_cust.name
					INTO	:ls_cusid_1,:ls_code,:ls_name
					FROM u_cust
					Where ( cuscode Like :ls_find_code OR Name Like :ls_find_code );
				IF sqlca.SQLCode <> 0 THEN
					PARENT.TriggerEvent('ue_f11')
					RETURN 1
				ELSE
					if_find = TRUE
				END IF
			END IF
		ELSE
			if_find = TRUE
		END IF
		
		IF if_find THEN
			dw_child.SetRedraw(FALSE)
			dw_child.Object.u_incasemx_cusid[dw_child.GetRow()] = ls_cusid_1
			dw_child.Object.u_cust_cuscode[dw_child.GetRow()] = ls_code
			dw_child.Object.u_cust_name[dw_child.GetRow()] = ls_name
			
			dw_child.SetRedraw(TRUE)
			dw_child.SetColumn("mtrlstatus")
			RETURN 1
		END IF
			ELSEIF dw_child.GetColumnName( ) = 'u_incasemx_mxdscrp' AND dw_child.GetRow() = dw_child.RowCount() THEN
				PARENT.TriggerEvent("insert_childrow")
				RETURN 1
			ELSE
				IF Key = keyenter!  THEN
					keybd_event ( 9, 0, 0 , 0 ) // 按下tab 
					keybd_event ( 9, 0, 2, 0 ) // 释放tab 	
					RETURN 1
				END IF
			END IF
		END IF
	END IF
END IF



end event

event dw_child::doubleclicked;if dw_edit_mode then
	choose case dwo.name
		case 'u_cust_cuscode'
			parent.triggerevent('ue_f11')
		case 'u_mtrldef_mtrlcode'
			parent.triggerevent('ue_f8')
	end choose	  
end if
end event

type cb_viewprint from w_publ_1ton_share_detail`cb_viewprint within w_incase
integer x = 2025
end type

event cb_viewprint::clicked;string ls_dft_old_dwname, ls_dft_new_dwname,ls_dwtype
long ls_dwprintid
int ls_i
IF NOT f_power_ind(836) THEN
	MessageBox('提示','你没有使用权限！',information!,ok!)
	RETURN
END IF
 

DECLARE dft_dwprint CURSOR FOR
SELECT dwprintid,dft_old_dwname, dft_new_dwname, chnname, dwtype
FROM sys_dft_dwprint_dynamic
where dwtype='w_incase';

open dft_dwprint;
fetch dft_dwprint into  :ls_dwprintid,:ls_dft_old_dwname, :ls_dft_new_dwname,:ls_chnname, :ls_dwtype;
if sqlca.sqlcode<>0 then
	parent.triggerevent('ue_viewprint',0,0)
else
	m_dft_dwprint_item m_1
	m_1=create m_dft_dwprint_item
	ls_i=1
	do while sqlca.sqlcode=0
		f_add_menuItem_dft(m_1,ls_i,ls_chnname,String(ls_dwprintid))
		fetch dft_dwprint into  :ls_dwprintid,:ls_dft_old_dwname, :ls_dft_new_dwname,:ls_chnname, :ls_dwtype;
		ls_i++
	loop
	close dft_dwprint;
	m_1.popmenu(this.x+50,this.y+50)
end if

end event

type cb_print from w_publ_1ton_share_detail`cb_print within w_incase
integer x = 1833
end type

event cb_print::clicked;string ls_dft_old_dwname, ls_dft_new_dwname,ls_dwtype
long ls_dwprintid
int ls_i
IF NOT f_power_ind(836) THEN
	MessageBox('提示','你没有使用权限！',information!,ok!)
	RETURN
END IF
 
w_curwin = parent

DECLARE dft_dwprint CURSOR FOR
SELECT dwprintid,dft_old_dwname, dft_new_dwname, chnname, dwtype
FROM sys_dft_dwprint_dynamic
where dwtype='w_incase';

open dft_dwprint;
fetch dft_dwprint into  :ls_dwprintid,:ls_dft_old_dwname, :ls_dft_new_dwname,:ls_chnname, :ls_dwtype;
if sqlca.sqlcode<>0 then
	parent.triggerevent('ue_print',0,0)
else
	m_dft_dwprint_item m_1
	m_1=create m_dft_dwprint_item
	ls_i=1
	do while sqlca.sqlcode=0
		f_add_menuitem_print_dft(m_1,ls_i,ls_chnname,String(ls_dwprintid))
		fetch dft_dwprint into  :ls_dwprintid,:ls_dft_old_dwname, :ls_dft_new_dwname,:ls_chnname, :ls_dwtype;
		ls_i++
	loop
	close dft_dwprint;
	m_1.popmenu(this.x+50,this.y+50)
end if

end event

type cb_add from w_publ_1ton_share_detail`cb_add within w_incase
end type

event cb_add::clicked;IF NOT f_power_ind(832) THEN
	MessageBox('提示','你没有使用权限！',information!,ok!)
	RETURN
END IF

String arg_msg = ''
Long uc_row,i

IF dw_edit_mode THEN
	dw_uc.AcceptText()
	dw_child.AcceptText()
	uc_row = dw_uc.GetRow()
	IF uc_row <= 0 THEN
		MessageBox('提示','请选定当前目标单据!',information!,ok!)
		RETURN
	END IF
	
	IF NOT Len(String(dw_uc.Object.u_incase_relcode[uc_row])) > 0 THEN
		MessageBox('提示','请填写相关号码!',information!,ok!)
		dw_uc.SetFocus()
		dw_uc.SetColumn("u_incase_relcode")
		RETURN
	END IF
	
	IF NOT dw_uc.Object.u_incase_incasedate[uc_row] > DateTime(2000-01-01,Now()) THEN
		MessageBox('提示','不合理发生时间!',information!,ok!)
		dw_uc.SetFocus()
		dw_uc.SetColumn("u_incase_incasedate")
		RETURN
	END IF
	IF NOT Len(String(dw_uc.Object.u_incase_assign_emp[uc_row])) > 0 THEN
		MessageBox('提示','请填写经手人!',information!,ok!)
		dw_uc.SetFocus()
		dw_uc.SetColumn("u_incase_assign_emp")
		RETURN
	END IF
	uo_incase_mtrl.incasedate = dw_uc.Object.u_incase_incasedate[uc_row]     // 发生时间
	uo_incase_mtrl.Assign_emp  = dw_uc.Object.u_incase_assign_emp[uc_row]      // 经手人
	uo_incase_mtrl.relcode   = dw_uc.Object.u_incase_relcode[uc_row]       //相关号码
	uo_incase_mtrl.dscrp  = dw_uc.Object.u_incase_dscrp[uc_row]      //备注
	uo_incase_mtrl.relid  = dw_uc.Object.u_incase_relid[uc_row]      
	uo_incase_mtrl.custid  = 0     //客户ID
	uo_incase_mtrl.prdship = dw_uc.Object.prdship[uc_row]
	FOR i = 1 TO dw_child.RowCount()
		IF dw_child.Object.u_incasemx_mtrlid[i] > 0  THEN			
			IF uo_incase_mtrl.acceptmx(dw_child.Object.u_incasemx_mtrlid[i],&				
				dw_child.Object.mtrlstatus[i],&
				dw_child.Object.u_incasemx_pfcode[i],&
				dw_child.Object.u_incasemx_qty[i],&
				dw_child.Object.u_incasemx_packunit[i],&
				dw_child.Object.u_incasemx_packcode[i],&
				dw_child.Object.u_incasemx_packsize[i],&
				dw_child.Object.u_incasemx_mxdscrp[i],&
				dw_child.Object.u_incasemx_packqty[i],&
				arg_msg,&
				dw_child.Object.pid[i],&
				dw_child.Object.u_incasemx_grossweight[i],&
				dw_child.Object.u_incasemx_netweight[i],&
				dw_child.Object.u_incasemx_cubage[i],&				
				dw_child.Object.u_incasemx_ifson_flag[i],&
				dw_child.Object.fathermtrlid[i],&
				dw_child.Object.packqty_1[i],&
				dw_child.Object.u_incasemx_cusid[i],&
				dw_child.Object.u_incasemx_relid_outware[i],&
				dw_child.Object.u_incasemx_relcode_outware[i],&
				dw_child.Object.u_incasemx_discard[i],&
				dw_child.Object.u_incasemx_sonscale[i]) = 0 THEN
				MessageBox('错误',arg_msg,stopsign!,ok!)
				RETURN
			END IF
		END IF
	NEXT
	
	
	IF uo_incase_mtrl.save(publ_operator,arg_msg,true) = 0 THEN
		MessageBox('错误',arg_msg,stopsign!,ok!)
		RETURN
	END IF
	MessageBox('提示','保存操作成功!',information!,ok!)

	long ll_row
	ll_row = dw_pageretr.getrow()
	dw_pageretr.SelectRow(0,FALSE)
	dw_pageretr.SelectRow(ll_row,TRUE)
	wf_refresh_curuc(cur_scid,uo_incase_mtrl.incaseid) //刷新uc
	
ELSE
	IF uo_incase_mtrl.newbegin(cur_scid,arg_msg) = 0 THEN //生产令领料
		MessageBox('错误',arg_msg,stopsign!,ok!)
		RETURN
	END IF
END IF

CALL SUPER::Clicked

IF dw_edit_mode THEN
	PARENT.TriggerEvent("insert_childrow")
	dw_uc.SetColumn("u_incase_incasedate")
ELSE
	PARENT.TriggerEvent("retrieve_childdw")
END IF



end event

type cb_edit from w_publ_1ton_share_detail`cb_edit within w_incase
end type

event cb_edit::clicked;IF NOT f_power_ind(832) THEN
	MessageBox('提示','你没有使用权限！',information!,ok!)
	RETURN
END IF


string arg_msg=''
long uc_row

if not dw_edit_mode then
	uc_row=dw_pageretr.getrow()
	if uc_row<=0 then
		messagebox('提示','请选定当前目标单据!',information!,ok!)
		return
	end if
end if

if not dw_edit_mode then
	if uo_incase_mtrl.updatebegin(cur_scid,dw_pageretr.object.u_incase_incaseid[uc_row],arg_msg)=0 then
		messagebox('错误',arg_msg,stopsign!,ok!)
		return
	end if
end if

call super::clicked
end event

type cb_delet from w_publ_1ton_share_detail`cb_delet within w_incase
end type

event cb_delet::clicked;call super::clicked;IF NOT f_power_ind(833) THEN
	MessageBox('提示','你没有使用权限！',information!,ok!)
	RETURN
END IF

IF dw_edit_mode THEN RETURN
IF NOT KeyDown(KeyControl!) THEN
	IF MessageBox ("询问","是否确定要删除当前吗",Question!,YesNo! ) = 2 THEN RETURN
END IF

String arg_msg = ''
Long uc_row

uc_row = dw_pageretr.GetRow()
IF uc_row <= 0 THEN
	MessageBox('提示','请选定当前目标订单!',information!,ok!)
	RETURN
END IF
IF uo_incase_mtrl.Cancel(cur_scid,dw_pageretr.Object.u_incase_incaseid[uc_row],arg_msg,TRUE) = 0 THEN
	MessageBox('错误',arg_msg,stopsign!,ok!)
ELSE
	//日志
	Long ls_id
	String ls_code
	ls_id = dw_uc.Object.u_incase_incaseid[uc_row]
	ls_code = dw_uc.Object.u_incase_incasecode[uc_row]
	f_setsysoplog('装箱单','装箱单删除,ID:'+String(ls_id)+',code:'+ls_code,arg_msg,TRUE)
	//--
	MessageBox('提示','删除单据'+String(dw_pageretr.Object.u_incase_incasecode[uc_row])+'成功!',information!,ok!)
	
	
	dw_pageretr.DeleteRow(uc_row)
	dw_pageretr.PostEvent(RowFocusChanged!)
END IF



end event

type cb_addzy from w_publ_1ton_share_detail`cb_addzy within w_incase
end type

event cb_addzy::clicked;call super::clicked;m_Dfc_Control_PopupMenu dmPopupMenu
string menustr


menustr="Text=增加备注~tEvent=ue_addzy"
menustr=menustr + "|" + "Text=展开包件~tEvent=ue_find_pf"
menustr = menustr + "|" + "Text=-"
menustr = menustr + "|" + "Text=查看附件~tEvent=ue_fj_view"
menustr = menustr + "|" + "Text=添加附件~tEvent=ue_fj_edit"

if len(trim(menustr))<>0 then
	dmPopupMenu = Create m_Dfc_Control_PopupMenu
	dmPopupMenu.mf_BuildMenu(This, menustr)
	dmPopupMenu.mf_PopMenu()
	Destroy dmPopupMenu
end if



end event

type cb_auditing from w_publ_1ton_share_detail`cb_auditing within w_incase
end type

event cb_auditing::clicked;call super::clicked;IF NOT f_power_ind(834) THEN
	MessageBox('提示','你没有使用权限！',information!,ok!)
	RETURN
END IF


IF dw_edit_mode THEN RETURN

String arg_msg = ''
Long pagerert_row
Long ll_incaseid,ll_scid

IF MessageBox ("询问","是否确定要对当前装箱单作审核吗?",Question!,YesNo! ) = 2 THEN RETURN

pagerert_row = dw_pageretr.GetRow()
IF pagerert_row <= 0 THEN
	MessageBox('提示','请选定当前目标单据!',information!,ok!)
	RETURN
END IF

ll_incaseid = dw_pageretr.Object.u_incase_incaseid[pagerert_row]
ll_scid = dw_pageretr.Object.u_incase_scid[pagerert_row]


IF uo_incase_mtrl.audit(ll_scid,ll_incaseid,publ_operator,arg_msg,TRUE) = 0 THEN
	MessageBox('错误',arg_msg,stopsign!,ok!)
ELSE
	MessageBox('提示','审核成功!',information!,ok!)
	wf_refresh_curuc(ll_scid,ll_incaseid)
END IF



end event

type cb_xm from w_publ_1ton_share_detail`cb_xm within w_incase
end type

type cb_retrieve from w_publ_1ton_share_detail`cb_retrieve within w_incase
end type

type cb_xls from w_publ_1ton_share_detail`cb_xls within w_incase
integer x = 2217
end type

type cb_help from w_publ_1ton_share_detail`cb_help within w_incase
integer x = 1682
end type

type cb_auditing_cancel from w_publ_1ton_share_detail`cb_auditing_cancel within w_incase
end type

event cb_auditing_cancel::clicked;call super::clicked;IF NOT f_power_ind(874) THEN
	MessageBox('提示','你没有使用权限！',information!,ok!)
	RETURN
END IF


IF dw_edit_mode THEN RETURN

String arg_msg = ''
Long pagerert_row
Long ll_incaseid,ll_scid

IF MessageBox ("询问","是否确定要对当前装箱单作撤消审核吗?",Question!,YesNo! ) = 2 THEN RETURN

pagerert_row = dw_pageretr.GetRow()
IF pagerert_row <= 0 THEN
	MessageBox('提示','请选定当前目标单据!',information!,ok!)
	RETURN
END IF

ll_incaseid = dw_pageretr.Object.u_incase_incaseid[pagerert_row]
ll_scid = dw_pageretr.Object.u_incase_scid[pagerert_row]


//撤审
IF uo_incase_mtrl.cancelaudit(ll_scid,ll_incaseid,arg_msg,TRUE) = 0 THEN
	MessageBox('错误',arg_msg,stopsign!,ok!)
ELSE
	MessageBox('提示','撤审成功!',information!,ok!)
	wf_refresh_curuc(ll_scid,ll_incaseid)
END IF



end event

type p_msg from w_publ_1ton_share_detail`p_msg within w_incase
end type

type p_help from w_publ_1ton_share_detail`p_help within w_incase
end type

type p_encl from w_publ_1ton_share_detail`p_encl within w_incase
end type

type p_other from w_publ_1ton_share_detail`p_other within w_incase
end type

type gb_3 from w_publ_1ton_share_detail`gb_3 within w_incase
end type

type ln_bar from w_publ_1ton_share_detail`ln_bar within w_incase
end type

type ln_bar2 from w_publ_1ton_share_detail`ln_bar2 within w_incase
integer beginx = 0
integer beginy = 172
integer endx = 3264
integer endy = 172
end type

type r_bar from w_publ_1ton_share_detail`r_bar within w_incase
end type

type ln_1 from w_publ_1ton_share_detail`ln_1 within w_incase
integer endx = 2281
end type

type ln_2 from w_publ_1ton_share_detail`ln_2 within w_incase
end type

type st_2 from statictext within w_incase
integer x = 782
integer y = 208
integer width = 219
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_incase
integer x = 955
integer y = 192
integer width = 549
integer height = 468
boolean bringtotop = true
end type

event constructor;call super::constructor;cur_scid=this.uo_scid
//cur_scid_arr = THIS.uo_scid_arr
end event

event selectionchanged;call super::selectionchanged;cur_scid=this.uo_scid
//cur_scid_arr = THIS.uo_scid_arr
parent.triggerevent("retrieve_pageretr")
end event

type st_3 from statictext within w_incase
integer x = 1568
integer y = 204
integer width = 219
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_status from dropdownlistbox within w_incase
integer x = 1742
integer y = 188
integer width = 549
integer height = 468
integer taborder = 40
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
parent.triggerevent('retrieve_pageretr')
end event