public int UpAlarmHand(v2_alarm_logHandVModel hand)
{
StringBuilder strSql = new StringBuilder();
if (hand.Aid == 0)
{
strSql.Clear();
strSql.Append("select max(Aid)as mkey from v2_alarm_log_hand where Log_id=@Log_id");
object obj = SQLHelper.ExecuteScalar(strSql.ToString(), new { Log_id = hand.Log_id });
hand.Aid = CommFunc.ConvertDBNullToInt32(obj) + 1;
}
strSql.Clear();
strSql.Append("insert into v2_alarm_log_hand(Log_id,Aid,HdType,Content,Create_by,Create_dt,ErrCode,ErrTxt,HdTime)");
strSql.Append("values(@Log_id,@Aid,@HdType,@Content,@SysUid,now(),@ErrCode,@ErrTxt,now())");
strSql.Append(" ON DUPLICATE KEY UPDATE Content=@Content,ErrCode=@ErrCode,ErrTxt=@ErrTxt,HdTime=now()");
return(SQLHelper.Execute(strSql.ToString(), new { Log_id = hand.Log_id, Aid = hand.Aid, HdType = hand.HdType, Content = hand.Content, SysUid = this.SysUid, ErrCode = hand.ErrCode, ErrTxt = hand.ErrTxt }));
}
public v2_alarm_logHandVModel GetAlarmHand(long log_id, string hdType)
{
StringBuilder strSql = new StringBuilder();
strSql.Clear();
strSql.Append("select Log_id,Aid,HdType,Content,Create_dt,ErrCode,ErrTxt,HdTime");
strSql.Append(" from v2_alarm_log_hand");
strSql.Append(" where Log_id=@Log_id and HdType=@HdType order by Aid desc limit 1");
DataTable dtSource = SQLHelper.Query(strSql.ToString(), new { Log_id = log_id, HdType = hdType });
v2_alarm_logHandVModel hand = new v2_alarm_logHandVModel()
{
Log_id = log_id, Aid = 0, HdType = hdType
};
if (dtSource.Rows.Count > 0)
{
hand = ModelHandler <v2_alarm_logHandVModel> .FillModel(dtSource.Rows[0]);
}
return(hand);
}
private static void SendHd(int ledger, long log_id, AlarmType alarmType, HdType hdType, string content, int module_id)
{
SysPro pro;
NCSys.Pro.TryGetValue(ledger, out pro);
if (pro == null)
{
return;
}
DataProcessBLL bll = new DataProcessBLL(ledger, Config.Uid);
v2_alarm_logHandVModel hand = bll.GetAlarmHand(log_id, hdType.ToString());
hand.Content = content;
if (hand.ErrCode == 1)
{
int sendSpan = CommFunc.ConvertDBNullToInt32(IniHepler.GetConfig(Config.lpFileName, "Alarm", "SendSpan"));
if (hand.HdTime.AddMinutes(sendSpan) > DateTime.Now)
{
return;
}
else
{
hand.Aid = 0;/*新增一条记录*/
}
}
DataTable dtSource = bll.GetSendInfo(module_id);
List <string> mpReceipts = new List <string>();
List <string> emReceipts = new List <string>();
string coName = "", moduleName = "";
foreach (DataRow drCrm in dtSource.Rows)
{
if (!string.IsNullOrEmpty(CommFunc.ConvertDBNullToString(drCrm["MPhone"])))
{
mpReceipts.Add(CommFunc.ConvertDBNullToString(drCrm["MPhone"]));
}
if (!string.IsNullOrEmpty(CommFunc.ConvertDBNullToString(drCrm["Email"])))
{
emReceipts.Add(CommFunc.ConvertDBNullToString(drCrm["Email"]));
}
coName = CommFunc.ConvertDBNullToString(drCrm["CoName"]);
moduleName = CommFunc.ConvertDBNullToString(drCrm["ModuleName"]);
}
bool sue = false;
string msg = "";
try
{
if (hdType == HdType.AL_Sms)
{
if (mpReceipts.Count > 0)
{
if (alarmType == AlarmType.Al_Use)
{/*感知万物演示用*/
string ccc = JsonHelper.Serialize(new { moduleName = moduleName });
if (!string.IsNullOrEmpty(pro.Sms.ComSmsConfig.ComSms))
{
sue = pro.Sms.SendMessage(mpReceipts, ccc, out msg);
}
else if (!string.IsNullOrEmpty(SmsFun.AliSmsConfig.AliAppKey))
{
sue = pro.Sms.SmsMessage(mpReceipts, ccc, out msg, "SMS_137657141");
}
else
{
msg = "没有发现短信接口";
}
}
else
{
msg = "感知演示,暂不开放";
}
}
else
{
msg = "无手机号码";
}
}
else if (hdType == HdType.AL_Email)
{
if (mpReceipts.Count > 0)
{
StringBuilder mailcont1 = new StringBuilder();
mailcont1.Append("你好:" + coName);
mailcont1.Append("<br>");
mailcont1.Append("告警内容:" + hand.Content);
mailcont1.Append("<br>");
mailcont1.Append("告警时间:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", System.Globalization.DateTimeFormatInfo.InvariantInfo));
pro.Email.SendMail("告警通知", mailcont1.ToString(), "", emReceipts, null, null);
sue = true;
}
else
{
msg = "无邮箱地址";
}
}
hand.ErrCode = sue == true ? 1 : -1;
}
catch (Exception ex)
{
hand.ErrCode = -1;
msg = ex.Message;
}
hand.ErrTxt = msg;
bll.UpAlarmHand(hand);
}
public int UpAlarmHand(v2_alarm_logHandVModel hand)
{
return(dal.UpAlarmHand(hand));
}
