teditchapter.aspx

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

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="TEditChapter.aspx.cs" Inherits="Teacher_TEditChapter" MasterPageFile="~/TQMS_Master.master" %>


<asp:Content ContentPlaceHolderID ="main" ID ="TEditChapter" runat="server">
    <asp:FormView ID="FormView1" runat="server" DataKeyNames="TQ_ChapterID" DataSourceID="SqlDataSource1"
        DefaultMode="Edit" OnItemInserted="FormView1_ItemInserted" Width="80%" OnItemUpdated="FormView1_ItemUpdated">
        <EditItemTemplate>
            <table style="width: 668px">
                <tr>
                    <td colspan="2" style="color: black">
                        &nbsp;<strong>章目信息的修改</strong></td>
                </tr>
                <tr>
                    <td colspan="2" style="height: 53px">
                        &nbsp;请<span style="color: red">注意</span>：<span style="font-size: 10pt">在提交信息前请认真填写音节信息<br />
                            &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 章名最多３０个字符。标准格式为：<br />
                            第一章 计算机基础</span></td>
                </tr>
                <tr>
                    <td align="left">
                        章编号：</td>
                    <td>
                        <asp:Label ID="TQ_ChapterIDLabel1" runat="server" Text='<%# Eval("TQ_ChapterID") %>'></asp:Label></td>
                </tr>
                <tr>
                    <td align="left">
                        章目名称：</td>
                    <td>
                        <asp:TextBox ID="TQ_ChapterNameTextBox" runat="server" Text='<%# Bind("TQ_ChapterName") %>' Width="300px"></asp:TextBox>
                        <span style="color: red">*</span><asp:RequiredFieldValidator ID="rfdChapterName"
                            runat="server" ControlToValidate="TQ_ChapterNameTextBox" Display="Dynamic" ErrorMessage="RequiredFieldValidator"></asp:RequiredFieldValidator></td>
                </tr>
                <tr>
                    <td align="left">
                        所属科目：</td>
                    <td>
                        <asp:DropDownList ID="ddlCourse" runat="server" DataSourceID="SqlDataSource2" DataTextField="TQ_CourseName"
                            DataValueField="TQ_CourseID" SelectedValue='<%# Bind("TQ_CourseID") %>' Width="300px">
                        </asp:DropDownList>
                    </td>
                </tr>
                <tr>
                    <td align="left" style="width: 56px">
                    </td>
                    <td style="width: 100px">
                    </td>
                </tr>
            </table>
            <br />
            <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
                Text="更新"></asp:LinkButton>&nbsp;
            <asp:HyperLink ID="hlkBack" runat="server" NavigateUrl="~/Teacher/TChapter.aspx">返回</asp:HyperLink>
        </EditItemTemplate>
        <InsertItemTemplate>
            <table style="width: 100%">
                <tr>
                    <td colspan="2">
                        试题管理---添加科目</td>
                </tr>
                <tr>
                    <td>
                        章目名称：</td>
                    <td>
                        <asp:TextBox ID="tbxChapterName" runat="server" Text='<%# Bind("TQ_ChapterName") %>'
                            Width="198px"></asp:TextBox>
                        <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="tbxChapterName"
                            ErrorMessage="必须填写"></asp:RequiredFieldValidator>(30字符以内)</td>
                </tr>
                <tr>
                    <td>
                        所属科目：</td>
                    <td>
                        <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource2"
                            DataTextField="TQ_CourseName" DataValueField="TQ_CourseID" SelectedValue='<%# Bind("TQ_CourseID") %>'
                            Width="205px">
                        </asp:DropDownList></td>
                </tr>
                <tr>
                    <td style="width: 100px">
                    </td>
                    <td style="width: 295px">
                    </td>
                </tr>
                <tr>
                    <td colspan="2" style="height: 20px">
                        <asp:LinkButton ID="LinkButton1" runat="server" CommandName="insert">插入</asp:LinkButton>
                        <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/Teacher/TChapter.aspx">返回</asp:HyperLink></td>
                </tr>
            </table>
        </InsertItemTemplate>
    </asp:FormView>
    &nbsp; &nbsp; &nbsp;
    <asp:Label ID="lblMessege" runat="server" Width="105px"></asp:Label>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:QuestionManagerConnectionString %>"
        DeleteCommand="DELETE FROM [TQ_Chapters] WHERE [TQ_ChapterID] = @TQ_ChapterID"
        InsertCommand="INSERT INTO [TQ_Chapters] ([TQ_ChapterName], [TQ_CourseID]) VALUES (@TQ_ChapterName, @TQ_CourseID)"
        SelectCommand="SELECT [TQ_ChapterID], [TQ_ChapterName], [TQ_CourseID] FROM [TQ_Chapters] WHERE ([TQ_ChapterID] = @TQ_ChapterID)"
        UpdateCommand="UPDATE [TQ_Chapters] SET [TQ_ChapterName] = @TQ_ChapterName, [TQ_CourseID] = @TQ_CourseID WHERE [TQ_ChapterID] = @TQ_ChapterID">
        <SelectParameters>
            <asp:QueryStringParameter Name="TQ_ChapterID" QueryStringField="id" Type="Int32" />
        </SelectParameters>
        <UpdateParameters>
            <asp:Parameter Name="TQ_ChapterName" Type="String" />
            <asp:Parameter Name="TQ_CourseID" Type="Int32" />
            <asp:Parameter Name="TQ_ChapterID" Type="Int32" />
        </UpdateParameters>
        <DeleteParameters>
            <asp:Parameter Name="TQ_ChapterID" Type="Int32" />
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="TQ_ChapterName" Type="String" />
            <asp:Parameter Name="TQ_CourseID" Type="Int32" />
        </InsertParameters>
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:QuestionManagerConnectionString %>"
        SelectCommand="SELECT [TQ_CourseID], [TQ_CourseName] FROM [TQ_Courses]"></asp:SqlDataSource>

</asp:Content>