private string[] GetOrderinfo(AlarmLogModel model) { Random rd = new Random(); string[] oinfo = new string[2]; oinfo[0] = model.alarmCode + DateTime.Now.ToString("yyMMddHHmmssfff"); oinfo[1] = string.Format("{0},{1},{2}", model.devName, model.alarmName, GetAlarmStateName(model.alarmState)); return(oinfo); }
/// <summary> /// 添加一条报警复位记录 /// </summary> /// <param name="model"></param> public bool ReSet(AlarmLogModel model) { if (model == null) { return(false); } StringBuilder strSql = new StringBuilder(); strSql.Append("insert into alarmlog(devID,alarmCode,alarmValue,alarmState,insertTime)"); strSql.Append(" values ("); strSql.AppendFormat("{0},'{1}',{2},{3},'{4}')", model.devID, model.alarmCode, model.alarmValue, model.alarmState, DateTime.Now); return(MySQLHelper.ExecuteNonQuery(strSql.ToString(), null) > 0 ? true : false); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(AlarmLogModel model) { if (model == null) { return(false); } List <string> cmdlist = new List <string>(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into alarmlog(devID,alarmCode,alarmValue,alarmState,insertTime)"); strSql.Append(" values ("); strSql.AppendFormat("{0},'{1}',{2},{3},'{4}')", model.devID, model.alarmCode, model.alarmValue, model.alarmState, DateTime.Now); cmdlist.Add(strSql.ToString()); strSql.Clear(); string[] orderInfo = GetOrderinfo(model); strSql.Append("insert into maintenancelog("); strSql.Append("settingID,devhouseID,orderCode,orderContent,orderType,createTime,status)"); strSql.Append(" values ("); strSql.AppendFormat("0,{0},'{1}','{2}',1,'{3}',1)", model.devID, orderInfo[0], orderInfo[1], DateTime.Now); cmdlist.Add(strSql.ToString()); return(MySQLHelper.ExecuteSqlByTran(cmdlist) > 0 ? true : false); }