linkman_add.asp

来自「适用于网络/信息企业」· ASP 代码 · 共 179 行

ASP
179
字号
<!--#include file="../INC/Conn.asp"-->
<!--#include file="inc/Check.asp"-->
<!--#include file="inc/public.asp"-->
<!--#include File="Procedure.asp"-->
<%
dim Makking
Makking = Trim(Request.QueryString("Makking"))    
'---------------------------------
select case Makking
case "save"

IF Request.Form("LinkMan_Name") = "" Then

	Save_title="·对不起,姓名不能为空"   
	call Save_err()

End if

	LinkMan_ID			= Request.Form("LinkMan_ID")
	LinkMan_Name		= Request.Form("LinkMan_Name")
	LinkMan_Telephone	= Request.Form("LinkMan_Telephone")
	LinkMan_Mobile		= Request.Form("LinkMan_Mobile")
	LinkMan_Job			= Request.Form("LinkMan_Job")
	LinkMan_Address		= Request.Form("LinkMan_Address")
	LinkMan_Mail		= Request.Form("LinkMan_Mail")
	LinkMan_Remark		= Request.Form("LinkMan_Remark")


IF Request.QueryString("LinkMan_ID") = "" Then

		LinkMan_ID       = makerndid(30)
		Do While Ranid_LinkMan(LinkMan_ID)
		LinkMan_ID       = makerndid(30)
		Loop

	Conn.Execute("Insert Into LinkMan (Buyer_ID,LinkMan_ID,Employee_ID,LinkMan_Name,LinkMan_Telephone,LinkMan_Mobile,LinkMan_Job,LinkMan_Address,LinkMan_Mail,LinkMan_Remark,DateTime) Values ('"& Request.QueryString("ID") &"','"& LinkMan_ID &"','"& Session("Eboer_CRM_Employee_ID") &"','"& LinkMan_Name &"','"& LinkMan_Telephone &"','"& LinkMan_Mobile &"','"& LinkMan_Job &"','"& LinkMan_Address &"','"& LinkMan_Mail &"','"& LinkMan_Remark &"','"& now() &"')")

	Response.Write "<script>window.opener.location.reload()</script>"

	Save_title="·添加成功"   
	call Save_ok()

Else

	Conn.Execute("upDate LinkMan Set LinkMan_Name = '"& LinkMan_Name &"',LinkMan_Telephone = '"& LinkMan_Telephone &"',LinkMan_Mobile = '"& LinkMan_Mobile &"',LinkMan_Job = '"& LinkMan_Job &"',LinkMan_Address = '"& LinkMan_Address &"',LinkMan_Mail = '"& LinkMan_Mail &"',LinkMan_Remark = '"& LinkMan_Remark &"' Where Buyer_ID='"& Request.QueryString("ID") &"' and LinkMan_ID = '"& Request.QueryString("LinkMan_ID") &"'")

	Save_title="·修改成功"   
	call Save_ok()

End IF

	


case ""

Set Rs = Conn.Execute("Select * From LinkMan Where Buyer_ID='"& Request.QueryString("ID") &"' and LinkMan_ID = '"& Request.QueryString("LinkMan_ID") &"'")

IF Not(Rs.Bof AND Rs.eof) Then

	LinkMan_ID			= Rs("LinkMan_ID")
	LinkMan_Name		= Rs("LinkMan_Name")
	LinkMan_Telephone	= Rs("LinkMan_Telephone")
	LinkMan_Mobile		= Rs("LinkMan_Mobile")
	LinkMan_Job			= Rs("LinkMan_Job")
	LinkMan_Address		= Rs("LinkMan_Address")
	LinkMan_Mail		= Rs("LinkMan_Mail")
	LinkMan_Remark		= Rs("LinkMan_Remark")
	
Else


	Set Rs_1 = Conn.Execute("Select * From Buyer_Info Where Buyer_ID='"& Request.QueryString("ID") &"'")
	
		IF Not(Rs_1.bof AND Rs_1.eof) Then
		
		LinkMan_Telephone	= Rs_1("Buyer_Telephone")
		LinkMan_Address		= Rs_1("Buyer_Address")
		
		End IF
		
	Rs_1.Close
	
	Set Rs_1 = Nothing
	
End if

Rs.Close
Set Rs = Nothing




