public ProblemInPaper(ProblemWithTypeName problemWithTN) { InitializeComponent(); this.problemWithTN = problemWithTN; this.rtxContent.Text = problemWithTN.Content; }
public OneProblemForm(ProblemWithTypeName problem, SelProblem selProblem) { InitializeComponent(); this.cuProblemWithTN = problem; this.selProblem = selProblem; this.rtxProblem.Text = problem.Content; }
public ProblemEidtForm(ProblemWithTypeName CurSelProblemWithTN, IKnowltAndProblemFormReq IKnowltAndProblemFormReq, EditProblem editProblem) { InitializeComponent(); this.IKnowltAndProblemFormReq = IKnowltAndProblemFormReq; this.CurSelProblemWithTN = CurSelProblemWithTN; this.editProblem = editProblem; this.iProblemEditFormReq = ImplProblemEditFormReq.NewInstance(); this.initData(); this.initView(); }
//想试题组成试卷表添加内容 public int InsertOneProblem(ProblemWithTypeName problemWithTN) { //throw new NotImplementedException(); int result = -1; string insertSql = "INSERT INTO problem_compose_examination_papers(problem_compose_examination_papers.id,problem_compose_examination_papers.utc8_create,problem_compose_examination_papers.utc8_modify,problem_compose_examination_papers.other,problem_compose_examination_papers.uk_problem_id) SELECT @id, @create, @modife, @other, @problemId FROM DUAL WHERE NOT EXISTS (SELECT * FROM problem_compose_examination_papers WHERE problem_compose_examination_papers.uk_problem_id = @problemId);"; MySqlConnection mySqlConnection = new MySqlConnection(Model.MySqlHelper.Conn); mySqlConnection.Open(); result = Model.MySqlHelper.ExecuteNonQuery(mySqlConnection, CommandType.Text, insertSql, new MySqlParameter("@id", Guid.NewGuid().ToString("N")), new MySqlParameter("@create", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")), new MySqlParameter("@modife", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")), new MySqlParameter("@other", null), new MySqlParameter("@problemId", problemWithTN.Id)); mySqlConnection.Close(); return(result); }
//查询和本知识点相关的试题出来 public List <ProblemWithTypeName> QueryAllProblems(string knowlId) { List <ProblemWithTypeName> ProblemList = new List <ProblemWithTypeName>(); //包含题目类型 string querySQL = "SELECT problem.id,problem.content,problem.other,problem.uk_problem_type_id,problem_type.`name` FROM knowledge_point_compose_problem INNER JOIN problem ON knowledge_point_compose_problem.uk_problem_id = problem.id LEFT JOIN problem_type ON problem.uk_problem_type_id = problem_type.id WHERE knowledge_point_compose_problem.uk_knowledge_point_id = @knowlId;"; MySqlDataReader mySqlDataReader = Model.MySqlHelper.ExecuteReader( Model.MySqlHelper.Conn, CommandType.Text, querySQL, new MySqlParameter("@knowlId", knowlId)); while (mySqlDataReader.Read()) { ProblemWithTypeName pwt = new ProblemWithTypeName(); pwt.Id = mySqlDataReader.IsDBNull(0) ? "" : mySqlDataReader.GetString(0); pwt.Content = mySqlDataReader.IsDBNull(1) ? "" : mySqlDataReader.GetString(1); pwt.Other = mySqlDataReader.IsDBNull(2) ? "" : mySqlDataReader.GetString(2); pwt.TypeId = mySqlDataReader.IsDBNull(3) ? "" : mySqlDataReader.GetString(3); pwt.TypeName = mySqlDataReader.IsDBNull(3) ? "" : mySqlDataReader.GetString(4); ProblemList.Add(pwt); } mySqlDataReader.Close(); return(ProblemList); }
private void SelProblem(OneProblemForm oneProblemForm, ProblemWithTypeName problemWithTN, bool IsBtn) { //if (this.CurSelProblemWithTN != problemWithTN) //{ // this.CurSelProblemWithTN = problemWithTN; // this.tbProblemType.Text = this.CurSelProblemWithTN.TypeName; // this.rtbProblemOther.Text = this.CurSelProblemWithTN.Other; //} if (CurSelProblemForm != oneProblemForm) { if (CurSelProblemForm != null) { CurSelProblemForm.CancelFocus(); } CurSelProblemForm = oneProblemForm; CurSelProblemForm.SetFocus(); this.CurSelProblemWithTN = CurSelProblemForm.cuProblemWithTN; this.tbProblemType.Text = this.CurSelProblemWithTN.TypeName; this.rtbProblemOther.Text = this.CurSelProblemWithTN.Other; } if (IsBtn) { //MessageBox.Show("添加到试卷"); if (this.IKnowltAndProblemFormReq.InsertOneProblem(this.CurSelProblemWithTN) == 1) { if (this.varClosePaper == null) { this.varClosePaper = new ClosePaper(this.ClosePaper); } PaperForm.getInstance(this.varClosePaper).AddChild(new ProblemInPaper(this.CurSelProblemWithTN)); } } this.ShowAnswer(); }