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

namespace HH.WMS.BLL.Basic
{
    public class TN_WMS_ITEMBLL : BaseBLL
    {
        #region 根据物料编码获取物料实体信息(访问MongoDB)
        /// <summary>
        /// 根据物料编码获取物料实体信息(访问MongoDB)
        /// </summary>
        /// <param name="itemCode">物料编码</param>
        /// <returns></returns>
        /// <History>[Hanhe(DBS)] created 2018-5-5</History>
        public AutoBomItemEntity GetItem(string itemCode)
        {
            return CreateDAL<TN_WMS_ITEMDAL>().GetItemEntity(itemCode);
        }
        public AutoBomItemEntityYS GetItemYS(string itemCode)
        {
            return CreateDAL<TN_WMS_ITEMDAL>().GetItemEntityYS(itemCode);
        }

        public List<AutoBomItemEntity> GetItemByNameSpec(string itemName, string specification)
        {
            return CreateDAL<TN_WMS_ITEMDAL>().GetItemByNameSpec(itemName, specification);
        }
        /// <summary>
        /// 根据物料编码返回物料实体
        /// </summary>
        /// <param name="itemCode"></param>
        /// <returns></returns>
        public List<AutoBomItemEntity> GetItemList(List<string> itemCodes)
        {
            return CreateDAL<TN_WMS_ITEMDAL>().GetItemList(itemCodes);
        }

        /// <summary>
        /// 根据物料编码返回物料实体
        /// </summary>
        /// <param name="itemCode"></param>
        /// <returns></returns>
        public List<AutoBomItemEntity> GetAllItem(string itemCode)
        {
            return CreateDAL<TN_WMS_ITEMDAL>().GetAllItem(itemCode);
        }
        /// <summary>
        /// 根据物料编码返回物料实体
        /// </summary>
        /// <param name="itemCode"></param>
        /// <returns></returns>
        ///  <history>[HanHe(LT)] CREATED 2018/11/26</history>
        public List<AutoBomItemEntity> GetListItemByCode(string itemCode, string itemName, string model, int pageIndex, int pageSize, out int total)
        {
            return CreateDAL<TN_WMS_ITEMDAL>().GetListItemByCode(itemCode, itemName, model, pageIndex, pageSize, out total);
        }
        #endregion

        #region 物料列表
        /// <summary>
        /// 物料列表
        /// </summary>
        /// <returns></returns>
        public List<AutoBomItemEntity> GetItemList(SearchModel searchModel, out int total)
        {
            return CreateDAL<TN_WMS_ITEMDAL>().GetItemList(searchModel, out total);
        }
        #endregion

        #region 模糊匹配top条
        /// <summary>
        /// 模糊匹配top条
        /// </summary>
        /// <param name="key"></param>
        /// <param name="top"></param>
        /// <returns></returns>
        public List<AutoBomItemEntity> GetMatchItem(string key, int top = 10)
        {
            return CreateDAL<TN_WMS_ITEMDAL>().GetMatchItem(key, top);
        }
        #endregion

        public TN_AB_B_ITEM_PRICEEntity GetItemPriceModel(string itemCode)
        {
            TN_AB_B_ITEM_PRICEEntity entity = CreateDAL<TN_WMS_ITEMDAL>().GetItemPriceModel(itemCode);
            //if (entity == null)
            //{

            //}

            return entity;
        }

        public OperateResult GetItemDetail(string scanCode, string codeType)
        {
            string sqlWhere = "";//where条件
            string itemCode = "";//物料编码
            MONGO_PRINT_BARCODE printEntity = new MONGO_PRINT_BARCODE();
            if (codeType == "0") //不限制
            {
                sqlWhere += "and CN_S_ITEM_CODE ='{0}' OR CN_S_SERIAL_NO='{0}' OR CN_S_PACKING_CODE='{0}'";
                printEntity = CreateDAL<MONGO_PRINT_BARCODEDAL>().GetLikeValue(scanCode);

            }
            else if (codeType == "1")
            {
                itemCode = scanCode;
            }
            else if (codeType == "2")
            {
                printEntity = CreateDAL<MONGO_PRINT_BARCODEDAL>().GetFieldValue("CN_S_SERIAL_NO", scanCode);
            }
            else if (codeType == "3")
            {
                printEntity = CreateDAL<MONGO_PRINT_BARCODEDAL>().GetFieldValue("CN_S_UNIQUE_CODE", scanCode);
            }
            if (codeType != "1" && !string.IsNullOrEmpty(codeType))
            {
                itemCode = printEntity.CN_S_ITEM_CODE;
            }
            AutoBomItemEntity itemEnity = BLLCreator.Create<TN_WMS_ITEMBLL>().GetItem(itemCode);
            return OperateResult.Succeed("", itemEnity);

        }
    }
}