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