/********************************************************************************

** 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);
        }
    }
}