using System;
using System.Data;
using Microsoft.ApplicationBlocks.Data;

namespace STGROUP.ST_ExamBiz
{
	/// <summary>
	/// ST_Dept 的摘要說明。
	/// </summary>
	public class ST_Course
	{
		string st_SqlString = System.Configuration.ConfigurationSettings.AppSettings["ConnString"];
		public ST_Course()
		{
			//
			// TODO: 在此處添加構(gòu)造函數(shù)邏輯
			//
		}
		/// <summary>
		/// 插入科目基本信息
		/// </summary>
		/// <param name="st_StuInfo"></param>
		public void ST_InsertCourseInfo(string ST_CourseName)
		{
			string sqlString = "insert ST_CourseInfo(ST_CourseName) values('"+ST_CourseName+"')";
			SqlHelper.ExecuteNonQuery(st_SqlString, CommandType.Text, sqlString);
		}

		/// <summary>
		/// 修改科目基本信息
		/// </summary>
		/// <param name="st_StuInfo"></param>
		public void ST_UpdateCourseInfo(string ST_CourseName, int ST_CourseID)
		{
			string sqlString = "update ST_CourseInfo set ST_CourseName='"+ST_CourseName+"' where ST_CourseID="+ST_CourseID;
			SqlHelper.ExecuteNonQuery(st_SqlString, CommandType.Text, sqlString);
		}
		/// <summary>
		/// 刪除科目的記錄
		/// </summary>
		/// <param name="st_TeacherID"></param>
		public void ST_DeleteCourseInfo(int ST_CourseID)
		{
			string sqlString = "update ST_CourseInfo set ST_IsDeleted=1 where  ST_CourseID="+ST_CourseID;
			SqlHelper.ExecuteNonQuery(st_SqlString, CommandType.Text, sqlString);
		}

		/// <summary>
		/// 取得一個(gè)科目的信息
		/// </summary>
		/// <param name="ST_DeptID"></param>
		/// <returns></returns>
		public DataSet ST_GetCourseInfo(int ST_CourseID)
		{
			string sqlString = "select * from ST_CourseInfo where ST_IsDeleted=0 and ST_CourseID="+ST_CourseID;
			return SqlHelper.ExecuteDataset(st_SqlString, CommandType.Text, sqlString);
		}
		/// <summary>
		/// 取得科目的信息
		/// </summary>
		/// <param name="ST_DeptID"></param>
		/// <returns></returns>
		public DataSet ST_GetAllCourseInfo()
		{
			string sqlString = "select * from ST_CourseInfo where ST_IsDeleted=0";
			return SqlHelper.ExecuteDataset(st_SqlString, CommandType.Text, sqlString);
		}
	}
}