addteacher.cs

排课系统

using System;
using System.Data.SqlClient;
using System.Data;
namespace PK
{
	/// <summary>
	/// AddTeacher 的摘要说明。
	/// </summary>
	public class AddTeacher:Connection
	{
		private SqlConnection connConnection;
		public SqlConnection getConnection
		{
			get
			{
				return new SqlConnection(this.getConnectionString);
			}
			set
			{
			}
		}
		public AddTeacher()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public void Open()
		{
			connConnection = this.getConnection;
			connConnection.Open();
		}
		public void Close()
		{
			connConnection.Close();
		}
		public bool AddTeacherInfo(string teacherNo,string teacherName)
		{
			SqlCommand command = new SqlCommand("addTeacher",this.connConnection);
			command.CommandType = CommandType.StoredProcedure;
			SqlParameter TeacherNo = new SqlParameter("@teacherNo",SqlDbType.VarChar,20);
			TeacherNo.Value = teacherNo;
			command.Parameters.Add(TeacherNo);
			SqlParameter TeacherName = new SqlParameter("@teacherName",SqlDbType.VarChar,20);
			TeacherName.Value = teacherName;
			command.Parameters.Add(TeacherName);
			try
			{
				command.ExecuteNonQuery();
				return true;
			}
			catch
			{
				return false;
			}
		}
		public bool DeleteTeacherInfo(string teacherNo)
		{
			SqlCommand command = new SqlCommand("deleteTeacher",this.connConnection);
			command.CommandType = CommandType.StoredProcedure;
			SqlParameter TeacherNo = new SqlParameter("@teacherNo",SqlDbType.VarChar,20);
			TeacherNo.Value = teacherNo;
			command.Parameters.Add(TeacherNo);
			try
			{
				command.ExecuteNonQuery();
				return true;
			}
			catch
			{
				return false;
			}
		}
	}
}