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);
}
}
