edit.asp

功能齐全的oa系统

<% option explicit%>
<!-- #include virtual="include/DataEnvi.asp" -->
<!-- #include virtual="Include/Page.asp" -->
<!-- #include virtual="include/String.asp" -->
<%
	
	Dim C,conn
	Dim IntID
	Dim ObjRS,ObjRSMod,ModStr,Mark
	
	IntID = Request.QueryString("ID")
	if Cint(IntID)=0 Then
    	Response.Write "<script language=javascript>alert('请选择采购记录');history.back();</script>"
    	Response.End
    End if
	Set conn=Server.CreateObject("ADODB.Connection")
	OpenDBCrm( conn )
	Set C = Server.CreateObject ("CMS2003.DBhandle")
	C.Init(conn)

	If Request.Form.Count > 0 Then
		IntID = Request.Form("ID")
		If Trim(Request.Form("_Pro_name"))="" then
			Response.Write "<script language=javascript>alert('请填写商品名称');history.back();</script>"
    			Response.End
  		End if
  		If Trim(Request.Form("_Pro_man"))="" then
			Response.Write "<script language=javascript>alert('请填写经办人');history.back();</script>"
    			Response.End
  		End if
  		If Trim(Request.Form("_Sell_man"))="" then
			Response.Write "<script language=javascript>alert('请填写经销商');history.back();</script>"
    			Response.End
  		End if
         
		Set ObjRSMod = C.View("Select * From T_CRM_Stock Where ID = " & IntID)
		
		Mark=False
'---------------------------------------------------------------------------------------------
'修改过的字段在日志当中进行记录
		If ObjRSMod("Pro_name")<>Request("_Pro_name") Then
			ModStr=ModStr&"产品名称 修改前："&ObjRSMod("Pro_name")&"修改后:"&Request("_Pro_name")
			Mark=True
		End if

        If ObjRSMod("Pro_price")<>Request("_Pro_price") Then
			ModStr=ModStr&"产品单价 修改前："&ObjRSMod("Pro_price")&"修改后:"&Request("_Pro_price")
			Mark=True
		End if
        
		If ObjRSMod("Pro_num")<>Request("_Pro_num") Then
			ModStr=ModStr&"采购数量 修改前："&ObjRSMod("Pro_num")&"修改后:"&Request("_Pro_num")
			Mark=True
		End if
        
		If ObjRSMod("Pro_man")<>Request("_Pro_man") Then
			ModStr=ModStr&"经办人 修改前："&ObjRSMod("Pro_man")&"修改后:"&Request("_Pro_man")
			Mark=True
		End if

		If ObjRSMod("Sell_man")<>Request("_Sell_man") Then
			ModStr=ModStr&"经销商 修改前："&ObjRSMod("Sell_man")&"修改后:"&Request("_Sell_man")
			Mark=True
		End if

		If ObjRSMod("Discount")<>Request("_Discount") Then
			ModStr=ModStr&"折扣 修改前："&ObjRSMod("Discount")&"修改后:"&Request("_Discount")
			Mark=True
		End if

'--------------------------------------------------------------------------

		Call C.Edit(IntID,"_","T_CRM_Stock")
		if Mark Then
           conn.Execute("insert into T_CRM_ViewLog (FirstMenu,SecondMenu,Operation,OpeTime,OpePeople,OpeIP,OpeDesc,ChangeString) values ('采购管理','采购记录','修改','"&Now()&"','"&session("AccountID")&"','"&Request.ServerVariables("REMOTE_ADDR")&"','"&FixSQL(Request("OpeDesc"))&"','"&FixSQL(ModStr)&"')")
        End if
	    conn.Close
     	Set conn = Nothing
     	Response.Redirect "list.asp"   
	End If

	Set ObjRS = C.View("Select * From T_CRM_Stock Where ID = " & IntID)
   	conn.Close
	Set conn = Nothing
%>



