K3账套用户名:
alter proc sp_k3users
@f1 varchar(20),
@v1 varchar(20),
@f2 varchar(20),
@v2 varchar(20),
@t varchar(20)
with encryption
as
begin
declare @s varchar(2000)
select @s='select distinct * from v_k3users where 1=1'
if isnull(@v1,'')='' and isnull(@v2,'')='' and isnull(@t,'')=''
select @s=@s+' and 时间戳 in(select max(时间戳) from v_k3users)'
if isnull(@v1,'')<>''
select @s=@s+' and '+@f1+' like '''+@v1+''''
if isnull(@v2,'')<>''
select @s=@s+' and '+@f2+' like ''%'+@v2+'%'''
if isnull(@t,'')<>''
select @s=@s+' and 时间戳='''+@t+''''
select @s=@s+' order by 公司名称,用户名'
--print @s
exec(@s)
end
exec sp_k3users '','','公司性质','有限公司',''
K3物流报表:
alter proc sp_k3wl
@f1 varchar(20),
@v1 varchar(20),
@f2 varchar(20),
@v2 varchar(20),
@t varchar(20)
with encryption
as
begin
declare @s varchar(2000)
select @s='select distinct * from v_k3wl where 1=1'
if isnull(@v1,'')='' and isnull(@v2,'')='' and isnull(@t,'')=''
select @s=@s+' and 时间戳 in(select max(时间戳) from v_k3wl)'
if isnull(@v1,'')<>''
select @s=@s+' and '+@f1+' like '''+@v1+''''
if isnull(@v2,'')<>''
select @s=@s+' and '+@f2+' like ''%'+@v2+'%'''
if isnull(@t,'')<>''
select @s=@s+' and 时间戳='''+@t+''''
select @s=@s+' order by 公司名称'
--print @s
exec(@s)
end
exec sp_k3wl '公司性质','有限公司','公司名称','包头斯巴鲁',''