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();
}
