public ExecResult UpdateAnswerInfo(AnswerInfoModel model)
{
string strSql = $"update AnswerInfo set [AnswerResult]='{model.AnswerResult}' where [AnswerInfoID]={model.AnswerInfoID}";
int intResult = BestWoDP.DapperHelper.ExceSQL(strSql, BestWoDP.DapperHelper.DBConnection.KnowledgeHelper);
List <ExceDataResult> listResult = new List <ExceDataResult>();
if (intResult > 0)
{
listResult.Add(new ExceDataResult {
DocumentNo = model.AnswerInfoID.ToString(), Success = true, Remark = "操作成功"
});
return(new ExecResult {
StatusCode = 1, Message = "操作成功", Data = listResult
});
}
else
{
listResult.Add(new ExceDataResult {
DocumentNo = "", Success = false, Remark = "操作失败"
});
return(new ExecResult {
StatusCode = 1, Message = "操作失败", Data = listResult
});
}
}
public ExecResult AddAnswerInfo(AnswerInfoModel model)
{
string strSql = $"insert into AnswerInfo([CarID], [AnswerContent], [AnswerResult], [EmployeeID], [CreateUser], [CreateTime]) values('{model.CarID}','{model.AnswerContent}','{model.AnswerResult}','{model.EmployeeID}','{ model.CreateUser}','{model.CreateTime}')";
int intResult = BestWoDP.DapperHelper.ExceSQLReturnID(strSql, BestWoDP.DapperHelper.DBConnection.KnowledgeHelper);
List <ExceDataResult> listResult = new List <ExceDataResult>();
if (intResult > 0)
{
listResult.Add(new ExceDataResult {
DocumentNo = intResult.ToString(), Success = true, Remark = "操作成功"
});
return(new ExecResult {
StatusCode = 1, Message = "操作成功", Data = listResult
});
}
else
{
listResult.Add(new ExceDataResult {
DocumentNo = "", Success = false, Remark = "操作失败"
});
return(new ExecResult {
StatusCode = 1, Message = "操作失败", Data = listResult
});
}
}
private void btnCommit_Click(object sender, EventArgs e)
{
//新增答题情况
AnswerInfoModel model = new AnswerInfoModel();
model.AnswerContent = this.txtAnswer.Text;
model.CarID = Convert.ToInt32(this.lbCarID.Text);
model.CreateTime = DateTime.Now;
model.CreateUser = "******";
model.EmployeeID = 1;
string strPost = JsonConvert.SerializeObject(model);
KnowledgeDesk.ActionHelper.WebAPIHelper webapi = new ActionHelper.WebAPIHelper();
string strErr = "";
ExecResult result = webapi.ExecuteResultList("http://119.29.105.131:8099/api/AnswerInfo/AddAnswerInfo", strPost, "Post", ref strErr);
if (result.Data[0].Success)
{
this.lbAnswerID.Text = result.Data[0].DocumentNo;
this.Width = 802;
this.btnCommit.Enabled = false;
this.btnNext.Enabled = true;
}
else
{
MessageBox.Show("操作失败，请重新提交");
return;
}
}
public ExecResult UpdateAnswerInfo(AnswerInfoModel model)
{
return(_answerInfo.UpdateAnswerInfo(model));
}
public ExecResult AddAnswerInfo(AnswerInfoModel model)
{
return(_answerInfo.AddAnswerInfo(model));
}
private void btnNext_Click(object sender, EventArgs e)
{
//验证是否有结论
//更新答题结果
AnswerInfoModel model = new AnswerInfoModel();
model.AnswerResult = strResult;
model.AnswerInfoID = Convert.ToInt32(this.lbAnswerID.Text);
string strPost = JsonConvert.SerializeObject(model);
KnowledgeDesk.ActionHelper.WebAPIHelper webapi = new ActionHelper.WebAPIHelper();
string strErr = "";
ExecResult result = webapi.ExecuteResultList("http://119.29.105.131:8099/api/AnswerInfo/UpdateAnswerInfo", strPost, "Post", ref strErr);
if (result.Data[0].Success)
{
//更新卡牌分数
CarModel car = new CarModel();
car.CarID = Convert.ToInt32(this.lbCarID.Text);
switch (strResult)
{
case "未掌握":
car.Points = 0.6M;
break;
case "模糊":
car.Points = 0.8M;
break;
case "完全掌握":
car.Points = Convert.ToDecimal(this.lbPoints.Text) + 0.1M;
break;
}
car.CarQuestion = this.txtQuestion.Text;
car.CarAnswer = this.txtReal.Text;
car.RoomID = Convert.ToInt32(this.lbRoomID.Text);
car.FloorID = Convert.ToInt32(this.lbFloorID.Text);
string strPostCar = JsonConvert.SerializeObject(car);
ExecResult resultCar = webapi.ExecuteResultList("http://119.29.105.131:8099/api/Car/UpdateCar", strPostCar, "Post", ref strErr);
if (resultCar.Data[0].Success)
{
//设置宽度
this.Width = 414;
}
else
{
MessageBox.Show("操作失败，请重试");
return;
}
}
this.txtAnswer.Text = "";
this.txtQuestion.Text = "";
this.txtReal.Text = "";
this.btnCommit.Enabled = true;
this.btnNext.Enabled = false;
this.rbnlike.Checked = false;
this.rbnno.Checked = false;
this.rbnyes.Checked = false;
GetQuestion();
}
