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
/********************************************************************************
 
** auth: DBS
 
** date: 2018/11/20 20:42:30
 
** desc: 尚未编写描述
 
** Ver.:  V1.0.0
 
*********************************************************************************/
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using HH.WMS.Entitys.Sys;
using HH.WMS.Entitys;
using HH.WMS.DAL.SysMgr;
using HH.WMS.DAL;
 
namespace HH.WMS.BLL.SysMgr
{
    public class TN_WM_B_STRATEGY_VALUEBLL : DapperBaseBLL
    {
        /// <summary>
        /// 保存更新变更的策略
        /// </summary>
        /// <param name="stockCode">仓库编号</param>
        /// <param name="list">变更项</param>
        /// <returns></returns>
        /// <history>[HanHe(dbs)] CREATED 2018/11/19</history>
        public OperateResult UpdateSetValue(string stockCode, List<TN_WM_B_STRATEGY_DEFEntity> list)
        {
            OperateResult operateResult = UseTransaction(trans =>
            {
                foreach (TN_WM_B_STRATEGY_DEFEntity m in list)
                {
                    CreateDAL<TN_WM_B_STRATEGY_DEFDAL>().UpdateSetValue(new TN_WM_B_STRATEGY_VALUEEntity()
                    {
                        CN_GUID = Guid.NewGuid().ToString(),
                        CN_S_CODE = m.CN_S_CODE,
                        CN_S_VALUE = m.CN_S_VALUE,
                        CN_S_STOCK_CODE = stockCode,
                        CN_S_CREATOR = m.CN_S_CREATOR,
                        CN_S_CREATOR_BY = m.CN_S_CREATOR_BY,
                        CN_S_MODIFY = m.CN_S_MODIFY,
                        CN_S_MODIFY_BY = m.CN_S_MODIFY_BY,
                        CN_S_NAME = m.CN_S_NAME,
                        CN_T_CREATE = DateTime.Now,
                        CN_T_MODFIY = DateTime.Now
                    }, trans);
                }
            });
            return operateResult;
        }
 
        #region 修改值
        /// <summary>
        /// 修改值
        /// </summary>
        /// <param name="list"></param>
        /// <returns></returns>
        public OperateResult UpdateSetValue(List<TN_WM_B_STRATEGY_VALUEEntity> list)
        {
            return UseTransaction(trans =>
            {
                foreach (var item in list)
                {
                    CreateDAL<DapperDAL<TN_WM_B_STRATEGY_VALUEEntity>>().Update(new
                    {
                        CN_S_VALUE = item.CN_S_VALUE,
                        CN_S_MODIFY = item.CN_S_MODIFY,
                        CN_S_MODIFY_BY = item.CN_S_MODIFY_BY,
                        CN_T_MODFIY = item.CN_T_MODFIY
                    }, new
                    {
                        CN_S_STOCK_CODE = item.CN_S_STOCK_CODE,
                        CN_S_CODE = item.CN_S_CODE
                    }, trans);
                }
            });
        }
        #endregion
    }
}