
--供应商管理员角色
/*
准入协同注册用户删除打印和引出权限
*/
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_userquery' and fpermitemid='4730fc9e000000ac';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_userquery' and fpermitemid='4730fc9f000004ae';

/*
注册资料查询删除 管理权转让 变更控制策略  维护革新数据
*/
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_supplier' and fpermitemid='/IN0GIK354+3';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_supplier' and fpermitemid='0DYOW+U/0B9B';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_supplier' and fpermitemid='4730fc9f000000ac';

/*
注册资料变更
*/
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_supchange' and fpermitemid='47162f66000000ac';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_supchange' and fpermitemid='47165e8e000000ac';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_supchange' and fpermitemid='4730fc9f000000ad';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_supchange' and fpermitemid='4730fc9f000000ae';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_supchange' and fpermitemid='80513207000000ac';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_supchange' and fpermitemid='4730fc9f000002ae';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_supchange' and fpermitemid='4730fc9f000003ae';


/*
评估报告
*/
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_score' and fpermitemid='4730fc9f000000ad';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_score' and fpermitemid='4730fc9f000000ae';

/*
改善管理
*/
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_improve' and fpermitemid='47156aff000000ac';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_improve' and fpermitemid='4715e1f1000000ac';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_improve' and fpermitemid='47162f66000000ac';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_improve' and fpermitemid='47165e8e000000ac'; 
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_improve' and fpermitemid='804f6478000000ac'; 
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_improve' and fpermitemid='80513207000000ac';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_improve' and fpermitemid='4730fc9f000000ad'; 
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_improve' and fpermitemid='4730fc9f000000ae'; 
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_improve' and fpermitemid='4730fc9f000002ae'; 
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_improve' and fpermitemid='4730fc9f000003ae'; 


/*
考核管理
*/
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_examine' and fpermitemid='47156aff000000ac'; 
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_examine' and fpermitemid='4715e1f1000000ac'; 
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_examine' and fpermitemid='47162f66000000ac'; 
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_examine' and fpermitemid='47165e8e000000ac'; 
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_examine' and fpermitemid='804f6478000000ac'; 
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_examine' and fpermitemid='80513207000000ac'; 
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_examine' and fpermitemid='4730fc9f000000ad'; 
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_examine' and fpermitemid='4730fc9f000000ae'; 
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_examine' and fpermitemid='4730fc9f000002ae';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_examine' and fpermitemid='4730fc9f000003ae';

/*
质量变更申请
*/
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_quality' and fpermitemid='4730fc9f000000ad';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_quality' and fpermitemid='4730fc9f000000ae';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_quality' and fpermitemid='4730fc9f000002ae';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF7KUBZ0L8B' and fentitytypeid='adm_quality' and fpermitemid='4730fc9f000003ae';


--2.供应商用户角色
/*
注册用户查询
*/
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_userquery' and fpermitemid='4730fc9e000000ac';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_userquery' and fpermitemid='4730fc9f000004ae';

/*
注册资料查询
*/
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_supplier' and fpermitemid='/IN0GIK354+3';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_supplier' and fpermitemid='0DYOW+U/0B9B';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_supplier' and fpermitemid='4730fc9f000000ac';

/*
注册资料变更
*/
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_supchange' and fpermitemid='47162f66000000ac';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_supchange' and fpermitemid='47165e8e000000ac';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_supchange' and fpermitemid='4730fc9f000000ad';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_supchange' and fpermitemid='4730fc9f000000ae';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_supchange' and fpermitemid='80513207000000ac';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_supchange' and fpermitemid='4730fc9f000002ae';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_supchange' and fpermitemid='4730fc9f000003ae';


/*
品类变更查询
*/
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '20H31BUARGHR';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FENTITYTYPEID,FCONTROLMODE) VALUES ('0KF19VDCVAK+','4715e1f1000000ac','20H31BUARGHR',' ','/DNEA3QW/ATD',0,'adm_categorychg',' '); 
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '20H31BUARGHU';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FENTITYTYPEID,FCONTROLMODE) VALUES ('0KF19VDCVAK+','804f6478000000ac','20H31BUARGHU',' ','/DNEA3QW/ATD',0,'adm_categorychg',' '); 
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '20H31BUARGHV';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FENTITYTYPEID,FCONTROLMODE) VALUES ('0KF19VDCVAK+','80513207000000ac','20H31BUARGHV',' ','/DNEA3QW/ATD',0,'adm_categorychg',' '); 

/*
评估报告
*/
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_score' and fpermitemid='4730fc9f000000ad';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_score' and fpermitemid='4730fc9f000000ae';

/*
改善管理
*/
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_improve' and fpermitemid='47156aff000000ac';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_improve' and fpermitemid='4715e1f1000000ac';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_improve' and fpermitemid='47162f66000000ac';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_improve' and fpermitemid='47165e8e000000ac';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_improve' and fpermitemid='804f6478000000ac';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_improve' and fpermitemid='80513207000000ac';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_improve' and fpermitemid='4730fc9f000000ad';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_improve' and fpermitemid='4730fc9f000000ae';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_improve' and fpermitemid='4730fc9f000002ae';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_improve' and fpermitemid='4730fc9f000003ae';


/*
考核管理
*/
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_examine' and fpermitemid='47156aff000000ac';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_examine' and fpermitemid='4715e1f1000000ac';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_examine' and fpermitemid='47162f66000000ac';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_examine' and fpermitemid='47165e8e000000ac';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_examine' and fpermitemid='804f6478000000ac';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_examine' and fpermitemid='80513207000000ac';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_examine' and fpermitemid='4730fc9f000000ad';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_examine' and fpermitemid='4730fc9f000000ae';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_examine' and fpermitemid='4730fc9f000002ae';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_examine' and fpermitemid='4730fc9f000003ae';

/*
质量变更申请
*/
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_quality' and fpermitemid='4730fc9f000000ad';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_quality' and fpermitemid='4730fc9f000000ae';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_quality' and fpermitemid='4730fc9f000002ae';
DELETE FROM t_perm_rolepermdetial WHERE fid ='0KF19VDCVAK+' and fentitytypeid='adm_quality' and fpermitemid='4730fc9f000003ae';