a_expbatch.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;

public partial class A_ExpBatch : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            this.lbMsg.Text = "";
            Admin aAdmin = (Admin)this.Master;
            aAdmin.ManageTitle = "实验项目批次管理";
            aAdmin.MenuSelectedValue = "ExpBatch";
            this.fsItem.Visible = false;
            Initialize();
            this.btnDel.Attributes.Add("onclick", "return  confirm('您真的要删除吗？');");
            BindDisplayList(0,"");
        }

    }


    #region 属性
    static int m_ColID = 0;
    public string CurrentTerm
    {
        get
        {
            if (this.ddlTerm.SelectedIndex == 0)
            {
                return "";
            }
            return this.ddlTerm.SelectedValue;
        }
    }
    public string CurrentCourse
    {
        get
        {
            if (this.ddlCourse.SelectedIndex == 0)
            {
                return "";
            }
            return this.ddlCourse.SelectedValue;
        }
    }
    public long CurrentExpID 
    {
        get
        {
            if (this.ddlExperiment.SelectedIndex > 0)
            {
                return long.Parse(ddlExperiment.SelectedValue);
            }
            else
            {
                return 0;
            }
        }
    }
    #endregion


    #region 操作函数
    /// <summary>
    /// 返回所有的实验项目批次
    /// </summary>
    /// <param name="pageIndex"></param>
    /// <param name="sortExpression">要排序的字段</param>
    private void BindDisplayList(int pageIndex, string sortExpression)
    {
        lbMsg.Text = "";
        BatchList.Columns[m_ColID].Visible = true;
        BatchList.SelectedIndex = -1;
        
        DataTable dt = null;
        if (this.CurrentTerm != "" && this.CurrentCourse != "" && this.CurrentExpID == 0)
        {
            dt = SingleInitials.DbAccess.GetBatchList(this.CurrentTerm,this.CurrentCourse,"").Tables[0];//返回所有列表
        }
        else if (this.CurrentExpID != 0 )
        {
            dt = SingleInitials.DbAccess.GetBatchList(CurrentExpID).Tables[0];//返回所有列表
        }

        if (dt != null)
        {
            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;
    }

    private void Initialize()
    {
        UIControls.BindTermsDDL(this.ddlTerm);
        UIControls.BindTeacherDDL(this.ddlTeacher);
        this.ddlCourse.Items.Insert(0, "请选择..");
        this.ddlExperiment.Items.Insert(0, "请选择..");
    }

    private void DisplayItem(string mID)
    {
        fsItem.Visible = true;
        if (mID == "-1")
        {
            btnDel.Visible = false;
            legendItem.InnerText = "新增";
            NewItem();
        }
        else
        {
            btnDel.Visible = true;
            legendItem.InnerText = "修改";
            LoadItem(int.Parse(mID));
        }
    }
   
    private bool CheckInput(ref string strError)
    {
        strError = "";
        bool retValue = true;
        if (this.tbxKeyID.Text == "-1" && this.CurrentExpID == 0 )//当为添加状态时
        {
            strError += "请选择实验项目;";
            retValue = false;
        }

        if (ddlTeacher.SelectedIndex == 0)
        {
            strError += "请选择老师;";
            retValue = false;
        }
        if (tbxAddress.Text.Trim() == "")
        {
            strError += "请输入地址;";
            retValue = false;
        }
        if (tbxCapcity.Text.Trim() == "")
        {
            strError += "请输入容量;";
            retValue = false;
        }

        if (!UIControls.IsPositiveInt(tbxCapcity.Text.Trim()))
        {
            strError += "\"容量\"必须为正整数;";
            retValue = false;
        }

        if (dpExpDate.Value.Trim() == "")
        {
            strError += "请输入实验日期;";
            retValue = false;
        }
        if (ddlClassNo.SelectedIndex == 0)
        {
            strError += "请选择节次;";
            retValue = false;
        }
        return retValue;

    }
    private bool Save()
    {
        string errStr = "";
        if (!CheckInput(ref errStr))
        {
            lbMsg.Text = errStr;
            return false;
        }

        try
        {
            if (this.tbxKeyID.Text == "-1")
            {
                //添加
                ExpReserve.Batch aBatch = new ExpReserve.Batch();

                aBatch.Address = tbxAddress.Text;
                aBatch.Asured = cbxAsured.Checked.ToString();
                aBatch.Capacity = JKLib.Utility.MyConvert.ToInt32IgnErr(this.tbxCapcity.Text.Trim());
                aBatch.ClassNo = ddlClassNo.Text;
                aBatch.CoureDetailID = this.CurrentExpID;
                aBatch.Date = dpExpDate.DateValue;
                aBatch.TeacherID = long.Parse(this.ddlTeacher.SelectedValue);
                return SingleInitials.DbAccess.AddAbatch(aBatch);
                // true;
            }
            else
            {
                //修改
                ExpReserve.Batch aBatch = SingleInitials.DbAccess.GetABatch(long.Parse(this.tbxKeyID.Text));

                aBatch.Address = tbxAddress.Text;
                aBatch.Asured = cbxAsured.Checked.ToString();
                aBatch.Capacity = JKLib.Utility.MyConvert.ToInt32IgnErr(this.tbxCapcity.Text.Trim());
                aBatch.ClassNo = ddlClassNo.Text;
                //aBatch.CoureDetailID = this.CurrentExpID;
                aBatch.Date = dpExpDate.DateValue;
                aBatch.TeacherID = long.Parse(this.ddlTeacher.SelectedValue);
                //aBatch.ID = long.Parse(this.tbxKeyID.Text);
                return SingleInitials.DbAccess.EditAbatch(aBatch);
            }
        }
        catch (Exception ex)
        {
            lbMsg.Text = ex.Message;
            return false;

        }
        
    }

    private void NewItem()
    {
        // 清空编辑界面 
        ddlTeacher.SelectedIndex = 0;
        tbxAddress.Text = "";
        tbxCapcity.Text = "";
        dpExpDate.Value = "";
        ddlClassNo.SelectedIndex = 0;
        cbxAsured.Checked = false;

    }

    private void LoadItem(int mID)
    {
        
        ExpReserve.Batch aBatch = SingleInitials.DbAccess.GetABatch(mID);
        tbxKeyID.Text = aBatch.ID.ToString();//记录当前记录ID

        ddlTeacher.SelectedValue = aBatch.TeacherID.ToString();
        tbxAddress.Text = aBatch.Address;
        tbxCapcity.Text = aBatch.Capacity.ToString();
        dpExpDate.DateValue = aBatch.Date;
        ddlClassNo.Text = aBatch.ClassNo;
        cbxAsured.Checked = bool.Parse(aBatch.Asured);
        
    }

    #endregion


    #region 表格处理
    protected void BatchList_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        BindDisplayList(e.NewPageIndex, null);
    }
    protected void BatchList_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "BatchEdit")
        {
            BatchList.SelectedIndex = int.Parse(e.CommandArgument.ToString());
            string theID = BatchList.Rows[int.Parse(e.CommandArgument.ToString())].Cells[m_ColID].Text;
            tbxKeyID.Text = theID;
            DisplayItem(theID);
        }
        if (e.CommandName == "ShowStudents")
        {
            BatchList.SelectedIndex = int.Parse(e.CommandArgument.ToString());
            string theID = BatchList.Rows[int.Parse(e.CommandArgument.ToString())].Cells[m_ColID].Text;
            Response.Redirect("A_ExpBooking.aspx?BatchID=" + theID);
        }
    }
    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 ddlTerm_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (ddlTerm.SelectedItem != null && ddlTerm.SelectedIndex >0)
        {
            UIControls.BindCourseDDL(ddlCourse,ddlTerm.SelectedItem.Value);
            ddlExperiment.Items.Clear();
            this.ddlExperiment.Items.Insert(0, "请选择..");
        }
        this.fsItem.Visible = false;
    }
    protected void ddlCourse_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (ddlCourse.SelectedItem != null && ddlTerm.SelectedItem != null
            && ddlTerm.SelectedIndex > 0 && ddlCourse.SelectedIndex>0)
        {
            UIControls.BindExperimentsDDL(ddlExperiment, ddlTerm.SelectedItem.Value,ddlCourse.SelectedItem.Text);
        }
        this.fsItem.Visible = false;
    }
    protected void ddlExperiment_SelectedIndexChanged(object sender, EventArgs e)
    {
        //if (ddlExperiment.SelectedItem != null && ddlExperiment.SelectedIndex>0)
        //{
            this.BindDisplayList(0,"");
        //}
        fsItem.Visible = false;
    }
    #endregion


    #region 按钮事件
    protected void btnNewBatch_Click(object sender, EventArgs e)
    {
        this.tbxKeyID.Text = "-1";
        DisplayItem(tbxKeyID.Text);
    }
    protected void btnDel_Click(object sender, EventArgs e)
    {
        try
        {
            int lastPageIndex = this.BatchList.PageIndex;
            SingleInitials.DbAccess.DeleteAbatch(long.Parse(this.tbxKeyID.Text));
            this.BindDisplayList(0, "");//更新列表
            if (lastPageIndex < this.BatchList.PageCount)
            {
                this.BindDisplayList(lastPageIndex, "");//更新列表
            }
            this.fsItem.Visible = false;
        }
        catch (Exception ex)
        {
            lbMsg.Text = ex.Message;
        }
    }
    protected void btn_Save_Click(object sender, EventArgs e)
    {
        int lastPageIndex = this.BatchList.PageIndex;
        if (Save())
        {
            if ("-1" == this.tbxKeyID.Text)//添加
            {
                this.BindDisplayList(0, "");//更新列表
            }
            else
            {
                this.BindDisplayList(lastPageIndex, "");//更新列表
            }
            
            this.fsItem.Visible = false;
        }
    }
    #endregion
    protected void btnSeeAll_Click(object sender, EventArgs e)
    {
        this.ddlExperiment.SelectedIndex = 0;
        this.BindDisplayList(0,"");
    }
}