operation_list.asp
来自「适用于网络/信息企业」· ASP 代码 · 共 195 行
ASP
195 行
<!--#include file="../INC/Conn.asp"-->
<!--#include file="inc/Check.asp"-->
<!--#include file="inc/public.asp"-->
<%
dim Makking
Makking = Trim(Request.QueryString("Makking"))
'---------------------------------
select case Makking
Case ""
'-------------------------------------------排序
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 DateTime Desc"
Case "1"
SQL_Order = "Order By Pact_Name"
Case "-1"
SQL_Order = "Order By Pact_Name Desc"
Case "2"
SQL_Order = "Order By Pact_Money"
Case "-2"
SQL_Order = "Order By Pact_Money Desc"
Case "3"
SQL_Order = "Order By End_Time"
Case "-3"
SQL_Order = "Order By End_Time Desc"
Case "4"
SQL_Order = "Order By Operation_State"
Case "-4"
SQL_Order = "Order By Operation_State 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="85%"><span class="style2">管理中心 >>> 业务列表</span></td>
<td width="10%" 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="center" cellpadding="0" cellspacing="0">
<tr valign="bottom">
<td align="center" valign="middle"><a href="LinkMan_List.asp?ID=<%=Request.QueryString("ID")%>">
联系人</a> | <a href="Link_Log_List.asp?ID=<%=Request.QueryString("ID")%>">
联系记录</a> | <a href="Link_Task_List.asp?ID=<%=Request.QueryString("ID")%>">联系任务</a>
| <a href="Operation_List.asp?ID=<%=Request.QueryString("ID")%>">业务记录</a>
| <a href="My_Buyer_Add.asp?ID=<%=Request.QueryString("ID")%>">客户类型</a>
| <a href="Buyer_Edit.asp?ID=<%=Request.QueryString("ID")%>">客户资料</a></td>
</tr>
</table></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 align="right" 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="Operation_List.asp?ID=<%=Request.QueryString("ID")%>&Link_Task_ID=<%=Request.QueryString("Link_Task_ID")%>&Order=1">业务名称</a>
</td>
<td width="15%" height="20" background="Images/box_bg.gif" bgcolor="ffffff"><a href="Operation_List.asp?ID=<%=Request.QueryString("ID")%>&Link_Task_ID=<%=Request.QueryString("Link_Task_ID")%>&Order=1">合同金额</a>
<td width="25%" background="Images/box_bg.gif" bgcolor="ffffff"><a href="Operation_List.asp?ID=<%=Request.QueryString("ID")%>&Link_Task_ID=<%=Request.QueryString("Link_Task_ID")%>&Order=1">截止日期</a></td>
<td width="15%" background="Images/box_bg.gif" bgcolor="ffffff"><a href="Operation_List.asp?ID=<%=Request.QueryString("ID")%>&Link_Task_ID=<%=Request.QueryString("Link_Task_ID")%>&Order=1">状态</a></td>
<td width="20%" background="Images/box_bg.gif" bgcolor="ffffff">操作</td>
</tr>
<%
SQL = "select * from Operation where Buyer_ID = '"& Request.QueryString("ID") &"' "& SQL_Order &""
Set rs=server.CreateObject("adodb.recordset")
rs.open SQL,Conn,1,1
IF not (rs.BOF and rs.eof) then
rs.PageSize = 12
%>
<!--#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:Operation_See('<%=Rs("Pact_ID")%>');"><%=Rs("Pact_Name")%></a></td>
<td height="22"><%=Rs("Pact_Money")%></TD>
<td height="22"><%=Rs("End_Time")%></td>
<td height="22"><%=Rs("Operation_State")%></td>
<td height="22">
<%IF Rs("Employee_ID") = Session("Eboer_CRM_Employee_ID") Then%>
<a href="Operation_Add.asp?ID=<%=Request.QueryString("ID")%>&Pact_ID=<%=Rs("Pact_ID")%>">修改</A>|<a href="javascript:Operation_Del('<%=Rs("Pact_ID")%>')" onClick="return confirm('删除后将不可恢复，您确定要这样操作吗？')">删除</A>
<%Else%>
<font color="#999999">修改|删除</font>
<%End IF%>
</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="ID="& Request.QueryString("ID") &"&Link_Task_ID="& Request.QueryString("Link_Task_ID") &"&Order="& Order &"&"
call PageControl(iCount,maxpage,page)
rs.close
set rs=nothing
%></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="1" bgcolor="#E2E1E1"></td>
</tr>
</table>
<a href="Operation_Add.asp?ID=<%=Request.QueryString("ID")%>"><img src="Images/add.gif" width="36" height="21" border="0"></a></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>
<script language="javascript">
<!--
function Operation_See(id){
window.open("Operation_See.asp?id="+id+"","","width=500,height=310,scrollbars=yes");
}
function Operation_Del(id){
window.open("Operation_Del.asp?id="+id+"","","width=500,height=310,scrollbars=yes");
}
//-->
</script>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?