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