zhuanjia.aspx

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

<%@ Page Language="C#" MasterPageFile="~/admin/admin.master" AutoEventWireup="true" CodeFile="zhuanjia.aspx.cs" Inherits="admin_zhuanjia" 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;">
                    专家管理：</td>
            </tr>
            <tr>
                <td colspan="3" style="height: 67px" valign="top">
                    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
                        CellPadding="4" DataSourceID="SqlDataSource2" ForeColor="#333333"
                        GridLines="None" Width="616px">
                        <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                        <Columns>
                            <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                            <asp:BoundField DataField="Expert_id" HeaderText="编号" InsertVisible="False"
                                ReadOnly="True" SortExpression="Expert_id" />
                            <asp:BoundField DataField="Expert_name" HeaderText="名称" SortExpression="Expert_name" />
                            <asp:BoundField DataField="Expert_pwd" HeaderText="密码" SortExpression="Expert_pwd" />
                            <asp:BoundField DataField="Class_name" HeaderText="类别" SortExpression="Class_name" />
                            <asp:BoundField DataField="Expert_email" HeaderText="电子邮件" SortExpression="Expert_email" />
                            <asp:BoundField DataField="Expert_Age" HeaderText="年龄" SortExpression="Expert_Age" />
                            <asp:BoundField DataField="Expert_Mail" HeaderText="性别" SortExpression="Expert_Mail" />
                            <asp:BoundField DataField="Expert_chubanshe" HeaderText="出版社" SortExpression="Expert_chubanshe" />
                            <asp:BoundField DataField="Expert_Tel" HeaderText="电话" SortExpression="Expert_Tel" />
                            <asp:BoundField DataField="Expert_address" HeaderText="地址" SortExpression="Expert_address" />
                        </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>
                </td>
            </tr>
            <tr>
                <td colspan="3">
                </td>
            </tr>
        </table>
  
        <table border="0" style="height: 156px; border-right: #33ccff 0px solid; border-top: #33ccff 0px solid; border-left: #33ccff 0px solid; border-bottom: #33ccff 0px solid;" width="100%">
            <tr>
                <td style="height: 22px; background-image: url(../img/bg.gif);" align="center" colspan="2">
                    添加专家&nbsp;</td>
            </tr>
            <tr>
                <td>
                    姓名：</td>
                <td>
                    <asp:TextBox ID="txtname" runat="server"></asp:TextBox>
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="txtname"
                        Display="Dynamic" ErrorMessage="姓名空" ValidationGroup="1"></asp:RequiredFieldValidator></td>
            </tr>
            <tr>
                <td>
                    密码：</td>
                <td>
                    <asp:TextBox ID="txtpwd" runat="server" TextMode="Password" Width="149px"></asp:TextBox>
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="txtpwd"
                        Display="Dynamic" ErrorMessage="密码空" ValidationGroup="1"></asp:RequiredFieldValidator></td>
            </tr>
            <tr>
                <td>
                    email:</td>
                <td>
                    <asp:TextBox ID="txtemal" runat="server"></asp:TextBox>
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtemal"
                        Display="Dynamic" ErrorMessage="电子邮件空" ValidationGroup="1"></asp:RequiredFieldValidator>
                    <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="txtemal"
                        Display="Dynamic" ErrorMessage="格式错误" ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"
                        ValidationGroup="1"></asp:RegularExpressionValidator></td>
            </tr>
             <tr>
                <td style="height: 19px">
                    年龄：</td>
                <td style="height: 19px">
                    <asp:TextBox ID="txtage" runat="server"></asp:TextBox></td>
            </tr>
             <tr>
                <td style="height: 8px">
                    性别：</td>
                <td style="height: 8px">
                    <asp:RadioButtonList ID="rdSex" runat="server" RepeatDirection="Horizontal">
                        <asp:ListItem>男</asp:ListItem>
                        <asp:ListItem>女</asp:ListItem>
                    </asp:RadioButtonList></td>
            </tr>
             <tr>
                <td style="height: 19px">
                    出版社：</td>
                <td style="height: 19px">
                    <asp:DropDownList ID="dpPublish" runat="server" DataSourceID="SqlDataSource3" DataTextField="PubName"
                        DataValueField="id">
                    </asp:DropDownList>
                </td>
            </tr>
             <tr>
                <td style="height: 19px">
                    电话：</td>
                <td style="height: 19px">
                    <asp:TextBox ID="txttel" runat="server"></asp:TextBox></td>
            </tr>
             <tr>
                <td style="height: 19px">
                    地址：</td>
                <td style="height: 19px">
                    <asp:TextBox ID="txtAddress" runat="server"></asp:TextBox></td>
            </tr>
            <tr>
                <td colspan="2" align="center" style="background-image: url(../img/bg.gif); height: 26px;">
                    
                        <asp:Button ID="Button2" runat="server" Text="添加" BorderStyle="None" Width="73px" OnClick="Button2_Click" ValidationGroup="1" />
                  
                </td>
            </tr>
        </table>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:fileConnectionString %>"
        SelectCommand="SELECT * FROM [Class]"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConflictDetection="CompareAllValues"
        ConnectionString="<%$ ConnectionStrings:fileConnectionString %>" DeleteCommand="DELETE FROM [Expert] WHERE [Expert_id] = @original_Expert_id AND [Expert_name] = @original_Expert_name AND [Expert_pwd] = @original_Expert_pwd AND [Class_name] = @original_Class_name AND [Expert_email] = @original_Expert_email AND [Expert_Age] = @original_Expert_Age AND [Expert_Mail] = @original_Expert_Mail AND [Expert_chubanshe] = @original_Expert_chubanshe AND [Expert_Tel] = @original_Expert_Tel AND [Expert_address] = @original_Expert_address"
        InsertCommand="INSERT INTO [Expert] ([Expert_name], [Expert_pwd], [Class_name], [Expert_email], [Expert_Age], [Expert_Mail], [Expert_chubanshe], [Expert_Tel], [Expert_address]) VALUES (@Expert_name, @Expert_pwd, @Class_name, @Expert_email, @Expert_Age, @Expert_Mail, @Expert_chubanshe, @Expert_Tel, @Expert_address)"
        OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [Expert]"
        UpdateCommand="UPDATE [Expert] SET [Expert_name] = @Expert_name, [Expert_pwd] = @Expert_pwd, [Class_name] = @Class_name, [Expert_email] = @Expert_email, [Expert_Age] = @Expert_Age, [Expert_Mail] = @Expert_Mail, [Expert_chubanshe] = @Expert_chubanshe, [Expert_Tel] = @Expert_Tel, [Expert_address] = @Expert_address WHERE [Expert_id] = @original_Expert_id AND [Expert_name] = @original_Expert_name AND [Expert_pwd] = @original_Expert_pwd AND [Class_name] = @original_Class_name AND [Expert_email] = @original_Expert_email AND [Expert_Age] = @original_Expert_Age AND [Expert_Mail] = @original_Expert_Mail AND [Expert_chubanshe] = @original_Expert_chubanshe AND [Expert_Tel] = @original_Expert_Tel AND [Expert_address] = @original_Expert_address">
        <DeleteParameters>
            <asp:Parameter Name="original_Expert_id" Type="Int32" />
            <asp:Parameter Name="original_Expert_name" Type="String" />
            <asp:Parameter Name="original_Expert_pwd" Type="String" />
            <asp:Parameter Name="original_Class_name" Type="String" />
            <asp:Parameter Name="original_Expert_email" Type="String" />
            <asp:Parameter Name="original_Expert_Age" Type="String" />
            <asp:Parameter Name="original_Expert_Mail" Type="String" />
            <asp:Parameter Name="original_Expert_chubanshe" Type="String" />
            <asp:Parameter Name="original_Expert_Tel" Type="String" />
            <asp:Parameter Name="original_Expert_address" Type="String" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="Expert_name" Type="String" />
            <asp:Parameter Name="Expert_pwd" Type="String" />
            <asp:Parameter Name="Class_name" Type="String" />
            <asp:Parameter Name="Expert_email" Type="String" />
            <asp:Parameter Name="Expert_Age" Type="String" />
            <asp:Parameter Name="Expert_Mail" Type="String" />
            <asp:Parameter Name="Expert_chubanshe" Type="String" />
            <asp:Parameter Name="Expert_Tel" Type="String" />
            <asp:Parameter Name="Expert_address" Type="String" />
            <asp:Parameter Name="original_Expert_id" Type="Int32" />
            <asp:Parameter Name="original_Expert_name" Type="String" />
            <asp:Parameter Name="original_Expert_pwd" Type="String" />
            <asp:Parameter Name="original_Class_name" Type="String" />
            <asp:Parameter Name="original_Expert_email" Type="String" />
            <asp:Parameter Name="original_Expert_Age" Type="String" />
            <asp:Parameter Name="original_Expert_Mail" Type="String" />
            <asp:Parameter Name="original_Expert_chubanshe" Type="String" />
            <asp:Parameter Name="original_Expert_Tel" Type="String" />
            <asp:Parameter Name="original_Expert_address" Type="String" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter Name="Expert_name" Type="String" />
            <asp:Parameter Name="Expert_pwd" Type="String" />
            <asp:Parameter Name="Class_name" Type="String" />
            <asp:Parameter Name="Expert_email" Type="String" />
            <asp:Parameter Name="Expert_Age" Type="String" />
            <asp:Parameter Name="Expert_Mail" Type="String" />
            <asp:Parameter Name="Expert_chubanshe" Type="String" />
            <asp:Parameter Name="Expert_Tel" Type="String" />
            <asp:Parameter Name="Expert_address" Type="String" />
        </InsertParameters>
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:fileConnectionString %>"
        SelectCommand="SELECT * FROM [Publish]"></asp:SqlDataSource>
   
</asp:Content>