public void SetDefaultEmpl(string str, IBODepotEmplacement emplacement, Action <IBOArticle3, Exception> callback)
{
try
{
callback(repos.SetDefaultEmpl(str, emplacement), null);
}
catch (Exception e)
{
callback(null, e);
}
}
public void GetArticles(IBODepotEmplacement emplacement, Action <Collection <Article>, Exception> callback)
{
try
{
callback(repos.GetArticles(emplacement), null);
}
catch (Exception e)
{
callback(null, e);
}
}
internal Collection <Article> GetArticles(IBODepotEmplacement emplacement)
{
using (SqlConnection cnx = new SqlConnection(cnxString))
{
cnx.Open();
using (SqlCommand cmd = cnx.CreateCommand())
{
cmd.CommandText = @"SELECT A.AR_Ref, A.AR_Design, A.AR_Ref, AE.AE_Ref, AG1.EG_Enumere AS Gamme1, AG2.EG_Enumere AS Gamme2,
CASE WHEN AG1.EG_Enumere IS NOT NULL THEN ISNULL(GS.GS_QteSto, 0) ELSE ISNULL(S.AS_QteSto, 0) END AS QteSto,
CASE WHEN AG1.EG_Enumere IS NOT NULL THEN ISNULL(GS.GS_QteCom, 0) ELSE ISNULL(S.AS_QteCom, 0) END AS QteCom,
CASE WHEN AG1.EG_Enumere IS NOT NULL THEN ISNULL(GS.GS_QteRes, 0) ELSE ISNULL(S.AS_QteRes, 0) END AS QteRes
FROM F_ARTICLE A
LEFT JOIN F_ARTGAMME AG1 ON AG1.AR_Ref = A.AR_Ref AND AG1.AG_Type = 0
LEFT JOIN F_ARTGAMME AG2 ON AG2.AR_Ref = A.AR_Ref AND AG2.AG_Type = 1
LEFT JOIN F_ARTENUMREF AE ON AE.AG_No1 = AG1.AG_No AND AE.AG_No2 = ISNULL(AG2.AG_No, 0)
LEFT JOIN F_ARTSTOCK S ON S.AR_Ref = A.AR_Ref
LEFT JOIN F_GAMSTOCK GS ON GS.AR_Ref = A.AR_Ref AND GS.AG_No1 = AG1.AG_No AND GS.AG_No2 = ISNULL(AG2.AG_No, 0)
JOIN P_UNITE AS UV ON UV.cbIndice = A.AR_UniteVen
JOIN F_ARTCLIENT AC ON AC.AR_Ref = A.AR_Ref AND AC.AC_Categorie = 1
LEFT JOIN F_DEPOTEMPL DP ON S.DE_No = DP.DE_No AND S.DP_NoPrincipal = DP.DP_No
JOIN F_DEPOT DE ON DE.DE_No = S.DE_No AND DE.DE_Code = @deCode
WHERE DP.DP_Code = @dpCode";
cmd.Parameters.AddWithValue("@deCode", emplacement.Depot.DE_Code);
cmd.Parameters.AddWithValue("@dpCode", emplacement.DP_Code);
using (SqlDataReader reader = cmd.ExecuteReader())
{
Collection <Article> list = new Collection <Article>();
while (reader.Read())
{
list.Add(new Article()
{
ArRef = (string)reader["AR_Ref"],
AeRef = (reader["AE_Ref"] == DBNull.Value) ? null : (string)reader["AE_Ref"],
Gamme1 = (reader["Gamme1"] == DBNull.Value) ? null : (string)reader["Gamme1"],
Gamme2 = (reader["Gamme2"] == DBNull.Value) ? null : (string)reader["Gamme2"],
Designation = reader["AR_Design"].ToString(),
Stock = double.Parse(reader["QteSto"].ToString())
});
}
return(list);
}
}
}
}
internal IBOArticle3 SetDefaultEmpl(string str, IBODepotEmplacement empl)
{
if (!openBaseCial())
{
throw new Exception("Impossible de se connecter à la base");
}
using (SqlConnection cnx = new SqlConnection(cnxString))
{
cnx.Open();
using (SqlCommand cmd = cnx.CreateCommand())
{
cmd.CommandText = @"SELECT DISTINCT A.AR_Ref, AE.AE_Ref, CO.CO_Ref, AG1.EG_Enumere AS Gamme1, AG2.EG_Enumere AS Gamme2
FROM F_ARTICLE A
LEFT JOIN F_ARTGAMME AG1 ON AG1.AR_Ref = A.AR_Ref AND AG1.AG_Type = 0
LEFT JOIN F_ARTGAMME AG2 ON AG2.AR_Ref = A.AR_Ref AND AG2.AG_Type = 1
LEFT JOIN F_ARTENUMREF AE ON AE.AG_No1 = AG1.AG_No AND AE.AG_No2 = ISNULL(AG2.AG_No, 0)
JOIN F_ARTFOURNISS AF ON AF.AR_Ref = A.AR_Ref
LEFT JOIN F_TARIFGAM TG ON TG.AG_No1 = AG1.AG_No AND TG.AG_No2 = ISNULL(AG2.AG_No, 0) AND TG.TG_RefCF = AF.CT_Num
LEFT JOIN F_CONDITION CO ON CO.AR_Ref = A.AR_Ref
WHERE A.AR_Ref = @str
OR AE.AE_Ref = @str
OR CO.CO_Ref = @str
OR A.AR_CodeBarre = @str
OR AF.AF_CodeBarre = @str
OR AE.AE_CodeBarre = @str
OR TG.TG_CodeBarre = @str
OR CO.CO_CodeBarre = @str";
cmd.Parameters.AddWithValue("@str", str);
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (!reader.HasRows)
{
throw new Exception("Article non trouvé");
}
reader.Read();
IBOArticle3 article = GetInstance().FactoryArticle.ReadReference(reader["AR_Ref"].ToString());
if (article.ArticleDepotPrincipal == null)
{
IBOArticleDepot3 ad = (IBOArticleDepot3)article.FactoryArticleDepot.Create();
ad.Depot = empl.Depot;
ad.EmplacementPrincipal = empl;
ad.WriteDefault();
article.Refresh();
}
else
{
article.ArticleDepotPrincipal.EmplacementPrincipal = empl;
article.ArticleDepotPrincipal.Write();
article.Refresh();
}
return(article);
}
}
}
}
public void SetDefaultEmpl(string str, IBODepotEmplacement emplacement, Action <IBOArticle3, Exception> callback)
{
throw new NotImplementedException();
}
public void GetArticles(IBODepotEmplacement emplacement, Action <Collection <Article>, Exception> callback)
{
throw new NotImplementedException();
}
