public SearchBrowseStudent()
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
//测试数据连接
string errorstring;
errorstring = conn.ExeSql("Select * FROM School");
if (errorstring != "OK")
{
MessageBox.Show("请检查本地数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
string str_Sql = "Select * from Class";
if (conn.GetRowCount(str_Sql) == 0)
{
MessageBox.Show("请先输入班级信息！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
//conn.BindComboBox("Select * FROM School Order By School_Type_ID,School_ID",comboBox_School,"School_ID","School_Name");
conn.BindComboBox("SELECT QuXian_Code,QuXian_Name FROM QuXian", comboBox_QuXian, "QuXian_Code", "QuXian_Name");
conn.BindComboBox("SELECT QuXian_ID,QuXian_Name FROM QuXian", comboBox_Student_QuXian, "QuXian_ID", "QuXian_Name");
str_Sql = "SELECT School_Name AS 学校名称,Class_Type_Name AS 年级,Class_Name AS 班级,Student_ID As 身份证号码,Name As 姓名,Sex AS 性别,convert(char(10),Birthday,120) As 出生日期,Father AS 父亲,Mother AS 母亲,Keeper AS 监护人,StudentTel AS 联系电话,Student_Address AS 家庭住址,Father_Job AS 父亲职业,Father_XueLi AS 父亲学历,Mother_Job AS 母亲职业,Mother_XueLi AS 母亲学历 FROM View_StudentClass_Detail_City Where School_ID='000'"; //"+comboBox_School.SelectedValue+"'";
errorstring = conn.Fill(str_Sql);
if (errorstring != "OK")
{
MessageBox.Show("查找失败！请检查数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
DataGrid1.SetDataBinding(conn.ds, "TableIn");
DataGridTableStyle MyStyle = new DataGridTableStyle();
MyStyle.MappingName = "TableIn";
DataGrid1.TableStyles.Add(MyStyle);
MyStyle.GridColumnStyles["学校名称"].Width = 150;
MyStyle.GridColumnStyles["身份证号码"].Width = 120;
MyStyle.GridColumnStyles["性别"].Width = 30;
MyStyle.GridColumnStyles["家庭住址"].Width = 200;
MyStyle.GridColumnStyles["联系电话"].Width = 80;
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
private void button1_Click(object sender, System.EventArgs e)
{
if (conn.KickOut(textBox_UserName.Text) == "")
{
MessageBox.Show("必须输入用户名！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (conn.KickOut(textBox_PassWord.Text) == "")
{
MessageBox.Show("必须输入密码！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (conn.Sniffer_In(textBox_PassWord.Text) || conn.Sniffer_In(textBox_UserName.Text))
{
MessageBox.Show("用户名或密码不得用空格或者'\"?%=空格！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
//去除'"?%=空格,修改用户表
string errorstring = "", str_ReadOnly, str_Sql;
if (checkBox_ReadOnly.Checked == true)
{
str_ReadOnly = "1";
}
else
{
str_ReadOnly = "0";
}
str_Sql = "Update Users SET PassWord='******',ReadOnly=" + str_ReadOnly + " Where UserName='******'";
errorstring = conn.ExeSql(str_Sql);
if (errorstring != "OK")
{
MessageBox.Show("未成功修改！请检查数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
MessageBox.Show("成功修改！", "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
//刷新DataGrid显示,置空各信息项,等待选中新的有效项
str_Sql = "SELECT UserName AS 用户名,PassWord AS 密码,ReadOnly AS 仅为只读用户 FROM Users";
conn.Fill(str_Sql);
DataGrid1.SetDataBinding(conn.ds, "TableIn");
textBox_UserName.Text = "";
textBox_PassWord.Text = "";
checkBox_ReadOnly.Checked = true;
button1.Enabled = false;
}
private void button1_Click(object sender, System.EventArgs e)
{
if (textBox_School_ID.Text == "" || textBox2_School_Name.Text == "")
{
MessageBox.Show("必须输入学校名称和学校代码！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (textBox_School_ID.Text.Length != 12 || textBox2_School_Name.Text.Length > 50 || textBox_Schoolmaster.Text.Length > 50 || textBox_School_Tel.Text.Length > 20 || textBox_School_Zip.Text.Length > 6 || textBox_School_Address.Text.Length > 100)
{
MessageBox.Show("请不要超长输入！\r\n学校代码只能为12位！\r\n邮编只能为六位数！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
//去除'"?%=空格,修改学校信息表
string errorstring = "";
string str_Sql = "UPDATE School SET School_Name='" + conn.KickOut(textBox2_School_Name.Text)
+ "',School_Type_ID=" + comboBox1_School_Type.SelectedValue.ToString()
+ ",Schoolmaster='" + conn.KickOut(textBox_Schoolmaster.Text)
+ "',School_Tel='" + conn.KickOut(textBox_School_Tel.Text)
+ "',School_Zip='" + conn.KickOut(textBox_School_Zip.Text)
+ "',School_Address='" + conn.KickOut(textBox_School_Address.Text)
+ "' WHERE School_ID='" + conn.KickOut(textBox_School_ID.Text) + "'";
errorstring = conn.ExeSql(str_Sql);
if (errorstring != "OK")
{
MessageBox.Show("未成功修改！请检查数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
MessageBox.Show("成功修改！", "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
//刷新DataGrid显示,置空各信息项,等待选中新的有效项
str_Sql = "SELECT School_ID AS 学校代码,School_Name AS 学校名称,School_Type_Name AS 学校类别,Schoolmaster AS 校长,School_Tel AS 电话,School_Zip AS 邮政编码,School_Address AS 学校地址,School_Type_Year AS 学校学制年限 FROM View_School";
conn.Fill(str_Sql);
DataGrid1.SetDataBinding(conn.ds, "TableIn");
textBox_School_ID.Text = "";
textBox2_School_Name.Text = "";
textBox_Schoolmaster.Text = "";
textBox_School_Tel.Text = "";
textBox_School_Zip.Text = "";
textBox_School_Address.Text = "";
button1.Enabled = false;;
}
private void button1_Click(object sender, System.EventArgs e)
{
if (comboBox_Office.SelectedItem == null)
{
MessageBox.Show("请选择该居委会所在办事处！", "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (conn.KickOut(textBox_Committee_Name.Text) == "")
{
MessageBox.Show("必须输入居委会名称！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (textBox_Committee_Name.Text.Length > 15)
{
MessageBox.Show("请不要超长输入居委会名称！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
//去除'"?%=空格,插入办事处表
string str_Sql, errorstring = "";
str_Sql = "INSERT INTO Committee (Committee_ID,Committee_Name,Office_ID) values("
+ conn.KickOut(textBox_Committee_ID.Text.Trim()) + ",'"
+ conn.KickOut(textBox_Committee_Name.Text.Trim())
+ "'," + comboBox_Office.SelectedValue.ToString() + ")";
errorstring = conn.ExeSql(str_Sql);
if (errorstring != "OK")
{
MessageBox.Show("未成功添加！请检查数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
//MessageBox.Show("成功添加！", "提醒！",MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
//刷新DataGrid显示,选中最后一行反色显示
str_Sql = "SELECT Committee_ID AS 居委会代码,Committee_Name AS 居委会名称,Office_Name AS 办事处名称,QuXian_Name AS 区县名称 FROM View_Committee";
conn.Fill(str_Sql);
DataGrid1.SetDataBinding(conn.ds, "TableIn");
DataGrid1.Select(conn.ds.Tables["TableIn"].Rows.Count - 1);
textBox_Committee_ID.Text = conn.GetMaxId("Committee_ID", "Committee");
textBox_Committee_Name.Text = "";
}
private void button1_Click(object sender, System.EventArgs e)
{
string errorstring = "", str_Sql = "";
//DELETE from School WHERE School_ID='"+textBox_School_ID.Text+"'";
DialogResult result = MessageBox.Show(this, "真的要进行删除吗?", "提醒！", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (result == DialogResult.OK)
{
str_Sql = "DELETE from Student WHERE School_ID='" + textBox_School_ID.Text + "'";
errorstring = conn.ExeSql(str_Sql);
str_Sql = "DELETE from Class WHERE School_ID='" + textBox_School_ID.Text + "'";
errorstring = conn.ExeSql(str_Sql);
str_Sql = "DELETE from Teacher WHERE School_ID='" + textBox_School_ID.Text + "'";
errorstring = conn.ExeSql(str_Sql);
str_Sql = "DELETE from School WHERE School_ID='" + textBox_School_ID.Text + "'";
errorstring = conn.ExeSql(str_Sql);
if (errorstring != "OK")
{
MessageBox.Show("未成功删除！请检查本地数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
MessageBox.Show("成功删除！", "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
return;
}
str_Sql = "SELECT School_ID AS 学校代码,School_Name AS 学校名称,School_Type_Name AS 学校类别,Schoolmaster AS 校长,School_Tel AS 电话,School_Zip AS 邮政编码,School_Address AS 学校地址,School_Type_Year AS 学校学制年限 FROM View_School";
conn.Fill(str_Sql);
DataGrid1.SetDataBinding(conn.ds, "TableIn");
button1.Enabled = false;
}
private void button1_Click(object sender, System.EventArgs e)
{
if (comboBox_Office.SelectedItem == null)
{
MessageBox.Show("请选择该居委会所在办事处！", "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (conn.KickOut(textBox_Committee_Name.Text) == "")
{
MessageBox.Show("必须输入居委会名称！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (textBox_Committee_Name.Text.Length > 15)
{
MessageBox.Show("请不要超长输入居委会名称！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
//去除'"?%=空格,修改办事处表
string str_Sql, errorstring = "";
str_Sql = "UPDATE Committee SET Committee_Name='" + conn.KickOut(textBox_Committee_Name.Text)
+ "',Office_ID=" + comboBox_Office.SelectedValue.ToString()
+ " WHERE Committee_ID=" + textBox_Committee_ID.Text;
errorstring = conn.ExeSql(str_Sql);
if (errorstring != "OK")
{
MessageBox.Show("修改不成功！请检查数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
MessageBox.Show("成功修改！", "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
//刷新DataGrid显示,选中最后一行反色显示
str_Sql = "SELECT Committee_ID AS 居委会代码,Committee_Name AS 居委会名称,Office_Name AS 办事处名称,QuXian_Name AS 区县名称 FROM View_Committee";
conn.Fill(str_Sql);
DataGrid1.SetDataBinding(conn.ds, "TableIn");
textBox_Committee_Name.Text = "";
}
private void button1_Click(object sender, System.EventArgs e)
{
if (conn.KickOut(textBox_Office_Name.Text) == "")
{
MessageBox.Show("必须输入办事处名称！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (textBox_Office_Name.Text.Length > 15)
{
MessageBox.Show("请不要超长输入办事处名称！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
//去除'"?%=空格,修改办事处表
string str_Sql, errorstring = "";
str_Sql = "UPDATE Office SET Office_Name='" + conn.KickOut(textBox_Office_Name.Text)
+ "',QuXian_ID_OfficeIn=" + comboBox1_QuXian.SelectedValue
+ " WHERE Office_ID=" + textBox_Office_ID.Text;
errorstring = conn.ExeSql(str_Sql);
if (errorstring != "OK")
{
MessageBox.Show("修改不成功！请检查数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
MessageBox.Show("成功修改！", "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
//刷新DataGrid显示,置空各信息项,等待选中新的有效项
str_Sql = "SELECT Office.Office_ID AS 办事处代码,Office.Office_Name AS 办事处名称,QuXian.QuXian_Name AS 所在区县 FROM Office inner join QuXian on Office.QuXian_ID_OfficeIn=QuXian.QuXian_ID ";
conn.Fill(str_Sql);
DataGrid1.SetDataBinding(conn.ds, "TableIn");
textBox_Office_ID.Text = "";
textBox_Office_Name.Text = "";
button1.Enabled = false;
}
private void button1_Click(object sender, System.EventArgs e)
{
if (conn.KickOut(textBox_Class_Type_Name.Text) == "")
{
MessageBox.Show("必须输入班级类型名称！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (textBox_Class_Type_Name.Text.Length > 15)
{
MessageBox.Show("请不要超长输入班级类型名称！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
//去除'"?%=空格,修改班级类型表
string str_Sql, errorstring = "";
str_Sql = "UPDATE Class_Type SET Class_Type_Name='" + conn.KickOut(textBox_Class_Type_Name.Text)
+ "' WHERE Class_Type_ID=" + textBox_Class_Type_ID.Text;
errorstring = conn.ExeSql(str_Sql);
if (errorstring != "OK")
{
MessageBox.Show("修改不成功！请检查数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
MessageBox.Show("成功修改！", "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
//刷新DataGrid显示,置空各信息项,等待选中新的有效项
str_Sql = "SELECT Class_Type.Class_Type_ID AS 班级类别代码,Class_Type.Class_Type_Name AS 班级类别名,School_Type.School_Type_Name AS 学校类别名 FROM Class_Type inner join School_Type on Class_Type.School_Type_ID_Class_Belong=School_Type.School_Type_ID";
conn.Fill(str_Sql);
DataGrid1.SetDataBinding(conn.ds, "TableIn");
textBox_Class_Type_ID.Text = "";
textBox_Class_Type_Name.Text = "";
textBox_School_Type.Text = "";
button1.Enabled = false;
}
private void button1_Click(object sender, System.EventArgs e)
{
if (conn.KickOut(textBox_School_Type_Name.Text) == "")
{
MessageBox.Show("必须输入学校类型名称！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (textBox_School_Type_Name.Text.Length > 15)
{
MessageBox.Show("请不要超长输入学校类型名称！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
//去除'"?%=空格,修改学校类型表
string str_Sql, errorstring = "";
str_Sql = "UPDATE School_Type SET School_Type_Name='" + conn.KickOut(textBox_School_Type_Name.Text)
+ "',School_Type_Year=" + numericUpDown1.Value.ToString()
+ " WHERE School_Type_ID=" + textBox_School_Type_ID.Text;
errorstring = conn.ExeSql(str_Sql);
if (errorstring != "OK")
{
MessageBox.Show("修改不成功！请检查数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
MessageBox.Show("成功修改！", "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
//刷新DataGrid显示,置空各信息项,等待选中新的有效项
str_Sql = "SELECT School_Type_ID As 学校类别代码,School_Type_Name As 学校类别名,School_Type_Year As 学校类别学制 FROM School_Type";
conn.Fill(str_Sql);
DataGrid1.SetDataBinding(conn.ds, "TableIn");
textBox_School_Type_ID.Text = "";
textBox_School_Type_Name.Text = "";
button1.Enabled = false;
}
private void button1_Click(object sender, System.EventArgs e)
{
if (conn.KickOut(textBox_QuXian_Name.Text) == "")
{
MessageBox.Show("必须输入区县名称！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (textBox_QuXian_Name.Text.Length > 15)
{
MessageBox.Show("请不要超长输入区县名称！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
//去除'"?%=空格,修改学校类型表
string str_Sql, errorstring = "";
str_Sql = "UPDATE QuXian SET QuXian_Name='" + conn.KickOut(textBox_QuXian_Name.Text)
+ "' WHERE QuXian_ID=" + textBox_QuXian_ID.Text;
errorstring = conn.ExeSql(str_Sql);
if (errorstring != "OK")
{
MessageBox.Show("修改不成功！请检查数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
MessageBox.Show("成功修改！", "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
//刷新DataGrid显示,置空各信息项,等待选中新的有效项
str_Sql = "SELECT QuXian.QuXian_ID AS 区县代码,QuXian.QuXian_Name AS 区县名称 FROM QuXian";
conn.Fill(str_Sql);
DataGrid1.SetDataBinding(conn.ds, "TableIn");
textBox_QuXian_ID.Text = "";
textBox_QuXian_Name.Text = "";
button1.Enabled = false;
}
private void button1_Click(object sender, System.EventArgs e)
{
if (conn.KickOut(textBox_Class_Type_Name.Text) == "")
{
MessageBox.Show("必须输入班级类型名称！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (textBox_Class_Type_Name.Text.Length > 15)
{
MessageBox.Show("请不要超长输入班级类型名称！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
//去除'"?%=空格,插入班级类型表
string str_Sql, errorstring = "";
str_Sql = "INSERT INTO Class_Type values(" + textBox_Class_Type_ID.Text.Trim() + ",'"
+ conn.KickOut(textBox_Class_Type_Name.Text.Trim()) + "',"
+ comboBox1_School_Type.SelectedValue.ToString() + ")";
errorstring = conn.ExeSql(str_Sql);
if (errorstring != "OK")
{
MessageBox.Show("未成功添加！请检查数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
MessageBox.Show("成功添加！", "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
//刷新DataGrid显示,选中最后一行反色显示
str_Sql = "SELECT Class_Type.Class_Type_ID AS 班级类别代码,Class_Type.Class_Type_Name AS 班级类别名,School_Type.School_Type_Name AS 学校类别名 FROM Class_Type inner join School_Type on Class_Type.School_Type_ID=School_Type.School_Type_ID";
conn.Fill(str_Sql);
DataGrid1.SetDataBinding(conn.ds, "TableIn");
DataGrid1.Select(conn.ds.Tables["TableIn"].Rows.Count - 1);
textBox_Class_Type_ID.Text = conn.GetMaxId("Class_Type_ID", "Class_Type");
}
private void button1_Click(object sender, System.EventArgs e)
{
string errorstring = "", str_Sql = "DELETE from Users WHERE UserName='******'";
if (textBox_UserName.Text == "Admin")
{
MessageBox.Show(" 不能删除超级用户！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
DialogResult result = MessageBox.Show(this, "真的要进行删除吗?", "提醒！", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (result == DialogResult.OK)
{
errorstring = conn.ExeSql(str_Sql);
if (errorstring != "OK")
{
MessageBox.Show("未成功删除！请检查本地数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
MessageBox.Show("成功删除！", "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
return;
}
//显示当前所有用户的DataGrid
str_Sql = "SELECT UserName AS 用户名,PassWord AS 密码,ReadOnly AS 仅为只读用户 FROM Users";
conn.Fill(str_Sql);
DataGrid1.SetDataBinding(conn.ds, "TableIn");
//信息清空,未选中用户,删除按钮失效
textBox_UserName.Text = "";
textBox_PassWord.Text = "";
checkBox_ReadOnly.Checked = true;
button1.Enabled = false;
}
private void button1_Click(object sender, System.EventArgs e)
{
if (conn.KickOut(textBox_Office_Name.Text) == "")
{
MessageBox.Show("必须输入办事处名称！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (textBox_Office_Name.Text.Length > 15)
{
MessageBox.Show("请不要超长输入办事处名称！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
//去除'"?%=空格,插入办事处表
string str_Sql, errorstring = "";
str_Sql = "INSERT INTO Office values(" + conn.KickOut(textBox_Office_ID.Text.Trim()) + ",'"
+ conn.KickOut(textBox_Office_Name.Text.Trim()) + "'," + conn.KickOut(comboBox1_QuXian_ID.SelectedValue.ToString()) + ")";
errorstring = conn.ExeSql(str_Sql);
if (errorstring != "OK")
{
MessageBox.Show("未成功添加！请检查数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
MessageBox.Show("成功添加！", "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
//刷新DataGrid显示,选中最后一行反色显示
str_Sql = "SELECT Office.Office_ID AS 办事处代码,Office.Office_Name AS 办事处名称,QuXian.QuXian_Name AS 区县名称 FROM QuXian inner join Office on QuXian.QuXian_ID=Office.QuXian_ID_OfficeIn";
conn.Fill(str_Sql);
DataGrid1.SetDataBinding(conn.ds, "TableIn");
DataGrid1.Select(conn.ds.Tables["TableIn"].Rows.Count - 1);
textBox_Office_Name.Text = "";
textBox_Office_ID.Text = conn.GetMaxId("Office_ID", "Office");
}
private void button1_Click(object sender, System.EventArgs e)
{
if (conn.KickOut(textBox_School_Type_Name.Text) == "")
{
MessageBox.Show("必须输入学校类型名称！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (textBox_School_Type_Name.Text.Length > 15)
{
MessageBox.Show("请不要超长输入学校类型名称！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
string str_Sql, errorstring = "";
str_Sql = "INSERT INTO School_Type values(" + textBox_School_Type_ID.Text.Trim() + ",'"
+ conn.KickOut(textBox_School_Type_Name.Text.Trim()) + "',"
+ numericUpDown1.Value.ToString() + ")";
errorstring = conn.ExeSql(str_Sql);
if (errorstring != "OK")
{
MessageBox.Show("未成功添加！请检查数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
MessageBox.Show("成功添加！", "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
str_Sql = "SELECT School_Type_ID As 学校类别代码,School_Type_Name As 学校类别名,School_Type_Year As 学校类别学制 FROM School_Type";
conn.Fill(str_Sql);
DataGrid1.SetDataBinding(conn.ds, "TableIn");
DataGrid1.Select(conn.ds.Tables["TableIn"].Rows.Count - 1);
textBox_School_Type_ID.Text = conn.GetMaxId("School_Type_ID", "School_Type");
}
private void button1_Click(object sender, System.EventArgs e)
{
if (conn.KickOut(textBox_New_School_ID.Text) == "")
{
MessageBox.Show("必须输入学校代码！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (textBox_New_School_ID.Text.Length != 12)
{
MessageBox.Show("学校代码只能为12位！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (conn.School_ID_Had(textBox_New_School_ID.Text))
{
MessageBox.Show("请不要输入重复的学校代码！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
//转存学校信息，需要删除
string str_Sql = "Select * from School Where School_ID='" + textBox_Old_School_ID.Text + "'";
string errorstring = conn.Fill(str_Sql);
conn.dr = conn.ds.Tables[0].Rows[0];
str_Sql = "insert into School (School_ID,School_Name,School_Type_ID,Schoolmaster,School_Tel,School_Zip,School_Address) values ('"
+ conn.KickOut(textBox_New_School_ID.Text) + "','"
+ conn.dr["School_Name"].ToString() + "',"
+ conn.dr["School_Type_ID"].ToString() + ",'"
+ conn.dr["Schoolmaster"].ToString() + "','"
+ conn.dr["School_Tel"].ToString() + "','"
+ conn.dr["School_Zip"].ToString() + "','"
+ conn.dr["School_Address"].ToString() + "')";
errorstring = conn.ExeSql(str_Sql);
//更新教师信息，不用删除
str_Sql = "Update Teacher Set School_ID='" + textBox_New_School_ID.Text
+ "' Where School_ID='" + textBox_Old_School_ID.Text + "'";
errorstring = conn.ExeSql(str_Sql);
//转存班级信息，需要删除
conn.ds.Reset();
str_Sql = "Select * from Class Where School_ID='" + textBox_Old_School_ID.Text + "'";
errorstring = conn.Fill(str_Sql);
for (int i = 0; i < conn.ds.Tables[0].Rows.Count; i++)
{
conn.dr = conn.ds.Tables[0].Rows[i];
str_Sql = "INSERT INTO Class (Class_ID,School_ID,Class_Type_ID,Class_Name,TeacherInCharge) values("
+ conn.dr["Class_ID"].ToString() + ",'"
+ textBox_New_School_ID.Text + "',"
+ conn.dr["Class_Type_ID"].ToString() + ",'"
+ conn.dr["Class_Name"].ToString() + "','"
+ conn.dr["TeacherInCharge"].ToString() + "')";
errorstring = conn.ExeSql(str_Sql);
}
//转存学生信息，不需要删除
str_Sql = "Update Student Set School_ID='" + textBox_New_School_ID.Text
+ "' Where School_ID='" + textBox_Old_School_ID.Text + "'";
errorstring = conn.ExeSql(str_Sql);
//删除该学校代码对应的所有信息,先删除学生,再删除班级,最后删除学校,以防外键冲突
str_Sql = "DELETE from Class WHERE School_ID='" + textBox_Old_School_ID.Text + "'";
conn.ExeSql(str_Sql);
str_Sql = "DELETE from School WHERE School_ID='" + textBox_Old_School_ID.Text + "'";
conn.ExeSql(str_Sql);
MessageBox.Show("成功修改！", "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
}
private void button1_Click(object sender, System.EventArgs e)
{
if (conn.KickOut(textBox_UserName.Text) == "")
{
MessageBox.Show("必须输入用户名！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (textBox_UserName.Text.Length > 20)
{
MessageBox.Show("请不要超长输入用户名！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
bool bool_UserName_Had = true;
try
{
bool_UserName_Had = conn.UserName_Had(textBox_UserName.Text);
}
catch
{
MessageBox.Show("数据库错误！！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
if (bool_UserName_Had == true)
{
MessageBox.Show("请不要输入重复的用户名！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (textBox_PassWord.Text == "")
{
MessageBox.Show("必须输入密码！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (textBox_PassWord.Text.Length > 20)
{
MessageBox.Show("请不要超长输入密码！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (conn.Sniffer_In(textBox_PassWord.Text) || conn.Sniffer_In(textBox_UserName.Text))
{
MessageBox.Show("用户名或密码不得用空格或者'\"?%=空格！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
//去除'"?%=空格,插入办事处表
string errorstring = "", str_ReadOnly, str_Sql;
if (checkBox_ReadOnly.Checked == true)
{
str_ReadOnly = "1";
}
else
{
str_ReadOnly = "0";
}
str_Sql = "insert into Users (UserName,PassWord,ReadOnly) values ('"
+ conn.KickOut(textBox_UserName.Text) + "','" + conn.KickOut(textBox_PassWord.Text) + "'," + str_ReadOnly + ")";
errorstring = conn.ExeSql(str_Sql);
if (errorstring != "OK")
{
MessageBox.Show("未成功添加！请检查数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
MessageBox.Show("成功添加！", "提醒！", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
//刷新DataGrid显示
str_Sql = "SELECT UserName AS 用户名,PassWord AS 密码,ReadOnly AS 仅为只读用户 FROM Users";
try
{
errorstring = conn.Fill(str_Sql);
}
catch
{
MessageBox.Show(errorstring, "提醒！", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
conn.Close();
}
DataGrid1.SetDataBinding(conn.ds, "TableIn");
textBox_UserName.Text = "";
textBox_PassWord.Text = "";
checkBox_ReadOnly.Checked = true;
}
private void button1_Click(object sender, System.EventArgs e)
{
string str_Sql, errorstring = "";
if (conn.KickOut(textBox_School_ID.Text) == "")
{
MessageBox.Show("必须输入学校代码！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (conn.KickOut(textBox2_School_Name.Text) == "")
{
MessageBox.Show("必须输入学校名称！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (textBox_School_ID.Text.Length != 12)
{
MessageBox.Show("学校代码只能为12位！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (textBox2_School_Name.Text.Length > 50)
{
MessageBox.Show("请不要超长输入学校名称！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (textBox_Schoolmaster.Text.Length > 50)
{
MessageBox.Show("请不要超长输入校长名！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (textBox_School_Tel.Text.Length > 20)
{
MessageBox.Show("请不要超长输入电话号码！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (textBox_School_Zip.Text.Length != 6)
{
MessageBox.Show("邮编只能为六位数！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (textBox_School_Address.Text.Length > 100)
{
MessageBox.Show("请不要超长输入地址！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (conn.School_ID_Had(textBox_School_ID.Text))
{
MessageBox.Show("请不要输入重复的学校代码！", "警告！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
//去除'"?%=空格,插入办事处表
str_Sql = "insert into School (School_ID,School_Name,School_Type_ID,Schoolmaster,School_Tel,School_Zip,School_Address) values ('"
+ conn.KickOut(textBox_School_ID.Text) + "','" + conn.KickOut(textBox2_School_Name.Text) + "',"
+ comboBox1_School_Type.SelectedValue.ToString() + ",'"
+ conn.KickOut(textBox_Schoolmaster.Text) + "','"
+ conn.KickOut(textBox_School_Tel.Text) + "','"
+ conn.KickOut(textBox_School_Zip.Text) + "','"
+ conn.KickOut(textBox_School_Address.Text) + "')";
errorstring = conn.ExeSql(str_Sql);
if (errorstring != "OK")
{
MessageBox.Show("未成功添加！请检查数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
MessageBox.Show("成功添加！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
//刷新DataGrid显示
str_Sql = "SELECT School_ID AS 学校代码,School_Name AS 学校名称,School_Type_Name AS 学校类别,Schoolmaster AS 校长,School_Tel AS 电话,School_Zip AS 邮政编码,School_Address AS 学校地址,School_Type_Year AS 学校学制年限 FROM View_School";
errorstring = conn.Fill(str_Sql);
if (errorstring != "OK")
{
MessageBox.Show("请检查数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
DataGrid1.SetDataBinding(conn.ds, "TableIn");
}
private void button1_Click(object sender, System.EventArgs e)
{
button1.Enabled = false;
string str_Sql, errorstring = "OK", str_School_ID_In;
StringBuilder StringBuilder_Sql = new StringBuilder();
connSchool.ds.Reset();
try
{
connSchool.ds.ReadXmlSchema(textBox_LocationDBOut.Text + "\\School.xsd");
connSchool.ds.ReadXml(textBox_LocationDBOut.Text + "\\School.xml");
}
catch
{ //对话框
MessageBox.Show("School文件打开失败！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
int SchoolCount = connSchool.ds.Tables[0].Rows.Count;
//导入班级信息
connClass.ds.Reset();
try
{
connClass.ds.ReadXmlSchema(textBox_LocationDBOut.Text + "\\Class.xsd");
connClass.ds.ReadXml(textBox_LocationDBOut.Text + "\\Class.xml");
}
catch
{ //对话框
MessageBox.Show("Class文件打开失败！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
//导入教师信息
connTeacher.ds.Reset();
try
{
connTeacher.ds.ReadXmlSchema(textBox_LocationDBOut.Text + "\\Teacher.xsd");
connTeacher.ds.ReadXml(textBox_LocationDBOut.Text + "\\Teacher.xml");
}
catch
{ //对话框
MessageBox.Show("Teacher文件打开失败！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
//导入学生信息
connStudent.ds.Reset();
try
{
connStudent.ds.ReadXmlSchema(textBox_LocationDBOut.Text + "\\Student.xsd");
connStudent.ds.ReadXml(textBox_LocationDBOut.Text + "\\Student.xml");
}
catch
{ //对话框
MessageBox.Show("Student文件打开失败！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
for (int indexSchool = 0; indexSchool < SchoolCount; indexSchool++)
{
connSchool.dr = connSchool.ds.Tables[0].Rows[indexSchool];
str_School_ID_In = connSchool.dr["School_ID"].ToString();
DialogResult result;
/*各种验证
* if(conn.School_ID_Had(str_School_ID_In))
* {
* result=MessageBox.Show(this,"真的要导入学校代码为 "+str_School_ID_In+" 的学校吗?"
+"其学校名称为"+conn.School_IDtoWhat(str_School_ID_In,"School_Name")
+"操作会替换该学校原有的所有信息","提醒！",
* MessageBoxButtons.OKCancel,MessageBoxIcon.Question);
* }
* else
* {
* result=MessageBox.Show(this,"真的要导入吗?","提醒！",
* MessageBoxButtons.OKCancel,MessageBoxIcon.Question);
* }
*
* if (result==DialogResult.OK)*/
{
//删除该学校代码对应的所有信息,先删除学生,再删除班级,最后删除学校,以防外键冲突
str_Sql = "DELETE from Student WHERE School_ID='" + str_School_ID_In + "'";
conn.ExeSql(str_Sql);
str_Sql = "DELETE from Class WHERE School_ID='" + str_School_ID_In + "'";
conn.ExeSql(str_Sql);
str_Sql = "DELETE from Teacher WHERE School_ID='" + str_School_ID_In + "'";
conn.ExeSql(str_Sql);
str_Sql = "DELETE from School WHERE School_ID='" + str_School_ID_In + "'";
conn.ExeSql(str_Sql);
// str_Sql="insert into School (School_ID,School_Name,School_Type_ID,Schoolmaster,School_Tel,School_Zip,School_Address) values ('"
// +str_School_ID_In+"','"
// +connSchool.dr["School_Name"].ToString()+"',"
// +connSchool.dr["School_Type_ID"].ToString()+",'"
// +connSchool.dr["Schoolmaster"].ToString()+"','"
// +connSchool.dr["School_Tel"].ToString()+"','"
// +connSchool.dr["School_Zip"].ToString()+"','"
// +connSchool.dr["School_Address"].ToString()+"')";
str_Sql = StringBuilder_Sql.ToString();
StringBuilder_Sql.Remove(0, str_Sql.Length);
StringBuilder_Sql.Append("insert into School (School_ID,School_Name,School_Type_ID,Schoolmaster,School_Tel,School_Zip,School_Address) values ('");
StringBuilder_Sql.Append(str_School_ID_In);
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connSchool.dr["School_Name"].ToString());
StringBuilder_Sql.Append("',");
StringBuilder_Sql.Append(connSchool.dr["School_Type_ID"].ToString());
StringBuilder_Sql.Append(",'");
StringBuilder_Sql.Append(connSchool.dr["Schoolmaster"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connSchool.dr["School_Tel"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connSchool.dr["School_Zip"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connSchool.dr["School_Address"].ToString());
StringBuilder_Sql.Append("')");
str_Sql = StringBuilder_Sql.ToString();
errorstring = conn.ExeSql(str_Sql);
if (errorstring != "OK")
{
MessageBox.Show("未成功导入学校信息！请检查数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
/*提示成功导入
* MessageBox.Show("成功导入学校信息！"+errorstring, "提醒！",
* MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
*/
//int TeacherCount=connTeacher.ds.Tables[0].Rows.Count;
//for(int i=0;i<TeacherCount;i++)
foreach (System.Data.DataRow drtemp in connTeacher.ds.Tables[0].Rows)
{
//connTeacher.dr=connTeacher.ds.Tables[0].Rows[i];
connTeacher.dr = drtemp;
if (connTeacher.dr["School_ID"].ToString() == str_School_ID_In)
{
string str_InWorkSheet, str_IsFullTime;
if (connTeacher.dr["InWorkSheet"].ToString() == "True")
{
str_InWorkSheet = "1";
}
else
{
str_InWorkSheet = "0";
}
if (connTeacher.dr["IsFullTime"].ToString() == "True")
{
str_IsFullTime = "1";
}
else
{
str_IsFullTime = "0";
}
// str_Sql="INSERT INTO Teacher (School_ID,Teacher_ID,Name,Sex,Birthday,WorkTime,SchoolType,PostCan,PostIn,SchoolGrad,GradTime,SpecialIn,LessonTeach,InWorkSheet,IsFullTime) values('"
// +conn.dr["School_ID"].ToString()
// +"','"+conn.dr["Teacher_ID"].ToString()
// +"','"+conn.dr["Name"].ToString()
// +"','"+conn.dr["Sex"].ToString()
// +"','"+conn.dr["Birthday"].ToString()
// +"','"+conn.dr["WorkTime"].ToString()
// +"','"+conn.dr["SchoolType"].ToString()
// +"','"+conn.dr["PostCan"].ToString()
// +"','"+conn.dr["PostIn"].ToString()
// +"','"+conn.dr["SchoolGrad"].ToString()
// +"','"+conn.dr["GradTime"].ToString()
// +"','"+conn.dr["SpecialIn"].ToString()
// +"','"+conn.dr["LessonTeach"].ToString()
// +"',"+str_InWorkSheet
// +","+str_IsFullTime+")";
StringBuilder_Sql.Remove(0, str_Sql.Length);
StringBuilder_Sql.Append("INSERT INTO Teacher (School_ID,Teacher_ID,Name,Sex,Birthday,WorkTime,SchoolType,PostCan,PostIn,SchoolGrad,GradTime,SpecialIn,LessonTeach,InWorkSheet,IsFullTime) values('");
StringBuilder_Sql.Append(connTeacher.dr["School_ID"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connTeacher.dr["Teacher_ID"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connTeacher.dr["Name"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connTeacher.dr["Sex"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connTeacher.dr["Birthday"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connTeacher.dr["WorkTime"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connTeacher.dr["SchoolType"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connTeacher.dr["PostCan"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connTeacher.dr["PostIn"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connTeacher.dr["SchoolGrad"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connTeacher.dr["GradTime"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connTeacher.dr["SpecialIn"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connTeacher.dr["LessonTeach"].ToString());
StringBuilder_Sql.Append("',");
StringBuilder_Sql.Append(str_InWorkSheet);
StringBuilder_Sql.Append(",");
StringBuilder_Sql.Append(str_IsFullTime);
StringBuilder_Sql.Append(")");
str_Sql = StringBuilder_Sql.ToString();
errorstring = connTeacher.ExeSql(str_Sql);
}
}
if (errorstring != "OK")
{
MessageBox.Show("未成功导入教师信息！请检查数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
/*提示成功导入
* MessageBox.Show("成功导入教师信息！"+errorstring, "提醒！",
* MessageBoxButtons.OK, MessageBoxIcon.Asterisk);conn.ds.Reset();
*/
//int ClassCount=connClass.ds.Tables[0].Rows.Count;
//for(int i=0;i<ClassCount;i++)
//{
foreach (System.Data.DataRow drtemp in connClass.ds.Tables[0].Rows)
{
connClass.dr = drtemp;
//connClass.dr=connClass.ds.Tables[0].Rows[i];
if (connClass.dr["School_ID"].ToString() == str_School_ID_In)
{
// str_Sql="INSERT INTO Class (Class_ID,School_ID,Class_Type_ID,Class_Name,TeacherInCharge) values("
// +conn.dr["Class_ID"].ToString()+",'"
// +conn.dr["School_ID"].ToString()+"',"
// +conn.dr["Class_Type_ID"].ToString()+",'"
// +conn.dr["Class_Name"].ToString()+"','"
// +conn.dr["TeacherInCharge"].ToString()+"')";
StringBuilder_Sql.Remove(0, str_Sql.Length);
StringBuilder_Sql.Append("INSERT INTO Class (Class_ID,School_ID,Class_Type_ID,Class_Name,TeacherInCharge) values(");
StringBuilder_Sql.Append(connClass.dr["Class_ID"].ToString());
StringBuilder_Sql.Append(",'");
StringBuilder_Sql.Append(connClass.dr["School_ID"].ToString());
StringBuilder_Sql.Append("',");
StringBuilder_Sql.Append(connClass.dr["Class_Type_ID"].ToString());
StringBuilder_Sql.Append(",'");
StringBuilder_Sql.Append(connClass.dr["Class_Name"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connClass.dr["TeacherInCharge"].ToString());
StringBuilder_Sql.Append("')");
str_Sql = StringBuilder_Sql.ToString();
errorstring = conn.ExeSql(str_Sql);
}
}
if (errorstring != "OK")
{
MessageBox.Show("未成功导入班级信息！请检查数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
/*提示成功导入
* MessageBox.Show("成功导入班级信息！"+errorstring, "提醒！",
* MessageBoxButtons.OK, MessageBoxIcon.Asterisk);conn.ds.Reset();
*/
//int StudentCount=connStudent.ds.Tables[0].Rows.Count;
//for(int i=0;i<connStudent.ds.Tables[0].Rows.Count;i++)
//{
// connStudent.dr=connStudent.ds.Tables[0].Rows[i];
foreach (System.Data.DataRow drtemp in connStudent.ds.Tables[0].Rows)
{
connStudent.dr = drtemp;
if (connStudent.dr["School_ID"].ToString() == str_School_ID_In)
{
// str_Sql="insert into Student (School_ID,Student_ID,Class_ID,Name,Birthday,Sex,Father,Mother,Keeper,StudentTel,QuXian_ID,Office_ID,Committee_ID,Student_Address,Father_Job,Father_XueLi,Mother_Job,Mother_XueLi) values ('"
// +conn.dr["School_ID"].ToString()+"','"
// +conn.dr["Student_ID"].ToString()+"',"
// +conn.dr["Class_ID"].ToString()+",'"
// +conn.dr["Name"].ToString()+"','"
// +conn.dr["Birthday"].ToString()+"','"
// +conn.dr["Sex"].ToString()+"','"
// +conn.dr["Father"].ToString()+"','"
// +conn.dr["Mother"].ToString()+"','"
// +conn.dr["Keeper"].ToString()+"','"
// +conn.dr["StudentTel"].ToString()+"',"
// +conn.dr["QuXian_ID"].ToString()+","
// +conn.dr["Office_ID"].ToString()+",'"
// +conn.dr["Committee_ID"].ToString()+"','"
// +conn.dr["Student_Address"].ToString()+"','"
// +conn.dr["Father_Job"].ToString()+"','"
// +conn.dr["Father_XueLi"].ToString()+"','"
// +conn.dr["Mother_Job"].ToString()+"','"
// +conn.dr["Mother_XueLi"].ToString()+"')";
StringBuilder_Sql.Remove(0, str_Sql.Length);
StringBuilder_Sql.Append("insert into Student (School_ID,Student_ID,Class_ID,Name,Birthday,Sex,Father,Mother,Keeper,StudentTel,QuXian_ID,Office_ID,Committee_ID,Student_Address,Father_Job,Father_XueLi,Mother_Job,Mother_XueLi) values ('");
StringBuilder_Sql.Append(connStudent.dr["School_ID"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connStudent.dr["Student_ID"].ToString());
StringBuilder_Sql.Append("',");
StringBuilder_Sql.Append(connStudent.dr["Class_ID"].ToString());
StringBuilder_Sql.Append(",'");
StringBuilder_Sql.Append(connStudent.dr["Name"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connStudent.dr["Birthday"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connStudent.dr["Sex"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connStudent.dr["Father"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connStudent.dr["Mother"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connStudent.dr["Keeper"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connStudent.dr["StudentTel"].ToString());
StringBuilder_Sql.Append("',");
StringBuilder_Sql.Append(connStudent.dr["QuXian_ID"].ToString());
StringBuilder_Sql.Append(",");
StringBuilder_Sql.Append(connStudent.dr["Office_ID"].ToString());
StringBuilder_Sql.Append(",'");
StringBuilder_Sql.Append(connStudent.dr["Committee_ID"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connStudent.dr["Student_Address"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connStudent.dr["Father_Job"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connStudent.dr["Father_XueLi"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connStudent.dr["Mother_Job"].ToString());
StringBuilder_Sql.Append("','");
StringBuilder_Sql.Append(connStudent.dr["Mother_XueLi"].ToString());
StringBuilder_Sql.Append("')");
str_Sql = StringBuilder_Sql.ToString();
errorstring = connStudent.ExeSql(str_Sql);
}
}
if (errorstring != "OK")
{
MessageBox.Show("未成功导入学生信息！请检查数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
/*提示成功导入
* MessageBox.Show("成功导入学生信息！"+errorstring, "提醒！",
* MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
*/
}
/*对话框if的返回语句
* else
* {
* return;
* }
*/
}
MessageBox.Show("成功导入" + SchoolCount.ToString() + "个学校信息！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk); conn.ds.Reset();
}
private void button1_Click(object sender, System.EventArgs e)
{
button1.Enabled = false;
string str_Sql, errorstring = "OK", str_School_ID_In;
//导入学校信息
conn.ds.Reset();
try
{
conn.ds.ReadXmlSchema(textBox_LocationDBOut.Text + "\\School.xsd");
conn.ds.ReadXml(textBox_LocationDBOut.Text + "\\School.xml");
}
catch
{ //对话框
MessageBox.Show("School文件打开失败！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
conn.dr = conn.ds.Tables[0].Rows[0];
str_School_ID_In = conn.dr["School_ID"].ToString();
DialogResult result;
if (conn.School_ID_Had(str_School_ID_In))
{
result = MessageBox.Show(this, "真的要导入学校代码为 " + str_School_ID_In + " 的学校吗?"
+ "其学校名称为" + conn.School_IDtoWhat(str_School_ID_In, "School_Name")
+ "操作会替换该学校原有的所有信息", "提醒！",
MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
}
else
{
result = MessageBox.Show(this, "真的要导入吗?", "提醒！",
MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
}
if (result == DialogResult.OK)
{
//删除该学校代码对应的所有信息,先删除学生,再删除班级,最后删除学校,以防外键冲突
str_Sql = "DELETE from Student WHERE School_ID='" + str_School_ID_In + "'";
conn.ExeSql(str_Sql);
str_Sql = "DELETE from Class WHERE School_ID='" + str_School_ID_In + "'";
conn.ExeSql(str_Sql);
str_Sql = "DELETE from Teacher WHERE School_ID='" + str_School_ID_In + "'";
conn.ExeSql(str_Sql);
str_Sql = "DELETE from School WHERE School_ID='" + str_School_ID_In + "'";
conn.ExeSql(str_Sql);
conn.ds.Reset();
conn.ds.ReadXmlSchema(textBox_LocationDBOut.Text + "\\School.xsd");
conn.ds.ReadXml(textBox_LocationDBOut.Text + "\\School.xml");
conn.dr = conn.ds.Tables[0].Rows[0];
str_Sql = "insert into School (School_ID,School_Name,School_Type_ID,Schoolmaster,School_Tel,School_Zip,School_Address,QuXian_Code) values ('"
+ str_School_ID_In + "','"
+ conn.dr["School_Name"].ToString() + "',"
+ conn.dr["School_Type_ID"].ToString() + ",'"
+ conn.dr["Schoolmaster"].ToString() + "','"
+ conn.dr["School_Tel"].ToString() + "','"
+ conn.dr["School_Zip"].ToString() + "','"
+ conn.dr["School_Address"].ToString() + "','"
+ conn.dr["QuXian_Code"].ToString() + "')";
errorstring = conn.ExeSql(str_Sql);
if (errorstring != "OK")
{
MessageBox.Show("未成功导入学校信息！请检查数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
MessageBox.Show("成功导入学校信息！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
//导入教师信息
conn.ds.Reset();
try
{
conn.ds.ReadXmlSchema(textBox_LocationDBOut.Text + "\\Teacher.xsd");
conn.ds.ReadXml(textBox_LocationDBOut.Text + "\\Teacher.xml");
}
catch
{ //对话框
MessageBox.Show("Teacher文件打开失败！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
for (int i = 0; i < conn.ds.Tables[0].Rows.Count; i++)
{
string str_InWorkSheet, str_IsFullTime;
conn.dr = conn.ds.Tables[0].Rows[i];
if (conn.dr["InWorkSheet"].ToString() == "True")
{
str_InWorkSheet = "1";
}
else
{
str_InWorkSheet = "0";
}
if (conn.dr["IsFullTime"].ToString() == "True")
{
str_IsFullTime = "1";
}
else
{
str_IsFullTime = "0";
}
str_Sql = "INSERT INTO Teacher (School_ID,Teacher_ID,Name,Sex,Birthday,WorkTime,SchoolType,PostCan,PostIn,SchoolGrad,GradTime,SpecialIn,LessonTeach,InWorkSheet,IsFullTime) values('"
+ conn.dr["School_ID"].ToString()
+ "','" + conn.dr["Teacher_ID"].ToString()
+ "','" + conn.dr["Name"].ToString()
+ "','" + conn.dr["Sex"].ToString()
+ "','" + conn.dr["Birthday"].ToString()
+ "','" + conn.dr["WorkTime"].ToString()
+ "','" + conn.dr["SchoolType"].ToString()
+ "','" + conn.dr["PostCan"].ToString()
+ "','" + conn.dr["PostIn"].ToString()
+ "','" + conn.dr["SchoolGrad"].ToString()
+ "','" + conn.dr["GradTime"].ToString()
+ "','" + conn.dr["SpecialIn"].ToString()
+ "','" + conn.dr["LessonTeach"].ToString()
+ "'," + str_InWorkSheet
+ "," + str_IsFullTime + ")";
errorstring = conn.ExeSql(str_Sql);
}
if (errorstring != "OK")
{
MessageBox.Show("未成功导入教师信息！请检查数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
MessageBox.Show("成功导入教师信息！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk); conn.ds.Reset();
//导入班级信息
conn.ds.Reset();
try
{
conn.ds.ReadXmlSchema(textBox_LocationDBOut.Text + "\\Class.xsd");
conn.ds.ReadXml(textBox_LocationDBOut.Text + "\\Class.xml");
}
catch
{ //对话框
MessageBox.Show("Class文件打开失败！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
for (int i = 0; i < conn.ds.Tables[0].Rows.Count; i++)
{
conn.dr = conn.ds.Tables[0].Rows[i];
str_Sql = "INSERT INTO Class (Class_ID,School_ID,Class_Type_ID,Class_Name,TeacherInCharge) values("
+ conn.dr["Class_ID"].ToString() + ",'"
+ conn.dr["School_ID"].ToString() + "',"
+ conn.dr["Class_Type_ID"].ToString() + ",'"
+ conn.dr["Class_Name"].ToString() + "','"
+ conn.dr["TeacherInCharge"].ToString() + "')";
errorstring = conn.ExeSql(str_Sql);
}
if (errorstring != "OK")
{
MessageBox.Show("未成功导入班级信息！请检查数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
MessageBox.Show("成功导入班级信息！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk); conn.ds.Reset();
//导入学生信息
conn.ds.Reset();
try
{
conn.ds.ReadXmlSchema(textBox_LocationDBOut.Text + "\\Student.xsd");
conn.ds.ReadXml(textBox_LocationDBOut.Text + "\\Student.xml");
}
catch
{ //对话框
MessageBox.Show("Student文件打开失败！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
for (int i = 0; i < conn.ds.Tables[0].Rows.Count; i++)
{
conn.dr = conn.ds.Tables[0].Rows[i];
str_Sql = "insert into Student (School_ID,Student_ID,Class_ID,Name,Birthday,Sex,Father,Mother,Keeper,StudentTel,QuXian_ID,Office_ID,Committee_ID,Student_Address,Father_Job,Father_XueLi,Mother_Job,Mother_XueLi) values ('"
+ conn.dr["School_ID"].ToString() + "','"
+ conn.dr["Student_ID"].ToString() + "',"
+ conn.dr["Class_ID"].ToString() + ",'"
+ conn.dr["Name"].ToString() + "','"
+ conn.dr["Birthday"].ToString() + "','"
+ conn.dr["Sex"].ToString() + "','"
+ conn.dr["Father"].ToString() + "','"
+ conn.dr["Mother"].ToString() + "','"
+ conn.dr["Keeper"].ToString() + "','"
+ conn.dr["StudentTel"].ToString() + "',"
+ conn.dr["QuXian_ID"].ToString() + ","
+ conn.dr["Office_ID"].ToString() + ",'"
+ conn.dr["Committee_ID"].ToString() + "','"
+ conn.dr["Student_Address"].ToString() + "','"
+ conn.dr["Father_Job"].ToString() + "','"
+ conn.dr["Father_XueLi"].ToString() + "','"
+ conn.dr["Mother_Job"].ToString() + "','"
+ conn.dr["Mother_XueLi"].ToString() + "')";
errorstring = conn.ExeSql(str_Sql);
}
if (errorstring != "OK")
{
MessageBox.Show("未成功导入学生信息！请检查数据库！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
button1.Enabled = false;
return;
}
MessageBox.Show("成功导入学生信息！" + errorstring, "提醒！",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
conn.Close();
this.Dispose();
}
else
{
return;
}
} /**//**/
