/// <summary>
/// Maps DiscountModel table
/// </summary>
/// <param name="reader">The reader.</param>
/// <param name="rowNumber">The row number.</param>
/// <returns></returns>
private object MapDiscountModel(IDataReader reader, int row)
{
ConItemBuyerDiscountModel model = new ConItemBuyerDiscountModel();
model.DiscountBatchValue = Convert.ToString(reader["discount_batch"]);
model.DiscountPayatonceValue = Convert.ToString(reader["discount_payatonce"]);
model.DiscountPaymentValue = Convert.ToString(reader["discount_payment"]);
model.DiscountThirtydayValue = Convert.ToString(reader["discount_thirtyday"]);
return(model);
}
public ConItemBuyerDiscountModel getDiscountInfo(string buyerId, string platId, string conItemId)
{
StringBuilder sql = new StringBuilder();
ConItemBuyerDiscountModel model = null;
sql.Append(" select c.discount_batch,");
sql.Append(" c.discount_payment,");
sql.Append(" c.discount_payatonce,");
sql.Append(" c.discount_thirtyday ");
sql.Append(" from con_item_buyer_discount c ");
sql.Append(" where c.buyer_id = :buyer_id ");
sql.Append(" and c.source_id = :source_id ");
sql.Append(" and c.create_plat = :plat_id ");
DbParameter paramBuyer = base.DbFacade.CreateParameter();
paramBuyer.ParameterName = "buyer_id";
paramBuyer.DbType = DbType.String;
paramBuyer.Value = buyerId;
DbParameter paramPlat = base.DbFacade.CreateParameter();
paramPlat.ParameterName = "plat_id";
paramPlat.DbType = DbType.String;
paramPlat.Value = platId;
DbParameter paramCon = base.DbFacade.CreateParameter();
paramCon.ParameterName = "source_id";
paramCon.DbType = DbType.String;
paramCon.Value = conItemId;
try
{
model = DbFacade.SQLExecuteObject(sql.ToString(), new MapRow(MapDiscountModel), paramBuyer, paramPlat, paramCon) as ConItemBuyerDiscountModel;
}
catch (Exception e)
{
throw e;
}
return(model);
}
