private void TreeBind(int userID)
{
Spread.BLL.Tag cbll = new Spread.BLL.Tag();
DataTable dt = bllChannel.GetList(" UserID='" + userID.ToString() + "'").Tables[0];
ddlChanel.DataSource = dt;
ddlChanel.DataTextField = "Title";
ddlChanel.DataValueField = "ID";
ddlChanel.DataBind();
ListItem item = new ListItem("汇总", "0");
ddlChanel.Items.Insert(0, item);
}
//绑定类别
private void TreeBind()
{
Spread.BLL.Tag cbll = new Spread.BLL.Tag();
DataTable dt = cbll.GetList(" TagCategoryID=6").Tables[0];
ddlClassId.DataSource = dt;
ddlClassId.DataTextField = "Name";
ddlClassId.DataValueField = "ID";
ddlClassId.DataBind();
ListItem item = new ListItem("请选择所属类型...", "0");
ddlClassId.Items.Insert(0, item);
}
//绑定年份
private void YearBind()
{
Spread.BLL.Tag cbll = new Spread.BLL.Tag();
DataTable dt = cbll.GetList(" TagCategoryID=5").Tables[0];
ddlYear.DataSource = dt;
ddlYear.DataTextField = "Name";
ddlYear.DataValueField = "Name";
ddlYear.DataBind();
ListItem item = new ListItem("请选择所属年份...", "0");
ddlYear.Items.Insert(0, item);
}
private void TreeBind(int userID)
{
Spread.BLL.Tag cbll = new Spread.BLL.Tag();
DataTable dt = bllMenu.GetList("").Tables[0];
ddlMenu.DataSource = dt;
ddlMenu.DataTextField = "Title";
ddlMenu.DataValueField = "ID";
ddlMenu.DataBind();
ListItem item = new ListItem("汇总", "0");
ddlMenu.Items.Insert(0, item);
}
public string GetMenuTitle(int classid)
{
Spread.BLL.Tag cbll = new Spread.BLL.Tag();
DataTable dt = cbll.GetList(" ID=" + classid + "").Tables[0];
if (dt.Rows.Count > 0)
{
return dt.Rows[0]["Name"].ToString();
}
else { return ""; }
}
