public BsTableDataSource <SumReadModel> GetNewSumReadUI(RouteSearcReadNewModel request)
{
using (var db = DbFactory.Open())
{
List <SumReadModel> list = new List <SumReadModel>();
if (request.IsRead)
{
list = db.SqlList <SumReadModel>("select a.ReceiveUserName,a.ReceiveUserPhone,a.Position,a.ReceiveDateTime,a.Id as MessageId,c.grade from AppSendMessage a inner join AppMobileLogin b on b.userName=a.ReceiveUserPhone left join ADCDInfo c on c.adcd = a.ReciveAdcd where a.AppWarnInfoId = '" + request.WarnInfoId + "' and a.sendAdcd='" + request.reciveAdcd + "' and a.IsReaded = 1 ");
}
else
{
list = db.SqlList <SumReadModel>("select a.ReceiveUserName,a.ReceiveUserPhone,a.Position,a.ReceiveDateTime,a.Id as MessageId,c.grade from AppSendMessage a left join ADCDInfo c on c.adcd = a.ReciveAdcd where a.AppWarnInfoId = '" + request.WarnInfoId + "' and a.sendAdcd='" + request.reciveAdcd + "' and a.IsReaded = 0 ");
}
var pageList = list.Skip(request.PageSize * (request.PageIndex - 1))
.Take(request.PageSize).OrderByDescending(x => x.ReceiveDateTime).ToList();
return(new BsTableDataSource <SumReadModel> {
total = list.Count(), rows = pageList
});
}
}
public BsTableDataSource <SumReadModel> Get(RouteSearcReadNewModel request)
{
return(sumMessage.GetNewSumReadUI(request));
}
