public ActionResult Query(DataAcquisitionDataQueryViewModel model) { MethodReturnResult result = new MethodReturnResult(); DataAcquisitionDataGetParameter p = new DataAcquisitionDataGetParameter(); try { #region 取得数据 DataTable dt = new DataTable(); //采集结果集 PagingConfig cfg = new PagingConfig() { OrderBy = "", Where = "" }; using (DataAcquisitionDataServiceClient client = new DataAcquisitionDataServiceClient()) { //初始化参数 p.StartDate = model.StartDate; //开始日期 p.EndDate = model.EndDate; //结束日期 p.ItemCode = model.ItemCode; //项目代码 p.LocationName = model.LocationName; //车间 p.LineCode = model.LineCode; //线别 p.EquipmentCode = model.EquipmentCode; //设备代码 p.PageSize = model.PageSize; p.PageNo = model.PageNo; MethodReturnResult <DataSet> rst = client.GetData(ref p); if (rst.Code > 0) //产生错误 { result.Code = rst.Code; result.Message = rst.Message; result.Detail = rst.Detail; return(Json(result)); } else { ViewBag.FieldData = rst.Data.Tables[0]; //采集字段数据 cfg.Records = p.Records; //总记录数 //根据报表格式及数据清单组合数据列表 result = CreateTableList(rst, ref dt); if (result.Code > 0) //产生错误 { return(Json(result)); } } } #endregion //回传参数 //创建Where条件 cfg.Where = "?ItemCode=" + model.ItemCode + ";" + "StartDate=" + model.StartDate + ";" + "EndDate=" + model.EndDate + ";" + "LineCode=" + model.LineCode + ";" + "EquipmentCode=" + model.EquipmentCode; ViewBag.PagingConfig = cfg; ViewBag.ListData = dt; if (Request.IsAjaxRequest()) { return(PartialView("_ListPartial", model)); } else { return(View(model)); } } catch (Exception e) { result.Code = 1002; result.Message = e.Message; result.Detail = e.ToString(); } return(Json(result)); }
/// <summary> /// 初始化采集信息主界面 /// </summary> /// <param name="itemCode">项目代码</param> /// <returns></returns> public async Task <ActionResult> Index(string itemCode) { MethodReturnResult result = new MethodReturnResult(); DataAcquisitionDataQueryViewModel model = new DataAcquisitionDataQueryViewModel() { StartDate = System.DateTime.Now.ToString("yyyy-MM-dd 00:00:00"), EndDate = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), EDCTime = System.DateTime.Now, PageSize = 20, PageNo = 1 }; try { //取得项目信息 using (DataAcquisitionItemServiceClient client = new DataAcquisitionItemServiceClient()) { await Task.Run(() => { MethodReturnResult <DataAcquisitionItem> resultItem = client.Get(itemCode); if (result.Code == 0) { ViewBag.DataAcquisitionItem = resultItem.Data; model.RouteOperationName = resultItem.Data.RouteStepName; model.ItemCode = itemCode; } }); } //取得字段列表 using (DataAcquisitionFieldServiceClient client = new DataAcquisitionFieldServiceClient()) { await Task.Run(() => { string where = string.Format("Key.ItemCode = '{0}'", itemCode); PagingConfig cfg = new PagingConfig() { IsPaging = false, OrderBy = "Key.ItemCode,SerialNumber", Where = where }; MethodReturnResult <IList <DataAcquisitionField> > resultField = client.Get(ref cfg); if (resultField.Code == 0) { ViewBag.DataAcquisitionFieldList = resultField.Data; } }); } if (Request.IsAjaxRequest()) { return(PartialView("_ListPartial", model)); } return(View(model)); } catch (Exception e) { result.Code = 1002; result.Message = e.Message; result.Detail = e.ToString(); return(Json(result)); } }