public static void LoadFromSystemDB(MieSystemDB systemDB, MieChatterNodeInfo chatterNodeInfo) { SQLiteCommand command = systemDB.Connection.CreateCommand(); command.CommandText = @"SELECT * FROM ChatterNodeEntries ORDER BY FileCode;"; using (SQLiteDataReader reader = command.ExecuteReader()) { while (reader.Read() == true) { var fileCode = (long)reader["FileCode"]; var nodeID = (int)(long)reader["NodeID"]; var xNodeType = (long)reader["NodeType"]; var xIsRootNode = (long)reader["IsRootNode"]; MieChatterNodeEntry.NNodeType nodeType = (MieChatterNodeEntry.NNodeType)Enum.ToObject(typeof(MieChatterNodeEntry.NNodeType), xNodeType); bool isRootNode = xIsRootNode == 0 ? false : true; MieChatterNodeEntry nodeEntry = new MieChatterNodeEntry( nodeType, nodeID, isRootNode); var nodeFile = chatterNodeInfo.GetNodeFile(fileCode); var rc = nodeFile.AddFlatNodeEntry(nodeEntry); } } foreach (var nodeFile in chatterNodeInfo.Files.Values) { nodeFile.BuildLink(); nodeFile.UpdateDepth(); } }
public static void LoadFromSystemDB(MieSystemDB systemDB, MieChatterNodeInfo convNodeInfo) { SQLiteCommand command = systemDB.Connection.CreateCommand(); command.CommandText = @"SELECT FileCode,FromNodeID,ToNodeID FROM ChatterNodeLinks ORDER BY FileCode;"; using (SQLiteDataReader reader = command.ExecuteReader()) { while (reader.Read() == true) { var fileCode = (long)reader["FileCode"]; var fromNodeID = (int)(long)reader["FromNodeID"]; var toNodeID = (int)(long)reader["ToNodeID"]; var nodeFile = convNodeInfo.GetNodeFile(fileCode); MieChatterLink nodeLink = new MieChatterLink(fromNodeID, toNodeID); nodeFile.AddLinkEntry(nodeLink); } } }