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