using HH.WMS.Common;
using HH.WMS.Common.External;
using HH.WMS.Entitys;
using HH.WMS.Entitys.ERP;
using HH.WMS.Entitys.MoveStock;
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace HH.WMS.DAL.ERP
{
    public class MiddleLibraryDAL : ErpDapperBaseDAL
    {
        /// <summary>
        /// 获取车牌档案
        /// </summary>
        /// <param name="carNo"></param>
        /// <returns></returns>
        public TN_CAR_INFOEntity GetCarInfo(string carNo)
        {
            return DALCreator.CreateErp<ErpDapperDAL<TN_CAR_INFOEntity>>().GetSingleEntity(new { CN_S_CAR_NO = carNo });
        }

        /// <summary>
        /// 获取大磅单
        /// </summary>
        /// <param name="poundNo"></param>
        /// <returns></returns>
        public TN_ER_CAR_POUNDEntity GetCarPound(string poundNo)
        {
            return DALCreator.CreateErp<ErpDapperDAL<TN_ER_CAR_POUNDEntity>>().GetSingleEntity(new { CN_S_POUND_NO = poundNo });
        }

        public List<TN_SYS_MATERIAL_STOCKOUTEntity> GetMaterialStockOut(string itemCode, string produceLine)
        {
            return DALCreator.CreateErp<ErpDapperDAL<TN_SYS_MATERIAL_STOCKOUTEntity>>().GetList(new
            {
                CN_S_ITEM_CODE = itemCode,
                CN_S_LINE = produceLine,
                CN_S_STATE = "开工"
            }, " ORDER BY CN_DT_CREATE ");
        }

        public List<TN_SYS_MATERIAL_STOCKOUTEntity> GetMaterialStockOut(string produceLine)
        {
            return DALCreator.CreateErp<ErpDapperDAL<TN_SYS_MATERIAL_STOCKOUTEntity>>().GetList(new
            {
                CN_S_LINE = produceLine,
                CN_S_STATE = "开工"
            }, " ORDER BY CN_DT_CREATE ");
        }

        #region ADD

        public OperateResult AddCarPound(TN_ER_CAR_POUNDEntity carPound, LogPara logPara, IDbTransaction trans)
        {
            var sysPound = new TN_SYS_POUNDEntity
            {
                CN_S_POUND_NO = carPound.CN_S_POUND_NO,
                CN_S_CAR_NO = carPound.CN_S_CAR_NO,
                CN_F_WEIGHT = carPound.CN_F_WEIGHT,
                CN_DT_WEIGHT = carPound.CN_T_ARRIVE,
                CN_S_ITEM_TYPE = carPound.CN_S_ITEM_TYPE,
                CN_DT_OPERATION = carPound.CN_T_CREATE,
                CN_S_OP_FROM = "",
                CN_DT_CREATE = carPound.CN_T_CREATE,
                CN_S_CREATOR = "",
                CN_F_CAR_WEIGHT = carPound.CN_F_CAR_WEIGHT,
                CN_DT_CAR_WEIGHT = carPound.CN_T_OUT,
                CN_S_VENDOR_NO = carPound.CN_S_VENDOR_NO,
                CN_S_STOCK_CODE = carPound.CN_S_STOCK_CODE,
                SynchroFlag = 0
            };
            Log.Detail(logPara, "保存数据:" + JsonConvert.SerializeObject(sysPound));
            return DALCreator.CreateErp<ErpDapperDAL<TN_SYS_POUNDEntity>>().Add(sysPound, logPara, trans);
        }

        public OperateResult AddMaterialStockIn(TN_SYS_MATERIAL_STOCKIN_DTLEntity materialStockInDtl, LogPara logPara, IDbTransaction trans)
        {
            Log.Detail(logPara, "添加参数：" + JsonConvert.SerializeObject(materialStockInDtl));
            var result = DALCreator.CreateErp<ErpDapperDAL<TN_SYS_MATERIAL_STOCKIN_DTLEntity>>().Add(materialStockInDtl, logPara, trans);
            Log.Detail(logPara, "向中间库同步小磅单结果：" + JsonConvert.SerializeObject(result));
            return result;
        }

        public OperateResult AddMaterialStockOut(TN_SYS_MATERIAL_STOCKOUT_DTLEntity materialStockOutDtl, LogPara logPara)
        {
            Log.Detail(logPara, "添加参数：" + JsonConvert.SerializeObject(materialStockOutDtl));
            var result = DALCreator.CreateErp<ErpDapperDAL<TN_SYS_MATERIAL_STOCKOUT_DTLEntity>>().Add(materialStockOutDtl);
            Log.Detail(logPara, "向中间库同步领料单子表结果：" + JsonConvert.SerializeObject(result));
            return result;
        }

        #endregion

        
    }
}