private void buttonX4_Click(object sender, EventArgs e)
{
//if ( tBName.Text != "" && tBMail.Text != "" && tBTel.Text != "" && tbTitle.Text != "" && tbBelongs.Text != "")
//{
string EmailPattern = @"^([A-Za-z0-9]{1}[A-Za-z0-9_]*)@([A-Za-z0-9_]+)[.]([A-Za-z0-9_]*)$";//E-Mail地址格式的正则表达式
if (tBMail.Text == "" || Regex.IsMatch(tBMail.Text.Trim(), EmailPattern))
{
if (status == 1)
{
TeacherInfo teacher = new TeacherInfo();
teacher.TeacherId = tBID.Text;
teacher.TeacherName = tBName.Text;
teacher.Email = tBMail.Text;
teacher.Phone = tBTel.Text;
teacher.Title = tbTitle.Text;
teacher.IsSupervisor = cbIsDUDao.Checked;
teacher.TeachingSection = tbBelongs.Text;
SqlHelper help = new SqlHelper();
if (help.update("Teachers_Data", teacher) > 0)
{
MessageBox.Show("修改成功");
listView1.Items.Clear();
DataTable dt = pageshow.ListviewShow("select * from Teachers_Data", currentpage, pagesize, "Teachers_Data");
UIShow show = new UIShow();
show.teachers_listview_write(dt, listView1);
}
}
if (status == 0)
{
TeacherInfo teacher = new TeacherInfo();
teacher.TeacherId = tBID.Text;
teacher.TeacherName = tBName.Text;
teacher.Email = tBMail.Text;
teacher.Phone = tBTel.Text;
teacher.Title = tbTitle.Text;
teacher.IsSupervisor = cbIsDUDao.Checked;
teacher.TeachingSection = tbBelongs.Text;
SqlHelper help = new SqlHelper();
if (help.Insert(teacher, "Teachers_Data") > 0)
{
MessageBox.Show("添加成功");
}
else
{
MessageBox.Show("操作失败");
}
clear_listview();
totalpage = pageshow.totalpage("select * from Teachers_Data", pagesize, "Teachers_Data");
labPageAll.Text = totalpage + "";
textBoxNow.Text = currentpage.ToString();
DataTable dt = pageshow.ListviewShow("select * from Teachers_Data", currentpage, pagesize, "Teachers_Data");
UIShow show = new UIShow();
show.teachers_listview_write(dt, listView1);
}
this.btnsave.Enabled = false;
}
else
{
MessageBox.Show("请输入正确的邮箱地址");
}
// }
//else
//{
// MessageBox.Show("请确保数据完整");
//}
}
private void buttonX3_Click(object sender, EventArgs e)
{
PlacementInfo placement = new PlacementInfo(listView2.CheckedItems[0].SubItems[5].Text, label1.Text, cmbName.SelectedItem.ToString(),
Convert.ToInt32(textBox1.Text.Trim()), Convert.ToInt32(textBox2.Text.Trim()), Convert.ToInt32(comboBox7.SelectedItem.ToString()),
label13.Text, listView2.CheckedItems[0].SubItems[0].Text, listView2.CheckedItems[0].SubItems[1].Text, listView2.CheckedItems[0].SubItems[4].Text
, listView2.CheckedItems[0].SubItems[2].Text, listView2.CheckedItems[0].SubItems[3].Text, 0);
SqlHelper help = new SqlHelper();
DataTable dtPlacement = help.getDs("select * from Placement_Data", "Placement_Data").Tables[0];
if (string.IsNullOrEmpty(id))
{
if (dtPlacement.Select("Class_ID='" + listView2.CheckedItems[0].SubItems[5].Text + "'").Length == 0)
{
if (help.Insert(placement, "Placement_Data") > 0)
{
Main.fm.flashListview();
foreach (string supervisor in Supervisor)
{
string SpareTimeCommand = "update SpareTime_Data set IsAssigned=true where Supervisor='" + supervisor + "'" + " and Spare_Number= '" + intclassnumber + "'" + " and Spare_Day=" + day + "" + " and Spare_Week=" + week + "";
string TeacherCommand = "update Teachers_Data set Class_Totality=Class_Totality+1 where Teacher='" + supervisor + "'";
help.Oledbcommand(SpareTimeCommand);
help.Oledbcommand(TeacherCommand);
}
MessageBox.Show("添加成功");
}
else
{
MessageBox.Show("添加失败");
}
}
else
{
MessageBox.Show("请勿重复添加");
}
}
else
{
if (help.update("Placement_Data", placement) >= 0)
{
DistinctSupervisor(olds, oldsupervisors);
List<string> s = new List<string>();
List<string> j = new List<string>();
foreach (string a in oldsupervisors)
{
s.Add(a);
}
foreach (string b in Supervisor)
{
j.Add(b);
}
foreach (string old in oldsupervisors)
{
foreach (string news in Supervisor)
{
if (old.IndexOf(news) != -1 || news.IndexOf(old) != -1)
{
s.Remove(old);
j.Remove(news);
}
}
}
foreach (string supervisor in j)
{
string SpareTimeCommand = "update SpareTime_Data set IsAssigned=true where Supervisor='" + supervisor + "'" + " and Spare_Number= " + intclassnumber + "" + " and Spare_Day=" + day + "" + " and Spare_Week=" + week + "";
string TeacherCommand = "update Teachers_Data set Class_Totality=Class_Totality+1 where Teacher='" + supervisor + "'";
help.Oledbcommand(SpareTimeCommand);
help.Oledbcommand(TeacherCommand);
}
//对应的督导安排情况和总听课次数做相应的修改。
foreach (string old in s)
{
string SpareTimeCommand = "update SpareTime_Data set IsAssigned=false where Supervisor like '" + "%" + old + "%" + "'" + " and Spare_Number= " + intclassnumber + "" + " and Spare_Day=" + day + "" + " and Spare_Week=" + week + "";
string TeacherCommand = "update Teachers_Data set Class_Totality=Class_Totality-1 where Teacher like '" + "%" + old + "%" + "'";
help.Oledbcommand(SpareTimeCommand);
help.Oledbcommand(TeacherCommand);
}
Main.fm.flashListview();
MessageBox.Show("修改成功！");
oldsupervisors.Clear();
olds = label13.Text;
flashui();
}
else
{
MessageBox.Show("修改失败！");
}
}
}
