/// <summary> /// 获取配置信息总数 /// </summary> /// <param name="con"></param> /// <returns></returns> public int GetNotifyMessageTypeCount(NotifyMessageTypeCondition con) { const string sql = @"SELECT COUNT(0) FROM MessageTypeEnum WHERE {0}"; string trueSql = string.Format(sql, string.Join(" AND ", GetNotifyMessageTypeConditon(con).ToArray())); using (IDbConnection conn = ConnectionFactory.JinRiNotify_SELECT) { return(conn.Query <int>(trueSql, con).FirstOrDefault()); } }
/// <summary> /// 获取通知类型信息 /// </summary> /// <returns></returns> public List <NotifyMessageTypeEntity> GetNotifyMessageTypeList(NotifyMessageTypeCondition con) { const string sql = @"SELECT MessageTypeId, MessageType, Remark, MessagePriority, Status, CreateTime FROM MessageTypeEnum WHERE {0}"; string condition = string.Join(" AND ", GetNotifyMessageTypeConditon(con)); string trueSql = string.Format(sql, condition); using (IDbConnection conn = ConnectionFactory.JinRiNotify_SELECT) { return(conn.Query <NotifyMessageTypeEntity>(trueSql, con).ToList()); } }
/// <summary> /// 获取通知类型 /// </summary> /// <returns></returns> public List <NotifyMessageTypeModel> GetNotifyMessageTypeList(NotifyMessageTypeCondition con) { List <NotifyMessageTypeEntity> entityList = JinRiNotifyFacade.Instance.GetNotifyMessageTypeList(con); List <NotifyMessageTypeModel> list = new List <NotifyMessageTypeModel>(); entityList.ForEach(t => { NotifyMessageTypeModel model = MappingHelper.From <NotifyMessageTypeModel, NotifyMessageTypeEntity>(t); model.MessageTypeName = t.MessageType.ToString(); model.MessagePriorityName = t.MessagePriority.ToString(); list.Add(model); }); return(list); }
/// <summary> /// 获取通知类型 /// </summary> /// <param name="condition"></param> /// <returns></returns> public ActionResult List(NotifyMessageTypeCondition condition) { NotifyMessageBusiness business = new NotifyMessageBusiness(); var rows = business.GetNotifyMessageTypeList(condition); condition.RecordCount = business.GetNotifyMessageTypeCount(condition); var json = JsonConvert.SerializeObject(new { rows = rows, total = condition.RecordCount }, JsonConvertHelper.IsoDateTimeConverter); return(Content(json)); }
/// <summary> /// 获取通知类型(缓存) /// </summary> /// <returns></returns> public List <NotifyMessageTypeModel> GetNotifyMessageTypeListFromCache(NotifyMessageTypeCondition con) { var data = DataCache.Get(CacheKeys.NotifyMessageTypeKey) as List <NotifyMessageTypeModel>; if (data == null) { data = GetNotifyMessageTypeList(con); if (data == null) { data = new List <NotifyMessageTypeModel>(); } DataCache.Set(CacheKeys.NotifyMessageTypeKey, data, DateTime.Now.AddSeconds(CacheKeys.NotifyMessageTypeKey_TimeOut)); } return(data); }
public ActionResult Save(NotifyMessageTypeModel model, int OptType) { var message = new ReturnMessage { Success = false, Msg = "操作失败!" }; try { NotifyMessageTypeCondition condition = new NotifyMessageTypeCondition(); NotifyMessageBusiness business = new NotifyMessageBusiness(); if (OptType == 2) //新增 { var messageTypeList = business.GetNotifyMessageTypeList(condition); if (messageTypeList.Where(t => t.MessageType == model.MessageType).Count() > 0) { message.Msg = "消息类型重复!"; return(Content(JsonConvert.SerializeObject(message))); } model.CreateTime = DateTime.Now; model.Status = 2; message.Success = business.SaveNotifyMessageType(model); } else //修改 { condition.MessageTypeId = model.MessageTypeId; var messageType = business.GetNotifyMessageTypeList(condition).FirstOrDefault(); if (messageType == null) { message.Msg = "消息类型不存在!"; return(Content(JsonConvert.SerializeObject(message))); } model.Status = messageType.Status; if (OptType == 3) //删除 { model = messageType; model.Status = 3; } message.Success = business.EditNotifyMessageType(model); } } catch (Exception) { } return(Content(JsonConvert.SerializeObject(message))); }
/// <summary> /// 获取通知类型查询条件 /// </summary> /// <param name="con"></param> /// <returns></returns> private List <string> GetNotifyMessageTypeConditon(NotifyMessageTypeCondition con) { List <string> condition = new List <string>(); condition.Add(" 1=1 "); if (con != null) { if (!Null.IsNull(con.Status)) { condition.Add(" Status = @Status "); } if (!Null.IsNull(con.MessageTypeId)) { condition.Add(" MessageTypeId = @MessageTypeId "); } } return(condition); }
/// <summary> /// 获取配置信息总数 /// </summary> /// <param name="con"></param> /// <returns></returns> public int GetNotifyMessageTypeCount(NotifyMessageTypeCondition con) { return(JinRiNotifyFacade.Instance.GetNotifyMessageTypeCount(con)); }
/// <summary> /// 获取通知类型信息 /// </summary> /// <returns></returns> public List <NotifyMessageTypeEntity> GetNotifyMessageTypeList(NotifyMessageTypeCondition con) { return(JinRiNotifyQuery.Instance.GetNotifyMessageTypeList(con)); }