%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>亿博尔-客户关系管理系统</title>
</head>
<link href="Images/Admin.css" rel="stylesheet" type="text/css">
<body>
<table width="98%" height="40"  border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><table width="100%"  border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#D8D8D8">
      <tr>
        <td height="30" align="left" bgcolor="ffffff"><table width="100%" height="100%"  border="0" cellpadding="3" cellspacing="0">
            <tr bgcolor="eeeeee">
              <td width="5%" align="center"><img src="Images/1.gif" width="13" height="12"></td>
                <td width="85%"><span class="style2">管理中心 &gt;&gt;&gt; 添加/修改联系人</span></td>
                <td width="10%" align="right">&nbsp;</td>
            </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
</table>
<table width="98%" height="88%"  border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#D8D8D8">
  <tr>
    <td valign="top" bgcolor="ffffff"><table width="95%"  border="0" align="center" cellpadding="5" cellspacing="0">
        <tr>
          <td align="center" valign="top" bgcolor="ffffff"> 
            <form method='POST' name="form" action="LinkMan_Add.asp?Makking=save&ID=<%=Request.QueryString("ID")%>&LinkMan_ID=<%=Request.QueryString("LinkMan_ID")%>">
              <br>
              <table width=100% border=0 align='center' cellpadding=1 
      cellspacing=1 bordercolordark=#ffffff bgcolor="#EBEBEB" class='size09'>
                <tr> 
                  <td width="25%" height="12" align="right" bgcolor="ffffff">姓名:</td>
                  <td height="12" bgcolor="ffffff"><input name="LinkMan_Name" type="text" id="LinkMan_Name" value="<%=LinkMan_Name%>" size="30" maxlength="50">
                    <font color="#FF0000"> *</font></td>
                </tr>
                <tr> 
                  <td width="25%" height="-2" align="right" bgcolor="ffffff">职务:</td>
                  <td height="5" bgcolor="ffffff"><input name="LinkMan_Job" type="text" id="LinkMan_Job" value="<%=LinkMan_Job%>" size="30" maxlength="50"></td>
                </tr>
                <tr>
                  <td width="25%" height="-1" align="right" bgcolor="ffffff">办公室电话:</td>
                  <td height="6" bgcolor="ffffff"><input name="LinkMan_Telephone" type="text" id="LinkMan_Telephone" value="<%=LinkMan_Telephone%>" size="30" maxlength="50">
                    <font color="#FF0000">&nbsp; </font></td>
                </tr>
                <tr>
                  <td width="25%" height="-1" align="right" bgcolor="ffffff">移动电话:</td>
                  <td height="12" bgcolor="ffffff"><input name="LinkMan_Mobile" type="text" id="LinkMan_Mobile" value="<%=LinkMan_Mobile%>" size="30" maxlength="50">
                  </td>
                </tr>
                <tr>
                  <td width="25%" height="-1" align="right" bgcolor="ffffff">E-mail:</td>
                  <td height="12" bgcolor="ffffff"><input name="LinkMan_Mail" type="text" id="LinkMan_Mail" value="<%=LinkMan_Mail%>" size="30" maxlength="50"></td>
                </tr>
                <tr>
                  <td width="25%" height="0" align="right" bgcolor="ffffff">通讯地址:</td>
                  <td height="12" bgcolor="ffffff"><input name="LinkMan_Address" type="text" id="LinkMan_Address" value="<%=LinkMan_Address%>" size="30" maxlength="50"></td>
                </tr>
                <tr>
                  <td width="25%" height="12" align="right" bgcolor="ffffff">备注:</td>
                  <td height="12" bgcolor="ffffff"><textarea name="LinkMan_Remark" cols="40" rows="5" id="LinkMan_Remark"><%=LinkMan_Remark%></textarea></td>
                </tr>
              </table>
              <p> 
                <input name="B1" type="image" src="Images/refer.gif" width="36" height="21" border="0">
                &nbsp;<%IF request.ServerVariables("http_referer")="" Then%><a href=""><img src="Images/back.gif" width="36" height="21" border="0" onClick="javascript:window.close()"></a><%Else%><a href="<%=request.ServerVariables("http_referer")%>"><img src="Images/back.gif" width="36" height="21" border="0"></a><%End IF%></p>
            </form></td>
        </tr>
      </table>      
      
    </td>
  </tr>
</table>
<%end select
Conn.Close
Set Conn = Nothing

%>
<table width="98%"  border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="6"></td>
  </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?