Backup/DAL/UserInfoDAO.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using Model;

namespace DAL
{
    public class UserInfoDAO
    {
       
        SQLHelper sqlhelper = new SQLHelper();
        private DataSet ds;

        //判断用户名密码是否正确
        public int userIsRight(UserInfoBean u)
        {
            int count = 0;
            count = sqlhelper.ReturnSQL("select count(*) from userinfo where userid='"+u.userid+"' and userpwd='"+u.userPwd+"'");
            return count;
        }
        //查询用户ID
        public int getIdByUserid(string userid)
        {
            int count = sqlhelper.ReturnSQL("select id from userinfo where userid='"+userid+"'");
            return count;
        }
        //查询用户角色
        public int getRoleTypeInfo(string userID)
        {
            int count = 0;
            count = sqlhelper.ReturnSQL("select roleid from userinfo where userid='"+userID+"'");
            return count;
        }
        //判断用户状态
        public int userStates(string userID)
        {
            int count = 0;
            count = sqlhelper.ReturnSQL("select userstate from userinfo where userid='"+userID+"'");
            return count;
        }

        //得到总记录数
        public int GetUserInfoCount()
        {
            try
            {
                int count = sqlhelper.ReturnSQL("select count(*) from userinfo");
                return count;
            }
            catch (Exception)
            {
                
                throw;
            }
        }
        //查询用户信息
        public DataSet GetUserInfo(int start,int limit)
        {
            try