public static bool FillBlankProblemUpdate(FillBlankProblem fu) { if (FillBlankProblemService.FillBlankProbleUpdate(fu)) { return true; } else { return false; } }
public static bool FillBlankProblemDelete(FillBlankProblem fd) { if (FillBlankProblemService.FillBlankProbleDelete(fd)) { return true; } else { return false; } }
public static bool FillBlankProblemInsert(FillBlankProblem fi) { if (FillBlankProblemService.FillBlankProbleInsert(fi)) { return true; } else { return false; } }
public static bool FillBlankProbleDelete(FillBlankProblem fd) { string sql = "DELETE FROM SingleProblem WHERE ID=@ID"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("ID",fd.ID), }; int i = DBHelp.ExecuteCommand(sql, param); if (i > 0) { return true; } else { return false; } }
public List<FillBlankProblem> GeFillBlankProblemList() { using (SqlConnection con = DBHelp.GetConnection()) { string sql = "select * from FillBlankProblem"; SqlCommand cmd = new SqlCommand(sql, con); con.Open(); List<FillBlankProblem> list = new List<FillBlankProblem>(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { FillBlankProblem fill = new FillBlankProblem(); fill.ID = Convert.ToInt32(dr["ID"]); fill.CourseID = Convert.ToInt32(dr["CourseID"]); fill.FrontTitle = dr["FrontTitle"].ToString(); list.Add(fill); } return list; } }
public static bool FillBlankProbleInsert(FillBlankProblem fi) { string sql = @"insert into FillBlankProblem(CourseID,FrontTitle,BackTitle,Answer) values(@CourseID,@FrontTitle,@BackTitle,@Answer)"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@CourseID",fi.CourseID), new SqlParameter("@FrontTitle",fi.FrontTitle), new SqlParameter("@BackTitle",fi.BackTitle), new SqlParameter("@Answer",fi.Answer) }; int i = DBHelp.ExecuteCommand(sql, param); if (i > 0) { return true; } else { return false; } }
public static bool FillBlankProbleUpdate(FillBlankProblem fb) { string sql = @"UPDATE FillBlankProblem SET CourseID =@CourseID, FrontTitle =@FrontTitle, BackTitle =@BackTitle,Answer =@Answer where ID=@ID"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@CourseID",fb.CourseID), new SqlParameter("@FrontTitle",fb.FrontTitle), new SqlParameter("@BackTitle",fb.BackTitle), new SqlParameter("@Answer",fb.Answer), new SqlParameter("@ID",fb.ID) }; int i = DBHelp.ExecuteCommand(sql, param); if (i > 0) { return true; } else { return false; } }
public List<FillBlankProblem> FillQuestion(string UserId, int PaperId) { using (SqlConnection con=DBHelp.GetConnection()) { string sql = @"SELECT dbo.UserAnswer.Mark, dbo.UserAnswer.UserAnswer, dbo.UserAnswer.ExamTime, dbo.FillBlankProblem.FrontTitle, dbo.FillBlankProblem.BackTitle, dbo.FillBlankProblem.Answer, dbo.Paper.PaperName FROM dbo.UserAnswer INNER JOIN dbo.FillBlankProblem ON dbo.UserAnswer.TitleID = dbo.FillBlankProblem.ID 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<FillBlankProblem> list = new List<FillBlankProblem>(); while (dr.Read()) { FillBlankProblem Fill = new FillBlankProblem(); Fill.Mark = Convert.ToInt32(dr["Mark"]); Fill.UserAnswer = dr["UserAnswer"].ToString(); Fill.ExamTime = Convert.ToDateTime(dr["ExamTime"]); Fill.FrontTitle = dr["FrontTitle"].ToString(); Fill.BackTitle = dr["BackTitle"].ToString(); Fill.Answer = dr["Answer"].ToString(); Fill.PaperName = dr["PaperName"].ToString(); list.Add(Fill); } return list; } }