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