DAL/AdminDAL.cs

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

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

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

namespace DAL
{
    public class AdminDAL
    {
        #region //查找该用户是否存在
        public Admin adminCheck(string adminId)
        {
            string strSql = "select * from admin where adminId ='"+ adminId +"'";
            SqlConnection conn = DBHelper.CreatConn();
            DataTable dt = DBHelper.GetTable(strSql);
            Admin model = new Admin();
            if (dt.Rows.Count > 0)
            {
                model.Password = dt.Rows[0]["Password"].ToString();
                return model;
            }
            return null;
        }
        #endregion
        #region //用户登录
        public Admin adminLogin(string adminId)
        {
            string strSql = "select password,adminIdenti from admin where adminId='" + adminId + "'";
            SqlConnection conn = DBHelper.CreatConn();
            DataTable dt = DBHelper.GetTable(strSql);
            Admin model = new Admin();
            if (dt.Rows.Count > 0)
            {
                model.Password = dt.Rows[0]["password"].ToString();
                model.AdminIdenti = dt.Rows[0]["adminIdenti"].ToString();
                return model;
            }
            return null;
        }
        #endregion
        #region//获取所有用户信息
        public DataTable getAdmin() {
            string strStuSql = "select * from admin";
            try
            {
                SqlConnection conn = DBHelper.CreatConn();
                if (DBHelper.GetTable(strStuSql) != null)
                {
                    return DBHelper.GetTable(strStuSql);
                }
                else
                    return null;
            }
            catch (Exception e)
            {
                throw e;
            }