/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MesWeb.Model.T_ParameterCode model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_ParameterCode set ");
strSql.Append("ParameterCode=@ParameterCode,");
strSql.Append("ParameterType=@ParameterType,");
strSql.Append("ParameterName=@ParameterName,");
strSql.Append("ParameterUnitID=@ParameterUnitID,");
strSql.Append("ParameterBit=@ParameterBit,");
strSql.Append("Type=@Type");
strSql.Append(" where ParameterCodeID=@ParameterCodeID");
SqlParameter[] parameters =
{
new SqlParameter("@ParameterCode", SqlDbType.Int, 4),
new SqlParameter("@ParameterType", SqlDbType.Int, 4),
new SqlParameter("@ParameterName", SqlDbType.NVarChar, 50),
new SqlParameter("@ParameterUnitID", SqlDbType.Int, 4),
new SqlParameter("@ParameterBit", SqlDbType.Int, 4),
new SqlParameter("@Type", SqlDbType.Int, 4),
new SqlParameter("@ParameterCodeID", SqlDbType.Int, 4)
};
parameters[0].Value = model.ParameterCode;
parameters[1].Value = model.ParameterType;
parameters[2].Value = model.ParameterName;
parameters[3].Value = model.ParameterUnitID;
parameters[4].Value = model.ParameterBit;
parameters[5].Value = model.Type;
parameters[6].Value = model.ParameterCodeID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public JsonResult EditParamCode(MesWeb.Model.T_ParameterCode code)
{
log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name);
var bllParamCode = new MesWeb.BLL.T_ParameterCode();
var retData = new VM_Result_Data();
try {
if (bllParamCode.Update(code))
{
retData.Code = RESULT_CODE.OK;
retData.Content = "更新成功";
}
else
{
retData.Content = "更新失败";
log.Error("更新参数失败");
}
} catch (Exception e) {
log.Fatal("更新参数类型发生异常", e);
}
return(Json(retData));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MesWeb.Model.T_ParameterCode model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_ParameterCode(");
strSql.Append("ParameterCode,ParameterType,ParameterName,ParameterUnitID,ParameterBit,Type)");
strSql.Append(" values (");
strSql.Append("@ParameterCode,@ParameterType,@ParameterName,@ParameterUnitID,@ParameterBit,@Type)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ParameterCode", SqlDbType.Int, 4),
new SqlParameter("@ParameterType", SqlDbType.Int, 4),
new SqlParameter("@ParameterName", SqlDbType.NVarChar, 50),
new SqlParameter("@ParameterUnitID", SqlDbType.Int, 4),
new SqlParameter("@ParameterBit", SqlDbType.Int, 4),
new SqlParameter("@Type", SqlDbType.Int, 4)
};
parameters[0].Value = model.ParameterCode;
parameters[1].Value = model.ParameterType;
parameters[2].Value = model.ParameterName;
parameters[3].Value = model.ParameterUnitID;
parameters[4].Value = model.ParameterBit;
parameters[5].Value = model.Type;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MesWeb.Model.T_ParameterCode DataRowToModel(DataRow row)
{
MesWeb.Model.T_ParameterCode model = new MesWeb.Model.T_ParameterCode();
if (row != null)
{
if (row["ParameterCodeID"] != null && row["ParameterCodeID"].ToString() != "")
{
model.ParameterCodeID = int.Parse(row["ParameterCodeID"].ToString());
}
if (row["ParameterCode"] != null && row["ParameterCode"].ToString() != "")
{
model.ParameterCode = int.Parse(row["ParameterCode"].ToString());
}
if (row["ParameterType"] != null && row["ParameterType"].ToString() != "")
{
model.ParameterType = int.Parse(row["ParameterType"].ToString());
}
if (row["ParameterName"] != null)
{
model.ParameterName = row["ParameterName"].ToString();
}
if (row["ParameterUnitID"] != null && row["ParameterUnitID"].ToString() != "")
{
model.ParameterUnitID = int.Parse(row["ParameterUnitID"].ToString());
}
if (row["ParameterBit"] != null && row["ParameterBit"].ToString() != "")
{
model.ParameterBit = int.Parse(row["ParameterBit"].ToString());
}
if (row["Type"] != null && row["Type"].ToString() != "")
{
model.Type = int.Parse(row["Type"].ToString());
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MesWeb.Model.T_ParameterCode GetModel(int ParameterCodeID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ParameterCodeID,ParameterCode,ParameterType,ParameterName,ParameterUnitID,ParameterBit,Type from T_ParameterCode ");
strSql.Append(" where ParameterCodeID=@ParameterCodeID");
SqlParameter[] parameters =
{
new SqlParameter("@ParameterCodeID", SqlDbType.Int, 4)
};
parameters[0].Value = ParameterCodeID;
MesWeb.Model.T_ParameterCode model = new MesWeb.Model.T_ParameterCode();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected VM_Fusioncharts_MSLine getMachineCPKMSLineData(int machineID, MesWeb.Model.T_ParameterCode code, int dataCount = 12)
{
var msLine = new VM_Fusioncharts_MSLine();
var bllParamData = new MesWeb.BLL.T_CollectedDataParameters();
var bllSensorParamCode = new MesWeb.BLL.T_SensorModule_T_ParameterCode();
var bllParamUnit = new MesWeb.BLL.T_ParameterUnit();
var bllParamSet = new MesWeb.BLL.T_ParametersCol();
var dataList = bllParamData.GetModelList("MachineID = " + machineID + "and ParameterCodeID = " + code.ParameterCodeID);
var paramSetting = bllParamSet.GetModelList("ParameterCodeID = " + (int)code.ParameterCodeID).FirstOrDefault();
var paramUnit = bllParamUnit.GetModel((int)code.ParameterUnitID);
var chart = new FusionChart {
caption = code.ParameterName,
numberSuffix = paramUnit.ParameterUnitSymbol,
yAxisName = paramUnit.ParameterUnitName,
xAxisName = "时间"
};
var maxLine = new FusionLine {
startvalue = paramSetting.ParametersColMaxiumValue,
displayvalue = "最大值",
};
var minLine = new FusionLine {
startvalue = paramSetting.ParametersColMiniumValue,
displayvalue = "最小值",
};
var maxCPKLine = new FusionLine {
startvalue = "2.0",
displayvalue = "CPK最大值"
};
var minCPKLine = new FusionLine {
startvalue = "0.2",
displayvalue = "CPK最小值"
};
var trendline = new FusionTrendLine();
trendline.line.Add(maxLine);
trendline.line.Add(minLine);
trendline.line.Add(maxCPKLine);
trendline.line.Add(minCPKLine);
var cpkDataSet = new FusionMSDataset();
var sensorDataSet = new FusionMSDataset();
cpkDataSet.seriesname = "CPK";
sensorDataSet.seriesname = code.ParameterName;
var categories = new FusionMSCategories();
for (int i = 0; i < dataList.Count; i++)
{
var data = dataList[i];
categories.category.Add(new FusionMSCategorie {
label = data.CollectedTime.ToString().Split(' ')[1]
});
sensorDataSet.data.Add(new MSlineValue {
value = float.Parse(data.CollectedValue).ToString("0.00")
});
cpkDataSet.data.Add(new MSlineValue {
value = GetCPKValue(code.ParameterCodeID, machineID).ToString("0.00")
});
}
msLine.categories.Add(categories);
msLine.chart = chart;
msLine.trendlines.Add(trendline);
msLine.dataset.Add(sensorDataSet);
msLine.dataset.Add(cpkDataSet);
return(msLine);
}