/////////////////////// #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); }
// 取得交通航段 public static List <TrafficModel> GetTrafficSectors(ProdDetailRQModel req) { List <TrafficModel> sectors = new List <TrafficModel>(); try { // 區段 SECTOR DataSet sec_ds = TrafficDAL.GetTrafficSectors(req.PRODNO, req.SDATE, req.EDATE); var fw_flag = ""; var accum_add_day = 0; var total_psg = req.ADULT + req.CHILD + req.CHILDNB + req.SENIOR; foreach (DataRow dr in sec_ds.Tables[0].Rows) { // 檢查去/回程國定假日 var AddPriceWeeks = string.IsNullOrEmpty(dr.ToStringEx("ADD_PRICE_WEEKS")) ? "0000000" : dr.ToStringEx("ADD_PRICE_WEEKS"); var s_is_holiday = AddPriceWeeks.Substring(Convert.ToInt32(Convert.ToDateTime(req.SDATE).DayOfWeek), 1); // 出發日是否為假日 var e_is_holiday = AddPriceWeeks.Substring(Convert.ToInt32(Convert.ToDateTime(req.EDATE).DayOfWeek), 1); // 回程日是否為假日 s_is_holiday = (s_is_holiday.Equals("1") || NationalHolidayDAL.ChkNationalHoliday(req.SDATE)) ? "1" : "0"; e_is_holiday = (e_is_holiday.Equals("1") || NationalHolidayDAL.ChkNationalHoliday(req.EDATE)) ? "1" : "0"; var IsTripInHoliday = (dr.ToStringEx("FORWARD_FLAG").Equals("1") ? s_is_holiday : e_is_holiday).Equals("1") ? true : false; var dept_date = dr.ToStringEx("FORWARD_FLAG").Equals("1") ? req.SDATE : req.EDATE; // 各段交通累積日數, 當去回程切換數值應該歸零重計 if (fw_flag != dr.ToStringEx("FORWARD_FLAG")) { accum_add_day = 0; fw_flag = dr.ToStringEx("FORWARD_FLAG"); } accum_add_day += dr.ToInt32("ADD_DAY"); try { // 航段使用交通成本 TrafficSectorCostModel SectorCost = GetTrafficCost(req.PRODNO, dr.ToStringEx("DEP_FROM"), dr.ToStringEx("ARR_TO"), Convert.ToDateTime(dept_date), dr.ToInt64("TRAFFIC_XID"), dr.ToInt64("TRAFFIC_COST_XID"), IsTripInHoliday); // 跳過無成本的交通段 if (SectorCost == null) { throw new Exception(string.Format("PROD_NO={0}, FORWARD_FLAG={1}, DATE={2}, TRAFFIC_XID={3}, TRAFFIC_COST_XID={4} 交通成本為 NULL", req.PRODNO, dr.ToStringEx("FORWARD_FLAG"), dept_date, dr.ToInt64("TRAFFIC_XID"), dr.ToInt64("TRAFFIC_COST_XID"))); } // 若承運商為B7, 帶入預設成本與行程代碼 if (dr.ToStringEx("CARRIER_CODE").Equals("B7")) { SectorCost.ADULT_TOURCODE = IsTripInHoliday ? dr.ToStringEx("ADT_TOURCODE_H") : dr.ToStringEx("ADT_TOURCODE"); SectorCost.CHILD_TOURCODE = IsTripInHoliday ? dr.ToStringEx("CHD_TOURCODE_H") : dr.ToStringEx("CHD_TOURCODE"); SectorCost.SENIOR_TOURCODE = IsTripInHoliday ? dr.ToStringEx("SEN_TOURCODE_H") : dr.ToStringEx("SEN_TOURCODE"); SectorCost.ADULT_FAREBASIS = IsTripInHoliday ? dr.ToStringEx("ADT_FAREBASIS_H") : dr.ToStringEx("ADT_FAREBASIS"); SectorCost.CHILD_FAREBASIS = IsTripInHoliday ? dr.ToStringEx("CHD_FAREBASIS_H") : dr.ToStringEx("CHD_FAREBASIS"); SectorCost.SENIOR_FAREBASIS = IsTripInHoliday ? dr.ToStringEx("SEN_FAREBASIS_H") : dr.ToStringEx("SEN_FAREBASIS"); } #region 建構交通航段Model var sec_item = new TrafficSectorModel() { PROD_NO = dr.ToStringEx("PROD_NO"), TRAFFIC_XID = dr.ToStringEx("TRAFFIC_XID"), TRAFFIC_COST_XID = dr.ToStringEx("TRAFFIC_COST_XID"), TRAFFIC_COST_PRICE_XID = dr.ToStringEx("TRAFFIC_COST_PRICE_XID"), TRIP_WAY = dr.ToStringEx("TRIP_WAY"), FORWARD_FLAG = dr.ToStringEx("FORWARD_FLAG"), SECTOR = dr.ToInt32("SEC"), TRAFFIC_TYPE = dr.ToStringEx("TRAFFIC_TYPE"), CARRIER_CODE = dr.ToStringEx("CARRIER_CODE"), DEP_FROM = dr.ToStringEx("DEP_FROM"), ARR_TO = dr.ToStringEx("ARR_TO"), FLY_HL_FLAG = dr.ToStringEx("FLY_HL_FLAG"), SUP_NO = dr.ToStringEx("SUP_NO"), FARE_BASIS = dr.ToStringEx("FARE_BASIS"), ARNK_FLAG = dr.ToStringEx("ARNK_FLAG"), // 票規 RULE_TYPE = dr.ToStringEx("RULE_TYPE"), // 交通成本 TRAFFIC_COST = SectorCost, }; var timetable = QueryCrsTimeTable(dr.ToDateTime("S_DATE"), dr.ToDateTime("E_DATE"), sec_item, total_psg); #endregion 建構交通航段Model var sector = new TrafficModel() { PROD_NO = dr.ToStringEx("PROD_NO"), TRAFFIC_XID = dr.ToStringEx("TRAFFIC_XID"), TRIP_WAY = dr.ToStringEx("TRIP_WAY"), SECTOR = dr.ToStringEx("SEC"), TRAFFIC_TYPE = dr.ToStringEx("TRAFFIC_TYPE"), TRAFFIC_NAME = dr.ToStringEx("CARRIER_CODE_NAME"), SUP_NO = dr.ToStringEx("SUP_NO"), RETURN_FEE = dr.ToStringEx("RETURN_FEE"), RETURN_FEE_PERCENT = Convert.ToDouble(string.IsNullOrEmpty(dr.ToStringEx("RETURN_FEE_PERCENT")) ? "0" : dr.ToStringEx("RETURN_FEE_PERCENT")), // 票規 RULE_TYPE = dr.ToStringEx("RULE_TYPE"), // 交通位控 //TRAFFIC_QTYS = Qty, // 交通時刻表 //TRAFFIC_TIMETBS = timetable }; sectors.Add(sector); } catch (Exception ex2) { Website.Instance.logger.FatalFormat("{0},{1}", ex2.Message, ex2.StackTrace); } } } catch (Exception ex) { //Website.Instance.logger.FatalFormat("{0},{1}", ex.Message, ex.StackTrace); throw ex; } return(sectors); }