实体类(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);
}
}
}