Business/UserBusiness.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using DBAccess;
using Entity;
using System.Data;

namespace Business
{
    public class UserBusiness
    {
        public int CheckUsernameExistByUsername(string username)//检查用户名是否存在
        {
            string[] names = { "@username" };
            object[] values = { username };
            object obj = OLEDB.GetSinglevalue(" select count(uid) from tb_user where username=@username  ", names, values);
            return Convert.ToInt32(obj);
        }

        public int CheckRoletypeByUsername(string username, int roletype)//检查用户类型是否匹配
        {
            string[] names = { "@username", "@roletype" };
            object[] values = { username, roletype };
            object obj = OLEDB.GetSinglevalue(" select count(uid) from tb_user where username=@username and roletype=@roletype  ", names, values);
            return Convert.ToInt32(obj);
        }

        public int GetErrcountByUsername(string username)//检查密码输错次数
        {
            string[] names = { "@username" };
            object[] values = { username };
            object obj = OLEDB.GetSinglevalue(" select errcount from tb_user where username=@username  ", names, values);
            return Convert.ToInt32(obj);
        }

        public int CheckPWDByUsernameAndPassword(string username, string password,int roletype)//检查密码是否正确
        {
            string[] names = { "@username", "@password","@roletype" };
            object[] values = { username, password,roletype };
            object obj = OLEDB.GetSinglevalue(" select count(uid) from tb_user where username=@username and password=@password and roletype=@roletype  ", names, values);
            return Convert.ToInt32(obj);
        }

        public int ResetErrcountByUsername(string username)//重置密码输错错误次数<输错1次-1，一共三次>
        {
            string[] names = { "@username" };
            object[] values = { username };
            return OLEDB.ExecuteSQL(" update tb_user set errcount=0 where username=@username  ", names, values);
        }

        public int UpdateErrcountByUsername(string username)//更新密码输错错误次数
        {
            string[] names = { "@username" };
            object[] values = { username };
            object obj = OLEDB.GetSinglevalue(" update tb_user set errcount=errcount+1 where username=@username  ", names, values);
            return Convert.ToInt32(obj);
        }