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
|
[WebMethod]
public FactureTopNet CreationFacture( ref int NUM_FACTURE, ref int NUM_JUR_FACT,ref int SOCIETE, ref int TYPE, ref string LOGIN_CREATION,ref DateTime DATE_CREATION, ref string LOGIN_MODIFICATION,ref DateTime DATE_MODIFICATION,ref Decimal MNT_FACT,ref decimal REMISE, ref decimal NET_PAYE,ref decimal REST_PAYE,ref string OBSERV, ref int ID_CLIENT,ref string REMARQUE,ref string MONTANTTEXT, ref int TIMBRE, ref int AVOIR, ref int NUM_LISTE,ref int ID_REV,ref int NUM_PF, ref int NUM_PP, ref string REFERENCE, ref string CLE, ref int ID_COM,ref decimal MONTANT_COM, ref DateTime DATE_COM,ref int RED_COM, ref int INTER_GROUPE)
{
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection();
conn.ConnectionString = @"Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=topnet;Initial Catalog=TopnetBase;Data Source=SWEET-4B6F892B4\SQLEXPRESS";
conn.Open();
FactureTopNet facture = new FactureTopNet();
int r;
string req = "INSERT INTO facture (NUM_FACTURE, NUM_JUR_FACT, SOCIETE, TYPE, LOGIN_CREATION, DATE_CREATION,LOGIN_MODIFICATION,DATE_MODIFICATION,MNT_FACT, REMISE, NET_PAYE, REST_PAYE, OBSERV, ID_CLIENT, REMARQUE, MONTANTTEXT, TIMBRE, AVOIR,NUM_LISTE,ID_REV,NUM_PF,NUM_PP, REFERENCE, CLE, ID_COM,MONTANT_COM, DATE_COM, RED_COM, INTER_GROUPE)VALUES('" + NUM_FACTURE + "','" + NUM_JUR_FACT + "','" + SOCIETE + "','" + TYPE + "','" + LOGIN_CREATION + "','" +DATE_CREATION + "','" + LOGIN_MODIFICATION + "','" + DATE_MODIFICATION + "','" + MNT_FACT + "','" + REMISE + "','" + NET_PAYE + "','" + REST_PAYE + "','" + OBSERV + "','" + ID_CLIENT + "','" + REMARQUE + "','" + MONTANTTEXT + "','" + TIMBRE + "','" + AVOIR + "','" + NUM_LISTE + "','" + ID_REV + "','" + NUM_PF + "','" + NUM_PP + "','" + REFERENCE + "','" + CLE + "','" + ID_COM + "','" +MONTANT_COM + "','" + DATE_COM + "','" + RED_COM + "','" + INTER_GROUPE + "')";
System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand(req, conn);
r = command.ExecuteNonQuery();
facture.NUM_FACTURE = NUM_FACTURE;
facture.NUM_JUR_FACT = NUM_JUR_FACT;
facture.SOCIETE = SOCIETE;
facture.TYPE = TYPE;
facture.LOGIN_CREATION = LOGIN_CREATION;
facture.DATE_CREATION = DATE_CREATION;
facture.LOGIN_MODIFICATION = LOGIN_MODIFICATION;
facture.DATE_MODIFICATION = DATE_MODIFICATION;
facture.MNT_FACT = MNT_FACT;
facture.REMISE = REMISE;
facture.NET_PAYE = NET_PAYE;
facture.REST_PAYE = REST_PAYE;
facture.OBSERV = OBSERV;
facture.ID_CLIENT = ID_CLIENT;
facture.REMARQUE = REMARQUE;
facture.MONTANTTEXT = MONTANTTEXT;
facture.TIMBRE = TIMBRE;
facture.AVOIR = AVOIR;
facture.NUM_LISTE = NUM_LISTE;
facture.ID_REV = ID_CLIENT;
facture.NUM_PF = NUM_PF;
facture.NUM_PP = NUM_PP;
facture.REFERENCE = REFERENCE;
facture.CLE = CLE;
facture.ID_COM = ID_COM;
facture.MONTANT_COM = MONTANT_COM;
facture.DATE_COM = DATE_COM;
facture.RED_COM = RED_COM;
facture.INTER_GROUPE = INTER_GROUPE;
return facture;
} |
Partager