using System;
using System.Data;
using System.Collections;
using ExamCenter.ADLCTier;

namespace ExamCenter.BLCTier
{
	/// <summary>
	/// UseCaseBLC 的摘要說明。
	/// </summary>
	public struct UseCase
	{
		public int intUseCaseId;
		public int intParentId;
		public string strUseCaseName;
	}
	public class UseCaseBLC : BaseADLC
	{
	
		private string SQL_SELECT_BY_NAME = "SELECT * FROM usecase WHERE usecasename = '";
		private const string SQL_SELECT_USECASE = "SELECT * FROM usecase";
		private string SQL_SELECT_USECASE_BY_ID = "SELECT * FROM usecase WHERE usecaseID =";
		public UseCaseBLC()
		{
			//
			// TODO: 在此處添加構造函數邏輯
			//
		}

		public DataSet GetUseCaseByName(string strUseCaseName)
		{
			//方法：public DataSet GetUseCaseByName(string strUseCaseName)
			//參數：strUseCaseName為功能名
			//功能：根據功能名返回數據集

			SQL_SELECT_BY_NAME = SQL_SELECT_BY_NAME + strUseCaseName + "'";
			return UseCaseBLC.ExecuteSqlReturnDs(SQL_SELECT_BY_NAME);
		}
			
		public DataSet GetUseCaseById(int intUseCaseId)
		{
			//方法：public DataSet GetUseCaseById(int intUsecaseId)
			//參數：intUseCaseId為功能id
			//功能：根據功能id返回數據集
			//返回：如果此功能存在，返回數據集
			//      否則，返回null

			//SQL_SELECT_USECASE_BY_ID為查詢語句
			SQL_SELECT_USECASE_BY_ID = SQL_SELECT_USECASE_BY_ID + intUseCaseId.ToString();
			//執行查詢語句
			return UseCaseBLC.ExecuteSqlReturnDs(SQL_SELECT_USECASE_BY_ID);
		}
		public DataSet GetAllUseCase()
		{
			//方法：public DataSet GetAllUseCase()
			//功能：返回所有的UseCase
			//返回值：數據集

			//執行SQL_SELECT_USECASE查詢語句返回功能表
			return UseCaseBLC.ExecuteSqlReturnDs(SQL_SELECT_USECASE);
		}

		public void UpdateUseCase(DataSet dsUseCase)
		{
			//方法：public void UpdateUseCase(DataSet dsUseCase)
			//功能：更新功能表

			UseCaseBLC.UpdateDataSource(dsUseCase,SQL_SELECT_USECASE);
		}
		public UseCase FindUseCasesByUseCaseId(int intUseCaseId)
		{
			//方法：public UseCase FindUseCasesByUseCaseId(int intUseCaseId)
			//參數：intUseCaseId為功能id
			//功能：根據功能id返回一個UseCase結構

			UseCase uc = new UseCase();
			string sqlSelectCommand="SELECT * FROM usecase WHERE usecaseID="+intUseCaseId.ToString ();
			DataSet dsUseCase=UseCaseBLC.ExecuteSqlReturnDs(sqlSelectCommand);

			if( dsUseCase.Tables [0].Rows.Count ==1)
			{
				uc.intUseCaseId=Convert.ToInt16 (dsUseCase.Tables [0].Rows[0]["usecaseID"]);
				uc.strUseCaseName=dsUseCase.Tables [0].Rows[0]["usecasename"].ToString ();
				uc.intParentId =Convert.ToInt16 (dsUseCase.Tables [0].Rows[0]["parentID"]);
			}
			return uc;
		}

		public IList FindUseCasesByUseCaseIds(IList iliUseCaseId)
		{
			//根據功能id列表返回所有的usecase結構列表
			IList usecases = new ArrayList();

			foreach( int intUseCaseID in iliUseCaseId)
			{
				usecases.Add (this.FindUseCasesByUseCaseId(intUseCaseID));
			}
			return usecases;
		}

	}
}