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