statusitem.cs

该项目管理系统可对项目的过程进行管理和控制

using System;
using System.Data;
using System.Data.SqlClient;

namespace BronzeMonkey.GeneralTaskList
{
	/// <summary>
	/// Summary description for StatusItem.
	/// </summary>
	public class StatusItem
	{
		public readonly int StatusID = 0;
		public string Description = String.Empty;
		public string FontFlags = String.Empty;

		public StatusItem()
		{
		}

		public StatusItem(int StatusID, string Description, string FontFlags)
		{
			this.StatusID = StatusID;
			this.Description = Description;
			this.FontFlags = FontFlags;
		}

		public void Update(string ConnectionString)
		{
			SqlCommand Command = new SqlCommand("TaskList_UpdateStatusType", new SqlConnection(ConnectionString));
			Command.CommandType = CommandType.StoredProcedure;

			Command.Parameters.Add("@StatusID", SqlDbType.BigInt).Value = this.StatusID;
			Command.Parameters.Add("@Description", SqlDbType.VarChar, 25).Value = this.Description;
			Command.Parameters.Add("@StatusFontFlags", SqlDbType.VarChar, 500).Value = this.FontFlags;

			Command.Connection.Open();
			Command.ExecuteNonQuery();
			Command.Connection.Close();

			Command.Dispose();
		}

		public static StatusItem GetStatusItem(int StatusID, string ConnectionString)
		{
			StatusItem ThisItem = new StatusItem();

			SqlCommand Command = new SqlCommand("TaskList_GetStatusTypeByID", new SqlConnection(ConnectionString));
			Command.CommandType = CommandType.StoredProcedure;

			Command.Parameters.Add("@StatusID", SqlDbType.BigInt).Value = StatusID;

			Command.Connection.Open();
			SqlDataReader dr = Command.ExecuteReader(CommandBehavior.CloseConnection);
			if( dr.Read() )
			{
				ThisItem = new StatusItem(
					Convert.ToInt32(dr["StatusID"]),
					Convert.ToString(dr["Description"]),
					Convert.ToString(dr["FontFlags"]));
			}
			else
			{
				throw new Exception("Could not find a Status Type matching ID " + StatusID.ToString());
			}
			
			dr.Close();
			Command.Dispose();

			return ThisItem;
		}

		public static int AddStatusItem(string Description, string FontFlags, string ConnectionString)
		{
			SqlCommand Command = new SqlCommand("TaskList_AddStatusType", new SqlConnection(ConnectionString));
			Command.CommandType = CommandType.StoredProcedure;

			Command.Parameters.Add("@Description", SqlDbType.VarChar, 25).Value = Description;
			Command.Parameters.Add("@StatusFontFlags", SqlDbType.VarChar, 500).Value = FontFlags;
			SqlParameter RetVal = Command.Parameters.Add("@ReturnValue", SqlDbType.Int);
			RetVal.Direction = ParameterDirection.ReturnValue;

			Command.Connection.Open();
			Command.ExecuteNonQuery();
			Command.Connection.Close();

			Command.Dispose();

			return Convert.ToInt32(RetVal.Value);
		}

		public static void DeleteStatusItem(int StatusID, string ConnectionString)
		{
			SqlCommand Command = new SqlCommand("TaskList_DeleteStatusType", new SqlConnection(ConnectionString));
			Command.CommandType = CommandType.StoredProcedure;

			Command.Parameters.Add("@StatusID", SqlDbType.BigInt).Value = StatusID;

			Command.Connection.Open();
			Command.ExecuteNonQuery();
			Command.Connection.Close();

			Command.Dispose();
		}
	}
}