//组装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) + "}");