• AX中Json转化成表记录


    static void JsonToTable(str _json,Common _Common)
    {
        sysdictTable        dictTable;
        TableId             tableId;
        dictfield           dictField, tmpdictField;
        int                 fieldsNum, i, fieldId, j, tmpdictFieldid;
        Map                 postsData;
        Map                 lineineMap;
        List                line;
        ListEnumerator      lineE;
        ;
        postsData = RetailCommonWebAPI::getMapFromJsonString(_json);
        tableId = _Common.TableId ;
        dictTable = new sysDictTable(tableId);
        fieldsNum = dictTable.columnCnt();
        fieldsNum = dictTable.fieldCntWithoutSys();
        line = List::create(postsData.lookup(tableId2name(tableId)));
        lineE = line.getEnumerator();
        while(lineE.moveNext())
        {
            lineineMap = Map::create(lineE.current());
            for(i=1;i<=fieldsNum;i++)
            {
                fieldId  = dictTable.fieldCnt2Id(i);
                dictField = new dictField(tableId,fieldId);
                for (j=1; j<=dictField.arraySize(); j++)
                {
                    tmpdictFieldid = fieldId2Ext(fieldId, j);
                    tmpdictField = new dictField(tableId,tmpdictFieldid);
                    if (lineineMap.exists(tmpdictField.name()))
                    {
                        _common.(tmpdictField.id()) = conPeek(lineineMap.lookup(tmpdictField.name()), 1);
                    }
                }
            }
            _common.insert();   
        }
    }
  • 相关阅读:
    PS的使用[未完待续]
    Navicat破解方法【很靠谱】
    some blogs
    Linux curl命令详解
    api_automation_mysql
    linux 笔记
    pytest 笔记
    sel+python 基础
    postman 断言
    homebrew note
  • 原文地址:https://www.cnblogs.com/alfred-cn/p/12455703.html
Copyright © 2020-2023  润新知