AX中Json转化成表记录
2024-09-19 18:26:48
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);
{
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();
}
}
{
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();
}
}
最新文章
- Linux/Windows下如何退出telnet
- SMTP邮箱验证错误解决
- 实现跨域请求jsonp方式
- js地理位置获取、显示、轨迹绘制
- PHP 高并发、抢票、秒杀 解决方案
- IOS播放音乐和音效
- [SQL SERVER系列]存储过程,游标和触发器实例[原创]
- SPRING IN ACTION 第4版笔记-第八章Advanced Spring MVC-007-给flowl加权限控制<;secured>;
- Spring-----3、Spring的核心机制(依赖注入)
- scauoj 18025 小明的密码 数位DP
- C++11中map的用法
- MongoDB【快速入门】
- 快速理解js中的call,apply的作用
- Linux中的 openssl-opensslv
- C#的split分割的举例
- webpack 4.x之搭建前端开发环境
- spring-cloud-config-server——Environment Repository
- (zhuan) LSTM Neural Network for Time Series Prediction
- [转载]Core Elements of a Program
- EMACS快捷键