st_student.cs

学生选棵系统

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

namespace STGROUP.ST_CourseBiz
{
	/// <summary>
	/// Class1 的摘要说明。
	/// </summary>
	public class ST_Student
	{
		string st_SqlString = System.Configuration.ConfigurationSettings.AppSettings["ConnString"];
		public ST_Student()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}

		/// <summary>
		/// 插入学生基本信息
		/// </summary>
		/// <param name="st_StuInfo"></param>
		public void ST_InsertStudentInfo(ST_StudentEntity st_StuInfo)
		{
			SqlParameter[] parms =  SqlHelperParameterCache.GetSpParameterSet(st_SqlString, "ST_InsertStudentInfo", false);
			parms[0].Value = st_StuInfo.ST_StudentName;
			parms[1].Value = st_StuInfo.ST_StudentNumber;
			parms[2].Value = st_StuInfo.ST_StudentGender;
			parms[3].Value = st_StuInfo.ST_DeptID;
			parms[4].Value = st_StuInfo.ST_MajorID;

			SqlHelper.ExecuteNonQuery(st_SqlString, "ST_InsertStudentInfo", parms);
		}

		/// <summary>
		/// 修改学生基本信息
		/// </summary>
		/// <param name="st_StuInfo"></param>
		public void ST_UpdateStudentInfo(ST_StudentEntity st_StuInfo)
		{
			SqlParameter[] parms =  SqlHelperParameterCache.GetSpParameterSet(st_SqlString, "ST_UpdateStudentInfo", false);
			parms[0].Value = st_StuInfo.ST_StudentID;
			parms[1].Value = st_StuInfo.ST_StudentName;
			parms[2].Value = st_StuInfo.ST_StudentNumber;
			parms[3].Value = st_StuInfo.ST_StudentGender;
			parms[4].Value = st_StuInfo.ST_DeptID;
			parms[5].Value = st_StuInfo.ST_MajorID;

			SqlHelper.ExecuteNonQuery(st_SqlString, "ST_UpdateStudentInfo", parms);
		}
		/// <summary>
		/// 删除一个学生的信息
		/// </summary>
		/// <param name="st_StuID"></param>
		public void ST_DeleteStudentInfo(int st_StuID)
		{
			string sqlString = "update ST_StudentInfo set ST_IsDeleted=1 where ST_StudentID="+st_StuID;
			SqlHelper.ExecuteNonQuery(st_SqlString, CommandType.Text, sqlString);
		}

		/// <summary>
		/// 插入一条学生选课记录
		/// </summary>
		/// <param name="st_StuID"></param>
		/// <param name="st_Course"></param>
		public void ST_InsertStudentCourse(int st_StuID, int st_CourseID)
		{
			string sqlString = "insert ST_StuCourse(ST_StudentID,ST_CourseID) values("+st_StuID+","+st_CourseID+")";
			SqlHelper.ExecuteNonQuery(st_SqlString, CommandType.Text, sqlString);
		}
		/// <summary>
		/// 删除一条学生选课记录
		/// </summary>
		/// <param name="st_StuID"></param>
		/// <param name="st_Course"></param>
		public void ST_DeleteStudentCourse(int st_StuID, int st_CourseID)
		{
			string sqlString = "delete from ST_StuCourse where ST_StudentID="+st_StuID+" and ST_CourseID="+st_CourseID;
			SqlHelper.ExecuteNonQuery(st_SqlString, CommandType.Text, sqlString);
		}

		/// <summary>
		/// 查询一个学生选课记录
		/// </summary>
		/// <param name="st_StuID"></param>
		/// <param name="st_Course"></param>
		public DataTable ST_GetStudentCourse(int st_StuID)
		{
			DataTable dt = null;
			string sqlString = "select * from ST_StuCourse st inner join ST_CourseInfo sc on st.ST_CourseID=sc.ST_CourseID where ST_StudentID="+st_StuID;
			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_GetStudentInfo(int ST_StudentID)
		{
			string sqlString = "select * from ST_StudentInfo sti inner join ST_DeptInfo sdi on sti.ST_DeptID=sdi.ST_DeptID inner join dbo.ST_MajorInfo smi on sti.ST_MajorID=smi.ST_MajorID where sti.ST_IsDeleted=0 and sdi.ST_IsDeleted=0 and smi.ST_IsDeleted=0 and ST_StudentID="+ST_StudentID;
			return SqlHelper.ExecuteDataset(st_SqlString, CommandType.Text, sqlString);
		}
		/// <summary>
		/// 取得学生的信息
		/// </summary>
		/// <param name="ST_DeptID"></param>
		/// <returns></returns>
		public DataSet ST_GetAllStudentInfo()
		{
			string sqlString = "select * from ST_StudentInfo sti inner join ST_DeptInfo sdi on sti.ST_DeptID=sdi.ST_DeptID inner join dbo.ST_MajorInfo smi on sti.ST_MajorID=smi.ST_MajorID where sti.ST_IsDeleted=0 and sdi.ST_IsDeleted=0 and smi.ST_IsDeleted=0";
			return SqlHelper.ExecuteDataset(st_SqlString, CommandType.Text, sqlString);
		} 

		/// <summary>
		/// 通过专业查询一个学生没有选的课
		/// </summary>
		/// <param name="st_StuID"></param>
		/// <param name="st_Course"></param>
		public DataTable ST_GetStudentUnCourse(int st_StuID, int st_MajorID)
		{
			DataTable dt = null;
			string sqlString = "select * from dbo.ST_CourseInfo inner join dbo.ST_TeacherInfo on ST_CourseInfo.ST_TeacherID=ST_TeacherInfo.ST_TeacherID where ST_MajorID="+st_MajorID+" and st_courseID not in(select st_courseID from ST_StuCourse where ST_StudentID="+st_StuID+")";
			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_StuID"></param>
		/// <param name="st_Course"></param>
		public DataTable ST_GetStudentCourse(int st_StuID, int st_MajorID)
		{
			DataTable dt = null;
			string sqlString = "select * from ST_StuCourse st inner join ST_CourseInfo sc on st.ST_CourseID=sc.ST_CourseID inner join ST_TeacherInfo sti on sc.ST_TeacherID=sti.ST_TeacherID inner join ST_MajorInfo sm on sc.ST_MajorID = sm.ST_MajorID where ST_StudentID="+st_StuID+" and sc.ST_MajorID="+st_MajorID;
			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_StuInfo"></param>
		public void ST_UpdateStudentPass(string st_StuPass,int st_StuID,int st_type)
		{
			string sqlString = "update st_users set ST_Pass='"+st_StuPass+"' where ST_ID="+st_StuID+" and ST_Type="+st_type;
			SqlHelper.ExecuteNonQuery(st_SqlString, CommandType.Text, sqlString);
		}

		/// <summary>
		/// 修改学生密码
		/// </summary>
		/// <param name="st_StuInfo"></param>
		public string ST_GetStudentPass(int st_StuID)
		{
			string sqlString = "select ST_Pass from st_users where ST_ID="+st_StuID;
			object obj = SqlHelper.ExecuteScalar(st_SqlString, CommandType.Text, sqlString);
			return obj.ToString();
		}



	}
}