[易飞]密码加密解密函数

最新推荐文章于 2019-08-14 09:01:57 发布

厦门德仔

最新推荐文章于 2019-08-14 09:01:57 发布

阅读量3.4k

点赞数 2

分类专栏： ERP-易飞文章标签：解密加密 n2 user function sql

ERP-易飞专栏收录该内容

185 篇文章 20 订阅 ¥99.90 ¥299.90

订阅专栏

超级会员免费看

本文介绍了易飞系统中用于密码加密和解密的函数，详细阐述了加密和解密过程，对于理解和保障用户数据安全性具有重要意义。

摘要由CSDN通过智能技术生成

加密函数：

CREATE FUNCTION EncodePwd
( 
@user nvarchar(32), 
@userPwd nvarchar(32)
)
RETURNS nvarchar(128)
AS
BEGIN
DECLARE @fnil nvarchar(128),@FF1 NVARCHAR(128)
SET @fnil = '''(&.&!''%&{1}quot;''&)" ",&)$(%#$-$#$" '
SET @FF1 = ' !"#$%&''()*+,-./'
DECLARE @n int, @i int, @d int
DECLARE @Result nvarchar(100)
SET @i = LEN(@user)
SET @Result = SUBSTRING(@fnil,(@i-1)*2+1, 30-(@i-1)*2)
SET @n = @i-1
WHILE(@n>=0)
BEGIN SET @i = (ASCII(SUBSTRING(@user,@n+1,1)) - 32) % 16 
SET @d = (ASCII(SUBSTRING(@user,@n+1,1)) - 32) / 16 + 1 
SET @Result = @Result + CHAR(32 + @d + 1) + SUBSTRING(@FF1,@i+1,1) 
SET @n = @n-1
END
DECLARE @n1 int , @n2 int
DECLARE @FStr1 NCHAR(1), @FStr2 NCHAR(1), @FStr3 NCHAR(1), @Fchar1 NCHAR(1)
SET @i =1
WHILE(@i<=LEN(@userPwd))
BEGIN IF(@i<=4) 
BEGIN 
SET @FStr1 = SUBSTRING(@userPwd,@i,1) 
SET @FStr2 = SUBSTRING(@Result,@i,1) 
SET @FStr3 = SUBSTRING(@Result,28+@i,1) 
SET @n1 = ((ASCII(SUBSTRING(@userPwd,@i,1)) - 32) % 8) 
SET @n2 = ((ASCII(SUBSTRING(@userPwd,@i,1)) - 32) / 16) 
SET @Fchar1 = CHAR(@n2 * 16 + 32) 
SET @n2 = ASCII(@FStr2) ^ ASCII(@FStr1) 
SET @n2 = (@n2 & 0x0F) + 0x20 
SET @FStr2 =CHAR(@n2) 
SET @FStr3 = CHAR(ASCII(@Fchar1) + ((ASCII(@FStr3) + ASCII(@Fchar1)) % 16)) 
SET @Result = SUBSTRING(@Result,1, @i-1) + @FStr2 + Substring(@Result,@i + 1, 31 - @i+1) 
SET @Result = Substring(@Result,1, 28 + @i-1) + @FStr3 + Substring(@Result,29 + @i, 3 - @i+1) 
END 
ELSE 
BEGIN 
SET @FStr1 = SUBSTRING(@userPwd,@i,1) 
SET @FStr2 = SUBSTRING(@Result,@i,1) 
SET @FStr3 = SUBSTRING(@Result,@i-4,1) 
SET @n1 = ((ASCII(SUBSTRING(@userPwd,@i,1)) - 32) % 16) 
SET @n2 = ((ASCII(SUBSTRING(@userPwd,@i,1)) - 32) / 16) 
SET @Fchar1 = CHAR(@n2 * 16 + 32) 
SET @n2 = ASCII(@FStr2) ^ ASCII(@FStr1) 
SET @n2 = (@n2 & 0x0F) + 0x20 
SET @FStr2 =CHAR(@n2) 
SET @FStr3 = CHAR(ASCII(@Fchar1) + ((ASCII(@FStr3) + ASCII(@Fchar1)) % 16)) 
SET @Result = SUBSTRING(@Result,1, @i-1) + @FStr2 + Substring(@Result,@i + 1, 31 - @i+1) 
SET @Result = Substring(@Result,1, @i-4-1) + @FStr3 + Substring(@Result,@i-3, 35 - @i+1) 
END 
SET @i = @i+1 END
RETURN @Result
END
GO

解密函数：

ALTER FUNCTION [dbo].[DecodePwd]
( 
	@user nvarchar(32), 
	@userPwd nvarchar(128)
)
RETURNS nvarchar(128)
AS
BEGIN
DECLARE @Return NVARCHAR(100)
SET @Return =''DECLARE @KeyLen INT,@i INT,@n1 INT,@n2 INT
DECLARE @FStr1 CHAR(1),@FStr2 CHAR(1),@FStr3 CHAR(1),@FStr4 CHAR(1)DECLARE @fnil nvarchar(128),@FF1 NVARCHAR(128)
SET @fnil = '''(&.&!''%&{1}quot;''&)" ",&)$(%#$-$#$" 'SET @FF1 = ' !"#$%&''()*+,-./'DECLARE @n int, @d int
DECLARE @Result nvarchar(100)
SET @i = LEN(@user)
SET @Result = SUBSTRING(@fnil,(@i-1)*2+1, 30-(@i-1)*2)
SET @n = @i-1WHILE(@n>=0)
BEGIN 
SET @i = (ASCII(SUBSTRING(@user,@n+1,1)) - 32) % 16 
SET @d = (ASCII(SUBSTRING(@user,@n+1,1)) - 32) / 16 + 1 
SET @Result = @Result + CHAR(32 + @d + 1) + SUBSTRING(@FF1,@i+1,1) 
SET @n = @n-1
END
SET @KeyLen =0
SET @i =28
WHILE(@i>=1)
BEGIN 
IF(SUBSTRING(@userPwd,@i,1)<>SUBSTRING(@Result,@i,1)) 
BEGIN 
SET @KeyLen = @i BREAK; 
END 
SET @i = @i-1
END
IF(@KeyLen =0) RETURN ''
SET @i = @KeyLen
WHILE(@i>=1)
BEGIN IF(@i<=4) 
BEGIN 
SET @FStr1 = SUBSTRING(@Result,@i,1) 
SET @FStr3 = SUBSTRING(@userPwd,@i,1) 
SET @FStr4 = SUBSTRING(@userPwd,32-4+@i,1) 
SET @n1 = ASCII(@FStr1) ^ ASCII(@FStr3) 
SET @n2 = ((ASCII(@FStr4)-32) / 16) 
SET @Return = CHAR((16*@n2)+32+@n1) + @Return 
SET @FStr4 = CHAR((ASCII(@FStr4) % 16)+32) 
SET @userPwd = SUBSTRING(@userPwd,1,32-4+@i-1)+@FStr4+SUBSTRING(@userPwd,32-4+@i+1,4-@i) 
END 
ELSE 
BEGIN 
SET @FStr1 = SUBSTRING(@Result,@i,1) 
SET @FStr3 = SUBSTRING(@userPwd,@i,1) 
SET @FStr4 = SUBSTRING(@userPwd,@i-4,1) 
SET @n1 = ASCII(@FStr1) ^ ASCII(@FStr3) 
SET @n2 = ((ASCII(@FStr4)-32) / 16) 
SET @Return = CHAR((16*@n2)+32+@n1) + @Return 
SET @FStr4 = CHAR((ASCII(@FStr4) % 16)+32) 
SET @userPwd = SUBSTRING(@userPwd,1,@i-4-1)+@FStr4+SUBSTRING(@userPwd,@i-4+1,32-@i+4)
 END SET @i = @i-1
END
RETURN @Return 
END