userinfoservice.cs

will let you know the result once they replied will let you know the result once they replied

using System;
using System.Collections.Generic;
using System.Text;
using MyOffice.Models;
using MyOffice.DBUtility;
using System.Data;
using System.Data.SqlClient;

namespace MyOffice.DAL
{
    public class UserInfoService
    {
        public IList<UserInfo> GetAllUsers()
        {
            IList<UserInfo> list = new List<UserInfo>();
            string sql = string.Format(@"select * from userinfo");
            using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql, null))
            {
                while (reader.Read())
                {
                    UserInfo user = new UserInfo();
                    user.UserID = reader.GetString(0);
                    user.UserName = reader.GetString(1);
                    user.Password = reader.GetString(2);
                    user.DepartInfo = new DepartInfoService().GetDepartByID(reader.GetInt32(3));
                    user.Gender = reader.GetInt32(4);
                    user.RoleInfo = new RoleInfoService().GetRoleByID(reader.GetInt32(5));
                    user.UserState = new UserStateService().GetUserStateByID(reader.GetInt32(6));
                    list.Add(user);
                }
            }
            return list;
        }

        public bool CheckUserID(string userID)
        {
            bool flag = false;
            string sql = string.Format(@"select * from userinfo where userid='{0}'",userID);
            using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql, null))
            {
                if (!reader.Read())
                {
                    flag = true;
                    return flag;
                }
            }
            return flag;
        }

        public bool CheckUserName(string userName)
        {
            bool flag = false;
            string sql = string.Format(@"select * from userinfo where username='{0}'",userName);
            using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql, null))
            {
                if (!reader.Read())
                {
                    flag = true;
                    return flag;
                }
            }
            return flag;
        }

        public UserInfo UserLogin(string userName, string password)
        {
            string sql = string.Format(@"select * from userinfo where userid='{0}' and password='{1}'",userName,password);
            using (SqlDataReader reader =  SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql, null))
            {
                if (reader.Read())
                {
                    UserInfo user = new UserInfo();
                    user.UserID = reader.GetString(0);
                    user.UserName = reader.GetString(1);
                    user.Password = reader.GetString(2);
                    user.DepartInfo = new DepartInfoService().GetDepartByID(reader.GetInt32(3));
                    user.Gender = reader.GetInt32(4);
                    user.RoleInfo = new RoleInfoService().GetRoleByID(reader.GetInt32(5));
                    user.UserState = new UserStateService().GetUserStateByID(reader.GetInt32(6));
                    return user;
                }
                else
                {
                    return null;
                }
            }

        }

        public UserInfo GetUserByID(string userID)
        {
            string sql = string.Format(@"select * from userinfo where userid='{0}'",userID);
            using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql, null))
            {
                if (reader.Read())
                {
                    UserInfo user = new UserInfo();
                    user.UserID = reader.GetString(0);
                    user.UserName = reader.GetString(1);
                    user.Password = reader.GetString(2);
                    user.DepartInfo = new DepartInfoService().GetDepartByID(reader.GetInt32(3));
                    user.Gender = reader.GetInt32(4);
                    user.RoleInfo = new RoleInfoService().GetRoleByID(reader.GetInt32(5));
                    user.UserState = new UserStateService().GetUserStateByID(reader.GetInt32(6));
                    return user;
                }
                else
                {
                    return null;
                }
            }
        }
    }
}