예제 #1
0
        int id_FF = 0; //T_TB_FenFa表的ID
        // GET: TBsys/jiaock
        public ActionResult Index(string searchAC, string searchClass, int pageIndex = 1, int pageSize = 4)
        {
            if (Session["person"] == null || (int)Session["type"] != 4)
            {
                return(Redirect("/TBsys/Login/Index"));
            }

            IEnumerable <myTBsys.Models.T_TB_Fenfa> query = db.T_TB_Fenfa;

            if (String.IsNullOrEmpty(searchAC))
            {
            }
            else
            {
                //query = query.Where(m => m.BookId.Contains(searchstring));
                query = query.Where(m => m.T_SH_Class.T_SH_Major.T_SH_Department.T_SH_Academy.Name.Equals(searchAC));
                if (String.IsNullOrEmpty(searchClass))
                {
                }
                else
                {
                    query = query.Where(m => m.T_SH_Class.Name.Equals(searchClass));
                }
            }

            //分页
            int recordCount = query.Count();//总数量

            query               = query.Skip((pageIndex - 1) * pageSize).Take(pageSize);
            ViewBag.pageIndex   = pageIndex;
            ViewBag.pageSize    = pageSize;
            ViewBag.recordCount = recordCount;
            // ViewBag.searchstring = searchstring;
            ViewBag.searchAC    = searchAC;
            ViewBag.searchClass = searchClass;


            //获取数据列表
            List <myTBsys.Models.T_TB_Fenfa> lst = query.ToList();

            ViewBag.lst = lst;


            var query1 = db.T_TB_TeachingTask;
            var query2 = db.T_TB_TeaYuding;
            var query3 = db.T_TB_StuYuding;
            var query4 = db.T_QT_Other;
            var query5 = db.T_TB_StoreTable;
            var query6 = db.T_TB_Choose;
            var query7 = db.T_TB_Fenfa;
            var query8 = db.T_SH_Academy;
            var query9 = db.T_SH_Class;
            List <myTBsys.Models.T_TB_TeaYuding>  lst2 = query2.ToList();
            List <myTBsys.Models.T_TB_StuYuding>  lst3 = query3.ToList();
            List <myTBsys.Models.T_QT_Other>      lst4 = query4.ToList();
            List <myTBsys.Models.T_TB_StoreTable> lst5 = query5.ToList();
            List <myTBsys.Models.T_TB_Choose>     lst6 = query6.ToList();
            List <myTBsys.Models.T_TB_Fenfa>      lst7 = query7.ToList();
            List <myTBsys.Models.T_SH_Academy>    lst8 = query8.ToList();

            if (lst5.Count == 0)//判断StoreTable表是否已生成
            {
                for (int i = 0; i < lst6.Count; i++)
                {
                    myTBsys.Models.T_TB_StoreTable item = new Models.T_TB_StoreTable();
                    item.Id      = id_ST;
                    id_ST        = id_ST + 1;
                    item.TaskId  = lst6[i].TeachingTaskId;
                    item.BookId  = lst6[i].BookId;
                    item.ClassId = lst6[i].T_TB_TeachingTask.ClassId;
                    item.State   = 2;
                    int num = 0;//书的数量
                    for (int j = 0; j < lst3.Count; j++)
                    {
                        if (lst6[i].T_TB_TeachingTask.ClassId == lst3[j].T_SH_Student.ClassId &&
                            lst6[i].BookId == lst3[j].BookId)
                        {
                            num++;
                        }
                    }
                    item.YudingNum = num;
                    db.T_TB_StoreTable.Add(item);
                    db.SaveChanges();
                }
            }

            if (lst7.Count == 0)//判断分发表是否已生成
            {
                for (int i = 0; i < lst5.Count; i++)
                {
                    myTBsys.Models.T_TB_Fenfa item = new Models.T_TB_Fenfa();
                    //item.Id = id_FF;
                    //id_FF=id_FF+1;
                    item.BookId  = lst5[i].BookId;
                    item.ClassId = (int)lst5[i].ClassId;
                    item.BookNum = lst5[i].YudingNum;
                    item.RealPay = lst5[i].YudingNum * (double)lst5[i].T_TB_Books.Price * (double)lst4[0].Discount;
                    item.State   = 2;
                    item.StuId   = "14211160237";
                    db.T_TB_Fenfa.Add(item);
                    db.SaveChanges();
                }
            }

            ViewBag.lst1 = query1.ToList();
            ViewBag.lst2 = query2.ToList();
            ViewBag.lst3 = query3.ToList();
            ViewBag.lst4 = query4.ToList();
            ViewBag.lst8 = query8.ToList();
            ViewBag.lst9 = query9.ToList();

            return(View());
        }
예제 #2
0
        int id = 0;//T_TB_StoreTable表的ID
        // GET: TBsys/Jiaowc
        public ActionResult Index(string searchstring, int pageIndex = 1, int pageSize = 4)
        {
            if (Session["person"] == null || (int)Session["type"] != 5)
            {
                return(Redirect("/TBsys/Login/Index"));
            }

            IEnumerable <myTBsys.Models.T_TB_Books> queryall = db.T_TB_Books; //总返回全部的数据
            IEnumerable <myTBsys.Models.T_TB_Books> query    = db.T_TB_Books; //可返回删改后的数据

            var query1 = db.T_TB_TeachingTask;
            var query2 = db.T_TB_TeaYuding;
            var query3 = db.T_TB_StuYuding;
            var query4 = db.T_QT_Other;
            var query5 = db.T_TB_StoreTable;
            var query6 = db.T_TB_Choose;
            List <myTBsys.Models.T_TB_TeaYuding>  lst2 = query2.ToList();
            List <myTBsys.Models.T_TB_StuYuding>  lst3 = query3.ToList();
            List <myTBsys.Models.T_TB_StoreTable> lst5 = query5.ToList();
            List <myTBsys.Models.T_TB_Choose>     lst6 = query6.ToList();


            if (String.IsNullOrEmpty(searchstring))
            {
            }
            else
            {
                //query = query.Where(m => m.Name.Contains(searchstring));
                query = query.Where(m => m.Publisher.Equals(searchstring));
            }
            List <myTBsys.Models.T_TB_Books> lst = query.ToList();

            //删除book表中有记录但是在choose表中不存在的课本
            for (int i = 0; i < lst.Count; i++)
            {
                int exist = 0;
                for (int j = 0; j < lst6.Count; j++)
                {
                    if (lst[i].Id == lst6[j].BookId)
                    {
                        exist = 1;
                        break;
                    }
                }
                if (exist == 0)
                {
                    lst.Remove(lst[i]);
                    i = i - 1;
                }
            }
            int recordCount = lst.Count;

            //分页
            //int recordCount = query.Count();//总数量
            //query = query.Skip((pageIndex - 1) * pageSize).Take(pageSize);
            ViewBag.pageIndex    = pageIndex;
            ViewBag.pageSize     = pageSize;
            ViewBag.recordCount  = recordCount;
            ViewBag.searchstring = searchstring;

            //返回给select处理显示
            List <myTBsys.Models.T_TB_Books> lstall = queryall.ToList();

            ViewBag.lstall = lstall;
            //获取数据列表
            //List<myTBsys.Models.T_TB_Books> lst = query.ToList();
            ViewBag.lst = lst;



            if (lst5.Count == 0)//判断表是否已生成
            {
                for (int i = 0; i < lst6.Count; i++)
                {
                    myTBsys.Models.T_TB_StoreTable item = new Models.T_TB_StoreTable();
                    item.Id      = id;
                    id           = id + 1;
                    item.TaskId  = lst6[i].TeachingTaskId;
                    item.BookId  = lst6[i].BookId;
                    item.ClassId = lst6[i].T_TB_TeachingTask.ClassId;
                    item.State   = 2;
                    int num = 0;//书的数量
                    for (int j = 0; j < lst3.Count; j++)
                    {
                        if (lst6[i].T_TB_TeachingTask.ClassId == lst3[j].T_SH_Student.ClassId &&
                            lst6[i].BookId == lst3[j].BookId)
                        {
                            num++;
                        }
                    }
                    item.YudingNum = num;
                    db.T_TB_StoreTable.Add(item);
                    db.SaveChanges();
                }
            }
            ViewBag.lst1 = query1.ToList();
            ViewBag.lst2 = query2.ToList();
            ViewBag.lst3 = query3.ToList();
            ViewBag.lst4 = query4.ToList();
            ViewBag.lst5 = query5.ToList();
            ViewBag.lst6 = query6.ToList();

            return(View());
        }