st_dept.cs

学生选棵系统

using System;
using STGROUP.ST_CourseBiz;
using System.Data;
using Microsoft.ApplicationBlocks.Data;

namespace STGROUP.ST_CourseBiz
{
	/// <summary>
	/// ST_Dept 的摘要说明。
	/// </summary>
	public class ST_Dept
	{
		string st_SqlString = System.Configuration.ConfigurationSettings.AppSettings["ConnString"];
		public ST_Dept()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		/// <summary>
		/// 插入院系基本信息
		/// </summary>
		/// <param name="st_StuInfo"></param>
		public void ST_InsertDeptInfo(string ST_DeptName)
		{
			string sqlString = "insert ST_DeptInfo(ST_DeptName) values('"+ST_DeptName+"')";
			SqlHelper.ExecuteNonQuery(st_SqlString, CommandType.Text, sqlString);
		}

		/// <summary>
		/// 修改院系基本信息
		/// </summary>
		/// <param name="st_StuInfo"></param>
		public void ST_UpdateDeptInfo(string ST_DeptName, int ST_DeptID)
		{
			string sqlString = "update ST_DeptInfo set ST_DeptName='"+ST_DeptName+"' where ST_DeptID="+ST_DeptID;
			SqlHelper.ExecuteNonQuery(st_SqlString, CommandType.Text, sqlString);
		}
		/// <summary>
		/// 删除院系的记录
		/// </summary>
		/// <param name="st_TeacherID"></param>
		public void ST_DeleteDeptInfo(int ST_DeptID)
		{
			string sqlString = "update ST_DeptInfo set ST_IsDeleted=1 where  ST_DeptID="+ST_DeptID;
			SqlHelper.ExecuteNonQuery(st_SqlString, CommandType.Text, sqlString);
		}

		/// <summary>
		/// 取得一个院系的信息
		/// </summary>
		/// <param name="ST_DeptID"></param>
		/// <returns></returns>
		public DataSet ST_GetDeptInfo(int ST_DeptID)
		{
			string sqlString = "select * from ST_DeptInfo where ST_IsDeleted=0 and ST_DeptID="+ST_DeptID;
			return SqlHelper.ExecuteDataset(st_SqlString, CommandType.Text, sqlString);
		}
		/// <summary>
		/// 取得院系的信息
		/// </summary>
		/// <param name="ST_DeptID"></param>
		/// <returns></returns>
		public DataSet ST_GetAllDeptInfo()
		{
			string sqlString = "select * from ST_DeptInfo where ST_IsDeleted=0";
			return SqlHelper.ExecuteDataset(st_SqlString, CommandType.Text, sqlString);
		}
	}
}