public BsTableDataSource <VillageViewModel> GetVillageTransferPersonAdcd(NoVerifyGetVillageTransferPersonAdcd request) { using (var db = DbFactory.Open()) { var year = DateTime.Now.Year; if (request.year != 0) { year = request.year; } var builder = db.From <ADCDInfo>(); builder.LeftJoin <ADCDInfo, VillageTransferPerson>((x, y) => x.adcd == y.adcd); builder.Where <ADCDInfo>(x => x.adcd.StartsWith(adcd.Substring(0, 9)) && x.adcd != adcd); if (!string.IsNullOrEmpty(request.adnm)) { builder.And(x => x.adnm.Contains(request.adnm)); } builder.SelectDistinct(x => new { x.Id, x.adcd, x.adnm }); if (request.type == 0)//0:未上报,1:已上报 { builder.And <VillageTransferPerson>(y => (y.DangerZoneName == string.Empty || y.DangerZoneName == null) && y.IfTransfer == null); } else if (request.type == 1) { builder.And <VillageTransferPerson>(y => (y.DangerZoneName != "" && y.Year == year) || (y.IfTransfer == 1 && y.Year == year)); } else if (request.type == 2) { } else { throw new Exception("上报状态不正确"); } 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 <VillageViewModel>(builder); return(new BsTableDataSource <VillageViewModel>() { total = count, rows = list }); } }
public BsTableDataSource <VillageViewModel> Get(NoVerifyGetVillageTransferPersonAdcd request) { return(NoVerifyVillageTransferPersonManager.GetVillageTransferPersonAdcd(request)); }