Exemplo n.º 1
0
        protected override void ConfiguraDataSetVisao(System.Data.DataSet _dataSet)
        {
            DataTable table = _dataSet.Tables["DRPATRIMONIO"];

            DRProps.SetInfoColuna(table, "CodFornecedor", ColProps.Visible, false);
            DRProps.SetInfoColuna(table, "CODIGOPRJ", ColProps.Visible, false);
            DRProps.SetInfoColuna(table, "VALORAQUISICAO", ColProps.Format, DRProps.Fomat2Decimal());
            DRProps.SetInfoColuna(table, "VALORTOTAL", ColProps.Format, DRProps.Fomat2Decimal());
            DRProps.SetInfoColuna(table, "DATAAQUISICAO", ColProps.DisplayWidth, 67);
            DRProps.SetInfoColuna(table, "PATRIMONIO", ColProps.DisplayWidth, 383);
            DRProps.SetInfoColuna(table, "CODETAPA", ColProps.DisplayWidth, 76);
            DRProps.SetInfoColuna(table, "ATIVIDADE", ColProps.DisplayWidth, 76);
            DRProps.SetInfoColuna(table, "IDPATRIMONIO", ColProps.DisplayWidth, 66);
        }
Exemplo n.º 2
0
        protected override void ConfiguraDataSetVisao(System.Data.DataSet _dataSet)
        {
            DataTable table = _dataSet.Tables["DRDESPESA"];

            DRProps.SetInfoColuna(table, "CodigoPrj", ColProps.Visible, false);
            DRProps.SetInfoColuna(table, "IdDespesa", ColProps.Caption, "Id.", ColProps.DisplayWidth, 48, ColProps.DisplayIndex, 1);
            DRProps.SetInfoColuna(table, "CODETAPA", ColProps.DisplayWidth, 42, ColProps.DisplayIndex, 2);
            DRProps.SetInfoColuna(table, "CODATIVIDADE", ColProps.DisplayWidth, 56, ColProps.DisplayIndex, 3);
            DRProps.SetInfoColuna(table, "DESCRICAO", ColProps.DisplayWidth, 357, ColProps.DisplayIndex, 4);
            DRProps.SetInfoColuna(table, "Observacao", ColProps.Visible, false);
            DRProps.SetInfoColuna(table, "DataInclusao", ColProps.DisplayWidth, 66, ColProps.DisplayIndex, 5);
            DRProps.SetInfoColuna(table, "DataPag", ColProps.DisplayWidth, 78, ColProps.DisplayIndex, 6);
            DRProps.SetInfoColuna(table, "Valor", ColProps.DisplayIndex, 7, ColProps.Format, DRProps.Fomat2Decimal());
            DRProps.SetInfoColuna(table, "NumeroNota", ColProps.DisplayIndex, 8);
            DRProps.SetInfoColuna(table, "TIPODESPESA", ColProps.Visible, false);

            DRProps.SetInfoColuna(table, "DESCTIPODESPESA", ColProps.Caption, "Tipo Despesa", ColProps.DisplayIndex, 9);
            DRProps.SetInfoColuna(table, "TIPODESPESA", ColProps.Visible, false);
            DRProps.SetInfoColuna(table, "STATUS", ColProps.DisplayWidth, 41, ColProps.DisplayIndex, 10);
            DRProps.SetInfoColuna(table, "CodFornecedor", ColProps.Visible, false);
            DRProps.SetInfoColuna(table, "NOMEFANTASIA", ColProps.Caption, "Fornecedor", ColProps.DisplayIndex, 11);

            DRProps.SetInfoColuna(table, "USUARIOINCLU", ColProps.Visible, false);
            DRProps.SetInfoColuna(table, "USUARIOAPROVACAO", ColProps.Visible, false);
        }
Exemplo n.º 3
0
        protected override void ConfiguraDataSetVisao(System.Data.DataSet _dataSet)
        {
            DRProps.SetInfoColuna(_dataSet.Tables["DRETAPA"], "CODETAPA", ColProps.DisplayWidth, 50);
            DRProps.SetInfoColuna(_dataSet.Tables["DRETAPA"], "DESCRICAO", ColProps.DisplayWidth, 350);

            DRProps.SetInfoColuna(_dataSet.Tables["DRETAPA"], "DATAINI", ColProps.Caption, "Data Ínicio");
            DRProps.SetInfoColuna(_dataSet.Tables["DRETAPA"], "DATATERMINO", ColProps.Caption, "Data Término");
            DRProps.SetInfoColuna(_dataSet.Tables["DRETAPA"], "TOTALMATERIAL", ColProps.Caption, "Material", ColProps.Format, DRProps.Fomat2Decimal());
            DRProps.SetInfoColuna(_dataSet.Tables["DRETAPA"], "TOTALMAOOBRA", ColProps.Caption, "Mão de Obra", ColProps.Format, DRProps.Fomat2Decimal());
            DRProps.SetInfoColuna(_dataSet.Tables["DRETAPA"], "TOTALGERAL", ColProps.Caption, "Valor Total Previsto", ColProps.Format, DRProps.Fomat2Decimal());
            DRProps.SetInfoColuna(_dataSet.Tables["DRETAPA"], "PERCENTUAL", ColProps.Caption, "% Equivalente na Obra", ColProps.Format, DRProps.Fomat2Decimal());
            DRProps.SetInfoColuna(_dataSet.Tables["DRETAPA"], "VALORDESPESA", ColProps.Caption, "Valor Total Despesas", ColProps.Format, DRProps.Fomat2Decimal());
            DRProps.SetInfoColuna(_dataSet.Tables["DRETAPA"], "MostrarGrafico", ColProps.Visible, false);

            base.ConfiguraDataSetVisao(_dataSet);
        }
