当前文件路径：XuanKeLunWen/Admin/Make.aspx

		            
  1<%...@ Page Language="C#" MasterPageFile="~/Admin/Index.master" AutoEventWireup="true" CodeFile="Make.aspx.cs" Inherits="Admin_Make" Title="Untitled Page" %>
  2<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
  3    <table border="0" cellpadding="0" cellspacing="0" style=" width: 100%;
  4       font-size: 14px;">
  5        <tr>
  6            <td align="center" colspan="3" style=" height: 18px">
  7                教学计划制定</td>
  8        </tr>
  9        <tr>
 10            <td colspan="3" rowspan="4" align="center" style="height: auto">
 11                <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="Classid"
 12                    DataSourceID="AccessDataSource1" AllowPaging="True" Width="100%" BackColor="White" BorderColor="#336666" BorderStyle="Double" BorderWidth="3px" CellPadding="4" GridLines="Horizontal" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" Font-Size="14px">
 13                    <Columns>
 14                        <asp:CommandField SelectText="单击通过审核" ShowSelectButton="True" />
 15                      
 16                       
 17                        <asp:BoundField DataField="CClass" HeaderText="系别" SortExpression="CClass" />
 18                        <asp:BoundField DataField="Czhuanye" HeaderText="专业" SortExpression="Czhuanye" />
 19                        <asp:BoundField DataField="Cteacher" HeaderText="教师" SortExpression="Cteacher" />
 20                        <asp:BoundField DataField="CweekBegTime" HeaderText="开始周" SortExpression="CweekBegTime" />
 21                        <asp:BoundField DataField="CweekEndTime" HeaderText="结束周" SortExpression="CweekEndTime" />
 22                        <asp:BoundField DataField="Cdate" HeaderText="星期" SortExpression="Cdate" />
 23                        <asp:BoundField DataField="Ctime" HeaderText="节次" SortExpression="Ctime" />
 24                        <asp:BoundField DataField="Cshifouxuanxiu" HeaderText="是否选修课" SortExpression="Cshifouxuanxiu" />
 25                    </Columns>
 26                    <FooterStyle BackColor="White" ForeColor="#333333" />
 27                    <RowStyle BackColor="White" ForeColor="#333333" />
 28                    <SelectedRowStyle BackColor="#339966" Font-Bold="True" ForeColor="White" />
 29                    <PagerStyle BackColor="#336666" ForeColor="White" HorizontalAlign="Center" />
 30                    <HeaderStyle BackColor="#336666" Font-Bold="True" ForeColor="White" />
 31                </asp:GridView>
 32                <asp:AccessDataSource ID="AccessDataSource1" runat="server" ConflictDetection="CompareAllValues"
 33                    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] = ?"
 34                    InsertCommand="INSERT INTO [JiaoyanshiClass] ([Classid], [Cname], [Cteacher], [CweekBegTime], [Cdate], [Ctime], [CweekEndTime], [CClass], [Czhuanye], [Cshifouxuanxiu], [Cshencha]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
 35                    OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [JiaoyanshiClass] WHERE ([Cshencha] = ?) ORDER BY [Classid]"
 36                    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] = ?">
 37                    <DeleteParameters>
 38                        <asp:Parameter Name="original_Classid" Type="Int32" />
 39                        <asp:Parameter Name="original_Cname" Type="String" />
 40                        <asp:Parameter Name="original_Cteacher" Type="String" />
 41                        <asp:Parameter Name="original_CweekBegTime" Type="String" />
 42                        <asp:Parameter Name="original_Cdate" Type="String" />
 43                        <asp:Parameter Name="original_Ctime" Type="String" />
 44                        <asp:Parameter Name="original_CweekEndTime" Type="String" />
 45                        <asp:Parameter Name="original_CClass" Type="String" />
 46                        <asp:Parameter Name="original_Czhuanye" Type="String" />
 47                        <asp:Parameter Name="original_Cshifouxuanxiu" Type="String" />
 48                        <asp:Parameter Name="original_Cshencha" Type="String" />
 49                    </DeleteParameters>
 50                    <UpdateParameters>
 51                        <asp:Parameter Name="Cname" Type="String" />
 52                        <asp:Parameter Name="Cteacher" Type="String" />
 53                        <asp:Parameter Name="CweekBegTime" Type="String" />
 54                        <asp:Parameter Name="Cdate" Type="String" />
 55                        <asp:Parameter Name="Ctime" Type="String" />
 56                        <asp:Parameter Name="CweekEndTime" Type="String" />
 57                        <asp:Parameter Name="CClass" Type="String" />
 58                        <asp:Parameter Name="Czhuanye" Type="String" />
 59                        <asp:Parameter Name="Cshifouxuanxiu" Type="String" />
 60                        <asp:Parameter Name="Cshencha" Type="String" />
 61                        <asp:Parameter Name="original_Classid" Type="Int32" />
 62                        <asp:Parameter Name="original_Cname" Type="String" />
 63                        <asp:Parameter Name="original_Cteacher" Type="String" />
 64                        <asp:Parameter Name="original_CweekBegTime" Type="String" />
 65                        <asp:Parameter Name="original_Cdate" Type="String" />
 66                        <asp:Parameter Name="original_Ctime" Type="String" />
 67                        <asp:Parameter Name="original_CweekEndTime" Type="String" />
 68                        <asp:Parameter Name="original_CClass" Type="String" />
 69                        <asp:Parameter Name="original_Czhuanye" Type="String" />
 70                        <asp:Parameter Name="original_Cshifouxuanxiu" Type="String" />
 71                        <asp:Parameter Name="original_Cshencha" Type="String" />
 72                    </UpdateParameters>
 73                    <SelectParameters>
 74                        <asp:Parameter DefaultValue="否" Name="Cshencha" Type="String" />
 75                    </SelectParameters>
 76                    <InsertParameters>
 77                        <asp:Parameter Name="Classid" Type="Int32" />
 78                        <asp:Parameter Name="Cname" Type="String" />
 79                        <asp:Parameter Name="Cteacher" Type="String" />
 80                        <asp:Parameter Name="CweekBegTime" Type="String" />
 81                        <asp:Parameter Name="Cdate" Type="String" />
 82                        <asp:Parameter Name="Ctime" Type="String" />
 83                        <asp:Parameter Name="CweekEndTime" Type="String" />
 84                        <asp:Parameter Name="CClass" Type="String" />
 85                        <asp:Parameter Name="Czhuanye" Type="String" />
 86                        <asp:Parameter Name="Cshifouxuanxiu" Type="String" />
 87                        <asp:Parameter Name="Cshencha" Type="String" />
 88                    </InsertParameters>
 89                </asp:AccessDataSource>
 90                <br />
 91                </td>
 92        </tr>
 93        <tr>
 94        </tr>
 95        <tr>
 96        </tr>
 97        <tr>
 98        </tr>
 99        <tr>
100            <td align="center" colspan="3" style="height: 16px">
101                &nbsp;</td>
102        </tr>
103    </table>
104</asp:Content>
105
106