/// <summary>
/// 添加满就送促销规则.
/// </summary>
/// <param name="promoteMeetMoneyRule">
/// Promote_MeetMoney_Rule的对象.
/// </param>
/// <param name="transaction">
/// 数据库事务.
/// </param>
/// <returns>
/// 规则的编号.
/// </returns>
public int Insert(Promote_MeetMoney_Rule promoteMeetMoneyRule, SqlTransaction transaction)
{
if (promoteMeetMoneyRule == null)
{
throw new ArgumentNullException("promoteMeetMoneyRule");
}
var parameters = new List<SqlParameter>
{
this.SqlServer.CreateSqlParameter(
"PromoteMeetMoneyID",
SqlDbType.Int,
promoteMeetMoneyRule.PromoteMeetMoneyID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"MeetMoney",
SqlDbType.Float,
promoteMeetMoneyRule.MeetMoney,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"IsNoCeiling",
SqlDbType.Bit,
promoteMeetMoneyRule.IsNoCeiling,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"IsDecreaseCash",
SqlDbType.Bit,
promoteMeetMoneyRule.IsDecreaseCash,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"DecreaseCash",
SqlDbType.Float,
promoteMeetMoneyRule.DecreaseCash,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"IsGiveGift",
SqlDbType.Bit,
promoteMeetMoneyRule.IsGiveGift,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"ProductID",
SqlDbType.Int,
promoteMeetMoneyRule.ProductID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"IsGiveIntegral",
SqlDbType.Bit,
promoteMeetMoneyRule.IsGiveIntegral,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Integral",
SqlDbType.Int,
promoteMeetMoneyRule.Integral,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"IsNoPostage",
SqlDbType.Bit,
promoteMeetMoneyRule.IsNoPostage,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"IsGiveCoupon",
SqlDbType.Bit,
promoteMeetMoneyRule.IsGiveCoupon,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"CouponType",
SqlDbType.Int,
promoteMeetMoneyRule.CouponType,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"CouponID",
SqlDbType.Int,
promoteMeetMoneyRule.CouponID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"ReferenceID",
SqlDbType.Int,
promoteMeetMoneyRule.ID,
ParameterDirection.Output)
};
this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Promote_MeetMoney_Rule_Insert", parameters, transaction);
return (int)parameters.Find(parameter => parameter.ParameterName == "ReferenceID").Value;
}
/// <summary>
/// 修改满就送促销规则.
/// </summary>
/// <param name="promoteMeetMoneyRule">
/// Promote_MeetMoney_Rule的对象.
/// </param>
/// <param name="transaction">
/// 数据库事务.
/// </param>
public void Update(Promote_MeetMoney_Rule promoteMeetMoneyRule, SqlTransaction transaction)
{
var parameters = new List<SqlParameter>
{
this.SqlServer.CreateSqlParameter(
"ID",
SqlDbType.Int,
promoteMeetMoneyRule.ID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"MeetMoney",
SqlDbType.Float,
promoteMeetMoneyRule.MeetMoney,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"IsNoCeiling",
SqlDbType.Bit,
promoteMeetMoneyRule.IsNoCeiling,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"IsDecreaseCash",
SqlDbType.Bit,
promoteMeetMoneyRule.IsDecreaseCash,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"DecreaseCash",
SqlDbType.Float,
promoteMeetMoneyRule.DecreaseCash,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"IsGiveGift",
SqlDbType.Bit,
promoteMeetMoneyRule.IsGiveGift,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"ProductID",
SqlDbType.Int,
promoteMeetMoneyRule.ProductID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"IsGiveIntegral",
SqlDbType.Bit,
promoteMeetMoneyRule.IsGiveIntegral,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Integral",
SqlDbType.Int,
promoteMeetMoneyRule.Integral,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"IsNoPostage",
SqlDbType.Bit,
promoteMeetMoneyRule.IsNoPostage,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"IsGiveCoupon",
SqlDbType.Bit,
promoteMeetMoneyRule.IsGiveCoupon,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"CouponType",
SqlDbType.Int,
promoteMeetMoneyRule.CouponType,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"CouponID",
SqlDbType.Int,
promoteMeetMoneyRule.CouponID,
ParameterDirection.Input)
};
this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Promote_MeetMoney_Rule_Update", parameters, transaction);
}
