|
问题已经解决了,处理方式是,删除UI模板,重新启用0租户模板
UI模板上的按钮做了调整后,好像是会有问题,无法修复,UI模板删除语法
delete from iuap_apdoc_basedoc.billentity_base where ytenant_id = '' and iBillId in (select id from iuap_apdoc_basedoc.bill_base where ytenant_id = '' and cBillNo in ('hrbd_org_admin_list'));
delete from iuap_apdoc_basedoc.billtemplate_base where ytenant_id = '' and iBillId in (select id from iuap_apdoc_basedoc.bill_base where ytenant_id = '' and cBillNo in ('hrbd_org_admin_list'));
delete from iuap_apdoc_basedoc.billtplgroup_base where ytenant_id = '' and iBillId in (select id from iuap_apdoc_basedoc.bill_base where ytenant_id = '' and cBillNo in ('hrbd_org_admin_list'));
delete from iuap_apdoc_basedoc.billitem_base where ytenant_id = '' and iBillId in (select id from iuap_apdoc_basedoc.bill_base where ytenant_id = '' and cBillNo in ('hrbd_org_admin_list'));
delete from iuap_apdoc_basedoc.bill_command where ytenant_id = '' and billnumber in (select cBillNo from iuap_apdoc_basedoc.bill_base where ytenant_id = '' and cBillNo in ('hrbd_org_admin_list'));
delete from iuap_apdoc_basedoc.bill_toolbar where ytenant_id = '' and billnumber in (select cBillNo from iuap_apdoc_basedoc.bill_base where ytenant_id = '' and cBillNo in ('hrbd_org_admin_list'));
delete from iuap_apdoc_basedoc.bill_toolbaritem where ytenant_id = '' and billnumber in (select cBillNo from iuap_apdoc_basedoc.bill_base where ytenant_id = '' and cBillNo in ('hrbd_org_admin_list'));
delete from iuap_apdoc_basedoc.bill_base where ytenant_id = '' and cBillNo in ('hrbd_org_admin_list');
select * from iuap_apdoc_basedoc.billentity_base where ytenant_id = '' and iBillId in (select id from iuap_apdoc_basedoc.bill_base where ytenant_id = '' and cBillNo in ('hrbd_org_admin_list'));
select * from iuap_apdoc_basedoc.billtemplate_base where ytenant_id = '' and iBillId in (select id from iuap_apdoc_basedoc.bill_base where ytenant_id = '' and cBillNo in ('hrbd_org_admin_list'));
select * from iuap_apdoc_basedoc.billtplgroup_base where ytenant_id = '' and iBillId in (select id from iuap_apdoc_basedoc.bill_base where ytenant_id = '' and cBillNo in ('hrbd_org_admin_list'));
select * from iuap_apdoc_basedoc.billitem_base where ytenant_id = '' and iBillId in (select id from iuap_apdoc_basedoc.bill_base where ytenant_id = '' and cBillNo in ('hrbd_org_admin_list'));
select * from iuap_apdoc_basedoc.bill_command where ytenant_id = '' and billnumber in (select cBillNo from iuap_apdoc_basedoc.bill_base where ytenant_id = '' and cBillNo in ('hrbd_org_admin_list'));
select * from iuap_apdoc_basedoc.bill_toolbar where ytenant_id = '' and billnumber in (select cBillNo from iuap_apdoc_basedoc.bill_base where ytenant_id = '' and cBillNo in ('hrbd_org_admin_list'));
select * from iuap_apdoc_basedoc.bill_toolbaritem where ytenant_id = '' and billnumber in (select cBillNo from iuap_apdoc_basedoc.bill_base where ytenant_id = '' and cBillNo in ('hrbd_org_admin_list'));
select * from iuap_apdoc_basedoc.bill_base where ytenant_id = '' and cBillNo in ('hrbd_org_admin_list'); |
|