private void buttonX2_Click(object sender, EventArgs e) { if (cli != null) { if (!modif) { string err = test_sauve(); if (err.Equals("")) { SaveIncrementationNumero(); String dat = datefact.Value.ToString("yyyy-MM-dd"); string sql = "INSERT INTO Facture (NUMF,REF,NREF,VREF,CODEC, NOMC,ADRC,DATEF, CODES,CODEE, THT,RAVANCE,RGARANTIE,NETHT, TVA,TIMBRE,TTC,RS50,RS15,NET,MODEP,type,VGARANTIE,VAVANCE,prorata,Contrat) VALUE (" + "'" + nfact.Text + "'," + "'" + met.CString(tref.Text) + "'," + "'" + met.CString(tnref.Text) + "'," + "'" + met.CString(tvref.Text) + "'," + "'" + Tcodc.Text + "'," + "'" + met.CString(Tnomc.Text) + "'," + "'" + met.CString(Tadrc.Text) + "'," + "'" + dat + "'," + "'" + Program.Societe + "'," + "'" + Program.Exercice + "'," + "'" + Ttht.Text.Replace(Program.sep, string.Empty) + "'," + "'" + Tav.Text.Replace(Program.sep, string.Empty) + "'," + "'" + Tret.Text.Replace(Program.sep, string.Empty) + "'," + "'" + Tnetht.Text.Replace(Program.sep, string.Empty) + "'," + "'" + Ttva.Text.Replace(Program.sep, string.Empty) + "'," + "'" + Ttimbre.Text.Replace(Program.sep, string.Empty) + "'," + "'" + Tttc.Text.Replace(Program.sep, string.Empty) + "'," + "'" + rs50.Text.Replace(Program.sep, string.Empty) + "'," + "'" + rs15.Text.Replace(Program.sep, string.Empty) + "'," + "'" + net.Text.Replace(Program.sep, string.Empty) + "'," + "'" + Modep.SelectedValue + "'," + "'MD'," + "'" + Tpret.Text.Replace(Program.sep, string.Empty) + "'," + "'" + tpav.Text.Replace(Program.sep, string.Empty) + "'," + "'" + tprorata.Text.Replace(Program.sep, string.Empty) + "'," + "" + IDContrat + "" + ")"; met.Execute(sql); //Montage String sqlF = "insert INTO lmontage (NPYLONE,TYPEPYLONE,POIDS,U,PUHT,PTHT,TVA,CODES,CODEE,NUMF,IDLC) values"; Boolean frst = true; foreach (DataGridViewRow dr in mygrid1.Rows) { if (!dr.IsNewRow) { if (!dr.Cells["ID"].Value.Equals(-1)) { if (!frst) { sqlF += ",("; } else { sqlF += "("; } sqlF += "'" + met.CString(dr.Cells["Npylon"].Value) + "'" + ",'" + met.CString(dr.Cells["TypePylone"].Value) + "'" + ",'" + (dr.Cells["VBP"].Value + "").Replace(Program.sep, string.Empty) + "'" + ",'" + met.CString(dr.Cells["U"].Value) + "'" + ",'" + (dr.Cells["PUHTF"].Value + "").Replace(Program.sep, string.Empty) + "'" + ",'" + (dr.Cells["PTHT"].Value + "").Replace(Program.sep, string.Empty) + "'" + ",'" + (dr.Cells["TVAFF"].Value + "").Replace(Program.sep, string.Empty) + "'" + ",'" + Program.Societe + "'" + ",'" + Program.Exercice + "'" + ",'" + nfact.Text + "'" + ",'" + dr.Cells["ID"].Value + "')"; MAJProrat(dr.Cells["ID"].Value + ""); frst = false; } } } if (!frst) { met.Execute(sqlF); } MessageBox.Show("Sauvgard avec sucée."); buttonX2.Visible = false; buttonX3.Visible = true; } else { MessageBox.Show(err); } } } else { MessageBox.Show("Verifier Le Code Client."); } }
private void buttonX2_Click(object sender, EventArgs e) { if (cli != null) { if (!modif) { string err = test_sauve(); if (err.Equals("")) { SaveIncrementationNumero(); String dat = datefact.Value.ToString("yyyy-MM-dd"); string sql = "INSERT INTO Facture (NUMF,REF,NREF,VREF,CODEC, NOMC,ADRC,DATEF, CODES,CODEE, THT,RAVANCE,RGARANTIE,NETHT, TVA,TIMBRE,TTC,RS50,RS15,NET,MODEP,type,VGARANTIE,VAVANCE,prorata) VALUE (" + "'" + met.CString(nfact.Text) + "'," + "'" + met.CString(tref.Text) + "'," + "'" + met.CString(tnref.Text) + "'," + "'" + met.CString(tvref.Text) + "'," + "'" + Tcodc.Text + "'," + "'" + Tnomc.Text + "'," + "'" + met.CString(Tadrc.Text) + "'," + "'" + dat + "'," + "'" + Program.Societe + "'," + "'" + Program.Exercice + "'," + "'" + Ttht.Text.Replace(Program.sep, string.Empty) + "'," + "'" + Tav.Text.Replace(Program.sep, string.Empty) + "'," + "'" + Tret.Text.Replace(Program.sep, string.Empty) + "'," + "'" + Tnetht.Text.Replace(Program.sep, string.Empty) + "'," + "'" + Ttva.Text.Replace(Program.sep, string.Empty) + "'," + "'" + Ttimbre.Text.Replace(Program.sep, string.Empty) + "'," + "'" + Tttc.Text.Replace(Program.sep, string.Empty) + "'," + "'" + rs50.Text.Replace(Program.sep, string.Empty) + "'," + "'" + rs15.Text.Replace(Program.sep, string.Empty) + "'," + "'" + net.Text.Replace(Program.sep, string.Empty) + "'," + "'" + Modep.SelectedValue + "'," + "'T'," + "'" + Tpret.Text.Replace(Program.sep, string.Empty) + "'," + "'" + tpav.Text.Replace(Program.sep, string.Empty) + "'," + "'" + tprorata.Text.Replace(Program.sep, string.Empty) + "'" + ")"; met.Execute(sql); //Montage String sqlF = "insert INTO ltravaux (DESIGNATION,QTE,U,PUHT,PTHT,TVA,CODES,CODEE,NUMF) values"; Boolean frst = true; foreach (DataGridViewRow dr in mygrid1.Rows) { if (!dr.IsNewRow) { if (!frst) { sqlF += ",("; } else { sqlF += "("; } sqlF += "'" + met.CString(dr.Cells["Npylon"].Value) + "'" + ",'" + (dr.Cells["VBP"].Value + "").Replace(Program.sep, string.Empty) + "'" + ",'" + met.CString(dr.Cells["U"].Value) + "'" + ",'" + (dr.Cells["PUHTF"].Value + "").Replace(Program.sep, string.Empty) + "'" + ",'" + (dr.Cells["PTHT"].Value + "").Replace(Program.sep, string.Empty) + "'" + ",'" + (dr.Cells["TVAFF"].Value + "").Replace(Program.sep, string.Empty) + "'" + ",'" + Program.Societe + "'" + ",'" + Program.Exercice + "'" + ",'" + nfact.Text + "')"; frst = false; } } if (!frst) { met.Execute(sqlF); } MessageBox.Show("Sauvgard avec sucée."); buttonX2.Visible = false; buttonX3.Visible = true; } else { MessageBox.Show(err); } } else { string err = test_sauve(); if (err.Equals("")) { String dat = datefact.Value.ToString("yyyy-MM-dd"); string sql = "UPDATE Facture SET REF='" + met.CString(tref.Text) + "',NREF='" + met.CString(tnref.Text) + "',VREF='" + met.CString(tvref.Text) + "',CODEC='" + met.CString(Tcodc.Text) + "', NOMC='" + met.CString(Tnomc.Text) + "',ADRC='" + met.CString(Tadrc.Text) + "',DATEF='" + dat + "', CODES='" + Program.Societe + "', CODEE='" + Program.Exercice + "', THT='" + Ttht.Text.Replace(Program.sep, string.Empty) + "',RAVANCE='" + Tav.Text.Replace(Program.sep, string.Empty) + "',RGARANTIE='" + Tret.Text.Replace(Program.sep, string.Empty) + "',NETHT='" + Tnetht.Text.Replace(Program.sep, string.Empty) + "', TVA='" + Ttva.Text.Replace(Program.sep, string.Empty) + "',TIMBRE='" + Ttimbre.Text.Replace(Program.sep, string.Empty) + "',TTC='" + Tttc.Text.Replace(Program.sep, string.Empty) + "'RS50='" + rs50.Text.Replace(Program.sep, string.Empty) + "'," + "'RS15='" + rs15.Text.Replace(Program.sep, string.Empty) + "'," + "'NET='" + net.Text.Replace(Program.sep, string.Empty) + "'," + "',MODEP='" + Modep.SelectedValue + "',type='T',VGARANTIE='" + Tpret.Text.Replace(Program.sep, string.Empty) + "',VAVANCE='" + tpav.Text.Replace(Program.sep, string.Empty) + "',prorata='" + tprorata.Text.Replace(Program.sep, string.Empty) + "'WHERE codes='" + Program.Societe + "' and numf = '" + NumFact + "'"; met.Execute(sql); //Fondation met.Execute("DELETE FROM ltravaux WHERE codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and numf='" + NumFact + "'"); String sqlF = "INSERT INTO ltravaux (DESIGNATION,QTE,U,PUHT,PTHT,TVA,CODES,CODEE,NUMF) values"; Boolean frst = true; foreach (DataGridViewRow dr in mygrid1.Rows) { if (!dr.IsNewRow) { if (!frst) { sqlF += ",("; } else { sqlF += "("; } sqlF += "'" + met.CString(dr.Cells["Npylon"].Value) + "'" + ",'" + (dr.Cells["VBP"].Value + "").Replace(Program.sep, string.Empty) + "'" + ",'" + met.CString(dr.Cells["U"].Value) + "'" + ",'" + (dr.Cells["PUHTF"].Value + "").Replace(Program.sep, string.Empty) + "'" + ",'" + (dr.Cells["PTHT"].Value + "").Replace(Program.sep, string.Empty) + "'" + ",'" + (dr.Cells["TVAFF"].Value + "").Replace(Program.sep, string.Empty) + "'" + ",'" + Program.Societe + "'" + ",'" + Program.Exercice + "'" + ",'" + nfact.Text + "')"; frst = false; } } if (!frst) { met.Execute(sqlF); } MessageBox.Show("Sauvgard avec sucée."); buttonX2.Visible = false; buttonX3.Visible = true; } else { MessageBox.Show(err); } } } else { MessageBox.Show("Verifier Le Code Client."); } }
private void buttonX2_Click(object sender, EventArgs e) { if (cli != null) { if (!modif) { string err = ""; if (err.Equals("")) { SaveIncrementationNumero(); String dat = datefact.Value.ToString("yyyy-MM-dd"); string sql = "INSERT INTO Facture (NUMF,REF,NREF,VREF,CODEC, NOMC,ADRC,DATEF, CODES,CODEE, THT,RAVANCE,RGARANTIE,NETHT, TVA,TIMBRE,TTC,RS50,RS15,NET,MODEP,type,VGARANTIE,VAVANCE,prorata,Contrat) VALUE (" + "'" + nfact.Text + "'," + "'" + met.CString(tref.Text) + "'," + "'" + met.CString(tnref.Text) + "'," + "'" + met.CString(tvref.Text) + "'," + "'" + Tcodc.Text + "'," + "'" + met.CString(Tnomc.Text) + "'," + "'" + met.CString(Tadrc.Text) + "'," + "'" + dat + "'," + "'" + Program.Societe + "'," + "'" + Program.Exercice + "'," + "'" + Ttht.Text.Replace(Program.sep, string.Empty) + "'," + "'" + Tav.Text.Replace(Program.sep, string.Empty) + "'," + "'" + Tret.Text.Replace(Program.sep, string.Empty) + "'," + "'" + Tnetht.Text.Replace(Program.sep, string.Empty) + "'," + "'" + Ttva.Text.Replace(Program.sep, string.Empty) + "'," + "'" + Ttimbre.Text.Replace(Program.sep, string.Empty) + "'," + "'" + Tttc.Text.Replace(Program.sep, string.Empty) + "'," + "'" + rs50.Text.Replace(Program.sep, string.Empty) + "'," + "'" + rs15.Text.Replace(Program.sep, string.Empty) + "'," + "'" + net.Text.Replace(Program.sep, string.Empty) + "'," + "'" + Modep.SelectedValue + "'," + "'DD'," + "'" + Tpret.Text.Replace(Program.sep, string.Empty) + "'," + "'" + tpav.Text.Replace(Program.sep, string.Empty) + "'," + "'" + tprorata.Text.Replace(Program.sep, string.Empty) + "'," + "" + IDContrat + "" + ")"; met.Execute(sql); //Montage String sqlF = "insert INTO lderoulage (NPYLONE,TYPEPYLONE,QTE,U,PUHT,PTHT,TVA,CODES,CODEE,NUMF,IDLC,IDLC1) values"; Boolean frst = true; int lasord = 0; string lastid = ""; for (int cpt = 0; cpt < mygrid1.Rows.Count - 1; cpt += 2) { DataGridViewRow dr = mygrid1.Rows[cpt]; DataGridViewRow dr1 = mygrid1.Rows[cpt + 1]; if (!dr.IsNewRow) { if (!dr.Cells["ID"].Value.Equals(-1)) { if (!frst) { sqlF += ",("; } else { sqlF += "("; } string xqte = "0", xpu = "0", xptht = "0", xtva = "0", xid1 = "0"; if (cpt != mygrid1.Rows.Count - 2) { xqte = (dr1.Cells["VBP"].Value + "").Replace(Program.sep, string.Empty); xpu = (dr1.Cells["PUHTF"].Value + "").Replace(Program.sep, string.Empty); xptht = (dr1.Cells["PTHT"].Value + "").Replace(Program.sep, string.Empty); xtva = (dr1.Cells["TVAFF"].Value + "").Replace(Program.sep, string.Empty); xid1 = dr1.Cells["ID"].Value + ""; MAJProrat(dr.Cells["ID"].Value + ""); int.TryParse(dr1.Cells["ordre"].Value + "", out lasord); } else { } lastid = dr1.Cells["ID"].Value + ""; sqlF += "'" + met.CString(dr.Cells["Npylon"].Value) + "'" + ",'" + met.CString(dr.Cells["TypePylone"].Value) + "'" + ",'" + xqte + "'" + ",'" + met.CString(dr1.Cells["U"].Value) + "'" + ",'" + xpu + "'" + ",'" + xptht + "'" + ",'" + xtva + "'" + ",'" + Program.Societe + "'" + ",'" + Program.Exercice + "'" + ",'" + nfact.Text + "'" + ",'" + dr.Cells["ID"].Value + "','" + xid1 + "')"; frst = false; } } } lastid = mygrid1.Rows[mygrid1.Rows.Count - 2].Cells["ID"].Value + ""; string sqllastid = "SELECT MAX(ordre) FROM lcontrat WHERE IDCONTRAT = " + IDContrat; DataSet dsid = met.recuperer_table(sqllastid); try { int idtest = 0; int.TryParse(dsid.Tables[0].Rows[0][0] + "", out idtest); if (lasord == idtest) { MAJProrat(lastid + ""); } } catch { } if (!frst) { met.Execute(sqlF); } MessageBox.Show("Sauvgard avec sucée."); buttonX2.Visible = false; buttonX3.Visible = true; } else { MessageBox.Show(err); } } } else { MessageBox.Show("Verifier Le Code Client."); } }