/// <summary> /// 修改满足条件送优惠券促销规则. /// </summary> /// <param name="promoteMeetGiveCoupon"> /// Promote_Meet_GiveCoupon的对象. /// </param> /// <param name="transaction"> /// 数据事务. /// </param> public void UpdateByRuleID(Promote_Meet_GiveCoupon promoteMeetGiveCoupon, SqlTransaction transaction) { if (promoteMeetGiveCoupon == null) { throw new ArgumentNullException("promoteMeetGiveCoupon"); } var parameters = new List<SqlParameter> { this.SqlServer.CreateSqlParameter( "MeetRuleID", SqlDbType.Int, promoteMeetGiveCoupon.MeetRuleID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "MeetTypeID", SqlDbType.Int, promoteMeetGiveCoupon.MeetTypeID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "CouponTypeID", SqlDbType.Int, promoteMeetGiveCoupon.CouponTypeID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "CouponID", SqlDbType.Int, promoteMeetGiveCoupon.CouponID, ParameterDirection.Input) }; this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Promote_Meet_GiveCoupon_Update", parameters, transaction); }
/// <summary> /// 添加满足条件送优惠券促销规则. /// </summary> /// <param name="promoteMeetGiveCoupon"> /// Promote_Meet_GiveCoupon的对象. /// </param> /// <param name="transaction"> /// 数据事务. /// </param> /// <returns> /// 满足条件送优惠券促销规则编号. /// </returns> public int Insert(Promote_Meet_GiveCoupon promoteMeetGiveCoupon, SqlTransaction transaction) { if (promoteMeetGiveCoupon == null) { throw new ArgumentNullException("promoteMeetGiveCoupon"); } var parameters = new List<SqlParameter> { this.SqlServer.CreateSqlParameter( "MeetRuleID", SqlDbType.Int, promoteMeetGiveCoupon.MeetRuleID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "MeetTypeID", SqlDbType.Int, promoteMeetGiveCoupon.MeetTypeID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "CouponTypeID", SqlDbType.Float, promoteMeetGiveCoupon.CouponTypeID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "CouponID", SqlDbType.Float, promoteMeetGiveCoupon.CouponID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "ReferenceID", SqlDbType.Int, promoteMeetGiveCoupon.ID, ParameterDirection.Output) }; this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Promote_Meet_GiveCoupon_Insert", parameters, transaction); return (int)parameters.Find(parameter => parameter.ParameterName == "ReferenceID").Value; }