using HH.MData;
using HH.WMS.Common;
using HH.WMS.Entitys.Basic;
using MongoDB.Bson;
using MongoDB.Driver.Builders;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace HH.WMS.DAL.Pda
{
    public class NtApiDAL : DapperBaseDAL
    {
        #region 根据卸货区获取车牌号磅单号
        public DataTable GetPoundInfoByArea(string areaCode)
        {
            string sql = @" select CN_S_POUND_NO,CN_S_CAR_NO,CN_S_ITEM_TYPE from TN_ER_CAR_POUND 
                            where CN_S_UNLOCAD_AREA_CODE = @CN_S_UNLOCAD_AREA_CODE and CN_S_STATE = '执行中' ";

            return ExecuteDataTable(sql, new { CN_S_UNLOCAD_AREA_CODE = areaCode });
        }
        #endregion

        #region 根据卸货区获取码盘笼箱信息
        public List<TrayEncodeInfo> GetEncodeTrayByArea(string areaCode)
        {
            StringBuilder sbStr = new StringBuilder();
            sbStr.Append(" select a.CN_S_TRAY_CODE,a.CN_S_LOCATION_CODE,b.CN_S_ITEM_CODE,b.CN_S_ITEM_NAME,b.CN_F_QUANTITY,b.CN_S_MEASURE_UNIT ,b.CN_S_IN_AREA_CODE from tn_wm_b_tray_location  ");
            sbStr.Append(" a inner join TN_WM_B_TRAY_ITEM_MST b on a.CN_S_TRAY_CODE = b.CN_S_TRAY_CODE inner join TN_WM_B_LOCATION_EXT c on a.CN_S_LOCATION_CODE = c.CN_S_LOCATION_CODE where a.CN_S_STOCK_AREA='" + areaCode + "' ");
            sbStr.Append(" and c.CN_S_LOCATION_STATE = '" + Constants.Location_State_Normal +"'");
            return ExecuteQuery<TrayEncodeInfo>(sbStr.ToString());
        }
        #endregion
        #region 根据卸货区获取码盘笼箱信息
        public List<TrayEncodeInfo> GetGoodByTrayCode(string trayCode)
        {
            StringBuilder sbStr = new StringBuilder();
            sbStr.Append(" select a.CN_S_TRAY_CODE,a.CN_S_ITEM_CODE,a.CN_S_ITEM_NAME,a.CN_F_QUANTITY,a.CN_S_MEASURE_UNIT,a.CN_S_IN_AREA_CODE,b.CN_S_USE_STATE from TN_WM_B_TRAY_ITEM_MST  ");
            sbStr.Append(" a inner join TN_WM_TRAY_INFO b  on a.CN_S_TRAY_CODE = b.CN_S_TRAY_CODE where a.CN_S_TRAY_CODE='" + trayCode + "' ");
            return ExecuteQuery<TrayEncodeInfo>(sbStr.ToString());
        }
        #endregion

        #region 根据大类获取该类型下的所有物料
        public List<AutoBomItemEntity> GetItemByItemClass(List<string> itemClass)
        {
            List<AutoBomItemEntity> lstItem = new List<AutoBomItemEntity>();
            //作为查询条件
            var listClass = itemClass.ConvertAll<BsonValue>(x => x);
            var query = Query.In("CN_S_MAJOR_TYPE", listClass);
            lstItem = MongoDBSingleton.Instance.Find<AutoBomItemEntity>(query, "TN_AB_ITEM");
            return lstItem;
        }
        #endregion
        #region 获取托盘中物料的信息，按批次汇总
        /// <summary>
        /// 获取托盘中物料的信息，按批次汇总
        /// </summary>
        /// <param name="trayCode">托盘号</param>
        /// <returns></returns>
        /// <History>[Hanhe(DBS)] CREATED BY 2018/12/8</History>
        public List<TrayEncodeInfo> GetTrayDetail(string trayCode)
        {
            StringBuilder sbStr = new StringBuilder();
            sbStr.Append(" select a.CN_S_ITEM_CODE,a.CN_S_ITEM_NAME,a.CN_S_MODEL,a.CN_S_MEASURE_UNIT, a.CN_F_QUANTITY  ");
            sbStr.Append(" from TN_WM_B_TRAY_ITEM_MST a inner join  TN_WM_B_TRAY_ITEM_DTL b on a.CN_GUID=b.CN_PARENT_GUID ");
            sbStr.Append("   where a.CN_S_TRAY_CODE= '" + trayCode + "' ");
            return ExecuteQuery<TrayEncodeInfo>(sbStr.ToString());
        }
        #endregion


    }
}