var data;
$(function () {
$.ajax({
url: '/Home/A',
data: 'get',
dataType: 'json',
success: function (res) {
data = res.data;
$.each(res.data, function (i, r) {
var tr = '
'+ '
' + this.id + ''+ '
' + this.username + ''+ '
' + r.email + ''+ '
' + r.sex + ''+ '
' + r.city + ''+ '
' + r.sign + ''+ '
' + r.experience + ''+ '
' + r.ip + ''+ '
' + r.logins + ''+ '
' + r.joinTime + ''+ '
';$("#tb").append(tr);
})
}
})
})
function Add(data) {
alert(data);
$.ajax({
url: "/Home/Add",
type: "post",
dataType: "json",
data: { list: data },
success: function (res) {
}
})
}
//function Tianjia() {
// //var id = document.getElementById('1').innerHTML;
// //var username = document.getElementById('2').innerHTML;
// //var email = document.getElementById('3').innerHTML;
// //var sex = document.getElementById('4').innerHTML;
// //var city = document.getElementById('5').innerHTML;
// //var sign = document.getElementById('6').innerHTML;
// //var experience = document.getElementById('7').innerHTML;
// //var ip = document.getElementById('8').innerHTML;
// //var logins = document.getElementById('9').innerHTML;
// //var joinTime = document.getElementById('10').innerHTML;
// //$.ajax({
// // url: "/Home/Add",
// // type: "post",
// // dataType: "json",
// // data: { id: id, username: username, email: email, sex: sex, city: city, sign: sign, experience: experience, ip: ip, logins: logins, joinTime: joinTime },
// // success: function (data) {
// // if (data > 0) {
// // alert('1');
// // }
// // }
// //})
//}
ID | 用户名 | 邮箱 | 性别 | 城市 | 签名 | 积分 | IP | 登入次数 | 加入时间 |
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(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;
}
[HttpPost]
public string Add(List list)
{
for (int i = 0; i < list.Count(); i++)
{
Stock k = list[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",k.id),
new SqlParameter("@username",k.username),
new SqlParameter("@email",k.email),
new SqlParameter("@sex",k.sex),
new SqlParameter("@city",k.city),
new SqlParameter("@sign",k.sign),
new SqlParameter("@experience",k.experience),
new SqlParameter("@ip",k.ip),
new SqlParameter("@logins",k.logins),
new SqlParameter("@joinTime",k.joinTime),
};
int count = DBHelper.ZSG(sql, pa);
}
var data = new
{
a = 200,
b = "添加成功"
};
var json = JsonConvert.SerializeObject(data);
return json;
}