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 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));
}
/// <summary>
/// 初始化模块状态缓存字典
/// </summary>
private void initCurModuelStateDic()
{
var bllMachine = new MesWeb.BLL.T_Machine();
var machList = bllMachine.GetModelList("");
var bllSensor = new MesWeb.BLL.T_SensorModule();
var bllParam = new MesWeb.BLL.T_ParameterCode();
var bllSensor_Param = new MesWeb.BLL.T_SensorModule_T_ParameterCode();
//遍历所有机台
foreach (var machine in machList)
{
var machineId = machine.MachineID;
//为每个机台的所有模块生成一个字典
var moduleDic = new ConcurrentDictionary <string, List <Param> >();
//添加机台
if (curModuleStateDic.TryAdd(machineId, moduleDic))
{
var sensors = bllSensor.GetModelList("MachineID = " + machineId);
//遍历模块
foreach (var sensor in sensors)
{
//初始化每个模块的参数列表
var paramList = new List <Param>();
//添加模块
if (moduleDic.TryAdd(sensor.SerialNum, paramList))
{
var sensor_param = bllSensor_Param.GetModelList("SensorModuleID = " + sensor.SensorModuleID);
//遍历模块对应的参数
foreach (var sp in sensor_param)
{
//获得参数
var param = bllParam.GetModel(sp.ParameterCodeID.Value);
//添加参数
paramList.Add(new Param {
ParamCodeID = param.ParameterCodeID.ToString(),
ParamCode = param.ParameterCode.ToString(),
ParamName = param.ParameterName
});
}
}
}
}
}
}
public JsonResult AddSensorAction(VM_AddSensorAdmin sensorAdmin)
{
log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name);
var retData = new VM_Result_Data();
var sensorModule = sensorAdmin.SensorModule;
var sensorLayout = sensorAdmin.SensorLayout;
if (sensorModule.SerialNum != null && sensorAdmin.ParentLayoutPictureID != null && sensorAdmin.ParameterCodeIDs.Count > 0)
{
try {
var bllMachine = new MesWeb.BLL.T_Machine();
var machineLayout = bllLayout.GetModel((int)sensorLayout.ParentLayoutPictureID);
var bllSensor = new MesWeb.BLL.T_SensorModule();
var bllSensorParamCode = new MesWeb.BLL.T_SensorModule_T_ParameterCode();
sensorModule.MachineID = bllMachine.GetModel((int)machineLayout.TableRowID).MachineID;
sensorLayout.LayoutTypeID = (int)LAYOUT_TPYE.SENSOR_MODULE;
//add sensor
sensorLayout.TableRowID = bllSensor.Add(sensorModule);
//build sensor and parametercode relationship
foreach (var param in sensorAdmin.ParameterCodeIDs)
{
bllSensorParamCode.Add(new MesWeb.Model.T_SensorModule_T_ParameterCode {
SensorModuleID = sensorLayout.TableRowID,
ParameterCodeID = int.Parse(param)
});
}
//add sensor layout
bllLayout.Add(sensorLayout);
retData.Code = RESULT_CODE.OK;
retData.Content = "添加模块成功！";
} catch (Exception e) {
log.Fatal("往数据库写入数据失败", e);
}
}
else
{
log.Warning("字段校验失败");
retData.Content = "字段校验失败";
}
return(Json(retData));
}
protected List <VM_Fusioncharts_Line> getSensorLineChartList(int sensorModuleID, int machineID, int size = -1)
{
List <VM_Fusioncharts_Line> vmChartsList = new List <VM_Fusioncharts_Line>();
var bllSensor = new MesWeb.BLL.T_SensorModule();
var sensor = bllSensor.GetModel(sensorModuleID);
if (sensor != null)
{
var bllSensorParamCode = new MesWeb.BLL.T_SensorModule_T_ParameterCode();
var bllParamCode = new MesWeb.BLL.T_ParameterCode();
var sensorParamCodeList = bllSensorParamCode.GetModelList("SensorModuleID = " + sensor.SensorModuleID);
var codeList = new List <MesWeb.Model.T_ParameterCode>();
foreach (var sensorCode in sensorParamCodeList)
{
var paramCode = bllParamCode.GetModel((int)sensorCode.ParameterCodeID);
codeList.Add(paramCode);
}
vmChartsList = getParamsChartList(machineID, codeList.ToArray());
}
return(vmChartsList);
}
public ActionResult Machine()
{
var bllMachine = new MesWeb.BLL.T_Machine();
var machineList = bllMachine.GetModelList("");
var bllParam = new MesWeb.BLL.T_ParameterCode();
var bllSensor = new MesWeb.BLL.T_SensorModule();
var bllSensor_Param = new MesWeb.BLL.T_SensorModule_T_ParameterCode();
//机台参数树状结构
var vmJSTree = new List <VM_JSTree>();
//遍历机台
foreach (var machine in machineList)
{
var machineTreeId = "mach_" + machine.MachineID.ToString();
var machTree = new VM_JSTree {
text = machine.MachineName, id = machineTreeId
};
var sensorList = bllSensor.GetModelList("MachineID = " + machine.MachineID);
machTree.children = new List <VM_JSTree>();
foreach (var sensor in sensorList)
{
var spList = bllSensor_Param.GetModelList("SensorModuleID = " + sensor.SensorModuleID);
//遍历参数
foreach (var sp in spList)
{
var param = bllParam.GetModel(sp.ParameterCodeID.Value);
machTree.children.Add(
new VM_JSTree {
text = param.ParameterName,
id = machineTreeId + "_param_" + param.ParameterCodeID.ToString()
});
}
}
vmJSTree.Add(machTree);
}
return(View(vmJSTree));
}
public JsonResult GetParamChartProperties(int layoutId)
{
var retData = new VM_Result_Data();
log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name);
var properties = new List <VM_Highcharts_Property>();
var bllParamCode = new MesWeb.BLL.T_ParameterCode();
var bllSensor_ParamCode = new MesWeb.BLL.T_SensorModule_T_ParameterCode();
var bllSensor = new MesWeb.BLL.T_SensorModule();
var bllUnit = new MesWeb.BLL.T_ParameterUnit();
var bllParamCol = new MesWeb.BLL.T_ParametersCol();
try {
var sensroLayout = bllLayout.GetModel(layoutId);
if (sensroLayout.LayoutTypeID != (int)LAYOUT_TPYE.SENSOR_MODULE)
{
retData.Content = "施工有误，请联系管理员";
log.Error("传感器模块参数错误");
return(Json(retData));
}
var machLayout = GetParentLayout(layoutId);
var machineId = machLayout.TableRowID.Value;
var sensor = bllSensor.GetModel(sensroLayout.TableRowID.Value);
var sensor_codes = bllSensor_ParamCode.GetModelList("SensorModuleID = " + sensor.SensorModuleID);
foreach (var sc in sensor_codes)
{
var property = new VM_Highcharts_Property();
//获取参数
var code = bllParamCode.GetModel(sc.ParameterCodeID.Value);
//是否能够画曲线
property.CanDrawChart = canDrawChart(code.ParameterCodeID);
//曲线类型，将drawType为一样的曲线画在同一图上
property.drawType = code.ParameterType;
property.Title = code.ParameterName;
property.ParamCodeId = code.ParameterCodeID;
//获取参数单位
if (code.ParameterUnitID.HasValue)
{
var unit = bllUnit.GetModel(code.ParameterUnitID.Value);
if (unit != null)
{
property.Symbol = unit.ParameterUnitSymbol;
}
}
else
{
property.Symbol = "未设置";
}
//获取参数最值
var paramCol = bllParamCol.GetModelList("ParameterCodeID = " + code.ParameterCodeID + "AND MachineID = " + machineId).FirstOrDefault();
if (paramCol != null)
{
property.MaxValue = float.Parse(paramCol.ParametersColMaxiumValue);
property.MinValue = float.Parse(paramCol.ParametersColMiniumValue);
}
//是否带有 CPK
if (Enum.IsDefined(typeof(CPK_PARAM_CODE), sc.ParameterCodeID))
{
property.IsCPK = true;
}
else
{
property.IsCPK = false;
}
properties.Add(property);
}
if (properties.Count > 0)
{
retData.Code = RESULT_CODE.OK;
//每参数曲线基本值(最值，标题，单位等等)
//每个模块有多个参数，所以这里是一个properties集合
retData.Appendix = properties;
//给每个模块绑定传感器编号，便于接受485报警
retData.Content = sensor.SerialNum;
}
} catch (Exception e) {
log.Error("获取模块参数失败", e);
retData.Content = "获取模块参数失败";
}
return(Json(retData));
}
