新闻类别表操作类

/*
 * 创建人：李要南
 * 创建时间：2008-12-5 19: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 CategoryDAL
    {
        private SQLHelper sqlhelper = null;
        public CategoryDAL()
        {
            sqlhelper = new SQLHelper();
        }

        #region 取出当前所有新闻分类
        /// <summary>
        /// 取出当前所有新闻分类
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAll()
        {
            DataTable dt = new DataTable();
            string sql = "select * from category";
            dt = sqlhelper.ExecuteReader(sql, CommandType.Text);
            return dt;
        }
        #endregion

        #region 增加类别
        /// <summary>
        /// 增加类别
        /// </summary>
        /// <param name="caName">类别名称</param>
        /// <returns></returns>
        public bool Insert(string caName)
        {
            bool flag = false;
            string sql = "insert into category values(@caName)";
            SqlParameter[] para = new SqlParameter[] {
                new SqlParameter("@caName", caName) };
            int res = sqlhelper.ExecuteNonQuery(sql, para, CommandType.Text);
            if (res > 0)
            {
                flag = true;
            }
            return flag;
        }
        #endregion

        #region 修改类别
        /// <summary>
        ///  修改类别
        /// </summary>
        /// <param name="ca"></param>
        /// <returns></returns>
        public bool Update(Category ca)
        {
            bool flag = false;
            string sql = "update category set [name]=@caName where id=@id";
            SqlParameter[] para = new SqlParameter[] { new SqlParameter("@caName", ca.Name),
            new SqlParameter("@id",ca.Id)
            };
            int res = sqlhelper.ExecuteNonQuery(sql, para, 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 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;
            bool flag = false;
            string sql = "delete category where id=@id";
            SqlParameter[] para = new SqlParameter[] {
            new SqlParameter("@id",id)
            };
            int res = sqlhelper.ExecuteNonQuery(sql, para, CommandType.Text);
            if (res > 0)
            {
                flag = true;
            }
            return flag;
        }
        #endregion

        #region 判断类别名称是否已存在
        /// <summary>
        /// 判断类别名称是否已存在
        /// </summary>
        /// <param name="caName">类别名称</param>
        /// <returns></returns>
        public bool IsExists(string caName)
        {
            bool flag = false;
            string sql = "select * from category where [name]='" + caName + "'";
            DataTable dt = sqlhelper.ExecuteReader(sql, CommandType.Text);
            if (dt.Rows.Count > 0)
            {
                flag = true;
            }
            return flag;
        }
        #endregion

    }
}