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