private void RewriteProButt_Click(object sender, EventArgs e)
{
bool T = false;
GdpDrive Gdp = new GdpDrive();
List <string> idfields = new List <string>();
List <dynamic> iddata = new List <dynamic>();
switch (comboBox_List.Text.ToString())
{
case "活动名称":
idfields.Add("ActName");
break;
case "活动开始时间":
idfields.Add("ActStart");
T = true;
break;
case "活动结束时间":
idfields.Add("ActEnd");
T = true;
break;
case "描述":
idfields.Add("Describe");
break;
}
iddata.Add(textBox_Rewrite.Text.ToString());
if (T)
{
DialogResult dr = MessageBox.Show("请确认日期格式如2008-8-8！", "警告", MessageBoxButtons.OKCancel);
if (dr == DialogResult.Cancel)
{
return;
}
}
try
{
bool Judge = Gdp.ChangeTableRecord("Activity", "TID", proID.Text.ToString(), idfields, iddata);
if (Judge)
{
MessageBox.Show("修改成功！");
}
else
{
MessageBox.Show("没有该组织！");
}
}
catch
{
MessageBox.Show("输入格式有误！");
return;
}
}
private void RewriteOrgButt_Click(object sender, EventArgs e)
{
GdpDrive Gdp = new GdpDrive();
List <string> fields = new List <string>();
List <dynamic> value = new List <dynamic>();
value.Add(orgNowName.Text.ToString());
fields.Add("FullName");
bool Judge = Gdp.ChangeTableRecord("organizer", "FullName", orgPreName.Text.ToString(), fields, value);
if (Judge)
{
MessageBox.Show("修改成功！");
}
else
{
MessageBox.Show("没有该组织！");
}
}
private void AddLocationButt_Click(object sender, EventArgs e)
{
if (Convert.ToSingle(locationGrid.Rows[0].Cells[0].Value) < 73 ||
Convert.ToSingle(locationGrid.Rows[0].Cells[0].Value) > 135 ||
Convert.ToSingle(locationGrid.Rows[0].Cells[1].Value) > 53 ||
Convert.ToSingle(locationGrid.Rows[0].Cells[1].Value) < 23)
{
MessageBox.Show("经纬度输入越界，请重新输入！");
return;
}
GdpDrive Gdp = new GdpDrive();
Gdp.AddPointFeature("site", Convert.ToSingle(locationGrid.Rows[0].Cells[0].Value), Convert.ToSingle(locationGrid.Rows[0].Cells[1].Value));
List <string> fields = new List <string>();
fields.Add("Name");
List <dynamic> datas = new List <dynamic>();
datas.Add(Convert.ToString(locationGrid.Rows[0].Cells[2].Value));
Gdp.ChangeTableRecord("site", "Name", null, fields, datas);
axMapControl_Main.ActiveView.Refresh();
MessageBox.Show("添加成功");
}
