journey_manage.asp
来自「适用于网络/信息企业」· ASP 代码 · 共 209 行
ASP
209 行
<!--#include file="../INC/Conn.asp"-->
<!--#include file="inc/Check.asp"-->
<!--#include file="inc/public.asp"-->
<%
dim Makking
Makking = Trim(Request.QueryString("Makking"))
'---------------------------------
%>
<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>
<%
select case Makking
case ""
%>
<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="90%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#D8D8D8">
<tr>
<td valign="top" bgcolor="ffffff"> <br>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<form name="form" method="post" action="Journey_Manage.asp?Makking=Search">
<tr>
<td height="30" align="right">员工ID：</td>
<td height="30"> <input name="Employee_ID" type="text" id="Employee_ID" size="30"></td>
</tr>
<tr>
<td height="30" align="right">时间：</td>
<td height="30"> <select name="year1" class="all_box1">
<%
if Time_1 = "" then
Time_1 = Now()
end if
%>
<%for i=2005 to 2010%>
<option value="<%=i%>" <%if year(Time_1)=i then %>selected<% end if %>><%=i%>
</option>
<%next%>
</select>
年
<select name="month1" class="all_box1">
<%for i=1 to 12%>
<option value="<%=i%>"<%if month(Time_1)=i then %>selected<% end if %> ><%=i%>
</option>
<%next%>
</select>
月 </td>
</tr>
<tr>
<td height="30" align="right"> </td>
<td height="30"> <input name="imageField" type="image" src="Images/see.gif" width="36" height="21" border="0"></td>
</tr>
</form>
</table> </td>
</tr>
</table>
<%Case "Search"%>
<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>
<%
Dim YearStr,MonthStr,MonthArr,DayStr,Employee_ID
Employee_ID = Trim(Request("Employee_ID"))
YearStr = Year(Request("TimeStr"))
MonthStr = Month(Request("TimeStr"))
NextTime = Request("TimeStr")
IF NextTime = "" Then NextTime = Year(Now()) & "-" & Month(Now())
DayStr = Day(Now())
IF Request("TimeStr") = "" Then YearStr = Year(Now())
IF Request("TimeStr") = "" Then MonthStr = Month(Now())
IF MonthStr = 1 Then MonthArr = 31
IF MonthStr = 2 Then MonthArr = 29
IF MonthStr = 3 Then MonthArr = 31
IF MonthStr = 4 Then MonthArr = 30
IF MonthStr = 5 Then MonthArr = 31
IF MonthStr = 6 Then MonthArr = 30
IF MonthStr = 7 Then MonthArr = 31
IF MonthStr = 8 Then MonthArr = 31
IF MonthStr = 9 Then MonthArr = 30
IF MonthStr = 10 Then MonthArr = 31
IF MonthStr = 11 Then MonthArr = 30
IF MonthStr = 12 Then MonthArr = 31
%>
<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" 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"><%=MonthStr%>月</td>
<td width="38%" height="20" background="Images/box_bg.gif" bgcolor="ffffff">去向
<td width="38%" background="Images/box_bg.gif" bgcolor="ffffff">事由</td>
<td width="12%" background="Images/box_bg.gif" bgcolor="ffffff">操作</td>
</tr>
<%
For i = 1 to MonthArr
TimeStr = YearStr & "-" & MonthStr & "-" & i
Journey_Whither = ""
Journey_Causation = ""
Set Rs = Conn.Execute("Select * From Journey Where TimeStr = '"& TimeStr &"' AND Employee_ID = '"& Employee_ID &"'")
IF Not(Rs.Bof AND Rs.eof) Then
Journey_Whither = Rs("Journey_Whither")
Journey_Causation = Rs("Journey_Causation")
End if
Rs.Close
Set Rs = Nothing
%>
<tr align="left" bgcolor="ffffff" onmouseout="this.style.backgroundColor=''" onmouseover="this.style.backgroundColor='#F5F5F5'">
<td height="22" colspan="3"><%IF Year(Now()) &"-"& Month(Now()) &"-"& Day(Now()) = YearStr & "-" & MonthStr & "-" & i Then%><font color="#FF0000"><%End IF%><%=i%></FONT></td>
<td height="22"><%=Journey_Whither%></TD>
<td height="22"><%=Journey_Causation%></td>
<td height="22"><a href="javascript:Journey_See('<%=TimeStr%>','<%=Employee_ID%>')">查看</a></td>
</tr>
<%
next
%>
</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">
</td>
<td width="51%" height="24" align="right" valign="middle" background="Images/box_bg_1.gif"><a href="My_Journey.asp?TimeStr=<%= DateAdd("m",-1,NextTime)%>">上一月</a> <a href="My_Journey.asp?TimeStr=<%= DateAdd("m",+1,NextTime)%>">下一月</a> </td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="1" bgcolor="#E2E1E1"></td>
</tr>
</table> </td>
</tr>
</table> </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 Journey_See(TimeStr,Employee_ID){
window.open("Journey_See.asp?TimeStr="+TimeStr+"&Employee_ID="+Employee_ID+"","","width=500,height=280,scrollbars=yes");
}
//-->
</script>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?