数据导入
导入方案相关参数
// 信息集类型 1：人员 2：单位 3：岗位
String settype = importScheme.getString("settype");
// 人员库范围, 新增默认第一个
String nbase = importScheme.getString("nbase");
// 数据库类型 msql：SqL server, oracle：oracle数据库, mysql：mysql
String dbtype = importScheme.getString("dbtype");
// 数据库地址
String dbserver = importScheme.getString("dbserver");
// 数据库名称
String dbname = importScheme.getString("dbname");
// 数据库端口
String dbport = importScheme.getString("dbport");
// 数据库账号
String dbuser = importScheme.getString("dbuser");
// 数据库密码
String dbpwd = importScheme.getString("dbpwd");
// 数据库链接
String dburl = importScheme.getString("dburl");
// 信息表映射
JSONObject setref = importScheme.getJSONObject("setref");
// hcm信息集 A01
String ehrtable = setref.getString("ehrtable");
// 第三方表
String thirdtable = setref.getString("thirdtable");
// hcm关联指标
String ehrralation = setref.getString("ehrralation");
// 第三方关联指标
String thirdralation = setref.getString("thirdralation");
// hcm保护条件 (不更新hcm保护条件下的数据)
String ehrcond = setref.getString("ehrcond");
// 第三方过滤条件 (不获取第三方的这些数据)
String thirdcond = setref.getString("thirdcond");
// 指标映射
JSONArray fieldref = importScheme.getJSONArray("fieldref");
数据库参数存储格式
[
{
"id": "1",
"name": "导入人员主集",
"settype": "1 ",
"nbase": "Usr,Ret",
"dbtype": "mssql",
"dbserver": "127.0.0.1",
"dbname": "gqys",
"dbport": "1433",
"dbuser": "sa",
"dbpwd": "123456",
"dburl": "jdbc:sqlserver://127.0.0.1:1433;databaseName=gqys80;",
"enable": "1",
"setref": {
"ehrtable": "A01",
"thirdtable": "t_thirda01",
"ehrralation": "guidkey",
"thirdralation": "guidkey",
"ehrcond": "",
"thirdcond": ""
},
"fieldref": [
{
"hrfield": "a0101",
"thirdfield": "a0101",
"ispk": "0"
},
{
"hrfield": "a0107",
"thirdfield": "a0107",
"ispk": "0"
}
]
},
{
"id": "2",
"name": "导入人员子集方案",
"settype": "1 ",
"nbase": "Usr,Ret",
"dbtype": "mssql",
"dbserver": "127.0.0.1",
"dbname": "gqys",
"dbport": "1433",
"dbuser": "sa",
"dbpwd": "123456",
"dburl": "jdbc:sqlserver://127.0.0.1:1433;databaseName=gqys80;",
"enable": "1",
"setref": {
"ehrtable": "A04",
"thirdtable": "thirdA04",
"ehrralation": "a0100",
"thirdralation": "a0100",
"ehrcond": "",
"thirdcond": ""
},
"fieldref": [
{
"hrfield": "GUIDKEY",
"thirdfield": "GUIDKEY",
"ispk": "1"
},
{
"hrfield": "a0435",
"thirdfield": "a0435",
"ispk": "0"
},
{
"hrfield": "a0430",
"thirdfield": "a0430",
"ispk": "0"
},
{
"hrfield": "a0455",
"defaultVal": "随便一个单位",
"ispk": "0"
}
]
},
{
"id": "3",
"name": "导入机构子集",
"settype": "2 ",
"nbase": "",
"dbtype": "mssql",
"dbserver": "127.0.0.1",
"dbname": "gqys",
"dbport": "1433",
"dbuser": "sa",
"dbpwd": "123456",
"dburl": "jdbc:sqlserver://127.0.0.1:1433;databaseName=gqys80;",
"enable": "1",
"setref": {
"ehrtable": "B01",
"thirdtable": "thirdB01",
"ehrralation": "guidkey",
"thirdralation": "guidkey",
"ehrcond": "b0110 < '01040O00'",
"thirdcond": ""
},
"fieldref": [
{
"hrfield": "b0105",
"thirdfield": "b0105",
"ispk": "0"
},
{
"hrfield": "b0125",
"thirdfield": "b0125",
"ispk": "0"
},
{
"hrfield": "b0173",
"defaultVal": "指定默认代表人",
"ispk": "0"
}
]
},
{
"id": "4",
"name": "导入机构子集",
"settype": "2 ",
"nbase": "",
"dbtype": "mssql",
"dbserver": "127.0.0.1",
"dbname": "gqys",
"dbport": "1433",
"dbuser": "sa",
"dbpwd": "123456",
"dburl": "jdbc:sqlserver://127.0.0.1:1433;databaseName=gqys80;",
"enable": "1",
"setref": {
"ehrtable": "B07",
"thirdtable": "third_b07",
"ehrralation": "b0110",
"thirdralation": "b0110",
"ehrcond": "b0110 < '01040O00'",
"thirdcond": ""
},
"fieldref": [
{
"hrfield": "B07Z0",
"thirdfield": "B07Z0",
"ispk": "0"
},
{
"hrfield": "B07Z1",
"thirdfield": "B07Z1",
"ispk": "0"
},
{
"hrfield": "B0705",
"defaultVal": "7",
"ispk": "0"
},
{
"hrfield": "guidkey",
"thirdfield": "guidkey",
"ispk": "1"
}
]
}
]
数据导入的四种情况
人员主集
人员子集
机构主集
机构子集