コード例 #1
0
        //调整
        protected void ReSet_OnCommand(object sender, CommandEventArgs e)
        {
            if (e.CommandName == "ReSet")
            {
                LabMS.BLL.Arrangement arr = new LabMS.BLL.Arrangement();
                List<LabMS.Model.Arrangement> arrModelList = new List<LabMS.Model.Arrangement>();
                string[] strArray = e.CommandArgument.ToString().Split(',');
                string Week;
                int WeekDay, Lession, LocationID;

                IDHF.Value = e.CommandArgument.ToString();
                Week = strArray[0];
                WeekDay = int.Parse(strArray[1]);
                Lession = int.Parse(strArray[2]);
                LocationID = int.Parse(strArray[3]);
                arrModelList = arr.GetModelList("[Week]='" + Week + "' and [WeekDay]=" + WeekDay + " and Lession=" + Lession + " and LocationID=" + LocationID);
                LabDropdowlist();//绑定实验室
                LabDDL.SelectedValue = arrModelList[0].LabID.ToString();
                HouseDropDownList();//绑定用房
                HouseDDL.SelectedValue = arrModelList[0].LocationID.ToString();
                WeekDropDownList();//绑定周次
                WeekSelectDDL.SelectedValue = arrModelList[0].Week;
                #region 绑定教课教师
                DataSet teacherList = new DataSet();
                teacherList = GetTeacherList(Week, WeekDay, Lession, LocationID);

                string strHTML = "<table id='studenlist' class='infoTable' border='1' style='border-collapse: collapse;'>";
                strHTML += "<thead>";
                strHTML += "<tr class='header'>";
                strHTML += "<th style='display:none'>";
                strHTML += "ID";
                strHTML += "</th>";

                strHTML += "<th>";
                strHTML += "教师编号";
                strHTML += "</th>";

                strHTML += "<th>";
                strHTML += "教师姓名";
                strHTML += "</th>";
                strHTML += "<th>";
                strHTML += "";
                strHTML += "</th>";
                strHTML += "</tr>";
                strHTML += "</thead>";
                strHTML += "<tbody>";
                tb_StudentIDs.Text = teacherList.Tables[0].Rows[0]["ID"].ToString();
                tb_StudentNames.Value = teacherList.Tables[0].Rows[0]["Teacher_Name"].ToString();
                strHTML += "<tr>";
                strHTML += "<td style='display:none'>";
                strHTML += teacherList.Tables[0].Rows[0]["ID"].ToString();
                strHTML += "</td>";
                strHTML += "<td>";
                strHTML += teacherList.Tables[0].Rows[0]["Teacher_Code"].ToString();
                strHTML += "</td>";
                strHTML += "<td>";
                strHTML += teacherList.Tables[0].Rows[0]["Teacher_Name"].ToString();
                strHTML += "</td>";
                strHTML += "<td>";
                strHTML += "<a>删除</a>";
                strHTML += "</td>";
                strHTML += "</tr>";
                strHTML += "</tbody>";
                strHTML += "</table>";
                tblistStudents.Value = strHTML;
                tblistEmpty.Value = "0";
                #endregion
                #region 绑定上课班级
                DataSet classList = new DataSet();
                classList = GetClassList(Week, WeekDay, Lession, LocationID);

                string strHTML2 = "<table  id='studenlist' class='infoTable' border='1' style='border-collapse: collapse;'>";
                strHTML2 += "<thead>";
                strHTML2 += "<tr class='header'>";
                strHTML2 += "<th style='display:none'>";
                strHTML2 += "ID";
                strHTML2 += "</th>";
                strHTML2 += "<th>";
                strHTML2 += "班级编号";
                strHTML2 += "</th>";
                strHTML2 += "<th>";
                strHTML2 += "班级名称";
                strHTML2 += "</th>";
                strHTML2 += "<th>";
                strHTML2 += "专业";
                strHTML2 += "</th>";
                strHTML2 += "<th>";
                strHTML2 += "班级人数";
                strHTML2 += "</th>";
                strHTML2 += "<th>";
                strHTML2 += "删除";
                strHTML2 += "</th>";
                strHTML2 += "</tr>";
                strHTML2 += "</thead>";
                strHTML2 += "<tbody>";
                tb_StudentIDs2.Value = "";
                for (int i = 0; i < classList.Tables[0].Rows.Count; i++)
                {
                    if (tb_StudentIDs2.Value == "")
                    {
                        tb_StudentIDs2.Value += classList.Tables[0].Rows[i]["ID"].ToString();
                        tb_StudentNames2.Value += classList.Tables[0].Rows[i]["Class_Name"].ToString();
                    }
                    else
                    {
                        tb_StudentIDs2.Value += "," + classList.Tables[0].Rows[i]["ID"].ToString();
                        tb_StudentNames2.Value += "," + classList.Tables[0].Rows[i]["Class_Name"].ToString();
                    }
                    strHTML2 += "<tr>";
                    strHTML2 += "<td style='display:none'>";
                    strHTML2 += classList.Tables[0].Rows[i]["ID"].ToString();
                    strHTML2 += "</td>";
                    strHTML2 += "<td>";
                    strHTML2 += classList.Tables[0].Rows[i]["Class_Code"].ToString();
                    strHTML2 += "</td>";
                    strHTML2 += "<td>";
                    strHTML2 += classList.Tables[0].Rows[i]["Class_Name"].ToString();
                    strHTML2 += "</td>";
                    strHTML2 += "<td>";
                    strHTML2 += classList.Tables[0].Rows[i]["Class_Professional"].ToString();
                    strHTML2 += "</td>";
                    strHTML2 += "<td>";
                    strHTML2 += classList.Tables[0].Rows[i]["Class_StudentNum"].ToString();
                    strHTML2 += "</td>";
                    strHTML2 += "<td>";
                    strHTML2 += "<a>删除</a>";
                    strHTML2 += "</td>";
                    strHTML2 += "</tr>";
                }
                strHTML2 += "</tbody>";
                strHTML2 += "</table>";
                tblistEmpty2.Value = "0";
                tblistStudents2.Value = strHTML2;
                #endregion
                IDUniq = GetTeaMissID(int.Parse(arrModelList[0].CourseID.ToString()), YearDDL.SelectedValue, TermDDL.SelectedValue);
                tboldcourse.Text = "chkDay" + WeekDay + "Class" + Lession;
                arrtable.Visible = true;
                YearDDL.Enabled = false;
                TermDDL.Enabled = false;
                CourseDDL.Enabled = false;
                DeleteBtn.Enabled = false;
                ArrangementGridView.Enabled = false;
            }
        }
