private void AddStudentButt_Click(object sender, EventArgs e)
{
GdpDrive Gdp = new GdpDrive();
Searcher SER = new Searcher();
SER.TableName = "participant";
SER.idField.Add("PID");
SER.idData.Add(studentInfoGrid.Rows[0].Cells[0].Value);
SER.Fields.Add("PID");
Gdp.Query(ref SER);
if (SER.array.Count > 0)
{
MessageBox.Show("该学生已存在！");
return;
}
List <dynamic> values = new List <dynamic>();
for (int i = 0; i < 5; i++)
{
values.Add(studentInfoGrid.Rows[0].Cells[i].Value);
}
Gdp.AddTableRecord("participant", values);
MessageBox.Show("添加成功！");
}
private void signUpButt_Click(object sender, EventArgs e)
{
// 选择地图上的学校，点击报名
if (signUpGrid.Rows[0].Cells[0].Value == null)
{
MessageBox.Show("请选择学校");
}
else
{
string PTID = logForm.textBox_User.Text;
string TTID = Convert.ToString(signUpGrid.Rows[0].Cells[0].Value);
Searcher pJudge = new Searcher();
pJudge.TableName = "PANexus";
pJudge.idField.Add("PID");
pJudge.idData.Add(PTID);
pJudge.idField.Add("TID");
pJudge.idData.Add(TTID);
pJudge.Fields.Add("TID");
GdpDrive Gdp = new GdpDrive();
Gdp.Query(ref pJudge);
if (pJudge.array.Count > 0)
{
MessageBox.Show("请勿重复报名！");
return;
}
Gdp.AddTableRecord("PANexus", pJudge.idData);
MessageBox.Show("报名成功！");
}
}
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 bool UserJudge(UserLog User)
{
Searcher ER = new Searcher();
switch (flag)
{
case 2:
ER.TableName = "participant";
ER.idField.Add("PID");
break;
case 3:
ER.TableName = "organizer";
ER.idField.Add("OID");
break;
default:
ER.TableName = "Admin";
ER.idField.Add("AID");
break;
}
ER.idField.Add("PassWord");
ER.idData.Add(User.name);
ER.idData.Add(User.password);
ER.Fields.Add("PassWord");
GdpDrive Gdp = new GdpDrive();
Gdp.Query(ref ER);
if (ER.array.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
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("添加成功");
}
private void AddProButt_Click(object sender, EventArgs e)
{
GdpDrive Gdp = new GdpDrive();
Searcher SER = new Searcher();
List <dynamic> values = new List <dynamic>();
if (SiteID < 0)
{
MessageBox.Show("未选中活动点！");
return;
}
SER.TableName = "SANexus";
SER.idField.Add("SID");
SER.idData.Add(SiteID);
SER.Fields.Add("TID");
Gdp.Query(ref SER);
if (SER.array.Count > 0)
{
MessageBox.Show("该地已有活动！");
return;
}
SER.idField[0] = "TID";
SER.idData[0] = Convert.ToString(proInfoGrid.Rows[0].Cells[0].Value);
Gdp.Query(ref SER);
if (SER.array.Count > 0)
{
MessageBox.Show("该活动ID已存在！");
return;
}
DialogResult dr = MessageBox.Show("请确认日期格式如2008-8-8！", "警告", MessageBoxButtons.OKCancel);
if (dr == DialogResult.Cancel)
{
return;
}
values.Clear();
for (int i = 0; i < 5; i++)
{
values.Add(proInfoGrid.Rows[0].Cells[i].Value);
}
try { Gdp.AddTableRecord("Activity", values); }
catch
{
MessageBox.Show("日期格式有误！");
return;
}
values.Clear();
values.Add(proInfoGrid.Rows[0].Cells[0].Value);
values.Add(SiteID);
Gdp.AddTableRecord("SANexus", values);
values.Clear();
values.Add(logForm.textBox_User.Text);
values.Add(proInfoGrid.Rows[0].Cells[0].Value);
Gdp.AddTableRecord("OANexus", values);
}
// 在地图上点击学校，获取支教信息
private void axMapControl_Main_OnMouseDown(object sender, ESRI.ArcGIS.Controls.IMapControlEvents2_OnMouseDownEvent e)
{
// 选择学校
IMap pMap = axMapControl_Main.Map;
IEnumLayer pEnumLayer = pMap.get_Layers(null, true);
pEnumLayer.Reset();
ILayer pLayer = pEnumLayer.Next();
IFeatureLayer pFeatureLayer;
while (pLayer != null)
{
if (pLayer.Name == "china")
{
pFeatureLayer = (IFeatureLayer)pLayer;
pFeatureLayer.Selectable = false;
}
pLayer = pEnumLayer.Next();
}
IGeometry selectGeometry = null;
IEnvelope pEnv;
IActiveView pActiveView = axMapControl_Main.ActiveView;
pEnv = axMapControl_Main.TrackRectangle();
if (pEnv.IsEmpty == true)
{
ESRI.ArcGIS.esriSystem.tagRECT r;
r.bottom = e.y + 5;
r.top = e.y - 5;
r.left = e.x - 5;
r.right = e.x + 5;
pActiveView.ScreenDisplay.DisplayTransformation.TransformRect(pEnv, ref r, 4);
pEnv.SpatialReference = pActiveView.FocusMap.SpatialReference;
}
selectGeometry = pEnv as IGeometry;
axMapControl_Main.Map.ClearSelection();
axMapControl_Main.Refresh(esriViewDrawPhase.esriViewGeoSelection, null, null);
axMapControl_Main.Map.SelectByShape(selectGeometry, null, false);
axMapControl_Main.Refresh(esriViewDrawPhase.esriViewGeoSelection, null, null);
// 显示信息
ISelection pselect = pMap.FeatureSelection;
IEnumFeatureSetup pEnumFeatureSetup = (IEnumFeatureSetup)pselect;
pEnumFeatureSetup.AllFields = true;
IEnumFeature pEnumFeature = (IEnumFeature)pEnumFeatureSetup;
//pEnumFeature.Reset();
pfeature = pEnumFeature.Next();
if (pfeature == null)
{
return;
}
SiteID = pfeature.get_Value(0);
GdpDrive Gdp = new GdpDrive();
Searcher GDs = new Searcher();
GDs.TableName = "SANexus";
GDs.idField.Add("SID");
GDs.idData.Add(SiteID);
GDs.Fields.Add("TID");
Gdp.Query(ref GDs);
if (GDs.array.Count < 1)
{
MessageBox.Show("该地区无支教活动！");
return;
}
LookUp(GDs.array[0][0]);
//resultGrid.Rows[0].Cells[0].Value = name;
//signUpGrid.Rows[0].Cells[0].Value = pfeature.get_Value(2).ToString();
}
