📄 bteacherability.cs
字号:
using System;
using System.Collections;
using System.Collections.Generic;
using System.Text;
using Entities;
namespace BLL
{
public class BTeacherAbility
{
//通过TeachPlan_ID查找员工信息
public ArrayList Select(object TeachPlan_ID)
{
Entities.TeachPlan eTeachPlan = new BLL.BTeachPlan().GetEntities(TeachPlan_ID);
ArrayList teachers = new ArrayList();
Search.TeacherAbilitySearcher sTeacherAbilitySearcher = new Search.TeacherAbilitySearcher();
sTeacherAbilitySearcher.CourseID = eTeachPlan.CourseID;
sTeacherAbilitySearcher.CourseIDIsValid = true;
DAL.IDTeacherAbility dTeacherAbility = DALContainer.Factory.GetIDTeacherAbility();
ArrayList list=dTeacherAbility.Select(sTeacherAbilitySearcher);
foreach (TeacherAbility ability in list)
{
teachers.Add(ability.Employee);
}
return teachers;
}
//通过teacherid查找课程信息
public ArrayList SelectCourse(object teacherid)
{
Search.TeacherAbilitySearcher Searcher = new Search.TeacherAbilitySearcher();
Searcher.TeacherID = Convert.ToInt32(teacherid);
Searcher.TeacherIDIsValid = true;
DAL.IDTeacherAbility dTeacherAbility = DALContainer.Factory.GetIDTeacherAbility();
ArrayList aTeacherAbility = dTeacherAbility.Select(Searcher);
ArrayList aCourse = new BLL.BCourse().Select() ;
ArrayList list = new ArrayList();
foreach (Course course in aCourse)
{
bool flag = false;
foreach (TeacherAbility teacherAbility in aTeacherAbility)
{
if (teacherAbility.CourseID == course.CourseID)
{
flag = true;
break;
}
}
cbkCourse cc = new cbkCourse();
cc.CourseID = course.CourseID;
cc.CourseName = course.CourseName;
cc.CourseColor = course.CourseColor;
cc.Term = course.Term;
cc.TermID = course.TermID;
cc.TimeSpan = course.TimeSpan;
if (flag)
{
cc.CBK = true;
}
else
{
cc.CBK = false;
}
list.Add(cc);
}
return list;
}
public int Insert(Entities.TeacherAbility eTeacherAbility)
{
DAL.IDTeacherAbility dTeacherAbility = DALContainer.Factory.GetIDTeacherAbility();
return dTeacherAbility.Insert(eTeacherAbility);
}
public int Delete(Search.TeacherAbilitySearcher searcher)
{
DAL.IDTeacherAbility dTeacherAbility = DALContainer.Factory.GetIDTeacherAbility();
return dTeacherAbility.Delete(searcher);
}
public ArrayList Select()
{
ArrayList aTeacherAbility = new ArrayList();
//获取所有教员
DAL.IDEmployee dEmp = DALContainer.Factory.GetIDEmployee();
Search.EmployeeSearcher searcher = new Search.EmployeeSearcher();
searcher.DepartmentID = 1;
searcher.DepartmentIDIsValid = true;
searcher.IsValid = true;
searcher.IsValidIsValid = true;
ArrayList aTeacher = dEmp.Select(searcher);
//获取教师以有授课能力
DAL.IDTeacherAbility dTeacherAbility = DALContainer.Factory.GetIDTeacherAbility();
foreach (Entities.Employee eEmployee in aTeacher)
{
Search.TeacherAbilitySearcher search = new Search.TeacherAbilitySearcher();
search.TeacherID = eEmployee.EmployeeID;
search.TeacherIDIsValid = true;
ArrayList aTeacherIDAbility = new ArrayList() ;
aTeacherIDAbility = dTeacherAbility.Select(search);
if (aTeacherIDAbility.Count > 0)
{
//遍历实体
foreach (Entities.TeacherAbility eTeacherAbility in aTeacherIDAbility)
{
string courses = "";
bool flag = false;
//通过遍历aTeacherAbility,判断aTeacherAbility中是否有存在
foreach (Teach_Course_info tcinfo in aTeacherAbility)
{
if (tcinfo.TeacherID == eTeacherAbility.TeacherID)
{
flag = true;
break;
}
}
if (flag)
continue;
foreach (Entities.TeacherAbility eTeacherAbility2 in aTeacherIDAbility)
{
if (eTeacherAbility.TeacherID == eTeacherAbility2.TeacherID)
{
courses += "," + eTeacherAbility2.Course.CourseName;
}
}
courses = courses.Substring(1);
Teach_Course_info info = new Teach_Course_info();
info.TeacherID = eTeacherAbility.TeacherID;
info.Employee = eTeacherAbility.Employee;
info.Courses = courses;
aTeacherAbility.Add(info);
}
aTeacherIDAbility.Clear();
}
else
{
Teach_Course_info info = new Teach_Course_info();
info.TeacherID = eEmployee.EmployeeID;
info.Employee = eEmployee;
info.Courses = "";
aTeacherAbility.Add(info);
}
}
return aTeacherAbility;
}
}
public class Teach_Course_info
{
private int teacherID;
private Entities.Employee employee;
private string courses;
public int TeacherID
{
get
{
return teacherID;
}
set
{
teacherID = value;
}
}
public Entities.Employee Employee
{
get
{
return employee;
}
set
{
employee = value;
}
}
public string Courses
{
get
{
return courses;
}
set
{
courses = value;
}
}
}
public class cbkCourse:Course
{
private bool cbk;
public bool CBK
{
get
{
return cbk;
}
set
{
cbk = value;
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -