欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

LigerUi中下拉框一级树tree数据库读取代码示例!

程序员文章站 2022-05-25 15:41:56
...

/// 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}

]