/// <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;
}