コード例 #2
0
        //保存更改
        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());
        }
コード例 #3
0
        //检验课程是否有冲突
        protected string[] CheckArrangement(LabMS.Model.Arrangement arrModel)
        {
            LabMS.BLL.Arrangement arr = new LabMS.BLL.Arrangement();
            List<LabMS.Model.Arrangement> arrModelList = new List<LabMS.Model.Arrangement>();
            string[] checkArrangement = new string[5];
            checkArrangement[0] = "";
            checkArrangement[1] = "";
            checkArrangement[2] = "";
            checkArrangement[3] = "";
            checkArrangement[4] = "";
            arrModelList = arr.GetModelList(" LocationID=" + arrModel.LocationID + " and [Week]='" + arrModel.Week + "' and Lession=" + arrModel.Lession + " and [WeekDay]=" + arrModel.WeekDay + " and CourseID<>" + arrModel.CourseID + " and ScoreTerm='" + arrModel.ScoreTerm + "' and Year='" + arrModel.Year + "'");//课程冲突
            if (arrModelList.Count > 0)
            {
                checkArrangement[0] = arrModelList[0].CourseName;
            }

            List<LabMS.Model.Arrangement> arrModelList2 = new List<LabMS.Model.Arrangement>();
            arrModelList2 = arr.GetModelList(" [Week]='" + arrModel.Week + "' and Lession=" + arrModel.Lession + " and [WeekDay]=" + arrModel.WeekDay + " and CourseID<>" + arrModel.CourseID + " and TeacherID=" + arrModel.TeacherID + " and ScoreTerm='" + arrModel.ScoreTerm + "' and Year='" + arrModel.Year + "'");//老师课程安排冲突(同时上2门课程)
            if (arrModelList2.Count > 0)
            {
                checkArrangement[1] = arrModelList2[0].CourseName;
            }

            List<LabMS.Model.Arrangement> arrModelList4 = new List<LabMS.Model.Arrangement>();
            arrModelList4 = arr.GetModelList(" [Week]='" + arrModel.Week + "' and Lession=" + arrModel.Lession + " and [WeekDay]=" + arrModel.WeekDay + " and CourseID<>" + arrModel.CourseID + " and ClassID=" + arrModel.ClassID + " and ScoreTerm='" + arrModel.ScoreTerm + "' and Year='" + arrModel.Year + "'");//班级安排冲突
            if (arrModelList4.Count > 0)
            {
                checkArrangement[3] = arrModelList4[0].CourseName;
            }

            List<LabMS.Model.Arrangement> arrModelList5 = new List<LabMS.Model.Arrangement>();
            arrModelList5 = arr.GetModelList(" [Week]='" + arrModel.Week + "' and Lession=" + arrModel.Lession + " and [WeekDay]=" + arrModel.WeekDay + " and LocationID=" + arrModel.LocationID + " and TeacherID<>" + arrModel.TeacherID + " and ScoreTerm='" + arrModel.ScoreTerm + "' and Year='" + arrModel.Year + "'");//老师地点安排冲突(同一个地点2个老师上课)
            if (arrModelList5.Count > 0)
            {
                checkArrangement[4] = arrModelList5[0].TeacherName;
            }

            List<LabMS.Model.Arrangement> arrModelList3 = new List<LabMS.Model.Arrangement>();
            arrModelList3 = arr.GetModelList(" [Week]='" + arrModel.Week + "' and Lession=" + arrModel.Lession + " and [WeekDay]=" + arrModel.WeekDay + " and CourseID=" + arrModel.CourseID + " and TeacherID=" + arrModel.TeacherID + " and ClassID=" + arrModel.ClassID + " and LocationID=" + arrModel.LocationID);//不添加
            if (arrModelList3.Count > 0)
            {
                checkArrangement[2] = arrModelList3[0].ID.ToString();
            }

            return checkArrangement;
        }
