//修改学生信息
public static bool UpdateStudent(Student stu)
{
string sql = "Update Student set LoginPwd = @Pwd,StudentName = @StuName,Gender = @Gender,GradeId = @GradeId,Phone = @Phone,Address = @Address,BornDate = @BornDate, Email = @Email where StudentNo = @StudentNo";
SqlParameter[] paras =
{
new SqlParameter("@Pwd", stu.LoginPwd),
new SqlParameter("@StuName", stu.StudentName),
new SqlParameter("@Gender", stu.Gender),
new SqlParameter("@GradeId", stu.Grade.GradeId),
new SqlParameter("@Phone", stu.Phone),
new SqlParameter("@Address", stu.Address),
new SqlParameter("@BornDate", stu.BornDate),
new SqlParameter("@Email", stu.Email),
new SqlParameter("@StudentNo", stu.StudentNo)
};
try
{
return(SQLDBHelper.ExecuteNonQueryByDBHelper(sql, paras));
}
catch (Exception)
{
throw;
}
}
//添加学生
public static bool AddStudent(Student stu)
{
string sql = "insert Student values(@StuNo,@Pwd,@StuName,@Gender,@GradeId,@Phone,@Address,@BornDate,@Email)";
SqlParameter[] paras =
{
new SqlParameter("@StuNo", stu.StudentNo),
new SqlParameter("@Pwd", stu.LoginPwd),
new SqlParameter("@StuName", stu.StudentName),
new SqlParameter("@Gender", stu.Gender),
new SqlParameter("@GradeId", stu.Grade.GradeId),
new SqlParameter("@Phone", stu.Phone),
new SqlParameter("@Address", stu.Address),
new SqlParameter("@BornDate", stu.BornDate),
new SqlParameter("@Email", stu.Email)
};
try
{
return(SQLDBHelper.ExecuteNonQueryByDBHelper(sql, paras));
}
catch (Exception)
{
throw;
}
}
public static bool EditLoginPwd(Admin admin)
{
string sql = "Update Admin set LoginPwd = @NewPwd where LoginId = @Id";
SqlParameter[] paras = {
new SqlParameter("@NewPwd",admin.LoginPwd),
new SqlParameter("@Id",admin.LoginId)
};
try
{
return SQLDBHelper.ExecuteNonQueryByDBHelper(sql,paras);
}
catch (Exception)
{
throw;
}
}
//新增成绩
public static bool AddResult(ResultInsert result)
{
string sql = "insert Result Values(@StuNo,@SubNo,@Result,@ExamDate)";
SqlParameter [] paras =
{
new SqlParameter("@StuNo", result.StudentNo),
new SqlParameter("@SubNo", result.SubjectNo),
new SqlParameter("@Result", result.StudentResult),
new SqlParameter("@ExamDate", result.ExamDate)
};
try
{
return(SQLDBHelper.ExecuteNonQueryByDBHelper(sql, paras));
}
catch (Exception)
{
throw;
}
}
