studentsystemdb.cs

教务管理系统 基于.net和sqlserver2000的教务管理系统

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

namespace Park.Common
{
	/// <summary>
	/// StudentSystemDB 的摘要说明。
	/// </summary>
	public class StudentSystemDB
	{
		public static int AddClass(string studentid,string classid)
		{
			SqlConnection myConnection=Utils.GetConnection();

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

			// Mark the Command as a SPROC
			myCommand.CommandType = CommandType.StoredProcedure;

			// Add Parameters to SPROC
			SqlParameter StudentID = new SqlParameter("@studentid", SqlDbType.NVarChar, 20);
			StudentID.Value = studentid;
			myCommand.Parameters.Add(StudentID);

			// Add Parameters to SPROC
			SqlParameter ClassID = new SqlParameter("@classid", SqlDbType.Int);
			ClassID.Value = classid;
			myCommand.Parameters.Add(ClassID);

			// Add Parameters to SPROC
			SqlParameter retval = new SqlParameter("@retval", SqlDbType.Int);
			retval.Direction = ParameterDirection.Output;
			myCommand.Parameters.Add(retval);

			// Execute the command
			myConnection.Open();

			myCommand.ExecuteNonQuery();		

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

			return  (int)retval.Value;
		}

		public static int DeleteClass(string studentid, string classid)
		{
			SqlConnection myConnection=Utils.GetConnection();

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

			// Mark the Command as a SPROC
			myCommand.CommandType = CommandType.StoredProcedure;

			// Add Parameters to SPROC
			SqlParameter StudentID = new SqlParameter("@studentid", SqlDbType.NVarChar, 20);
			StudentID.Value = studentid;
			myCommand.Parameters.Add(StudentID);

			// Add Parameters to SPROC
			SqlParameter ClassID = new SqlParameter("@classid", SqlDbType.Int);
			ClassID.Value = classid;
			myCommand.Parameters.Add(ClassID);

			// Add Parameters to SPROC
			SqlParameter retval = new SqlParameter("@retval", SqlDbType.Int);
			retval.Direction = ParameterDirection.Output;
			myCommand.Parameters.Add(retval);

			// Execute the command
			myConnection.Open();

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

			return (int)retval.Value;
		}

	}
}