courselist.aspx

asp.net 2.0的教务管理软件源码

<%@ Page Language="C#" MasterPageFile="~/style/MasterPage.master" AutoEventWireup="true"
    CodeFile="CourseList.aspx.cs" Inherits="Personal_CourseList" Title="课程工作管理 - 杰邦教学管理系统" %>

<%@ Register TagPrefix="JControls" TagName="TypeList" Src="~/uctl/StandardChoice.ascx" %>
<%@ Register TagPrefix="uc1" TagName="myCodeTree" Src="~/uctl/CodeTree.ascx" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
     <div style="z-index: 105; left: 1px; width: 200px; position: absolute; top: 1px;
        height: 24px" id="divLeftTitle">
        <table style="width: 100%">
            <tr>
                <td class="titlebar">
                    课程/工作列表</td>
            </tr>
        </table>
    </div>
   <div id="divTree" >
        <uc1:myCodeTree ID="Courses" TableName="J_Course" IdColumn="co_ID" NameColumn="co_Name" ParentIdColumn="co_Parent" RootNames="'课程工作'" runat="server" />
    </div>
    <div id="divTitle" style="z-index: 105; left: 206px; width: 77%; position: absolute;
        top: 1px">
        <table style="width: 100%" border="0" cellpadding="0" cellspacing="0">
            <tr>
                <td class="titlebar">
                    课程/工作管理：<asp:Label ID="Path" runat="server"></asp:Label>
                    <asp:Label ID="lblCounter" runat="server"></asp:Label></td>
            </tr>
        </table>
    </div>
    <div style=" height: 250px; left: 206px; top: 26px;"id="divMain">
        <asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False"
            DataSourceID="SqlDataSource1" Width="97%"
            DataKeyNames="co_ID" CssClass="mainView" OnRowDeleted="GridView1_RowDeleted" OnRowDeleting="GridView1_RowDeleting" OnSelectedIndexChanged="GridView1_SelectedIndexChanged">
            <Columns>
                <asp:BoundField DataField="co_ID" HeaderText="ID" InsertVisible="False" ReadOnly="True"
                    SortExpression="co_ID" />
                <asp:BoundField DataField="co_Name" HeaderText="课程名称" SortExpression="ac_Name" />
                <asp:BoundField DataField="co_Parent" HeaderText="co_Parent" SortExpression="co_Parent"
                    Visible="False" />
                <asp:BoundField DataField="co_Credit" HeaderText="学分" SortExpression="co_Description" />
                <asp:BoundField DataField="co_Time" HeaderText="学时" SortExpression="co_Time" />
                <asp:CommandField ShowDeleteButton="True" ShowSelectButton="True" SelectText="修改" DeleteText="&lt;div style=&quot;display:inline&quot; id=&quot;deleteme&quot; onclick=&quot;JavaScript:return confirm('确定删除吗？这将连带删除所有与该科目有关的成绩或考勤记录！')&quot;&gt;删除&lt;/div&gt;"/>
            </Columns>
        </asp:GridView>
    </div>
    <div id="divForm" style="z-index: 103; left: 206px; width: 77%; position: absolute;
        top: 280px; height: 196px; background-color: #eeeeee;">
        <table style="width: 100%">
            <tr>
                <td class="titlebar">
                    <asp:Label ID="lblMessageResult" runat="server"></asp:Label>&nbsp;&nbsp;
                </td>
            </tr>
        </table>
        <table style="width: 100%;" border="0" cellpadding="0" cellspacing="0">
            <tbody>
                <tr>
                    <td align="right" style="width: 108px">
                    </td>
                    <td>
                        &nbsp;</td>
                    <td>
                    </td>
                </tr>
                <tr>
                    <td align="right" style="width: 108px">
                        种类：</td>
                    <td style="width: 206px">
                        <asp:DropDownList ID="ddlType" runat="server">
                            <asp:ListItem Value="1">课程</asp:ListItem>
                            <asp:ListItem Value="0">工作</asp:ListItem>
                        </asp:DropDownList>
                        &nbsp;
                        <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtName"
                            CssClass="ErrMsg" ErrorMessage="请输入名称." ForeColor="" SetFocusOnError="True"></asp:RequiredFieldValidator></td>
                    <td>
                        简介：</td>
                </tr>
                <tr>
                    <td align="right">
                        课程/工作名称：</td>
                    <td>
                        <asp:TextBox ID="txtName" runat="server" MaxLength="20" Width="180px"></asp:TextBox>
                        </td>
                    <td rowspan="4" valign="top">
                        <asp:TextBox ID="txtDescription" runat="server" Height="85px" TextMode="MultiLine"
                            Width="278px" MaxLength="1000"></asp:TextBox>
                        <br />
                        <asp:Button ID="btnOK" runat="server" OnClick="btnOK_Click" Text="保存" />
                        <asp:Button ID="btnAddNew" runat="server" OnClick="btnAddNew_Click" Text="新增" CausesValidation="False" />
                        <asp:Label ID="ErrMsg" runat="server" ForeColor="Red"></asp:Label></td>
                </tr>
                <tr>
                    <td align="right">
                        上级分类：</td>
                    <td>
                        <asp:DropDownList ID="ddlParent" runat="server" DataSourceID="SqlDataSource2"
                            DataTextField="theName" DataValueField="theID" Width="186px">
                        </asp:DropDownList></td>
                </tr>
                <tr>
                    <td align="right">
                        总时数：</td>
                    <td>
                        <asp:TextBox ID="txtTime" runat="server" MaxLength="3" Width="50px"></asp:TextBox>
                        <asp:RangeValidator ID="RangeValidator1" runat="server" ControlToValidate="txtTime"
                            ErrorMessage="学时在0-1000之间." MaximumValue="1000" MinimumValue="0" Type="Integer" SetFocusOnError="True"></asp:RangeValidator></td>
                </tr>
                <tr>
                    <td align="right">
                        学分：</td>
                    <td>
                        <asp:TextBox ID="txtCredit" runat="server" MaxLength="2" Width="49px"></asp:TextBox>
                        <asp:RangeValidator ID="RangeValidator2" runat="server" ControlToValidate="txtCredit"
                            ErrorMessage="学分在0-100之间." MaximumValue="100" MinimumValue="0" Type="Integer" SetFocusOnError="True"></asp:RangeValidator></td>
                </tr>
            </tbody>
        </table>
    </div>
    <div style="z-index: 104; left: -7px; width: 1px; position: absolute; top: 432px;
        height: 100px">
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:keke100ConnectionString %>"
            DeleteCommand="DELETE FROM J_Course WHERE co_ID=@co_ID" SelectCommand="SELECT * FROM [J_Course] WHERE ([co_Parent] = @ID)" OnSelected="SqlDataSource1_Selected">
            <DeleteParameters>
                <asp:Parameter Name="co_ID" />
            </DeleteParameters>
            <SelectParameters>
                <asp:Parameter Name="ID" />
            </SelectParameters>
        </asp:SqlDataSource>        
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:keke100ConnectionString %>"
            SelectCommand="p_ListAllCourse" SelectCommandType="StoredProcedure"></asp:SqlDataSource>

    </div>

</asp:Content>