List组装json返回值

 

 

//组装json返回值

List<TreeModel> Data = new List<TreeModel>();

string sql = "select * from Steel_ProductName order by PId asc,Sort asc,Id asc";

DataSet ds = db.GetDataSet(sql);

DataTable dt = ds.Tables[0];

for (int i = 0; i < dt.Rows.Count; i++)

{

TreeModel model = new TreeModel();

model.id =Convert.ToInt32(Public_Class.Ntrim(dt.Rows[i]["Id"]));

model.pId = Convert.ToInt32(Public_Class.Ntrim(dt.Rows[i]["PId"]));

model.name = Public_Class.Ntrim(dt.Rows[i]["ProductName"]);

model.open = true;

Data.Add(model);

}

RestSharp.Serializers.JsonSerializer serializer = new RestSharp.Serializers.JsonSerializer();

Response.Write("{\"result\":\"ok\",\"Data\":" + serializer.Serialize(Data) + "}");