private static LIS_CONSIGNACAOEntity FillEntityObject(ref FbDataReader DataReader)
{
LIS_CONSIGNACAOEntity entity = new LIS_CONSIGNACAOEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDCONSIGNACAO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCONSIGNACAO"));
entity.IDCLIENTE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCLIENTE"));
entity.NOMECLIENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMECLIENTE"));
entity.DTEMISSAO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DTEMISSAO"));
entity.DTVALIDADE = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DTVALIDADE"));
entity.IDSTATUS = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDSTATUS"));
entity.NOMESTATUS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMESTATUS"));
entity.PRAZOENTREGA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("PRAZOENTREGA"));
entity.IDFORMAPAGTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDFORMAPAGTO"));
entity.NOMEFORMAPGTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEFORMAPGTO"));
entity.IDFUNCIONARIO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDFUNCIONARIO"));
entity.NOMEFUNCIONARIO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEFUNCIONARIO"));
entity.IDTRANSPORTES = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDTRANSPORTES"));
entity.NOMETRANPORTES = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMETRANPORTES"));
entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO"));
entity.TOTALIPI = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALIPI"));
entity.PORCDESCONTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCDESCONTO"));
entity.TOTALDESCONTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALDESCONTO"));
entity.PORCACRESCIMO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCACRESCIMO"));
entity.TOTALACRESCIMO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALACRESCIMO"));
entity.TOTAORCAMENTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTAORCAMENTO"));
return(entity);
}
private void AddColPersonalizada()
{
DataGridPerson.DataSource = null;
DataGridPerson.AutoGenerateColumns = false;
int i = 0;
foreach (LIS_CAMPOSRELATPERSEntity item in LIS_CAMPOSRELATPERSColl)
{
DataGridPerson.Columns.Add(item.NOMEBANCODADOS, item.NOMECAMPOS);
if (item.SOMATORIO == "1")
{
listColunaSumn.Add(i);
}
if (item.ORDEM == 1)
{
CampoOrdenar = item.NOMEBANCODADOS;
}
DataGridPerson.Columns[i].DataPropertyName = item.NOMEBANCODADOS;
DataGridPerson.Columns[i].Width = Convert.ToInt32(item.TAMANHO);
//Formatando as celulas
string TypeField = ReturnTypeField(Convert.ToInt32(item.IDCAMPO));
switch (TypeField)
{
case "NUMERIC":
DataGridPerson.Columns[i].DefaultCellStyle.Format = "N2";
DataGridPerson.Columns[i].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
break;
case "INTEGER":
DataGridPerson.Columns[i].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
break;
}
i++;
}
//Ordenar o campos selecionado
if (CampoOrdenar != string.Empty)
{
string orderBy = CampoOrdenar;
Phydeaux.Utilities.DynamicComparer <LIS_CONSIGNACAOEntity> comparer = new Phydeaux.Utilities.DynamicComparer <LIS_CONSIGNACAOEntity>(orderBy);
LIS_CONSIGNACAOCollRelatPers.Sort(comparer.Comparer);
}
////adiciona uma linha no rodape do grid
LIS_CONSIGNACAOEntity AddLinha = new LIS_CONSIGNACAOEntity();
AddLinha.IDCONSIGNACAO = null;
LIS_CONSIGNACAOCollRelatPers.Add(AddLinha);
DataGridPerson.DataSource = LIS_CONSIGNACAOCollRelatPers;
PercorreDataGrid();
}