Пример #1
0
        /// <summary>
        /// 积分兑换礼券
        /// </summary>
        /// <param name="model">兑换相关信息</param>
        /// <returns></returns>
        public int PointToCoupon(CustPointToCouponModel model)
        {
            using (var conn = Helper.GetConnection())
            {
                //参数
                var obj = new
                {
                    p_custid = model.Custid,
                    p_cardid = model.Cardid,
                    p_code = model.Code,
                    p_remark = model.Remark
                };

                var args = new DynamicParameters(obj);
                args.Add("p_value", dbType: DbType.Int32, direction: ParameterDirection.Output);

                using (conn.QueryMultiple("ccnsp_pointtocoupon", args, commandType: CommandType.StoredProcedure))
                {
                    //获取结果集
                    //var data = result.Read<T>();
                }

                return args.Get<int>("p_value");
            }
        }