文件操作 - TravelPlanReport.aspx

文件: E:\HostingSpaces\kimblycr\guard.kimbly.in\wwwroot\TravelPlanReport.aspx

编辑文件内容

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="TravelPlanReport.aspx.cs" Inherits="TravelPlanReport" %>
<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="asp" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server"></asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
<table class="style1">
<tr><td colspan="7"><h1>Travel Plan Report</h1><hr /></td></tr>
<tr><td width="10%">Date</td><td width="15%"><asp:TextBox ID="txtSDate" 
        runat="server" AutoPostBack="True" ontextchanged="txtSDate_TextChanged"></asp:TextBox>
<asp:CalendarExtender ID="txtSDate_CalendarExtender" runat="server" Enabled="True" TargetControlID="txtSDate" Format="dd-MMM-yy"></asp:CalendarExtender></td>
<td width="10%">Site</td>
<td width="15%">
<asp:DropDownList ID="DDLSites" runat="server" DataSourceID="SqlDataSource2" DataTextField="SiteName" DataValueField="AutoID" Width="200px" 
AutoPostBack="True" onselectedindexchanged="DDLSites_SelectedIndexChanged"></asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ApplicationServices %>" SelectCommand="SELECT [AutoID], [SiteName] FROM [Sites]"></asp:SqlDataSource>
</td>
<td width="10%">Plan</td>
<td width="15%">
<asp:DropDownList ID="DDLPlans" runat="server" DataSourceID="SqlDataSource1" DataTextField="Name" DataValueField="AutoID" Width="100px">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:GuardCentralConnectionString %>" SelectCommand="GetTravelPlanForSiteDate" SelectCommandType="StoredProcedure">
<SelectParameters><asp:Parameter Name="SiteID" Type="Int32" /><asp:Parameter Name="PlanDate" Type="DateTime" /></SelectParameters></asp:SqlDataSource>
</td>
<td style="text-align: center"><asp:ImageButton ID="BtnSearch" runat="server" ImageUrl="~/Images/Search.png" onclick="BtnSearch_Click" />
</td></tr>
<tr><td colspan="7"><hr /></td></tr>
<tr><td colspan="3" style="width: 20%">
    <asp:Label ID="lblTimePlanned" runat="server" style="font-weight: 700"></asp:Label>
    </td>
<td width="15%" colspan="2" style="width: 25%">
    <asp:Label ID="lblTT" runat="server" style="font-weight: 700"></asp:Label>
</td>
<td width="15%">
    &nbsp;</td>
<td style="text-align: center">&nbsp;</td></tr><tr><td colspan="7">
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            CellPadding="4" DataSourceID="SqlDataSource3" ForeColor="#333333" 
            GridLines="None" Width="100%">
            <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
            <Columns>
                <asp:BoundField DataField="point" HeaderText="Point" SortExpression="point" />
                <asp:BoundField DataField="Status" HeaderText="Status" 
                    SortExpression="Status" />
                <asp:BoundField DataField="Employee" HeaderText="Employee" 
                    SortExpression="Employee" />
                <asp:BoundField DataField="TimePlanned" HeaderText="TimePlanned" 
                    SortExpression="TimePlanned" />
                <asp:BoundField DataField="TimeReached" HeaderText="TimeReached" 
                    SortExpression="TimeReached" />
            </Columns>
            <EditRowStyle BackColor="#999999" />
            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" 
                HorizontalAlign="Left" />
            <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="SqlDataSource3" runat="server" 
            ConnectionString="<%$ ConnectionStrings:GuardCentralConnectionString %>" 
            SelectCommand="GetPlanExecution" SelectCommandType="StoredProcedure">
            <SelectParameters>
                <asp:Parameter Name="PlanID" Type="Int32" />
                <asp:Parameter Name="SiteID" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
        </td></tr></table>
</asp:Content>

文件操作 - TravelPlanReport.aspx

文件: E:\HostingSpaces\kimblycr\guard.kimbly.in\wwwroot\TravelPlanReport.aspx

编辑文件内容

修改文件时间

删除文件