projclass.cs

手机商城是一网上购物平台 可以进行购买

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace TestOnline
{
	/// <summary>
	/// projClass 的摘要说明。
	/// </summary>
	public class projClass
	{
		private  SqlConnection myConnection;
		private SqlCommand myCommand;
		private SqlDataReader thisReader;
		private SqlDataAdapter myAdapter;
		private DataSet mySet;

		public projClass()
		{
			myConnection=new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
//		    myCommand=new SqlCommand();
//			myAdapter=new SqlDataAdapter();
//			mySet=new DataSet();
		}
		public int getUsers(string stuId,string userPwd)
		{ 
//			SqlConnection myCommand=new SqlCommand("select stuId from student where stuId='"+stuId+"'and stuPwd='"+userPwd+"'",myConnection);
			myConnection.Open();
			int count=0;
			if(thisReader.Read())
			{
				count=1;
			}
			thisReader.Close();
			myConnection.Close();
			return count;

		}
		public int ifStuExist(string stuId)
			//判断是否存在此学生!
		{
//			SqlConnection myConnection=new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
			myCommand=new SqlCommand("sp_student_selectAsId",myConnection);
			myCommand.CommandType=CommandType.StoredProcedure;
			myCommand.Parameters.Add("@stuId",SqlDbType.VarChar,15).Value=stuId;
			myConnection.Open();
		    thisReader=myCommand.ExecuteReader();
			if(thisReader.Read())
			{
				thisReader.Close();
				myConnection.Close();
				return 1;
			} 
			else 
			myConnection.Close();
			return 0;
		}
		public int ifCourseExist(string courseId,string courseName)
			//判断是否存在此课程!
		{
//			SqlConnection myConnection=new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
		    myCommand=new SqlCommand("sp_course_ifExist",myConnection);
			myCommand.CommandType=CommandType.StoredProcedure;
			myCommand.Parameters.Add("@courseId",SqlDbType.VarChar,20).Value=courseId;
			myCommand.Parameters.Add("@courseName",SqlDbType.VarChar,20).Value=courseName;
			myConnection.Open();
			thisReader=myCommand.ExecuteReader();
			if(thisReader.Read())
			{
				thisReader.Close();
				myConnection.Close();
				return 1;
			} 
			else 
				myConnection.Close();
			return 0;
		}
		public int ifteacherExist(string teacherId)
			//判断是否存在此课程!
		{
//			SqlConnection myConnection=new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
			myCommand=new SqlCommand("sp_teacher_selectInfo",myConnection);
			myCommand.CommandType=CommandType.StoredProcedure;
			myCommand.Parameters.Add("@teacherId",SqlDbType.VarChar,15).Value=teacherId;
			myConnection.Open();
			thisReader=myCommand.ExecuteReader();
			if(thisReader.Read())
		    {
				thisReader.Close();
				myConnection.Close();
				return 1;
			} 
			else 
			myConnection.Close();
			return 0;
		}
		public int ifTeacherExist(string teacherId)
			//判断是否存在此教师
		{
//			SqlConnection myConnection=new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
			myCommand=new SqlCommand("sp_teacher_selectInfo",myConnection);
			myCommand.CommandType=CommandType.StoredProcedure;
			myCommand.Parameters.Add("@teacherId",SqlDbType.VarChar,15).Value=teacherId;
			myConnection.Open();
			thisReader=myCommand.ExecuteReader();
			if(thisReader.Read())
			{
				thisReader.Close();
				myConnection.Close();
				return 1;
			} 
			else 
				thisReader.Close();
			myConnection.Close();
			return 0;
		}
		public int getUser(string stuId,string stuPwd)
		{
//			SqlConnection myConnection=new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
            myCommand=new SqlCommand("sp_student_select",myConnection);
			myCommand.CommandType=CommandType.StoredProcedure;
			myCommand.Parameters.Add("@stuId",SqlDbType.VarChar,15).Value=stuId;
            myCommand.Parameters.Add("@stuPwd",SqlDbType.VarChar,10).Value=stuPwd;
			myConnection.Open();
			thisReader=myCommand.ExecuteReader();
			
			//int count=0;//count=0说明用户名不存在
			if(thisReader.Read())
			{
				return 1;
			
			}
			thisReader.Close();
			myConnection.Close();
			return 0;

		}
		public DataSet getStuInfoAsId(string stuId)
			//根据学生的学号来查找学生
		{
//			SqlConnection myConnection=new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
			myCommand=new SqlCommand("sp_student_selectAsId",myConnection);
			myCommand.CommandType=CommandType.StoredProcedure;
			myCommand.Parameters.Add("@stuId",SqlDbType.VarChar,15).Value=stuId;
			myConnection.Open();
			myAdapter=new SqlDataAdapter(myCommand);
			DataSet ds=new DataSet();
		    myAdapter.Fill(ds,"stuInfo");
			myConnection.Close();
			return ds;
		}
		public DataSet getStuInfoAsStatus(int stuStatus)
			//根据学生的状态查找学生记录
		{
			myCommand=new SqlCommand("sp_student_selectAsStatus",myConnection);
			myCommand.CommandType=CommandType.StoredProcedure;
			myCommand.Parameters.Add("@stuStatus",SqlDbType.Int).Value=stuStatus;
			myConnection.Open();
			myAdapter=new SqlDataAdapter(myCommand);
			DataSet ds=new DataSet();
			myAdapter.Fill(ds,"stuInfo");
			myConnection.Close();
			return ds;
		}
		
		public int getAdmin(string adminId,string adminPwd)
		{
			myCommand=new SqlCommand("sp_administrator_select",myConnection);
			myCommand.CommandType=CommandType.StoredProcedure;
			myCommand.Parameters.Add("@adminId",SqlDbType.VarChar,15).Value=adminId;
			myCommand.Parameters.Add("@adminPwd",SqlDbType.VarChar,10).Value=adminPwd;
			myConnection.Open();
			thisReader=myCommand.ExecuteReader();
			
			int count=0;
			if(thisReader.Read())
			{
				count=1;
			
			}
			thisReader.Close();
			myConnection.Close();
			return count;

		}
		public int getTeacher(string teacherId,string teacherPwd)
		{
			myCommand=new SqlCommand("sp_teacher_select",myConnection);
			myCommand.CommandType=CommandType.StoredProcedure;
			myCommand.Parameters.Add("@teacherId",SqlDbType.VarChar,15).Value=teacherId;
			myCommand.Parameters.Add("@teacherPwd",SqlDbType.VarChar,10).Value=teacherPwd;
			myConnection.Open();
			thisReader=myCommand.ExecuteReader();
			
			int count=0;
			if(thisReader.Read())
			{
				count=1;
			
			}
			myConnection.Close();
			return count;

		}
	  public string getUserName(string stuId)
			//从数据库中取得学生的姓名
		{
			myCommand=new SqlCommand("sp_student_selectName",myConnection);
			myCommand.CommandType=CommandType.StoredProcedure;
			myCommand.Parameters.Add("@stuId",SqlDbType.VarChar,15).Value=stuId;
			myConnection.Open();
		    thisReader=myCommand.ExecuteReader();
		  if(thisReader.Read())
		  {
			  return thisReader[0].ToString(); 
		  }
		  else
		  myConnection.Close();
			  return "none";
		}
		public string getTeacherName(string teacherId)
			//从数据库中取得教师的姓名
		{
			myCommand=new SqlCommand("sp_teacher_selectInfo",myConnection);
			myCommand.CommandType=CommandType.StoredProcedure;
			myCommand.Parameters.Add("@teacherId",SqlDbType.VarChar,15).Value=teacherId;
			myConnection.Open();
			thisReader=myCommand.ExecuteReader();
			if(thisReader.Read())
			{
					return thisReader[2].ToString();
			  
			}
			else 
			myConnection.Close();
			return "none";
		}
		public string getTeacherCourseId(string teacherId)
			//从数据库中取得教师的所教的科目ID
		{
			myCommand=new SqlCommand("sp_teacher_selectInfo",myConnection);
			myCommand.CommandType=CommandType.StoredProcedure;
			myCommand.Parameters.Add("@teacherId",SqlDbType.VarChar,15).Value=teacherId;
			myConnection.Open();
			thisReader=myCommand.ExecuteReader();
			if(thisReader.Read())
			{
				return thisReader[3].ToString(); 
			}
			else 
			 myConnection.Close();
				return "none";
		}
		public string getTeacherIdAsCourseId(string courseId)
			//根据courseId取出老师姓名
		{
			myCommand=new SqlCommand("sp_teacher_selectAsCourseId",myConnection);
			myCommand.CommandType=CommandType.StoredProcedure;
			myCommand.Parameters.Add("@courseId",SqlDbType.VarChar,20).Value=courseId;
			myConnection.Open();
			thisReader=myCommand.ExecuteReader();
			if(thisReader.Read())
			{
				return thisReader[0].ToString();
			  
			}
			else 
			myConnection.Close();
				return "none";
		}
		public bool getIfTest(string courseId)
			//判断该科目是否可以考试
		{
			myCommand=new SqlCommand("sp_course_isTest_select",myConnection);
			myCommand.CommandType=CommandType.StoredProcedure;
			myCommand.Parameters.Add("@courseId",SqlDbType.VarChar,20).Value=courseId;
			myConnection.Open();
			thisReader=myCommand.ExecuteReader();
			if(thisReader.Read())
			{
					return thisReader.GetBoolean(0);
			  
			}
			else 
			myConnection.Close();
				return false;
		}
		public DataSet getCourses()
			//从数据库的course表中取得课程信息,从而绑定到页面的dropdownlist中
		{  
			myCommand=new SqlCommand("sp_course_selectCourses",myConnection);
			myCommand.CommandType=CommandType.StoredProcedure;
            myConnection.Open();
			myAdapter=new SqlDataAdapter(myCommand);
			mySet=new DataSet();
			myAdapter.Fill(mySet);
			myConnection.Close();
			return mySet;
		}
		public DataSet getTest(string course)
		{
			myCommand=new SqlCommand("sp_test_selectAsCourse",myConnection);
			myCommand.CommandType=CommandType.StoredProcedure;
			myCommand.Parameters.Add("@testCourse",SqlDbType.VarChar,20).Value=course;
			myConnection.Open();
			myAdapter=new SqlDataAdapter(myCommand);
			mySet=new DataSet();
			myAdapter.Fill(mySet,"testInfo");
			myConnection.Close();
			return mySet;
		}
		public DataSet getQuestionAndAns(string course)
		{
			myCommand=new SqlCommand("sp_test_select_questionAndAns",myConnection);
			myCommand.CommandType=CommandType.StoredProcedure;
			myCommand.Parameters.Add("@testCourse",SqlDbType.VarChar,20).Value=course;
			myConnection.Open();
			myAdapter=new SqlDataAdapter(myCommand);
			mySet=new DataSet();
			myAdapter.Fill(mySet);
			myConnection.Close();
			return mySet;
		}
		public DataSet getStuInfo()
			//取得学生的信息
		{
			myCommand=new SqlCommand("sp_student_selectInfo",myConnection);
			myCommand.CommandType=CommandType.StoredProcedure;
			myConnection.Open();
		//	SqlDataReader thisReader=myCommand.ExecuteReader();
			//return thisReader;
			myAdapter=new SqlDataAdapter(myCommand);
			mySet=new DataSet();
			myAdapter.Fill(mySet,"stuInfo");
			myConnection.Close();
			return mySet;
		}
		public DataSet getTeacherInfo(string teacherId)
			//取得学生的信息
		{
		    myCommand=new SqlCommand("sp_teacher_selectInfo",myConnection);
			myCommand.CommandType=CommandType.StoredProcedure;
			myCommand.Parameters.Add("@teacherId",SqlDbType.VarChar,10).Value=teacherId;
			myConnection.Open();
			
			myAdapter=new SqlDataAdapter(myCommand);
			mySet=new DataSet();
			myAdapter.Fill(mySet,"teacherInfo");
			myConnection.Close();
			return mySet;
		}
		public DataSet getScoreAsStuIdAndCourseId()
			//取得考试结果的信息
		{
			myCommand=new SqlCommand("sp_score_selectASstuIdAndCourseId",myConnection);
			myCommand.CommandType=CommandType.StoredProcedure;
			myConnection.Open();
			//	SqlDataReader thisReader=myCommand.ExecuteReader();
			//return thisReader;