//获取头部广告图 private void GetBannerList() { string sql = "SELECT top 8 ImageUrl,Url FROM dbo.MVipBanner with(nolock) WHERE LocationType=1 and isshow = 1 order by DisplaySequence ASC,AddDate DESC"; var para = new Dapper.DynamicParameters(); BannerList = PublicConn.QueryVipBySql <MVipBanner>(sql, ref para); }