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 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 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"); //} }