/// <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));
}
