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;
|
}
|
|
|
}
|
}
|
