Esempio n. 1
0
        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");
            //}
        }
Esempio n. 2
0
        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);
                }
            }
            //}
        }
Esempio n. 3
0
        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);
        }
Esempio n. 4
0
        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");
            //}
        }