public List<SingleProblem> GetSingleProblemList(string selectvalue) { using (SqlConnection con = DBHelp.GetConnection()) { string sql = "select * from SingleProblem where CourseID=" + selectvalue; SqlCommand cmd = new SqlCommand(sql, con); con.Open(); List<SingleProblem> list = new List<SingleProblem>(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { SingleProblem sing = new SingleProblem(); sing.ID = Convert.ToInt32(dr["ID"]); sing.CourseID = Convert.ToInt32(dr["CourseID"]); sing.Title = dr["Title"].ToString(); sing.AnswerA = dr["AnswerA"].ToString(); sing.AnswerB = dr["AnswerB"].ToString(); sing.AnswerC = dr["AnswerC"].ToString(); sing.AnswerD = dr["AnswerD"].ToString(); sing.Answer = dr["Answer"].ToString(); list.Add(sing); } return list; } }
public bool InsertQuestion(SingleProblem iq) { string sql = @"INSERT INTO SingleProblem (CourseID,Title,AnswerA,AnswerB,AnswerC,AnswerD,Answer) VALUES (@CourseID,@Title,@AnswerA,@AnswerB,@AnswerC,@AnswerD,@Answer)"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@CourseID",iq.CourseID), new SqlParameter("@Title",iq.Title), new SqlParameter("@AnswerA",iq.AnswerA), new SqlParameter("@AnswerB",iq.AnswerB), new SqlParameter("@AnswerC",iq.AnswerC), new SqlParameter("@AnswerD",iq.AnswerD), new SqlParameter("@Answer",iq.Answer) }; int db = DBHelp.ExecuteCommand(sql, para); if (db > 0) { return true; } else { return false; } }
public static bool UpdateSingleSelected(SingleProblem spp) { if (SingleSelectedService.UpdateQuestion(spp)) { return true; } else { return false; } }
public static bool AddSingleSelected(SingleProblem sp) { if (SingleSelectedService.InsertQuestion(sp)) { return true; } else { return false; } }
public bool UpdateQuestion(SingleProblem uq) { string sql = @"UPDATE SingleProblem SET CourseID =@CourseID, Title =@Title, AnswerA =@AnswerA, AnswerB =@AnswerB, AnswerC =@AnswerC, AnswerD =@AnswerD, Answer =@Answer where ID=@ID"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@CourseID",uq.CourseID), new SqlParameter("@Title",uq.Title), new SqlParameter("@AnswerA",uq.AnswerA), new SqlParameter("@AnswerB",uq.AnswerB), new SqlParameter("@AnswerC",uq.AnswerC), new SqlParameter("@AnswerD",uq.AnswerD), new SqlParameter("@Answer",uq.Answer), new SqlParameter("@ID",uq.ID) }; int i = DBHelp.ExecuteCommand(sql, param); if (i > 0) { return true; } else { return false; } }
public List<SingleProblem> selectSingQuestion(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.SingleProblem.Title, dbo.SingleProblem.AnswerB, dbo.SingleProblem.AnswerA, dbo.SingleProblem.AnswerC, dbo.SingleProblem.AnswerD, dbo.SingleProblem.Answer, dbo.Paper.PaperName FROM dbo.UserAnswer INNER JOIN dbo.SingleProblem ON dbo.UserAnswer.TitleID = dbo.SingleProblem.ID AND dbo.UserAnswer.Type = '单选题' INNER JOIN dbo.Paper ON dbo.UserAnswer.PaperID = dbo.Paper.PaperID where dbo.UserAnswer.UserID='" + UserId + "' and dbo.UserAnswer.PaperID='" + PaperId + "'"; SqlCommand cmd = new SqlCommand(sql, con); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); List<SingleProblem> list = new List<SingleProblem>(); while (dr.Read()) { SingleProblem Sing = new SingleProblem(); Sing.ID = Convert.ToInt32(dr["id"]); Sing.Mark = Convert.ToInt32(dr["Mark"]); Sing.UserAnswer = dr["UserAnswer"].ToString(); Sing.ExamTime = Convert.ToDateTime(dr["ExamTime"]); Sing.Title = dr["Title"].ToString(); Sing.AnswerA = dr["AnswerA"].ToString(); Sing.AnswerB = dr["AnswerB"].ToString(); Sing.AnswerC = dr["AnswerC"].ToString(); Sing.AnswerD = dr["AnswerD"].ToString(); Sing.Answer = dr["Answer"].ToString(); Sing.PaperName = dr["PaperName"].ToString(); list.Add(Sing); } return list; } }
public List<SingleProblem> GetSingleProblemList() { using (SqlConnection con = DBHelp.GetConnection()) { string sql = "select * from SingleProblem"; SqlCommand cmd = new SqlCommand(sql, con); con.Open(); List<SingleProblem> list = new List<SingleProblem>(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { SingleProblem sing = new SingleProblem(); sing.ID = Convert.ToInt32(dr["ID"]); sing.CourseID = Convert.ToInt32(dr["CourseID"]); sing.Title = dr["Title"].ToString(); list.Add(sing); } return list; } }