private void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
string strConnection = System.Configuration.ConfigurationManager.ConnectionStrings["StudentManager"].ConnectionString;
Model.Class.Class objClass = new Model.Class.Class();
Manage.Class.Class objclass = new Manage.Class.Class(strConnection);
objClass.ClassNo = txtClassNo.Text.Replace("'", "''");
objClass.ClassNo = objClass.ClassNo.Trim();
objClass.ClassName = txtClassName.Text.Replace("'", "''");
objClass.ClassName = objClass.ClassName.Trim();
objClass.Remark = txtRemark.Text.Replace("'", "''");
objClass.Remark = objClass.Remark.Trim();
if (objClass.ClassName == "" || objClass.ClassNo == "")
{
MessageBox.Show("请将信息填写完整！");
}
else
{
int i = objclass.JudgeClassNo(objClass);
int j = objclass.JudgeClassName(objClass);
if (i == 0 && j == 0)
{
int iRent = objclass.AddClass(objClass, out strErr);
if (iRent == 0)
{
MessageBox.Show(strErr);
return;
}
else
{
MessageBox.Show("添加成功");
this.Visible = false;
}
}
else if (i == 1 && j == 0)
{
MessageBox.Show("当前班级已经存在，新建失败");
}
else if (i == 0 && j == 1)
{
MessageBox.Show("当前班级名称已经存在，新建失败");
}
else
{
MessageBox.Show("班级编号和班级名称都已经存在，新建失败");
}
}
}
void BindDataGridView()
{
string strErr = "";
DataTable objDataTable = new DataTable();
string strConnection = System.Configuration.ConfigurationManager.ConnectionStrings["StudentManager"].ConnectionString;
Manage.Class.Class objClass = new Manage.Class.Class(strConnection);
int iRent = objClass.SearchClass(out objDataTable, out strErr);
if (iRent == 0)
{
MessageBox.Show(strErr);
return;
}
else
{
dataGridView.DataSource = objDataTable;
}
}
private void btnDel_Click(object sender, EventArgs e)
{
if (dataGridView.SelectedRows.Count == 0)
{
MessageBox.Show("请先选择你要删除的行");
}
else
{
if (DialogResult.Yes == MessageBox.Show("删除班级前要确定该班没有学生", "确认删除", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
string strConnection = System.Configuration.ConfigurationManager.ConnectionStrings["StudentManager"].ConnectionString;
Manage.Class.Class objClass = new Manage.Class.Class(strConnection);
string strErr = "";
for (int i = 0; i < dataGridView.SelectedRows.Count; i++)
{
string classNo = dataGridView.SelectedRows[i].Cells["班级编号"].Value.ToString();
classNo = classNo.Replace("'", "''");
classNo = classNo.Trim();
string className = dataGridView.SelectedRows[i].Cells["班级名称"].Value.ToString();
className = className.Replace("'", "''");
className = className.Trim();
int j = objClass.JudgeExistStu(classNo);
if (j == 0)
{
int iRent = objClass.DelClass(classNo, className, out strErr);
if (iRent == 0)
{
MessageBox.Show(strErr);
return;
}
}
else
{
MessageBox.Show("不能删除该班级，该班级还有学生");
BindDataGridView();
return;
}
}
BindDataGridView();
}
}
}
void BindClassName()
{
string strErr = "";
DataTable objDataTable = new DataTable();
Manage.Class.Class objClass = new Manage.Class.Class(strConnection);
int iRent = objClass.SearchClass1(out objDataTable, out strErr);
if (iRent == 0)
{
MessageBox.Show(strErr);
return;
}
else
{
cmbClassName.DataSource = objDataTable;
cmbClassName.DisplayMember = "班级名称";
cmbClassName.ValueMember = "班级Id";
}
}
void BindClassId()
{
string strConnection = System.Configuration.ConfigurationManager.ConnectionStrings["StudentManager"].ConnectionString;
Manage.Class.Class objClass = new Manage.Class.Class(strConnection);
string strErr = "";
DataTable objDataTable = new DataTable();
int iRent = objClass.SearchClass3(out objDataTable, out strErr);
if (iRent == 0)
{
MessageBox.Show(strErr);
return;
}
else
{
cmbClassName.DataSource = objDataTable;
cmbClassName.DisplayMember = "ClassName";
cmbClassName.ValueMember = "ClassId";
}
}
private void btnSave_Click(object sender, EventArgs e) //保存修改后的班级。如果修改后的班级编号和名称有相同的，修改失败
{
string strErr = "";
string strConnection = System.Configuration.ConfigurationManager.ConnectionStrings["StudentManager"].ConnectionString;
Model.Class.Class objClass = new Model.Class.Class();
Manage.Class.Class objClassMan = new Manage.Class.Class(strConnection);
objClass.ClassNo = txtClassNo.Text.Replace("'", "''");
objClass.ClassNo = objClass.ClassNo.Trim();
objClass.ClassName = txtClassName.Text.Replace("'", "''");
objClass.ClassName = objClass.ClassName.Trim();
objClass.Remark = txtRemark.Text.Replace("'", "''");
objClass.Remark = objClass.Remark.Trim();
string strClassNo = classNo.Replace("'", "''");
strClassNo = strClassNo.Trim();
string strClassName = className.Replace("'", "''");
strClassName = strClassName.Trim();
if (objClass.ClassName == "" || objClass.ClassNo == "")
{
MessageBox.Show("请将信息填写完整！");
}
else
{
int i = objClassMan.JudgeClassNo(objClass);
int j = objClassMan.JudgeClassName(objClass);
if (strClassNo == objClass.ClassNo && strClassName == objClass.ClassName)
{
int iRent = objClassMan.ModifyClass(classNo, objClass, out strErr);
if (iRent == 0)
{
MessageBox.Show(strErr);
return;
}
else
{
this.Visible = false;
}
}
else if (strClassNo != objClass.ClassNo && strClassName == objClass.ClassName)
{
if (i == 0)
{
int iRent = objClassMan.ModifyClass(classNo, objClass, out strErr);
if (iRent == 0)
{
MessageBox.Show(strErr);
return;
}
else
{
this.Visible = false;
}
}
else
{
MessageBox.Show("当前班级编号已经存在，修改失败");
txtClassNo.Text = classNo;
}
}
else if (strClassNo == objClass.ClassNo && strClassName != objClass.ClassName)
{
if (j == 0)
{
int iRent = objClassMan.ModifyClass(classNo, objClass, out strErr);
if (iRent == 0)
{
MessageBox.Show(strErr);
return;
}
else
{
this.Visible = false;
}
}
else
{
MessageBox.Show("当前班级名称已经存在，修改失败");
txtClassName.Text = className;
}
}
else
{
if (i == 0 && j == 0)
{
int iRent = objClassMan.ModifyClass(classNo, objClass, out strErr);
if (iRent == 0)
{
MessageBox.Show(strErr);
return;
}
else
{
this.Visible = false;
}
}
else
{
MessageBox.Show("当前班级编号和名称都已经存在，修改失败");
txtClassNo.Text = classNo;
}
}
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
string strErr = "";
DataTable objDataTable = new DataTable();
string strConnection = System.Configuration.ConfigurationManager.ConnectionStrings["StudentManager"].ConnectionString;
Manage.Class.Class objClass = new Manage.Class.Class(strConnection);
string ClassNo = txtClassNo.Text.Replace(@"\", @"\\");
ClassNo = ClassNo.Replace("%", @"\%");
ClassNo = ClassNo.Replace("_", @"\_");
ClassNo = ClassNo.Replace("'", @"\''");
ClassNo = ClassNo.Trim();
string ClassName = txtClassName.Text.Replace(@"\", @"\\");
ClassName = ClassName.Replace("%", @"\%");
ClassName = ClassName.Replace("_", @"\_");
ClassName = ClassName.Replace("'", @"\''");
ClassName = ClassName.Trim();
if (iRights == 1)
{
int iRent = objClass.SearchClassByClassNoClassName(ClassNo, ClassName, out objDataTable, out strErr);
if (iRent == 0)
{
MessageBox.Show(strErr);
}
else
{
if (objDataTable.Rows.Count == 0)
{
MessageBox.Show("没有您要查询的记录");
}
else
{
dataGridView.DataSource = objDataTable;
}
}
}
else
{
int iRent = objClass.SearchClassByClassNoClassNameTea(ClassNo, ClassName, strUsersNo, out objDataTable, out strErr);
if (iRent == 0)
{
MessageBox.Show(strErr);
}
else
{
if (objDataTable.Rows.Count == 0)
{
MessageBox.Show("没有您要查询的记录");
}
else
{
dataGridView.DataSource = objDataTable;
}
}
}
txtClassName.Text = "";
txtClassNo.Text = "";
}
