public ActionResult GetRouteNames(string routeEnterpriseName)
{
IList <RouteEnterpriseDetail> lstRouteEnterpriseDetail = new List <RouteEnterpriseDetail>();
using (RouteEnterpriseDetailServiceClient client = new RouteEnterpriseDetailServiceClient())
{
PagingConfig cfg = new PagingConfig()
{
IsPaging = false,
Where = string.Format("Key.RouteEnterpriseName='{0}'", routeEnterpriseName),
OrderBy = "ItemNo"
};
MethodReturnResult <IList <RouteEnterpriseDetail> > result = client.Get(ref cfg);
if (result.Code <= 0 && result.Data != null)
{
lstRouteEnterpriseDetail = result.Data;
}
}
return(Json(from item in lstRouteEnterpriseDetail
select new
{
Text = item.Key.RouteName,
Value = item.Key.RouteName
}, JsonRequestBehavior.AllowGet));
}
public ActionResult GetRouteList(string routeEnterpriseName)
{
using (RouteEnterpriseDetailServiceClient client = new RouteEnterpriseDetailServiceClient())
{
PagingConfig cfg = new PagingConfig()
{
IsPaging = false,
Where = string.Format("Key.RouteEnterpriseName='{0}'", routeEnterpriseName),
OrderBy = "ItemNo"
};
MethodReturnResult <IList <RouteEnterpriseDetail> > result = client.Get(ref cfg);
if (result.Code <= 0)
{
return(Json(result.Data, JsonRequestBehavior.AllowGet));
}
}
return(Json(new List <RouteEnterpriseDetail>(), JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> Query(RouteEnterpriseDetailQueryViewModel model)
{
if (ModelState.IsValid)
{
using (RouteEnterpriseDetailServiceClient client = new RouteEnterpriseDetailServiceClient())
{
await Task.Run(() =>
{
StringBuilder where = new StringBuilder();
if (model != null)
{
where.AppendFormat(" {0} Key.RouteEnterpriseName = '{1}'"
, where.Length > 0 ? "AND" : string.Empty
, model.RouteEnterpriseName);
if (!string.IsNullOrEmpty(model.RouteName))
{
where.AppendFormat(" {0} Key.RouteName LIKE '{1}%'"
, where.Length > 0 ? "AND" : string.Empty
, model.RouteName);
}
}
PagingConfig cfg = new PagingConfig()
{
OrderBy = "ItemNo",
Where = where.ToString()
};
MethodReturnResult <IList <RouteEnterpriseDetail> > result = client.Get(ref cfg);
if (result.Code == 0)
{
ViewBag.PagingConfig = cfg;
ViewBag.List = result.Data;
}
});
}
}
return(PartialView("_ListPartial", new RouteEnterpriseDetailViewModel()));
}
//
// GET: /FMM/RouteEnterpriseDetail/
public async Task <ActionResult> Index(string routeEnterpriseName)
{
using (RouteEnterpriseServiceClient client = new RouteEnterpriseServiceClient())
{
MethodReturnResult <RouteEnterprise> result = await client.GetAsync(routeEnterpriseName ?? string.Empty);
if (result.Code > 0 || result.Data == null)
{
return(RedirectToAction("Index", "RouteEnterprise"));
}
ViewBag.RouteEnterprise = result.Data;
}
using (RouteEnterpriseDetailServiceClient client = new RouteEnterpriseDetailServiceClient())
{
await Task.Run(() =>
{
PagingConfig cfg = new PagingConfig()
{
Where = string.Format(" Key.RouteEnterpriseName = '{0}'"
, routeEnterpriseName),
OrderBy = "ItemNo"
};
MethodReturnResult <IList <RouteEnterpriseDetail> > result = client.Get(ref cfg);
if (result.Code == 0)
{
ViewBag.PagingConfig = cfg;
ViewBag.List = result.Data;
}
});
}
return(View(new RouteEnterpriseDetailQueryViewModel()
{
RouteEnterpriseName = routeEnterpriseName
}));
}
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 (RouteEnterpriseDetailServiceClient client = new RouteEnterpriseDetailServiceClient())
{
await Task.Run(() =>
{
PagingConfig cfg = new PagingConfig()
{
PageNo = pageNo,
PageSize = pageSize,
Where = where ?? string.Empty,
OrderBy = orderBy ?? string.Empty
};
MethodReturnResult <IList <RouteEnterpriseDetail> > result = client.Get(ref cfg);
if (result.Code == 0)
{
ViewBag.PagingConfig = cfg;
ViewBag.List = result.Data;
}
});
}
}
return(PartialView("_ListPartial"));
}
