// select box data refresh. public void selectBoxDataRefresh(ListBox selectBox, string[] dateStr) { int dayItem = (int)selectBox.Items[0]; selectBox.Items.Clear(); selectBox.Items.Insert(0, dayItem); dbConnect.Open(); SQLiteCommand command = new SQLiteCommand(QueryList.listBoxRefreshSQL(dateStr), dbConnect); SQLiteDataReader reader = command.ExecuteReader(); int moreCount = 0; for (int count = 1; reader.Read(); count = count + 1) { if (count >= 4) { moreCount = moreCount + 1; } else { selectBox.Items.Insert(count, reader["text"].ToString()); } } if (moreCount > 0) { selectBox.Items.Insert(4, "(...more " + moreCount + ")"); } reader.Close(); dbConnect.Close(); }
// calendar diary set Method. private void settingCalendar() { int maxDays = int.Parse(DateTime.DaysInMonth(selectYear, selectMonth).ToString()); int blankCount, tempCt; DateTime dOfMonth = new DateTime(); dOfMonth = dOfMonth.AddYears(selectYear - 1).AddMonths(selectMonth - 1); switch (dOfMonth.DayOfWeek.ToString()) { case "Sunday": blankCount = 7; break; case "Monday": blankCount = 1; break; case "Tuesday": blankCount = 2; break; case "Wednesday": blankCount = 3; break; case "Thursday": blankCount = 4; break; case "Friday": blankCount = 5; break; default: blankCount = 6; break; } tempCt = blankCount - 1; dbConnect.Open(); for (int row = 1, boxCount = 0, dayCount = 1; row <= 6; row = row + 1) { for (int col = 0; col < 7; col = col + 1) { if (blankCount > 0 || dayCount > maxDays) { gbox[boxCount].BackColor = System.Drawing.SystemColors.InactiveCaptionText; gbox[boxCount].TabStop = false; blankCount = blankCount - 1; } else { string[] dateStr = new string[3]; // Calender Panel color setting. if (DateTime.Now.ToString("yyyy-MM") == (selectYear.ToString() + "-" + selectMonth.ToString("00")) && dayCount == int.Parse(DateTime.Now.ToString("dd"))) { gbox[dayCount + tempCt].BackColor = System.Drawing.Color.FromArgb(192, 255, 255); } else if (dOfMonth.DayOfWeek.ToString() == "Sunday") { gbox[boxCount].BackColor = System.Drawing.Color.FromArgb(255, 192, 192); } else if (dOfMonth.DayOfWeek.ToString() == "Saturday") { gbox[boxCount].BackColor = System.Drawing.Color.FromArgb(192, 192, 255); } else { gbox[boxCount].BackColor = System.Drawing.SystemColors.Window; } // database setting. dateStr = dOfMonth.ToString("yyyy-MM-dd").Split('-'); dateStr[1] = int.Parse(dateStr[1]).ToString(); dateStr[2] = int.Parse(dateStr[2]).ToString(); dbCommand = new SQLiteCommand(QueryList.listBoxRefreshSQL(dateStr), dbConnect); SQLiteDataReader reader = dbCommand.ExecuteReader(); gbox[boxCount].Items.Insert(0, dayCount); int moreCount = 0; for (int count = 1; reader.Read(); count = count + 1) { if (count >= 4) { moreCount = moreCount + 1; } else { gbox[boxCount].Items.Insert(count, reader["text"].ToString()); } } if (moreCount > 0) { gbox[boxCount].Items.Insert(4, "(...more " + moreCount + ")"); } reader.Close(); gbox[boxCount].TabStop = true; dayCount = dayCount + 1; dOfMonth = dOfMonth.AddDays(1); } gbox[boxCount].Enabled = false; boxCount = boxCount + 1; } } dbConnect.Close(); gbox_index = selectDay + tempCt; gbox[gbox_index].BackColor = System.Drawing.Color.FromArgb(255, 255, 192); //MessageBox.Show("Refresh Database"); dataview.refreshData(); }