/// <summary> /// 初始化采集信息主界面 /// </summary> /// <param name="eDCTime">采集时间</param> /// <param name="itemCode">采集项目</param> /// <param name="lineCode">线别</param> /// <param name="equipmentCode">设备</param> /// <param name="locationName">车间</param> /// <returns></returns> public ActionResult Index(DateTime eDCTime, string itemCode, string lineCode, string equipmentCode, string locationName) { MethodReturnResult result = new MethodReturnResult(); try { DataAcquisitionTransQueryViewModel model = new DataAcquisitionTransQueryViewModel() { EDCTime = eDCTime, ItemCode = itemCode, LineCode = lineCode, EquipmentCode = equipmentCode, LocationName = locationName, PageSize = 20, PageNo = 1 }; //初始化调用数据查询 return(Query(model)); } catch (Exception e) { result.Code = 1002; result.Message = e.Message; result.Detail = e.ToString(); return(Json(result)); } }
/// <summary> /// 取得采集数据信息 /// </summary> /// <param name="eDCTime">采集时间</param> /// <param name="itemCode">项目代码</param> /// <param name="lineCode">线别</param> /// <param name="equipmentCode">设备代码</param> /// <param name="locationName">车间</param> /// <param name="DataAcquisitionTransQueryViewModel">返回模型数据</param> /// <returns></returns> private MethodReturnResult GetDataAcquisitionTrans(DateTime eDCTime, string itemCode, string lineCode, string equipmentCode, string locationName, ref DataAcquisitionTransQueryViewModel model) { MethodReturnResult result = new MethodReturnResult(); try { string where = ""; //取得项目信息 using (DataAcquisitionItemServiceClient client = new DataAcquisitionItemServiceClient()) { MethodReturnResult <DataAcquisitionItem> resultItem = client.Get(itemCode); if (result.Code == 0) { //采集项目 ViewBag.DataAcquisitionItem = resultItem.Data; //返回采集项目工序 model.RouteOperationName = resultItem.Data.RouteStepName; } } //取得字段列表 using (DataAcquisitionFieldServiceClient client = new DataAcquisitionFieldServiceClient()) { 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; } } using (DataAcquisitionTransServiceClient client = new DataAcquisitionTransServiceClient()) { //取得采集数据 where = string.Format("Key.EDCTime = '{0}' AND Key.ItemCode = '{1}' AND Key.LineCode = '{2}' AND Key.EquipmentCode = '{3}' AND Key.LocationName = '{4}'" , eDCTime , itemCode , lineCode , equipmentCode , locationName); PagingConfig cfg = new PagingConfig() { IsPaging = false, Where = where }; MethodReturnResult <IList <DataAcquisitionTrans> > resultdata = client.Get(ref cfg); if (resultdata.Code > 0) { result.Code = resultdata.Code; result.Message = resultdata.Message; result.Detail = resultdata.Detail; return(result); } //model.Creator = resultdata.Data[0].Creator; //创建人 //model.CreateTime = resultdata.Data[0].CreateTime; //创建日期 //model.Auditor = resultdata.Data[0].Auditor; //审核人 //model.AuditTime = resultdata.Data[0].AuditTime; //审核日期 ViewBag.DataAcquisitionTransList = resultdata.Data; } } catch (Exception e) { result.Code = 1002; result.Message = e.Message; result.Detail = e.ToString(); } return(result); }
public ActionResult Query(DataAcquisitionTransQueryViewModel model) { MethodReturnResult result = new MethodReturnResult(); DataAcquisitionTransGetParameter p = new DataAcquisitionTransGetParameter(); try { #region 取得数据 DataTable dt = new DataTable(); //采集结果集 PagingConfig cfg = new PagingConfig() { OrderBy = "", Where = "" }; using (DataAcquisitionTransServiceClient client = new DataAcquisitionTransServiceClient()) { //初始化参数 p.EDCTime = model.EDCTime; //采集时间 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 + ";" + "EDCTime=" + model.EDCTime + ";" + "LocationName=" + model.LocationName + ";" + "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)); }