Exemplo n.º 4
0
 protected override void ConfiguraDataSetVisao(System.Data.DataSet _dataSet)
 {
     DRProps.SetInfoColuna(_dataSet.Tables["DRPAGAMENTOINVESTIDOR"], "CodInvestidor", ColProps.Visible, false);
     DRProps.SetInfoColuna(_dataSet.Tables["DRPAGAMENTOINVESTIDOR"], "CodigoPrj", ColProps.Visible, false);
     DRProps.SetInfoColuna(_dataSet.Tables["DRPAGAMENTOINVESTIDOR"], "Obs", ColProps.Visible, false);
     DRProps.SetInfoColuna(_dataSet.Tables["DRPAGAMENTOINVESTIDOR"], "VALOR", ColProps.Format, DRProps.Fomat2Decimal());
     DRProps.SetInfoColuna(_dataSet.Tables["DRPAGAMENTOINVESTIDOR"], "UsuarioAprov", ColProps.Caption, "Usuário Aprovou");
     DRProps.SetInfoColuna(_dataSet.Tables["DRPAGAMENTOINVESTIDOR"], "DataAprovacao", ColProps.Caption, "Data Aprovação");
 }
Exemplo n.º 5
0
        protected override void ConfiguraDataSetVisao(System.Data.DataSet _dataSet)
        {
            DataTable table = _dataSet.Tables["DRRENDIMENTO"];

            DRProps.SetInfoColuna(table, "CODIGOPRJ", ColProps.Visible, false);
            DRProps.SetInfoColuna(table, "IDRENDIMENTO", ColProps.DisplayIndex, 1);
            DRProps.SetInfoColuna(table, "MES", ColProps.DisplayIndex, 2);
            DRProps.SetInfoColuna(table, "DATAAPURACAO", ColProps.DisplayIndex, 3);
            DRProps.SetInfoColuna(table, "VALORRENDIMENTO", ColProps.DisplayIndex, 4, ColProps.Format, DRProps.Fomat2Decimal());
        }
Exemplo n.º 6
0
        protected override void ConfiguraDataSetVisao(System.Data.DataSet _dataSet)
        {
            //if (ParamServer.VisualizacaoTotalizadoresAtivado)
            //{
            //    if (_dataSet.Tables["DRATIVIDADE"].Columns["VALORDESPESA"]!= null)
            //        _dataSet.Tables["DRATIVIDADE"].Columns["VALORDESPESA"].Caption = "Valor Total Despesas";

            //    base.ConfiguraDataSetVisao(_dataSet);
            //}

            DataTable table = _dataSet.Tables["DRATIVIDADE"];

            DRProps.SetInfoColuna(table, "CODATIVIDADE", ColProps.DisplayWidth, 70, ColProps.DisplayIndex, 1);
            DRProps.SetInfoColuna(table, "DESCRICAO", ColProps.DisplayWidth, 350, ColProps.DisplayIndex, 2);
            DRProps.SetInfoColuna(table, "DataIni", ColProps.DisplayWidth, 66, ColProps.DisplayIndex, 3);
            DRProps.SetInfoColuna(table, "DataTermino", ColProps.Caption, "Data Término", ColProps.DisplayWidth, 66, ColProps.DisplayIndex, 4);
            DRProps.SetInfoColuna(table, "Unidade", ColProps.Caption, "Un", ColProps.DisplayWidth, 26, ColProps.DisplayIndex, 5);
            DRProps.SetInfoColuna(table, "Qtd", ColProps.Caption, "Quant.", ColProps.DisplayWidth, 66, ColProps.DisplayIndex, 6);
            DRProps.SetInfoColuna(table, "PrecoUnitarioMaoObra", ColProps.DisplayIndex, 7, ColProps.Format, DRProps.Fomat2Decimal());
            DRProps.SetInfoColuna(table, "PrecoUnitarioMaterial", ColProps.DisplayIndex, 8, ColProps.Format, DRProps.Fomat2Decimal());
            DRProps.SetInfoColuna(table, "Total", ColProps.DisplayIndex, 9, ColProps.Format, DRProps.Fomat2Decimal());
            DRProps.SetInfoColuna(table, "TotalGeral", ColProps.Visible, true, ColProps.DisplayIndex, 10, ColProps.Format, DRProps.Fomat2Decimal());
            if (ParamServer.VisualizacaoTotalizadoresAtivado)
            {
                DRProps.SetInfoColuna(table, "VALORDESPESA", ColProps.Caption, "Valor Total Despesas", ColProps.DisplayIndex, 11);
            }
            DRProps.SetInfoColuna(table, "PercentualCompletude", ColProps.Caption, "% Completude", ColProps.DisplayWidth, 66, ColProps.DisplayIndex, 12);
            DRProps.SetInfoColuna(table, "Status", ColProps.DisplayWidth, 49, ColProps.DisplayIndex, 13);

            base.ConfiguraDataSetVisao(_dataSet);
        }
