private void valider_Click(object sender, EventArgs e) { SqlDataAdapter dataadapter; DataSet dataset; string sql; string dd = "", df = "", np = ""; dd = debut.Value.Date.ToString("yyyyMMdd"); df = fin.Value.Date.ToString("yyyyMMdd"); //np = valProduit.Text.ToUpper(); np = productList.Rows[listeArticle.SelectedIndex][0].ToString(); //MessageBox.Show(debut.Value.Date.ToString("yyyy-MM-dd")); sql = $"SELECT DISTINCT CT_Intitule AS 'CLIENTS' from F_COMPTET,F_DOCLIGNE where F_COMPTET.CT_Num = F_DOCLIGNE.CT_Num AND CT_Type = 0 AND AR_Ref = '{np}' AND DO_Date between convert(datetime,'{dd}') AND convert(datetime,'{df}')"; dataadapter = new SqlDataAdapter(sql, connector.getConnector()); dataset = new DataSet(); dataadapter.Fill(dataset, "Clients"); resultat.DataSource = dataset; resultat.DataMember = "Clients"; resultat.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; dataadapter.Dispose(); }
public void getStockDepot() { Node p = this.head; int i, depot; while (p != null) { String request = @" select F_DEPOT.DE_No,AS_QteSto,DE_Intitule from F_ARTSTOCK,F_DEPOT where AR_Ref='{0}' and F_DEPOT.DE_No = F_ARTSTOCK.DE_No and F_ARTSTOCK.DE_No <> 7 order by F_ARTSTOCK.DE_No "; request = String.Format(request, p.ar_ref); i = 1; using (SqlCommand cmd = new SqlCommand(request, sqlserver.getConnector())) { using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { depot = dr.GetInt32(0); if (depot == 1) { p.ar_qtedp = dr.GetDecimal(1); } else if (depot == 2) { p.ar_qtekousseri = dr.GetDecimal(1); } else if (depot == 3) { p.ar_qteyde = dr.GetDecimal(1); } else if (depot == 4) { p.ar_qteyato = dr.GetDecimal(1); } else if (depot == 5) { p.ar_qteakwa2 = dr.GetDecimal(1); } else if (depot == 6) { p.ar_qteakwa3 = dr.GetDecimal(1); } else if (depot == 8) { p.ar_qtegaroua = dr.GetDecimal(1); } else if (depot == 9) { p.ar_qtebamenda = dr.GetDecimal(1); } } } } p = p.right; } }
public void getArticles() { String request = @" select AR_Ref,AR_Design,AR_PrixVen from F_ARTICLE where AR_Sommeil=0 "; using (SqlCommand cmd = new SqlCommand(request, dbcon.getConnector())) { using (SqlDataReader dr = cmd.ExecuteReader()) { String[] row; while (dr.Read()) { row = new string[3]; row[0] = dr.GetString(0); row[1] = dr.GetString(1); row[2] = DecimalToString(dr.GetDecimal(2)); listeArticles.Rows.Add(row); } } } }
public void getRequiredArticles() { using (SqlCommand sc = new SqlCommand(sqlvenduHebdo(), sqlsrv.getConnector())) { using (SqlDataReader dr = sc.ExecuteReader()) { Node p; while (dr.Read()) { p = new Node(); p.ar_ref = dr.GetString(0); p.ar_design = dr.GetString(1); enfiler(p); } } } }
public void getArticlesReliquat() { DateTime date = DateTime.Now; //date = date.AddDays(-1); if (date.DayOfWeek.ToString() == "Monday") { date = date.AddDays(-2); } else { date = date.AddDays(-1); } String request = @" SELECT AR_Ref,DL_Design,sum(DL_Qte) as 'quantite' from F_DOCLIGNE,F_DOCENTETE where F_DOCLIGNE.DO_Date = '{0}' and F_DOCENTETE.DO_Domaine=0 and F_DOCENTETE.DO_Type=1 and F_DOCENTETE.DO_Reliquat = 1 and F_DOCENTETE.DO_Piece = F_DOCLIGNE.DO_Piece and AR_Ref is not null group by AR_Ref,DL_Design order by DL_Design "; request = String.Format(request, date.Date.ToString("yyyyMMdd")); using (SqlCommand cmd = new SqlCommand(request, sqlconn.getConnector())) { using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { Node p = new Node(); p.ar_ref = dr.GetString(0); p.ar_design = dr.GetString(1); p.ar_quantite = dr.GetDecimal(2); enfiler(p); } } } }
private int choix;/* * vaut 0 si l'operation est basee sur les factures, 1 si il s'agit des devis */ public AnalyseArticles() { server = new SqlserverConnection(); cnnp = server.getConnector(); }