/// <summary> /// 把数据库内容,写到文件中,便于查看 /// </summary> void TestWriteListDbFile() { ReadIniFile iniFile = new ReadIniFile(); string jsonfilepath = iniFile.IniReadValue(iniFile.getIniFilePath("JsonDataMgr.ini"), "JsonFileInfo", "jsonfilepath"); JsonFile json = new JsonFile(); json.WriteFile(jsonfilepath + "oid_info_db.json", JsonConvert.SerializeObject(oid_info_db)); json.WriteFile(jsonfilepath + "nameEn_info_db.json", JsonConvert.SerializeObject(nameEn_info_db)); json.WriteFile(jsonfilepath + "table_info_db.json", JsonConvert.SerializeObject(table_info_db)); }
/// <summary> /// 解析lm.dtz 写 cmd.json /// </summary> public void ConvertAccessDbToJsonCmdTree() { //Console.WriteLine("DbToJsonCmdTree start " + DateTime.Now.ToString("yyyy年MM月dd日HH时mm分ss秒fff毫秒")); //生产 cmdTree 命令树文件 string sqlContent = "select * from CmdTree order by CmdID"; DataSet dataSet = GetRecordByAccessDb(mdbFile, sqlContent); CmdTreeJsonData cmdJsonDatat = new CmdTreeJsonData(); cmdJsonDatat.CmdParseDataSet(dataSet); JsonFile jsonObjFile = new JsonFile(); //jsonObjFile.WriteFile("D:\\C#\\SCMT\\obj.json", objTreeJson.GetStringObjTreeJson()); jsonObjFile.WriteFile(jsonfilepath + "cmd.json", cmdJsonDatat.GetStringObjTreeJson()); this.cmdTreeInfo = cmdJsonDatat.GetStringObjTreeJson(); isCmdJsonOK = true; //Console.WriteLine("DbToJsonCmdTree end " + DateTime.Now.ToString("yyyy年MM月dd日HH时mm分ss秒fff毫秒")); return; }
/********** 私有函数 **********/ ////////// public bool testGetDataByTableEnglishName() { ReadIniFile iniFile = new ReadIniFile(); string jsonfilepath = iniFile.IniReadValue(iniFile.getIniFilePath("JsonDataMgr.ini"), "JsonFileInfo", "jsonfilepath"); JsonFile json = new JsonFile(); JObject JObj = json.ReadJsonFileForJObject(jsonfilepath + "Tree_Reference.json"); foreach (var table in JObj["NodeList"]) { IReDataByTableEnglishName reData; string MibTableName = table["MibTableName"].ToString(); if (String.Equals("/", MibTableName)) { continue; } if (false == getDataByTableEnglishName(MibTableName, out reData)) { Console.WriteLine("===={0} not exist.", MibTableName); } } return(true); }
/// <summary> /// json 文件生产 3种数据库 /// </summary> private void GeneratedMibInfoList(bool useOld) { initDbMemory(); /// ReadIniFile iniFile = new ReadIniFile(); string jsonfilepath = iniFile.IniReadValue( iniFile.getIniFilePath("JsonDataMgr.ini"), "JsonFileInfo", "jsonfilepath"); JsonFile json = new JsonFile(); JObject JObj = json.ReadJsonFileForJObject(jsonfilepath + "mib.json"); foreach (var table in JObj["tableList"]) { Dictionary <string, string> nameEnTableInfo = new Dictionary <string, string>(); Dictionary <string, string> oidTableInfo = new Dictionary <string, string>(); string tableName = table["nameMib"].ToString(); string tableOid = table["oid"].ToString(); string tableIndexNum = table["indexNum"].ToString(); string nameCh = table["nameCh"].ToString(); dynamic childList = table["childList"]; nameEnTableInfo.Add("isLeaf", "0"); nameEnTableInfo.Add("oid", tableOid); nameEnTableInfo.Add("indexNum", tableIndexNum); nameEnTableInfo.Add("nameCh", nameCh); this.nameEn_info_db.Add(tableName, nameEnTableInfo); oidTableInfo.Add("isLeaf", "0"); oidTableInfo.Add("nameMib", tableName); oidTableInfo.Add("indexNum", tableIndexNum); oidTableInfo.Add("nameCh", nameCh); this.oid_info_db.Add(tableOid, oidTableInfo); this.table_info_db.Add(tableName, table); foreach (var child in childList) { Dictionary <string, string> nameEnChildInfo = new Dictionary <string, string>(); Dictionary <string, string> oidChildInfo = new Dictionary <string, string>(); string childName = child["childNameMib"]; string childOid = child["childOid"]; string childNameCh = child["childNameCh"]; nameEnChildInfo.Add("tableNameEn", tableName); nameEnChildInfo.Add("isLeaf", "1"); nameEnChildInfo.Add("oid", childOid); nameEnChildInfo.Add("indexNum", tableIndexNum); nameEnChildInfo.Add("nameCh", childNameCh); try { this.nameEn_info_db.Add(childName, nameEnChildInfo); } catch (Exception ex) { this.nameEn_info_db[childName]["oid"] = this.nameEn_info_db[childName]["oid"] + "|" + childOid; Console.WriteLine("生成json_db时{0},{1}", childName, ex.Message); } oidChildInfo.Add("isLeaf", "1"); oidChildInfo.Add("nameMib", childName); oidChildInfo.Add("indexNum", tableIndexNum); this.oid_info_db.Add(childOid, oidChildInfo); } } TestWriteListDbFile(); return; }
void JsonFileWrite(string fileName, string content) { JsonFile jsonMibFile = new JsonFile(); jsonMibFile.WriteFile(fileName, content); }