employee_log.asp

来自「适用于网络/信息企业」· ASP 代码 · 共 147 行

ASP
147
字号
<!--#include file="../INC/Conn.asp"-->
<!--#include file="inc/Check.asp"-->
<!--#include file="inc/public.asp"-->
<%
Dim Makking

Makking = Trim(Request.QueryString("Makking"))

Time_1        = Request("Time_1")
Time_2 		  = Request("Time_2")

Employee_ID	= Trim(Request("Employee_ID"))

IF Employee_ID <> "" Then

	SQL_Employee_ID	= " And Employee_ID = '"& Employee_ID &"' "

End IF

IF  Time_1<>"" AND Time_2 <> "" Then

	SQL_Time = " AND DateTime >= '"& Time_1 &"' AND DateTime <= '"& Time_2 &"' "

End IF

%>
<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">管理中心 &gt;&gt;&gt; 用户登录管理</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="">
                      <input type="hidden" name="City" value="">
                      <tr valign="bottom"> 
                        <td valign="middle"> 员工ID: 
                          <input name="Employee_ID" type="text" id="Employee_ID" value="<%=Employee_ID%>" size="10">
                          &nbsp;&nbsp;时间:从 
                          <input name="Time_1" type="text" onclick="JSCalendar(this)" value="<%=Time_1%>" size="12" readonly>
                          <input name="Time_2" type="text" onClick="JSCalendar(this)" value="<%=Time_2%>" size="12" readonly></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">
              <tr align="left" bgcolor="ffffff"> 
                <td height="20" background="Images/box_bg.gif">ID</td>
                <td width="20%" height="20" background="Images/box_bg.gif">用户ID</td>
                <td width="30%" height="20" background="Images/box_bg.gif" bgcolor="ffffff">IP
                <td width="30%" height="20" background="Images/box_bg.gif" bgcolor="ffffff">时间</td>
              </tr>
              <%
	SQL = "select * from Log Where Employee_ID <>'' "& SQL_Employee_ID &" "& SQL_Time &" Order by DateTime Desc"
	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"><%=Rs("ID")%></td>
                <td height="22"><%=Rs("Employee_ID")%></td>
                <td height="22"><%=Rs("IP")%></TD>
                <td height="22"><%=Rs("DateTime")%> </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="Employee_ID="& Employee_ID &"&Trim_1="& Trim_1 &"&Trim_2="& Trim_2 &"&"
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 Employee_See(id){
        window.open("Employee_See.asp?id="+id+"","","width=500,height=310,scrollbars=yes");
    }
//-->
</script>

⌨️ 快捷键说明

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