<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="departmentattendance.aspx.cs" Inherits="Web.kq.show.departmentattendance" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
    <title>OA标题页</title>
    <link href="../../css/css.css" rel="stylesheet" type="text/css" />
    <meta http-equiv="Content-Type" content="text/html; charset=GB2312" />
    <script type="text/javascript" src="../../css/popcalendar.js"></script>
</head>
<body>
    <form id="fom" runat="server">
        <div id ="main-c-03-right" >
            <table cellpadding="0"; cellspacing ="0"; style =" width :100%;background-image: url('../../css/images/right_top.png'); background-repeat :repeat-x" >
                <tr>
                    <td style ="width :720px; height :34px;  background-image: url('../../css/images/atghtj.png');	background-repeat: no-repeat;
                	background-position: left top;"><div id="main-c-03-right02-top">
                	   <!--这里添加页面标题 -->
                      	考勤查询
                      	
                	</div></td>
                </tr>
            </table>
            <div id="main-c-03-right02-main">
                <asp:Panel ID="pnAll" runat="server">
            <div >                       
             部门：<asp:DropDownList ID="ddlDepartment" runat="server"> </asp:DropDownList>
             &nbsp;人员编号或姓名：<asp:TextBox ID="tbStaff" runat="server"></asp:TextBox>
             &nbsp;&nbsp; 起始日期：<asp:textbox id="date1" runat="server" Width="65px"  onclick="popUpCalendar(this,this,'yyyy-mm-dd')"></asp:textbox>
             终止日期：<asp:textbox id="date2" runat="server" Width="65px"   onclick="popUpCalendar(this,this,'yyyy-mm-dd')"> </asp:textbox>
       <asp:Button ID="btQuery1" runat="server" onclick="btnQuery_Click" Text="提交查询" ValidationGroup="Inquires" 
                  />
                &nbsp;<asp:RegularExpressionValidator ID="RegularExpressionValidator4" runat="server" 
            ControlToValidate="tbStaff" Display="Dynamic" ErrorMessage="输入的人员编号或姓名不对！" 
            ValidationExpression="^[^%&gt;&lt;'&amp;*=!&quot;?]{0,25}$" 
                 ValidationGroup="Inquires" ForeColor="Red"></asp:RegularExpressionValidator>
                        <asp:RequiredFieldValidator ID="RequiredFieldValidator4" 
                  runat="server" ControlToValidate="date1" Display="Dynamic" 
                  ErrorMessage="起始日期必填！" ValidationGroup="Inquires" ForeColor="Red"></asp:RequiredFieldValidator>
              <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" 
                  ControlToValidate="date2" Display="Dynamic" ErrorMessage="终止日期必填！" 
                 ValidationGroup="Inquires" ForeColor="Red"></asp:RequiredFieldValidator>
              <asp:RegularExpressionValidator ID="RegularExpressionValidator5" runat="server" 
                  ControlToValidate="date1" Display="Dynamic" ErrorMessage="请填正确日期格式：如2001-01-01" 
                  ValidationExpression="\d{4}-\d{2}-\d{2}" ValidationGroup="Inquires" 
                    ForeColor="Red"></asp:RegularExpressionValidator>
              <asp:RegularExpressionValidator ID="RegularExpressionValidator6" runat="server" 
                  ControlToValidate="date2" Display="Dynamic" ErrorMessage="请填正确日期格式：如2001-01-01" 
                  ValidationExpression="\d{4}-\d{2}-\d{2}" ValidationGroup="Inquires"></asp:RegularExpressionValidator>
             说明：1、终止日期要大于起始日期；2、日期间隔不大于1年。</div>
            
<!--栏目开始 -->
            <table style ="width :100%" border="0" align="center" cellpadding="0" cellspacing="0" class="ziti04">
               <tr>
                    <td style ="font-weight:bolder;background-image: url('../../css/images/asdfrsg.png'); height :33px; padding-left :20px">
                    <!--这里添加栏目标题 -->
                    部门考勤明细
                    
                     &gt;&gt;</td>
                    <td style ="background-image: url('../../css/images/asdfrsg.png'); text-align :right "><asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" 
                                                ControlToValidate="tbNum" Display="Dynamic" ErrorMessage="行数不能为空。" 
                                                ValidationGroup="Inquires"></asp:RequiredFieldValidator>
                                            <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" 
                                                ControlToValidate="tbNum" Display="Dynamic" ErrorMessage="请输入大于0的整数。" 
                                                ValidationExpression="^\+?[1-9][0-9]*$" ToolTip="RowNum" 
                                                ValidationGroup="Inquires"></asp:RegularExpressionValidator></td>
                    <td style ="background-image: url('../../css/images/asdfrsg.png'); width :164px"> 每页显示行数：<asp:TextBox ID="tbNum" runat="server" 
                    Width="44px" MaxLength="4">20</asp:TextBox></td>
                    <td  style ="background-image: url('../../css/images/asdfrsg.png'); width :76px" ><asp:Button ID="btnQuery" runat="server" onclick="btnQuery_Click" Text="确定" ToolTip="RowNum" 
                                                ValidationGroup="Inquires" /> </td>
                </tr>
                <tr>
                    <td height="10" colspan="4" style="font-weight:bolder;"></td>
                </tr>
            </table>
            <!--这里添加内容 -->
                    <asp:GridView ID="GridView1" runat="server" BorderWidth="1px" 
                onrowdatabound="GridView1_RowDataBound" Width="100%" CssClass="gv" 
                        AutoGenerateColumns="False" onrowcreated="GridView1_RowCreated">
            <RowStyle HorizontalAlign="Center" VerticalAlign="Middle" BorderWidth="1px" 
                CssClass="gvrow" />
                  <Columns>
                <asp:BoundField DataField="id" HeaderText="序号" ReadOnly="True" />
                <asp:BoundField DataField="staffid" HeaderText="人员编号" ReadOnly="True" />
                <asp:BoundField DataField="staffname" HeaderText="姓名" ReadOnly="True" />
                <asp:BoundField DataField="department" HeaderText="部门" ReadOnly="True" />
                <asp:BoundField DataField="attendancedetails" HeaderText="考勤记录" ReadOnly="True" />
                <asp:BoundField DataField="remarks" HeaderText="备注" ReadOnly="True" />

                </Columns>
            <HeaderStyle BorderWidth="1px" CssClass="gvhead" />
        </asp:GridView>
		<table cellpadding="0" cellspacing="0" style ="width :100%">
              <tr>
                  <td style =" padding-left :5px; text-align :left  "> <asp:Label ID="lbRowscountview" runat="server" 
                ForeColor="Red"></asp:Label>
                        <br />
                  </td>
                  <td  id ="allowpage" runat ="server" style ="text-align :right ;  padding-right  :5px">
                      &nbsp;</td>
              </tr>
          </table>
<asp:Panel ID="plOutput" runat="server" Visible ="false" >
            <div class =" td_rightnoborder  ">      
                <asp:Button ID="btPrintView" runat="server" Text="打印预览" 
                  onclick="btPrintView_Click"  />
                <asp:Button ID="btExcel" runat="server" onclick="btExcel_Click" 
                    Text="导出到EXCEL" />
            </div>
              </asp:Panel>

<!--栏目结束 -->
    </asp:Panel>
               

                </div>
            </div>
        </form>
    </body>
</html>
