Q5/ws_objects/Ew_machining.pbl.src/w_wfjg_out.srw

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

global type w_wfjg_out from w_publ_1ton_share_detail
string title = "车间外协发出单"
boolean maxbox = true
windowstate windowstate = maximized!
event insert_childrow ( )
event ue_fj_edit ( )
event ue_fj_view ( )
event ue_cmp_uqty ( )
event ue_cmp_qty ( )
ddlb_status ddlb_status
st_2 st_2
st_3 st_3
ddlb_scid ddlb_scid
end type
global w_wfjg_out w_wfjg_out

type variables
//uo_wfjg_py uo_ware
uo_outware_wfjg uo_ware
long cur_flag= -1 //-1：全部，0未审
long cur_scid  //分店ID
string ol_cdw_str=''
uo_spt_price uo_sptprice
Int cur_editfocus = 0 //1:新建2:修改
end variables

forward prototypes
public function integer wf_flagstatus_rf ()
public function integer wf_refresh_curuc (long arg_scid, long arg_outwareid)
public function integer wf_autoaddmx (long arg_scid, long arg_storageid, long arg_wrkgrpid, long arg_orderid, long arg_mtrlid, string arg_mtrlname, string arg_relcode, string arg_ordercode, string arg_msg)
public function integer wf_check_ifmtrlware (ref string arg_msg)
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_print_retrievedata (ref s_print_pic_list arg_s_pic, ref string arg_msg)
public subroutine wf_change_sptid (long arg_sptid)
end prototypes

event insert_childrow();long li_row
li_row=dw_child.insertrow(0)
dw_child.scrolltorow(li_row)
dw_child.object.ow_wfjgmx_out_ifrel[li_row] = sys_option_autoyes
if li_row > 1 then
	dw_child.accepttext()
	dw_child.object.ow_wfjgmx_out_storageid[li_row] = dw_child.object.ow_wfjgmx_out_storageid[li_row - 1]	
end if
dw_child.SetColumn ('ow_wfjgmx_out_ifrel')	


end event

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

//IF NOT f_power_ind(1446) 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_uc.GetRow() 
IF ls_row <= 0 THEN
	RETURN
END IF

IF f_get_outerconnection(ll_ConnectionID,arg_msg) = 0 THEN
	MessageBox('错误','没有指定附件数据库连接'+arg_msg,stopsign!,OK!)
	RETURN
END IF

s_pic.f_long = 908 //采购订单的mainID
s_pic.f_string = dw_uc.Object.ow_wfjg_out_outwarecode[ls_row]
s_pic.g_long = dw_uc.Object.ow_wfjg_out_outwareid[ls_row]
s_pic.e_long = dw_uc.Object.ow_wfjg_out_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_uc.GetRow()
IF ls_row <= 0 THEN
	RETURN
END IF

IF f_get_outerconnection(ll_ConnectionID,arg_msg) = 0 THEN
	MessageBox('错误','没有指定附件数据库连接'+arg_msg,stopsign!,OK!)
	RETURN
END IF

s_pic.f_long = 908 //采购订单的mainID
s_pic.f_string = dw_uc.Object.ow_wfjg_out_outwarecode[ls_row]
s_pic.g_long = dw_uc.Object.ow_wfjg_out_outwareid[ls_row]
s_pic.e_long = dw_uc.Object.ow_wfjg_out_scid[ls_row]
s_pic.sqltransaction = sys_filedb_sqlca

OpenWithParm(w_fj_bill_view,s_pic)



end event

event ue_cmp_uqty();IF NOT dw_edit_mode THEN RETURN
Long ll_i
dw_child.AcceptText()
dw_child.SetRedraw(FALSE)
FOR ll_i = 1 TO dw_child.RowCount()
	IF dw_child.Object.ow_wfjgmx_out_qty[ll_i] > 0 AND dw_child.Object.ow_wfjgmx_out_rate[ll_i] > 0 THEN
		dw_child.Object.ow_wfjgmx_out_uqty[ll_i] = Round(dw_child.Object.ow_wfjgmx_out_qty[ll_i] / dw_child.Object.ow_wfjgmx_out_rate[ll_i],sys_option_unit_dec)
	END IF
NEXT
dw_child.SetRedraw(TRUE)



end event

event ue_cmp_qty();IF NOT dw_edit_mode THEN RETURN
Long ll_i
dw_child.accepttext()
dw_child.SetRedraw(FALSE)
FOR ll_i = 1 TO dw_child.RowCount()
	IF dw_child.Object.ow_wfjgmx_out_uqty[ll_i] > 0 AND dw_child.Object.ow_wfjgmx_out_rate[ll_i] > 0 THEN
		dw_child.Object.ow_wfjgmx_out_qty[ll_i] = round(dw_child.Object.ow_wfjgmx_out_uqty[ll_i] * dw_child.Object.ow_wfjgmx_out_rate[ll_i],sys_option_unit_dec)
	END IF
NEXT
dw_child.SetRedraw(TRUE)

end event

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.ow_wfjg_out_flag[pagerert_row]=0 then
		cb_auditing.enabled=true
		cb_auditing_cancel.enabled=false
	elseif dw_pageretr.object.ow_wfjg_out_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_refresh_curuc (long arg_scid, long arg_outwareid);//wf_refresh_curuc
IF arg_outwareid <= 0 OR IsNull(arg_outwareid) THEN RETURN 0
Long uc_row
uc_row = dw_pageretr.GetRow()
IF uc_row <= 0 THEN RETURN 0

datetime outdate
string outrep
string cusname
string part
string dscrp
string outwarecode
datetime opdate
string opemp
datetime auditingdate
int flag
string auditingrep
int balcflag
string storagename
string Modemp
datetime moddate
string sptcode	
string sptname	
long sptid

SELECT ow_wfjg_out.outdate,
	ow_wfjg_out.outrep,
 
	ow_wfjg_out.part,
	ow_wfjg_out.dscrp,
	ow_wfjg_out.outwarecode,
	ow_wfjg_out.opdate,
	ow_wfjg_out.opemp,
	ow_wfjg_out.auditingdate,
	ow_wfjg_out.flag,
	ow_wfjg_out.auditingemp,
	ow_wfjg_out.balcflag,
	ow_wfjg_out.Modemp,
	ow_wfjg_out.moddate,
	u_spt.sptcode,
	u_spt.name,
	ow_wfjg_out.sptid
	INTO	:outdate,
	:outrep,
	:part,
	:dscrp,
	:outwarecode,
	:opdate,
	:opemp,
	:auditingdate,
	:flag,
	:auditingrep,
	:balcflag,
	:Modemp,
	:moddate,
	:sptcode,
	:sptname,
	:sptid
	FROM ow_wfjg_out INNER JOIN
	u_spt ON ow_wfjg_out.sptid = u_spt.sptid
	Where ( ow_wfjg_out.outwareid = :arg_outwareid )
 	and ( ow_wfjg_out.sptid = u_spt.sptid) 
	and ( ow_wfjg_out.scid = :arg_scid );
IF sqlca.SQLCode <> 0 THEN
	MessageBox('错误',"查询操作失败(错误单据唯一码)",stopsign!,OK!)
	RETURN 0
END IF

