--预置角色-角色维度页签-预置数据处理
--业务数据提报员

--预置维度
--这个表的id保存一次就会刷新，所以不能根据id删除
DELETE FROM t_hrcs_roledimension WHERE FROLEID = '2D5ECEASF48H' and FDIMENSIONID = 1386189615295269888;
DELETE FROM t_hrcs_roledimension WHERE FROLEID = '2D5ECEASF48H' and FDIMENSIONID = 1109486343509107712;

INSERT INTO t_hrcs_roledimension(FID,FCREATETIME,FMODIFIERID,FDIMENSIONID,FMODIFYTIME,FROLEID,FBUCAFUNCID,FCREATORID) VALUES (1987192218540060672,{ts'2024-07-04  00:00:00'},13466739,1386189615295269888,{ts'2024-07-04  00:00:00'},'2D5ECEASF48H',29,0);

INSERT INTO t_hrcs_roledimension(FID,FCREATETIME,FMODIFIERID,FDIMENSIONID,FMODIFYTIME,FROLEID,FBUCAFUNCID,FCREATORID) VALUES (1987192218540060673,{ts'2024-07-04  00:00:00'},13466739,1109486343509107712,{ts'2024-07-04  00:00:00'},'2D5ECEASF48H',29,0);

--id会变，统一删除，预置数据，客户不能编辑，应该不会多删。
delete from t_hrcs_dimensionprop where fid in (select fid FROM t_hrcs_roledimension WHERE FROLEID = '2D5ECEASF48H' and FDIMENSIONID = 1386189615295269888);
delete from t_hrcs_dimensionprop where fid in (select fid FROM t_hrcs_roledimension WHERE FROLEID = '2D5ECEASF48H' and FDIMENSIONID = 1109486343509107712);

