How to use the PriGrelha from the PRIMAVERA ERP SDK?

The SDK is a library of business standards and controls for the PRIMAVERA environment. It allows partners and external development teams to quickly and easily create add-ons for the ERP.

The purse of this article is to describe how we can use one of these controls - the PriGrelha, as well as its loading and initialization process in a database query context (for example, a current account statement list).

Query to execute:

SELECT		TipoEntidade, Entidade, Modulo, Filial, TipoDoc, Serie, NumDocInt, DataDoc, ValorTotal, ValorPendente
FROM		Pendentes
ORDER BY	TipoEntidade, Entidade, DataDoc

Using the PriGrelha

Step 1 - Initializing the SDK

To use any SDK control, it must first be initialized (see article "How to use the ERP PRIMAVERA SDK controls?."

Step 2 - Initialization with the SDK context

After launching the PriGrelha control in the form, it needs to be initialized with the context of the SDK. This initialization must take place before any operation on the table.

private void frmDemoGrid_Load(object sender, EventArgs e)
{
	// Initialize the SDK context
	PriSDKContext.Initialize(BSO, PSO);

	// Initialize SDK controls
	InitializeSDKControls();

	// Initialize the grid
	InitializeGrid();
}

Step 3 - Format

For the table to display results you need to format the respective columns, indicating which field to display for each one. These columns need to comply with the query that will be executed.

The method used for this formatting is AddColKey from the PriGrelha, and these are the main arguments:

In the general initialization of the PriGrelha you also need to indicate other attributes, such as:

• Groupings
• Context menu
• Title
• Permissions

Groupings

You need to specify if the grid will have groupings and how many are allowed. To do this, you must execute the following command line as many times as the number of groupings you want to allow for the grid (up to a maximum of four):

priGrelha1.AddColAgrupa();

Context menu

By default, the context menu to display will be the standard menu named 'PopupGrelhasStd'. If you want to add new options to the menu, you need to create a specific menu. The instruction to define the context menu is:

priGrelha1.BandaMenuContexto = 'PopupGrelhasStd';

Title

The table must have a title. The instruction to define the title is:

priGrelha1.TituloGrelha = 'Demo Grid 1';

Permissions

There are some properties that indicate what operations are allowed on the table.

Other table properties

Step 4 - Loading the PriGrelha

This article describes the simplest and easiest way to use a PriGrelha in a database query context, through an SQL query executed by DataBind.

As explained above, the fields from the SELECT performed to get records for the table must match the created columns.

The best way to ensure this is by using a method from the table itself to return all fields, following the structure created in the initialization method, which is already correctly formatted to be added to the SELECT.

Example of how to perform the DataBind from a database query:

private void LoadGrid()
{
	StdBELista lista;

	StringBuilder query = new StringBuilder();
	query.AppendLine(string.Format('SELECT {0}', priGrelha1.DaCamposBDSelect()));
	query.AppendLine('FROM Pendentes');
	query.AppendLine(string.Format('WHERE TipoEntidade = '{0}'', tiposEntidade1.TipoEntidade));

	if (!string.IsNullOrWhiteSpace(f41.Text))
	{
		query.AppendLine(string.Format('AND Entidade = '{0}'', f41.Text));
	}

	query.AppendLine('ORDER BY DataDoc');

	lista = new StdBELista();
	lista = PriSDKContext.SdkContext.BSO.Consulta(query.ToString());

	priGrelha1.DataBind(lista);
}

"DataFill" event

If the 'PermiteDataFill' property is enabled, this event will be executed. It allows you to manipulate all the data being loaded into the table, line by line.

private void priGrelha1_DataFill(object Sender, PriGrelha.DataFillEventArgs e)
{
	// Set modulo description
	string modulo = PSO.Utils.FStr(priGrelha1.GetGRID_GetValorCelula(e.Row, colModulo));
	string moduloDesc = modulo;

	switch (modulo)
	{
		case 'V':
			moduloDesc = 'Vendas';
			break;
		case 'C':
			moduloDesc = 'Compras';
			break;
		case 'M':
			moduloDesc = 'C/Corentes';
			break;
		default:
			break;
	}

	priGrelha1.SetGRID_SetValorCelula(e.Row, colModuloDesc, moduloDesc);

	// Set days of delay
	int daysOfDelay = PSO.Utils.FInt(priGrelha1.GetGRID_GetValorCelula(e.Row, colDiasAtraso));
	daysOfDelay = daysOfDelay < 0 ? Math.Abs(daysOfDelay) : 0;
	priGrelha1.SetGRID_SetValorCelula(e.Row, colDiasAtraso, daysOfDelay);
}

Other events

There are other table events. These are the most important ones to consider:

Here you can find a complete example of how to use the PriGrelha in editing mode.