all_buyer.asp
来自「适用于网络/信息企业」· ASP 代码 · 共 269 行
ASP
269 行
<!--#include file="../INC/Conn.asp"-->
<!--#include file="inc/Check.asp"-->
<!--#include file="inc/public.asp"-->
<%
Dim Makking
Makking = Trim(Request.QueryString("Makking"))
IF Makking = "Del" Then
Conn.Execute("Delete LinkMan where LinkMan_ID = "& Request.QueryString("LinkMan_ID") &"")
Response.Redirect request.ServerVariables("http_referer")
End IF
Dim Search_key,My_Buyer_Type,Search_Body,Search_City,My_Buyer
Dim SQL_Search_key,SQL_Search_Type,SQL_Search_City,SQL_My_Buyer
My_Buyer = Trim(Request("My_Buyer"))
Search_key = Trim(Request("Key"))
Search_Estate = Trim(Request("Search_Estate"))
Search_Body = Trim(Request("Search_Body"))
Search_City = Trim(Request("City"))
Order = Trim(Request("Order"))
Session("Search_key") = Search_key
Session("Search_Estate") = Search_Estate
Session("Search_Body") = Search_Body
Session("Search_City") = Search_City
IF Search_key <> "" Then
SQL_Search_key = " and "& Search_Body &" like '%"& Search_key &"%' "
End IF
IF Search_Estate <> "" Then
SQL_Search_Estate = " and Buyer_Estate = '"& Search_Estate &"' "
End IF
IF My_Buyer <> "" Then
SQL_My_Buyer = " and My_Buyer = '"& My_Buyer &"' "
End IF
IF Search_City <> "" Then
SQL_Search_City = " and City like '"& Search_City &"%' "
End IF
'---------------------------------------------------排序
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 DateTime Desc"
Case "1"
SQL_Order = "Order By Buyer_Name"
Case "-1"
SQL_Order = "Order By Buyer_Name Desc"
End Select
Session("Order") = Order
%>
<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="78%"><span class="style2">管理中心 >>> 全部客户</span></td>
<td width="17%" align="right">
</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<table width="98%" height="40" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"> <table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#D8D8D8">
<tr>
<td height="30" align="left" bgcolor="ffffff"><table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center"> <table width="99%" height="30" border="0" align="right" cellpadding="0" cellspacing="0">
<form name="form" method="get" action="All_Buyer.asp">
<input type="hidden" name="City" value="">
<tr valign="bottom">
<td width="250" valign="middle"> <input name="key" type="text" class="box3" id="key" value="<%=Session("Search_key")%>" size="15">
<select name="Search_Estate">
<option value="">全部</option>
<option value="正常" <%IF Session("Search_Estate")="正常" Then%>selected<%End IF%>>正常</option>
<option value="变更" <%IF Session("Search_Estate")="变更" Then%>selected<%End IF%>>变更</option>
<option value="注销" <%IF Session("Search_Estate")="注销" Then%>selected<%End IF%>>注销</option>
</select> <select name="Search_Body">
<option value="Buyer_Name" <%IF Session("Search_Body")="Buyer_Name" Then%>selected<%End IF%>>名称</option>
<option value="Buyer_Address" <%IF Session("Search_Body")="Buyer_Address" Then%>selected<%End IF%>>地址</option>
<option value="Buyer_Postcode" <%IF Session("Search_Body")="Buyer_Postcode" Then%>selected<%End IF%>>邮编</option>
<option value="Buyer_Telephone" <%IF Session("Search_Body")="Buyer_Telephone" Then%>selected<%End IF%>>电话</option>
<option value="Buyer_Fax" <%IF Session("Search_Body")="Buyer_Fax" Then%>selected<%End IF%>>传真</option>
<option value="Buyer_Introduce" <%IF Session("Search_Body")="Buyer_Introduce" Then%>selected<%End IF%>>简介</option>
<option value="Buyer_Website" <%IF Session("Search_Body")="Buyer_Website" Then%>selected<%End IF%>>网站</option>
<option value="Buyer_Mail" <%IF Session("Search_Body")="Buyer_Mail" Then%>selected<%End IF%>>邮件</option>
<option value="Legal_Person" <%IF Session("Search_Body")="Legal_Person" Then%>selected<%End IF%>>法人</option>
</select> </td>
<td valign="middle"><IFRAME frameBorder=0 id=FrmRight name=right src="../inc/City.asp?NumberID=<%=Session("Search_City")%>" style="HEIGHT: 100%; VISIBILITY: inherit; WIDTH: 100%; Z-INDEX: 1"></IFRAME></td>
<td width="50" align="center" valign="middle"><input name="imageField" type="image" src="Images/see.gif" width="36" height="21" border="0"></td>
</tr>
</form>
</table></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="4" background="Images/box_bg.gif"><a href="All_Buyer.asp?My_Buyer=<%=My_Buyer%>&key=<%=Search_key%>&Search_Estate=<%=Search_Estate%>&Search_Body=<%=Search_Body%>&City=<%=Search_City%>&Order=1">客户名称</a></td>
<td width="12%" height="20" background="Images/box_bg.gif" bgcolor="ffffff">联系人</td>
<td width="12%" background="Images/box_bg.gif" bgcolor="ffffff">联系记录</td>
<td width="12%" background="Images/box_bg.gif" bgcolor="ffffff">联系任务</td>
<td width="12%" background="Images/box_bg.gif" bgcolor="ffffff">业务管理</td>
<td width="12%" background="Images/box_bg.gif" bgcolor="ffffff">修改/删除</td>
<td width="12%" background="Images/box_bg.gif" bgcolor="ffffff"><a href="All_Buyer.asp?key=<%=Search_key%>&Search_Estate=<%=Search_Estate%>&Search_Body=<%=Search_Body%>&City=<%=Search_City%>">全部客户</a></td>
</tr>
<%
SQL = "select * from Buyer_Info where "& SQL_City &" "& SQL_Search_City &" "& SQL_Search_key &" "& SQL_Search_Estate &" "& SQL_My_Buyer &" "& 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="4"><a href="javascript:Buyer_See('<%=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:LinkMan_List('<%=Rs("Buyer_ID")%>');">查看</A>|<a href="javascript:LinkMan_Add('<%=Rs("Buyer_ID")%>');">添加</A></td>
<td height="22"><a href="javascript:Link_Log_List('<%=Rs("Buyer_ID")%>');">记录</A>|<a href="javascript:Link_Log_Add('<%=Rs("Buyer_ID")%>');">添加</A></td>
<td height="22"><a href="javascript:Link_Task_List('<%=Rs("Buyer_ID")%>');">任务</A>|<a href="javascript:Link_Task_Add('<%=Rs("Buyer_ID")%>');">添加</A></td>
<td height="22"><a href="javascript:Operation_List('<%=Rs("Buyer_ID")%>');">记录</A>|<a href="javascript:Operation_Add('<%=Rs("Buyer_ID")%>');">添加</A></td>
<td height="22"><a href="javascript:Buyer_Edit('<%=Rs("Buyer_ID")%>');">修改</a>|<a href="javascript:Buyer_Del('<%=Rs("Buyer_ID")%>');" onClick="return confirm('删除后将不可恢复，您确定要这样操作吗？')">删除</a></td>
<td height="22"><a href="javascript:My_Buyer_Add('<%=Rs("Buyer_ID")%>');">添加到</a>[<a href="All_Buyer.asp?My_Buyer=<%=Rs("My_Buyer")%>&key=<%=Search_key%>&Search_Estate=<%=Search_Estate%>&Search_Body=<%=Search_Body%>&City=<%=Search_City%>"><%=Rs("My_Buyer")%></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="key="& Search_key &"&Search_Estate="& Search_Estate &"&Search_Body="& Search_Body &"&City="& Search_City &"&My_Buyer="& My_Buyer &"&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>
</body>
</html>
<script language="javascript">
<!--
function Buyer_State(id){
window.open("Buyer_State.asp?id="+id+"","","width=400,height=250,scrollbars=yes");
}
function LinkMan_List(id){
window.open("LinkMan_List.asp?id="+id+"","","width=500,height=380,scrollbars=yes");
}
function LinkMan_Add(id){
window.open("LinkMan_Add.asp?id="+id+"","","width=500,height=380,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(id){
window.open("Link_Log_Add.asp?id="+id+"","","width=500,height=310,scrollbars=yes");
}
function Link_Task_List(id){
window.open("Link_Task_List.asp?id="+id+"","","width=500,height=380,scrollbars=yes");
}
function Link_Task_Add(id){
window.open("Link_Task_Add.asp?id="+id+"","","width=500,height=360,scrollbars=yes");
}
function Buyer_Edit(id){
window.open("Buyer_Edit.asp?id="+id+"","","width=500,height=545,scrollbars=yes");
}
function Buyer_See(id){
window.open("Buyer_See.asp?id="+id+"","","width=500,height=525,scrollbars=yes");
}
function Buyer_Del(id){
window.open("Buyer_Del.asp?id="+id+"","","width=500,height=360,scrollbars=yes");
}
function My_Buyer_Add(id){
window.open("My_Buyer_Add.asp?id="+id+"","","width=500,height=360,scrollbars=yes");
}
function Operation_List(id){
window.open("Operation_List.asp?id="+id+"","","width=500,height=420,scrollbars=yes");
}
function Operation_Add(id){
window.open("Operation_Add.asp?id="+id+"","","width=500,height=420,scrollbars=yes");
}
//-->
</script>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?