st_teacher.cs

学生选棵系统

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

namespace STGROUP.ST_CourseBiz
{
	/// <summary>
	/// ST_Teacher 的摘要说明。
	/// </summary>
	public class ST_Teacher
	{
		string st_SqlString = System.Configuration.ConfigurationSettings.AppSettings["ConnString"];
		public ST_Teacher()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		/// <summary>
		/// 插入老师基本信息
		/// </summary>
		/// <param name="st_StuInfo"></param>
		public void ST_InsertTeacherInfo(string st_TeacherName, string st_TeacherNumber, int st_DeptID)
		{
			string sqlString = "insert ST_TeacherInfo(st_TeacherName,st_TeacherNumber,st_DeptID) values('"+st_TeacherName+"','"+st_TeacherNumber+"',"+st_DeptID+");insert into ST_Users(ST_Name, ST_Pass, ST_type,ST_ID) values ('"+st_TeacherName+"', '1234', 2,SCOPE_IDENTITY())";
			SqlHelper.ExecuteNonQuery(st_SqlString, CommandType.Text, sqlString);
		}

		/// <summary>
		/// 修改老师基本信息
		/// </summary>
		/// <param name="st_StuInfo"></param>
		public void ST_UpdateTeacherInfo(string st_TeacherName, string st_TeacherNumber, int st_DeptID, int st_TeacherID)
		{
			string sqlString = "update ST_TeacherInfo set st_TeacherName='"+st_TeacherName+"',st_TeacherNumber='"+st_TeacherNumber+"',st_DeptID="+st_DeptID+" where st_TeacherID="+st_TeacherID;
			SqlHelper.ExecuteNonQuery(st_SqlString, CommandType.Text, sqlString);
		}
		/// <summary>
		/// 删除老师的记录
		/// </summary>
		/// <param name="st_TeacherID"></param>
		public void ST_DeleteTeacherInfo(int st_TeacherID)
		{
			string sqlString = "update ST_TeacherInfo set ST_IsDeleted=1 where st_TeacherID="+st_TeacherID;
			SqlHelper.ExecuteNonQuery(st_SqlString, CommandType.Text, sqlString);
		}

		/// <summary>
		/// 查询一个老师教课记录
		/// </summary>
		/// <param name="st_StuID"></param>
		/// <param name="st_Course"></param>
		public DataTable ST_GetTeacherCourse(int st_TeacherID)
		{
			DataTable dt = null;
			string sqlString = "select * from ST_CourseInfo sc inner join ST_MajorInfo stc on sc.ST_MajorID=stc.ST_MajorID where sc.ST_TeacherID="+st_TeacherID;
			DataSet ds = SqlHelper.ExecuteDataset(st_SqlString, CommandType.Text, sqlString);
			if(ds!=null && ds.Tables.Count>0 && ds.Tables[0].Rows.Count>0)
				dt = ds.Tables[0];
			return dt;
		}

		/// <summary>
		/// 取得一个老师的信息
		/// </summary>
		/// <param name="ST_DeptID"></param>
		/// <returns></returns>
		public DataSet ST_GetTeacherInfo(int ST_TeacherID)
		{
			string sqlString = "select * from ST_TeacherInfo 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_TeacherID="+ST_TeacherID;
			return SqlHelper.ExecuteDataset(st_SqlString, CommandType.Text, sqlString);
		}
		/// <summary>
		/// 取得老师的信息
		/// </summary>
		/// <param name="ST_DeptID"></param>
		/// <returns></returns>
		public DataSet ST_GetAllTeacherInfo()
		{
			string sqlString = "select * from ST_TeacherInfo 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_GetStuInfoByTID(int ST_TeacherID)
		{
			string sqlString = "select * from ST_StuCourse st inner join ST_CourseInfo sc on st.ST_CourseID=sc.ST_CourseID inner join ST_StudentInfo stc on st.ST_StudentID=stc.ST_StudentID inner join ST_MajorInfo smi on stc.ST_MajorID=smi.ST_MajorID where sc.ST_TeacherID="+ST_TeacherID;
			return SqlHelper.ExecuteDataset(st_SqlString, CommandType.Text, sqlString);
		}

	}
}