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