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 DALDictionary
    {
        /// <summary>
        /// 获取数据类别
        /// </summary>
        /// <returns></returns>
        public DataTable GetDictionarys()
        {
            try
            {
                StringBuilder stringBuilder = new StringBuilder();
                stringBuilder.Append("select * from Dictionary where IsDel = 0 and topCode is null;");

                DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(stringBuilder);
                return dt;
            }
            catch
            {
                throw new NotImplementedException();
            }
        }

        public IList<Dictionarys> GetDictionaryItems(Dictionarys dictionarys, ref PageInfo page) 
        {
            try
            {
                StringBuilder stringBuilder = new StringBuilder();
                stringBuilder.Append("select * from View_Dictionary_Userinfo where IsDel = 0 and TopCode is not null ");
                if (dictionarys.TopCode != null && dictionarys.TopCode != "")
                {
                    stringBuilder.Append(" and TopCode = " + dictionarys.TopCode.AddQuotes());
                }
                if (dictionarys.TypeName != null && dictionarys.TypeName != "")
                {
                    stringBuilder.Append(" and TypeName like '%" + dictionarys.TypeName + "%' ");
                }
                if (dictionarys.Guid != null && dictionarys.Guid != "") 
                {
                    stringBuilder.Append(" and Guid = " + dictionarys.Guid.AddQuotes());
                }

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

                DataTable dt = DataFactory.SqlDataBase().GetPageList(stringBuilder.ToString(), para, "TopCode", "ASC", ref page);
                IList<Dictionarys> list = ModelConvertHelper<Dictionarys>.DataTableToModel(dt);

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

        public bool SetDictionarys(Dictionarys dictionarys, string loginUser) 
        {
            try
            {
                bool bl = false;
                int rowCount = 0;
                Hashtable ht = new Hashtable();
                if (dictionarys.Guid == "")
                {
                    StringBuilder stringBuilder = new StringBuilder();
                    stringBuilder.Append("select isnull(max(Code),0)+1 from Dictionary where IsDel = 0 and TopCode =" + dictionarys.TopCode.AddQuotes());
                    if (dictionarys.TopCode == "CDStatu") 
                    {
                        stringBuilder.Append(" and code != '99';");
                    }                  
                    DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(stringBuilder);

                    ht["Code"] = dt.Rows[0][0].ToString().PadLeft(2,'0').AddQuotes();
                    ht["TypeName"] = dictionarys.TypeName.AddQuotes();
                    ht["TopCode"] = dictionarys.TopCode.AddQuotes();

                    ht["CreatUser"] = loginUser.AddQuotes();

                    rowCount = DataFactory.SqlDataBase().InsertByHashtableNullParam("Dictionary", ht);
                }
                else
                {
                    ht["TypeName"] = dictionarys.TypeName.AddQuotes();
                    ht["TopCode"] = dictionarys.TopCode.AddQuotes();

                    ht["UpdateTime"] = "convert(varchar(20),getdate(),120)";
                    ht["UpdateUser"] = loginUser.AddQuotes();

                    rowCount = DataFactory.SqlDataBase().UpdateByHashtable("Dictionary",
                        "Guid", dictionarys.Guid.AddQuotes(), ht);
                }

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

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

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

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

        public bool DelDictionarys(string[] Guids, string loginUser)
        {
            try
            {
                bool bl = false;
                int rowCount = 0;
                Hashtable ht = new Hashtable();
                foreach (string Guid in Guids)
                {
                    ht["IsDel"] = 1;
                    ht["UpdateTime"] = "convert(varchar(20),getdate(),120)";
                    ht["UpdateUser"] = loginUser.AddQuotes();
                    rowCount += DataFactory.SqlDataBase().UpdateByHashtable("Dictionary",
                            "Guid", Guid.AddQuotes(), ht);
                }

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

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