link_log_manage.asp
来自「适用于网络/信息企业」· ASP 代码 · 共 344 行
ASP
344 行
<!--#include file="../INC/Conn.asp"-->
<!--#include file="inc/Check.asp"-->
<!--#include file="inc/public.asp"-->
<%
Dim Makking
Makking = Request.QueryString("Makking")
%>
<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">
<%
Select Case Makking
Case ""
%>
<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="78%"><span class="style2">管理中心 >>> 管理联系记录</span></td>
<td width="17%" align="right">
</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<table width="98%" height="90%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#D8D8D8">
<tr>
<td valign="top" bgcolor="ffffff"> <br>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<form name="form" method="post" action="Link_Log_Manage.asp?Makking=Search">
<input type="hidden" name="City" value="">
<input type="hidden" name="Class" value="">
<tr>
<td height="30" align="right">关键词：</td>
<td height="30">
<input name="key" type="text" id="key" size="30"></td>
</tr>
<tr>
<td height="30" align="right">联系方式：</td>
<td height="30">
<select name="Search_Fashion">
<option value="">全部方式</option>
<option value="电话联系" <%IF Session("My_Search_Fashion")="电话联系" Then%>selected<%End IF%>>电话联系</option>
<option value="拜访客户" <%IF Session("My_Search_Fashion")="拜访客户" Then%>selected<%End IF%>>拜访客户</option>
<option value="传真资料" <%IF Session("My_Search_Fashion")="传真资料" Then%>selected<%End IF%>>传真资料</option>
<option value="邮件发送" <%IF Session("My_Search_Fashion")="邮件发送" Then%>selected<%End IF%>>邮件发送</option>
<option value="其它方式" <%IF Session("My_Search_Fashion")="其它方式" Then%>selected<%End IF%>>其它方式</option>
</select></td>
</tr>
<tr>
<td height="30" align="right">搜索内容：</td>
<td height="30">
<select name="Search_Body">
<option value="LinkMan_Name" <%IF Session("My_Search_Body")="LinkMan_Name" Then%>selected<%End IF%>>联系人</option>
<option value="Buyer_Name" <%IF Session("My_Search_Body")="Buyer_Name" Then%>selected<%End IF%>>联系客户</option>
<option value="Link_Info" <%IF Session("My_Search_Body")="Link_Info" Then%>selected<%End IF%>>联系信息</option>
<option value="Link_Content" <%IF Session("My_Search_Body")="Link_Content" Then%>selected<%End IF%>>联系内容</option>
</select></td>
</tr>
<tr>
<td height="30" align="right">行业：</td>
<td height="30">
<IFRAME frameBorder=0 id=FrmRight name=right src="../inc/Class.asp?NumberID=<%=Session("My_Search_Class")%>" style="HEIGHT: 100%; VISIBILITY: inherit; WIDTH: 100%; Z-INDEX: 1"></IFRAME></td>
</tr>
<tr>
<td height="30" align="right">地区：</td>
<td height="30">
<IFRAME frameBorder=0 id=FrmRight name=right src="../inc/City.asp?NumberID=<%=Session("My_Search_City")%>" style="HEIGHT: 100%; VISIBILITY: inherit; WIDTH: 100%; Z-INDEX: 1"></IFRAME></td>
</tr>
<tr>
<td height="30" align="right">员工ID：</td>
<td height="30">
<input name="Employee_ID" type="text" id="Employee_ID" size="30"></td>
</tr>
<tr>
<td height="30" align="right">开始时间：</td>
<td height="30"> <input name="Time_1" type="text" onclick="JSCalendar(this)" value="<%=Time_1%>" size="12" readonly>
</td>
</tr>
<tr>
<td height="30" align="right">结束时间：</td>
<td height="30"> <input name="Time_2" type="text" onClick="JSCalendar(this)" value="<%=Time_2%>" size="12" readonly></td>
</tr>
<tr>
<td height="30" align="right">审核情况：</td>
<td height="30">
<select name="Auditing">
<option value="">全部</option>
<option value="未审核">未审核</option>
<option value="已审核">已审核</option>
</select></td>
</tr>
<tr>
<td height="30" align="right"> </td>
<td height="30">
<input name="imageField" type="image" src="Images/see.gif" width="36" height="21" border="0"></td>
</tr>
</form>
</table> </td>
</tr>
</table>
<%
Case "Search"
Dim Search_key,Search_Body,Search_Fashion,Search_City,Search_Class,Time_1,Time_2,Employee_ID
Dim SQL_Search_key,SQL_Search_City,SQL_Search_Fashion
Search_key = Trim(Request("Key"))
Search_Fashion= Trim(Request("Search_Fashion"))
Search_Body = Trim(Request("Search_Body"))
Search_City = Trim(Request("City"))
Search_Class = Trim(Request("Class"))
Auditing = Trim(Request("Auditing"))
Time_1 = Request("Time_1")
Time_2 = Request("Time_2")
Employee_ID = Request("Employee_ID")
IF Search_key <> "" Then
SQL_Search_key = " AND "& Search_Body &" like '%"& Search_key &"%' "
End IF
IF Search_Fashion <> "" Then
SQL_Search_Fashion = " AND Link_Fashion = '"& Search_Fashion &"' "
End IF
IF Search_City <> "" Then
SQL_Search_City = " AND City like '"& Search_City &"%' "
End IF
IF Search_Class <> "" Then
SQL_Search_Class = " AND Buyer_Trade like '"& Search_Class &"%' "
End IF
IF Auditing <> "" Then
SQL_Auditing = " AND Auditing = '"& Auditing &"' "
End IF
IF Employee_ID <> "" Then
SQL_Employee_ID = " AND Link_Log.Employee_ID = '"& Employee_ID &"' "
End IF
IF Time_1 <> "" AND Time_2 <> "" Then
SQL_Time = " AND Link_Log.DateTime >= '"& Time_1 &"' AND Link_Log.DateTime <= '"& Time_2 &"' "
End IF
'-------------------------------------------排序
Order = Trim(Request("Order"))
IF Request.QueryString("Page") = "" OR Request.QueryString("Page")<=1 Then
IF Order = Session("Order") Then Order = "-"& Order
End IF
Select Case Order
Case ""
SQL_Order = "Order by Link_Log.DateTime Desc"
Case "1"
SQL_Order = "Order By LinkMan_Name"
Case "-1"
SQL_Order = "Order By LinkMan_Name Desc"
Case "2"
SQL_Order = "Order By Link_Fashion"
Case "-2"
SQL_Order = "Order By Link_Fashion Desc"
Case "3"
SQL_Order = "Order By Link_Log.DateTime"
Case "-3"
SQL_Order = "Order By Link_Log.DateTime Desc"
Case "4"
SQL_Order = "Order By Buyer_Name"
Case "-4"
SQL_Order = "Order By Buyer_Name Desc"
End Select
Session("Order") = Order
%>
<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="78%"><span class="style2">管理中心 >>> 管理联系记录</span></td>
<td width="17%" align="right"> </td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<table width="98%" height="90%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#D8D8D8">
<tr>
<td valign="top" bgcolor="ffffff"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" bgcolor="ffffff"> <table width=100% border=0 align='center' cellpadding=3 cellspacing=1 bordercolordark=#ffffff bgcolor="eaeaea">
<td width="3%">
<tr align="left" bgcolor="ffffff">
<td height="20" colspan="3" background="Images/box_bg.gif"><a href="Link_Log_Manage.asp?Makking=Search&key=<%=Search_key%>&Search_Fashion=<%=Search_Fashion%>&Search_Body=<%=Search_Body%>&City=<%=Search_City%>&Class=<%=Search_Class%>&Auditing=<%=Auditing%>&Time_1=<%=Time_1%>&Time_2=<%=Time_2%>&Employee_ID=<%=Employee_ID%>&Order=1">联系人</a></td>
<td width="12%" height="20" background="Images/box_bg.gif" bgcolor="ffffff"><a href="Link_Log_Manage.asp?Makking=Search&key=<%=Search_key%>&Search_Fashion=<%=Search_Fashion%>&Search_Body=<%=Search_Body%>&City=<%=Search_City%>&Class=<%=Search_Class%>&Auditing=<%=Auditing%>&Time_1=<%=Time_1%>&Time_2=<%=Time_2%>&Employee_ID=<%=Employee_ID%>&Order=2">联系方式</a>
<td width="22%" height="20" background="Images/box_bg.gif" bgcolor="ffffff"><a href="Link_Log_Manage.asp?Makking=Search&key=<%=Search_key%>&Search_Fashion=<%=Search_Fashion%>&Search_Body=<%=Search_Body%>&City=<%=Search_City%>&Class=<%=Search_Class%>&Auditing=<%=Auditing%>&Time_1=<%=Time_1%>&Time_2=<%=Time_2%>&Employee_ID=<%=Employee_ID%>&Order=3">联系时间</a></td>
<td width="25%" background="Images/box_bg.gif" bgcolor="ffffff"><a href="Link_Log_Manage.asp?Makking=Search&key=<%=Search_key%>&Search_Fashion=<%=Search_Fashion%>&Search_Body=<%=Search_Body%>&City=<%=Search_City%>&Class=<%=Search_Class%>&Auditing=<%=Auditing%>&Time_1=<%=Time_1%>&Time_2=<%=Time_2%>&Employee_ID=<%=Employee_ID%>&Order=4">所在企业</a></td>
<td width="12%" background="Images/box_bg.gif" bgcolor="ffffff">在该企业中</td>
<td width="12%" background="Images/box_bg.gif" bgcolor="ffffff">操作</td>
</tr>
<%
SQL = "select Link_Log.*,Link_Log.DateTime As DateTime_1,Link_Log.Buyer_ID,My_Buyer.Employee_ID,My_Buyer.Buyer_ID,Buyer_Info.*,Buyer_Info.Buyer_ID from Link_Log,My_Buyer,Buyer_Info where (Link_Log.Buyer_ID = Buyer_Info.Buyer_ID) and (My_Buyer.Buyer_ID = Buyer_Info.Buyer_ID) "& SQL_Search_City &" "& SQL_Search_Fashion &" "& SQL_Search_key &" "& SQL_Search_Class &" "& SQL_Auditing &" "& SQL_Employee_ID &" "& SQL_Time &" AND "& SQL_City &" "& SQL_Order &""
Set rs=server.CreateObject("adodb.recordset")
rs.open SQL,Conn,1,1
IF not (rs.BOF and rs.eof) then
rs.PageSize = 18
%>
<!--#include file="../inc/page.asp"-->
<tr align="left" bgcolor="ffffff" onmouseout="this.style.backgroundColor=''" onmouseover="this.style.backgroundColor='#F5F5F5'">
<td height="22" colspan="3"><a href="javascript:Link_Log_See('<%=Rs("Link_Log_ID")%>');"><%=Rs("LinkMan_Name")%></a></td>
<td width="15%" height="22"><%=Rs("Link_Fashion")%></TD>
<td height="22"><%=Rs("DateTime_1")%></td>
<td height="22"><a href="javascript:Buyer_Edit('<%=Rs("Buyer_ID")%>');">
<%
IF len(Rs("Buyer_Name"))>12 Then
Response.Write(left(Rs("Buyer_Name"),12)) & "..."
Else
Response.Write(Rs("Buyer_Name"))
End IF
%>
</a></td>
<td height="22"><a href="javascript:Link_Log_List('<%=Rs("Buyer_ID")%>');">记录</A>|<a href="javascript:Link_Log_Add_1('<%=Rs("Buyer_ID")%>');">添加</A></td>
<td height="22">
<a href="javascript:Link_Log_Add('<%=Rs("Buyer_ID")%>','<%=Rs("Link_Log_ID")%>');">修改</A>|<a href="javascript:Link_Log_Auditing('<%=Rs("Link_Log_ID")%>')"><%=Rs("Auditing")%></A>
</td>
</tr>
<%
rs.movenext
next
end if
%>
</table></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="24" colspan="3" align="left" valign="middle" background="Images/box_bg_1.gif">
<%Call Page_See()%>
</td>
<td width="51%" height="24" align="right" valign="middle" background="Images/box_bg_1.gif">
<%Page_links="Makking=Search&key="& Search_key &"&Search_Fashion="& Search_Fashion &"&Search_Body="& Search_Body &"&City="& Search_City &"&Class="& Search_Class &"&Auditing="& Auditing &"&Time_1="& Time_1 &"&Time_2="& Time_2 &"&Employee_ID="&Employee_ID&"&Order="& Order &"&"
call PageControl(iCount,maxpage,page)
rs.close
set rs=nothing
Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="1" bgcolor="#E2E1E1"></td>
</tr>
</table></td>
</tr>
</table>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="6"></td>
</tr>
</table>
<%End Select%>
</body>
</html>
<script language="javascript">
<!--
function Link_Log_See(id){
window.open("Link_Log_See.asp?id="+id+"","","width=500,height=310,scrollbars=yes");
}
function Buyer_Edit(id){
window.open("Buyer_Edit.asp?id="+id+"","","width=500,height=530,scrollbars=yes");
}
function Link_Log_List(id){
window.open("Link_Log_List.asp?id="+id+"","","width=500,height=380,scrollbars=yes");
}
function Link_Log_Add_1(id){
window.open("Link_Log_Add.asp?id="+id+"","","width=500,height=310,scrollbars=yes");
}
function Link_Log_Add(id,Link_Log_ID){
window.open("Link_Log_Add.asp?id="+id+"&Link_Log_ID="+Link_Log_ID+"","","width=500,height=380,scrollbars=yes");
}
function Link_Log_Del(id){
window.open("Link_Log_Del.asp?id="+id+"","","width=500,height=310,scrollbars=yes");
}
function Link_Log_Auditing(id){
window.open("Link_Log_Auditing.asp?id="+id+"","","width=500,height=280,scrollbars=yes");
}
//-->
</script>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?