public bool updateCache(DocsPaVO.Caching.InfoFileCaching info)
{
bool result = true;
DocsPaUtils.Query q = DocsPaUtils.InitQuery.getInstance().getQuery("U_CACHE");
q.setParam("docnumber", info.DocNumber.ToString());
q.setParam("pathcache", "'" + info.CacheFilePath + "'");
q.setParam("idAmministrazione", "'" + info.idAmministrazione + "'");
q.setParam("aggiornato", info.Aggiornato.ToString());
q.setParam("version_id", info.Version_id.ToString());
q.setParam("loked", "'" + info.locked.ToString() + "'");
q.setParam("comptype", "'" + info.comptype + "'");
q.setParam("file_size", info.file_size.ToString());
q.setParam("alternate_path", "'" + info.alternate_path + "'");
q.setParam("var_impronta", "'" + info.var_impronta + "'");
q.setParam("ext", "'" + info.ext.Trim() + "'");
q.setParam("data", "'" + info.last_access + "'");
string sql = q.getSQL();
logger.Debug("updateCache - query:" + sql);
if (!this.ExecuteNonQuery(sql))
{
result = false;
throw new Exception();
}
return(result);
}
public bool updateComponentCache(DocsPaVO.Caching.InfoFileCaching info)
{
bool result = true;
DocsPaUtils.Query q = DocsPaUtils.InitQuery.getInstance().getQuery("U_CACHE_COMPONENTS");
q.setParam("DOCNUMBER", info.DocNumber.ToString());
q.setParam("VERSION_ID", info.Version_id.ToString());
q.setParam("LOCKED", "'" + info.locked.ToString() + "'");
q.setParam("COMPTYPE", "'" + info.comptype + "'");
q.setParam("FILE_SIZE", info.file_size.ToString());
q.setParam("ALTERNATE_PATH", "'" + info.alternate_path + "'");
q.setParam("VAR_IMPRONTA", "'" + info.var_impronta + "'");
q.setParam("EXT", "'" + info.ext + "'");
q.setParam("PATH", "'" + info.CacheFilePath + "'");
string sql = q.getSQL();
logger.Debug("updateComponentCache - query:" + sql);
if (!this.ExecuteNonQuery(sql))
{
result = false;
throw new Exception();
}
return(result);
}
public DocsPaVO.Caching.InfoFileCaching massimaVersioneDelDocumentoComponents(string docnumber)
{
DocsPaVO.Caching.InfoFileCaching info = null;
DocsPaUtils.Query sql = DocsPaUtils.InitQuery.getInstance().getQuery("S_CACHE_MAX_VESIONE_COMPONENTS");
sql.setParam("docnumber", docnumber.ToString());
logger.Debug("massimaVersioneDelDocumentoComponents - query:" + sql.getSQL());
using (DocsPaDB.DBProvider dbProvider = new DocsPaDB.DBProvider())
{
using (System.Data.IDataReader reader = dbProvider.ExecuteReader(sql.getSQL()))
{
if (reader != null)
{
while (reader.Read())
{
info = new InfoFileCaching();
info.CacheFilePath = reader.GetString(reader.GetOrdinal("pathcache"));
info.ext = reader.GetString(reader.GetOrdinal("ext"));
info.Version_id = reader.GetInt32(reader.GetOrdinal("version_id"));
}
}
}
}
return(info);
}