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