usersservice.cs

简单聊天系统,自己做的,有数据库.多多支持,做的不好,请大家原谅.

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

using NewChartModels;

namespace NewChartDAL
{
   public class UsersService
    {
       public static int CheckLogin(string loginId, string loginPwd)
       {
           string sql = "select id from Users where LoginId=@loginId and LoginPwd=@loginPwd";
           SqlParameter[] p = new SqlParameter[]
           {
                new SqlParameter("@loginId",loginId),
                new SqlParameter("@loginPwd",loginPwd)
           };
           int num=DBHelper.GetScalar(sql,p);
           if (num > 0)
           {
               return num;
           }
           return -1;
       }

       public static UsersInfo GetUsersInfoById(int id)
       {
           string sql = "select * from Users where Id=@id ";
           UsersInfo user = null;
           using (SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@id", id)))
           {
               if (reader.Read())
               {
                   user = new UsersInfo();
                   user.Id=Convert.ToInt32(reader["Id"]);
                   user.LoginId=reader["LoginId"].ToString();
                   user.LoginPwd=reader["LoginPwd"].ToString();
                   user.Name=reader["Name"].ToString();
                   user.Address=reader["Address"].ToString();
                   user.Phone=reader["Phone"].ToString();
                   user.Mail = reader["Mail"].ToString();
                   UserRolesInfo ur = new UserRolesInfo();
                   ur.Id = (int)reader["Id"];
                   user.UserRoles = ur;
                   UserStatesInfo us = new UserStatesInfo();
                   us.Id=(int)reader["Id"];
                   user.UserStates = us;
                   user.Gender =Convert.ToInt32( reader["Gender"]);
                   return user;
               }
           }
           return null;

       }


       public static bool CheckUser(string name)
       {
           string sql = "select * from Users where Name=@name";
           int result = DBHelper.GetScalar(sql,new SqlParameter("@name",name));
           if (result > 0)
           {
               return true;
           }
           return false;
       }


       public static bool AddUsers(UsersInfo userinfo)
       {
           string sql = "insert into users values(@loginId,@loginPwd,@name,@address,@phone,@mail,@userRoleId,@userStateId,@gender)";
           SqlParameter[] p = new SqlParameter[]
           {
               new SqlParameter("@loginId",userinfo.LoginId),
               new SqlParameter("@loginPwd",userinfo.LoginPwd),
               new SqlParameter("@name",userinfo.Name),
               new SqlParameter("@address",userinfo.Address),
               new SqlParameter("@phone",userinfo.Phone),
               new SqlParameter("@mail",userinfo.Mail),
               new SqlParameter("@userRoleId",userinfo.UserRoles.Id),
               new SqlParameter("@userStateId",userinfo.UserStates.Id),
               new SqlParameter("@gender",userinfo.Gender),
              
           };
           int result = DBHelper.ExecuteCommand(sql,p);
           if (result > 0)
           {
               return true;
           }
           return false;
       }


       public static IList<UsersInfo> GetAllUsers()
       {
           List<UsersInfo> userinfo = new List<UsersInfo>();
           string sql = "select * from Users";
           UsersInfo info = null;
           using (SqlDataReader reader=DBHelper.GetReader(sql))
           {
               while (reader.Read())
               {
                   info = new UsersInfo();
                   info.Id = Convert.ToInt32(reader["Id"]);
                   info.LoginId = reader["LoginId"].ToString();
                   info.LoginPwd = reader["LoginPwd"].ToString();
                   info.Name = reader["Name"].ToString();
                   info.Address = reader["Address"].ToString();
                   info.Phone = reader["Phone"].ToString();
                   info.Mail = reader["Mail"].ToString();
                   UserRolesInfo ur = new UserRolesInfo();
                   ur.Id = (int)reader["UserRoleId"];
                   info.UserRoles = ur;

                   UserStatesInfo us = new UserStatesInfo();
                   us.Id = (int)reader["UserStateId"];
                   info.UserStates = us;

                   info.Gender = (int)reader["Gender"];

                   userinfo.Add(info);
               }
           }
           return userinfo;
       }


       public static void DeleteUserById(int id)
       {
           string sql = "delete from Users where Id=@Id";
           DBHelper.ExecuteCommand(sql, new SqlParameter("@Id",id));
       }

       public static string[] GetUserByPreName(string preName, int count)
       {
           IList<UsersInfo> list = new List<UsersInfo>();
           List<string> results = new List<string>();
           string sql = "select Name from users where name like '" + preName + "%'";
           using (SqlDataReader reader = DBHelper.GetReader(sql))
           {
               while (reader.Read())
               {
                   UsersInfo user = new UsersInfo();
                   user.Name = reader["Name"].ToString();
                   list.Add(user);
               }
           }
           foreach (UsersInfo item in list)
           {
               results.Add(item.Name);
           }
           return results.ToArray();
       }

       public static int GetUserIdByName(string name)
       {
           string sql = "select Id from Users where Name=@name";
           int id = DBHelper.GetScalar(sql,new SqlParameter("@name",name));
           return id;
       }

   }
}