Q5/ws_objects/Ew_price.pbl.src/w_spt_price_change.srw

$PBExportHeader$w_spt_price_change.srw
forward
global type w_spt_price_change from w_publ_1ton_share_detail
end type
type ddlb_status from dropdownlistbox within w_spt_price_change
end type
type ddlb_billtype from dropdownlistbox within w_spt_price_change
end type
type st_2 from statictext within w_spt_price_change
end type
type st_3 from statictext within w_spt_price_change
end type
end forward

global type w_spt_price_change from w_publ_1ton_share_detail
integer width = 3602
integer height = 2360
string title = "询价单"
boolean maxbox = true
windowstate windowstate = maximized!
event insert_childrow ( )
event ue_viewprint_2 ( )
event ue_fj_edit ( )
event ue_fj_view ( )
ddlb_status ddlb_status
ddlb_billtype ddlb_billtype
st_2 st_2
st_3 st_3
end type
global w_spt_price_change w_spt_price_change

type variables
uo_spt_price_change uo_price
uo_spt_price uo_sptprice
long cur_flag= -1
long cur_billtype = 2

uo_ljfieb uo_fieb


end variables

forward prototypes
public function integer wf_refresh_curuc (long arg_billid)
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_get_mx (long arg_scid, long arg_inwareid, ref s_inwaremx inwaremx[], ref long it_mxit)
public function integer wf_set_mx (long arg_scid, long arg_inwareid)
end prototypes

event insert_childrow();long li_row
li_row=dw_child.insertrow(0)
dw_child.scrolltorow(li_row)
dw_child.SetColumn ('u_mtrldef_mtrlcode')	
end event

event ue_viewprint_2();//IF NOT (f_power_ind(384) or f_power_ind(427)) 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
//
//DateTime firstdate,enddate,ld_billdate
//ld_billdate = dw_pageretr.Object.u_spt_price_change_billdate[LS_ROW]
//firstdate = DateTime(Date(String(ld_billdate,'yyyy-mm-dd')),Time(0))
//enddate = DateTime(Date(String(ld_billdate,'yyyy-mm-dd')),Time('23:59:59'))
//
//S_print_MSG LS_PRMSG
//
//LS_PRMSG.obj_dwNAME = 'dw_rp_spt_price_change_edit_hz_1'
//LS_PRMSG.TAG_TEXT = '调价单'
//LS_PRMSG.FILTER_STRING = ''
//LS_PRMSG.retr_pram_falg = 6
//LS_PRMSG.PAGECH_FLAG = 0
//LS_PRMSG.retr_pramfdt = firstdate
//LS_PRMSG.retr_pramedt = enddate
//OpenWithParm(w_publ_preview,LS_PRMSG)
//
//
//////**更新打印次料
//Long ll_billid[],i_mxt = 1,ll_i
//String arg_msg
//printnum = Message.DoubleParm
//
//DECLARE cur_price CURSOR FOR
//	SELECT u_spt_price_change.billid
//	FROM u_spt_price_change
//	WHERE billdate >= :firstdate
//	AND billdate <= :enddate;
//open 	cur_price;
//fetch cur_price into :ll_billid[i_mxt];
//do while sqlca.sqlcode = 0
//	i_mxt++
//	fetch cur_price into :ll_billid[i_mxt];
//loop
//i_mxt = i_mxt - 1
//close cur_price;
//
//
//if i_mxt > 0 then
//	for ll_i = 1 to i_mxt
//		f_update_printnum('u_spt_price_change',printnum,0,ll_billid[ll_i],'','',arg_msg,TRUE)
//	next
//end if
//
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_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 = 417 //采购订单的mainID
s_pic.f_string = dw_pageretr.Object.u_spt_price_change_billcode[ls_row]
s_pic.g_long = dw_pageretr.Object.u_spt_price_change_billid[ls_row]
s_pic.e_long = 0
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 = 417 //采购订单的mainID
s_pic.f_string = dw_pageretr.Object.u_spt_price_change_billcode[ls_row]
s_pic.g_long = dw_pageretr.Object.u_spt_price_change_billid[ls_row]
s_pic.e_long = 0
s_pic.sqltransaction = sys_filedb_sqlca

OpenWithParm(w_fj_bill_view,s_pic)



end event

public function integer wf_refresh_curuc (long arg_billid);//====================================================================
// Function: wf_refresh_curuc(arg_scid,arg_inbillid)
//--------------------------------------------------------------------
// Description: 刷新dw_uc
//--------------------------------------------------------------------
// Arguments: 
//		value	long	arg_scid    		
//		value	long	arg_inbillid		
//--------------------------------------------------------------------
// Returns:  integer
//--------------------------------------------------------------------
// Author:	yyx		Date: 2003.11.14
//--------------------------------------------------------------------
// Modify History: 
//	
//====================================================================
//wf_refresh_curuc
If arg_billid <= 0 Or IsNull(arg_billid) Then Return 0
Long uc_row
uc_row = dw_pageretr.GetRow()
If uc_row <= 0 Then Return 0

Long billid
String billcode
DateTime billdate
String dscrp
String sptname
String sptcode
Long sptid
long moneyid
Int flag

DateTime Auditdate ,Opdate ,moddate
String   Auditemp ,Opemp ,modemp
String inrep
Long billtype
DateTime sendtime
String senduser
Long sendcnt,ifecomm

