public Data_Schema.DepartureShowDataTable DepartureData60() { Data_Schema.DepartureShowDataTable dt = DepartureData(); Data_Schema.DepartureShowRow row; DateTime start = DateTime.Now.AddMinutes(-60); DateTime end = DateTime.Now.AddMinutes(60); for (int i = dt.Rows.Count; i > 0; i--) { row = dt.Rows[i - 1] as Data_Schema.DepartureShowRow; if ((row.TIME_LT < start) || (row.TIME_LT > end)) { dt.Rows.RemoveAt(i - 1); } } return(dt); }
public Data_Schema.DepartureShowDataTable DepartureData() { Data_Schema.DepartureShowDataTable tableToShow = new Data_Schema.DepartureShowDataTable(); Dictionary <long, ShareCodeDeparture> shareCodeDictionary = new Dictionary <long, ShareCodeDeparture>(); Hashtable ht = new Hashtable(); Data_Schema.DepartureWebDataTable sourceTableFromWebAndCache = GetAllDeparture(); if (sourceTableFromWebAndCache == null) { logger.Error(Constants.LoggerMessages.ProxyWebSourceError, Constants.CommonConst.TextDeparture); sourceTableFromWebAndCache = DepartureReadHistoryFromFile(true); } Data_Schema.DepartureShowRow rowShow; foreach (Data_Schema.DepartureWebRow rowSourceTableFromWebAndCache in sourceTableFromWebAndCache.Rows) { switch (rowSourceTableFromWebAndCache.ORDER) { case 1: rowShow = tableToShow.NewDepartureShowRow(); if (shareCodeDictionary.ContainsKey(rowSourceTableFromWebAndCache.FLIGHTID)) { shareCodeDictionary[rowSourceTableFromWebAndCache.FLIGHTID].MASTERROW = rowShow; } else { shareCodeDictionary.Add(rowSourceTableFromWebAndCache.FLIGHTID, new ShareCodeDeparture(rowShow)); } tableToShow.AddDepartureShowRow(CopyLineDeparture(rowSourceTableFromWebAndCache, rowShow)); break; case 0: tableToShow.AddDepartureShowRow(CopyLineDeparture(rowSourceTableFromWebAndCache, tableToShow.NewDepartureShowRow())); break; case 2: if (shareCodeDictionary.ContainsKey(rowSourceTableFromWebAndCache.PARID)) { shareCodeDictionary[rowSourceTableFromWebAndCache.PARID].IATAICAO.Add(rowSourceTableFromWebAndCache.IATAICAO); shareCodeDictionary[rowSourceTableFromWebAndCache.PARID].ICAO_AIR.Add(rowSourceTableFromWebAndCache.ICAO_AIR); shareCodeDictionary[rowSourceTableFromWebAndCache.PARID].FLGTNUM.Add(rowSourceTableFromWebAndCache.FLGTNUM); } else { shareCodeDictionary.Add(rowSourceTableFromWebAndCache.PARID, new ShareCodeDeparture(rowSourceTableFromWebAndCache.IATAICAO, rowSourceTableFromWebAndCache.ICAO_AIR, rowSourceTableFromWebAndCache.FLGTNUM)); } break; default: logger.Warn(Constants.LoggerMessages.ProxyOrderBadValue, Constants.CommonConst.TextDeparture, rowSourceTableFromWebAndCache.PARID); break; } } foreach (ShareCodeDeparture shareCode in shareCodeDictionary.Values) { if (shareCode.MASTERROW != null) { shareCode.MASTERROW.FLGTSHARE = Utils.ConvertListToString(shareCode.FLGTNUM, Constants.CommonConst.SelectorNewLine); shareCode.MASTERROW.ICAO_AIR = Utils.ConvertListToStringICAO(shareCode.MASTERROW.IATAICAO, shareCode.MASTERROW.ICAO_AIR, shareCode.IATAICAO, shareCode.ICAO_AIR, Constants.CommonConst.SelectorDash, Constants.CommonConst.SelectorNewLine); } } tableToShow.AddDepartureShowRow(-1, "", "", "", DateTime.Now, "", "", "", "", "", "", "", "", "", "", "", "", ""); tableToShow.DefaultView.Sort = "TIME_LT"; tableToShow.DefaultView.ApplyDefaultSort = true; return(tableToShow); }