public List <ADCDDisasterViewModel> GetTownVillage(GetTownVillage request) { if (string.IsNullOrEmpty(request.adcd)) { throw new Exception("adcd不能为空"); } using (var db = DbFactory.Open()) { //var builder = db.From<ADCDInfo>(); var sql = ""; if (string.IsNullOrEmpty(request.adnm)) { // builder.Join<ADCDInfo, ADCDDisasterInfo>((x,y)=> x.adcd.Contains(request.adcd.Substring(0, 9)) && x.adcd != request.adcd && x.adcd == y.adcd); sql = "select ADCDInfo.id,ADCDInfo.adcd,ADCDInfo.adnm, ADCDDisasterInfo.TotalNum,c.householderNum as PopulationNum,ADCDDisasterInfo.FXFTRW " + "from ADCDInfo left join ADCDDisasterInfo on ADCDInfo.adcd = ADCDDisasterInfo.adcd left join (select sum(householderNum) as householderNum, adcd from VillageTransferPerson group by adcd) as C on ADCDInfo.adcd = c.adcd " + "where ADCDInfo.adcd LIKE '%" + request.adcd.Substring(0, 9) + "%' AND ADCDInfo.adcd != '" + request.adcd + "' "; } if (!string.IsNullOrEmpty(request.adnm)) { //sql = "select ADCDInfo.id,ADCDInfo.adcd,ADCDInfo.adnm, ADCDDisasterInfo.TotalNum,c.householderNum as PopulationNum,ADCDDisasterInfo.FXFTRW " // + "from ADCDInfo, ADCDDisasterInfo,(select sum(householderNum) as householderNum, adcd from VillageTransferPerson group by adcd) as C " // + "where ADCDInfo.adcd LIKE '%" + request.adcd.Substring(0, 9) + "%' AND ADCDInfo.adnm like '%" + request.adnm + "%' AND ADCDInfo.adcd != '" + request.adcd + "' AND ADCDInfo.adcd = ADCDDisasterInfo.adcd AND ADCDInfo.adcd = c.adcd"; sql = "select ADCDInfo.id,ADCDInfo.adcd,ADCDInfo.adnm, ADCDDisasterInfo.TotalNum,c.householderNum as PopulationNum,ADCDDisasterInfo.FXFTRW " + " from ADCDInfo left join ADCDDisasterInfo on ADCDInfo.adcd = ADCDDisasterInfo.adcd left join (select sum(householderNum) as householderNum, adcd from VillageTransferPerson group by adcd) as C on ADCDInfo.adcd = c.adcd" + " where ADCDInfo.adcd LIKE '%" + request.adcd.Substring(0, 9) + "%' AND ADCDInfo.adnm like '%" + request.adnm + "%' AND ADCDInfo.adcd != '" + request.adcd + "' "; } var list = db.Select <ADCDDisasterViewModel>(sql); return(list); } }
public List <ADCDDisasterViewModel> GET(GetTownVillage request) { return(AuditManager.GetTownVillage(request)); }