logindb.cs

利用vs2008+sql开发的酒店管理系统

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using HotelManageDAL;
using HotelManageMDL;

namespace HotelManageDBL
{
    public class LoginDB
    {
        //创建HotelManageDA类
        HotelManageDA hda = new HotelManageDA();
        //创建实体对象
        Login login = new Login();
        //创建数据集
        DataSet ds = new DataSet();
        /// <summary>
        /// 查找的方法
        /// </summary>
        /// <param name="userName"></param>
        /// <param name="password"></param>
        /// <returns></returns>
        public bool SelectLogin(string userName,string password)
        {
            string selSql = "select * from login";
            try
            {
                //调用查找方法，并接收到数据集中
                ds = hda.Select(selSql);
            }
            catch { throw; }
            //创建视图对象
            DataView dv = new DataView(ds.Tables[0]);
            //用视图过滤
            dv.RowFilter = "UserName='" + userName + "' and Password='" + password + "'";

            if (dv.Count == 0)
            {
                return false;
            }
            else
            {
                return true;
            }
           
        }
    }
}