Пример #1
0
        protected void Save_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(tb_CourseCode.Text.Trim()))
            {
                LabMS.Common.JShelper.JSAlert(this, "error", "�γ̱�Ų���Ϊ��");
                return;
            }
            if (string.IsNullOrEmpty(tb_CourseName.Text.Trim()))
            {
                LabMS.Common.JShelper.JSAlert(this, "error", "���������");
                return;
            }
            if (ddl_Lab.SelectedValue == "0")
            {
                LabMS.Common.JShelper.JSAlert(this, "error", "��ѡ��е��γ̵�ʵ����");
                return;
            }
            if (string.IsNullOrEmpty(tb_ExpHouse.Text))
            {
                LabMS.Common.JShelper.JSAlert(this, "error", " ʵ��ѧʱ����Ϊ��");
                return;
            }
            if (string.IsNullOrEmpty(tb_StartWeek.Text))
            {
                LabMS.Common.JShelper.JSAlert(this, "error", "��ʼ�ܴβ���Ϊ����ӦΪ����");
                return;
            }
            if (!IsNumber(tb_StartWeek.Text.Trim()))
            {
                LabMS.Common.JShelper.JSAlert(this, "error", "��ʼ�ܴβ���Ϊ����ӦΪ����");
                return;
            }
            if (!IsNumber(tb_EndWeek.Text.Trim()))
            {
                LabMS.Common.JShelper.JSAlert(this, "error", "�����ܴβ���Ϊ����ӦΪ����");
                return;
            }
            int Num1 = 0;
            int Num2 = 0;
            if (int.TryParse(tb_StartWeek.Text, out Num1) && int.TryParse(tb_EndWeek.Text, out Num2))
            {
                if (Num2 < Num1)
                {
                    LabMS.Common.JShelper.JSAlert(this, "error", "��ʼ�ܴδ��ڽ����ܴ�");
                    return;
                }
            }
            else
            {
                LabMS.Common.JShelper.JSAlert(this, "error", "�ܴβ���Ϊ�գ���Ӧ��Ϊ����");
                return;
            }

            if (!IsNumber(tb_ComputerTime.Text.Trim()))
            {
                LabMS.Common.JShelper.JSAlert(this, "error", "�ϻ�����Ϊ����ӦΪ����");
                return;
            }
            if (string.IsNullOrEmpty(tb_Teacher.Text))
            {
                LabMS.Common.JShelper.JSAlert(this, "error", "��ʦ����Ϊ����ӦΪ����");
                return;
            }
            if (!(Gv_Class.Rows.Count > 0))
            {
                LabMS.Common.JShelper.JSAlert(this, "error", "��ѡ��γ̶�Ӧ�İ༶");
                return;
            }

            LabMS.BLL.TeachMission TeachMission = new LabMS.BLL.TeachMission();
            LabMS.Model.TeachMission model = new LabMS.Model.TeachMission();
            model.LabID = Convert.ToInt32(ddl_Lab.SelectedValue.Trim());

            model.Ms_CourseCode = (tb_CourseCode.Text);
            model.Ms_CourseName = tb_CourseName.Text;
            model.Ms_SubmitTime = DateTime.Now;
            model.Ms_Teacher = Convert.ToInt32(tb_TeacherID.Text);
            model.Ms_Conflict = rbl_Conflict.SelectedValue.Trim();
            model.Ms_StartWeek = Convert.ToInt32(tb_StartWeek.Text.Trim().ToString());
            model.Ms_EndWeek = Convert.ToInt32(tb_EndWeek.Text.Trim().ToString());
            model.Ms_CourseHourse = Convert.ToInt32(tb_ExpHouse.Text.Trim());
            model.Ms_ComputerHourse = Convert.ToInt32(tb_ComputerTime.Text.Trim());
            model.Ms_Year = ddl_Year.SelectedValue;
            model.Ms_Term = ddl_Season.SelectedValue;
            int ID = TeachMission.Add(model);
            string[] array = tb_ClassIDs.Text.Split(',');
            List<string> lsIDs = new List<string>();

            lsIDs.Add(array[0]);

            foreach (string item in array)
            {
                int Count = 0;
                foreach (string Pr in lsIDs)
                {
                    if (item != Pr)
                    {
                        Count++;
                    }
                }
                if (Count == lsIDs.Count)
                {
                    lsIDs.Add(item);
                }
            }

            ///�����༶��ѡ�ΰ༶ �Ϳγ̵�����
            ///\
            ///
            int CourseID = int.Parse(tb_CourseID.Text.Trim());
            LabMS.BLL.ClassItem ClassItem = new LabMS.BLL.ClassItem();
            LabMS.BLL.Class Class = new LabMS.BLL.Class();
            LabMS.Model.Class classModel;
            LabMS.Model.ClassItem classItemModel;
            for (int n = 0; n < lsIDs.Count; n++)
            {
                classModel = Class.GetModel(Convert.ToInt32(lsIDs[n]));
                classItemModel = new LabMS.Model.ClassItem();

                classItemModel.CourseID = CourseID;
                classItemModel.ClassItem_Code = classModel.Class_Code;
                classItemModel.ClassItem_Name = classModel.Class_Name;
                classItemModel.ClassItem_Num = classModel.Class_StudentNum;
                classItemModel.ClassItem_Degree = classModel.Class_Year;
                classItemModel.ClassID = Convert.ToInt32(lsIDs[n]);
                classItemModel.Time = DateTime.Now;
                classItemModel.TeachMissionID = ID;
                int classItemModelID = ClassItem.Add(classItemModel);
            }

            //������ʦ�Ϳγ�֮�����ϵ
            /// ��ʦ��ѡ��
            ///

            LabMS.BLL.TeacherCourse TC = new LabMS.BLL.TeacherCourse();
            LabMS.Model.TeacherCourse Model = new LabMS.Model.TeacherCourse();

            Model.CourseID = CourseID;
            Model.TeacherID = Convert.ToInt32(tb_TeacherID.Text.Trim());

            int temID = TC.Add(Model);

            Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('����ɹ���');if(window.confirm('�Ƿ񷵻��б�ҳ�棿')){window.location.href='TeachingMissionList.aspx'}else{window.location.href='TeachingMissionPreview.aspx?ID=" + temID + "'};</script>");
        }
