private static void LoadCaches()
{
var stationBll = new BaseStationBll();
var trainNoBll = new TrainNoBll();
_stationCaches = stationBll.QueryList("IsDelete=0").ToList();
_trainNoCaches = trainNoBll.QueryList("IsDelete=0").ToList();
}
public JsonResult StationEdit()
{
var stationJson = Request["station"];
var station = JsonHelper.Deserialize <BaseStation>(stationJson);
var updateType = station.Id > 0 ? DataUpdateType.Update : DataUpdateType.Insert;
// 更新车站
var stationUpdateRes = false;
var stationBll = new BaseStationBll();
if (station.Id > 0)
{
stationUpdateRes = stationBll.Update(station);
}
else
{
var condition = string.Format("StationName='{0}' AND IsDelete=0", station.StationName);
if (stationBll.Exists(condition))
{
return(Json(ErrorModel.ExistSameItem));
}
var insertedStation = stationBll.Insert(station);
stationUpdateRes = insertedStation.Id > 0;
}
// 更新文件
if (stationUpdateRes)
{
// 写入更新记录
DataUpdateLog.SingleUpdate(typeof(BaseStation).Name, station.Id, updateType);
var filesJson = Request["files"];
var files = JsonHelper.Deserialize <StationFiles[]>(filesJson);
if (!files.Any())
{
return(Json(ErrorModel.OperateSuccess));
}
files.ForEach(f => { f.StationId = station.Id; });
var filesToInsert = files.Where(f => f.Id == 0);
var filesBll = new StationFilesBll();
var maxId = (int)filesBll.GetMaxId();
filesBll.BulkInsert(filesToInsert);
// 写入更新记录
DataUpdateLog.BulkUpdate(typeof(StationFiles).Name, maxId);
return(Json(ErrorModel.OperateSuccess));
}
return(Json(ErrorModel.OperateFailed));
}
public JsonResult SearchStations(string key)
{
if (string.IsNullOrEmpty(key))
{
return(Json(ErrorModel.InputError));
}
var stationBll = new BaseStationBll();
var condition = string.Format("IsDelete=0 AND Spell LIKE '{0}%' OR StationName LIKE '%{0}%' OR SN LIKE '%{0}%'", key);
var stations = stationBll.QueryList(condition);
return(Json(ErrorModel.GetDataSuccess(stations)));
}
public JsonResult GetStationInfo(int stationId)
{
var stationBll = new BaseStationBll();
var station = stationBll.QuerySingle(stationId);
if (station != null)
{
var stationFileBll = new StationFilesBll();
var files = stationFileBll.QueryList(string.Format("StationId={0} AND IsDelete=0", stationId));
var jsonObj = new
{
station = station,
files = files
};
var response = ErrorModel.GetDataSuccess(jsonObj);
return(Json(response));
}
return(Json(ErrorModel.GetDataFailed));
}
/// <summary>
/// 将指定集合中的车站信息写入数据库，并确保数据库中不会存在同名的车站
/// 对于已经存在的车站则查询数据库，将新值存入返回的集合中
/// 对于新的车站则插入数据库，将插入后的新值存入返回的集合中
/// 最终返回的集合中所有的车站均带有唯一主键
/// </summary>
/// <param name="stations">待写稿的车站信息集合</param>
/// <returns><see cref="List{BaseStation}"/>对象</returns>
private static List <BaseStation> WriteStations(List <BaseStation> stations)
{
var stationBll = new BaseStationBll();
var newStations = new List <BaseStation>();
stations.ForEach(s =>
{
var temp = _stationCaches.Find(item => item.StationName == s.StationName);
if (temp != null)
{
newStations.Add(temp);
}
else
{
stationBll.Insert(s);
DataUpdateLog.SingleUpdate(nameof(BaseStation), s.Id, DataUpdateType.Insert);
newStations.Add(s);
_stationCaches.Add(s);
}
});
return(newStations);
}
