文件操作 - ByDate.aspx
返回文件管理
返回主菜单
删除本文件
文件: E:\HostingSpaces\kimblycr\crm.kimbly.in\wwwroot\Reports\Sales\ByDate.aspx
编辑文件内容
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ByDate.aspx.cs" Inherits="BasicCRM.ByDate" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"><title></title> <link href="../../css/bootstrap.min.css" rel="stylesheet" /> <script src="../../js/Reports.js"></script> </head> <body> <form id="form1" runat="server"> <div style="margin-left: 5px;"> <h4>Leads by Date</h4><hr style="width:100%"/> <div class="form-group" style="width:100%; margin-top: 10px"> <label style="float:left;margin: 5px;margin-right: 10px;" >Start Date</label> <asp:TextBox ID="txtStartDate" runat="server" type="date" cssClass="form-control" style="width:200px; float:left;height: 30px;"></asp:TextBox> <label style="float:left;margin: 5px;margin-right: 10px;" >End Date</label> <asp:TextBox ID="txtEndDate" runat="server" type="date" cssClass="form-control" style="width:200px; float:left;height: 30px;"></asp:TextBox> <asp:Button ID="BtnRpt" runat="server" Text="Get" CssClass="btn btn-success" onclick="BtnRpt_Click" style="margin-left:10px" /> <asp:Label ID="lblTotal" runat="server" style="margin-left:10px; float:left" Text="0" /> </div> <hr style="width:100%"/> <div style="width:100%"> <asp:GridView ID="GridView1" runat="server" CellPadding="4" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None" AutoGenerateColumns="False" Width="100%"> <AlternatingRowStyle BackColor="White" ForeColor="#284775" /> <Columns> <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True" SortExpression="ID" /> <asp:BoundField DataField="Organization" HeaderText="Organization" SortExpression="Organization" /> <asp:BoundField DataField="Mobile" HeaderText="Mobile" SortExpression="Mobile" /> <asp:BoundField DataField="EMail" HeaderText="EMail" SortExpression="EMail" /> <asp:BoundField DataField="PhoneNo" HeaderText="PhoneNo" SortExpression="PhoneNo" /> <asp:BoundField DataField="Requirement" HeaderText="Requirement" SortExpression="Requirement" /> <asp:BoundField DataField="Lead_Source" HeaderText="Lead_Source" SortExpression="Lead_Source" /> <asp:BoundField DataField="City" HeaderText="City" SortExpression="City" /> <asp:BoundField DataField="EstimatedValue" HeaderText="EstimatedValue" SortExpression="EstimatedValue" /> <asp:BoundField DataField="Probablity" HeaderText="Probablity" SortExpression="Probablity" /> <asp:CheckBoxField DataField="Important" HeaderText="Important" SortExpression="Important" /> </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="GetLeadsByDate" SelectCommandType="StoredProcedure"> <SelectParameters> <asp:Parameter Name="SDate" Type="DateTime" /> <asp:Parameter Name="EDate" Type="DateTime" /> </SelectParameters> </asp:SqlDataSource> </div> </div> </form> </body> </html>
修改文件时间
将文件时间修改为当前时间的前一年
删除文件