temp

//批量删除新闻记录，使用事务，返回实际删除的行数         public static int deleteNews(ArrayList idList)         {             SqlConnection conn = new SqlConnection(connStr);             conn.Open();             SqlTransaction tran = conn.BeginTransaction();             int num = 0;             try             {                 for (int i = 0; i < idList.Count; i++)                 {                     int newsid = Int32.Parse(idList[i].ToString());                     SqlParameter[] sqlPar = new SqlParameter[1];                     sqlPar[0] = new SqlParameter("@id", newsid);                     num += SqlHelper.ExecuteNonQuery(tran, CommandType.StoredProcedure, "proc_Delete_News_By_Id", sqlPar);                 }                 tran.Commit();                 return num;             }             catch             {                 tran.Rollback();                 throw;             }             finally             {                 conn.Close();             }         }