コード例 #4
0
        //处理DS列表
        protected List<LabMS.Model.Arrangement> HandleList(DataSet ds)
        {
            List<LabMS.Model.Arrangement> arrList = new List<LabMS.Model.Arrangement>();
            LabMS.BLL.Arrangement arr = new LabMS.BLL.Arrangement();
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                List<LabMS.Model.Arrangement> arrModelList = new List<LabMS.Model.Arrangement>();
                string strClassName = "";
                List<int> ClassID = new List<int>();
                string strTeaName = "";
                List<int> TeacherID = new List<int>();
                arrModelList = arr.GetModelList("LocationID=" + int.Parse(ds.Tables[0].Rows[i]["LocationID"].ToString()) + " and [WeekDay]=" + int.Parse(ds.Tables[0].Rows[i]["WeekDay"].ToString()) + " and Lession=" + int.Parse(ds.Tables[0].Rows[i]["Lession"].ToString()) + " and CourseID=" + int.Parse(ds.Tables[0].Rows[i]["CourseID"].ToString()) + " and [Week]='" + ds.Tables[0].Rows[i]["Week"].ToString() + "' and ClassID is not null and TeacherID is not null and CourseID is not null and [Week] is not null");
                for (int j = 0; j < arrModelList.Count; j++)
                {
                    bool IsClassID = true;
                    for (int m = 0; m < ClassID.Count; m++)
                    {
                        if (int.Parse(arrModelList[j].ClassID.ToString()) == ClassID[m])
                        {
                            IsClassID = false;
                        }
                    }
                    if (IsClassID)
                    {
                        ClassID.Add(int.Parse(arrModelList[j].ClassID.ToString()));
                        strClassName += arrModelList[j].ClassName + " ";//班级名称
                    }
                    bool IsTeacherID = true;
                    for (int m = 0; m < TeacherID.Count; m++)
                    {
                        if (int.Parse(arrModelList[j].TeacherID.ToString()) == TeacherID[m])
                        {
                            IsTeacherID = false;
                        }
                    }
                    if (IsTeacherID)
                    {
                        TeacherID.Add(int.Parse(arrModelList[j].TeacherID.ToString()));
                        strTeaName += arrModelList[j].TeacherName + " ";//教师名称
                    }
                }
                strClassName = strClassName.Trim();
                strTeaName = strTeaName.Trim();

                LabMS.Model.Arrangement arrModel = new LabMS.Model.Arrangement();
                arrModel.LabName = ds.Tables[0].Rows[i]["ID"].ToString();//暂把实验室名称存储各ID
                arrModel.CourseID = int.Parse(ds.Tables[0].Rows[i]["CourseID"].ToString());
                arrModel.CourseName = ds.Tables[0].Rows[i]["CourseName"].ToString();
                arrModel.ClassName = strClassName;
                arrModel.TeacherName = strTeaName;
                arrModel.Week = ds.Tables[0].Rows[i]["Week"].ToString();
                arrModel.WeekDay = int.Parse(ds.Tables[0].Rows[i]["WeekDay"].ToString());
                arrModel.LocationName = ds.Tables[0].Rows[i]["LocationName"].ToString();
                arrModel.Lession = int.Parse(ds.Tables[0].Rows[i]["Lession"].ToString());
                arrList.Add(arrModel);
            }
            return arrList;
        }
