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_NOTAFISCALEntity> comparer = new Phydeaux.Utilities.DynamicComparer <LIS_NOTAFISCALEntity>(orderBy);
LIS_NOTAFISCALCollRelatPers.Sort(comparer.Comparer);
}
////adiciona uma linha no rodape do grid
LIS_NOTAFISCALEntity AddLinha = new LIS_NOTAFISCALEntity();
AddLinha.IDNOTAFISCAL = null;
LIS_NOTAFISCALCollRelatPers.Add(AddLinha);
DataGridPerson.DataSource = LIS_NOTAFISCALCollRelatPers;
PercorreDataGrid();
}
private static LIS_NOTAFISCALEntity FillEntityObject(ref FbDataReader DataReader)
{
LIS_NOTAFISCALEntity entity = new LIS_NOTAFISCALEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDNOTAFISCAL = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDNOTAFISCAL"));
entity.NFISCAL = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NFISCAL"));
entity.SERIE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("SERIE"));
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.DTSAIDA = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DTSAIDA"));
entity.HORASAIDA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("HORASAIDA"));
entity.IDTIPOMOVIM = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDTIPOMOVIM"));
entity.NOMEMOVIMESTOQUE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEMOVIMESTOQUE"));
entity.IDCFOP = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCFOP"));
entity.DESCCFOP = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DESCCFOP"));
entity.CODCFOP = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CODCFOP"));
entity.INSCESTSTRIB = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("INSCESTSTRIB"));
entity.BASECALCICMS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("BASECALCICMS"));
entity.VALORICMS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORICMS"));
entity.BASECALCICMSLSUB = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("BASECALCICMSLSUB"));
entity.VALORICMSSUB = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORICMSSUB"));
entity.VALORFRETE = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORFRETE"));
entity.VALORSEGURO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORSEGURO"));
entity.OUTRADESPES = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("OUTRADESPES"));
entity.TOTALIPI = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALIPI"));
entity.TOTALPRODUTOS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALPRODUTOS"));
entity.TOTALNOTA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALNOTA"));
entity.IDVENDEDOR = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDVENDEDOR"));
entity.NOMEVENDEDOR = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEVENDEDOR"));
entity.VALORCOMISSAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORCOMISSAO"));
entity.IDTRANSPORTES = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDTRANSPORTES"));
entity.NOMETRANSPORTADORA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMETRANSPORTADORA"));
entity.PLACA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("PLACA"));
entity.IDUF = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDUF"));
entity.QUANT = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("QUANT"));
entity.ESPECIE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("ESPECIE"));
entity.MARCA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("MARCA"));
entity.NUMEROS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NUMEROS"));
entity.PESOBRUTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PESOBRUTO"));
entity.PESOLIQUIDO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PESOLIQUIDO"));
entity.INFOCOMPLEM = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("INFOCOMPLEM"));
entity.IDCENTROCUSTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCENTROCUSTO"));
entity.CENTROCUSTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CENTROCUSTO"));
entity.DESCCENTROCUSTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DESCCENTROCUSTO"));
entity.IDFORMAPAGTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDFORMAPAGTO"));
entity.NOMEFORMAPAGTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEFORMAPAGTO"));
entity.IDLOCALCOBRANCA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDLOCALCOBRANCA"));
entity.NOMELOCCOBRANCA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMELOCCOBRANCA"));
entity.IDSTATUS = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDSTATUS"));
entity.NOMESTATUS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMESTATUS"));
entity.VALORPAGO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORPAGO"));
entity.VALORDEVEDOR = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORDEVEDOR"));
entity.FRETE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("FRETE"));
entity.PORCDESCONTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCDESCONTO"));
entity.VALORDESCONTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORDESCONTO"));
entity.PORCACRESCIMO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCACRESCIMO"));
entity.VALORACRESCIMO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORACRESCIMO"));
return(entity);
}
