public List <NotifyMessageModel> GetDifferentShowList(DifferentShowCondition con)
{
List <NotifyMessageEntity> list = JinRiNotifyFacade.Instance.GetDifferentShowList(con);
List <NotifyMessageModel> modelList = new List <NotifyMessageModel>();
list.ForEach((x) =>
{
modelList.Add(MappingHelper.From <NotifyMessageModel, NotifyMessageEntity>(x));
});
return(modelList);
}
public ActionResult List(DifferentShowCondition model)
{
List <NotifyMessageModel> list = m_diffBus.GetDifferentShowList(model);
var json = JsonConvert.SerializeObject(new
{
rows = list,
total = 0
}, JsonConvertHelper.IsoDateTimeConverter);
return(Content(json));
}
public List <NotifyMessageEntity> GetDifferentShowList(DifferentShowCondition con)
{
using (IDbConnection conn = ConnectionFactory.JinRiNotify_SELECT)
{
const string strSql =
@"SELECT a.MessageId, a.AppId, a.MessagePriority, a.MessageType, a.MessageKey, a.NotifyData, a.SourceFrom, a.ClientIP, a.CreateTime
FROM notifymessage a LEFT JOIN pushmessage b ON a.MessageId=b.MessageId
WHERE a.CreateTime >= @StartDate
AND a.CreateTime <= @EndDate
AND b.MessageId IS NULL";
return(conn.Query <NotifyMessageEntity>(strSql, con).ToList());
}
}
/// <summary>
/// 差异数据显示
/// </summary>
/// <param name="con"></param>
/// <returns></returns>
public List <NotifyMessageEntity> GetDifferentShowList(DifferentShowCondition con)
{
return(JinRiNotifyQuery.Instance.GetDifferentShowList(con));
}
