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

📄 my_journey.asp

📁 适用于网络/信息企业
💻 ASP
字号:
<!--#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 ""
%>
<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">管理中心 &gt;&gt;&gt; 我的行程</span></td>
                <td width="10%" align="right">&nbsp;</td>
            </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
</table>
<%
Dim YearStr,MonthStr,MonthArr,DayStr

	YearStr  = Year(Request.QueryString("TimeStr"))
	MonthStr = Month(Request.QueryString("TimeStr"))
	
	NextTime = Request.QueryString("TimeStr")
	
 IF NextTime = "" Then NextTime = Year(Now()) & "-" & Month(Now())
	
	DayStr   = Day(Now())
	
 IF Request.QueryString("TimeStr")  = "" Then YearStr  = Year(Now())
 IF Request.QueryString("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 = '"& Session("Eboer_CRM_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_Add('<%=TimeStr%>')">修改</a>|<A href="javascript:Journey_Del('<%=TimeStr%>')"  onClick="return confirm('清除后将不可恢复,您确定要这样操作吗?')">清除</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">&nbsp; 
                </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>&nbsp;<a href="My_Journey.asp?TimeStr=<%= DateAdd("m",+1,NextTime)%>">下一月</a>&nbsp;&nbsp;</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_Add(TimeStr){
        window.open("Journey_Add.asp?TimeStr="+TimeStr+"","","width=500,height=280,scrollbars=yes");
    }
    function Journey_Del(TimeStr){
        window.open("Journey_Del.asp?TimeStr="+TimeStr+"","","width=500,height=280,scrollbars=yes");
    }
//-->
</script>

⌨️ 快捷键说明

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