BLL调用sqlhelper

最新推荐文章于 2024-05-25 18:00:05 发布

原创最新推荐文章于 2024-05-25 18:00:05 发布 · 557 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#books #string #login #object #query #class

asp.net 专栏收录该内容

59 篇文章

订阅专栏

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;

}
}
}