三层架构查询

三层架构查询

 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);