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