dw_pageretr.Object.ow_wfjg_out_scid[uc_row] = arg_scid
dw_pageretr.Object.ow_wfjg_out_outwareid[uc_row] = arg_outwareid
dw_pageretr.Object.ow_wfjg_out_outdate[uc_row] = outdate
dw_pageretr.Object.ow_wfjg_out_outrep[uc_row] =  outrep
dw_pageretr.Object.ow_wfjg_out_part[uc_row] =  part
dw_pageretr.Object.ow_wfjg_out_dscrp[uc_row] =  dscrp
dw_pageretr.Object.ow_wfjg_out_outwarecode[uc_row] = outwarecode
dw_pageretr.Object.ow_wfjg_out_opdate[uc_row] =  opdate
dw_pageretr.Object.ow_wfjg_out_opemp[uc_row] = opemp
dw_pageretr.Object.ow_wfjg_out_Auditingdate[uc_row] = auditingdate
dw_pageretr.Object.ow_wfjg_out_flag[uc_row] = flag
dw_pageretr.Object.ow_wfjg_out_Auditingemp[uc_row] = auditingrep
dw_pageretr.Object.ow_wfjg_out_balcflag[uc_row] =  balcflag
dw_pageretr.Object.ow_wfjg_out_moddate[uc_row] = moddate
dw_pageretr.Object.ow_wfjg_out_modemp[uc_row] = modemp
dw_pageretr.Object.u_spt_name[uc_row] = sptname
dw_pageretr.Object.u_spt_code[uc_row] = sptcode
dw_pageretr.Object.ow_wfjg_out_sptid[uc_row] = sptid

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_scid, long arg_storageid, long arg_wrkgrpid, long arg_orderid, long arg_mtrlid, string arg_mtrlname, string arg_relcode, string arg_ordercode, string arg_msg);Int rslt = 1
long childrow
//
//
//
//
//
//childrow = dw_child.GetRow()
//
//IF childrow > 0 THEN
// DECLARE qq CURSOR FOR  
//  SELECT cw_banktype.accsetid  
//    FROM cw_banktype  ;
//	IF dw_child.Object.u_outwaremx_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_outwaremx_relid[childrow] = arg_orderid
//dw_child.Object.u_outwaremx_olmtrlid[childrow] = arg_mtrlid
//dw_child.Object.u_mtrldef_mtrlname_1[childrow] = arg_mtrlname
//dw_child.Object.u_order_ml_relcode[childrow] = arg_relcode
//dw_child.Object.u_order_ml_ordercode[childrow] = arg_ordercode

RETURN rslt


end function

public function integer wf_check_ifmtrlware (ref string arg_msg);////
Long i,rowcnt,rslt = 1
//Long ls_mtrlwareid,ls_mtrlid,ls_storageid,ls_dxflag,ll_cusid,ls_sptid
//String ls_mtrlcode
//String ls_plancode
//String ls_status,ls_woodcode,ls_pcode
//Decimal ls_qty
//
//rowcnt = dw_child.RowCount( )
//
//ls_storageid = dw_uc.Object.u_outware_storageid[dw_uc.GetRow()]
//IF ls_storageid = 0 THEN
//	arg_msg = '请选择仓库'
//	rslt = 0
//	GOTO ext
//END IF
//
//Int li_if_cus_mtrlware
//SELECT  balctype INTO :li_if_cus_mtrlware
//	FROM u_storage
//	Where storageid = :ls_storageid;
//IF sqlca.SQLCode <> 0 THEN
//	arg_msg = '查询仓库是否使用客户库存失败'
//	rslt = 0
//	goto ext
//END IF
//
//IF li_if_cus_mtrlware = 1 THEN
//	ll_cusid = dw_uc.Object.u_outware_cusid[dw_uc.GetRow()]
//	IF ll_cusid = 0 THEN
//		arg_msg = '请选择客户'
//		rslt = 0
//		GOTO ext
//	END IF
//	
//	ls_sptid = ll_cusid	
//ELSE
//	ls_sptid = 0
//END IF
//
//FOR i = 1 TO rowcnt
//	
//	ls_mtrlwareid = 	dw_child.Object.u_outwaremx_mtrlwareid[i]
//	ls_mtrlid = 	dw_child.Object.u_outwaremx_mtrlid[i]
//	ls_mtrlcode = 	dw_child.Object.u_mtrldef_mtrlcode[i]
//	
//	ls_plancode = 	dw_child.Object.u_outwaremx_plancode[i]
//	ls_dxflag = 	dw_child.Object.u_outwaremx_dxflag[i]
//	
//	ls_status = 	dw_child.Object.u_outwaremx_status[i]
//	ls_woodcode = 	dw_child.Object.u_outwaremx_woodcode[i]
//	ls_pcode = 	dw_child.Object.u_outwaremx_pcode[i]
//	
//	ls_qty = dw_child.Object.u_outwaremx_qty[i]
//	
//	IF ls_mtrlid = 0 OR ls_qty = 0 THEN CONTINUE
//	
//	
//	IF f_insert_0_mtrlware(ls_mtrlwareid,ls_mtrlid,ls_mtrlcode,ls_storageid,ls_sptid,ls_status,ls_woodcode,ls_pcode,ls_plancode,0,arg_msg) = 0 THEN
//		rslt = 0
//		GOTO ext
//	ELSE
//		dw_child.Object.u_outwaremx_mtrlwareid[i] = ls_mtrlwareid
//	END IF
//	
//NEXT
//
//dw_child.AcceptText( )
//ext:
RETURN rslt
//
//
//
//
end function

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.ow_wfjg_out_outwareid[row]
	ll_scid = dw_pageretr.Object.ow_wfjg_out_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 = 908 //客户投拆单的 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_uc.GetRow()
IF LS_ROW <= 0 THEN
	arg_msg = '没有目标单据!'
	RETURN 0
END IF

//修改点:获取 指定retriev参数
ll_id = dw_uc.Object.ow_wfjg_out_outwareid[LS_ROW]
ll_scid = dw_uc.Object.ow_wfjg_out_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 = 908);
	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.ow_wfjgmx_out_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_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.ow_wfjg_out_outwareid[LS_ROW]
ll_scid = dw_pageretr.Object.ow_wfjg_out_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.ow_wfjgmx_out_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

public subroutine wf_change_sptid (long arg_sptid);Long ll_row

ll_row  = dw_uc.GetRow()

IF ll_row <= 0 THEN RETURN

IF dw_uc.Object.ow_wfjg_out_sptid[ll_row] > 0 And  dw_uc.Object.ow_wfjg_out_sptid[ll_row] <> arg_sptid THEN
	dw_child.Reset()
	This.TriggerEvent("insert_childrow")
END IF


RETURN


end subroutine

on w_wfjg_out.create
int iCurrent
call super::create
this.ddlb_status=create ddlb_status
this.st_2=create st_2
this.st_3=create st_3
this.ddlb_scid=create ddlb_scid
iCurrent=UpperBound(this.Control)
this.Control[iCurrent+1]=this.ddlb_status
this.Control[iCurrent+2]=this.st_2
this.Control[iCurrent+3]=this.st_3
this.Control[iCurrent+4]=this.ddlb_scid
end on

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

event open;THIS.TriggerEvent('ue_before_open')
wf_movetocenter()


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()

IF s_tran.d_long = 2 THEN
	cur_scid =  s_tran.c_long
	Int li_item
	li_item = ddlb_scid.FindItem(s_tran.d_string,0)
	IF li_item > 0 THEN
		ddlb_scid.SelectItem(li_item)
	END IF
END IF

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 = 8 //uc dw前5列可以编辑
child_column_int =18 //子dw前5列可以编辑

uo_ware = CREATE uo_outware_wfjg
uo_ware.commit_transaction = sqlca
uo_sptprice = CREATE uo_spt_price
s_hide_col s_col
s_col.col_1 = 'ow_wfjgmx_out_fprice'
s_col.col_2 = 'ow_wfjgmx_out_uprice'	
s_col.col_3 = 'enamt'
f_hide_col(1473,dw_child,s_col)

end event

event close;call super::close;
destroy uo_ware
destroy uo_sptprice
wf_del_tempfilepathname()
end event

event refresh_interface;call super::refresh_interface;wf_flagstatus_rf()
ddlb_status.enabled=not dw_edit_mode
if dw_edit_mode then
	ddlb_scid.enabled=false
else
	if sys_scid > 0 then
		ddlb_scid.enabled=false
	else
		ddlb_scid.enabled=true
	end if
end if
//if dw_edit_mode then
//	dw_child.x=0 
//	dw_child.width=this.width - 50
//	dw_pageretr.height=764
//else
//	dw_child.x=1042 
//	dw_child.width=2523
//	dw_pageretr.height=1992
//end if
//
end event

event retrieve_childdw;call super::retrieve_childdw;long row,uc_relid
row=dw_pageretr.getrow()
if row>0 then 
	uc_relid=dw_pageretr.object.ow_wfjg_out_outwareid[row]
	dw_child.SetRedraw (false)
	dw_child.retrieve(cur_scid,uc_relid,sys_option_2unit)
	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,sys_user_spttype)
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

