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