/// <summary> /// 删除多条 /// </summary> /// <param name="request"></param> /// <returns></returns> public BaseResult AppRegPersonDelMore(AppRegPersonDelMore request) { BaseResult br = new BaseResult(); using (var db = DbFactory.Open()) { try { StringBuilder sb = new StringBuilder(); //县/镇 if (!string.IsNullOrEmpty(request.countyadcd) || !string.IsNullOrEmpty(request.townadcd)) { request.AdcdIds.ForEach(w => { sb.Append("DELETE FROM AppGetReg WHERE Mobile='" + w.phone + "' AND UserName='******' AND AdcdId='" + w.adcdId + "';"); }); br.IsSuccess = db.ExecuteNonQuery(sb.ToString()) > 0 ? true : false; } else { //村 var f = db.SqlList <AppAlluserViewNODistinct>( "EXEC AppAlluserViewNODistinct @villageadcd,@year", new { villageadcd = request.villageadcd, year = request.year }); request.AdcdIds.Distinct().ToList().ForEach(w => { var fcount = f.Where(x => x.adcd == w.adcd && x.phone == w.phone && x.userName == w.username).Count(); if (fcount == 0) { sb.Append("DELETE FROM AppGetReg WHERE Mobile='" + w.phone + "' AND UserName='******' AND AdcdId='" + w.adcdId + "';"); } }); if (String.IsNullOrEmpty(sb.ToString())) { br.IsSuccess = false; return(br); } br.IsSuccess = db.ExecuteNonQuery(sb.ToString()) > 0 ? true : false; } } catch (Exception ex) { br.IsSuccess = false; br.ErrorMsg = ex.Message; } return(br); } }
public BaseResult POST(AppRegPersonDelMore request) { return(_IAppRegPersonUpdate.AppRegPersonDelMore(request)); }