public async Task <ActionResult> Query(WorkOrderDecayQueryViewModel model) { if (ModelState.IsValid) { using (WorkOrderDecayServiceClient client = new WorkOrderDecayServiceClient()) { await Task.Run(() => { StringBuilder where = new StringBuilder(); if (model != null) { where.AppendFormat(" Key.OrderNumber = '{0}' AND Key.MaterialCode='{1}'" , model.OrderNumber , model.MaterialCode); } PagingConfig cfg = new PagingConfig() { OrderBy = "Key", Where = where.ToString() }; MethodReturnResult <IList <WorkOrderDecay> > result = client.Get(ref cfg); if (result.Code == 0) { ViewBag.PagingConfig = cfg; ViewBag.List = result.Data; } }); } } return(PartialView("_ListPartial")); }
// // GET: /ZPVM/WorkOrderDecay/ public async Task <ActionResult> Index(string OrderNumber, string MaterialCode) { if (string.IsNullOrEmpty(OrderNumber) || string.IsNullOrEmpty(MaterialCode)) { return(RedirectToAction("Index", "WorkOrderRule")); } using (WorkOrderRuleServiceClient client = new WorkOrderRuleServiceClient()) { MethodReturnResult <WorkOrderRule> result = await client.GetAsync(new WorkOrderRuleKey() { OrderNumber = OrderNumber, MaterialCode = MaterialCode }); if (result.Code > 0 || result.Data == null) { return(RedirectToAction("Index", "WorkOrderRule")); } ViewBag.Rule = result.Data; } using (WorkOrderDecayServiceClient client = new WorkOrderDecayServiceClient()) { await Task.Run(() => { PagingConfig cfg = new PagingConfig() { Where = string.Format(" Key.OrderNumber = '{0}' AND Key.MaterialCode='{1}'" , OrderNumber , MaterialCode), OrderBy = "Key" }; MethodReturnResult <IList <WorkOrderDecay> > result = client.Get(ref cfg); if (result.Code == 0) { ViewBag.PagingConfig = cfg; ViewBag.List = result.Data; } }); } return(View(new WorkOrderDecayQueryViewModel() { OrderNumber = OrderNumber, MaterialCode = MaterialCode })); }
public async Task <ActionResult> PagingQuery(string where, string orderBy, int?currentPageNo, int?currentPageSize) { if (ModelState.IsValid) { int pageNo = currentPageNo ?? 0; int pageSize = currentPageSize ?? 20; if (Request["PageNo"] != null) { pageNo = Convert.ToInt32(Request["PageNo"]); } if (Request["PageSize"] != null) { pageSize = Convert.ToInt32(Request["PageSize"]); } using (WorkOrderDecayServiceClient client = new WorkOrderDecayServiceClient()) { await Task.Run(() => { PagingConfig cfg = new PagingConfig() { PageNo = pageNo, PageSize = pageSize, Where = where ?? string.Empty, OrderBy = orderBy ?? string.Empty }; MethodReturnResult <IList <WorkOrderDecay> > result = client.Get(ref cfg); if (result.Code == 0) { ViewBag.PagingConfig = cfg; ViewBag.List = result.Data; } }); } } return(PartialView("_ListPartial")); }