impuserdal.cs

酒店在线订餐管理系统

                cmd.Connection.Close();
            }
        }
        #endregion

        #region 查询出为认证的用户
        public IList<User> SelectNoVerify()
        {
            cmd.CommandText = "SELECT * FROM UT_User WHERE [Group]=0";
            try
            {
                if (cmd.Connection.State == System.Data.ConnectionState.Closed)
                    cmd.Connection.Open();
                DbDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
                List<User> list = new List<User>();
                User u = null;
                while (reader.Read())
                {
                    u = new User();
                    u.Guid = reader.GetGuid(0).ToString();
                    u.LoginName = reader.GetString(1);
                    u.Group = int.Parse(reader.GetValue(8).ToString());
                    u.Contact = reader.GetString(6);
                    u.Tel = reader.GetString(7);
                    list.Add(u);
                }
                return list;
            }
            catch (Exception ex)
            {
                throw new Exception("检索未认证用户失败" + ex.Message);
            }
            finally
            {
                cmd.Parameters.Clear();
                cmd.Connection.Close();
            }
        }
        #endregion

        #region 选择出认证用户
        public IList<User> SelectVerified()
        {
            cmd.CommandText = "SELECT * FROM UT_User WHERE [Group]=1";
            try
            {
                if (cmd.Connection.State == System.Data.ConnectionState.Closed)
                    cmd.Connection.Open();
                DbDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
                List<User> list = new List<User>();
                User u = null;
                while (reader.Read())
                {
                    u = new User();
                    u.Guid = reader.GetGuid(0).ToString();
                    u.LoginName = reader.GetString(1);
                    u.Group = int.Parse(reader.GetValue(8).ToString());
                    u.Contact = reader.GetString(6);
                    u.Tel = reader.GetString(7);
                    list.Add(u);
                }
                return list;
            }
            catch (Exception ex)
            {
                throw new Exception("检索未认证用户失败" + ex.Message);
            }
            finally
            {
                cmd.Parameters.Clear();
                cmd.Connection.Close();
            }
        }
        #endregion

        #region 选择出所有用户
        public IList<User> UserList()
        {
            cmd.CommandText = "SELECT * FROM UT_User WHERE [Group]<2";
            try
            {
                if (cmd.Connection.State == System.Data.ConnectionState.Closed)
                    cmd.Connection.Open();
                DbDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
                List<User> list = new List<User>();
                User u = null;
                while (reader.Read())
                {
                    u = new User();
                    u.Guid = reader.GetGuid(0).ToString();
                    u.LoginName = reader.GetString(1);
                    u.Group = int.Parse(reader.GetValue(8).ToString());
                    u.Contact = reader.GetString(6);
                    u.Tel = reader.GetString(7);
                    list.Add(u);
                }
                return list;
            }
            catch (Exception ex)
            {
                throw new Exception("检索未认证用户失败" + ex.Message);
            }
            finally
            {
                cmd.Parameters.Clear();
                cmd.Connection.Close();
            }
        }
        #endregion

        #region 设定用户为认证用户
        public int SetVerify(string userName)
        {
            cmd.CommandText = "UPDATE UT_User SET [Group]=1 WHERE LoginName=@LN";
            SqlParameter p = new SqlParameter("LN", userName);
            cmd.Parameters.Add(p);
            try
            {
                if (cmd.Connection.State == System.Data.ConnectionState.Closed)
                    cmd.Connection.Open();
                return cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                throw new Exception("将用户设置成认证用户失败" + ex.Message);
            }
            finally
            {
                cmd.Parameters.Clear();
                cmd.Connection.Close();
            }
        }
        #endregion

        #region 设定用户为非用户
        public int SetNoVerify(string userName)
        {
            cmd.CommandText = "UPDATE UT_User SET [Group]=0 WHERE LoginName=@LN";
            SqlParameter p = new SqlParameter("LN", userName);
            cmd.Parameters.Add(p);
            try
            {
                if (cmd.Connection.State == System.Data.ConnectionState.Closed)
                    cmd.Connection.Open();
                return cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                throw new Exception("将用户设置成未认证用户失败" + ex.Message);
            }
            finally
            {
                cmd.Parameters.Clear();
                cmd.Connection.Close();
            }
        }
        #endregion

        #region 根据用户名获取用户对象
        public User GetUserInfo(string userName)
        {
            cmd.CommandText = "SELECT * FROM UV_ActiveUser WHERE LoginName=@LN";
            SqlParameter p = new SqlParameter("LN", userName);
            cmd.Parameters.Add(p);
            if (cmd.Connection.State == System.Data.ConnectionState.Closed)
                cmd.Connection.Open();
            DbDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            User u = null;
            if (reader.HasRows)
            {
                while (reader.Read())
                    u = new User(reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetString(5), reader.GetString(6), reader.GetString(7), int.Parse(reader.GetValue(8).ToString()), reader.IsDBNull(9) ? 0 : reader.GetInt32(9));
            }
            else
            {
                reader.Close();
                cmd.CommandText = "SELECT * FROM UT_User WHERE LoginName=@LN";
                if (cmd.Connection.State == System.Data.ConnectionState.Closed)
                    cmd.Connection.Open();
                reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                while (reader.Read())
                    u = new User(reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetString(5), reader.GetString(6), reader.GetString(7), int.Parse(reader.GetValue(8).ToString()), 0);
            }

            cmd.Connection.Close();
            return u;
          
        }
        #endregion

        #region 选出活跃用户


        public IList<User> SelectActiveUser()
        {
            cmd.CommandText = "SELECT * FROM UV_ActiveUser";
            try
            {
                if (cmd.Connection.State == System.Data.ConnectionState.Closed)
                    cmd.Connection.Open();
                IList<User> list=new List<User>();
                User u = null;
                DbDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                while (reader.Read())
                {
                    u = new User(reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetString(5), reader.GetString(6), reader.GetString(7), int.Parse(reader.GetValue(8).ToString()), reader.IsDBNull(9) ? 0 : reader.GetInt32(9));
                    list.Add(u);
                }
                return list;
            }
            catch (Exception ex)
            {
                throw new Exception("搜索活跃用户失败" + ex.Message);
            }
            finally
            {
                cmd.Parameters.Clear();
                cmd.Connection.Close();
            }
        }

        #endregion


        #endregion
    }
}