文件操作 - Attendance.aspx
返回文件管理
返回主菜单
删除本文件
文件: E:\HostingSpaces\kimblycr\json.kimbly.in\wwwroot\Attendance.aspx
编辑文件内容
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Attendance.aspx.cs" Inherits="ConnectionsJSONService.Attendance" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head id="Head1" runat="server"><title>Field Visits</title> <link href="css/bootstrap.min.css" rel="stylesheet" type="text/css" /> </head> <body> <form id="form1" runat="server"> <div style="width:100%"> <div style="float:left;width:15%; padding-top:5px; padding-left:5px"> <asp:TextBox ID="txtName" runat="server" CssClass="form-control" style="margin-bottom: 5px;"></asp:TextBox> </div> <div style="float:left;width:5%;margin-top: 10px;margin-left: 10px;">Start</div> <div style="float:left;width:15%;padding-top:5px; padding-left:5px" > <asp:TextBox ID="txtSDate" type="Date" runat="server" CssClass="form-control" style="margin-bottom: 5px;"></asp:TextBox> </div> <div style="float:left;width:5%;margin-top: 10px;margin-left: 10px;">End</div> <div style="float:left;width:15%;padding-top:5px; padding-left:5px" > <asp:TextBox ID="txtEDate" type="Date" runat="server" CssClass="form-control" style="margin-bottom: 5px;"></asp:TextBox> </div> <div style="float:left; padding-top:5px; padding-left:5px"> <asp:Button ID="BtnSearch" runat="server" Text="Search" CssClass="btn btn-success" onclick="BtnSearch_Click" /> </div> <div style="float:left; padding-top:5px; padding-left:5px"> <h5> </h5> </div> <hr style="width:100%"/> </div> <div style="width:100%"> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4" DataKeyNames="ID" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None" Width="100%"> <AlternatingRowStyle BackColor="White" ForeColor="#284775" /> <Columns><asp:BoundField DataField="ID" HeaderText="ID" SortExpression="ID" InsertVisible="False" ReadOnly="True" Visible="False" /> <asp:BoundField DataField="FullName" HeaderText="Name" SortExpression="FullName" /> <asp:BoundField DataField="AttnDate" HeaderText="Date" DataFormatString="{0:dd-MMM}" SortExpression="AttnDate" /> <asp:BoundField DataField="DayIN" HeaderText="DayIN" DataFormatString="{0:hh-mm tt}" SortExpression="DayIN" /> <asp:BoundField DataField="DayOut" DataFormatString="{0:hh-mm tt}" HeaderText="DayOut" SortExpression="DayOut" /> <asp:BoundField DataField="totalTime" HeaderText="TotalTime" SortExpression="totalTime" /> <asp:BoundField DataField="INAddress" HeaderText="INAddress" SortExpression="INAddress" /> <asp:BoundField DataField="OutAddress" HeaderText="OutAddress" SortExpression="OutAddress" /> </Columns> <EditRowStyle BackColor="#999999" /><FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /><PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" /> <RowStyle BackColor="#F7F6F3" ForeColor="#333333" /><SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" /> <SortedAscendingCellStyle BackColor="#E9E7E2" /><SortedAscendingHeaderStyle BackColor="#506C8C" /> <SortedDescendingCellStyle BackColor="#FFFDF8" /><SortedDescendingHeaderStyle BackColor="#6F8DAE" /> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ApplicationServices %>" SelectCommand="GetAttendanceByDate" SelectCommandType="StoredProcedure"> <SelectParameters><asp:Parameter DbType="Date" Name="SDate" /> <asp:Parameter Name="EDate" DbType="Date" /> <asp:Parameter Name="name" Type="String" /> </SelectParameters> </asp:SqlDataSource> </div> </form> </body> </html>
修改文件时间
将文件时间修改为当前时间的前一年
删除文件