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