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