Exemplo n.º 1
0
 public ActionResult UpdateOrderTime()
 {
     using (var db = new ShiJieBeiDbContext())
     {
         // 批量更新
         Random random  = new Random();
         var    entitys = db.GameOrders;
         entitys.ToList().ForEach(item =>
         {
             int day        = random.Next(14, 20);
             int hour       = random.Next(0, 24);
             int minute     = random.Next(0, 60);
             int second     = random.Next(0, 60);
             string tempStr =
                 $"{DateTime.Now:yyyy}-{DateTime.Now:MM}-{day} {hour}:{minute}:{second}";
             DateTime rTime  = Convert.ToDateTime(tempStr);
             item.CreateTime = rTime;
         });
         db.SaveChanges();
     }
     //foreach (var item in _db.GameOrders)
     //{
     //    Random random = new Random();
     //    int day = random.Next(14, 20);
     //    int hour = random.Next(0, 24);
     //    int minute = random.Next(0, 60);
     //    int second = random.Next(0, 60);
     //    string tempStr = string.Format("{0}-{1}-{2} {3}:{4}:{5}", DateTime.Now.ToString("yyyy"),DateTime.Now.ToString("MM"), day, hour, minute, second);
     //    DateTime rTime = Convert.ToDateTime(tempStr);
     //    item.CreateTime = rTime;
     //    _db.Entry(item).State = System.Data.Entity.EntityState.Modified;
     //}
     //_db.SaveChanges();
     return(Content($"{DateTime.Now}更新时间成功"));
 }