/// <summary> /// 选择省区 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void spinner_ItemSelected(Object sender, AdapterView.ItemSelectedEventArgs e) { Spinner spinner = (Spinner)sender; string ls_prov = spinner.GetItemAtPosition(e.Position).ToString(); DataTable ldt_city = new DataTable(); string ls_sql = "select cityname from city,province where provinceno= province.prov_code and prov_name='" + ls_prov.Trim() + "'"; ldt_city = SqliteHelper.ExecuteDataTable(ls_sql); if (ldt_city.Rows.Count <= 0) { if (ls_prov != "选择省份") Toast.MakeText(this, ls_prov + "下未找到城市,请在下方录入新城市", ToastLength.Short).Show(); } string[] list = new string[ldt_city.Rows.Count];// Resources.GetStringArray(Resource.Array.planets_array); for (int i = 0; i < ldt_city.Rows.Count; i++) { if (ldt_city.Rows[i]["cityname"] != null) list[i] = ldt_city.Rows[i]["cityname"].ToString().Trim(); } var adapter = new CustomControl.MySpinnerAdapter(this, list); Spinner sp_city = FindViewById<Spinner>(Resource.Id.NewCustomer_city); sp_city.Adapter = adapter; }
/// <summary> /// 绑定省区控件 /// </summary> private void BindProv(Spinner spinner) { string StrSql = "select prov_code,prov_name FROM province"; DataTable dt = SqliteHelper.ExecuteDataTable(StrSql); string[] list = new string[dt.Rows.Count + 1];// Resources.GetStringArray(Resource.Array.planets_array); list[0] = "选择省份"; for (int i = 1; i < dt.Rows.Count; i++) { if (dt.Rows[i]["prov_name"] != null) list[i] = dt.Rows[i]["prov_name"].ToString().Trim(); } ArrayAdapter<String> adapter = new CustomControl.MySpinnerAdapter(this, list);// new ArrayAdapter<String>(this, Android.Resource.Layout.TestListItem); //TestListItem(this, Android.Resource.Layout.SimpleSpinnerItem); adapter.SetDropDownViewResource(Android.Resource.Layout.SimpleSpinnerDropDownItem); spinner.Adapter = adapter; }