/**
* 从数据库里面查出所有的数据，展示。
* */
private void showAllAirPort()
{
List <Dictionary <string, object> > result = ProfileHelper.Instance.Select("SELECT * FROM AirPort");
airPortList.Clear();
foreach (Dictionary <string, object> dictionary in result)
{
String name = Convert.ToString(dictionary["Name"]);
double lat = Convert.ToDouble(dictionary["Lat"]);
double lang = Convert.ToDouble(dictionary["Lng"]);
int id = Convert.ToInt32(dictionary["ID"]);
double length = Convert.ToDouble(dictionary["Length"]);
int num = Convert.ToInt16(dictionary["Num"]);
Air_Port air_Port = new Air_Port(id, name, lat, lang, num, length);
airPortList.Add(air_Port);
}
this.dataGridView1.DataSource = null;
if (null != airPortList && airPortList.Count() > 0)
{
this.dataGridView1.DataSource = this.airPortList;
}
}
private void skinButton1_Click(object sender, EventArgs e)
{
String name = skinTextBox2.Text;
if (null == name || name.Length == 0)
{
MessageBox.Show("请输入机场名称！");
return;
}
if (null == skinTextBox3.Text || skinTextBox3.Text.Length == 0)
{
MessageBox.Show("请输入经纬度！");
return;
}
if (null == skinTextBox4.Text || skinTextBox4.Text.Length == 0)
{
MessageBox.Show("请输入经纬度！");
return;
}
if (null == skinTextBox1.Text || skinTextBox1.Text.Length == 0)
{
MessageBox.Show("请输入环数！");
return;
}
if (null == skinTextBox5.Text || skinTextBox5.Text.Length == 0)
{
MessageBox.Show("请输入环距离！");
return;
}
Air_Port air_Port = new Air_Port(
0,
name,
Convert.ToDouble(skinTextBox3.Text),
Convert.ToDouble(skinTextBox4.Text),
Convert.ToInt16(skinTextBox1.Text),
Convert.ToDouble(skinTextBox5.Text));
if (skinLabel2.Text.Equals("ID"))
{
// 插入数据库
ProfileHelper.Instance.Update("INSERT INTO AirPort (ID, Name, Lat, Lng, Num, Length) VALUES (NULL, '" +
air_Port.Name + "', " +
air_Port.Lat + ", " +
air_Port.Lng + ", " +
air_Port.Num + ", " +
air_Port.Length + ")");
}
else if (!string.IsNullOrWhiteSpace(skinLabel2.Text))
{
// 更新数据库
ProfileHelper.Instance.Update(
"UPDATE AirPort set " +
" Name = '" + air_Port.Name + "', " +
" Lat = " + air_Port.Lat + ", " +
" Lng = " + air_Port.Lng + ", " +
" Num = " + air_Port.Num + ", " +
" Length = " + air_Port.Length +
" where ID = " + skinLabel2.Text);
// 更新后初始化组件
skinTextBox1.Text = "";
skinTextBox2.Text = "";
skinTextBox3.Text = "";
skinTextBox4.Text = "";
skinTextBox5.Text = "";
skinButton1.Text = "新增";
}
showAllAirPort();
airPort_event(true, 1);
}
