using System;
using System.Collections.Generic;

using System.Data;


using MyShop.DALFactory;
using MyShop.IDAL;
using MyShop.Model;

namespace MyShop.BLL
{
    public class Announce
    {
        private IAnnounce dal = DataAccess.CreateAnnounce();

        public Announce() { }

        #region IAnnounce

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

            if (string.IsNullOrEmpty(model.Title.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 Id)
        {
            if (string.IsNullOrEmpty(Id.ToString()))
                return 0;
            string filer;
            filer = " Id =" + Id;
            return Delete(filer);
        }
        public int Update(AnnounceInfo model)
        {

            if (model == null)
            {
                return 0;
            }
            string filter;
            filter = "Id=" + model.Id;
            return Update(model, filter);
        }

        public AnnounceInfo GetModel(int  Id)
        {
            DataSet dataset = new DataSet();
            dataset = GetDataSet(" Id=" + Id);
            if (dataset.Tables[0].Rows.Count > 0)
                return GetModel(dataset.Tables[0].Rows[0]);
            return null;

        }

        #endregion


        /// <summary>
        /// 首页公告
        /// </summary>
        public DataSet GetSelectedAnnounce()
        {
            string filter;
            filter = " isSelected=1 ";
            return GetDataSet(filter);
        }

        /// <summary>
        /// 得到在有有效时间内的公告列表
        /// </summary>
        /// <returns></returns>
        public DataSet GetList()
        {
            return dal.GetList();
        }


        #region 后台管理

        public DataSet GetDataSetOrderById()
        {
            return GetDataSet(" [Id] > 0 Order by  [Id]  ");
        }


        /// <summary>
        /// 把为Id的记录改为最新公告,同时将其它记录改为不是最新公告
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public int Select(int id,bool action)
        {
            AnnounceInfo model = new AnnounceInfo();

            if (action)
            {
                string filter = " [isSelected] = 1 ";
                DataSet dataset = new DataSet();

                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.IsSelected = 0;
                        Update(model);
                    }
                }
            }

            model = GetModel(id);
            model.IsSelected = action ? 1 : 0; ;
            return Update(model);
        }

        /// <summary>
        /// 检查标题是否存在
        /// </summary>
        /// <param name="title"></param>
        /// <returns></returns>
        public bool IsExist(string title)
        {
            title = Utils.ReplaceBadSQL(title.Trim());
            if (string.IsNullOrEmpty(title))
                return false;
            string filter = " title='" + title + "'";

            return Exist(filter);
        }

        /// <summary>
        /// 快速搜索
        /// </summary>
        /// <param name="searchType"></param>
        /// <returns></returns>
        public DataSet QuickSearch(int searchType)
        {
            return dal.QuickSearch(searchType);
        }

        /// <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
    }
}