public static bool judgeProblemUpdate(JudgeProblem jp)
{
if (JudgeProblemService.judgeProblemUpdate(jp))
{
return true;
}
else
{
return false;
}
}
public static bool judgeProblemInsert(JudgeProblem ji)
{
if (JudgeProblemService.judgeProblemInsert(ji))
{
return true;
}
else
{
return false;
}
}
public bool judgeProblemUpdate(JudgeProblem jp)
{
string sql = "Update JudgeProblem Set CourseID=@CourseID,Title=@Title,Answer=@Answer where ID=" + jp.ID;
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@CourseID",jp.CourseID),
new SqlParameter("@Title",jp.Title),
new SqlParameter("@Answer",jp.Answer),
};
int i = DBHelp.ExecuteCommand(sql, para);
if (i > 0)
{
return true;
}
else
{
return false;
}
}
public bool judgeProblemInsert(JudgeProblem ji)
{
string sql = "Insert into JudgeProblem (CourseID,Title,Answer) values(@CourseID,@Title,@Answer)";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@CourseID",ji.CourseID),
new SqlParameter("@Title",ji.Title),
new SqlParameter("@Answer",ji.Answer)
};
int i = DBHelp.ExecuteCommand(sql, para);
if (i > 0)
{
return true;
}
else
{
return false;
}
}
public List<JudgeProblem> GetJudgeProblemList()
{
using (SqlConnection conn = DBHelp.GetConnection())
{
string sql = "select * from JudgeProblem";
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
List<JudgeProblem> list = new List<JudgeProblem>();
SqlDataReader DR = cmd.ExecuteReader();
if (DR.Read())
{
JudgeProblem judge = new JudgeProblem();
judge.ID = Convert.ToInt32(DR["ID"]);
judge.CourseID = Convert.ToInt32(DR["CourseID"]);
judge.Title = DR["Title"].ToString();
list.Add(judge);
}
return list;
}
}
public List<JudgeProblem> selectJudgeQuestion(string UserId, int PaperId)
{
using (SqlConnection con = DBHelp.GetConnection())
{
string sql = @"SELECT dbo.UserAnswer.id,dbo.UserAnswer.Mark, dbo.UserAnswer.UserAnswer, dbo.UserAnswer.ExamTime, dbo.JudgeProblem.Title, dbo.JudgeProblem.Answer,
dbo.Paper.PaperName
FROM dbo.UserAnswer INNER JOIN
dbo.JudgeProblem ON dbo.UserAnswer.TitleID = dbo.JudgeProblem.ID AND dbo.UserAnswer.Type = '判断题' INNER JOIN
dbo.Paper ON dbo.UserAnswer.PaperID = dbo.Paper.PaperID AND dbo.UserAnswer.Type = '判断题'
where
dbo.UserAnswer.UserID='" + UserId + "' and dbo.UserAnswer.PaperID='" + PaperId + "'";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
List<JudgeProblem> list = new List<JudgeProblem>();
while (dr.Read())
{
JudgeProblem judge = new JudgeProblem();
judge.ID =Convert.ToInt32(dr["id"]);
judge.UserAnswer = dr["UserAnswer"].ToString();
judge.Mark = Convert.ToInt32(dr["Mark"]);
judge.ExamTime = Convert.ToDateTime(dr["ExamTime"]);
judge.Title = dr["Title"].ToString();
judge.Answer = Convert.ToBoolean(dr["Answer"]);
judge.PaperName = dr["Papername"].ToString();
list.Add(judge);
}
return list;
}
}