文件操作 - AttendanceSheet.aspx
返回文件管理
返回主菜单
删除本文件
文件: E:\HostingSpaces\kimblycr\howell.kimbly.in\wwwroot\Reports1\Monthly\AttendanceSheet.aspx
编辑文件内容
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="AttendanceSheet.aspx.cs" Inherits="HowellWebService.Reports1.Monthly.AttendanceSheet" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> <link href="../../css/bootstrap.min.css" rel="stylesheet" /> </head> <body> <form id="form1" runat="server"> <div style="width:100%; margin-left:10px"><h4> Attendance Sheet</h4><hr style="width:100%" /> </div> <div style="width:100%; margin-left:10px"><div style="width:15%; float:left"> <asp:TextBox ID="txtYear" runat="server" placeholder="Year"></asp:TextBox> </div> <div style="width:15%; float:left; margin-left:10px">Month</div><div style="width:20%; float:left"> <asp:DropDownList ID="DDLMonth" runat="server" Height="24px" Width="172px"> <asp:ListItem Value="1">January</asp:ListItem> <asp:ListItem Value="2">February</asp:ListItem> <asp:ListItem Value="3">March</asp:ListItem> <asp:ListItem Value="4">April</asp:ListItem> <asp:ListItem Value="5">May</asp:ListItem> <asp:ListItem Value="6">June</asp:ListItem> <asp:ListItem Value="7">July</asp:ListItem> <asp:ListItem Value="8">August</asp:ListItem> <asp:ListItem Value="9">September</asp:ListItem> <asp:ListItem Value="10">October</asp:ListItem> <asp:ListItem Value="11">November</asp:ListItem> <asp:ListItem Value="12">December</asp:ListItem> </asp:DropDownList> </div> <div style="width:15%; float:left"> <asp:Button ID="BtnSearch" runat="server" Text="Search" CssClass="btn btn-success" OnClick="BtnSearch_Click" /> </div> <div style="width:15%; float:left"> <asp:Button ID="BtnExcel" runat="server" Text="Excel" CssClass="btn btn-default" OnClick="BtnExcel_Click" /> </div> </div> <div style="width:100%; margin-left:10px"> <hr style="width:100%" /> </div> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1"> <Columns> <asp:BoundField DataField="EmployeeCode" HeaderText="EmployeeCode" SortExpression="EmployeeCode" /> <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" /> <asp:BoundField DataField="Designation" HeaderText="Designation" SortExpression="Designation" /> <asp:BoundField DataField="JoinDate" DataFormatString="{0:dd-MMM-yy}" HeaderText="JoinDate" SortExpression="JoinDate" /> <asp:BoundField DataField="NoOfWorkingDays" HeaderText="NoOfWorkingDays" SortExpression="NoOfWorkingDays" /> <asp:BoundField DataField="CasualLeaveTaken" HeaderText="CasualLeaveTaken" SortExpression="CasualLeaveTaken" /> <asp:BoundField DataField="MedicalLeaveTaken" HeaderText="MedicalLeaveTaken" SortExpression="MedicalLeaveTaken" /> <asp:BoundField DataField="AccidentalLeaveTaken" HeaderText="AccidentalLeaveTaken" SortExpression="AccidentalLeaveTaken" /> <asp:BoundField DataField="LWP" HeaderText="LWP" SortExpression="LWP" /> <asp:BoundField DataField="BalanceCL" HeaderText="BalanceCL" SortExpression="BalanceCL" /> <asp:BoundField DataField="BalanceML" HeaderText="BalanceML" SortExpression="BalanceML" /> <asp:BoundField DataField="BalanceLWP" HeaderText="BalanceLWP" SortExpression="BalanceLWP" /> <asp:BoundField DataField="BalanceAccidentalLeave" HeaderText="BalanceAccidentalLeave" SortExpression="BalanceAccidentalLeave" /> <asp:BoundField DataField="NetDays" HeaderText="NetDays" SortExpression="NetDays" /> </Columns> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ApplicationServices %>" SelectCommand="GetAttendanceSheet" SelectCommandType="StoredProcedure"></asp:SqlDataSource> </form> </body> </html>
修改文件时间
将文件时间修改为当前时间的前一年
删除文件