/// <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); }