/** webapi aifs取数 **/
delete from t_open_apiservice_aicmd where FENTRYID = 435402105168155651;
delete from t_open_apiservice_aicmd_l where FPKID = '/BFZ+O6S9+AU';
delete from t_open_apiservice_aicmd_l where FPKID = '/BFZ+O6S9+AV';
INSERT INTO t_open_apiservice_aicmd (FID,FENTRYID, FSEQ, FAINUMBER) VALUES (435402105168155648, 435402105168155651, 1, 'aifsGetData');
INSERT INTO t_open_apiservice_aicmd_l (FPKID, FENTRYID, FLOCALEID, FAINAME, FAIDESCRIPTION) VALUES ('/BFZ+O6S9+AU', 435402105168155651, 'zh_CN', 'aifs取数', ' ');
/** webapi 获取财务数据 **/
delete from t_open_apiservice where FID = 435402105168155648;
delete from t_open_apiservice_l where FPKID = '/BFZ+O6S9+AS';
delete from t_open_apiservice_l where FPKID = '/BFZ+O6S9+AR';
INSERT INTO t_open_apiservice (FID, FNUMBER, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FENABLE, FDISABLERID, FDISABLEDATE, FMESSAGETYPE, FBIZOBJECT, FAPPID, FSTATUS, FURLFORMAT, FURL, FHTTPMETHOD, FCONTENTTYPE, FREQTYPE, FREPTYPE, FPLUGIN, FAPISERVICETYPE, FOPERATION, FCUSTOMMETHOD, FMASTERID) VALUES (435402105168155648, 'getFiDataService', 1201, {ts'2018-08-24 17:43:44'}, 1201, {ts'2018-08-24 17:46:15'}, '1', null, null, null, ' ', '11H66HLOX4IC', 'A', '/ai/do', '/ai/do', '0', '0', 0, 0, '[{"Type":0,"_Type_":"Plugin","ClassName":"kd.fi.aifs.formplugin.parse.PaserAiCommand","Enabled":true,"rowKey":null}]', '1', ' ', ' ', 435402105168155648);
INSERT INTO t_open_apiservice_l (FPKID, FID, FLOCALEID, FNAME, FDISCRIPTION) VALUES ('/BFZ+O6S9+AR', 435402105168155648, 'zh_CN', '获取财务数据', ' ');
/** webapi 集成接口服务 **/
DELETE FROM t_open_apiservice WHERE FID = 630852696877858816;
DELETE FROM t_open_apiservice_l WHERE FPKID = '/ZGB2SXSNG/9';
DELETE FROM t_open_apiservice_l WHERE FPKID = '/ZGB2SXSNG/=';
INSERT INTO t_open_apiservice (FID, FNUMBER, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FENABLE, FDISABLERID, FDISABLEDATE, FMESSAGETYPE, FBIZOBJECT, FAPPID, FSTATUS, FURLFORMAT, FURL, FHTTPMETHOD, FCONTENTTYPE, FREQTYPE, FREPTYPE, FPLUGIN, FAPISERVICETYPE, FOPERATION, FCUSTOMMETHOD, FMASTERID) VALUES (630852696877858816, 'IntegrationApiService', 209630, {ts'2019-5-21 09:50:25'}, 209630, {ts'2019-5-22 17:04:40'}, '1', NULL, NULL, NULL, ' ', '11H66HLOX4IC', 'C', '/app/{appId}/{servicename}', '/app/cm/IntegrationApiService', '1', '0', 0, 0, '[{\"ClassName\":\"kd.fi.bcm.formplugin.intergration.IntegrationApiPlugin\",\"Enabled\":true}]', '2', ' ', ' ', 630852696877858816);
INSERT INTO t_open_apiservice_l (FPKID, FID, FLOCALEID, FNAME, FDISCRIPTION) VALUES ('/ZGB2SXSNG/9', 630852696877858816, 'zh_CN', '集成接口服务', '集成接口服务');
/** webapi Excel客戶端API **/
DELETE FROM t_open_apiservice WHERE FID = 685902433376884736;
DELETE FROM t_open_apiservice_l WHERE FPKID = '0481X=+I+YC6';
INSERT INTO t_open_apiservice (FID, FNUMBER, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FENABLE, FDISABLERID, FDISABLEDATE, FMESSAGETYPE, FBIZOBJECT, FAPPID, FSTATUS, FURLFORMAT, FURL, FHTTPMETHOD, FCONTENTTYPE, FREQTYPE, FREPTYPE, FAPISERVICETYPE, FOPERATION, FCUSTOMMETHOD, FMASTERID, FPLUGIN)
values (685902433376884736, 'excelAPI', 1748914, {ts'2019-08-05 08:44:46'}, 1748914, {ts'2019-08-05 08:44:46'}, '1', null, null, null, ' ', '11H66HLOX4IC', 'C', '/app/cm/excelAPI', ' ', '0', '0', '0', '0', '2', ' ', ' ', 685902433376884736, '[{"Type":0,"_Type_":"Plugin","ClassName":"kd.fi.bcm.formplugin.excel.ExcelPlugin","Enabled":true,"rowKey":null}]');
INSERT INTO t_open_apiservice_l (FPKID, FID, FLOCALEID, FNAME, FDISCRIPTION) VALUES ('0481X=+I+YC6', 685902433376884736, 'zh_CN', 'Excel客戶端API', 'Excel客戶端API');
/** webapi 集成日志追踪 add by qingmao**/
DELETE FROM t_open_apiservice WHERE FID = 722159734693619712;
INSERT INTO t_open_apiservice(FID,FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,FDISABLEDATE,FURL,FMASTERID,FSTATUS,FCONTENTTYPE,FNUMBER,FREPTYPE,FMESSAGETYPE,FCREATETIME,FMODIFIERID,FENABLE,FPLUGIN,FMODIFYTIME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID,FREQTYPE,FDISABLERID,FBIZOBJECT) VALUES (722159734693619712,'2',' ',' ',null,' ',722159734693619712,'C','0','ISEventLogServiceAPI',0,null,{ts'2019-09-24  09:18:09'},89559110,'1','[{"Type":0,"_Type_":"Plugin","RowKey":1,"ClassName":"kd.fi.bcm.formplugin.intergration.ISEventLogServiceAPIPlugin","Enabled":true,"rowKey":null}]',{ts'2019-09-24  09:22:28'},'11H66HLOX4IC','/app/cm/ISEventLogServiceAPI','1',89559110,0,null,' '); 
DELETE FROM t_open_apiservice_l WHERE FID = 722159734693619712;
INSERT INTO t_open_apiservice_l(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (722159734693619712,' ','08OSEM1Q4Y9R','zh_CN','集成日志追踪');

/** 后需改动修改api规范,非新增函数 **/
delete from t_open_apiservice where FID = 435402105168155648;
INSERT INTO t_open_apiservice (FID, FNUMBER, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FENABLE, FDISABLERID, FDISABLEDATE, FMESSAGETYPE, FBIZOBJECT, FAPPID, FSTATUS, FURLFORMAT, FURL, FHTTPMETHOD, FCONTENTTYPE, FREQTYPE, FREPTYPE, FPLUGIN, FAPISERVICETYPE, FOPERATION, FCUSTOMMETHOD, FMASTERID) VALUES (435402105168155648, 'getFiDataService', 1, {ts'2018-8-8 18:08:08'}, 1, {ts'2018-8-8 18:08:08'}, '1', null, null, null, ' ', '11H66HLOX4IC', 'A', '/ai/do', '/ai/do', '0', '0', 0, 0, '[{"Type":0,"_Type_":"Plugin","ClassName":"kd.fi.aifs.formplugin.parse.PaserAiCommand","Enabled":true,"rowKey":null}]', '1', ' ', ' ', 435402105168155648);
DELETE FROM t_open_apiservice WHERE FID = 630852696877858816;
INSERT INTO t_open_apiservice (FID, FNUMBER, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FENABLE, FDISABLERID, FDISABLEDATE, FMESSAGETYPE, FBIZOBJECT, FAPPID, FSTATUS, FURLFORMAT, FURL, FHTTPMETHOD, FCONTENTTYPE, FREQTYPE, FREPTYPE, FPLUGIN, FAPISERVICETYPE, FOPERATION, FCUSTOMMETHOD, FMASTERID) VALUES (630852696877858816, 'IntegrationApiService', 1, {ts'2018-8-8 18:08:08'}, 1, {ts'2018-8-8 18:08:08'}, '1', NULL, NULL, NULL, ' ', '11H66HLOX4IC', 'C', '/app/cm/IntegrationApiService', '/app/cm/IntegrationApiService', '1', '0', 0, 0, '[{\"ClassName\":\"kd.fi.bcm.formplugin.intergration.IntegrationApiPlugin\",\"Enabled\":true}]', '1', ' ', ' ', 630852696877858816);
DELETE FROM t_open_apiservice WHERE FID = 685902433376884736;
INSERT INTO t_open_apiservice (FID, FNUMBER, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FENABLE, FDISABLERID, FDISABLEDATE, FMESSAGETYPE, FBIZOBJECT, FAPPID, FSTATUS, FURLFORMAT, FURL, FHTTPMETHOD, FCONTENTTYPE, FREQTYPE, FREPTYPE, FAPISERVICETYPE, FOPERATION, FCUSTOMMETHOD, FMASTERID, FPLUGIN)
values (685902433376884736, 'excelAPI', 1, {ts'2018-8-8 18:08:08'}, 1, {ts'2018-8-8 18:08:08'}, '1', null, null, null, ' ', '11H66HLOX4IC', 'C', '/app/cm/excelAPI', ' ', '0', '0', '0', '0', '1', ' ', ' ', 685902433376884736, '[{"Type":0,"_Type_":"Plugin","ClassName":"kd.fi.bcm.formplugin.excel.ExcelPlugin","Enabled":true,"rowKey":null}]');
DELETE FROM t_open_apiservice WHERE FID = 722159734693619712;
INSERT INTO t_open_apiservice(FID,FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,FDISABLEDATE,FURL,FMASTERID,FSTATUS,FCONTENTTYPE,FNUMBER,FREPTYPE,FMESSAGETYPE,FCREATETIME,FMODIFIERID,FENABLE,FPLUGIN,FMODIFYTIME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID,FREQTYPE,FDISABLERID,FBIZOBJECT) VALUES (722159734693619712,'2',' ',' ',null,' ',722159734693619712,'C','0','ISEventLogServiceAPI',0,null,{ts'2018-8-8 18:08:08'},1,'1','[{"Type":0,"_Type_":"Plugin","RowKey":1,"ClassName":"kd.fi.bcm.formplugin.intergration.ISEventLogServiceAPIPlugin","Enabled":true,"rowKey":null}]',{ts'2018-8-8 18:08:08'},'11H66HLOX4IC','/app/cm/ISEventLogServiceAPI','1',1,0,null,' '); 

