public FullLifeModel GetFullLife(int id, FullLifeIndex pageIndex)
{
var res = new FullLifeModel
{
Details = Gettongs_entity(id)
};
var ToolManagedbContext = new ToolManageDbContext();
var AuditdbContext = new AuditDbContext();
IQueryable <InTable> InTables = ToolManagedbContext.InTables;
IQueryable <OutTable> OutTables = ToolManagedbContext.OutTables;
IQueryable <Warehouse> WarehouseTables = AuditdbContext.Warehouses;
IQueryable <Scrap> ScrapTables = AuditdbContext.Scraps;
IQueryable <RepairTable> RepairTables = ToolManagedbContext.RepairTables;
InTables = InTables.Where(u => u.Code.Contains(res.Details.Code));
InTables = InTables.Where(u => u.SeqID == res.Details.SeqID);
OutTables = OutTables.Where(u => u.Code.Contains(res.Details.Code));
OutTables = OutTables.Where(u => u.SeqID == res.Details.SeqID);
WarehouseTables = WarehouseTables.Where(u => u.Code.Contains(res.Details.Code));
WarehouseTables = WarehouseTables.Where(u => u.SeqID == res.Details.SeqID);
ScrapTables = ScrapTables.Where(u => u.Code.Contains(res.Details.Code));
ScrapTables = ScrapTables.Where(u => u.SeqID == res.Details.SeqID);
RepairTables = RepairTables.Where(u => u.Code.Contains(res.Details.Code));
RepairTables = RepairTables.Where(u => u.SeqID == res.Details.SeqID);
res.InDetails = InTables.OrderByDescending(u => u.ID).ToPagedList(pageIndex.pageIndex1, 12);
res.OutDetails = OutTables.OrderByDescending(u => u.ID).ToPagedList(pageIndex.pageIndex2, 12);
res.WarehouseDetails = WarehouseTables.OrderByDescending(u => u.ID).ToPagedList(pageIndex.pageIndex3, 12);
res.ScrapDetails = ScrapTables.OrderByDescending(u => u.ID).ToPagedList(pageIndex.pageIndex4, 12);
res.RepairDetails = RepairTables.OrderByDescending(u => u.ID).ToPagedList(pageIndex.pageIndex5, 12);
return(res);
}
public ActionResult Scrap(int id, int pageIndex = 1)
{
var page = new FullLifeIndex();
page.pageIndex4 = pageIndex;
var model = this.ToolManageService.GetFullLife(id, page);
return(View(model));
}
public ActionResult Index_old(int id, FullLifeIndex pageIndex)
{
var model = this.ToolManageService.GetFullLife(id, pageIndex);
return(View(model));
}
