easyui tree控件加載url數據
建表
CREATE TABLE [dbo].[OrganizationStructure](
[Id] [int] IDENTITY(1,1) NOT NULL,
[OwnerId] [int] NOT NULL,
[Name] [nvarchar](100) NOT NULL,
[Type] [int] NULL,
CONSTRAINT [PK_OrganizationStructure] PRIMARY KEY CLUSTERED
(
[Name] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
后臺
private string GetOrganizationStructureText()
{
StringBuilder sb = new StringBuilder();
sb.Append("[");
GetChildrenText(0, ref sb);
sb.Append("]");
return sb.ToString();
}
private void GetChildrenText(int id,ref StringBuilder sb)
{
using(TrainingSystemDataContext dc=new TrainingSystemDataContext(DBConn.GetConn()))
{
var query = from s in dc.OrganizationStructure where s.OwnerId == id select s;
int querycount = query.Count();
int i = 0;
foreach (var s in query)
{
sb.AppendLine("{" + string.Format(""id":{0},"text":"{1}"", s.Id, s.Name));
int count = DBCommand.QueryInteger("SELECT COUNT(*) FROM [OrganizationStructure] WHERE [OwnerId]=" + s.Id);
if (count > 0)
{
sb.AppendLine(","children":[");
GetChildrenText(s.Id,ref sb);
sb.AppendLine("]");
}
sb.AppendLine("}");
++i;
if (i != querycount)
sb.Append(",");
}
}
}前臺
<ul id="tt" class="easyui-tree"
url="data.aspx">
上一篇 矩陣的秩及子空間
下一篇 Android簡單的學生管理系統
程序員人生，我編程，我富裕，記住wfuyu網，php教程，php學習，php手冊，CMS模版制作
聲明：本站大部分內容是作者原創，少部分收集于互聯網供大家一起學習，原版權很多不明，如有侵權請聯系本站，謝謝！
粵ICP備14040726號-1?? 2015-2020 程序員人生 版權所有
