public BsTableDataSource <CountryPersonServiceModel> GetCountryPersonList(GetCountryPersonList request)
{
using (var db = DbFactory.Open())
{
if (request.year == null)
{
throw new Exception("年度异常");
}
var bulider = db.From <CountryPerson>();
//搜索部分判断
if (!string.IsNullOrEmpty(request.adcd))
{
bulider.Where(x => x.adcd == request.adcd);
}
if (null != request.nums && request.nums > 1)
{
bulider.Where(x => x.AuditNums == request.nums);
}
if (!string.IsNullOrEmpty(request.Id.ToString()) && request.Id != 0)
{
bulider.And(x => x.Id == request.Id);
}
if (!string.IsNullOrEmpty(request.name))
{
bulider.And(x => x.UserName == request.name);
}
if (!string.IsNullOrEmpty(request.Position))
{
bulider.And(x => x.Position == request.Position);
}
if (!string.IsNullOrEmpty(request.Post))
{
bulider.And(x => x.Post == request.Post);
}
if (!string.IsNullOrEmpty(request.Sort) && !string.IsNullOrEmpty(request.Order) && request.Order == "asc")
{
bulider.OrderBy(x => request.Sort);
}
else if (!string.IsNullOrEmpty(request.Sort) && !string.IsNullOrEmpty(request.Order) && request.Order == "desc")
{
bulider.OrderByDescending(x => request.Sort);
}
else
{
bulider.OrderByDescending(x => x.UpdateTime);
}
bulider.And(w => w.Year == request.year);
var count = db.Count(bulider);
var PageSize = request.PageSize == 0 ? 15 : request.PageSize;
var PageIndex = request.PageIndex == 0 ? 0 : (request.PageIndex) * PageSize;
bulider.Limit(PageIndex, PageSize);
var list = db.Select <CountryPersonServiceModel>(bulider);
return(new BsTableDataSource <CountryPersonServiceModel> {
rows = list, total = count
});
}
}
public BsTableDataSource <CountryPersonServiceModel> Get(GetCountryPersonList request)
{
return(CountryPerson.GetCountryPersonList(request));
}
