public void GetQueriesInfoTest() { const string queryCountSQL = @"select count (*) from tasQuery where blnSubQuery = 0"; lock (m_LayoutDB.Connection) { EidssUserContext.CheckUserLoggedIn(); LookupManager.ClearByTable("Query"); LookupManager.ClearAndReloadOnIdle(); int queryCount = GetCount(queryCountSQL); int actualQueryCount = AvrQueryLayoutTreeDbHelper.ReLoadQueries().Count; Assert.AreEqual(queryCount, actualQueryCount); } }
internal static Dictionary <long, string> GetAvrQueries() { List <AvrTreeElement> queries = AvrQueryLayoutTreeDbHelper.ReLoadQueries(true); Dictionary <long, string> result = queries.ToDictionary(query => query.QueryID, query => query.NationalName); return(result); // // DataView view = LookupBinder.GetQueryDataView(false); // view.Sort = "intOrder, QueryName"; // // foreach (DataRowView row in view) // { // var queryId = (long)row["idflQuery"]; // string queryName = row["QueryName"].ToString(); // // result.Add(queryId, queryName); // } }