public JsonResult GetSelParamIds(int layoutId) { var retData = new VM_Result_Data(); try { var layout = bllLayout.GetModel(layoutId); var bllParamCode_Sensor = new MesWeb.BLL.T_SensorModule_T_ParameterCode(); var bllSensor = new MesWeb.BLL.T_SensorModule(); var sensor = bllSensor.GetModel((int)layout.TableRowID); var paramCode_SensorList = bllParamCode_Sensor.GetModelList("SensorModuleID = " + sensor.SensorModuleID); var paramCodeIds = new List <int?>(); foreach (var item in paramCode_SensorList) { paramCodeIds.Add(item.ParameterCodeID); } if (paramCodeIds.Count > 0) { retData.Code = RESULT_CODE.OK; retData.Appendix = paramCodeIds; } } catch (Exception e) { log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name); log.Error("获取模块参数失败!", e); retData.Content = "获取模块参数失败!"; } return(Json(retData)); }
public string GetSensorDataAction(int Id) { var sensorLayout = bllLayout.GetModel(Id); var retData = new VM_Result_Data(); List <VM_Fusioncharts_Line> vmChartList = new List <VM_Fusioncharts_Line>(); try { var machineLayout = GetParentLayout(Id); if (sensorLayout != null && machineLayout != null) { vmChartList = getSensorLineChartList( (int)sensorLayout.TableRowID, (int)machineLayout.TableRowID); } if (vmChartList.Count > 0) { retData.Code = RESULT_CODE.OK; retData.Content = "加载成功"; retData.Appendix = vmChartList; } else { retData.Content = "加载传感器数据失败!"; log.Error("加载传感器失败"); } } catch (Exception e) { log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name); retData.Content = "系统错误"; log.Error("查找传感器数据失败", e); } return(JsonConvert.SerializeObject(retData)); }
public JsonResult AddProductReportAction(VM_Report_Product product) { var retData = new VM_Result_Data(); retData.Content = "添加成品失败"; var bllPd = new MesWeb.BLL.T_Report_Product(); var bllPdStd = new MesWeb.BLL.T_Report_Product_Standard(); var bllPdActual = new MesWeb.BLL.T_Report_Product_Actual(); try { var stdId = bllPdStd.Add(product.ReportProductStd); var actualId = bllPdActual.Add(product.ReportProductActual); if (stdId > 0 && actualId > 0) { var pd = product.ReportProduct; pd.StandardId = stdId; pd.ActualId = actualId; if (bllPd.Add(pd) > 0) { retData.Code = RESULT_CODE.OK; retData.Content = "添加成品表成功"; } } } catch (Exception e) { log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name); log.Error(e); } return(Json(retData)); }
public string GetExtraSensorData(int Id) { var sensorLayout = bllLayout.GetModel(Id); var retData = new VM_Result_Data(); List <VM_Fusioncharts_Line> vmChartList = new List <VM_Fusioncharts_Line>(); try { if (sensorLayout != null) { if (sensorLayout.LayoutTypeID == (int)LAYOUT_TPYE.EXTRA_SENSOR) { vmChartList = getSensorLineChartList((int)sensorLayout.TableRowID, (int)VIRTUAL_LAYOUT.VIRTUAL_MACHINE); if (vmChartList[0].data.Count > 0) { retData.Code = RESULT_CODE.OK; retData.Content = "加载成功"; retData.Appendix = vmChartList; } else { retData.Content = "加载传感器数据失败!"; log.Error("加载传感器失败"); } } } } catch (Exception e) { log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name); retData.Content = "系统错误"; log.Error("查找传感器数据失败", e); } return(JsonConvert.SerializeObject(retData)); }
public JsonResult CreateProcedureLayoutAction(int Id, MesWeb.Model.T_LayoutPicture layout) { log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name); var retData = new VM_Result_Data(); var findLayout = bllLayout.GetModel(Id); if (layout == null || findLayout == null) { retData.Content = "上传内容为空"; log.Error("上传工序布局图为空或者该工序节点不存在"); return(Json(retData)); } findLayout.PicUrl = layout.PicUrl; var isUpdated = bllLayout.Update(findLayout); if (isUpdated == true) { retData.Code = RESULT_CODE.OK; retData.Content = "上传成功!"; } else { retData.Content = "上传失败!"; log.Error("上传工序图往数据库写入失败"); } return(Json(retData)); }
public JsonResult CreateWorkshopLayoutAction(MesWeb.Model.T_LayoutPicture layout) { log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name); var retData = new VM_Result_Data(); if (layout == null) { retData.Content = "上传内容为空"; log.Error("上传总体布局图为空"); return(Json(retData)); } var topLayout = bllLayout.GetModelList("IsTop = 1").FirstOrDefault(); if (topLayout == null) { layout.IsTop = true; if (bllLayout.Add(layout) > 0) { retData.Code = RESULT_CODE.OK; retData.Content = "上传成功!"; } else { retData.Content = "系统错误!"; log.Error("写入数据库时发生错误"); } } else { retData.Content = "布局图已经存在!"; log.Fatal("总体布局图已经存在,但是还有人上传"); } return(Json(retData)); }
public JsonResult AddUserAction(MesWeb.Model.T_User user) { var retData = new VM_Result_Data(); if (!string.IsNullOrEmpty(user.UserName) && user.EmployeeID.Value > 0) { try { var bllUser = new MesWeb.BLL.T_User(); user.Password = SecurityHelper.encryptPlainPwd("123456"); if (bllUser.Add(user) > 0) { retData.Code = RESULT_CODE.OK; retData.Content = "添加用户成功"; } } catch (Exception e) { log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name); log.Error("添加用户失败!", e); } } else { retData.Content = "名称或绑定员工不能为空"; } return(Json(retData)); }
private VM_Result_Data getEmployeeData(string param) { var retData = new VM_Result_Data(); retData.Content = "查询失败"; var bllEmp = new MesWeb.BLL.T_Employee(); var bllDpt = new MesWeb.BLL.T_Department(); var empList = bllEmp.GetModelList(param); try { if (empList.Count > 0) { var vmEmpList = new List <VM_Search_Employee>(); foreach (var emp in empList) { var vmEmp = new VM_Search_Employee(emp); var dpt = bllDpt.GetModelList("DepartmentID = " + emp.DepartmentID).FirstOrDefault(); if (dpt != null) { vmEmp.DepartmentName = dpt.DepartmentName; } vmEmpList.Add(vmEmp); } retData.Appendix = vmEmpList; retData.Code = RESULT_CODE.OK; retData.Content = "查询成功"; } } catch (Exception) { } return(retData); }
public ActionResult SaveParamSetting(MesWeb.Model.T_ParametersCol paramSet) { var retData = new VM_Result_Data(); var bllParamSet = new MesWeb.BLL.T_ParametersCol(); try { if (paramSet.ParameterCodeID.HasValue) { //数据存在于表中则更新 if (bllParamSet.Exists(paramSet.ParametersColID)) { bllParamSet.Update(paramSet); } else { //数据不存在于表中则添加 bllParamSet.Add(paramSet); } } else { //数据不存在于表中则添加 bllParamSet.Add(paramSet); } retData.Content = "设置参数设定值成功"; retData.Code = RESULT_CODE.OK; } catch (Exception e) { log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name); log.Error("保存参数设定值失败!", e); retData.Content = "保存参数设定值失败"; } return(Json(retData)); }
public JsonResult GetODCPKChartDataAction(int layoutID) { log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name); var retData = new VM_Result_Data(); VM_Fusioncharts_MSLine vmCharts = new VM_Fusioncharts_MSLine(); int machineID = 0; try { machineID = getTableRowID(layoutID); if (machineID == 0) { retData.Content = "机台号出错"; log.Warning("机台号出错"); } else { vmCharts = getMachineCPKMSLineData(machineID, (int)SPEC_PARAM_CODE.OUTTER_OD); } } catch (Exception e) { log.Error("OD的CPK出错", e); retData.Content = "OD值CPK计算出错"; } if (vmCharts.dataset.Count > 0) { retData.Code = RESULT_CODE.OK; retData.Content = "加载OD CPK成功"; retData.Appendix = vmCharts; // retData.Appendix.CPK = cpk; } return(Json(retData)); }
public JsonResult TestSuccItems(VM_Trace_Search_Cond cond) { var retData = new VM_Result_Data(); var items = SearchTraceBrefAction(cond); List <List <MesWeb.Model.T_HisMain> > listArray = null; List <MesWeb.Model.T_HisMain> hisMainListArray = new List <MesWeb.Model.T_HisMain>(); listArray = getSameYearData(cond.StartTime, cond.EndTime, cond.MachineType); filterListMainArrary(hisMainListArray, listArray, cond.AxisNum); List <VM_JSMind> jsMindList = new List <VM_JSMind>(); hisMainListArray.ForEach(h => { VM_JSMind vmJsMind = new VM_JSMind(); genMindStruct(h.Axis_No.Trim(), "root", ref vmJsMind, isRoot: true); jsMindList.Add(vmJsMind); }); var succTimes = 0; jsMindList.ForEach(mind => { if (mind.data.Count >= 4) { succTimes++; } }); retData.Code = RESULT_CODE.OK; retData.Content = succTimes; return(Json(retData)); }
public JsonResult AddMultiRowReportAction(List <List <string> > allData, List <int> index, string type, List <string> remark) { var retData = new VM_Result_Data(); retData.Content = "添加报表失败"; var isAllAdded = true; if (allData != null && index != null) { allData.ForEach(d => { isAllAdded = addReport(d, index, type, remark); }); } else { isAllAdded = false; } if (isAllAdded) { retData.Code = RESULT_CODE.OK; retData.Content = "添加报表成功"; } return(Json(retData)); }
public JsonResult UpdateUserAction(MesWeb.Model.T_User user) { var retData = new VM_Result_Data(); var bllUser = new MesWeb.BLL.T_User(); retData.Content = "更新用户失败"; if (user != null) { var oldUser = bllUser.GetModel(user.UserID); if (oldUser != null) { //如果用户没有输入密码,则使用原来的密码 if (string.IsNullOrEmpty(user.Password)) { user.Password = oldUser.Password; } else { //对用户的密码进行第二次加密 user.Password = SecurityHelper.encryptMD5Pwd(user.Password); } try { if (bllUser.Update(user)) { retData.Code = RESULT_CODE.OK; retData.Content = "更新用户成功"; } } catch (Exception e) { log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name); log.Error("更新用户失败!", e); } } } return(Json(retData)); }
private VM_Report_Plastic getPlasticReportById(int id) { var retData = new VM_Result_Data(); var vmPls = new VM_Report_Plastic(); retData.Content = "搜索塑料表失败"; var bllPls = new MesWeb.BLL.T_Report_Plastic(); var bllHeader = new MesWeb.BLL.T_Report_Header(); var bllFooter = new MesWeb.BLL.T_Report_Footer(); var pls = bllPls.GetModel(id); if (pls == null) { return(null); } var header = bllHeader.GetModel(pls.ReportHeaderId.Value); if (header != null) { try { var footer = bllFooter.GetModel(pls.ReportFooterId.Value); ReportPlasticUpdate(out vmPls, pls, header, footer); } catch (Exception e) { log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name); log.Error(e); } } return(vmPls); }
private VM_Result_Data createSubLayout(int Id, MesWeb.Model.T_LayoutPicture layout) { log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name); var retData = new VM_Result_Data(); var findLayout = bllLayout.GetModel(Id); if (layout == null || findLayout == null) { retData.Content = "上传内容为空"; retData.Appendix = "上传布局局图为空或者该节点不存在"; return(retData); } findLayout.PicUrl = layout.PicUrl; var isUpdated = bllLayout.Update(findLayout); if (isUpdated == true) { retData.Code = RESULT_CODE.OK; retData.Content = "上传成功!"; } else { retData.Content = "上传失败!"; retData.Appendix = "上传布局图往数据库写入失败"; } return(retData); }
public JsonResult SearchPlastictBySpecNumAction(string specNum) { var retData = new VM_Result_Data(); retData.Content = "搜索塑料表失败"; var bllPls = new MesWeb.BLL.T_Report_Plastic(); var bllHeader = new MesWeb.BLL.T_Report_Header(); var bllFooter = new MesWeb.BLL.T_Report_Footer(); var header = bllHeader.GetModelList("SpecNum = '" + specNum + "'").First(); if (header != null) { try { var pls = bllPls.GetModelList("ReportHeaderId = " + header.Id).First(); if (pls != null) { var vmPls = new VM_Report_Plastic(); var footer = bllFooter.GetModel(pls.ReportFooterId.Value); ReportPlasticUpdate(out vmPls, pls, header, footer); retData.Appendix = vmPls; retData.Content = "查询塑料报表成功"; retData.Code = RESULT_CODE.OK; } } catch (Exception e) { log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name); log.Error(e); } } return(Json(retData)); }
public JsonResult DeleteProcOrStoreLayout(int Id) { var retData = new VM_Result_Data(); log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name); bool isDel = false; var layout = bllLayout.GetModel(Id); if (layout != null) { if (layout.LayoutTypeID == (int)LAYOUT_TPYE.WORK_AREA) { isDel = deleteProcLayout(Id); } else if (layout.LayoutTypeID == (int)LAYOUT_TPYE.STORE_AREA) { isDel = deleteStoreLayout(Id); } } else { log.Error("删除数据为空"); retData.Content = "系统错误"; } if (isDel == true) { retData.Code = RESULT_CODE.OK; retData.Content = "删除成功!"; } return(Json(retData)); }
public JsonResult GetParamCodeInfoAction(int Id) { log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name); var retData = new VM_Result_Data(); var bllParamCode = new MesWeb.BLL.T_ParameterCode(); var paramCode = bllParamCode.GetModel(Id); if (paramCode == null) { log.Error("获取参数类型失败,参数ID " + Id); retData.Content = "获取参数类型失败"; return(Json(retData)); } var bllParamUnit = new MesWeb.BLL.T_ParameterUnit(); var paramUnitList = bllParamUnit.DataTableToList(bllParamUnit.GetAllList().Tables[0]); int selId = 0; if (paramCode.ParameterUnitID == null) { paramCode.ParameterUnitID = 1; } selId = (int)paramCode.ParameterUnitID.Value; var vmParamCodeInfo = new VM_ParamCodeInfo() { ParameterBit = paramCode.ParameterBit, ParameterName = paramCode.ParameterName, ParameterType = paramCode.ParameterType, ParameterCode = paramCode.ParameterCode, ParameterUnitID = paramCode.ParameterUnitID, ParameterCodeID = paramCode.ParameterCodeID, Type = paramCode.Type }; var isSel = false; foreach (var unit in paramUnitList) { if (unit.ParameterUnitID == selId) { isSel = true; } else { isSel = false; } vmParamCodeInfo.ParamUnitList.Add(new VM_CscDrop { label = unit.ParameterUnitName, value = unit.ParameterUnitID.ToString(), selected = isSel }); } if (!string.IsNullOrEmpty(vmParamCodeInfo.ParameterName)) { retData.Code = RESULT_CODE.OK; } retData.Appendix = vmParamCodeInfo; return(Json(retData)); }
public string GetServerLog() { var retData = new VM_Result_Data(); var bllServerLog = new MesWeb.BLL.T_ServerLog(); var serLogList = bllServerLog.DataTableToList(bllServerLog.GetAllList().Tables[0]); return(JsonConvert.SerializeObject(serLogList)); }
public JsonResult AddMachineLayoutAction(VM_AddMachineAdmin machineAdmin) { log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name); var retData = new VM_Result_Data(); var machine = machineAdmin.Machine; var machineLayout = machineAdmin.MachineLayout; if (machine.MachineName != null) { try { var bllLayoutType = new MesWeb.BLL.T_LayoutType(); var layoutType = bllLayoutType.GetModelList("TableName = 'T_Machine'").FirstOrDefault(); if (layoutType.LayoutTtypeID > 0) { var bllMachine = new MesWeb.BLL.T_Machine(); var machindID = bllMachine.Add(machine); //若工序有几台图片,则共用 var sameProcMach = bllLayout.GetModelList("ParentLayoutPictureID = " + machineLayout.ParentLayoutPictureID); if (sameProcMach != null) { var containPicMach = (from m in sameProcMach where m.PicUrl != null select m).FirstOrDefault(); if (containPicMach != null) { machineLayout.PicUrl = containPicMach.PicUrl; machineLayout.PicHeight = containPicMach.PicHeight; machineLayout.PicWidth = containPicMach.PicWidth; } } machineLayout.LayoutTypeID = layoutType.LayoutTtypeID; machineLayout.TableRowID = machindID; bllLayout.Add(machineLayout); retData.Code = RESULT_CODE.OK; retData.Content = "添加机台成功!"; } else { log.Error("未找到布局关系 T_Machine "); } } catch (Exception e) { log.Fatal("数据库发生错误!", e); } } else { log.Warning("添加机台名称不能为空"); retData.Content = "添加机台名称不能为空"; } return(Json(retData)); }
public JsonResult DeleteLayoutView(MesWeb.Model.T_LayoutPicture delayoutPic) { var retData = new VM_Result_Data(); if (delayoutPic != null) { var findLayoutPic = bllLayoutPic.GetModel(delayoutPic.LayoutPictureID); } return(Json(retData)); }
public JsonResult GetAllReportAction() { var retData = new VM_Result_Data(); var cerFolder = ConfigurationManager.AppSettings["CertificateFolder"]; var filePath = Path.Combine(Server.MapPath("~" + cerFolder)); retData.Appendix = FindFile(filePath); retData.Code = RESULT_CODE.OK; return(Json(retData)); }
public JsonResult LogoutAction() { var retData = new VM_Result_Data(); //清除session Session[SecurityHelper.isLoginSessionId] = null; retData.Content = "注销成功"; retData.Code = RESULT_CODE.OK; return(Json(retData)); }
public JsonResult GetMenuById(int Id) { var retData = new VM_Result_Data(); var bllMenu = new MesWeb.BLL.T_Menu(); retData.Content = bllMenu.GetModel(Id); if (retData.Content != null) { retData.Code = RESULT_CODE.OK; } return(Json(retData)); }
public JsonResult DeleteSensorLayoutAction(int Id) { log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name); var retData = new VM_Result_Data(); var layout = bllLayout.GetModel(Id); try { if (deleteLayout(layout)) { var bllSensor = new MesWeb.BLL.T_SensorModule(); var bllSensorParamCode = new MesWeb.BLL.T_SensorModule_T_ParameterCode(); var sensorParamCodeList = bllSensorParamCode.GetModelList("SensorModuleID=" + layout.TableRowID); var deleteList = new StringBuilder(); for (int i = 0; i < sensorParamCodeList.Count; i++) { deleteList.Append(sensorParamCodeList[i].SensorModule_PARCODEID.ToString()); if (i != sensorParamCodeList.Count - 1) { deleteList.Append(","); } } if (bllSensorParamCode.DeleteList(deleteList.ToString())) { if (bllSensor.Delete((int)layout.TableRowID)) { retData.Code = RESULT_CODE.OK; retData.Content = "删除成功"; } else { log.Error("删除传感器失败"); retData.Content = "删除传感器失败"; } } else { log.Error("删除关系失败"); retData.Content = "删除传感器失败"; } } else { log.Error("删除传感器布局失败"); retData.Content = "删除失败!"; } } catch (Exception e) { retData.Content = "系统错误"; log.Fatal("系统错误", e); } return(Json(retData)); }
public JsonResult GetHistoryData(string axisNumStr) { log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name); var retData = new VM_Result_Data(); if (HisMain.IsAxisNum(axisNumStr)) { var axisNum = new HisData(axisNumStr); var bllHisData = new MesWeb.BLL.T_HisData(axisNum.TableName); try { var hisDataList = bllHisData.GetModelList("machineID = " + axisNum.MachineId); var sensorDataList = new List <VM_Sensor_Online>(); foreach (var item in ParamCodeDic) { //找出映射的数据 var data = (from s in hisDataList where s.ParameterCodeID == item.Key select s).ToList(); if (data.Count > 0) { //生成传感器的数据结构 var sensorData = new VM_Sensor_Online { ParamCodeId = item.Value }; sensorData.SeriesData = new List <VM_Sensor_Data>(); foreach (var d in data) { try { var seriesData = new VM_Sensor_Data { X = ((DateTime)(d.CollectedTime)).AddHours(8).ToUniversalTime().ToString(), Y = float.Parse(d.CollectedValue) }; sensorData.SeriesData.Add(seriesData); } catch (Exception e) { log.Error(e); continue; } } sensorDataList.Add(sensorData); } } retData.Appendix = sensorDataList; retData.Content = "加载机台历史数据成功"; retData.Code = RESULT_CODE.OK; } catch (Exception e) { log.Error(e); retData.Content = "加载机台历史数据失败"; } } return(Json(retData)); }
public JsonResult AddReportAction(List <string> data, List <int> index, string type) { var retData = new VM_Result_Data(); retData.Content = "添加报表失败"; if (addReport(data, index, type, null)) { retData.Code = RESULT_CODE.OK; retData.Content = "添加报表成功"; } return(Json(retData)); }
public ActionResult SearchReportAction(List <string> cond, string type) { var retData = new VM_Result_Data(); retData.Content = "查询失败"; var bllAllReport = new MesWeb.BLL.T_AllReport(); var condStr = ""; if (cond != null && cond.Count > 0) { cond.ForEach(c => { condStr = condStr + spliter + "%" + c + "%"; }); condStr = condStr.Substring(spliter.Length); } var result = bllAllReport.GetModelList("ReportType = '" + type + "' and IndexValue like '" + condStr + "' "); if (result != null && result.Count > 0) { var repList = new List <VM_GumReportSearchResult>(); var results = new List <SearchReportResult>(); result.ForEach(report => { var value = report.ReportValue.Split(new string[] { spliter }, StringSplitOptions.None).ToList(); var remark = report.Remark.Split(new string[] { spliter }, StringSplitOptions.None).ToList(); var res = new SearchReportResult(); //通用型结果 res.Remark = remark; res.Report = value; res.Id = report.Id; res.InputDate = report.InputDate.HasValue ? report.InputDate.Value.ToString("yyyy-MM-dd") : "--"; results.Add(res); var rep = new VM_GumReportSearchResult(); //翻译字段 rep.BatchNum = value[2]; rep.InputDate = report.InputDate.HasValue ? report.InputDate.Value.ToString("yyyy-MM-dd") : "--"; rep.SpecNum = value[1]; rep.Supplier = value[0]; rep.Detail = "<a reportId='" + report.Id + "' onclick='navToGumDetail(this)'>详细</a>"; repList.Add(rep); }); retData.Content = results; retData.Code = RESULT_CODE.OK; retData.Appendix = repList; } return(Json(retData)); }
/// *********************cniots************************************* /// Author : ychost /// Created : 2016-09-01 20:29:50 /// <summary> /// response the workshop layout view /// </summary> /// <param name="ID">workshop layout picture id</param> /// <returns>the work shop view</returns> /// Last Modified By : ychost /// Last Modified On : 2016-09-03 11:09:33 /// *********************cniots************************************* public ActionResult WorkShopView(int ID) { var retData = new VM_Result_Data(); var workShopViewLayout = bllLayoutPic.GetModel(ID); if (workShopViewLayout != null) { VM_LayoutPicture vmWorkShopView = getVmLayoutView(workShopViewLayout); retData.Appendix = vmWorkShopView; retData.Code = RESULT_CODE.OK; retData.Content = "加载成功!"; } return(View(retData)); }
/// <summary> /// 获取机台传感器数据 /// </summary> /// <param name="dpData">原始所有数据</param> /// <returns></returns> public VM_Result_Data GetSensorData(SensorData data) { //int calcMs = 0; //按参数类型分组 var groupData = (from d in data.CollectedData group d by d.ParameterCodeID into g select g); var sensorOnlines = new List <VM_Sensor_Online>(); foreach (var specGp in groupData) { var sensorOnline = new VM_Sensor_Online(); var paramCodeId = specGp.Key; if (paramCodeId == null) { continue; } //获取参数 ID sensorOnline.ParamCodeId = paramCodeId; sensorOnline.SeriesData = new List <VM_Sensor_Data>(); //获取参数值 foreach (var spec in specGp) { //防止速度过快数据重叠 // calcMs += 5; // Random rand = new Random(); // var randMs = rand.Next(calcMs,calcMs + 4); // var x = ((DateTime)(spec.CollectedTime)).AddMilliseconds(randMs); // //设置精度到毫秒级别 //f表示保留一位小数,即精度为 0.5s = 500ms; //重新生成时间保证时间不重叠 var m = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.ffff"); // var m = x.ToString(); sensorOnline.SeriesData.Add(new VM_Sensor_Data { X = m, Y = float.Parse(spec.CollectedValue) }); sensorOnline.Message = spec.CollectedValue.ToString(); } sensorOnlines.Add(sensorOnline); } var retData = new VM_Result_Data(); if (sensorOnlines.Count > 0) { retData.Appendix = sensorOnlines; retData.Code = RESULT_CODE.OK; retData.Content = "更新实时数据成功"; } return(retData); }