vs登录管理账户

本文介绍了在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();
        }
    }
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值