コード例 #5
0
ファイル: AddScore.aspx.cs プロジェクト: dalinhuang/labms
        //获取授课教师 通过项目ID 班级ID 课程ID
        protected string GetTeacherByClaIDAndProIDAndCouID(int CourseID,int ProjectID,int ClassID)
        {
            LabMS.BLL.Arrangement arr = new LabMS.BLL.Arrangement();
            List<LabMS.Model.Arrangement> arrModel = new List<LabMS.Model.Arrangement>();
            int ProCouID,ClaCouID;
            string TeacherName;

            ProCouID = GetProCourseIDByProID(ProjectID, CourseID);
            ClaCouID = GetCouClaIDByClaID(ClassID, CourseID);

            arrModel = arr.GetModelList("ChoosenClassID=" + ClaCouID + " and CourseProjectID=" + ProCouID);
            TeacherName = HandTeaList(arrModel);
            return TeacherName;
        }
コード例 #6
0
        //����γ��Ƿ��г�ͻ
        protected string[] CheckArrangement(LabMS.Model.Arrangement arrModel)
        {
            LabMS.BLL.Arrangement arr=new LabMS.BLL.Arrangement();
            List<LabMS.Model.Arrangement> arrModelList=new List<LabMS.Model.Arrangement>();
            string[] checkArrangement = new string[5];
            checkArrangement[0] = "";
            checkArrangement[1] = "";
            checkArrangement[2] = "";
            checkArrangement[3] = "";
            checkArrangement[4] = "";
            arrModelList = arr.GetModelList(" LocationID=" + arrModel.LocationID + " and [Week]='" + arrModel.Week + "' and Lession=" + arrModel.Lession + " and [WeekDay]=" + arrModel.WeekDay + " and CourseID<>" + arrModel.CourseID + " and ScoreTerm='" + arrModel.ScoreTerm + "' and Year='" + arrModel.Year + "'");//�γ̳�ͻ
            if (arrModelList.Count > 0)
            {
                checkArrangement[0] = arrModelList[0].CourseName;
            }

            List<LabMS.Model.Arrangement> arrModelList2 = new List<LabMS.Model.Arrangement>();
            arrModelList2 = arr.GetModelList(" [Week]='" + arrModel.Week + "' and Lession=" + arrModel.Lession + " and [WeekDay]=" + arrModel.WeekDay + " and CourseID<>" + arrModel.CourseID + " and TeacherID=" + arrModel.TeacherID + " and ScoreTerm='" + arrModel.ScoreTerm + "' and Year='" + arrModel.Year + "'");//��ʦ�γ̰��ų�ͻ(ͬʱ��2�ſγ�)
            if (arrModelList2.Count > 0)
            {
                checkArrangement[1] = arrModelList2[0].CourseName;
            }

            List<LabMS.Model.Arrangement> arrModelList4 = new List<LabMS.Model.Arrangement>();
            arrModelList4 = arr.GetModelList(" [Week]='" + arrModel.Week + "' and Lession=" + arrModel.Lession + " and [WeekDay]=" + arrModel.WeekDay + " and CourseID<>" + arrModel.CourseID + " and ClassID=" + arrModel.ClassID + " and ScoreTerm='" + arrModel.ScoreTerm + "' and Year='" + arrModel.Year + "'");//�༶���ų�ͻ
            if (arrModelList4.Count > 0)
            {
                checkArrangement[3] = arrModelList4[0].CourseName;
            }

            List<LabMS.Model.Arrangement> arrModelList5 = new List<LabMS.Model.Arrangement>();
            arrModelList5 = arr.GetModelList(" [Week]='" + arrModel.Week + "' and Lession=" + arrModel.Lession + " and [WeekDay]=" + arrModel.WeekDay + " and LocationID=" + arrModel.LocationID + " and TeacherID<>" + arrModel.TeacherID + " and ScoreTerm='" + arrModel.ScoreTerm + "' and Year='" + arrModel.Year + "'");//��ʦ�ص㰲�ų�ͻ(ͬһ���ص�2����ʦ�Ͽ�)
            if (arrModelList5.Count > 0)
            {
                checkArrangement[4] = arrModelList5[0].TeacherName;
            }

            List<LabMS.Model.Arrangement> arrModelList3 = new List<LabMS.Model.Arrangement>();
            arrModelList3 = arr.GetModelList(" [Week]='" + arrModel.Week + "' and Lession=" + arrModel.Lession + " and [WeekDay]=" + arrModel.WeekDay + " and CourseID=" + arrModel.CourseID + " and TeacherID=" + arrModel.TeacherID + " and ClassID=" + arrModel.ClassID + " and LocationID=" + arrModel.LocationID);//�����
            if (arrModelList3.Count > 0)
            {
                checkArrangement[2] = arrModelList3[0].ID.ToString();
            }

            return checkArrangement;
        }
