/// <summary> /// 根据type获取对应的Station信息列表按照Descr排序 /// </summary> /// <param name="type"></param> /// <returns>Station信息列表</returns> public IList<StationInfo> GetStationReinputList() { IList<StationInfo> retlist = new List<StationInfo>(); try { IStationRepository stationRep = RepositoryFactory.GetInstance().GetRepository<IStationRepository>(); IPartRepository partRep = RepositoryFactory.GetInstance().GetRepository<IPartRepository, IPart>(); IList<string> valueList = new List<string>(); valueList = partRep.GetValueFromSysSettingByName("FAReturnStation"); if (valueList.Count == 0) { return retlist; } //Station不等于F0/45/57/76/6A/66/66E/71/73/79 string[] stationArray = valueList[0].Split(','); string excludestr = "F0/45/57/76/6A/66/66E/71/73/79"; foreach (string stationID in stationArray) { if (!excludestr.Contains(stationID)) { IStation station = stationRep.Find(stationID); StationInfo staInfo = new StationInfo(); staInfo.StationId = stationID; staInfo.Descr = station.Descr; retlist.Add(staInfo); } } return retlist; } catch (Exception) { throw; } }
/// <summary> /// 根据type获取对应的Station信息列表按照Descr排序 /// </summary> /// <param name="type"></param> /// <returns>Station信息列表</returns> public IList<StationInfo> GetStationSortingList() { IList<StationInfo> retlist = new List<StationInfo>(); try { IStationRepository stationRep = RepositoryFactory.GetInstance().GetRepository<IStationRepository>(); IPartRepository partRep = RepositoryFactory.GetInstance().GetRepository<IPartRepository, IPart>(); IList<string> valueList = new List<string>(); valueList = partRep.GetValueFromSysSettingByName("PAQCSortingStation"); if (valueList.Count == 0) { return retlist; } string[] stationArray = valueList[0].Split(','); foreach (string stationID in stationArray) { IStation station = stationRep.Find(stationID); StationInfo staInfo = new StationInfo(); staInfo.StationId = stationID; staInfo.Descr = station.Descr; retlist.Add(staInfo); } return retlist; } catch (Exception) { throw; } }
/// <summary> /// 根据type获取对应的Station信息列表按照Descr排序 /// </summary> /// <param name="type"></param> /// <returns>Station信息列表</returns> public IList<StationInfo> GetStationByTypeList(string type) { IList<StationInfo> retlist = new List<StationInfo>(); try { IStationRepository stationRepository = RepositoryFactory.GetInstance().GetRepository<IStationRepository>(); IList<IStation> stalist = stationRepository.GetStationListFromStation(type); if (stalist != null && stalist.Count > 0) { StationInfo staInfo = null; foreach (IStation sta in stalist) { staInfo = new StationInfo(); staInfo.StationId = sta.StationId; staInfo.Descr = sta.Descr; retlist.Add(staInfo); } } return retlist; } catch (Exception) { throw; } }
public IList<StationInfo> GetStationListByLineAndType(string pdline, string type) { IList<StationInfo> retLst = new List<StationInfo>(); try { ILineRepository stationRepository = RepositoryFactory.GetInstance().GetRepository<ILineRepository>(); IList<IStation> tempLst = stationRepository.GetStationListByLineAndStationType(pdline, type); if (tempLst != null && tempLst.Count > 0) { StationInfo stationInfo = null; foreach (IStation temp in tempLst) { stationInfo = new StationInfo(); stationInfo.StationId = temp.StationId; stationInfo.Descr = temp.Descr; retLst.Add(stationInfo); } } return retLst; } catch (Exception) { throw; } }
/// <summary> /// 获取全部站信息列表 /// </summary> /// <returns>站信息列表</returns> public IList<StationInfo> GetAllStationInfo() { try { IList<StationInfo> staInfolist = null; var stationRepository = RepositoryFactory.GetInstance().GetRepository<IMES.FisObject.Common.Station.IStationRepository, IMES.FisObject.Common.Station.IStation>(); IList<IStation> stalist = stationRepository.FindAll(); staInfolist = new List<StationInfo>(); if (stalist != null && stalist.Count > 0) { StationInfo staInfo = null; foreach (IStation sta in stalist) { staInfo = new StationInfo(); staInfo.StationId = sta.StationId; staInfo.Descr = sta.Descr; staInfolist.Add(staInfo); } } return staInfolist; } catch (Exception ex) { throw ex; } }
public IList<StationInfo> GetAllPartCollectionStation() { try { IList<StationInfo> ret = null; MethodBase mthObj = MethodBase.GetCurrentMethod(); int tk = mthObj.MetadataToken; SQLContextNew sqlCtx = null; lock (mthObj) { if (!SQLCache.PeerTheSQL(tk, out sqlCtx)) { sqlCtx = FuncNew.GetConditionedSelectForFuncedField<StationCheck>(tk, "DISTINCT", new string[][] { new string[]{StationCheck.fn_station, StationCheck.fn_station}, new string[]{StationCheck.fn_id, string.Format("(SELECT TOP 1 {0} FROM {1} t1 WHERE t1.{2}={3})", Station.fn_name, ToolsNew.GetTableName(typeof(Station)), Station.fn_station, StationCheck.fn_station)} }, new ConditionCollection<StationCheck>(), StationCheck.fn_station); } } using (SqlDataReader sqlR = _Schema.SqlHelper.ExecuteReader(_Schema.SqlHelper.ConnectionString_GetData, CommandType.Text, sqlCtx.Sentence, sqlCtx.Params)) { if (sqlR != null) { ret = new List<StationInfo>(); while (sqlR.Read()) { var item = new StationInfo(); item.StationId = g.GetValue_Str(sqlR, sqlCtx.Indexes(StationCheck.fn_station)); item.Descr = g.GetValue_Str(sqlR, sqlCtx.Indexes(StationCheck.fn_id)); ret.Add(item); } } } return ret; } catch (Exception) { throw; } }