前端:
$.ajax({
type: 'Get',
contentType: "application/x-www-form-urlencoded",
url: 'http://localhost:57181/api/MyWebAPI/GetTaoCanOnHttpGet',
data: { id: categoryid,name:'helenzhou' },
dataType: 'json',
success: function (data) {
var tt = "";
$.each(data, function (k, v) {
tt += '<div style="height:120px;">' +
'<img src="' + v.taoCanIMGUrl + '" style="width:100px;height:100px;float:left;"/>' +
'<ul style="float:left;list-style: none;padding-left: 10px">' +
'<li>' + v.name + '</li>' +
'<li>' + v.price + '</li>' +
'<li onclick="AddToCart(' + v.taoCanId + ',' + v.price + ',\'' + v.name + '\');">加入购物车</li></ul></div>';
});
$("#div_taocan").html(tt);
}
});
public class MyWebAPIController : ApiController
[HttpGet]
public List<TaoCan> GetTaoCanOnHttpGet(string id,string name)
{
Console.WriteLine(id);
Console.WriteLine(name);
var taoCanCategoryId = new System.Data.SqlClient.SqlParameter("@taoCanCategoryId",
System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input,
0, 0, "taoCanCategoryId", System.Data.DataRowVersion.Current, false, null, "", "", "");
taoCanCategoryId.Value = Convert.ToInt32(id);
var list = db.Database.SqlQuery<TaoCan>(@"SELECT [taoCanId]
,[name]
,[price]
,[isOnline]
,[AddTime]
,[ModifyTime]
,[taoCanCategoryId]
,[taoCanIMGUrl]
FROM [dbo].[TaoCan]
where taoCanCategoryId =@taoCanCategoryId
", taoCanCategoryId).ToList();
return list;
}