Exemplo n.º 7
0
        protected override void ConfiguraDataSetVisao(System.Data.DataSet _dataSet)
        {
            DRProps.SetInfoColuna(_dataSet.Tables["DROBRAINVESTIDOR"], "CodInvestidor", ColProps.Visible, false);
            DRProps.SetInfoColuna(_dataSet.Tables["DROBRAINVESTIDOR"], "Apartamento", ColProps.DisplayWidth, 150);
            DRProps.SetInfoColuna(_dataSet.Tables["DROBRAINVESTIDOR"], "CodigoPrj", ColProps.DisplayWidth, 45);
            DRProps.SetInfoColuna(_dataSet.Tables["DROBRAINVESTIDOR"], "ValorPrevistoInvesti", ColProps.Format, DRProps.Fomat2Decimal());
            DRProps.SetInfoColuna(_dataSet.Tables["DROBRAINVESTIDOR"], "IDCOTA", ColProps.Visible, false);
            DRProps.SetInfoColuna(_dataSet.Tables["DROBRAINVESTIDOR"], "COTA", ColProps.Caption, "Cota");

            DRProps.SetInfoColuna(_dataSet.Tables["DRInvestidores"], "CodInvestidor", ColProps.DisplayWidth, 62);
            DRProps.SetInfoColuna(_dataSet.Tables["DRInvestidores"], "Nome", ColProps.DisplayWidth, 346);
            DRProps.SetInfoColuna(_dataSet.Tables["DRInvestidores"], "CPF", ColProps.Visible, false, ColProps.DisplayWidth, 79);
            DRProps.SetInfoColuna(_dataSet.Tables["DRInvestidores"], "RG", ColProps.Visible, false, ColProps.DisplayWidth, 89);
            DRProps.SetInfoColuna(_dataSet.Tables["DRInvestidores"], "Cep", ColProps.Visible, false, ColProps.DisplayWidth, 75);
            DRProps.SetInfoColuna(_dataSet.Tables["DRInvestidores"], "Endereco", ColProps.Visible, false, ColProps.DisplayWidth, 201);
            DRProps.SetInfoColuna(_dataSet.Tables["DRInvestidores"], "Numero", ColProps.Visible, false, ColProps.DisplayWidth, 46);
            DRProps.SetInfoColuna(_dataSet.Tables["DRInvestidores"], "Estado", ColProps.Visible, false, ColProps.DisplayWidth, 53);
            DRProps.SetInfoColuna(_dataSet.Tables["DRInvestidores"], "Telefone", ColProps.Visible, false, ColProps.DisplayWidth, 72);
            DRProps.SetInfoColuna(_dataSet.Tables["DRInvestidores"], "Celular", ColProps.Visible, false, ColProps.DisplayWidth, 72);
            DRProps.SetInfoColuna(_dataSet.Tables["DRInvestidores"], "Fax", ColProps.Visible, false, ColProps.DisplayWidth, 72);
            DRProps.SetInfoColuna(_dataSet.Tables["DRInvestidores"], "DataNascimento", ColProps.Visible, false, ColProps.DisplayWidth, 68);

            DRProps.SetInfoColuna(_dataSet.Tables["DRInvestidores"], "Obs", ColProps.Visible, false);
            DRProps.SetInfoColuna(_dataSet.Tables["DRInvestidores"], "Complemento", ColProps.Visible, false);
            DRProps.SetInfoColuna(_dataSet.Tables["DRInvestidores"], "Bairro", ColProps.Visible, false);
            DRProps.SetInfoColuna(_dataSet.Tables["DRInvestidores"], "Cidade", ColProps.Visible, false);
            DRProps.SetInfoColuna(_dataSet.Tables["DRInvestidores"], "Email", ColProps.Visible, false);

            DRProps.SetInfoColuna(_dataSet.Tables["DRInvestidores"], "VLRPREVISTO", ColProps.Caption, "Investimento Previsto", ColProps.Format, DRProps.Fomat2Decimal());
            DRProps.SetInfoColuna(_dataSet.Tables["DRInvestidores"], "TOTALPAGO", ColProps.Caption, "Total Pago", ColProps.Format, DRProps.Fomat2Decimal());
            DRProps.SetInfoColuna(_dataSet.Tables["DRInvestidores"], "APTO", ColProps.Caption, "Apartamento");
            DRProps.SetInfoColuna(_dataSet.Tables["DRInvestidores"], "PercentAdquirido", ColProps.Caption, "%");
            DRProps.SetInfoColuna(_dataSet.Tables["DRInvestidores"], "Fracao", ColProps.Caption, "Fração do Lote");
        }