public List <WLZTreeNode> CreateParentNode()
{
try
{
DataTable dt = db.GetParentNode();
List <WLZTreeNode> list = new List <WLZTreeNode>();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
WLZTreeNode Node = new WLZTreeNode();
Node.Code = dr["DLCODE"].ToString();
Node.DLCODE = Node.Code;
Node.label = dr["DLNAME"].ToString();
//Node.id = Guid.NewGuid().ToString();
Node.children = null;
Node.hasChildren = true;
Node.IsLoading = false;
Node.FlagID = "Parent";
list.Add(Node);
}
}
return(list);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public List <WLZTreeNode> GetEditParentNode(string PMCODE)
{
try
{
DataSet ds = db.GetNode(PMCODE);
List <WLZTreeNode> list = new List <WLZTreeNode>();
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
WLZTreeNode Node = new WLZTreeNode();
Node.Code = dr["DLCODE"].ToString();
Node.DLCODE = Node.Code;
Node.label = dr["DLNAME"].ToString();
Node.hasChildren = true;
Node.FlagID = "Parent";
if (Node.Code == PMCODE.Substring(0, 2))
{
Node.IsLoading = true;
Node.children = new List <WLZTreeNode>();
GetEditChildrenNode(Node, ds, PMCODE, 0);
}
else
{
Node.IsLoading = false;
Node.children = null;
}
list.Add(Node);
}
return(list);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public void GetEditChildrenNode(WLZTreeNode ParentNode, DataSet ds, string PMCODE, int level)
{
List <WLZTreeNode> list = new List <WLZTreeNode>();
string DLCODE = PMCODE.Substring(0, 2);
string ZLCODE = PMCODE.Substring(0, 4);
string XLCODE = PMCODE.Substring(0, 6);
foreach (DataRow dr in ds.Tables[level + 1].Rows)
{
switch (ParentNode.FlagID)
{
case "Parent":
WLZTreeNode ZLNode = new WLZTreeNode();
ZLNode.DLCODE = ParentNode.DLCODE;
ZLNode.ZLCODE = dr["ZLCODE"].ToString();
ZLNode.Code = dr["ZLCODE"].ToString();
ZLNode.label = dr["ZLNAME"].ToString();
ZLNode.hasChildren = true;
ZLNode.FlagID = "ZLNode";
if (ZLNode.Code == ZLCODE)
{
ZLNode.children = new List <WLZTreeNode>();
ZLNode.IsLoading = true;
if (level < 2)
{
GetEditChildrenNode(ZLNode, ds, PMCODE, 1);
}
}
else
{
ZLNode.IsLoading = false;
ZLNode.children = null;
}
ParentNode.children.Add(ZLNode);
break;
case "ZLNode":
WLZTreeNode XLNode = new WLZTreeNode();
XLNode.DLCODE = DLCODE;
XLNode.ZLCODE = ZLCODE;
XLNode.Code = dr["XLCODE"].ToString();
XLNode.XLCODE = XLNode.Code;
XLNode.label = dr["XLNAME"].ToString();
XLNode.hasChildren = true;
XLNode.FlagID = "XLNode";
if (XLNode.Code == PMCODE.Substring(0, 6))
{
XLNode.children = new List <WLZTreeNode>();
XLNode.IsLoading = true;
if (level < 2)
{
GetEditChildrenNode(XLNode, ds, PMCODE, 2);
}
}
else
{
XLNode.IsLoading = false;
XLNode.children = null;
}
ParentNode.children.Add(XLNode);
break;
case "XLNode":
WLZTreeNode PMNode = new WLZTreeNode();
PMNode.DLCODE = DLCODE;
PMNode.ZLCODE = ZLCODE;
PMNode.XLCODE = XLCODE;
PMNode.Code = dr["PMCODE"].ToString();
PMNode.label = dr["PMNAME"].ToString();
PMNode.hasChildren = false;
PMNode.FlagID = "XLNode";
if (PMNode.Code == PMCODE)
{
PMNode.children = new List <WLZTreeNode>();
PMNode.IsLoading = true;
if (level < 2)
{
GetEditChildrenNode(PMNode, ds, PMCODE, 3);
}
}
else
{
PMNode.IsLoading = false;
PMNode.children = null;
}
ParentNode.children.Add(PMNode);
break;
}
}
}
public List <WLZTreeNode> CreateChildrenNode(string flagID, string DLCODE, string ZLCODE, string XLCODE)
{
try
{
List <WLZTreeNode> list = new List <WLZTreeNode>();
DataTable dt = db.GetChildrenNode(flagID, DLCODE, ZLCODE, XLCODE);
switch (flagID)
{
case "Parent":
foreach (DataRow dr in dt.Rows)
{
WLZTreeNode Node = new WLZTreeNode();
Node.DLCODE = DLCODE;
Node.ZLCODE = dr["ZLCODE"].ToString();
Node.Code = dr["ZLCODE"].ToString();
Node.label = dr["ZLNAME"].ToString();
//Node.id = Guid.NewGuid().ToString();
Node.children = null;
Node.hasChildren = true;
Node.FlagID = "ZLNode";
Node.IsLoading = false;
list.Add(Node);
}
break;
case "ZLNode":
foreach (DataRow dr in dt.Rows)
{
WLZTreeNode Node = new WLZTreeNode();
Node.DLCODE = DLCODE;
Node.ZLCODE = ZLCODE;
Node.Code = dr["XLCODE"].ToString();
Node.XLCODE = Node.Code;
Node.label = dr["XLNAME"].ToString();
//Node.id = Guid.NewGuid().ToString();
Node.children = null;
Node.hasChildren = true;
Node.FlagID = "XLNode";
Node.IsLoading = false;
list.Add(Node);
}
break;
case "XLNode":
foreach (DataRow dr in dt.Rows)
{
WLZTreeNode Node = new WLZTreeNode();
Node.DLCODE = DLCODE;
Node.ZLCODE = ZLCODE;
Node.XLCODE = XLCODE;
Node.Code = dr["PMCODE"].ToString();
Node.label = dr["PMNAME"].ToString();
//Node.id = Guid.NewGuid().ToString();
Node.hasChildren = false;
Node.FlagID = "PMNode";
Node.IsLoading = false;
list.Add(Node);
}
break;
}
return(list);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
