新闻表操作类

/*
 * 创建人：李要南
 * 创建时间：2008-12-6 15: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 NewsDAL
    {
        private SQLHelper sqlhelper=null;

        public NewsDAL()
        {
            sqlhelper = new SQLHelper();
        }
        #region 选择全部新闻
        /// <summary>
        /// 选择全部新闻
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAll() {
            DataTable dt = new DataTable();
            string sql = "select * from news";
            dt = new SQLHelper().ExecuteReader(sql, CommandType.Text);
            return dt;
        }
        #endregion

        #region 取出最新10条新闻（所属分类，新闻标题，发布时间）
        /// <summary>
        /// 取出最新10条新闻（所属分类，新闻标题，发布时间）
        /// </summary>
        /// <returns></returns>
        public DataTable SelectNewNews()
        {
            DataTable dt = new SQLHelper().ExecuteReader("procNewsSeleteNewNews", CommandType.StoredProcedure);
            return dt;
        }
        #endregion

        #region 取出10条热点新闻
        /// <summary>
        /// 取出10条热点新闻
        /// </summary>
        /// <returns></returns>

        public DataTable SelectHotNews()
        {
            DataTable dt = new SQLHelper().ExecuteReader("procNewsSeleteHotNews", CommandType.StoredProcedure);
            return dt;
        }
        #endregion

        #region 根据类别ID取出该类别下的所有新闻
        /// <summary>
        /// 根据类别ID取出该类别下的所有新闻
        /// </summary>
        /// <param name="caid"></param>
        /// <returns></returns>
        public DataTable SelectByCaId(string caid)
        {
            DataTable dt = new DataTable();
            SqlParameter[] paras = new SqlParameter[]{
           new SqlParameter("@caid",caid)
           };
            dt = new SQLHelper().ExecuteReader("news_selectByCaId", paras, CommandType.StoredProcedure);
            return dt;
        }
        #endregion

        #region 根据新闻ID取出该条新闻主题内容
        /// <summary>
        /// 根据新闻ID取出该条新闻主题内容
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public News SelectById(string id)
        {
            News n = new News();
            DataTable dt = new DataTable();
            SqlParameter[] paras = new SqlParameter[]{
           new SqlParameter("@id",id)
           };
            dt = new SQLHelper().ExecuteReader("news_selectById", paras, CommandType.StoredProcedure);
            n.Id = dt.Rows[0]["id"].ToString();
            n.Title = dt.Rows[0]["title"].ToString();
            n.Content = dt.Rows[0]["content"].ToString();
            n.CreateTime = dt.Rows[0]["createTime"].ToString();
            n.CaId = dt.Rows[0]["caid"].ToString();
            return n;
        }
        #endregion

        #region 根据标题搜索新闻
        /// <summary>
        /// 根据标题搜索新闻
        /// </summary>
        /// <param name="title"></param>
        /// <returns></returns>

        public DataTable SelectByTitle(string title)
        {
            DataTable dt = new DataTable();
            SqlParameter[] para = new SqlParameter[] { new SqlParameter("@title", title) };
            dt = new SQLHelper().ExecuteReader("news_selectByTitle", para, CommandType.StoredProcedure);
            return dt;
        }
        #endregion

        #region 根据内容搜索新闻
        /// <summary>
        /// 根据内容搜索新闻
        /// </summary>
        /// <param name="content"></param>
        /// <returns></returns>

        public DataTable SelectByContent(string content)
        {
            DataTable dt = new DataTable();
            SqlParameter[] para = new SqlParameter[] { new SqlParameter("@content", content) };
            dt = new SQLHelper().ExecuteReader("news_selectByContent", para, CommandType.StoredProcedure);
            return dt;
        }
        #endregion

        #region 增加新闻
        /// <summary>
        /// 增加新闻
        /// </summary>
        /// <param name="n"></param>
        /// <returns></returns>

        public bool Insert(News n)
        {
            bool flag = false;
            string cmdText = "news_insert";
            SqlParameter[] para = new SqlParameter[] { new SqlParameter("@title",n.Title),
            new SqlParameter("@content",n.Content),new SqlParameter("@caId",n.CaId)};
            int res = new SQLHelper().ExecuteNonQuery(cmdText, para, CommandType.StoredProcedure);
            if (res > 0)
            {
                flag = true;
            }
            return flag;
        }
        #endregion

        #region 修改新闻
        /// <summary>
        /// 修改新闻
        /// </summary>
        /// <param name="n"></param>
        /// <returns></returns>

        public bool Update(News n)
        {
            bool flag = false;
            string cmdText = "news_update";
            SqlParameter[] para = new SqlParameter[] {
                new SqlParameter("@title",n.Title),
            new SqlParameter("@content",n.Content),
            new SqlParameter("@caId",n.CaId),
            new SqlParameter("@id",n.Id)};
            int res = new SQLHelper().ExecuteNonQuery(cmdText, para, CommandType.StoredProcedure);
            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 cmdText = "news_delete";
            SqlParameter[] para = new SqlParameter[] {
                new SqlParameter("@id",id)};
            int res = new SQLHelper().ExecuteNonQuery(cmdText, para, CommandType.StoredProcedure);
            if (res > 0)
            {
                flag = true;
            }
            return flag;
        }
        #endregion

    }
}

转载于:https://www.cnblogs.com/liyaonan/archive/2009/03/11/1408887.html