///////////////////////
#region 班次時刻表
// 取得航班時刻表
//public static List<TrafficTimeTableModel> GetApkgTimeTable(string prod_no, DateTime s_date, string carrier_code, int total_psg)//, bool IsAEOneWayForce = false)
//{
// List<TrafficTimeTableModel> time_tables = new List<TrafficTimeTableModel>();
// try
// {
// // 列出有關航假航段內容
// var apkg_sectors = sectors.Where(s => s.TRAFFIC_TYPE == "0001" && GetQtyTypeRule(s.CARRIER_CODE) == "CRS").ToList();
// time_tables.AddRange(QueryCrsTimeTable(carrier_code, s_date, apkg_sectors, total_psg));
// // 非航假航段內容
// var other_sectors = sectors.Where(s => !apkg_sectors.Contains(s)).ToList();
// time_tables.AddRange(QueryTimeTable(prod_no, s_date, null, other_sectors));
// }
// catch (Exception ex)
// {
// Website.Instance.logger.FatalFormat("{0},{1}", ex.Message, ex.StackTrace);
// }
// return time_tables;
//}
// 查詢 DPKG CRS, 取得航班時刻
protected static List <TrafficTimeTableModel> QueryCrsTimeTable(DateTime s_date, DateTime e_date, TrafficSectorModel sector, int total_psg) //(string carrier_code, DateTime S_DATE, string cityfrom, string cityto, int total_psg)
{
List <TrafficTimeTableModel> time_tables = new List <TrafficTimeTableModel>();
try
{
var soapClients = Website.Instance.Configuration.GetSection("SoapClient");
var binding = new BasicHttpBinding(BasicHttpSecurityMode.Transport)
{
MaxReceivedMessageSize = Int32.MaxValue
};
var ep = new EndpointAddress(soapClients["WS_DPKG_CRS"]);
WS_DPKG_CRS.CrsServiceSoapClient crs_service = new WS_DPKG_CRS.CrsServiceSoapClient(binding, ep);
Request_GetAv reqGetAv = new Request_GetAv();
reqGetAv.CrsSystem = sector.CARRIER_CODE.Equals("B7") ? CrsSystemOption.B7 : sector.CARRIER_CODE.Equals("AE") ? CrsSystemOption.AE : CrsSystemOption.GE;
if (sector.CARRIER_CODE == "AE")
{
reqGetAv.Rule_Type = sector.RULE_TYPE;
}
List <Segment> dep_seg = new List <Segment>();
dep_seg.Add(new Segment()
{
Airline = sector.CARRIER_CODE,
TripFlag = sector.FORWARD_FLAG,
DepartureDate = e_date.ToString("yyyyMMdd"),
DepartureTime = "0000",
DepartureAirport = sector.DEP_FROM,
ArrivalDate = s_date.ToString("yyyyMMdd"),
ArrivalTime = "2359",
ArrivalAirport = sector.ARR_TO,
BookingSeatCount = total_psg
});
List <Itinerary> _Itinerary = new List <Itinerary>();
_Itinerary.Add(new Itinerary()
{
Segment = dep_seg.ToArray()
});
reqGetAv.Itinerary = _Itinerary.ToArray();
// 詢問CRSGW有效位控
string xmlResp = GetAvTask(crs_service, XMLTool.XMLSerialize(reqGetAv)).Result;
Response_GetAv respGetAv = new Response_GetAv();
respGetAv = (Response_GetAv)XMLTool.XMLDeSerialize(xmlResp, respGetAv.GetType().ToString());
var sel_segs = respGetAv.AvItinerary.Where(s => s.Segments != null && s.Segments.Count() > 0).SelectMany(s => s.Segments);
// 產出 Time Table
foreach (var seg in sel_segs)
{
foreach (var item in seg.Segment)
{
var sec = sector.Where(s => s.DEP_FROM.Equals(item.DepartureAirport) && s.ARR_TO.Equals(item.ArrivalAirport)).FirstOrDefault();
DateTime dept_date = DateTime.ParseExact(item.DepartureDate, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture);
//DateTime arrv_date = DateTime.ParseExact(item.ArrivalDate, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture);
//成本與搭乘限制
DataSet dtl_ds = LimitDAL.GetTrafficCostDtl(sector.TRAFFIC_COST_PRICE_XID, sector.TRAFFIC_XID, sector.TRAFFIC_COST_XID, S_DATE.ToString("yyyyMMdd"));
int nInvalidRules = 0; //未符合規則計數, 0: 通過
//過濾交通限制
if (dtl_ds.Tables[0].Rows.Count != 0)
{
// 檢查是否指定使用 FAIR_BASIS
var sel_fair_basis = dtl_ds.Tables[0].AsEnumerable().Where(r => !string.IsNullOrEmpty(r.Field <string>("FAIR_BASIS"))).Select(b => b.Field <string>("FAIR_BASIS")).Distinct().ToList();
if (sel_fair_basis.Count() > 0)
{
// 比對 FAIR_BASIS
if (sel_fair_basis.Where(f => f.Equals(item.FareBasis, StringComparison.InvariantCultureIgnoreCase)).Count() < 1)
{
nInvalidRules++; // 累計未符合規則
}
}
// 過濾無效航班規則
bool IsValidFlight = FilterTraffic(dr.ToDateTime("S_DATE"), item.DepartureTime.Replace(":", ""), item.FlightNumber, sector, dtl_ds.Tables[0]);
if (!IsValidFlight)
{
nInvalidRules++; // 累計未符合規則
}
}
if (nInvalidRules == 0)
{
//var HL_FLAG = sector.FLY_HL_FLAG.Equals("0") ? false : true;
var HL_FLAG = sector.FLY_HL_FLAG;
// 通過過濾規則放入時刻表
time_tables.Add(new TrafficTimeTableModel()
{
S_DATE = dept_date.ToString(),
FORWARD_FLAG = item.TripFlag,
DEP_FROM_NAME = sector.DEP_FROM_NAME,
DEP_FROM = item.DepartureAirport,
ARR_TO_NAME = sector.ARR_TO_NAME,
ARR_TO = item.ArrivalAirport,
FLY_NO = item.FlightNumber,
DEP_FROM_TIME = item.DepartureTime,
ARR_TO_TIME = item.ArrivalTime,
BOOKING_CLASS = item.BookingClass,
SEAT_COUNT = item.BookingSeatCount.Value,
FARE_BASIS = item.FareBasis,
CAN_HL = HL_FLAG
});
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(time_tables);
}
