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