public ActionResult HistoryList(NotifyMessageCondition condition)
{
NotifyMessageBusiness business = new NotifyMessageBusiness();
condition.QuerySource = 2;
var rows = business.GetNotifyMessageList(condition);
var json = JsonConvert.SerializeObject(new
{
rows = rows,
total = condition.RecordCount
}, JsonConvertHelper.IsoDateTimeConverter);
return(Content(json));
}
/// <summary>
/// 消息列表条件
/// </summary>
/// <param name="con"></param>
/// <returns></returns>
private List <string> GetNotifyMessageConditionList(NotifyMessageCondition con)
{
List <string> list = new List <string>();
list.Add(" 1=1 ");
if (con != null)
{
if (!Null.IsNull(con.AppId))
{
list.Add(" AppId = @AppId ");
}
if (!Null.IsNull(con.MessageType))
{
list.Add(" MessageType = @MessageType ");
}
if (!string.IsNullOrWhiteSpace(con.MessageKey))
{
if (con.MessageKey.Length <= 20)
{
list.Add(" MessageKey = @MessageKey ");
}
else
{
list.Add(" MessageKey LIKE CONCAT(@MessageKey, '%') ");
}
}
if (!Null.IsNull(con.SCreateTime))
{
list.Add(" CreateTime >= '" + con.SCreateTime + "' ");
}
if (!Null.IsNull(con.ECreateTime))
{
list.Add(" CreateTime <= '" + con.ECreateTime + "' ");
}
if (!Null.IsNull(con.MessagePriority))
{
list.Add(" MessagePriority = @MessagePriority ");
}
if (!Null.IsNull(con.MessageId))
{
list.Add(" MessageId = @MessageId ");
}
}
return(list);
}
/// <summary>
/// 获取请求消息列表（分页）
/// </summary>
/// <param name="con"></param>
/// <returns></returns>
public List <NotifyMessageEntity> GetNotifyMessageList(NotifyMessageCondition con)
{
using (IDbConnection conn = ConnectionFactory.JinRiNotify_SELECT)
{
const string sql =
@"SELECT * FROM
(SELECT MessageId, AppId, MessagePriority, MessageKey, MessageType, NotifyData, SourceFrom, ClientIP, CreateTime
FROM {3}
WHERE {2}
ORDER BY {0} {1}
LIMIT @Offset, @PageSize) AS TMP ";
string table = con.QuerySource == 2 ? "NotifyMessage_backup" : "NotifyMessage";
string condition = string.Join(" AND ", GetNotifyMessageConditionList(con).ToArray());
string _sql = string.Format("SELECT COUNT(0) FROM {1} WHERE {0}", condition, table);
con.RecordCount = conn.Query <int>(_sql, con).FirstOrDefault(); //总记录数
string trueSql = string.Format(sql, con.OrderBy, con.OrderDirection, condition, table);
return(conn.Query <NotifyMessageEntity>(trueSql, con).ToList());
}
}
/// <summary>
/// 获取请求消息列表（分页）
/// </summary>
/// <param name="con"></param>
/// <returns></returns>
public List <NotifyMessageModel> GetNotifyMessageList(NotifyMessageCondition con)
{
NotifyMessageBusiness business = new NotifyMessageBusiness();
var messageTypeList = business.GetNotifyMessageTypeListFromCache(new NotifyMessageTypeCondition());
List <NotifyMessageEntity> entityList = JinRiNotifyFacade.Instance.GetNotifyMessageList(con);
List <NotifyMessageModel> list = new List <NotifyMessageModel>();
entityList.ForEach(x =>
{
var model = MappingHelper.From <NotifyMessageModel, NotifyMessageEntity>(x);
var messageType = messageTypeList.Where(t => t.MessageType.ToString().Equals(model.MessageType, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
if (messageType != null)
{
model.MessageTypeCName = messageType.Remark;
}
list.Add(model);
});
return(list);
}
/// <summary>
/// 获取请求消息列表（分页）
/// </summary>
/// <param name="con"></param>
/// <returns></returns>
public List <NotifyMessageEntity> GetNotifyMessageList(NotifyMessageCondition con)
{
return(JinRiNotifyQuery.Instance.GetNotifyMessageList(con));
}
