如何用ajax从asp后太的list获取数据到前端 生成表格 (取到集合字段的值就行了)
后端传前端有点蒙 ,麻烦各位指点,谢谢
前端代码
$(function () {
$.ajax({
type: 'post',
url: 'test1.ashx',
dataType: 'text',
data: { },
success: function (data) {
//var obj_line = $.parseJSON(data);
//for (var i = 0; i < obj_line.length; i++) {
// alert(data[i].ProductName);
//}
},
error: function(){ alert("服务器端异常"); }
})
}
);
后端代码 ashx文件下的
public class test1 : IHttpHandler
{
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
JavaScriptSerializer jss = new JavaScriptSerializer();
List<Product> list = ProductBLL.ShowProduct();
context.Response.Write(jss.Serialize(list));
context.Response.End();
}
bll层
public static List<Product> ShowProduct()
{
return ProductDAL.ShowProduct();
}
dal层
public static List<Product> ShowProduct()
{
string sql = string.Format("select * from Product");
SqlDataReader dr = DBHelper.reDr(sql);
List<Product> list = new List<Product>();
while (dr.Read())
{
Product p = new Product()
{
ProductID=int.Parse(dr["ProductID"].ToString()),
ProductName= dr["ProductName"].ToString(),
ProductPric= dr["ProductPric"].ToString(),
ProductPrice=double.Parse( dr["ProductPrice"].ToString()),
ProductDese = dr["ProductDese"].ToString(),
ClassID= int.Parse(dr["ClassID"].ToString()),
AddTime=DateTime.Parse(dr["AddTime"].ToString())
};
list.Add(p);
}
dr.Close();
return list;
}
}
实体类models
public class Product
{
public int ProductID { get; set; }
public string ProductName { get; set; }
public string ProductPric { get; set; }
public Double ProductPrice { get; set; }
public string ProductDese { get; set; }
public int ClassID { get; set; }
public DateTime AddTime { get; set; }
}