songs.cs

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

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

namespace MusicClass
{
	/// <summary>
	/// Songs 的摘要说明。
	/// </summary>
	public class Songs
	{
		private string _id;
		private string _name;
		private string _singer;
		private string _alblumn;
		private string _pubdate;
		private string _categoryid;

		#region
		public string Id
		{
			get { return _id;}
			set { _id = value;}
		}
		public string Name
		{
			get { return _name;}
			set { _name = value;}
		}
		public string Singer
		{
			get { return _singer;}
			set { _singer = value;}
		}
		public string Alblumn
		{
			get { return _alblumn;}
			set { _alblumn = value;}
		}
		public string PubDate
		{
			get { return _pubdate;}
			set { _pubdate = value;}
		}
		public string CategoryId
		{
			get { return _categoryid;}
			set { _categoryid = value;}
		}

		#endregion
		
		public Songs()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public static DataTable GetAllSongs()
		{
			DataTable dt = new DataTable();
			string querySongs = "SELECT Id,Name,Singer,Alblumn,To_Char(PubDate,'rrrr-mm-dd') PubDate,CategoryId From Songs";
			OracleConnection conn = new OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["OraConnString"]);
			OracleDataAdapter oraDA = new OracleDataAdapter(querySongs,conn);
			oraDA.Fill(dt);
			return dt;
		}

		public static DataTable GetAllSongs(string sql)
		{
			DataTable dt = new DataTable();			
			OracleConnection conn = new OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["OraConnString"]);
			OracleDataAdapter oraDA = new OracleDataAdapter(sql,conn);
			oraDA.Fill(dt);
			return dt;		
		}

		public static Songs GetById(string id)
		{
			OracleConnection conn = new OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["OraConnString"]);
			OracleCommand comm = new OracleCommand("SELECT * FROM Songs WHERE id='"+id+"'",conn);
			try
			{
				conn.Open();
				OracleDataReader oraDr = comm.ExecuteReader();
				if(oraDr.Read())
				{
					Songs song = new Songs();
					song.Id = oraDr.IsDBNull(0)?"":oraDr.GetString(0);
					song.Name = oraDr.IsDBNull(1)?"":oraDr.GetString(1);
					song.Singer = oraDr.IsDBNull(2)?"":oraDr.GetString(2);
					song.Alblumn = oraDr.IsDBNull(3)?"":oraDr.GetString(3);
					song.PubDate = oraDr.IsDBNull(4)?"":oraDr.GetDateTime(4).ToString();
					song.CategoryId = oraDr.IsDBNull(5)?"":oraDr.GetString(5);
					return song;
				}
			}
			finally
			{
				conn.Close();
			}
			return null;
		}

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

	}
}