コード例 #7
0
        //����
        protected void Save_OnClick(object sender, EventArgs e)
        {
            if (LabDDL.SelectedValue == "0")
            {
                Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('��ѡ��ʵ���ң�')</script>");
                return;
            }
            if (HouseDDL.SelectedValue == "")
            {
                Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('��ѡ�񷿼䣡')</script>");
                return;
            }
            if (tb_StudentIDs.Value == "")
            {
                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;
            }
            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(CourseIDHF.Value));

            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.Value);//��ʦ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[] teaListsID = tb_StudentIDs.Value.Split(',');
            //String[] teaListsName=tb_StudentNames.Value.Split(',');
            String[] claListsID = tb_StudentIDs2.Value.Split(',');
            String[] claListsName=tb_StudentNames2.Value.Split(',');
            //for (int i = 0; i < teaListsID.Length; i++)
            //{
                //arr.TeacherName = teaListsName[i];
                //arr.TeacherID = int.Parse(teaListsID[i]);
                //arr.CourseTeacherID = GetTeaCouID(int.Parse(teaListsID[i]), int.Parse(CourseIDHF.Value));//��ʦ�γ�ID
            arr.CourseTeacherID = GetTeaCouID(int.Parse(tb_StudentIDs.Value), int.Parse(CourseIDHF.Value));
                for (int j = 0; j < claListsID.Length; j++)
                {
                    arr.ClassID = int.Parse(claListsID[j]);//�༶ID
                    arr.ClassName = claListsName[j];//�༶����
                    arr.ChoosenClassID = GetClaCouID(int.Parse(CourseIDHF.Value), int.Parse(claListsID[j]), int.Parse(TeaMisIDHF.Value));//ѡ�ΰ༶ID
                    bool checkAllWeekSelected = false;//�ж��Ƿ�ѡ���ܴ�
                    for (int m = 0; m < 20; m++)
                    {
                        CheckBox check=(CheckBox)lbWeeks.FindControl("chkWeek"+m.ToString());
                        if (check.Checked)
                        {
                            checkAllWeekSelected = true;
                            int mm = m + 1;
                            arr.Week = mm.ToString();//�ڿ��ܴ�
                            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[5];
                                        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;
                            }
                        }
                    }
                    if (!checkAllWeekSelected)
                    {
                        Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('��ѡ���ܴΣ�')</script>");
                        return;
                    }

                }
               // }
            Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('����ɹ���');refreshParent() </script>");
            ArrangementGridView_DataBind();
        }
