/// <summary> /// 获取工作组成员信息 /// </summary> /// <param name="request"></param> /// <returns></returns> public BsTableDataSource <VillageWorkingGroupViewModel> NoVerifyGetGroup(NoVerifyGetGroup request) { using (var db = DbFactory.Open()) { //if (string.IsNullOrEmpty(adcd)) //{ throw new Exception("请重新登录"); } var builder = db.From <VillageWorkingGroup>(); builder.LeftJoin <VillageWorkingGroup, ADCDInfo>((x, y) => x.VillageADCD == y.adcd); var _year = null != request.year && !string.IsNullOrEmpty(request.year.ToString()) ? request.year : System.DateTime.Now.Year; builder.Where <VillageWorkingGroup>(x => x.Year == _year && x.VillageADCD == request.adcd); if (request.nums != null && request.nums > 1) { builder.Where <VillageWorkingGroup>(w => w.AuditNums == request.nums); } builder.Select(" VillageWorkingGroup.*,ADCDInfo.adnm"); var count = db.Count(builder); if (!string.IsNullOrEmpty(request.Sort) && !string.IsNullOrEmpty(request.Order) && request.Order == "asc") { builder.OrderBy(o => request.Sort); } else if (!string.IsNullOrEmpty(request.Sort) && !string.IsNullOrEmpty(request.Order) && request.Order == "desc") { builder.OrderByDescending(o => request.Sort); } else { builder.OrderByDescending(o => o.ID); } var PageSize = request.PageSize == 0 ? 15 : request.PageSize; var PageIndex = request.PageIndex == 0 ? 0 : (request.PageIndex) * PageSize; builder.Limit(PageIndex, PageSize); var RList = db.Select <VillageWorkingGroupViewModel>(builder); return(new BsTableDataSource <VillageWorkingGroupViewModel>() { rows = RList, total = count }); } }
public BsTableDataSource <VillageWorkingGroupViewModel> GET(NoVerifyGetGroup request) { return(NoVerifyVillageWorkingGroupManage.NoVerifyGetGroup(request)); }