BBSCategoryFactory

BBSCategoryFactory

 

using System;
using System.Collections.Generic;
using System.Text;
using System.Diagnostics;
using System.Data.Common;
using System.Data;

using Com.Csddt.BBS.Model;
using Com.Csddt.BBS.IDAL;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Common;

namespace Com.Csddt.BBS.OracleDAL
{
    public class BBSCategoryFactory : IBBSCategory
    {
        /// <summary>
        /// 数据库连接字符串
        /// </summary>
        private Database db = DatabaseFactory.CreateDatabase("Com.Csddt.bbs.ConnectionString");

        public DataSet GetList()
        {
            string sql = @"select * from bbs_category";
            DbCommand cmd = db.GetSqlStringCommand(sql);
            return db.ExecuteDataSet(cmd);
        }
        /// <summary>
        /// 添加
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool Add(BBSCategoryEntity model)
        {
            DbCommand cmd = db.GetStoredProcCommand("proc_BBS_CATEGORY_ADD");
            db.AddInParameter(cmd, "CATEGORY_NAME_in", DbType.String, model.CATEGORY_NAME);
            db.AddInParameter(cmd, "PARENT_CATEGORY_ID_in", DbType.Int32, model.PARENT_CATEGORY_ID);
            db.AddInParameter(cmd, "TYPE_ID_in", DbType.Int32, model.TYPE_ID);
            if (db.ExecuteNonQuery(cmd) > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool Update(BBSCategoryEntity model)
        {
            DbCommand cmd = db.GetStoredProcCommand("proc_BBS_CATEGORY_Update");
            db.AddInParameter(cmd, "CATEGORY_ID_in", DbType.String, model.CATEGORY_ID);
            db.AddInParameter(cmd, "CATEGORY_NAME_in", DbType.String, model.CATEGORY_NAME);
            db.AddInParameter(cmd, "PARENT_CATEGORY_ID_in", DbType.Int32, model.PARENT_CATEGORY_ID);
            db.AddInParameter(cmd, "TYPE_ID_in", DbType.Int32, model.TYPE_ID);
            if (db.ExecuteNonQuery(cmd) > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="bbs_category_id"></param>
        /// <returns></returns>
        public bool Delete(int bbsCategoryID)
        {
            DbCommand cmd = db.GetStoredProcCommand("proc_BBS_CATEGORY_Delete");
            db.AddInParameter(cmd, "CATEGORY_ID_in", DbType.Int32, bbsCategoryID);
            if (db.ExecuteNonQuery(cmd) > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
    }
}