/*********************************
查看未銷/未領/未報損/的機子所有信息
*************************************/
declare @act int --1為按類型2按串號3所有
declare @val char(5)--型號
set @act=1
set @val='XH007'
--set @val='234234'
if @act=1 
begin
SELECT *
FROM vAllSj a
where a.fid not in (select fcode from thxc) and a.fid not in (select fhrxx from tgtlh) and a.fid not in(select fhrxx from tbs) and a.fsjxhid=@val
end

if @act=2 
begin
SELECT *
FROM vAllSj a
where a.fid not in (select fcode from thxc) and a.fid not in (select fhrxx from tgtlh) and a.fid not in(select fhrxx from tbs) and ltrim(rtrim(a.fno))=ltrim(rtrim(@val))
end

if @act=3
begin
SELECT *
FROM vAllSj a
where a.fid not in (select fcode from thxc) and a.fid not in (select fhrxx from tgtlh) and a.fid not in(select fhrxx from tbs) 

end