DAL/DALadmin.cs

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

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

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

namespace DAL
{
   public class DALadmin
    {
       

        /*验证管理员登陆*/
        public string _login(CAdmin admin)
        {
            SqlConnection con = SQLHelper.Connect();
            string Aname = DESEncrypt.Encrypt(admin.APws);
            string sql = "select Adminname from tb_admin where AdminID =@ID and Password=@psw";
            SqlCommand cmd = new SqlCommand(sql, con);
            cmd.Parameters.Add(new SqlParameter("@ID", admin.ID)); 
            cmd.Parameters.Add(new SqlParameter("@psw",Aname));
            con.Open();
            Aname = (string)cmd.ExecuteScalar();
            con.Close(); 
            return Aname;
        }

       /*绑定数据*/
        public DataSet adminBind()
        {
            SqlConnection con = SQLHelper.Connect();
            con.Open();
            SqlCommand cmd = new SqlCommand("select * from tb_Admin",con);
            SqlDataAdapter adp = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            adp.Fill(ds); 
            con.Close();
            return ds; 
        }


       /*按用户名查询*/
        public DataSet adminSearchID(string yhm)
        {
            SqlConnection con = SQLHelper.Connect();
            con.Open();
            SqlCommand cmd = new SqlCommand("select * from tb_Admin where AdminId = @ID", con);
            cmd.Parameters.Add(new SqlParameter("@ID", yhm));
            SqlDataAdapter adp = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            adp.Fill(ds); 
            con.Close();
            return ds;
        }


        /*按姓名查询*/
        public DataSet adminSearchNM(string name)