/// <summary> /// 添加CPS佣金信息. /// </summary> /// <param name="cpsCommissionRatio"> /// Cps_CommissionRatio的对象实例. /// </param> /// <returns> /// The <see cref="int"/>. /// </returns> public int Insert(Cps_CommissionRatio cpsCommissionRatio) { if (cpsCommissionRatio == null) { throw new ArgumentNullException("cpsCommissionRatio"); } var parameters = new List<SqlParameter> { this.SqlServer.CreateSqlParameter( "CpsID", SqlDbType.Int, cpsCommissionRatio.CpsID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "ProductCategoryID", SqlDbType.Int, cpsCommissionRatio.ProductCategoryID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "CommissionRatio", SqlDbType.Float, cpsCommissionRatio.CommissionRatio, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "CreateTime", SqlDbType.DateTime, cpsCommissionRatio.CreateTime, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "ReferenceID", SqlDbType.Int, null, ParameterDirection.Output) }; this.SqlServer.ExecuteNonQuery( CommandType.StoredProcedure, "sp_Cps_CommissionRatio_Insert", parameters, null); return (int)parameters.Find(parameter => parameter.ParameterName == "ReferenceID").Value; }
/// <summary> /// 更新所有CPS佣金比例信息. /// </summary> /// <param name="cpsCommissionRatio"> /// Cps_CommissionRatio的对象实例. /// </param> public void Modify(Cps_CommissionRatio cpsCommissionRatio) { this.cpsCommissionRatioDA.Updata(cpsCommissionRatio); }
/// <summary> /// 添加CPS佣金信息. /// </summary> /// <param name="cpsCommissionRatio"> /// Cps_CommissionRatio的对象实例. /// </param> /// <returns> /// CPS的平台编号. /// </returns> public int Add(Cps_CommissionRatio cpsCommissionRatio) { return this.cpsCommissionRatioDA.Insert(cpsCommissionRatio); }
/// <summary> /// 更新CPS拥挤比例. /// </summary> /// <param name="cpsCommissionRatio"> /// The cps_ commission ratio. /// </param> public void Updata(Cps_CommissionRatio cpsCommissionRatio) { if (cpsCommissionRatio == null) { throw new ArgumentNullException("cpsCommissionRatio"); } var parameters = new List<SqlParameter> { this.SqlServer.CreateSqlParameter( "ID", SqlDbType.Int, cpsCommissionRatio.ID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "CpsID", SqlDbType.Int, cpsCommissionRatio.CpsID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "ProductCategoryID", SqlDbType.Int, cpsCommissionRatio.ProductCategoryID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "CommissionRatio", SqlDbType.Float, cpsCommissionRatio.CommissionRatio, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "CreateTime", SqlDbType.DateTime, cpsCommissionRatio.CreateTime, ParameterDirection.Input) }; this.SqlServer.ExecuteNonQuery( CommandType.StoredProcedure, "sp_cps_CommissionRatio_Update", parameters, null); }