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 ObjDB,ObjRS,ObjRSFile,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("_B_text"))="" then
			Response.Write "<script language=javascript>alert('请填写合同简述');history.back();</script>"
    			Response.End
  		End if
		Set ObjRSMod = C.View("Select B_text,B_jia From T_CRM_Bargain Where ID = " & IntID)
		
		Mark=False
		If ObjRSMod("B_text")<>Request("_B_text") Then
			ModStr=ModStr&"合同简介 修改前："&ObjRSMod("B_text")&"修改后:"&Request("_B_text")
			Mark=True
		End if


		Call C.Edit(IntID,"_","T_CRM_Bargain")

        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_Bargain Where ID = " & IntID)
	
	'------------------------------------------------------------------------------
	'保留T_crm_Bargain中的记录号，以便在添加附件时同时对OA库中的t_oa_Attach表和Kingcrm库中的t_crm_Bargain表进行操作
	Session("t_crm_Bargain_id")=IntID

	'------------------------------------------------------------------------------
	
	Set ObjDB = Server.CreateObject("ADODB.Connection")
	OpenDB objDB	
	conn.Close
	Set conn = Nothing

'显示附件的函数
Function ShowAttachs(ObjDB,Attachs)
  Dim ObjRSFile,StrSQL
  Dim AttachIDs
  Dim StrTmp
  If IsNull(Attachs) Then Attachs = ""
  If Attachs = "" Then
    ShowAttachs = "<无附件>"
    Exit Function
  End If
  AttachIDs = "'" & Replace(Attachs,",","','") & "'"
  StrSQL = "Select * From t_OA_Attach Where KeyPath In (" & AttachIDs & ")"
  Set ObjRSFile = ObjDB.Execute(StrSQL)
  StrTmp = "<select name=ALLATTACHS style='width:238px;'>"
  While Not ObjRSFile.Eof
    StrTmp = StrTmp & "<option value=" & ObjRSFile("KeyPath") & ">" & ObjRSFile("FileName") & "</option>"
    ObjRSFile.MoveNext
  Wend
  StrTmp = StrTmp & "</select>"
  StrTmp = StrTmp & "<input value='查 &nbsp;&nbsp;&nbsp;看' class=button type=button onclick=" & Chr(34) & "window.open('" & Application("RootPath") & "crm/Attach/View.asp?ID='+ALLATTACHS.value)" & Chr(34) & ">"
  ShowAttachs = StrTmp
End Function 
	
%>
<Script language=javascript>  
	function EditAttach()
	{
  	var r =window.showModalDialog("../../crm/Attach/Index.asp?IDs=" + document.forms[0].Attachs.value + "&BasePath=Bargain&R=" + Math.random(),"AttachWin","dialogHeight=240px,dialogWidth=420px,resizable=No,status=1,scrollbars=1");
  	if(r!=null)
  	{
  		ReturnAttachs(r)
  	}
	}

	function ReturnAttachs(v)
	{
  	document.forms[0].AttachsShow.value = v[0]
  	document.forms[0].Attachs.value = v[1]
	}
</Script>


<%'==================================================================%>
<%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=LStr>
    <td width="15%">修改合同信息</td>
    <td width="85%" colspan=3> </td>
  </tr>
  <tr class=Ltr>
    <td>项目名称</td>
    <td><input type="text" class=Input Check=1 Show="项目名称" name="_ProName" value="<%=ObjRS("ProName")%>"></td>
    <td>合同号</td>
    <td><input type="text" class=Input Check=1 Show="合同号" name="_B_hao" value="<%=ObjRS("B_hao")%>"></td>
  </tr>
  <tr class=Ltr>
    <td>编号</td>
    <td><input type="text" class=Input Check=1 Show="编号" name="_B_number" value="<%=ObjRS("B_number")%>"></td>
    <td>合同简述</td>
    <td><input type="text" class=Input Check=1 Show="合同简述" name="_B_text" value="<%=ObjRS("B_text")%>"></td>
  </tr>
  <tr class=Ltr>
    <td>甲方</td>
    <td><input type="text" class=Input Check=0 Show="甲方" name="_B_jia" value="<%=ObjRS("B_jia")%>"></td>
    <td>乙方</td>
    <td><input type="text" class=Input Check=0 Show="乙方" name="_B_yi" value="<%=ObjRS("B_yi")%>"></td>
  </tr>
  <tr class=Ltr>
    <td>签署日期</td>
    <td><input type="text" class=Input Check=0 Show="签署日期" onclick="InputDate(this)" readonly name="_B_start" value="<%=ObjRS("B_start")%>"></td>
     <td>合同期限</td>
     <td><input type="text" class=Input Check=0 Show="合同期限" name="_B_time" value="<%=ObjRS("B_time")%>"></td>
  </tr>
  <tr class=Ltr>
    <td>签署地点</td>
    <td><input type="text" class=Input Check=0 Show="签署地点" name="_B_address" value="<%=ObjRS("B_address")%>"></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <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="_B_jia_commissary" value="<%=ObjRS("B_jia_commissary")%>"></td>
    <td>乙方代表</td>
    <td><input type="text" class=Input Check=0 Show="乙方代表" name="_B_yi_commissary" value="<%=ObjRS("B_yi_commissary")%>"></td> 
  </tr>
  <tr class=Ltr>
    <td>甲方地址</td>
    <td><input type="text" class=Input Check=0 Show="甲方地址" name="_B_jia_address" value="<%=ObjRS("B_jia_address")%>"></td>
    <td>乙方地址</td>
    <td><input type="text" class=Input Check=0 Show="乙方地址" name="_B_yi_address"  value="<%=ObjRS("B_yi_address")%>"></td>
  </tr>
  <tr class=Ltr>
     <td>甲方电话</td>
     <td><input type="text" class=Input Check=0 Show="甲方电话" name="_B_jia_phone" value="<%=ObjRS("B_jia_phone")%>"></td>
     <td>乙方电话</td>
     <td><input type="text" class=Input Check=0 Show="乙方电话" name="_B_yi_phone" value="<%=ObjRS("B_yi_phone")%>"></td>
  </tr>
  <tr class=Ltr>
     <td>执行状态</td>
     <td><input type="text" class=Input Check=0 Show="执行状态" name="_B_state"  value="<%=ObjRS("B_state")%>"></td>
     <td>附件</td>
  <td><%=ShowAttachs(ObjDB,ObjRS("Attachs"))%><input name=Attachs type=hidden class=Input value="<%=ObjRS("Attachs")%>"><input type=button value="编辑附件" class=button onclick="EditAttach()" id=button3 name=button3>
  </tr>
  <tr class=Ltr>
		<td>备注</td>
		<td colspan=3><textarea rows="3" cols="40" class=Input Check=0 Show="备注" name="_Remark"><%=ObjRS("Remark")%></textarea></td>
  </tr>
  <tr class=Ltr>
		<td>修改原因：</td>
		<td colspan=3><textarea rows="3" cols="40" 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>
	


<%'------------------------------------------------------------------%>
<%
	ObjDB.Close
	Set ObjDB=Nothing
	End Sub%>
<%'==================================================================%>

<!-- #include virtual="templet\templet.asp" -->