蓝月亮

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
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
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 MiddleLibraryDAL : ErpDapperBaseDAL
    {
        /// <summary>
        /// 获取车牌档案
        /// </summary>
        /// <param name="carNo"></param>
        /// <returns></returns>
        public TN_CAR_INFOEntity GetCarInfo(string carNo)
        {
            return DALCreator.CreateErp<ErpDapperDAL<TN_CAR_INFOEntity>>().GetSingleEntity(new { CN_S_CAR_NO = carNo });
        }
 
        /// <summary>
        /// 获取大磅单
        /// </summary>
        /// <param name="poundNo"></param>
        /// <returns></returns>
        public TN_ER_CAR_POUNDEntity GetCarPound(string poundNo)
        {
            return DALCreator.CreateErp<ErpDapperDAL<TN_ER_CAR_POUNDEntity>>().GetSingleEntity(new { CN_S_POUND_NO = poundNo });
        }
 
        public List<TN_SYS_MATERIAL_STOCKOUTEntity> GetMaterialStockOut(string itemCode, string produceLine)
        {
            return DALCreator.CreateErp<ErpDapperDAL<TN_SYS_MATERIAL_STOCKOUTEntity>>().GetList(new
            {
                CN_S_ITEM_CODE = itemCode,
                CN_S_LINE = produceLine,
                CN_S_STATE = "开工"
            }, " ORDER BY CN_DT_CREATE ");
        }
 
        public List<TN_SYS_MATERIAL_STOCKOUTEntity> GetMaterialStockOut(string produceLine)
        {
            return DALCreator.CreateErp<ErpDapperDAL<TN_SYS_MATERIAL_STOCKOUTEntity>>().GetList(new
            {
                CN_S_LINE = produceLine,
                CN_S_STATE = "开工"
            }, " ORDER BY CN_DT_CREATE ");
        }
 
        #region ADD
 
        public OperateResult AddCarPound(TN_ER_CAR_POUNDEntity carPound, LogPara logPara, IDbTransaction trans)
        {
            var sysPound = new TN_SYS_POUNDEntity
            {
                CN_S_POUND_NO = carPound.CN_S_POUND_NO,
                CN_S_CAR_NO = carPound.CN_S_CAR_NO,
                CN_F_WEIGHT = carPound.CN_F_WEIGHT,
                CN_DT_WEIGHT = carPound.CN_T_ARRIVE,
                CN_S_ITEM_TYPE = carPound.CN_S_ITEM_TYPE,
                CN_DT_OPERATION = carPound.CN_T_CREATE,
                CN_S_OP_FROM = "",
                CN_DT_CREATE = carPound.CN_T_CREATE,
                CN_S_CREATOR = "",
                CN_F_CAR_WEIGHT = carPound.CN_F_CAR_WEIGHT,
                CN_DT_CAR_WEIGHT = carPound.CN_T_OUT,
                CN_S_VENDOR_NO = carPound.CN_S_VENDOR_NO,
                CN_S_STOCK_CODE = carPound.CN_S_STOCK_CODE,
                SynchroFlag = 0
            };
            Log.Detail(logPara, "保存数据:" + JsonConvert.SerializeObject(sysPound));
            return DALCreator.CreateErp<ErpDapperDAL<TN_SYS_POUNDEntity>>().Add(sysPound, logPara, trans);
        }
 
        public OperateResult AddMaterialStockIn(TN_SYS_MATERIAL_STOCKIN_DTLEntity materialStockInDtl, LogPara logPara, IDbTransaction trans)
        {
            Log.Detail(logPara, "添加参数：" + JsonConvert.SerializeObject(materialStockInDtl));
            var result = DALCreator.CreateErp<ErpDapperDAL<TN_SYS_MATERIAL_STOCKIN_DTLEntity>>().Add(materialStockInDtl, logPara, trans);
            Log.Detail(logPara, "向中间库同步小磅单结果：" + JsonConvert.SerializeObject(result));
            return result;
        }
 
        public OperateResult AddMaterialStockOut(TN_SYS_MATERIAL_STOCKOUT_DTLEntity materialStockOutDtl, LogPara logPara)
        {
            Log.Detail(logPara, "添加参数：" + JsonConvert.SerializeObject(materialStockOutDtl));
            var result = DALCreator.CreateErp<ErpDapperDAL<TN_SYS_MATERIAL_STOCKOUT_DTLEntity>>().Add(materialStockOutDtl);
            Log.Detail(logPara, "向中间库同步领料单子表结果：" + JsonConvert.SerializeObject(result));
            return result;
        }
 
        #endregion
 
        
    }
}