st_major.cs

学生选棵系统

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

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

		/// <summary>
		/// 修改专业基本信息
		/// </summary>
		/// <param name="st_StuInfo"></param>
		public void ST_UpdateMajorInfo(string ST_MajorName, int ST_DeptID, int ST_MajorID)
		{
			string sqlString = "update ST_MajorInfo set ST_MajorName='"+ST_MajorName+"',ST_DeptID="+ST_DeptID+" where ST_MajorID="+ST_MajorID;
			SqlHelper.ExecuteNonQuery(st_SqlString, CommandType.Text, sqlString);
		}
		/// <summary>
		/// 删除专业的记录
		/// </summary>
		/// <param name="st_TeacherID"></param>
		public void ST_DeleteMajorInfo(int ST_MajorID)
		{
			string sqlString = "update ST_MajorInfo set ST_IsDeleted=1 where ST_MajorID="+ST_MajorID;
			SqlHelper.ExecuteNonQuery(st_SqlString, CommandType.Text, sqlString);
		}
		/// <summary>
		/// 取得一个专业的信息
		/// </summary>
		/// <param name="ST_DeptID"></param>
		/// <returns></returns>
		public DataSet ST_GetMajorInfo(int ST_MajorID)
		{
			string sqlString = "select * from ST_MajorInfo sm inner join ST_DeptInfo sd on sm.ST_DeptID=sd.ST_DeptID where sm.ST_IsDeleted=0 and sd.ST_IsDeleted=0 and ST_MajorID="+ST_MajorID;
			return SqlHelper.ExecuteDataset(st_SqlString, CommandType.Text, sqlString);
		}
		/// <summary>
		/// 取得专业的信息
		/// </summary>
		/// <param name="ST_DeptID"></param>
		/// <returns></returns>
		public DataSet ST_GetAllMajorInfo()
		{
			string sqlString = "select * from ST_MajorInfo sm inner join ST_DeptInfo sd on sm.ST_DeptID=sd.ST_DeptID where sm.ST_IsDeleted=0 and sd.ST_IsDeleted=0";
			return SqlHelper.ExecuteDataset(st_SqlString, CommandType.Text, sqlString);
		}
		/// <summary>
		/// 取得专业的信息
		/// </summary>
		/// <param name="ST_DeptID"></param>
		/// <returns></returns>
		public DataSet ST_GetMajorInfoByDid(int ST_DeptID)
		{
			string sqlString = "select * from ST_MajorInfo sm inner join ST_DeptInfo sd on sm.ST_DeptID=sd.ST_DeptID where sm.ST_IsDeleted=0 and sd.ST_IsDeleted=0 and sm.ST_DeptID="+ST_DeptID;
			return SqlHelper.ExecuteDataset(st_SqlString, CommandType.Text, sqlString);
		}
	}
}