private void EditAnswer(ProblemAnswer pa)
{
if (this.CurSelProblemWithTN == null)
{
MessageBox.Show("没有先选中试题，本次操作无效");
return;
}
pa.Modify = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
pa.ProblemId = this.CurSelProblemWithTN.Id;//试题ID很关键啊
if (this.CurAnswer == null)
{
pa.Id = Guid.NewGuid().ToString("N");
pa.Create = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
this.IKnowltAndProblemFormReq.InsertOneAnswer(pa);
}
else
{
pa.Id = this.CurAnswer.Id;
this.IKnowltAndProblemFormReq.UpdateOneAnswer(pa);
}
//刷新下
this.ShowAnswer();
//MessageBox.Show("暂时什么都没做呢" + pa.Content);
}
private void ShowAnswer()
{
if (CurSelProblemWithTN == null)
{
return;
}
List <ProblemAnswer> paList = this.IKnowltAndProblemFormReq.QueryOneAnswerByProblemId(this.CurSelProblemWithTN.Id);
if (paList.Count > 0)
{
this.CurAnswer = paList[0];
this.rtbAnswer.Text = paList[0].Content;
this.rtbAnswerOther.Text = paList[0].Other;
this.tbAnswerSRC.Text = paList[0].Source;
}
else
{
this.CurAnswer = null;
this.rtbAnswer.Text = "";
this.rtbAnswerOther.Text = "";
this.tbAnswerSRC.Text = "";
}
Console.WriteLine("设置完成答案");
}
private void btnCubmit_Click(object sender, EventArgs e)
{
ProblemAnswer pa = new ProblemAnswer();
pa.Content = this.rtbAnswer.Text;
pa.Other = this.rtbOther.Text;
pa.Source = this.tbSrc.Text;
this.editeAnswer(pa);
this.Close();
}
private void OnRunWorkerCompleted(object sender, System.ComponentModel.RunWorkerCompletedEventArgs e)
{
ProblemAnswer answer = e.Result as ProblemAnswer;
if (answer != null)
{
_answer.Text = answer.Answer.ToString();
_elapsed.Text = answer.Elapsed.TotalMilliseconds + " ms";
}
Enabled = true;
}
public void UpdateOneAnswer(ProblemAnswer pa)
{
//throw new NotImplementedException();
string updateSql = "UPDATE problem_answer SET problem_answer.utc8_modify = @modife,problem_answer.content = @content,problem_answer.source = @source,problem_answer.other= @other WHERE problem_answer.id = @answerId;";
updateSql = "UPDATE problem_answer SET problem_answer.utc8_modify = @modife,problem_answer.content = @content,problem_answer.source = @source,problem_answer.other = @other WHERE problem_answer.id = @answerId; ";
MySqlConnection mySqlConnection = new MySqlConnection(Model.MySqlHelper.Conn);
mySqlConnection.Open();
Model.MySqlHelper.ExecuteNonQuery(mySqlConnection, CommandType.Text, updateSql,
new MySqlParameter("@modife", pa.Modify),
new MySqlParameter("@content", pa.Content),
new MySqlParameter("@source", pa.Source),
new MySqlParameter("@other", pa.Other),
new MySqlParameter("@answerId", pa.Id));
mySqlConnection.Close();
}
public void InsertOneAnswer(ProblemAnswer pa)
{
//throw new NotImplementedException();
string insertSql = "INSERT INTO problem_answer (problem_answer.id,problem_answer.utc8_create,problem_answer.utc8_modify,problem_answer.other,problem_answer.uk_problem_id,problem_answer.content,problem_answer.source)VALUES (@id, @create, @modife, @other, @problemId, @content, @source)";
MySqlConnection mySqlConnection = new MySqlConnection(Model.MySqlHelper.Conn);
mySqlConnection.Open();
Model.MySqlHelper.ExecuteNonQuery(mySqlConnection, CommandType.Text, insertSql,
new MySqlParameter("@id", pa.Id),
new MySqlParameter("@create", pa.Create),
new MySqlParameter("@modife", pa.Modify),
new MySqlParameter("@other", pa.Other),
new MySqlParameter("@problemId", pa.ProblemId),
new MySqlParameter("@content", pa.Content),
new MySqlParameter("@source", pa.Source));
mySqlConnection.Close();
}
public List <ProblemAnswer> QueryOneAnswerByProblemId(string id)
{
//throw new NotImplementedException();
List <ProblemAnswer> paList = new List <ProblemAnswer>();
string querySQL = "SELECT problem_answer.id,problem_answer.content,problem_answer.other,problem_answer.source FROM problem_answer WHERE problem_answer.uk_problem_id = @problemId;";
MySqlDataReader mySqlDataReader = Model.MySqlHelper.ExecuteReader(
Model.MySqlHelper.Conn, CommandType.Text, querySQL,
new MySqlParameter("@problemId", id));
while (mySqlDataReader.Read())
{
ProblemAnswer pa = new ProblemAnswer();
pa.Id = mySqlDataReader.IsDBNull(0) ? "" : mySqlDataReader.GetString(0);
pa.Content = mySqlDataReader.IsDBNull(1) ? "" : mySqlDataReader.GetString(1);
pa.Other = mySqlDataReader.IsDBNull(2) ? "" : mySqlDataReader.GetString(2);
pa.Source = mySqlDataReader.IsDBNull(3) ? "" : mySqlDataReader.GetString(3);
paList.Add(pa);
}
mySqlDataReader.Close();
return(paList);
}
