public int QuestionEdit([FromBody] dynamic Json)
{
TestpaperitemModel testpaperitemModel = new TestpaperitemModel
{
question = Json.question,
paperid = Json.paperid,
select1_score = Json.select1_score,
select2_score = Json.select2_score,
select3_score = Json.select3_score,
select4_score = Json.select4_score
};
return(testpaperitemRepository.Update(testpaperitemModel));
}
public int Update(TestpaperitemModel item)
{
string cmdText = "UPDATE `testpaperitem` SET `question` = ?question, `paperid`= ?paperid, `select1_score`= ?select1_score, `select2_score`= ?select2_score, `select3_score`= ?select3_score, `select4_score`= ?select4_score WHERE (`iid`=?iid);";
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?question", MySqlDbType.String),
new MySqlParameter("?paperid", MySqlDbType.Int32),
new MySqlParameter("?select1_score", MySqlDbType.Float),
new MySqlParameter("?select2_score", MySqlDbType.Float),
new MySqlParameter("?select3_score", MySqlDbType.Float),
new MySqlParameter("?select4_score", MySqlDbType.Float),
};
param[0].Value = item.question;
param[1].Value = item.paperid;
param[2].Value = item.select1_score;
param[3].Value = item.select2_score;
param[4].Value = item.select3_score;
param[5].Value = item.select4_score;
return(MysqlHelper.ExecuteNonQuery(cmdType, cmdText, param));
}
public int Insert(TestpaperitemModel item)
{
string cmdText = "INSERT INTO testpaperitem (`question`, `paperid`, `select1_score`, `select2_score`, `select3_score`, `select4_score`) VALUES (?question, ?paperid,?select1_score,?select2_score,?select3_score,?select4_score);";
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?question", MySqlDbType.String),
new MySqlParameter("?paperid", MySqlDbType.Int32),
new MySqlParameter("?select1_score", MySqlDbType.Float),
new MySqlParameter("?select2_score", MySqlDbType.Float),
new MySqlParameter("?select3_score", MySqlDbType.Float),
new MySqlParameter("?select4_score", MySqlDbType.Float),
};
param[0].Value = item.question;
param[1].Value = item.paperid;
param[2].Value = item.select1_score;
param[3].Value = item.select2_score;
param[4].Value = item.select3_score;
param[5].Value = item.select4_score;
return(MysqlHelper.ExecuteNonQuery(cmdType, cmdText, param));
}
