文件操作 - ShiftReport.aspx

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

编辑文件内容

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="ShiftReport.aspx.cs" Inherits="ShiftReport" %>
<%@ 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>Shift Report</h1><hr /></td></tr>
<tr>
<td width="10%">
    Date</td>
<td width="15%">
<asp:TextBox ID="txtSDate" runat="server"></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%">Shift</td>
<td width="15%">
    <asp:DropDownList ID="DDLShifts" runat="server" DataSourceID="SqlDataSource3" 
        DataTextField="Name" DataValueField="AutoID" Width="100px">
    </asp:DropDownList>
    <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ApplicationServices %>" 
        SelectCommand="SELECT [AutoID], [Name] FROM [Shifts] WHERE ([SiteID] = @SiteID)">
        <SelectParameters>
            <asp:ControlParameter ControlID="DDLSites" Name="SiteID" 
                PropertyName="SelectedValue" Type="Int32" />
        </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">
                
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        CssClass="DDGridView" HeaderStyle-CssClass="th" RowStyle-CssClass="td" 
        DataSourceID="SqlDataSource1" Width="50%" onrowcommand="GridView1_RowCommand">
<Columns>
<asp:TemplateField HeaderText="RouteName" SortExpression="RouteName">
<ItemTemplate><asp:Label ID="lblRoute" runat="server" Text='<%# Bind("RouteName") %>'></asp:Label></ItemTemplate>
</asp:TemplateField>
    <asp:TemplateField HeaderText="StartTime" SortExpression="StartTime">
        <ItemTemplate>
            <asp:Label ID="lblstime" runat="server" Text='<%# Bind("StartTime") %>'></asp:Label>
        </ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="EndTime" SortExpression="EndTime">
        <ItemTemplate>
            <asp:Label ID="lbleTime" runat="server" Text='<%# Bind("EndTime") %>'></asp:Label>
        </ItemTemplate>
    </asp:TemplateField>
<asp:BoundField DataField="Count" HeaderText="Count" SortExpression="Count" />
    <asp:ButtonField CommandName="V" Text="View" />
</Columns>
<HeaderStyle CssClass="th"></HeaderStyle><RowStyle CssClass="td"></RowStyle>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ApplicationServices %>" SelectCommand="PickRoutesINShifts" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:ControlParameter ControlID="DDLSites" Name="SiteID" PropertyName="SelectedValue" Type="Int32" />
<asp:ControlParameter ControlID="DDLShifts" Name="Sid" PropertyName="SelectedValue" Type="Int32" />
</SelectParameters></asp:SqlDataSource></td></tr>
<tr>
<td colspan="7">
    <table width="100%">
        <tr>
            <td width="50%">
                <h4>
                    Check Points</h4><hr />
            </td>
            <td>
                <h4>
                    Events</h4><hr />
            </td>
        </tr>
        <tr>
            <td>
                
<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" CssClass="DDGridView" 
                    HeaderStyle-CssClass="th" RowStyle-CssClass="td" DataSourceID="SqlDataSource4" 
                    Width="100%">
<Columns>
    <asp:BoundField DataField="CheckPoints" HeaderText="CheckPoints" 
        SortExpression="CheckPoints" />
    <asp:BoundField DataField="DateTime" HeaderText="DateTime" 
        SortExpression="DateTime" />
</Columns>
<HeaderStyle CssClass="th"></HeaderStyle><RowStyle CssClass="td"></RowStyle>
</asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource4" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:ApplicationServices %>" 
                    SelectCommand="CPReportForShifts" SelectCommandType="StoredProcedure">
                    <SelectParameters>
                        <asp:Parameter DbType="Time" Name="StartTime" />
                        <asp:Parameter DbType="Time" Name="EndTime" />
                        <asp:Parameter DbType="Date" Name="Date" />
                        <asp:Parameter Name="siteID" Type="Int32" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
            <td>
                
<asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" CssClass="DDGridView" 
                    HeaderStyle-CssClass="th" RowStyle-CssClass="td" DataSourceID="SqlDataSource5" 
                    Width="100%">
<Columns>
    <asp:BoundField DataField="EventName" HeaderText="EventName" 
        SortExpression="EventName" />
    <asp:BoundField DataField="DateTime" HeaderText="DateTime" 
        SortExpression="DateTime" />
</Columns>
<HeaderStyle CssClass="th"></HeaderStyle><RowStyle CssClass="td"></RowStyle>
</asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource5" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:ApplicationServices %>" 
                    SelectCommand="EventsReportForShifts" SelectCommandType="StoredProcedure">
                    <SelectParameters>
                        <asp:Parameter DbType="Time" Name="StartTime" />
                        <asp:Parameter DbType="Time" Name="EndTime" />
                        <asp:Parameter DbType="Date" Name="Date" />
                        <asp:Parameter Name="SiteID" Type="Int32" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
        </tr>
    </table>
    </td></tr></table></asp:Content>

文件操作 - ShiftReport.aspx

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

编辑文件内容

修改文件时间

删除文件