コード例 #8
0
        //����DS�б�
        protected List<LabMS.Model.Arrangement> HandleList(DataSet ds)
        {
            List<LabMS.Model.Arrangement> arrList = new List<LabMS.Model.Arrangement>();
            LabMS.BLL.Arrangement arr = new LabMS.BLL.Arrangement();
            for(int i=0;i<ds.Tables[0].Rows.Count;i++)
            {
                List<LabMS.Model.Arrangement> arrModelList=new List<LabMS.Model.Arrangement>();
                string strClassName = "";
                List<int> ClassID = new List<int>();
                string strTeaName = "";
                List<int> TeacherID = new List<int>();
                string strWeek = "";
                List<int> WeekList = new List<int>();
                arrModelList = arr.GetModelList("LocationID=" + int.Parse(ds.Tables[0].Rows[i]["LocationID"].ToString()) + " and [WeekDay]=" + int.Parse(ds.Tables[0].Rows[i]["WeekDay"].ToString()) + " and Lession=" + int.Parse(ds.Tables[0].Rows[i]["Lession"].ToString()) + " and CourseID=" + int.Parse(ds.Tables[0].Rows[i]["CourseID"].ToString()) + " and ClassID is not null and TeacherID is not null and Week is not null");
                for (int j = 0; j < arrModelList.Count; j++)
                {
                    bool IsClassID=true;
                    for (int m = 0; m < ClassID.Count; m++)
                    {
                        if (int.Parse(arrModelList[j].ClassID.ToString()) == ClassID[m])
                        {
                            IsClassID = false;
                        }
                    }
                    if (IsClassID)
                    {
                        ClassID.Add(int.Parse(arrModelList[j].ClassID.ToString()));
                        strClassName += arrModelList[j].ClassName+" ";//�༶����
                    }
                    bool IsTeacherID = true;
                    for (int m = 0; m < TeacherID.Count; m++)
                    {
                        if (int.Parse(arrModelList[j].TeacherID.ToString()) == TeacherID[m])
                        {
                            IsTeacherID = false;
                        }
                    }
                    if (IsTeacherID)
                    {
                        TeacherID.Add(int.Parse(arrModelList[j].TeacherID.ToString()));
                        strTeaName += arrModelList[j].TeacherName+" ";//��ʦ����
                    }
                    bool IsWeek = true;
                    for (int m = 0; m < WeekList.Count; m++)
                    {
                        if (int.Parse(arrModelList[j].Week) == WeekList[m])
                        {
                            IsWeek = false;
                        }
                    }
                    if (IsWeek)
                    {
                        WeekList.Add(int.Parse(arrModelList[j].Week));

                        //strWeek += arrModelList[j].Week;//�ܴ�
                    }
                }
                strClassName = strClassName.Trim();
                strTeaName = strTeaName.Trim();
                strWeek = WeekSort(WeekList);

                LabMS.Model.Arrangement arrModel = new LabMS.Model.Arrangement();
                arrModel.ClassName = strClassName;
                arrModel.TeacherName = strTeaName;
                arrModel.Week = strWeek;
                arrModel.WeekDay = int.Parse(ds.Tables[0].Rows[i]["WeekDay"].ToString());
                arrModel.LocationName = ds.Tables[0].Rows[i]["LocationName"].ToString();
                arrModel.Lession = int.Parse(ds.Tables[0].Rows[i]["Lession"].ToString());
                arrList.Add(arrModel);
            }
            return arrList;
        }
コード例 #9
0
        //����γ̰����б�
        protected List<ExtendModule.CourseArrange> HandCouArrList(List<LabMS.Model.TeachMission> couArrList)
        {
            List<ExtendModule.CourseArrange> list=new List<ExtendModule.CourseArrange>();
            if (couArrList.Count == 0)
            {
                return list;
            }
            LabMS.BLL.ClassItem claIte = new LabMS.BLL.ClassItem();
            List<LabMS.Model.ClassItem> claIteModel = new List<LabMS.Model.ClassItem>();
            LabMS.BLL.Arrangement arr = new LabMS.BLL.Arrangement();
            List<LabMS.Model.Arrangement> arrModelList = new List<LabMS.Model.Arrangement>();

            claIteModel = claIte.GetModelList("TeachMissionID is not null");
            arrModelList = arr.GetModelList("ChoosenClassID is not null");
            for (int i = 0; i < couArrList.Count; i++)
            {
                ExtendModule.CourseArrange listModel = new ExtendModule.CourseArrange();

                listModel.ID = GetCourseID(int.Parse(couArrList[i].ID.ToString()));
                listModel.TeaMisID = couArrList[i].ID;
                listModel.Course_Code = couArrList[i].Ms_CourseCode;
                listModel.Course_Name = couArrList[i].Ms_CourseName;
                listModel.IsCheck = couArrList[i].Ms_Conflict;
                listModel.LabName = GetLabNameByID((int)couArrList[i].LabID);
                listModel.Course_ExprientHouse = couArrList[i].Ms_CourseHourse;
                listModel.Class = GetClassAndNum(claIteModel, couArrList[i].ID);
                listModel.ClassArrange = GetArrangedClass(arrModelList, claIteModel, couArrList[i].ID);

                list.Add(listModel);
            }

            return list;
        }