CCN.Modules.Rewards.DataAccess.RewardsDataAccess.GetMallShopCardTypeNameList C# (CSharp) Метод

        public IEnumerable<string> GetMallShopCardTypeNameList(string shopid)
        {
            const string sql = "select distinct bc.codename from coupon_card as a inner join base_code as bc on a.cardtype=bc.codevalue and bc.typekey='coupon_type' where shopid = @shopid;";
            return Helper.Query<string>(sql, new { shopid });
        }