Example #1
0
 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;
 }
Example #2
0
 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;
 }
Example #3
0
 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;
 }
Example #4
0
 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;
 }
Example #5
0
 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;
 }
Example #6
0
 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;
 }