public List <ADCDDisasterViewModel> NoAuthticationGetTownVillage(NoAuthticationGetTownVillage 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(NoAuthticationGetTownVillage request)
{
return(NoAuthticationAuditManager.NoAuthticationGetTownVillage(request));
}
