public RedirectToRouteResult AddTestPaper(TestpapersModel testpapers) { Debug.WriteLine(testpapers.papername + "!!!!!!!!!!!!"); testpapersRepository.Insert(testpapers); return(RedirectToRoute(new { controller = "Admin", action = "PaperAdd", }));//重定向 }
public int Insert(TestpapersModel item) { string cmdText = "INSERT INTO testpapers (`papername`, `introduce`, `gradeproduct`, `select1_name`, `select2_name`, `select3_name`, `select4_name`) VALUES (?papername, ?introduce, ?gradeproduct, ?select1_name,?select2_name,?select3_name,?select4_name);"; MySqlParameter[] param = new MySqlParameter[] { new MySqlParameter("?papername", MySqlDbType.String), new MySqlParameter("?introduce", MySqlDbType.String), new MySqlParameter("?gradeproduct", MySqlDbType.Float), new MySqlParameter("?select1_name", MySqlDbType.String), new MySqlParameter("?select2_name", MySqlDbType.String), new MySqlParameter("?select3_name", MySqlDbType.String), new MySqlParameter("?select4_name", MySqlDbType.String), }; param[0].Value = item.papername; param[1].Value = item.introduce; param[2].Value = item.gradeproduct; param[3].Value = item.select1_name; param[4].Value = item.select2_name; param[5].Value = item.select3_name; param[6].Value = item.select4_name; return(MysqlHelper.ExecuteNonQuery(cmdType, cmdText, param)); }