public void Delete(T t) { OleDB.ExecuteNonQuery("delete from TAtomAndGrp" + " where FKind = '" + Kind + "' and Id = " + t.Id); Entities.Remove(t.Id); }
protected void SaveSln(EnSolution solution) { OleDB.ExecuteNonQuery("delete from TSolution"); OleDB.ExecuteNonQuery("insert into TSolution (FActiveWeek, FLessonNumber) values (" + "'" + ExBuildListWithHexChar.GetHexStr(solution.ActiveWeekArr) + "'" + ",'" + ExBuildListWithHexChar.GetHexStr(solution.LessonNumberArr) + "'" + ")"); }
public void Update(T t) { OleDB.ExecuteNonQuery( "update TAtomAndGrp set " + " FName = @FName, " + " FColor = " + (IsCourse ? (t as EnSubject).Color.ToArgb().ToString() : "0") + " where FKind = '" + Kind + "' " + " and Id = " + t.Id, new KeyValue <String, Object>("@FName", t.Name) ); }
public void ClearAll() { OleDB.ExecuteNonQuery("delete from TAtomAndGrp" + " where FKind = '" + Kind + "'"); IList <Int64> Ids = new List <Int64>(); foreach (BaseEntity ety in Entities.Values) { if (ety is T) { Ids.Add(ety.Id); } } foreach (Int64 id in Ids) { Entities.Remove(id); } }