/// <summary> /// 删除单条记录 /// </summary> /// <param name="obj">对象</param> public int Delete(object obj) { string sql = "DELETE adctab WHERE 1=1 AND aid = @Aid"; Command db = new Command(); DbParameter[] ps = new DbParameter[1]; ps[0] = db.CreateParameter("@Aid", obj,DbType.Int32); return db.Delete(sql,ps); }
/// <summary> /// 删除多条记录【批量】 /// </summary> /// <param name="array">数组</param> public int Delete(ArrayList array) { if (array == null || array.Count == 0) throw new ArgumentNullException("array"); string sql = string.Format("DELETE adctab where aid in({0})", StringHelp.Join(array)); Command db = new Command(); return db.Delete(sql); }