uuser.aspx

一个多用户在线题库管理系统,可以实现各类试题的添加和管理

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="UUser.aspx.cs" Inherits="UUser_UUser"  MasterPageFile="~/TQMS_Master.master"%>
<asp:Content ID="TUser" ContentPlaceHolderID="main" runat="server">
    &nbsp;<table width="100%">
        <tr>
            <td width="10">
                &nbsp;</td>
            <td style="width: 100px">
    <asp:FormView ID="FormView1" runat="server" DataKeyNames="TQ_UserID" DataSourceID="SqlDataSource1" Width="318px">
        <EditItemTemplate>
            <table cellpadding="0" cellspacing="0" class="table" width="400">
                <tr>
                    <td class="tdHead" colspan="2" style="height: 21px">
                        <span style="font-size: 10.5pt; font-family: 宋体; mso-ascii-font-family: 'Times New Roman';
                            mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman';
                            mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN;
                            mso-bidi-language: AR-SA"><strong>修改个人信息</strong></span></td>
                </tr>
                <tr>
                    <td colspan="2" style="height: 21px">
            <asp:Label ID="TQ_UserIDLabel1" runat="server" Text='<%# Eval("TQ_UserID") %>'></asp:Label></td>
                </tr>
                <tr>
                    <td style="height: 21px" align="left" class="tdAlter" width="120">
                        用户名：</td>
                    <td align="left" class="tdAlter">
                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("TQ_UserName") %>'></asp:Label></td>
                </tr>
                <tr>
                    <td align="left" width="120">
                        姓 名：</td>
                    <td style="width: 100px" align="left">
                        <asp:Label ID="Label2" runat="server" Text='<%# Bind("TQ_TureName") %>'></asp:Label></td>
                </tr>
                <tr>
                    <td style="height: 24px" align="left" class="tdAlter" width="120">
                        密 码：</td>
                    <td align="left" class="tdAlter">
            <asp:TextBox ID="TQ_UserPwdTextBox" runat="server" Text='<%# Bind("TQ_UserPwd") %>' TextMode="Password"></asp:TextBox></td>
                </tr>
                <tr>
                    <td align="left" style="height: 24px" width="120">
                        <span style="font-size: 10.5pt; font-family: 宋体; mso-ascii-font-family: 'Times New Roman';
                            mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman';
                            mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN;
                            mso-bidi-language: AR-SA">再次输入密码</span></td>
                    <td align="left">
                        <asp:TextBox ID="TextBox1" runat="server" TextMode="Password"></asp:TextBox>
                        <asp:CompareValidator ID="CompareValidator1" runat="server" ControlToCompare="TQ_UserPwdTextBox"
                            ControlToValidate="TextBox1" Display="Dynamic" ErrorMessage="两次输入密码匹配"></asp:CompareValidator></td>
                </tr>
                <tr>
                    <td align="left" class="tdAlter" width="120">
                        邮 箱：</td>
                    <td align="left" class="tdAlter">
            <asp:TextBox ID="TQ_EmailTextBox" runat="server" Text='<%# Bind("TQ_Email") %>'>
            </asp:TextBox>
                        <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="TQ_EmailTextBox"
                            Display="Dynamic" ErrorMessage="邮箱格式不正确！！" ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"></asp:RegularExpressionValidator></td>
                </tr>
                <tr>
                    <td style="height: 21px;" align="left" width="120">
                        用户类型：</td>
                    <td align="left">
                        <asp:Label ID="TQ_UserTypeLabel" runat="server" Text='<%# Bind("TQ_UserType") %>'></asp:Label></td>
                </tr>
            </table>
            <br />
            <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
                Text="更新">
            </asp:LinkButton>
            <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                Text="取消">
            </asp:LinkButton>
        </EditItemTemplate>
     
        <ItemTemplate>
            <table class="table">
                <tr>
                    <td class="tdHead" colspan="2" style="height: 21px">
                        <span style="font-size: 10.5pt; font-family: 宋体; mso-ascii-font-family: 'Times New Roman';
                            mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman';
                            mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN;
                            mso-bidi-language: AR-SA"><strong>个人信息修改</strong></span></td>
                </tr>
                <tr>
                    <td colspan="2" style="height: 21px">
            <asp:Label ID="TQ_UserIDLabel" runat="server" Text='<%# Eval("TQ_UserID") %>' Visible="False"></asp:Label></td>
                </tr>
                <tr>
                    <td style="width: 100px; height: 21px" class="tdAlter">
                        用户名：</td>
                    <td style="width: 100px; height: 21px" class="tdAlter">
            <asp:Label ID="TQ_UserNameLabel" runat="server" Text='<%# Bind("TQ_UserName") %>'></asp:Label></td>
                </tr>
                <tr>
                    <td style="width: 100px">
                        姓 名：</td>
                    <td style="width: 100px">
            <asp:Label ID="TQ_TureNameLabel" runat="server" Text='<%# Bind("TQ_TureName") %>'></asp:Label></td>
                </tr>
                <tr>
                    <td style="width: 100px" class="tdAlter">
                        密 码：</td>
                    <td style="width: 100px" class="tdAlter">
            <asp:Label ID="TQ_UserPwdLabel" runat="server" Text='<%# Bind("TQ_UserPwd") %>'></asp:Label></td>
                </tr>
                <tr>
                    <td style="width: 100px">
                        邮 箱：</td>
                    <td style="width: 100px">
            <asp:Label ID="TQ_EmailLabel" runat="server" Text='<%# Bind("TQ_Email") %>'></asp:Label></td>
                </tr>
                <tr>
                    <td style="width: 100px" class="tdAlter">
                        用户类型：</td>
                    <td style="width: 100px" class="tdAlter">
                        <asp:Label ID="TQ_UserTypeLabel" runat="server" Text='<%# Bind("TQ_UserType") %>'></asp:Label></td>
                </tr>
            </table>
            <br />
            <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit"
                Text="编辑"></asp:LinkButton>
            &nbsp;
        </ItemTemplate>
    </asp:FormView>
            </td>
        </tr>
    </table>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
        ConnectionString="<%$ ConnectionStrings:QuestionManagerConnectionString %>" DeleteCommand="DELETE FROM [TQ_UserInfo] WHERE [TQ_UserID] = @original_TQ_UserID AND [TQ_UserName] = @original_TQ_UserName AND [TQ_TureName] = @original_TQ_TureName AND [TQ_UserPwd] = @original_TQ_UserPwd AND [TQ_Email] = @original_TQ_Email AND [TQ_UserType] = @original_TQ_UserType"
        OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [TQ_UserID], [TQ_UserName], [TQ_TureName], [TQ_UserPwd], [TQ_Email], [TQ_UserType] FROM [TQ_UserInfo] WHERE ([TQ_TureName] = @TQ_TureName)"
        UpdateCommand="UPDATE [TQ_UserInfo] SET [TQ_UserName] = @TQ_UserName, [TQ_TureName] = @TQ_TureName, [TQ_UserPwd] = @TQ_UserPwd, [TQ_Email] = @TQ_Email, [TQ_UserType] = @TQ_UserType WHERE [TQ_UserID] = @original_TQ_UserID AND [TQ_UserName] = @original_TQ_UserName AND [TQ_TureName] = @original_TQ_TureName AND [TQ_UserPwd] = @original_TQ_UserPwd AND [TQ_Email] = @original_TQ_Email AND [TQ_UserType] = @original_TQ_UserType">
        <DeleteParameters>
            <asp:Parameter Name="original_TQ_UserID" Type="Int32" />
            <asp:Parameter Name="original_TQ_UserName" Type="String" />
            <asp:Parameter Name="original_TQ_TureName" Type="String" />
            <asp:Parameter Name="original_TQ_UserPwd" Type="String" />
            <asp:Parameter Name="original_TQ_Email" Type="String" />
            <asp:Parameter Name="original_TQ_UserType" Type="String" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="TQ_UserName" Type="String" />
            <asp:Parameter Name="TQ_TureName" Type="String" />
            <asp:Parameter Name="TQ_UserPwd" Type="String" />
            <asp:Parameter Name="TQ_Email" Type="String" />
            <asp:Parameter Name="TQ_UserType" Type="String" />
            <asp:Parameter Name="original_TQ_UserID" Type="Int32" />
            <asp:Parameter Name="original_TQ_UserName" Type="String" />
            <asp:Parameter Name="original_TQ_TureName" Type="String" />
            <asp:Parameter Name="original_TQ_UserPwd" Type="String" />
            <asp:Parameter Name="original_TQ_Email" Type="String" />
            <asp:Parameter Name="original_TQ_UserType" Type="String" />
        </UpdateParameters>
        <SelectParameters>
            <asp:SessionParameter Name="TQ_TureName" SessionField="UserName" Type="String" />
        </SelectParameters>
       
    </asp:SqlDataSource>
</asp:Content>