Select u_spt_price_change.billid,
	u_spt_price_change.billcode,
	u_spt_price_change.billdate,
	u_spt_price_change.dscrp,
	u_spt_price_change.flag,
	u_spt_price_change.Auditemp,
	u_spt_price_change.Auditdate,
	u_spt_price_change.Opdate,
	u_spt_price_change.Opemp,
	u_spt_price_change.moddate,
	u_spt_price_change.modemp,
	u_spt.Name,
	u_spt.sptcode,
	u_spt_price_change.sptid,
	u_spt_price_change.inrep,
	u_spt_price_change.billtype,
	u_spt_price_change.moneyid,
	u_spt_price_change.senduser,
	u_spt_price_change.sendtime,
	u_spt_price_change.sendcnt,
	Case  u_spt.ifecomm when 0 Then 0 Else 1 End as   ifecomm
	Into :billid,
	:billcode,
	:billdate,
	:dscrp,
	:flag,
	:Auditemp,
	:Auditdate,
	:Opdate,
	:Opemp,
	:moddate,
	:modemp,
	:sptname,
	:sptcode,
	:sptid,
	:inrep,
	:billtype,
	:moneyid,
	:senduser,
	:sendtime,
	:sendcnt,
	:ifecomm
	From u_spt_price_change Inner JOIN
	u_spt On u_spt_price_change.sptid = u_spt.sptid
	Where u_spt_price_change.billid = :arg_billid;
If sqlca.SQLCode <> 0 Then
	MessageBox('错误',"查询操作失败(错误单据唯一码)",stopsign!,ok!)
	Return 0
End If

dw_pageretr.Object.u_spt_price_change_billid[uc_row] = arg_billid
dw_pageretr.Object.u_spt_price_change_Billcode[uc_row] = billcode
dw_pageretr.Object.u_spt_price_change_billdate[uc_row] = billdate
dw_pageretr.Object.u_spt_price_change_dscrp[uc_row] =  dscrp
dw_pageretr.Object.u_spt_price_change_flag[uc_row] =  flag
dw_pageretr.Object.u_spt_price_change_Auditemp[uc_row] =  Auditemp
dw_pageretr.Object.u_spt_price_change_Auditdate[uc_row] = Auditdate
dw_pageretr.Object.u_spt_price_change_Opdate[uc_row] =  Opdate
dw_pageretr.Object.u_spt_price_change_Opemp[uc_row] = Opemp
dw_pageretr.Object.u_spt_price_change_moddate[uc_row] = moddate
dw_pageretr.Object.u_spt_price_change_modemp[uc_row] = modemp
dw_pageretr.Object.u_spt_name[uc_row] = sptname
dw_pageretr.Object.u_spt_sptcode[uc_row] = sptcode
dw_pageretr.Object.u_spt_price_change_sptid[uc_row] = sptid
dw_pageretr.Object.u_spt_price_change_inrep[uc_row] = inrep
dw_pageretr.Object.u_spt_price_change_billtype[uc_row] = billtype
dw_pageretr.Object.u_spt_price_change_moneyid[uc_row] = moneyid
dw_pageretr.Object.u_spt_price_change_sendcnt[uc_row] = sendcnt
dw_pageretr.Object.u_spt_price_change_senduser[uc_row] = senduser
dw_pageretr.Object.u_spt_price_change_sendtime[uc_row] = sendtime
dw_pageretr.Object.ifecomm[uc_row] = ifecomm

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 subroutine wf_check_billfj ();String arg_msg
Long ll_ConnectionID
Long cur_billtype_fj
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_spt_price_change_billid[row]
	ll_scid = 0
	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_fj = 417 //客户投拆单的 mainiD

ls_uo_fjbt.uf_check_billfj( cur_billtype_fj, 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);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 = 0

//查询所选模版是否含有图片信息
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 = 417);
	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.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)
	
	IF ll_ifpic = 1 THEN
		IF arg_str_billlist.bill[i].datawindow  = 'dw_xls_saletaskmx' AND arg_str_billlist.bill[i].ds_data.RowCount() > 0 THEN //设置图片路径
			FOR ll_j = 1 TO arg_str_billlist.bill[i].ds_data.RowCount()
				arg_str_billlist.bill[i].ds_data.Object.pic[ll_j] = s_pic.path[ll_j]
			NEXT
		END IF
	END IF
NEXT


DESTROY ls_uo_fjbt
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_spt_price_change_flag[pagerert_row]=0 then
		cb_auditing.enabled=true
		cb_auditing_cancel.enabled=false
	elseif dw_pageretr.object.u_spt_price_change_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_get_mx (long arg_scid, long arg_inwareid, ref s_inwaremx inwaremx[], ref long it_mxit);long i
i = 1
//s_inwaremx  inwaremx[] 

////用游标读取明细
DECLARE cur_inwaermx CURSOR FOR
SELECT u_inwaremx.mtrlid, u_mtrldef.mtrlcode, u_mtrldef.mtrlname, u_mtrldef.mtrlmode, 
      u_inwaremx.unit,u_inwaremx.rate, u_inwaremx.status, u_inwaremx.woodcode, u_inwaremx.pcode, 
      u_inwaremx.uprice
FROM u_inwaremx INNER JOIN
      u_mtrldef ON u_inwaremx.mtrlid = u_mtrldef.mtrlid
	WHERE u_inwaremx.scid = :arg_scid AND
	u_inwaremx.inwareid = :arg_inwareid;
//	
OPEN cur_inwaermx;
FETCH cur_inwaermx INTO :inwaremx[i].mtrlid,:inwaremx[i].mtrlcode,:inwaremx[i].mtrlname,:inwaremx[i].mtrlmode,:inwaremx[i].unit,:inwaremx[i].rate,
	:inwaremx[i].status,:inwaremx[i].woodcode,:inwaremx[i].pcode,:inwaremx[i].uprice;

DO WHILE sqlca.SQLCode = 0
	i++
	FETCH cur_inwaermx INTO :inwaremx[i].mtrlid,:inwaremx[i].mtrlcode,:inwaremx[i].mtrlname,:inwaremx[i].mtrlmode,:inwaremx[i].unit,:inwaremx[i].rate,
	:inwaremx[i].status,:inwaremx[i].woodcode,:inwaremx[i].pcode,:inwaremx[i].uprice;
	
LOOP
CLOSE cur_inwaermx;

it_mxit = i - 1
return 1
end function