Пример #2
0
        //添加并获取老师课程ID
        protected int GetTeaCouID(int TeaID, int CouID)
        {
            LabMS.BLL.TeacherCourse teaCou = new LabMS.BLL.TeacherCourse();
            LabMS.Model.TeacherCourse teaCouModel = new LabMS.Model.TeacherCourse();
            List<LabMS.Model.TeacherCourse> teaCouModelList = new List<LabMS.Model.TeacherCourse>();
            int ID;

            teaCouModelList = teaCou.GetModelList("TeacherID=" + TeaID + " and CourseID=" + CouID);
            if (teaCouModelList.Count == 0)
            {
                teaCouModel.CourseID = CouID;
                teaCouModel.TeacherID = TeaID;
                teaCou.Add(teaCouModel);
                ID = teaCou.GetMaxId() - 1;
            }
            else
            {
                ID = teaCouModelList[0].ID;
            }
            return ID;
        }
Пример #3
0
        /// <summary>
        /// �õ�һ������ʵ��
        /// </summary>
        public LabMS.Model.TeacherCourse GetModel(int ID)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("select  top 1 ID,TeacherID,CourseID from TeacherCourse ");
            strSql.Append(" where ID=@ID ");
            SqlParameter[] parameters = {
                    new SqlParameter("@ID", SqlDbType.Int,4)};
            parameters[0].Value = ID;

            LabMS.Model.TeacherCourse model=new LabMS.Model.TeacherCourse();
            DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
            if(ds.Tables[0].Rows.Count>0)
            {
                if(ds.Tables[0].Rows[0]["ID"].ToString()!="")
                {
                    model.ID=int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
                }
                if(ds.Tables[0].Rows[0]["TeacherID"].ToString()!="")
                {
                    model.TeacherID=int.Parse(ds.Tables[0].Rows[0]["TeacherID"].ToString());
                }
                if(ds.Tables[0].Rows[0]["CourseID"].ToString()!="")
                {
                    model.CourseID=int.Parse(ds.Tables[0].Rows[0]["CourseID"].ToString());
                }
                return model;
            }
            else
            {
                return null;
            }
        }
        protected void Save_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(tb_CourseCode.Text.Trim()))
            {
                LabMS.Common.JShelper.JSAlert(this, "error", "�γ̱�Ų���Ϊ��");
                return;
            }
            if (string.IsNullOrEmpty(tb_CourseName.Text.Trim()))
            {
                LabMS.Common.JShelper.JSAlert(this, "error", "���������");
                return;
            }
            if (ddl_Lab.SelectedValue == "0")
            {
                LabMS.Common.JShelper.JSAlert(this, "error", "��ѡ��е��γ̵�ʵ����");
                return;
            }
            if (string.IsNullOrEmpty(tb_ExpHouse.Text))
            {
                LabMS.Common.JShelper.JSAlert(this, "error", " ʵ��ѧʱ����Ϊ��");
                return;
            }
            if (string.IsNullOrEmpty(tb_StartWeek.Text))
            {
                LabMS.Common.JShelper.JSAlert(this, "error", "��ʼ�ܴβ���Ϊ����ӦΪ����");
                return;
            }
            if (!IsNumber(tb_StartWeek.Text.Trim()))
            {
                LabMS.Common.JShelper.JSAlert(this, "error", "��ʼ�ܴβ���Ϊ����ӦΪ����");
                return;
            }
            if (!IsNumber(tb_EndWeek.Text.Trim()))
            {
                LabMS.Common.JShelper.JSAlert(this, "error", "�����ܴβ���Ϊ����ӦΪ����");
                return;
            }
            int Num1 = 0;
            int Num2 = 0;
            if (int.TryParse(tb_StartWeek.Text, out Num1) && int.TryParse(tb_EndWeek.Text, out Num2))
            {
                if (Num2 < Num1)
                {
                    LabMS.Common.JShelper.JSAlert(this, "error", "��ʼ�ܴδ��ڽ����ܴ�");
                }
            }
            else
            {
                LabMS.Common.JShelper.JSAlert(this, "error", "�ܴβ���Ϊ�գ���Ӧ��Ϊ����");
                return;
            }

            if (!IsNumber(tb_ComputerTime.Text.Trim()))
            {
                LabMS.Common.JShelper.JSAlert(this, "error", "�ϻ�����Ϊ����ӦΪ����");
                return;
            }
            if (string.IsNullOrEmpty(tb_Teacher.Text))
            {
                LabMS.Common.JShelper.JSAlert(this, "error", "��ʦ����Ϊ����ӦΪ����");
                return;
            }
            if (!(Gv_Class.Rows.Count > 0))
            {
                LabMS.Common.JShelper.JSAlert(this, "error", "��ѡ��γ̶�Ӧ�İ༶");
                return;
            }

            try
            {
                LabMS.BLL.TeachMission TeachMission = new LabMS.BLL.TeachMission();
                LabMS.Model.TeachMission model = new LabMS.Model.TeachMission();

                model = TeachMission.GetModel(QueryString);
                if (model != null)
                {
                    model.LabID = Convert.ToInt32(ddl_Lab.SelectedValue.Trim());
                    model.Ms_CourseCode = (tb_CourseCode.Text);
                    model.Ms_CourseName = tb_CourseName.Text;
                    model.Ms_SubmitTime = DateTime.Now;
                    model.Ms_Teacher = Convert.ToInt32(tb_TeacherID.Text);
                    model.Ms_Conflict = rbl_Conflict.SelectedValue.Trim();
                    model.Ms_StartWeek = Convert.ToInt32(tb_StartWeek.Text.Trim().ToString());
                    model.Ms_EndWeek = Convert.ToInt32(tb_EndWeek.Text.Trim().ToString());
                    model.Ms_CourseHourse = Convert.ToInt32(tb_ExpHouse.Text.Trim());
                    model.Ms_ComputerHourse = Convert.ToInt32(tb_ComputerTime.Text.Trim());
                    model.Ms_Term = ddl_Season.SelectedValue;
                    model.Ms_Year = ddl_Year.SelectedValue;
                    TeachMission.Update(model);
                }
            }
            catch (Exception ex)
            {
                lb_Error.Text = ex.Message;
            }

            string[] array = tb_ClassIDs.Text.Split(',');
            if (array.Length == 1 && array[0] == "")
            {
                return;
            }
            List<string> lsIDs = new List<string>();

            lsIDs.Add(array[0]);

            foreach (string item in array)
            {
                int Count = 0;
                foreach (string Pr in lsIDs)
                {
                    if (item != Pr)
                    {
                        Count++;
                    }
                }
                if (Count == lsIDs.Count)
                {
                    lsIDs.Add(item);
                }
            }

            //��ȡ�б�
            try
            {
                ExtendBLL.ClassItemDelete ClassItemDelete = new ExtendBLL.ClassItemDelete();
                int result = ClassItemDelete.Delete(QueryString.ToString());
                if (result == 0)
                {
                    //LabMS.Common.JShelper.JSAlert(this, "error", "��ѯ�ַ�������");
                    Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>window.location.href='~/err.aspx?Message=��ѯ�ַ�������';<script>");
                    return;
                }
                if (result == 2)
                {
                    LabMS.Common.JShelper.JSAlert(this, "error", "���´���");
                }
            }
            catch (Exception ex)
            {
                lb_Error.Text = ex.Message;
            }

            int CourseID = int.Parse(tb_CourseID.Text.Trim());
            LabMS.BLL.ClassItem ClassItem = new LabMS.BLL.ClassItem();
            LabMS.BLL.Class Class = new LabMS.BLL.Class();
            LabMS.Model.Class classModel;
            LabMS.Model.ClassItem classItemModel;
            for (int n = 0; n < lsIDs.Count; n++)
            {
                classModel = Class.GetModel(Convert.ToInt32(lsIDs[n]));
                classItemModel = new LabMS.Model.ClassItem();
                classItemModel.CourseID = CourseID;
                classItemModel.ClassItem_Code = classModel.Class_Code;
                classItemModel.ClassItem_Name = classModel.Class_Name;
                classItemModel.ClassItem_Num = classModel.Class_StudentNum;
                classItemModel.ClassItem_Degree = classModel.Class_Year;
                classItemModel.ClassID = Convert.ToInt32(lsIDs[n]);
                classItemModel.Time = DateTime.Now;
                classItemModel.TeachMissionID = QueryString;
                int classItemModelID = ClassItem.Add(classItemModel);
            }

            LabMS.BLL.TeacherCourse TC = new LabMS.BLL.TeacherCourse();
            LabMS.Model.TeacherCourse Model = new LabMS.Model.TeacherCourse();

            Model.CourseID = CourseID;
            Model.TeacherID = Convert.ToInt32(tb_TeacherID.Text.Trim());

            TC.Add(Model);

            Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('�޸ijɹ�');window.location.href='TeachingMissionList.aspx';</script>");
        }