Esempio n. 1
0
        //****************************************************************************************************
        public static List <CityData> getCityData(string str)
        {
            str = str.ToLower();

            List <CityData> data = new List <CityData>();

            if (cityData == null)
            {
                DataTable dt = new ModCity().getSelect();
                foreach (DataRow dr in dt.Rows)
                {
                    CityData item = new CityData()
                    {
                        cityName   = dr["cityName"].ToString(),
                        spell      = dr["spell"].ToString().ToLower(),
                        firstSpell = dr["firstSpell"].ToString().ToLower()
                    };

                    data.Add(item);
                }

                cityData = data;
            }
            else
            {
                data = cityData;
            }

            return((data.Where(
                        item =>
                        (item.cityName.Contains(str)) ||
                        (item.spell.Contains(str)) ||
                        (item.firstSpell.Contains(str))
                        )).ToList <CityData>());
        }
Esempio n. 2
0
 //****************************************************************************************************
 private void cmbCity_KeyUp(object sender, KeyEventArgs e)
 {
     if (cmbCity.Text == "")
     {
         lstCity.Visible = false;
     }
     else
     {
         List <CityData> cityData = CityData.getCityData(cmbCity.Text);
         if (cityData == null)
         {
             lstCity.Visible = false;
         }
         else
         {
             lstCity.Visible       = true;
             lstCity.DataSource    = cityData;
             lstCity.DisplayMember = "cityName";
             lstCity.ValueMember   = "cityName";
         }
     }
 }