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

namespace HH.WMS.BLL.External
{
    public class WmsApiForHcbhBLL : WmsApiBaseBLL
    {
        #region 解绑货位

         public BasisResponse UnbindLocation(string locationCode)
        {
            //var logPara = LogType.LogPara("解绑货位");
            var locationExt = BLLCreator.Create<DapperBLL<TN_WM_LOCATION_EXTEntity>>().GetSingleEntity(new { CN_S_LOCATION_CODE = locationCode });
            if (locationExt == null)
            {
                return BasisResponse.Error("当前货位未找到！");
            }
            var trayLocation = BLLCreator.Create<DapperBLL<TN_WM_B_TRAY_LOCATIONEntity>>().GetSingleEntity(new { CN_S_LOCATION_CODE = locationExt.CN_S_LOCATION_CODE });
            return UseBasisTransaction(trans =>
            { 
                //删除货位托盘
                DALCreator.Create<DapperDAL<TN_WM_B_TRAY_LOCATIONEntity>>().Delete(new { CN_S_LOCATION_CODE = locationCode }, trans);

                //删除托盘物料
                if (trayLocation != null)
                    DALCreator.Create<DAL.InStock.TN_WM_B_TRAY_ITEM_RELDAL>().DeleteTrayItem(" CN_S_TRAY_CODE='" + trayLocation.CN_S_TRAY_CODE + "' ", trans);

                //修改货位状态
                DALCreator.Create<DapperDAL<TN_WM_LOCATION_EXTEntity>>().Update(new { CN_S_USE_STATE = "空" }, new { CN_S_LOCATION_CODE = locationCode }, trans);
            });
        }
         public BasisResponse UnbindLocationLJ(string locationCode)
         {
             //var logPara = LogType.LogPara("解绑货位");
             var locationExt = BLLCreator.Create<DapperBLL<TN_WM_LOCATION_EXTEntity>>().GetSingleEntity(new { CN_S_LOCATION_CODE = locationCode });
             if (locationExt == null)
             {
                 return BasisResponse.Error("当前货位未找到！");
             }
             var trayLocation = BLLCreator.Create<DapperBLL<TN_WM_B_TRAY_LOCATIONEntity>>().GetSingleEntity(new { CN_S_LOCATION_CODE = locationExt.CN_S_LOCATION_CODE });
             return UseBasisTransaction(trans =>
             {
                 //删除货位托盘
                 DALCreator.Create<DapperDAL<TN_WM_B_TRAY_LOCATIONEntity>>().Delete(new { CN_S_LOCATION_CODE = locationCode }, trans);

                 //删除托盘物料
                 if (trayLocation != null)
                     DALCreator.Create<DAL.InStock.TN_WM_B_TRAY_ITEM_RELDAL>().DeleteTrayItem(" CN_S_TRAY_CODE='" + trayLocation.CN_S_TRAY_CODE + "' ", trans);

                 //修改货位状态
                 DALCreator.Create<DapperDAL<TN_WM_LOCATION_EXTEntity>>().Update(new { CN_S_USE_STATE = "空", CN_T_CREATE = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")) }, new { CN_S_LOCATION_CODE = locationCode }, trans);
             });
         }
        #endregion
       
    }
}