static void Main(string[] args) { Collector querieCollector = new Collector(30, @"C:\site\ntec\App_Data\configs.db", @"C:\site\ntec\xml"); List<Dictionary<string, string>> queries = querieCollector.GetQueries(); foreach (Dictionary<string, string> query in queries) { RunQuery( query["conn"], query["sql"], query["xml_file"] ); } int x; }
/// <summary> /// Get data from site database /// </summary> private static void LoadntecDbData(int scheduleInterval, DataTable siteConfig) { for (int i = 0; i < siteConfig.Rows.Count; i++) { string siteName = siteConfig.Rows[i]["title"].ToString(); string dbPath = siteConfig.Rows[i]["db_path"].ToString(); string xmlFolderPath = siteConfig.Rows[i]["default_xml_folder"].ToString(); Collector collector = new Collector(scheduleInterval, dbPath, xmlFolderPath); List<Dictionary<string, string>> dbQuery = collector.GetQueries(); for (int k = 0; k < dbQuery.Count; k++) { dbQuery[k] = AddKeyStatus(dbQuery[k], "status", ""); dbQuery[k] = AddKeyStatus(dbQuery[k], "site_name", siteName); dbQuery[k] = AddKeyStatus(dbQuery[k], "exec_time", ""); } if (dbQuery.Count > 0) _queries.AddRange(dbQuery); } }