Exemple #1
0
        public ActionResult ZiXiAction()
        {
            var Jih = jiHuaBLL.GetAllData().Where(p => p.ShiFouWanCheng == false).OrderByDescending(p => p.ID).First();

            DateTime StartTime = (DateTime)Jih.KaiShiShiJian;

            DateTime EndTime = (DateTime)Jih.JieShuShiJian;

            TimeSpan time = EndTime - StartTime;
            //本次班级排课班级及次数集合
            List <BenCiPaiKeBanJiJiCiShu> Class = PaiKeBanJiJiCiShuBLL.GetAllData();
            //已安排上课的班级
            var ClassList = PaiKeBLL.GetAllData();

            //本次排课的班级
            var ClassList2 = Class.ToList().Distinct();

            var ClassList3 = ClassList2.ToList().OrderBy(i => Guid.NewGuid()).ToList();

            try
            {
                foreach (var item in ClassList2)
                {
                    for (int i = 0; i < time.Days; i++)
                    {
                        //查询当天的上午是否排课
                        var Count        = ClassList.Where(p => p.BJ == item.BanJiMingChen && p.RQ == StartTime.AddDays(i) && p.SD == "上").Count();
                        var WeiAnPaiList = PaiKeBLL.List(StartTime.AddDays(i));
                        if (Count == 0)
                        {
                            if (PaiKeBLL.List(StartTime.AddDays(i), "上").Count() == 0)
                            {
                                PaikeLinshiBiao paikeLinshi = new PaikeLinshiBiao()
                                {
                                    JS = "未安排",
                                    BJ = item.BanJiMingChen,
                                    KC = "放假",
                                    JY = "未安排",
                                    RQ = StartTime.AddDays(i),
                                    SD = "上"
                                };
                                PaiKeBLL.Add(paikeLinshi);
                            }
                            else
                            {
                                var             a           = PaiKeBLL.List(StartTime.AddDays(i), "上").First();;
                                PaikeLinshiBiao paikeLinshi = new PaikeLinshiBiao()
                                {
                                    JS = a.KeYongZiYuanMingChen,
                                    BJ = item.BanJiMingChen,
                                    KC = "自习",
                                    JY = "未安排",
                                    RQ = StartTime.AddDays(i),
                                    SD = "上"
                                };
                                PaiKeBLL.Add(paikeLinshi);
                            }
                        }
                        //查询当天的下午是否排课
                        var XW = ClassList.Where(p => p.BJ == item.BanJiMingChen && p.RQ == StartTime.AddDays(i) && p.SD == "下").Count();
                        if (XW == 0)
                        {
                            if (PaiKeBLL.List(StartTime.AddDays(i), "下").Count() == 0)
                            {
                                PaikeLinshiBiao paikeLinshi = new PaikeLinshiBiao()
                                {
                                    JS = "未安排",
                                    BJ = item.BanJiMingChen,
                                    KC = "自习",
                                    JY = "未安排",
                                    RQ = StartTime.AddDays(i),
                                    SD = "下"
                                };
                                PaiKeBLL.Add(paikeLinshi);
                            }
                            else
                            {
                                var             a           = PaiKeBLL.List(StartTime.AddDays(i), "下").First();
                                PaikeLinshiBiao paikeLinshi = new PaikeLinshiBiao()
                                {
                                    JS = a.KeYongZiYuanMingChen,
                                    BJ = item.BanJiMingChen,
                                    KC = "自习",
                                    JY = "未安排",
                                    RQ = StartTime.AddDays(i),
                                    SD = "下"
                                };
                                PaiKeBLL.Add(paikeLinshi);
                            }
                        }
                        //查询当天是否排课
                        var SD = PaiKeBLL.GetAllData().Where(p => p.BJ == item.BanJiMingChen && p.RQ == StartTime.AddDays(i)).Count();
                        if (SD == 0)
                        {
                            var a = PaiKeBLL.List(StartTime.AddDays(i)).First();
                            for (int Hi = 0; Hi < 2; Hi++)
                            {
                                string str2 = "";
                                if (i == 1)
                                {
                                    str2 = "上";
                                }
                                else
                                {
                                    str2 = "下";
                                }
                                PaikeLinshiBiao paikeLinshi = new PaikeLinshiBiao()
                                {
                                    JS = a.KeYongZiYuanMingChen,
                                    BJ = item.BanJiMingChen,
                                    KC = "自习",
                                    JY = "0",
                                    RQ = StartTime.AddDays(i),
                                    SD = str2
                                };
                                PaiKeBLL.Add(paikeLinshi);
                            }
                        }
                    }
                }
                ShangKeBiaoBLL.TruncateZhangZaiShangKeBiao();
                //排课集合
                var List = PaiKeBLL.GetAllData().OrderBy(p => p.RQ).Where(p => p.KC == "自习").ToList();
                //添加到一次课表
                foreach (var item in List)
                {
                    string         TeacherName = "";
                    int            TeacherID   = 0;
                    YuanGongBiao   Teacher;
                    JiaoXueKeCheng KC;
                    string         KCName;
                    int            KCID;
                    string         ZJName = "";
                    int            ZJID;
                    if (item.JY == "未安排")
                    {
                        TeacherName = "未安排";
                    }
                    else
                    {
                        Teacher     = yuan.GetAllData().Where(p => p.ID == Convert.ToInt32(item.JY)).First();
                        TeacherName = Teacher.JiaoYuanMingChen;
                        TeacherID   = Teacher.ID;
                    }
                    if (item.KC == "自习")
                    {
                        KCName = "自习";
                        KCID   = 0;
                        ZJName = "无";
                        ZJID   = 0;
                    }
                    else
                    {
                        var ZJ = KeChengJiHuaBiaoBLL.GetAllData().Where(p => p.BanJiMing == item.BJ && p.ZhangJieMingChen == item.KC).First();
                        KC     = JiaoXueKeChengBLL.GetAllData().Where(p => p.ID == ZJ.KeChengMing).First();
                        KCName = KC.KeChengMing;
                        KCID   = KC.ID;
                        ZJName = ZJ.ZhangJieMingChen;
                        ZJID   = (int)ZJ.ZhangJieBianHao;
                    }
                    //获取课程名
                    var    ZY     = ZiYuanGuanLiBLL.GetAllData().Where(p => p.ZiYuanMing == item.JS).First();
                    string SJMing = "";
                    if (item.SD == "上")
                    {
                        SJMing = "8:00-12:20";
                    }
                    else
                    {
                        SJMing = "13:30 - 17:30";
                    }
                    YiCiPaiKeDeKeBiaoXinXiBiao yiCiPaiKeDeKeBiaoXinXi = new YiCiPaiKeDeKeBiaoXinXiBiao
                    {
                        CanJiaRenYuan    = TeacherName,
                        BeiZhu           = Jih.JiHuaMingChen,
                        RiQi             = item.RQ,
                        ShiJianDuan      = item.SD,
                        ShiJianMing      = SJMing,
                        ZhuangTai        = "待上课",
                        JiaoYuanBianHao  = TeacherID.ToString(),
                        JiaoYuanMingChen = TeacherName,
                        ShiShiShiJian    = item.RQ.ToString(),
                        ZhangJieBianHao  = ZJID.ToString(),
                        ZhangJieMingChen = ZJName,
                        KeChengBianHao   = KCID.ToString(),
                        KeChengMingChen  = KCName,
                        ZiYuanBianHao    = ZY.ID.ToString(),
                        ZiYuanMingChen   = item.JS,
                        ClassName        = item.BJ,
                    };
                    bLL.Add(yiCiPaiKeDeKeBiaoXinXi);
                }
            }
            catch (Exception ex)
            {
                return(Json(new { errorInfo = "没有可安排排课的资源" + ex + "", errorNo = "0", }, JsonRequestBehavior.AllowGet));
            }
            ShangKeBiaoBLL.Add();
            return(Json(new { errorInfo = "设置本次自习课完成", errorNo = "0", }, JsonRequestBehavior.AllowGet));
        }
