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