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
| /********************************************************************************
|
| ** auth： DBS
|
| ** date： 2018/11/20 14:45:23
|
| ** 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;
| using HH.WMS.Entitys.Sys;
| using System.Data;
|
| namespace HH.WMS.DAL.SysMgr
| {
| public class TN_WM_B_STRATEGY_DEFDAL: DapperBaseDAL
| {
| /// <summary>
| /// 保存更新变更的策略
| /// </summary>
| /// <param name="model">更新值</param>
| /// <param name="trans">事务</param>
| /// <returns></returns>
| /// <history>[HanHe(dbs)] CREATED 2018/11/19</history>
| public OperateResult UpdateSetValue(TN_WM_B_STRATEGY_VALUEEntity model,IDbTransaction trans)
| {
|
| string sql = @"if exists
| (select CN_GUID from tn_wm_b_strategy_value where CN_S_STOCK_CODE =@CN_S_STOCK_CODE and CN_S_CODE=@CN_S_CODE)
| update tn_wm_b_strategy_value set CN_S_VALUE=@CN_S_VALUE where CN_S_STOCK_CODE =@CN_S_STOCK_CODE and CN_S_CODE=@CN_S_CODE
| else
| INSERT INTO tn_wm_b_strategy_value
| (CN_GUID
| ,CN_S_STOCK_CODE
| ,CN_S_CODE
| ,CN_S_NAME
| ,CN_S_VALUE
| ,CN_S_CREATOR
| ,CN_S_CREATOR_BY
| ,CN_T_CREATE
| ,CN_S_MODIFY
| ,CN_S_MODIFY_BY
| ,CN_T_MODFIY)
| VALUES
| (@CN_GUID,
| @CN_S_STOCK_CODE,
| @CN_S_CODE,
| @CN_S_NAME,
| @CN_S_VALUE,
| @CN_S_CREATOR,
| @CN_S_CREATOR_BY,
| @CN_T_CREATE,
| @CN_S_MODIFY,
| @CN_S_MODIFY_BY,
| @CN_T_MODFIY)";
|
| return ExecuteTranSql(sql, new
| {
| CN_S_STOCK_CODE = model.CN_S_STOCK_CODE,
| CN_S_CODE = model.CN_S_CODE,
| CN_S_VALUE = model.CN_S_VALUE,
| CN_GUID = model.CN_GUID,
| CN_S_NAME = model.CN_S_NAME,
| CN_S_CREATOR = model.CN_S_CREATOR,
| CN_S_CREATOR_BY = model.CN_S_CREATOR_BY,
| CN_T_CREATE = model.CN_T_CREATE,
| CN_S_MODIFY = model.CN_S_MODIFY,
| CN_S_MODIFY_BY = model.CN_S_MODIFY_BY,
| CN_T_MODFIY = model.CN_T_MODFIY
| }, trans);
| }
| }
| }
|
|
