/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MainTenanceLogModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update maintenancelog set ");
strSql.Append("settingID=@settingID,");
strSql.Append("devhouseID=@devhouseID,");
strSql.Append("orderCode=@orderCode,");
strSql.Append("orderContent=@orderContent,");
strSql.Append("orderType=@orderType,");
strSql.Append("createTime=@createTime,");
strSql.Append("operateTime=@operateTime,");
strSql.Append("status=@status,");
strSql.Append("remark=@remark");
strSql.Append(" where mID=@mID");
MySqlParameter[] parameters =
{
new MySqlParameter("@settingID", MySqlDbType.Int32, 10),
new MySqlParameter("@devhouseID", MySqlDbType.Int32, 10),
new MySqlParameter("@orderCode", MySqlDbType.VarChar, 18),
new MySqlParameter("@orderContent", MySqlDbType.VarChar, 500),
new MySqlParameter("@orderType", MySqlDbType.Int32, 4),
new MySqlParameter("@createTime", MySqlDbType.DateTime),
new MySqlParameter("@operateTime", MySqlDbType.DateTime),
new MySqlParameter("@status", MySqlDbType.Int32, 4),
new MySqlParameter("@remark", MySqlDbType.VarChar, 50),
new MySqlParameter("@mID", MySqlDbType.Int32, 10)
};
parameters[0].Value = model.settingID;
parameters[1].Value = model.devhouseID;
parameters[2].Value = model.orderCode;
parameters[3].Value = model.orderContent;
parameters[4].Value = model.orderType;
parameters[5].Value = model.createTime;
parameters[6].Value = model.operateTime;
parameters[7].Value = model.status;
parameters[8].Value = model.remark;
parameters[9].Value = model.mID;
int rows = MySQLHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MainTenanceLogModel DataRowToModel(DataRow row)
{
MainTenanceLogModel model = new MainTenanceLogModel();
if (row != null)
{
if (row["mID"] != null && row["mID"].ToString() != "")
{
model.mID = int.Parse(row["mID"].ToString());
}
if (row["settingID"] != null && row["settingID"].ToString() != "")
{
model.settingID = int.Parse(row["settingID"].ToString());
}
if (row["devhouseID"] != null && row["devhouseID"].ToString() != "")
{
model.devhouseID = int.Parse(row["devhouseID"].ToString());
}
if (row["orderCode"] != null)
{
model.orderCode = row["orderCode"].ToString();
}
if (row["orderContent"] != null)
{
model.orderContent = row["orderContent"].ToString();
}
if (row["orderType"] != null && row["orderType"].ToString() != "")
{
model.orderType = int.Parse(row["orderType"].ToString());
}
if (row["createTime"] != null && row["createTime"].ToString() != "")
{
model.createTime = DateTime.Parse(row["createTime"].ToString());
}
if (row["operateTime"] != null && row["operateTime"].ToString() != "")
{
model.operateTime = DateTime.Parse(row["operateTime"].ToString());
}
if (row["status"] != null && row["status"].ToString() != "")
{
model.status = int.Parse(row["status"].ToString());
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MainTenanceLogModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into maintenancelog(");
strSql.Append("settingID,devhouseID,orderCode,orderContent,orderType,createTime,operateTime,status,remark)");
strSql.Append(" values (");
strSql.Append("@settingID,@devhouseID,@orderCode,@orderContent,@orderType,@createTime,@operateTime,@status,@remark)");
MySqlParameter[] parameters =
{
new MySqlParameter("@settingID", MySqlDbType.Int32, 10),
new MySqlParameter("@devhouseID", MySqlDbType.Int32, 10),
new MySqlParameter("@orderCode", MySqlDbType.VarChar, 18),
new MySqlParameter("@orderContent", MySqlDbType.VarChar, 500),
new MySqlParameter("@orderType", MySqlDbType.Int32, 4),
new MySqlParameter("@createTime", MySqlDbType.DateTime),
new MySqlParameter("@operateTime", MySqlDbType.DateTime),
new MySqlParameter("@status", MySqlDbType.Int32, 4),
new MySqlParameter("@remark", MySqlDbType.VarChar, 50)
};
parameters[0].Value = model.settingID;
parameters[1].Value = model.devhouseID;
parameters[2].Value = model.orderCode;
parameters[3].Value = model.orderContent;
parameters[4].Value = model.orderType;
parameters[5].Value = model.createTime;
parameters[6].Value = model.operateTime;
parameters[7].Value = model.status;
parameters[8].Value = model.remark;
int rows = MySQLHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MainTenanceLogModel GetModel(int mID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select mID,settingID,devhouseID,orderCode,orderContent,orderType,createTime,operateTime,status,remark from maintenancelog ");
strSql.Append(" where mID=@mID");
MySqlParameter[] parameters =
{
new MySqlParameter("@mID", MySqlDbType.Int32)
};
parameters[0].Value = mID;
MainTenanceLogModel model = new MainTenanceLogModel();
DataTable dt = MySQLHelper.ExecuteToDataTable(strSql.ToString(), parameters);
if (dt.Rows.Count > 0)
{
return(DataRowToModel(dt.Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MainTenanceLogModel model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MainTenanceLogModel model)
{
return(dal.Add(model));
}
public void SendAlarmMsg(DataRow dr)
{
AlarmSettingBLL setting = new AlarmSettingBLL();
SendMessageBLL msg = new SendMessageBLL();
//判断是否有发送短信记录
string alarmCode = dr["alarmCode"].ToString();
string devID = dr["devID"].ToString();
string strMsgWhere = string.Format(" alarmState<>1 and devID={0} and alarmCode='{1}'", devID, alarmCode);
DataTable dtMsg = msg.GetList(strMsgWhere);
if (dtMsg.Rows.Count == 0)
{
//当为异常信息时发送短信
if (dr["alarmState"].ToString() != "1")
{
//由设备名字，报警名字，报警信息
string stateName = string.Empty;
#region 取得报警信息
switch (dr["alarmState"].ToString())
{
case "-2":
stateName = "过低";
break;
case "2":
stateName = "过高";
break;
case "-1":
stateName = "异常";
break;
case "1":
stateName = "正常";
break;
default:
stateName = "正常";
break;
}
#endregion
string strMsg = string.Format("'{0}','{1}',{2}", dr["devName"].ToString(), dr["alarmName"].ToString(), stateName);
//判断当前报警编码是否发送短信
if (setting.GetAlarmSettingSendMessage(alarmCode))
{
#region 发送信息
SendUserMessage(dr, strMsg);
#endregion
}
#region 增加工单记录
MainTenanceLogBLL maintenance = new MainTenanceLogBLL();
MainTenanceLogModel modelLog = new MainTenanceLogModel();
modelLog.settingID = 0;
modelLog.devhouseID = Convert.ToInt32(devID);
modelLog.orderCode = alarmCode + DateTime.Now.ToString("yyMMddHHmmssfff") + (Encoding.ASCII.GetBytes(alarmCode).Sum(k => k / new Random().NextDouble()) % 1000).ToString("000");
modelLog.orderContent = strMsg;
modelLog.orderType = 1;
modelLog.createTime = DateTime.Now;
modelLog.status = 1;
maintenance.Add(modelLog);
#endregion
}
else
{
//将发送状态改为正常
msg.UpdateStatus(devID, alarmCode);
}
}
}
