public JsonResult GetTrainNo(int id)
{
var trainNoBll = new TrainNoBll();
var trainNo = trainNoBll.QuerySingle("IsDelete=0 AND Id=" + id);
if (trainNo == null)
{
return(Json(ErrorModel.GetDataFailed));
}
var viewLineBll = new ViewTrainNoLIneBll();
var lines = viewLineBll.QueryList("Id=" + id);
var json = ErrorModel.GetDataSuccess(new
{
trainNo,
lines
});
return(Json(json));
}
public ActionResult TrainMoment(int?trainNoId)
{
if (trainNoId == null)
{
return(RedirectToAction("TrainNo"));
}
var trainNoBll = new TrainNoBll();
var trainMomentBll = new ViewTrainMomentBll();
var trainNo = trainNoBll.QuerySingle(trainNoId);
if (trainNo == null)
{
return(RedirectToAction("TrainNo"));
}
var moments = trainMomentBll.QueryList("TrainNoId=" + trainNoId, null, null, "Sort").ToList();
var trainMomentHasAdded = true;
if (!moments.Any())
{
trainMomentHasAdded = false;
var lineStationBll = new LineStationsBll();
var viewTrainNoLineBll = new ViewTrainNoLIneBll();
var lines = viewTrainNoLineBll.QueryList("Id=" + trainNoId, null, null, "Sort");
var lineIds = lines.Select(item => item.LineId);
var condition = string.Format("LineId IN({0})", string.Join(",", lineIds));
var stations = lineStationBll.QueryList(condition);
var lineStationDic = new List <KeyValuePair <ViewTrainNoLIne, List <LineStations> > >();
lines.ForEach(line =>
{
// 将线路与其经过的车站以键值对的方式按顺序归到一起
var theStations = stations.Where(item => item.LineId == line.LineId).OrderBy(item => item.Sort);
lineStationDic.Add(new KeyValuePair <ViewTrainNoLIne, List <LineStations> >(line, theStations.ToList()));
});
// 构造一个ViewTrainMoment集合以便在前台统一展示
var lineCounter = 0;
var stationOrder = 0;
moments = new List <ViewTrainMoment>();
lineStationDic.ForEach(item =>
{
lineCounter++;
var tempLine = item.Key;
var tempSations = item.Value;
var stationCounter = 0;
tempSations.ForEach(t =>
{
stationCounter++;
if (lineCounter > 1 && stationCounter == 1)
{
// 由于上一条线的终点站与下一站的终点站相同，此处去掉后一条线的起点站
return;
}
stationOrder++;
var model = new ViewTrainMoment();
model.FullName = trainNo.FullName;
model.Sort = stationOrder;
model.StationName = t.StationName;
model.TrainNoId = trainNo.Id;
model.TrainNoLineId = tempLine.TrainNoLineId;
model.TrainStationId = t.StationId;
model.LineId = t.LineId;
model.LineName = tempLine.LineName;
moments.Add(model);
});
});
}
ViewBag.Id = trainNoId;
ViewBag.TrainNo = trainNo;
ViewBag.Moments = moments.ToList();
ViewBag.IsFirstTime = !trainMomentHasAdded;
return(View());
}