根据大洲编号从缓存获取按字母分类的城市列表

最新推荐文章于 2024-11-04 09:52:52 发布

臭小子小豆豆

最新推荐文章于 2024-11-04 09:52:52 发布

阅读量719

点赞数

文章标签： string equals join list null c

本文链接：https://blog.csdn.net/ououou123456789/article/details/7450196

版权

在大部分的时候要在页面上显示字母和 国家页面 ，可以采用类中有类的方法，绑定reapter控件就可以

public static List<Letter_City> GetCitiesWithLetterByContinentID(short continentId)
        {
            string key = string.Format(SR.Cache_City_With_Letter_By_ContinentID, continentId);
            var cities = ByecityCache.Get(key) as List<Letter_City>;
            if (cities == null)
            {
                cities = new List<Letter_City>();
                var allCities = AllCities;
                for (char i = 'A'; i <= 'Z'; i++)
                {
                    string letter = i.ToString();
                    var list = from c in allCities
                               join ct in AllCountries
                                   on c.CountryID equals ct.CountryID
                               where c.ContinentID == continentId && c.Name_Pinyin_Short.StartsWith(letter, StringComparison.OrdinalIgnoreCase)
                               orderby c.Hot
                               select new CountryCityList
                               {
                                   CityName_CN = c.Name_CN,
                                   CityName_EN = c.Name_EN.ToLower().Replace(SR.Space, SR.UnderLine),
                                   CountryName_EN = ct.Name_EN.ToLower().Replace(SR.Space, SR.UnderLine)
                               };
                    if (list.ToList().Count > 0)
                    {
                        cities.Add(new Letter_City
                        {
                            Letter = letter,
                            Cities = list.ToList()
                        });
                    }
                }
                ByecityCache.Max(key, cities);
            }
            return cities;
        }