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