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);
}