110,566
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.SqlTypes;
namespace yifeiapp1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void label1_Click(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("server=" + textBox1.Text + ";database=DSCSYS ;Uid = " + textBox2.Text + "; Pwd = " + textBox3.Text + "");
string sqlstr = "CREATE FUNCTION [dbo].[DecodePwd]" +
"(@user nvarchar(32),@userPwd nvarchar(128))" +
"RETURNS nvarchar(128) " +
"AS " +
"BEGIN " +
"DECLARE @Return NVARCHAR(128) " +
"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 ='(&.&!%&$\"&)\" \",&)$(%#$-$#$$\" "+
"SET @FF1 = !\"#$%&()*+,-./ " +
"DECLARE @n int, @d int " +
"DECLARE @Result nvarchar(128) " +
"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 " +
"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" ;
SqlCommand cmd = new SqlCommand(sqlstr,con);
cmd.Connection = con;
cmd.CommandText = sqlstr;
cmd.CommandType = CommandType.Text;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
private void button2_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("server=" + textBox1.Text + ";database=DSCSYS ;Uid = " + textBox2.Text + "; Pwd = " + textBox3.Text + "");
SqlDataAdapter da = new SqlDataAdapter("SELECT MA001 as 用户名, dbo.DecodePwd(MA001,MA003) as 密码 from DSCMA", con);
DataSet ds = new DataSet();
da.Fill(ds);
DataTable dtb = ds.Tables[0];
dataGridView1.DataSource = dtb;
con.Close();
}
private void Form1_Load(object sender, EventArgs e)
{
}
}
}
IF OBJECT_ID('dbo.DecodePwd') IS NOT NULL
DROP FUNCTION dbo.DecodePwd