
-- 查询 关联权限项
DELETE FROM T_HRCS_PERMRELAT WHERE FID = 1566136351483624448;
INSERT INTO T_HRCS_PERMRELAT(FID,FCREATETIME,FPERMITEMID,FMODIFIERID,FMODIFYTIME,FAPPID,FDESCRIPTION,FCREATORID,FENTITYTYPEID) VALUES (1566136351483624448,{ts'2022-12-01  00:00:00'},'QXX0001',1,{ts'2022-12-01  00:00:00'},'217WYC/L9U7E',' ',1,'haos_projteambaseinfo'); 

DELETE FROM t_hrcs_permrelatentry WHERE FENTRYID = 1566136351525440512;
INSERT INTO t_hrcs_permrelatentry(FID,FISSYSPRESET,FPERMITEMID,FENTRYID,FSEQ,FAPPID,FENTITYTYPEID) VALUES (1566136351483624448,'1','QXX0001',1566136351525440512,1,'217WYC/L9U7E','haos_projectgroupadd'); 
DELETE FROM t_hrcs_permrelatentry WHERE FENTRYID = 1566137185336425472;
INSERT INTO t_hrcs_permrelatentry(FID,FISSYSPRESET,FPERMITEMID,FENTRYID,FSEQ,FAPPID,FENTITYTYPEID) VALUES (1566136351483624448,'1','QXX0001',1566137185336425472,2,'217WYC/L9U7E','haos_projteamcooprelalter'); 



-- 实体维度映射
DELETE FROM t_hrcs_entityctrl WHERE FID = 1518231557020593152;
INSERT INTO t_hrcs_entityctrl(FID,FCREATETIME,FMODIFIERID,FMODIFYTIME,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (1518231557020593152,{ts'2022-09-26  00:00:00'},1,{ts'2022-12-01  00:00:00'},'W11R1282DJK',1,'haos_projectgroupadd'); 

DELETE FROM t_hrcs_entitydimentry WHERE FENTRYID = 1566112118179112960;
INSERT INTO t_hrcs_entitydimentry(FID,FISMUST,FISSYSPRESET,FPROPKEY,FENTRYID,FDIMENSIONID,FSEQ,FDESCRIPTION,FAUTHRANGE) VALUES (1518231557020593152,'1','1','parentorg',1566112118179112960,1109486343509107712,2,' ','2'); 
DELETE FROM t_hrcs_entitydimentry WHERE FENTRYID = 1518231557020594176;
INSERT INTO t_hrcs_entitydimentry(FID,FISMUST,FISSYSPRESET,FPROPKEY,FENTRYID,FDIMENSIONID,FSEQ,FDESCRIPTION,FAUTHRANGE) VALUES (1518231557020593152,'1','1','belongadminorg',1518231557020594176,1109486343509107712,1,' ','2'); 


DELETE FROM t_hrcs_entityctrl WHERE FID = 1566045114080520192;
INSERT INTO t_hrcs_entityctrl(FID,FCREATETIME,FMODIFIERID,FMODIFYTIME,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (1566045114080520192,{ts'2022-12-01  00:00:00'},1,{ts'2022-12-02  00:00:00'},'W11R1282DJK',1,'haos_projteamcooprelalter'); 


DELETE FROM t_hrcs_entitydimentry WHERE FENTRYID = 1566515397908355072;
INSERT INTO t_hrcs_entitydimentry(FID,FISMUST,FISSYSPRESET,FPROPKEY,FENTRYID,FDIMENSIONID,FSEQ,FDESCRIPTION,FAUTHRANGE) VALUES (1566045114080520192,'1','1','parentorg',1566515397908355072,1109486343509107712,1,' ','3'); 
