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); }