users.cs

一个在线的音乐榜单的系统

using System;
using System.Data;
using System.Data.OracleClient;

namespace MusicClass
{
	/// <summary>
	/// Users 的摘要说明。
	/// </summary>
	public class Users
	{
		private string _id;
		private string _name;
		private string _password;
		private string _isAdmin;

		public string Id
		{
			get { return _id;}
			set { _id = value;}
		}
		public string Name
		{
			get { return _name;}
			set { _name = value;}
		}
		public string Password
		{
			get { return _password;}
			set { _password = value;}
		}
		public string IsAdmin
		{
			get { return _isAdmin;}
			set { _isAdmin = value;}
		}

		public Users()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public static Users GetUserByName(string name)
		{
			string queryUser = "SELECT Id,Name,Password,IsAdmin FROM Users WHERE Upper(Name)='"+name.ToUpper()+"'";
			OracleConnection conn = new OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["OraConnString"]);
			OracleCommand comm = new OracleCommand(queryUser,conn);
			try
			{
				conn.Open();
				OracleDataReader oraReader = comm.ExecuteReader();
				if( oraReader.Read() )
				{
					Users user =new Users();
					user.Id = oraReader.IsDBNull(0)?"":oraReader.GetString(0);
					user.Name = oraReader.IsDBNull(1)?"":oraReader.GetString(1);
					user.Password = oraReader.IsDBNull(2)?"":oraReader.GetString(2);
					user.IsAdmin = oraReader.IsDBNull(3)?"":oraReader.GetString(3);
					return user;
				}
				return null;
			}
			finally
			{
				conn.Close();
			}			
		}
		public static Users GetUserById(string id)
		{
			string queryUser = "SELECT Id,Name,Password,IsAdmin FROM Users WHERE Upper(id)='"+id.ToUpper()+"'";
			OracleConnection conn = new OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["OraConnString"]);
			OracleCommand comm = new OracleCommand(queryUser,conn);
			try
			{
				conn.Open();
				OracleDataReader oraReader = comm.ExecuteReader();
				if( oraReader.Read() )
				{
					Users user =new Users();
					user.Id = oraReader.IsDBNull(0)?"":oraReader.GetString(0);
					user.Name = oraReader.IsDBNull(1)?"":oraReader.GetString(1);
					user.Password = oraReader.IsDBNull(2)?"":oraReader.GetString(2);
					user.IsAdmin = oraReader.IsDBNull(3)?"":oraReader.GetString(3);
					return user;
				}
				return null;
			}
			finally
			{
				conn.Close();
			}			
		}
		public static DataTable GetAllUser()
		{
			DataTable dt = new DataTable();
			string queryUsers = "SELECT Id,Name,Password,IsAdmin From Users";
			OracleConnection conn = new OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["OraConnString"]);
			OracleDataAdapter oraDA = new OracleDataAdapter(queryUsers,conn);
			oraDA.Fill(dt);
			return dt;
		}


		public static int SaveUser(Users user)
		{
			string update = "UPDATE users SET Name='"+user.Name+"', Password='"+user.Password+"',IsAdmin = '"+user.IsAdmin +"' WHERE Id='"+user.Id+"'";
			OracleConnection conn = new OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["OraConnString"]);
			OracleCommand comm = new OracleCommand(update,conn);
			try
			{
				conn.Open();
				return comm.ExecuteNonQuery();
			}
			finally
			{
				conn.Close();
			}
		}
		public int AddUser(Users user)
		{
			if( GetUserByName(user.Name) != null )
				return -1;
			string insertUser = "INSERT INTO USERS(name,password,isAdmin) Values('"+user.Name+"','"+user.Password+"','"+user.IsAdmin+"')";
			OracleConnection conn = new OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["OraConnString"]);
			OracleCommand comm = new OracleCommand(insertUser,conn);
			try
			{
				conn.Open();
				return comm.ExecuteNonQuery();
			}
			finally
			{
				conn.Close();
			}			
		}
	}
}