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);
}
