public static List <WarningMessageModel> GetPagingWarning(int pageindex, int pagesize)
{
string sql = @"SELECT id,title,note,warningtype,code,time,fixing FROM dbo.sys_warning ORDER BY time DESC";
SqlHelper sqlHelper = new SqlHelper(conStr);
int startRecord = (pageindex - 1) * pagesize;
DataTable table = sqlHelper.ExecuteQuery(sql, startRecord, pagesize, "sys_warning");
List <WarningMessageModel> list = new List <WarningMessageModel>();
for (int i = 0; i < table.Rows.Count; i++)
{
WarningMessageModel warningMessageModel = new WarningMessageModel();
warningMessageModel.id = table.Rows[i]["id"].ToString();
warningMessageModel.title = table.Rows[i]["title"].ToString();
warningMessageModel.body = table.Rows[i]["note"].ToString();
warningMessageModel.warnNo = table.Rows[i]["warningtype"].ToString();
warningMessageModel.time = table.Rows[i]["time"].ToString();
warningMessageModel.code = table.Rows[i]["code"].ToString();
warningMessageModel.fixing = table.Rows[i]["fixing"].ToString();
list.Add(warningMessageModel);
}
return(list);
}
public static bool AddWarning(WarningMessageModel warningMessageModel)
{
string sql = @"INSERT INTO dbo.sys_warning(id,title,note,warningtype,code,time, modname) VALUES(@id,@title,@note,@warningtype,@code,@time, @modname)";
SqlParameter[] para = new SqlParameter[7];
para[0] = new SqlParameter("@id", System.Guid.NewGuid().ToString());
para[1] = new SqlParameter("@title", warningMessageModel.title);
para[2] = new SqlParameter("@note", warningMessageModel.body);
para[3] = new SqlParameter("@warningtype", warningMessageModel.warnNo);
para[4] = new SqlParameter("@time", warningMessageModel.time);
if (warningMessageModel.code != null)
{
para[5] = new SqlParameter("@code", warningMessageModel.code);
}
else
{
para[5] = new SqlParameter("@code", "Unkonwn");
}
para[6] = new SqlParameter("@modname", warningMessageModel.modname);
SqlHelper sqlHelper = new SqlHelper(conStr);
int result = sqlHelper.ExecuteNonQuery(sql, para);
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
public static List <WarningMessageModel> GetAllWarning()
{
string sql = @"SELECT id,title,note,warningtype,code,time FROM dbo.sys_warning ORDER BY time DESC";
SqlHelper sqlHelper = new SqlHelper(conStr);
DataTable table = sqlHelper.ExecuteQuery(sql);
List <WarningMessageModel> list = new List <WarningMessageModel>();
for (int i = 0; i < table.Rows.Count; i++)
{
WarningMessageModel warningMessageModel = new WarningMessageModel();
warningMessageModel.id = table.Rows[i]["id"].ToString();
warningMessageModel.title = table.Rows[i]["title"].ToString();
warningMessageModel.body = table.Rows[i]["note"].ToString();
warningMessageModel.warnNo = table.Rows[i]["warningtype"].ToString();
warningMessageModel.time = table.Rows[i]["time"].ToString();
warningMessageModel.code = table.Rows[i]["code"].ToString();
warningMessageModel.fixing = table.Rows[i]["fixing"].ToString();
warningMessageModel.modname = table.Rows[i]["modname"].ToString();
list.Add(warningMessageModel);
}
return(list);
}
public static bool EditWarning(WarningMessageModel warningMessageModel)
{
string sql = @"UPDATE dbo.sys_warning SET title=@title,note=@note,warningtype=@warningtype,time=@time,code=@code, @fixing=fixing WHERE @id=id";
SqlParameter[] para = new SqlParameter[7];
para[0] = new SqlParameter("@id", warningMessageModel.id);
para[1] = new SqlParameter("@title", warningMessageModel.title);
para[2] = new SqlParameter("@note", warningMessageModel.body);
para[3] = new SqlParameter("@warningtype", warningMessageModel.warnNo);
para[4] = new SqlParameter("@time", warningMessageModel.time);
para[5] = new SqlParameter("@code", warningMessageModel.code);
para[6] = new SqlParameter("@fixing", warningMessageModel.fixing);
SqlHelper sqlHelper = new SqlHelper(conStr);
int result = sqlHelper.ExecuteNonQuery(sql, para);
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
public static WarningMessageModel GetWarningByID(string id)
{
string sql = @"SELECT id,title,note,warningtype,code,time,fixing FROM dbo.sys_warning WHERE id=@id";
SqlParameter[] para = new SqlParameter[1];
para[0] = new SqlParameter("@id", id);
SqlHelper sqlHelper = new SqlHelper(conStr);
DataTable table = sqlHelper.ExecuteQuery(sql, para);
WarningMessageModel warningMessageModel = null;
if (table.Rows.Count == 1)
{
warningMessageModel = new WarningMessageModel();
warningMessageModel.id = table.Rows[0]["id"].ToString();
warningMessageModel.title = table.Rows[0]["title"].ToString();
warningMessageModel.body = table.Rows[0]["note"].ToString();
warningMessageModel.warnNo = table.Rows[0]["warningtype"].ToString();
warningMessageModel.time = table.Rows[0]["time"].ToString();
warningMessageModel.code = table.Rows[0]["code"].ToString();
warningMessageModel.fixing = table.Rows[0]["fixing"].ToString();
}
return(warningMessageModel);
}
public static List <WarningMessageModel> GetWarningByWarnNo(string warnno)
{
string sql = @"SELECT id,title,note,warningtype,code,time,fixing FROM dbo.sys_warning WHERE warningtype=@warningtype ORDER BY time DESC";
SqlParameter[] para = new SqlParameter[1];
para[0] = new SqlParameter("@warningtype", warnno);
SqlHelper sqlHelper = new SqlHelper(conStr);
DataTable table = sqlHelper.ExecuteQuery(sql, para);
List <WarningMessageModel> list = new List <WarningMessageModel>();
for (int i = 0; i < table.Rows.Count; i++)
{
WarningMessageModel warningMessageModel = new WarningMessageModel();
warningMessageModel.id = table.Rows[i]["id"].ToString();
warningMessageModel.title = table.Rows[i]["title"].ToString();
warningMessageModel.body = table.Rows[i]["note"].ToString();
warningMessageModel.warnNo = table.Rows[i]["warningtype"].ToString();
warningMessageModel.time = table.Rows[i]["time"].ToString();
warningMessageModel.code = table.Rows[i]["code"].ToString();
warningMessageModel.fixing = table.Rows[i]["fixing"].ToString();
list.Add(warningMessageModel);
}
return(list);
}
public static int PushWarningMessage(ModuleBase current, string name, WarningMessageModel wmm)
{
if (current == null || wmm == null || name == null)
{
Logging.logger.Error(MsgConstStr.ParmNull + " " + current + " " + name + " " + wmm);
return(-1);
}
PushMessage sm = new PushMessage();
sm.ModName = current.ModName;
sm.MsgType = Warning.WarnType.ToString();
sm.Content = JsonConvert.SerializeObject(wmm);
wmm.modname = current.ModName;
string json = JsonConvert.SerializeObject(sm);
int rlt = current.FaninClientSendData(name, json);
if (rlt != 0)
{
Logging.logger.Error(MsgConstStr.FaninCSendFail + " " + 0);
return(-1);
}
return(0);
}
private int ProcessWarnIssue(PushMessage pm)
{
bool ret;
int rlt = -1;
if (ModWarnSts.ContainsKey(pm.ModName))
{
ModWarnStsAll mwsa = ModWarnSts[pm.ModName];
if (mwsa.ModName != pm.ModName)
{
Logging.logger.Error(MsgConstStr.ModNameWrong + mwsa.ModName + " " + pm.ModName);
return(rlt);
}
WarningMessageModel wmm = (WarningMessageModel)JsonConvert.DeserializeObject(pm.Content, typeof(WarningMessageModel));
if (mwsa.WarnStsMon.ContainsKey(wmm.warnNo))
{
WarnStsMonAll wsma = mwsa.WarnStsMon[wmm.warnNo];
if (wsma.WarnNo != wmm.warnNo)
{
Logging.logger.Error(MsgConstStr.WarnIssueWrong);
return(rlt);
}
WarnStatusMon wsm;
if (wsma.WarnCodeAll.ContainsKey(wmm.code))
{
wsm = wsma.WarnCodeAll[wmm.code];
if (wsm.code != wmm.code)
{
Logging.logger.Warn(MsgConstStr.WarnCodeWrong);
wsm.code = wmm.code;
}
if (wsm.WarnNo != wmm.warnNo)
{
Logging.logger.Warn(MsgConstStr.WarnIssueWrong);
wsm.WarnNo = wmm.warnNo;
}
if (wsm.status == WarningSts.NormalSts)
{
//save data to db
ret = WarningDA.AddWarning(wmm);
if (ret)
{
wsm.status = WarningSts.WarnSts;
wsm.start = Convert.ToDateTime(wmm.time);
wsm.count = 0;
rlt = 0;
}
else
{
Logging.logger.Error(MsgConstStr.SaveWarn2DBWrong);
}
}
else
{
if (DateTime.Compare(wsm.start.AddMinutes(warntimelimit), DateTime.Now) < 0)
{
//save data to db
ret = WarningDA.AddWarning(wmm);
if (ret)
{
wsm.status = WarningSts.WarnSts;
wsm.count = 0;
wsm.start = Convert.ToDateTime(wmm.time);
rlt = 0;
}
else
{
Logging.logger.Error(MsgConstStr.SaveWarn2DBWrong);
}
}
else
{
wsm.count += 1;
}
}
}
else
{
wsm = new WarnStatusMon();
wsm.code = wmm.code;
wsm.start = Convert.ToDateTime(wmm.time);
wsm.status = WarningSts.WarnSts;
wsm.WarnNo = wmm.warnNo;
wsm.WarnValue = wmm.title;
wsm.count = 0;
ret = WarningDA.AddWarning(wmm);
if (!ret)
{
Logging.logger.Error(MsgConstStr.SaveWarn2DBWrong);
}
rlt = 0;
wsma.WarnCodeAll.Add(wsm.code, wsm);
}
}
else
{
Logging.logger.Error(MsgConstStr.NoWarnIssue);
return(rlt);
}
}
else
{
Logging.logger.Error(MsgConstStr.NoWarnIssue);
rlt = 0;
}
return(rlt);
}
