public List <PbProject.Model.Tb_Ticket_Policy> GetPolicy(bool ChangePnr) { string errMsg = ""; List <PbProject.Model.Tb_Ticket_Policy> mPolicyList = new List <Tb_Ticket_Policy>(); try { List <PbProject.Model.Tb_Ticket_SkyWay> SkyList = new PbProject.Logic.Order.Tb_Ticket_SkyWayBLL().GetSkyWayListBySQLWhere("OrderId='" + _order.OrderId + "'"); //if (_QXValue.Contains("") && SkyList.Count == 1) //{ FormatPNR ss = new FormatPNR(); string StartDate = SkyList[0].FromDate.ToShortDateString(); string SecondDate = SkyList[0].FromDate.ToShortDateString(); string RTContent = ss.RemoveHideChar(SkyList[0].NewPnrContent).Replace("\t", "").Replace("\n", ""); string PATContent = ss.RemoveHideChar(SkyList[0].Pat).Replace("\r", "").Replace("\t", "").Replace("\n", ""); bool IsOnePrice = false; if (!SkyList[0].Space.Contains("1")) { RTContent = ss.RemoveChildSeat(RTContent, out IsOnePrice); } DataSet ds8000Y = _8000yiService.SPbyPNRNote(_8000yiAccout, _8000yiPassword, _order.PNR, 0, RTContent); if (ds8000Y.Tables.Count > 0) { if (ds8000Y.Tables[0].Rows.Count > 0) { try { // 对方接口报错 errMsg = ds8000Y.Tables[0].Rows[0]["errInfo"].ToString(); } catch { // 返回正常 mPolicyList = Merger8000YDT(ds8000Y.Tables[0].Select("A10<='" + StartDate + " 00:00:00' and A11>='" + SecondDate + " 00:00:00'"), _mTopcom, ChangePnr); //Update8000YInterFcae(ds8000Y); } } } //} } catch (Exception ex) { //errorData51book = "1"; //OnError("整体线程异常," + ex.ToString(), "PiaoBao.BLLLogic.Policy.InterFacePol.Get8000YPol"); } if (errMsg != "") { //errorData51book = "1"; } return(mPolicyList); }
public void OnCreateOrder() { //if (_QXValue.Contains("|62|"))//控制是否自动生成订单 //{ List <PbProject.Model.Tb_Ticket_SkyWay> skyList = new PbProject.Logic.Order.Tb_Ticket_SkyWayBLL().GetSkyWayListBySQLWhere("OrderId='" + _order.OrderId + "'"); string RTContent = skyList[0].NewPnrContent.Replace("\r", "").Replace("\t", "").Replace("\n", ""); string PATContent = skyList[0].Pat.Replace("\r", "").Replace("\t", "").Replace("\n", ""); RTContent = (new PnrAnalysis.FormatPNR()).SplitPnrAutoLine(new PnrAnalysis.FormatPNR().RemoveHideChar(RTContent)); DataSet dsReson; if (_order.TravelType == 1) { dsReson = _8000yiService.CreatOrderNewByPNRNote(_8000yiAccout, _8000yiPassword, _order.PNR, _order.PolicyId, RTContent); string mes8000yiCreate = "table's count:" + dsReson.Tables.Count + "&"; for (int i = 0; i < dsReson.Tables[0].Rows.Count; i++) { for (int j = 0; j < dsReson.Tables[0].Columns.Count; j++) { mes8000yiCreate = mes8000yiCreate + dsReson.Tables[0].Columns[i].ColumnName + ":" + dsReson.Tables[0].Rows[i][j].ToString() + "/";//DataTable转化成String类型 } } mes8000yiCreate = "table's name:" + dsReson.Tables[0].TableName + "/table's content:" + mes8000yiCreate; CreateLog(_order.OrderId, "预定", mes8000yiCreate, 1); if (dsReson != null) { try { string orderid = dsReson.Tables[0].Rows[0]["OrderID"].ToString(); //OnErrorNew(1, "8000Y生成订单成功", "8000Y生成订单"); CreateLog(_order.OrderId, "预定", "8000Y生成订单成功", 3); _order.OutOrderId = dsReson.Tables[0].Rows[0]["OrderID"].ToString(); if (dsReson.Tables[0].Rows[0]["CWZongJia"].ToString() == "") { dsReson.Tables[0].Rows[0]["CWZongJia"] = "0"; } OnPay(Convert.ToDecimal(dsReson.Tables[0].Rows[0]["CWZongJia"].ToString()), dsReson.Tables[0].Rows[0]["OrderID"].ToString(), mes8000yiCreate); } catch (Exception) { CreateLog(_order.OrderId, "预定", "8000Y生成订单失败:" + dsReson.Tables[0].Rows[0]["ErrInfo"].ToString(), 3); } } } else { CreateLog(_order.OrderId, "预定", "8000yi只支持单程票", 3); } //} }
public void OnCreateOrder() { //if (_QXValue.Contains("|62|"))//控制是否自动生成订单 //{ List <PbProject.Model.Tb_Ticket_SkyWay> skyList = new PbProject.Logic.Order.Tb_Ticket_SkyWayBLL().GetSkyWayListBySQLWhere("OrderId='" + _order.OrderId + "'"); string RTContent = skyList[0].NewPnrContent.Replace("\r", "").Replace("\t", "").Replace("\n", ""); PnrAnalysis.FormatPNR ss = new PnrAnalysis.FormatPNR(); string PATContent = ss.RemoveHideChar(skyList[0].Pat).Replace("\r", "").Replace("\t", "").Replace("\n", ""); //string RTContent = RepalaceChar(skyList[0].Pat); //OnErrorNew(1, "51book开始生成订单", "51book生成订单"); DataSet dsReson = _51bookSerive.bookCreatePolicyOrderByPNR(_51bookAccout, _order.PNR, _order.PolicyId, _51bookUrl, _51bookUrl, _mUser.UserName, _51bookAg, RTContent, PATContent); string mes51bookCreate = "table's count:" + dsReson.Tables.Count + "&"; for (int i = 0; i < dsReson.Tables[0].Rows.Count; i++) { for (int j = 0; j < dsReson.Tables[0].Columns.Count; j++) { mes51bookCreate = mes51bookCreate + dsReson.Tables[0].Columns[i].ColumnName + ":" + dsReson.Tables[0].Rows[i][j].ToString() + "/";//DataTable转化成String类型 } } mes51bookCreate = "table1's name:" + dsReson.Tables[0].TableName + "/table1's content:" + mes51bookCreate; if (dsReson.Tables[0].Columns.Contains("ErorrMessage")) { CreateLog(_order.OrderId, "预定", mes51bookCreate, 1); //OnErrorNew(1, "51book生成订单失败", "51book生成订单"); } else { if (dsReson.Tables[0].Rows[0]["sequenceNo"].ToString() != "") { CreateLog(_order.OrderId, "预定", "51book生成订单成功!", 3); //OnErrorNew(1, "51book生成订单成功", "51book生成订单"); if (dsReson.Tables[0].Rows[0]["settlePrice"].ToString() == "") { dsReson.Tables[0].Rows[0]["settlePrice"] = "0"; } OnPay(Convert.ToDecimal(dsReson.Tables[0].Rows[0]["settlePrice"].ToString()), dsReson.Tables[0].Rows[0]["sequenceNo"].ToString(), mes51bookCreate); } } //OnErrorNew(1, mesPMCreate, "PMdataset"); //} }
public void OnCreateOrder() { //if (_QXValue.Contains("|62|"))//控制是否自动生成订单 //{ List <PbProject.Model.Tb_Ticket_SkyWay> skyList = new PbProject.Logic.Order.Tb_Ticket_SkyWayBLL().GetSkyWayListBySQLWhere("OrderId='" + _order.OrderId + "'"); string RTContent = skyList[0].NewPnrContent.Replace("\r", "").Replace("\t", "").Replace("\n", ""); PnrAnalysis.FormatPNR ss = new PnrAnalysis.FormatPNR(); string PATContent = ss.RemoveHideChar(skyList[0].Pat).Replace("\r", "").Replace("\t", "").Replace("\n", ""); //string RTContent = RepalaceChar(skyList[0].Pat); string PNRinfo = "O|P|" + _order.PNR + "^F^" + _order.BigCode + "|" + skyList[0].FromDate.ToString("yyyy-MM-dd") + "|" + skyList[0].FromCityCode + "|" + skyList[0].FromCityName + "|" + skyList[0].ToCityCode + "|" + skyList[0].ToCityName + "|" + skyList[0].CarryCode + skyList[0].FlightCode + "^N||" + skyList[0].FromDate.ToShortTimeString() + "|" + skyList[0].ToDate.ToShortTimeString() + "|" + skyList[0].Space + "|" + skyList[0].Discount + "||" + _order.PMFee / _order.PassengerName.Split('/').Length + "|" + (skyList[0].ABFee + skyList[0].FuelFee) + "|" + _order.PassengerName.Split('/').Length + "|" + _order.PassengerName.Replace("/", "@"); DataSet dsReson = _todayService.CreateOrderByPNR(_todayAccout2, _order.PNR, _order.JinriGYCode, (_order.PolicyPoint * 100).ToString(), _order.PolicyId, PNRinfo, "0"); string mestodayCreate = "table's count:" + dsReson.Tables.Count + "&"; for (int i = 0; i < dsReson.Tables[0].Rows.Count; i++) { for (int j = 0; j < dsReson.Tables[0].Columns.Count; j++) { mestodayCreate = mestodayCreate + dsReson.Tables[0].Columns[i].ColumnName + ":" + dsReson.Tables[0].Rows[i][j].ToString() + "/";//DataTable转化成String类型 } } mestodayCreate = "table1's name:" + dsReson.Tables[0].TableName + "/table1's content:" + mestodayCreate; if (dsReson != null) { if (dsReson.Tables[0].Rows[0]["OrderNo"].ToString() != "") { CreateLog(_order.OrderId, "预定", "今日生成订单成功", 3); if (dsReson.Tables[0].Rows[0]["PayMoney"].ToString() == "") { dsReson.Tables[0].Rows[0]["PayMoney"] = "0"; } OnPay(Convert.ToDecimal(dsReson.Tables[0].Rows[0]["PayMoney"].ToString()), dsReson.Tables[0].Rows[0]["OrderNo"].ToString(), mestodayCreate); } else { CreateLog(_order.OrderId, "预定", "今日生成订单失败", 3); CreateLog(_order.OrderId, "预定", "今日生成订单失败:" + mestodayCreate, 1); } } //} }
public void OnCreateOrder() { //if (_QXValue.Contains("|62|"))//控制是否自动生成订单 //{ List <PbProject.Model.Tb_Ticket_SkyWay> skyList = new PbProject.Logic.Order.Tb_Ticket_SkyWayBLL().GetSkyWayListBySQLWhere("OrderId='" + _order.OrderId + "'"); PnrAnalysis.FormatPNR ss = new PnrAnalysis.FormatPNR(); string RTContent = skyList[0].NewPnrContent.Replace("\r", "").Replace("\t", "").Replace("\n", ""); string PATContent = ss.RemoveHideChar(skyList[0].Pat).Replace("\r", "").Replace("\t", "").Replace("\n", ""); #region 处理高低开 if (!_order.Space.Contains("1")) //不为子舱位 { string bb = ""; PnrAnalysis.PatModel sss = ss.GetPATInfo(skyList[0].NewPnrContent, out bb); if (sss.ChildPat != null) { for (int i = 0; i < sss.PatList.Count; i++) { if (sss.PatList[i].SeatGroup == sss.ChildPat.SeatGroup) { sss.PatList.Remove(sss.PatList[i]); break; } } PatInfo patFirst = sss.PatList[0]; PatInfo patLast = sss.PatList[sss.PatList.Count - 1]; //if (_QXValue.Contains("|60|")) //{ PATContent = ss.NewPatData(patFirst); //} //else //{ // PATContent = ss.NewPatData(patLast); //} bool IsOnePrice = false; RTContent = ss.RemoveChildSeat(RTContent, out IsOnePrice); } } #endregion //OnErrorNew(1, "517开始生成订单", "517生成订单"); DataSet dsReson; if (_order.PolicyId.Split('~')[1].ToString() != "") //判断有无子政策ID { dsReson = _517Service.CreateOrderByPnrAndPAT(_517Accout, _517Password, _517Ag, RTContent, _order.BigCode, Convert.ToInt32(_order.PolicyId.Split('~')[0].ToString()), _order.LinkMan, _order.LinkManPhone, _order.PolicyId.Split('~')[1].ToString(), PATContent, _order.PNR); } else { dsReson = _517Service.CreateOrderByPnrAndPAT(_517Accout, _517Password, _517Ag, RTContent, _order.BigCode, Convert.ToInt32(_order.PolicyId.Split('~')[0].ToString()), _order.LinkMan, _order.LinkManPhone, "", PATContent, _order.PNR); } string mes517Create = ""; for (int i = 0; i < dsReson.Tables[0].Rows.Count; i++) { for (int j = 0; j < dsReson.Tables[0].Columns.Count; j++) { mes517Create = mes517Create + dsReson.Tables[0].Columns[i].ColumnName + ":" + dsReson.Tables[0].Rows[i][j].ToString() + "/"; //DataTable转化成String类型 } } mes517Create = "table's name:" + dsReson.Tables[0].TableName + "/table's content:" + mes517Create; CreateLog(_order.OrderId, "预定", mes517Create, 1); if (dsReson.Tables[0].TableName == "error") //生成订单失败,记录日志 { CreateLog(_order.OrderId, "预定", mes517Create, 3); //OnErrorNew(1, "517生成订单失败", "517生成订单"); } else { if (dsReson.Tables[0].Rows[0]["OrderId"].ToString() != "") { //OnErrorNew(1, "517生成订单成功", "517生成订单"); CreateLog(_order.OrderId, "预定", "517生成订单成功!", 3); if (dsReson.Tables[0].Rows[0]["TotlePirce"].ToString() == "") { dsReson.Tables[0].Rows[0]["TotlePirce"] = "0"; } OnPay(Convert.ToDecimal(dsReson.Tables[0].Rows[0]["TotlePirce"].ToString()), dsReson.Tables[0].Rows[0]["OrderId"].ToString(), mes517Create); } else { CreateLog(_order.OrderId, "预定", "517生成订单失败:" + mes517Create, 3); } } //} }
public List <PbProject.Model.Tb_Ticket_Policy> GetPolicy(bool ChangePnr) { List <PbProject.Model.Tb_Ticket_Policy> mPolicyList = new List <Tb_Ticket_Policy>(); try { //if (_QXValue.Contains(""))//控台517开关是否打开 //{ List <PbProject.Model.Tb_Ticket_SkyWay> skyList = new PbProject.Logic.Order.Tb_Ticket_SkyWayBLL().GetSkyWayListBySQLWhere("OrderId='" + _order.OrderId + "'"); string StartDate = ""; string SecondDate = ""; StartDate = skyList[0].FromDate.ToShortDateString(); SecondDate = skyList[0].FromDate.ToShortDateString(); PnrAnalysis.FormatPNR ss = new FormatPNR(); string RTContent = ss.RemoveHideChar(skyList[0].NewPnrContent).Replace("\r", "").Replace("\t", "").Replace("\n", ""); string PATContent = ss.RemoveHideChar(skyList[0].Pat).Replace("\r", "").Replace("\t", "").Replace("\n", ""); if (skyList.Count > 1) { SecondDate = skyList[1].FromDate.ToShortDateString(); } //获取517政策 DataSet ds517 = new DataSet(); try { ds517 = _517Service.GetBenefitDataPnrContent(_517Accout, _517Password, _517Ag, RTContent, PATContent, _order.PNR); } catch (Exception e) { } if (ds517.Tables.Count > 0) { try { DataTable NewDt = ds517.Tables[0].Clone(); NewDt.Columns["EffectDate"].DataType = typeof(DateTime); NewDt.Columns["ExpirationDate"].DataType = typeof(DateTime); foreach (DataRow dr in ds517.Tables[0].Rows) { DataRow NewDr = NewDt.NewRow(); for (int i = 0; i < ds517.Tables[0].Columns.Count; i++) { NewDr[i] = dr[i].ToString(); } NewDt.Rows.Add(NewDr); } mPolicyList = Merger517DT(NewDt.Select("EffectDate<='" + StartDate + " 00:00:00' and ExpirationDate>='" + SecondDate + " 23:59:59'"), _mTopcom, ChangePnr); } catch (Exception ex) { //errorData517 = "1"; //OnError(ex.ToString(), "PiaoBao.BLLLogic.Policy.InterFacePol.Get517Pol"); } } } //} catch (Exception ex) { //errorData517 = "1"; //OnError("整体线程异常," + ex.ToString(), "PiaoBao.BLLLogic.Policy.InterFacePol.Get517Pol"); } return(mPolicyList); }
public List <PbProject.Model.Tb_Ticket_Policy> GetPolicy() { List <PbProject.Model.Tb_Ticket_Policy> mPolicyList = new List <Tb_Ticket_Policy>(); try { List <PbProject.Model.Tb_Ticket_SkyWay> SkyList = new PbProject.Logic.Order.Tb_Ticket_SkyWayBLL().GetSkyWayListBySQLWhere(" OrderId='" + _order.OrderId + "'"); //if (_QXValue.Contains("|9|") && SkyList.Count < 2) //{ string StartDate = SkyList[0].FromDate.ToShortDateString(); string SecondDate = SkyList[0].FromDate.ToShortDateString(); List <PbProject.Model.Tb_Ticket_Passenger> passengerList = new PbProject.Logic.Order.Tb_Ticket_PassengerBLL().GetPasListBySQLWhere(" OrderId='" + _order.OrderId + "'"); string PnrInfo = "O|P|" + _order.PNR + "^F^" + _order.BigCode + "|" + SkyList[0].FromDate.ToShortDateString() + "|" + SkyList[0].FromCityCode + "|" + SkyList[0].FromCityName + "|" + SkyList[0].ToCityCode + "|" + SkyList[0].ToCityName + "|" + SkyList[0].CarryCode + SkyList[0].FlightCode + "^N||" + SkyList[0].FromDate.ToShortTimeString() + "|" + SkyList[0].ToDate.ToShortTimeString() + "|" + SkyList[0].Space + "|" + SkyList[0].Discount + "||" + _order.PMFee / _order.PassengerName.Split('/').Length + "|" + (SkyList[0].ABFee + SkyList[0].FuelFee) + "|" + _order.PassengerNumber + "|" + _order.PassengerName.Replace("/", "@"); DataSet dsToday = new DataSet(); string sss = ""; try { sss = _todayService.GetRateListByPNR(_todayAccout, _order.PNR, PnrInfo); StringReader sr = new StringReader(sss); XmlTextReader xtr = new XmlTextReader(sr); dsToday = new DataSet(); dsToday.ReadXml(xtr); } catch (Exception) { //errorDataToday = "1"; //OnError("WebService异常,重新调用", "PiaoBao.BLLLogic.Policy.InterFacePol.GetTodayPol"); //dsToday = wsvcToday.GetRateListByPNR(Company.A63, PnrCode, PnrInfo); sss = _todayService.GetRateListByPNR(_todayAccout, _order.PNR, PnrInfo); StringReader sr = new StringReader(sss); XmlTextReader xtr = new XmlTextReader(sr); dsToday = new DataSet(); dsToday.ReadXml(xtr); } if (dsToday.Tables.Count > 1) { if (dsToday.Tables[1].Rows.Count > 0) { if (dsToday.Tables[1].TableName == "Response") { DateTime dt1; DateTime dt2; if (DateTime.TryParse(StartDate.Replace("/", "-"), out dt1) && DateTime.TryParse(SecondDate.Replace("/", "-"), out dt2) ) { string sqlwhere = "Sdate<='" + dt1.ToString("yyyy-MM-dd") + " 00:00:00' and Edate>='" + dt2.ToString("yyyy-MM-dd") + " 23:59:59'"; // 返回正常 mPolicyList = MergerTodayDT(dsToday.Tables[1].Select(sqlwhere), _mTopcom, SkyList[0].CarryCode, SkyList[0].FromCityCode, SkyList[0].ToCityCode); //UpdateTodayInterFcae(dsToday); } } } } //} } catch (Exception ex) { //errorDataToday = "1"; //OnError("整体线程异常," + ex.ToString(), "PiaoBao.BLLLogic.Policy.InterFacePol.GetTodayPol"); } return(mPolicyList); }
public List <PbProject.Model.Tb_Ticket_Policy> GetPolicy(bool ChangePnr) { List <PbProject.Model.Tb_Ticket_Policy> mPolicyList = new List <Tb_Ticket_Policy>(); try { //if (_QXValue.Contains(""))//控台517开关是否打开 //{ List <PbProject.Model.Tb_Ticket_SkyWay> skyList = new PbProject.Logic.Order.Tb_Ticket_SkyWayBLL().GetSkyWayListBySQLWhere("OrderId='" + _order.OrderId + "'"); string StartDate = ""; string SecondDate = ""; StartDate = skyList[0].FromDate.ToShortDateString(); SecondDate = skyList[0].FromDate.ToShortDateString(); PnrAnalysis.FormatPNR ss = new FormatPNR(); string RTContent = ss.RemoveHideChar(skyList[0].NewPnrContent).Replace("\r", "").Replace("\t", "").Replace("\n", ""); string PATContent = ss.RemoveHideChar(skyList[0].Pat).Replace("\r", "").Replace("\t", "").Replace("\n", ""); if (skyList.Count > 1) { SecondDate = skyList[1].FromDate.ToShortDateString(); } //获取517政策 DataSet dsYeeXing = new DataSet(); try { dsYeeXing = _yeeXingService.ParsePnrMatchAirpContract(_yeeXingAccout, _yeeXingAccout2, _order.PNR, RTContent, PATContent); } catch (Exception e) { } if (dsYeeXing.Tables.Count > 0) { try { DataTable NewDt = dsYeeXing.Tables[5].Clone(); NewDt.Columns.Add("startTime", typeof(DateTime)); NewDt.Columns.Add("endTime", typeof(DateTime)); NewDt.Columns.Add("airComp", typeof(String)); NewDt.Columns.Add("airSeg", typeof(int)); NewDt.Columns.Add("orgCity", typeof(String)); NewDt.Columns.Add("dstCity", typeof(String)); NewDt.Columns.Add("flight", typeof(String)); NewDt.Columns.Add("cabin", typeof(String)); foreach (DataRow dr in dsYeeXing.Tables[5].Rows) { DataRow NewDr = NewDt.NewRow(); for (int i = 0; i < dsYeeXing.Tables[5].Columns.Count; i++) { NewDr[i] = dr[i].ToString(); } NewDr["startTime"] = dsYeeXing.Tables[2].Rows[0]["startTime"]; NewDr["endTime"] = dsYeeXing.Tables[2].Rows[0]["endTime"]; NewDr["airComp"] = dsYeeXing.Tables["lineinfo"].Rows[0]["airComp"]; NewDr["orgCity"] = dsYeeXing.Tables["lineinfo"].Rows[0]["orgCity"]; NewDr["dstCity"] = dsYeeXing.Tables["lineinfo"].Rows[0]["dstCity"]; NewDr["flight"] = ""; NewDr["cabin"] = dsYeeXing.Tables["lineinfo"].Rows[0]["cabin"]; NewDr["airSeg"] = dsYeeXing.Tables["lineinfos"].Rows[0]["airSeg"]; NewDt.Rows.Add(NewDr); } mPolicyList = MergerYeeXingDT(NewDt.Select("1=1"), _mTopcom, ChangePnr); } catch (Exception ex) { //errorData517 = "1"; //OnError(ex.ToString(), "PiaoBao.BLLLogic.Policy.InterFacePol.Get517Pol"); } } } //} catch (Exception ex) { //errorData517 = "1"; //OnError("整体线程异常," + ex.ToString(), "PiaoBao.BLLLogic.Policy.InterFacePol.Get517Pol"); } return(mPolicyList); }
public void OnCreateOrder() { //if (_QXValue.Contains("|62|"))//控制是否自动生成订单 //{ List <PbProject.Model.Tb_Ticket_SkyWay> skyList = new PbProject.Logic.Order.Tb_Ticket_SkyWayBLL().GetSkyWayListBySQLWhere("OrderId='" + _order.OrderId + "'"); PnrAnalysis.FormatPNR ss = new PnrAnalysis.FormatPNR(); string RTContent = skyList[0].NewPnrContent.Replace("\r", "").Replace("\t", "").Replace("\n", ""); string PATContent = ss.RemoveHideChar(skyList[0].Pat).Replace("\r", "").Replace("\t", "").Replace("\n", ""); #region 处理高低开 if (!_order.Space.Contains("1"))//不为子舱位 { string bb = ""; PnrAnalysis.PatModel sss = ss.GetPATInfo(skyList[0].NewPnrContent, out bb); if (sss.ChildPat != null) { for (int i = 0; i < sss.PatList.Count; i++) { if (sss.PatList[i].SeatGroup == sss.ChildPat.SeatGroup) { sss.PatList.Remove(sss.PatList[i]); break; } } PatInfo patFirst = sss.PatList[0]; PatInfo patLast = sss.PatList[sss.PatList.Count - 1]; //if (_QXValue.Contains("|60|")) //{ PATContent = ss.NewPatData(patFirst); //} //else //{ // PATContent = ss.NewPatData(patLast); //} bool IsOnePrice = false; RTContent = ss.RemoveChildSeat(RTContent, out IsOnePrice); } } #endregion //OnErrorNew(1, "517开始生成订单", "517生成订单"); DataSet dsReson; dsReson = _yeeXingService.ParsePnrBookContract(_yeeXingAccout, _yeeXingAccout2, _order.PNR, RTContent, PATContent, _order.PolicyId, _order.PMFee.ToString(), _order.OrderId, _order.PolicyPoint.ToString(), _order.ReturnMoney.ToString()); string mesYeeXingCreate = ""; for (int i = 0; i < dsReson.Tables[0].Rows.Count; i++) { for (int j = 0; j < dsReson.Tables[0].Columns.Count; j++) { mesYeeXingCreate = mesYeeXingCreate + dsReson.Tables[0].Columns[i].ColumnName + ":" + dsReson.Tables[0].Rows[i][j].ToString() + "/";//DataTable转化成String类型 } } mesYeeXingCreate = "table's name:" + dsReson.Tables[0].TableName + "/table's content:" + mesYeeXingCreate; CreateLog(_order.OrderId, "预定", mesYeeXingCreate, 1); if (dsReson.Tables[0].Rows[0]["is_success"].ToString() == "F")//生成订单失败,记录日志 { CreateLog(_order.OrderId, "预定", mesYeeXingCreate, 3); } else { CreateLog(_order.OrderId, "预定", "易行生成订单成功!", 3); if (dsReson.Tables[0].Rows[0]["totalPrice"].ToString() == "") { dsReson.Tables[0].Rows[0]["totalPrice"] = "0"; } OnPay(Convert.ToDecimal(dsReson.Tables[0].Rows[0]["totalPrice"].ToString()), dsReson.Tables[0].Rows[0]["orderid"].ToString(), mesYeeXingCreate); } //} }
public List <PbProject.Model.Tb_Ticket_Policy> GetPolicy(bool ChangePnr) { List <PbProject.Model.Tb_Ticket_Policy> mPolicyList = new List <Tb_Ticket_Policy>(); try { //if (_QXValue.Contains("")) //{ List <PbProject.Model.Tb_Ticket_SkyWay> SkyList = new PbProject.Logic.Order.Tb_Ticket_SkyWayBLL().GetSkyWayListBySQLWhere("OrderId='" + _order.OrderId + "'"); string CompanyCode = _51bookAccout; string CompanySign = _51bookAg; string travel = "OW"; string time = SkyList[0].FromDate.ToShortDateString(); if (SkyList.Count > 1) { travel = "RT"; time = SkyList[1].FromDate.ToShortDateString(); } DataSet ds51 = new DataSet(); PnrAnalysis.FormatPNR ss = new PnrAnalysis.FormatPNR(); string pnrTxt = ss.RemoveHideChar(SkyList[0].NewPnrContent).Replace("\r", "").Replace("\t", "").Replace("\n", ""); string patTxt = ss.RemoveHideChar(SkyList[0].Pat).Replace("\r", "").Replace("\t", "").Replace("\n", ""); //string pnrTxt = RepalaceChar(SkyList[0].Pat); int stau = 0; try { ds51 = _51bookSerive.bookGetPolicyDataByPNR(CompanyCode, _order.PNR, CompanySign, pnrTxt, patTxt); } catch (Exception e) { stau = 1; //OnError(e.ToString(), "PiaoBao.BLLLogic.Policy.InterFacePol.Get51BookPol"); } if (stau == 1) { try { ds51 = _51bookSerive.bookGetPolicyDataByPNR(CompanyCode, _order.PNR, CompanySign, pnrTxt, patTxt); } catch (Exception e) { stau = 1; //OnError(e.ToString(), "PiaoBao.BLLLogic.Policy.InterFacePol.Get51BookPol"); } } if (ds51.Tables.Count > 0) { if (ds51.Tables[0].Rows.Count > 0) { try { string where = "startDate<='" + SkyList[0].FromDate.ToShortDateString() + "' and expiredDate>='" + SkyList[0].ToDate.ToShortDateString() + "' "; where += " and printTicketStartDate<='" + DateTime.Now.ToShortDateString() + "' and printTicketExpiredDate>='" + DateTime.Now.ToShortDateString() + "'"; where += " and routeType = '" + travel + "' and needSwitchPNR='false'"; mPolicyList = Merger51DT(ds51.Tables[0].Select(), travel, SkyList[0].FromDate.ToShortDateString(), time, _mTopcom, ChangePnr); //updateInterFcae(ds51); } catch (Exception ex) { //errorData51book = "1"; //OnError(ex.ToString(), "PiaoBao.BLLLogic.Policy.InterFacePol.Get51BookPol"); } } } //} } catch (Exception ex) { //OnError("整体线程异常," + ex.ToString(), "PiaoBao.BLLLogic.Policy.InterFacePol.Get51BookPol"); } return(mPolicyList); }
public List <PbProject.Model.Tb_Ticket_Policy> GetPolicy(bool ChangePnr) { List <PbProject.Model.Tb_Ticket_Policy> mPolicyList = new List <Tb_Ticket_Policy>(); try { List <PbProject.Model.Tb_Ticket_SkyWay> SkyList = new PbProject.Logic.Order.Tb_Ticket_SkyWayBLL().GetSkyWayListBySQLWhere(" OrderId='" + _order.OrderId + "'"); //if (_QXValue.Contains("")) //{ string StartDate = ""; string SecondDate = ""; string StartFlyNo = ""; string SecondFlyNo = ""; string StartSpace = ""; string SecondSpace = ""; string StartCity = ""; string SecondCity = ""; string ThirdCity = ""; string TravelType = "0"; string uid = _pmAccout; string pwd = _pmAg; StartDate = SkyList[0].FromDate.ToShortDateString(); StartFlyNo = SkyList[0].CarryCode + SkyList[0].FlightCode; StartSpace = SkyList[0].Space; StartCity = SkyList[0].FromCityCode; SecondCity = SkyList[0].ToCityCode; if (SkyList.Count > 1) { TravelType = "1"; SecondDate = SkyList[1].FromDate.ToShortDateString(); SecondFlyNo = SkyList[1].CarryCode + SkyList[1].FlightCode; SecondSpace = SkyList[1].Space; if (SkyList[0].FromCityCode != SkyList[1].ToCityCode) { TravelType = "2"; ThirdCity = SkyList[1].ToCityCode; } } DataSet dsPM = new DataSet(); bool IfTry = true; try { if (TravelType == "0") { dsPM = _pmService.GetPolicyDataByDC(StartDate, StartFlyNo, StartCity, SecondCity, "", StartSpace, uid, pwd); } else { string citytemp = ""; //往返 if (TravelType == "1") { citytemp = StartCity; } //联程 else { citytemp = ThirdCity; } dsPM = _pmService.GetPolicyDataByWFLC(TravelType, StartDate, SecondDate, StartFlyNo, SecondFlyNo, StartCity, SecondCity, SecondCity, citytemp, "", StartSpace, SecondSpace, uid, pwd); } } catch (Exception e) { //errorDataPM = "1"; IfTry = false; //OnError(e.ToString(), "PiaoBao.BLLLogic.Policy.InterFacePol.GetPMPol"); } if (IfTry == false) { try { if (TravelType == "0") { dsPM = _pmService.GetPolicyDataByDC(StartDate, StartFlyNo, StartCity, SecondCity, "", StartSpace, uid, pwd); } else { string citytemp = ""; //往返 if (TravelType == "1") { citytemp = StartCity; } //联程 else { citytemp = ThirdCity; } dsPM = _pmService.GetPolicyDataByWFLC(TravelType, StartDate, SecondDate, StartFlyNo, SecondFlyNo, StartCity, SecondCity, SecondCity, citytemp, "", StartSpace, SecondSpace, uid, pwd); } } catch (Exception e) { //errorDataPM = "1"; IfTry = false; //OnError(e.ToString(), "PiaoBao.BLLLogic.Policy.InterFacePol.GetPMPol"); } } if (dsPM.Tables.Count > 1 && dsPM.Tables[1].Rows.Count > 0) { try { mPolicyList = MergerPMDT(dsPM.Tables[1].Select(), SkyList[0].FromCityCode, SkyList[0].ToCityCode, SkyList[0].CarryCode, SkyList[0].FlightCode + "/" + SkyList[SkyList.Count - 1].FlightCode, _mTopcom, StartDate.Replace("/", "-"), SecondDate.Replace("/", "-"), ChangePnr); //updatePMInterFcae(dsPM); } catch (Exception ex) { //errorDataPM = "1"; //OnError(ex.ToString(), "PiaoBao.BLLLogic.Policy.InterFacePol.GetPMPol"); } } //} } catch (Exception ex) { //OnError("整体线程异常," + ex.ToString(), "PiaoBao.BLLLogic.Policy.InterFacePol.GetPMPol"); } //DataPMOk = true; return(mPolicyList); }
public void OnCreateOrder() { //if (_QXValue.Contains("|62|"))//控制是否自动生成订单 //{ List <PbProject.Model.Tb_Ticket_SkyWay> skyList = new PbProject.Logic.Order.Tb_Ticket_SkyWayBLL().GetSkyWayListBySQLWhere("OrderId='" + _order.OrderId + "'"); string RTContent = skyList[0].NewPnrContent.Replace("\r", "").Replace("\t", "").Replace("\n", ""); PnrAnalysis.FormatPNR ss = new PnrAnalysis.FormatPNR(); string PATContent = ss.RemoveHideChar(skyList[0].Pat).Replace("\r", "").Replace("\t", "").Replace("\n", ""); #region 处理高低开 if (!_order.Space.Contains("1"))//不为子舱位 { string bb = ""; PnrAnalysis.PatModel sss = ss.GetPATInfo(skyList[0].NewPnrContent, out bb); if (sss.ChildPat != null) { for (int i = 0; i < sss.PatList.Count; i++) { if (sss.PatList[i].SeatGroup == sss.ChildPat.SeatGroup) { sss.PatList.Remove(sss.PatList[i]); break; } } PnrAnalysis.PatInfo patFirst = sss.PatList[0]; PnrAnalysis.PatInfo patLast = sss.PatList[sss.PatList.Count - 1]; //if (_QXValue.Contains("|60|"))//低开开关是否打开 //{ PATContent = ss.NewPatData(patFirst); //} //else //{ // PATContent = ss.NewPatData(patLast); //} bool IsOnePrice = false; RTContent = ss.RemoveChildSeat(RTContent, out IsOnePrice); } } #endregion //OnErrorNew(1, "票盟开始生成订单", "票盟生成订单"); DataSet dsReson = _pmService.CreateOrderByPAT(_order.PolicyId, _order.BigCode, HttpUtility.UrlEncode(RTContent), HttpUtility.UrlEncode(PATContent), "0", _pmAccout, _pmAg); string mesPMCreate = "table's count:" + dsReson.Tables.Count + "&"; if (dsReson.Tables.Count <= 1) { for (int i = 0; i < dsReson.Tables[0].Rows.Count; i++) { for (int j = 0; j < dsReson.Tables[0].Columns.Count; j++) { mesPMCreate = mesPMCreate + dsReson.Tables[0].Columns[i].ColumnName + ":" + dsReson.Tables[0].Rows[i][j].ToString() + "/";//DataTable转化成String类型 } } mesPMCreate = "table1's name:" + dsReson.Tables[0].TableName + "/table1's content:" + mesPMCreate; CreateLog(_order.OrderId, "预定", mesPMCreate, 1); //OnErrorNew(1, "票盟生成订单失败", "票盟生成订单"); } else { mesPMCreate = mesPMCreate + "&"; for (int i = 0; i < dsReson.Tables[1].Rows.Count; i++) { for (int j = 0; j < dsReson.Tables[1].Columns.Count; j++) { mesPMCreate = mesPMCreate + dsReson.Tables[1].Columns[i].ColumnName + ":" + dsReson.Tables[1].Rows[i][j].ToString() + "/"; } } mesPMCreate = "table2's name:" + dsReson.Tables[0].TableName + "/table2's content:" + mesPMCreate; if (dsReson.Tables[0].Rows[0]["statuscode"].ToString() == "0") { CreateLog(_order.OrderId, "预定", "票盟生成订单成功!", 3); OnPay(Convert.ToDecimal(dsReson.Tables[1].Rows[0]["payfee"].ToString()), dsReson.Tables[1].Rows[0]["orderid"].ToString(), mesPMCreate); //OnErrorNew(1, "票盟生成订单成功", "票盟生成订单"); } else { //票盟生成订单失败 //OnErrorNew(1, 票盟生成订单失败, "票盟生成订单"); CreateLog(_order.OrderId, "预定", "票盟生成订单失败:" + mesPMCreate, 3); } } //OnErrorNew(1, mesPMCreate, "PMdataset"); //} }