private void btnSave_Click(object sender, RoutedEventArgs e) { if (cmbDistrictName.SelectedValue == null) { DISTRICT district = new DISTRICT(); district.DISTRICT_NAME = cmbDistrictName.Text; data.Insert <DISTRICT>(district); } if (cmbTalukName.SelectedValue == null) { TALUK taluk = new TALUK(); taluk.TALUK_NAME = cmbTalukName.Text; taluk.DISTRICT_ID = selectedDistrict = cmbDistrictName.SelectedValue == null?data.GetAll <DISTRICT>().Max(s => s.DISTRICT_ID) : Convert.ToInt32(cmbDistrictName.SelectedValue); data.Insert <TALUK>(taluk); } if (null != txtVillageName.Text && txtVillageName.Text != string.Empty) { VILLAGE village = new VILLAGE(); village.VILLAGE_NAME = txtVillageName.Text; village.TALUK_ID = selectedTaluk = cmbTalukName.SelectedValue == null?data.GetAll <TALUK>().Max(s => s.TALUK_ID) : Convert.ToInt32(cmbTalukName.SelectedValue); data.Insert(village); MessageBox.Show("New Village Added Succesfully."); } txtVillageName.Text = string.Empty; BindGrid(); cmbDistrictName.ItemsSource = data.GetAll <DISTRICT>().Select(s => new { Id = s.DISTRICT_ID, Name = s.DISTRICT_NAME }); cmbDistrictName.SelectedValue = cmbDistrictName.SelectedValue == null ? selectedDistrict : Convert.ToInt32(cmbDistrictName.SelectedValue);; cmbTalukName.ItemsSource = data.GetAll <TALUK>(s => s.DISTRICT_ID == Convert.ToInt32(cmbDistrictName.SelectedValue)).Select(s => new { Id = s.TALUK_ID, Name = s.TALUK_NAME }); cmbTalukName.SelectedValue = cmbTalukName.SelectedValue == null ? selectedTaluk : Convert.ToInt32(cmbTalukName.SelectedValue); }
/// <summary> /// 根据id获取乡镇 /// </summary> /// <param name="countyId">province_id</param> /// <returns></returns> public static List <VILLAGE> getVillageByTownId(string townId) { List <VILLAGE> lst = new List <VILLAGE>(); try { string sql = "select id,town_id,village_id,village_name from village where town_id='" + townId + "'order by village_id "; DataTable dt = MySqlDHelper.ExecuteDataTable(sql); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { VILLAGE village = new VILLAGE(); village.ID = int.Parse(row["id"].ToString()); village.TOWN_ID = row["town_id"].ToString(); village.VILLAGE_ID = row["village_id"].ToString(); village.VILLAGE_NAME = row["village_name"].ToString(); lst.Add(village); } } return(lst); } catch (Exception e) { string err = new DateTime().ToString() + " 根据城市id获取区县:region/getVillageByTownId ,错误:" + e.Message; LogHelper.WriteLog(err); return(lst); } }
private void AddVillageRow(Village village, Polygon polygon) { VILLAGERow row = VILLAGE.NewVILLAGERow(); row.Village = village; row.Polygon = polygon; row.KINGDOM = village.Kingdom.ToString(CultureInfo.InvariantCulture); row.LOCATION = village.LocationString; row.NAME = village.Name; row.ISVISIBLE = World.Default.Map.Display.IsVisible(village); if (village.HasPlayer) { row.PLAYER = village.Player.Name; if (village.HasTribe) { row.TRIBE = village.Player.Tribe.Tag; } } row.POINTS = village.Points; if (village.PreviousVillageDetails != null) { row.POINTSDIFF = village.Points - village.PreviousVillageDetails.Points; if (row.POINTSDIFF == 0) { row.SetPOINTSDIFFNull(); } } else { row.SetPOINTSDIFFNull(); } row.POLYGON = polygon.Name; row.POLYGONGROUP = polygon.Group; row.POLYGONVISIBLE = polygon.Visible; row.BBCODE = village.BbCode(); VILLAGE.Rows.Add(row); }