private static void InsertAssert(EquipmentContext context, string filepath) { if (context.Asserts.Any()) { return; // DB has been seeded } string[] Datas = Reader(filepath); foreach (var line in Datas.Skip(1)) { if (line.Trim() == "") { continue; } var data = line.Split(","); // 无日期转换 DateTime.TryParse(data[3], out DateTime datetime); context.Asserts.Add( new Assert { InstrumentId = data[0], Code = data[1], Name = data[2], EntryDate = datetime, SourceUnit = data[4], Remark = data[5] } ); } context.SaveChanges(); }
private static void InsertCalibration(EquipmentContext context, string filepath) { if (context.Calibrations.Any()) { return; // DB has been seeded } string[] Datas = Reader(filepath); foreach (var line in Datas.Skip(1)) { if (line.Trim() == "") { continue; } var data = line.Split(","); // 无日期转换 DateTime.TryParse(data[1], out DateTime datetime); context.Calibrations.Add( new Calibration { InstrumentID = data[0], Date = datetime, Unit = data[2], Result = Result.Passed, Calibrator = data[4], } ); } context.SaveChanges(); }
private static void InsertComponent(EquipmentContext context, string filepath) { if (context.Components.Any()) { return; // DB has been seeded } string[] Datas = Reader(filepath); foreach (var line in Datas.Skip(1)) { if (line.Trim() == "") { continue; } var data = line.Split(","); context.Components.Add( new Component { InstrumentID = data[0], SerialNumber = data[1], Name = data[2], Model = data[3], Brand = data[4], } ); } context.SaveChanges(); }
private static void InsertInstrument(EquipmentContext context, string filepath) { if (context.Instruments.Any()) { return; // DB has been seeded } string[] Datas = Reader(filepath); foreach (var line in Datas.Skip(1)) { if (line.Trim() == "") { continue; } var data = line.Split(","); // 无日期转换 DateTime.TryParse(data[3], out DateTime datetime); context.Instruments.Add( new Instrument { ID = data[0], Platform = data[1], Name = data[2], StartUsingDate = datetime, CalibrationCycle = int.Parse(data[4]), MetrologicalCharacteristics = data[5], Status = InstrumentStatus.Using, Location = data[7], Principal = data[8], NewSystemCode = data[9], Group = data[10], Projects = data[11], Remark = data[12] } ); } context.SaveChanges(); }