private static NOTASERVICOEntity FillEntityObject(ref FbDataReader DataReader) { NOTASERVICOEntity entity = new NOTASERVICOEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDNOTASERVICO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDNOTASERVICO")); entity.NPS = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("NPS")); entity.DATAEMISSAO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATAEMISSAO")); entity.CODNATUREZA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("CODNATUREZA")); entity.REGIMETRIBUTACAO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("REGIMETRIBUTACAO")); entity.IDCLIENTE = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDCLIENTE")); entity.DEDUCAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("DEDUCAO")); entity.PIS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PIS")); entity.COFINS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("COFINS")); entity.INSS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("INSS")); entity.IMPOSTORENDA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("IMPOSTORENDA")); entity.CONTRIBUICAOSOCIAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("CONTRIBUICAOSOCIAL")); entity.ISS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ISS")); entity.ISSRETIDO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ISSRETIDO")); entity.OUTRASRETENCOES = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("OUTRASRETENCOES")); entity.BASECALCULO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("BASECALCULO")); entity.ALIQSERVICO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALIQSERVICO")); entity.DESCONTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("DESCONTO")); entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO")); entity.DESCRICAODETALSERVICO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DESCRICAODETALSERVICO")); entity.TOTALSERVICO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALSERVICO")); entity.IDCENTROCUSTO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDCENTROCUSTO")); entity.IDFORMAPAGTO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFORMAPAGTO")); entity.IDLOCALCOBRANCA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDLOCALCOBRANCA")); return(entity); }
private static LIS_PRODUTOSPEDOTICAEntity FillEntityObject(ref FbDataReader DataReader) { LIS_PRODUTOSPEDOTICAEntity entity = new LIS_PRODUTOSPEDOTICAEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDPRODPEDOTICA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPRODPEDOTICA")); entity.IDPEDIDOOTICA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPEDIDOOTICA")); entity.IDPRODUTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPRODUTO")); entity.QUANTIDADE = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("QUANTIDADE")); entity.VALORUNITARIO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORUNITARIO")); entity.VALORTOTAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORTOTAL")); entity.NOMEPRODUTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEPRODUTO")); entity.COMISSAOPEDIDO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("COMISSAOPEDIDO")); entity.DTEMISSAO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DTEMISSAO")); entity.IDCLIENTE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCLIENTE")); entity.NUMREFERENCIA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NUMREFERENCIA")); entity.IDSTATUS = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDSTATUS")); entity.PORCDECONTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCDECONTO")); entity.VLUNITLIQUIDO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VLUNITLIQUIDO")); entity.FLAGORCAMENTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGORCAMENTO")); return(entity); }
private static VENDAS_ECFEntity FillEntityObject(ref FbDataReader DataReader) { VENDAS_ECFEntity entity = new VENDAS_ECFEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.CUPOM = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CUPOM")); entity.N_CAIXA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("N_CAIXA")); entity.DATA = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATA")); entity.OPERADOR = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("OPERADOR")); entity.CLIENTE = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("CLIENTE")); entity.VENDEDOR = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("VENDEDOR")); entity.COMISSAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("COMISSAO")); entity.ACRESCIMO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ACRESCIMO")); entity.DESCONTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("DESCONTO")); entity.TOT_ISS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOT_ISS")); entity.TOT_ISS_D = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOT_ISS_D")); entity.TOT_SERVICOS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOT_SERVICOS")); entity.TOT_ICMS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOT_ICMS")); entity.TOT_PRODUTOS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOT_PRODUTOS")); entity.TOT_VENDA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOT_VENDA")); entity.CANCELADO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("CANCELADO")); entity.SEQUENCIA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("SEQUENCIA")); entity.CONVENIO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("CONVENIO")); entity.OBS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBS")); return(entity); }
private static MANUTESQUIPAMENTOEntity FillEntityObject(ref FbDataReader DataReader) { MANUTESQUIPAMENTOEntity entity = new MANUTESQUIPAMENTOEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDMANUTEESQUIPAMENTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDMANUTEESQUIPAMENTO")); entity.DATAMANUT = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATAMANUT")); entity.DATAPROXIMAMANUT = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATAPROXIMAMANUT")); entity.IDTIPOMANUTENCAO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDTIPOMANUTENCAO")); entity.IDSITUACAO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDSITUACAO")); entity.IDFUNCSOLICITANTE = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFUNCSOLICITANTE")); entity.IDFUNCEXECUTOR = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFUNCEXECUTOR")); entity.IDFORNECEDOR = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFORNECEDOR")); entity.VALORMANUTENCAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORMANUTENCAO")); entity.KMMANUTENCAO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("KMMANUTENCAO")); entity.KMPROXMANUT = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("KMPROXMANUT")); entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO")); entity.IDEQUIPAMENTO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDEQUIPAMENTO")); entity.IDCENTROCUSTO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDCENTROCUSTO")); entity.CODREFERENCIA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CODREFERENCIA")); entity.KMATUAL = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("KMATUAL")); return(entity); }
private static LIS_PRODUTONFEntity FillEntityObject(ref FbDataReader DataReader) { LIS_PRODUTONFEntity entity = new LIS_PRODUTONFEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDPRODUTONF = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPRODUTONF")); entity.IDNOTAFISCAL = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDNOTAFISCAL")); entity.IDPRODUTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPRODUTO")); entity.NOMEPRODUTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEPRODUTO")); entity.QUANTIDADE = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("QUANTIDADE")); entity.VALORUNITARIO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORUNITARIO")); entity.VALORTOTAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORTOTAL")); entity.COMISSAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("COMISSAO")); entity.ALICMS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALICMS")); entity.REDICMS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("REDICMS")); entity.VALORICMS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORICMS")); entity.ALIPI = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALIPI")); entity.VALORIPI = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORIPI")); entity.IDCLASSFISCAL = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCLASSFISCAL")); entity.IDCST = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCST")); entity.BASEICMS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("BASEICMS")); entity.IDUNIDADE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDUNIDADE")); entity.NOMEUNIDADE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEUNIDADE")); return(entity); }
private static MOVPRODUTOESEntity FillEntityObject(ref FbDataReader DataReader) { MOVPRODUTOESEntity entity = new MOVPRODUTOESEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDMOVPRODUTOES = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDMOVPRODUTOES")); entity.IDESTOQUEES = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDESTOQUEES")); entity.IDPRODUTO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDPRODUTO")); entity.QUANTIDADE = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("QUANTIDADE")); entity.VALORCUNITARIO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORCUNITARIO")); entity.VALORTOTAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORTOTAL")); entity.FLAGATUALIZACUSTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGATUALIZACUSTO")); entity.SALDOESTOQUE = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("SALDOESTOQUE")); entity.ALQICMS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALQICMS")); entity.IDCFOP = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDCFOP")); entity.BASEICMS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("BASEICMS")); entity.VLICMS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VLICMS")); entity.CST_CSOSN = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CST_CSOSN")); entity.VLIPI = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VLIPI")); entity.VLFRETE = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VLFRETE")); entity.VLBASEICMSST = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VLBASEICMSST")); entity.VLICMSST = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VLICMSST")); entity.VLDESCONTOPRODUTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VLDESCONTOPRODUTO")); return(entity); }
private static PEDIDOMARCEntity FillEntityObject(ref FbDataReader DataReader) { PEDIDOMARCEntity entity = new PEDIDOMARCEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDPEDIDOMARC = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPEDIDOMARC")); entity.IDCLIENTE = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDCLIENTE")); entity.DTEMISSAO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DTEMISSAO")); entity.IDSTATUS = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDSTATUS")); entity.PRAZOENTREGA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("PRAZOENTREGA")); entity.IDTRANSPORTES = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDTRANSPORTES")); entity.IDVENDEDOR = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDVENDEDOR")); entity.VALORCOMISSAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORCOMISSAO")); entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO")); entity.TOTALPRODUTOS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALPRODUTOS")); entity.TOTALIMPOSTOS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALIMPOSTOS")); 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")); entity.TOTALPEDIDO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALPEDIDO")); entity.IDFORMAPAGAMENTO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFORMAPAGAMENTO")); entity.VALORPAGO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORPAGO")); entity.VALORDEVEDOR = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORDEVEDOR")); entity.IDLOCALCOBRANCA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDLOCALCOBRANCA")); entity.IDCENTROCUSTOS = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDCENTROCUSTOS")); entity.TOTALMATERIAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALMATERIAL")); entity.FLAGORCAMENTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGORCAMENTO")); return(entity); }
private static TIPOTRIBUTACAOEntity FillEntityObject(ref FbDataReader DataReader) { TIPOTRIBUTACAOEntity entity = new TIPOTRIBUTACAOEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.CODIGO_TIPOTRIBUTACAO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("CODIGO_TIPOTRIBUTACAO")); entity.NOME_TIPOTRIBUTACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOME_TIPOTRIBUTACAO")); entity.TIPO_TIPOTRIBUTACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("TIPO_TIPOTRIBUTACAO")); entity.REGIME_TIPOTRIBUTACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("REGIME_TIPOTRIBUTACAO")); entity.CST_TIPOTRIBUTACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CST_TIPOTRIBUTACAO")); entity.ALIQUOTA_TIPOTRIBUTACAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALIQUOTA_TIPOTRIBUTACAO")); entity.PERCBASE_TIPOTRIBUTACAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PERCBASE_TIPOTRIBUTACAO")); entity.ALIQUOTAST_TIPOTRIBUTACAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALIQUOTAST_TIPOTRIBUTACAO")); entity.PERCBASEST_TIPOTRIBUTACAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PERCBASEST_TIPOTRIBUTACAO")); entity.CFOPVENDA_DENTROESTADO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("CFOPVENDA_DENTROESTADO")); entity.CFOPVENDA_FORAESTADO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("CFOPVENDA_FORAESTADO")); entity.CODECF_TIPOTRIBUTACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CODECF_TIPOTRIBUTACAO")); entity.CONDICAO_TIPOTRIBUTACAO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("CONDICAO_TIPOTRIBUTACAO")); entity.ALIQUOTAFE_TIPOTRIBUTACAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALIQUOTAFE_TIPOTRIBUTACAO")); entity.PERCBASEFE_TIPOTRIBUTACAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PERCBASEFE_TIPOTRIBUTACAO")); entity.ALIQUOTASTFE_TIPOTRIBUTACAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALIQUOTASTFE_TIPOTRIBUTACAO")); entity.PERCBASESTFE_TIPOTRIBUTACAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PERCBASESTFE_TIPOTRIBUTACAO")); return(entity); }
private static CONSIGNACAOEntity FillEntityObject(ref FbDataReader DataReader) { CONSIGNACAOEntity entity = new CONSIGNACAOEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDCONSIGNACAO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCONSIGNACAO")); entity.IDCLIENTE = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDCLIENTE")); entity.DTEMISSAO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DTEMISSAO")); entity.DTVALIDADE = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DTVALIDADE")); entity.IDSTATUS = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDSTATUS")); entity.PRAZOENTREGA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("PRAZOENTREGA")); entity.IDFORMAPAGTO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFORMAPAGTO")); entity.IDFUNCIONARIO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFUNCIONARIO")); entity.IDTRANSPORTES = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDTRANSPORTES")); 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 static PRODUTOSPEDIDOEntity FillEntityObject(ref FbDataReader DataReader) { PRODUTOSPEDIDOEntity entity = new PRODUTOSPEDIDOEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDPRODPEDIDO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPRODPEDIDO")); entity.IDPEDIDO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDPEDIDO")); entity.IDPRODUTO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDPRODUTO")); entity.QUANTIDADE = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("QUANTIDADE")); entity.VALORUNITARIO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORUNITARIO")); entity.VALORTOTAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORTOTAL")); entity.COMISSAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("COMISSAO")); entity.IDCOR = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDCOR")); entity.TOTALMT = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALMT")); entity.FLAGEXIBIR = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGEXIBIR")); entity.DADOSADICIONAIS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DADOSADICIONAIS")); entity.ALTURA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALTURA")); entity.LARGURA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("LARGURA")); entity.IDAMBIENTE = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDAMBIENTE")); entity.IDPRODUTOMASTER = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDPRODUTOMASTER")); entity.PORCPERDAMT = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCPERDAMT")); entity.BUSTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("BUSTO")); entity.QUADRIL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("QUADRIL")); entity.COLARINHO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("COLARINHO")); entity.MANGA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("MANGA")); entity.BARRA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("BARRA")); entity.CINTURA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("CINTURA")); entity.IDTAMANHO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDTAMANHO")); return(entity); }
private static LIS_HELPDESKEntity FillEntityObject(ref FbDataReader DataReader) { LIS_HELPDESKEntity entity = new LIS_HELPDESKEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDHELPDESK = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDHELPDESK")); entity.DATAINCLUSAO = getData.ConvertDBValueToDateTime(DataReader, DataReader.GetOrdinal("DATAINCLUSAO")); entity.DATASOLUCAO = getData.ConvertDBValueToDateTime(DataReader, DataReader.GetOrdinal("DATASOLUCAO")); entity.IDTIPOSOLICITANTE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDTIPOSOLICITANTE")); entity.TIPOSOLICITANTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("TIPOSOLICITANTE")); entity.IDDEPARTAMENTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDDEPARTAMENTO")); entity.NOMEDEPARTAMENTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEDEPARTAMENTO")); entity.IDSTATUS = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDSTATUS")); entity.NOMESTATUS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMESTATUS")); entity.IDPRIORIDADE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPRIORIDADE")); entity.NOMEPRIORIDADE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEPRIORIDADE")); entity.IDFUNCIONARIO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDFUNCIONARIO")); entity.NOMEFUNCIONARIO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEFUNCIONARIO")); entity.NOMESOLICITANTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMESOLICITANTE")); entity.EMAILSOLICITANTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("EMAILSOLICITANTE")); entity.TELEFONESOLICITANTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("TELEFONESOLICITANTE")); entity.SOLICITACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("SOLICITACAO")); entity.SOLUCAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("SOLUCAO")); return(entity); }
private static LIS_EQUIPAMENTOEntity FillEntityObject(ref FbDataReader DataReader) { LIS_EQUIPAMENTOEntity entity = new LIS_EQUIPAMENTOEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDEQUIPAMENTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDEQUIPAMENTO")); entity.NOME = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOME")); entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO")); entity.CACAMBA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CACAMBA")); entity.PESOOPERACIONAL = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("PESOOPERACIONAL")); entity.CONSUMOHORA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CONSUMOHORA")); entity.PROFESCAVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("PROFESCAVACAO")); entity.POTENCIAHP = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("POTENCIAHP")); entity.VALOR = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALOR")); entity.IDSTATUS = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDSTATUS")); entity.NOMESTATUS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMESTATUS")); entity.LOCALIZACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("LOCALIZACAO")); entity.VALORDIA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORDIA")); entity.VALORMES = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORMES")); entity.IDENTIFICACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("IDENTIFICACAO")); return(entity); }
private static PROCESSO1Entity FillEntityObject(ref FbDataReader DataReader) { PROCESSO1Entity entity = new PROCESSO1Entity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDPROCESSO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPROCESSO")); entity.NUMERO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NUMERO")); entity.DATAPUBLICACAO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATAPUBLICACAO")); entity.DATAPREVISAO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATAPREVISAO")); entity.DATAFINAL = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATAFINAL")); entity.PROCESSO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("PROCESSO")); entity.IDSTATUS = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDSTATUS")); entity.IDTRIBUNAL = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDTRIBUNAL")); entity.IDJORNAL = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDJORNAL")); entity.IDSECRETARIA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDSECRETARIA")); entity.IDFUNCIONARIO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFUNCIONARIO")); entity.IDAUTOR = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDAUTOR")); entity.IDREU = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDREU")); entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO")); entity.CODIGO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CODIGO")); entity.IDFUNCCAD = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFUNCCAD")); return(entity); }
private static LIS_FECHOSERVICOEntity FillEntityObject(ref FbDataReader DataReader) { LIS_FECHOSERVICOEntity entity = new LIS_FECHOSERVICOEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDFECHOSERVICO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDFECHOSERVICO")); entity.DATAEMISSAO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATAEMISSAO")); entity.IDORDEMSERVICO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDORDEMSERVICO")); entity.VALORORCAMENTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORORCAMENTO")); entity.PRAZOENTREGA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("PRAZOENTREGA")); entity.IDSTATUS = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDSTATUS")); entity.NOMESTATUS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMESTATUS")); entity.IDFUNCIONARIO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDFUNCIONARIO")); entity.NOMEFUNCIONARIO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEFUNCIONARIO")); entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO")); entity.TOTALITEMSERVICO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALITEMSERVICO")); entity.TOTALITEMPECA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALITEMPECA")); entity.MAOOBRA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("MAOOBRA")); entity.OUTROVALOR = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("OUTROVALOR")); entity.TOTALFECHOS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALFECHOS")); entity.GARANTIAVECTO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("GARANTIAVECTO")); entity.IDFORMAPAGAMENTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDFORMAPAGAMENTO")); entity.NOMEFORMAPAGTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEFORMAPAGTO")); entity.IDCLIENTE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCLIENTE")); entity.NOMECLIENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMECLIENTE")); return(entity); }
private static DUPLICATAPAGAREntity FillEntityObject(ref FbDataReader DataReader) { DUPLICATAPAGAREntity entity = new DUPLICATAPAGAREntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDDUPLICATAPAGAR = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDDUPLICATAPAGAR")); entity.NUMERO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NUMERO")); entity.IDFORNECEDOR = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFORNECEDOR")); entity.IDCENTROCUSTO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDCENTROCUSTO")); entity.DATAEMISSAO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATAEMISSAO")); entity.DATAVECTO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATAVECTO")); entity.DATAPAGTO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATAPAGTO")); entity.IDTIPODUPLICATA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDTIPODUPLICATA")); entity.VALORDUPLICATA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORDUPLICATA")); entity.VALORDESCONTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORDESCONTO")); entity.VALORMULTA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORMULTA")); entity.VALORPAGO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORPAGO")); entity.VALORJUROS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORJUROS")); entity.VALORDEVEDOR = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORDEVEDOR")); entity.NOTAFISCAL = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOTAFISCAL")); entity.NCHEQUE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NCHEQUE")); entity.IDLOCALCOBRANCA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDLOCALCOBRANCA")); entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO")); entity.IDSTATUS = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDSTATUS")); entity.DIASATRASO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("DIASATRASO")); entity.DATAATJUROS = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATAATJUROS")); return(entity); }
private static LIS_PRODUTOSPEDIDOMTQOSEntity FillEntityObject(ref FbDataReader DataReader) { LIS_PRODUTOSPEDIDOMTQOSEntity entity = new LIS_PRODUTOSPEDIDOMTQOSEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDPRODUTOSPEDIDOMTQOS = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPRODUTOSPEDIDOMTQOS")); entity.IDORDEMSERVICO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDORDEMSERVICO")); entity.IDPRODUTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPRODUTO")); entity.QUANTIDADE = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("QUANTIDADE")); entity.ALTURA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALTURA")); entity.LARGURA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("LARGURA")); entity.MT2 = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("MT2")); entity.VALORMETRO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORMETRO")); entity.VALORUNITARIO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORUNITARIO")); entity.VALORTOTAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORTOTAL")); entity.COMISSAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("COMISSAO")); entity.NOMEPRODUTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEPRODUTO")); entity.FLAGBAIXAESTMT = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGBAIXAESTMT")); entity.FLAGORCAMENTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGORCAMENTO")); entity.DATAEMISSAO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATAEMISSAO")); entity.PORCPERDAMT = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCPERDAMT")); entity.TOTALPERDAMT = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALPERDAMT")); entity.IDFUNCIONARIO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDFUNCIONARIO")); entity.NOMEFUNCIONARIO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEFUNCIONARIO")); return(entity); }
private static CUPOM_PRODUTOEntity FillEntityObject(ref FbDataReader DataReader) { CUPOM_PRODUTOEntity entity = new CUPOM_PRODUTOEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.CODIGO_EMPRESA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("CODIGO_EMPRESA")); entity.CODIGO_CUPOM = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("CODIGO_CUPOM")); entity.CUPOM_ITEM = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("CUPOM_ITEM")); entity.CODIGO_PRODUTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("CODIGO_PRODUTO")); entity.REFERENCIA_PRODUTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("REFERENCIA_PRODUTO")); entity.NOME_PRODUTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOME_PRODUTO")); entity.QTDADE_PRODUTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("QTDADE_PRODUTO")); entity.VALOR_UNITARIO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALOR_UNITARIO")); entity.VALOR_TOTAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALOR_TOTAL")); entity.UNIDADE_PRODUTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("UNIDADE_PRODUTO")); entity.CSTICMS_PRODUTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CSTICMS_PRODUTO")); entity.ALIQUOTAICMS_PRODUTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALIQUOTAICMS_PRODUTO")); entity.CFOP_PRODUTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CFOP_PRODUTO")); entity.BASEICMS_PRODUTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("BASEICMS_PRODUTO")); entity.VALORICMS_PRODUTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORICMS_PRODUTO")); entity.ALIQUOTASUBST_PRODUTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALIQUOTASUBST_PRODUTO")); entity.VALORSUBST_PRODUTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORSUBST_PRODUTO")); entity.BASESUBST_PRODUTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("BASESUBST_PRODUTO")); entity.ALIQUOTARED_PRODUTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALIQUOTARED_PRODUTO")); return(entity); }
private static FESTASEntity FillEntityObject(ref FbDataReader DataReader) { FESTASEntity entity = new FESTASEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDFESTAS = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDFESTAS")); entity.NOME = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOME")); entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO")); return(entity); }
private static MOEDAEntity FillEntityObject(ref FbDataReader DataReader) { MOEDAEntity entity = new MOEDAEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDMOEDA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDMOEDA")); entity.NOME = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOME")); entity.DESCRICAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DESCRICAO")); return(entity); }
private static MOVIMENTACAOCONTAEntity FillEntityObject(ref FbDataReader DataReader) { MOVIMENTACAOCONTAEntity entity = new MOVIMENTACAOCONTAEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDMOVICONTA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDMOVICONTA")); entity.NOMEMOVIMENTACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEMOVIMENTACAO")); entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO")); return(entity); }
private static MENSAGEMNFEEntity FillEntityObject(ref FbDataReader DataReader) { MENSAGEMNFEEntity entity = new MENSAGEMNFEEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDMENSAGEMNFE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDMENSAGEMNFE")); entity.MENSAGEM = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("MENSAGEM")); entity.NOME = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOME")); return(entity); }
private static ESTADOEntity FillEntityObject(ref FbDataReader DataReader) { ESTADOEntity entity = new ESTADOEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.UF = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("UF")); entity.DESCRICAO_UF = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DESCRICAO_UF")); entity.CODIGO_UF_IBGE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("CODIGO_UF_IBGE")); return(entity); }
private static BANCOEntity FillEntityObject(ref FbDataReader DataReader) { BANCOEntity entity = new BANCOEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDBANCO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDBANCO")); entity.NOMEBANCO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEBANCO")); entity.NUMEROBANCO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NUMEROBANCO")); return(entity); }
private static FORMULARIOEntity FillEntityObject(ref FbDataReader DataReader) { FORMULARIOEntity entity = new FORMULARIOEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDFORMULARIO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDFORMULARIO")); entity.NOMEFORMULARIO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEFORMULARIO")); entity.NOMETELA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMETELA")); entity.IDGRUPOFORMLARIO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDGRUPOFORMLARIO")); return(entity); }
private static GRUPOAGENDAEntity FillEntityObject(ref FbDataReader DataReader) { GRUPOAGENDAEntity entity = new GRUPOAGENDAEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDGRUPOAGENDA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDGRUPOAGENDA")); entity.NOMEGRUPOAGENDA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEGRUPOAGENDA")); entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO")); return(entity); }
private static STATUSDUPLICATAEntity FillEntityObject(ref FbDataReader DataReader) { STATUSDUPLICATAEntity entity = new STATUSDUPLICATAEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDSTATUSDUPLICATA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDSTATUSDUPLICATA")); entity.NOMESTATUS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMESTATUS")); entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO")); return entity; }
private static PROFISSAORAMOATIVIDADEEntity FillEntityObject(ref FbDataReader DataReader) { PROFISSAORAMOATIVIDADEEntity entity = new PROFISSAORAMOATIVIDADEEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDPROFISSAORAMOATIVIDADE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPROFISSAORAMOATIVIDADE")); entity.NOME = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOME")); entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO")); return(entity); }
private static LIS_SCRIPTVERSAOEntity FillEntityObject(ref FbDataReader DataReader) { LIS_SCRIPTVERSAOEntity entity = new LIS_SCRIPTVERSAOEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDSCRIPT = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDSCRIPT")); entity.IDVERSAO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDVERSAO")); entity.DESCRICAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DESCRICAO")); entity.NUMEROVERSAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NUMEROVERSAO")); return(entity); }
private static CONTRATOEntity FillEntityObject(ref FbDataReader DataReader) { CONTRATOEntity entity = new CONTRATOEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDCONTRATO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCONTRATO")); entity.NOME = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOME")); entity.DESCRICAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DESCRICAO")); entity.FLAGPRINCIPAL = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGPRINCIPAL")); return(entity); }
private static CODMOVESTOQUEEntity FillEntityObject(ref FbDataReader DataReader) { CODMOVESTOQUEEntity entity = new CODMOVESTOQUEEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDCODMOVESTOQUE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCODMOVESTOQUE")); entity.CODIGO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CODIGO")); entity.NOME = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOME")); entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO")); return(entity); }