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