default.aspx.cs

这是asp.net^和Visual C++Sharp编写的串并口通讯的书籍 源代码

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using System.Security.Cryptography;
using System.Text;
using System.Data.SqlClient;
using System.IO;
public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {


    }
    //检测用户名是否存在
    public void  CheckUser()
    {

           SqlConnection sqlconn = new SqlConnection("server=(local);uid=sa;pwd=;database=db_08");
            string sqlstr = "select * from tb_03 where Name='" + this.txtLoginName.Text + "'";
            sqlconn.Open();
            SqlCommand sqlcom = new SqlCommand(sqlstr, sqlconn);
            SqlDataReader dr = sqlcom.ExecuteReader();
                if (dr.Read())
                {
                    if (dr[2].ToString() == "男")
                    {
                        ddlSex.SelectedIndex = 0;
                    }
                    if (dr[2].ToString() == "女")
                    {
                        ddlSex.SelectedIndex = 1;
                    }
                    txtPwd.Text = Decrypting(dr[3].ToString());//调解密方法解密
                    txtQuePwd.Text = dr[4].ToString();
                    txtAnsPwd.Text = Decrypting(dr[5].ToString());//调解密方法解密
                    txtEmail.Text = Decrypting(dr[6].ToString());//调解密方法解密

                }
                else
                {

                    Response.Write("<script>alert('没有找到任何记录！');</script>");
                }
            dr.Close();
            sqlconn.Close();
          

    }
  
   //解密字符串
    public string Decrypting(string Source)
    {
        try
        {

            //将解密字符串转换成字节数组
            byte[] bytIn = System.Convert.FromBase64String(Source);
            //建立加密对象的密钥和偏移量对TripleDES，采取24字节或192位的密钥和初始向量
            byte[] key ={ 53, 68, 57, 79, 159, 168, 157, 179, 201, 40, 0, 123, 210, 189, 167, 1 };
            byte[] IV ={ 5, 13, 46, 97, 69, 109, 177, 39 };
            //实例  TripleDESCryptoServiceProvider类将字符串写入流中
            RC2CryptoServiceProvider rc2 = new RC2CryptoServiceProvider();
            rc2.IV = IV;
            rc2.Key = key;
            //解密流
            System.IO.MemoryStream ms = new System.IO.MemoryStream(bytIn, 0, bytIn.Length);
            ICryptoTransform encrypto = rc2.CreateDecryptor();//实义解密转换
            CryptoStream cs = new CryptoStream(ms, encrypto, CryptoStreamMode.Read);
            StreamReader strd = new StreamReader(cs, Encoding.Default);
            return strd.ReadToEnd();
        }
        catch (Exception ex)
        {
            throw new Exception("在文件解密的时候出现错误！错误提示： \n" + ex.Message);
        }
    }


    protected void Button2_Click(object sender, EventArgs e)
    {
        CheckUser();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        Response.Write("<script>window.close();</script>");
    }

}