www.pudn.com > MyShop.rar > Category.cs


using System; 
using System.Collections.Generic; 
 
using System.Data; 
 
 
using MyShop.DALFactory; 
using MyShop.IDAL; 
using MyShop.Model; 
 
namespace MyShop.BLL 
{ 
    public class Category 
    { 
        private ICategory dal = DataAccess.CreateCategory(); 
        private int _id; 
 
        public Category() 
        { 
 
        } 
 
        public Category(int id) 
        { 
            this._id = id; 
        } 
 
        #region ICategory member 
 
        protected int Add(CategoryInfo model) 
        { 
            if (model == null) 
                return 0; 
            return dal.Add(model); 
        } 
        public int Delete(string filter) 
        { 
            if (string.IsNullOrEmpty(filter)) 
                return 0; 
            return dal.Delete(filter); 
        } 
 
        public bool Exist(string filter) 
        { 
            filter = filter.Trim(); 
            if (string.IsNullOrEmpty(filter)) 
                return false; 
            return dal.Exist(filter); 
        } 
 
        public DataSet GetDataSet() 
        { 
            return dal.GetDataSet(); 
        } 
        public DataSet GetDataSet(string filter) 
        { 
            filter = filter.Trim(); 
            if (string.IsNullOrEmpty(filter)) 
                return null; 
            return dal.GetDataSet(filter); 
        } 
        public DataSet GetDataSet(int categoryId) 
        { 
            if (categoryId <= 0) 
                return null; 
            string filter = " categoryId=" + categoryId; 
            return GetDataSet(filter); 
        } 
        public CategoryInfo GetModel(DataRow dr) 
        { 
            if (dr == null) 
                return null; 
            return dal.GetModel(dr); 
        } 
 
        private DataSet Query(string sql) 
        { 
            sql = sql.Trim(); 
            if (string.IsNullOrEmpty(sql)) 
                return null; 
            return dal.Query(sql); 
        } 
 
        protected int Update(CategoryInfo model, string filter) 
        { 
            if (model == null) 
                return 0; 
            filter = filter.Trim(); 
            if (string.IsNullOrEmpty(filter)) 
                return 0; 
            return dal.Update(model, filter); 
        } 
        //------------------------- 
        #endregion 
 
        #region common 
 
        public int Add(CategoryInfo model, out string msg) 
        { 
            msg = ""; 
            if (model == null) 
            { 
                msg = msg + "
  • 数据不能为空
    • "; 
                return 0; 
            } 
 
            bool isErr = false; 
 
            if (string.IsNullOrEmpty(model.CategoryName.Trim())) 
            { 
                msg = msg + "请输入商品小类名称"; 
                isErr = true; 
            } 
 
            if (isErr) 
                return 0; 
 
            int count = 0; 
            count = Add(model); 
            if (count == 0) 
                msg = "
  • 系统发生错误,请重新添加!
    • "; 
            if (count == 1) 
                msg = "
  • 添加成功!
    • "; 
            return count; 
        } 
 
        ///  
        /// 所有类型，不区分isDisabled 
        ///  
        ///  
        ///  
        public DataSet GetDataSetByProductKindId( int productKindId) 
        { 
            if (productKindId == 0 || string.IsNullOrEmpty(productKindId.ToString())) 
                return null; 
            string filter = ""; 
            filter = " productKindId=" + productKindId; 
            return GetDataSet(filter); 
        } 
 
        ///  
        /// 所有类型，筛选掉禁用的isDisabled = 1的类别,order by OrderId 
        ///  
        ///  
        ///  
        public DataSet GetDataSetByProductKindIdEnabled(int productKindId) 
        { 
            string filter = ""; 
            filter = " [isDisabled] = 0 and productKindId=" + productKindId + " order by OrderId "; 
            return GetDataSet(filter); 
        } 
 
        public int Delete(int categoryId) 
        { 
            if (string.IsNullOrEmpty(categoryId.ToString())) 
                return 0; 
            string filer; 
            filer = " categoryId =" + categoryId; 
            return Delete(filer); 
        } 
        public int Update(CategoryInfo model) 
        { 
 
            if (model == null) 
            { 
                return 0; 
            } 
            string filter; 
            filter = " categoryId=" + model.CategoryId; 
            return Update(model, filter); 
        } 
 
        public CategoryInfo GetModel(int categoryId) 
        { 
             
            DataSet dataset = new DataSet(); 
            dataset = GetDataSet(" categoryId=" + categoryId); 
            if (dataset != null && dataset.Tables[0].Rows.Count > 0) 
                return GetModel(dataset.Tables[0].Rows[0]); 
           return null; 
 
        } 
        #endregion     
 
        #region 以下过程要用Category category = new Category(id)实例化后才能进行调用 
 
 
        #region property 
 
        ///  
        /// 获取当前项目ID 
        ///  
        public int ID 
        { 
            get 
            { 
                return this._id; 
            } 
        } 
 
        ///  
        ///  获取调查项目的实体 
        ///  
        public CategoryInfo Model 
        { 
            get 
            { 
                return GetModel(this._id); 
            } 
            set 
            { 
                Update(value); 
            } 
        } 
 
        ///  
        /// 获取当前对象是否存在(数据库中有没有这条记录) 
        ///  
        public bool isExist 
        { 
            get  
            { 
                return Model == null ? false : true; 
            } 
        } 
 
        #endregion 
 
        #endregion 
 
 
        #region 后台管理 
        public DataSet GetDataSetOrderByOrderId() 
        { 
            return GetDataSet(" [categoryId] > 0 Order by  OrderId  "); 
        } 
 
        ///  
        /// 启用或禁用 
        ///  
        ///  
        /// true  为设置禁用 false 为设置启用 
        ///  
        public int Disable(int categoryId, bool action) 
        { 
            CategoryInfo model = new  CategoryInfo(); 
            model = GetModel(categoryId); 
            if (model == null) 
                return 0; 
 
            model.IsDisabled = (action == true) ? 1 : 0; 
            return Update(model); 
        } 
 
 
        ///  
        /// 检查名称是否存在 
        ///  
        ///  
        ///  
        public bool IsExist(string categoryName) 
        { 
            categoryName = Utils.ReplaceBadSQL(categoryName.Trim()); 
            if (string.IsNullOrEmpty(categoryName)) 
                return false; 
            string filter = " [categoryName]='" + categoryName + "'"; 
 
            return Exist(filter); 
        } 
 
        ///  
        /// 快速搜索 
        ///  
        ///  
        ///  
        public DataSet QuickSearch(int productKindId) 
        { 
            DataSet ds = new DataSet(); 
            string filter = " [productkindId] =" + productKindId; 
            return GetDataSet(filter); 
        } 
 
        ///  
        /// 高级查询 
        ///  
        ///  
        ///  
        ///  
        public DataSet KeywordsSearch(string field, string keywords) 
        { 
            field = Utils.ReplaceBadSQL(field.Trim().ToLower()); 
            keywords = Utils.ReplaceBadSQL(keywords.ToLower().Trim()); 
            if (string.IsNullOrEmpty(field) || string.IsNullOrEmpty(keywords)) 
                return null; 
            return dal.KeywordsSearch(field, keywords); 
        } 
 
 
        #endregion 
 
    } 
}