MD5加密,TFS团队管理器，ADO.NET调用存储过程

实体类(UsersModal)

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Modal
{
   public class UsersModal
    {
        private Guid uid;
        private string uname;
        private string upwd;

        public Guid Uid
        {
            get
            {
                return uid;
            }

            set
            {
                uid = value;
            }
        }

        public string Uname
        {
            get
            {
                return uname;
            }

            set
            {
                uname = value;
            }
        }

        public string Upwd
        {
            get
            {
                return upwd;
            }

            set
            {
                upwd = value;
            }
        }
    }
}

MD5加密(PassWordUtils)

using System;
using System.Collections.Generic;
using System.Linq;
using System.Security.Cryptography;
using System.Text;
using System.Threading.Tasks;

namespace Common
{
   public static class PassWordUtils
    {
        public static string MD5PassWord(string passWord)
        {
            MD5 md5 = new MD5CryptoServiceProvider();
            byte[] bytes = Encoding.Default.GetBytes(passWord);
            return BitConverter.ToString(md5.ComputeHash(bytes)).Replace("-", string.Empty);
        }
    }
}

####### UsersDAL、UsersBLL

using Modal;
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Student.DAL
{
    public class UsersDAL
    {
        DBHeple db = new DBHeple();

        public UsersModal Login(SqlParameter[] paras)
        {
            SqlDataReader sdr = db.ExecuteReader("select * from t_users where uname=@uname and upwd=@upwd", paras);
            if (sdr.HasRows)
            {
                if (sdr.Read())
                {
                    UsersModal um = new UsersModal();
                    um.Uid = Guid.Parse(sdr["uid"].ToString());
                    um.Uname = sdr["uname"].ToString();
                    um.Upwd = sdr["upwd"].ToString();
                    return um;
                }
            }
            sdr.Close();
            return null;
        }

        public void LoginProc(SqlParameter[] paras)
        {
            db.ExecuteDataSet("p_LoginUsers", paras,System.Data.CommandType.StoredProcedure);
        }

        public int AddUsersModal(SqlParameter[] paras)
        {
            return db.ExecuteNonQuery("insert into t_users values(NEWID(),@uname,@upwd)", paras);
        }

        public int AddUsersModalProc(SqlParameter[] paras)
        {
            return db.ExecuteNonQueryProc("p_AddUsers", paras);
        }
    }
}

--------------------------
using Modal;
using Student.DAL;
using System.Data.SqlClient;
using System.Data;
using System;

namespace Student.BLL
{
    public class UsersBLL
    {
        UsersDAL usersDal = new UsersDAL();
        public UsersModal Login(UsersModal usersModal)
        {
            SqlParameter[] paras = new SqlParameter[2];
            paras[0] = new SqlParameter("@uname", usersModal.Uname);
            paras[1] = new SqlParameter("@upwd", usersModal.Upwd);
            return usersDal.Login(paras);
        }

        public UsersModal LoginProc(UsersModal usersModal)
        {
            SqlParameter[] paras = new SqlParameter[5];
            paras[0] = new SqlParameter("@uname", "");
            paras[0].DbType = DbType.String;
            paras[0].Size = 100;
            paras[0].Direction = ParameterDirection.Output;

            paras[1] = new SqlParameter("@upwd", "");
            paras[1].DbType = DbType.String;
            paras[1].Size = 100;
            paras[1].Direction = ParameterDirection.Output;

            paras[2] = new SqlParameter("@uid", "");
            paras[2].DbType = DbType.Guid;
            paras[2].Size = 100;
            paras[2].Direction = ParameterDirection.Output;


            paras[3] = new SqlParameter("@loginuname", SqlDbType.NVarChar);
            paras[3].Value = usersModal.Uname;
            paras[4] = new SqlParameter("@loginupwd", SqlDbType.NVarChar);
            paras[4].Value = usersModal.Upwd;

            usersDal.LoginProc(paras);

            UsersModal um = new UsersModal();
            um.Uname = paras[0].Value.ToString();
            um.Upwd = paras[1].Value.ToString();
            um.Uid = Guid.Parse(paras[2].Value.ToString());

            return um;

        }

        public int AddUsersModal(UsersModal usersModal)
        {
            SqlParameter[] paras = new SqlParameter[2];
            paras[0] = new SqlParameter("@uname", usersModal.Uname);
            paras[1] = new SqlParameter("@upwd", usersModal.Upwd);
            return usersDal.AddUsersModal(paras);
        }

        public int AddUsersModalProc(UsersModal usersModal)
        {
            SqlParameter[] paras = new SqlParameter[2];
            paras[0] = new SqlParameter("@uname", SqlDbType.NVarChar);
            paras[0].Value = usersModal.Uname;
            paras[1] = new SqlParameter("@upwd", SqlDbType.NVarChar);
            paras[1].Value = usersModal.Upwd;
            return usersDal.AddUsersModal(paras);
        }
    }
}

界面(Frm_7)

using Common;
using Modal;
using Student.BLL;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Security.Cryptography;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace Winfrom06
{
    public partial class Frm_7 : Form
    {
        UsersBLL usersBll = new UsersBLL();
         
        public Frm_7()
        {
            InitializeComponent();
        }

        private void btn_Save_Click(object sender, EventArgs e)
        {
            UsersModal um = new UsersModal();
            um.Uname = txt_uname.Text.Trim();
            um.Upwd = PassWordUtils.MD5PassWord(txt_upwd.Text.Trim());
            int index = usersBll.AddUsersModal(um);
            if (index > 0)
            {
                MessageBox.Show("操作成功", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }

        private void btn_Login_Click(object sender, EventArgs e)
        {
            UsersModal um = new UsersModal();
            um.Uname = txt_uname.Text.Trim();
            um.Upwd = PassWordUtils.MD5PassWord(txt_upwd.Text.Trim());
            UsersModal loginUsersModal = usersBll.Login(um);
            MessageBox.Show(loginUsersModal.Uid + "....." + loginUsersModal.Uname + "....." +loginUsersModal.Upwd);
        }

        private void btn_SaveProc_Click(object sender, EventArgs e)
        {
            UsersModal um = new UsersModal();
            um.Uname = txt_uname.Text.Trim();
            um.Upwd = PassWordUtils.MD5PassWord(txt_upwd.Text.Trim());
            int index = usersBll.AddUsersModalProc(um);
            if (index > 0)
            {
                MessageBox.Show("操作成功", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }

        private void btn_LoginProc_Click(object sender, EventArgs e)
        {
            UsersModal um = new UsersModal();
            um.Uname = txt_uname.Text.Trim();
            um.Upwd = PassWordUtils.MD5PassWord(txt_upwd.Text.Trim());
            UsersModal loginUsersModal= usersBll.LoginProc(um);
            MessageBox.Show(loginUsersModal.Uid + "....." + loginUsersModal.Uname + "....." + loginUsersModal.Upwd);
            
        }
    }
}