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
|
var vnumO = 700001;
var vcptT = getValue("NClient");
var vref = getValue("DemandeSuiteA");
var vdateref = getValue("DateDeDemande");
var d = new Date();
var vdelaiExpJ = d.getDay()+"/"+d.getMonth()+"/"+d.getFullYear();
var vnumD = getValue("DemandeN");
var vtitre = "Titre";
var tabB = getValue("DemandeDeBornes");
for( var it = tabB.iterator(); it.hasNext(); )
{
var vcodA = "";
var vRem = "";
var vPUB = "";
var vqte = "";
var lineValue = it.next();
var vcodA = getValue(lineValue,"CodeTarifPmiBornes");
var vrem = getValue(lineValue,"RemiseAccordeeBornes");
var vPUB = getValue(lineValue,"PrixTarifUBornes");
var vqte = getValue(lineValue,"QuantiteBornes");
myQuery1 = "INSERT INTO [Gest_Com].[dbo].[Export_Pmi] ([numOffre],[cptTiers],[ref],";
myQuery2 = "[dateRef],[titre],[codeArticle],[quantitéCdée],[délaiExpJ],[PUBrut],[remise],[numDemande])";
myQuery3 = "VALUES ('"+vnumO+"','"+vcptT+"','"+vref+"','"+vdateref+"','"+vtitre+"','"+vcodA+"',";
myQuery4 = "'"+vqte+"','"+vdelaiExpJ+"','"+vPUB+"','"+vrem+"','"+vnumD+"')";
myQuery = myQuery1+myQuery2+myQuery3+myQuery4;
alert(myQuery);
sqlQuery("Gest_Com",myQuery);
} |
Partager