public IList <CV_PM_ALT_BASE_QuaryParam> getAllAltBase() { IList <CV_PM_ALT_BASE> list = new List <CV_PM_ALT_BASE>(); IList <CV_PM_ALT_BASE_QuaryParam> listQuary = new List <CV_PM_ALT_BASE_QuaryParam>(); try { list = cv_PM_ALT_BASEBO.GetEntities(); if (list == null || list.Count == 0) { return(listQuary); } for (int i = 0; i < list.Count; i++) { CV_PM_ALT_BASE_QuaryParam Entity = new CV_PM_ALT_BASE_QuaryParam(); Entity.AlertID = list[i].AlertID; Entity.AlertName = list[i].AlertName; Entity.AlertAlias = list[i].AlertAlias; Entity.AlertDesc = list[i].AlertDesc; Entity.AlertContent = list[i].AlertContent; Entity.Category = list[i].Category; Entity.AlertType = list[i].AlertType; Entity.Format = list[i].Format; Entity.AlertObject = list[i].AlertObject; Entity.PreProcedure = list[i].PreProcedure; Entity.PostProcedure = list[i].PostProcedure; Entity.AlertInterval = list[i].AlertInterval; Entity.AlertTimePoints = list[i].AlertTimePoints; Entity.LastAlertedTime = list[i].LastAlertedTime; Entity.IsActive = list[i].IsActive; Entity.CIsActive = list[i].CIsActive; Entity.RowDeleted = list[i].RowDeleted; Entity.CreatedBy = list[i].CreatedBy; Entity.CreatedOn = list[i].CreatedOn; Entity.ModifiedBy = list[i].ModifiedBy; Entity.ModifiedOn = list[i].ModifiedOn; Entity.SqlScript = list[i].SqlScript; Entity.URL = list[i].URL; if (list[i].AlertType.ToString() == "1") { Entity.alertTypeName = "邮件"; } else if (list[i].AlertType.ToString() == "2") { Entity.alertTypeName = "微信"; } listQuary.Add(Entity); } if (listQuary.Count > 0) { listQuary = listQuary.OrderByDescending(c => c.ModifiedOn).ToList(); } return(listQuary); } catch (Exception e) { throw e; } }
public string InsertBase(PM_ALT_BASE entity) { if (entity == null) { return("预警内容为空"); } if (entity.AlertInterval.HasValue) { if (entity.AlertInterval < 10) { return("执行间隔不能低于10秒"); } } if (!string.IsNullOrEmpty(entity.AlertTimePoints)) { foreach (string fixedTimer in entity.AlertTimePoints.Split(',')) { if (string.IsNullOrEmpty(fixedTimer.Trim())) { continue; } string strTime = string.Format("2000-01-01 {0}:00", fixedTimer.Trim()); DateTime dateTime = new DateTime(); bool result = DateTime.TryParse(strTime, out dateTime); if (!result) { return("执行时间点格式错误"); } } } PM_ALT_BASE exist = pm_ALT_BASEBO.GetEntity(entity.AlertName); if (exist == null || exist.AlertID == null) { //nothing } else { return("预警名称已存在"); } IList <CV_PM_ALT_BASE_QuaryParam> list = new List <CV_PM_ALT_BASE_QuaryParam>(); CV_PM_ALT_BASE_QuaryParam cvAltBace = new CV_PM_ALT_BASE_QuaryParam(); entity.AlertID = Guid.NewGuid(); entity.CreatedOn = SSGlobalConfig.Now; entity.ModifiedOn = entity.CreatedOn; entity.RowDeleted = false; try { PM_ALT_BASE altBase = new PM_ALT_BASE(); altBase = pm_ALT_BASEBO.Insert(entity); cvAltBace.AlertAlias = altBase.AlertAlias; cvAltBace.AlertContent = altBase.AlertContent; cvAltBace.AlertDesc = altBase.AlertDesc; cvAltBace.AlertID = altBase.AlertID; cvAltBace.AlertInterval = altBase.AlertInterval; cvAltBace.AlertName = altBase.AlertName; cvAltBace.AlertObject = altBase.AlertObject; cvAltBace.AlertTimePoints = altBase.AlertTimePoints; cvAltBace.AlertType = altBase.AlertType; cvAltBace.Category = altBase.Category; cvAltBace.CreatedBy = altBase.CreatedBy; cvAltBace.CreatedOn = altBase.CreatedOn; cvAltBace.Format = altBase.Format; cvAltBace.IsActive = altBase.IsActive; cvAltBace.LastAlertedTime = altBase.LastAlertedTime; cvAltBace.ModifiedBy = altBase.ModifiedBy; cvAltBace.ModifiedOn = altBase.ModifiedOn; cvAltBace.PostProcedure = altBase.PostProcedure; cvAltBace.PreProcedure = altBase.PreProcedure; cvAltBace.RowDeleted = altBase.RowDeleted; cvAltBace.URL = altBase.URL; if (altBase.AlertType.ToString() == "1") { cvAltBace.alertTypeName = "邮件"; } else if (altBase.AlertType.ToString() == "2") { cvAltBace.alertTypeName = "微信"; } list.Add(cvAltBace); return("OK"); } catch (Exception ex) { return("新增异常:" + ex.Message); } }