基于ajax的三层，实现数据库的增删改查（三 BLL层编写）

由于前面我在DAL层对数据进行了处理，所以在此层就不用写太多复杂代码，直接调用DAL传入参数就可以，代码如下

//查询单条
        public int selectOne(string userid,string userpass)
        {
            DalT1 D = new DalT1();
            object res= D.select(userid,userpass);
            if (res == null)
            {
                return 0;
            }
            else {
                return 1;
            }
        }
    
        //查询所有
        public List<userMes> showTable()
        {
            DalT1 d1 = new DalT1();
            List<userMes> li = new List<userMes>();
            li= d1.selectAll();
            return li;
        }
   
        //删除单条
       public int deleteOneB(int id)
       {
           DalT1 d1 = new DalT1();
           int res= d1.deleteOne(id);
           return res;
       }
 
       //添加单条
       public int addone(string username, string userpass)
       {
           DalT1 d = new DalT1();
           int res= d.addone(username, userpass);
           return res;
       }
        
       //修改单条
       public int changeOne(userMes u,int id)
       {
            DalT1 d=new DalT1();
            int res = d.changeOnew(u,id);
            return res;
       }

       //查询页数
       public int selectCount(int num)
       {
           DalT1 d = new DalT1();
           int res= d.selectCount();
           double resP =Math.Ceiling(Convert.ToDouble( res / num));
           int resPP = Convert.ToInt32(resP);
           return resPP;
       }
       
       //查询页数内的数据
       public List<userMes> selectMes(int pageCount, int pageSize)
       {
           DalT1 d = new DalT1();
           List<userMes> sqr = d.selectMes(pageCount, pageSize);
           return sqr;
       }