public static DbNullable<string> FceGetComponentMovementCode(DbNullable<int> movementType) { DbCache.FunctionKey key = new DbCache.FunctionKey("FceGetComponentMovementCode"); DbCache.CacheRecord record; key.Set(movementType); if (DbCache.Contains(key)) { record = DbCache.GetRecord(key); if (!record.IsValid()) { record.Value = Functions.FceGetComponentMovementCode(movementType); record.LastUpdate = DateTime.Now; record.Valid = true; } } else { record = new DbCache.CacheRecord(); record.Value = Functions.FceGetComponentMovementCode(movementType); record.LastUpdate = DateTime.Now; record.Valid = true; DbCache.SetRecord(key, record); } return (DbNullable<string>)record.Value; }
public static DbNullable<decimal> FceGetDefaultIFU() { DbCache.FunctionKey key = new DbCache.FunctionKey("FceGetDefaultIFU"); DbCache.CacheRecord record; key.Set(); if (DbCache.Contains(key)) { record = DbCache.GetRecord(key); if (!record.IsValid()) { record.Value = Functions.FceGetDefaultIFU(); record.LastUpdate = DateTime.Now; record.Valid = true; } } else { record = new DbCache.CacheRecord(); record.Value = Functions.FceGetDefaultIFU(); record.LastUpdate = DateTime.Now; record.Valid = true; DbCache.SetRecord(key, record); } return (DbNullable<decimal>)record.Value; }
public static DbNullable<int> Diagramobjects() { DbCache.FunctionKey key = new DbCache.FunctionKey("Diagramobjects"); DbCache.CacheRecord record; key.Set(); if (DbCache.Contains(key)) { record = DbCache.GetRecord(key); if (!record.IsValid()) { record.Value = Functions.Diagramobjects(); record.LastUpdate = DateTime.Now; record.Valid = true; } } else { record = new DbCache.CacheRecord(); record.Value = Functions.Diagramobjects(); record.LastUpdate = DateTime.Now; record.Valid = true; DbCache.SetRecord(key, record); } return (DbNullable<int>)record.Value; }
public static DbNullable<int> FceWorkDays(DbNullable<DateTime> dateFrom, DbNullable<DateTime> dateTill) { DbCache.FunctionKey key = new DbCache.FunctionKey("FceWorkDays"); DbCache.CacheRecord record; key.Set(dateFrom, dateTill); if (DbCache.Contains(key)) { record = DbCache.GetRecord(key); if (!record.IsValid()) { record.Value = Functions.FceWorkDays(dateFrom, dateTill); record.LastUpdate = DateTime.Now; record.Valid = true; } } else { record = new DbCache.CacheRecord(); record.Value = Functions.FceWorkDays(dateFrom, dateTill); record.LastUpdate = DateTime.Now; record.Valid = true; DbCache.SetRecord(key, record); } return (DbNullable<int>)record.Value; }
public static DbNullable<string> FcePrmExcelTemp() { DbCache.FunctionKey key = new DbCache.FunctionKey("FcePrmExcelTemp"); DbCache.CacheRecord record; key.Set(); if (DbCache.Contains(key)) { record = DbCache.GetRecord(key); if (!record.IsValid()) { record.Value = Functions.FcePrmExcelTemp(); record.LastUpdate = DateTime.Now; record.Valid = true; } } else { record = new DbCache.CacheRecord(); record.Value = Functions.FcePrmExcelTemp(); record.LastUpdate = DateTime.Now; record.Valid = true; DbCache.SetRecord(key, record); } return (DbNullable<string>)record.Value; }
public static DbNullable<decimal> FceGetTotalWeightVyskladneni(DbNullable<int> pKV) { DbCache.FunctionKey key = new DbCache.FunctionKey("FceGetTotalWeightVyskladneni"); DbCache.CacheRecord record; key.Set(pKV); if (DbCache.Contains(key)) { record = DbCache.GetRecord(key); if (!record.IsValid()) { record.Value = Functions.FceGetTotalWeightVyskladneni(pKV); record.LastUpdate = DateTime.Now; record.Valid = true; } } else { record = new DbCache.CacheRecord(); record.Value = Functions.FceGetTotalWeightVyskladneni(pKV); record.LastUpdate = DateTime.Now; record.Valid = true; DbCache.SetRecord(key, record); } return (DbNullable<decimal>)record.Value; }
public static QFComponentsPhoto CachedLoad(int componentID) { DbCache.TableKey key = new DbCache.TableKey("QFComponentsPhoto"); DbCache.CacheRecord record; key.Set(componentID); if (DbCache.Contains(key)) { record = DbCache.GetRecord(key); if (!record.IsValid()) { record.Value = Load(componentID); record.LastUpdate = DateTime.Now; record.Valid = true; } } else { record = new DbCache.CacheRecord(); record.Value = Load(componentID); record.LastUpdate = DateTime.Now; record.Valid = true; DbCache.SetRecord(key, record); } return (QFComponentsPhoto)record.Value; }
public static QFTimesRevisionDialog CachedLoad(int timesRevisionID) { DbCache.TableKey key = new DbCache.TableKey("QFTimesRevisionDialog"); DbCache.CacheRecord record; key.Set(timesRevisionID); if (DbCache.Contains(key)) { record = DbCache.GetRecord(key); if (!record.IsValid()) { record.Value = Load(timesRevisionID); record.LastUpdate = DateTime.Now; record.Valid = true; } } else { record = new DbCache.CacheRecord(); record.Value = Load(timesRevisionID); record.LastUpdate = DateTime.Now; record.Valid = true; DbCache.SetRecord(key, record); } return (QFTimesRevisionDialog)record.Value; }
public static QFPrikazVyskladDetail CachedLoad(int iDPrikazVYskladDetail, int prikazVyskladID) { DbCache.TableKey key = new DbCache.TableKey("QFPrikazVyskladDetail"); DbCache.CacheRecord record; key.Set(iDPrikazVYskladDetail, prikazVyskladID); if (DbCache.Contains(key)) { record = DbCache.GetRecord(key); if (!record.IsValid()) { record.Value = Load(iDPrikazVYskladDetail, prikazVyskladID); record.LastUpdate = DateTime.Now; record.Valid = true; } } else { record = new DbCache.CacheRecord(); record.Value = Load(iDPrikazVYskladDetail, prikazVyskladID); record.LastUpdate = DateTime.Now; record.Valid = true; DbCache.SetRecord(key, record); } return (QFPrikazVyskladDetail)record.Value; }