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 = ""; }