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