查询:
public static DataSet GetBlackList(List<long> idlist)
{
string sql = "select * from Apry ap where ap.id in (";
foreach (long id in idlist)
{
sql += id +",";
}
sql = sql.TrimEnd(','); //去掉结尾的逗号
sql += ")";
return DBHelper.SQLExecute(sql, null);
}
批量删除:
public static DataSet GetBlackList(List<long> idlist)
{
string sql = "delete Apry ap where ap.id in (";
foreach (long id in idlist)
{
sql += id +",";
}
sql = sql.TrimEnd(','); //去掉结尾的逗号
sql += ")";
return DBHelper.ExecuteNonQuery(sql, null);
}