/// <summary>
/// 添加现金券绑定
/// </summary>
/// <param name="couponID">
/// 券ID
/// </param>
/// <param name="userID">
/// 会员ID
/// </param>
/// <param name="cause">
/// 描述
/// </param>
/// <param name="status">
/// The status.
/// </param>
/// <param name="transaction">
/// The transaction.
/// </param>
/// <returns>
/// 绑定的编码
/// </returns>
public int Add(int orderId, int couponID, int userID, string cause, int status, SqlTransaction transaction)
{
var coupon = new Coupon_Cash_Binding
{
Cause = cause,
CouponCashID = couponID,
OrderID = orderId,
Status = status,
UserID = userID,
Number = "M" + this.CreateRandomCode(8),
Password = this.CreateRandomCode(6),
BindingTime = DateTime.Now,
UseTime = null
};
return this.Add(coupon, transaction);
}
/// <summary>
/// 添加现金券绑定
/// </summary>
/// <param name="couponCashBinding">
/// Coupon_Cash_Binding的对象实例
/// </param>
/// <param name="transaction">数据库事务，默认值为Null</param>
/// <returns>
/// 现金券绑定编号
/// </returns>
public int Add(Coupon_Cash_Binding couponCashBinding, SqlTransaction transaction = null)
{
return this.couponCashBindingDA.Insert(couponCashBinding, transaction);
}
/// <summary>
/// 添加现金券绑定.
/// </summary>
/// <param name="couponCashBinding">
/// Coupon_Cash_Binding的对象实例.
/// </param>
/// <param name="transaction">数据库事务，默认为Null</param>
/// <returns>
/// 现金券绑定的编号.
/// </returns>
public int Insert(Coupon_Cash_Binding couponCashBinding, SqlTransaction transaction = null)
{
if (couponCashBinding == null)
{
throw new ArgumentNullException("couponCashBinding");
}
var parameters = new List<SqlParameter>
{
this.SqlServer.CreateSqlParameter(
"CouponCashID",
SqlDbType.Int,
couponCashBinding.CouponCashID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"UserID",
SqlDbType.Int,
couponCashBinding.UserID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"OrderID",
SqlDbType.Int,
couponCashBinding.OrderID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Number",
SqlDbType.VarChar,
couponCashBinding.Number,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Password",
SqlDbType.VarChar,
couponCashBinding.Password,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Cause",
SqlDbType.VarChar,
couponCashBinding.Cause,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Status",
SqlDbType.Int,
couponCashBinding.Status,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"UseTime",
SqlDbType.DateTime,
couponCashBinding.UseTime,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"BindingTime",
SqlDbType.DateTime,
couponCashBinding.BindingTime,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"ReferenceID",
SqlDbType.Int,
null,
ParameterDirection.Output)
};
this.SqlServer.ExecuteNonQuery(
CommandType.StoredProcedure,
"sp_Coupon_Cash_Binding_Insert",
parameters,
transaction);
return (int)parameters.Find(parameter => parameter.ParameterName == "ReferenceID").Value;
}
/// <summary>
/// 添加现金券绑定
/// </summary>
/// <param name="couponCashBinding">
/// Coupon_Cash_Binding的对象实例
/// </param>
public void Modify(Coupon_Cash_Binding couponCashBinding)
{
this.couponCashBindingDA.Update(couponCashBinding);
}
/// <summary>
/// 添加现金券绑定.
/// </summary>
/// <param name="couponCashBinding">
/// Coupon_Cash_Binding的对象实例.
/// </param>
public void Update(Coupon_Cash_Binding couponCashBinding)
{
if (couponCashBinding == null)
{
throw new ArgumentNullException("couponCashBinding");
}
var parameters = new List<SqlParameter>
{
this.SqlServer.CreateSqlParameter(
"CouponCashID",
SqlDbType.Int,
couponCashBinding.CouponCashID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"UserID",
SqlDbType.Int,
couponCashBinding.UserID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"OrderID",
SqlDbType.Int,
couponCashBinding.OrderID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Number",
SqlDbType.VarChar,
couponCashBinding.Number,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Password",
SqlDbType.VarChar,
couponCashBinding.Password,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Cause",
SqlDbType.VarChar,
couponCashBinding.Cause,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Status",
SqlDbType.Int,
couponCashBinding.Status,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"UseTime",
SqlDbType.DateTime,
couponCashBinding.UseTime,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"BindingTime",
SqlDbType.DateTime,
couponCashBinding.BindingTime,
ParameterDirection.Input),
};
this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Coupon_Cash_Update", parameters, null);
}