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