private String GenererNumAR()
        {
            string exerci = DateTime.Now.Date.Year.ToString().Substring(2, 2);
            //**********************************************************************************************
            if (DB._0310_AchatRevendu.Count() == 0) return "A001/" + exerci;
            //**********************************************************************************************
            string dernierNumAR = DB._0310_AchatRevendu.Where(x => x.numAchatRevendu.StartsWith("A") && x.dateAchat.Value.Date.Year == DateTime.Now.Date.Year).ToList().Last().numAchatRevendu;
            int numAR = 0;
            String Code;

            if (dernierNumAR.StartsWith("A") && int.TryParse(dernierNumAR.Substring(1, 3), out numAR))
            {

                Code = String.Format("A{0:000}", numAR + 1) + "/" + exerci;
                for (int i = 1; i < 1000; i++)
                {
                    Code = String.Format("A{0:000}", numAR + i) + "/" + exerci;
                    if (!DB._0310_AchatRevendu.Any(l => l.numAchatRevendu == Code)) return Code;
                }

            }
            else
            {
                return Code = "";
            }
            //**********************************************************************************************

            return "";
        }