private void CompoentTreeInit()
{
compoentData = new List <UTreeNodeData>();
path += "38#结构模型算量信息";
this._path = path;
//ReadComponentXml();
XmlDocument xml = new XmlDocument();
//xml.Load(path);
string s1 = Resources.Load(path).ToString();
xml.LoadXml(s1);
List <string> elementTypes = new List <string>();
List <CompoentCount> countList = new List <CompoentCount>();
//List<CompoentCount> afterList = new List<CompoentCount>();
Dictionary <string, List <string> > elementsList = new Dictionary <string, List <string> >();
XmlNode mainNode = xml.SelectSingleNode("算量信息");
var nodes = mainNode.ChildNodes;
foreach (XmlNode childNode in nodes)
{
string elementId = childNode.Name;
XmlNode name = childNode.SelectSingleNode("项目名称");
XmlNode code = childNode.SelectSingleNode("项目编码");
string codeText = code.InnerText;
string nameText = name.InnerText;
if (elementsList.ContainsKey(codeText))
{
elementsList[codeText].Add(elementId);
}
else
{
elementsList.Add(codeText, new List <string>());
elementsList[codeText].Add(elementId);
elementTypes.Add(nameText + " " + codeText);
}
}
this._elementList = elementsList;
elementTypes.Sort();
//编码规范
XmlDocument xmlRule = new XmlDocument();
path = path.Replace("算量信息", "清单规则");
// xmlRule.Load(path);
string s2 = Resources.Load(path).ToString();
xmlRule.LoadXml(s2);
//List<string> projectNameList = new List<string>();
//List<string> nodeClassList = new List<string>();
//List<string> codeNameList = new List<string>();
//List<string> codeNumList = new List<string>();
//int i = 0; int j = 0; int k = 0; int l = 0;
int i = 0;
foreach (string elementType in elementTypes)
{
i++;
string temp = GetCountData(elementType.Split(' ')[1], path);
string projectName = temp.Split('$')[0];
string nodeClass = temp.Split('$')[1];
string codeName = elementType.Split(' ')[1];
string codeNum = elementType.Split(' ')[2];
CompoentCount mycount = new CompoentCount()
{
ProjectName = projectName,
NodeClass = nodeClass,
CodeName = codeName,
CodeNum = codeNum
};
countList.Add(mycount);
}
var datas = countList.GroupBy(c => new { c.ProjectName }).ToList();
foreach (var dataA in datas)
{
i++;
UTreeNodeData node0 = new UTreeNodeData(i, dataA.First().ProjectName);
var item1 = dataA.GroupBy(c => new { c.NodeClass }).ToList();
foreach (var item11 in item1)
{
i++;
UTreeNodeData node1 = new UTreeNodeData(i, item11.First().NodeClass);
node0.AddChild(node1);
var item2 = item11.GroupBy(c => new { c.CodeName }).ToList();
foreach (var item22 in item2)
{
i++;
UTreeNodeData node2 = new UTreeNodeData(i, item22.First().CodeName);
node1.AddChild(node2);
var item3 = item22.GroupBy(c => new { c.CodeNum }).ToList();
foreach (var item33 in item3)
{
i++;
UTreeNodeData node3 = new UTreeNodeData(i, item33.First().CodeNum);
node2.AddChild(node3);
}
}
}
compoentData.Add(node0);
}
//compoentTree.SetDataProvider(compoentData);
}
public List <UTreeNodeData> GetComData()
{
List <string> fullCode = new List <string>(); //12位编码
List <string> nineCode = new List <string>(); //9位编码
List <string> treeList = new List <string>(); //构件分类集合
//Dictionary<string, string> xmlNodePathDic = new Dictionary<string, string>();//根据前9位编码得到xml节点路径
comNodeData = new List <UTreeNodeData>();
#region 查询数据库和xml清单规则得到一个list<string> E混凝土及钢筋混凝土工程_E.3现浇混凝土梁_010503002001
SqliteConnection conn2 = Tools.Instance.SqlConnection();
SqliteCommand cmd2 = conn2.CreateCommand();
cmd2.CommandText = "Select distinct Code from InventoryDB";
SqliteDataReader dr2 = cmd2.ExecuteReader();
if (dr2.HasRows)
{
while (dr2.Read())
{
string temp = dr2.GetString(0);
fullCode.Add(temp);//得到12位编码
}
}
string tempCode = "";
foreach (string item in fullCode)
{
string code9 = item.Substring(0, 9);
string it = item;
if (code9 != tempCode)
{
nineCode.Add(code9);//得到9位编码
tempCode = code9;
}
}
string str2013 = Resources.Load("国标清单2013").ToString();
xmldoc = new XmlDocument();
xmldoc.LoadXml(str2013);
XmlNodeList node = xmldoc.SelectSingleNode("//工程量计算规范").ChildNodes;
foreach (XmlNode item in node) //item D砌筑工程
{
foreach (XmlNode it in item.ChildNodes) //it D.1砖砌体
{
foreach (XmlNode i in it.ChildNodes) // i 砖基础
{
foreach (XmlNode b in i.ChildNodes)
{
for (int j = 0; j < fullCode.Count; j++)
{
if (b.InnerText == fullCode[j].Substring(0, 9))
{
string treeNode = "";
treeNode = item.Name + "_" + it.Name + "_" + fullCode[j];
string nodePath = "//工程量计算规范//" + item.Name + "//" + it.Name + "//" + i.Name;
if (!xmlNodePathDic.ContainsKey(fullCode[j].Substring(0, 9)))
{
xmlNodePathDic.Add(fullCode[j].Substring(0, 9), nodePath);//根据9位编码获取Xml节点的路径
}
if (fullCode[j].Contains(b.InnerText))
{
treeList.Add(treeNode);// 存放： E混凝土及钢筋混凝土工程_E.3现浇混凝土梁_010503002001
}
//Debug.Log(treeNode);
// break;
}
}
}
}
}
}
#endregion
#region
List <CompoentCount> countList = new List <CompoentCount>();
int z = 0;
Debug.Log(treeList.Count);
foreach (string temptree in treeList)
{
z++;
string nodeClass = temptree.Split('_')[0];
string codeName = temptree.Split('_')[1];
string codeNum = temptree.Split('_')[2];
CompoentCount mycount = new CompoentCount()
{
ProjectName = "",
NodeClass = nodeClass,
CodeName = codeName,
CodeNum = codeNum
};
countList.Add(mycount);
}
var datas = countList.GroupBy(c => new { c.NodeClass }).ToList();
foreach (var dataA in datas)
{
z++;
UTreeNodeData node0 = new UTreeNodeData(z, dataA.First().NodeClass);
Debug.Log("0" + dataA.First().NodeClass);
var item1 = dataA.GroupBy(c => new { c.CodeName }).ToList();
foreach (var item11 in item1)
{
z++;
UTreeNodeData node1 = new UTreeNodeData(z, item11.First().CodeName); //E.3现浇混凝土梁
Debug.Log("1" + item11.First().CodeName);
node0.AddChild(node1);
var item2 = item11.GroupBy(c => new { c.CodeNum }).ToList();//矩形梁
foreach (var item22 in item2)
{
z++;
UTreeNodeData node2 = new UTreeNodeData(z, item22.First().CodeNum);
Debug.Log("2" + item22.First().CodeNum);
node1.AddChild(node2);
}
}
comNodeData.Add(node0);
}
#endregion
return(comNodeData);
}
private void LevelTreeInit()
{
compoentData = new List <UTreeNodeData>();
List <string> levelList = new List <string>();
SqliteConnection conn = Tools.Instance.SqlConnection();
SqliteCommand cmd = conn.CreateCommand();
cmd.CommandText = "Select distinct Layer from ElementDB";
SqliteDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
floorNum.Add(dr.GetString(0));//得到所有的层数
}
}
int num = floorNum.Count;
SqliteConnection conn2 = Tools.Instance.SqlConnection();
SqliteCommand cmd2 = conn2.CreateCommand();
cmd2.CommandText = "Select distinct Code from InventoryDB";
SqliteDataReader dr2 = cmd2.ExecuteReader();
if (dr2.HasRows)
{
while (dr2.Read())
{
string temp = dr2.GetString(0);
fullCode.Add(temp);//得到12位编码
}
}
string tempCode = "";
foreach (string item in fullCode)
{
string code9 = item.Substring(0, 9);
string it = item;
if (code9 != tempCode)
{
nineCode.Add(code9);//得到9位编码
tempCode = code9;
}
}
string str2013 = Resources.Load("国标清单2013").ToString();
xmldoc = new XmlDocument();
xmldoc.LoadXml(str2013);
XmlNodeList node = xmldoc.SelectSingleNode("//工程量计算规范").ChildNodes;
foreach (XmlNode item in node) //item D砌筑工程
{
foreach (XmlNode it in item.ChildNodes) //it D.1砖砌体
{
foreach (XmlNode i in it.ChildNodes) // i 砖基础
{
foreach (XmlNode b in i.ChildNodes)
{
for (int j = 0; j < fullCode.Count; j++)
{
if (b.InnerText == fullCode[j].Substring(0, 9))
{
string treeNode = "";
treeNode = item.Name + "_" + it.Name + "_" + fullCode[j];
string nodePath = "//工程量计算规范//" + item.Name + "//" + it.Name + "//" + i.Name;
if (!xmlNodePathDic.ContainsKey(fullCode[j].Substring(0, 9)))
{
xmlNodePathDic.Add(fullCode[j].Substring(0, 9), nodePath);//根据9位编码获取Xml节点的路径
}
if (fullCode[j].Contains(b.InnerText))
{
treeList.Add(treeNode);// 存放： E混凝土及钢筋混凝土工程_E.3现浇混凝土梁_010503002001
}
//Debug.Log(treeNode);
// break;
}
}
}
}
}
}
List <CompoentCount> countList = new List <CompoentCount>();
int z = 0;
Debug.Log(treeList.Count);
foreach (string temptree in treeList)
{
z++;
string nodeClass = temptree.Split('_')[0];
string codeName = temptree.Split('_')[1];
string codeNum = temptree.Split('_')[2];
CompoentCount mycount = new CompoentCount()
{
ProjectName = "",
NodeClass = nodeClass,
CodeName = codeName,
CodeNum = codeNum
};
countList.Add(mycount);
}
var datas = countList.GroupBy(c => new { c.NodeClass }).ToList();
foreach (var dataA in datas)
{
z++;
UTreeNodeData node0 = new UTreeNodeData(z, dataA.First().NodeClass);
Debug.Log("0" + dataA.First().NodeClass);
var item1 = dataA.GroupBy(c => new { c.CodeName }).ToList();
foreach (var item11 in item1)
{
z++;
UTreeNodeData node1 = new UTreeNodeData(z, item11.First().CodeName); //E.3现浇混凝土梁
Debug.Log("1" + item11.First().CodeName);
node0.AddChild(node1);
var item2 = item11.GroupBy(c => new { c.CodeNum }).ToList();//矩形梁
foreach (var item22 in item2)
{
z++;
UTreeNodeData node2 = new UTreeNodeData(z, item22.First().CodeNum);
Debug.Log("2" + item22.First().CodeNum);
node1.AddChild(node2);
}
}
compoentData.Add(node0);
}
//foreach (var item in ReadModelXML.idAndLevels.Values)
//{
// if (!levelList.Contains(item))
// levelList.Add(item);
//}
//List<string> levelList = new List<string>
//{
// "结构B2","结构B1","结构1","结构2","结构3","结构4","结构5","结构6",
// "结构7","结构8","结构9","结构10","结构11","结构12","结构13","结构14",
// "结构15","结构16","结构17","结构18","结构RMF","结构RF","结构TF"
//};
//UTreeNodeData levelChildNode = new UTreeNodeData(2, "结构B2");
UTreeNodeData leveltree = new UTreeNodeData(1, "楼层");
//levelTree.AddChild(levelChildNode);
int count = 0;
foreach (var item in floorNum)
{
count++;
UTreeNodeData levelChildNode = new UTreeNodeData(count, item);
leveltree.AddChild(levelChildNode);
}
levelData = new List <UTreeNodeData>();
levelData.Add(leveltree);
}
