private void btnPesquisa_Click(object sender, EventArgs e)
{
if (Validacoes())
{
CreaterCursor Cr = new CreaterCursor();
this.Cursor = Cr.CreateCursor(Cr.btmap, 0, 0);
try
{
RowRelatorio.Clear();
string DataInicial = Util.ConverStringDateSearch(msktDataInicial.Text);
string DataFinal = Util.ConverStringDateSearch(msktDataFinal.Text);
RowRelatorio.Add(new RowsFiltro("DATACONTATO", "System.DateTime", ">=", DataInicial));
RowRelatorio.Add(new RowsFiltro("DATACONTATO", "System.DateTime", "<=", DataFinal));
LIS_OCORRENCIATLMKColl = LIS_OCORRENCIATLMKP.ReadCollectionByParameter(RowRelatorio);
//Remove ID repetido
LIS_OCORRENCIATLMKCollection LIS_OCORRENCIATLMKColl2 = new LIS_OCORRENCIATLMKCollection();
foreach (LIS_OCORRENCIATLMKEntity item in LIS_OCORRENCIATLMKColl)
{
if (LIS_OCORRENCIATLMKColl2.Find(delegate(LIS_OCORRENCIATLMKEntity item2)
{
return
(item2.IDFUNCIONARIO == item.IDFUNCIONARIO);
}) == null)
{
LIS_OCORRENCIATLMKColl2.Add(item);
}
}
LIS_OCORRENCIATLMKColl.Clear();
LIS_OCORRENCIATLMKColl = LIS_OCORRENCIATLMKColl2;
PreencheGrid();
this.Cursor = Cursors.Default;
}
catch (Exception EX)
{
this.Cursor = Cursors.Default;
MessageBox.Show("Erro na pesquisa!");
MessageBox.Show("Erro técnico: " + EX.Message);
}
}
}
private static LIS_OCORRENCIATLMKCollection ExecuteReader(ref LIS_OCORRENCIATLMKCollection collection, ref FbDataReader dataReader, FbCommand dbCommand)
{
using (dataReader = dbCommand.ExecuteReader())
{
collection = new LIS_OCORRENCIATLMKCollection();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
collection.Add(FillEntityObject(ref dataReader));
}
}
if (!(dataReader.IsClosed))
{
dataReader.Close();
}
dataReader.Dispose();
}
return(collection);
}