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 + "<li>数据不能为空</li>";
                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 = "<li>系统发生错误,请重新添加!</li>";
            if (count == 1)
                msg = "<li>添加成功!</li>";
            return count;
        }

        /// <summary>
        /// 所有类型，不区分isDisabled
        /// </summary>
        /// <param name="productKindId"></param>
        /// <returns></returns>
        public DataSet GetDataSetByProductKindId( int productKindId)
        {
            if (productKindId == 0 || string.IsNullOrEmpty(productKindId.ToString()))
                return null;
            string filter = "";
            filter = " productKindId=" + productKindId;
            return GetDataSet(filter);
        }

        /// <summary>
        /// 所有类型，筛选掉禁用的isDisabled = 1的类别,order by OrderId
        /// </summary>
        /// <param name="productKindId"></param>
        /// <returns></returns>
        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

        /// <summary>
        /// 获取当前项目ID
        /// </summary>
        public int ID
        {
            get
            {
                return this._id;
            }
        }

        /// <summary>
        ///  获取调查项目的实体
        /// </summary>
        public CategoryInfo Model
        {
            get
            {
                return GetModel(this._id);
            }
            set
            {
                Update(value);
            }
        }

        /// <summary>
        /// 获取当前对象是否存在(数据库中有没有这条记录)
        /// </summary>
        public bool isExist
        {
            get 
            {
                return Model == null ? false : true;
            }
        }

        #endregion

        #endregion


        #region 后台管理
        public DataSet GetDataSetOrderByOrderId()
        {
            return GetDataSet(" [categoryId] > 0 Order by  OrderId  ");
        }

        /// <summary>
        /// 启用或禁用
        /// </summary>
        /// <param name="productId"></param>
        /// <param name="action">true  为设置禁用 false 为设置启用</param>
        /// <returns></returns>
        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);
        }


        /// <summary>
        /// 检查名称是否存在
        /// </summary>
        /// <param name="typeName"></param>
        /// <returns></returns>
        public bool IsExist(string categoryName)
        {
            categoryName = Utils.ReplaceBadSQL(categoryName.Trim());
            if (string.IsNullOrEmpty(categoryName))
                return false;
            string filter = " [categoryName]='" + categoryName + "'";

            return Exist(filter);
        }

        /// <summary>
        /// 快速搜索
        /// </summary>
        /// <param name="productKindId"></param>
        /// <returns></returns>
        public DataSet QuickSearch(int productKindId)
        {
            DataSet ds = new DataSet();
            string filter = " [productkindId] =" + productKindId;
            return GetDataSet(filter);
        }

        /// <summary>
        /// 高级查询
        /// </summary>
        /// <param name="field"></param>
        /// <param name="keywords"></param>
        /// <returns></returns>
        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

    }
}