using (MESDB db = new MESDB())
{
var repair = new MesRepair()
{
F_ID = Guid.NewGuid().ToString(),
MachineNum = "666",
RepairEndTime = Convert.ToDateTime("2021/04/27 13:00:00.500"),
};
var tempRepairEndTimeList = new List<DateTime>();
tempRepairEndTimeList.Add(repair.RepairEndTime.Value);
Redis.GetCache.HashSet(
Redis.TCPS_RealTimeMachineInfo + "666", "RepairEndTimeList",
tempRepairEndTimeList);
db.MesRepair.Add(repair);
db.SaveChanges();
}
由于 MySQL的datetime类型只会精确到秒。四舍五入以后,
MySQL如下: