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());
}
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());
}