④内部公开请勿外传--第一步：以下放在查询分析器中，选中>>执行sqlSELECT*INTOT_ORG_BASEUNIT_BAK0806fromT_ORG_BASEUNITwherecharindex('_',FNUMBER)>0;updateT_ORG_BASEUNITorgsetFNUMBER=replace(FNUMBER,'_','-'),FLONGNUMBER=replace(FLONGNUMBER,'_','-')WHEREexists(SELECT1FROMT_ORG_BASEUNIT_BAK0806bakwherebak.fid=org.fid);SELECT*INTOT_ORG_Admin_BAK0806fromT_ORG_Adminwherecharindex('_',FNUMBER)>0;updateT_ORG_AdminorgsetFNUMBER=replace(FNUMBER,'_','-'),FLONGNUMBER=replace(FLONGNUMBER,'_','-')WHEREexists(SELECT1FROMT_ORG_Admin_BAK0806bakwherebak.fid=org.fid);SELECT*INTOT_ORG_CtrlUnit_BAK0806fromT_ORG_CtrlUnitwherecharindex('_',FNUMBER)>0;updateT_ORG_CtrlUnitorgsetFNUMBER=replace(FNUMBER,'_','-'),FLONGNUMBER=replace(FLONGNUMBER,'_','-')WHEREexists(SELECT1FROMT_ORG_CtrlUnit_BAK0806bakwherebak.fid=org.fid);SELECT*INTOT_ORG_Company_BAK0806fromT_ORG_Companywherecharindex('_',FNUMBER)>0;updateT_ORG_CompanyorgsetFNUMBER=replace(FNUMBER,'_','-'),FLONGNUMBER=replace(FLONGNUMBER,'_','-')WHEREexists(SELECT1FROMT_ORG_Company_BAK0806bakwherebak.fid=org.fid);SELECT*INTOT_ORG_CostCenter_BAK0806fromT_ORG_CostCenterwherecharindex('_',FNUMBER)>0;updateT_ORG_CostCenterorgsetFNUMBER=replace(FNUMBER,'_','-'),FLONGNUMBER=replace(FLONGNUMBER,'_','-')WHEREexists(SELECT1FROMT_ORG_CostCenter_BAK0806bakwherebak.fid=org.fid);SELECT*INTOT_ORG_HRO_BAK0806fromT_ORG_HROwherecharindex('_',FNUMBER)>0;updateT_ORG_HROorgsetFNUMBER=replace(FNUMBER,'_','-'),FLONGNUMBER=replace(FLONGNUMBER,'_','-')WHEREexists(SELECT1FROMT_ORG_HRO_BAK0806bakwherebak.fid=org.fid);SELECT*INTOT_ORG_MarketOrgUnit_BAK0806fromT_ORG_MarketOrgUnitwherecharindex('_',FNUMBER)>0;updateT_ORG_MarketOrgUnitorgsetFNUMBER=replace(FNUMBER,'_','-'),FLONGNUMBER=replace(FLONGNUMBER,'_','-')WHEREexists(SELECT1FROMT_ORG_MarketOrgUnit_BAK0806bakwherebak.fid=org.fid);SELECT*INTOT_ORG_ProfitCenter_BAK0806fromT_ORG_ProfitCenterwherecharindex('_',FNUMBER)>0;updateT_ORG_ProfitCenterorgsetFNUMBER=replace(FNUMBER,'_','-'),FLONGNUMBER=replace(FLONGNUMBER,'_','-')WHEREexists(SELECT1FROMT_ORG_ProfitCenter_BAK0806bakwherebak.fid=org.fid);1/3④内部公开请勿外传SELECT*INTOT_ORG_Purchase_BAK0806fromT_ORG_Purchasewherecharindex('_',FNUMBER)>0;updateT_ORG_PurchaseorgsetFNUMBER=replace(FNUMBER,'_','-'),FLONGNUMBER=replace(FLONGNUMBER,'_','-')WHEREexists(SELECT1FROMT_ORG_Purchase_BAK0806bakwherebak.fid=org.fid);SELECT*INTOT_ORG_Quality_BAK0806fromT_ORG_Qualitywherecharindex('_',FNUMBER)>0;updateT_ORG_QualityorgsetFNUMBER=replace(FNUMBER,'_','-'),FLONGNUMBER=replace(FLONGNUMBER,'_','-')WHEREexists(SELECT1FROMT_ORG_Quality_BAK0806bakwherebak.fid=org.fid);SELECT*INTOT_ORG_Sale_Quality_BAK0806fromT_ORG_Salewherecharindex('_',FNUMBER)>0;updateT_ORG_SaleorgsetFNUMBER=replace(FNUMBER,'_','-'),FLONGNUMBER=replace(FLONGNUMBER,'_','-')WHEREexists(SELECT1FROMT_ORG_Sale_Quality_BAK0806bakwherebak.fid=org.fid);SELECT*INTOT_ORG_ServiceOrgUnit_BAK0806fromT_ORG_ServiceOrgUnitwherecharindex('_',FNUMBER)>0;updateT_ORG_ServiceOrgUnitorgsetFNUMBER=replace(FNUMBER,'_','-'),FLONGNUMBER=replace(FLONGNUMBER,'_','-')WHEREexists(SELECT1FROMT_ORG_ServiceOrgUnit_BAK0806bakwherebak.fid=org.fid);SELECT*INTOT_ORG_ShareCenterOrgUnit_BAK0806fromT_ORG_ShareCenterOrgUnitwherecharindex('_',FNUMBER)>0;updateT_ORG_ShareCenterOrgUnitorgsetFNUMBER=replace(FNUMBER,'_','-'),FLONGNUMBER=replace(FLONGNUMBER,'_','-')WHEREexists(SELECT1FROMT_ORG_ShareCenterOrgUnit_BAK0806bakwherebak.fid=org.fid);SELECT*INTOT_ORG_Storage_BAK0806fromT_ORG_Storagewherecharindex('_',FNUMBER)>0;updateT_ORG_StorageorgsetFNUMBER=replace(FNUMBER,'_','-'),FLONGNUMBER=replace(FLONGNUMBER,'_','-')WHEREexists(SELECT1FROMT_ORG_Storage_BAK0806bakwherebak.fid=org.fid);SELECT*INTOT_ORG_Transport_BAK0806fromT_ORG_Transportwherecharindex('_',FNUMBER)>0;updateT_ORG_TransportorgsetFNUMBER=replace(FNUMBER,'_','-'),FLONGNUMBER=replace(FLONGNUMBER,'_','-')WHEREexists(SELECT1FROMT_ORG_Transport_BAK0806bakwherebak.fid=org.fid);SELECT*INTOT_ORG_UnionGroup_BAK0806fromT_ORG_UnionGroupwherecharindex('_',FNUMBER)>0;updateT_ORG_UnionGrouporgsetFNUMBER=replace(FNUMBER,'_','-'),FLONGNUMBER=replace(FLONGNUMBER,'_','-')WHEREexists(SELECT1FROMT_ORG_UnionGroup_BAK0806bakwherebak.fid=org.fid);--第二步：以下放在查询分析器中，选中>>执行服务端脚本com.kingdee.eas.basedata.org.OrgSpecialTablesRebuildFacadeFactory.getLocalInstance(ctx).rebuildOrg2/3④内部公开请勿外传StructureDisplayName();3/3
