/// <summary>
/// 为列车时刻表中的车站Id、车次线路表Id赋值，并写入数据库
/// </summary>
private static void WriteTrainMoments(TimeTable table)
{
for (var i = 0; i < table.Moments.Count; i++)
{
table.Moments[i].Sort = i;
table.Moments[i].TrainStationId = table.Stations[i].Id;
table.Moments[i].TrainNoLineId = table.TrainNoLineRelation.Id;
}
var bll = new TrainMomentBll();
var maxId = (int)bll.GetMaxId();
bll.BulkInsert(table.Moments);
DataUpdateLog.BulkUpdate(nameof(TrainMoment), maxId);
}
/// <summary>
/// 构造线路-车站关系并写入数据库
/// </summary>
/// <param name="table"></param>
private static void WriteLineStaionRelation(TimeTable table)
{
// 构造线路-车站关系并写入数据库
var lineStationRelation = new List <LineStations>();
for (var i = 0; i < table.Stations.Count; i++)
{
lineStationRelation.Add(new LineStations
{
LineId = table.Line.Id,
Sort = i,
StationId = table.Stations[i].Id,
StationName = table.Stations[i].StationName
});
}
var lineStationsBll = new LineStationsBll();
var startId = (int)lineStationsBll.GetMaxId(); // 记录插入之前的最大ID
lineStationsBll.BulkInsert(lineStationRelation);
DataUpdateLog.BulkUpdate(nameof(LineStations), startId); // 将数据更新记录同步到DbUpdataLog表中
}
