inuser.aspx

智能选课系统:本程序采用Microsoft Visual Studio 2005集成环境开发即 asp.net 2.0+access 数据库开发。 功能如下:学校中学生教师根据不同的权限合理分配,提

<%@ Page Language="C#" MasterPageFile="~/Admin/Index.master" AutoEventWireup="true" CodeFile="Inuser.aspx.cs" Inherits="Admin_Inuser" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table border="0" cellpadding="0" cellspacing="0" style= "width: 100%;
       ">
        <tr>
            <td align="center" colspan="3" style="height: 18px">
                使用中的教学计划</td>
        </tr>
        <tr>
            <td colspan="3" rowspan="4">
                <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
                    DataKeyNames="Classid" DataSourceID="AccessDataSource1" Width="100%" BackColor="White" BorderColor="#336666" BorderStyle="Double" BorderWidth="3px" CellPadding="4" GridLines="Horizontal">
                    <Columns>
                        <asp:BoundField DataField="Cname" HeaderText="课程名称" SortExpression="Cname" />
                        <asp:BoundField DataField="CClass" HeaderText="系别" SortExpression="CClass" />
                        <asp:BoundField DataField="Czhuanye" HeaderText="专业" SortExpression="Czhuanye" />
                        <asp:BoundField DataField="Cteacher" HeaderText="教师" SortExpression="Cteacher" />
                        <asp:BoundField DataField="CweekBegTime" HeaderText="开始周" SortExpression="CweekBegTime" />
                        <asp:BoundField DataField="CweekEndTime" HeaderText="结束周" SortExpression="CweekEndTime" />
                        <asp:BoundField DataField="Cdate" HeaderText="星期" SortExpression="Cdate" />
                        <asp:BoundField DataField="Ctime" HeaderText="节次" SortExpression="Ctime" />
                        <asp:BoundField DataField="Cshifouxuanxiu" HeaderText="是否选修" SortExpression="Cshifouxuanxiu" />
                    </Columns>
                    <FooterStyle BackColor="White" ForeColor="#333333" />
                    <RowStyle BackColor="White" ForeColor="#333333" />
                    <SelectedRowStyle BackColor="#339966" Font-Bold="True" ForeColor="White" />
                    <PagerStyle BackColor="#336666" ForeColor="White" HorizontalAlign="Center" />
                    <HeaderStyle BackColor="#336666" Font-Bold="True" ForeColor="White" />
                </asp:GridView>
                <asp:AccessDataSource ID="AccessDataSource1" runat="server" ConflictDetection="CompareAllValues"
                    DataFile="~/database/xuanke.mdb" DeleteCommand="DELETE FROM [JiaoyanshiClass] WHERE [Classid] = ? AND [Cname] = ? AND [Cteacher] = ? AND [CweekBegTime] = ? AND [Cdate] = ? AND [Ctime] = ? AND [CweekEndTime] = ? AND [CClass] = ? AND [Czhuanye] = ? AND [Cshifouxuanxiu] = ? AND [Cshencha] = ?"
                    InsertCommand="INSERT INTO [JiaoyanshiClass] ([Classid], [Cname], [Cteacher], [CweekBegTime], [Cdate], [Ctime], [CweekEndTime], [CClass], [Czhuanye], [Cshifouxuanxiu], [Cshencha]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
                    OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [JiaoyanshiClass] WHERE ([Cshencha] = ?) ORDER BY [Classid]"
                    UpdateCommand="UPDATE [JiaoyanshiClass] SET [Cname] = ?, [Cteacher] = ?, [CweekBegTime] = ?, [Cdate] = ?, [Ctime] = ?, [CweekEndTime] = ?, [CClass] = ?, [Czhuanye] = ?, [Cshifouxuanxiu] = ?, [Cshencha] = ? WHERE [Classid] = ? AND [Cname] = ? AND [Cteacher] = ? AND [CweekBegTime] = ? AND [Cdate] = ? AND [Ctime] = ? AND [CweekEndTime] = ? AND [CClass] = ? AND [Czhuanye] = ? AND [Cshifouxuanxiu] = ? AND [Cshencha] = ?">
                    <DeleteParameters>
                        <asp:Parameter Name="original_Classid" Type="Int32" />
                        <asp:Parameter Name="original_Cname" Type="String" />
                        <asp:Parameter Name="original_Cteacher" Type="String" />
                        <asp:Parameter Name="original_CweekBegTime" Type="String" />
                        <asp:Parameter Name="original_Cdate" Type="String" />
                        <asp:Parameter Name="original_Ctime" Type="String" />
                        <asp:Parameter Name="original_CweekEndTime" Type="String" />
                        <asp:Parameter Name="original_CClass" Type="String" />
                        <asp:Parameter Name="original_Czhuanye" Type="String" />
                        <asp:Parameter Name="original_Cshifouxuanxiu" Type="String" />
                        <asp:Parameter Name="original_Cshencha" Type="String" />
                    </DeleteParameters>
                    <UpdateParameters>
                        <asp:Parameter Name="Cname" Type="String" />
                        <asp:Parameter Name="Cteacher" Type="String" />
                        <asp:Parameter Name="CweekBegTime" Type="String" />
                        <asp:Parameter Name="Cdate" Type="String" />
                        <asp:Parameter Name="Ctime" Type="String" />
                        <asp:Parameter Name="CweekEndTime" Type="String" />
                        <asp:Parameter Name="CClass" Type="String" />
                        <asp:Parameter Name="Czhuanye" Type="String" />
                        <asp:Parameter Name="Cshifouxuanxiu" Type="String" />
                        <asp:Parameter Name="Cshencha" Type="String" />
                        <asp:Parameter Name="original_Classid" Type="Int32" />
                        <asp:Parameter Name="original_Cname" Type="String" />
                        <asp:Parameter Name="original_Cteacher" Type="String" />
                        <asp:Parameter Name="original_CweekBegTime" Type="String" />
                        <asp:Parameter Name="original_Cdate" Type="String" />
                        <asp:Parameter Name="original_Ctime" Type="String" />
                        <asp:Parameter Name="original_CweekEndTime" Type="String" />
                        <asp:Parameter Name="original_CClass" Type="String" />
                        <asp:Parameter Name="original_Czhuanye" Type="String" />
                        <asp:Parameter Name="original_Cshifouxuanxiu" Type="String" />
                        <asp:Parameter Name="original_Cshencha" Type="String" />
                    </UpdateParameters>
                    <SelectParameters>
                        <asp:Parameter DefaultValue="是" Name="Cshencha" Type="String" />
                    </SelectParameters>
                    <InsertParameters>
                        <asp:Parameter Name="Classid" Type="Int32" />
                        <asp:Parameter Name="Cname" Type="String" />
                        <asp:Parameter Name="Cteacher" Type="String" />
                        <asp:Parameter Name="CweekBegTime" Type="String" />
                        <asp:Parameter Name="Cdate" Type="String" />
                        <asp:Parameter Name="Ctime" Type="String" />
                        <asp:Parameter Name="CweekEndTime" Type="String" />
                        <asp:Parameter Name="CClass" Type="String" />
                        <asp:Parameter Name="Czhuanye" Type="String" />
                        <asp:Parameter Name="Cshifouxuanxiu" Type="String" />
                        <asp:Parameter Name="Cshencha" Type="String" />
                    </InsertParameters>
                </asp:AccessDataSource>
            </td>
        </tr>
        <tr>
        </tr>
        <tr>
        </tr>
        <tr>
        </tr>
        <tr>
            <td align="center" colspan="3" style="height: 16px">
                &nbsp;</td>
        </tr>
    </table>
</asp:Content>