//只显未自已管的仓库
datawindowchild childdw
String new_sqlstr,modify_str

dw_uc.SetTransObject (sqlca)
dw_uc.GetChild("u_outware_storageid",childdw)
childdw.SetTransObject (sqlca)

new_sqlstr = childdw.Describe("DataWindow.Table.Select")
IF Len(ol_cdw_str) = 0 THEN ol_cdw_str = new_sqlstr
new_sqlstr = f_modify_selectstr(ol_cdw_str)
modify_str = "DataWindow.Table.Select='" + new_sqlstr +"'"
childdw.Modify ( modify_str )
childdw.Retrieve(cur_scid)
//childdw.retrieve()


end event

event ue_usual_query_filt;call super::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+'( ow_wfjg_out_outwarecode LIKE "%'+trim(sle_usual_query.text)+'%" )'
	ELSE
		obj_expr=obj_expr+'( ow_wfjg_out_outwarecode 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)
	dw_pageretr.SetRow(1)
	dw_pageretr.triggerevent(rowfocuschanged!)
end if
dw_pageretr.SetRedraw(TRUE)
end event

event ue_usual_query_retr;call super::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="(ow_wfjg_out.outwarecode like '%"+trim(sle_usual_query.text)+"%')"
	else
		ls_querystrpart="(ow_wfjg_out.outwarecode 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_f8;call super::ue_f8;//用于选择明细内容,被f8[默认]\dw_child.doubleclicked调用
IF NOT dw_edit_mode THEN RETURN
Long child_row,ls_sptid
dw_child.AcceptText()

String ls_unit_buy,ls_unit_scll,ls_unit_sale
Decimal ld_rate_buy,ld_rate_scll,ld_rate_sale
Int li_wfjgunit,li_wfjgdec
string ls_unit
long li_dec
decimal ld_rate
s_mtrldef_array arg_s_mtrldef

dw_uc.accepttext()
ls_sptid = dw_uc.Object.ow_wfjg_out_sptid[dw_uc.GetRow()]
IF IsNull(ls_sptid) OR ls_sptid = 0 THEN
	THIS.TriggerEvent("ue_f9")
END IF


child_row = dw_child.GetRow()
Long ls_j
IF dw_child.Object.ow_wfjgmx_out_ifrel[child_row] = 0 THEN
	
	THIS.Enabled = FALSE
	
	IF NOT IsValid(w_mtrldef_edit) THEN
		s_edit_index_tran s_ch_tran
		s_ch_tran.if_retrieve_all = FALSE
		s_ch_tran.work_mode = 1
		s_ch_tran.arg_pkid = 0
		s_ch_tran.arg_string_code = ''
		s_ch_tran.b_long = 3
		s_ch_tran.c_long =  - 1
		s_ch_tran.if_select_all = TRUE
		
		dw_child.AcceptText()
		IF dw_child.GetRow() > 0 THEN s_ch_tran.arg_string_code = Trim(dw_child.Object.u_mtrldef_mtrlcode[dw_child.GetRow()])
		
		OpenWithParm(w_mtrldef_edit,s_ch_tran) //调用
		
		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.ow_wfjgmx_out_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
				
					
				IF f_find_mtrl_by_id(s_inscust.mtrlid[ls_j],arg_s_mtrldef) = 0 THEN
					li_wfjgunit = 0
					ls_unit_buy = ''
					ls_unit_scll = ''
					ls_unit_sale = ''
					ld_rate_buy = 0
					ld_rate_scll = 0
					ld_rate_sale = 0
					li_wfjgdec = 0
				ELSE
					li_wfjgunit = arg_s_mtrldef.wfjgunit[1]
					ls_unit_buy = arg_s_mtrldef.unit_buy[1]
					ls_unit_scll = arg_s_mtrldef.unit_scll[1]
					ls_unit_sale = arg_s_mtrldef.unit_sale[1]
					ld_rate_buy = arg_s_mtrldef.rate_buy[1]
					ld_rate_scll = arg_s_mtrldef.rate_scll[1]
					ld_rate_sale = arg_s_mtrldef.rate_sale[1]
					li_wfjgdec = arg_s_mtrldef.wfjgdec[1]
				END IF
				
				IF li_wfjgunit = 0 THEN
					ls_unit = s_inscust.unit[ls_j]
					ld_rate = 1
					li_dec = sys_option_unit_dec
				ELSEIF li_wfjgunit = 1 THEN
					ls_unit = ls_unit_buy
					ld_rate = ld_rate_buy
					li_dec = li_wfjgdec
				ELSEIF li_wfjgunit = 2 THEN
					ls_unit = ls_unit_scll
					ld_rate = ld_rate_scll
					li_dec = li_wfjgdec
				ELSEIF li_wfjgunit = 3 THEN
					ls_unit = ls_unit_sale
					ld_rate = ld_rate_sale
					li_dec = li_wfjgdec
				END IF
				
				dw_child.Object.ow_wfjgmx_out_mtrlid[child_row] = s_inscust.mtrlid[ls_j]
				dw_child.Object.u_mtrldef_mtrlcode[child_row] = s_inscust.mtrlcode[ls_j]
				dw_child.Object.u_mtrldef_mtrlname[child_row] = s_inscust.mtrlname[ls_j]
				dw_child.Object.u_mtrldef_mtrlmode[child_row]    = s_inscust.mtrlmode[ls_j]
				dw_child.Object.u_mtrldef_unit[child_row] = s_inscust.unit[ls_j]
				dw_child.Object.ow_wfjgmx_out_uunit[child_row] = ls_unit
				dw_child.Object.ow_wfjgmx_out_rate[child_row] = ld_rate
				
				dw_child.Object.u_mtrldef_mtrlsectype[child_row] = s_inscust.mtrlsectype[ls_j]
				dw_child.Object.u_mtrldef_zxmtrlmode[child_row] = s_inscust.zxmtrlmode[ls_j]
				
				dw_child.Object.u_mtrldef_mtrltype[child_row] = S_INSCUST.mtrltype[ls_j]
				dw_child.Object.u_mtrldef_handtype[child_row] = S_INSCUST.handtype[ls_j]
				

				
				
				Decimal ls_1stnewcost,ls_1stzqrate,ls_1strate
				String arg_msg,ls_status,ls_woodcode,ls_pcode
				ls_status = dw_child.Object.ow_wfjgmx_out_status[child_row]
				ls_woodcode = dw_child.Object.ow_wfjgmx_out_woodcode[child_row]
				ls_pcode = dw_child.Object.ow_wfjgmx_out_pcode[child_row]
				IF uo_sptprice.uf_getmtrlsptprice(ls_sptid,s_inscust.mtrlid[ls_j],s_inscust.unit[ls_j],ls_status,ls_woodcode,ls_pcode,0,ls_1stnewcost,ls_1stzqrate,ls_1strate,arg_msg) <> 1 THEN
					IF s_inscust.planprice[ls_j] = 0 THEN
						dw_child.Object.ow_wfjgmx_out_fprice[child_row]     = s_inscust.lmbuyprice[ls_j]
					ELSE
						dw_child.Object.ow_wfjgmx_out_fprice[child_row]     = s_inscust.planprice[ls_j]
					END IF
				ELSE
					dw_child.Object.ow_wfjgmx_out_fprice[child_row] = ls_1stnewcost
					dw_child.Object.ow_wfjgmx_out_rebate[child_row]     = ls_1stzqrate
				END IF
				
			END IF
		NEXT
	END IF
	dw_child.SetRedraw(TRUE)
	dw_child.SetFocus()
	
	THIS.Enabled = TRUE
