CMS修改主菜单类别编码CategoryNo
SQL 全选
select top 10 * from [dbo].[data_ArchiveCategory] where CategoryNo='XXERP';
select top 10 * from [dbo].[data_ArchiveCategoryGroup] where CategoryNo='XXERP';
select top 10 * from [dbo].[data_Articles] where Category='XXERP';
select top 10 * from [dbo].[data_ArticlesAttrSort] where Category='XXERP';
update data_ArchiveCategory set CategoryNo='LinERP' where CategoryNo='XXERP';
update data_ArchiveCategoryGroup set CategoryNo='LinERP' where CategoryNo='XXERP';
update data_Articles set Category='LinERP' where Category='XXERP';
update data_ArticlesAttrSort set Category='LinERP' where Category='XXERP';
select top 10 * from [dbo].[data_ArchiveCategory] where CategoryNo='LinERP';
select top 10 * from [dbo].[data_ArchiveCategoryGroup] where CategoryNo='LinERP';
select top 10 * from [dbo].[data_Articles] where Category='LinERP';
select top 10 * from [dbo].[data_ArticlesAttrSort] where Category='LinERP';执行脚本后
1、系统管理 -》站点管理 -》刷新缓存、重新生成索引
2、在Linerp大类 -》重新生成所有档案、重新创建索引
版权声明：本文为开发框架文库发布内容,转载请附上原文出处连接
NewDoc C/S框架网
