memberdb.cs

电子选课系统 电子选课系统电子选课系统电子选课系统

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

namespace Park.Common
{
	/// <summary>
	/// MemberDB 的摘要说明。
	/// </summary>
	public class MemberDB
	{

		public static bool AddTeacher(string userid,string name,string email,string prof)
		{
			SqlConnection myConnection=Utils.GetConnection();

			SqlCommand myCommand = new SqlCommand("Member_Add_Teacher", myConnection);

			// 
			myCommand.CommandType = CommandType.StoredProcedure;

			// 添加参数
			SqlParameter UserId = new SqlParameter("@id", SqlDbType.NVarChar, 20);
			UserId.Value = userid;
			myCommand.Parameters.Add(UserId);

			// 添加参数
			SqlParameter Name = new SqlParameter("@name", SqlDbType.Char, 10);
			Name.Value = name;
			myCommand.Parameters.Add(Name);

			// 添加参数
			SqlParameter Email = new SqlParameter("@email", SqlDbType.VarChar, 50);
			Email.Value = email;
			myCommand.Parameters.Add(Email);

			// 添加参数
			SqlParameter Prof = new SqlParameter("@prof", SqlDbType.Char, 10);
			Prof.Value = prof;
			myCommand.Parameters.Add(Prof);

			// 添加参数
			SqlParameter retval = new SqlParameter("@retval", SqlDbType.Int);
			retval.Direction = ParameterDirection.Output;
			myCommand.Parameters.Add(retval);

			// 执行存储过程
			myConnection.Open();

				try
				{
					myCommand.ExecuteNonQuery();
				}
				catch(Exception )
				{
					myCommand.Dispose();
					myConnection.Dispose();
					return false;
				}
				

			myCommand.Dispose();
			myConnection.Dispose();

			return  retval.Value.Equals(1);
		}

		public static bool EditTeacher(string userid,string name, string email, string prof)
		{
			SqlConnection myConnection=Utils.GetConnection();

			SqlCommand myCommand = new SqlCommand("Member_Update_Teacher", myConnection);

			// 
			myCommand.CommandType = CommandType.StoredProcedure;

			// 添加参数
			myCommand.Parameters.Add(new SqlParameter("@id",	 SqlDbType.NVarChar, 20));
			myCommand.Parameters.Add(new SqlParameter("@name",	 SqlDbType.Char,	 10));
			myCommand.Parameters.Add(new SqlParameter("@email",	 SqlDbType.VarChar,  50));
			myCommand.Parameters.Add(new SqlParameter("@prof",	 SqlDbType.Char,	 10));
			myCommand.Parameters.Add(new SqlParameter("@retval", SqlDbType.Int));
			myCommand.Parameters["@id"].Value			= userid;
			myCommand.Parameters["@name"].Value			= name;
			myCommand.Parameters["@email"].Value		= email;
			myCommand.Parameters["@prof"].Value			= prof;
			myCommand.Parameters["@retval"].Direction	= ParameterDirection.Output;

			// 执行存储过程
			myConnection.Open();

			try
			{
				myCommand.ExecuteNonQuery();
			}
			catch(Exception )
			{
				myCommand.Dispose();
				myConnection.Dispose();
				return false;
			}
				

			myCommand.Dispose();
			myConnection.Dispose();

			return  myCommand.Parameters["@retval"].Value.Equals(1);
		}


		public static void DeleteTeacher(string userid)
		{
			SqlConnection myConnection=Utils.GetConnection();

			SqlCommand myCommand = new SqlCommand("Member_Delete_Teacher", myConnection);

			// 
			myCommand.CommandType = CommandType.StoredProcedure;

			// 添加参数
			SqlParameter UserId = new SqlParameter("@id", SqlDbType.NVarChar, 20);
			UserId.Value = userid;
			myCommand.Parameters.Add(UserId);

			// 执行存储过程
			myConnection.Open();

			myCommand.ExecuteNonQuery();
			myCommand.Dispose();
			myConnection.Dispose();

			return ;
		}

		public static bool AddStudent(string userid,string name,string classname)
		{
			SqlConnection myConnection=Utils.GetConnection();

			SqlCommand myCommand = new SqlCommand("Member_Add_Student", myConnection);

			// 
			myCommand.CommandType = CommandType.StoredProcedure;

			// 添加参数
			SqlParameter UserId = new SqlParameter("@id", SqlDbType.NVarChar, 20);
			UserId.Value = userid;
			myCommand.Parameters.Add(UserId);

			// 添加参数
			SqlParameter Name = new SqlParameter("@name", SqlDbType.Char, 10);
			Name.Value = name;
			myCommand.Parameters.Add(Name);

			// 添加参数
			SqlParameter ClassName = new SqlParameter("@classname", SqlDbType.VarChar, 30);
			ClassName.Value = classname;
			myCommand.Parameters.Add(ClassName);

			// 添加参数
			SqlParameter retval = new SqlParameter("@retval", SqlDbType.Int);
			retval.Direction = ParameterDirection.Output;
			myCommand.Parameters.Add(retval);

			// 执行存储过程
			myConnection.Open();
			try
			{
			myCommand.ExecuteNonQuery();

			}
			catch(Exception )
			{
				myCommand.Dispose();
				myConnection.Dispose();
				return false;
			}
				
			myCommand.Dispose();
			myConnection.Dispose();

			return  retval.Value.Equals(1);
		}

		public static bool EditStudent(string userid,string name,string classname)
		{
			SqlConnection myConnection=Utils.GetConnection();

			SqlCommand myCommand = new SqlCommand("Member_Update_Student", myConnection);

			// 
			myCommand.CommandType = CommandType.StoredProcedure;

			// 添加参数
			myCommand.Parameters.Add(new SqlParameter("@id",		SqlDbType.NVarChar, 20));
			myCommand.Parameters.Add(new SqlParameter("@name",		SqlDbType.Char,	 10));
			myCommand.Parameters.Add(new SqlParameter("@classname", SqlDbType.VarChar,  30));
			myCommand.Parameters.Add(new SqlParameter("@retval",	SqlDbType.Int));
			myCommand.Parameters["@id"].Value			= userid;
			myCommand.Parameters["@name"].Value			= name;
			myCommand.Parameters["@classname"].Value	= classname;
			myCommand.Parameters["@retval"].Direction	= ParameterDirection.Output;

			// 执行存储过程
			myConnection.Open();

			try
			{
				myCommand.ExecuteNonQuery();
			}
			catch(Exception )
			{
				myCommand.Dispose();
				myConnection.Dispose();
				return false;
			}
				

			myCommand.Dispose();
			myConnection.Dispose();

			return  myCommand.Parameters["@retval"].Value.Equals(1);
		}


		public static void DeleteStudent(string userid)
		{
			SqlConnection myConnection=Utils.GetConnection();

			SqlCommand myCommand = new SqlCommand("Member_Delete_Student", myConnection);

			// 
			myCommand.CommandType = CommandType.StoredProcedure;

			// 添加参数
			SqlParameter UserId = new SqlParameter("@id", SqlDbType.NVarChar, 20);
			UserId.Value = userid;
			myCommand.Parameters.Add(UserId);

			// 执行存储过程
			myConnection.Open();

			myCommand.ExecuteNonQuery();
			myCommand.Dispose();
			myConnection.Dispose();

			return ;
		}

	}
}