protected IQueryable<ProductionJob> JobsForLookup(JobLookupModel model) { if (model.IfNotNull(m => m.AnyCriteria) == false) { return Enumerable.Empty<ProductionJob>().AsQueryable(); } var jobQry = from j in PrdnDBContext.ProductionJobs select j; if (model.CustID != null) { jobQry = from j in jobQry where j.CustID == model.CustID select j; } if (!String.IsNullOrWhiteSpace(model.CustLocation)) { jobQry = from j in jobQry where j.CustLocation.StartsWith(model.CustLocation) select j; } if (!String.IsNullOrWhiteSpace(model.OrderNo)) { jobQry = from j in jobQry where j.OrderNo.StartsWith(model.OrderNo) select j; } if (!String.IsNullOrWhiteSpace(model.PurchaseOrder)) { jobQry = from j in jobQry where j.PurchaseOrder.StartsWith(model.PurchaseOrder) select j; } if (!String.IsNullOrWhiteSpace(model.CstRequestID)) { jobQry = from j in jobQry where j.CstRequestID.StartsWith(model.CstRequestID) select j; } if (!String.IsNullOrWhiteSpace(model.DropShipCustID)) { jobQry = from j in jobQry where j.DropShipCustID.StartsWith(model.DropShipCustID) select j; } if (!String.IsNullOrWhiteSpace(model.SerialNo)) { jobQry = from j in jobQry where j.SerialNo.StartsWith(model.SerialNo) select j; } if (!String.IsNullOrWhiteSpace(model.ProdCD)) { jobQry = from j in jobQry where j.ProdCD.StartsWith(model.ProdCD) select j; } if (!String.IsNullOrWhiteSpace(model.PrdnOrderNo)) { jobQry = from j in jobQry where j.Run.PrdnOrderNo.StartsWith(model.PrdnOrderNo) select j; } if (model.PrdnTypeID != null) { jobQry = from j in jobQry where j.Run.PrdnTypeID == model.PrdnTypeID select j; } if (model.FromShipDt != null) { jobQry = from j in jobQry where j.Run.PrdnOrder.ShipDay >= model.FromShipDt select j; } if (model.ThruShipDt != null) { DateTime beforeDt = (DateTime)model.ThruShipDt; beforeDt = beforeDt.Date.AddDays(1); jobQry = from j in jobQry where j.Run.PrdnOrder.ShipDay < beforeDt select j; } if (model.RunSeqNo != null) { jobQry = from j in jobQry where j.RunSeqNo == model.RunSeqNo select j; } if (model.JobID != null) { jobQry = from j in jobQry where j.ID == model.JobID select j; } //if (!String.IsNullOrWhiteSpace(statusStr)) //{ // List<string> stati = PrdnJobStatusViewModel.UpperStatuses(statusStr).ToList(); // jobs = from j in jobs // where stati.Contains(j.StatusStr) // select j; //} var jobs = (from j in jobQry orderby j.Run.PrdnOrderNo, j.Run.PrdnType.SortOrder, j.Run.PrdnType.Code, j.RunSeqNo select j).Take(200); return jobs; }
protected IEnumerable<PrdnJobListViewModel> JobLookupViewList(JobLookupModel model) { var jobs = JobsForLookup(model); /*var viewJobs = from j in jobs select new PrdnJobListViewModel { PrdnOrderNo = j.Run.PrdnOrder.OrderNo, PrdnShipDay = j.Run.PrdnOrder.ShipDay, RunID = j.Run.ID.ToInt(), PrdnTypeCD = j.Run.PrdnType.Code, JobID = j.ID.ToInt(), RunSeqNo = j.RunSeqNo.ToInt(), SerialNo = j.SerialNo, ProdCD = j.ProdCD, ProdDescr = j.Product.Description, Status = j.Status, StatusDt = j.StatusDt, CustCode = j.Customer.Code, CustLocation = j.CustLocation }; */ List<PrdnJobListViewModel> viewJobs = Mapper.Map<List<ProductionJob>, List<PrdnJobListViewModel>>(jobs.ToList()); return viewJobs; }
public ActionResult FindJob() { JobLookupModel model = new JobLookupModel(); var types = from t in PrdnDBContext.ProductionTypes orderby t.SortOrder, t.Code select new { t.ID, Text = t.Code+" - "+t.Description }; model.PrdnTypes = new SelectList(types.ToList(), "ID", "Text"); model.CustList = GetCustomerList(); return View(model); }
protected GridModel JobGridLookup(JobLookupModel model) { IEnumerable<PrdnJobListViewModel> l = JobLookupViewList(model); return new GridModel(l); }
public ActionResult _JobLookup(JobLookupModel model) { return View(JobGridLookup(model)); }