隐藏门店中药的进销存

wbv123

select * from u_ware_q a, u_ware_class b where
a.wareid=b.wareid and b.parentcode=’55’ and classcode=’06’

–屏蔽商品资料

create table #disable_u_ware_q(id int)
update a set wareid =’A’+a.wareid,status=2 from u_ware_q a, u_ware_class b where
a.wareid=b.wareid and b.parentcode=’55’ and classcode=’06’ and a.wareid not like ‘A%’
drop table #disable_u_ware_q
以上是隐藏门店中药的进销存。
create table #disable_u_ware(id int)
update a set wareid =’A’+a.wareid,status=2 from u_ware a, u_ware_class b where
a.wareid=b.wareid and b.parentcode=’55’ and classcode=’06’ and a.wareid not like ‘A%’
drop table #disable_u_ware

55是分类组 06是类别

–取消隐藏数据
select wareid,REPLACE(wareid,’A’,”),* from u_ware_q where wareid like ‘A%’

create table #disable_u_ware_q(id int)
update u_ware_q set wareid=REPLACE(wareid,’A’,”), status=1 where wareid like ‘A%’
drop table #disable_u_ware_q

create table #disable_u_ware(id int)
update u_ware set wareid=REPLACE(wareid,’A’,”), status=1 where wareid like ‘A%’
drop table #disable_u_ware