using System;
using System.Collections.Generic;

using System.Data;


using MyShop.DALFactory;
using MyShop.IDAL;
using MyShop.Model;
namespace MyShop.BLL
{
    public  class DeliverType 
    {
        private IDeliverType dal = DataAccess.CreateDeliverType();

        public DeliverType() { }



        #region IDeliverType member

        public int Add(DeliverTypeInfo 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 DeliverTypeInfo 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);
        }

        public int Update(DeliverTypeInfo 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(DeliverTypeInfo model, out string msg)
        {
            msg = "";
            if (model == null)
            {
                msg = "<li>数据不能为空</li>";
                return 0;
            }

            bool isErr = false;

            if (string.IsNullOrEmpty(model.TypeName.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;
        }


        public int Delete(int typeId)
        {
            if (string.IsNullOrEmpty(typeId.ToString()))
                return 0;
            string filer;
            filer = " typeId =" + typeId;
            return Delete(filer);
        }

        /// <summary>
        /// 修改会员资料
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int Update(DeliverTypeInfo model)
        {
            if (string.IsNullOrEmpty(model.TypeId.ToString()))
                return 0;
            string filter = "typeId = " + model.TypeId;
            return Update(model, filter);
        }

        public DeliverTypeInfo GetModel(int typeId)
        {
            DataSet dataset = new DataSet();
            dataset = GetDataSet(" typeId=" + typeId);
            if (dataset != null && dataset.Tables[0].Rows.Count > 0)
                return GetModel(dataset.Tables[0].Rows[0]);
            return null;
        }

        public DeliverTypeInfo GetModel(string typeName)
        {
            if (string.IsNullOrEmpty(typeName))
                return null;
            DataSet dataset = new DataSet();
            dataset = GetDataSet(" typeName='" + typeName + "'");
            if (dataset != null && dataset.Tables[0].Rows.Count > 0)
                return GetModel(dataset.Tables[0].Rows[0]);
            return null;
        }
        #endregion

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


        /// <summary>
        /// 把为typeId的记录改为默认,同时将其它记录改为不是默认
        /// </summary>
        /// <param name="typeId"></param>
        /// <returns></returns>
        public int MakeDefault(int typeId)
        {
            string filter = " [Isdefault] = 1 ";
            DataSet dataset = new DataSet();
            DeliverTypeInfo model = new DeliverTypeInfo();

            dataset = GetDataSet(filter);
            //把其它的改为不是默认
            if (dataset.Tables[0].Rows.Count > 0)
            {
                for (int i = 0; i < dataset.Tables[0].Rows.Count; i++)
                {
                    model = GetModel(dataset.Tables[0].Rows[i]);
                    model.IsDefault = 0;
                    Update(model);
                }
            }

            model = GetModel(typeId);
            model.IsDefault = 1;
            return Update(model);
        }

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

            return Exist(filter);
        }


        #endregion

    }
}