/// <summary>
/// 获取指定大小的一页分相信息表集合
/// </summary>
/// <param name="pageIndex">当前页码</param>
/// <param name="pageSize">分页大小</param>
/// <param name="rowsCount">总记录条数</param>
/// <returns>分页数据</returns>
public ObservableCollection<PhaseSplittingInfo> SelectAllCollection(int pageIndex, int pageSize, int rowsCount)
{
ObservableCollection<PhaseSplittingInfo> datas = new ObservableCollection<PhaseSplittingInfo>();
GenDataReader reader = Session.ExcecuteReader(_dal.SelectAllSqlStatement(), pageIndex, pageSize, rowsCount);
while (reader.Read())
{
PhaseSplittingInfo dao = new PhaseSplittingInfo();
_dal.DataReaderToEntity(reader, dao);
datas.Add(dao);
}
reader.Close();
return datas;
}
/// <summary>
/// 获取指定大小的一页站内轨道区段与道岔映射表集合
/// </summary>
/// <param name="pageIndex">当前页码</param>
/// <param name="pageSize">分页大小</param>
/// <param name="rowsCount">总记录条数</param>
/// <returns>分页数据</returns>
public ObservableCollection <StationSectionMapping> SelectAllCollection(int pageIndex, int pageSize, int rowsCount)
{
ObservableCollection <StationSectionMapping> datas = new ObservableCollection <StationSectionMapping>();
GenDataReader reader = Session.ExcecuteReader(_dal.SelectAllSqlStatement(), pageIndex, pageSize, rowsCount);
while (reader.Read())
{
StationSectionMapping dao = new StationSectionMapping();
_dal.DataReaderToEntity(reader, dao);
datas.Add(dao);
}
reader.Close();
return(datas);
}
/// <summary>
/// 获取所有的坐标系信息表集合
/// </summary>
/// <returns>所有信息</returns>
public ObservableCollection <CoordinateInfo> SelectAllCollection()
{
ObservableCollection <CoordinateInfo> datas = new ObservableCollection <CoordinateInfo>();
SqlStatement stmt = _session.CreateSqlStatement();
stmt.AppendString("select * from CoordinateInfo");
stmt.StatementType = SqlStatementType.Select;
GenDataReader reader = _session.ExcecuteReader(stmt);
while (reader.Read())
{
CoordinateInfo dao = new CoordinateInfo();
DataReaderToEntity(reader, dao);
datas.Add(dao);
}
reader.Close();
return(datas);
}
/// <summary>
/// 获取所有的应答器位置集合
/// </summary>
/// <returns>所有信息</returns>
public ObservableCollection <TransponderLocation> SelectAllCollection()
{
ObservableCollection <TransponderLocation> datas = new ObservableCollection <TransponderLocation>();
SqlStatement stmt = _session.CreateSqlStatement();
stmt.AppendString("select * from TransponderLocation");
stmt.StatementType = SqlStatementType.Select;
GenDataReader reader = _session.ExcecuteReader(stmt);
while (reader.Read())
{
TransponderLocation dao = new TransponderLocation();
DataReaderToEntity(reader, dao);
datas.Add(dao);
}
reader.Close();
return(datas);
}