using System;
using System.Collections;
using System.Data;
using System.Windows.Forms;
using ExamCenter.ADLCTier;
using ExamCenter.FormTier;

namespace ExamCenter.BLCTier
{
   public class KdBLC : BaseADLC
    {
        private const string SQL_SELECT_ALL_KD = "SELECT kdID,kdname,description FROM kd";
        private string SQL_SELECT_KD_BY_ID = "SELECT * FROM kd WHERE kdID =";
       public KdBLC()
       {
           //
           // TODO: 在此處添加構(gòu)造函數(shù)邏輯
           //
       }
       public DataSet GetKdById(int intKdId)
       {
           //方法：public DataSet GetKdById(int intKdId)
           //參數(shù)：考點id
           //功能：根據(jù)考點id以數(shù)據(jù)集的形式返回考點表中考點信息
           //返回：若考點存在，返回數(shù)據(jù)集
           //      否則，返回null

           //SQL_SELECT_KD_BY_ID為查詢語句
           SQL_SELECT_KD_BY_ID = SQL_SELECT_KD_BY_ID + intKdId.ToString();
           //執(zhí)行查詢命令，返回數(shù)據(jù)集
           return UserBLC.ExecuteSqlReturnDs(SQL_SELECT_KD_BY_ID);

       }
       public DataSet GetAllKd()
       {
           //方法：public DataSet GetAllKd()
           //功能：返回考點表
           //返回：數(shù)據(jù)集

           //執(zhí)行查詢語句SQL_SELECT_ALL_KD，返回數(shù)據(jù)集
           return UserBLC.ExecuteSqlReturnDs(SQL_SELECT_ALL_KD);
       }

       public void UpdateUser(DataSet dsKd)
       {
           //方法：public void UpdateUser(DataSet user)
           //功能：更新考點表
           //返回：void

           //更新考點表dsKd
           UserBLC.UpdateDataSource(dsKd, SQL_SELECT_ALL_KD);
       }


    }


}