/// <summary>
/// 获取教学楼id
/// </summary>
void GetBuiding()
{
DataTable Class = new DataTable();
CourseBuildingBLL BLL = new CourseBuildingBLL();
Class = BLL.GETSome();
Building_id.DataSource = Class;
Building_id.DisplayMember = "Building_Id";
treeLoad(Teacher);
}
/// <summary>
/// 系楼改变的时候 教室改变
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Building_id_SelectedValueChanged(object sender, EventArgs e)
{
try
{
DataTable dt = new DataTable();
string Class = Building_id.Text;
CourseBuildingBLL bll = new CourseBuildingBLL();
dt = bll.SelectSome(Class);
//dt = bll.SelectSome(Class);
ClassRoom.DataSource = dt;
ClassRoom.DisplayMember = "Name";
ClassRoom.ValueMember = "Classroom_Id";
}
catch (Exception)
{
return;
}
}
/// <summary>
/// 初始化树形导航 将院系课程和老师显示出来
/// </summary>
/// <param name="TV"></param>
public static void treeLoad(TreeView TV)
{
DataTable ds;
CourseBuildingBLL bll = new CourseBuildingBLL();
ds = bll.GetNode1();
foreach (DataRow dr in ds.Rows)
{
TreeNode newNode = new TreeNode(dr[0].ToString(), 0, 1);
TV.Nodes.Add(newNode);
DataTable dy;
string name1 = dr[0].ToString();
dy = bll.GetNode2(name1);
foreach (DataRow du in dy.Rows)
{
TreeNode Node = new TreeNode(du[0].ToString(), 0, 1);
newNode.Nodes.Add(Node);
}
}
}
/// <summary>
/// 选定 树形导航来填充信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Teacher_AfterSelect(object sender, TreeViewEventArgs e)
{
CourseBuildingBLL bll = new CourseBuildingBLL();
DataTable dt = new DataTable();
string Major;
TreeNode SelectNode = Teacher.SelectedNode; //获取当前选中的节点
if (SelectNode != null)
{
TreeNode ParentNode = SelectNode.Parent;
if (ParentNode != null)
{
Course.Text = "";
dt = bll.GetCourse1(ParentNode.Text);
this.Course.DataSource = dt;
this.Course.DisplayMember = "Course";
this.Course.ValueMember = "Course_Id";
Major = bll.GetMajor(SelectNode.Text);
this.Teacher1.Text = SelectNode.Text;
this.Major1.Text = Major;
}
}
}
/// <summary>
/// 获取院系
/// </summary>
/// <returns></returns>
public string getbuilding1()
{
CourseBuildingBLL bll = new CourseBuildingBLL();
return(bll.getbuilding1(building.Class.Text));
}
/// <summary>
/// 获得老师专业
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
private string GetMajor(string name)
{
CourseBuildingBLL bll = new CourseBuildingBLL();
return(bll.GetMajor(name));
}
