/// <summary>
/// 添加现金券信息.
/// </summary>
/// <param name="couponCash">
/// 现金券Coupon_Cash的对象实例.
/// </param>
/// <returns>
/// 现金券的编号.
/// </returns>
public int InsertCoupon_Cash(Coupon_Cash couponCash)
{
if (couponCash == null)
{
throw new ArgumentNullException("couponCash");
}
var parameters = new List<SqlParameter>
{
this.SqlServer.CreateSqlParameter(
"EmployeeID",
SqlDbType.Int,
couponCash.EmployeeID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Name",
SqlDbType.NVarChar,
couponCash.Name,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"FaceValue",
SqlDbType.Float,
couponCash.FaceValue,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"InitialNumber",
SqlDbType.Int,
couponCash.InitialNumber,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Description",
SqlDbType.NVarChar,
couponCash.Description,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"StartTime",
SqlDbType.DateTime,
couponCash.StartTime,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"EndTime",
SqlDbType.DateTime,
couponCash.EndTime,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"CreateTime",
SqlDbType.DateTime,
couponCash.CreateTime,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"ReferenceID",
SqlDbType.Int,
null,
ParameterDirection.Output)
};
this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Coupon_Cash_Insert", parameters, null);
return (int)parameters.Find(parameter => parameter.ParameterName == "ReferenceID").Value;
}
/// <summary>
/// 添加现金券信息.
/// </summary>
/// <param name="couponCash">
/// 现金券Coupon_Cash的对象实例.
/// </param>
/// <returns>
/// 现金券的编号.
/// </returns>
public int Add(Coupon_Cash couponCash)
{
return this.couponCashDA.InsertCoupon_Cash(couponCash);
}