/// <summary>
/// 获取危险点类型列表
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public BsTableDataSource <DangerZoneViewModel> GetDangerZoneList(GetDangerZoneList request)
{
using (var db = DbFactory.Open())
{
var builder = db.From <DangerZone>();
builder.LeftJoin <DangerZone, ADCDInfo>((x, y) => x.adcd == y.adcd);
if (!string.IsNullOrEmpty(request.adcd))
{
builder.And(x => x.adcd == request.adcd);
}
if (!string.IsNullOrEmpty(request.name))
{
builder.And(x => x.DangerZoneName.Contains(request.name));
}
builder.Select <DangerZone, ADCDInfo>((x, y) => new { Id = x.Id, adcd = x.adcd, adnm = y.adnm, operateLog = x.operateLog });
var count = db.Select(builder).Count;
if (!string.IsNullOrEmpty(request.Sort) && !string.IsNullOrEmpty(request.Order) && request.Order == "asc")
{
builder.OrderBy(x => request.Sort);
}
else if (!string.IsNullOrEmpty(request.Sort) && !string.IsNullOrEmpty(request.Order) &&
request.Order == "desc")
{
builder.OrderByDescending(x => request.Sort);
}
else
{
builder.OrderBy(x => x.adcd);
}
var rows = request.PageSize == 0 ? 10 : request.PageSize;
var skip = request.PageIndex == 0 ? 0 : (request.PageIndex - 1) * rows;
builder.Limit(skip, rows);
var list = db.Select <DangerZoneViewModel>(builder);
return(new BsTableDataSource <DangerZoneViewModel>()
{
total = count, rows = list
});
}
}
public BsTableDataSource <DangerZoneViewModel> Get(GetDangerZoneList request)
{
return(DangerZoneManager.GetDangerZoneList(request));
}
