public PerformanceCounterData(PerformanceCounter[] performanceCounter, DataType dataType, GetDataType getDataType, string instanceName, Object[] param = null) { this.performanceCounter = performanceCounter; this.dataType = dataType; this.getDataType = getDataType; this.param = param; this.instanceName = instanceName; }
private DataTable GetQuestionsAnswersOrResults(GetDataType getDataType) { var selectionField = string.Empty; // SELECT BLOCK var query = "Select distinct "; switch (getDataType) { case GetDataType.Answers: selectionField = "main.Answers.Name"; break; case GetDataType.Questions: selectionField = "main.Questions.Name"; break; case GetDataType.QuestionsAnswersScores: selectionField = "main.Questions.Name, main.Answers.Name, main.Interview.Score"; break; case GetDataType.Theme: selectionField = "main.Themes.Name"; break; } if (selectionField != string.Empty) { // FROM BLOCK query += selectionField + " from main.Interview, " + "main.Questions, " + "main.Answers, " + "main.Themes "; // WHERE BLOCK query += "where main.Interview.QUESTION_ID = main.Questions.ID " + "and main.Interview.ANSWER_ID = main.Answers.ID " + "and main.Interview.theme_id = main.Themes.ID"; if (getDataType != GetDataType.Theme) { query += " and main.Themes.Name = " + "'" + InterView.GetInterviewTheme() + "'"; } query += " order by main.Questions.ID, main.Answers.ID "; try { var result = DbConnection.SelectFromDb(query); return(result); } catch (Exception exp) { throw new Exception(exp.ToString()); } } return(null); }
public int GetWordCount(GetDataType type) { lock (this) { OleDbConnection cn = new OleDbConnection(ConnectionString); cn.Open(); OleDbCommand cmd; if (type == GetDataType.All) { cmd = new OleDbCommand("SELECT Count(Words.ID) FROM Words", cn); } else if (type == GetDataType.Studied) { cmd = new OleDbCommand("SELECT Count(Words.ID) FROM Words Where(Words.Hide=true)", cn); } else { cmd = new OleDbCommand("SELECT Count(Words.ID) FROM Words Where(Words.Hide=false)", cn); } return((int)cmd.ExecuteScalar()); } }
private void StartGetDataDelegate(GetDataType gdt) { switch (gdt) { case GetDataType.All: while (SiteArtists.Count > 0) { var item = SiteArtists[0]; SiteArtists.RemoveAt(0); Func<CArtist, List<CDownloadImage>> getdatadelegate = GetAllDataDelegate; _getdataCount++; getdatadelegate.BeginInvoke(item, GetDataCallBack, getdatadelegate); while (_getdataCount > _maxtask) { Thread.Sleep(7000); } } break; case GetDataType.Update: while (SiteArtists.Count > 0) { var item = SiteArtists[0]; SiteArtists.RemoveAt(0); Func<CArtist, List<CDownloadImage>> getdatadelegate = GetUpdateDataDelegate; _getdataCount++; getdatadelegate.BeginInvoke(item, GetDataCallBack, getdatadelegate); while (_getdataCount > _maxtask) { Thread.Sleep(7000); } } break; } while (_getdataCount > 0) { Thread.Sleep(5000); } }
public List <Kanji> GetKanjiData(GetDataType type) { lock (this) { List <Kanji> arr = new List <Kanji>(); OleDbConnection cn = new OleDbConnection(ConnectionString); cn.Open(); OleDbCommand cmd; if (type == GetDataType.All) { cmd = new OleDbCommand("SELECT * FROM KANJI ", cn); } else if (type == GetDataType.Studied) { cmd = new OleDbCommand("SELECT * FROM KANJI WHERE Hide = true", cn); } else { cmd = new OleDbCommand("SELECT * FROM KANJI WHERE Hide = false", cn); } OleDbDataAdapter da = new OleDbDataAdapter(cmd); DataTable dt = new DataTable(); int i = da.Fill(dt); if (i == 0) { cn.Close(); return(arr); } foreach (DataRow dr in dt.Rows) { Kanji k = new Kanji(); try { k.Id = (int)dr["Id"]; k.StrKanji = dr["Kanji"] as string; k.StrAmon = dr["Amon"] as string; k.StrAmkun = dr["Amkun"] as string; k.StrMeaning = dr["Meaning"] as string; k.StrSample = dr["Sample"] as string; k.IsStudied = (bool)dr["Hide"]; } catch { continue; } if (null != k.StrKanji && !string.IsNullOrEmpty(k.StrKanji.Trim()) && null != k.StrMeaning && !string.IsNullOrEmpty(k.StrMeaning.Trim())) { k.StrAmon = null == k.StrAmon ? string.Empty : k.StrAmon; k.StrAmkun = null == k.StrAmkun ? string.Empty : k.StrAmkun; k.StrSample = null == k.StrSample ? string.Empty : k.StrSample; arr.Add(k); } } cn.Close(); return(arr); } }
public List <Word> GetWordData(GetDataType type) { lock (this) { List <Word> arr = new List <Word>(); OleDbConnection cn = new OleDbConnection(ConnectionString); cn.Open(); OleDbCommand cmd; if (type == GetDataType.All) { cmd = new OleDbCommand("SELECT * FROM WORDS ", cn); } else if (type == GetDataType.Studied) { cmd = new OleDbCommand("SELECT * FROM WORDS WHERE Hide = true", cn); } else { cmd = new OleDbCommand("SELECT * FROM WORDS WHERE Hide = false", cn); } OleDbDataAdapter da = new OleDbDataAdapter(cmd); DataTable dt = new DataTable(); int i = da.Fill(dt); if (i == 0) { cn.Close(); return(arr); } foreach (DataRow dr in dt.Rows) { Word w = new Word(); try { w.Id = (int)dr["Id"]; w.Kanji = dr["Kanji"] as string; w.Kana = dr["Kana"] as string; w.Meaning = dr["Meaning"] as string; w.IsStudied = (bool)dr["Hide"]; } catch { continue; } if (null != w.Kana || string.Empty != w.Kana || null != w.Meaning || string.Empty != w.Meaning) { w.Kana = null == w.Kana ? string.Empty : w.Kana; w.Kanji = null == w.Kanji ? string.Empty : w.Kanji; w.Meaning = null == w.Meaning ? string.Empty : w.Meaning; w.Romanji = null == w.Romanji ? string.Empty : w.Romanji; arr.Add(w); } } cn.Close(); return(arr); } }