private void buttonX4_Click(object sender, EventArgs e) { // Bouton Ok suppression buttonX5.Visible = true; buttonX1.Visible = false; buttonX2.Visible = false; buttonX3.Visible = false; buttonX4.Visible = false; buttonX6.Visible = true; buttonX7.Visible = true; buttonX8.Visible = true; buttonX11.Visible = true; label4.Text = ""; String msg = MessageBox.Show("Ete-vous sur", "Important", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString(); if (msg.Equals("Yes")) { String req = "DELETE FROM utilisateur Where ID = " + ds.Tables[0].Rows[index].ItemArray[0]; if (met.Execute(req)) { MessageBox.Show("Suppression effectuée"); } } util_Load(sender, e); }
private void buttonX2_Click(object sender, EventArgs e) { // Bouton Sauver if (superValidator1.Validate()) { if (!modif) { String req = "INSERT INTO modalite(codes,code,libelle,Observation) Values ('" + Program.Societe + "','" + textBox1.Text + "', '" + textBox2.Text + "','" + textBox3.Text.Replace("'", "\\'") + "')"; if (met.Execute(req)) { MessageBox.Show("Sauvgarde effectué"); } String req1 = "SELECT * FROM modalite where codes='" + Program.Societe + "' Order by code "; ds = met.recuperer_table(req1); afficheb(); affiche(); } else { Boolean test = true; if (!textBox1.Text.Equals(ds.Tables[0].Rows[index].Field <object>("code"))) { String sql = "SELECT code FROM modalite where codes='" + Program.Societe + "'"; DataSet verif = met.recuperer_table(sql); if (verif.Tables[0].Rows.Count != 0) { test = false; } } if (test) { // Mode Modification String req = "Update modalite Set codes='" + Program.Societe + "',code = '" + textBox1.Text + "', libelle = '" + textBox2.Text + "',Obsertvation='" + textBox3.Text.Replace("'", "\\'") + "' Where ID = " + ds.Tables[0].Rows[index].ItemArray[0]; if (met.Execute(req)) { MessageBox.Show("Sauvgarde effectué"); } modif = false; String req1 = "SELECT * FROM modalite where codes='" + Program.Societe + "' Order by code "; ds = met.recuperer_table(req1); afficheb(); affiche(); this.buttonX6.Focus(); } else { MessageBox.Show("Code déja existant"); } } } }
private void buttonX1_Click(object sender, EventArgs e) { if (Program.ISSaDmin) { String req = "Update pnum Set dlivraison = '" + t1.Text + "', livraison = '" + t2.Text + "', dcomande = '" + t3.Text + "', comande = '" + t4.Text + "', ddevis = '" + t5.Text + "', devis = '" + t6.Text + "', dcomandef = '" + t11.Text + "', comandef = '" + t12.Text + "', dregcli = '" + t7.Text + "', regcli = '" + t8.Text + "', dentre = '" + t9.Text + "', entre = '" + t10.Text + "', dregfour = '" + t13.Text + "', regfour = '" + t14.Text + "', dbon = '" + t15.Text + "', bon = '" + t16.Text + "' Where ID = " + ds.Tables[0].Rows[index].ItemArray[0]; if (met.Execute(req)) { MessageBox.Show("Sauvgarde effectué"); } Pnum_Load(sender, e); this.buttonX1.Focus(); } else { MessageBox.Show("Accés Non Autorisé"); } }
private void toolStripButton4_Click(object sender, EventArgs e) { if (superValidator1.Validate()) { // Bouton Sauver toolStrip1.Visible = true; toolStrip2.Visible = false; toolStrip3.Visible = false; textBox1.ReadOnly = true; textBox2.ReadOnly = true; radioButton1.Enabled = false; radioButton2.Enabled = false; button1.Visible = true; button2.Visible = true; button3.Visible = true; button4.Visible = true; if (!modif) { // Mode création //(Access) string S = "#"+dateTimePicker1.Value.Month + "/" + dateTimePicker1.Value.Day + "/" + dateTimePicker1.Value.Year + "#"; //(Mysql) string S = + dateTimePicker1.Value.Month + "-" + dateTimePicker1.Value.Day + "-" + dateTimePicker1.Value.Year; String req = "INSERT INTO tva(libelle, taux, actif) Values ('" + textBox1.Text + "', " + textBox2.Text + ", " + radioButton1.Checked + ")"; if (met.Execute(req)) { MessageBox.Show("Sauvgarde effectué"); } tva_Load(sender, e); } else { // Mode Modification String req = "Update tva Set Libelle = '" + textBox1.Text + "', taux = " + textBox2.Text + ", actif = " + radioButton1.Checked + " Where ID = " + ds.Tables[0].Rows[index].ItemArray[0]; if (met.Execute(req)) { MessageBox.Show("Sauvgarde effectué"); } modif = false; tva_Load(sender, e); } } }
private void buttonX4_Click(object sender, EventArgs e) { // Bouton Ok suppression buttonX5.Visible = true; buttonX1.Visible = false; buttonX2.Visible = false; buttonX3.Visible = false; buttonX4.Visible = false; buttonX6.Visible = true; buttonX7.Visible = true; buttonX8.Visible = true; buttonX11.Visible = true; label12.Text = ""; String msg = MessageBox.Show("Etes-vous sûr de Supprimer ", "Important", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString(); if (msg.Equals("Yes")) { String req = "DELETE FROM Client Where ID = " + ds.Tables[0].Rows[index].ItemArray[0]; if (met.Execute(req)) { MessageBox.Show("Suppression effectuée"); } } string req5 = "SELECT * FROM client WHERE codes='" + Program.Societe + "' AND codee='" + Program.Exercice + "' Order by code"; ds = met.recuperer_table(req5, "client"); if (index > 1) { index--; } else { index = 0; } affiche(); afficheb(); }
private void buttonX9_Click(object sender, EventArgs e) { if (superValidator1.Validate()) { DateTime datej = DateTime.Now; int Xnbj = 0; int.TryParse(nbj.Text, out Xnbj); xdate = datej.AddDays(Xnbj); String req = "Update propos Set imaged = '" + xdate.ToString("yyyy-MM-dd") + "', imagef = '21011966' "; met.Execute(req); MessageBox.Show("Redémarrer l'application SVP !"); Application.Exit(); } }
private void buttonX10_Click_1(object sender, EventArgs e) { if (Program.ISSaDmin) { String msg = MessageBox.Show("Voulez-Vous Créer Exercice ???", "Important", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString(); if (msg.Equals("Yes")) { if (comboBoxEx1.Items.Count != 0) { string sql1 = "Select Codes,codee From exercice Where codes = '" + xcodes + "' and codee = '" + anne.SelectedItem + "' "; DataSet verif = met.recuperer_table(sql1); if (verif.Tables[0].Rows.Count == 0) { String req1 = "INSERT INTO exercice(codes,codee,libelle) Values ('" + xcodes + "','" + anne.SelectedItem + "','" + textBox10.Text + "')"; if (met.Execute(req1)) { progressBarX1.Maximum = 8; progressBarX1.Value = 0; progressBarX1.Visible = true; // Table xxxxx // Table yyyyy MessageBox.Show("Création Exercice Avec Succés"); } String req12 = "SELECT * FROM exercice"; ds1 = met.recuperer_table(req12, "exercice"); String req13 = "SELECT * FROM ste"; ds = met.recuperer_table(req13, "ste"); } else { MessageBox.Show("Exercice déja Existant"); } } } // fin message (yes/no) } else { MessageBox.Show("Accés Non Autorisé"); } }
private void buttonX1_Click(object sender, EventArgs e) { String msg = MessageBox.Show("Ete-vous sur", "Important", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString(); if (msg.Equals("Yes")) { progressBarX1.Maximum = checkedListBox1.CheckedIndices.Count; progressBarX1.Value = 0; progressBarX1.Visible = true; foreach (int i in checkedListBox1.CheckedIndices) { String table = ds.Tables["Nomtable"].Rows[i].Field <string>("nom"); String sql = "Delete From " + table + " where codes='" + Program.Societe + "' AND codee='" + Program.Exercice + "'"; met.Execute(sql); progressBarX1.Value++; } progressBarX1.Visible = false; MessageBox.Show("suppression avec succée"); } }
private void buttonX1_Click(object sender, EventArgs e) { if (Program.ISSaDmin) { String req = "Update pnumste Set dfacture = '" + t1.Text + "', facture = '" + t2.Text + "', codeclient = '" + t5.Text + "' Where ID = " + ds.Tables[0].Rows[index].ItemArray[0]; if (met.Execute(req)) { MessageBox.Show("Sauvgarde effectué"); } pnumste_Load(sender, e); this.buttonX1.Focus(); } else { MessageBox.Show("Accés Non Autorisé"); } }
private void buttonX2_Click(object sender, EventArgs e) { // if (comboBox1.SelectedIndex!=-1 && comboBox1.SelectedIndex!=-1 && t1.Text!="") if (comboBox1.SelectedIndex != -1 && comboBox1.SelectedIndex != -1) { string sqlcli = "select code from client where codes = '" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codef = '" + comboBox1.SelectedValue + "'"; DataSet dscli = met.recuperer_table(sqlcli, "client"); if (dscli != null) { wnbre = dscli.Tables[0].Rows.Count; foreach (DataRow dr in dscli.Tables["client"].Rows) { string xcodec = dr.Field <string>("code"); string sqlart = "select code from article where codes = '" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codef = '" + comboBox2.SelectedValue + "'"; DataSet dsart = met.recuperer_table(sqlart, "article"); if (dsart != null) { foreach (DataRow dr1 in dsart.Tables["article"].Rows) { string xcodea = dr1.Field <string>("code"); //Suppression String req10 = "DELETE FROM tarif where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codec = '" + xcodec + "' and codea = '" + xcodea + "' "; met.Execute(req10); double xqdeb = 0, xqfin = 0, xremm = 0, xremq = 0; foreach (DataGridViewRow dgr in mygrid3.Rows) { if (!dgr.IsNewRow) { try { xqdeb = double.Parse(dgr.Cells["qdeb"].Value + ""); } catch { } try { xqfin = double.Parse(dgr.Cells["qfin"].Value + ""); } catch { } try { xremm = double.Parse(dgr.Cells["remisem"].Value + ""); } catch { } try { xremq = double.Parse(dgr.Cells["remiseq"].Value + ""); } catch { } //Sauvegarde String req = "INSERT INTO tarif(codes,codee,codec,codea,qdeb,qfin,remisem,remiseq,typerem) Values ('" + Program.Societe + "','" + Program.Exercice + "','" + xcodec + "','" + xcodea + "', " + xqdeb + ", " + xqfin + ", " + xremm + ", " + xremq + ", " + true + ")"; met.Execute(req); xqdeb = 0; xqfin = 0; xremm = 0; xremq = 0; } } } } } String req3 = "SELECT codec,codea,qdeb,qfin,remisem,remiseq FROM tarif where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "' order by codec,codea,qdeb "; DataSet ds3 = met.recuperer_table(req3, "tarif"); label2.Text = ds3.Tables[0].Rows.Count.ToString(); if (ds3 != null) { mygrid2.DataSource = ds3.Tables["tarif"].DefaultView; } MessageBox.Show(wnbre + " Clients effectués "); mygrid3.Rows.Clear(); comboBox1.SelectedIndex = -1; comboBox2.SelectedIndex = -1; } } else { MessageBox.Show(" Selectionner Famille Clients,Articles & Saisir Remise "); } }
private void buttonX2_Click(object sender, EventArgs e) { // Bouton Sauver if (superValidator1.Validate()) { string xsld1 = "Null", xsld = "Null"; if (!textBoxX1.Text.Trim().Equals("")) { xsld1 = "'" + textBoxX1.Text + "'"; } if (!textBoxX4.Text.Trim().Equals("")) { xsld = "'" + textBoxX4.Text + "'"; } if (!modif) { String sql = "SELECT code FROM four where codes='" + Program.Societe + "' AND codee='" + Program.Exercice + "' and code ='" + textBox1.Text + "'"; DataSet verif = met.recuperer_table(sql); if (verif.Tables[0].Rows.Count == 0) { // Mode création //(Access) string S = "#"+dateTimePicker1.Value.Month + "/" + dateTimePicker1.Value.Day + "/" + dateTimePicker1.Value.Year + "#"; //(Mysql) string S = + dateTimePicker1.Value.Month + "-" + dateTimePicker1.Value.Day + "-" + dateTimePicker1.Value.Year; String req = "INSERT INTO Four(codes,codee,code,codef,libelle,adrl,adrf,adrm,mf,telfixe,telfixe1,telgsm,telgsm1,fax,fax1,timbre,fodecfact,solde1,solde,obs,image) Values ('" + Program.Societe + "','" + Program.Exercice + "','" + textBox1.Text + "','" + comboBox1.SelectedValue + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox9.Text + "','" + textBox6.Text + "','" + textBox10.Text + "','" + textBox7.Text + "','" + textBox11.Text + "','" + textBox8.Text + "','" + textBox12.Text + "', " + radioButton3.Checked + ", " + radioButton1.Checked + ", " + xsld1.Replace(Program.sep, string.Empty) + ", " + xsld.Replace(Program.sep, string.Empty) + ",'" + textBoxX6.Text + "',@image" + ")"; MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(req, met.mycon); cmd.Parameters.Add("@image", MySql.Data.MySqlClient.MySqlDbType.LongBlob); cmd.Parameters["@image"].Size = Image_stream.Length; if (Image_stream.Length != 0) { cmd.Parameters["@image"].Value = Image_stream; } else { cmd.Parameters["@image"].Value = DBNull.Value; } cmd.ExecuteNonQuery(); // Incrémentation code fournisseur String req2 = "SELECT * FROM pnumste where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "'"; ds = met.recuperer_table(req2, "pnumste"); string s2 = ds.Tables[0].Rows[index].Field <Object>("codefour") + ""; String snum = textBox1.Text; int anum = int.Parse(snum); xnum = int.Parse(s2); xnum++; if (anum >= xnum) { string s = anum.ToString().Trim(); int l1 = s2.Trim().Length; int l2 = s.Length; for (int ii = l2; ii < l1; ii++) { s = "0" + s; } string sqlinc = "UPDATE pnumste SET codefour = '" + s + "' where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "'"; met.Execute(sqlinc); } String req7 = "SELECT * FROM four where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "' Order by code "; ds = met.recuperer_table(req7, "four"); string req8 = "SELECT MAX(ID) from four "; DataSet ds2 = met.recuperer_table(req8, "four"); List <DataColumn> lis = new List <DataColumn>(); lis.Add(ds.Tables["four"].Columns["ID"]); ds.Tables["four"].PrimaryKey = lis.ToArray(); DataRow[] dr1 = ds.Tables["four"].Select("ID = '" + ds2.Tables[0].Rows[0].ItemArray[0] + "'"); if (dr1.Length != 0) { index = ds.Tables[0].Rows.IndexOf(dr1[0]); } MessageBox.Show("Sauvgarde effectué"); string req4 = "SELECT * FROM four where codes='" + Program.Societe + "' AND codee='" + Program.Exercice + "' Order by code"; ds = met.recuperer_table(req4, "four"); affiche(); afficheb(); } else { MessageBox.Show("Code déja existant"); } } else // Modification { // Mode Modification String req = "Update Four Set codes = '" + Program.Societe + "', codee = '" + Program.Exercice + "', code = '" + textBox1.Text + "', libelle = '" + textBox2.Text + "', adrf = '" + textBox3.Text + "', adrl = '" + textBox4.Text + "', adrm='" + textBox5.Text + "', mf='" + textBox9.Text + "',telfixe='" + textBox6.Text + "',telfixe1='" + textBox10.Text + "',telgsm='" + textBox7.Text + "',telgsm1='" + textBox11.Text + "',fax='" + textBox8.Text + "',fax1='" + textBox12.Text + "',codef='" + comboBox1.SelectedValue + "',timbre = " + radioButton3.Checked + ",fodecfact = " + radioButton1.Checked + ",solde1=" + xsld1.Replace(Program.sep, string.Empty) + ",solde=" + xsld.Replace(Program.sep, string.Empty) + ",obs='" + textBoxX6.Text + "',image=@image" + " Where ID = " + ds.Tables[0].Rows[index].ItemArray[0]; MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(req, met.mycon); cmd.Parameters.Add("@image", MySql.Data.MySqlClient.MySqlDbType.LongBlob); cmd.Parameters["@image"].Size = Image_stream.Length; if (Image_stream.Length != 0) { cmd.Parameters["@image"].Value = Image_stream; } else { cmd.Parameters["@image"].Value = DBNull.Value; } cmd.ExecuteNonQuery(); MessageBox.Show("Sauvgarde effectué"); modif = false; string req4 = "SELECT * FROM four where codes='" + Program.Societe + "' AND codee='" + Program.Exercice + "' Order by code"; ds = met.recuperer_table(req4, "four"); affiche(); afficheb(); this.buttonX6.Focus(); } } }
private void buttonItem3_Click(object sender, EventArgs e) { if (mygrid1.SelectedRows != null) { if (mygrid1.SelectedRows.Count != 0) { Boolean test = true; if (table == "familleclient") { String req2 = "SELECT codef FROM client where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codef='" + mytext1.Text + "' "; DataSet ds2 = met.recuperer_table(req2, "client"); if (ds2 != null) { if (ds2.Tables["client"].Rows.Count != 0) { test = false; } } } if (table == "famillefour") { String req2 = "SELECT codef FROM four where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codef='" + mytext1.Text + "' "; DataSet ds2 = met.recuperer_table(req2, "four"); if (ds2 != null) { if (ds2.Tables["four"].Rows.Count != 0) { test = false; } } } if (table == "famillearticle") { String req2 = "SELECT codef FROM article where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codef='" + mytext1.Text + "' "; DataSet ds2 = met.recuperer_table(req2, "article"); if (ds2 != null) { if (ds2.Tables["article"].Rows.Count != 0) { test = false; } } } if (table == "region") { String req2 = "SELECT coder FROM client where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "' and coder='" + mytext1.Text + "' "; DataSet ds2 = met.recuperer_table(req2, "client"); if (ds2 != null) { if (ds2.Tables["client"].Rows.Count != 0) { test = false; } } } if (test) { String msg = MessageBox.Show("Vous êtes Sur de supprimer ", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString(); if (msg.Equals("Yes")) { String sql = "DELETE FROM " + table + " WHERE ID = " + mygrid1.SelectedRows[0].Cells["c1"].Value; met.Execute(sql); int ind = mygrid1.SelectedRows[0].Index; load_data(); if (mygrid1.Rows.Count != 0) { if (ind < mygrid1.Rows.Count) { mygrid1.CurrentCell = mygrid1.Rows[ind].Cells[1]; mygrid1.Rows[ind].Selected = true; } else { ind = mygrid1.Rows.Count - 1; mygrid1.CurrentCell = mygrid1.Rows[ind].Cells[1]; mygrid1.Rows[ind].Selected = true; } } dgv_click(); buttonX1_Click(sender, e); MessageBox.Show("Suppression avec succée"); } } else { MessageBox.Show("Suppression Impossible, " + table + " Utilisée"); } } } }
private void buttonX5_Click(object sender, EventArgs e) { if (Program.ISSaDmin) { string xnfact; progressBarX1.Value = 0; progressBarX1.Visible = true; foreach (DataGridViewRow dgr in mygrid2.Rows) { progressBarX1.Maximum = mygrid2.Rows.Count; if (dgr.Cells["choixp"].Value != null) { if ((Boolean)dgr.Cells["choixp"].Value) { decimal xreg = 0, xttc = 0, xavr = 0, xttc1 = 0, xret = 0, xrem = 0, xsld1 = 0; decimal zmnt = 0, zttc = 0, zavr = 0, zreg = 0, zrem = 0, zret = 0; string xcode = dgr.Cells["codea"].Value + ""; ////// Client string req = "Select ID,code,libelle,solde1 from client where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and code ='" + xcode + "' "; ds = met.recuperer_table(req, "client"); if (ds.Tables[0].Rows.Count != 0) { try { xsld1 = ds.Tables[0].Rows[0].Field <decimal>("solde1"); } catch { } } string req1 = "Select Sum(totalttc) as totalttc,Sum(montret1) as retenue,Sum(montrem) as remise from eentc where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and codem='" + Program.Magasin + "' and codec='" + xcode + "' "; DataSet tmp1 = met.recuperer_table(req1, "eentc"); try { xttc += tmp1.Tables[0].Rows[0].Field <Decimal>("totalttc"); xret += tmp1.Tables[0].Rows[0].Field <Decimal>("retenue"); xrem += tmp1.Tables[0].Rows[0].Field <Decimal>("remise"); } catch { } string req2 = "Select Sum(totalttc) as totalttc from eentl where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and codem='" + Program.Magasin + "' and codec='" + xcode + "' and facture = false "; DataSet tmp2 = met.recuperer_table(req2, "eentl"); try { xttc1 += tmp2.Tables[0].Rows[0].Field <Decimal>("totalttc"); } catch { } string req3 = "Select Sum(totalttc) as totalttc from eentvc where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and codem='" + Program.Magasin + "' and codec='" + xcode + "'"; DataSet tmp3 = met.recuperer_table(req3, "eentvc"); try { xavr += tmp3.Tables[0].Rows[0].Field <Decimal>("totalttc"); } catch { } string req4 = "Select Sum(mont) as mont from eregc where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and codem='" + Program.Magasin + "' and codec='" + xcode + "'"; DataSet tmp4 = met.recuperer_table(req4, "eregc"); try { xreg += tmp4.Tables[0].Rows[0].Field <Decimal>("mont"); } catch { } ////// Sauvergarde Client String req5 = "Update Client Set debit = " + (xttc + xttc1) + ", credit = " + xreg + ", avoir = " + xavr + ", retenue = " + xret + ", rem = " + xrem + ", solde = " + ((xsld1 + xttc + xttc1) - (xavr + xreg + xret + xrem)) + " Where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and code='" + xcode + "'"; met.Execute(req5); // Retour Montant avoir & montant reglement a 0 pour facture client string req10 = "Select montavr,montreg from eentc where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and codem='" + Program.Magasin + "' and codec='" + xcode + "'"; DataSet tmp10 = met.recuperer_table(req10, "eentc"); foreach (DataRow dr3 in tmp10.Tables["eentc"].Rows) { String req6 = "Update eentc Set MONTAVR = " + zmnt + ", montreg = " + zmnt + ", montrem = " + zmnt + ", montret1 = " + zmnt + " Where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and codec='" + xcode + "'"; met.Execute(req6); } // calcul Montant avoir pour facture client string req11 = "Select totalttc,nfact from eentvc where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and codem='" + Program.Magasin + "' and codec='" + xcode + "'"; DataSet tmp11 = met.recuperer_table(req11, "eentvc"); foreach (DataRow dr3 in tmp11.Tables["eentvc"].Rows) { xnfact = dr3.Field <string>("nfact"); try { zmnt = dr3.Field <Decimal>("totalttc"); } catch { } String req7 = "Update eentc Set MONTAVR = " + zmnt + " Where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and codem='" + Program.Magasin + "' and num ='" + xnfact + "'"; met.Execute(req7); } // calcul Montant reglement pour facture client string req17 = "Select num from eentc where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and codem='" + Program.Magasin + "' and codec='" + xcode + "'"; DataSet tmp17 = met.recuperer_table(req17, "eentc"); decimal wzmnt = 0, wrem = 0, wret = 0; foreach (DataRow dr3 in tmp17.Tables["eentc"].Rows) { xnfact = dr3.Field <string>("num"); string req7 = "Select mont,mntrem,mntret,nfact from lregc where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and codem='" + Program.Magasin + "' and nfact ='" + xnfact + "'"; DataSet tmp7 = met.recuperer_table(req7, "lregc"); foreach (DataRow dr2 in tmp7.Tables["lregc"].Rows) { try { wzmnt += dr2.Field <Decimal>("mont"); } catch { } try { wrem += dr2.Field <Decimal>("mntrem"); } catch { } try { wret += dr2.Field <Decimal>("mntret"); } catch { } } String req8 = "Update eentc Set MONTREG = " + wzmnt + ", montrem = " + wrem + ", montret1 = " + wret + " Where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and codem='" + Program.Magasin + "' and num ='" + xnfact + "'"; met.Execute(req8); wzmnt = wrem = wret = 0; } //calcul solde facture client string req12 = "Select num,totalttc,montavr,montreg,montrem,montret1,reste from eentc where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and codem='" + Program.Magasin + "' and codec='" + xcode + "'"; DataSet tmp12 = met.recuperer_table(req12, "eentc"); foreach (DataRow dr3 in tmp12.Tables["eentc"].Rows) { xnfact = dr3.Field <string>("num"); try { zttc = dr3.Field <Decimal>("totalttc"); } catch { } try { zavr = dr3.Field <Decimal>("montavr"); } catch { } try { zreg = dr3.Field <Decimal>("montreg"); } catch { } try { zrem = dr3.Field <Decimal>("montrem"); } catch { } try { zret = dr3.Field <Decimal>("montret1"); } catch { } String req9 = "Update eentc Set reste = " + ((zttc - (zavr + zreg + zrem + zret))) + " Where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and num ='" + xnfact + "'"; met.Execute(req9); } progressBarX1.Value++; } } } progressBarX1.Visible = false; MessageBox.Show("Réorganisation effectuée avec Succés"); } else { MessageBox.Show("Accés Non Autorisé"); } }
private void buttonX3_Click(object sender, EventArgs e) { // Bouton Supprimer Facture if (dataGridViewX1.Rows.Count != 0) { if (dataGridViewX1.SelectedRows[0].Cells["mode"].Value + "" == "D") { string sql = "select * from eentc where codes = '" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codem='" + Program.Magasin + "' and num = '" + dataGridViewX1.SelectedRows[0].Cells["num"].Value + "' and regle = false"; DataSet dss = met.recuperer_table(sql, "eentc"); if (dss.Tables["eentc"].Rows.Count != 0) { String msg = MessageBox.Show("Ete-vous sur", "Important", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString(); if (msg.Equals("Yes")) { string req1 = "Select * from lentc where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and codem='" + Program.Magasin + "' and num = '" + dataGridViewX1.SelectedRows[0].Cells["num"].Value + "' "; DataSet tmp1 = met.recuperer_table(req1, "lentc"); foreach (DataRow dr1 in tmp1.Tables["lentc"].Rows) { double xqte = 0, QTESTK = 0, QTESOR = 0, QTEMAG = 0, QTESORMAG = 0, QTESTE = 0, QTESORSTE = 0; string xcodea = ""; xcodea = dr1.Field <string>("codea" + ""); string xcodeg = dr1.Field <string>("codeg" + ""); string xcoded = dr1.Field <string>("coded" + ""); xqte = dr1.Field <double>("qte"); try { xqte = dr1.Field <double>("qte"); } catch { } #region // Update stock string sql1 = "Select qtestk,qtesor from artdep where codes = '" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codea ='" + xcodea + "' and coded='" + xcoded + "' and codem='" + Program.Magasin + "' and codeg='" + xcodeg + "'"; DataSet ds1 = met.recuperer_table(sql1, "artdep"); if (ds1 != null) { if (ds1.Tables.Count != 0) { if (ds1.Tables["artdep"].Rows.Count != 0) { Double.TryParse(ds1.Tables["artdep"].Rows[0]["qtestk"] + "", out QTESTK); Double.TryParse(ds1.Tables["artdep"].Rows[0]["qtesor"] + "", out QTESOR); } } } string sql2 = "Select qtestk,qtesor from artmag where codes = '" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codea ='" + xcodea + "' and codem='" + Program.Magasin + "'"; DataSet ds2 = met.recuperer_table(sql2, "artmag"); if (ds2 != null) { if (ds2.Tables.Count != 0) { if (ds2.Tables["artmag"].Rows.Count != 0) { Double.TryParse(ds2.Tables["artmag"].Rows[0]["qtestk"] + "", out QTEMAG); Double.TryParse(ds2.Tables["artmag"].Rows[0]["qtesor"] + "", out QTESORMAG); } } } string sql3 = "Select qtestk,qtesor,vstk from article where codes = '" + Program.Societe + "' and codee = '" + Program.Exercice + "' and code ='" + xcodea + "' "; DataSet ds3 = met.recuperer_table(sql3, "article"); if (ds3 != null) { if (ds3.Tables.Count != 0) { if (ds3.Tables["article"].Rows.Count != 0) { xvstk = ds3.Tables["article"].Rows[0].Field <Boolean>("vstk"); Double.TryParse(ds3.Tables["article"].Rows[0]["qtestk"] + "", out QTESTE); Double.TryParse(ds3.Tables["article"].Rows[0]["qtesor"] + "", out QTESORSTE); } } } if (xvstk == true) { string sqlup = "UPDATE artdep set qtestk = '" + (QTESTK + xqte) + "',qtesor='" + (QTESOR - xqte) + "' where codes = '" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codea ='" + xcodea + "' and coded='" + xcoded + "' and codem='" + Program.Magasin + "' and codeg='" + xcodeg + "'"; met.Execute(sqlup); sqlup = "UPDATE artmag set qtestk = '" + (QTEMAG + xqte) + "',qtesor='" + (QTESORMAG - xqte) + "' where codes = '" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codea ='" + xcodea + "' and codem='" + Program.Magasin + "'"; met.Execute(sqlup); sqlup = "UPDATE article set qtestk = '" + (QTESTE + xqte) + "',qtesor='" + (QTESORSTE - xqte) + "' where codes = '" + Program.Societe + "' and codee = '" + Program.Exercice + "' and code ='" + xcodea + "' "; met.Execute(sqlup); } #endregion // Update stock } String req5 = "Select code,debit,solde From client where codes = '" + Program.Societe + "' AND codee ='" + Program.Exercice + "' AND Code = '" + dataGridViewX1.SelectedRows[0].Cells["codec"].Value + "'"; DataSet dsc = met.recuperer_table(req5, "client"); decimal wdeb = 0, wsld = 0; try { wdeb = dsc.Tables["client"].Rows[0].Field <decimal>("debit"); } catch { } try { wsld = dsc.Tables["client"].Rows[0].Field <decimal>("solde"); } catch { } try { decimal.TryParse(dataGridViewX1.SelectedRows[0].Cells["TOTALTTC"].Value + "", out xdeb); } catch { } String upcli = "UPDATE client SET debit = " + (wdeb - xdeb) + ", solde=" + (wsld - xdeb) + " where codes = '" + Program.Societe + "' AND codee ='" + Program.Exercice + "' AND Code = '" + dataGridViewX1.SelectedRows[0].Cells["codec"].Value + "'"; met.Execute(upcli); String req6 = "Select code,vente,taux,com From rep where codes = '" + Program.Societe + "' AND codee ='" + Program.Exercice + "' AND Code = '" + dataGridViewX1.SelectedRows[0].Cells["coder"].Value + "'"; DataSet dsr = met.recuperer_table(req6, "rep"); decimal wven = 0, nven = 0; double wcom = 0, wtaux = 0; try { wven = dsr.Tables["rep"].Rows[0].Field <decimal>("vente"); } catch { } try { wtaux = dsr.Tables["rep"].Rows[0].Field <double>("taux"); } catch { } try { decimal.TryParse(dataGridViewX1.SelectedRows[0].Cells["TOTALHT"].Value + "", out xven); } catch { } nven = wven - xven; wcom = (double)nven * (wtaux / 100); String uprep = "UPDATE rep SET vente = " + nven + ", com=" + wcom + " where codes = '" + Program.Societe + "' AND codee ='" + Program.Exercice + "' AND Code = '" + dataGridViewX1.SelectedRows[0].Cells["coder"].Value + "'"; met.Execute(uprep); String req3 = "DELETE FROM eentc Where codes = '" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codem='" + Program.Magasin + "' and num = '" + dataGridViewX1.SelectedRows[0].Cells["num"].Value + "'"; if (met.Execute(req3)) { String req4 = "DELETE FROM lentc Where codes = '" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codem='" + Program.Magasin + "' and num = '" + dataGridViewX1.SelectedRows[0].Cells["num"].Value + "'"; if (met.Execute(req4)) { MessageBox.Show("Suppression effectuée"); } } buttonX1_Click(sender, e); } } else { MessageBox.Show("Facture Reglée"); } } else if (dataGridViewX1.SelectedRows[0].Cells["mode"].Value + "" == "L") { string sql = "select * from eentc where codes = '" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codem='" + Program.Magasin + "' and num = '" + dataGridViewX1.SelectedRows[0].Cells["num"].Value + "' and regle = false"; DataSet dss = met.recuperer_table(sql, "eentc"); if (dss.Tables["eentc"].Rows.Count != 0) { String msg = MessageBox.Show("Ete-vous sur", "Important", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString(); if (msg.Equals("Yes")) { string sqln = "select * from nblfacture where codes = '" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codem='" + Program.Magasin + "' and numf = '" + dataGridViewX1.SelectedRows[0].Cells["num"].Value + "'"; DataSet dsn = met.recuperer_table(sqln, "nblfacture"); if (dsn != null) { foreach (DataRow dr in dsn.Tables["nblfacture"].Rows) { string xnbl = dr.Field <string>("numl"); String upbl = "UPDATE eentl SET facture = " + false + " where codes = '" + Program.Societe + "' AND codee ='" + Program.Exercice + "' AND codem ='" + Program.Magasin + "' AND num = '" + xnbl + "'"; met.Execute(upbl); } } String req3 = "DELETE FROM eentc Where codes = '" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codem='" + Program.Magasin + "' and num = '" + dataGridViewX1.SelectedRows[0].Cells["num"].Value + "'"; met.Execute(req3); String req4 = "DELETE FROM lentc Where codes = '" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codem='" + Program.Magasin + "' and num = '" + dataGridViewX1.SelectedRows[0].Cells["num"].Value + "'"; met.Execute(req4); String req5 = "DELETE FROM nblfacture Where codes = '" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codem='" + Program.Magasin + "' and numf = '" + dataGridViewX1.SelectedRows[0].Cells["num"].Value + "'"; met.Execute(req5); MessageBox.Show("Suppression effectuée"); buttonX1_Click(sender, e); } } else { MessageBox.Show("Facture Reglée"); } } else if (dataGridViewX1.SelectedRows[0].Cells["mode"].Value + "" == "B") { string sql = "select * from eentc where codes = '" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codem='" + Program.Magasin + "' and num = '" + dataGridViewX1.SelectedRows[0].Cells["num"].Value + "'"; DataSet dss = met.recuperer_table(sql, "eentc"); if (dss.Tables["eentc"].Rows.Count != 0) { String msg = MessageBox.Show("Ete-vous sur", "Important", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString(); if (msg.Equals("Yes")) { string sqln = "select * from nblfacture where codes = '" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codem='" + Program.Magasin + "' and numf = '" + dataGridViewX1.SelectedRows[0].Cells["num"].Value + "'"; DataSet dsn = met.recuperer_table(sqln, "nblfacture"); if (dsn != null) { foreach (DataRow dr in dsn.Tables["nblfacture"].Rows) { string xnbl = dr.Field <string>("numl"); String upbl = "UPDATE eentcb SET facture = " + false + " where codes = '" + Program.Societe + "' AND codee ='" + Program.Exercice + "' AND codem ='" + Program.Magasin + "' AND num = '" + xnbl + "'"; met.Execute(upbl); } } String req3 = "DELETE FROM eentc Where codes = '" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codem='" + Program.Magasin + "' and num = '" + dataGridViewX1.SelectedRows[0].Cells["num"].Value + "'"; met.Execute(req3); String req4 = "DELETE FROM lentc Where codes = '" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codem='" + Program.Magasin + "' and num = '" + dataGridViewX1.SelectedRows[0].Cells["num"].Value + "'"; met.Execute(req4); String req5 = "DELETE FROM nblfacture Where codes = '" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codem='" + Program.Magasin + "' and numf = '" + dataGridViewX1.SelectedRows[0].Cells["num"].Value + "'"; met.Execute(req5); MessageBox.Show("Suppression effectuée"); buttonX1_Click(sender, e); } } } } }
private void buttonX2_Click(object sender, EventArgs e) { if (!Log.Text.Equals("") && !PWD.Text.Equals("") && Soc.SelectedIndex != -1 && Exerc.SelectedIndex != -1) { DataSet ds = met.recuperer_table("Select * From utilisateur Where libelle = '" + Log.Text + "' AND mp = '" + PWD.Text + "'", "utilisateur"); if (ds.Tables["utilisateur"].Rows.Count != 0) { Program.Societe = Soc.SelectedValue.ToString(); Program.Exercice = ((DataRowView)Exerc.SelectedValue).Row.ItemArray[2] + ""; Program.User = ds.Tables["utilisateur"].Rows[0].Field <String>("code"); Program.LibUser = ds.Tables["utilisateur"].Rows[0].Field <String>("libelle"); if (ds.Tables["utilisateur"].Rows[0].Field <String>("type").Equals("S")) { Program.ISSaDmin = true; Program.ISaDmin = true; Program.TypUser = "******"; } if (ds.Tables["utilisateur"].Rows[0].Field <String>("type").Equals("A")) { Program.ISaDmin = true; Program.TypUser = "******"; } if (ds.Tables["utilisateur"].Rows[0].Field <String>("type").Equals("U")) { Program.TypUser = "******"; } /// Controle programme String req = "SELECT * FROM propos"; DataSet ds2 = met.recuperer_table(req, "propos"); if (ds2 != null) { if (ds2.Tables.Count != 0) { if (ds2.Tables[0].Rows.Count != 0) { wdateprog = ds2.Tables[0].Rows[0].Field <DateTime>("imaged"); } } } int wpasse = 850120156; if (wdateprog < wdatejours) { String req1 = "Update propos Set imagef = " + wpasse + " "; met.Execute(req1); } //String reqsp = "select * FROM propos "; //DataSet dsprp = met.recuperer_table(reqsp, "propos"); //if (dsprp != null) //{ // if (dsprp.Tables.Count != 0) // { // wdateprog = dsprp.Tables[0].Rows[0].Field<DateTime>("imaged"); // wpasseprog = dsprp.Tables[0].Rows[0].Field<int>("imagef"); // } //} //if (wdateprog < wdatejours || wpasseprog != 21011966) //{ // Program.ISAret = true; // Program.ISDemo = true; //} /// this.Hide(); Menugen1 mg = new Menugen1(); mg.Show(); } else { MessageBox.Show("Verifier Votre Login et/ou Mot de passe"); } } else { MessageBox.Show("Veillez Remplir Tous les champs"); } }
private void buttonX1_Click(object sender, EventArgs e) { progressBarX1.Value = 0; progressBarX1.Visible = true; string xnfact; decimal zmnt = 0, zttc = 0, zavr = 0, zreg = 0; string req = "Select ID,code,libelle,solde1 from client where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' order by code "; ds = met.recuperer_table(req, "client"); progressBarX1.Maximum = (ds.Tables["client"].Rows.Count) / 3; foreach (DataRow dr in ds.Tables["client"].Rows) { decimal xreg = 0, xttc = 0, xavr = 0, xttc1 = 0, xsld1 = 0; textBoxX1.Text = dr.Field <string>("code"); textBoxX2.Text = dr.Field <string>("libelle"); label1.Text = "Client"; this.Update(); try { xsld1 = dr.Field <Decimal>("solde1"); } catch { } string req1 = "Select Sum(totalttc) as totalttc from eentc where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and codec='" + textBoxX1.Text + "' "; DataSet tmp1 = met.recuperer_table(req1, "eentc"); try { xttc += tmp1.Tables[0].Rows[0].Field <Decimal>("totalttc"); } catch { } string req2 = "Select Sum(totalttc) as totalttc from eentl where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and codec='" + textBoxX1.Text + "' and facture = false "; DataSet tmp2 = met.recuperer_table(req2, "eentl"); try { xttc1 += tmp2.Tables[0].Rows[0].Field <Decimal>("totalttc"); } catch { } string req3 = "Select Sum(totalttc) as totalttc from eentvc where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and codec='" + textBoxX1.Text + "'"; DataSet tmp3 = met.recuperer_table(req3, "eentvc"); try { xavr += tmp3.Tables[0].Rows[0].Field <Decimal>("totalttc"); } catch { } string req4 = "Select Sum(mont) as mont from eregc where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and codec='" + textBoxX1.Text + "'"; DataSet tmp4 = met.recuperer_table(req4, "eregc"); try { xreg += tmp4.Tables[0].Rows[0].Field <Decimal>("mont"); } catch { } String req5 = "Update Client Set debit = " + (xttc + xttc1) + ", credit = " + xreg + ", avoir = " + xavr + ", solde = " + ((xsld1 + xttc + xttc1) - (xavr + xreg)) + " Where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and code='" + textBoxX1.Text + "'"; met.Execute(req5); progressBarX1.Value++; } string reqr = "Select ID,code,libelle,taux from rep where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' order by code "; ds = met.recuperer_table(reqr, "rep"); progressBarX1.Maximum = (ds.Tables["rep"].Rows.Count) / 3; foreach (DataRow dr in ds.Tables["rep"].Rows) { decimal xven = 0, xven1 = 0; double xtaux = 0, xcom = 0; textBoxX1.Text = dr.Field <string>("code"); textBoxX2.Text = dr.Field <string>("libelle"); label1.Text = "Représentant"; this.Update(); try { xtaux = dr.Field <double>("taux"); } catch { } string req1 = "Select Sum(totalht) as totalht from eentc where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and coder='" + textBoxX1.Text + "' "; DataSet tmp1 = met.recuperer_table(req1, "eentc"); try { xven += tmp1.Tables[0].Rows[0].Field <Decimal>("totalht"); } catch { } string req2 = "Select Sum(totalht) as totalht from eentl where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and coder='" + textBoxX1.Text + "' and facture = false "; DataSet tmp2 = met.recuperer_table(req2, "eentl"); try { xven1 += tmp2.Tables[0].Rows[0].Field <Decimal>("totalht"); } catch { } xcom = (double)(xven + xven1) * (xtaux / 100); String req5 = "Update rep Set vente = " + (xven + xven1) + ", com = " + xcom + " Where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and code='" + textBoxX1.Text + "'"; met.Execute(req5); progressBarX1.Value++; } string reqf = "Select ID,code,libelle,solde1 from four where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' order by code "; ds = met.recuperer_table(reqf, "four"); progressBarX1.Maximum += (ds.Tables["four"].Rows.Count) / 3; foreach (DataRow dr in ds.Tables["four"].Rows) { decimal wreg = 0, wttc = 0, wavr = 0, wttc1 = 0, wsld1 = 0; textBoxX1.Text = dr.Field <string>("code"); textBoxX2.Text = dr.Field <string>("libelle"); label1.Text = "Fournisseur"; this.Update(); try { wsld1 = dr.Field <Decimal>("solde1"); } catch { } string req1 = "Select Sum(totalttc) as totalttc from eentf where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and codec='" + textBoxX1.Text + "' "; DataSet tmp1 = met.recuperer_table(req1, "eentf"); try { wttc += tmp1.Tables[0].Rows[0].Field <Decimal>("totalttc"); } catch { } string req2 = "Select Sum(totalttc) as totalttc from eente where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and codec='" + textBoxX1.Text + "' and facture = false "; DataSet tmp2 = met.recuperer_table(req2, "eente"); try { wttc1 += tmp2.Tables[0].Rows[0].Field <Decimal>("totalttc"); } catch { } string req3 = "Select Sum(totalttc) as totalttc from eentvf where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and codec='" + textBoxX1.Text + "'"; DataSet tmp3 = met.recuperer_table(req3, "eentvf"); try { wavr += tmp3.Tables[0].Rows[0].Field <Decimal>("totalttc"); } catch { } string req4 = "Select Sum(mont) as mont from eregf where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and codec='" + textBoxX1.Text + "'"; DataSet tmp4 = met.recuperer_table(req4, "eregf"); try { wreg += tmp4.Tables[0].Rows[0].Field <Decimal>("mont"); } catch { } String req5 = "Update four Set debit = " + (wttc + wttc1) + ", credit = " + wreg + ", avoir = " + wavr + ", solde = " + ((wsld1 + wttc + wttc1) - (wavr + wreg)) + " Where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and code='" + textBoxX1.Text + "'"; met.Execute(req5); progressBarX1.Value++; } // Retour Montant avoir & montant reglement a 0 pour facture client string req10 = "Select montavr,montreg from eentc where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "'"; DataSet tmp10 = met.recuperer_table(req10, "eentc"); foreach (DataRow dr3 in tmp10.Tables["eentc"].Rows) { String req5 = "Update eentc Set MONTAVR = " + zmnt + ", montreg = " + zmnt + " Where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "'"; met.Execute(req5); } // Retour Montant avoir & montant reglement a 0 pour facture fournisseur string req11 = "Select montavr,montreg from eentf where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "'"; DataSet tmp11 = met.recuperer_table(req11, "eentf"); foreach (DataRow dr3 in tmp11.Tables["eentf"].Rows) { String req5 = "Update eentf Set MONTAVR = " + zmnt + ", montreg = " + zmnt + " Where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "'"; met.Execute(req5); } // calcul Montant avoir pour facture client string req6 = "Select totalttc,nfact from eentvc where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "'"; DataSet tmp6 = met.recuperer_table(req6, "eentvc"); foreach (DataRow dr3 in tmp6.Tables["eentvc"].Rows) { xnfact = dr3.Field <string>("nfact"); try { zmnt = dr3.Field <Decimal>("totalttc"); } catch { } String req5 = "Update eentc Set MONTAVR = " + zmnt + " Where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and num ='" + xnfact + "'"; met.Execute(req5); } // calcul Montant reglement pour facture client string req17 = "Select num from eentc where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "'"; DataSet tmp17 = met.recuperer_table(req17, "eentc"); decimal wzmnt = 0; foreach (DataRow dr3 in tmp17.Tables["eentc"].Rows) { xnfact = dr3.Field <string>("num"); string req7 = "Select mont,nfact from lregc where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and nfact ='" + xnfact + "'"; DataSet tmp7 = met.recuperer_table(req7, "lregc"); foreach (DataRow dr2 in tmp7.Tables["lregc"].Rows) { try { wzmnt += dr2.Field <Decimal>("mont"); } catch { } } String req5 = "Update eentc Set MONTREG = " + wzmnt + " Where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and num ='" + xnfact + "'"; met.Execute(req5); wzmnt = 0; } // calcul Montant avoir pour facture fournisseur string req8 = "Select totalttc,nfact from eentvf where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "'"; DataSet tmp8 = met.recuperer_table(req8, "eentvf"); foreach (DataRow dr3 in tmp8.Tables["eentvf"].Rows) { xnfact = dr3.Field <string>("nfact"); try { zmnt = dr3.Field <Decimal>("totalttc"); } catch { } String req5 = "Update eentf Set MONTAVR = " + zmnt + " Where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and num ='" + xnfact + "'"; met.Execute(req5); } // calcul Montant reglement pour facture fournisseur string req19 = "Select num from eentf where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "'"; DataSet tmp19 = met.recuperer_table(req19, "eentf"); decimal zzmnt = 0; foreach (DataRow dr3 in tmp19.Tables["eentf"].Rows) { xnfact = dr3.Field <string>("num"); string req7 = "Select mont,nfact from lregf where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and nfact ='" + xnfact + "'"; DataSet tmp7 = met.recuperer_table(req7, "lregf"); foreach (DataRow dr2 in tmp7.Tables["lregf"].Rows) { try { zzmnt += dr2.Field <Decimal>("mont"); } catch { } } String req5 = "Update eentf Set MONTREG = " + zzmnt + " Where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and num ='" + xnfact + "'"; met.Execute(req5); zzmnt = 0; } //calcul solde facture client string req12 = "Select num,totalttc,montavr,montreg,reste from eentc where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "'"; DataSet tmp12 = met.recuperer_table(req12, "eentc"); foreach (DataRow dr3 in tmp12.Tables["eentc"].Rows) { xnfact = dr3.Field <string>("num"); try { zttc = dr3.Field <Decimal>("totalttc"); } catch { } try { zavr = dr3.Field <Decimal>("montavr"); } catch { } try { zreg = dr3.Field <Decimal>("montreg"); } catch { } String req5 = "Update eentc Set reste = " + ((zttc - (zavr + zreg))) + " Where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and num ='" + xnfact + "'"; met.Execute(req5); } //calcul solde facture fournisseur string req13 = "Select num,totalttc,montavr,montreg,reste from eentf where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "'"; DataSet tmp13 = met.recuperer_table(req13, "eentf"); foreach (DataRow dr3 in tmp13.Tables["eentf"].Rows) { xnfact = dr3.Field <string>("num"); try { zttc = dr3.Field <Decimal>("totalttc"); } catch { } try { zavr = dr3.Field <Decimal>("montavr"); } catch { } try { zreg = dr3.Field <Decimal>("montreg"); } catch { } String req5 = "Update eentf Set reste = " + ((zttc - (zavr + zreg))) + " Where codes='" + Program.Societe + "' and codee='" + Program.Exercice + "' and num ='" + xnfact + "'"; met.Execute(req5); } MessageBox.Show("Organisation effectuée"); progressBarX1.Visible = false; textBoxX1.Text = ""; textBoxX2.Text = ""; label1.Text = ""; }
private void buttonX2_Click(object sender, EventArgs e) { Boolean test = true; // Bouton Sauver if (superValidator1.Validate()) { String sql = "SELECT code FROM " + table + " where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "' and code='" + textBox1.Text + "'"; DataSet verif = met.recuperer_table(sql, table); if (verif.Tables[0].Rows.Count != 0) { test = false; } if (!modif) { if (test) { String req = "INSERT INTO " + table + "(codes,codee,code,libelle) Values ('" + Program.Societe + "','" + Program.Exercice + "','" + textBox1.Text + "', '" + textBox2.Text + "')"; met.Execute(req); // String req2 = "SELECT * FROM pnumste where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "'"; ds = met.recuperer_table(req2, "pnumste"); string s2 = ds.Tables[0].Rows[index].Field <Object>(champs) + ""; String snum = textBox1.Text; int anum = int.Parse(snum); xnum = int.Parse(s2); xnum++; if (anum >= xnum) { string s = anum.ToString().Trim(); int l1 = s2.Trim().Length; int l2 = s.Length; for (int ii = l2; ii < l1; ii++) { s = "0" + s; } string sqlinc = "UPDATE pnumste SET " + champs + " = '" + s + "' where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "'"; met.Execute(sqlinc); } // MessageBox.Show("Sauvegarde éffectué"); String req1 = "SELECT * FROM " + table + " where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "' and type = '" + xtype + "' Order by code "; ds = met.recuperer_table(req1, table); string req5 = "SELECT MAX(ID) from " + table + " "; DataSet ds2 = met.recuperer_table(req5, table); List <DataColumn> lis = new List <DataColumn>(); lis.Add(ds.Tables[table].Columns["ID"]); ds.Tables[table].PrimaryKey = lis.ToArray(); DataRow[] dr = ds.Tables[table].Select("ID = '" + ds2.Tables[0].Rows[0].ItemArray[0] + "'"); if (dr.Length != 0) { index = ds.Tables[0].Rows.IndexOf(dr[0]); } test = true; afficheb(); affiche(); } else { MessageBox.Show("Code déja existant"); test = true; } } else { { // Mode Modification String req = "Update " + table + " Set codes='" + Program.Societe + "',codee='" + Program.Exercice + "',code = '" + textBox1.Text + "', libelle = '" + textBox2.Text + "' Where ID = " + ds.Tables[0].Rows[index].ItemArray[0]; if (met.Execute(req)) { MessageBox.Show("Sauvegarde éffectué"); } modif = false; String req1 = "SELECT * FROM " + table + " where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "' and type = '" + xtype + "' Order by code "; ds = met.recuperer_table(req1, table); test = true; afficheb(); affiche(); this.buttonX6.Focus(); } } } }
private void buttonX1_Click(object sender, EventArgs e) { if (Program.ISSaDmin) { foreach (DataRow dr in ds.Tables["parametre"].Rows) { string xparam = dr.Field <string>("param"); String req = ""; if (xparam.Equals("TauxMajoration")) { req = "Update parametre Set value = '" + t1.Text + "' Where codes='" + Program.Societe + "' and param = '" + xparam + "' "; } else if (xparam.Equals("Timbre")) { req = "Update parametre Set value = '" + t2.Text + "' Where codes='" + Program.Societe + "' and param = '" + xparam + "' "; } else if (xparam.Equals("Cumulqteclient")) { req = "Update parametre Set value = '" + c1.SelectedItem + "' Where codes='" + Program.Societe + "' and param = '" + xparam + "' "; } else if (xparam.Equals("Cumulqtefour")) { req = "Update parametre Set value = '" + c2.SelectedItem + "' Where codes='" + Program.Societe + "' and param = '" + xparam + "' "; } else if (xparam.Equals("CumulRemiseClient")) { req = "Update parametre Set value = '" + c3.SelectedItem + "' Where codes='" + Program.Societe + "' and param = '" + xparam + "' "; } else if (xparam.Equals("BonTicket")) { req = "Update parametre Set value = '" + c4.SelectedItem + "' Where codes='" + Program.Societe + "' and param = '" + xparam + "' "; } else if (xparam.Equals("RCB")) { req = "Update parametre Set value = '" + c5.SelectedItem + "' Where codes='" + Program.Societe + "' and param = '" + xparam + "' "; } else if (xparam.Equals("RCL")) { req = "Update parametre Set value = '" + c6.SelectedItem + "' Where codes='" + Program.Societe + "' and param = '" + xparam + "' "; } else if (xparam.Equals("RCF")) { req = "Update parametre Set value = '" + c7.SelectedItem + "' Where codes='" + Program.Societe + "' and param = '" + xparam + "' "; } else if (xparam.Equals("RCA")) { req = "Update parametre Set value = '" + c8.SelectedItem + "' Where codes='" + Program.Societe + "' and param = '" + xparam + "' "; } else if (xparam.Equals("RCR")) { req = "Update parametre Set value = '" + c9.SelectedItem + "' Where codes='" + Program.Societe + "' and param = '" + xparam + "' "; } else if (xparam.Equals("RFL")) { req = "Update parametre Set value = '" + c10.SelectedItem + "' Where codes='" + Program.Societe + "' and param = '" + xparam + "' "; } else if (xparam.Equals("RFF")) { req = "Update parametre Set value = '" + c11.SelectedItem + "' Where codes='" + Program.Societe + "' and param = '" + xparam + "' "; } else if (xparam.Equals("RFA")) { req = "Update parametre Set value = '" + c12.SelectedItem + "' Where codes='" + Program.Societe + "' and param = '" + xparam + "' "; } else if (xparam.Equals("RFR")) { req = "Update parametre Set value = '" + c13.SelectedItem + "' Where codes='" + Program.Societe + "' and param = '" + xparam + "' "; } met.Execute(req); } MessageBox.Show("Sauvegarde effectué"); param_Load(sender, e); this.buttonX1.Focus(); } else { MessageBox.Show("Accés Non Autorisé"); } }
private void buttonX5_Click(object sender, EventArgs e) { if (Program.ISSaDmin) { progressBarX1.Value = 0; progressBarX1.Visible = true; foreach (DataGridViewRow dgr in mygrid2.Rows) { progressBarX1.Maximum = mygrid2.Rows.Count; if (dgr.Cells["choixp"].Value != null) { if ((Boolean)dgr.Cells["choixp"].Value) { double xqtedep = 0, xstk = 0; Double xtqte = 0, xtqte1 = 0; Double xtqte2 = 0, xtqte3 = 0; Double wtqte = 0, wtqte1 = 0; double wtqte2 = 0, wtqte3 = 0, wstk = 0, wqtedep = 0; string req1 = ""; string xcode = dgr.Cells["codea"].Value + ""; ////// Article Dépot string reqd = ""; reqd = "SELECT code FROM depot where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codem='" + Program.Magasin + "' "; DataSet dsd = met.recuperer_table(reqd, "depot"); foreach (DataRow drp in dsd.Tables["depot"].Rows) { string wcoded = drp.Field <string>("code"); string reqg = ""; reqg = "SELECT codeg,libelle FROM gamme where codea ='" + xcode + "' and codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "' "; DataSet dsg = met.recuperer_table(reqg, "gamme"); foreach (DataRow drg in dsg.Tables["gamme"].Rows) { xtqte = xtqte1 = 0; xtqte2 = xtqte3 = xstk = xqtedep = 0; string wcodeg = drg.Field <string>("codeg"); req1 = "SELECT qtedep FROM artdep WHERE codes='" + Program.Societe + "' AND codee='" + Program.Exercice + "' and codem = '" + Program.Magasin + "' and codea ='" + xcode + "' and coded = '" + wcoded + "' and codeg = '" + wcodeg + "' "; ds = met.recuperer_table(req1, "artdep"); if (ds.Tables[0].Rows.Count != 0) { try { xqtedep = ds.Tables[0].Rows[0].Field <double>("qtedep"); } catch { xqtedep = 0; } try { wqtedep += ds.Tables[0].Rows[0].Field <double>("qtedep"); } catch {} } //req1 = "SELECT coded,codeg,num,codea,qte,ID FROM lentf where coded ='" + wcoded + "' and codeg = '" + wcodeg + "' and codea = '" + xcode + "' and codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codem='" + Program.Magasin + "' "; req1 = "SELECT distinct l.coded,l.codeg,l.num,l.codea,l.qte,e.type,l.ID FROM lentf l, eentf e where l.coded ='" + wcoded + "' and l.codeg = '" + wcodeg + "' and l.codea = '" + xcode + "' and e.num=l.num and e.type='C' and l.codes='" + Program.Societe + "' and l.codee = '" + Program.Exercice + "' and l.codem='" + Program.Magasin + "' "; ds = met.recuperer_table(req1, "lentf"); foreach (DataRow dr in ds.Tables["lentf"].Rows) { try { xtqte2 += dr.Field <Double>("qte"); } catch { } try { wtqte2 += dr.Field <Double>("qte"); } catch { } } req1 = "SELECT distinct l.coded,l.codeg,l.num,l.codea,l.qte,l.ID FROM lente l, eente e where l.coded ='" + wcoded + "' and l.codeg = '" + wcodeg + "' and l.codea = '" + xcode + "' and l.codes='" + Program.Societe + "' and l.codee = '" + Program.Exercice + "' and l.codem='" + Program.Magasin + "' "; ds = met.recuperer_table(req1, "lente"); foreach (DataRow dr in ds.Tables["lente"].Rows) { try { xtqte2 += dr.Field <Double>("qte"); } catch { } try { wtqte2 += dr.Field <Double>("qte"); } catch { } } req1 = "SELECT distinct l.coded,l.codeg,l.num,l.codea,l.qte,l.ID FROM lentcb l, eentcb e where l.coded ='" + wcoded + "' and l.codeg = '" + wcodeg + "' and l.codea = '" + xcode + "' and l.codes='" + Program.Societe + "' and l.codee = '" + Program.Exercice + "' and l.codem='" + Program.Magasin + "' "; ds = met.recuperer_table(req1, "lentcb"); foreach (DataRow dr in ds.Tables["lentcb"].Rows) { try { xtqte += dr.Field <Double>("qte"); } catch { } try { wtqte += dr.Field <Double>("qte"); } catch { } } //req1 = "SELECT coded,codeg,num,codea,qte,ID FROM lentc where coded ='" + wcoded + "' and codeg = '" + wcodeg + "' and codea = '" + xcode + "' and codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codem='" + Program.Magasin + "' "; req1 = "SELECT distinct l.coded,l.codeg,l.num,l.codea,l.qte,l.ID FROM lentc l, eentc e where l.coded ='" + wcoded + "' and l.codeg = '" + wcodeg + "' and l.codea = '" + xcode + "' and e.num=l.num and e.mode='D' and l.codes='" + Program.Societe + "' and l.codee = '" + Program.Exercice + "' and l.codem='" + Program.Magasin + "' "; ds = met.recuperer_table(req1, "lentc"); foreach (DataRow dr in ds.Tables["lentc"].Rows) { try { xtqte += dr.Field <Double>("qte"); } catch { } try { wtqte += dr.Field <Double>("qte"); } catch { } } req1 = "SELECT distinct l.coded,l.codeg,l.num,l.codea,l.qte,l.ID FROM lentl l, eentl e where l.coded ='" + wcoded + "' and l.codeg = '" + wcodeg + "' and l.codea = '" + xcode + "' and l.codes='" + Program.Societe + "' and l.codee = '" + Program.Exercice + "' and l.codem='" + Program.Magasin + "' "; ds = met.recuperer_table(req1, "lentl"); foreach (DataRow dr in ds.Tables["lentl"].Rows) { try { xtqte += dr.Field <Double>("qte"); } catch { } try { wtqte += dr.Field <Double>("qte"); } catch { } } req1 = "SELECT coded,codeg,num,codea,qte,ID FROM lentvc where coded ='" + wcoded + "' and codeg = '" + wcodeg + "' and codea = '" + xcode + "' and codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codem='" + Program.Magasin + "' "; ds = met.recuperer_table(req1, "lentvc"); foreach (DataRow dr in ds.Tables["lentvc"].Rows) { try { xtqte1 += dr.Field <Double>("qte"); } catch { } try { wtqte1 += dr.Field <Double>("qte"); } catch { } } req1 = "SELECT coded,codeg,num,codea,qte,ID FROM lentvf where coded ='" + wcoded + "' and codeg = '" + wcodeg + "' and codea = '" + xcode + "' and codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codem='" + Program.Magasin + "' "; ds = met.recuperer_table(req1, "lentvf"); foreach (DataRow dr in ds.Tables["lentvf"].Rows) { try { xtqte3 += dr.Field <Double>("qte"); } catch { } try { wtqte3 += dr.Field <Double>("qte"); } catch { } } //////Sauvegarde Article Dépot xstk = xqtedep + xtqte2 - xtqte3 - xtqte + xtqte1; string reqt1 = ""; reqt1 = "Update artdep set qteent = " + xtqte2.ToString().Replace(Program.sep, string.Empty) + ",qteavrc=" + xtqte1.ToString().Replace(Program.sep, string.Empty) + ",qtesor=" + xtqte.ToString().Replace(Program.sep, string.Empty) + ",qteavrf=" + xtqte3.ToString().Replace(Program.sep, string.Empty) + ",qtestk=" + xstk.ToString().Replace(Program.sep, string.Empty) + " Where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codem='" + Program.Magasin + "' and codea = '" + xcode + "' and coded ='" + wcoded + "' and codeg='" + wcodeg + "' "; met.Execute(reqt1); } } wstk = wqtedep + wtqte2 - wtqte3 - wtqte + wtqte1; string reqt2 = "Update artmag set qteent = " + wtqte2.ToString().Replace(Program.sep, string.Empty) + ",qteavrc=" + wtqte1.ToString().Replace(Program.sep, string.Empty) + ",qtesor=" + wtqte.ToString().Replace(Program.sep, string.Empty) + ",qteavrf=" + wtqte3.ToString().Replace(Program.sep, string.Empty) + ",qtestk=" + wstk.ToString().Replace(Program.sep, string.Empty) + " Where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "' and codem='" + Program.Magasin + "' and codea = '" + xcode + "' "; met.Execute(reqt2); } } progressBarX1.Value++; } progressBarX1.Visible = false; MessageBox.Show("Réorganisation effectuée avec Succés"); } else { MessageBox.Show("Accés Non Autorisé"); } }
private void buttonX5_Click(object sender, EventArgs e) { if (Program.ISSaDmin) { progressBarX1.Value = 0; progressBarX1.Visible = true; foreach (DataGridViewRow dgr in mygrid2.Rows) { progressBarX1.Maximum = mygrid2.Rows.Count; if (dgr.Cells["choixp"].Value != null) { if ((Boolean)dgr.Cells["choixp"].Value) { double xqtedep = 0, xstk = 0; Double xqteavrc = 0, xqteavrf = 0, xqtesor = 0, xqteent = 0; string req1 = ""; string xcode = dgr.Cells["codea"].Value + ""; ////// Article Magasin req1 = "SELECT codea,qtedep,qteent,qtesor,qteavrc,qteavrf,qtestk FROM artmag WHERE codes='" + Program.Societe + "' AND codee='" + Program.Exercice + "' and codea ='" + xcode + "' "; ds = met.recuperer_table(req1, "artmag"); if (ds != null) { if (ds.Tables.Count != 0) { if (ds.Tables[0].Rows.Count != 0) { foreach (DataRow dr in ds.Tables["artmag"].Rows) { try { xqtedep += dr.Field <double>("qtedep"); } catch { } try { xqteavrc += dr.Field <double>("qteavrc"); } catch { } try { xqteavrf += dr.Field <double>("qteavrf"); } catch { } try { xqteent += dr.Field <double>("qteent"); } catch { } try { xqtesor += dr.Field <double>("qtesor"); } catch { } try { xstk += dr.Field <double>("qtestk"); } catch { } } //// Sauvegarde Article Societe String reqt1 = "Update article set qteent = " + xqteent.ToString().Replace(Program.sep, string.Empty) + ",qteavrc=" + xqteavrc.ToString().Replace(Program.sep, string.Empty) + ",qtesor=" + xqtesor.ToString().Replace(Program.sep, string.Empty) + ",qteavrf=" + xqteavrf.ToString().Replace(Program.sep, string.Empty) + ",qtestk=" + xstk.ToString().Replace(Program.sep, string.Empty) + ",qtedep=" + xqtedep.ToString().Replace(Program.sep, string.Empty) + " Where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "' and code = '" + xcode + "' "; met.Execute(reqt1); } } } } } progressBarX1.Value++; } progressBarX1.Visible = false; MessageBox.Show("Réorganisation effectuée avec Succés"); } else { MessageBox.Show("Accés Non Autorisé"); } }