文件操作 - GuardReport.aspx

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

编辑文件内容

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="GuardReport.aspx.cs" Inherits="GuardReport" %>
<%@ 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="9"><h1>Employees Report</h1><hr /></td></tr>
<tr>
<td width="10%">
    Start </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%">
    End </td>
<td width="10%">
<asp:TextBox ID="txtEDate" runat="server"></asp:TextBox>
<asp:CalendarExtender ID="txtEDate_CalendarExtender" runat="server" Enabled="True" 
        TargetControlID="txtEDate" 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%">
    <asp:CheckBox ID="ChkGuard" runat="server" />
    </td>
<td width="15%">
    <asp:DropDownList ID="DDLGuards" runat="server" DataSourceID="SqlDataSource3" 
        DataTextField="Name" DataValueField="ID" Width="100px">
    </asp:DropDownList>
    <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ApplicationServices %>" 
        SelectCommand="SELECT * FROM [Guards] 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="9">
    <table width="100%">
        <tr>
            <td width="50%">
                <h4>
                    Check Points</h4><hr />
            </td>
            <td>
                <h4>
                    Events</h4><hr />
            </td>
        </tr>
        <tr>
            <td valign="top">
                
<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" CssClass="DDGridView" 
                    HeaderStyle-CssClass="th" RowStyle-CssClass="td" DataSourceID="SqlDataSource4" 
                    Width="100%">
    <Columns>
        <asp:BoundField DataField="GuardName" HeaderText="GuardName" 
            SortExpression="GuardName" />
        <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="PickGuardsCheckPointsReport" 
                    SelectCommandType="StoredProcedure">
                    <SelectParameters>
                        <asp:Parameter Name="sdate" Type="DateTime" />
                        <asp:Parameter Name="edate" Type="DateTime" />
                        <asp:Parameter Name="siteID" Type="Int32" />
                        <asp:Parameter Name="GuardID" Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
            <td valign="top">
                
<asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" CssClass="DDGridView" 
                    HeaderStyle-CssClass="th" RowStyle-CssClass="td" DataSourceID="SqlDataSource5" 
                    Width="100%">
<Columns>
    <asp:BoundField DataField="GuardName" HeaderText="GuardName" 
        SortExpression="GuardName" />
    <asp:BoundField DataField="Events" HeaderText="Events" 
        SortExpression="Events" />
    <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="PickGuardsEventsReport" SelectCommandType="StoredProcedure">
                    <SelectParameters>
                        <asp:Parameter Name="sdate" Type="DateTime" />
                        <asp:Parameter Name="edate" Type="DateTime" />
                        <asp:Parameter Name="SiteID" Type="Int32" />
                        <asp:Parameter Name="GuardID" Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
        </tr>
    </table>
    </td></tr></table></asp:Content>

文件操作 - GuardReport.aspx

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

编辑文件内容

修改文件时间

删除文件