private static LIS_ORCAMENTOEntity FillEntityObject(ref FbDataReader DataReader) { LIS_ORCAMENTOEntity entity = new LIS_ORCAMENTOEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDORCAMENTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDORCAMENTO")); 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.NOMETRANSPORTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMETRANSPORTE")); 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_ORCAMENTOEntity> comparer = new Phydeaux.Utilities.DynamicComparer <LIS_ORCAMENTOEntity>(orderBy); LIS_ORCAMENTOCollRelatPers.Sort(comparer.Comparer); } ////adiciona uma linha no rodape do grid LIS_ORCAMENTOEntity AddLinha = new LIS_ORCAMENTOEntity(); AddLinha.IDORCAMENTO = null; LIS_ORCAMENTOCollRelatPers.Add(AddLinha); DataGridPerson.DataSource = LIS_ORCAMENTOCollRelatPers; PercorreDataGrid(); }