public function integer wf_set_mx (long arg_scid, long arg_inwareid);//采购收货单调用


Long child_row
Long ll_sptid
Long ls_j

ll_sptid = dw_uc.Object.u_spt_price_change_sptid [dw_uc.GetRow()]

dw_child.AcceptText()

s_inwaremx  inwaremx[]
Long it_mxbt = 0

wf_get_mx(arg_scid, arg_inwareid, inwaremx[], it_mxbt)


FOR ls_j = 1 To  it_mxbt
	IF inwaremx[ls_j].mtrlid > 0 THEN //正常返回值则可以取以下值
		IF dw_child.GetRow() > 0 THEN
			IF dw_child.Object.u_spt_price_changemx_mtrlid[dw_child.GetRow()] <> 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_spt_price_changemx_mtrlid[child_row] = inwaremx[ls_j].mtrlid
		dw_child.Object.u_mtrldef_mtrlcode [child_row]    = inwaremx[ls_j].mtrlcode
		dw_child.Object.u_mtrldef_mtrlname[child_row]    = inwaremx[ls_j].mtrlname
		dw_child.Object.u_mtrldef_mtrlmode [child_row]    = inwaremx[ls_j].mtrlmode
		dw_child.Object.u_mtrldef_unit[child_row] = inwaremx[ls_j].unit
		dw_child.Object.u_spt_price_changemx_status[child_row] = inwaremx[ls_j].status
		dw_child.Object.u_spt_price_changemx_woodcode[child_row] = inwaremx[ls_j].woodcode
		dw_child.Object.u_spt_price_changemx_pcode[child_row] = inwaremx[ls_j].pcode
		dw_child.Object.u_spt_price_changemx_price[child_row] = inwaremx[ls_j].uprice
		
		
		Decimal ls_1stnewcost,ls_1stzqrate,ls_1strate
		String arg_msg
		String ls_1stunit,ls_status,ls_woodcode,ls_pcode
		
		ls_1stunit = dw_child.Object.u_spt_price_changemx_unit[child_row]
		ls_status = dw_child.Object.u_spt_price_changemx_status[child_row]
		ls_woodcode = dw_child.Object.u_spt_price_changemx_woodcode[child_row]
		ls_pcode = dw_child.Object.u_spt_price_changemx_pcode[child_row]
		
		IF uo_sptprice.uf_getmtrlsptprice(ll_sptid,inwaremx[ls_j].mtrlid,ls_1stunit,ls_status,ls_woodcode,ls_pcode,0,ls_1stnewcost,ls_1stzqrate,ls_1strate,arg_msg) <> 1 THEN
			dw_child.Object.u_spt_price_changemx_lastprice[child_row]   = 0
			dw_child.Object.u_spt_price_changemx_unit[child_row] = inwaremx[ls_j].unit
			dw_child.Object.u_spt_price_changemx_rate[child_row] = inwaremx[ls_j].rate
		ELSE
			dw_child.Object.u_spt_price_changemx_lastprice[child_row]		  = ls_1stnewcost
			dw_child.Object.u_spt_price_changemx_rate[child_row]      = ls_1strate
			dw_child.Object.u_spt_price_changemx_unit[child_row]        = ls_1stunit
		END IF
		
	END IF
	
NEXT
dw_child.SetColumn('u_spt_price_changemx_unit')
dw_child.SetFocus()

RETURN 1


end function

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

on w_spt_price_change.destroy
call super::destroy
destroy(this.ddlb_status)
destroy(this.ddlb_billtype)
destroy(this.st_2)
destroy(this.st_3)
end on

event ue_f8;call super::ue_f8;
IF Not dw_edit_mode THEN RETURN
Long child_row
Long ll_sptid
child_row = dw_child.GetRow()
IF child_row = 0 THEN
	MessageBox('提示','请选定单据!',information!,ok!)
	RETURN
END IF

ll_sptid = dw_uc.Object.u_spt_price_change_sptid [dw_uc.GetRow()]

IF IsNull(ll_sptid) Or ll_sptid = 0 THEN
	This.TriggerEvent("ue_f9")
	ll_sptid = dw_uc.Object.u_spt_price_change_sptid [dw_uc.GetRow()]
	IF IsNull(ll_sptid) Or ll_sptid = 0 THEN RETURN
END IF

