gaojianguanli.aspx

毕业设计内容： 1、 作者投稿功能 2、 专家审稿 3、 系统管理员对所有稿件的管理功能 管理权限设置:分为三级权限。包括用户:添加文章、查询自己稿件的审稿情况、审稿意见、查看个人资料等 专家:审批文

<%@ Page Language="C#" MasterPageFile="~/admin/admin.master" AutoEventWireup="true" CodeFile="Gaojianguanli.aspx.cs" Inherits="admin_Gaojianguanli" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table border="0" cellpadding="0" cellspacing="0" style="width: 100%; font-size: 12px;">
        <tr>
            <td align="center" colspan="3" style="background-image: url(../img/bg.gif); height: 16px; width: 624px;">
    待审作品</td>
        </tr>
        <tr>
            <td colspan="3" style="height: 9px; width: 624px;" valign="top"><asp:GridView ID="GridView2" runat="server" AllowPaging="True" AutoGenerateColumns="False"
                                CellPadding="4" DataSourceID="SqlDataSource2" ForeColor="#333333" GridLines="None"
                               Width="617px" DataKeyNames="Book_id" Height="18px">
                <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                <Columns>
                
                    <asp:TemplateField> 
                    <ItemTemplate>
                    单击查看详细内容：
                    <asp:HyperLink  ID="hyk1" runat="server" NavigateUrl='<%# Eval("Book_id","../admin/details.aspx?id={0}") %>' Text='<%# Eval("Title") %>' BorderStyle="None" Height="19px" Width="450px"></asp:HyperLink>
                    </ItemTemplate>
                    </asp:TemplateField>
                       
                       
                   
                  
                </Columns>
                <RowStyle BackColor="#E3EAEB" />
                <EditRowStyle BackColor="#7C6F57" />
                <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
                <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
                <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                <AlternatingRowStyle BackColor="White" />
            </asp:GridView>
                &nbsp;
            </td>
        </tr>
        <tr>
            <td align="center" colspan="3" style="background-image: url(../img/bg.gif); width: 624px; height: 15px;">
    全部稿件</td>
        </tr>
        <tr>
            <td colspan="3" style="height: 31px; width: 624px;">
                <table border="0" cellpadding="0" cellspacing="0" style="width: 100%">
                    <tr>
                        <td colspan="3">
                            <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
                                CellPadding="4" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None"
                               Width="612px">
                                <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                                <RowStyle BackColor="#E3EAEB" />
                                <EditRowStyle BackColor="#7C6F57" />
                                <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
                                <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
                                <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                                <AlternatingRowStyle BackColor="White" />
                                 <Columns>
                    <asp:TemplateField> 
                    <ItemTemplate>
                    单击查看详细内容：
                    <asp:HyperLink  ID="hyk1" runat="server" NavigateUrl='<%# Eval("Book_id","../admin/details.aspx?id={0}") %>' Text='<%# Eval("Title") %>' BorderStyle="None" Height="19px" Width="450px"></asp:HyperLink>
                    </ItemTemplate>
                    </asp:TemplateField>
                       
                       
                    </Columns>
                   
                            </asp:GridView>
                            &nbsp;</td>
                    </tr>
                    <tr>
                        <td style="height: 16px;" align="center" colspan="2">
                            已经审核作品</td>
                        <td style="height: 16px">
                        </td>
                    </tr>
                    <tr>
                        <td style="height: 3px;" colspan="2">
                            &nbsp;
                            <asp:GridView ID="GridView3" runat="server" AllowPaging="True" AutoGenerateColumns="False"
                                CellPadding="4" DataSourceID="SqlDataSource3" ForeColor="#333333" GridLines="None"
                               Width="612px">
                               
                                <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                                <RowStyle BackColor="#E3EAEB" />
                                <EditRowStyle BackColor="#7C6F57" />
                                <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
                                <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
                                <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                                <AlternatingRowStyle BackColor="White" />   <Columns>
                    <asp:TemplateField> 
                    <ItemTemplate>
                    单击查看详细内容：
                    <asp:HyperLink  ID="hyk1" runat="server" NavigateUrl='<%# Eval("Book_id","../admin/details.aspx?id={0}") %>' Text='<%# Eval("Title") %>' BorderStyle="None" Height="19px" Width="450px"></asp:HyperLink>
                    </ItemTemplate>
                    </asp:TemplateField>
                       
                       
                    </Columns>
                   
                            </asp:GridView>
                            <asp:SqlDataSource ID="SqlDataSource3" runat="server"
                                ConnectionString="<%$ ConnectionStrings:fileConnectionString %>" DeleteCommand="DELETE FROM [Efile] WHERE [Book_id] = @original_Book_id"
                                InsertCommand="INSERT INTO [Efile] ([Author], [Title], [Author_email], [Description], [File_path], [File_class], [fileshenhe], [filepinglun], [filehege]) VALUES (@Author, @Title, @Author_email, @Description, @File_path, @File_class, @fileshenhe, @filepinglun, @filehege)"
                                OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [Efile] WHERE ([filehege] = @filehege)"
                                UpdateCommand="UPDATE [Efile] SET [Author] = @Author, [Title] = @Title, [Author_email] = @Author_email, [Description] = @Description, [File_path] = @File_path, [File_class] = @File_class, [fileshenhe] = @fileshenhe, [filepinglun] = @filepinglun, [filehege] = @filehege WHERE [Book_id] = @original_Book_id">
                                <DeleteParameters>
                                    <asp:Parameter Name="original_Book_id" Type="Int32" />
                                </DeleteParameters>
                                <UpdateParameters>
                                    <asp:Parameter Name="Author" Type="String" />
                                    <asp:Parameter Name="Title" Type="String" />
                                    <asp:Parameter Name="Author_email" Type="String" />
                                    <asp:Parameter Name="Description" Type="String" />
                                    <asp:Parameter Name="File_path" Type="String" />
                                    <asp:Parameter Name="File_class" Type="String" />
                                    <asp:Parameter Name="fileshenhe" Type="String" />
                                    <asp:Parameter Name="filepinglun" Type="String" />
                                    <asp:Parameter Name="filehege" Type="String" />
                                    <asp:Parameter Name="original_Book_id" Type="Int32" />
                                </UpdateParameters>
                                <SelectParameters>
                                    <asp:Parameter DefaultValue="是" Name="filehege" Type="String" />
                                </SelectParameters>
                                <InsertParameters>
                                    <asp:Parameter Name="Author" Type="String" />
                                    <asp:Parameter Name="Title" Type="String" />
                                    <asp:Parameter Name="Author_email" Type="String" />
                                    <asp:Parameter Name="Description" Type="String" />
                                    <asp:Parameter Name="File_path" Type="String" />
                                    <asp:Parameter Name="File_class" Type="String" />
                                    <asp:Parameter Name="fileshenhe" Type="String" />
                                    <asp:Parameter Name="filepinglun" Type="String" />
                                    <asp:Parameter Name="filehege" Type="String" />
                                </InsertParameters>
                            </asp:SqlDataSource>
                        </td>
                        <td style="height: 3px">
                        </td>
                    </tr>
                    <tr>
                        <td style="width: 100px">
                        </td>
                        <td style="width: 100px">
                        </td>
                        <td>
                        </td>
                    </tr>
                </table>
                            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:fileConnectionString %>"
                                OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [Efile] ORDER BY [Book_id]">
                            </asp:SqlDataSource>
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:fileConnectionString %>"
                    SelectCommand="SELECT * FROM [Efile] WHERE ([fileshenhe] = @fileshenhe) ORDER BY [Book_id]">
                    <SelectParameters>
                        <asp:Parameter DefaultValue="否" Name="fileshenhe" Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
                &nbsp; &nbsp;
            </td>
        </tr>
    </table>
    <br />
</asp:Content>