/// <summary>
/// 获取大事件的列表
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public BsTableDataSource <AppSumEventModel> GetSumEventUI(RouteSearchEventModel request)
{
using (var db = DbFactory.Open())
{
string role = AdcdHelper.GetByAdcdRole(adcd);
var whereLamda = db.From <AppWarnEvent>();
whereLamda.LeftJoin <AppWarnEvent, ADCDInfo>((x, y) => x.adcd == y.adcd);
if (role == "省级")
{
if (request.CityAdcd == null)
{
whereLamda.And(x => x.adcd.StartsWith("33"));
}
else
{
whereLamda.And(x => x.adcd.StartsWith(request.CityAdcd.Substring(0, 4)));
}
}
if (role == "市级")
{
whereLamda.And(x => x.adcd.StartsWith(adcd.Substring(0, 4)));
}
if (role == "县级")
{
whereLamda.And(x => x.adcd.StartsWith(adcd.Substring(0, 6)));
}
if (role == "镇级")
{
whereLamda.And(x => x.adcd == adcd);
}
if (request.CountryAdcd != null)
{
whereLamda.And(x => x.adcd == request.CountryAdcd);
}
whereLamda.And(x => x.StartTime >= Convert.ToDateTime(DateTime.Now.ToString("yyyy-01-01")));
if (!string.IsNullOrEmpty(request.EventName))
{
whereLamda.And(x => x.EventName.Contains(request.EventName));
}
whereLamda.OrderByDescending(x => x.StartTime);
var total = db.Count(whereLamda);
var PageSize = request.PageSize == 0 ? 15 : request.PageSize;
var PageIndex = request.PageIndex == 0 ? 0 : (request.PageIndex) * PageSize;
whereLamda.Limit(PageIndex, PageSize);
var list = db.Select <AppSumEventModel>(whereLamda);
return(new BsTableDataSource <AppSumEventModel> {
total = total, rows = list
});
}
}
public BsTableDataSource <AppSumEventModel> Get(RouteSearchEventModel request)
{
return(sumMessage.GetSumEventUI(request));
}
/// <summary>
/// 获取大事件的列表
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public BsTableDataSource <AppSumEventModel> GetSumEventUI(RouteSearchEventModel request)
{
using (var db = DbFactory.Open())
{
string role = AdcdHelper.GetByAdcdRole(adcd);
List <AppSumTownModel> townList = db.SqlList <AppSumTownModel>("select a.SendMessageByUserName,a.ReceiveDateTime,a.SendMessage, a.AppWarnEventId, b.adnm, b.adcd from AppSendMessage a left join ADCDInfo b on a.SendAdcd = b.adcd where a.SendAdcd = '" + adcd + "' and a.SendMessagePhone = a.ReceiveUserPhone ");
var whereLamda = db.From <AppWarnEvent>();
whereLamda.LeftJoin <AppWarnEvent, ADCDInfo>((x, y) => x.adcd == y.adcd);
if (role == "省级")
{
if (request.CityAdcd == null)
{
whereLamda.And(x => x.adcd.StartsWith("33"));
}
else
{
whereLamda.And(x => x.adcd.StartsWith(request.CityAdcd.Substring(0, 4)));
}
}
if (role == "市级")
{
whereLamda.And(x => x.adcd.StartsWith(adcd.Substring(0, 4)));
}
if (role == "县级")
{
whereLamda.And(x => x.adcd.StartsWith(adcd.Substring(0, 6)));
}
if (request.CountryAdcd != null)
{
whereLamda.And(x => x.adcd == request.CountryAdcd);
}
//whereLamda.And(x => x.StartTime>=Convert.ToDateTime(DateTime.Now.ToString("yyyy-01-01")));
if (!string.IsNullOrEmpty(request.EventName))
{
whereLamda.And(x => x.EventName.Contains(request.EventName));
}
whereLamda.OrderByDescending(x => x.StartTime);
var total = db.Count(whereLamda);
var townTotal = townList.Count();
var PageSize = request.PageSize == 0 ? 15 : request.PageSize;
var PageIndex = request.PageIndex == 0 ? 0 : (request.PageIndex) * PageSize;
whereLamda.Limit(PageIndex, PageSize);
townList.Skip(PageSize * (PageIndex - 1)).Take(PageSize);
var list = db.Select <AppSumEventModel>(whereLamda);
if (role == "镇级")
{
total = townTotal;
list = new List <AppSumEventModel>();
if (!string.IsNullOrEmpty(request.EventName))
{
townList = townList.FindAll(x => x.sendMessage.Contains(request.EventName));
}
foreach (var item in townList)
{
AppSumEventModel model = new AppSumEventModel();
model.Id = item.appWarnEventId;
model.adcd = item.adcd;
model.adnm = item.adnm;
model.EventName = item.sendMessage;
model.StartTime = item.receiveDateTime;
model.UserName = item.sendMessageByUserName;
list.Add(model);
}
}
return(new BsTableDataSource <AppSumEventModel> {
total = total, rows = list
});
}
}
