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); }
public static void CopyLbfToClipBoard( string name, string priority, string status, string description, string createdate, string duedate, string workHolder, TaskMemoViewModel tmv) { string str = ""; str = name + "\t" + priority + "\t" + status + "\t\"" + description + "\"\t" + createdate + "\t" + duedate + "\t" + workHolder; foreach (ListTaskMemo ltm in TaskMemoViewModel.tmv.Memos) { str += "\t\"" + ltm.Memo + "\"\t" + ltm.Date; } if (!string.IsNullOrEmpty(str)) { Clipboard.SetText(str); } }