private void GetDropFornecedor()
{
try
{
FORNECEDORProvider FORNECEDORP = new FORNECEDORProvider();
FORNECEDORColl = FORNECEDORP.ReadCollectionByParameter(null, "NOME");
cbFornecedor.DisplayMember = "NOME";
cbFornecedor.ValueMember = "IDFORNECEDOR";
FORNECEDOREntity FORNECEDORTy = new FORNECEDOREntity();
FORNECEDORTy.NOME = ConfigMessage.Default.MsgDrop;
FORNECEDORTy.IDFORNECEDOR = -1;
FORNECEDORColl.Add(FORNECEDORTy);
Phydeaux.Utilities.DynamicComparer <FORNECEDOREntity> comparer = new Phydeaux.Utilities.DynamicComparer <FORNECEDOREntity>(cbFornecedor.DisplayMember);
FORNECEDORColl.Sort(comparer.Comparer);
cbFornecedor.DataSource = FORNECEDORColl;
cbFornecedor.SelectedIndex = 0;
}
catch (Exception ex)
{
MessageBox.Show("Erro técnico: " + ex.Message);
}
}
private static FORNECEDORCollection ExecuteReader(ref FORNECEDORCollection collection, ref FbDataReader dataReader, FbCommand dbCommand)
{
using (dataReader = dbCommand.ExecuteReader())
{
collection = new FORNECEDORCollection();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
collection.Add(FillEntityObject(ref dataReader));
}
}
if (!(dataReader.IsClosed))
{
dataReader.Close();
}
dataReader.Dispose();
}
return(collection);
}