/// <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;
}