// //GET: /FMM/CalibrationPlateLine/Query public ActionResult Query(string CalibrationPlateID) { using (CalibrationPlateLineServiceClient client = new CalibrationPlateLineServiceClient()) { PagingConfig cfg = new PagingConfig() { IsPaging = false, Where = string.Format("Key.CalibrationPlateID = '{0}'", CalibrationPlateID) }; MethodReturnResult <IList <CalibrationPlateLine> > result = client.Get(ref cfg); if (result.Code == 0) { ViewBag.List = result.Data; ViewBag.CalibrationPlateID = CalibrationPlateID; } } if (Request.IsAjaxRequest()) { return(PartialView("_ListPartial", new CalibrationPlateLineViewModel() { CalibrationPlateID = CalibrationPlateID })); } else { return(View("Index")); } }
public ActionResult Query(CalibrationPlateQueryViewModel model) { string keyList = null; if (model.LineCode != null || model.LocationName != null) { using (CalibrationPlateLineServiceClient client = new CalibrationPlateLineServiceClient()) { PagingConfig cfg = new PagingConfig() { IsPaging = false, Where = GetQueryCondition(model) }; MethodReturnResult <IList <CalibrationPlateLine> > result = client.Get(ref cfg); if (result.Code == 0 && result.Data.Count > 0) { StringBuilder strb = new StringBuilder(); foreach (var item in result.Data) { strb.Append("'" + item.Key.CalibrationPlateID + "',"); } keyList = strb.ToString().Substring(0, strb.Length - 1); } else { return(PartialView("_ListPartial")); } } } if (keyList != null) { using (CalibrationPlateServiceClient client = new CalibrationPlateServiceClient()) { PagingConfig cfg = new PagingConfig() { IsPaging = false, Where = string.Format(" Key in ({0})" , keyList) }; MethodReturnResult <IList <CalibrationPlate> > result = client.Get(ref cfg); if (result.Code == 0) { ViewBag.List = result.Data; } } } else { using (CalibrationPlateServiceClient client = new CalibrationPlateServiceClient()) { PagingConfig cfg = new PagingConfig() { IsPaging = false, OrderBy = "Key" }; MethodReturnResult <IList <CalibrationPlate> > result = client.Get(ref cfg); if (result.Code == 0) { ViewBag.List = result.Data; } } } return(PartialView("_ListPartial")); }