//获取教学任务书ID
        public int GetTeaMissID(int ID, string Year, string Term)
        {
            ExtendBLL.Arrangement arr = new ExtendBLL.Arrangement();
            DataSet ds = new DataSet();
            int teaMisID;

            ds = arr.GetTeaMisID(ID, Year, Term);
            teaMisID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
            return teaMisID;
        }
        //绑定GridView
        protected void ArrangementGridView_DataBind(int CourseID, string Week, string WeekDay, string LocationName, string TeacherName)
        {
            List<LabMS.Model.Arrangement> arrModelList = new List<LabMS.Model.Arrangement>();
            ExtendBLL.Arrangement couArrange = new ExtendBLL.Arrangement();
            DataSet ds = new DataSet();
            ds = couArrange.GetAllArrangement(CourseID, Week, WeekDay, LocationName, TeacherName);
            arrModelList = HandleList(ds);

            ArrangementGridView.DataSource = arrModelList;
            ArrangementGridView.DataBind();
        }
        //保存更改
        protected void Save_OnClick(object sender, EventArgs e)
        {
            if (tb_StudentIDs.Text == "")
            {
                Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('请选择教师!')</script>");
                return;
            }
            if (tb_StudentIDs2.Value == "")
            {
                Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('请选择班级!')</script>");
                return;
            }

            string[] strArray = IDHF.Value.Split(',');
            ExtendBLL.Arrangement arrExBLL = new ExtendBLL.Arrangement();

            string Week = strArray[0];
            int WeekDay = int.Parse(strArray[1]);
            int Lession = int.Parse(strArray[2]);
            int LocationID = int.Parse(strArray[3]);

            arrExBLL.DeleteCouArr(" [Week]='" + Week + "' and Weekday=" + WeekDay + " and Lession=" + Lession + " and LocationID=" + LocationID + " and CourseID=" + int.Parse(CourseDDL.SelectedValue));

            LabMS.BLL.Arrangement arrBLL = new LabMS.BLL.Arrangement();
            LabMS.Model.Arrangement arr = new LabMS.Model.Arrangement();
            LabMS.BLL.Course cou = new LabMS.BLL.Course();
            LabMS.Model.Course couModel = new LabMS.Model.Course();
            couModel = cou.GetModel(int.Parse(CourseDDL.SelectedValue));

            arr.CourseID = couModel.ID;//课程ID
            arr.Year = couModel.CourseYear;//学年
            arr.ScoreTerm = couModel.CourseSeason;//学期
            arr.CourseName = couModel.Course_Name;//课程名称
            arr.LocationID = int.Parse(HouseDDL.SelectedValue);//用房ID
            arr.LocationName = HouseDDL.SelectedItem.Text;//用房位置
            arr.LabID = int.Parse(LabDDL.SelectedValue);//实验室ID
            arr.TeacherID = int.Parse(tb_StudentIDs.Text);//教师ID
            arr.TeacherName = tb_StudentNames.Value;//教师名称
            string labName = LabDDL.Text;
            int index = labName.IndexOf("|-");
            if (index == 0)
            {
                labName = labName.Substring(index, labName.Length - index - 1);
            }
            arr.LabName = labName;//实验室名称
            String[] claListsID = tb_StudentIDs2.Value.Split(',');
            String[] claListsName = tb_StudentNames2.Value.Split(',');

            arr.CourseTeacherID = GetTeaCouID(int.Parse(tb_StudentIDs.Text), int.Parse(CourseDDL.SelectedValue));
            for (int j = 0; j < claListsID.Length; j++)
            {
                arr.ClassID = int.Parse(claListsID[j]);//班级ID
                arr.ClassName = claListsName[j];//班级名称
                arr.ChoosenClassID = GetClaCouID(int.Parse(CourseDDL.SelectedValue), int.Parse(claListsID[j]), GetTeaMissID(int.Parse(CourseDDL.SelectedValue), YearDDL.SelectedValue, TermDDL.SelectedValue));//选课班级ID

                arr.Week = WeekSelectDDL.SelectedValue;//授课周次
                bool checkClassSelected = false;
                for (int n = 1; n < 8; n++)
                {
                    arr.WeekDay = n;//授课天次

                    for (int p = 1; p < 6; p++)
                    {
                        CheckBox check2 = (CheckBox)lbDayAndClass.FindControl("chkDay" + n.ToString() + "Class" + p.ToString());
                        if (check2.Checked)
                        {
                            checkClassSelected = true;
                            arr.Lession = p;//授课节次

                            string[] strCheckArrangement = new string[3];
                            strCheckArrangement = CheckArrangement(arr);
                            if (strCheckArrangement[0] != "")
                            {
                                Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('课程安排冲突!" + arr.LocationName + "在第" + arr.Week.ToString() + "周 星期" + arr.WeekDay.ToString() + " 第" + arr.Lession.ToString() + "大节已安排课程:" + strCheckArrangement[0] + "')</script>");
                                return;
                            }
                            if (strCheckArrangement[1] != "")
                            {
                                Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('老师课程安排冲突!" + arr.TeacherName + "在第" + arr.Week.ToString() + "周 星期" + arr.WeekDay.ToString() + " 第" + arr.Lession.ToString() + "大节已安排课程:" + strCheckArrangement[1] + "')</script>");
                                return;
                            }
                            if (strCheckArrangement[3] != "")
                            {
                                Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('班级安排冲突!" + arr.ClassName + "在第" + arr.Week.ToString() + "周 星期" + arr.WeekDay.ToString() + " 第" + arr.Lession.ToString() + "大节已安排课程:" + strCheckArrangement[3] + "')</script>");
                                return;
                            }
                            if (strCheckArrangement[4] != "")
                            {
                                Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('老师地点安排冲突!在第" + arr.Week.ToString() + "周 星期" + arr.WeekDay.ToString() + " 第" + arr.Lession.ToString() + "大节已安排老师:" + strCheckArrangement[4] + "上课')</script>");
                                return;
                            }
                            if (strCheckArrangement[2] != "")
                            {
                                ;
                            }
                            else
                            {
                                arrBLL.Add(arr);
                            }
                        }
                    }
                }
                if (!checkClassSelected)
                {
                    Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('请选择上课节次!')</script>");
                    return;
                }
            }
            Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('修改成功!')</script>");
            arrtable.Visible = false;
            YearDDL.Enabled = true;
            TermDDL.Enabled = true;
            CourseDDL.Enabled = true;
            DeleteBtn.Enabled = true;
            ArrangementGridView.Enabled = true;
            ArrangementGridView_DataBind(int.Parse(CourseDDL.SelectedValue), WeekDDL.SelectedValue, WeekDayDDL.SelectedValue, LocationBTX.Text.Trim(), TeacherTBX.Text.Trim());
        }
        //获取老师列表
        protected DataSet GetTeacherList(string Week, int WeekDay, int Lession, int LocationID)
        {
            ExtendBLL.Arrangement arr = new ExtendBLL.Arrangement();
            DataSet ds = new DataSet();

            ds = arr.GetTeaInfo(Week, WeekDay, Lession, LocationID);
            return ds;
        }
 //删除
 protected void Delete_OnClick(object sender, EventArgs e)
 {
     ExtendBLL.Arrangement arr = new ExtendBLL.Arrangement();
     for (int i = 0; i < ArrangementGridView.Rows.Count; i++)
     {
         CheckBox CB = (CheckBox)ArrangementGridView.Rows[i].FindControl("chk");
         if (CB.Checked)
         {
             string[] str = ArrangementGridView.DataKeys[i].Value.ToString().Split(',');
             arr.DeleteCouArr("[Week]='" + str[0] + "' and [WeekDay]=" + int.Parse(str[1]) + " and Lession=" + int.Parse(str[2]) + " and LocationID=" + int.Parse(str[3]));
         }
     }
     ArrangementGridView_DataBind(int.Parse(CourseDDL.SelectedValue), WeekDDL.SelectedValue, WeekDayDDL.SelectedValue, LocationBTX.Text.Trim(), TeacherTBX.Text.Trim());
 }
