?? 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: 在此處添加構(gòu)造函數(shù)邏輯
//
}
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;
}
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -