public void UpdateManyByProdutor(long idProdutor)
{
var ticks = DateTime.Now.Ticks;
this.OptimizedUpdate(GISAUtils.GetIdsNiveisDocumentaisComProdutores(idProdutor));
log.Debug("UpdateManyByProdutor: " + new TimeSpan(DateTime.Now.Ticks - ticks).ToString());
}
public override void CreateIndex()
{
using (IndexWriter indexWriter = new IndexWriter(this.index, new NivelDocumentalSearcher.InstancePerFieldAnalyzerWrapper().instancePerFieldAnalyzerWrapper, IndexWriter.MaxFieldLength.UNLIMITED))
{
GISAUtils.getAllNivelDocumentalIds().ToList().ForEach(id => indexWriter.AddDocument(this.GetDocument(id)));
indexWriter.Optimize();
indexWriter.Dispose();
}
}
public override void CreateIndex()
{
using (IndexWriter indexWriter = new IndexWriter(this.index, new SynonymAnalyzer(new XmlSynonymEngine()), IndexWriter.MaxFieldLength.UNLIMITED))
{
GISAUtils.getAllNivelDocumentalInternetIds().ToList().ForEach(id => indexWriter.AddDocument(this.GetDocument(id)));
indexWriter.Optimize();
indexWriter.Dispose();
}
}
public void GetUser()
{
IList <long> ids = GISAUtils.GetTrusteeUsersIds("leitor");
foreach (long id in ids)
{
Console.WriteLine(id);
}
Assert.AreEqual(1, ids.Count);
}
public void GetAllUnidadesFisicas()
{
IList <long> ids = GISAUtils.getAllUnidadesFisicasIds();
foreach (long id in ids)
{
UnidadeFisica uf = new UnidadeFisica(id);
Assert.IsNotNull(uf);
}
}
public void MyUpdate(List <string> idsNivel)
{
//GISAUtils.GetIdsNiveisDocumentaisInternet(idsNivel);
//this.Update(idsNivel);
var ticks = DateTime.Now.Ticks;
this.OptimizedUpdate(GISAUtils.GetIdsNiveisDocumentaisInternet(idsNivel));
log.Debug("UpdateManyIdsNiveisDocumentaisInternet: " + new TimeSpan(DateTime.Now.Ticks - ticks).ToString());
}
public void GetGroup()
{
IList <long> ids = GISAUtils.GetTrusteeUsersIds("t.Name = 'todos'");
foreach (long id in ids)
{
Console.WriteLine(id);
}
Console.WriteLine("ids.count: {0}", ids.Count);
Assert.IsTrue(ids.Count > 1);
}
public new string Search(string searchText)
{
string operador = GISAUtils.buildOperatorSearchString(ref searchText);
DateTime?inicio = null;
DateTime?fim = null;
searchText = GISAUtils.buildDataInicialDataFinalSearchString(searchText, out inicio, out fim);
List <string> nivelIds = GISAUtils.GetNivelIds(operador, inicio, fim);
List <string> luceneResults;
if (nivelIds == null) //no parameter was actually filled for GetNivelIds()
{
luceneResults = base.Search(searchText);
}
else
{
if (nivelIds.Count > 0)
{
if (searchText.Length > 0)
{
string a = GISAUtils.buildList_Id_OR_Id(searchText, nivelIds);
luceneResults = base.Search(a);
}
else
{
luceneResults = nivelIds;
}
}
else
{
luceneResults = new List <string>();
}
}
Dictionary <string, string> test = new Dictionary <string, string>();
List <string> ret = new List <string>();
foreach (string id in luceneResults)
{
if (test.ContainsKey(id))
{
continue;
}
test.Add(id, id);
ret.Add(id);
}
return(string.Join(" ", ret.ToArray()));
}
public void GetARandomUnidadeFisica()
{
IList <long> ids = GISAUtils.getAllUnidadesFisicasIds();
if (ids.Count > 0)
{
Random random = new Random();
int pos = random.Next(0, ids.Count - 1);
UnidadeFisica uf = new UnidadeFisica(ids[pos]);
Assert.IsNotNull(uf);
}
}
public void DateWellFormedString()
{
IList <long> ids = GISAUtils.getAllUnidadesFisicasIds();
foreach (long id in ids)
{
UnidadeFisica uf = new UnidadeFisica(id);
Console.WriteLine(uf.DataInicioProd);
Console.WriteLine(uf.DataFimProd);
Assert.AreEqual(8, uf.DataInicioProd.Length);
Assert.AreEqual(8, uf.DataFimProd.Length);
}
}
public string Search(string searchText, long idTrustee)
{
var results = this.queryCacher.SearchInCache(idTrustee, searchText);
if (results != null)
{
return(string.Join(" ", results.ToArray()));
}
string operador = GISAUtils.buildOperatorSearchString(ref searchText);
DateTime?inicio;
DateTime?fim;
searchText = GISAUtils.buildDataInicialDataFinalSearchString(searchText, out inicio, out fim);
List <string> nivelIds = GISAUtils.GetNivelIds(operador, inicio, fim);
List <string> luceneResults;
if (nivelIds == null) //no parameter was actually filled for GetNivelIds()
{
luceneResults = base.Search(searchText);
}
else
{
if (nivelIds.Count > 0)
{
if (searchText.Length > 0)
{
string a = GISAUtils.buildList_Id_OR_Id(searchText, nivelIds);
luceneResults = base.Search(a);
}
else
{
luceneResults = nivelIds;
}
}
else
{
luceneResults = new List <string>();
}
}
var c = DateTime.Now.Ticks;
var ret = Util.FilterByReadPermission(luceneResults, idTrustee);
var b = new TimeSpan(DateTime.Now.Ticks - c).ToString();
queryCacher.Add(idTrustee, searchText, luceneResults);
return(string.Join(" ", ret.ToArray()));
}
public void GetFRDBases()
{
var ids = GISAUtils.GetNivelIds(string.Empty, null, new DateTime(2008, 10, 30));
if (ids == null)
{
Assert.Fail("Parameters not specified?!");
}
foreach (string id in ids)
{
Console.WriteLine(id);
}
Console.WriteLine("ids.count: {0}", ids.Count);
Assert.IsTrue(ids.Count > 1);
}
public void GetARandomDocument()
{
IList <long> ids = GISAUtils.getAllNivelDocumentalIds();
if (ids.Count > 0)
{
Random random = new Random();
int pos = random.Next(0, ids.Count - 1);
long initMemory = GC.GetTotalMemory(true);
NivelDocumental doc = new NivelDocumental(ids[pos]);
long usedMemory = (GC.GetTotalMemory(true) - initMemory) / 1024;
Console.WriteLine("One Document Memory: " + usedMemory.ToString() + "KB");
Assert.IsNotNull(doc);
}
}
public static List <string> FilterByReadPermission(List <string> ids, long idTrustee)
{
ISession session = null;
var res = new List <string>();
try
{
session = GISAUtils.SessionFactory.OpenSession();
using (SqlCommand command = new SqlCommand(string.Empty, (SqlConnection)session.Connection))
{
GISAUtils.ImportIDs(ids.ToArray(), (SqlConnection)session.Connection);
command.CommandText = "CREATE TABLE #effective (IDNivel BIGINT PRIMARY KEY, IDUpper BIGINT, Ler TINYINT)";
command.ExecuteNonQuery();
command.CommandText = "INSERT INTO #effective SELECT ID, ID, null FROM #temp ORDER BY #temp.seq_nr";
command.ExecuteNonQuery();
command.CommandText = "sp_getEffectiveReadPermissions";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@IDTrustee", SqlDbType.BigInt);
command.Parameters[0].Value = idTrustee;
command.ExecuteNonQuery();
command.Parameters.Clear();
command.CommandType = CommandType.Text;
command.CommandText = "SELECT IDNivel FROM #effective INNER JOIN #temp ON #temp.ID = #effective.IDNivel WHERE Ler = 1 ORDER BY #temp.seq_nr";
var reader = command.ExecuteReader();
while (reader.Read())
{
res.Add(reader.GetInt64(0).ToString());
}
reader.Close();
}
}
catch (Exception) { throw; }
finally
{
if (session != null)
{
session.Close();
}
}
return(res);
}
public new string Search(string searchText)
{
string operador = GISAUtils.buildOperatorSearchString(ref searchText);
DateTime?inicio;
DateTime?fim;
searchText = GISAUtils.buildDataInicialDataFinalSearchString(searchText, out inicio, out fim);
List <string> nivelIds = GISAUtils.GetNivelIds(operador, inicio, fim);
List <string> luceneResults;
if (nivelIds == null) //no parameter was actually filled for GetNivelIds()
{
luceneResults = base.Search(searchText);
}
else
{
if (nivelIds.Count > 0)
{
if (searchText.Length > 0)
{
string a = GISAUtils.buildList_Id_OR_Id(searchText, nivelIds);
luceneResults = base.Search(a);
}
else
{
luceneResults = nivelIds;
}
}
else
{
luceneResults = new List <string>();
}
}
return(string.Join(" ", luceneResults.ToArray()));
}
public void GetAllNivelDocumental()
{
try
{
IList <long> ids = GISAUtils.getAllNivelDocumentalIds();
long initMemory = GC.GetTotalMemory(true);
foreach (long id in ids)
{
NivelDocumental doc = new NivelDocumental(id);
Assert.IsNotNull(doc);
}
long usedMemory = (GC.GetTotalMemory(true) - initMemory) / 1024;
GC.Collect();
GC.WaitForPendingFinalizers();
Console.WriteLine("All Documents Memory: " + usedMemory.ToString() + "KB");
}
catch (InsufficientMemoryException)
{
Console.WriteLine("It's too much for me...!");
}
}
public UnidadeFisica(long idNivel)
{
ISession session = null;
try
{
session = GISAUtils.SessionFactory.OpenSession();
var ufs = session.CreateSQLQuery(GISAUtils.getAllUnidadesFisicasQuery + " and n.ID = " + idNivel.ToString());
ufs.SetTimeout(1000);
foreach (var uf in ufs.List <object[]>())
{
this.id = uf[0].ToString();
this.numero = uf[1].ToString();
this.designacao = uf[2].ToString();
this.codigoBarras = uf[3].ToString();
this.guiaIncorporacao = uf[4].ToString();
this.eliminado = uf[5].ToString().Equals("1") ? "sim" : "nao";
this.cota = uf[6].ToString();
this.dataInicioProd = GISAUtils.DataInicioProdFormatada(uf[7].ToString(), uf[8].ToString(), uf[9].ToString());
this.dataFimProd = GISAUtils.DataInicioProdFormatada(uf[10].ToString(), uf[11].ToString(), uf[12].ToString());
this.conteudoInformacional = uf[13].ToString();
this.tipoUnidadeFisica = uf[14].ToString();
}
}
catch (Exception) { throw; }
finally
{
if (session != null)
{
session.Close();
}
}
//ISession session = null;
//try
//{
// session = GISAUtils.SessionFactory.OpenSession();
// // Codigo e designacao
// NivelEntity nivel = session.Get<NivelEntity>(idNivel);
// if (nivel != null && nivel.Codigo != null && !nivel.IsDeleted)
// {
// this.id = nivel.Id.ToString();
// this.numero = nivel.Codigo;
// NivelDesignadoEntity nd = session.Get<NivelDesignadoEntity>(nivel.Id);
// if (nd != null && nd.Designacao != null && !nd.IsDeleted)
// {
// this.designacao = nd.Designacao;
// NivelUnidadeFisicaEntity nuf = session.Get<NivelUnidadeFisicaEntity>(nd.Id);
// if (nuf != null && nuf.CodigoBarras != null && !nuf.IsDeleted)
// this.CodigoBarras = nuf.CodigoBarras.ToString();
// }
// // Guia de incorporacao, Eliminado:
// NivelUnidadeFisicaEntity nufe = session.Get<NivelUnidadeFisicaEntity>(nivel.Id);
// if (nufe != null && !nufe.IsDeleted)
// {
// if (nufe.GuiaIncorporacao != null)
// this.guiaIncorporacao = nufe.GuiaIncorporacao;
// this.eliminado = nufe.Eliminado ? "sim" : "nao";
// }
// else
// this.eliminado = "nao";
// }
// long idFRDBase = -1;
// IQuery qFrdbase = session.CreateQuery("from FRDBaseEntity frdb WHERE frdb.Nivel.Id = " + idNivel);
// qFrdbase.SetTimeout(1000);
// FRDBaseEntity frdbase = qFrdbase.UniqueResult<FRDBaseEntity>();
// if (frdbase == null)
// {
// return;
// }
// idFRDBase = frdbase.Id;
// // Cota
// SFRDUFCotaEntity sfrdufc = session.Get<SFRDUFCotaEntity>(idFRDBase);
// if (sfrdufc != null && !sfrdufc.IsDeleted)
// {
// if (sfrdufc.Cota != null)
// this.cota = sfrdufc.Cota;
// }
// // Datas de producao
// SFRDDatasProducaoEntity sfrddp = session.Get<SFRDDatasProducaoEntity>(idFRDBase);
// this.dataInicioProd = GISAUtils.DataInicioProdFormatada(sfrddp);
// this.dataFimProd = GISAUtils.DataFimProdFormatada(sfrddp);
// // Conteudo informacional e guia incorporacao
// SFRDConteudoEEstruturaEntity sfrdcee = session.Get<SFRDConteudoEEstruturaEntity>(idFRDBase);
// if (sfrdcee != null && sfrdcee.ConteudoInformacional != null && !sfrdcee.IsDeleted)
// {
// this.conteudoInformacional = sfrdcee.ConteudoInformacional;
// }
// // Tipo de unidade fisica
// SFRDUFDescricaoFisicaEntity sfrdufdf = session.Get<SFRDUFDescricaoFisicaEntity>(idFRDBase);
// if (sfrdufdf != null && !sfrdufdf.IsDeleted)
// {
// TipoAcondicionamentoEntity ta = sfrdufdf.TipoAcondicionamento;
// if (ta != null && ta.Designacao != null && !ta.IsDeleted)
// {
// this.tipoUnidadeFisica = ta.Designacao;
// }
// }
// // Operador/Grupo - on the fly
// // Unidades arquivisticas - on the fly
//}
//catch (Exception) { throw; }
//finally
//{
// if (session != null) session.Close();
//}
}