<%'==================================================================%>
<%Sub Main%>
<%'------------------------------------------------------------------%>

	
	<form action="" method="post" onsubmit="return(CheckForm(this))" id=form1 name=form1>
	<input type=hidden name=ID value="<%=Request.QueryString("ID")%>">
   <table class=Ltable cellspacing=1 cellpadding=3>
	<tr class=LHtr align="middle">
		<td width="15%">采购基本信息</td>
		<td width="85%"> </td>
	</tr>
	<tr class=Ltr>
		<td>产品名称</td>
		<td><input type="text"  Check=0 Show="产品名称" name="_Pro_name" value="<%=ObjRS("Pro_name")%>"></td>
	</tr>
	
	<tr class=Ltr>
		<td>规格型号</td>
		<td><input type="text"  Check=0 Show="规格型号" name="_Pro_con" value="<%=ObjRS("Pro_con")%>"></td>
	</tr>

	<tr class=Ltr>
		<td>产品单价</td>
		<td><input type="text"  Check=0 Show="产品单价" name="_Pro_price" value="<%=ObjRS("Pro_price")%>"></td>
	</tr>
	
	<tr class=Ltr>
		<td>采购数量</td>
		<td><input type="text"  Check=0 Show="采购数量" name="_Pro_num" value="<%=ObjRS("Pro_num")%>"></td>
	</tr>

	<tr class=Ltr>
		<td>经办人</td>
		<td><input type="text" Check=0 Show="经办人" name="_Pro_man" value="<%=ObjRS("Pro_man")%>"></td>
	</tr>
	

	<tr class=Ltr>
		<td>经销商</td>
		<td><input type="text" Check=0 Show="经销商" name="_Sell_man" value="<%=ObjRS("Sell_man")%>"></td>
	</tr>
	</table>
  	<table id=MoreInfo class=Ltable cellspacing=1 cellpadding=3>
  	<tr class=LStr>
	<td width="15%">修改采购详细信息</td>
	<td width="85%" colspan=3> </td>
  	</tr>
	<tr class=Ltr>
		<td>合同序号</td>
		<td><input type="text" class=Input Check=0 Show="合同序号" name="_Bargain_num" value="<%=ObjRS("Bargain_num")%>"></td>
	
		<td>编号</td>
		<td><input type="text" Check=0 Show="编号" name="_Number" value="<%=ObjRS("Number")%>"></td>
	</tr>
	<tr class=Ltr>
		<td>外包装</td>
		<td><input type="text" Check=0 Show="外包装" name="_Out_pack" value="<%=ObjRS("Out_pack")%>"></td>
	
		<td>有无合格证</td>
		<td><input type="text" Check=0 Show="有无合格证" maxlength="4" name="_Eligibility" value="<%=ObjRS("Eligibility")%>"></td>
	</tr>
	<tr class=Ltr>
		<td>到货日期</td>
		<td><input type="text" onclick="InputDate(this)" readonly class=Input Check=0 Show="到货日期" name="_Selldate" value="<%=ObjRS("Selldate")%>"></td>
	
		<td>折扣</td>
		<td><input type="text" Check=0 Show="折扣" name="_Discount" value="<%=ObjRS("Discount")%>"></td>
	</tr>
	<tr class=Ltr>
		<td>检验结果</td>
		<td colspan=3><textarea cols="40" rows="3"  Check=0 Show="检验结果" name="_Test"><%=ObjRS("Test")%></textarea></td>
	</tr>	
	<tr class=Ltr>
		<td>备注</td>
		<td colspan=3><textarea cols="40" rows="3" Check=0 Show="备注" name="_Remark"><%=ObjRS("Remark")%></textarea></td>
	</tr>
	  <tr class=Ltr>
		<td>修改原因：</td>
		<td colspan=3><textarea cols="40" rows="3" class=Input Check=0 Show="修改原因" name="OpeDesc"></textarea></td>
  </tr>
	</table>
  <table cellspacing=1 cellpadding=3>
  <tr>
		<td>
		<input type="submit"  name="Submit" class=Button value="提 交"><input type="button" class=Button value="取 消" onclick="doList()" id=button1 name=button1></td>
		<td></td>
  </tr>

	</table>
	</FORM>
<%
End Sub
%>
<!-- #include virtual="templet\templet.asp" -->