userservice.cs

客户关系管理系统 客户关系管理系统

using System;
using System.Collections.Generic;
using System.Text;
using MyCRM.IDAL;
using MyCRM.Models;
using System.Data;
using System.Data.SqlClient;
using MyCRM.DBUtility;

namespace MyCRM.DAL
{
    /// <summary>
    /// 用户信息数据层
    /// </summary>
   public class UserService:IUser
   {
        /// <summary>
        ///查询用户所有信息
        /// </summary>
        /// <returns>返回集合</returns>
       public List<Sys_user> GetAllUsers()
       {
           string sql = "select * from sys_user";
           return GetUsersBySql(sql);
       }
       /// <summary>
       /// 登录验证
       /// </summary>
       /// <param name="userId">登录名</param>
       /// <param name="Password">密码</param>
       /// <param name="validUser">用户对象</param>
       /// <returns>返回用户对象</returns>

       public bool Login(string username, string Password, out Sys_user validUser)
       {
           UserService us = new UserService();
           Sys_user user = us.GetUserById(username);
           if (user == null)
           {
               //用户名不存在 
               validUser = null;
               return false;
           }
           else
           {
               if (user.User_password == Password)
               {
                   validUser = user;
                   return true;
               }
               else
               {
                   //密码错误
                   validUser = null;
                   return false;
               }
           }
       }

        /// <summary>
        /// 验证用户Id是否已存在
        /// </summary>
        /// <param name="userId">用户ID</param>
        /// <returns>返回布尔类型</returns>
       public bool IsUserIdExist(string username)
        {
            string sql = "select count(*) from Sys_user where user_name = '" + username + "'";
            int count = DBHelper.GetScalar(sql);
            if (count > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// 根据用户Id获得用户信息
        /// </summary>
        /// <param name="userId">用户ID</param>
        /// <returns>返回对象</returns>
       public Sys_user GetUserById(string username)
        {
            string sql = "select * from Sys_user where user_name = '" + username + "'";
            DataTable dtUserInfo = DBHelper.GetDataSet(sql);
            Sys_user user = new Sys_user();
            foreach (DataRow row in dtUserInfo.Rows)
            {
                user.User_id = (int)row["User_Id"];
                user.User_name = (string)row["User_Name"];
                user.User_password = (string)row["User_password"];
                user.User_flag = (int)row["user_flag"];              
                RoleService ris = new RoleService();
                user.Role = ris.GetRoleInfoById((int)row["user_role_id"]);
            }
            return user;
        }
       /// <summary>
       /// 根据用户ID查询
       /// </summary>
       /// <param name="userid"></param>
       /// <returns></returns>
       public Sys_user GetUsersById(int userid)
       {
           string sql = "select * from Sys_user where user_id = " + userid;
           DataTable dtUserInfo = DBHelper.GetDataSet(sql);
           Sys_user user = new Sys_user();
           foreach (DataRow row in dtUserInfo.Rows)
           {
               user.User_id = (int)row["User_Id"];
               user.User_name = (string)row["User_Name"];
               user.User_password = (string)row["User_password"];
               user.User_flag = (int)row["user_flag"];

               RoleService ris = new RoleService();
               user.Role = ris.GetRoleInfoById((int)row["user_role_id"]);
           }
           return user;
       }
        /// <summary>
        /// 依据sql语句查询用户
        /// </summary>
        /// <param name="safeSql">sql语句</param>
        /// <returns>返回集合</returns>
       public List<Sys_user> GetUsersBySql(string safeSql)
        {
            List<Sys_user> list = new List<Sys_user>();
            using (DataTable table = DBHelper.GetDataSet(safeSql))
            {
                foreach (DataRow row in table.Rows)
                {
                    Sys_user user = new Sys_user();
                    user.User_id = (int)row["User_Id"];
                    user.User_name = (string)row["User_Name"];
                    user.User_password = (string)row["User_password"];
                    user.User_flag = (int)row["user_flag"];
                    RoleService ris = new RoleService();
                    user.Role = ris.GetRoleInfoById((int)row["user_role_id"]);
                    list.Add(user);
                }
                return list;
            }
        }

    }
  }