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 DALDepotsArea
    {
        /// <summary>
        /// 获取区域集合
        /// </summary>
        /// <param name="region"></param>
        /// <param name="page"></param>
        /// <returns></returns>
        public IList<DepotsArea> GetDepotsAreaItems(QueryDepotsArea depotsArea, ref PageInfo page)
        {
            try
            {
                StringBuilder stringBuilder = new StringBuilder();
                stringBuilder.Append("select * from View_DepotsArea_Region where IsDel = 0 ");
                if (depotsArea.DepotsCode != null && depotsArea.DepotsCode != "")
                {
                    stringBuilder.Append("and DepotsCode like '%" + depotsArea.DepotsCode + "%' ");
                }
                if (depotsArea.DepotsName != null && depotsArea.DepotsName != "")
                {
                    stringBuilder.Append("and DepotsName like '%" + depotsArea.DepotsName + "%' ");
                }
                //if (depotsArea.RegionID != null && depotsArea.RegionID != "") 
                //{
                //    stringBuilder.Append("and RegionID = " + depotsArea.RegionID.AddQuotes());
                //}

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

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

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

        public IList<DepotsArea> GetDepotsAreaItems(string Guid = "",string RegionId = "")
        {
            try
            {
                StringBuilder stringBuilder = new StringBuilder();
                stringBuilder.Append("select * from View_DepotsArea_Region where IsDel = 0 ");
                if (Guid != null && Guid != "")
                {
                    stringBuilder.Append(" and Guid = " + Guid.AddQuotes());
                }
                //if (RegionId != null && RegionId != "") 
                //{
                //    stringBuilder.Append(" and RegionID = " + RegionId.AddQuotes());
                //}

                DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(stringBuilder);
                return ModelConvertHelper<DepotsArea>.DataTableToModel(dt);
            }
            catch
            {
                throw new NotImplementedException();
            }
        }
        public IList<DepotsArea> GetDepotsAreaItems()
        {
            try
            {
                StringBuilder stringBuilder = new StringBuilder();
                stringBuilder.Append("select * from View_DepotsArea_Region where IsDel = 0 ");

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

        /// <summary>
        /// 保存区域信息
        /// </summary>
        /// <param name="region"></param>
        /// <param name="loginUser"></param>
        /// <returns>true:成功 false:失败</returns>
        public bool SetDepotsAreas(DepotsArea depotsArea, string loginUser)
        {
            try
            {
                bool bl = false;
                int rowCount = 0;
                Hashtable ht = new Hashtable();
                if (depotsArea.Guid == "")
                {
                    ht["DepotsCode"] = depotsArea.DepotsCode.AddQuotes();
                    ht["DepotsName"] = depotsArea.DepotsName.AddQuotes();
                    //ht["RegionID"] = depotsArea.RegionID.AddQuotes();
                    ht["DepotsRow"]= depotsArea.DepotsRow;
                    ht["DepotsColumn"] = depotsArea.DepotsColumn;
                    ht["DepotsLayer"] = depotsArea.DepotsLayer;
                    //ht["InStorageLocation"] = depotsArea.InStorageLocation.AddQuotes();
                    //ht["OutStorageLocation"] = depotsArea.OutStorageLocation.AddQuotes();
                    ht["Demo"] = depotsArea.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("DepotsArea", ht);
                }
                else
                {
                    ht["DepotsName"] = depotsArea.DepotsName.AddQuotes();
                    ht["Demo"] = depotsArea.Demo.AddQuotes();
                    ht["UpdateTime"] = "convert(varchar(20),getdate(),120)";
                    ht["UpdateUser"] = loginUser.AddQuotes();

                    rowCount = DataFactory.SqlDataBase().UpdateByHashtable("DepotsArea",
                        "Guid", depotsArea.Guid.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 DelDepotsAreas(string[] DepotsAreaGuids, string loginUser)
        {
            try
            {
                bool bl = false;
                int rowCount = 0;
                Hashtable ht = new Hashtable();
                foreach (string DepotsAreaGuid in DepotsAreaGuids)
                {
                    ht["IsDel"] = 1;
                    rowCount += DataFactory.SqlDataBase().UpdateByHashtable("DepotsArea",
                            "Guid", DepotsAreaGuid.AddQuotes(), ht);
                }

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

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

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

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