using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;
using?System.Data;
using?Entity;
using?DataAccess;

namespace?Business
{
????public?class?AdminBusiness
????{
????????///?

????????///?
????????///?

????????///?
????????///?
????????///?
????????public?static?DataTable?TeacherSearchbyName（string?tablenamestring?condition）
????????{
????????????string[]?names?=?new?string[]?{?“tablename“?“condition“?};
????????????object[]?values?=?new?object[]?{?tablename?condition?};
????????????return?DataAccess.Operations.GetDataTable（“sp_TeacherSearchbyName“?CommandType.StoredProcedure）;
????????}
????????///?

????????///?判斷教師ID是否存在如果存在返回1，否則返回0
????????///?

????????///?教師信息
????????///?如果存在返回1，否則返回0
????????public?static?int?TeacherIsExistbyID（Entity.TeacherInfo?t）
????????{
????????????string[]?names?=?new?string[]?{?“TeacherID“?};
????????????object[]?values?=?new?object[]?{?t.TeacherID?};

????????????string?outpara?=?“result“;
????????????SqlDbType?outtype?=?SqlDbType.Int;
????????????object?outvalue?=?null;

????????????DataAccess.Operations.ExecuteSQL（“sp_TeacherIsExistbyID“?CommandType.StoredProcedure?names?values?outpara?outtype?out?outvalue）;
????????????return?Convert.ToInt32（outvalue）;
????????}
????????///?

????????///?從管理員的角度執行新增教師操作，僅添加部分信息。添加成功返回1，否則返回0。
????????///?

????????///?教師信息
????????///?添加成功返回1，否則返回0
????????public?static?int?TeacherInsertNew（Entity.TeacherInfo?t）
????????{
????????????string[]?names?=?new?string[]?{?“teacherid“?“teachername“?“password“?“titleid““roleid“?“officeid“?“authorizedid“?};
????????????object[]?values?=?new?object[]?{?t.TeacherID?t.TeacherName?t.Password?t.titleID?t.RoleID?t.OfficeID?t.AuthorizedID?};

????????????return?DataAccess.Operations.ExecuteSQL（“sp_TeacherInsertNew_Admin“?CommandType.StoredProcedure?names?values）;
????????}
????????///?

????????///?從管理員的角度執行更新教師信息操作。僅更新部分信息。更新成功返回1，否則返回0
????????///?

????????///?教師信息
????????///?更新成功返回1，否則返回0。
????????public?static?int?TeacherUpdatebyID（Entity.TeacherInfo?t）
????????{
????????????string[]?names?=?new?string[]?{?“teacherid“?“teachername“?“titleid““roleid“?“officeid“?“authorizedid“?};
????????????object[]?values?=?new?object[]?{?t.TeacherID?t.TeacherName?t.titleID?t.RoleID?t.OfficeID?t.AuthorizedID?};

????????????return?DataAccess.Operations.ExecuteSQL（“sp_TeacherUpdatebyID_Admin“?CommandType.StoredProcedure?names?values）;
????????}
????????///?

????????///?從管理員的角度執行刪除教師信息操作。刪除成功返回1，否則返回0
????????///?

????????///?教師信息
????????///?刪除成功返回1，否則返回0