public static void UpdateOverdueChildren()
{
DataTable dt = sqlite.GetDataTable(string.Format(("SELECT * FROM {0} WHERE {1} < '{2}'"), ListChild.TABLE_NAME, ListChild.FIELD_NAME_END_TIME, DateTime.Now.ToString(Global.TIME_FORMAT_STRING)));
if (dt.Rows.Count > 0)
{
sqlite.BeginTransaction();
for (int i = 0; i < dt.Rows.Count; i++)
{
ListChild listChild = ListChild.GetListChildById(Convert.ToInt32(dt.Rows[i][ListChild.FIELD_NAME_ID]));
if ((listChild.Mark != MarkType.Overdue) && (listChild.Mark != MarkType.Abandoned))
{
listChild.Mark = MarkType.Overdue;
UpdateListChild(listChild);
}
}
sqlite.CommitTransaction();
}
}
public override bool LoadDataFromFile(string parFile)
{
using (StreamReader streamReader = new StreamReader(parFile)) //Открываем файл для чтения)
{
string varHead = "insert into " + Path.GetFileNameWithoutExtension(parFile) + "(" + streamReader.ReadLine() + ") values ";
db.BeginTransaction();
while (!streamReader.EndOfStream)
{
db.ExecuteNonQuery(varHead + "(" + streamReader.ReadLine() + ")");
}
db.CommitTransaction();
return(true);
}
}
public static void CommitTransaction()
{
sqlite.CommitTransaction();
}
