当用户在数据库中插入数据时，如何插入当前日期和时间

Question

我正在尝试将数据插入数据库。 我基本上是在尝试获取当前日期，我也隐藏了该特定字段("更新日期"(，因为我确实希望用户看到。现在我想要的只是每当我将一些数据插入数据库创建日期时，都应该自动插入。

控制器

[HttpPost]
    [ValidateAntiForgeryToken]
    public ActionResult Create(StoreImageCreateVM StoreImageVM)
    {
        if (ModelState.IsValid)
        {
            try
            {
                StoreImageLogic.Insert(StoreImageVM);
            }
            catch (Exception e) 
            {
                TempData["Failure"] = "Creation Failed. Image too large.";
                return View(StoreImageVM);
            }
            TempData["Success"] = "Creation Successful";
            return RedirectToAction("Index", new { id = StoreImageVM.StoreID });
        }
  return View(StoreImageVM);
    }

保存更改方法

 public bool Insert(StoreImageCreateVM imageVM)
    {
        StoreImage image = new StoreImage();
        image.StoreID = imageVM.StoreID;
        image.ImageDescription = imageVM.Description;
        image.UploadDate = imageVM.uploadDate;

        //Upload the file
        string path = AppDomain.CurrentDomain.BaseDirectory + @"ContentUploads";            
        string filename = imageVM.File.FileName;
        string fullPath = Path.Combine(path, filename);
        imageVM.File.SaveAs(fullPath);
        //Set imageURL
        string serverFilePath = @"ContentUploads";
        image.FullFilePath = serverFilePath + filename;
        image.Active = true;
        return base.Insert(image).StoreImageID != 0;
    }
}

Answer 1

我只是通过使用DateTime.Now方法添加以更改SaveChanges方法。 见下文。

        public bool Insert(StoreImageCreateVM imageVM)
    {
        StoreImage image = new StoreImage();
        image.StoreID = imageVM.StoreID;
        image.ImageDescription = imageVM.Description;
        image.UploadDate = DateTime.Now;

        //Upload the file
        string path = AppDomain.CurrentDomain.BaseDirectory + @"ContentUploads";            
        string filename = imageVM.File.FileName;
        string fullPath = Path.Combine(path, filename);
        imageVM.File.SaveAs(fullPath);
        //Set imageURL
        string serverFilePath = @"ContentUploads";
        image.FullFilePath = serverFilePath + filename;
        image.Active = true;
        return base.Insert(image).StoreImageID != 0;
    }
}

}