private static CSTEntity FillEntityObject(ref FbDataReader DataReader)
{
CSTEntity entity = new CSTEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDCST = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCST"));
entity.IDORIGEM = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDORIGEM"));
entity.CODIGO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CODIGO"));
entity.DESCRICAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DESCRICAO"));
entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO"));
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 LIS_CAIXA2Entity FillEntityObject(ref FbDataReader DataReader)
{
LIS_CAIXA2Entity entity = new LIS_CAIXA2Entity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDCAIXA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCAIXA"));
entity.IDTIPOMOVCAIXA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDTIPOMOVCAIXA"));
entity.NDOCUMENTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NDOCUMENTO"));
entity.IDTIPODUPLICATA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDTIPODUPLICATA"));
entity.IDCENTROCUSTOS = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCENTROCUSTOS"));
entity.VALOR = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALOR"));
entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO"));
entity.NOMEMOVCAIXA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEMOVCAIXA"));
entity.NOMETIPODUPLICATA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMETIPODUPLICATA"));
entity.CENTROCUSTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CENTROCUSTO"));
entity.DESCENTROCUSTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DESCENTROCUSTO"));
entity.DATAMOV = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATAMOV"));
entity.VALORCREDITO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORCREDITO"));
entity.VALORDEBITO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORDEBITO"));
return(entity);
}
private static RELATORIOPERSONALIZADOEntity FillEntityObject(ref FbDataReader DataReader)
{
RELATORIOPERSONALIZADOEntity entity = new RELATORIOPERSONALIZADOEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDRELATORIOPERSONALIZADO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDRELATORIOPERSONALIZADO"));
entity.NOMERELATORIO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMERELATORIO"));
entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO"));
entity.ORIENTACAO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("ORIENTACAO"));
entity.IDTELA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDTELA"));
return(entity);
}
private static CFOPEntity FillEntityObject(ref FbDataReader DataReader)
{
CFOPEntity entity = new CFOPEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDCFOP = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCFOP"));
entity.CODCFOP = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CODCFOP"));
entity.DESCRICAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DESCRICAO"));
entity.FLAGBAIXAESTOQUE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGBAIXAESTOQUE"));
entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO"));
return(entity);
}
private static CLASSFISCALEntity FillEntityObject(ref FbDataReader DataReader)
{
CLASSFISCALEntity entity = new CLASSFISCALEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDCLASSFISCAL = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCLASSFISCAL"));
entity.CODIGO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CODIGO"));
entity.ALIQICMS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALIQICMS"));
entity.BASEREDUZIDA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("BASEREDUZIDA"));
entity.IDMENSAGEMNFE = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDMENSAGEMNFE"));
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 ITENSFORMAPAGTOEntity FillEntityObject(ref FbDataReader DataReader)
{
ITENSFORMAPAGTOEntity entity = new ITENSFORMAPAGTOEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDITENSFORMAPAGTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDITENSFORMAPAGTO"));
entity.IDFORMAPAGAMENTO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFORMAPAGAMENTO"));
entity.DIAS = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("DIAS"));
entity.PORCPAGTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCPAGTO"));
entity.PORCJUROS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCJUROS"));
return(entity);
}
private static CLIENTEFASTEntity FillEntityObject(ref FbDataReader DataReader)
{
CLIENTEFASTEntity entity = new CLIENTEFASTEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.CODIGO_CLIENTE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("CODIGO_CLIENTE"));
entity.NOME_CLIENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOME_CLIENTE"));
entity.FANTASIA_CLIENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FANTASIA_CLIENTE"));
entity.CPF_CLIENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CPF_CLIENTE"));
entity.DOC_CLIENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DOC_CLIENTE"));
entity.ENDERECO_CLIENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("ENDERECO_CLIENTE"));
entity.NUMEROEND_CLIENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NUMEROEND_CLIENTE"));
entity.COMPLEMENTOEND_CLIENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("COMPLEMENTOEND_CLIENTE"));
entity.BAIRRO_CLIENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("BAIRRO_CLIENTE"));
entity.CEP_CLIENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CEP_CLIENTE"));
entity.EMAIL_CLIENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("EMAIL_CLIENTE"));
entity.TELEFONE1_CLIENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("TELEFONE1_CLIENTE"));
entity.TELEFONE2_CLIENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("TELEFONE2_CLIENTE"));
entity.CELULAR_CLIENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CELULAR_CLIENTE"));
entity.COD_CIDADE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("COD_CIDADE"));
return(entity);
}
private static NCMEntity FillEntityObject(ref FbDataReader DataReader)
{
NCMEntity entity = new NCMEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDNCM = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDNCM"));
entity.CODNCM = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CODNCM"));
entity.ALNACIONAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALNACIONAL"));
entity.ALIMPORTACAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALIMPORTACAO"));
entity.DESCRICAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DESCRICAO"));
return(entity);
}
private static LIS_PRODUTOPEDMARC2Entity FillEntityObject(ref FbDataReader DataReader)
{
LIS_PRODUTOPEDMARC2Entity entity = new LIS_PRODUTOPEDMARC2Entity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDPRODUTOPEDMARC2 = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPRODUTOPEDMARC2"));
entity.PEDIDOMARC = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("PEDIDOMARC"));
entity.QUANT = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("QUANT"));
entity.ALTURA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALTURA"));
entity.LARGURA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("LARGURA"));
entity.COMPRIMENTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("COMPRIMENTO"));
entity.TOTALMT3 = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALMT3"));
entity.VLUNITARIO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VLUNITARIO"));
entity.VLTOTAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VLTOTAL"));
entity.DADOSADICIONAIS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DADOSADICIONAIS"));
entity.IDPRODUTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPRODUTO"));
entity.NOMEPRODUTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEPRODUTO"));
entity.FLAGORCAMENTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGORCAMENTO"));
entity.DTEMISSAO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DTEMISSAO"));
return(entity);
}
private static COMISSAOTERCEntity FillEntityObject(ref FbDataReader DataReader)
{
COMISSAOTERCEntity entity = new COMISSAOTERCEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDCOMISSAOTERC = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCOMISSAOTERC"));
entity.IDPEDIDO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDPEDIDO"));
entity.IDFUNCIONARIO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFUNCIONARIO"));
entity.PORCENTAGEM = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCENTAGEM"));
entity.VALOR = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALOR"));
return(entity);
}
private static LIS_PEDIDO2Entity FillEntityObject(ref FbDataReader DataReader)
{
LIS_PEDIDO2Entity entity = new LIS_PEDIDO2Entity();
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"));
entity.VALORPAGO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORPAGO"));
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 CONTROLEACESSOEntity FillEntityObject(ref FbDataReader DataReader)
{
CONTROLEACESSOEntity entity = new CONTROLEACESSOEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDCONTROLEACESSO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCONTROLEACESSO"));
entity.FLAGALTERA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGALTERA"));
entity.FLAGAPAGA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGAPAGA"));
entity.FLAGACESSA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGACESSA"));
entity.IDNIVEL = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDNIVEL"));
entity.IDFORMULARIO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFORMULARIO"));
return(entity);
}
private static CAMPOIMPTABULADOREntity FillEntityObject(ref FbDataReader DataReader)
{
CAMPOIMPTABULADOREntity entity = new CAMPOIMPTABULADOREntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDCAMPOIMPTAB = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCAMPOIMPTAB"));
entity.NOMEBANCODADOS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEBANCODADOS"));
entity.NOMECAMPOS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMECAMPOS"));
entity.IDTELA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDTELA"));
entity.TAMANHO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("TAMANHO"));
entity.TIPO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("TIPO"));
return(entity);
}
private static PRODUTOSFESTASEntity FillEntityObject(ref FbDataReader DataReader)
{
PRODUTOSFESTASEntity entity = new PRODUTOSFESTASEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDPRODFESTA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPRODFESTA"));
entity.IDITENSFESTAS = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDITENSFESTAS"));
entity.IDPRODUTO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDPRODUTO"));
entity.VALOR = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALOR"));
entity.QUANTIDADE = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("QUANTIDADE"));
entity.VALORTOTAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORTOTAL"));
return(entity);
}
private static FOTOPRODUTOEntity FillEntityObject(ref FbDataReader DataReader)
{
FOTOPRODUTOEntity entity = new FOTOPRODUTOEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDFOTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDFOTO"));
entity.NOME = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOME"));
entity.TIPO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("TIPO"));
entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO"));
entity.IDPRODUTO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDPRODUTO"));
entity.FOTO = getData.ConvertDBValueToBytes(DataReader, DataReader.GetOrdinal("FOTO"));
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 SERVICOPEDIDOFESTAEntity FillEntityObject(ref FbDataReader DataReader)
{
SERVICOPEDIDOFESTAEntity entity = new SERVICOPEDIDOFESTAEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDSERVICOPEDIDOFESTA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDSERVICOPEDIDOFESTA"));
entity.IDPEDIDOFESTA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDPEDIDOFESTA"));
entity.IDSERVICO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDSERVICO"));
entity.QUANTIDADE = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("QUANTIDADE"));
entity.VALORUNITARIO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORUNITARIO"));
entity.VALORTOTAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORTOTAL"));
return(entity);
}
private static JUROSDUPLICATASEntity FillEntityObject(ref FbDataReader DataReader)
{
JUROSDUPLICATASEntity entity = new JUROSDUPLICATASEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDJUROSDUPLICATA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDJUROSDUPLICATA"));
entity.MULTAATRASO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("MULTAATRASO"));
entity.JUROSDIA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("JUROSDIA"));
entity.TAXA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TAXA"));
entity.OUTRAS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("OUTRAS"));
entity.FLAGCALCULAR = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGCALCULAR"));
return(entity);
}
private static CAMPOSRELATORIOPERSONALIZADOEntity FillEntityObject(ref FbDataReader DataReader)
{
CAMPOSRELATORIOPERSONALIZADOEntity entity = new CAMPOSRELATORIOPERSONALIZADOEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDCAMPOSRELATPERSONAZ = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCAMPOSRELATPERSONAZ"));
entity.IDCAMPO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDCAMPO"));
entity.TAMANHO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("TAMANHO"));
entity.ORDEM = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("ORDEM"));
entity.SOMATORIO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("SOMATORIO"));
entity.IDRELATORIOPERSONALIZADO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDRELATORIOPERSONALIZADO"));
return(entity);
}
private static PRODCONSIGNACAOEntity FillEntityObject(ref FbDataReader DataReader)
{
PRODCONSIGNACAOEntity entity = new PRODCONSIGNACAOEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDPRODCONSIGNACAO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPRODCONSIGNACAO"));
entity.IDCONSIGNACAO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDCONSIGNACAO"));
entity.IDPRODUTO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDPRODUTO"));
entity.QUANTIDADE = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("QUANTIDADE"));
entity.VALORUNITARIO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORUNITARIO"));
entity.VALORTOTAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORTOTAL"));
return(entity);
}
private static LIS_PEDIDOEntity FillEntityObject(ref FbDataReader DataReader)
{
LIS_PEDIDOEntity entity = new LIS_PEDIDOEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDPEDIDO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPEDIDO"));
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.FLAGPRODIMPRESSAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGPRODIMPRESSAO"));
entity.PRODUTOFINAL = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("PRODUTOFINAL"));
entity.FLAGORCAMENTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGORCAMENTO"));
entity.NREFERENCIA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NREFERENCIA"));
entity.DATAENTREGA = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATAENTREGA"));
return(entity);
}
private static SERVICOEntity FillEntityObject(ref FbDataReader DataReader)
{
SERVICOEntity entity = new SERVICOEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDSERVICO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDSERVICO"));
entity.NOME = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOME"));
entity.VALOR = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALOR"));
entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO"));
entity.ALIQISSQN = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALIQISSQN"));
entity.CODIGOSERVICO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("CODIGOSERVICO"));
entity.SITUATRIBUTARIA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("SITUATRIBUTARIA"));
return(entity);
}
private static USUARIOEntity FillEntityObject(ref FbDataReader DataReader)
{
USUARIOEntity entity = new USUARIOEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDUSUARIO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDUSUARIO"));
entity.IDFUNCIONARIO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFUNCIONARIO"));
entity.IDNIVELUSUARIO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDNIVELUSUARIO"));
entity.FLAGATIVO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGATIVO"));
entity.NOMEUSUARIO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEUSUARIO"));
entity.SENHAUSUARIO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("SENHAUSUARIO"));
entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO"));
return(entity);
}
private static PRODUTORESERVAEntity FillEntityObject(ref FbDataReader DataReader)
{
PRODUTORESERVAEntity entity = new PRODUTORESERVAEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDPRODUTORESERVA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPRODUTORESERVA"));
entity.IDRESERVA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDRESERVA"));
entity.QUANT = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("QUANT"));
entity.VLUNITARIO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VLUNITARIO"));
entity.VLTOTAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VLTOTAL"));
entity.IDPRODUTO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDPRODUTO"));
entity.FLAGNOVARESERVA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGNOVARESERVA"));
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 ITPECASFECHOSEntity FillEntityObject(ref FbDataReader DataReader)
{
ITPECASFECHOSEntity entity = new ITPECASFECHOSEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDITPECASFECHOS = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDITPECASFECHOS"));
entity.IDPRODUTO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDPRODUTO"));
entity.QUANTIDADE = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("QUANTIDADE"));
entity.VALORUNITARIO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORUNITARIO"));
entity.VALORTOTAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORTOTAL"));
entity.IDFECHOSERVICO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFECHOSERVICO"));
entity.IDORDEMSERVICO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDORDEMSERVICO"));
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);
}