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 TN_ER_COMBINE_CAGE_HISTORYDAL : DapperBaseDAL
    {

        /// <summary>
        /// 码盘修改数量,根据Guid
        /// </summary>
        /// <param name="TrayItemMstlst"></param>
        /// <param name="trans"></param>
        public OperateResult UpdateCombineStatus(string trayCode, string afterStatus, string beforeStatus, IDbTransaction trans)
        {
            OperateResult result = new OperateResult();

            StringBuilder strSql = new StringBuilder();
            strSql.Append(" UPDATE TN_ER_COMBINE_CAGE_HISTORY SET CN_N_SYNC=@CN_N_SYNC_AFTER ");
            strSql.Append(" WHERE CN_S_MAIN_TRAY_CODE=@CN_S_MAIN_TRAY_CODE AND CN_N_SYNC=@CN_N_SYNC_BEFORE  ");

            result = ExecuteTranSql(strSql.ToString(), new
            {
                CN_N_SYNC_AFTER = afterStatus,
                CN_N_SYNC_BEFORE = beforeStatus,
                CN_S_MAIN_TRAY_CODE = trayCode
            }, trans);
            if (result.Status == ResultStatus.Error)
                return result;

            return result;
        }


    }
}