Exemple #2
0
        public ActionResult PaiKe(int ID)
        {
            //根据ID获取教务选择的排课方案
            var one = PaiKeFangAn.GetAllData().Where(p => p.ID == ID).First();

            //排课时段与资源集合
            List <PaiKeShiDuanYuZiYuanZuHe> shiDuanBiaos = PaiKeShiDuanYuZiYuan.GetAllData();

            //本次班级排课班级及次数集合
            List <BenCiPaiKeBanJiJiCiShu> Class = PaiKeBanJiJiCiShuBLL.GetAllData();

            //本次排课默认课次表
            List <BeCiPaiKeMorenKeCiBioa> KeCiList = KeCi.GetAllData();

            var ZYuan = keYongZiYuanBLL.GetAllData();

            var ZYuanCount = keYongZiYuanBLL.GetAllData().Count();
            //可排三个班的教室
            var three = KeCiList.Where(p => p.ClassCount == 3).ToList();

            //可排两个班的教室
            var two = KeCiList.Where(p => p.ClassCount == 2).ToList();

            //可排一个班的教室
            var one2 = KeCiList.Where(p => p.ClassCount == 1).ToList();

            List <Hi> o = bLL.banJiKaiSheKeChengJiHuaBiaos();

            //获取排课资源的次数

            //删除零时表数据
            PaiKeBLL.DeleteTable();
            bLL.DeleteTable();

            //形态
            Dictionary <string, List <List <string> > > dicFA = new Dictionary <string, List <List <string> > >
            {
                //3个班排课方式只有一种
                {
                    "3-1",
                    new List <List <string> >()
                    {
                        new List <string> {
                            "1-上", "3-上", "4-上", "6-上"
                        },                                                              //第1个班
                        new List <string> {
                            "1-下", "2-下", "4-下", "5-下"
                        },                                                               //第2个班
                        new List <string> {
                            "2-上", "3-下", "5-上", "6-下"
                        }                                                                 //第3个班
                    }
                },
                //2个班排课方式列出几种
                {
                    "2-1",
                    new List <List <string> >()
                    {
                        new List <string> {
                            "1-上", "3-上", "4-上", "6-上"
                        },                                                               //第1个班
                        new List <string> {
                            "1-下", "3-下", "4-下", "6-下"
                        }                                                               //第2个班
                    }
                },

                {
                    "2-2",
                    new List <List <string> >()
                    {
                        new List <string> {
                            "1-上", "3-上", "4-上", "6-上"
                        },                                                               //第1个班
                        new List <string> {
                            "1-下", "2-下", "4-下", "5-下"
                        }                                                               //第2个班
                    }
                },
                {
                    "2-3",
                    new List <List <string> >()
                    {
                        new List <string> {
                            "2-上", "3-上", "5-上", "6-上"
                        },                                                               //第1个班
                        new List <string> {
                            "2-下", "3-下", "5-下", "6-下"
                        }                                                               //第2个班
                    }
                },
                //1个班排课方式列出几种
                {
                    "1-1",
                    new List <List <string> >()
                    {
                        new List <string> {
                            "1-上", "3-上", "4-上", "6-上"
                        }                                                               //第1个班
                    }
                },
                {
                    "1-2",
                    new List <List <string> >()
                    {
                        new List <string> {
                            "1-下", "3-下", "4-下", "6-下"
                        }                                                               //第1个班
                    }
                },

                {
                    "1-3",
                    new List <List <string> >()
                    {
                        new List <string> {
                            "1-上", "2-上", "4-上", "5-上"
                        }                                                               //第1个班
                    }
                },

                {
                    "1-4",
                    new List <List <string> >()
                    {
                        new List <string> {
                            "1-下", "2-下", "4-下", "5-下"
                        }                                                               //第1个班
                    }
                },

                {
                    "1-5",
                    new List <List <string> >()
                    {
                        new List <string> {
                            "2-下", "3-下", "5-下", "6-下"
                        }                                                               //第1个班
                    }
                },
                {
                    "1-6",
                    new List <List <string> >()
                    {
                        new List <string> {
                            "2-上", "3-上", "5-上", "6-上"
                        }                                                               //第1个班
                    }
                }
            };

            //上课课表集合
            List <JSPJJY> jsspjjyList = new List <JSPJJY>();
            int           n3_1        = 0;
            int           n2_1        = 0;
            int           n1_1        = 0;
            string        str         = "";

            foreach (var item in o.OrderBy(p => p.AnPaiJiaoYuan))
            {
                if (str != item.AnPaiJiaoYuan + "")
                {
                    //根据安排教员查找出所带班级
                    var tempbjlist = bLL.List(item.AnPaiJiaoYuan);
                    int bjcount    = tempbjlist.Count();//
                    //==========================//
                    if (bjcount == 3)
                    {
                        var aaa = three[n3_1++];//
                        for (int in1 = 0; in1 < tempbjlist.Count(); in1++)
                        {
                            JSPJJY jSPJJY = new JSPJJY
                            {
                                JS      = aaa.ZiYuanMingChen,
                                JY      = item.AnPaiJiaoYuan + "",
                                PBS     = 3 + "",
                                XD      = "3-1",
                                XDIndex = in1 + 1,
                                BJ      = tempbjlist[in1].BanJiMing
                            };
                            jsspjjyList.Add(jSPJJY);
                        }
                    }
                    //=========================//
                    if (bjcount == 2)
                    {
                        var aaa = two[n2_1++];//
                        for (int in1 = 0; in1 < tempbjlist.Count(); in1++)
                        {
                            JSPJJY jSPJJY = new JSPJJY
                            {
                                JS      = aaa.ZiYuanMingChen,
                                JY      = item.AnPaiJiaoYuan + "",
                                PBS     = 2 + "",
                                XD      = "2-1",
                                XDIndex = in1 + 1,
                                BJ      = tempbjlist[in1].BanJiMing
                            };
                            jsspjjyList.Add(jSPJJY);
                        }
                    }
                    //==================//
                    if (bjcount == 1)
                    {
                        var aaa = one2[n1_1++];//

                        //
                        for (int in1 = 0; in1 < tempbjlist.Count(); in1++)
                        {
                            JSPJJY jSPJJY = new JSPJJY
                            {
                                JS      = aaa.ZiYuanMingChen,
                                JY      = item.AnPaiJiaoYuan + "",
                                PBS     = 1 + "",
                                XD      = "1-1",
                                XDIndex = in1 + 1,
                                BJ      = tempbjlist[in1].BanJiMing
                            };
                            //
                            jsspjjyList.Add(jSPJJY);
                        }
                    }
                    str = item.AnPaiJiaoYuan + "";//
                }
            }
            ////////////////////////
            //开始排课时间
            var Jih = jiHuaBLL.GetAllData().Where(p => p.ShiFouWanCheng == false).OrderByDescending(p => p.ID).First();

            DateTime StartTime = (DateTime)Jih.KaiShiShiJian;

            DateTime EndTime = (DateTime)Jih.JieShuShiJian;

            TimeSpan time = EndTime - StartTime;
            //课表集合
            List <KB> kBs = new List <KB>();

            //安排上课教室
            foreach (var item in jsspjjyList)
            {
                var           obj = item;
                List <string> SD  = dicFA[item.XD][item.XDIndex - 1];
                int           i   = 0;
                foreach (var item2 in SD)
                {
                    string[] s = item2.Split(new char[] { '-' });

                    int    aday  = Convert.ToInt32(s[0]); //开始时间+天数,为排课日期
                    string strsd = s[1];                  //时段
                    i++;
                    if (StartTime.AddDays(aday - 1) <= EndTime)
                    {
                        var ClassKC = KeChengJiHuaBiaoBLL.GetAllData().Where(p => p.BanJiMing == item.BJ && p.ShiFouYiWanCheng == false).Take(4).ToList();
                        KB  kB      = new KB()
                        {
                            BJ = item.BJ,
                            RQ = StartTime.AddDays(aday - 1),
                            SD = strsd,
                            JS = item.JS,
                            KC = ClassKC[i - 1].ZhangJieMingChen,
                            JY = item.JY
                        };
                        PaikeLinshiBiao paikeLinshiBiao = new PaikeLinshiBiao
                        {
                            BJ = kB.BJ,
                            RQ = kB.RQ,
                            SD = kB.SD,
                            JS = kB.JS,
                            KC = kB.KC,
                            JY = kB.JY
                        };
                        PaiKeBLL.Add(paikeLinshiBiao);
                        kBs.Add(kB);
                    }
                    //设置自习课:实习方式,查询出没有进行排课的教室,设置为自习,并且不能出现时间冲突
                }
            }

            //#region 无用
            ////已安排上课的班级
            //var ClassList = PaiKeBLL.GetAllData();

            ////本次排课的班级
            //var ClassList2 = Class.ToList().Distinct();

            //foreach (var item in ClassList2)
            //{

            //    for (int i = 0; i < time.Days; i++)
            //    {
            //        //查询当天的上午是否排课
            //        var Count = ClassList.Where(p => p.BJ == item.BanJiMingChen && p.RQ == StartTime.AddDays(i) && p.SD == "上").Count();
            //        var WeiAnPaiList = PaiKeBLL.List(StartTime.AddDays(i));
            //        if (Count == 0)
            //        {
            //            var a = PaiKeBLL.List(StartTime.AddDays(i), "上").First(); ;
            //            PaikeLinshiBiao paikeLinshi = new PaikeLinshiBiao()
            //            {
            //                JS = a.KeYongZiYuanMingChen,
            //                BJ = item.BanJiMingChen,
            //                KC = "自习",
            //                JY = "未安排",
            //                RQ = StartTime.AddDays(i),
            //                SD = "上"
            //            };
            //            PaiKeBLL.Add(paikeLinshi);
            //        }

            //        //查询当天的下午是否排课
            //        var XW = ClassList.Where(p => p.BJ == item.BanJiMingChen && p.RQ == StartTime.AddDays(i) && p.SD == "下").Count();
            //        if (XW == 0)
            //        {
            //            var a = PaiKeBLL.List(StartTime.AddDays(i), "下").First(); ;
            //            PaikeLinshiBiao paikeLinshi = new PaikeLinshiBiao()
            //            {
            //                JS = a.KeYongZiYuanMingChen,
            //                BJ = item.BanJiMingChen,
            //                KC = "自习",
            //                JY = "未安排",
            //                RQ = StartTime.AddDays(i),
            //                SD = "下"
            //            };
            //            PaiKeBLL.Add(paikeLinshi);
            //        }
            //        //查询当天是否排课
            //        var SD = PaiKeBLL.GetAllData().Where(p => p.BJ == item.BanJiMingChen && p.RQ == StartTime.AddDays(i)).Count();
            //        if (SD == 0)
            //        {
            //            var a = PaiKeBLL.List(StartTime.AddDays(i)).First();
            //            for (int Hi = 0; Hi < 2; Hi++)
            //            {
            //                string str2 = "";
            //                if (i == 1)
            //                {
            //                    str2 = "上";
            //                }
            //                else
            //                {
            //                    str2 = "下";
            //                }
            //                PaikeLinshiBiao paikeLinshi = new PaikeLinshiBiao()
            //                {
            //                    JS = a.KeYongZiYuanMingChen,
            //                    BJ = item.BanJiMingChen,
            //                    KC = "自习",
            //                    JY = "0",
            //                    RQ = StartTime.AddDays(i),
            //                    SD = str2
            //                };
            //                PaiKeBLL.Add(paikeLinshi);
            //            }
            //        }
            //    }
            //}
            //#endregion

            //排课集合
            var List = PaiKeBLL.GetAllData().OrderBy(p => p.RQ).ToList();

            //添加到一次课表
            foreach (var item in List)
            {
                string         TeacherName = "";
                int            TeacherID   = 0;
                YuanGongBiao   Teacher;
                JiaoXueKeCheng KC;
                string         KCName;
                int            KCID;
                string         ZJName = "";
                int            ZJID;
                Teacher     = yuan.GetAllData().Where(p => p.ID == Convert.ToInt32(item.JY)).First();
                TeacherName = Teacher.JiaoYuanMingChen;
                TeacherID   = Teacher.ID;
                var ZJ = KeChengJiHuaBiaoBLL.GetAllData().Where(p => p.BanJiMing == item.BJ && p.ZhangJieMingChen == item.KC).First();
                KC     = JiaoXueKeChengBLL.GetAllData().Where(p => p.ID == ZJ.KeChengMing).First();
                KCName = KC.KeChengMing;
                KCID   = KC.ID;
                ZJName = ZJ.ZhangJieMingChen;
                ZJID   = (int)ZJ.ZhangJieBianHao;
                //if (item.JY == "未安排")
                //{
                //    TeacherName = "未安排";
                //}
                //else
                //{

                //}
                //if (item.KC == "自习")
                //{
                //    KCName = "自习";
                //    KCID = 0;
                //    ZJName = "无";
                //    ZJID = 0;
                //}
                //else
                //{

                //}
                //获取课程名

                var    ZY     = ZiYuanGuanLiBLL.GetAllData().Where(p => p.ZiYuanMing == item.JS).First();
                string SJMing = "";
                if (item.SD == "上")
                {
                    SJMing = "8:00-12:20";
                }
                else
                {
                    SJMing = "13:30 - 17:30";
                }
                YiCiPaiKeDeKeBiaoXinXiBiao yiCiPaiKeDeKeBiaoXinXi = new YiCiPaiKeDeKeBiaoXinXiBiao
                {
                    CanJiaRenYuan    = TeacherName,
                    BeiZhu           = Jih.JiHuaMingChen,
                    RiQi             = item.RQ,
                    ShiJianDuan      = item.SD,
                    ShiJianMing      = SJMing,
                    ZhuangTai        = "待上课",
                    JiaoYuanBianHao  = TeacherID.ToString(),
                    JiaoYuanMingChen = TeacherName,
                    ShiShiShiJian    = item.RQ.ToString(),
                    ZhangJieBianHao  = ZJID.ToString(),
                    ZhangJieMingChen = ZJName,
                    KeChengBianHao   = KCID.ToString(),
                    KeChengMingChen  = KCName,
                    ZiYuanBianHao    = ZY.ID.ToString(),
                    ZiYuanMingChen   = item.JS,
                    ClassName        = item.BJ,
                };
                bLL.Add(yiCiPaiKeDeKeBiaoXinXi);
            }

            return(Json(new { errorInfo = "设置上课课表完成", errorNo = "0" }, JsonRequestBehavior.AllowGet));
        }