/// <summary> /// 列表数据 /// 菜单信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public string Select_Menus(string id) { try { using (JSZX_ResourceEntities db = new JSZX_ResourceEntities()) { var linq = from t in db.SPT_Menus(id) select t; List <SPT_Menus_Result> it = new List <SPT_Menus_Result>(); it = linq.ToList(); string ret = ""; // 判断是否取到数据 if (it != null && it.Count > 0)// 取到数据 { ret += "{\"Table\":["; for (int i = 0; i < it.Count; i++) { // 不是第一行 补逗号 if (i != 0) { ret += ","; } ret += "{" + "\"id\":\"" + it[i].id + "\"" + ",\"pId\":\"" + it[i].pId + "\"" + ",\"name\":\"" + it[i].name + "\"" + ",\"checked\":\"" + it[i].is_checked + "\"" + "}"; } ret += "]}"; } return(ret); } } catch (Exception ex) { return(""); } }