t_expbatchs.aspx.cs

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

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using ExpReserve;

public partial class T_ExpBatchs : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Admin aAdmin = (Admin)this.Master;
            aAdmin.ManageTitle = "预约批次管理";
            aAdmin.MenuSelectedValue = "TExpBatchs";
            

            lblCurrentTerm.Text = SingleInitials.DbAccess.GetActiveTerm();
            UIControls.BindCourseDDL(this.ddlCourse, lblCurrentTerm.Text);
            this.ddlExperiment.Items.Insert(0,"请选择..");
            this.lbMsg.Text = "";
            btnSeeAll_Click(this,new EventArgs());

        }


    }


    #region 属性
    static int m_ColID = 0;
    public string CurrentTerm
    {
        get
        {
            return this.lblCurrentTerm.Text;
        }
    }
    public string CurrentCourse
    {
        get
        {
            if (this.ddlCourse.SelectedIndex == 0)
            {
                return "";
            }
            return this.ddlCourse.SelectedValue;
        }
    }
    public string CurrentExperiment
    {
        get
        {
            if (this.ddlExperiment.SelectedIndex == 0)
            {
                return "";
            }
            return this.ddlExperiment.SelectedItem.Text;
        }
    }
    public long CurrentTeacherID
    {
        get
        {
            return long.Parse(Users.GetCurrentTableID());
        }
    }
    #endregion



    /// <summary>
    /// 返回所有的实验项目批次
    /// </summary>
    /// <param name="pageIndex"></param>
    /// <param name="sortExpression">要排序的字段</param>
    private void BindDisplayList(int pageIndex, string sortExpression)
    {
        this.lbMsg.Text = "";
        BatchList.Columns[m_ColID].Visible = true;
        BatchList.SelectedIndex = -1;


        DataTable dt = SingleInitials.DbAccess.GetTeacherBatchList(CurrentTerm,CurrentCourse,CurrentExperiment,CurrentTeacherID).Tables[0];//返回所有列表
        dt.Columns.Add("State",typeof(string),"BookingCount+'/'+Capacity");
        dt.Columns.Add("ButtonText",typeof(string));
        dt.Columns.Add("IsOverdue", typeof(string));
        
        foreach (DataRow iDataRow in dt.Rows)
        {
            if (bool.Parse(iDataRow["Asured"].ToString()))
            {
                iDataRow["ButtonText"] = "取消确认";
            }
            else
            {
                iDataRow["ButtonText"] = "确认";
            }
            DateTime iDate = DateTime.Parse(iDataRow["Date"].ToString());
            if (iDate >= DateTime.Now)
            {
                iDataRow["IsOverdue"] = "否";
            }
            else
            {
                iDataRow["IsOverdue"] = "是";
            }

        }
        if (sortExpression == null || sortExpression == string.Empty)
        {
            JKLib.Web.GridViewOperation.BindPagingGridView(BatchList, dt.DefaultView, pageIndex);
        }
        else
        {
            JKLib.Web.GridViewOperation.BindPagingGridView(BatchList, dt.DefaultView, pageIndex, sortExpression, true, JKLib.Web.GridViewOperation.BindPagingGridViewType.Sorting);
        }
        BatchList.Columns[m_ColID].Visible = false;
    }

   


    #region 表格处理
    protected void BatchList_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        BindDisplayList(e.NewPageIndex, null);
    }
    protected void BatchList_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "BatchAsure")
        {
            string theID = BatchList.Rows[int.Parse(e.CommandArgument.ToString())].Cells[m_ColID].Text;
            long aBatchID = long.Parse(theID);
            try
            {
                bool IsCancel = false;
                Batch aBatch = SingleInitials.DbAccess.GetABatch(aBatchID);
                if (bool.Parse(aBatch.Asured))
                {
                    aBatch.Asured = false.ToString();
                    IsCancel = true;
                }
                else
                {
                    aBatch.Asured = true.ToString();
                    IsCancel = false;
                }
                int lastPageIndex = BatchList.PageIndex;
                SingleInitials.DbAccess.EditAbatch(aBatch);
                //更新列表
                BindDisplayList(lastPageIndex, "");
                if (IsCancel)
                {
                    this.lbMsg.Text = "取消确认成功!";
                }
                else
                {
                    this.lbMsg.Text = "确认成功!";
                }
                
            }
            catch (Exception ex)
            {
                this.lbMsg.Text = ex.Message;
            }  
        }
    }
    protected void BatchList_RowCreated(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.Pager)
            JKLib.Web.GridViewOperation.GridRowCreated(sender, e);
    }
    protected void BatchList_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        ////Button   btn   =   (Button)e.Row.Cells[2].Controls[0]; 
        ////btn.Attributes.Add("onclick","return   confirm('您真的要删除吗？');");
        //LinkButton btn = (LinkButton)e.Row.Cells[2].Controls[0]; 
        //btn.Attributes.Add("onclick", "return   confirm('您真的要删除吗？');");    
    }
    protected void BatchList_Sorting(object sender, GridViewSortEventArgs e)
    {
        BindDisplayList(BatchList.PageIndex, e.SortExpression);
    }
    #endregion


    #region 列表事件处理
   
    protected void ddlCourse_SelectedIndexChanged(object sender, EventArgs e)
    {
        BatchList.DataSource = null;
        BatchList.DataBind();
        if (ddlCourse.SelectedIndex > 0 && this.lblCurrentTerm.Text != "")
        {
            UIControls.BindExperimentsDDL(this.ddlExperiment, this.lblCurrentTerm.Text, this.ddlCourse.SelectedValue);
        }
        else
        {
            this.ddlExperiment.Items.Clear();
            this.ddlExperiment.Items.Insert(0,"请选择..");
        }
    }
    protected void ddlExperiment_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (this.ddlCourse.SelectedIndex > 0)
        {
            this.BindDisplayList(0, "");
        }
        
    }
    #endregion

    protected void btnSeeAll_Click(object sender, EventArgs e)
    {
        int pageIndex = 0;
        string sortExpression = "";
        this.lbMsg.Text = "";
        BatchList.Columns[m_ColID].Visible = true;
        BatchList.SelectedIndex = -1;
        this.ddlCourse.SelectedIndex = 0;
        this.ddlExperiment.SelectedIndex = 0;

        DataTable dt = SingleInitials.DbAccess.GetTeacherBatchList(CurrentTerm, "", "", CurrentTeacherID).Tables[0];//返回所有列表
        dt.Columns.Add("State", typeof(string), "BookingCount+'/'+Capacity");
        dt.Columns.Add("ButtonText", typeof(string));
        dt.Columns.Add("IsOverdue", typeof(string));
        foreach (DataRow iDataRow in dt.Rows)
        {
            if (bool.Parse(iDataRow["Asured"].ToString()))
            {
                iDataRow["ButtonText"] = "取消确认";
            }
            else
            {
                iDataRow["ButtonText"] = "确认";
            }
            DateTime iDate = DateTime.Parse(iDataRow["Date"].ToString());
            if (iDate >= DateTime.Now)
            {
                iDataRow["IsOverdue"] = "否";
            }
            else
            {
                iDataRow["IsOverdue"] = "是";
            }
        }
        if (sortExpression == null || sortExpression == string.Empty)
        {
            JKLib.Web.GridViewOperation.BindPagingGridView(BatchList, dt.DefaultView, pageIndex);
        }
        else
        {
            JKLib.Web.GridViewOperation.BindPagingGridView(BatchList, dt.DefaultView, pageIndex, sortExpression, true, JKLib.Web.GridViewOperation.BindPagingGridViewType.Sorting);
        }
        BatchList.Columns[m_ColID].Visible = false;

    }
}