public async Task <ActionResult> Query(RouteEnterpriseQueryViewModel model) { if (ModelState.IsValid) { using (RouteEnterpriseServiceClient client = new RouteEnterpriseServiceClient()) { await Task.Run(() => { StringBuilder where = new StringBuilder(); if (model != null) { if (!string.IsNullOrEmpty(model.Name)) { where.AppendFormat(" {0} Key LIKE '{1}%'" , where.Length > 0 ? "AND" : string.Empty , model.Name); } } PagingConfig cfg = new PagingConfig() { OrderBy = "Key", Where = where.ToString() }; MethodReturnResult <IList <RouteEnterprise> > result = client.Get(ref cfg); if (result.Code == 0) { ViewBag.PagingConfig = cfg; ViewBag.List = result.Data; } }); } } return(PartialView("_ListPartial")); }
// // GET: /FMM/RouteEnterprise/ public async Task <ActionResult> Index() { using (RouteEnterpriseServiceClient client = new RouteEnterpriseServiceClient()) { await Task.Run(() => { PagingConfig cfg = new PagingConfig() { OrderBy = "Key" }; MethodReturnResult <IList <RouteEnterprise> > result = client.Get(ref cfg); if (result.Code == 0) { ViewBag.PagingConfig = cfg; ViewBag.List = result.Data; } }); } return(View(new RouteEnterpriseQueryViewModel())); }
public IEnumerable <SelectListItem> GetRouteEnterpriseNameList() { using (RouteEnterpriseServiceClient client = new RouteEnterpriseServiceClient()) { PagingConfig cfg = new PagingConfig() { IsPaging = false, Where = string.Format("Status='{0}'", Convert.ToInt32(EnumObjectStatus.Available)) }; MethodReturnResult <IList <RouteEnterprise> > result = client.Get(ref cfg); if (result.Code <= 0) { return(from item in result.Data select new SelectListItem() { Text = item.Key, Value = item.Key }); } } return(new List <SelectListItem>()); }
// // GET: /FMM/RouteEnterprise/ public async Task <ActionResult> Index() { using (RouteEnterpriseServiceClient client = new RouteEnterpriseServiceClient()) { await Task.Run(() => { PagingConfig cfg = new PagingConfig() { Where = string.Format(" Status = '{0}'" , EnumObjectStatus.Available.GetHashCode()), OrderBy = "Key" }; MethodReturnResult <IList <RouteEnterprise> > result = client.Get(ref cfg); if (result.Code == 0) { ViewBag.PagingConfig = cfg; ViewBag.List = result.Data; } }); } return(View(new RouteEnterpriseQueryViewModel())); }
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 (RouteEnterpriseServiceClient client = new RouteEnterpriseServiceClient()) { await Task.Run(() => { PagingConfig cfg = new PagingConfig() { PageNo = pageNo, PageSize = pageSize, Where = where ?? string.Empty, OrderBy = orderBy ?? string.Empty }; MethodReturnResult <IList <RouteEnterprise> > result = client.Get(ref cfg); if (result.Code == 0) { ViewBag.PagingConfig = cfg; ViewBag.List = result.Data; } }); } } return(PartialView("_ListPartial")); }