/// <summary> /// Retorna lista de grupo filtrando pelo objeto por SQL query /// </summary> public static LIType FindBySql(IType objiType, string sql) { sql = string.Format(sql, GetTableName(objiType)); if (objiType.Transaction != null) { return(new CData().FindBySql(ref objiType, sql)); } string key = CacheKeySql(sql); var objCache = Cache.Get(key); if (objCache != null && !(objCache is LIType)) { Cache.Invalidate(key); } LIType listWithCache = (LIType)Cache.Get(key); if (listWithCache != null) { return(listWithCache); } LIType list = new CData().FindBySql(ref objiType, sql); Cache.Add(key, list, DateTime.Now.AddMinutes(Cache.MinutesOfEspirationCache())); return(list); }
/// <summary> /// Retorna lista de grupo filtrando pelo objeto por condição /// </summary> public static LIType FindByConditions(IType objiType, string conditions) { if (objiType.Transaction != null) { return(new CData().FindByConditions(ref objiType, conditions)); } string key = CacheKey(objiType, conditions); var objCache = Cache.Get(key); if (objCache != null && !(objCache is LIType)) { Cache.Invalidate(key); } LIType listWithCache = (LIType)Cache.Get(key); if (listWithCache != null) { return(listWithCache); } LIType list = new CData().FindByConditions(ref objiType, conditions); Cache.Add(key, list, DateTime.Now.AddMinutes(Cache.MinutesOfEspirationCache())); return(list); }
/// <summary> /// Retorna lista de grupo filtrando pelo objeto por SQL query /// </summary> public static LIType FindBySql(IType objiType, string sql) { sql = string.Format(sql, GetTableName(objiType)); if (objiType.Transaction != null) return new CData().FindBySql(ref objiType, sql); string key = CacheKeySql(sql); var objCache = Cache.Get(key); if (objCache != null && !(objCache is LIType)) Cache.Invalidate(key); LIType listWithCache = (LIType)Cache.Get(key); if (listWithCache != null) return listWithCache; LIType list = new CData().FindBySql(ref objiType, sql); Cache.Add(key, list, DateTime.Now.AddMinutes(Cache.MinutesOfEspirationCache())); return list; }
/// <summary> /// Retorna lista de grupo filtrando pelo objeto por condição /// </summary> public static LIType FindByConditions(IType objiType, string conditions) { if(objiType.Transaction != null) return new CData().FindByConditions(ref objiType, conditions); string key = CacheKey(objiType, conditions); var objCache = Cache.Get(key); if (objCache != null && !(objCache is LIType)) Cache.Invalidate(key); LIType listWithCache = (LIType)Cache.Get(key); if (listWithCache != null) return listWithCache; LIType list = new CData().FindByConditions(ref objiType, conditions); Cache.Add(key, list, DateTime.Now.AddMinutes(Cache.MinutesOfEspirationCache())); return list; }