c# 后台绑定treeview 多个tab
2024-08-25 06:21:17
<wijmo:C1Tabs ID="C1Tab1" runat="server" ><%--OnSelectedChanged="" AutoPostBack="true" --%>
<Pages><wijmo:C1TabPage id="C1TabPage0" runat="server" ><wijmo:C1TreeView id="tabstree0" AllowTriState="false" runat="server"></wijmo:C1TreeView></wijmo:C1TabPage>
</Pages>
</wijmo:C1Tabs>
string str= "SELECT [a],[b] FROM [表名] ";
DataTable dtOil = DbHelper.DAL.ExecuteDataSet(str).Tables[0];
tree1(dtOil, "");
public void tree1(DataTable dtOil, string name)
{
string role = "select u.DisplayName from (select ur.UserID from (select RoleID from roles where RoleName='厂家' ) as r left join userroles ur on r.RoleID=ur.RoleID) as us left join users u on u.UserID=us.UserID where u.DisplayName like '%" + name + "%'";
DataTable dtrole = DbHelper.DAL.DataTable(role);
C1Tab1.Pages.Clear();
for (int i = 0; i < dtrole.Rows.Count; i++)
{
//tab绑定
C1.Web.Wijmo.Controls.C1Tabs.C1TabPage ctab = new C1.Web.Wijmo.Controls.C1Tabs.C1TabPage();
ctab.ID = "C1TabPage" + i + "";
ctab.Text = dtrole.Rows[i][0].ToString();
C1TreeView c1 = new C1TreeView();
c1.ID = "tabstree" + i.ToString(); ctab.Controls.Add(c1);
C1Tab1.Pages.Add(ctab);
}
for (int i = 0; i < dtrole.Rows.Count; i++)
{
数据绑定
if (i == 0)
{
treeValues = "";
}
else
{
treeValues += "&";
}
C1TreeView c1 = (C1TreeView)C1Tab1.Pages[i].Controls[0];
c1.ShowCheckBoxes = true;
c1.ShowExpandCollapse = true;
string strchangjia = "SELECT * from (SELECT [a],[b] FROM [表名] where [treeType] = '1' and 品牌 like '%[0-9]%' group by [a],[b]) as jiu where jiu.alike '%" + dtrole.Rows[i][0].ToString().Replace(" ", "") + "%'";
DataTable dchangjia = GJPDbHelper.DAL.DataTable(strchangjia);
BindTreeOil2(dchangjia, c1);
count++;
}
}
private C1TreeView BindTreeOil2(DataTable dtSource, C1TreeView c)
{ c.Nodes.Clear(); string topNodeStr = "";
string twoNodeStr = "";
C1TreeViewNode curNode = new C1TreeViewNode(); ;
//DataRow[] rows = dtSource.Select(string.Format("ParentID={0}", parentID));
foreach (System.Data.DataRow c1row in dtSource.Rows)
{
if (topNodeStr != Convert.ToString(c1row[0]))
{
C1TreeViewNode newNode = new C1TreeViewNode();
newNode.Value = Convert.ToString(c1row[0]);
newNode.Text = Convert.ToString(c1row[0]); c.Nodes.Add(newNode);
topNodeStr = Convert.ToString(c1row[0]);
curNode = newNode;
}
else
{
C1TreeViewNode newNode = new C1TreeViewNode();
newNode.Value = Convert.ToString(c1row[1]);
newNode.Text = Convert.ToString(c1row[1]);
//string str = "select 产品 from [AIRB_MMTREE] where [类型] ='" + c1row[1].ToString() + "'";
//DataTable dt = GJPDbHelper.DAL.DataTable(str);
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// C1TreeViewNode newNode1 = new C1TreeViewNode();
// newNode1.Value = Convert.ToString(dt.Rows[i][0]);
// newNode1.Text = Convert.ToString(dt.Rows[i][0]);
// newNode.Nodes.Add(newNode1);
//}
//if (twoNodeStr != Convert.ToString(c1row[1]))
//{
// C1TreeViewNode newNode1 = new C1TreeViewNode();
// newNode1.Value = Convert.ToString(c1row[1]);
// newNode1.Text = Convert.ToString(c1row[1]);
// newNode.Nodes.Add(newNode1);
// twoNodeStr = Convert.ToString(c1row[1]);
// newNode = newNode1;
//}
//else
//{
// C1TreeViewNode newNode1 = new C1TreeViewNode();
// newNode1.Value = Convert.ToString(c1row[2]);
// newNode1.Text = Convert.ToString(c1row[2]);
// newNode.Nodes.Add(newNode1);
//} curNode.Nodes.Add(newNode); }
}
return c;
}
最新文章
- Xamarin Android 之起始篇
- Ajax商品分类三级联动实现
- grep查询文本：问一个简单shell问题，将grep的输出赋值给一个变量
- poj3342Party at Hali-Bula（树形dp）
- CodeIgniter框架入门教程——第一课 Hello World！
- POJ3784 Running Median
- MySQL日常应用和操作记录
- .Net自带的委托类型—Func，Action 和 Predicate
- 用标准C编写COM（一）
- [转]PT_DENY_ATTACH
- 使用 Newtonsoft.Json 操作 JSON 字符串
- Dynamics 365 CE在Pre Delete插件中应用Image
- lombok自带的slfj使用方法
- 获取天气预报API5_统计最容易生病时间段
- [转] HTML5中meta属性的使用详解
- scrapy爬虫出现Forbidden by robots.txt
- ie7/8浏览器报错：对象不支持“trim”属性或方法
- 关于CGI和FastCGI的理解
- Linux 用户和用户组详解
- Kubernetes 1.6新特性