本文共 1228 字,大约阅读时间需要 4 分钟。
前端
发送数据到数据库
后端
[HttpPost("/[controller]/MulileInsertTest")] public string MulileInsertTest([FromBody] object receiveData) { try { JObject result = (JObject)JsonConvert.DeserializeObject(receiveData.ToString()); string data = result["postdata"].ToString(); IDbConnection connection = new SqlConnection(TPConfig.conn_Main); JArray receive = (JArray)JsonConvert.DeserializeObject(data); using (connection) { connection.Open(); string sql = "insert into testTable (code,name,person) values (@code,@name,@person)"; for(int i = 0; i < receive.Count; i++) { JObject jsondata = JObject.Parse(receive[i].ToString()); connection.Execute(sql, new { code = jsondata["code"].ToString(), name = jsondata["name"].ToString(), person = jsondata["person"].ToString() }); } return "OK!"; } } catch (Exception) { throw; } }
转载地址:http://vkvp.baihongyu.com/