ELSE
	dw_child.AcceptText()
	dw_uc.AcceptText()
	Long childrow
	ls_sptid = dw_uc.Object.ow_wfjg_out_sptid[dw_uc.GetRow()]
	IF ls_sptid <= 0 THEN
		MessageBox("提示","请先选择供应商",information!,OK!)
		RETURN
	END IF
	
	s_mtrldef_wfjg_array  s_inscust8
	s_edit_index_tran s_tranf88
	s_tranf88.if_retrieve_all = FALSE
	s_tranf88.arg_pkid = 0
	s_tranf88.arg_string_code = dw_child.Object.u_mtrldef_mtrlcode[dw_child.GetRow()]
	s_tranf88.b_long = 2
	s_tranf88.d_long = ls_sptid
	s_tranf88.e_long =  0
	
	THIS.Enabled = FALSE
	IF NOT IsValid(w_wfjg_out_ch) THEN
		OpenWithParm(w_wfjg_out_ch,s_tranf88)
		
		
		s_inscust8 = Message.PowerObjectParm //接受返回结构
		dw_child.SetRedraw(FALSE)
		childrow = dw_child.GetRow()
		FOR ls_j = 1 TO  UpperBound(s_inscust8.wfjgid)
			IF s_inscust8.wfjgid[ls_j] > 0 THEN //正常返回值则可以取以下值
				
				IF dw_child.GetRow() > 0 THEN
					IF dw_child.Object.ow_wfjgmx_out_relid[childrow] <> 0 THEN
						childrow = dw_child.InsertRow (0)
					ELSE
						childrow = dw_child.GetRow()
					END IF
				ELSE
					childrow = dw_child.InsertRow (0)
				END IF
				
				IF f_find_mtrl_by_id(s_inscust8.mtrlid[ls_j],arg_s_mtrldef) = 0 THEN
					li_wfjgunit = 0
					ls_unit_buy = ''
					ls_unit_scll = ''
					ls_unit_sale = ''
					ld_rate_buy = 0
					ld_rate_scll = 0
					ld_rate_sale = 0
					li_wfjgdec = 0
				ELSE
					li_wfjgunit = arg_s_mtrldef.wfjgunit[1]
					ls_unit_buy = arg_s_mtrldef.unit_buy[1]
					ls_unit_scll = arg_s_mtrldef.unit_scll[1]
					ls_unit_sale = arg_s_mtrldef.unit_sale[1]
					ld_rate_buy = arg_s_mtrldef.rate_buy[1]
					ld_rate_scll = arg_s_mtrldef.rate_scll[1]
					ld_rate_sale = arg_s_mtrldef.rate_sale[1]
					li_wfjgdec = arg_s_mtrldef.wfjgdec[1]
				END IF
				
				IF li_wfjgunit = 0 THEN
					ls_unit = s_inscust8.unit[ls_j]
					ld_rate = 1
					li_dec = sys_option_unit_dec
				ELSEIF li_wfjgunit = 1 THEN
					ls_unit = ls_unit_buy
					ld_rate = ld_rate_buy
					li_dec = li_wfjgdec
				ELSEIF li_wfjgunit = 2 THEN
					ls_unit = ls_unit_scll
					ld_rate = ld_rate_scll
					li_dec = li_wfjgdec
				ELSEIF li_wfjgunit = 3 THEN
					ls_unit = ls_unit_sale
					ld_rate = ld_rate_sale
					li_dec = li_wfjgdec
				END IF
				
				dw_child.Object.ow_wfjgmx_out_ifrel[childrow]     = 1
				dw_child.Object.ow_wfjgmx_out_relid[childrow]     = s_inscust8.wfjgid[ls_j]
				dw_child.Object.ow_wfjgmx_out_mtrlid[childrow]    = s_inscust8.mtrlid[ls_j]
				dw_child.Object.u_mtrldef_mtrlcode[childrow]      = s_inscust8.mtrlcode[ls_j]
				dw_child.Object.ow_wfjgmx_out_relcode[childrow]   = s_inscust8.taskcode[ls_j]
				dw_child.Object.ow_wfjgmx_out_price[childrow]     = s_inscust8.price[ls_j]
				dw_child.Object.u_mtrldef_mtrlname[childrow]      = s_inscust8.mtrlname[ls_j]
				dw_child.Object.u_mtrldef_mtrlmode[childrow]      = s_inscust8.mtrlmode[ls_j]
				dw_child.Object.u_mtrldef_unit[childrow]          = s_inscust8.unit[ls_j]
				dw_child.Object.ow_wfjgmx_out_qty[childrow]       = s_inscust8.qty[ls_j]
				dw_child.Object.ow_wfjgmx_out_status[childrow]    = s_inscust8.status[ls_j]
				dw_child.Object.ow_wfjgmx_out_fprice[childrow]    = s_inscust8.price[ls_j]
				dw_child.Object.ow_wfjgmx_out_woodcode[childrow]  = s_inscust8.woodcode[ls_j]
				dw_child.Object.ow_wfjgmx_out_printid[childrow]   = s_inscust8.printid[ls_j]
				dw_child.Object.ow_wfjgmx_out_storageid[childrow] = s_inscust8.storageid[ls_j]
				dw_child.Object.ow_wfjgmx_out_uunit[childrow] = ls_unit
				dw_child.Object.ow_wfjgmx_out_uqty[childrow]  = s_inscust8.qty[ls_j]/ld_rate
				dw_child.Object.ow_wfjgmx_out_rate[childrow]  = ld_rate
				dw_child.Object.u_mtrldef_mtrlsectype[childrow] = s_inscust8.mtrlsectype[ls_j]
				dw_child.Object.u_mtrldef_zxmtrlmode[childrow] = s_inscust8.zxmtrlmode[ls_j] 
				dw_child.Object.ow_wfjgmx_out_mxdscrp[childrow] = s_inscust8.dscrp[ls_j] 
				dw_child.Object.ow_wfjgmx_out_mxdscrp2[childrow] = s_inscust8.dscrp2[ls_j]
				dw_child.Object.ow_wfjgmx_out_plancode[childrow] =s_inscust8.plancode[ls_j]
				
			END IF
		NEXT
		
		dw_child.SetColumn('ow_wfjgmx_out_qty')
		dw_child.SetRedraw(TRUE)
	END IF
	
	THIS.Enabled = TRUE
	
END IF


end event

event ue_addzy;call super::ue_addzy;IF NOT f_power_ind(804) 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_ware.add_dscrp(dw_pageretr.Object.ow_wfjg_out_scid[uc_row],dw_pageretr.object.ow_wfjg_out_outwareid[uc_row],LS_STR,arg_msg)=0 then
	messagebox('错误',arg_msg,stopsign!,OK!)
	return
else
	messagebox('提示','添加备注操作成功!',information!,OK!)
	wf_refresh_curuc(dw_pageretr.Object.ow_wfjg_out_scid[uc_row],dw_pageretr.object.ow_wfjg_out_outwareid[uc_row])
end if
end event

event ue_f9;call super::ue_f9;//用于选择明细内容,被F10[默认]
IF Not dw_edit_mode THEN RETURN

Long uc_row
uc_row = dw_uc.GetRow()
IF uc_row = 0 THEN
	MessageBox('提示','请选定出仓单!',information!,OK!)
	RETURN
END IF
dw_uc.AcceptText()

This.Enabled = False

IF Not IsValid(W_spt_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_spt_code[dw_uc.GetRow()]))
	
	OpenWithParm(W_spt_edit,s_ch_tran) //调用
	
	S_spt S_INSCUST
	S_INSCUST = Message.PowerObjectParm //接受返回结构
	
	IF S_INSCUST.sptid > 0 THEN //正常返回值则可以取以下值
		
		//重置dw_child
		wf_change_sptid(S_INSCUST.sptid)
		
		dw_uc.SetRedraw(False)
		dw_uc.Object.ow_wfjg_out_sptid[uc_row] = S_INSCUST.sptid
		dw_uc.Object.u_spt_name[uc_row] = S_INSCUST.Name
		dw_uc.Object.u_spt_code[uc_row] = S_INSCUST.sptcode
		dw_uc.SetRedraw(True)
		dw_uc.SetColumn("ow_wfjg_out_outdate")
	END IF
END IF

This.Enabled = True

end event

event ue_print;call super::ue_print;if not f_power_ind(733) then
	messagebox('提示','你没有使用权限！',information!,OK!)
	return
end if

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

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.ow_wfjg_out_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_wfjg_out_edit'
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.ow_wfjg_out_scid[LS_ROW]
LS_PRMSG.retr_pramnmb=dw_pageretr.object.ow_wfjg_out_outwareid[LS_ROW]
LS_PRMSG.rowcnt = dw_child.RowCount()


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('ow_wfjg_out',printnum,dw_pageretr.object.ow_wfjg_out_scid[LS_ROW],dw_pageretr.object.ow_wfjg_out_outwareid[LS_ROW],'','',arg_msg,true)
end event

