Example #1
0
        /// <summary>
        /// 生成流水号
        /// </summary>
        /// <param name="NumCode">流水号代码</param>
        /// <returns></returns>
        public String Generate(String NumCode)
        {
            string numPrefixFormat = NumberSeed.ReadNumberSeed(NumCode);

            lock (syncRoot)
            {
                if (numPrefixFormat.Contains("{0"))
                {
                    Core.DbContext db   = new Core.DbContext();
                    var            Seed = db.SysNumberSeedDb.GetSingle(x => x.NumCode == NumCode && x.PrefixFormat == numPrefixFormat);

                    if (Seed == null)
                    {
                        db.SysNumberSeedDb.Insert(new Model.Sys_NumberSeed {
                            PrefixFormat = numPrefixFormat, NumCode = NumCode, Seed = 1
                        });
                        return(string.Format(numPrefixFormat, 1));
                    }

                    Seed.Seed = Convert.ToInt32(Seed.Seed) + 1;
                    db.SysNumberSeedDb.Update(Seed);
                    return(string.Format(numPrefixFormat, Seed.Seed));
                }
                return(numPrefixFormat);
            }
        }
Example #2
0
        static void Test()
        {
            var factory = new UnitOfWorkFactory <SQLiteConnection>("Data Source=file.db");

            var db = new Core.DbContext(factory);

            db.CreateDb();
        }
Example #3
0
 public SerialNoHelper()
 {
     Core.DbContext db = new Core.DbContext();
     if (NumberSeed.number == null || NumberSeed.number.Count == 0)
     {
         NumberSeed.number = db.SysNumberDb.GetList();
     }
     if (NumberSeed.numprefix == null || NumberSeed.numprefix.Count == 0)
     {
         NumberSeed.numprefix = db.SysNumberPrefixDb.GetList();
     }
     if (NumberSeed.number_numprefix == null || NumberSeed.number_numprefix.Count == 0)
     {
         NumberSeed.number_numprefix = db.SysNumberNumPrefixDb.GetList();
     }
 }