开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Internet/网络编程 > WEB源码(ASP,PHP,...) > 查看源码
SearchData.aspx
资源名称：OAJP.rar　[点击查看]
上传用户：jdb8708888
上传日期：2013-05-29
资源大小：19971k
文件大小：10k
源码类别：

WEB源码(ASP,PHP,...)

开发平台：

C#

SearchData.aspx：源码内容
  1. <%@ Import namespace="System"%>
  2. <%@ Import namespace="System.Data"  %>
  3. <%@ Page language="c#" Codebehind="SearchData.aspx.cs" AutoEventWireup="false" Inherits="UDS.SubModule.WorkAttendance.SearchData" %>
  4. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
  5. <HTML>
  6. <HEAD>
  7. <title>SearchData</title>
  8. <META http-equiv="Content-Type" content="text/html; charset=gb2312">
  9. <meta content="Microsoft Visual Studio 7.0" name="GENERATOR">
  10. <meta content="C#" name="CODE_LANGUAGE">
  11. <meta content="JavaScript" name="vs_defaultClientScript">
  12. <meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
  13. <LINK href="../../Css/BasicLayout.css" type="text/css" rel="stylesheet">
  14. <script language="JavaScript" src="../../Css/meizzDate.js"></script>
  15. <script language="javascript">
  16. function fillstring(str)
  17. {
  18. if(str.length==1)
  19. {
  20. str = "0" + str; 
  21. }
  22. return(str);
  23. }
  24. function quickseldate(type)
  25. {
  26. var begintime,endtime;
  27. var oneminute = 60*1000;
  28. var onehour   = 60*oneminute;
  29. var oneday    = 24*onehour;
  30. var oneweek   = 7*oneday;
  32. var todayDate = new Date();
  33. var date = todayDate.getDate();
  34. var month= todayDate.getMonth() +1;
  35. var year= todayDate.getYear();
  36. var day = todayDate.getDay();
  37. if(navigator.appName == "Netscape")
  38. {
  39. year = 1900 + year;
  40. }
  42. //-->
  44. if(type=="day")
  45. {
  46. begintime = year.toString() + "-" + fillstring(month.toString()) + "-" + fillstring(date.toString());
  47. endtime = begintime;
  48. }
  49. else if(type=="week")
  50. {
  51. var daytoMon = day-1;
  52. if(day==0) 
  53. daytoMon = 6;
  55. todayDate.setTime(todayDate.getTime()-daytoMon*oneday);
  56. date = todayDate.getDate();
  57. month= todayDate.getMonth() +1;
  58. year= todayDate.getYear();
  59. day = todayDate.getDay();
  61. begintime = year.toString() + "-" + fillstring(month.toString()) + "-" + fillstring(date.toString());
  63. todayDate.setTime(todayDate.getTime()+6*oneday);
  65. date = todayDate.getDate();
  66. month= todayDate.getMonth() +1;
  67. year= todayDate.getYear();
  69. endtime = year.toString() + "-" + fillstring(month.toString()) + "-" + fillstring(date.toString());
  70. }
  71. else if(type=="month")
  72. {
  73. var dateto1 = date-1;
  75. todayDate.setTime(todayDate.getTime()-dateto1*oneday);
  76. date = todayDate.getDate();
  77. month= todayDate.getMonth() +1;
  78. year= todayDate.getYear();
  79. day = todayDate.getDay();
  81. begintime = year.toString() + "-" + fillstring(month.toString()) + "-" + fillstring(date.toString());
  83. todayDate.setMonth(month);
  84. todayDate.setTime(todayDate.getTime()-oneday);
  86. date = todayDate.getDate();
  87. month= todayDate.getMonth() +1;
  88. year= todayDate.getYear();
  90. endtime = year.toString() + "-" + fillstring(month.toString()) + "-" + fillstring(date.toString());
  92. }
  94. document.getElementById("txtbegintime").value = begintime;
  95. document.getElementById("txtendtime").value = endtime;
  97. }
  98. </script>
  99. <script language="C#" runat="server">
  100.  string  GetGridData(string staffid,int type)
  101.  {
  103. //type:0 正常 1：迟到 2：早退 3：未考勤 4：总考勤天数
  104. switch(type)
  105. {
  106. case 0:
  107. dvw.RowFilter = "OnDuty_Status = false and OffDuty_Status = false and staff_id="+staffid;
  108. break;
  109. case 1:
  110. dvw.RowFilter = "OnDuty_Status=true and staff_id="+staffid;
  111. break;
  112. case 2:
  113. dvw.RowFilter = "OffDuty_Status = true and staff_id="+staffid;
  114. break;
  115. case 3:
  116. dvw.RowFilter = "staff_id=" + staffid;
  117. return((dvw1.Count - dvw.Count).ToString());
  118. break;
  119. case 4:
  120. break;
  121. }
  122. return(dvw.Count.ToString());
  123.  
  124.  } 
  125. </script>
  126. </HEAD>
  127. <body leftMargin="0" topMargin="0">
  128. <form id="SearchData" method="post" runat="server">
  129. <FONT face="宋体">
  130. <TABLE id="Table1" borderColor="#111111" height="1" cellSpacing="0" cellPadding="0" width="100%"
  131. border="0">
  132. <TR height="30">
  133. <TD class="GbText" width="3%" background="../../Images/treetopbg.jpg" bgColor="#c0d9e6"><FONT color="#003366" size="3"><IMG alt="" src="../../DataImages/kaoqin2.gif"></FONT></TD>
  134. <TD class="GbText" background="../../Images/treetopbg.jpg" bgColor="#c0d9e6"><B><B>考勤查询</B></B></TD>
  135. </TR>
  136. </TABLE>
  137. <TABLE class="GBText" id="Table1" style="BORDER-COLLAPSE: collapse; HEIGHT: 242px" borderColor="#93bee2"
  138. height="242" cellSpacing="1" cellPadding="1" width="100%" border="1" DESIGNTIMEDRAGDROP="56">
  139. <TR>
  140. <TD style="WIDTH: 84px">输入时间段</TD>
  141. <TD>开始时间：
  142. <asp:textbox id="txtbegintime" onfocus="setday(this);" runat="server" CssClass="inputcss" Columns="10"
  143. ReadOnly="True"></asp:textbox><asp:requiredfieldvalidator id="RequiredFieldValidator1" runat="server" Display="None" ControlToValidate="txtbegintime"
  144. ErrorMessage="开始时间不能为空"></asp:requiredfieldvalidator>--结束时间
  145. <asp:textbox id="txtendtime" onfocus="setday(this);" runat="server" CssClass="inputcss" Columns="10"
  146. ReadOnly="True"></asp:textbox><asp:requiredfieldvalidator id="RequiredFieldValidator2" runat="server" Display="None" ControlToValidate="txtendtime"
  147. ErrorMessage="结束不能为空"></asp:requiredfieldvalidator>&nbsp;
  148. <asp:comparevalidator id="cvdate" runat="server" Display="None" ControlToValidate="txtendtime" ErrorMessage="结束时间应该大于开始时间"
  149. Operator="GreaterThanEqual" ControlToCompare="txtbegintime"></asp:comparevalidator>&nbsp;
  150. <asp:radiobutton id="rbtnthisweek" onclick="quickseldate('week');" runat="server" Text="本周" GroupName="quickdate"></asp:radiobutton><asp:radiobutton id="rbtnthismonth" onclick="quickseldate('month');" runat="server" Text="本月" GroupName="quickdate"></asp:radiobutton></TD>
  151. </TR>
  152. <TR>
  153. <TD style="WIDTH: 84px">查找范围</TD>
  154. <TD><asp:dropdownlist id="ddlsearchbound" runat="server" Width="300px" AutoPostBack="True">
  155. <asp:ListItem Value="0" Selected="True">公司</asp:ListItem>
  156. <asp:ListItem Value="1">职位</asp:ListItem>
  157. <asp:ListItem Value="2">个人</asp:ListItem>
  158. </asp:dropdownlist></TD>
  159. </TR>
  160. <TR>
  161. <TD style="WIDTH: 84px">请选择</TD>
  162. <TD><asp:listbox id="lbstaffs" runat="server" CssClass="inputcss" Width="150px" SelectionMode="Multiple"
  163. Height="141px" Visible="False"></asp:listbox><asp:dropdownlist id="ddldepartments" runat="server" Width="150px" Visible="False"></asp:dropdownlist></TD>
  164. </TR>
  165. <TR>
  166. <TD style="WIDTH: 84px"></TD>
  167. <TD><asp:validationsummary id="vs1" runat="server"></asp:validationsummary></TD>
  168. </TR>
  169. <TR>
  170. <TD align="center" colSpan="2" height="30"><asp:button id="btnsearch" runat="server" CssClass="buttoncss" Text=" 查  询 "></asp:button></TD>
  171. </TR>
  172. <TR>
  173. <TD align="right" colSpan="2"><asp:datagrid id="AttendanceGrid" runat="server" Width="100%" CellPadding="3" BorderWidth="1px"
  174. BorderColor="#93BEE2" DataKeyField="staff_id" EnableViewState="False" AutoGenerateColumns="False">
  175. <HeaderStyle Font-Size="X-Small" BackColor="#E8F4FF"></HeaderStyle>
  176. <Columns>
  177. <asp:BoundColumn DataField="realname" HeaderText="姓名">
  178. <ItemStyle Font-Size="X-Small"></ItemStyle>
  179. <FooterStyle Font-Size="X-Small"></FooterStyle>
  180. </asp:BoundColumn>
  181. <asp:TemplateColumn HeaderText="正常天数">
  182. <ItemTemplate>
  183. <asp:HyperLink Text ='<%# GetGridData(((DataRowView)Container.DataItem)["Staff_ID"].ToString(),0)%>' NavigateUrl='<%# "tmpStaffData.aspx?staffid="+((DataRowView)Container.DataItem)["Staff_ID"].ToString()+"&begintime="+txtbegintime.Text+"&endtime="+txtendtime.Text+"&type=1"%>' Target=_blank Runat=server>
  184. </asp:HyperLink>
  185. </ItemTemplate>
  186. </asp:TemplateColumn>
  187. <asp:TemplateColumn HeaderText="迟到天数">
  188. <ItemTemplate>
  189. <asp:HyperLink Text ='<%# GetGridData(((DataRowView)Container.DataItem)["Staff_ID"].ToString(),1)%>' NavigateUrl='<%# "tmpStaffData.aspx?staffid="+((DataRowView)Container.DataItem)["Staff_ID"].ToString()+"&begintime="+txtbegintime.Text+"&endtime="+txtendtime.Text+"&type=2"%>' Target=_blank Runat=server>
  190. </asp:HyperLink>
  191. </ItemTemplate>
  192. </asp:TemplateColumn>
  193. <asp:TemplateColumn HeaderText="早退天数">
  194. <ItemTemplate>
  195. <asp:HyperLink Text ='<%# GetGridData(((DataRowView)Container.DataItem)["Staff_ID"].ToString(),2)%>' NavigateUrl='<%# "tmpStaffData.aspx?staffid="+((DataRowView)Container.DataItem)["Staff_ID"].ToString()+"&begintime="+txtbegintime.Text+"&endtime="+txtendtime.Text+"&type=3"%>' Target=_blank Runat=server>
  196. </asp:HyperLink>
  197. </ItemTemplate>
  198. </asp:TemplateColumn>
  199. <asp:TemplateColumn HeaderText="未考勤天数">
  200. <ItemTemplate>
  201. <asp:HyperLink Text ='<%# GetGridData(((DataRowView)Container.DataItem)["Staff_ID"].ToString(),3)%>' NavigateUrl='<%# "tmpStaffData.aspx?staffid="+((DataRowView)Container.DataItem)["Staff_ID"].ToString()+"&begintime="+txtbegintime.Text+"&endtime="+txtendtime.Text+"&type=4"%>' Target=_blank Runat=server>
  202. </asp:HyperLink>
  203. </ItemTemplate>
  204. </asp:TemplateColumn>
  205. <asp:TemplateColumn HeaderText="总考勤天数">
  206. <ItemTemplate>
  207. <asp:HyperLink Text ='<%# GetGridData(((DataRowView)Container.DataItem)["Staff_ID"].ToString(),4)%>' NavigateUrl='<%# "tmpStaffData.aspx?staffid="+((DataRowView)Container.DataItem)["Staff_ID"].ToString()+"&begintime="+txtbegintime.Text+"&endtime="+txtendtime.Text+"&type=5"%>' Target=_blank Runat=server ID="Hyperlink1" NAME="Hyperlink1">
  208. </asp:HyperLink>
  209. </ItemTemplate>
  210. </asp:TemplateColumn>
  211. </Columns>
  212. </asp:datagrid><INPUT class="buttoncss" id="btn_Report" type="button" value="打印报表" style="DISPLAY:none"
  213. runat="server"></TD>
  214. </TR>
  215. </TABLE>
  216. </FONT>
  217. </form>
  218. </body>
  219. </HTML>