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

namespace HH.WMS.DAL.SysMgr
{
    public class TN_WM_UP_HISTORYDAL : DapperBaseDAL
    {
        #region 修改上架记录的货位信息
        /// <summary>
        /// 修改上架记录的货位信息
        /// </summary>
        /// <param name="trayCode">托盘编码</param>
        /// <param name="locationModel">货位信息</param>
        /// <param name="trans"></param>
        /// <returns></returns>
        public OperateResult UpdateLocation(string trayCode, List<TN_WM_LOCATION_EXTEntity> locationModel, IDbTransaction trans)
        {
            string sq1 = "UPDATE TN_WM_UP_HISTORY SET CN_S_STOCK_CODE=@CN_S_STOCK_CODE,CN_S_STOCK_AREA=@CN_S_STOCK_AREA,CN_S_LOCATION_CODE=@CN_S_LOCATION_CODE WHERE CN_S_TRAY_CODE=@CN_S_TRAY_CODE AND (CN_S_LOCATION_CODE='' OR CN_S_LOCATION_CODE IS NULL) ";
            OperateResult result = ExecuteTranSql(sq1, new
            {
                CN_S_STOCK_CODE = locationModel[0].CN_S_STOCK_CODE,
                CN_S_STOCK_AREA = locationModel[0].CN_S_AREA_CODE,
                CN_S_LOCATION_CODE = locationModel[0].CN_S_LOCATION_CODE,
                CN_S_TRAY_CODE = trayCode
            }, null);
            return result;
        }
        #endregion


    }
}