⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 d_salezyrymainfrm.asp

📁 一个很好的在线购物系统
💻 ASP
字号:
<!--#include file="../include/Pubconn.asp"-->

<!--#include file="../include/PubConnCode.asp"-->
<!--#include file="../include/PubFun.asp"-->
<% username=getuser()
 userclass=tablevisitor("d_linkman",username)
 departid=session("departid")
%>


<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft FrontPage 4.0">
<title></title><link href="../cread.css" rel="stylesheet" type="text/css">
</HEAD>
<script language="vbscript">
sub NewZyry()
   window.location="D_SaleZyrySubFrm.asp?page1="&document.form1.page1.value&"&page2="&document.form1.page2.value&"&par_id="&par_id&""
end sub

 sub qx()
msgbox "您无此权限!"
 exit sub
end sub
</script>
<%function getName(aa)
  set rs1=server.CreateObject("adodb.recordset") 
  if rs1.State=1 then rs1.Close
  rs1.Open "select * from D_clientinfo where clientnum='"& aa &"'",pubconn,1,3
  if rs1.RecordCount<=0 then 
     getName=""
  else
     getName=rs1.Fields("clientname")
  end if
end function%>
<BODY bgcolor="#FFFFFF">

  <%tag1="Lookup"%>
  <%tag2="New"%>
  <%tag3="Search"%>
  <%m_id=trim(Request("par_id"))%>
  
  <%'''''''''''''''''''''''''''''''''''''''第一次装载%>
  <%set rs=server.CreateObject("adodb.recordset")
    rs.Open "select * from D_linkman where clientnum='"& m_id &"'and  departid like '"&departid&"%'",pubconn,1,3%>
    
    <form name="form1"  method="post" action="D_SaleZyrySubFrm.asp">
       
       <%if rs.RecordCount<=0 then%>  
       <br><br><br><br><center><font size="2">提示:该经销商尚未建立重要人员档案!<br></font><br>
        <%if userclass>1 then%> 
       <input type="submit" name="B2" value="新建" class=hand style="background-color: #D1D1D1; border-style: solid; border-width: 1"><br><br>
       <%else%>
  <input type="button" value="新建" onclick="javascript:location.href='qx.asp'" name="B1" class=hand style="background-color: #D1D1D1; border-style: solid; border-width: 1">                     
<%end if%>

       <%aa="Lookup"%>
       <font size="2">   
        <a href="D_SalekhsubFrm.asp?lookup=<%=aa%>&page1=<%=Request("page1")%>&par_id=<%=Request("par_id")%>&par_name=<%=Request("par_name")%>&par_level=<%=Request("par_level")%>">返回</a>    
       </font>      
       </center>    
       <input type="hidden" name="page2" value=<%=page2%>>                 
       <input type="hidden" name="line" value=<%=line%>>                    
       <input type="hidden" name="par_id" value=<%=trim(Request("par_id"))%>><%'''''''客户序号%>       
       <input type="hidden" name="page1" value=<%=Request("page1")%>>       
       <input type="hidden" name="par_name" value=<%=Request("par_name")%>>       
       <input type="hidden" name="par_level" value=<%=Request("par_level")%>>                          
       <%Response.End %>       
       <%end if%>       
         
        <table border="0" width="100%">  
                <tr>  
                 <td width="100%" valign="middle"><img border="0" src="it_22.gif" width="34" height="15">  <b><font size="2">关键人物档案</font></b><hr width="40%" align="left" size="1"></td>   
                </tr>   
       </table>   
  
              <table border=0 cellspacing=0 width="100%">    
          <tr>    
            <td ><font size="3">客户名称:</font>&nbsp;&nbsp;&nbsp;&nbsp;<%=getName(m_id)%></td>    
          </tr>    
       </table> <hr>      
       <table border=1 cellspacing=0 width="100%">    
          <tr>    
            <td bgcolor="#DDD2C4">&nbsp;</td><td bgcolor="#DDD2C4">人员姓名</td><td bgcolor="#DDD2C4">性别</td><td bgcolor="#DDD2C4">出生日期</td><td bgcolor="#DDD2C4">籍贯</td><td bgcolor="#DDD2C4">部门</td><td bgcolor="#DDD2C4">职务</td><td bgcolor="#DDD2C4">办公电话</td><td bgcolor="#DDD2C4">手机</td><td bgcolor="#DDD2C4">   
            <p align="center">  
            是否在岗</p>  
            </td>   
   
          </tr>   
          <%if request("page2")<>"" then     
               page2=cint(request("page2"))   
            else    
               page2=1    
            end if    
            rs.pagesize=10   
            if page2>=rs.pagecount then    
               page2=rs.pagecount    
            else    
               if page2<1 then    
                  page2=1    
               end if    
            end if    
            rs.AbsolutePage=page2   
            line=0%>               
            <%for i=1 to rs.PageSize   
                  line=cint(line)+1%>    
                  <%if  i mod 2 =0 then%>   
                         <%backcolor="#f7f7f7"%>   
                       <%else%>                      
                         <%backcolor="#EDEBEC"%>   
                       <%end if%>   
                      <tr bgcolor=<%=backcolor%>>   
                     <td>
                   <%if (userclass=2 and username=rs("authors") and departid=rs("departid")) or (userclass=3 and departid=rs("departid")) then%>                               
                     <input type="checkbox"  name=<%="checkbox"&line%> value=1 id=checkbox1></td>   
                        <%else%>  
 						   <input type="checkbox" name="sc" value="1" onmousedown="qx()"> 
   						 <%end if%> 
 <input type="hidden"  name=<%="m_id1"&line%> value=<%=rs.fields("linkman")%> id=hidden1>   
                     <td><a href="D_SaleZyrySubFrm.asp?m_linkman=<%=rs.Fields("linkman")%>&page2=<%=page2%>&page1=<%=Request("page1")%>&par_name=<%=Request("par_name")%>&par_type=<%=Request("par_type")%>&par_level=<%=Request("par_level")%>&lookup=<%=tag1%>&m_clientnum=<%=rs.Fields("clientnum")%>"><%=rs.Fields("linkman")%></a></td>   
                     <%if rs.Fields("sex")<>"" then%>                        
                          <td><%=rs.Fields("Sex")%></td>   
                     <%else%>        
                          <td>&nbsp;</td>   
                     <%end if%>   
                     <%if rs.Fields("BirthDay")<>"" then%>   
                          <td><%=rs.Fields("BirthDay")%></td>   
                     <%else%>        
                          <td>&nbsp;</td>   
                     <%end if%>   
                     <%if rs.Fields("NativePlace")<>"" then%>   
                          <td><%=rs.Fields("NativePlace")%></td>    
                     <%else%>        
                          <td>&nbsp;</td>   
                     <%end if%>   
                     <%if rs.Fields("Department")<>"" then%>   
                          <td><%=rs.Fields("Department")%></td>   
                     <%else%>        
                          <td align="center">&nbsp;</td>   
                     <%end if%>   
                     <%if rs.Fields("HeadShip")<>"" then%>   
                         <td align="center"><%=rs.Fields("HeadShip")%></td>   
                     <%else%>       
                         <td align="center">&nbsp;</td>   
                     <%end if%>    
                     <%if rs.Fields("Telephone")<>"" then%>   
                         <td align="center"><%=rs.Fields("Telephone")%></td>   
                     <%else%>       
                         <td align="center">&nbsp;</td>   
                     <%end if%>   
                     <%if rs.Fields("MobileTelephone")<>"" then%>   
                          <td align="center"><%=rs.Fields("MobileTelephone")%></td>   
                     <%else%>   
                         <td align="center">&nbsp;</td>   
                     <%end if%>   
                     <%if rs.Fields("OnOrOff")<>"" and  rs.Fields("OnOrOff")="1" then%>                                             
                          <td align="center">在岗</td>   
                     <%else%>   
                         <td   align="center">已离岗</td>   
                     <%end if%>   
                   </tr>   
                    <%rs.MoveNext %>   
                    <%if rs.EOF then exit for%>   
              <%next %>   
              <%if line<10 then%>     
                   <%for i=line to 10%>   
                        <tr><td WIDTH="18">&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr>   
                   <%next%>   
              <%end if%>   
              <input type="hidden" name="page2" value=<%=page2%>>                
              <input type="hidden" name="line" value=<%=line%>>                
              <input type="hidden" name="par_id" value=<%=trim(Request("par_id"))%>><%'''''''客户序号%>   
              <input type="hidden" name="page1" value=<%=Request("page1")%>>   
              <input type="hidden" name="par_name" value=<%=Request("par_name")%>>   
              <input type="hidden" name="par_level" value=<%=Request("par_level")%>>                           
          </table><br>   
                
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font size="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;     
             &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;       
             <a href="D_SalezyrymainFrm.asp?page2=1&page1=<%=Request("page1")%>&par_id=<%=Request("par_id")%>&par_name=<%=Request("par_name")%>&par_type=<%=Request("par_type")%>&par_level=<%=Request("par_level")%>">首页</a>    
             <%if page1>1 then %>                                        
               <a href="D_salezyrymainFrm.asp?page2=<%=(page2-1)%>&page1=<%=Request("page1")%>&par_id=<%=Request("par_id")%>&par_name=<%=Request("par_name")%>&par_type=<%=Request("par_type")%>&par_level=<%=Request("par_level")%>">上一页</a>                                      
             <% else%>                                      
               上一页&nbsp;                                      
             <%end if%>                                 
             <%if page1<rs.pagecount then %>                                     
               <a href="D_salezyrymainFrm.asp?page2=<%=(page2+1)%>&page1=<%=Request("page1")%>&par_id=<%=Request("par_id")%>&par_name=<%=Request("par_name")%>&par_type=<%=Request("par_type")%>&par_level=<%=Request("par_level")%>">下一页</a>                                      
             <% else %>                                     
               下一页&nbsp;                                      
             <% end if%>     
             <a href="D_salezyrymainFrm.asp?page2=<%=rs.PageCount%>&page1=<%=Request("page1")%>&par_id=<%=Request("par_id")%>&par_name=<%=Request("par_name")%>&par_type=<%=Request("par_type")%>&par_level=<%=Request("par_level")%>">尾页</a>     
             &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;     
             共<%=rs.pagecount%>页&nbsp;&nbsp; 第<%=page2%>页&nbsp;</font><hr> 
             <%if userclass>1 then%>     
             <input type="submit" value="新建" name="B2" class=hand style="background-color: #D1D1D1; border-style: solid; border-width: 1">    
              <%else%>
  <input type="button" value="新建" onclick="javascript:location.href='qx.asp'" name="B1" class=hand style="background-color: #D1D1D1; border-style: solid; border-width: 1">                     
<%end if%>

             <input type="submit" value="删除" name="B2" class=hand style="background-color: #D1D1D1; border-style: solid; border-width: 1">       
             <%rs.close%>             
    </form>    
    <%aa="Lookup"%>    
  <center><a href="D_SalekhsubFrm.asp?lookup=<%=aa%>&page1=<%=Request("page1")%>&par_id=<%=Request("par_id")%>&par_name=<%=Request("par_name")%>&par_type=<%=Request("par_type")%>&par_level=<%=Request("par_level")%>"><font
  size="2">返回</font></a></center>    
</BODY>    
</HTML>    

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -