a_expbatch.aspx

实验课预约系统。采用.net+access数据库实现。 管理员对学生教师有管理功能

<%@ Page Language="C#" MasterPageFile="~/Admin.master"  AutoEventWireup="true" CodeFile="A_ExpBatch.aspx.cs" Inherits="A_ExpBatch" Title="开放式实验室预约系统-实验项目批次管理"  %>

<%@ Register Assembly="devBiz.Web.UI" Namespace="devBiz.Web.UI.WebControls" TagPrefix="dbz" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
       <fieldset id="fsList" runat="server" style="text-align: left">
        <legend runat="server" id="legendList">实验批次列表</legend>
        <div align="left">
            <asp:Label ID="Label1" runat="server" Text="学期"></asp:Label>
            <asp:DropDownList ID="ddlTerm" runat="server" Width="133px" AutoPostBack="True" OnSelectedIndexChanged="ddlTerm_SelectedIndexChanged">
            </asp:DropDownList>&nbsp;&nbsp;&nbsp;
            
            <asp:Label ID="Label2" runat="server" Text="实验科目"></asp:Label>
            <asp:DropDownList ID="ddlCourse" runat="server" Width="116px" AutoPostBack="True" OnSelectedIndexChanged="ddlCourse_SelectedIndexChanged">
            </asp:DropDownList>&nbsp;&nbsp;&nbsp;
            
            <asp:Label ID="Label3" runat="server" Text="实验项目"></asp:Label>
            <asp:DropDownList ID="ddlExperiment" runat="server" Width="125px" AutoPostBack="True" OnSelectedIndexChanged="ddlExperiment_SelectedIndexChanged">
            </asp:DropDownList>
            <asp:Button ID="btnSeeAll" runat="server" Text="查看全部" OnClick="btnSeeAll_Click" />
            
        </div>
        <div align="left">
        <asp:Button ID="btnNewBatch" runat="server" Text="新增" Width="100px" OnClick="btnNewBatch_Click"/></div>
     <asp:GridView ID="BatchList" runat="server" OnPageIndexChanging="BatchList_PageIndexChanging" OnRowCommand="BatchList_RowCommand" OnRowCreated="BatchList_RowCreated" OnRowDataBound="BatchList_RowDataBound" OnSorting="BatchList_Sorting" AutoGenerateColumns="False" >
        <Columns>
            <asp:BoundField DataField="ID" HeaderText="ID">
                <ItemStyle Width="20px" />
            </asp:BoundField>
            <asp:ButtonField HeaderText="编辑" Text="编辑" CommandName="BatchEdit" ButtonType="Button" >
                <ItemStyle Width="40px" />
            </asp:ButtonField>
　　　　　　<asp:BoundField DataField="CourseName" HeaderText="实验科目" />
            <asp:BoundField DataField="CourseDetailName" HeaderText="实验项目" />
            <asp:BoundField DataField="TeacherName" HeaderText="指导老师"/>
            <asp:BoundField DataField="Address" HeaderText="实验地址">
                <ItemStyle Width="100px" />
            </asp:BoundField>
            <asp:BoundField DataField="Capacity" HeaderText="容量">
                <ItemStyle Width="60px" />
            </asp:BoundField>
            <asp:BoundField DataField="Date" HeaderText="实验日期" DataFormatString="{0:yyyy-MM-dd}" HtmlEncode="False" />
            <asp:BoundField DataField="ClassNo" HeaderText="节次" />
            <asp:BoundField DataField="Asured" HeaderText="是否确认" />
            <asp:ButtonField CommandName="ShowStudents" Text="查看预约学生" HeaderText="查看预约学生" />
        </Columns>
    </asp:GridView>
    </fieldset>  
    <br />
    <fieldset id="fsItem" runat="server" style="text-align: left">
    <legend id="legendItem" runat="server">Edit</legend>
        <br />
        <table id="Table1" cellpadding="0" cellspacing="0" width="80%" border="0" runat="server">
				<tr>
					<td style="width: 145px; height: 24px">
                        指导老师</td>
					<td style="width: 501px; height: 24px; text-align: left;"> 
                        <asp:DropDownList ID="ddlTeacher" runat="server" Width="156px">
                        </asp:DropDownList>
                     </td>
				</tr>
				<tr>
					<td style="width: 145px; height: 24px">
                        实验地址</td>
					<td style="width: 501px; height: 24px; text-align: left;"><asp:TextBox id="tbxAddress" runat="server" CssClass="textbox" MaxLength="24"></asp:TextBox></td>
				</tr>
				<tr>
					<td style="width: 145px; height: 24px;">
                       容量
                     </td>
					<td style="width: 501px; text-align: left; height: 24px;">
                        <asp:TextBox ID="tbxCapcity" runat="server" MaxLength="4"></asp:TextBox>
                     </td>
				</tr>
				<tr>
					<td style="width: 145px">
                       实验日期
                     </td>
					<td style="width: 501px; text-align: left;">
                      
                        <dbz:DatePicker ID="dpExpDate" runat="server" DateFormat="yyyy-MM-dd" />
                     </td>
				</tr>
				<tr>
					<td style="width: 145px">
                       节次
                     </td>
					<td style="width: 501px; text-align: left;">
                       <asp:DropDownList ID="ddlClassNo" runat="server" Width="83px">
                           <asp:ListItem>请选择...</asp:ListItem>
                           <asp:ListItem>1,2节</asp:ListItem>
                           <asp:ListItem>3,4节</asp:ListItem>
                           <asp:ListItem>5,6节</asp:ListItem>
                           <asp:ListItem>7,8节</asp:ListItem>
                           <asp:ListItem>9,10节</asp:ListItem>
                       </asp:DropDownList>
                    </td>
				</tr>
				<tr>
					<td style="width: 145px">
                       是否确认
                     </td>
					<td style="width: 501px; text-align: left;">
                        <asp:CheckBox ID="cbxAsured" runat="server" Text="已确认" />
                        
                        
                     </td>
				</tr>
				<tr>
					<td colspan="2" align="center" style="height: 24px; text-align: left">
                        <asp:Label ID="lbMsg" runat="server" ForeColor="Red" Text="Label"></asp:Label><br />
                        <asp:Button id="btn_Save" runat="server" Text=" 保存 " CssClass="button" ToolTip="保存当前用户的更改" Width="100px" OnClick="btn_Save_Click"></asp:Button><asp:Button id="btnDel" runat="server" Text=" 删除 " CssClass="button" ToolTip="删除当前记录" OnClick="btnDel_Click"></asp:Button>
                        <asp:TextBox ID="tbxKeyID" runat="server" Visible="false" Width="89px">-1</asp:TextBox></td>
				</tr>
			</table>
        </fieldset> 
       
</asp:Content>