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">管理中心 >>> 添加/修改联系人</span></td>
<td width="10%" align="right"> </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"> </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">
<%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 + -
显示快捷键?