|
#region 构造节点
//
//获取节点(系统会自动往树立添加的)
//
//
//
public override ListGetTreeViewData(TreeNodeArgs treeNodeArgs)
{
if (string.IsNullOrEmpty(treeNodeArgs.NodeId) || treeNodeArgs.NodeId == "0")
{
string sql = string.Format(" SELECT MG.FID,FNUMBER,FGROUPID,FPARENTID,MGL.FNAME from T_BD_MATERIALGROUP MG INNER JOIN T_BD_MATERIALGROUP_L MGL ON MG.FID = MGL.FID WHERE MGL.FLOCALEID = {0} ",this.View.Context.UserLocale.LCID);
DynamicObjectCollection nodeList = DBUtils.ExecuteDynamicObject(this.View.Context,sql);
Dictionary _treeNodes = new Dictionary();
ListtreeNodes = new List();
foreach (DynamicObject node in nodeList)
{
if (Convert.ToString(node["FPARENTID"]).Equals("0"))
{
treeNodes.Add( new TreeNode()
{
id = node["FID"].ToString().Trim(),
parentid = node["FPARENTID"].ToString().Trim(),
xtype = "system",
text = node["FNAME"].ToString().Trim(),
children = GetSubNode(nodeList, node["FID"].ToString().Trim())
}
);
}
}
return treeNodes;
}
else
{
return null;
}
}
///
/// 节点点击时触发重新查询
///
///
public override void TreeNodeClick(TreeNodeArgs e)
{
if (this.Model != null)
{
TreeViewFilterParameter treeViewFilter = ((ITreeListModel)this.Model).TreeViewFilterParameter as TreeViewFilterParameter;
treeViewFilter.IgnoreSelectedGroupIds = true; // 忽略系统内置的标准选择节点过滤方法
treeViewFilter.FilterString = string.Format(" EXISTS (SELECT 1 FROM T_BD_MATERIALGROUP TG INNER JOIN T_BD_MATERIAL TM ON (TM.FMATERIALGROUP = TG.FID AND TG.FID = {0}) WHERE TM.FMATERIALID = t0.FMATERIALID ) ", Convert.ToInt64(e.NodeId));
((ITreeListView)this.ListView).RefreshList(); // 只刷新列表，不刷新树结构
}
}
private ListGetSubNode(DynamicObjectCollection nodeList, string parentID)
{
return nodeList
.Where(p => p["FPARENTID"].ToString().Equals(parentID) )
.Select(p => new TreeNode()
{
id = p["FID"].ToString(),
parentid = p["FPARENTID"].ToString(),
xtype = "leaf",
text = p["FNAME"].ToString(),
}).ToList();
}
#endregion
|
