1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53
|
class CodeRequetes
{
#region variables
private string _RequeteNavision; //requete pour l'affichage du tableau
Form1 maForm1 = new Form1();
#endregion
#region Propriétés
public String RequeteNavision
{
get { return _RequeteNavision; }
}
#endregion
/* #region constructeur
public CodeRequetes()
{
maForm1 ;
}
#endregion*/
public string Construction_Requete_Liste()
{
switch (maForm1.DDL_CHOIX.Text)
{
//Requetes Navisions en fonction de la vue demandée
case "VUE_INITIALE":
_RequeteNavision = "SELECT b.Description as Famille, [Item Sub-Family Code 1] as Sfam, No_, a.Description as Libellé, CAST ([Net Weight]*1000 as INT) as [PoidsNet]," +
"SUBSTRING([Expiration Calculation], 1, 2) as DLC, " +
"[Trademark Code] as [Code Marque],[Trademark Type] as [Type Marque]," +
"[Sales Unit of Measure] as Conditionnement, [Production Family Code] as DateMod, [Production Sub-Family Code 1] as FamProd1," +
" [Production Sub-Family Code 2] as FamProd2, [Production Sub-Family Code 3] as FamProd3, [Production Sub-Family Code 4] as FamProd4," +
"CONVERT(char(10),[Last Date Modified],112) as [Modifié le], [Modified by User] as [Modifié par]," +
"[Last Date Modified]" +
" FROM dbo.Gie$Item a, dbo.[Gie$Item Family_Sub-family] b" + // + Filtre +
" WHERE Blocked='0' AND ([Item Type]='VENTE' OR [Item Type]='ECHANT') " +
" AND a.[Item Familly Code] = b.Code";
break;
case "commercial":
break;
case "Logistique":
break;
case "Production":
break;
}
return _RequeteNavision;
}
} |
Partager