/// <summary>
/// The add.
/// </summary>
/// <param name="orderID">
/// The order ID.
/// </param>
/// <param name="couponID">
/// The coupon id.
/// </param>
/// <param name="userID">
/// The user id.
/// </param>
/// <param name="cause">
/// The cause.
/// </param>
/// <param name="status">
/// The status.
/// </param>
/// <param name="transaction">
/// The transaction.
/// </param>
/// <returns>
/// The <see cref="int"/>.
/// </returns>
public int Add(int orderID, int couponID, int userID, string cause, int status, SqlTransaction transaction)
{
var coupon = new Coupon_Decrease_Binding
{
Cause = cause,
CouponDecreaseID = couponID,
OrderID = orderID,
UserID = userID,
Status = status,
Number = "L" + this.CreateRandomCode(8),
Password = this.CreateRandomCode(6),
BindingTime = DateTime.Now,
UseTime = null
};
return this.Add(coupon, transaction);
}
/// <summary>
/// 添加满减券绑定.
/// </summary>
/// <param name="couponDecreaseBinding">
/// Coupon_Cash_Binding的对象实例.
/// </param>
/// <param name="transaction">数据库事务，默认为Null</param>
/// <returns>
/// 满减券绑定编号.
/// </returns>
public int Insert(Coupon_Decrease_Binding couponDecreaseBinding, SqlTransaction transaction = null)
{
if (couponDecreaseBinding == null)
{
throw new ArgumentNullException("couponDecreaseBinding");
}
var parameters = new List<SqlParameter>
{
this.SqlServer.CreateSqlParameter(
"CouponDecreaseID",
SqlDbType.Int,
couponDecreaseBinding.CouponDecreaseID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"UserID",
SqlDbType.Int,
couponDecreaseBinding.UserID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"OrderID",
SqlDbType.Int,
couponDecreaseBinding.OrderID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Number",
SqlDbType.VarChar,
couponDecreaseBinding.Number,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Password",
SqlDbType.VarChar,
couponDecreaseBinding.Password,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Cause",
SqlDbType.VarChar,
couponDecreaseBinding.Cause,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Status",
SqlDbType.Int,
couponDecreaseBinding.Status,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"UseTime",
SqlDbType.DateTime,
couponDecreaseBinding.UseTime,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"BindingTime",
SqlDbType.DateTime,
couponDecreaseBinding.BindingTime,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"ReferenceID",
SqlDbType.Int,
null,
ParameterDirection.Output)
};
this.SqlServer.ExecuteNonQuery(
CommandType.StoredProcedure,
"sp_Coupon_Decrease_Binding_Insert",
parameters,
transaction);
return (int)parameters.Find(parameter => parameter.ParameterName == "ReferenceID").Value;
}
/// <summary>
/// 添加满减券
/// </summary>
/// <param name="couponDecreaseBinding">
/// Coupon_Decrease_Binding的对象实例
/// </param>
/// <param name="transaction">数据库事务，默认为Null</param>
/// <returns>
/// 满减券绑定的编号
/// </returns>
public int Add(Coupon_Decrease_Binding couponDecreaseBinding, SqlTransaction transaction = null)
{
return this.couponDecreaseBindingDA.Insert(couponDecreaseBinding, transaction);
}