event ue_viewprint;call super::ue_viewprint;IF NOT f_power_ind(733) 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.ow_wfjg_out_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_wfjg_out_edit'
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.ow_wfjg_out_scid[LS_ROW]
LS_PRMSG.retr_pramnmb = dw_pageretr.Object.ow_wfjg_out_outwareid[LS_ROW]
LS_PRMSG.rowcnt = dw_child.rowcount()


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('ow_wfjg_out',printnum,dw_pageretr.Object.ow_wfjg_out_scid[LS_ROW],dw_pageretr.Object.ow_wfjg_out_outwareid[LS_ROW],'','',arg_msg,TRUE)

end event

event ue_f6;call super::ue_f6;IF NOT dw_edit_mode THEN RETURN
Long ls_mtrlid
s_unit s_inscust
IF sys_option_2unit <> 0 THEN 
	s_edit_index_tran s_tran_unit
	IF sys_option_2unit_ch = 1 THEN
		IF NOT IsValid(w_unit_ch) THEN
			IF dw_child.GetRow() < 1 THEN RETURN
			
			ls_mtrlid = dw_child.Object.ow_wfjgmx_out_mtrlid[dw_child.GetRow()]
			OpenWithParm(w_unit_ch,ls_mtrlid)
			s_inscust = Message.PowerObjectParm //接受返回结构
			
			IF s_inscust.unit <> '' THEN
				
				dw_child.Object.ow_wfjgmx_out_uunit[dw_child.GetRow()] = s_inscust.unit
				dw_child.Object.ow_wfjgmx_out_rate[dw_child.GetRow()] = s_inscust.rate
				IF  s_inscust.ReturnType = 0 THEN
					IF dw_child.Object.ow_wfjgmx_out_uqty[dw_child.GetRow()] > 0 THEN
						dw_child.Object.ow_wfjgmx_out_qty[dw_child.GetRow()] = Round(s_inscust.rate * dw_child.Object.ow_wfjgmx_out_uqty[dw_child.GetRow()],sys_option_unit_dec)
					END IF
				ELSE
					IF s_inscust.rate > 0 THEN
						dw_child.Object.ow_wfjgmx_out_uqty[dw_child.GetRow()] = Round(dw_child.Object.ow_wfjgmx_out_qty[dw_child.GetRow()] / s_inscust.rate , sys_option_unit_dec )
					END IF
				END IF
				
				dw_child.SetColumn( 'ow_wfjgmx_out_qty')
			END IF
			
		END IF
	ELSE
		IF NOT IsValid(w_unit_def_ch) THEN
			IF dw_child.GetRow() < 1 THEN RETURN
			Open(w_unit_def_ch)
			s_inscust = Message.PowerObjectParm //接受返回结构
			
			IF s_inscust.unit <> '' THEN
				dw_child.Object.ow_wfjgmx_out_uunit[dw_child.GetRow()] = s_inscust.unit
				dw_child.SetColumn( 'ow_wfjgmx_out_qty')
			END IF
			
		END IF
	END IF
ELSE
	IF NOT IsValid(w_unit_ch) THEN
		IF dw_child.GetRow() < 1 THEN RETURN
		dw_child.AcceptText()
		ls_mtrlid = dw_child.Object.ow_wfjgmx_out_mtrlid[dw_child.GetRow()]
		OpenWithParm(w_unit_ch,ls_mtrlid)
	
		s_inscust = Message.PowerObjectParm //接受返回结构
		
		IF s_inscust.unit <> '' THEN
			dw_child.Object.ow_wfjgmx_out_uunit[dw_child.GetRow()] = s_inscust.unit
			dw_child.Object.ow_wfjgmx_out_rate[dw_child.GetRow()] = s_inscust.rate
			IF  s_inscust.ReturnType = 0 THEN
					IF dw_child.Object.ow_wfjgmx_out_uqty[dw_child.GetRow()] > 0 THEN
						dw_child.Object.ow_wfjgmx_out_qty[dw_child.GetRow()] = Round(s_inscust.rate * dw_child.Object.ow_wfjgmx_out_uqty[dw_child.GetRow()],sys_option_unit_dec)
					END IF
				ELSE
					IF s_inscust.rate > 0 THEN
						dw_child.Object.ow_wfjgmx_out_uqty[dw_child.GetRow()] = Round(dw_child.Object.ow_wfjgmx_out_qty[dw_child.GetRow()] / s_inscust.rate , sys_option_unit_dec )
					END IF
				END IF
				
				dw_child.SetColumn( 'ow_wfjgmx_out_qty')
		END IF
			
	END IF
END IF



end event

type cb_func from w_publ_1ton_share_detail`cb_func within w_wfjg_out
end type

type cb_exit from w_publ_1ton_share_detail`cb_exit within w_wfjg_out
end type

type sle_usual_query from w_publ_1ton_share_detail`sle_usual_query within w_wfjg_out
integer x = 183
integer width = 549
end type

type cb_retrieveall from w_publ_1ton_share_detail`cb_retrieveall within w_wfjg_out
integer x = 3136
end type

type em_pagerowno from w_publ_1ton_share_detail`em_pagerowno within w_wfjg_out
integer x = 2811
integer y = 48
integer width = 320
end type

type dw_pageretr from w_publ_1ton_share_detail`dw_pageretr within w_wfjg_out
integer x = 2007
integer width = 1527
integer height = 860
string dataobject = "dw_wfjg_out_index"
end type

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

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

