📄 empmain_hol_disp.asp

📁 欢迎大家分享本系统为bs架构的asp+access版本。<br>包含：员工信息
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/EmpMain.asp" -->
<!--#include file="EmpMain_CheckRight.asp"-->
<%
if request.QueryString("pagetype") <> "" and request.QueryString("pagetype") <> "Base" then
if request.QueryString("pagetype") <> "hol" then
url = "empmain_" &request.QueryString("pagetype")& "_Disp.asp?ID=" & request.QueryString("ID") & "&pagetype=" & request.QueryString("pagetype")
response.Redirect(url)
response.end 
end if
end if
%>
<%call fnCheckRight("holinfo","1")%>
<%
Dim HD__MMColParam
HD__MMColParam = "1"
If (Request.QueryString("ID") <> "") Then 
  HD__MMColParam = Request.QueryString("ID")
End If
%>
<%
Dim HD
Dim HD_numRows

Set HD = Server.CreateObject("ADODB.Recordset")
HD.ActiveConnection = MM_EmpMain_STRING
HD.Source = "SELECT * FROM Holiday WHERE EmpID = " + Replace(HD__MMColParam, "'", "''") + ""
HD.CursorType = 0
HD.CursorLocation = 2
HD.LockType = 1
HD.Open()

HD_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index

Repeat1__numRows = -1
Repeat1__index = 0
HD_numRows = HD_numRows + Repeat1__numRows
%>
<html>

<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>考勤记录</title>
<link rel="stylesheet" href="CSS/SellWellWeb.css" type="text/css">
<script>
var objClassName
function HLItem(obj){
	obj.oldClassName=obj.className;
	obj.className="ListValuehighlight";
}

function Re(obj){
 obj.className=obj.oldClassName 
}

function doEdit(ID){
  window.location ="EmpMain_hol_Edit.asp?EmpID=<%=Request.QueryString("ID")%>&ID="+ID
}
</script>
</head>

<body class="body">
<form method="POST" action="EmpMain_hol_AddNew.asp" name="form1">
  <fieldset style="padding: 2" class="fiedset"> <legend>考勤记录</legend> 
  <table border="0" cellpadding="0" cellspacing="0" class="table" bordercolor="#111111" width="98%" align="center">
    <tr> 
      <td width="12%" align="center" nowrap class="listTitle">假期类型</td>
      <td width="37%" align="center" nowrap class="listTitle">起讫日期</td>
      <td width="17%" align="center" nowrap class="listTitle">天数</td>
      <td width="16%" align="center" nowrap class="listTitle">公休剩余</td>
      <td width="18%" align="center" nowrap class="listTitle">扣薪天数</td>
    </tr>
<% If HD.EOF And HD.BOF Then %>
    <tr class="ListValueWhite">     
      <td colspan="5">没有记录!</td>
    </tr>
<% End If ' end HD.EOF And HD.BOF %>
	<%i=-1%>
    <% 
While ((Repeat1__numRows <> 0) AND (NOT HD.EOF)) 
%>
	<%
i = i + 1
if i mod 2 = 0 then
className = "listValueWhite"
else
className = "listValuegray"
end if
%>
    <tr class="<%=className%>" onClick="doEdit('<%=(HD.Fields.Item("ID").Value)%>')" style="cursor:hand" onMouseOver="HLItem(this)" onMouseOut="Re(this)"> 
      <td><%=(HD.Fields.Item("HDType").Value)%></td>
      <td><%=(HD.Fields.Item("HDFrom").Value)%>至<%=(HD.Fields.Item("HDTo").Value)%></td>
      <td><%=(HD.Fields.Item("HDDayCount").Value)%></td>
      <td><%=(HD.Fields.Item("HDYearHolLeave").Value)%></td>
      <td><%=(HD.Fields.Item("HDNoPayCount").Value)%></td>
    </tr>
    <% 
  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  HD.MoveNext()
Wend
%>
  </table>
  </fieldset> 
  <div align="right">
  <input type="hidden" name="EmpID" value="<%=request.QueryString("ID")%>">
    <input type="submit" value="添加" name="B1" class="button">
  </div>
</form>

</body>

</html>
<%
HD.Close()
Set HD = Nothing
%>
⌨️ 快捷键说明

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