public static Boolean ExecuteSelectDateDetailsTableTaskTime(string dbpath, DateDetailsViewModel dsv, string sql, DateTime dt) { // return value true: More button visibie Boolean ret = false; SQLiteConnection con = new SQLiteConnection("Data Source=" + dbpath + ";"); con.Open(); SQLiteCommand com = new SQLiteCommand(sql, con); com.Parameters.Add(sqliteParam(com, "@date", dt.Date.ToString("yyyy-MM-dd HH:mm:ss"))); try { SQLiteDataReader sdr = com.ExecuteReader(); int resultCount = 0; while (sdr.Read() == true) { resultCount++; if (resultCount <= DateDetailsMoreSize) { ListDateDetails lds = new ListDateDetails(); lds.Name = (string)sdr["name"]; DateTime utc = DateCalc.SQLiteStringToDateTime((string)sdr["start_date"]); lds.StartDate = utc.ToLocalTime().ToString("G", System.Globalization.CultureInfo.CurrentCulture); DateTime utc2 = DateCalc.SQLiteStringToDateTime((string)sdr["end_date"]); lds.EndDate = utc2.ToLocalTime().ToString("G", System.Globalization.CultureInfo.CurrentCulture); TimeSpan ts = new TimeSpan((Int64)sdr["duration"]); lds.Duration = ts.ToString(@"hh\:mm\:ss"); dsv.Entries.Add(lds); SumTimeSpanDateDetails += ts; } else { DateDetailsMoreCount += DateDetailsMoreSize; ret = true; } } sdr.Close(); } catch (Exception ex) { MessageBox.Show("database table select tasktime DateDetails error!\n" + ex.Message); } finally { con.Close(); } return(ret); }
public static Boolean ExecuteSelectTableTaskMemo(string dbpath, TaskMemoViewModel tmv, string sql, Int64 id) { // return value true: More button visibie Boolean ret = false; SQLiteConnection con = new SQLiteConnection("Data Source=" + dbpath + ";"); con.Open(); SQLiteCommand com = new SQLiteCommand(sql, con); com.Parameters.Add(sqliteParamInt64(com, "@id", id)); try { SQLiteDataReader sdr = com.ExecuteReader(); int resultCount = 0; while (sdr.Read() == true) { resultCount++; if (resultCount <= TaskMemoMoreSize) { ListTaskMemo ltm = new ListTaskMemo(); ltm.Memo = (string)sdr["memo"]; DateTime utc = DateCalc.SQLiteStringToDateTime((string)sdr["date"]); ltm.Date = utc.ToLocalTime().ToString("G", System.Globalization.CultureInfo.CurrentCulture); tmv.Memos.Add(ltm); } else { TaskMemoMoreCount += TaskMemoMoreSize; ret = true; } } sdr.Close(); } catch (Exception ex) { MessageBox.Show("database table select taskmemo error!\n" + ex.Message); } finally { con.Close(); } return(ret); }