/// <summary> /// 添加满减券. /// </summary> /// <param name="couponDecrease"> /// Coupon_Decrease的对象实例. /// </param> /// <returns> /// 满减券编号. /// </returns> public int InsertCouponDecrease(Coupon_Decrease couponDecrease) { if (couponDecrease == null) { throw new ArgumentNullException("couponDecrease"); } var parameters = new List<SqlParameter> { this.SqlServer.CreateSqlParameter( "EmployeeID", SqlDbType.Int, couponDecrease.EmployeeID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Name", SqlDbType.NVarChar, couponDecrease.Name, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "FaceValue", SqlDbType.Float, couponDecrease.FaceValue, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "MeetAmount", SqlDbType.Float, couponDecrease.MeetAmount, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "InitialNumber", SqlDbType.Int, couponDecrease.InitialNumber, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Description", SqlDbType.NVarChar, couponDecrease.Description, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "StartTime", SqlDbType.DateTime, couponDecrease.StartTime, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "EndTime", SqlDbType.DateTime, couponDecrease.EndTime, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "CreateTime", SqlDbType.DateTime, couponDecrease.CreateTime, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "ReferenceID", SqlDbType.Int, null, ParameterDirection.Output) }; this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Coupon_Decrease_Insert", parameters, null); return (int)parameters.Find(parameter => parameter.ParameterName == "ReferenceID").Value; }
/// <summary> /// 添加满减券. /// </summary> /// <param name="couponDecrease"> /// Coupon_Decrease的对象实例. /// </param> /// <returns> /// 满减券的编号. /// </returns> public int Add(Coupon_Decrease couponDecrease) { return this.couponDecreaseDA.InsertCouponDecrease(couponDecrease); }