/// <summary>
/// 确认发布考试
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool ReleaseExamination(ExaminationInfo info)
{
string sql = "insert into TBL_ExaminationPaper values (NEWID(),@paperTitle,@singleList,@singleOption,@judgeList,@judgeOption,@classId,@teacherId,@courseId,GETDATE(),@testTime,@rollOutTime)";
SqlParameter[] pars =
{
new SqlParameter("@paperTitle", SqlDbType.NVarChar),
new SqlParameter("@singleList", SqlDbType.NVarChar),
new SqlParameter("@singleOption", SqlDbType.NVarChar),
new SqlParameter("@judgeList", SqlDbType.NVarChar),
new SqlParameter("@judgeOption", SqlDbType.NVarChar),
new SqlParameter("@classId", SqlDbType.UniqueIdentifier),
new SqlParameter("@teacherId", SqlDbType.UniqueIdentifier),
new SqlParameter("@courseId", SqlDbType.UniqueIdentifier),
new SqlParameter("@testTime", SqlDbType.NVarChar),
new SqlParameter("@rollOutTime", SqlDbType.NVarChar)
};
pars[0].Value = info.PaperTitle;
pars[1].Value = info.SingleList;
pars[2].Value = info.SingleOption;
pars[3].Value = info.JudgeList;
pars[4].Value = info.JudgeOption;
pars[5].Value = info.ClassID;
pars[6].Value = info.TeacherID;
pars[7].Value = info.CourseID;
pars[8].Value = info.TestTime;
pars[9].Value = info.RollOutTime;
int result = SQLHelper.ExecutSql(sql, CommandType.Text, pars);
return(result > 0);
}
/// <summary>
/// 修改头像
/// </summary>
/// <param name="guid"></param>
/// <param name="img"></param>
/// <returns></returns>
public bool ChangePhoto(Guid guid, string img)
{
string sql = "update TBL_StudentInfo set ImgUrl = @img where ID = @id";
SqlParameter[] pars =
{
new SqlParameter("@id", SqlDbType.UniqueIdentifier),
new SqlParameter("@img", SqlDbType.NVarChar)
};
pars[0].Value = guid;
pars[1].Value = img;
int result = SQLHelper.ExecutSql(sql, CommandType.Text, pars);
return(result > 0);
}
/// <summary>
/// 修改密码
/// </summary>
/// <param name="userId">账号</param>
/// <param name="newPass">密码</param>
/// <returns></returns>
public bool StudentChangePass(Guid userId, string newPass)
{
string sql = "update TBL_StudentInfo set LoginPass = @newPass , ChangeTime = GETDATE() where ID = @userId";
SqlParameter[] pars =
{
new SqlParameter("@userId", SqlDbType.UniqueIdentifier),
new SqlParameter("@newPass", SqlDbType.VarBinary)
};
pars[0].Value = userId;
pars[1].Value = SHA1.Encrpt(newPass);
int result = SQLHelper.ExecutSql(sql, CommandType.Text, pars);
return(result > 0);
}
/// <summary>
/// 提交试卷
/// </summary>
/// <param name="resultPaper"></param>
/// <returns></returns>
public bool SubmitExam(ResultDetailInfo resultPaper)
{
string sql = "insert into TBL_ResultDetail values (NEWID(),@paperId,@userId,@selectList,@result,GETDATE())";
SqlParameter[] pars =
{
new SqlParameter("@paperId", SqlDbType.UniqueIdentifier),
new SqlParameter("@userId", SqlDbType.UniqueIdentifier),
new SqlParameter("@selectList", SqlDbType.NVarChar),
new SqlParameter("@result", SqlDbType.Int)
};
pars[0].Value = resultPaper.PaperID;
pars[1].Value = resultPaper.StudentID;
pars[2].Value = resultPaper.SelectList;
pars[3].Value = resultPaper.ResultPoint;
int result = SQLHelper.ExecutSql(sql, CommandType.Text, pars);
return(result > 0);
}
