protected void btnSubmit_Click(object sender, EventArgs e)
{
TeacherManage tm = new TeacherManage();
bool result = tm.VldUserName(txtUserName.Text.ToString().Trim());
if (result == true)
{
string path = Server.MapPath(BusyworkManage.Path);
tm.AddTeacher(txtUserName.Text.ToString().Trim(), txtPWD.Text.ToString().Trim(), txtTeacherName.Text.ToString().Trim(), path);
}
else
{
string alert = "用户名已经存在！";
HttpContext.Current.Response.Write("<script language = 'javascript'>alert('" + alert + "');</script>");
}
}
public void UserLogin()
{
if (ddlSelect.SelectedValue == "教师")
{
TeacherManage tm = new TeacherManage();
tm.TeacherLogin(txtName.Text.ToString().Trim(), txtPwd.Text.ToString().Trim());
}
else if (ddlSelect.SelectedValue == "学生")
{
StudentManage sm = new StudentManage();
sm.StudentLogin(txtName.Text.ToString().Trim(), txtPwd.Text.ToString().Trim());
}
else
{
TeacherManage tm = new TeacherManage();
tm.AdminLogin(txtName.Text.ToString().Trim(), txtPwd.Text.ToString().Trim());
}
}
/// <summary>
/// Exam list
/// </summary>
/// <param name="teacherSelect"></param>
/// <returns></returns>
public List <TeacherManage> ExamList(TeacherSelect teacherSelect)
{
SqlConnection connection = new SqlConnection(CONNECTION_STRING);
connection.Open();
SqlCommand command = new SqlCommand("spTeacherManage", connection);
command.CommandType = CommandType.StoredProcedure;
List <TeacherManage> teacherManageExam = new List <TeacherManage>();
command.Parameters.Add(new SqlParameter("@TeacherSortName", teacherSelect.TeacherSortName));
command.Parameters.Add(new SqlParameter("@TeacherSortDirction", teacherSelect.TeacherSortDirction));
command.Parameters.Add(new SqlParameter("@Name", teacherSelect.Name));
command.Parameters.Add(new SqlParameter("@CurrentPage", teacherSelect.CurrentPage));
command.Parameters.Add(new SqlParameter("@PageSize", teacherSelect.PageSize));
command.Parameters.Add(new SqlParameter("@StartDate", teacherSelect.StartTime));
command.Parameters.Add(new SqlParameter("@EndDate", teacherSelect.EndTime));
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
TeacherManage teacherManage = new TeacherManage();
teacherManage.ExamName = reader.GetString(0);
teacherManage.Id = reader.GetInt32(1);
teacherManage.EffectiveTime = reader.GetDateTime(2);
teacherManage.QuestionQuantity = reader.GetInt32(3);
teacherManage.AvgScore = reader[4] == System.DBNull.Value ? 0 : reader.GetDecimal(4);
teacherManage.ExamineeCount = reader[5] == System.DBNull.Value ? 0 : reader.GetInt32(5);
teacherManage.NumOfQualified = reader[6] == System.DBNull.Value ? 0 : reader.GetInt32(6);
teacherManage.PassRate = reader[7] == System.DBNull.Value ? 0 : reader.GetDecimal(7);
teacherManage.RowNumber = reader.GetInt64(8);
teacherManageExam.Add(teacherManage);
}
}
return(teacherManageExam);
}
protected void btnQuit_Click(object sender, EventArgs e)
{
TeacherManage tm = new TeacherManage();
tm.TeacherLogoOff();
}
