private string GetNotifySettingCondition(NotifySettingCondition con) { List <string> conditon = new List <string>(); conditon.Add(" 1=1 "); if (!Null.IsNull(con.SettingKey)) { conditon.Add("SettingKey=@SettingKey"); } return(string.Join(" AND ", conditon.ToArray())); }
/// <summary> /// 获取AppConfig配置信息 /// </summary> /// <param name="condition"></param> /// <returns></returns> public List <NotifySettingModel> GetNotifySettingListFromCache(NotifySettingCondition condition) { var data = DataCache.Get(CacheKeys.NotifySettingCacheKey) as List <NotifySettingModel>; if (data == null) { data = GetNotifySettingList(condition); DataCache.Set(CacheKeys.NotifySettingCacheKey, data, DateTime.Now.AddSeconds(CacheKeys.NotifySettingCache_TimeOut)); } return(data); }
/// <summary> /// 获取AppConfig配置信息 /// </summary> /// <param name="condition"></param> /// <returns></returns> public List <NotifySettingEntity> GetNotifySettingList(NotifySettingCondition condition) { const string sql = @"SELECT NotifyId,SettingKey,SettingValue,Remark,Memo,ClassName,CreateTime,LastModifyTime FROM notifysetting WHERE {0}"; var _sql = string.Format(sql, GetNotifySettingCondition(condition)); using (IDbConnection conn = ConnectionFactory.JinRiNotify_SELECT) { return(conn.Query <NotifySettingEntity>(_sql, condition).ToList()); } }
public List <NotifySettingModel> GetNotifySettingList(NotifySettingCondition condition) { List <NotifySettingEntity> entityList = JinRiNotifyFacade.Instance.GetNotifySettingList(condition); List <NotifySettingModel> data = new List <NotifySettingModel>(); entityList.ForEach(t => { var model = MappingHelper.From <NotifySettingModel, NotifySettingEntity>(t); data.Add(model); }); return(data); }
public ActionResult GetNotifySetting(NotifySettingCondition condition) { NotifySettingBusiness bus = new NotifySettingBusiness(); var notifySetting = bus.GetNotifySettingList(condition).FirstOrDefault(); if (notifySetting == null) { return(new EmptyResult()); } var result = JsonConvert.DeserializeObject(notifySetting.SettingValue); return(Content(JsonConvert.SerializeObject(result))); }
public List <NotifySettingEntity> GetNotifySettingList(NotifySettingCondition condition) { return(JinRiNotifyQuery.Instance.GetNotifySettingList(condition)); }