SystemBLL/BLL.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Configuration;
using System.Security.Cryptography;
using DAL;
using System.Data.SqlClient;

namespace BLL
{
   public  class BLLOperation
    {
        public BLLOperation()
        {

        }
      /// <summary>
      /// 登录方法
      /// </summary>
      /// <param name="strUserName">用户名</param>
      /// <param name="strPassword">密码</param>
      /// <returns></returns>
      public static DataSet Login(string strUserName,string strPassword)
         {
             MD5 md5Hash = MD5.Create();
             string hashPassWord = GetMd5Hash(md5Hash, strPassword);
             string strcmd = "SELECT * from [login] where ([loginname]='" + strUserName + "' AND " + "[loginpass]='" + hashPassWord + "')";
             DALOperation dal = new DALOperation();
             DataSet  ds = dal.ExecuteDataSet(strcmd);      
             return ds;
      }
       /// <summary>
       /// MD5哈希方法
       /// </summary>
       /// <param name="md5Hash">MD5对象</param>
       /// <param name="input">需要被哈希计算的字符串</param>
       /// <returns></returns>
      protected  static string GetMd5Hash(MD5 md5Hash, string input)
      {

          byte[] data = md5Hash.ComputeHash(Encoding.UTF8.GetBytes(input));
          StringBuilder sBuilder = new StringBuilder();
          for (int i = 0; i < data.Length; i++)
          {
              sBuilder.Append(data[i].ToString("x2"));
          }
          return sBuilder.ToString();
      }
    }
    
}