public ActionResult AAA()
{
return View();
}
[HttpGet]
public string A()
{
HttpClient client = new HttpClient();
var aaa = client.GetStringAsync("https://www.layui.com/test/table/demo1.json");
var bbb = aaa.Result;
var json = JsonConvert.DeserializeObject<Class1>(bbb);
var data= json.data;
for (int i = 0; i < data.Count(); i++)
{
string sql = "INSERT INTO [dbo].[KuaYu]([id],[username],[email],[sex],[city],[sign],[experience],[ip],[logins],[joinTime]) VALUES(@id,@username,@email,@sex,@city,@sign,@experience,@ip,@logins,@joinTime)";
SqlParameter[] pa = new SqlParameter[]
{
new SqlParameter("@id",data[i].id),
new SqlParameter("@username",data[i].username),
new SqlParameter("@email",data[i].email),
new SqlParameter("@sex",data[i].sex),
new SqlParameter("@city",data[i].city),
new SqlParameter("@sign",data[i].sign),
new SqlParameter("@experience",data[i].experience),
new SqlParameter("@ip",data[i].ip),
new SqlParameter("@logins",data[i].logins),
new SqlParameter("@joinTime",data[i].joinTime),
};
int count = DBHelper.ZSG(sql, pa);
}
return bbb;
}