//数据绑定
private void RptBind()
{
BLL.article_category bll = new BLL.article_category();
string strWhere = string.Empty;
//获取管理员
Model.manager adminModel = GetAdminInfo();
if (adminModel.role_type != 1)
{
List <int> idlist = new List <int>();
//获取频道名称
string channel_name = new BLL.channel().GetChannelName(this.channel_id);
//获取权限列表
string nav_name = "channel_" + channel_name + "_category_";
DataTable dt2 = new BLL.manager_role_value().GetList(0, string.Format("role_id={0} and action_type='Show' and nav_name like '{1}%'", adminModel.role_id, nav_name), "").Tables[0];
if (dt2.Rows.Count > 0)
{
foreach (DataRow dr in dt2.Rows)
{
idlist.Add(int.Parse(dr["nav_name"].ToString().Replace(nav_name, string.Empty)));
}
}
else
{
idlist.Add(0);
}
strWhere = string.Format("id in ({0})", string.Join(",", idlist));
}
DataTable dt = bll.GetList(0, this.channel_id, strWhere);
this.rptList.DataSource = dt;
this.rptList.DataBind();
}
private void TreeBind(int _channel_id, out string return_term)
{
BLL.article_category bll = new BLL.article_category();
return_term = string.Empty;
string strWhere = string.Empty;
//获取管理员
Model.manager adminModel = GetAdminInfo();
if (adminModel.role_type != 1)
{
List <int> idlist = new List <int>();
//获取频道名称
string channel_name = new BLL.channel().GetChannelName(this.channel_id);
//获取权限列表
string nav_name = "channel_" + channel_name + "_category_";
DataTable dt2 = new BLL.manager_role_value().GetList(0, string.Format("role_id={0} and action_type='Show' and nav_name like '{1}%'", adminModel.role_id, nav_name), "").Tables[0];
if (dt2.Rows.Count > 0)
{
foreach (DataRow dr in dt2.Rows)
{
idlist.Add(int.Parse(dr["nav_name"].ToString().Replace(nav_name, string.Empty)));
}
}
else
{
idlist.Add(0);
}
return_term = string.Join(",", idlist);
strWhere = string.Format("id in ({0})", return_term);
}
DataTable dt = bll.GetList(0, this.channel_id, strWhere);
this.ddlCategoryId.Items.Clear();
this.ddlCategoryId.Items.Add(new ListItem("所有类别", ""));
this.ddlMoveId.Items.Clear();
this.ddlMoveId.Items.Add(new ListItem("批量移动...", ""));
foreach (DataRow dr in dt.Rows)
{
string Id = dr["id"].ToString();
int ClassLayer = int.Parse(dr["class_layer"].ToString());
string Title = dr["title"].ToString().Trim();
if (ClassLayer == 1)
{
this.ddlCategoryId.Items.Add(new ListItem(Title, Id));
this.ddlMoveId.Items.Add(new ListItem(Title, Id));
}
else
{
Title = "├ " + Title;
Title = Utils.StringOfChar(ClassLayer - 1, " ") + Title;
this.ddlCategoryId.Items.Add(new ListItem(Title, Id));
this.ddlMoveId.Items.Add(new ListItem(Title, Id));
}
}
}