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.");
}
}
