> For the complete documentation index, see [llms.txt](https://kythuat.dtechvn.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kythuat.dtechvn.com/nghiep-vu/x-ly-danh-muc-khong-s-dung.md).

# XỬ LÝ DANH MỤC KHÔNG SỬ DỤNG

## Mô tả bài toán

* Khi triển khai, 1 số danh mục không sử dụng, không tận dụng, cần thực hiện ẩn trên phần mềm

## Nội dung cần ẩn

* Danh mục
* Nhập liệu
* Tìm kiếm
* Báo cáo
* Brow khác&#x20;

## Hướng dẫn thao tác

* Cập nhật ẩn

```sql
--- update danh mục
declare @danhmuc nvarchar(50)='KHACHHANG'
update TableManage set stt=0
where TableName = @danhmuc or alia=@danhmuc
--- update nhập liệu
declare @danhmuc nvarchar(50)='PHANXUONG'
SELECT TABLENAME, STT,VIETNAM, FIELDNAME, SourceName, ValueMember, DisplayMember 
FROM BrowConfig
WHERE TABLENAME='NHAPLIEUCT' AND SourceName = @danhmuc

UPDATE BrowConfig SET STT=0
WHERE TABLENAME='NHAPLIEUCT' AND SourceName = @danhmuc
--- update tìm kiếm
declare @danhmuc nvarchar(50)='PHANXUONG'
SELECT TABLENAME, STT,VIETNAM, FIELDNAME, SourceName, ValueMember, DisplayMember 
FROM BrowConfig
WHERE TABLENAME='DULIEUKETOAN' AND SourceName = @danhmuc

UPDATE BrowConfig SET STT=0
WHERE TABLENAME='DULIEUKETOAN' AND SourceName = @danhmuc
--- update báo cáo
declare @danhmuc nvarchar(50)='PHANXUONG'
declare @danhmucMA nvarchar(50)= @danhmuc+'MA'
declare @danhmucTEN nvarchar(50)= @danhmuc+'TEN'

;with cte_report as 
(
	select T1.report, T1.VIETNAM,T1.identityKey,T2.GIATRI,T2.VIETNAM AS TENCOT,T2.KHONGHIEN,T2.KHONGIN
	FROM
	(
		select report,vietnam, identityKey
		from report 
		WHERE REPORT<1000000 AND DISABLE=0 AND Hethong=0
	)T1
	inner join 
	(
		SELECT report,vietnam,khonghien,khongin,giatri
		FROM ReportColumn
		WHERE REPORT<1000000 
		AND GIATRI LIKE '% as ' + @danhmucMA or GiaTri like '% as '+ @danhmucTEN
	)T2 on t1.report = t2.report
)
--select * from cte_report
UPDATE T1 SET T1.KHONGHIEN=1, T1.KHONGIN=1
FROM ReportColumn T1 INNER JOIN cte_report T2
ON T1.GiaTri = T2.GiaTri
--- update brow khác
```

* Cập nhật hiện lại theo bản chuẩn nếu cần

```sql
--- update danh mục
declare @danhmuc nvarchar(50)='KHACHHANG'
update T1 set T1.STT = T2.STT
--SELECT T1.STT,T1.TABLENAME,T1.ALIA,T2.TABLENAME,T2.ALIA
FROM (SELECT * FROM TableManage WHERE TableName = @danhmuc or alia=@danhmuc)T1
inner join
(
select * from dtechdev20.dbo.TableManage
where TableName = @danhmuc or alia=@danhmuc
)T2 on T1.TableName = T2.TableName AND T1.alia = T2.alia
--- update nhập liệu
declare @danhmuc nvarchar(50)='KHACHHANG'
update T1 set T1.STT = T2.STT
--SELECT T1.TABLENAME, T1.STT,T1.VIETNAM, T1.FIELDNAME, T1.SourceName, T1.ValueMember, T1.DisplayMember 
FROM (SELECT * FROM BrowConfig WHERE TABLENAME='NHAPLIEUCT' AND SourceName = @danhmuc)T1
inner join
(
select * from dtechdev20.dbo.BrowConfig
where TABLENAME='NHAPLIEUCT' AND SourceName = @danhmuc
)T2 
on T1.TableName = T2.TableName 
AND T1.FIELDNAME = T2.FIELDNAME
AND T1.SourceName = T2.SourceName
AND T1.ValueMember = T2.ValueMember
AND T1.DisplayMember = T2.DisplayMember
--- update tìm kiếm
declare @danhmuc nvarchar(50)='KHACHHANG'
update T1 set T1.STT = T2.STT
--SELECT T1.TABLENAME, T1.STT,T1.VIETNAM, T1.FIELDNAME, T1.SourceName, T1.ValueMember, T1.DisplayMember 
FROM (SELECT * FROM BrowConfig WHERE TABLENAME='DULIEUKETOAN' AND SourceName = @danhmuc)T1
inner join
(
select * from dtechdev20.dbo.BrowConfig
where TABLENAME='DULIEUKETOAN' AND SourceName = @danhmuc
)T2 
on T1.TableName = T2.TableName 
AND T1.FIELDNAME = T2.FIELDNAME
AND T1.SourceName = T2.SourceName
AND T1.ValueMember = T2.ValueMember
AND T1.DisplayMember = T2.DisplayMember
--- update báo cáo
declare @danhmuc nvarchar(50)='PHANXUONG'
declare @danhmucMA nvarchar(50)= @danhmuc+'MA'
declare @danhmucTEN nvarchar(50)= @danhmuc+'TEN'

;with cte_report as 
(
	select T1.report, T1.VIETNAM,T1.identityKey,T2.GIATRI,T2.VIETNAM AS TENCOT,T2.KHONGHIEN,T2.KHONGIN
	FROM
	(
		select report,vietnam, identityKey
		from report 
		WHERE REPORT<1000000 AND DISABLE=0 AND Hethong=0
	)T1
	inner join 
	(
		SELECT report,vietnam,khonghien,khongin,giatri
		FROM ReportColumn
		WHERE REPORT<1000000 
		AND GIATRI LIKE '% as ' + @danhmucMA or GiaTri like '% as '+ @danhmucTEN
	)T2 on t1.report = t2.report
)
--select * from cte_report
UPDATE T1 SET T1.KHONGHIEN=0, T1.KHONGIN=0
FROM ReportColumn T1 INNER JOIN cte_report T2
ON T1.GiaTri = T2.GiaTri
--- update brow khác
```
