private void AfficherJournalCorrespondant(string description)
{
//var coutUnitaire = 0f;
var entrees = (from psf in db.ResStockProduitsSemiFinis
where psf.Description == description
join ppsf in db.EveProductionProduitsSemiFinis on psf.CodeProduitSemiFini equals ppsf.CodeProduitSemiFini
join prod in db.EveProductions on ppsf.CodeProduction equals prod.CodeProduction
select new
{
prod.Date,
Description = "Production de " + psf.Description,
Entree = ppsf.QuantiteProduitSemiFini,
Sortie = 0f,
Solde = 0f
});
var sorties = (from mp in db.ResStockMatieresPremieres
join psf in db.ResStockProduitsSemiFinis on mp.CodeMatierePremiere equals psf.CodeMatierePremiere
join upsf in db.EveUtilisationProduitsSemiFinis on psf.CodeProduitSemiFini equals upsf.CodeProduitSemiFini
join prod in db.EveProductions on upsf.CodeUtilisationRessource equals prod.CodeUtilisationRessources
where psf.Description == description
select new
{
prod.Date,
Description = "Utilisation de " + psf.Description,
Entree = 0f,
Sortie = upsf.QuantiteProduitSemiFini,
Solde = 0f
});
var resultat = entrees.Concat(sorties)
.OrderByDescending(d => d.Date)
.ToList();
var stockInitial = (from mp in db.ResStockMatieresPremieres
join psf in db.ResStockProduitsSemiFinis on mp.CodeMatierePremiere equals psf.CodeMatierePremiere
where psf.Description == description
select psf.Quantite).FirstOrDefault();
DataTable dt = Conversion.ConvertirEnTableDeDonnees(resultat);
DataRow dr = dt.NewRow();
dt.Rows.InsertAt(dr, dt.Rows.Count);
dr["Entree"] = 0;
dr["Sortie"] = 0;
dr["Description"] = "Stock initial";
dgvJournalStocksProduitsSemiFinis.DataSource = dt;
Formattage.TableauDesStock(dgvJournalStocksProduitsSemiFinis);
GestionStocks.CalculerSoldeStocksDeFaconProgressive(dgvJournalStocksProduitsSemiFinis, stockInitial);
Formattage.ChangerTitreTableauDesStocks(dgvJournalStocksProduitsSemiFinis, "kg");
}
