Le paramétrage ci-inclus permet d'ajouter, dans la fiche client, une grille de C.A. mensuels, avec sélection de l'année.
Il faut procéder de la manière suivante :
- Ajouter une grille dans le signalétique des clients
- Y définir la requête fournie (fichier SQL.TXT repris dans le fichier ZIP ci-inclus)
- Compléter le customizer SigCli avec le code ci-dessous
N'oubliez pas de modifier les lignes de code "sigForm.MovableControls[ "B43C3A2A33" ]" pour y indiquer l'ID correspondant à la grille que vous avez ajoutée.
using System;
using System.Collections.Generic;
using System.Text;
using System.Windows.Forms;
using System.Drawing;
using MercatorUi;
using MercatorApi;
using System.Data;
using System.Data.SqlClient;
using System.IO;
namespace SigCli
{
public class Customizer : MercatorUi.ICustomizers.IFormLoadCustomizer, MercatorUi.ICustomizers.IFormClosedCustomizer
{
public void FormLoadCustomize(System.Windows.Forms.Form WindowsForm)
{
MercatorUi.Forms.Sig.SigForm sigForm = (MercatorUi.Forms.Sig.SigForm)WindowsForm;
MercatorUi.Forms.Sig.SigGrids.UserDefined userDefinedGrid = (MercatorUi.Forms.Sig.SigGrids.UserDefined)sigForm.MovableControls[ "B43C3A2A33" ];
userDefinedGrid.BeforeFillWithData += new MercatorUi.Forms.Sig.SigGrids.UserDefined.BeforeFillWithDataEventHandler(userDefinedGrid_BeforeFillWithData);
DevComponents.Editors.IntegerInput integerInput1 = new DevComponents.Editors.IntegerInput();
integerInput1.BackgroundStyle.Class = "DateTimeInputBackground" ;
integerInput1.BackgroundStyle.CornerType = DevComponents.DotNetBar.eCornerType.Square;
integerInput1.Location = new System.Drawing.Point(userDefinedGrid.Location.X + userDefinedGrid.Size.Width + 30, userDefinedGrid.Location.Y); // à calculer par rapport au grid
integerInput1.MaxValue = 2099;
integerInput1.MinValue = 2000;
integerInput1.Increment = 1;
integerInput1.Name = "integerInput1" ;
integerInput1.ShowUpDown = true ;
integerInput1.Size = new System.Drawing.Size(52, 20);
integerInput1.TabIndex = 112;
integerInput1.Value = DateTime .Today.Year;
integerInput1.ValueChanged += new EventHandler (integerInput_ValueChange);
userDefinedGrid.Parent.Controls.Add(integerInput1);
}
public void FormClosedCustomize(System.Windows.Forms.Form WindowsForm)
{
MercatorUi.Forms.Sig.SigForm sigForm = (MercatorUi.Forms.Sig.SigForm)WindowsForm;
MercatorUi.Forms.Sig.SigGrids.UserDefined userDefinedGrid = (MercatorUi.Forms.Sig.SigGrids.UserDefined)sigForm.MovableControls[ "B43C3A2A33" ];
userDefinedGrid.BeforeFillWithData -= new MercatorUi.Forms.Sig.SigGrids.UserDefined.BeforeFillWithDataEventHandler(userDefinedGrid_BeforeFillWithData);
System.Windows.Forms.Control[] controls = sigForm.Controls.Find( "integerInput1" , true );
DevComponents.Editors.IntegerInput integerInput1 = (DevComponents.Editors.IntegerInput)controls[0];
integerInput1.ValueChanged -= new EventHandler (integerInput_ValueChange);
}
private void userDefinedGrid_BeforeFillWithData( object sender, MercatorUi.Forms.Sig.SigGrids.UserDefined.BeforeFillWithDataEventArgs e)
{
MercatorUi.Forms.Sig.SigGrids.UserDefined userDefinedGrid = (MercatorUi.Forms.Sig.SigGrids.UserDefined)sender;
MercatorUi.Forms.Sig.SigForm sigForm = (MercatorUi.Forms.Sig.SigForm)userDefinedGrid.Form;
System.Windows.Forms.Control[] controls = sigForm.Controls.Find( "integerInput1" , true );
DevComponents.Editors.IntegerInput integerInput1 = (DevComponents.Editors.IntegerInput)controls[0];
int valTmp = integerInput1.Value;
e.ListSqlParams.Add( new MercatorSqlParam( "@myParam" , valTmp));
}
private void integerInput_ValueChange( object sender, EventArgs e)
{
DevComponents.Editors.IntegerInput integerInput1 = (DevComponents.Editors.IntegerInput)sender;
MercatorUi.Forms.Sig.SigForm sigForm = (MercatorUi.Forms.Sig.SigForm)integerInput1.Parent.Parent;
MercatorUi.Forms.Sig.SigGrids.UserDefined userDefinedGrid = (MercatorUi.Forms.Sig.SigGrids.UserDefined)sigForm.MovableControls[ "B43C3A2A33" ];
userDefinedGrid.FillWithData();
}
}
}
A télécharger :
0000002516.zip (0 Kb - 04/10/2015)