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);
}
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);
}
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");
}
protected override void ConfiguraDataSetVisao(System.Data.DataSet _dataSet)
{
DataTable table = _dataSet.Tables["DRFORNECEDOR"];
DRProps.SetInfoColuna(table, "CodFornecedor", ColProps.DisplayWidth, 47);
DRProps.SetInfoColuna(table, "NomeFantasia", ColProps.DisplayWidth, 383);
DRProps.SetInfoColuna(table, "Categoria", ColProps.DisplayWidth, 80);
}
protected override void ConfiguraDataSetVisao(System.Data.DataSet _dataSet)
{
DataTable table = _dataSet.Tables["DRPROJETO"];
DRProps.SetInfoColuna(table, "CodigoPrj", ColProps.DisplayWidth, 57);
DRProps.SetInfoColuna(table, "Nome", ColProps.DisplayWidth, 410);
DRProps.SetInfoColuna(table, "DataInicio", ColProps.DisplayWidth, 85);
DRProps.SetInfoColuna(table, "DataFin", ColProps.DisplayWidth, 98);
}
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");
}
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());
}
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);
}
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);
}
protected override void DoRecuperaRegistroDialog(System.Data.DataSet dataSet, object[] pk)
{
string sql = @"SELECT * FROM DRInvestidores (NOLOCK) WHERE CodInvestidor =@1";
DBCon.Fill(dataSet.Tables["DRInvestidores"], sql, pk);
string sql_ = @"SELECT DROBRAINVESTIDOR.*,DRCOTAS.DESCRICAO AS COTA FROM DROBRAINVESTIDOR
LEFT JOIN DRCOTAS ON
DRCOTAS.CODIGOPRJ = DROBRAINVESTIDOR.CODIGOPRJ AND
DRCOTAS.IDCOTA = DROBRAINVESTIDOR.IDCOTA
WHERE CODINVESTIDOR=@1";
DBCon.Fill(dataSet.Tables["DROBRAINVESTIDOR"], sql_, pk);
//somente para update
dataSet.Tables["DROBRAINVESTIDOR"].ExtendedProperties["@SQL"] =
@"SELECT * FROM DROBRAINVESTIDOR WHERE CODINVESTIDOR=@1";
DRProps.SetInfoColuna(dataSet.Tables["DROBRAINVESTIDOR"], "IDCOTA", ColProps.Visible, false);
DRProps.SetInfoColuna(dataSet.Tables["DROBRAINVESTIDOR"], "COTA", ColProps.Caption, "Cota");
}
protected override void ConfiguraDataSetVisao(System.Data.DataSet _dataSet)
{
DataTable table = _dataSet.Tables["DRUsuario"];
DRProps.SetInfoColuna(table, "LOGACODIGOPRJ", ColProps.Visible, false);
}
protected override void ConfiguraDataSetVisao(System.Data.DataSet _dataSet)
{
DataTable table = _dataSet.Tables["DREMPRESA"];
DRProps.SetInfoColuna(table, "NOME", ColProps.DisplayWidth, 395);
}
