Exemple #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            //using (ApplicationDbContext db = new ApplicationDbContext())
            //{
            //    db.Database.CreateIfNotExists();
            //}
            foreach (var path in Directory.GetFiles(@"D:\Work\Stock\samples\stock", "*.txt", SearchOption.TopDirectoryOnly))
            {
                FileInfo fi    = new FileInfo(path);
                var      lines = File.ReadAllLines(path, Encoding.Default);

                using (var db = new MongoDBContext())
                {
                    List <DailyPrice> list = new List <DailyPrice>();
                    for (int i = 2; i < lines.Length - 1; i++)
                    {
                        var item = DailyPrice.NewDailyPrice(lines[i]);
                        if (item == null)
                        {
                            continue;
                        }
                        item.Id   = Guid.NewGuid().ToString("N");
                        item.Code = fi.Name.Replace(fi.Extension, "");
                        list.Add(item);
                    }
                    if (list.Count > 0)
                    {
                        foreach (var item in list)
                        {
                            db.DataSet <DailyPrice>().Insert(item);
                        }
                    }
                }
                File.Move(fi.FullName, @"D:\Work\Stock\samples\OK\" + fi.Name);
            }
        }