/// <summary> /// 添加新短信发送历史记录 /// </summary> /// <param name="sendedNote">短信发送历史信息实体</param> /// <returns>1:添加成功;0:添加失败</returns> public int Add(Model.TN_SendedNote sendedNote) { #region query string StringBuilder sb = new StringBuilder(); sb.Append("insert into TN_SendedNote ("); sb.Append("CoalCode,"); sb.Append("CoalName,"); sb.Append("DevCode,"); sb.Append("AlarmGrade,"); sb.Append("ReciverName,"); sb.Append("ReciverPhoneNo,"); sb.Append("NoteContent,"); sb.Append("SendTime,"); sb.Append("SendState ) values ("); sb.Append("CoalCode,"); sb.Append("@CoalName,"); sb.Append("@DevCode,"); sb.Append("@AlarmGrade,"); sb.Append("@ReciverName,"); sb.Append("@ReciverPhoneNo,"); sb.Append("@NoteContent,"); sb.Append("@SendTime,"); sb.Append("@SendState)"); #endregion #region sql parameters SqlParameter[] parameter = { new SqlParameter("@CoalCode",SqlDbType.VarChar,20), new SqlParameter("@CoalName",SqlDbType.NVarChar,50), new SqlParameter("@DevCode",SqlDbType.VarChar,8), new SqlParameter("@AlarmGrade",SqlDbType.NVarChar,2), new SqlParameter("@ReciverName",SqlDbType.NVarChar,4000), new SqlParameter("@ReciverPhoneNo",SqlDbType.VarChar,8000), new SqlParameter("@NoteContent",SqlDbType.VarChar,200), new SqlParameter("@SendTime",SqlDbType.DateTime), new SqlParameter("@SendState",SqlDbType.Bit) }; parameter[0].Value = sendedNote.CoalCode; parameter[1].Value = sendedNote.CoalName; parameter[2].Value = sendedNote.DevCode; parameter[3].Value = sendedNote.AlarmGrade; parameter[4].Value = sendedNote.ReciverName; parameter[5].Value = sendedNote.ReciverPhoneNo; parameter[6].Value = sendedNote.NoteContent; parameter[7].Value = sendedNote.SendTime; parameter[8].Value = sendedNote.SendState; #endregion int retVal = da.ExecuteCommand(sb.ToString(), CommandType.Text, parameter); return retVal == 0 ? 0 : 1; }
/// <summary> /// 添加新煤矿信息 /// </summary> /// <param name="server">煤矿信息实体</param> /// <returns>1:为添加成功;0:为添加失败</returns> public int Add(Model.TN_Coal coal) { StringBuilder sb = new StringBuilder(); sb.Append("insert into TN_Coals ("); sb.Append("CoalCode,"); sb.Append("CoalName,"); sb.Append("CountryName,"); sb.Append("SiteName,"); sb.Append("ServerCode,"); sb.Append("CoalIP,"); sb.Append("CoalOwner,"); sb.Append("ContactPhone)"); sb.Append(" values ("); sb.Append("@CoalCode,"); sb.Append("@CoalName,"); sb.Append("@CountryName,"); sb.Append("@SiteName,"); sb.Append("@ServerCode,"); sb.Append("@CoalIP,"); sb.Append("@CoalOwner,"); sb.Append("@ContactPhone)"); SqlParameter[] parameter = { new SqlParameter("@CoalCode",SqlDbType.VarChar,20), new SqlParameter("@CoalName",SqlDbType.NVarChar,50), new SqlParameter("@CountryName",SqlDbType.NVarChar,50), new SqlParameter("@SiteName",SqlDbType.NVarChar,50), new SqlParameter("@ServerCode",SqlDbType.VarChar,4), new SqlParameter("@CoalIP",SqlDbType.VarChar,20), new SqlParameter("@CoalOwner",SqlDbType.NVarChar,20), new SqlParameter("@ContactPhone",SqlDbType.VarChar,50) }; parameter[0].Value = coal.CoalCode; parameter[1].Value = coal.CoalName; parameter[2].Value = coal.CountryName; parameter[3].Value = coal.SiteName; parameter[4].Value = coal.ServerCode; parameter[5].Value = coal.CoalIP; parameter[6].Value = coal.CoalOwner; parameter[7].Value = coal.ContactPhone; int retVal = dal.ExecuteCommand(sb.ToString(), CommandType.Text, parameter); return retVal == 0 ? 0 : 1; }
/// <summary> /// 添加新分数据服务器信息 /// </summary> /// <param name="server">分数据服务器实体</param> /// <returns>1:为添加成功;0:为添加失败</returns> public int Add(Model.TN_Server server) { StringBuilder sb = new StringBuilder(); sb.Append("insert into TN_Servers ("); sb.Append("ServerCode,"); sb.Append("ServerName,"); sb.Append("ServerIP,"); sb.Append("DBConfig,"); sb.Append("IsForbid,"); sb.Append("Remark)"); sb.Append(" values ("); sb.Append("@ServerCode,"); sb.Append("@ServerName,"); sb.Append("@ServerIP,"); sb.Append("@DBConfig,"); sb.Append("@IsForbid,"); sb.Append("@Remark)"); SqlParameter[] parameters = { new SqlParameter("@ServerCode",SqlDbType.VarChar,4), new SqlParameter("@ServerName",SqlDbType.NVarChar,20), new SqlParameter("@ServerIP",SqlDbType.VarChar,20), new SqlParameter("@DBConfig",SqlDbType.VarChar,500), new SqlParameter("@IsForbid",SqlDbType.Bit), new SqlParameter("@Remark",SqlDbType.NVarChar,200) }; parameters[0].Value = server.ServerCode; parameters[1].Value = server.ServerName; parameters[2].Value = server.ServerIP; parameters[3].Value = server.DBConfig; parameters[4].Value = server.IsForbid; parameters[5].Value = server.Remark; int retVal = dal.ExecuteCommand(sb.ToString(), CommandType.Text, parameters); return retVal == 0 ? 0 : 1; }
/// <summary> /// 构建结束报警短信息内容 /// </summary> /// <param name="note">报警短信息内容实体</param> /// <returns>短信息内容</returns> public static string CreateFinished(Model.TN_NoteContent note) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("{0} ", note.CoalName); sb.AppendFormat("{0} ", note.DevCode); sb.AppendFormat("{0} ", note.DevAddress); sb.Append("报警结束 "); sb.AppendFormat("开始时间:{0} ", note.StartTime.ToString("yyyy-MM-dd HH:mm:ss")); sb.AppendFormat("结束时间:{0} ", note.EndTime.ToString("yyyy-MM-dd HH:mm:ss")); #region 报警持续时间 if (note.Duration >= 60) { sb.AppendFormat("持续时间:{0};", CalculateTime(note.Duration)); } else { if (note.Duration > 0) { sb.AppendFormat("持续时间:{0}秒;", note.Duration.ToString()); } } #endregion return sb.ToString(); }
public int RollBack(Model.TN_AlarmRecodeClearUp arcu) { return dal.RollBack(arcu); }
/// <summary> /// 构建网络上传中断报警结束短信息内容 /// </summary> /// <param name="note">报警短信息内容实体</param> /// <returns>短信息内容</returns> public static string GreateUploadOffFinished(Model.TN_NoteContent note) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("{0} ", note.CoalName); sb.Append("数据上传中断 报警结束 "); sb.AppendFormat("持续:{0}秒 ", note.Duration.ToString()); sb.AppendFormat("开始:{0} ", note.StartTime.ToString("yy-M-d HH:mm:ss")); sb.AppendFormat("结束:{0}", note.EndTime.ToString("yy-M-d HH:mm:ss")); return sb.ToString(); }
/// <summary> /// 构建普通报警短信息内容 edit by tangcy /// </summary> /// <param name="note">报警短信息内容实体</param> /// <returns>短信息内容</returns> public static string CreateNormal(Model.TN_NoteContent note) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("{0};", note.CoalName); // sb.AppendFormat("传感器名称:{0};", note.DevCode); sb.AppendFormat("{0}报警;", note.DevCode); sb.AppendFormat("地址:{0};", note.DevAddress); sb.AppendFormat("报警类型:{0};", note.AlarmType); #region 报警级别 if (note.DevType == "模拟量" && note.DevCode == "瓦斯") { string AlarmDevValue = ConfigurationSettings.AppSettings["AlarmWSValue"];//浓度 string AlarmGradeName = ConfigurationSettings.AppSettings["AlarmGradeName"];//报警级别 if (AlarmDevValue != "" && AlarmGradeName != "") { string[] alarmgrade = AlarmDevValue.Split(','); string[] alarmgradename = AlarmGradeName.Split(','); #region 报警级别名称 多于或者等于 浓度标准 个数 if (alarmgradename.Length >= alarmgrade.Length)//报警级别名称 多于 浓度标准 { if (Convert.ToDecimal(note.DevValue) >= Convert.ToDecimal(alarmgrade[alarmgrade.Length - 1])) { sb.AppendFormat("报警级别:{0};", alarmgradename[alarmgradename.Length - 1]); } else { for (int i = 0; i < alarmgrade.Length - 1; i++) { if (Convert.ToDecimal(note.DevValue) >= Convert.ToDecimal(alarmgrade[i]) && Convert.ToDecimal(note.DevValue) < Convert.ToDecimal(alarmgrade[i + 1])) { sb.AppendFormat("报警级别:{0};", alarmgradename[i]); } } if (Convert.ToDecimal(note.DevValue) < Convert.ToDecimal(alarmgrade[0])) { sb.AppendFormat("报警级别:{0};", alarmgradename[0]); } } } #endregion #region 报警级别名称 少于 浓度标准 else//报警级别名称 少于 浓度标准 { if (Convert.ToDecimal(note.DevValue) >= Convert.ToDecimal(alarmgrade[alarmgradename.Length - 1])) { sb.AppendFormat("报警级别:{0};", alarmgradename[alarmgradename.Length - 1]); } else { for (int i = 0; i < alarmgradename.Length - 1; i++) { if (Convert.ToDecimal(note.DevValue) >= Convert.ToDecimal(alarmgrade[i]) && Convert.ToDecimal(note.DevValue) < Convert.ToDecimal(alarmgrade[i + 1])) { sb.AppendFormat("报警级别:{0};", alarmgradename[i]); } } if (Convert.ToDecimal(note.DevValue) < Convert.ToDecimal(alarmgrade[0])) { sb.AppendFormat("报警级别:{0};", alarmgradename[0]); } } } #endregion // sb.AppendFormat("报警级别:{0};", note.AlarmGrade); } else { sb.AppendFormat("报警级别:{0};", note.AlarmGrade); } } else { sb.AppendFormat("报警级别:{0};", note.AlarmGrade); } #endregion sb.AppendFormat("测量值:{0}{1};", note.DevValue, note.DevUnit); #region 报警持续时间 if (note.Duration >= 60) { sb.AppendFormat("持续时间:{0};", CalculateTime(note.Duration)); } else { if (note.Duration >0) { sb.AppendFormat("持续时间:{0}秒;", note.Duration.ToString()); } } #endregion // sb.AppendFormat("结束时间{0};", note.EndTime.ToString("yy-M-d HH:mm:ss")); return sb.ToString(); }
/// <summary> /// 添加新分数据服务器信息 /// </summary> /// <param name="server">分数据服务器实体</param> /// <returns>1:为添加成功;0:为添加失败</returns> public int Add(Model.TN_Server server) { return dal.Add(server); }
public int Delete(Model.TN_AlarmRecodeClearUp arcu) { return dal.Delete(arcu); }
/// <summary> /// 更新报警发送定义 /// </summary> /// <param name="alarmSendDefine">报警定义实体</param> /// <returns>1:添加成功;0:添加失败</returns> public int Update(Model.TN_AlarmSendDefine alarmSendDefine) { return dal.Update(alarmSendDefine); }
/// <summary> /// 添加新煤矿信息 /// </summary> /// <param name="server">煤矿信息实体</param> /// <returns>1:为添加成功;0:为添加失败</returns> public int Add(Model.TN_Coal coal) { return dal.Add(coal); }
/// <summary> /// 更新煤矿信息 /// </summary> /// <param name="coal">煤矿信息实体</param> /// <returns>1:为添加成功;0:为添加失败</returns> public int Update(Model.TN_Coal coal) { return dal.Update(coal); }
/// <summary> /// 更新最新发送十条短信报警数据 /// </summary> /// <param name="alarmItem">报警信息</param> private void UpdateHistoryTopTenList(Model.TN_AlarmItem alarmItem) { //判断当前集合中的数据条数,如果当前数据条数小于10直接添加 if (historyTopTen.Count < 10) { historyTopTen.Add(alarmItem); } else { //删除第一条短信报警记录 historyTopTen.RemoveAt(0); //加入一条 historyTopTen.Add(alarmItem); } }
/// <summary> /// 添加新报警发送定义 /// </summary> /// <param name="alarmSendDefine">报警定义实体</param> /// <returns>1:添加成功;0:添加失败</returns> public int Add(Model.TN_AlarmSendDefine alarmSendDefine) { #region querystring StringBuilder sb = new StringBuilder(); sb.Append("insert into TN_AlarmSendDefine ("); sb.Append("CoalCode,"); sb.Append("CoalName,"); sb.Append("AlarmType,"); sb.Append("DevName,"); sb.Append("ShiftRange,"); sb.Append("AlarmGrade,"); sb.Append("AutoUpdate,"); sb.Append("GUModel,"); sb.Append("ReciverName,"); sb.Append("ReciverPhoneNo,"); sb.Append("SendFrequency,"); sb.Append("FinishAlarmTime,"); sb.Append("SendFinishNote,"); sb.Append("Valid ) "); sb.Append(" values ("); sb.Append("@CoalCode,"); sb.Append("@CoalName,"); sb.Append("@AlarmType,"); sb.Append("@DevName,"); sb.Append("@ShiftRange,"); sb.Append("@AlarmGrade,"); sb.Append("@AutoUpdate,"); sb.Append("@GUModel,"); sb.Append("@ReciverName,"); sb.Append("@ReciverPhoneNo,"); sb.Append("@SendFrequency,"); sb.Append("@FinishAlarmTime,"); sb.Append("@SendFinishNote,"); sb.Append("@Valid ) "); #endregion querystring SqlParameter[] parameter = { new SqlParameter("@CoalCode",SqlDbType.VarChar,20), new SqlParameter("@CoalName",SqlDbType.NVarChar,50), new SqlParameter("@AlarmType",SqlDbType.NVarChar,50), new SqlParameter("@DevName",SqlDbType.NVarChar,20), new SqlParameter("@ShiftRange",SqlDbType.Decimal), new SqlParameter("@AlarmGrade",SqlDbType.NVarChar,2), new SqlParameter("@AutoUpdate",SqlDbType.Bit), new SqlParameter("@GUModel",SqlDbType.VarChar,20), new SqlParameter("@ReciverName",SqlDbType.NVarChar,4000), new SqlParameter("@ReciverPhoneNo",SqlDbType.VarChar,8000), new SqlParameter("@SendFrequency",SqlDbType.Int), new SqlParameter("@FinishAlarmTime",SqlDbType.Int), new SqlParameter("@SendFinishNote",SqlDbType.Bit), new SqlParameter("@Valid",SqlDbType.Bit) }; parameter[0].Value = alarmSendDefine.CoalCode; parameter[1].Value = alarmSendDefine.CoalName; parameter[2].Value = alarmSendDefine.AlarmType; parameter[3].Value = alarmSendDefine.DevName; parameter[4].Value = alarmSendDefine.ShiftRange; parameter[5].Value = alarmSendDefine.AlarmGrade; parameter[6].Value = alarmSendDefine.AutoUpdate; parameter[7].Value = alarmSendDefine.GUModel; parameter[8].Value = alarmSendDefine.ReciverName; parameter[9].Value = alarmSendDefine.ReciverPhoneNo; parameter[10].Value = alarmSendDefine.SendFrequency; parameter[11].Value = alarmSendDefine.FinishAlarmTime; parameter[12].Value = alarmSendDefine.SendFinishNote; parameter[13].Value = alarmSendDefine.Valid; int retVal = dal.ExecuteCommand(sb.ToString(), CommandType.Text, parameter); return retVal == 0 ? 0 : 1; }
public int UpdateCache(Model.TN_AlarmRecodeClearUp arcu) { return dal.UpdateCache(arcu); }
/// <summary> /// 添加新报警发送定义 /// </summary> /// <param name="alarmSendDefine">报警定义实体</param> /// <returns>1:添加成功;0:添加失败</returns> public int Add(Model.TN_AlarmSendDefine alarmSendDefine) { return dal.Add(alarmSendDefine); }
public int Add(Model.TN_AlarmRecodeClearUp arcu) { return dal.Add(arcu); }
/// <summary> /// 更新分数据服务器信息 /// </summary> /// <param name="server">分数据服务器实体</param> /// <returns>1:为添加成功;0:为添加失败</returns> public int Update(Model.TN_Server server) { StringBuilder sb = new StringBuilder(); sb.Append("update TN_Servers set "); sb.Append("ServerCode=@ServerCode,"); sb.Append("ServerName=@ServerName,"); sb.Append("ServerIP=@ServerIP,"); sb.Append("DBConfig=@DBConfig,"); sb.Append("IsForbid=@IsForbid,"); sb.Append("Remark=@Remark"); sb.AppendFormat(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@ServerCode",SqlDbType.VarChar,4), new SqlParameter("@ServerName",SqlDbType.NVarChar,20), new SqlParameter("@ServerIP",SqlDbType.VarChar,20), new SqlParameter("@DBConfig",SqlDbType.VarChar,500), new SqlParameter("@IsForbid",SqlDbType.Bit), new SqlParameter("@Remark",SqlDbType.NVarChar,200), new SqlParameter("@Id",SqlDbType.Int) }; parameters[0].Value = server.ServerCode; parameters[1].Value = server.ServerName; parameters[2].Value = server.ServerIP; parameters[3].Value = server.DBConfig; parameters[4].Value = server.IsForbid; parameters[5].Value = server.Remark; parameters[6].Value = server.Id; int retVal = dal.ExecuteCommand(sb.ToString(), CommandType.Text, parameters); return retVal == 0 ? 0 : 1; }
public Model.TN_AlarmRecodeClearUp GetModel(Model.TN_AlarmRecodeClearUp arcu) { return dal.GetModel(arcu); }
/// <summary> /// 更新分数据服务器信息 /// </summary> /// <param name="server">分数据服务器实体</param> /// <returns>1:为添加成功;0:为添加失败</returns> public int Update(Model.TN_Server server) { return dal.Update(server); }