vs登录管理账户

最新推荐文章于 2023-01-31 14:58:18 发布

sir_hanhanhan

最新推荐文章于 2023-01-31 14:58:18 发布

阅读量836

点赞数

本文链接：https://blog.csdn.net/sir_hanhanhan/article/details/109043773

版权

本文介绍了在Visual Studio中进行登录账户管理的相关知识，包括在DAL层编写查询，在BLL层进行引用，以及UI层的实现。

摘要由CSDN通过智能技术生成

今天复习了vs-中登陆管理账户
DAL层写查询

 public class ReaderDAL
    {
            public static DataTable getall(string name, string phone)
            {
                string sql = "select * from Reader where 1=1";
                if (name != "")
                {
                    sql += " and rdName like'%" + name + "%'";
                }
                if (phone != "")
                {
                    sql += " and rdPhone like'%" + phone + "%'";
                }
                DataTable dt = DB.select(sql);
                return dt;
            }
        }
    }

public class UserInfoDAL
    {
        public static UserInfo Select(string name, string pwd)
        {
            var sql = $"select * from UserInfo where name='{name}' and pwd='{pwd}'";
            var table = DB.select(sql);
            if (table == null || table.Rows.Count < 1)
            {
                return null;
            }
            var row = table.Rows[0];
            UserInfo user = new UserInfo()
            {
                Id = Convert.ToInt32(row["Id"]),
                Name = Convert.ToString(row["Name"]),
                Role = Convert.ToInt32(row["Role"])
            };
            return user;
        }
        public static int add(UserInfo userInfo)
        {
            var sql = $"insert into userinfo values('{userInfo.Name}','{userInfo.Pwd}',{userInfo.Role})";
            int num = DB.zsg(sql);
            return num;
        }
    }

public class UserInfoDAL
    {
        public static UserInfo Select(string name, string pwd)
        {
            var sql = $"select * from UserInfo where name='{name}' and pwd='{pwd}'";
            var table = DB.select(sql);
            if (table == null || table.Rows.Count < 1)
            {
                return null;
            }
            var row = table.Rows[0];
            UserInfo user = new UserInfo()
            {
                Id = Convert.ToInt32(row["Id"]),
                Name = Convert.ToString(row["Name"]),
                Role = Convert.ToInt32(row["Role"])
            };
            return user;
        }
        public static int add(UserInfo userInfo)
        {
            var sql = $"insert into userinfo values('{userInfo.Name}','{userInfo.Pwd}',{userInfo.Role})";
            int num = DB.zsg(sql);
            return num;
        }
    }

在BLL中引用，以及UI层

 public partial class list : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                bind();
            }
        }
        protected void bind()
        {
            string name = txt_name.Text;
            string phone = txt_phone.Text;
            DataTable dt = ReaderBLL.getall(name,phone);
            this.GridView1.DataSource = dt;
            this.GridView1.DataBind();
        }
         protected void btn_selcet_Click(object sender, EventArgs e)
        {
            string name = txt_name.Text;
            string phone = txt_phone.Text;
            DataTable dt = ReaderBLL.getall(name, phone);
            this.GridView1.DataSource = dt;
            this.GridView1.DataBind();
        }
    }