student_opr.cs

毕业设计题目,学生成绩查询系统,包括管理员和普通用户两级管理

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

namespace StudentScroeQuery.DAL
{
	/// <summary>
	/// Student_opr 的摘要说明。
	/// </summary>
	public class Student_opr:helper
	{
		public Student_opr()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public void add_newstudent(int num,string name,string password,DateTime birth)
		{
			comm.CommandText="insert into Student(Student_id,Student_name,Student_password,Student_birthday)values(@num,@name,@password,@birth)";
			comm.Parameters.Add("@num",SqlDbType.Int).Value=num;
			comm.Parameters.Add("@name",SqlDbType.VarChar).Value=name;
			comm.Parameters.Add("@password",SqlDbType.VarChar).Value=System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(password,"md5");
			comm.Parameters.Add("@birth",SqlDbType.DateTime).Value=birth;
			this.ExcuteCommandReturnVoid(comm);
		}
		public void add_newstudent(int num,string name,string password,string sex,string nation,DateTime birth,string home,string answer,string question,string email)
		{
			comm.CommandText="insert into Student(Student_id,Student_name,Student_password,Student＿sex,Student_nation,Student_birthday,Student_home,Student_answer,Student_question,Student_email)values(@num,@name,@password,@sex,@nation,@birth,@home,@answer,@question,@email)";
										
			comm.Parameters.Add("@num",SqlDbType.Int).Value=num;
			comm.Parameters.Add("@name",SqlDbType.VarChar).Value=name;
			comm.Parameters.Add("@password",SqlDbType.VarChar).Value=password;
			comm.Parameters.Add("@sex",SqlDbType.VarChar).Value=sex;
			comm.Parameters.Add("@nation",SqlDbType.VarChar).Value=nation;
			comm.Parameters.Add("@birth",SqlDbType.DateTime).Value=birth;
			comm.Parameters.Add("@home",SqlDbType.VarChar).Value=home;
			comm.Parameters.Add("@answer",SqlDbType.VarChar).Value=answer;
			comm.Parameters.Add("@question",SqlDbType.VarChar).Value=question;
			comm.Parameters.Add("@email",SqlDbType.VarChar).Value=email;
			this.ExcuteCommandReturnVoid(comm);
		}
		public DataSet get_allStudent()
		{
			comm.CommandText="select * from Student order by Student_id desc";
			return this.ExcuteCommandReturnDataSet(comm);
		}
		public void delstudent(int id)
		{
			this.ExcuteSqlReturnVoid("delete from Student where Student_id="+id.ToString());
		}
		public void update_student(int id,string name,string sex,string nation,string home,string email)
		{
		
			comm.CommandText="update Student set Student_id=@id,Student_name=@name,Student_sex=@sex,Student_nation=@nation,Student_home=@home,Student_email=@email where Student_id=@id";
			comm.Parameters.Add("@id",SqlDbType.Int).Value=id;
			comm.Parameters.Add("@name",SqlDbType.VarChar).Value=name;
			comm.Parameters.Add("@sex",SqlDbType.VarChar).Value=sex;
			comm.Parameters.Add("@nation",SqlDbType.VarChar).Value=nation;
			comm.Parameters.Add("@home",SqlDbType.VarChar).Value=home;
			comm.Parameters.Add("@email",SqlDbType.VarChar).Value=email;
			this.ExcuteCommandReturnVoid(comm);


		}
		//更新个人信息
		public void update_student(int id,string name,string sex,string nation,string question,string answer,string home,string email)
		{
				comm.CommandText="update Student set Student_name=@name,Student_sex=@sex,Student_nation=@nation,Student_home=@home,Student_question=@question,Student_answer=@answer,Student_email=@email where Student_id=@id";

			
			comm.Parameters.Add("@id",SqlDbType.Int).Value=id;
			comm.Parameters.Add("@name",SqlDbType.VarChar).Value=name;
			comm.Parameters.Add("@sex",SqlDbType.VarChar).Value=sex;
			comm.Parameters.Add("@nation",SqlDbType.VarChar).Value=nation;
			comm.Parameters.Add("@home",SqlDbType.VarChar).Value=home;
			comm.Parameters.Add("@email",SqlDbType.VarChar).Value=email;
			comm.Parameters.Add("@question",SqlDbType.VarChar).Value=question;
			comm.Parameters.Add("@answer",SqlDbType.VarChar).Value=answer;

			this.ExcuteCommandReturnVoid(comm);

		}
		//得到学生的个人信息
		public string[] getStudentInfo(int num)
		{
			DataSet ds=this.ExcuteSqlReturnDataSet("select * from Student where Student_id="+num.ToString());
			string[] info=new string[8];
			if(ds.Tables[0].Rows[0]!=null)
			{
				info[0]=ds.Tables[0].Rows[0]["Student_id"].ToString();
				info[1]=ds.Tables[0].Rows[0]["Student_name"].ToString();
				info[2]=ds.Tables[0].Rows[0]["Student_sex"].ToString();
				info[3]=ds.Tables[0].Rows[0]["Student_nation"].ToString();
				info[4]=ds.Tables[0].Rows[0]["Student_home"].ToString();
				info[5]=ds.Tables[0].Rows[0]["Student_question"].ToString();
				info[6]=ds.Tables[0].Rows[0]["Student_answer"].ToString();
				info[7]=ds.Tables[0].Rows[0]["Student_email"].ToString();
				

			}
			return info;
				
		}
		//判断该学号是否已经存在
		public bool NumExsited(int num)
		{
			comm.CommandText="select count(Student_id) from Student where Student_id=@num";
			comm.Parameters.Add("@num",SqlDbType.Int).Value=num;
			if(this.ExcuteCommandReturnNumber(comm)==0)
			{
				return false;
			}
			else
			{
				return true;
			}
		}
		//根据学号查出学生各科的成绩
		public DataSet getScore(int num)
		{
			comm.CommandText="select Score_Num,Course_Name from Score,Course where Score.Score_Student=@num and Score.Score_Course=Course.Course_Id";
			comm.Parameters.Add("@num",SqlDbType.Int).Value=num;

			return this.ExcuteCommandReturnDataSet(comm);
		}
	}
}