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