using Commom.Utility;
using Common;
using Model;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Text;

namespace BLL.DAL
{
    public class DALRegion
    {
        /// <summary>
        /// 获取区域集合
        /// </summary>
        /// <param name="region"></param>
        /// <param name="page"></param>
        /// <returns></returns>
        public IList<Region> GetRegionItems(QueryRegion region,ref PageInfo page) 
        {
            try
            {
                StringBuilder stringBuilder = new StringBuilder();
                stringBuilder.Append("select * from View_Region_UserInfo where IsDel = 0 ");
                if (region.RegionCode != null && region.RegionCode != "") 
                {
                    stringBuilder.Append("and RegionCode like '%" + region.RegionCode + "%'");
                }
                if (region.RegionName != null && region.RegionName != "")
                {
                    stringBuilder.Append("and RegionName like '%" + region.RegionName + "%'");
                }

                SqlParam[] para = new SqlParam[]
                {
                };

                DataTable dt = DataFactory.SqlDataBase().GetPageList(stringBuilder.ToString(), para, "CreatTime", "DESC", ref page);
                IList<Region> list = ModelConvertHelper<Region>.DataTableToModel(dt);

                return list;
            }
            catch
            {
                throw new NotImplementedException();
            }
        }

        public IList<Region> GetRegionItems()
        {
            try
            {
                StringBuilder stringBuilder = new StringBuilder();
                stringBuilder.Append("select * from View_Region_UserInfo where IsDel = '0' ");

                DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(stringBuilder);
                return ModelConvertHelper<Region>.DataTableToModel(dt);
            }
            catch
            {
                throw new NotImplementedException();
            }
        }

        /// <summary>
        /// 获取指定区域信息
        /// </summary>
        /// <param name="RegionCode"></param>
        /// <returns></returns>
        public Region getRegion(string RegionCode) 
        {
            try
            {
                StringBuilder stringBuilder = new StringBuilder();
                stringBuilder.Append("select * from View_Region_UserInfo where IsDel = '0' ");
                if (RegionCode != null && RegionCode != "")
                {
                    stringBuilder.Append("and RegionCode like '%"+ RegionCode + "%' ");

                    SqlParam[] para = new SqlParam[]
                    {
                    };

                    IDataReader dt = DataFactory.SqlDataBase().GetDataReaderBySQL(stringBuilder, para);
                    return ModelConvertHelper<Region>.ReaderToModel(dt);
                }

                return null;
            }
            catch
            {
                throw new NotImplementedException();
            }
        }

        /// <summary>
        /// 保存区域信息
        /// </summary>
        /// <param name="region"></param>
        /// <param name="loginUser"></param>
        /// <returns>true:成功 false:失败</returns>
        public bool SetRegions(SetRegion region,string loginUser) 
        {
            try
            {
                bool bl = false;
                int rowCount = 0;
                Hashtable ht = new Hashtable();
                if (region.Operation == "Add")
                {
                    ht["RegionCode"] = region.RegionCode.AddQuotes();
                    ht["RegionName"] = region.RegionName.AddQuotes();
                    ht["Demo"] = region.Demo.AddQuotes();
                    ht["CreatTime"] = "convert(varchar(20),getdate(),120)";
                    ht["CreatUser"] = loginUser.AddQuotes();
                    ht["UpdateTime"] = "convert(varchar(20),getdate(),120)";
                    ht["UpdateUser"] = loginUser.AddQuotes();

                    rowCount = DataFactory.SqlDataBase().InsertByHashtableNullParam("Region", ht);
                }
                else 
                {
                    ht["RegionName"] = region.RegionName.AddQuotes();
                    ht["Demo"] = region.Demo.AddQuotes();
                    ht["UpdateTime"] = "convert(varchar(20),getdate(),120)";
                    ht["UpdateUser"] = loginUser.AddQuotes();

                    rowCount = DataFactory.SqlDataBase().UpdateByHashtable("Region", 
                        "RegionCode", region.RegionCode.AddQuotes(), ht);
                }

                if (rowCount > 0) 
                {
                    bl = true;
                }

                return bl;
            }
            catch
            {
                throw new NotImplementedException();
            }
        }

        /// <summary>
        /// 删除区域(逻辑删除)
        /// </summary>
        /// <param name="regionCodes"></param>
        /// <param name="loginUser"></param>
        /// <returns>true:成功 false:失败</returns>
        public bool DelRegions(string[] regionCodes, string loginUser) 
        {
            try
            {
                bool bl = false;
                int rowCount = 0;
                Hashtable ht = new Hashtable();
                foreach (string regionCode in regionCodes) 
                {
                    ht["IsDel"] = 1;
                    rowCount += DataFactory.SqlDataBase().UpdateByHashtable("Region",
                            "RegionCode", regionCode.AddQuotes(), ht);
                }

                if (rowCount > 0) 
                {
                    bl = true;
                }

                return bl;
            }
            catch 
            {
                throw new NotImplementedException();
            }
        }

        /// <summary>
        /// 检查是否已存在
        /// </summary>
        /// <param name="region"></param>
        /// <returns></returns>
        public bool IsExist(SetRegion region) 
        {
            try
            {
                bool bl = false;
                StringBuilder stringBuilder = new StringBuilder();
                stringBuilder.Append("select count(*) from Region where (RegionCode = "+region.RegionCode.AddQuotes());
                stringBuilder.Append(" or RegionName = " + region.RegionName.AddQuotes()+") and isDel = 0 ");
                if (region.Operation == "Edit") 
                {
                    stringBuilder.Append("and RegionCode != " + region.RegionCode.AddQuotes());
                }
                DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(stringBuilder);
                if (dt.Rows[0][0].ToString() != "0")
                {
                    bl = true;
                }

                return bl;
            }
            catch 
            {
                throw new NotImplementedException();
            }
        }
    }
}