查看K3Wise的登录密码（k3默认登录密码）

declare @acc nvarchar(50)

select @acc= 'XXX'

declare @userid int

select @userid = FUserID

from hrms_users where Account = @acc

declare @i int

declare @jmpass varchar(255),@pass varchar(50)

declare @x int,@y int,@n int

select @pass=''

select @jmpass=fsid from t_user where fuserid=@userid

select @i=len(@jmpass)

if @i>50

begin

select @jmpass=substring(@jmpass,51,@i-50)

select @i=1

while @i<len(@jmpass)

begin

select @x=ascii(substring(@jmpass,@i,1)),@y=ascii(substring(@jmpass,@i+1,1)),@n=(@i-1)%8/3

print @n

if @n=0

select @pass=@pass+char((@y-32)/power(4,@n)+case when @x=32 then 0 else 64 end)

else if @n=1

select @pass=@pass+char((@y-32)/power(4,@n)+32+16*(@x-34))

else

select @pass=@pass+char((@y-32)/power(4,@n)+32+4*(@x-40))

select @i=@i+case when @n=2 then 2 else 3 end

end

end

select @pass