LigerUi中下拉框一级树tree数据库读取代码示例!
/// summary /// 格式化字符型、日期型、布尔型 /// /summary private static string StringFormat(string str, Type type) { if (type == typeof(string)) { str = String2Json(str); str = \ + str + \; } else if (type == typeof(DateTime)) { str = \ +
////// 格式化字符型、日期型、布尔型 /// private static string StringFormat(string str, Type type) { if (type == typeof(string)) { str = String2Json(str); str = "\"" + str + "\""; } else if (type == typeof(DateTime)) { str = "\"" + str + "\""; } else if (type == typeof(bool)) { str = str.ToLower(); } else if (type != typeof(string) && string.IsNullOrEmpty(str)) { str = "\"" + str + "\""; } return str; } ////// 过滤特殊字符 /// private static string String2Json(String s) { StringBuilder sb = new StringBuilder(); for (int i = 0; i 1 or Deleted is Null"; Sql_Class SqlClass1 = new Sql_Class(); SqlDataReader dr1 = SqlClass1.Sql_Select(Sql_Count); StringBuilder Count_1 = new StringBuilder(); while (dr1.Read()) { for (int i = 0; i 1 or Deleted is Null"; Sql_Class SqlClass = new Sql_Class(); SqlDataReader dr = SqlClass.Sql_Select(Sql); StringBuilder jsonString = new StringBuilder(); jsonString.Append("{"); // 总括号 -- 开始 jsonString.Append('"' + "Total" + '"' + ":" + '"' + Count_1.ToString() + '"' + ","); // 字段总数 jsonString.Append('"' + "Rows" + '"' + ":"); // 行字段开始 jsonString.Append("["); // 字段开始 while (dr.Read()) { jsonString.Append("{"); for (int i = 0; i
[
{"id":"188","value":null,"text":"中国","icon": null, "fatherid": null, "children":null},
{"id":"20","value":null,"text":"河北","icon": null, "fatherid": null, "children":null},
{"id":"21","value":null,"text":"河南","icon": null, "fatherid": null, "children":null},
{"id":"11","value":null,"text":"河东","icon": null, "fatherid": null, "children":null},
{"id":"12","value":null,"text":"上海","icon": null, "fatherid": null, "children":null},
{"id":"166","value":null,"text":"北京","icon": null, "fatherid": null, "children":null},
{"id":"888","value":null,"text":"天津","icon": null, "fatherid": null, "children": null}
]
上一篇: MongoDB做日志服务器
下一篇: 随机获取表若干行