category.cs

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

using System;
using System.Data;
using System.Data.OracleClient;
namespace MusicClass
{
	/// <summary>
	/// Category 的摘要说明。
	/// </summary>
	public class Category
	{
		private string _id;
		private string _name;
		public string Id
		{
			get { return _id;}
			set { _id = value;}
		}
		public string Name
		{
			get { return _name;}
			set { _name = value;}
		}
		public Category()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public static DataSet GetAllCategory()
		{
			DataSet dset = new DataSet();
			string sql = "SELECT * FROM PopMusic.Category ";
			OracleConnection conn = new OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["OraConnString"]);
			OracleDataAdapter oraDA = new OracleDataAdapter(sql,conn);
			oraDA.Fill(dset);
			return dset;
		}
		public static Category GetByName(string name)
		{
			string judge = "SELECT * FROM PopMusic.Category WHERE Upper(Name)='"+name.ToUpper()+"'";
			OracleConnection conn = new OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["OraConnString"]);
			OracleCommand comm = new OracleCommand(judge,conn);
			try
			{
				conn.Open();
				OracleDataReader dr = comm.ExecuteReader();
				if(dr.Read())
				{
					Category category = new Category();
					category.Id = dr.IsDBNull(0)?"":dr.GetString(0);
					category.Name = dr.IsDBNull(1)?"":dr.GetString(1);
					return category;
				}
				return null;
			}
			finally
			{
				conn.Close();
			}
		}
		public static int SaveCategoryById(string id,string name)
		{
			string sql;
			if( id== "&nbsp;")
			{	
				if( Category.GetByName( name )!= null)
					return -1;
				else
					sql = "INSERT INTO PopMusic.Category(Name) VALUES ('"+name+"')";
			}
			else
			{
				sql = "Update PopMusic.Category SET name='"+ name +"' WHERE id='"+id+"'";			
			}

			OracleConnection conn = new OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["OraConnString"]);
			OracleCommand comm = new OracleCommand(sql,conn);
			try
			{
				conn.Open();
				return comm.ExecuteNonQuery();
			}
			finally
			{
				conn.Close();
			}
		}
	}
}