dw_child.AcceptText()

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 child_row > 0 THEN s_tranf8.arg_string_code = Trim(dw_child.Object.u_mtrldef_mtrlcode[child_row])
	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_spt_price_changemx_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_spt_price_changemx_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]
			
			
			Decimal ls_1stnewcost,ls_1stzqrate,ls_1strate
			String arg_msg
			String ls_1stunit,ls_status,ls_woodcode,ls_pcode
			
			ls_1stunit = dw_child.Object.u_spt_price_changemx_unit[child_row]
			ls_status = dw_child.Object.u_spt_price_changemx_status[child_row]
			ls_woodcode = dw_child.Object.u_spt_price_changemx_status[child_row]
			ls_pcode = dw_child.Object.u_spt_price_changemx_status[child_row]
			
			IF uo_sptprice.uf_getmtrlsptprice(ll_sptid,s_inscust.mtrlid[ls_j],ls_1stunit,ls_status,ls_woodcode,ls_pcode,0,ls_1stnewcost,ls_1stzqrate,ls_1strate,arg_msg) <> 1 THEN
				dw_child.Object.u_spt_price_changemx_lastprice[child_row]   = 0
				
				IF s_inscust.unit_buy[ls_j] = '' THEN
					dw_child.Object.u_spt_price_changemx_unit[child_row] = s_inscust.unit[ls_j]
					dw_child.Object.u_spt_price_changemx_rate[child_row] = 1
				ELSE
					dw_child.Object.u_spt_price_changemx_unit[child_row] = s_inscust.unit_buy[ls_j]
					dw_child.Object.u_spt_price_changemx_rate[child_row] = s_inscust.rate_buy[ls_j]
				END IF
			ELSE
				dw_child.Object.u_spt_price_changemx_lastprice[child_row]		  = ls_1stnewcost
				dw_child.Object.u_spt_price_changemx_rate[child_row]      = ls_1strate
				dw_child.Object.u_spt_price_changemx_unit[child_row]        = ls_1stunit
			END IF
			
			//3个属性默认值
			String ls_status_default,ls_woodcode_default,ls_pcode_default
			Long li_mtrlorigin
			SELECT Mtrlorigin Into :li_mtrlorigin From u_mtrldef Where mtrlid = :s_inscust.mtrlid[ls_j];
			IF li_mtrlorigin = 2 Then
				ls_status_default = ''
				ls_woodcode_default = ''
				ls_pcode_default = ''
				SELECT status_default,woodcode_default,pcode_default Into :ls_status_default,:ls_woodcode_default,:ls_pcode_default From u_mtrldef Where mtrlid = :s_inscust.mtrlid[ls_j];
				
				IF Len(ls_status_default) > 0 THEN
					dw_child.Object.u_spt_price_changemx_status[child_row]   = Trim(ls_status_default)
				END IF
				
				
				IF Len(ls_woodcode_default) > 0 THEN
					dw_child.Object.u_spt_price_changemx_woodcode[child_row]   = Trim(ls_woodcode_default)
				END IF
				
				
				IF Len(ls_pcode_default) > 0 THEN
					dw_child.Object.u_spt_price_changemx_pcode[child_row]   = Trim(ls_pcode_default)
				END IF
			END IF
			
			//自定义1、自定义2值
			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]
		END IF
		
	NEXT
	dw_child.SetColumn('u_spt_price_changemx_unit')
	dw_child.SetFocus()
END IF






end event

event ue_f10;call super::ue_f10;IF NOT IsValid(w_unit_ch) THEN
	IF dw_child.GetRow() < 1 THEN RETURN
	Long ls_mtrlid
	ls_mtrlid = dw_child.Object.u_spt_price_changemx_mtrlid[dw_child.GetRow()]
	
	OpenWithParm(w_unit_ch,ls_mtrlid)
	s_unit s_inscust
	s_inscust = Message.PowerObjectParm //接受返回结构
	
	IF s_inscust.unit <> '' THEN
		dw_child.Object.u_spt_price_changemx_unit[dw_child.GetRow()] = s_inscust.unit
		dw_child.Object.u_spt_price_changemx_rate[dw_child.GetRow()] = s_inscust.rate
	END IF
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.u_spt_price_change_billid[row]
	dw_child.SetRedraw (false)
	dw_child.retrieve(uc_relid)
	dw_child.SetRedraw (true)
else
	dw_child.reset()
end if

end event

event open;call super::open;uc_column_int = 7 //uc dw前7列可以编辑
child_column_int = 12  //子dw前8列可以编辑

uo_price = CREATE uo_spt_price_change
uo_price.commit_transaction = sqlca

uo_sptprice = create uo_spt_price


uo_fieb = Create uo_ljfieb
uo_fieb.commit_transaction = sys_email_sqlca
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= ls_querystrpart + "(u_spt_price_change.billcode like '%"+trim(sle_usual_query.text)+"%')"
	else
		ls_querystrpart=ls_querystrpart + "(u_spt_price_change.billcode 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_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+'( u_spt_price_change_billcode like "%'+trim(sle_usual_query.text)+'%" )'
	else
		obj_expr=obj_expr+'( u_spt_price_change_billcode 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 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_flag,cur_billtype,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


end event

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

event ue_viewprint;call super::ue_viewprint;IF NOT (f_power_ind(384) or f_power_ind(427)) 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_spt_price_change_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_spt_price_change_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 = 0
LS_PRMSG.retr_pramnmb = dw_pageretr.Object.u_spt_price_change_billid [LS_ROW]
LS_PRMSG.rowcnt = dw_child.RowCount()
OpenWithParm(w_publ_preview,LS_PRMSG)

//**更新打印次料
String arg_msg
printnum = Message.DoubleParm
f_update_printnum('u_spt_price_change',printnum,0,dw_pageretr.Object.u_spt_price_change_billid[LS_ROW],'','',arg_msg,TRUE)



end event

event refresh_interface;call super::refresh_interface;ddlb_status.enabled = not dw_edit_mode
ddlb_billtype.enabled = not dw_edit_mode
end event

