private static HELPDESKEntity FillEntityObject(ref FbDataReader DataReader)
{
HELPDESKEntity entity = new HELPDESKEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDHELPDESK = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDHELPDESK"));
entity.DATAINCLUSAO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATAINCLUSAO"));
entity.DATASOLUCAO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATASOLUCAO"));
entity.IDTIPOSOLICITANTE = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDTIPOSOLICITANTE"));
entity.IDDEPARTAMENTO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDDEPARTAMENTO"));
entity.IDSTATUS = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDSTATUS"));
entity.IDPRIORIDADE = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDPRIORIDADE"));
entity.IDFUNCIONARIO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFUNCIONARIO"));
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_OCORRENCIATLMKEntity FillEntityObject(ref FbDataReader DataReader)
{
LIS_OCORRENCIATLMKEntity entity = new LIS_OCORRENCIATLMKEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDOCORRENCIATLMK = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDOCORRENCIATLMK"));
entity.IDFUNCIONARIO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDFUNCIONARIO"));
entity.IDSTATUSTLMK = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDSTATUSTLMK"));
entity.DATACONTATO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATACONTATO"));
entity.HORACONTATO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("HORACONTATO"));
entity.DATAPROXCONTATO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATAPROXCONTATO"));
entity.HORAPROXCONTATO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("HORAPROXCONTATO"));
entity.NOMECONTATO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMECONTATO"));
entity.CONVERSA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CONVERSA"));
entity.NOMEFUNCIONARIO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEFUNCIONARIO"));
entity.NOMESTATUSTLMK = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMESTATUSTLMK"));
entity.IDCLIENTE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCLIENTE"));
entity.NOMECLIENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMECLIENTE"));
return(entity);
}
private static LIS_PEDIDOOTICA2Entity FillEntityObject(ref FbDataReader DataReader)
{
LIS_PEDIDOOTICA2Entity entity = new LIS_PEDIDOOTICA2Entity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDFORMAPAGAMENTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDFORMAPAGAMENTO"));
entity.TOTALPEDIDO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALPEDIDO"));
entity.DTEMISSAO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DTEMISSAO"));
entity.NOMEFORMPAGTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEFORMPAGTO"));
return(entity);
}
private static ABERTURACAIXAEntity FillEntityObject(ref FbDataReader DataReader)
{
ABERTURACAIXAEntity entity = new ABERTURACAIXAEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDABERTURACAIXA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDABERTURACAIXA"));
entity.DATA = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATA"));
entity.IDFUNCIONARIO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFUNCIONARIO"));
entity.VALOR = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALOR"));
return(entity);
}
private static FERIADOEntity FillEntityObject(ref FbDataReader DataReader)
{
FERIADOEntity entity = new FERIADOEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDFERIADO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDFERIADO"));
entity.NOME = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOME"));
entity.DATA = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATA"));
entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO"));
return(entity);
}
private static LIS_DUPLICATAPAGAREntity FillEntityObject(ref FbDataReader DataReader)
{
LIS_DUPLICATAPAGAREntity entity = new LIS_DUPLICATAPAGAREntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDDUPLICATAPAGAR = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDDUPLICATAPAGAR"));
entity.NUMERO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NUMERO"));
entity.IDFORNECEDOR = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDFORNECEDOR"));
entity.NOMEFORNECEDOR = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEFORNECEDOR"));
entity.IDCENTROCUSTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCENTROCUSTO"));
entity.CENTROCUSTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CENTROCUSTO"));
entity.NOMECENTROCUSTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMECENTROCUSTO"));
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.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDTIPODUPLICATA"));
entity.NOMETIPODUPLICATA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMETIPODUPLICATA"));
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.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDLOCALCOBRANCA"));
entity.NOMELOCALCOBRANCA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMELOCALCOBRANCA"));
entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO"));
entity.IDSTATUS = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDSTATUS"));
entity.NOMESTATUS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMESTATUS"));
entity.DIASATRASO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("DIASATRASO"));
entity.DATAATJUROS = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATAATJUROS"));
return(entity);
}
private static HISTORPROCESSOEntity FillEntityObject(ref FbDataReader DataReader)
{
HISTORPROCESSOEntity entity = new HISTORPROCESSOEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDHISTORPROCESSO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDHISTORPROCESSO"));
entity.IDPROCESSO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDPROCESSO"));
entity.DATA = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATA"));
entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO"));
entity.IDFUNCIONARIO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFUNCIONARIO"));
return(entity);
}
private static TABELAIBPTEntity FillEntityObject(ref FbDataReader DataReader)
{
TABELAIBPTEntity entity = new TABELAIBPTEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDTABELAIBPT = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDTABELAIBPT"));
entity.IDNCM = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDNCM"));
entity.ALNACIONAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALNACIONAL"));
entity.ALIMPORTACAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALIMPORTACAO"));
entity.ALESTADUAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALESTADUAL"));
entity.ALMUNICIPAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALMUNICIPAL"));
entity.DTINICIO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DTINICIO"));
entity.DTFIM = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DTFIM"));
entity.CHAVE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CHAVE"));
entity.VERSAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("VERSAO"));
entity.FONTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FONTE"));
entity.IDCODUFIBGE = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDCODUFIBGE"));
entity.TIPO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("TIPO"));
entity.EX = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("EX"));
return(entity);
}
private static REMESSABANCOEntity FillEntityObject(ref FbDataReader DataReader)
{
REMESSABANCOEntity entity = new REMESSABANCOEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDREMESSABANCO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDREMESSABANCO"));
entity.DATA = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATA"));
entity.SEGUENCIA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("SEGUENCIA"));
entity.IDBANCO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDBANCO"));
entity.FLAGENVIADO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGENVIADO"));
entity.ARQUIVO = getData.ConvertDBValueToBytes(DataReader, DataReader.GetOrdinal("ARQUIVO"));
return(entity);
}
private static ITEVENDAS_ECFEntity FillEntityObject(ref FbDataReader DataReader)
{
ITEVENDAS_ECFEntity entity = new ITEVENDAS_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.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("OPERADOR"));
entity.ITEM = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("ITEM"));
entity.CODIGO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("CODIGO"));
entity.BARRAS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("BARRAS"));
entity.DESCRICAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DESCRICAO"));
entity.QTD = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("QTD"));
entity.PRECO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PRECO"));
entity.TRIBUTACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("TRIBUTACAO"));
entity.ICMS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ICMS"));
entity.ISS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ISS"));
entity.UND = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("UND"));
entity.GRADE_X = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("GRADE_X"));
entity.GRADE_Y = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("GRADE_Y"));
entity.GRADE_QUA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("GRADE_QUA"));
entity.GRADE_VENDIDA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("GRADE_VENDIDA"));
entity.SERIAL = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("SERIAL"));
entity.DESCONTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("DESCONTO"));
entity.ACRESCIMO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ACRESCIMO"));
entity.TOTAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTAL"));
entity.OUTRAS_DESP_ACRE = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("OUTRAS_DESP_ACRE"));
entity.CANCELADO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("CANCELADO"));
entity.OPERADOR_SUP = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("OPERADOR_SUP"));
entity.LOTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("LOTE"));
entity.TIPO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("TIPO"));
entity.TABELA_PRECO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("TABELA_PRECO"));
entity.PIS_ST = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("PIS_ST"));
entity.PIS_VALOR_BC = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PIS_VALOR_BC"));
entity.PIS_ALIQ = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PIS_ALIQ"));
entity.TOT_PIS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOT_PIS"));
entity.COFINS_ST = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("COFINS_ST"));
entity.COFINS_VALOR_BC = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("COFINS_VALOR_BC"));
entity.COFINS_ALIQ = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("COFINS_ALIQ"));
entity.TOT_COFINS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOT_COFINS"));
entity.CST_ICMS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CST_ICMS"));
entity.PRECO_CUSTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PRECO_CUSTO"));
return(entity);
}
private static LIS_MATERIALEntity FillEntityObject(ref FbDataReader DataReader)
{
LIS_MATERIALEntity entity = new LIS_MATERIALEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDMATERIAL = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDMATERIAL"));
entity.NOMEMATERIAL = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEMATERIAL"));
entity.CODMATERIALFORNECEDOR = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CODMATERIALFORNECEDOR"));
entity.CODBARRA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CODBARRA"));
entity.LOCALIZACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("LOCALIZACAO"));
entity.DATACADASTRO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATACADASTRO"));
entity.IDUNIDADE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDUNIDADE"));
entity.NOMEUNIDADE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEUNIDADE"));
entity.IDMARCA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDMARCA"));
entity.NOMEMARCA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEMARCA"));
entity.IDMOEDA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDMOEDA"));
entity.VALORCUSTOINICIAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORCUSTOINICIAL"));
entity.FRETEMATERIAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("FRETEMATERIAL"));
entity.ENCARGOSMATERIAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ENCARGOSMATERIAL"));
entity.VALORCUSTOFINAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORCUSTOFINAL"));
entity.MARGEMLUCRO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("MARGEMLUCRO"));
entity.VALORVENDA1 = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORVENDA1"));
entity.VALORVENDA2 = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORVENDA2"));
entity.VALORVENDA3 = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORVENDA3"));
entity.COMISSAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("COMISSAO"));
entity.IPI = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("IPI"));
entity.ICMS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ICMS"));
entity.QUANTIDADEMINIMA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("QUANTIDADEMINIMA"));
entity.ESTOQUEATUAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ESTOQUEATUAL"));
entity.IDGRUPOCATEGORIA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDGRUPOCATEGORIA"));
entity.NOMEGRUPOCATEGORIA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEGRUPOCATEGORIA"));
entity.IDSTATUS = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDSTATUS"));
entity.NOMESTATUS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMESTATUS"));
entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO"));
entity.PORCFRETE = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCFRETE"));
entity.PORCENCARGOS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCENCARGOS"));
entity.PORCMARGEMLUCRO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCMARGEMLUCRO"));
entity.PORCVENDA2 = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCVENDA2"));
entity.PORCVENDA3 = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCVENDA3"));
entity.PESO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PESO"));
entity.CODCLASSFISCAL = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CODCLASSFISCAL"));
entity.CODSITTRIBU = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CODSITTRIBU"));
entity.NOMECIENTIFICO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMECIENTIFICO"));
return(entity);
}
private static PRODUTOS2NFEEntity FillEntityObject(ref FbDataReader DataReader)
{
PRODUTOS2NFEEntity entity = new PRODUTOS2NFEEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDPRODUTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPRODUTO"));
entity.NOMEPRODUTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEPRODUTO"));
entity.CODPRODUTOFORNECEDOR = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CODPRODUTOFORNECEDOR"));
entity.CODBARRA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CODBARRA"));
entity.LOCALIZACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("LOCALIZACAO"));
entity.DATACADASTRO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATACADASTRO"));
entity.IDUNIDADE = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDUNIDADE"));
entity.IDMARCA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDMARCA"));
entity.IDMOEDA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDMOEDA"));
entity.VALORCUSTOINICIAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORCUSTOINICIAL"));
entity.FRETEPRODUTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("FRETEPRODUTO"));
entity.ENCARGOSPRODUTOS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ENCARGOSPRODUTOS"));
entity.VALORCUSTOFINAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORCUSTOFINAL"));
entity.MARGEMLUCRO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("MARGEMLUCRO"));
entity.VALORVENDA1 = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORVENDA1"));
entity.VALORVENDA2 = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORVENDA2"));
entity.VALORVENDA3 = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORVENDA3"));
entity.COMISSAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("COMISSAO"));
entity.IPI = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("IPI"));
entity.ICMS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ICMS"));
entity.QUANTIDADEMINIMA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("QUANTIDADEMINIMA"));
entity.ESTOQUEATUAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ESTOQUEATUAL"));
entity.IDGRUPOCATEGORIA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDGRUPOCATEGORIA"));
entity.IDSTATUS = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDSTATUS"));
entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO"));
entity.PORCFRETE = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCFRETE"));
entity.PORCENCARGOS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCENCARGOS"));
entity.PORCMARGEMLUCRO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCMARGEMLUCRO"));
entity.PORCVENDA2 = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCVENDA2"));
entity.PORCVENDA3 = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCVENDA3"));
entity.PESO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PESO"));
entity.IDCLASSIFICACAO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDCLASSIFICACAO"));
entity.IDCST = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDCST"));
entity.NCMSH = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NCMSH"));
entity.EXTIPI = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("EXTIPI"));
entity.ALIQPIS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALIQPIS"));
entity.ALIQCOFINS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALIQCOFINS"));
entity.CSTPISCONFIS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CSTPISCONFIS"));
return(entity);
}
private static DESTINOEQUIPAMENTOEntity FillEntityObject(ref FbDataReader DataReader)
{
DESTINOEQUIPAMENTOEntity entity = new DESTINOEQUIPAMENTOEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDDESTINOEQUIPAMENTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDDESTINOEQUIPAMENTO"));
entity.IDEQUIPAMENTO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDEQUIPAMENTO"));
entity.DESTINO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DESTINO"));
entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO"));
entity.DATA = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATA"));
entity.HORA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("HORA"));
return(entity);
}
private static AGENDAVENDEDORTLMKEntity FillEntityObject(ref FbDataReader DataReader)
{
AGENDAVENDEDORTLMKEntity entity = new AGENDAVENDEDORTLMKEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDAGENDAVENDEDORTLMK = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDAGENDAVENDEDORTLMK"));
entity.IDSTATUSTLMK = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDSTATUSTLMK"));
entity.IDCLIENTE = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDCLIENTE"));
entity.DATACONTATO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATACONTATO"));
entity.HORA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("HORA"));
entity.IDFUNCIONARIO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFUNCIONARIO"));
entity.IDGRUPOAGENDATLMK = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDGRUPOAGENDATLMK"));
return(entity);
}
private static AVISOAGENDATLMKEntity FillEntityObject(ref FbDataReader DataReader)
{
AVISOAGENDATLMKEntity entity = new AVISOAGENDATLMKEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDAVISOAGENDATLMK = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDAVISOAGENDATLMK"));
entity.IDCLIENTE = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDCLIENTE"));
entity.FLAGVISUALIZADO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGVISUALIZADO"));
entity.DATAPROXCONTATO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATAPROXCONTATO"));
entity.HORAPROXCONTATO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("HORAPROXCONTATO"));
entity.IDFUNCIONARIO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFUNCIONARIO"));
entity.FLAGADICIONADO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGADICIONADO"));
return(entity);
}
private static DATACOMEMORATIVAEntity FillEntityObject(ref FbDataReader DataReader)
{
DATACOMEMORATIVAEntity entity = new DATACOMEMORATIVAEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDDATACOMEMORATIVA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDDATACOMEMORATIVA"));
entity.IDCLIENTE = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDCLIENTE"));
entity.IDPARENTESCO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDPARENTESCO"));
entity.IDOCASIAO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDOCASIAO"));
entity.DATACOM = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATACOM"));
entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO"));
entity.NOMECOMEMORATIVO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMECOMEMORATIVO"));
return entity;
}
private static LIS_PRODUTONFCEEntity FillEntityObject(ref FbDataReader DataReader)
{
LIS_PRODUTONFCEEntity entity = new LIS_PRODUTONFCEEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.PRODUTONFCEID = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("PRODUTONFCEID"));
entity.CUPOMELETRONICOID = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("CUPOMELETRONICOID"));
entity.IDPRODUTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPRODUTO"));
entity.NOMEPRODUTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEPRODUTO"));
entity.CODBARRA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CODBARRA"));
entity.CODPRODUTOFORNECEDOR = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CODPRODUTOFORNECEDOR"));
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.ALICMS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALICMS"));
entity.BASEICMS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("BASEICMS"));
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.IDUNIDADE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDUNIDADE"));
entity.NOMEUNIDADE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEUNIDADE"));
entity.IDCFOP = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCFOP"));
entity.CODCFOP = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CODCFOP"));
entity.DESCCFOP = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DESCCFOP"));
entity.ALIQPIS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALIQPIS"));
entity.VALORPIS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORPIS"));
entity.ALIQCOFINS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALIQCOFINS"));
entity.VALORCOFINS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORCOFINS"));
entity.VLBASEST = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VLBASEST"));
entity.VLICMSST = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VLICMSST"));
entity.VLALIQST = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VLALIQST"));
entity.VLOUTROS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VLOUTROS"));
entity.VLTRIBUTOAPROX = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VLTRIBUTOAPROX"));
entity.DTEMISSAO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DTEMISSAO"));
entity.IDVENDEDOR = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDVENDEDOR"));
entity.IDSTATUSNFCE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDSTATUSNFCE"));
entity.ITEM = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("ITEM"));
entity.IDCST = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCST"));
entity.CODIGO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CODIGO"));
return(entity);
}
private static COTACAOCOMPRAEntity FillEntityObject(ref FbDataReader DataReader)
{
COTACAOCOMPRAEntity entity = new COTACAOCOMPRAEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDCOTACAOCOMPRA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCOTACAOCOMPRA"));
entity.NUMREFERENCIA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NUMREFERENCIA"));
entity.IDFORNECEDOR = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFORNECEDOR"));
entity.DATAEMISSAO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATAEMISSAO"));
entity.FLAGCOTACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGCOTACAO"));
entity.IDSTATUS = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDSTATUS"));
entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO"));
entity.TOTALCOTACAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALCOTACAO"));
return(entity);
}
private static DESTINOCHEQUEEntity FillEntityObject(ref FbDataReader DataReader)
{
DESTINOCHEQUEEntity entity = new DESTINOCHEQUEEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDDESTINOCHEQUE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDDESTINOCHEQUE"));
entity.IDCHEQUE = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDCHEQUE"));
entity.IDCLIENTE = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDCLIENTE"));
entity.IDFORNECEDOR = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFORNECEDOR"));
entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO"));
entity.TIPORECEBIMENTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("TIPORECEBIMENTO"));
entity.NOMEDESTINO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEDESTINO"));
entity.DATA = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATA"));
return(entity);
}
private static MOVCONTACORRENTEEntity FillEntityObject(ref FbDataReader DataReader)
{
MOVCONTACORRENTEEntity entity = new MOVCONTACORRENTEEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDMOVCTCORRENTE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDMOVCTCORRENTE"));
entity.NUMMOVIMENTACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NUMMOVIMENTACAO"));
entity.IDCONTACORRENTE = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDCONTACORRENTE"));
entity.IDMOVIMENTACAO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDMOVIMENTACAO"));
entity.IDTIPOMOVCAIXA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDTIPOMOVCAIXA"));
entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO"));
entity.VALOR = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALOR"));
entity.DATAMOVIMENTACAO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATAMOVIMENTACAO"));
return(entity);
}
private static CAIXAEntity FillEntityObject(ref FbDataReader DataReader)
{
CAIXAEntity entity = new CAIXAEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDCAIXA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCAIXA"));
entity.IDTIPOMOVCAIXA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDTIPOMOVCAIXA"));
entity.NDOCUMENTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NDOCUMENTO"));
entity.IDTIPODUPLICATA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDTIPODUPLICATA"));
entity.IDCENTROCUSTOS = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDCENTROCUSTOS"));
entity.VALOR = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALOR"));
entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO"));
entity.DATAMOV = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATAMOV"));
return(entity);
}
private static LIS_SERVICOPEDOTICAEntity FillEntityObject(ref FbDataReader DataReader)
{
LIS_SERVICOPEDOTICAEntity entity = new LIS_SERVICOPEDOTICAEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDPRODPEDOTICA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPRODPEDOTICA"));
entity.IDPEDIDOOTICA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPEDIDOOTICA"));
entity.IDSERVICO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDSERVICO"));
entity.NOMESERVICO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMESERVICO"));
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.DTEMISSAO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DTEMISSAO"));
entity.IDCLIENTE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCLIENTE"));
return(entity);
}
private static PRODUTOCOTACAOFORNECEDOREntity FillEntityObject(ref FbDataReader DataReader)
{
PRODUTOCOTACAOFORNECEDOREntity entity = new PRODUTOCOTACAOFORNECEDOREntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDPRODUTOCOTACAOFORNECEDOR = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPRODUTOCOTACAOFORNECEDOR"));
entity.IDPRODUTO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDPRODUTO"));
entity.IDFORNECEDOR = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFORNECEDOR"));
entity.TELEFONEFORNECEDOR = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("TELEFONEFORNECEDOR"));
entity.PRAZOENTREGA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("PRAZOENTREGA"));
entity.CONTATOFORNECEDOR = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CONTATOFORNECEDOR"));
entity.VALORCOMPRA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORCOMPRA"));
entity.CONDPAGTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CONDPAGTO"));
entity.DATACOTACAO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATACOTACAO"));
return(entity);
}
private static LIS_COMISSAOTERCEntity FillEntityObject(ref FbDataReader DataReader)
{
LIS_COMISSAOTERCEntity entity = new LIS_COMISSAOTERCEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDCOMISSAOTERC = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCOMISSAOTERC"));
entity.IDPEDIDO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPEDIDO"));
entity.IDFUNCIONARIO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDFUNCIONARIO"));
entity.PORCENTAGEM = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCENTAGEM"));
entity.VALOR = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALOR"));
entity.NOMEFUNC = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEFUNC"));
entity.DTEMISSAO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DTEMISSAO"));
entity.FLAGORCAMENTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGORCAMENTO"));
entity.IDSTATUS = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDSTATUS"));
return(entity);
}
private static LIS_PRODUTOSMANUTEntity FillEntityObject(ref FbDataReader DataReader)
{
LIS_PRODUTOSMANUTEntity entity = new LIS_PRODUTOSMANUTEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDPRODUTOSMANUT = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPRODUTOSMANUT"));
entity.IDMANUTEESQUIPAMENTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDMANUTEESQUIPAMENTO"));
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.COMISSAOPEDIDO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("COMISSAOPEDIDO"));
entity.NOMEPRODUTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEPRODUTO"));
entity.DATAMANUT = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATAMANUT"));
return(entity);
}
private static LIS_PRODUTOSPEDIDOMTQEntity FillEntityObject(ref FbDataReader DataReader)
{
LIS_PRODUTOSPEDIDOMTQEntity entity = new LIS_PRODUTOSPEDIDOMTQEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDPRODUTOSPEDIDOMTQ = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPRODUTOSPEDIDOMTQ"));
entity.IDPEDIDO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPEDIDO"));
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.IDCOR = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCOR"));
entity.NOMECOR = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMECOR"));
entity.FLAGEXIBIR = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGEXIBIR"));
entity.DADOADICIONAIS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DADOADICIONAIS"));
entity.FLAGORCAMENTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGORCAMENTO"));
entity.FLAGBAIXAESTMT = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGBAIXAESTMT"));
entity.DTEMISSAO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DTEMISSAO"));
entity.IDAMBIENTE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDAMBIENTE"));
entity.NOMEAMBIENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEAMBIENTE"));
entity.IDCLIENTE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCLIENTE"));
entity.IDGRUPOCATEGORIA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDGRUPOCATEGORIA"));
entity.IDMARCA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDMARCA"));
entity.NOMECLIENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMECLIENTE"));
entity.IDPRODUTOMASTER = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPRODUTOMASTER"));
entity.NOMEPRODUTOMASTER = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEPRODUTOMASTER"));
entity.FOTO = getData.ConvertDBValueToBytes(DataReader, DataReader.GetOrdinal("FOTO"));
entity.PORCPERDA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCPERDA"));
entity.TOTALPERDA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALPERDA"));
entity.DADOSADICIONAISPRODUTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DADOSADICIONAISPRODUTO"));
entity.IDVENDEDOR = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDVENDEDOR"));
return(entity);
}
private static ESTOQUELOTEEntity FillEntityObject(ref FbDataReader DataReader)
{
ESTOQUELOTEEntity entity = new ESTOQUELOTEEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDESTOQUELOTE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDESTOQUELOTE"));
entity.QUANTIDADE = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("QUANTIDADE"));
entity.IDLOTE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDLOTE"));
entity.IDPRODUTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPRODUTO"));
entity.NUMERODOC = getData.ConvertDBValueToString(DataReader, DataReader.GetOrdinal("NUMERODOC"));
entity.DATA = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATA"));
entity.FLAGTIPO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGTIPO"));
entity.FLAGATIVO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGATIVO"));
entity.FLAGATIVO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGATIVO"));
entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO"));
return(entity);
}
private static LIS_PEDIDOMARCEntity FillEntityObject(ref FbDataReader DataReader)
{
LIS_PEDIDOMARCEntity entity = new LIS_PEDIDOMARCEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDPEDIDOMARC = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPEDIDOMARC"));
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.IDSTATUS = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDSTATUS"));
entity.NOMESTATUS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMESTATUS"));
entity.PRAZOENTREGA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("PRAZOENTREGA"));
entity.IDTRANSPORTES = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDTRANSPORTES"));
entity.NOMETRANSPORTES = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMETRANSPORTES"));
entity.IDVENDEDOR = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDVENDEDOR"));
entity.NOMEVENDEDOR = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEVENDEDOR"));
entity.VALORCOMISSAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORCOMISSAO"));
entity.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.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDFORMAPAGAMENTO"));
entity.NOMEFORMAPAGTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEFORMAPAGTO"));
entity.VALORPAGO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORPAGO"));
entity.VALORDEVEDOR = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORDEVEDOR"));
entity.IDLOCALCOBRANCA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDLOCALCOBRANCA"));
entity.NOMELOCALCOBRANCA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMELOCALCOBRANCA"));
entity.IDCENTROCUSTOS = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCENTROCUSTOS"));
entity.DESCCENTROCUSTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DESCCENTROCUSTO"));
entity.CENTROCUSTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CENTROCUSTO"));
entity.TOTALMATERIAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALMATERIAL"));
entity.FLAGORCAMENTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGORCAMENTO"));
return(entity);
}
private static PLANOCORTEEntity FillEntityObject(ref FbDataReader DataReader)
{
PLANOCORTEEntity entity = new PLANOCORTEEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDPLANOCORTE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPLANOCORTE"));
entity.COMPCHAPA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("COMPCHAPA"));
entity.LARGURACHAPA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("LARGURACHAPA"));
entity.LARGLAMINA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("LARGLAMINA"));
entity.NIVELOTIMIZACAO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("NIVELOTIMIZACAO"));
entity.IDPRODUTO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDPRODUTO"));
entity.DESCRICAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DESCRICAO"));
entity.EXIBIRDADOS = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("EXIBIRDADOS"));
entity.EXIBIRMEDIDAS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("EXIBIRMEDIDAS"));
entity.DATACORTE = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATACORTE"));
entity.TAMZOOM = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("TAMZOOM"));
return(entity);
}
private static LIS_NOTASERVICOEntity FillEntityObject(ref FbDataReader DataReader)
{
LIS_NOTASERVICOEntity entity = new LIS_NOTASERVICOEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDNOTASERVICO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDNOTASERVICO"));
entity.NPS = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("NPS"));
entity.DATAEMISSAO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATAEMISSAO"));
entity.CODNATUREZA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("CODNATUREZA"));
entity.REGIMETRIBUTACAO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("REGIMETRIBUTACAO"));
entity.IDCLIENTE = getData.ConvertDBValueToInt32(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.NOMECLIENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMECLIENTE"));
entity.TOTALSERVICO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALSERVICO"));
entity.IDCENTROCUSTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCENTROCUSTO"));
entity.DESCCENTROCUSTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DESCCENTROCUSTO"));
entity.CENTROCUSTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CENTROCUSTO"));
entity.IDLOCALCOBRANCA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDLOCALCOBRANCA"));
entity.NOMELOCALCOBRANCA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMELOCALCOBRANCA"));
entity.IDFORMAPAGTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDFORMAPAGTO"));
entity.NOMEFORMAPAGTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEFORMAPAGTO"));
return(entity);
}