评论表操作类

/*
 * 创建人：李要南
 * 创建时间：2008-12-6 14:18
 * 说明：评论表操作类
 * 版权所有：李要南
 */
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Model;
namespace DAL
{
    /// <summary>
    /// 评论类操作类
    /// </summary>
    public class CommentDAL
    {
        private SQLHelper sqlhelper=null;
        public CommentDAL()
        {
            sqlhelper = new SQLHelper();
        }

        #region 根据新闻ID取出新闻的所有评论
        /// <summary>
        /// 根据新闻ID取出新闻的所有评论
        /// </summary>
        /// <param name="newId"></param>
        /// <returns></returns>
        public DataTable SelectByNewsId(string newId)
        {
            DataTable dt = new DataTable();
            string sql = "select * from comment where [newId]=@newId";
            SqlParameter[] paras = new SqlParameter[]
            {
                new SqlParameter("@newId",newId)
            };
            dt = sqlhelper.ExecuteReader(sql, paras, CommandType.Text);
            return dt;
        }
        #endregion

        #region 添加评论
        /// <summary>
        /// 添加评论
        /// </summary>
        /// <param name="c">评论实体类</param>
        /// <returns></returns>
        public bool Insert(Comment c)
        {
            bool flag = false;
            string sql = "insert into comment([newid],content,userip) values(@newId,@content,@userIp)";
            SqlParameter[] paras = new SqlParameter[] {
            new SqlParameter("@newId",c.NewId),
            new SqlParameter("@content",c.Content),
            new SqlParameter("@userIp",c.UserIp)
            };
            int res = sqlhelper.ExecuteNonQuery(sql, paras, CommandType.Text);
            if (res > 0)
            {
                flag = true;
            }
            return flag;
        }
        #endregion

        #region 删除评论
        /// <summary>
        /// 删除评论
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public bool Delete(string id)
        {
            bool flag = false;
            string sql = "delete from comment where id=@id";
            SqlParameter[] paras = new SqlParameter[] {
            new SqlParameter("@id",id)
            };
            int res = sqlhelper.ExecuteNonQuery(sql, paras, CommandType.Text);
            if (res > 0)
            {
                flag = true;
            }
            return flag;
        }
        #endregion

    }
}