event ue_f9;call super::ue_f9;
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()
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_sptcode[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_uc.SetRedraw(FALSE)
		dw_uc.Object.u_spt_price_change_sptid[uc_row] = S_INSCUST.sptid
		dw_uc.Object.u_spt_name[uc_row] = S_INSCUST.Name
		dw_uc.Object.u_spt_sptcode[uc_row] = S_INSCUST.sptcode
		
		dw_uc.SetRedraw(TRUE)
		dw_uc.SetColumn("u_spt_price_change_inrep")
		
	END IF
END IF


end event

event ue_addzy;call super::ue_addzy;IF dw_edit_mode THEN
	MessageBox('提示',"编辑状态下不可以使用!",information!,ok!)
	RETURN
END IF

IF Not (f_power_ind(785) OR f_power_ind(786)) THEN
	MessageBox('提示','你没有使用权限！',information!,ok!)
	RETURN
END IF

String arg_msg = ''
String 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_price.add_dscrp(dw_pageretr.Object.u_spt_price_change_billid[uc_row],ls_str,arg_msg) = 0 THEN
	MessageBox('错误',arg_msg,stopsign!,ok!)
	RETURN
ELSE
	MessageBox('提示','添加备注操作成功!',information!,ok!)
	wf_refresh_curuc(dw_pageretr.Object.u_spt_price_change_billid[uc_row])
END IF


end event

event ue_send_ljfieb;//IF Not f_power_ind(3164) THEN
//	MessageBox(publ_operator,sys_msg_pow)
//	RETURN
//END IF
//
IF dw_edit_mode THEN RETURN

IF  sys_email_sqlca.DBHandle() = 0  THEN
	MessageBox('Error','电子商务数据库连接失败,请检查')
	RETURN
END IF

IF MessageBox('询问','是否确认要发送单据给供应商?',question!,yesno!) = 2 THEN RETURN

Long ll_billid
String ls_billcode
Long ll_row
Int li_ifecomm
String arg_summary,arg_postscript,arg_remark
String arg_msg

ll_row  = dw_pageretr.GetRow()

IF ll_row <= 0 THEN
	MessageBox('系统提示','请选择要发送的单据')
	RETURN
END IF

ll_billid  = dw_pageretr.Object.u_spt_price_change_billid[ll_row]
ls_billcode = dw_pageretr.Object.u_spt_price_change_billcode[ll_row]

SELECT u_spt.ifecomm
	INTO :li_ifecomm
	FROM u_spt_price_change INNER JOIN
	u_spt ON u_spt_price_change.sptid = u_spt.sptid
	Where  u_spt_price_change.billid = :ll_billid Using sqlca;
IF sqlca.SQLCode <> 0 THEN
	MessageBox('Error','查询供应商询价单相关供应商通信信息失败,请检查设置,'+sqlca.SQLErrText)
	RETURN
END IF

IF li_ifecomm = 0 THEN
	MessageBox('系统提示','供应商没有使用电子商务,不能发送单据')
	RETURN
END IF

s_packet_ljfieb s_pack,s_return

OpenWithParm(w_dscrp_edit_ljfieb,s_pack)

s_return = Message.PowerObjectParm

IF s_return.returnflag <> 1 THEN RETURN

arg_summary = ''
arg_postscript = s_return.postscript
arg_remark = s_return.remark

IF uo_fieb.send_spt_price(ll_billid,arg_postscript,arg_remark,arg_msg,True) = 0 THEN
	MessageBox('Erorr',arg_msg)
	RETURN
END IF

UPDATE u_spt_price_change
	SET senduser = :publ_operator,
	sendtime = getdate(),
	sendcnt = sendcnt + 1
	Where billid = :ll_billid;
IF sqlca.SQLCode <> 0 THEN
	ROLLBACK Using sqlca;
	MessageBox('Error','更新发送次数失败,'+sqlca.SQLErrText)
	RETURN
ELSE
	COMMIT Using sqlca;
END IF

wf_refresh_curuc(ll_billid)

MessageBox('系统提示','提交成功!')





end event

event ue_jdview_ljfieb;long ll_row

ll_row = dw_pageretr.getrow()

if ll_row <= 0 then return

string ls_taskcode

ls_taskcode = dw_pageretr.object.u_spt_price_change_billcode[ll_row]

openwithparm(w_ljfieb_buytask_hisview,ls_taskcode)
end event

type cb_func from w_publ_1ton_share_detail`cb_func within w_spt_price_change
end type

type cb_exit from w_publ_1ton_share_detail`cb_exit within w_spt_price_change
end type

type sle_usual_query from w_publ_1ton_share_detail`sle_usual_query within w_spt_price_change
integer x = 183
integer y = 188
integer width = 480
end type

type cb_retrieveall from w_publ_1ton_share_detail`cb_retrieveall within w_spt_price_change
integer x = 2985
end type

type em_pagerowno from w_publ_1ton_share_detail`em_pagerowno within w_spt_price_change
integer width = 320
end type

type dw_pageretr from w_publ_1ton_share_detail`dw_pageretr within w_spt_price_change
integer x = 1929
integer y = 288
integer width = 1600
integer height = 1028
string dataobject = "dw_spt_price_change_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_spt_price_change
integer x = 0
integer y = 208
end type

type cb_nextpage from w_publ_1ton_share_detail`cb_nextpage within w_spt_price_change
integer x = 3136
end type

type dw_uc from w_publ_1ton_share_detail`dw_uc within w_spt_price_change
integer width = 1925
integer height = 1032
string dataobject = "dw_spt_price_change_edit"
end type

event dw_uc::dwnkey;PARENT.TriggerEvent('user_key')
IF Key = KeyDownArrow! THEN RETURN 1
IF dw_edit_mode THEN
	String ls_mtrlcode,ls_mtrlname,ls_mtrlmode
	String ls_sptcode,ls_sptname,ls_unit_buy,ls_unit
	Dec ls_rate
	Long ll_mtrlid,li_row,ll_sptid
	dw_uc.AcceptText()
	li_row = dw_uc.GetRow()
	
	IF	dw_uc.GetColumnName ( ) = 'u_spt_sptcode' AND Key = keyenter! THEN
		ls_sptcode = Trim(dw_uc.Object.u_spt_sptcode[li_row])
		SELECT sptid,Name INTO :ll_sptid,:ls_sptname FROM u_spt Where sptcode = :ls_sptcode;
		dw_uc.SetRedraw(FALSE)
		IF sqlca.SQLCode <> 0 THEN
			PARENT.TriggerEvent('ue_f9')
			RETURN 1
		ELSE
			dw_uc.Object.u_spt_price_change_sptid[li_row] = ll_sptid
			dw_uc.Object.u_spt_name[li_row] = ls_sptname
		END IF
		dw_uc.SetRedraw(TRUE)
		dw_uc.SetColumn("u_spt_price_change_inrep")
		RETURN 1
	ELSEIF	dw_uc.GetColumnName ( ) = 'u_spt_price_change_dscrp' AND Key = keyenter! THEN
		dw_child.SetFocus()
		dw_child.ScrollToRow(dw_child.RowCount())
		dw_child.SetColumn ('u_mtrldef_mtrlcode')
		RETURN 1
	ELSE
		IF  Key = keyenter!  OR Key = KeyDownArrow! THEN //
			keybd_event ( 9, 0, 0 , 0 ) // 按下tab 
			keybd_event ( 9, 0, 2, 0 ) // 释放tab 
			RETURN 1
		ELSEIF Key = keyuparrow! THEN
			keybd_event ( 16, 0, 0 , 0 )
			keybd_event ( 9, 0, 0 , 0 )
			keybd_event ( 9, 0, 2, 0 )
			keybd_event ( 16, 0, 2, 0 )
			RETURN 1
		END IF
	END IF
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_spt_price_change
end type

type dw_child from w_publ_1ton_share_detail`dw_child within w_spt_price_change
integer y = 1308
integer width = 3529
integer height = 928
string dataobject = "dw_spt_price_changemx_edit"
boolean controlmenu = true
boolean minbox = true
boolean resizable = false
end type

event dw_child::doubleclicked;IF dw_edit_mode AND row > 0   THEN
	CHOOSE CASE this.GetColumnName ( )
		CASE 'u_mtrldef_mtrlcode'
			PARENT.TriggerEvent('ue_f8')
		CASE  'u_spt_price_changemx_unit'
			PARENT.TriggerEvent('ue_f10')
	END CHOOSE
END IF



end event

event dw_child::dwnkey;call super::dwnkey;PARENT.TriggerEvent('user_key')

String ls_mtrlcode,ls_mtrlname,ls_mtrlmode
String ls_sptcode,ls_sptname,ls_unit_buy,ls_unit
Dec ls_rate
Long ll_mtrlid,li_row,ll_sptid

s_mtrldef_array arg_s_mtrldef

IF dw_edit_mode THEN
	
	dw_child.AcceptText()
	li_row = dw_child.GetRow()
	
	ll_sptid = dw_uc.Object.u_spt_price_change_sptid[dw_uc.GetRow()]
	IF IsNull(ll_sptid) OR ll_sptid = 0 THEN
		THIS.TriggerEvent("ue_f9")
	END IF
	
	IF KeyDown(KeyDownArrow!) THEN
		
		IF dw_child.GetRow() = dw_child.RowCount() THEN
			PARENT.TriggerEvent("insert_childrow")
			RETURN 1
		END IF
	ELSE
		
		IF dw_child.GetColumnName ( ) = 'u_mtrldef_mtrlcode' AND Key = keyenter! THEN
			ls_mtrlcode = Trim(dw_child.Object.u_mtrldef_mtrlcode[li_row])
			IF f_find_mtrl(ls_mtrlcode,-1,arg_s_mtrldef) = 0 THEN
				PARENT.TriggerEvent('ue_f8')
				RETURN 1
			ELSE
				ll_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_unit_buy = arg_s_mtrldef.unit_buy[1]
				ls_rate = arg_s_mtrldef.rate_buy[1]
			END IF
			
			dw_child.Object.u_spt_price_changemx_mtrlid[li_row] = ll_mtrlid
			dw_child.Object.u_mtrldef_mtrlname[li_row] = ls_mtrlname
			dw_child.Object.u_mtrldef_mtrlmode[li_row] = ls_mtrlmode
			dw_child.Object.u_mtrldef_unit[li_row] = ls_unit
			
			
			Decimal ls_1stnewcost,ls_1stzqrate,ls_1strate
			String arg_msg
			String ls_1stunit,ls_status,ls_woodcode,ls_pcode
			
			ls_1stunit = dw_child.Object.u_spt_price_changemx_unit[dw_child.GetRow()]
			ls_status = dw_child.Object.u_spt_price_changemx_status[dw_child.GetRow()]
			ls_woodcode = dw_child.Object.u_spt_price_changemx_woodcode[dw_child.GetRow()]
			ls_pcode = dw_child.Object.u_spt_price_changemx_pcode[dw_child.GetRow()]
			
			
			IF uo_sptprice.uf_getmtrlsptprice(ll_sptid,ll_mtrlid,ls_1stunit,ls_status,ls_woodcode,ls_pcode,0,ls_1stnewcost,ls_1stzqrate,ls_1strate,arg_msg) <> 1 THEN
				dw_child.Object.u_spt_price_changemx_lastprice[dw_child.GetRow()]   = 0
				
				IF ls_unit_buy = '' THEN
					dw_child.Object.u_spt_price_changemx_unit[dw_child.GetRow()] = ls_unit
					dw_child.Object.u_spt_price_changemx_rate[dw_child.GetRow()] = 1
				ELSE
					dw_child.Object.u_spt_price_changemx_unit[dw_child.GetRow()] = ls_unit_buy
					dw_child.Object.u_spt_price_changemx_rate[dw_child.GetRow()] = ls_rate
				END IF
				
				
			ELSE
				dw_child.Object.u_spt_price_changemx_lastprice[dw_child.GetRow()]		  = ls_1stnewcost
				dw_child.Object.u_spt_price_changemx_rate[dw_child.GetRow()]      = ls_1strate
				dw_child.Object.u_spt_price_changemx_unit[dw_child.GetRow()]        = ls_1stunit
			END IF
			
			//3个属性默认值
			
			String ls_status_default,ls_woodcode_default,ls_pcode_default
			Long li_mtrlorigin
			SELECT Mtrlorigin Into :li_mtrlorigin From u_mtrldef Where mtrlid = : arg_s_mtrldef.mtrlid[1];
			IF li_mtrlorigin = 2 Then
				
				ls_status_default = ''
				ls_woodcode_default = ''
				ls_pcode_default = ''
				SELECT status_default,woodcode_default,pcode_default Into :ls_status_default,:ls_woodcode_default,:ls_pcode_default From u_mtrldef Where mtrlid = : arg_s_mtrldef.mtrlid[1];
				
				IF Len(ls_status_default) > 0 THEN
					dw_child.Object.u_spt_price_changemx_status[dw_child.GetRow()]   = Trim(ls_status_default)
				END IF
				
				
				IF Len(ls_woodcode_default) > 0 THEN
					dw_child.Object.u_spt_price_changemx_woodcode[dw_child.GetRow()]   = Trim(ls_woodcode_default)
				END IF
				
				
				IF Len(ls_pcode_default) > 0 THEN
					dw_child.Object.u_spt_price_changemx_pcode[dw_child.GetRow()]   = Trim(ls_pcode_default)
				END IF
			END IF
			
			dw_child.SetRedraw(TRUE)
			dw_child.SetColumn("u_spt_price_changemx_unit")
			RETURN 1
		ELSEIF dw_child.GetColumnName( ) = 'u_spt_price_changemx_dscrp'  AND dw_child.GetRow() = dw_child.RowCount() and Key = keyenter! THEN
			PARENT.TriggerEvent("insert_childrow")
			RETURN 1
			
		ELSE
			IF  Key = keyenter!  OR Key = KeyDownArrow! THEN //
				keybd_event ( 9, 0, 0 , 0 ) // 按下tab 
				keybd_event ( 9, 0, 2, 0 ) // 释放tab 
				RETURN 1
			ELSEIF Key = keyuparrow! THEN
				keybd_event ( 16, 0, 0 , 0 )
				keybd_event ( 9, 0, 0 , 0 )
				keybd_event ( 9, 0, 2, 0 )
				keybd_event ( 16, 0, 2, 0 )
				RETURN 1
			END IF
		END IF
	END IF
END IF










end event

type cb_viewprint from w_publ_1ton_share_detail`cb_viewprint within w_spt_price_change
end type

type cb_print from w_publ_1ton_share_detail`cb_print within w_spt_price_change
end type

type cb_add from w_publ_1ton_share_detail`cb_add within w_spt_price_change
end type

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

String arg_msg = ''
Long uc_row,pagerert_row
Long relid_pageretr,reld_uc,j,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 dw_uc.Object.u_spt_price_change_billdate[uc_row] > DateTime(2000-01-01,Now()) THEN
		MessageBox('提示','不合理发生时间',information!,ok!)
		dw_uc.SetFocus()
		dw_uc.SetColumn("u_outware_outrep")
		RETURN
	END IF
	IF dw_uc.Object.u_spt_price_change_sptid[uc_row] = 0 THEN
		MessageBox('提示','请填写供应商',information!,ok!)
		dw_uc.SetFocus()
		dw_uc.SetColumn("u_spt_sptcode")
		RETURN
	END IF
	
	uo_price.billdate = dw_uc.Object.u_spt_price_change_billdate[uc_row] // 发生时间
	uo_price.sptid  = dw_uc.Object.u_spt_price_change_sptid[uc_row] // 供应商
	uo_price.dscrp  = dw_uc.Object.u_spt_price_change_dscrp[uc_row] //备注
	uo_price.billtype  = dw_uc.Object.u_spt_price_change_billtype[uc_row] //类型
	uo_price.inrep  = dw_uc.Object.u_spt_price_change_inrep[uc_row] //经手人
	uo_price.moneyid  = dw_uc.Object.u_spt_price_change_moneyid[uc_row] //币种
	
	
	FOR i = 1 To dw_child.RowCount()
		IF dw_child.Object.u_spt_price_changemx_mtrlid[i] > 0 THEN
			
			IF dw_child.Object.u_spt_price_changemx_unit[i] = '' THEN
				dw_child.Object.u_spt_price_changemx_unit[i] = dw_child.Object.u_mtrldef_unit[i]
				dw_child.Object.u_spt_price_changemx_rate[i] = 1
			END IF
			
			
			
			IF uo_price.acceptmx(i,&
				dw_child.Object.u_spt_price_changemx_mtrlid[i],&
				dw_child.Object.u_mtrldef_mtrlcode[i],&
				dw_child.Object.u_spt_price_changemx_unit[i],&
				dw_child.Object.u_spt_price_changemx_qty[i],&
				dw_child.Object.u_spt_price_changemx_price[i],&
				dw_child.Object.u_spt_price_changemx_rebate[i],&
				dw_child.Object.u_spt_price_changemx_rate[i],&
				dw_child.Object.u_spt_price_changemx_status[i],&
				dw_child.Object.u_spt_price_changemx_woodcode[i],&
				dw_child.Object.u_spt_price_changemx_pcode[i],&
				dw_child.Object.u_spt_price_changemx_sptmtrlname[i],&
				dw_child.Object.u_spt_price_changemx_dscrp[i],&
				arg_msg) = 0 THEN
				MessageBox('错误',arg_msg,stopsign!,ok!)
				RETURN
			END IF
		END IF
	NEXT
	
	IF uo_price.Save(arg_msg,True) = 0 THEN
		MessageBox('错误',arg_msg,stopsign!,ok!)
		RETURN
	END IF
	//MessageBox('提示','保存操作成功!',information!,ok!)
	f_SetProfileString (sys_empid,publ_userid+'_'+dw_uc.DataObject, "moneyid",String(dw_uc.Object.u_spt_price_change_moneyid[uc_row]))
	
	Long ll_row
	ll_row = dw_pageretr.GetRow()
	dw_pageretr.SelectRow(0,False)
	dw_pageretr.SelectRow(ll_row,True)
	wf_refresh_curuc(uo_price.billid) //刷新uc	
ELSE
	IF uo_price.newbegin() = 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_moneyid
	ls_moneyid = f_ProfileString (sys_empid,publ_userid+'_'+dw_uc.DataObject, "moneyid",'11')
	dw_uc.Object.u_spt_price_change_moneyid[dw_uc.GetRow()] = Long(ls_moneyid)
	dw_uc.SetColumn("u_spt_price_change_billtype")
	dw_uc.SetRedraw(True)
ELSE
	Parent.TriggerEvent("retrieve_childdw")
END IF
//







end event

type cb_edit from w_publ_1ton_share_detail`cb_edit within w_spt_price_change
end type

event cb_edit::clicked;
if not (f_power_ind(114) or f_power_ind(425)) then
	messagebox('提示','你没有使用权限！',information!,ok!)
	return
end if

String arg_msg = ''
Long uc_row

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

IF NOT dw_edit_mode THEN
	IF uo_price.updatebegin(dw_uc.Object.u_spt_price_change_billid[uc_row],arg_msg) = 0 THEN
		MessageBox('错误',arg_msg,stopsign!,ok!)
		RETURN
	END IF
END IF

CALL SUPER::Clicked
THIS.TriggerEvent('refresh_interface')

end event

type cb_delet from w_publ_1ton_share_detail`cb_delet within w_spt_price_change
end type

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

IF dw_edit_mode THEN RETURN
IF MessageBox ("询问","是否确定要删除当前单据吗?",Question!,YesNo! ) = 2 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 uo_price.del(dw_pageretr.Object.u_spt_price_change_billid[uc_row],TRUE,arg_msg) = 0 THEN
	MessageBox('错误',arg_msg,stopsign!,ok!)
ELSE
	//日志
	Long ls_id
	String ls_code
	ls_id = dw_pageretr.Object.u_spt_price_change_billid[uc_row]
	ls_code = dw_pageretr.Object.u_spt_price_change_billcode[uc_row]
	f_setsysoplog('单价调整单','单价调整单删除,id:'+String(ls_id)+',code:'+ls_code,arg_msg,TRUE)
	//--
	
	MessageBox('提示','删除单据'+String(ls_code)+'成功!',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_spt_price_change
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_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_spt_price_change
end type

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

String err_msg = ''
Long l_billid

String arg_msg = ''
Long pagerert_row

IF dw_edit_mode THEN RETURN

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_price.getinfo(dw_pageretr.object.u_spt_price_change_billid[pagerert_row],arg_msg)=0 then
	messagebox('错误',arg_msg,stopsign!,ok!)
	return
end if

if uo_price.auditing(true,arg_msg)=0 then
	messagebox('错误',arg_msg,stopsign!,ok!)
else
	messagebox('提示','审核成功!',information!,ok!)
	wf_refresh_curuc(dw_pageretr.object.u_spt_price_change_billid[pagerert_row])
end if
end event

type cb_xm from w_publ_1ton_share_detail`cb_xm within w_spt_price_change
end type

event cb_xm::clicked;call super::clicked;//
//is_mx_menustr = ''
//IF dw_edit_mode THEN
//	is_mx_menustr += "|" + "Text=导入设定购价~tEvent=ue_p_uprice_set"
//	is_mx_menustr += "|" + "Text=导入最新价~tEvent=ue_p_tax"
//END IF
//CALL Super::Clicked
//

end event

type cb_retrieve from w_publ_1ton_share_detail`cb_retrieve within w_spt_price_change
end type

type cb_xls from w_publ_1ton_share_detail`cb_xls within w_spt_price_change
end type

type cb_help from w_publ_1ton_share_detail`cb_help within w_spt_price_change
end type

type cb_auditing_cancel from w_publ_1ton_share_detail`cb_auditing_cancel within w_spt_price_change
end type

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

String err_msg = ''
Long l_billid

l_billid = dw_pageretr.Object.u_spt_price_change_billid[dw_pageretr.GetRow()]
IF dw_edit_mode THEN RETURN

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

Long pagerert_row
String arg_msg

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

IF uo_price.getinfo(dw_pageretr.Object.u_spt_price_change_billid [pagerert_row],arg_msg) = 0 THEN
	MessageBox('错误',arg_msg,stopsign!,ok!)
	RETURN
END IF

IF dw_pageretr.Object.u_spt_price_change_flag[pagerert_row] = 1 THEN
	IF uo_price.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.u_spt_price_change_billcode[pagerert_row]
		ls_opemp = dw_pageretr.Object.u_spt_price_change_opemp[pagerert_row]
		f_setsysoplog('调价单','撤审'+',code:'+ls_code+',相关号码:'+ls_outpart+',建立人:'+ls_opemp,arg_msg,TRUE)
		//--
		wf_refresh_curuc(dw_pageretr.Object.u_spt_price_change_billid[pagerert_row])
	END IF
END IF
end event

type p_msg from w_publ_1ton_share_detail`p_msg within w_spt_price_change
end type

type p_help from w_publ_1ton_share_detail`p_help within w_spt_price_change
end type

type p_encl from w_publ_1ton_share_detail`p_encl within w_spt_price_change
end type

type p_other from w_publ_1ton_share_detail`p_other within w_spt_price_change
end type

type gb_3 from w_publ_1ton_share_detail`gb_3 within w_spt_price_change
end type

type ln_bar from w_publ_1ton_share_detail`ln_bar within w_spt_price_change
end type

type ln_bar2 from w_publ_1ton_share_detail`ln_bar2 within w_spt_price_change
end type

type r_bar from w_publ_1ton_share_detail`r_bar within w_spt_price_change
end type

type ln_1 from w_publ_1ton_share_detail`ln_1 within w_spt_price_change
end type

type ln_2 from w_publ_1ton_share_detail`ln_2 within w_spt_price_change
end type

type ddlb_status from dropdownlistbox within w_spt_price_change
integer x = 1696
integer y = 192
integer width = 421
integer height = 300
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

type ddlb_billtype from dropdownlistbox within w_spt_price_change
integer x = 933
integer y = 192
integer width = 480
integer height = 300
integer taborder = 60
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 this.text = '调价单' then
	cur_billtype = 1 
elseif this.text = '报价单' then
	cur_billtype = 2
else
	cur_billtype = -1
end if

parent.triggerevent('retrieve_pageretr')
	
end event

type st_2 from statictext within w_spt_price_change
integer x = 750
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_spt_price_change
integer x = 1527
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