type cb_nextpage from w_publ_1ton_share_detail`cb_nextpage within w_wfjg_out
integer x = 3287
end type

type dw_uc from w_publ_1ton_share_detail`dw_uc within w_wfjg_out
integer width = 1998
integer height = 860
string dataobject = "dw_wfjg_out_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 ( ) = 'ow_wfjg_out_dscrp'  AND Key = KeyEnter! THEN
		dw_child.SetFocus()
		dw_child.ScrollToRow(1)
		dw_child.SetColumn ('ow_wfjgmx_out_ifrel')
		RETURN 1
	ELSEIF dw_uc.GetColumnName ( ) = 'u_spt_code' AND Key = KeyEnter! THEN
		String ls_code,ls_name,ls_find_code
		Long ls_sptid
		Long cnt = 0
		Boolean if_find = FALSE
		
		dw_uc.AcceptText()
		ls_code = Upper(Trim(dw_uc.Object.u_spt_code[dw_uc.GetRow()]))
		SELECT   u_spt.sptid,
			u_spt.name,
			u_spt.sptcode
			INTO	:ls_sptid,:ls_name,:ls_code
			FROM u_spt
			Where ( sptcode = :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_spt
				Where ( sptcode 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_spt.sptid,
					u_spt.sptcode,
					u_spt.name
					INTO	:ls_sptid,:ls_code,:ls_name
					FROM u_spt
					Where ( sptcode 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_child
			wf_change_sptid(ls_sptid)
			
			dw_uc.SetRedraw(FALSE)
			dw_uc.Object.ow_wfjg_out_sptid[dw_uc.GetRow()] = ls_sptid
			dw_uc.Object.u_spt_code[dw_uc.GetRow()] = ls_code
			dw_uc.Object.u_spt_name[dw_uc.GetRow()] = ls_name
			dw_uc.SetRedraw(TRUE)
			dw_uc.SetColumn("ow_wfjg_out_outdate")
			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::itemchanged;call super::itemchanged;IF NOT dw_edit_mode THEN RETURN
IF dwo.Name = 'u_outware_storageid' THEN
	dw_child.Reset()
	PARENT.TriggerEvent("insert_childrow")
END IF
end event

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

if row <= 0 then return

if dwo.name='p_p' then
	parent.TRIGGEREVENT('ue_f9')	
end if
end event

type gb_2 from w_publ_1ton_share_detail`gb_2 within w_wfjg_out
end type

type dw_child from w_publ_1ton_share_detail`dw_child within w_wfjg_out
integer y = 1152
integer height = 1024
string dataobject = "dw_wfjgmx_out_edit"
end type

event dw_child::dwnkey;call super::dwnkey;PARENT.TriggerEvent('user_key')
String ls_mtrlcode,ls_mtrlname,ls_unit,ls_mtrlmode
String ls_plancode,ls_status,ls_woodcode,ls_pcode
Long ls_mtrlid,ls_orderid
Dec ls_cost,ls_planprice,ls_lmbuyprice
string ls_mtrlsectype
string ls_zxmtrlmode

String ls_unit_buy,ls_unit_scll,ls_unit_sale
Decimal ld_rate_buy,ld_rate_scll,ld_rate_sale
Int li_wfjgunit,li_wfjgdec
long ld_rate,li_dec
s_mtrldef_array arg_s_mtrldef

Long child_row
Long ls_null
SetNull(ls_null)

Long ls_sptid

IF dw_edit_mode THEN
	dw_uc.AcceptText()
	dw_child.AcceptText()
	child_row = dw_child.GetRow()
	
	ls_orderid = dw_child.Object.ow_wfjgmx_out_relid[child_row]
	
	ls_sptid = dw_uc.Object.ow_wfjg_out_sptid[dw_uc.GetRow()]
	IF IsNull(ls_sptid) OR ls_sptid = 0 THEN
		THIS.TriggerEvent("ue_f10")
	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!) AND NOT KeyDown(KeyControl!) AND NOT KeyDown(KeyShift!) THEN
			IF dw_child.GetColumnName( ) = 'u_mtrldef_mtrlcode' THEN
				
				dw_child.AcceptText()
				child_row = dw_child.GetRow()
				IF dw_child.Object.ow_wfjgmx_out_ifrel[child_row] = 1 THEN
					PARENT.TriggerEvent('ue_f8')
					RETURN 1
				END IF	
	
				ls_mtrlcode = dw_child.Object.u_mtrldef_mtrlcode[child_row]
				IF f_find_mtrl(ls_mtrlcode, -1,arg_s_mtrldef) = 0 THEN
					PARENT.TriggerEvent('ue_f8')
					RETURN 1
				ELSE
					ls_mtrlid = arg_s_mtrldef.mtrlid[1]
					ls_mtrlcode = arg_s_mtrldef.mtrlcode[1]
					ls_mtrlname = arg_s_mtrldef.mtrlname[1]
					ls_unit = arg_s_mtrldef.unit[1]
					ls_mtrlmode = arg_s_mtrldef.mtrlmode[1]
					ls_planprice = arg_s_mtrldef.planprice[1]
					ls_lmbuyprice = arg_s_mtrldef.lmbuyprice[1]
					ls_mtrlsectype = arg_s_mtrldef.mtrlsectype[1]
					ls_zxmtrlmode = arg_s_mtrldef.zxmtrlmode[1]
					
					li_wfjgunit = arg_s_mtrldef.wfjgunit[1]
					ls_unit_buy = arg_s_mtrldef.unit_buy[1]
					ls_unit_scll = arg_s_mtrldef.unit_scll[1]
					ls_unit_sale = arg_s_mtrldef.unit_sale[1]
					ld_rate_buy = arg_s_mtrldef.rate_buy[1]
					ld_rate_scll = arg_s_mtrldef.rate_scll[1]
					ld_rate_sale = arg_s_mtrldef.rate_sale[1]
					li_wfjgdec = arg_s_mtrldef.wfjgdec[1]
				END IF
				
				IF li_wfjgunit = 0 THEN
					ls_unit = ls_unit
					ld_rate = 1
					li_dec = sys_option_unit_dec
				ELSEIF li_wfjgunit = 1 THEN
					ls_unit = ls_unit_buy
					ld_rate = ld_rate_buy
					li_dec = li_wfjgdec
				ELSEIF li_wfjgunit = 2 THEN
					ls_unit = ls_unit_scll
					ld_rate = ld_rate_scll
					li_dec = li_wfjgdec
				ELSEIF li_wfjgunit = 3 THEN
					ls_unit = ls_unit_sale
					ld_rate = ld_rate_sale
					li_dec = li_wfjgdec
				END IF
				
				//dw_child.Object.ow_wfjgmx_out_mtrlwareid[child_row] = ls_mtrlwareid
				dw_child.Object.ow_wfjgmx_out_mtrlid[child_row]    = ls_mtrlid
				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
				dw_child.Object.ow_wfjgmx_out_qty[child_row] = 0
				
				dw_child.Object.u_mtrldef_mtrlcode[child_row]    = ls_mtrlcode
				dw_child.Object.u_mtrldef_mtrlsectype[child_row] = ls_mtrlsectype
				dw_child.Object.u_mtrldef_zxmtrlmode[child_row] = ls_zxmtrlmode
				
				dw_child.Object.ow_wfjgmx_out_uunit[child_row] = ls_unit
				dw_child.Object.ow_wfjgmx_out_rate[child_row] = ld_rate
				
				IF dw_child.Object.ow_wfjgmx_out_uunit[child_row] = '' OR sys_option_2unit = 0 THEN
					dw_child.Object.ow_wfjgmx_out_uunit[child_row] = ls_unit
					dw_child.Object.ow_wfjgmx_out_rate[child_row] = 1
				END IF
				
				
				Decimal ls_1stnewcost,ls_1stzqrate,ls_1strate
				String arg_msg
				 
				IF cur_editfocus = 1 THEN
					ls_status=dw_child.Object.ow_wfjgmx_out_status[child_row]  
					ls_woodcode=dw_child.Object.ow_wfjgmx_out_woodcode[child_row]  
					ls_pcode=dw_child.Object.ow_wfjgmx_out_pcode[child_row]  
					IF uo_sptprice.uf_getmtrlsptprice(ls_sptid,ls_mtrlid,ls_unit,ls_status,ls_woodcode,ls_pcode,0,ls_1stnewcost,ls_1stzqrate,ls_1strate,arg_msg) <> 1 THEN
						IF ls_planprice = 0 THEN
							dw_child.Object.ow_wfjgmx_out_fprice[child_row]   = ls_lmbuyprice
						ELSE
							dw_child.Object.ow_wfjgmx_out_fprice[child_row]   = ls_planprice
						END IF
					ELSE
						dw_child.Object.ow_wfjgmx_out_fprice[child_row]		  = ls_1stnewcost
						dw_child.object.ow_wfjgmx_out_rebate[child_row]     = ls_1stzqrate
					END IF
				END IF
				
				IF Key = KeyEnter!  THEN //
					keybd_event ( 9, 0, 0 , 0 ) // 按下tab 
					keybd_event ( 9, 0, 2, 0 ) // 释放tab 	
					RETURN 1
				END IF
				
			ELSEIF  dw_child.GetColumnName( ) = 'ow_wfjgmx_out_rate' THEN
				dw_child.AcceptText()
				child_row = dw_child.GetRow()
				dw_child.Object.ow_wfjgmx_out_qty[child_row] = dw_child.Object.ow_wfjgmx_out_uqty[child_row] * dw_child.Object.ow_wfjgmx_out_rate[child_row]
				IF Key = KeyEnter!  THEN //
					keybd_event ( 9, 0, 0 , 0 ) // 按下tab 
					keybd_event ( 9, 0, 2, 0 ) // 释放tab 	
					RETURN 1
				END IF
			ELSEIF dw_child.GetColumnName( ) = 'ow_wfjgmx_out_uqty'  THEN
				dw_child.AcceptText()
				child_row = dw_child.GetRow()
				dw_child.Object.ow_wfjgmx_out_qty[child_row] = dw_child.Object.ow_wfjgmx_out_uqty[child_row] * dw_child.Object.ow_wfjgmx_out_rate[child_row]
				IF Key = KeyEnter!  THEN //
					keybd_event ( 9, 0, 0 , 0 ) // 按下tab 
					keybd_event ( 9, 0, 2, 0 ) // 释放tab 	
					RETURN 1
				END IF		
			
			
			ELSEIF dw_child.GetColumnName( ) = 'ow_wfjgmx_out_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;dw_child.AcceptText()
IF dw_edit_mode AND row > 0 THEN
	IF dwo.Name = 'ow_wfjgmx_out_uunit' THEN
		PARENT.TriggerEvent('ue_f6')
	ELSE
		PARENT.TriggerEvent('ue_f8')
	END IF
END IF
end event

event dw_child::itemchanged;call super::itemchanged;if not dw_edit_mode then return 
this.accepttext()
if  dwo.name = 'ow_wfjgmx_out_uqty' and sys_option_2unit = 0 then
	this.Object.ow_wfjgmx_out_qty[this.GetRow()] = Round(this.Object.ow_wfjgmx_out_rate[this.GetRow()] * this.Object.ow_wfjgmx_out_uqty[this.GetRow()],sys_option_unit_dec)
elseif dwo.name = 'ow_wfjgmx_out_qty' and sys_option_2unit = 0   and this.Object.ow_wfjgmx_out_rate[this.GetRow()]<>0 then
	this.Object.ow_wfjgmx_out_uqty[this.GetRow()] = Round(this.Object.ow_wfjgmx_out_qty[this.GetRow()]/this.Object.ow_wfjgmx_out_rate[this.GetRow()] ,sys_option_unit_dec)
end if
end event

type cb_viewprint from w_publ_1ton_share_detail`cb_viewprint within w_wfjg_out
end type

type cb_print from w_publ_1ton_share_detail`cb_print within w_wfjg_out
end type

type cb_add from w_publ_1ton_share_detail`cb_add within w_wfjg_out
end type

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

String arg_msg = ''
Long uc_row,i,j
Long relid_pageretr,reld_uc


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 dw_uc.Object.ow_wfjg_out_outdate[uc_row] > DateTime(2000-01-01,Now()) THEN
		MessageBox('提示','不合理发生时间',information!,OK!)
		dw_uc.SetFocus()
		dw_uc.SetColumn('u_outware_outdate')
		RETURN
	END IF
	IF NOT Len(String(dw_uc.Object.ow_wfjg_out_outrep[uc_row])) > 0 THEN
		MessageBox('提示','请填写经手人',information!,OK!)
		dw_uc.SetFocus()
		dw_uc.SetColumn('ow_wfjg_out_outrep')
		RETURN
	END IF
	
	FOR j = 1 TO dw_child.RowCount()
		IF dw_child.Object.ow_wfjgmx_out_qty[j] = 0 THEN CONTINUE
		
		IF NOT f_power_ind(125) AND dw_child.Object.ow_wfjgmx_out_ifrel[j] = 1 AND dw_child.Object.ow_wfjgmx_out_relid[j] = 0 THEN
			MessageBox('提示','用户权限限制,请选择外协订单,第'+string(j)+'行',information!,OK!)
			RETURN
		END IF
		
		IF NOT f_power_ind(125) AND dw_child.Object.ow_wfjgmx_out_ifrel[j] = 0 AND dw_child.Object.ow_wfjgmx_out_qty[j] > 0 THEN
			MessageBox('提示','用户权限限制,请选择外协订单,第'+string(j)+'行',information!,OK!)
			RETURN
		END IF
		
		IF dw_child.Object.ow_wfjgmx_out_mtrlwareid[j] > 0 AND dw_child.Object.ow_wfjgmx_out_qty[j] < 0 THEN
			MessageBox('提示','出仓单的数量一定要为正数',information!,OK!)
			RETURN
		END IF
	NEXT
	
	Long cnt
	IF sys_option_2unit_ch = 1 THEN
		cnt = 0
		FOR i = 1 TO dw_child.RowCount()
			IF dw_child.Object.ow_wfjgmx_out_rate[i] > 0  THEN
				IF dw_child.Object.ow_wfjgmx_out_qty[i] <> dw_child.Object.ow_wfjgmx_out_rate[i] *  dw_child.Object.ow_wfjgmx_out_uqty[i] THEN
					cnt++
					arg_msg = arg_msg + '第'+String(i)+'行,库存单位数量:'+String(dw_child.Object.ow_wfjgmx_out_qty[i],'#,##0.##########')+'计价单位数量:'+String(dw_child.Object.ow_wfjgmx_out_uqty[i],'#,##0.##########')+',转换率:'+String(dw_child.Object.ow_wfjgmx_out_rate[i],'#,##0.00##')+'~r~n'
				END IF
			END IF
		NEXT
		
		IF cnt > 0 THEN
			IF MessageBox('询问',arg_msg + '以上内容计价单位数量与库存单位数量不符合转换率,是否继续保存?',question!,yesno! ) = 2 THEN RETURN
		END IF
	END IF
	
	
	uo_ware.outdate = dw_uc.Object.ow_wfjg_out_outdate[uc_row]
	uo_ware.outrep  = dw_uc.Object.ow_wfjg_out_outrep[uc_row]
	uo_ware.dscrp   = dw_uc.Object.ow_wfjg_out_dscrp[uc_row]
	
	uo_ware.sptid   = dw_uc.Object.ow_wfjg_out_sptid[uc_row]
	uo_ware.part    = dw_uc.Object.ow_wfjg_out_part[uc_row]
	
	
	FOR i = 1 TO dw_child.RowCount()
		IF dw_child.Object.ow_wfjgmx_out_mtrlid[i] > 0 THEN
			IF uo_ware.acceptmx(dw_child.Object.ow_wfjgmx_out_mtrlwareid[i],&
				dw_child.Object.ow_wfjgmx_out_uqty[i],&
				dw_child.Object.ow_wfjgmx_out_uunit[i],&
				dw_child.Object.ow_wfjgmx_out_qty[i],&
				dw_child.Object.ow_wfjgmx_out_mxdscrp[i],&
				dw_child.Object.printid[i],&
				arg_msg,&
				dw_child.Object.ow_wfjgmx_out_ifrel[i],&
				dw_child.Object.ow_wfjgmx_out_relid[i],&
				0,&
				dw_child.Object.ow_wfjgmx_out_mtrlid[i],&
				dw_child.Object.ow_wfjgmx_out_storageid[i],&
				0,&
				dw_child.Object.ow_wfjgmx_out_plancode[i],&
				dw_child.Object.u_mtrldef_mtrlcode[i],&
				dw_child.Object.ow_wfjgmx_out_status[i],&
				dw_child.Object.ow_wfjgmx_out_woodcode[i],&
				dw_child.Object.ow_wfjgmx_out_pcode[i],&
				dw_child.Object.ow_wfjgmx_out_fprice[i],&
				dw_child.Object.ow_wfjgmx_out_rebate[i],&
				0,&
				dw_child.Object.ow_wfjgmx_out_rate[i],&
				dw_child.Object.ow_wfjgmx_out_jgdscrp[i],&
				dw_child.Object.ow_wfjgmx_out_mxdscrp2[i]) = 0 THEN
				MessageBox('错误',arg_msg,stopsign!,OK!)
				RETURN 
			END IF
		END IF
	NEXT
	
	IF uo_ware.Save(TRUE,arg_msg) = 0 THEN
		MessageBox('错误',arg_msg,stopsign!,OK!)
		RETURN
	END IF
	//	MessageBox(publ_operator,'保存操作成功!')
	f_SetProfileString (sys_empid,dw_uc.DataObject, "dft_outrep", String(dw_uc.Object.ow_wfjg_out_outrep[dw_uc.GetRow()]))
	
	
	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_ware.outwareid)
	
ELSE
	IF uo_ware.newbegin(cur_scid,5,arg_msg) = 0 THEN
		MessageBox('错误',arg_msg,stopsign!,OK!)
		RETURN
	END IF
END IF

CALL SUPER::Clicked

//read ini
IF dw_edit_mode THEN
	PARENT.TriggerEvent("insert_childrow")
	dw_uc.SetRedraw(FALSE)
	String ls_outrep
	ls_outrep = f_ProfileString (sys_empid,dw_uc.DataObject, "dft_outrep",'')
	dw_uc.Object.ow_wfjg_out_outrep[dw_uc.GetRow()] = publ_operator
	
	
	dw_uc.SetColumn("u_spt_code")
	dw_uc.SetRedraw(TRUE)
	cur_editfocus = 1
ELSE
	PARENT.TriggerEvent("retrieve_childdw")
	cur_editfocus = 0
END IF
//




end event

type cb_edit from w_publ_1ton_share_detail`cb_edit within w_wfjg_out
end type

event cb_edit::clicked;IF NOT f_power_ind(730)  THEN
	MessageBox('提示','你没有使用权限！',information!,OK!)
	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 not dw_edit_mode then
	if uo_ware.updatebegin(dw_pageretr.Object.ow_wfjg_out_scid[uc_row],dw_pageretr.object.ow_wfjg_out_outwareid[uc_row],5,arg_msg)=0 then
		messagebox('错误',arg_msg,stopsign!,OK!)
		return
	end if
end if

call super::clicked

if dw_edit_mode then
	cur_editfocus = 2
else
	cur_editfocus = 0
end if
end event

type cb_delet from w_publ_1ton_share_detail`cb_delet within w_wfjg_out
end type

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

if dw_edit_mode then return

string arg_msg=''
long uc_row

uc_row=dw_pageretr.getrow()
if uc_row<=0 then
	messagebox('提示','请选定当前目标单据!',information!,OK!)
	return
end if
IF MessageBox ("询问","是否确定要删除当前单据吗?",Question!,YesNo! ) = 2 THEN RETURN

if uo_ware.del(dw_pageretr.Object.ow_wfjg_out_scid[uc_row],dw_pageretr.object.ow_wfjg_out_outwareid[uc_row],arg_msg,true)=0 then
	messagebox('错误',arg_msg,stopsign!,OK!)
ELSE
	//日志
	long ls_id
	string ls_code
	ls_id=dw_pageretr.object.ow_wfjg_out_outwareid[uc_row]
	ls_code=dw_pageretr.object.ow_wfjg_out_outwarecode[uc_row]
	f_setsysoplog('车间外协出仓单','删除,ID:'+string(LS_id)+',code:'+ls_code,arg_msg,true)
	//--
	MESSAGEBOX('提示','删除单据'+string(dw_pageretr.object.ow_wfjg_out_outwarecode[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_wfjg_out
end type

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

menustr="Text=增加备注~tEvent=ue_addzy"
menustr=menustr + "|" + "Text=-"
menustr=menustr + "|" + "Text=复制单据~tEvent=ue_bill_copy"
menustr=menustr + "|" + "Text=粘贴单据~tEvent=ue_bill_paste"
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_wfjg_out
end type

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


if dw_edit_mode then return
string arg_msg=''
long pagerert_row

pagerert_row=dw_pageretr.getrow()
if pagerert_row<=0 then
	messagebox('提示','请选定当前目标单据!',information!,OK!)
	return
end if
IF MessageBox ("询问","是否确定要审核当前单据吗?",Question!,YesNo! ) = 2 THEN RETURN

if uo_ware.getinfo(dw_pageretr.Object.ow_wfjg_out_scid[pagerert_row],dw_pageretr.object.ow_wfjg_out_outwareid[pagerert_row],arg_msg)=0 then
	messagebox('错误',arg_msg,stopsign!,OK!)
	return
end if

if uo_ware.auditing(true,arg_msg)=0 then
	messagebox('错误',arg_msg,stopsign!,OK!)
ELSE
	messagebox('提示','审核成功!',information!,OK!)
	wf_refresh_curuc(dw_pageretr.Object.ow_wfjg_out_scid[pagerert_row],dw_pageretr.object.ow_wfjg_out_outwareid[pagerert_row])
end if
end event

type cb_xm from w_publ_1ton_share_detail`cb_xm within w_wfjg_out
end type

event cb_xm::clicked;m_Dfc_Control_PopupMenu dmPopupMenu
String menustr

menustr = "Text=增明细~tEvent=ue_addmx"
menustr = menustr + "|" + "Text=删明细~tEvent=ue_deletemx"
menustr = menustr + "|" + "Text=-"
menustr = menustr + "|" + "Text=按转换率计算库存数量~tEvent=ue_cmp_qty"
menustr = menustr + "|" + "Text=按转换率计算计价数量~tEvent=ue_cmp_uqty"
IF Trim(is_mx_menustr) <> '' THEN
	menustr = menustr + "|" + "Text=-"
	menustr = menustr + is_mx_menustr
END IF

if if_MtrlPicView then
	if Trim(menustr) <> "" then
		menustr = menustr + "|" + "Text=-"
		menustr = menustr + "|" + "Text=明细物料图片查看~tEvent=ue_MtrlPicView"
	else
		menustr = "Text=明细物料图片查看~tEvent=ue_MtrlPicView"
	end if
end if

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_retrieve from w_publ_1ton_share_detail`cb_retrieve within w_wfjg_out
end type

type cb_xls from w_publ_1ton_share_detail`cb_xls within w_wfjg_out
end type

type cb_help from w_publ_1ton_share_detail`cb_help within w_wfjg_out
end type

type cb_auditing_cancel from w_publ_1ton_share_detail`cb_auditing_cancel within w_wfjg_out
end type

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

IF dw_edit_mode THEN RETURN

String arg_msg = ''
Long pagerert_row

pagerert_row = dw_pageretr.GetRow()
IF pagerert_row <= 0 THEN
	MessageBox('提示','请选定当前目标单据!',information!,OK!)
	RETURN
END IF
IF MessageBox ("询问","是否确定要撤消审核当前单据吗?",Question!,YesNo! ) = 2 THEN RETURN

IF uo_ware.getinfo(dw_pageretr.Object.ow_wfjg_out_scid[pagerert_row],dw_pageretr.Object.ow_wfjg_out_outwareid[pagerert_row],arg_msg) = 0 THEN
	MessageBox('错误',arg_msg,stopsign!,OK!)
	RETURN
END IF

IF uo_ware.c_auditing(TRUE,arg_msg) = 0 THEN
	MessageBox('错误',arg_msg,stopsign!,OK!)
ELSE
	MessageBox('提示','撤消审核成功!',information!,OK!)
	//日志	
	String ls_code,ls_opemp,ls_outpart
	ls_code = dw_pageretr.Object.ow_wfjg_out_outwarecode[pagerert_row]
	ls_opemp = dw_pageretr.Object.ow_wfjg_out_opemp[pagerert_row]
	ls_outpart = dw_pageretr.Object.ow_wfjg_out_part[pagerert_row]
	f_setsysoplog('车间外协出仓单','撤审'+',code:'+ls_code+',相关号码:'+ls_outpart+',建立人:'+ls_opemp,arg_msg,TRUE)
	//--
	
	wf_refresh_curuc(dw_pageretr.Object.ow_wfjg_out_scid[pagerert_row],dw_pageretr.Object.ow_wfjg_out_outwareid[pagerert_row])
END IF

end event

type p_msg from w_publ_1ton_share_detail`p_msg within w_wfjg_out
end type

type p_help from w_publ_1ton_share_detail`p_help within w_wfjg_out
end type

type p_encl from w_publ_1ton_share_detail`p_encl within w_wfjg_out
end type

type p_other from w_publ_1ton_share_detail`p_other within w_wfjg_out
end type

type gb_3 from w_publ_1ton_share_detail`gb_3 within w_wfjg_out
end type

type ln_bar from w_publ_1ton_share_detail`ln_bar within w_wfjg_out
end type

type ln_bar2 from w_publ_1ton_share_detail`ln_bar2 within w_wfjg_out
end type

type r_bar from w_publ_1ton_share_detail`r_bar within w_wfjg_out
end type

type ln_1 from w_publ_1ton_share_detail`ln_1 within w_wfjg_out
end type

type ln_2 from w_publ_1ton_share_detail`ln_2 within w_wfjg_out
end type

type ddlb_status from dropdownlistbox within w_wfjg_out
integer x = 1687
integer y = 188
integer width = 549
integer height = 300
integer taborder = 30
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

type st_2 from statictext within w_wfjg_out
integer x = 1499
integer y = 204
integer width = 219
integer height = 48
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_3 from statictext within w_wfjg_out
integer x = 754
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_scid from uo_ddlb_scid within w_wfjg_out
integer x = 937
integer y = 188
integer width = 549
integer height = 1120
boolean bringtotop = true
end type

event constructor;call super::constructor;cur_scid=this.uo_scid
end event

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