usecaseblc.cs

一个好的系统 对初学者很有用啊 来看看啊

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;
		}

	}
}