Gérer les unités dans les différentes langues

0000003138 - 09/03/2023

Mercator 10.10 ou ultérieur permet la gestion des unités (du menu "Outils > Paramètres > Unités") dans les différentes langues. Pour cela, il suffit d'ajouter les colonnes souhaitées.

alter table UNITES add NOMN char(20) not null default ''
alter table UNITES add NOME char(20) not null default ''
alter table UNITES add NOMD char(20) not null default ''

Ensuite, il est nécessaire d'activer l'ajout automatique des colonnes via "Outils > Paramètres > Customizers de Grilles".

custom_unite

Pour activer cela avec quelques règles de colonnes, il suffit d'exécuter ce script SQL :

declare @custom varchar(max)
set @custom = '{"AutoAddCustomColumns":true,"ColumnRules":[{"Name":"NOM","RuptureCalculation":null,"Alignment":0,"Width":200,"Format":null,"Niveau":null,"Dept":null,"HeaderText":"F","Hidden":false,"ReadOnly":false,"Editor":0,"Rupture":0,"ButtonImageFromResource":null,"ButtonImageFromFile":null,"ButtonText":null,"ButtonSigLink":{"SigIdColumn":null,"SigNameColumn":null}},{"Name":"NOMN","RuptureCalculation":null,"Alignment":0,"Width":200,"Format":null,"Niveau":null,"Dept":null,"HeaderText":"N","Hidden":false,"ReadOnly":false,"Editor":0,"Rupture":0,"ButtonImageFromResource":null,"ButtonImageFromFile":null,"ButtonText":null,"ButtonSigLink":{"SigIdColumn":null,"SigNameColumn":null}},{"Name":"NOME","RuptureCalculation":null,"Alignment":0,"Width":200,"Format":null,"Niveau":null,"Dept":null,"HeaderText":"E","Hidden":false,"ReadOnly":false,"Editor":0,"Rupture":0,"ButtonImageFromResource":null,"ButtonImageFromFile":null,"ButtonText":null,"ButtonSigLink":{"SigIdColumn":null,"SigNameColumn":null}},{"Name":"NOMD","RuptureCalculation":null,"Alignment":0,"Width":200,"Format":null,"Niveau":null,"Dept":null,"HeaderText":"D","Hidden":false,"ReadOnly":false,"Editor":0,"Rupture":0,"ButtonImageFromResource":null,"ButtonImageFromFile":null,"ButtonText":null,"ButtonSigLink":{"SigIdColumn":null,"SigNameColumn":null}}],"StringUpdater":null,"RowHeight":0}'

if exists(select * from PARAMS_GRIDS_CUSTOM where id='ParamUnitsForm')
    update PARAMS_GRIDS_CUSTOM set custom=@custom where id='ParamUnitsForm'
else
    insert into PARAMS_GRIDS_CUSTOM (id,custom) values ('ParamUnitsForm',@custom)