Example #6
0
        //��ȡGV�б�
        protected DataSet GetGVList(int CouID)
        {
            ExtendBLL.Arrangement arr =new ExtendBLL.Arrangement();
            DataSet ds = new DataSet();

            ds = arr.GetList(CouID);
            return ds;
        }
        protected void ReSet_OnCommand(object sender, CommandEventArgs e)
        {
            if (e.CommandName == "ReSet")
            {
                ExtendBLL.Arrangement arr = new ExtendBLL.Arrangement();
                LabMS.BLL.ClassItem claItem = new LabMS.BLL.ClassItem();
                List<LabMS.Model.ClassItem> claItemModel = new List<LabMS.Model.ClassItem>();
                StringBuilder strWhere = new StringBuilder();

                strWhere.Append("ChoosenClassID=0");
                claItemModel = claItem.GetModelList("TeachMissionID=" + int.Parse(e.CommandArgument.ToString()));
                for (int i = 0; i < claItemModel.Count; i++)
                {
                    strWhere.Append(" or ChoosenClassID=" + claItemModel[i].ID);
                }

                arr.DeleteCouArr(strWhere.ToString());
            }
            CouArrangeGridView_DataBind();
        }
        //��ȡ�γ�ID
        protected int GetCourseID(int ID)
        {
            ExtendBLL.Arrangement arr = new ExtendBLL.Arrangement();
            DataSet ds = new DataSet();

            ds = arr.GetCourseIDByTeaMisID(ID);

            int courseID;
            courseID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
            return courseID;
        }