using HH.WMS.DAL.Algorithm;
using HH.WMS.DAL.Common;
using HH.WMS.DAL.MoveStock;
using HH.WMS.Entitys.Algorithm;
using HH.WMS.Entitys.Basic;
using HH.WMS.Entitys.Common;
using HH.WMS.Entitys.MoveStock;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace HH.WMS.BLL.MoveStock
{
    public class TN_WM_MOVE_DTLBLL : DapperBaseBLL
    {
        #region 获取分页列表
        /// <summary>
        /// 获取分页列表
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        /// <history>[HanHe(lt)] CREATED 2018/9/11</history>
        public DataTable GetDataTable(dynamic obj)
        {
            return CreateDAL<TN_WM_MOVE_DTLDAL>().GetDataTable(obj);
        }

        /// <summary>
        /// 获取列表
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        /// <history>[HanHe(lt)] CREATED 2018/10/9</history>
        public DataTable getInfo(string sqlWhere)
        {
            return CreateDAL<TN_WM_MOVE_DTLDAL>().getInfo(sqlWhere);
        }
        #endregion

        #region 新增
        /// <summary>
        /// 增加一条数据
        /// </summary>
        /// <history>[HanHe(lt)] CREATED 2018/9/10</history>
        public SqlExecuteResult Add(TN_WM_MOVE_DTLEntity entity)
        {
            return CreateDAL<TN_WM_MOVE_DTLDAL>().Add(entity, null);
        }


        #endregion

        #region 修改
        /// <summary>
        /// 增加一条数据
        /// </summary>
        /// <history>[HanHe(lt)] CREATED 2018/9/11</history>
        public SqlExecuteResult Update(TN_WM_MOVE_DTLEntity entity)
        {
            return CreateDAL<TN_WM_MOVE_DTLDAL>().Update(entity, null);
        }
        #endregion

        #region 删除
        /// <summary>
        /// 删除一条数据
        /// </summary>
        /// <history>[HanHe(lt)] CREATED 2018/9/10</history>
        public SqlExecuteResult Delete(string sqlwhere)
        {
            return CreateDAL<TN_WM_MOVE_DTLDAL>().Delete(sqlwhere, null);
        }
        #endregion

        #region 修改查询移库明细
        /// <summary>
        /// 修改查询移库明细
        /// </summary>
        /// <history>[HanHe(lt)] CREATED 2018/9/19</history>
        public DataTable GetDtl(string sqlwhere)
        {
            DataTable dt = CreateDAL<TN_WM_MOVE_DTLDAL>().GetDtl(sqlwhere);
            Dictionary<string, string> stockDic = new Dictionary<string, string>();
            Dictionary<string, string> areaDic = new Dictionary<string, string>();
            dt.Columns.Add("CN_S_STOCK_NAME");
            dt.Columns.Add("CN_S_AREA_NAME");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (!string.IsNullOrEmpty(dt.Rows[i]["CN_S_STOCK_CODE"].ToString())) //获取仓库名称
                {
                    if (!stockDic.ContainsKey(dt.Rows[i]["CN_S_STOCK_CODE"].ToString()))
                    {
                        TN_AB_STOCKEntity stockentity = CreateDAL<TN_WM_MONGODAL>().GetStockentity("CN_S_STOCK_CODE", dt.Rows[i]["CN_S_STOCK_CODE"].ToString());//获取仓库名称
                        if (stockentity != null)
                        {
                            dt.Rows[i]["CN_S_STOCK_NAME"] = stockentity.CN_S_STOCK_NAME;
                            stockDic.Add(dt.Rows[i]["CN_S_STOCK_CODE"].ToString(), stockentity.CN_S_STOCK_NAME);
                        }
                    }
                    else
                    {
                        dt.Rows[i]["CN_S_STOCK_NAME"] = stockDic[dt.Rows[i]["CN_S_STOCK_CODE"].ToString()];
                    }
                }
                if (!string.IsNullOrEmpty(dt.Rows[i]["CN_S_STOCK_AREA"].ToString()))//获取库区名称
                {
                    if (!areaDic.ContainsKey(dt.Rows[i]["CN_S_STOCK_AREA"].ToString()))
                    {
                        AutoBomStockAreaEntity areaentity = CreateDAL<TN_WMS_AREADAL>().GetModel(dt.Rows[i]["CN_S_STOCK_AREA"].ToString());//获取库区名称
                        if (areaentity != null)
                        {
                            dt.Rows[i]["CN_S_AREA_NAME"] = areaentity.CN_S_AREA_NAME;
                            areaDic.Add(dt.Rows[i]["CN_S_STOCK_AREA"].ToString(), areaentity.CN_S_AREA_NAME);
                        }
                    }
                    else
                    {
                        dt.Rows[i]["CN_S_AREA_NAME"] = areaDic[dt.Rows[i]["CN_S_STOCK_AREA"].ToString()];
                    }
                }
            }

            return dt;
        }
        #endregion
    }
}