protected string printJpjz(kabe_flight aft) { string cookieKey = aft.ft + "-" + this.fromcityCode + "-" + this.tocityCode + "-" + this.tripDate; string key = aft.airline + aft.depport + aft.arrport + aft.adultprice + "-" + aft.ticketId; if (Request.Cookies[cookieKey] != null) { string name = Request.Cookies[cookieKey][key]; if (name != null && name.Equals("jpjz")) { return("<img src='images/jwyouxian.gif' />"); } } return(" "); }
private void makeJpjz(ArrayList pageTickets, string tripTypeIntP, int start, int end) { string cookieKey = tripTypeIntP + "-" + this.fromcityCode + "-" + this.tocityCode + "-" + this.tripDate; if (Request.Cookies[cookieKey] == null) { HttpCookie cookie = new HttpCookie(cookieKey); //默认价格排序 Random ra = new Random(); int jpjzNum = ra.Next(start, end); int jpjzContent = 5; if (pageTickets.Count < 6) { jpjzContent = pageTickets.Count; } for (int i = 0, j = 0; i < jpjzNum; i++) { //生成随机数 int jpjzTicket = ra.Next(0, jpjzContent); kabe_flight cacheAFT = (kabe_flight)pageTickets[jpjzTicket]; string ticketKey = cacheAFT.airline + cacheAFT.depport + cacheAFT.arrport + cacheAFT.adultprice + "-" + cacheAFT.ticketId; if (cacheAFT.ft.Equals(tripTypeIntP)) { cookie.Values[ticketKey] = "jpjz"; j++; } if ((jpjzContent + 2) < pageTickets.Count && i == jpjzNum - 1 && j == 0) { jpjzContent = jpjzContent + 2; i = 0; } } cookie.Expires = System.DateTime.Now.AddDays(1);//设置过期时间 1天 Response.Cookies.Add(cookie); } }
protected void Page_Load(object sender, EventArgs e) { string contrast_str = ""; if (Request.Cookies["contrast_str"] == null) { Response.Cookies["contrast_str"].Value = contrast_str; Response.Cookies["contrast_str"].Expires = DateTime.Now.AddDays(1); } else { contrast_str = Request.Cookies["contrast_str"].Value; } if (Request.QueryString["addId"] != null && Request.QueryString["addId"] != "") { string addId = Request.QueryString["addId"].ToString(); if (contrast_str.IndexOf(addId + ",") == -1) { contrast_str = contrast_str + addId + ","; Response.Cookies["contrast_str"].Value = contrast_str; Response.Cookies["contrast_str"].Expires = DateTime.Now.AddDays(1); } } if (Request.QueryString["delId"] != null && Request.QueryString["delId"] != "") { string delId = Request.QueryString["delId"].ToString(); if (contrast_str.IndexOf(delId + ",") > -1) { contrast_str = contrast_str.Replace(delId + ",", ""); Response.Cookies["contrast_str"].Value = contrast_str; Response.Cookies["contrast_str"].Expires = DateTime.Now.AddDays(1); } } contrast_array = contrast_str.Split(",".ToCharArray()); contrast_num = contrast_array.Length - 1; DataRow = new DataRow[contrast_num]; for (int i = 0; i < contrast_num; i++) { string idString = contrast_array[i].ToString(); if (idString.IndexOf("kabe") == -1) { int tid = Convert.ToInt32(contrast_array[i].ToString()); DataRow[i] = GetTicketDetail(tid); } else { kabe_flight flight = null; string[] array = idString.Split('_'); ArrayList tickets = (ArrayList)Session[string.Format("TicketsSessionKey_{0}_{1}_{2}_{3}_{4}", array[1], array[2], array[3], array[4], array[5])]; if (tickets == null || tickets.Count == 0) { Response.Redirect("/index.aspx"); return; } foreach (kabe_flight f in tickets) { if (f.ticketId == array[6]) { flight = f; } } if (flight == null) { Response.Redirect("/index.aspx"); return; } //查询机场信息 string logopic = string.Empty; string airchName = string.Empty; string planNum = string.Empty; string age = string.Empty; string smallPic = string.Empty; string logoPic = string.Empty; string airId = string.Empty; string tairportdescription = string.Empty; string airlineSql = "select chName,planNum,age,aid,airlineCode,description,smallPic,logoPic from FY_Airline where airlineCode='" + flight.airline + "'"; DataSet airlineDS = SqlHelper.ExecuteDataset(SqlHelper.ConnString_select, CommandType.Text, airlineSql); if (airlineDS != null && airlineDS.Tables.Count > 0 && airlineDS.Tables[0].Rows.Count > 0) { airchName = airlineDS.Tables[0].Rows[0]["chName"].ToString(); airId = airlineDS.Tables[0].Rows[0]["aid"].ToString(); smallPic = airlineDS.Tables[0].Rows[0]["smallPic"].ToString(); logoPic = airlineDS.Tables[0].Rows[0]["logoPic"].ToString(); tairportdescription = airlineDS.Tables[0].Rows[0]["description"].ToString(); planNum = airlineDS.Tables[0].Rows[0]["planNum"].ToString(); age = airlineDS.Tables[0].Rows[0]["age"].ToString(); } int days = new Random().Next(-60, -5); string fromCityName = string.Empty, toCityName = string.Empty; //出发 到达 航司 查询转机信息 DataTable dt = new DataTable(); dt.Columns.Add("fromCity"); dt.Columns.Add("toCity"); dt.Columns.Add("fromCityname"); dt.Columns.Add("fromCityCode"); dt.Columns.Add("toCityname"); dt.Columns.Add("toCityCode"); dt.Columns.Add("addtime"); dt.Columns.Add("untaxPrice"); dt.Columns.Add("tripType"); dt.Columns.Add("tId"); dt.Columns.Add("fAirportCode"); dt.Columns.Add("fromPort"); dt.Columns.Add("tAirportName"); dt.Columns.Add("logoPic"); dt.Columns.Add("airname"); dt.Columns.Add("planNum"); dt.Columns.Add("age"); dt.Columns.Add("smallPic"); dt.Columns.Add("bagPrice"); dt.Columns.Add("engerTicket"); dt.Columns.Add("seatShip"); dt.Columns.Add("shortstayDate"); dt.Columns.Add("attPrice"); dt.Columns.Add("longstayDate"); dt.Columns.Add("childPrice"); dt.Columns.Add("fromsaleDate"); dt.Columns.Add("tosaleDate"); dt.Columns.Add("fromtripDate"); dt.Columns.Add("totripDate"); dt.Columns.Add("returnMoney"); dt.Columns.Add("updateProvision"); dt.Columns.Add("limitProvision"); dt.Columns.Add("fAirportName"); dt.Columns.Add("tAirportCode"); dt.Columns.Add("toPort"); dt.Columns.Add("airId"); dt.Columns.Add("score"); dt.Columns.Add("zongping"); dt.Columns.Add("xiai"); dt.Columns.Add("xiaofei"); dt.Columns.Add("manyi"); dt.Columns.Add("fuwu"); dt.Columns.Add("relayPort"); dt.Columns.Add("returnTip"); dt.Columns.Add("tairportdescription"); dt.Columns.Add("startTime"); dt.Columns.Add("arriveTime"); dt.Rows.Add(getFromCityIdByCode(array[2], out fromCityName), getToCityIdByCode(array[3], out toCityName), fromCityName, array[2], toCityName, array[3], "2013-06-08", flight.adultprice, Convert.ToInt32(flight.ft) - 1, "tId", flight.depport, ReadXmlHelper.GetAirPortNameByCode(flight.depport), ReadXmlHelper.GetAirPortNameByCode(flight.arrport), logoPic, airchName, planNum, age, smallPic, string.Empty, //bagPrice "电子客票", //engerTicket this.display_seat(flight.deproute.seat), "30", //shortstayDate string.Empty, //attPrice "180", //afti.longstayDate, flight.childprice, Convert.ToDateTime(flight.deproute.depdate).AddDays(days).ToString("yyyy-MM-dd"), //convertDate(afti.fromsaleDate.Trim()), flight.deproute.depdate, //convertDate(afti.tosaleDate.Trim()), flight.deproute.depdate, //convertDate(afti.fromtripDate.Trim()), flight.deproute.arrdate, //convertDate(afti.totripDate.Trim()), string.Empty, //afti.returnMoney, string.Empty, //afti.updateProvision, "<p>1.此票价为净价,不含任何费用<br /> 2.票价如有更改,恕不另行通知<br /> 3.不可签转,不可更改行程<br /> 4.所有航段必须有确认的订座,不可开OPEN票. <br /> 5.退票手续 :可退票,需缴纳手续费<br /> 6.误机(NOSHOW) :需收取误机费<br /> 7.更改订座 : 允许更改。乘客必须于出发日之前取消原订的航班,否则按照 '误机' 处理<br /> 8.儿童票价 :成人票价的75% <br /> 9.婴儿票价 :使用 IATA 公布成人票价的10%<br /> </p>", //afti.limitProvision, ReadXmlHelper.GetAirPortNameByCode(flight.depport), // afti.fromAirportName, flight.arrport, //afti.toAirportCode, "toPort", airId, "100", //afti.score, "3", //afti.zongping, "2", //afti.xiai, "4", //afti.xiaofei, "4", //afti.manyi, "4", //afti.fuwu, flight.deproute.route, "returnTip", tairportdescription, flight.deproute.depdate + " " + flight.deproute.deptime.Insert(2, ":"), flight.deproute.arrdate + " " + flight.deproute.arrtime.Insert(2, ":")); DataRow[i] = dt.Rows[0]; } } }
protected void GetSearchTicket() { DataSet airlines = this.getAirLineDataSets();//获取航空公司 System.Threading.AutoResetEvent resetEvent = new System.Threading.AutoResetEvent(false); getFei580TicektHandler d1 = new getFei580TicektHandler(getFei580Ticekt); getKABETiceketHandler d2 = new getKABETiceketHandler(getKABETiceket); IAsyncResult iar1 = null, iar2 = null; ArrayList tickets1 = null, tickets2 = null; AsyncCallback back1 = delegate(IAsyncResult iar) { try { tickets1 = d1.EndInvoke(iar1); if (iar2 != null && iar2.IsCompleted) { resetEvent.Set(); } } catch { resetEvent.Set(); } }; AsyncCallback back2 = delegate(IAsyncResult iar) { try { tickets2 = d2.EndInvoke(iar2); if (iar1 != null && iar1.IsCompleted) { resetEvent.Set(); } } catch { resetEvent.Set(); } }; iar1 = d1.BeginInvoke(back1, null); iar2 = d2.BeginInvoke(getAirLineCode(airlines, this.airlineId), back2, null); if (resetEvent.WaitOne(8000, true)) { resetEvent.Close(); } //没数据 显示提示 if ((tickets1 == null || tickets1.Count == 0) && (tickets2 == null || tickets2.Count == 0)) { this.panHaveValue2.Visible = false; this.panNoValue.Visible = true; return; } else { this.panHaveValue2.Visible = true; this.panNoValue.Visible = false; } ArrayList tickets = new ArrayList(); if (string.IsNullOrEmpty(this.orderStr)) { //排序飞瀛机票 foreach (kabe_flight ordertickets in tickets1) { if (tickets.Count == 0) { tickets.Add(ordertickets); } else { bool isEnd = false; for (int i = 0; i < tickets.Count && !isEnd; i++) { kabe_flight aft = (kabe_flight)tickets[i]; if ((i + 1) == tickets.Count && ordertickets.adultprice > aft.adultprice) { tickets.Add(ordertickets); isEnd = true; break; } else if (ordertickets.adultprice <= aft.adultprice) { tickets.Insert(i, ordertickets); isEnd = true; break; } } } } //排序Kabe机票 if (tickets2 != null) { foreach (kabe_flight ordertickets in tickets2) { if (tickets.Count == 0) { tickets.Add(ordertickets); } else { bool isEnd = false; for (int i = 0; i < tickets.Count && !isEnd; i++) { kabe_flight aft = (kabe_flight)tickets[i]; if ((i + 1) == tickets.Count && ordertickets.adultprice > aft.adultprice) { tickets.Add(ordertickets); isEnd = true; break; } else if (ordertickets.adultprice < aft.adultprice) { tickets.Insert(i, ordertickets); isEnd = true; break; } else if (ordertickets.adultprice == aft.adultprice && ordertickets.airline.Equals(aft.airline)) { isEnd = true; break; } } } } } } else if (this.orderStr.Trim() == "airLine") { //航空公司排序 tickets = tickets1; //排序kabe机票 foreach (kabe_flight ordertickets in tickets2) { if (tickets.Count == 0) { tickets.Add(ordertickets); } else { bool isEnd = false; for (int i = 0; i < tickets.Count && !isEnd; i++) { kabe_flight aft = (kabe_flight)tickets[i]; if ((i + 1) == tickets.Count && ordertickets.adultprice > aft.adultprice && ordertickets.airline.Equals(aft.airline)) { tickets.Add(ordertickets); isEnd = true; break; } else if (ordertickets.adultprice < aft.adultprice && ordertickets.airline.Equals(aft.airline)) { tickets.Insert(i, ordertickets); isEnd = true; break; } else if (ordertickets.adultprice == aft.adultprice && ordertickets.airline.Equals(aft.airline)) { tickets.Insert(i, ordertickets); isEnd = true; break; } } if (!isEnd) { tickets.Add(ordertickets); } } } } // if (Session["TicketsSessionKey_Airlines"] == null) { ArrayList airlinesresult = new ArrayList(); foreach (DataRow dr in airlines.Tables[0].Rows) { foreach (kabe_flight ordertickets in tickets) { if (dr["airlinecode"].ToString().Trim().ToLower() == ordertickets.airline.Trim().ToLower()) { kabe_Airline a = new kabe_Airline(); a.airlineId = dr["aId"].ToString(); a.airlineCode = dr["airlinecode"].ToString(); a.airlineName = dr["chName"].ToString(); a.airlinePic = dr["smallPic"].ToString(); airlinesresult.Add(a); break; } } } //写入Session 分页使用 Session["TicketsSessionKey_Airlines"] = airlinesresult; } Session["TicketsSessionKey_KaBaTickets"] = tickets2; Session[string.Format("TicketsSessionKey_{0}_{1}_{2}_{3}_{4}", this.tripType, fromcityCode, this.tocityCode, Convert.ToDateTime(this.tripDate).ToString("yyyyMMdd"), Convert.ToDateTime(this.backDate).ToString("yyyyMMdd"))] = tickets; this.BindData(tickets); }
/// <summary> /// 获取指定航空公司数据并返回给返回参数 /// </summary> /// <param name="tickets"></param> /// <param name="xmlNode"></param> /// <param name="airlineCode"></param> private void getKABEObjects(ref ArrayList tickets, XmlNode xmlNode, string airlineCode) { if (xmlNode.SelectSingleNode("code").InnerText != "0") { return; } //单双程 XmlElement para = xmlNode.SelectSingleNode("para") as XmlElement; string ft = para["ft"].InnerText; XmlElement flights = xmlNode.SelectSingleNode("flights") as XmlElement; foreach (XmlElement flight in flights.ChildNodes) { if (!string.IsNullOrEmpty(airlineCode)) { if (flight["airline"].InnerText.ToLower().Trim() != airlineCode.ToLower().Trim()) { continue; } } kabe_flight item = new kabe_flight(); item.source = "kabe"; item.ft = ft; item.ticketId = System.Guid.NewGuid().ToString(); item.depport = flight["depport"].InnerText; item.arrport = flight["arrport"].InnerText; item.airline = flight["airline"].InnerText; decimal adultprice = decimal.Parse(flight["adultprice"].InnerText); decimal childprice = decimal.Parse(flight["childprice"].InnerText); item.adultprice = adultprice > 1000 ? adultprice - 200 : adultprice; item.childprice = childprice > 1000 ? childprice - 200 : childprice; item.tax = flight["tax"].InnerText; item.currency = flight["currency"].InnerText; item.open = flight["open"].InnerText; kabe_deproute _deproute = new kabe_deproute(); XmlElement deproute = flight["deproute"]; _deproute.route = deproute["route"].InnerText; _deproute.aircode = deproute["aircode"].InnerText; _deproute.depdate = deproute["depdate"].InnerText; _deproute.arrdate = deproute["arrdate"].InnerText; _deproute.deptime = deproute["deptime"].InnerText; _deproute.arrtime = deproute["arrtime"].InnerText; _deproute.transfer = deproute["transfer"].InnerText; _deproute.seat = deproute["seat"].InnerText; item.deproute = _deproute; kabe_deproute _arrroute = new kabe_deproute(); XmlElement arrroute = flight["arrroute"]; _arrroute.route = arrroute["route"].InnerText; _arrroute.aircode = arrroute["aircode"].InnerText; _arrroute.depdate = arrroute["depdate"].InnerText; _arrroute.arrdate = arrroute["arrdate"].InnerText; _arrroute.deptime = arrroute["deptime"].InnerText; _arrroute.arrtime = arrroute["arrtime"].InnerText; _arrroute.transfer = arrroute["transfer"].InnerText; _arrroute.seat = arrroute["seat"].InnerText; item.arrroute = _arrroute; ArrayList segment = new ArrayList(); XmlElement flightdatas = flight["flightdatas"]; foreach (XmlElement s in flightdatas.ChildNodes) { kabe_segment _s = new kabe_segment(); _s.dep = s["dep"].InnerText; _s.arr = s["arr"].InnerText; _s.air = s["air"].InnerText; _s.flightno = s["flightno"].InnerText; _s.depairport = s["depairport"].InnerText; _s.arrairport = s["arrairport"].InnerText; _s.depdate = s["depdate"].InnerText; _s.arrdate = s["arrdate"].InnerText; _s.deptime = s["deptime"].InnerText; _s.arrtime = s["arrtime"].InnerText; _s.flytime = s["flytime"].InnerText; _s.plane = s["plane"].InnerText; _s.seat = s["seat"].InnerText; _s.stop = s["stop"].InnerText; _s.datas = s["datas"].InnerText; segment.Add(_s); } item.segment = segment; tickets.Add(item); } }
/// <summary> /// 获取Fei580票价 /// </summary> /// <returns></returns> protected ArrayList getFei580Ticekt() { StringBuilder str = new StringBuilder(); str.Append("select top 100 percent"); str.Append(" FY_Ticket.tid,FY_Ticket.untaxPrice,FY_Ticket.relayPort,FY_Ticket.tripType,"); str.Append(" FY_FromCity.cityCode as fromCityCode,"); str.Append(" FY_ToCity.cityCode as toCityCode,"); str.Append(" FY_Tax.tax,"); str.Append(" FY_FromCity.chName as fromCityname,FY_FromCity.fId,FY_Airline.aId,FY_ToCity.tId as toId,"); str.Append(" FY_ToCity.chName as toCityname,FY_Airline.airlineCode as airlineCode,FY_Airline.chName as airname, FY_Airline.smallPic as smallPic from FY_Ticket "); str.Append(" left join FY_FromCity on FY_FromCity.fId=FY_Ticket.fromCity"); str.Append(" left join FY_ToCity on FY_ToCity.tId=FY_Ticket.toCity"); str.Append(" left join FY_Airline on FY_Airline.aId=FY_Ticket.airLine"); str.Append(" left join FY_Tax on (FY_Ticket.tripType =FY_Tax.taxType and FY_Ticket.airLine = FY_Tax.airline and FY_Ticket.toCity = FY_Tax.toCity and FY_Ticket.fromCity = FY_Tax.fromCity)"); str.Append(" where 1=1 "); if (this.tripType != 2) { str.Append(" and (FY_Ticket.tripType=" + this.tripType + ")"); } if (this.fromcity != 0) { str.Append(" and (FY_FromCity.fId=" + this.fromcity + ")"); } if (!string.IsNullOrEmpty(this.tocityName1)) { str.Append(" and (FY_ToCity.chName like '%" + tocityName1 + "%')"); } if (!string.IsNullOrEmpty(this.tripDate)) { str.Append(" and (FY_Ticket.fromtripDate<='" + tripDate + "' and FY_Ticket.totripDate>='" + tripDate + "' )"); } if (!string.IsNullOrEmpty(this.tripDate) && !string.IsNullOrEmpty(this.backDate) && this.tripType != 0) { int day = (Convert.ToDateTime(backDate) - Convert.ToDateTime(tripDate)).Days; str.Append(" and DateDiff(d,FY_Ticket.fromtripDate,FY_Ticket.totripDate) >= " + day); } str.Append(" and (FY_Ticket.tosaleDate>='" + DateTime.Now.ToString("yyyy-MM-dd") + "')"); if (!string.IsNullOrEmpty(this.airlineId)) { str.Append(" and (FY_Airline.aId=" + airlineId + ")"); } if (string.IsNullOrEmpty(this.orderStr)) { str.Append(" order by FY_Ticket.untaxPrice asc ,FY_Ticket.tId desc"); } else { str.Append(" order by FY_Ticket." + this.orderStr + " asc ,FY_Ticket.tId desc"); } DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.ConnString_select, CommandType.Text, str.ToString()); DataTable dt = ds.Tables[0]; ArrayList result = new ArrayList(); foreach (DataRow dr in dt.Rows) { kabe_flight item = new kabe_flight(); item.source = "feiying"; item.ft = (Convert.ToInt32(dr["tripType"]) + 1).ToString(); item.ticketId = dr["tid"].ToString().Trim(); item.depport = dr["fromCityCode"].ToString(); item.arrport = dr["toCityCode"].ToString(); item.airline = dr["airlineCode"].ToString(); item.adultprice = decimal.Parse(dr["untaxPrice"].ToString()); item.childprice = 0.00M; item.relayPort = dr["relayPort"].ToString(); //item.tax = flight["tax"].InnerText; item.currency = "CNY"; item.open = "0"; //kabe_deproute _deproute = new kabe_deproute(); //XmlElement deproute = flight["deproute"]; //_deproute.route = deproute["route"].InnerText; //_deproute.aircode = deproute["aircode"].InnerText; //_deproute.depdate = deproute["depdate"].InnerText; //_deproute.arrdate = deproute["arrdate"].InnerText; //_deproute.deptime = deproute["deptime"].InnerText; //_deproute.arrtime = deproute["arrtime"].InnerText; //_deproute.transfer = deproute["transfer"].InnerText; //_deproute.seat = deproute["seat"].InnerText; //item.deproute = _deproute; //kabe_deproute _arrroute = new kabe_deproute(); //XmlElement arrroute = flight["arrroute"]; //_arrroute.route = arrroute["route"].InnerText; //_arrroute.aircode = arrroute["aircode"].InnerText; //_arrroute.depdate = arrroute["depdate"].InnerText; //_arrroute.arrdate = arrroute["arrdate"].InnerText; //_arrroute.deptime = arrroute["deptime"].InnerText; //_arrroute.arrtime = arrroute["arrtime"].InnerText; //_arrroute.transfer = arrroute["transfer"].InnerText; //_arrroute.seat = arrroute["seat"].InnerText; //item.arrroute = _arrroute; result.Add(item); } return(result); }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["tId"] != null) { string tId = Request.QueryString["tId"]; if (tId.IndexOf("kabe") == -1) { id = Convert.ToInt32(Request.QueryString["tId"].ToString()); ticketOne = GetTicketDetail(id); } else { string[] array = tId.Split('_'); ArrayList tickets = (ArrayList)Session[string.Format("TicketsSessionKey_{0}_{1}_{2}_{3}_{4}", array[1], array[2], array[3], array[4], array[5])]; if (tickets == null || tickets.Count == 0) { //scripthelp.AlertAndRedirect("记录超时,请重新查询票价信息!", "/index.aspx", this); Response.Redirect("/index.aspx"); return; } foreach (kabe_flight f in tickets) { if (f.ticketId == array[6]) { flight = f; } } if (flight == null) { //scripthelp.AlertAndRedirect("获取票价信息时报,请重新查询票价信息!", "/index.aspx", this); Response.Redirect("/index.aspx"); return; } //出发 到达 航司 查询转机信息 DataTable dt = new DataTable(); dt.Columns.Add("fromCity"); dt.Columns.Add("toCity"); dt.Columns.Add("fromCityname"); dt.Columns.Add("fromCityCode"); dt.Columns.Add("toCityname"); dt.Columns.Add("toCityCode"); dt.Columns.Add("addtime"); dt.Columns.Add("untaxPrice"); dt.Columns.Add("tripType"); dt.Columns.Add("tId"); dt.Columns.Add("fAirportCode"); dt.Columns.Add("fromPort"); dt.Columns.Add("tAirportName"); dt.Columns.Add("logoPic"); dt.Columns.Add("airname"); dt.Columns.Add("planNum"); dt.Columns.Add("age"); dt.Columns.Add("smallPic"); dt.Columns.Add("bagPrice"); dt.Columns.Add("engerTicket"); dt.Columns.Add("seatShip"); dt.Columns.Add("shortstayDate"); dt.Columns.Add("attPrice"); dt.Columns.Add("longstayDate"); dt.Columns.Add("childPrice"); dt.Columns.Add("fromsaleDate"); dt.Columns.Add("tosaleDate"); dt.Columns.Add("fromtripDate"); dt.Columns.Add("totripDate"); dt.Columns.Add("returnMoney"); dt.Columns.Add("updateProvision"); dt.Columns.Add("limitProvision"); dt.Columns.Add("fAirportName"); dt.Columns.Add("tAirportCode"); dt.Columns.Add("toPort"); dt.Columns.Add("airId"); dt.Columns.Add("score"); dt.Columns.Add("zongping"); dt.Columns.Add("xiai"); dt.Columns.Add("xiaofei"); dt.Columns.Add("manyi"); dt.Columns.Add("fuwu"); dt.Columns.Add("relayPort"); dt.Columns.Add("returnTip"); dt.Columns.Add("tairportdescription"); dt.Columns.Add("startTime"); dt.Columns.Add("arriveTime"); this.pan_aifeitime.Visible = true; //查询机场信息 string logopic = string.Empty; string airchName = string.Empty; string planNum = string.Empty; string age = string.Empty; string smallPic = string.Empty; string logoPic = string.Empty; string airId = string.Empty; string tairportdescription = string.Empty; string airlineSql = "select chName,planNum,age,aid,airlineCode,description,smallPic,logoPic from FY_Airline where airlineCode='" + flight.airline + "'"; DataSet airlineDS = SqlHelper.ExecuteDataset(SqlHelper.ConnString_select, CommandType.Text, airlineSql); if (airlineDS != null && airlineDS.Tables.Count > 0 && airlineDS.Tables[0].Rows.Count > 0) { airchName = airlineDS.Tables[0].Rows[0]["chName"].ToString(); airId = airlineDS.Tables[0].Rows[0]["aid"].ToString(); smallPic = airlineDS.Tables[0].Rows[0]["smallPic"].ToString(); logoPic = airlineDS.Tables[0].Rows[0]["logoPic"].ToString(); tairportdescription = airlineDS.Tables[0].Rows[0]["description"].ToString(); planNum = airlineDS.Tables[0].Rows[0]["planNum"].ToString(); age = airlineDS.Tables[0].Rows[0]["age"].ToString(); } int days = new Random().Next(-60, -5); this.flight_fplan = this.display_plan(flight.segment, flight.deproute.route); if (flight.ft == "2") { this.flight_tplan = this.display_plan(flight.segment, flight.arrroute.route); } dt.Rows.Add(getFromCityIdByCode(array[2]), getToCityIdByCode(array[3]), this.fromCityName, array[2], this.toCityName, array[3], "2013-06-08", flight.adultprice, Convert.ToInt32(flight.ft) - 1, tId, flight.depport, ReadXmlHelper.GetAirPortIDByCode(flight.depport), ReadXmlHelper.GetAirPortNameByCode(flight.arrport), logoPic, airchName, planNum, age, smallPic, string.Empty, //bagPrice "电子客票", //engerTicket this.display_seat(flight.deproute.seat), "30", //shortstayDate string.Empty, //attPrice "180", //afti.longstayDate, flight.childprice, Convert.ToDateTime(flight.deproute.depdate).AddDays(days).ToString("yyyy-MM-dd"), //convertDate(afti.fromsaleDate.Trim()), flight.deproute.depdate, //convertDate(afti.tosaleDate.Trim()), flight.deproute.depdate, //convertDate(afti.fromtripDate.Trim()), flight.deproute.arrdate, //convertDate(afti.totripDate.Trim()), string.Empty, //afti.returnMoney, string.Empty, //afti.updateProvision, "<p>1.此票价为净价,不含任何费用<br /> 2.票价如有更改,恕不另行通知<br /> 3.不可签转,不可更改行程<br /> 4.所有航段必须有确认的订座,不可开OPEN票. <br /> 5.退票手续 :可退票,需缴纳手续费<br /> 6.误机(NOSHOW) :需收取误机费<br /> 7.更改订座 : 允许更改。乘客必须于出发日之前取消原订的航班,否则按照 '误机' 处理<br /> 8.儿童票价 :成人票价的75% <br /> 9.婴儿票价 :使用 IATA 公布成人票价的10%<br /> </p>", //afti.limitProvision, ReadXmlHelper.GetAirPortNameByCode(flight.depport), // afti.fromAirportName, flight.arrport, //afti.toAirportCode, ReadXmlHelper.GetAirPortIDByCode(flight.arrport), airId, "100", //afti.score, "3", //afti.zongping, "2", //afti.xiai, "4", //afti.xiaofei, "4", //afti.manyi, "4", //afti.fuwu, flight.deproute.route, "returnTip", tairportdescription, flight.deproute.depdate + " " + flight.deproute.deptime.Insert(2, ":"), flight.deproute.arrdate + " " + flight.deproute.arrtime.Insert(2, ":")); //fromCityname,toCityname,toCityCode,toCityname,addtime, //untaxPrice,tripType,tId,fAirportCode,fromCityCode,fromPort, //tAirportName,logoPic,airname,planNum,age //smallPic,bagPrice,engerTicket,seatShip,shortstayDate,attPrice //longstayDate,childPrice,fromsaleDate,tosaleDate, //fromtripDate,totripDate,returnMoney,updateProvision ticketOne = dt.Rows[0]; } int fCityId = Convert.ToInt32(ticketOne["fromCity"].ToString()); int tCityId = Convert.ToInt32(ticketOne["toCity"].ToString()); ticket_7 = GetTicketDetailBydelay(7, fCityId, tCityId, 6); ticket_14 = GetTicketDetailBydelay(14, fCityId, tCityId, 6); ticket_30 = GetTicketDetailBydelay(30, fCityId, tCityId, 6); ticket_60 = GetTicketDetailBydelay(60, fCityId, tCityId, 6); ticket_90 = GetTicketDetailBydelay(90, fCityId, tCityId, 6); ticket_120 = GetTicketDetailBydelay(120, fCityId, tCityId, 6); ticket_180 = GetTicketDetailBydelay(180, fCityId, tCityId, 6); ticket_365 = GetTicketDetailBydelay(365, fCityId, tCityId, 6); ticket_all = GetTicketDetailBydelay(0, fCityId, tCityId, 5); tmax = tmax > ticket_7.Count ? tmax : ticket_7.Count; tmax = tmax > ticket_14.Count ? tmax : ticket_14.Count; tmax = tmax > ticket_30.Count ? tmax : ticket_30.Count; tmax = tmax > ticket_60.Count ? tmax : ticket_60.Count; tmax = tmax > ticket_90.Count ? tmax : ticket_90.Count; tmax = tmax > ticket_120.Count ? tmax : ticket_120.Count; tmax = tmax > ticket_180.Count ? tmax : ticket_180.Count; tmax = tmax > ticket_365.Count ? tmax : ticket_365.Count; hotNews = getNewsRandom(id); randowTicketF = GetRandowTicketF(14, fCityId, tCityId, 10); randowTicketT = GetRandowTicketT(14, fCityId, tCityId, 10); randowNews = getQuanByType(ticketOne["toCityname"].ToString()); } else { Response.Redirect("international.aspx"); } }