DELETE FROM t_hrcs_dimensionprop WHERE FENTRYID = 1987192218540061696;
INSERT INTO t_hrcs_dimensionprop(FID,FCREATETIME,FMODIFIERID,FENABLE,FPROPKEY,FENTRYID,FMODIFYTIME,FSEQ,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (1987192218540060672,NULL,0,'1','bizitemgroup',1987192218540061696,NULL,0,'0NXW1VOPH+QV',0,'hpdi_bizdatabillchoicetpl');
DELETE FROM t_hrcs_dimensionprop WHERE FENTRYID = 1987192218540061697;
INSERT INTO t_hrcs_dimensionprop(FID,FCREATETIME,FMODIFIERID,FENABLE,FPROPKEY,FENTRYID,FMODIFYTIME,FSEQ,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (1987192218540060672,NULL,0,'1','bizitemgroup',1987192218540061697,NULL,0,'0NXW1VOPH+QV',0,'hpdi_bizdatabill');
DELETE FROM t_hrcs_dimensionprop WHERE FENTRYID = 1987192218540061698;
INSERT INTO t_hrcs_dimensionprop(FID,FCREATETIME,FMODIFIERID,FENABLE,FPROPKEY,FENTRYID,FMODIFYTIME,FSEQ,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (1987192218540060672,NULL,0,'1','bizitemgroup',1987192218540061698,NULL,0,'0NXW1VOPH+QV',0,'hpdi_bizdataoperatelog');
DELETE FROM t_hrcs_dimensionprop WHERE FENTRYID = 1987192218540061699;
INSERT INTO t_hrcs_dimensionprop(FID,FCREATETIME,FMODIFIERID,FENABLE,FPROPKEY,FENTRYID,FMODIFYTIME,FSEQ,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (1987192218540060672,NULL,0,'1','bizitemgroup',1987192218540061699,NULL,0,'0NXW1VOPH+QV',0,'hpdi_circlebizdata');
DELETE FROM t_hrcs_dimensionprop WHERE FENTRYID = 1987192218540061700;
INSERT INTO t_hrcs_dimensionprop(FID,FCREATETIME,FMODIFIERID,FENABLE,FPROPKEY,FENTRYID,FMODIFYTIME,FSEQ,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (1987192218540060672,NULL,0,'1','bizitemgroup',1987192218540061700,NULL,0,'0NXW1VOPH+QV',0,'hpdi_bizdatarecord');
DELETE FROM t_hrcs_dimensionprop WHERE FENTRYID = 1987192218540061701;
INSERT INTO t_hrcs_dimensionprop(FID,FCREATETIME,FMODIFIERID,FENABLE,FPROPKEY,FENTRYID,FMODIFYTIME,FSEQ,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (1987192218540060672,NULL,0,'1','bizitemgroup',1987192218540061701,NULL,0,'0NXW1VOPH+QV',0,'hpdi_bizdataerrorlog');
DELETE FROM t_hrcs_dimensionprop WHERE FENTRYID = 1987192218540061702;
INSERT INTO t_hrcs_dimensionprop(FID,FCREATETIME,FMODIFIERID,FENABLE,FPROPKEY,FENTRYID,FMODIFYTIME,FSEQ,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (1987192218540060672,NULL,0,'1','bizitemgroup',1987192218540061702,NULL,0,'0NXW1VOPH+QV',0,'hpdi_allbizdata');
DELETE FROM t_hrcs_dimensionprop WHERE FENTRYID = 1987192218540061703;
INSERT INTO t_hrcs_dimensionprop(FID,FCREATETIME,FMODIFIERID,FENABLE,FPROPKEY,FENTRYID,FMODIFYTIME,FSEQ,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (1987192218540060672,NULL,0,'1','bizitemgroup',1987192218540061703,NULL,0,'0NXW1VOPH+QV',0,'hpdi_notcirclebizdata');
DELETE FROM t_hrcs_dimensionprop WHERE FENTRYID = 1987192218540061704;
INSERT INTO t_hrcs_dimensionprop(FID,FCREATETIME,FMODIFIERID,FENABLE,FPROPKEY,FENTRYID,FMODIFYTIME,FSEQ,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (1987192218540060673,NULL,0,'1','adminorg',1987192218540061704,NULL,0,'0NXW1VOPH+QV',0,'hpdi_bizdatarecord');
DELETE FROM t_hrcs_dimensionprop WHERE FENTRYID = 1987192218540061705;
INSERT INTO t_hrcs_dimensionprop(FID,FCREATETIME,FMODIFIERID,FENABLE,FPROPKEY,FENTRYID,FMODIFYTIME,FSEQ,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (1987192218540060673,NULL,0,'1','adminorg',1987192218540061705,NULL,0,'0NXW1VOPH+QV',0,'hpdi_notcirclebizdata');
DELETE FROM t_hrcs_dimensionprop WHERE FENTRYID = 1987192218540061706;
INSERT INTO t_hrcs_dimensionprop(FID,FCREATETIME,FMODIFIERID,FENABLE,FPROPKEY,FENTRYID,FMODIFYTIME,FSEQ,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (1987192218540060673,NULL,0,'1','empposorgrel.adminorg',1987192218540061706,NULL,0,'0NXW1VOPH+QV',0,'hpdi_bizdatabillent');
DELETE FROM t_hrcs_dimensionprop WHERE FENTRYID = 1987192218540061707;
INSERT INTO t_hrcs_dimensionprop(FID,FCREATETIME,FMODIFIERID,FENABLE,FPROPKEY,FENTRYID,FMODIFYTIME,FSEQ,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (1987192218540060673,NULL,0,'1','adminorg',1987192218540061707,NULL,0,'0NXW1VOPH+QV',0,'hpdi_circlebizdata');
DELETE FROM t_hrcs_dimensionprop WHERE FENTRYID = 1987192218540061708;
INSERT INTO t_hrcs_dimensionprop(FID,FCREATETIME,FMODIFIERID,FENABLE,FPROPKEY,FENTRYID,FMODIFYTIME,FSEQ,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (1987192218540060673,NULL,0,'1','adminorg',1987192218540061708,NULL,0,'0NXW1VOPH+QV',0,'hpdi_bizdataoperatelog');
DELETE FROM t_hrcs_dimensionprop WHERE FENTRYID = 1987192218540061709;
INSERT INTO t_hrcs_dimensionprop(FID,FCREATETIME,FMODIFIERID,FENABLE,FPROPKEY,FENTRYID,FMODIFYTIME,FSEQ,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (1987192218540060673,NULL,0,'1','adminorg',1987192218540061709,NULL,0,'0NXW1VOPH+QV',0,'hpdi_bizdataerrorlog');
DELETE FROM t_hrcs_dimensionprop WHERE FENTRYID = 1987192218540061710;
INSERT INTO t_hrcs_dimensionprop(FID,FCREATETIME,FMODIFIERID,FENABLE,FPROPKEY,FENTRYID,FMODIFYTIME,FSEQ,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (1987192218540060673,NULL,0,'1','adminorg',1987192218540061710,NULL,0,'0NXW1VOPH+QV',0,'hpdi_bizdatabill');
DELETE FROM t_hrcs_dimensionprop WHERE FENTRYID = 1987192218540061711;
INSERT INTO t_hrcs_dimensionprop(FID,FCREATETIME,FMODIFIERID,FENABLE,FPROPKEY,FENTRYID,FMODIFYTIME,FSEQ,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (1987192218540060673,NULL,0,'1','adminorg',1987192218540061711,NULL,0,'0NXW1VOPH+QV',0,'hpdi_allbizdata');
