private void button1_Click(object sender, EventArgs e) { int result = 0; ClassInfo classInfo = new ClassInfo(); classInfo.className = txtClassName.Text; int classId = Convert.ToInt32(labClassId.Text == "" ? "0" : labClassId.Text); if (classId > 0) //修改操作 { classInfo.ClassId = classId; result = classService.updateClass(classInfo); } else //新增操作 { result = classService.addClass(classInfo); } if (result > 0) { MessageBox.Show("保存成功"); bodyStu.loadClass(null); this.Close(); } else { MessageBox.Show("保存失败,请联系管理员"); } }
public int addClass(ClassInfo classInfo) { string strSql = "insert into sys_class(class_name) values(?className)"; MySqlParameter[] parames = new MySqlParameter[] { new MySqlParameter("?className", MySqlDbType.VarChar) }; parames[0].Value = classInfo.ClassName; return MySqlHelper.ExecuteNonQuery(strSql, parames); }
public int updateClass(ClassInfo classInfo) { string strSql = "update sys_class set class_name = ?className where class_id = ?classId"; MySqlParameter[] parames = new MySqlParameter[] { new MySqlParameter("?className", MySqlDbType.VarChar), new MySqlParameter("?classId", MySqlDbType.Int32) }; parames[0].Value = classInfo.ClassName; parames[1].Value = classInfo.ClassId; return MySqlHelper.ExecuteNonQuery(strSql, parames); }
/// <summary> /// �õ����еİ༶ /// </summary> /// <returns></returns> public List<ClassInfo> GetAllClasses() { List<ClassInfo> result = new List<ClassInfo>(); using (SqlDataReader dr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringSTEduSys, CommandType.StoredProcedure, "SP_GetAllClasses", null)) { while (dr.Read()) { ClassInfo a = new ClassInfo(); a.IClassId = Convert.ToInt32(dr["ID"]); a.StrClassName = Convert.ToString(dr["className"]); result.Add(a); } } return result; }
//修改班级 public int updateClass(ClassInfo classInfo) { return classDao.updateClass(classInfo); }
//添加班级 public int addClass(ClassInfo classInfo) { return classDao.addClass(classInfo); }
//��ȡij��ʦ�ν̵�ij�γ��µ����а༶ public List<ClassInfo> GetClassesByTeacherAndCourse(string teacherUserName, string courseName) { SqlParameter[] param = { new SqlParameter("@teacherUserName", teacherUserName), new SqlParameter("@courseName", courseName) }; List<ClassInfo> classes = new List<ClassInfo>(); using (SqlDataReader dr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringSTEduSys, CommandType.StoredProcedure, "SP_GetClassesByTeacherAndCourse", param)) { while (dr.Read()) { ClassInfo _class = new ClassInfo(); _class.IClassId = dr.GetInt32(0); _class.StrClassName = dr.GetString(1); classes.Add(_class); } } return classes; }