/// <summary>
/// 根据专业ID绑定班级
/// </summary>
/// <param name="specid"></param>
void BinderClasses(string specid)
{
islock = true;
DataTable Speciality = TreeViewBLL.GetClassesBLL(specid);
this.cmbBoxClass.DataSource = Speciality;
this.cmbBoxClass.DisplayMember = "Classes_Name";
this.cmbBoxClass.ValueMember = "Classes_ID";
islock = false;
}
void BinderSpeciality(string collegeid)
{
islock = true;
DataTable Speciality = TreeViewBLL.GetSpecBLL(collegeid);
this.cmbBoxSpeciality.DataSource = Speciality;
this.cmbBoxSpeciality.DisplayMember = "Speciality_Name";
this.cmbBoxSpeciality.ValueMember = "Speciality_ID";
islock = false;
}
void BinderColleges()
{
islock = true;
DataTable colleges = TreeViewBLL.GetCollegesBLL();
this.cmbBoxCollege.DataSource = colleges;
this.cmbBoxCollege.DisplayMember = "College_Name";
this.cmbBoxCollege.ValueMember = "College_ID";
islock = false;
}
//安置
protected string WangLuoTu(string bianhao, string tree, int state, int cengshu, int qishu, string storeid)
{
//获得存储过程产生的树
int type = 0;//公司查看网络图
DataTable table = new TreeViewBLL().GetExtendTreeView_NewAz(bianhao, tree, cengshu, qishu, type, 0);
string str = "";
//循环拼出树
str = "<table id='tab_tr' border=\"0\" cellspacing=\"0\" cellpadding=\"0\" class='tree_grid'>";
str += "<tr>"
+ "<th align='center'>会员编号</th>"
+ "<th align='center' >层数</th>"
+ "<th align='center'>级别</th>"
+ "<th align='right'>新个分数</th>"
+ "<th align='right'>新网分数</th>"
+ "<th align='right'>新网人数</th>"
+ "<th align='right' >总网人数</th>"
+ "<th align='right' >总网分数</th>"
+ "</tr>";
int count = 0;
foreach (DataRow row in table.Rows)
{
count++;
string strStyle = "";
if (count % 2 == 0)
{
strStyle = "background-color:#F1F4F8";;
}
else
{
strStyle = " background-color:#FAFAFA";
}
str += "<tr style='" + strStyle + "' class=\"tr\" id='tr" + row["bh"].ToString() + "' onmousedown=\"down_tw(event,this)\">";
str += "<td valing='middle'>" + row["htmltree"].ToString().Replace("─", "<img src='../images/011.gif' align=absmiddle border=0 />").Replace("☆", "<img src='../images/013.gif' align=absmiddle border=0 />").Replace("★", "<img src='../images/014.gif' align=absmiddle border=0 />").Replace("├", "<img src='../images/006.gif' align=absmiddle border=0 />").Replace("└", "<img src='../images/003.gif' align=absmiddle border=0 />").Replace("~", "<img src='../images/015.gif' align=absmiddle border=0 />").Replace("|", "<img src='../images/004.gif' align=absmiddle border=0 />") + "<img src='../images/1.png' class='img' align=absmiddle border=0 /></td>";
str += "<td align='center' valing='middle' title='层数'>" + row["cw"].ToString() + "</td>";
str += "<td align='left' valing='middle' title='级别'>" + row["level"].ToString() + "</td>";
str += "<td align='right' valing='middle' title='新个分数'>" + row["CurrentOneMark"].ToString() + "</td>";
str += "<td align='right' valing='middle' title='新网分数'>" + row["CurrentTotalNetRecord"].ToString() + "</td>";
str += "<td align='right' valing='middle' title='新网人数'>" + row["CurrentNewNetNum"].ToString() + "</td>";
str += "<td align='right' valing='middle' title='总网人数'>" + row["TotalNetNum"].ToString() + "</td>";
str += "<td align='right' valing='middle' title='总网分数'>" + row["TotalNetRecord"].ToString() + "</td>";
str += "</tr>";
}
str += "</table>";
return(str);
}
void bindTreeView()
{
try
{
DataTable colleges = TreeViewBLL.GetCollegesBLL();
tvColleges.Nodes.Clear();
foreach (DataRow row in colleges.Rows)
{
TreeNode tn = new TreeNode(row["College_Name"].ToString());
tn.Name = row["College_ID"].ToString();
tn.Tag = "colleges";
tvColleges.Nodes.Add(tn);
DataTable speciality = TreeViewBLL.GetSpecBLL(row["College_ID"].ToString());
foreach (DataRow specrow in speciality.Rows)
{
TreeNode spec = new TreeNode(specrow["Speciality_Name"].ToString());
spec.Name = specrow["Speciality_ID"].ToString();
spec.Tag = "Speciality";
tn.Nodes.Add(spec);
DataTable classes = TreeViewBLL.GetClassesBLL(specrow["Speciality_ID"].ToString());
foreach (DataRow classrow in classes.Rows)
{
TreeNode classe = new TreeNode(classrow["Classes_Name"].ToString());
classe.Name = classrow["Classes_ID"].ToString();
classe.Tag = "Classes";
spec.Nodes.Add(classe);
}
}
}
}
catch (Exception)
{
MessageBox.Show("异常！");
}
}