public ActionResult GetMaxItemNo(string materialCode) { using (MaterialBOMServiceClient client = new MaterialBOMServiceClient()) { PagingConfig cfg = new PagingConfig() { PageNo = 0, PageSize = 1, Where = string.Format("Key.MaterialCode='{0}'", materialCode), OrderBy = "Key.ItemNo Desc" }; MethodReturnResult <IList <MaterialBOM> > result = client.Get(ref cfg); if (result.Code <= 0 && result.Data != null && result.Data.Count > 0) { return(Json(result.Data[0].Key.ItemNo + 1, JsonRequestBehavior.AllowGet)); } } return(Json(1, JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> Query(MaterialBOMQueryViewModel model) { if (ModelState.IsValid) { using (MaterialBOMServiceClient client = new MaterialBOMServiceClient()) { await Task.Run(() => { StringBuilder where = new StringBuilder(); if (model != null) { where.AppendFormat(" {0} Key.MaterialCode = '{1}'" , where.Length > 0 ? "AND" : string.Empty , model.MaterialCode); if (!string.IsNullOrEmpty(model.RawMaterialCode)) { where.AppendFormat(" {0} RawMaterialCode LIKE '{1}%'" , where.Length > 0 ? "AND" : string.Empty , model.RawMaterialCode); } } PagingConfig cfg = new PagingConfig() { OrderBy = "Key.ItemNo", Where = where.ToString() }; MethodReturnResult <IList <MaterialBOM> > result = client.Get(ref cfg); if (result.Code == 0) { ViewBag.PagingConfig = cfg; ViewBag.List = result.Data; } }); } } return(PartialView("_ListPartial")); }
// // GET: /FMM/MaterialBOM/ public async Task <ActionResult> Index(string materialCode) { using (MaterialServiceClient client = new MaterialServiceClient()) { MethodReturnResult <Material> result = await client.GetAsync(materialCode ?? string.Empty); if (result.Code > 0 || result.Data == null) { return(RedirectToAction("Index", "Material")); } ViewBag.Material = result.Data; } using (MaterialBOMServiceClient client = new MaterialBOMServiceClient()) { await Task.Run(() => { PagingConfig cfg = new PagingConfig() { Where = string.Format(" Key.MaterialCode = '{0}'" , materialCode), OrderBy = "Key.ItemNo" }; MethodReturnResult <IList <MaterialBOM> > result = client.Get(ref cfg); if (result.Code == 0) { ViewBag.PagingConfig = cfg; ViewBag.List = result.Data; } }); } return(View(new MaterialBOMQueryViewModel() { 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 (MaterialBOMServiceClient client = new MaterialBOMServiceClient()) { await Task.Run(() => { PagingConfig cfg = new PagingConfig() { PageNo = pageNo, PageSize = pageSize, Where = where ?? string.Empty, OrderBy = orderBy ?? string.Empty }; MethodReturnResult <IList <MaterialBOM> > result = client.Get(ref cfg); if (result.Code == 0) { ViewBag.PagingConfig = cfg; ViewBag.List = result.Data; } }); } } return(PartialView("_ListPartial")); }