5135 sql server 获取树状分类数据接口 [直连版] App.DB_MsSQL_Data.FreeTree

假设原来有数据：
1> select * from TestTable;
2> go
id          name                                               quantity    parent_id  
----------- -------------------------------------------------- ----------- -----------
          4 小白V6                                                        27        NULL
          5 小白接口V5                                                     674           0
          6 小白V8                                                        19           4
          7 小白V8                                                        20           4
          8 小白V8                                                       131           0
          9 小白接口V5                                                     131           8
          10 小白接口V5                                                      10           8

(7 rows affected)

请求第一级：
{你的接口域名}/?s=App.DB_MsSQL_Data.FreeTree&model_name=TestTable&db_mark=db_test&parent_field=parent_id&parent_id=0&where=[["id", ">=", "1"]]&order=["id DESC"]&app_key={你的app_key}&sign={动态签名}

返回：
{
    "ret": 200,
    "data": {
        "err_code": 0,
        "err_msg": "",
        "tree": [
        {
            "id": 8,
            "name": "小白V8",
            "quantity": "131",
            "parent_id": 0,
            "children_tree": [
            {
                "id": 10,
                "name": "小白接口V5",
                "quantity": "10",
                "parent_id": 8
            },
            {
                "id": 9,
                "name": "小白接口V5",
                "quantity": "131",
                "parent_id": 8
            }
            ]
        },
        {
            "id": 5,
            "name": "小白接口V5",
            "quantity": "674",
            "parent_id": 0,
            "children_tree": []
        }
        ]
    },
    "msg": "V1.4.17 小白开放接口 App.DB_MsSQL_Data.FreeTree"
}

请求第二级：
{你的接口域名}/?s=App.DB_MsSQL_Data.FreeTree&model_name=TestTable&db_mark=db_test&parent_field=parent_id&parent_id=8&where=[["id", ">=", "1"]]&order=["id DESC"]&app_key={你的app_key}&sign={动态签名}

返回：
{
    "ret": 200,
    "data": {
        "err_code": 0,
        "err_msg": "",
        "tree": [
        {
            "id": 10,
            "name": "小白接口V5",
            "quantity": "10",
            "parent_id": 8,
            "children_tree": []
        },
        {
            "id": 9,
            "name": "小白接口V5",
            "quantity": "131",
            "parent_id": 8,
            "children_tree": []
        }
        ]
    },
    "msg": "V1.4.17 小白开放接口 App.DB_MsSQL_Data.FreeTree"
}