buyer_manage.asp

来自「适用于网络/信息企业」· ASP 代码 · 共 336 行 · 第 1/2 页

IF Employee_ID <> "" Then

	SQL_Employee_ID = " AND My_Buyer.Employee_ID = '"& Employee_ID &"' "

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 My_Buyer.DateTime Desc"
	
Case "1"

	SQL_Order = "Order By Buyer_Name"

Case "-1"

	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">管理中心 &gt;&gt;&gt; 管理联系记录</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="Buyer_Manage.asp?Buyer_Estate=<%=Buyer_Estate%>&Makking=Search&key=<%=Search_key%>&Search_Fashion=<%=Search_Fashion%>&Search_Body=<%=Search_Body%>&City=<%=Search_City%>&Class=<%=Search_Class%>&Search_Type=<%=Search_Type%>&Employee_ID=<%=Employee_ID%>&Order=1">客户名称</a></td>
                <td width="12%" height="20" background="Images/box_bg.gif" bgcolor="ffffff">客户类型 
                <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>
              </tr>
              <%
	SQL = "select My_Buyer.*,My_Buyer.Buyer_ID,My_Buyer.Employee_ID,My_Buyer.Buyer_ID,Buyer_Info.*,Buyer_Info.Buyer_ID from My_Buyer,Buyer_Info where (My_Buyer.Buyer_ID = Buyer_Info.Buyer_ID) "& SQL_Search_City &" "& SQL_Search_Fashion &" "& SQL_Search_key &" "& SQL_Search_Class &" "& SQL_Search_Type &" "& SQL_Employee_ID &" "& SQL_Buyer_Estate &" 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" onmouseover="this.style.backgroundColor='#F5F5F5'" onmouseout="this.style.backgroundColor=''"> 
                <td height="22" colspan="3"><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:My_Buyer_Add('<%=Rs("Buyer_ID")%>');" ><%=Rs("My_Buyer_Type")%></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_Manage_Add('<%=Rs("Buyer_ID")%>');">添加到</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="Buyer_Estate="& Buyer_Estate &"&Makking=Search&key="& Search_key &"&Search_Fashion="& Search_Fashion &"&Search_Body="& Search_Body &"&City="& Search_City &"&Class="& Search_Class &"&Search_Type="& Search_Type &"&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 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=525,scrollbars=yes");
    }
    function My_Buyer_Del(id){
        window.open("My_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");
    }
    function Buyer_Manage_Add(id){
        window.open("Buyer_Manage_Add.asp?id="+id+"","","width=500,height=420,scrollbars=yes");
    }
//-->
</script>