BLL調用sqlhelper

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using DAL;
using Model;
using System.Data.SqlClient;
using System.Data;
namespace BLL
{
    public class UsersOperation
    {
        public bool login(string UName,string UPwd)
        {
            SqlParameter[] pars = new SqlParameter[]
        {
        new SqlParameter("UName",UName),
        new SqlParameter("UPwd",UPwd)
        };
            object o=sqlHelper.ExcuteScalar("usp_login", CommandType.StoredProcedure, pars);
            if (o == null)
                return false;
            else
                return true;
        }

        public List<Books> BookQuery(string UName)
        {
            List<Books> book = new List<Books>();
            SqlParameter[] pars = new SqlParameter[]
        {
       
        new SqlParameter("UName",UName)
        };
            SqlDataReader dr = sqlHelper.ExCuteReader("usp_query", CommandType.StoredProcedure,pars);
            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    Books bk = new Books();
                    bk.BName = dr[0].ToString();
                    bk.BAuthor = dr[1].ToString();
                    book.Add(bk);
                }
             
            }
            dr.Close();
                return book;
        

        }
    }
}