public IEnumerable<dynamic> CommodityDiscountItem(string discountID) { //Init SQLStringInfo _sqlInfo = new SQLStringInfo(); _sqlInfo.ColumnSB.Append(" ,DIS.PostType,DIS.IsEndCommodity "); _sqlInfo.WhereSB.Append(" WHERE DiscountID = @DiscountID"); _sqlInfo.OrderBySB.Append(",COMM.Title"); //DAL CommodityDiscountInfoDAL discountDal = new CommodityDiscountInfoDAL(); string strSql = _sqlInfo.GetSQLString(discountDal.CommodityDiscountListSQL()); IEnumerable<dynamic> list = discountDal.Query(strSql, new { DiscountID = discountID }); return list; }