蓝月亮

jt

2021-06-10 5d0d028456874576560552f5a5c4e8b801786f11

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
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
       
    }
}