DAL/AdminDAL.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Model;
using System.Data.SqlClient;
using System.Configuration;

namespace DAL
{
    public class AdminDAL
    {
        public Admin QueryOneRecord(string adminID)
        {
            Admin admin = null;
            // 1. 创建连接
            SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["XDF"].ConnectionString);

            // 2. 打开连接
            connection.Open();

            // 2.1 创建命令对象
            SqlCommand command = new SqlCommand("SELECT * FROM Admin WHERE AdminID=@AdminID", connection);
            command.Parameters.AddWithValue("@AdminID", adminID);

            // 2.2 执行命令对象
            SqlDataReader dataReader = command.ExecuteReader();
            if (dataReader.Read())
            {
                admin = new Admin();
                admin.AdminID = adminID;
                admin.AdminName = dataReader["AdminName"].ToString();
                admin.Password = dataReader["Password"].ToString();
                admin.Sex = dataReader["Sex"].ToString();
                admin.BaseID = dataReader["Phone"].ToString();
                admin.BaseID = dataReader["BaseID"].ToString();
            }
            dataReader.Close();

            // 3. 关闭连接
            connection.Close();

            return admin;
        }
        public bool ModifyPassword(Admin admin)
        {

            // 1. 创建连接
            SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["XDF"].ConnectionString);

            // 2. 打开连接
            connection.Open();

            // 2.1 创建命令对象
            SqlCommand command = new SqlCommand("UPDATE Admin SET Password=@Password WHERE AdminID=@AdminID", connection);
            command.Parameters.AddWithValue("@AdminID", admin.AdminID);
            command.Parameters.AddWithValue("@Password", admin.Password);