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