/// <summary> /// 获取供应商控制系统 /// </summary> /// <param name="CpyNo"></param> /// <returns></returns> public string GetGYParameters(string CpyNo) { string result = ""; string sqlWhere = string.Format(" CpyNo=left('{0}',12) ", CpyNo.Trim(new char[] { '\'' })); List <Bd_Base_Parameters> ltParamter = Manage.CallMethod("Bd_Base_Parameters", "GetList", null, new object[] { sqlWhere }) as List <Bd_Base_Parameters>; if (ltParamter != null) { result = BaseParams.getParams(ltParamter).KongZhiXiTong; } return(result); }
public void OnPay(decimal outpayfee, string outorderid, string mesYeeXingCreate) { //if (_QXValue.Contains("31"))//是否自动代付 //{ DataSet dsResonPay; if (outpayfee != _order.OutOrderPayMoney)//如果百拓价格比本地高,则不支付 { CreateLog(_order.OrderId, "预定", "517自动代付失败:平台订单价格和本地价格不符,不进行代付!", 3); return; } _order.OutOrderId = outorderid; _order.OutOrderPayMoney = outpayfee; //if (_QXValue.Contains("54"))//开启517接口预存款支付 //{ //CreateLog(_order.OrderId, "预定", "517进行预存款支付", 1); //OnErrorNew(1, "预存款支付", "517支付订单"); //dsResonPay = _517Service.OrderPay(_517Accout, _517Password, _517Ag, "预存款账号", "预存款密码", _order.OutOrderId, outpayfee, "", _order.PNR); //} //else //{ CreateLog(_order.OrderId, "预定", "517进行支付宝支付", 1); // //OnErrorNew(1, "支付宝支付", "517支付订单"); dsResonPay = _yeeXingService.PayOutContract(_yeeXingAccout, _yeeXingAccout2, _order.OutOrderId, outpayfee.ToString(), "1", "", ""); //} if (dsResonPay != null) { string mesYeeXingPay = ""; for (int i = 0; i < dsResonPay.Tables[0].Rows.Count; i++) { for (int j = 0; j < dsResonPay.Tables[0].Columns.Count; j++) { mesYeeXingPay = mesYeeXingPay + dsResonPay.Tables[0].Columns[i].ColumnName + ":" + dsResonPay.Tables[0].Rows[i][j].ToString() + "/"; } } mesYeeXingCreate = mesYeeXingCreate + "&易行代付:" + mesYeeXingPay; if (dsResonPay.Tables[0].Rows[0]["is_success"].ToString() == "T") { CreateLog(_order.OrderId, "预定", "易行代付成功!", 3); _order.OrderStatusCode = 3; _order.PayStatus = 2; _order.OutOrderPayFlag = true; } else { CreateLog(_order.OrderId, "预定", "易行代付失败:" + dsResonPay.Tables[0].Rows[0]["error"].ToString() + ":" + mesYeeXingPay, 3); } } bool result = (bool)baseDataManage.CallMethod("Tb_Ticket_Order", "Update", null, new Object[] { _order }); //} }
public void OnPay(decimal outpayfee, string outorderid, string mes8000yiCreate) { //if (_QXValue.Contains("31"))//是否自动代付 //{ DataSet dsResonPay; if (outpayfee != _order.OutOrderPayMoney)//如果百拓价格比本地高,则不支付 { CreateLog(_order.OrderId, "预定", "8000yi自动代付失败:平台订单价格和本地价格不符,不进行代付!", 3); } _order.OutOrderId = outorderid; _order.OutOrderPayMoney = outpayfee; dsResonPay = _8000yiService.AutomatismPay(_8000yiAccout, _8000yiPassword, _order.OutOrderId, _8000yiAlipaycode); if (dsResonPay != null) { string mes8000yiPay = ""; for (int i = 0; i < dsResonPay.Tables[0].Rows.Count; i++) { for (int j = 0; j < dsResonPay.Tables[0].Columns.Count; j++) { mes8000yiPay = mes8000yiPay + dsResonPay.Tables[0].Columns[i].ColumnName + ":" + dsResonPay.Tables[0].Rows[i][j].ToString() + "/"; } } mes8000yiCreate = mes8000yiCreate + "&8000yi代付:" + mes8000yiPay; if (dsResonPay != null && dsResonPay.Tables.Count > 0) { try { // 支付失败 dsResonPay.Tables[0].Rows[0]["is_success"].ToString(); CreateLog(_order.OrderId, "预定", "8000Y代付失败:" + mes8000yiPay, 3); } catch { // 支付成功 CreateLog(_order.OrderId, "预定", "8000Y自动支付成功", 3); _order.OrderStatusCode = 3; _order.PayStatus = 2; _order.OutOrderPayFlag = true; } } } bool result = (bool)baseDataManage.CallMethod("Tb_Ticket_Order", "Update", null, new Object[] { _order }); //} }
public Data(string cpyno) { try { this.dataAction = new DataAction(); BaseDataManage baseDataManager = new BaseDataManage(); string No = "000000"; if (cpyno.Length >= 12) { No = cpyno.Substring(0, 12); } List <Bd_Base_Parameters> SupParameters = baseDataManager.CallMethod("Bd_Base_Parameters", "GetList", null, new Object[] { "CpyNo='" + No + "'" }) as List <Bd_Base_Parameters>; if (SupParameters != null) { foreach (Bd_Base_Parameters item in SupParameters) { if (item.SetName == "setCommission") { CommissionType = int.Parse(item.SetValue); break; } } } } catch (Exception e) { } }
/// <summary> /// 通过三字码查询城市 /// </summary> /// <param name="code"></param> /// <returns></returns> private string strReturn(LegStop ls) { string code = ""; try { code = ls.MiddleCityCode; string strim = ls.MiddleTime1; string etrim = ls.MiddleTime2; //Bd_Base_CityService bbc = new Bd_Base_CityService(); //IList<Bd_Base_City> ibbc = bbc.GetBd_Base_City("Code='" + code + "'", 1, 2); BaseDataManage Manage = new BaseDataManage(); string sqlwhere = " 1=1 and CityCodeWord='" + code + "'"; List <Bd_Air_AirPort> objList = Manage.CallMethod("Bd_Air_AirPort", "GetList", null, new object[] { sqlwhere }) as List <Bd_Air_AirPort>; if (objList.Count > 0) { code = objList[0].CityName; if (code != "") { //code = "【经停地点】" + code + "\n【经停时间】" + strim + "--" + etrim; code = code + "\r\n" + strim + "-" + etrim; } } } catch (Exception) { code = ""; } return(code); }
public void OnPay(decimal outpayfee, string outorderid, string mes51bookCreate) { //if (_QXValue.Contains("31"))//是否自动代付 //{ if (outpayfee != _order.OutOrderPayMoney)//如果百拓价格比本地高,则不支付 { CreateLog(_order.OrderId, "预定", "51book自动代付失败:平台订单价格和本地价格不符,不进行代付!", 3); } _order.OutOrderId = outorderid; _order.OutOrderPayMoney = outpayfee; DataSet dsResonPay = _51bookSerive.bookPayPolicyOrderByPNR(_51bookAccout, _order.OutOrderId, "", "", _51bookAg); if (dsResonPay != null) { string mes51bookPay = ""; for (int i = 0; i < dsResonPay.Tables[0].Rows.Count; i++) { for (int j = 0; j < dsResonPay.Tables[0].Columns.Count; j++) { mes51bookPay = mes51bookPay + dsResonPay.Tables[0].Columns[i].ColumnName + ":" + dsResonPay.Tables[0].Rows[i][j].ToString() + "/"; } } mes51bookCreate = mes51bookCreate + "&51book代付:" + mes51bookPay; if (dsResonPay.Tables[0].Columns.Contains("ErorrMessage")) { CreateLog(_order.OrderId, "预定", "51book代付失败:" + mes51bookPay, 3); } if (dsResonPay.Tables[0].Rows[0]["orderStatus"].ToString() == "2") { CreateLog(_order.OrderId, "预定", "51book代付成功!", 3); _order.OrderStatusCode = 3; _order.PayStatus = 2; _order.OutOrderPayFlag = true; } else { CreateLog(_order.OrderId, "预定", "51book代付失败:" + mes51bookPay, 3); } } bool result = (bool)baseDataManage.CallMethod("Tb_Ticket_Order", "Update", null, new Object[] { _order }); //} }
private void repFaresListDataBind() { int TotalCount = 0; IHashObject outParams = new HashObject(); //指定参数类型 第一个参数为out输出类型 //key 为参数索引从1开始 value为引用类型 out ref outParams.Add("1", "out"); List <Bd_Air_Fares> list = Manage.CallMethod("Bd_Air_Fares", "GetBasePager1", outParams, new object[] { TotalCount, AspNetPager1.PageSize, Curr, "*", Con, ViewState["orderBy"].ToString() }) as List <Bd_Air_Fares>; TotalCount = outParams.GetValue <int>("1"); AspNetPager1.RecordCount = TotalCount; AspNetPager1.CurrentPageIndex = Curr; AspNetPager1.CustomInfoHTML = " 页码 : <font color=\"red\" size='2px'>" + Curr + "</font> / " + AspNetPager1.PageCount; repFaresList.DataSource = list; repFaresList.DataBind(); }
public void OnPay(decimal outpayfee, string outorderid, string mestodayCreate) { //if (_QXValue.Contains("31"))//是否自动代付 //{ if (outpayfee != _order.OutOrderPayMoney)//如果百拓价格比本地高,则不支付 { CreateLog(_order.OrderId, "预定", "今日自动代付失败:平台订单价格和本地价格不符,不进行代付!", 3); } _order.OutOrderId = outorderid; _order.OutOrderPayMoney = outpayfee; DataSet dsResonPay = _todayService.AutoPayOrder(_todayAccout2, _order.OutOrderId); string mestodayPay = ""; for (int i = 0; i < dsResonPay.Tables[0].Rows.Count; i++) { for (int j = 0; j < dsResonPay.Tables[0].Columns.Count; j++) { mestodayPay = mestodayPay + dsResonPay.Tables[0].Columns[i].ColumnName + ":" + dsResonPay.Tables[0].Rows[i][j].ToString() + "/"; } } mestodayCreate = mestodayCreate + "&51book代付:" + mestodayPay; if (dsResonPay != null && dsResonPay.Tables.Count > 0) { if (dsResonPay.Tables[0].Rows.Count > 0 && dsResonPay.Tables[0].Rows[0]["Result"].ToString() == "T") { CreateLog(_order.OrderId, "预定", "今日代付成功!", 3); _order.OrderStatusCode = 3; _order.PayStatus = 2; _order.OutOrderPayFlag = true; } else { CreateLog(_order.OrderId, "预定", "今日代付失败:" + mestodayPay, 3); } } bool result = (bool)baseDataManage.CallMethod("Tb_Ticket_Order", "Update", null, new Object[] { _order }); //} }
/// <summary> /// 参数实例 /// </summary> /// <param name="Order"></param> /// <param name="mUser">买家帐号</param> public AllInterface(PbProject.Model.Tb_Ticket_Order Order, PbProject.Model.User_Employees mUser) { _order = Order; _mUser = mUser; _changePnr = Order.AllowChangePNRFlag; string sqlWhere = " UninCode='" + _mUser.CpyNo.Substring(0, 12) + "'"; List <PbProject.Model.User_Company> objList = Manage.CallMethod("User_Company", "GetList", null, new object[] { sqlWhere }) as List <PbProject.Model.User_Company>; if (objList != null && objList.Count > 0) { _mTopcom = objList[0]; } //_mTopcom = objList[0]; sqlWhere = " UninCode='" + _mUser.CpyNo + "'";; objList = Manage.CallMethod("User_Company", "GetList", null, new object[] { sqlWhere }) as List <PbProject.Model.User_Company>; if (objList != null && objList.Count > 0) { _mCom = objList[0]; } _allPolicy = new List <Model.Tb_Ticket_Policy>(); //_mCom = objList[0]; }
/// <summary> /// 是否是特价仓位 /// </summary> /// <param name="userInfo">用户信息</param> /// <param name="space">舱位</param> /// <returns>是否是特价舱位</returns> public bool IsSpecialSpace(UserLoginInfo userInfo, string space, string carryCode) { bool isSpecialSpace; BaseDataManage Manage = new BaseDataManage(); AirQurey airQuery = new AirQurey(userInfo.BaseParametersList, userInfo.User, userInfo.Company); string GCpyNo = userInfo.Company.UninCode.Substring(0, 12);//获取上级供应商或落地运营商的ID string sqlwhere = " 1=1 " + " and CpyNo='" + GCpyNo + "'"; List <Tb_SpecialCabin> objList = Manage.CallMethod("Tb_SpecialCabin", "GetList", null, new object[] { sqlwhere }) as List <Tb_SpecialCabin>; isSpecialSpace = airQuery.juageSpecialType(carryCode, space, objList); return(isSpecialSpace); }
/// <summary> /// 获取本地政策普通 /// </summary> /// <param name="CpyNo"></param> /// <param name="StartCityNameCode"></param> /// <param name="TargetCityNameCode"></param> /// <param name="TravelType"></param> /// <returns></returns> public List <Tb_Ticket_Policy> getLocalPolicy(string CpyNo, string StartCityNameCode, string MiddleCityNameCode, string TargetCityNameCode, string FromDate, string ReturnDate, string TravelType) { bool isBackOrUnite = false;//是否是往返或联成 if (TravelType == "2" || TravelType == "3") { isBackOrUnite = true; } TravelType = changeTravelType(TravelType); string GCpyNo = CpyNo.Substring(0, 12);//获取上级供应商或落地运营商的ID string midsql = " "; string BackOrUnitesqlTime = " "; if (MiddleCityNameCode != "") { midsql = " and (MiddleCityNameCode like '%" + MiddleCityNameCode + "%' or MiddleCityNameCode like '%ALL%' )"; } if (isBackOrUnite) { BackOrUnitesqlTime = " and ( '" + ReturnDate + "' >=FlightStartDate and '" + ReturnDate + "' <=FlightEndDate )" + " and ( '" + ReturnDate + "' >=PrintStartDate and '" + ReturnDate + "' <=PrintEndDate )"; } string sqlwhere = " 1=1 " + " and CpyNo='" + GCpyNo + "'" + " and (StartCityNameCode like '%" + StartCityNameCode + "%' or StartCityNameCode like '%ALL%' )" + midsql + " and (TargetCityNameCode like '%" + TargetCityNameCode + "%' or TargetCityNameCode like '%ALL%') " + " and ( '" + FromDate + "' >=FlightStartDate and '" + FromDate + "' <=FlightEndDate )" + " and ( '" + FromDate + "' >=PrintStartDate and '" + FromDate + "' <=PrintEndDate )" + BackOrUnitesqlTime + " and TravelType in (" + TravelType + ")" + " and A1=0 " + " and AuditType=1 " + " and IsPause=0 "; List <Tb_Ticket_Policy> objList = Manage.CallMethod("Tb_Ticket_Policy", "GetList", null, new object[] { sqlwhere }) as List <Tb_Ticket_Policy>; return(objList); }
/// <summary> /// 获取散冲团政策 /// </summary> /// <param name="airCode">承运人</param> /// <param name="fromCity">出发城市</param> /// <param name="toCity">到达城市</param> /// <param name="flightTime">出发时间</param> /// <returns></returns> public List <Tb_Ticket_UGroupPolicy> getTb_Ticket_UGroupPolicy(string airCode, string fromCity, string toCity, string flightTime) { string sqlwhere = " 1=1 " + " and AirCode like '%" + airCode + "%'" + " and FromCityCode like '%" + fromCity + "%'" + " and ToCityCode like '%" + toCity + "%'" + " and FlightStartDate<='" + flightTime + "'" + " and FlightEndDate>='" + flightTime + "'" + " and PrintStartDate<='" + flightTime + "'" + " and PrintEndDate>='" + flightTime + "'"; List <Tb_Ticket_UGroupPolicy> objList = Manage.CallMethod("Tb_Ticket_UGroupPolicy", "GetList", null, new object[] { sqlwhere }) as List <Tb_Ticket_UGroupPolicy>; return(objList); }
private void button3_Click(object sender, EventArgs e) { PbProject.Model.User_Company mTopcom = new PbProject.Logic.User.User_CompanyBLL().GetCompany("100001000045"); PbProject.Logic.ControlBase.Bd_Base_ParametersBLL Bp = new PbProject.Logic.ControlBase.Bd_Base_ParametersBLL(); List <PbProject.Model.Bd_Base_Parameters> ParList = Bp.GetParametersListByCpyNo(mTopcom.UninCode.ToString()); PbProject.Model.definitionParam.BaseSwitch BS = PbProject.WebCommon.Utility.BaseParams.getParams(ParList); PbProject.Logic.Pay.AliPay tempAlipay = new PbProject.Logic.Pay.AliPay(); string msg = ""; string sqlWhere = " orderid='0130502163134897981'"; BaseDataManage Manage = new BaseDataManage(System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase + "\\Dal.dll"); List <PbProject.Model.Tb_Ticket_Order> orderList = Manage.CallMethod("Tb_Ticket_Order", "GetList", null, new object[] { sqlWhere }) as List <PbProject.Model.Tb_Ticket_Order>; PbProject.Model.Tb_Ticket_Order order = orderList[0]; tempAlipay.QueryPriceByPNR(order, BS, ref msg); }
/// <summary> /// BindDictionary /// </summary> protected void BindDictionary() { string sql = "A1=" + this.Identificationtype + " and ParentName='权限标识管理 (重要标识)' order by ChildID"; List <Bd_Base_Dictionary> objList = Manage.CallMethod("Bd_Base_Dictionary", "GetList", null, new object[] { sql }) as List <Bd_Base_Dictionary>; if (objList != null) { foreach (Bd_Base_Dictionary item in objList) { ListItem LItem = new ListItem(); LItem.Text = item.ChildName; LItem.Value = item.ChildID.ToString(); LItem.Attributes.Add("title", item.ChildDescription); //LItem.Attributes.Add("title", item.ChildDescription); ck_ImportBox.Items.Add(LItem); } } }
/// <summary> /// BindDictionary /// </summary> protected void BindDictionary() { // SessionContent sessionContent = new SessionContent(); // sessionContent = Session[sessionContent.USERLOGIN] as SessionContent; //类型2直接是个人权限,目前需求个人权限不分等级(既所有等级的个人权限都是一样),若后期要分再做修改,YYY 2013_03_24 string sql = "A1=2 and ParentName='权限标识管理 (重要标识)'"; List <Bd_Base_Dictionary> objList = Manage.CallMethod("Bd_Base_Dictionary", "GetList", null, new object[] { sql }) as List <Bd_Base_Dictionary>; if (objList != null) { foreach (Bd_Base_Dictionary item in objList) { ListItem LItem = new ListItem(); LItem.Text = item.ChildName; LItem.Value = item.ChildID.ToString(); LItem.Attributes.Add("title", item.ChildDescription); ck_ImportBox.Items.Add(LItem); } } }
public List <Tb_Ticket_Policy> getInterFacePolicy(string OrderID, User_Employees mUser, bool IsOrGetPolicy) { List <Tb_Ticket_Policy> list = null; try { if (IsOrGetPolicy) { } else { string sqlwhere = " 1=1 " + "and OrderId='" + OrderID + "'"; List <Tb_Ticket_Order> objList = Manage.CallMethod("Tb_Ticket_Order", "GetList", null, new object[] { sqlwhere }) as List <Tb_Ticket_Order>; if (objList != null) { if (objList.Count > 0) { PbProject.Logic.PTInterface.AllInterface allInterface = new PbProject.Logic.PTInterface.AllInterface(objList[0], mUser); list = allInterface.GetPolicyAll(); } } } } catch (Exception) { list = null; } var q = from p in list orderby p.DownPoint * 10000 + p.DownReturnMoney descending select p; list = q.ToList <Tb_Ticket_Policy>(); return(list); }
/// <summary> /// BindDictionary /// </summary> protected void BindDictionary() { string currentuserid = Request["currentuserid"] ?? string.Empty; if (!string.IsNullOrEmpty(currentuserid)) { //if (Session[currentuserid] != null) if (Application[currentuserid] != null) { SessionContent sessionContent = new SessionContent(); //sessionContent = Session[currentuserid] as SessionContent; sessionContent = Application[currentuserid] as SessionContent; string cpyno = sessionContent.COMPANY.UninCode.Substring(0, 12); //首选查询出平台给该运营商开启了那些接口 string sql = " 1=1 and CpyNo='" + cpyno + "' and setName='" + PbProject.Model.definitionParam.paramsName.kongZhiXiTong + "'"; List <Bd_Base_Parameters> objList = Manage.CallMethod("Bd_Base_Parameters", "GetList", null, new object[] { sql }) as List <Bd_Base_Parameters>; StringBuilder childidSt = new StringBuilder("-1"); if (objList != null && objList.Count > 0) { #region 确认平台已经开启那些接口 if (objList[0].SetValue.Contains("|84|"))//517 { childidSt.Append(",84"); } if (objList[0].SetValue.Contains("|89|"))//51book { childidSt.Append(",89"); } if (objList[0].SetValue.Contains("|85|"))//百拓 { childidSt.Append(",85"); } if (objList[0].SetValue.Contains("|88|"))//票盟 { childidSt.Append(",88"); } if (objList[0].SetValue.Contains("|86|"))//8000Y { childidSt.Append(",86"); } if (objList[0].SetValue.Contains("|87|"))//今日 { childidSt.Append(",87"); } if (objList[0].SetValue.Contains("|93|"))//易行 { childidSt.Append(",93"); } if (objList[0].SetValue.Contains("|105|"))//航空公司B2B政策实时获取 { childidSt.Append(",105"); } #endregion } //查询字典表对应的数据 string sql1 = "A1=1 and ParentName='权限标识管理 (重要标识)' and ChildID in (" + childidSt + ")"; List <Bd_Base_Dictionary> objList1 = Manage.CallMethod("Bd_Base_Dictionary", "GetList", null, new object[] { sql1 }) as List <Bd_Base_Dictionary>; if (objList != null) { foreach (Bd_Base_Dictionary item in objList1) { ListItem LItem = new ListItem(); LItem.Text = item.ChildName; LItem.Value = item.ChildID.ToString(); LItem.Attributes.Add("title", item.ChildDescription); ck_ImportBox.Items.Add(LItem); } } } } }
/// <summary> /// 获取城市数据 /// </summary> /// <returns></returns> public string GetCityData() { StringBuilder sbScript = new StringBuilder(); try { BaseDataManage Manage = new BaseDataManage(); List <Bd_Air_AirPort> CityList = null; string cacheUrl = System.Configuration.ConfigurationManager.AppSettings["CacheUrl"]; //是否为国际城市 1是 0否 string IsGJ = Request["IsGJ"] != null ? Request["IsGJ"].ToString() : "0"; if (!string.IsNullOrEmpty(cacheUrl)) { try { //去缓存数据 IRemoteMethod remoteobj = (IRemoteMethod)Activator.GetObject(typeof(IRemoteMethod), cacheUrl); DataSet ds = remoteobj.GetBd_Air_Airport(""); if (ds != null && ds.Tables.Count > 0) { DataView dv = ds.Tables[0].DefaultView; dv.Sort = " CityQuanPin ";//拼音全称排序 DataTable Bd_Air_AirPort = dv.ToTable(); CityList = PbProject.Dal.Mapping.MappingHelper <Bd_Air_AirPort> .FillModelList(Bd_Air_AirPort); } } catch (Exception) { //取数据库数据 CityList = Manage.CallMethod("Bd_Air_AirPort", "GetList", null, new object[] { " 1=1 order by CityQuanPin " }) as List <Bd_Air_AirPort>; } } else { //取数据库数据 CityList = Manage.CallMethod("Bd_Air_AirPort", "GetList", null, new object[] { " 1=1 order by CityQuanPin " }) as List <Bd_Air_AirPort>; } List <string> AllData = new List <string>(); if (CityList != null && CityList.Count > 0) { List <string> A_C_List = new List <string>(); List <string> D_G_List = new List <string>(); List <string> H_I_List = new List <string>(); List <string> J_K_List = new List <string>(); List <string> L_M_List = new List <string>(); List <string> N_R_List = new List <string>(); List <string> S_T_List = new List <string>(); List <string> U_X_List = new List <string>(); List <string> Y_Z_List = new List <string>(); List <string> A_List = new List <string>(); List <string> B_List = new List <string>(); List <string> C_List = new List <string>(); List <string> D_List = new List <string>(); List <string> E_List = new List <string>(); List <string> F_List = new List <string>(); List <string> G_List = new List <string>(); List <string> H_List = new List <string>(); List <string> I_List = new List <string>(); List <string> J_List = new List <string>(); List <string> K_List = new List <string>(); List <string> L_List = new List <string>(); List <string> M_List = new List <string>(); List <string> N_List = new List <string>(); List <string> O_List = new List <string>(); List <string> P_List = new List <string>(); List <string> Q_List = new List <string>(); List <string> R_List = new List <string>(); List <string> S_List = new List <string>(); List <string> T_List = new List <string>(); List <string> U_List = new List <string>(); List <string> V_List = new List <string>(); List <string> W_List = new List <string>(); //List<string> X_List = new List<string>(); List <string> Y_List = new List <string>(); List <string> Z_List = new List <string>(); string FirstChar = ""; foreach (var item in CityList) { if (item.CityQuanPin.Length == 0 || item.CityCodeWord.Length == 0) { continue; } AllData.Add(item.CityQuanPin + "|" + item.CityName + "|" + item.CityCodeWord + "|" + item.CityJianPin + "|"); FirstChar = item.CityQuanPin[0].ToString().ToUpper(); if (IsGJ == "0" && item.IsDomestic == 1)//国内 { if ("ABC".Contains(FirstChar)) { A_C_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("DEFG".Contains(FirstChar)) { D_G_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("HI".Contains(FirstChar)) { H_I_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("JK".Contains(FirstChar)) { J_K_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("LM".Contains(FirstChar)) { L_M_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("NOPQR".Contains(FirstChar)) { N_R_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("ST".Contains(FirstChar)) { S_T_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("UVWX".Contains(FirstChar)) { U_X_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("YZ".Contains(FirstChar)) { Y_Z_List.Add(item.CityCodeWord + "|" + item.CityName); } } else if (IsGJ == "1" && item.IsDomestic == 2)//国际 { if ("A".Contains(FirstChar)) { A_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("B".Contains(FirstChar)) { B_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("C".Contains(FirstChar)) { C_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("D".Contains(FirstChar)) { D_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("E".Contains(FirstChar)) { E_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("F".Contains(FirstChar)) { F_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("G".Contains(FirstChar)) { G_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("H".Contains(FirstChar)) { H_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("I".Contains(FirstChar)) { I_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("J".Contains(FirstChar)) { J_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("K".Contains(FirstChar)) { K_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("L".Contains(FirstChar)) { L_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("M".Contains(FirstChar)) { M_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("N".Contains(FirstChar)) { N_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("O".Contains(FirstChar)) { O_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("P".Contains(FirstChar)) { P_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("Q".Contains(FirstChar)) { Q_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("R".Contains(FirstChar)) { R_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("S".Contains(FirstChar)) { S_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("T".Contains(FirstChar)) { T_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("U".Contains(FirstChar)) { U_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("V".Contains(FirstChar)) { V_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("W".Contains(FirstChar)) { W_List.Add(item.CityCodeWord + "|" + item.CityName); } //else if ("X".Contains(FirstChar)) //{ // X_List.Add(item.CityCodeWord + "|" + item.CityName); //} else if ("Y".Contains(FirstChar)) { Y_List.Add(item.CityCodeWord + "|" + item.CityName); } else if ("Z".Contains(FirstChar)) { Z_List.Add(item.CityCodeWord + "|" + item.CityName); } } } //所有数据 sbScript.AppendFormat("$$.module.address.source.fltdomestic =\"@{0}@\";\r\n", string.Join("@", AllData.ToArray())); sbScript.Append(" $$.module.address.source.fltdomestic_hotData = {\r\n"); if (IsGJ == "0") { //国内热门 sbScript.Append("\"热门\": \"@PEK|北京(首都)@NAY|北京(南苑)@SHA|上海(虹桥)@PVG|上海(浦东)@CAN|广州@SZX|深圳@CTU|成都@HGH|杭州@WUH|武汉@XIY|西安@CKG|重庆@TAO|青岛@CSX|长沙@NKG|南京@XMN|厦门@KMG|昆明@DLC|大连@TSN|天津@CGO|郑州@SYX|三亚@TNA|济南@FOC|福州\",\r\n"); sbScript.AppendFormat(" 'ABC': \"@{0}\",\r\n", string.Join("@", A_C_List.ToArray())); sbScript.AppendFormat(" 'DEFG': \"@{0}\",\r\n", string.Join("@", D_G_List.ToArray())); sbScript.AppendFormat(" 'HI': \"@{0}\",\r\n", string.Join("@", H_I_List.ToArray())); sbScript.AppendFormat(" 'JK': \"@{0}\",\r\n", string.Join("@", J_K_List.ToArray())); sbScript.AppendFormat(" 'LM': \"@{0}\",\r\n", string.Join("@", L_M_List.ToArray())); sbScript.AppendFormat(" 'NOPQR': \"@{0}\",\r\n", string.Join("@", N_R_List.ToArray())); sbScript.AppendFormat(" 'ST': \"@{0}\",\r\n", string.Join("@", S_T_List.ToArray())); sbScript.AppendFormat(" 'UVWX': \"@{0}\",\r\n", string.Join("@", U_X_List.ToArray())); sbScript.AppendFormat(" 'YZ': \"@{0}\"\r\n", string.Join("@", Y_Z_List.ToArray())); } else//国际热门 { sbScript.Append("\"热门\": \"@HKG|香港@TPE|台北@MFM|澳门@KHH|高雄@TYO|东京@SEL|首尔@SIN|新加坡@BKK|曼谷@NYC|纽约@KUL|吉隆坡@OSA|大阪@LAX|洛杉矶@SYD|悉尼@SFO|旧金山@YVR|温哥华@MEL|墨尔本@JKT|雅加达@CHI|芝加哥@YTO|多伦多@SGN|胡志明市@MNL|马尼拉@DPS|巴厘岛@NGO|名古屋@HKT|普吉岛@HAN|河内@MLE|马累@DXB|迪拜@PUS|釜山@KTM|加德满都\",\r\n"); sbScript.AppendFormat(" 'A': \"@{0}\",\r\n", string.Join("@", A_List.ToArray())); sbScript.AppendFormat(" 'B': \"@{0}\",\r\n", string.Join("@", B_List.ToArray())); sbScript.AppendFormat(" 'C': \"@{0}\",\r\n", string.Join("@", C_List.ToArray())); sbScript.AppendFormat(" 'D': \"@{0}\",\r\n", string.Join("@", D_List.ToArray())); sbScript.AppendFormat(" 'E': \"@{0}\",\r\n", string.Join("@", E_List.ToArray())); sbScript.AppendFormat(" 'F': \"@{0}\",\r\n", string.Join("@", F_List.ToArray())); sbScript.AppendFormat(" 'G': \"@{0}\",\r\n", string.Join("@", G_List.ToArray())); sbScript.AppendFormat(" 'H': \"@{0}\",\r\n", string.Join("@", H_List.ToArray())); sbScript.AppendFormat(" 'I': \"@{0}\",\r\n", string.Join("@", I_List.ToArray())); sbScript.AppendFormat(" 'J': \"@{0}\",\r\n", string.Join("@", J_List.ToArray())); sbScript.AppendFormat(" 'K': \"@{0}\",\r\n", string.Join("@", K_List.ToArray())); sbScript.AppendFormat(" 'L': \"@{0}\",\r\n", string.Join("@", L_List.ToArray())); sbScript.AppendFormat(" 'M': \"@{0}\",\r\n", string.Join("@", M_List.ToArray())); sbScript.AppendFormat(" 'N': \"@{0}\",\r\n", string.Join("@", N_List.ToArray())); sbScript.AppendFormat(" 'O': \"@{0}\",\r\n", string.Join("@", O_List.ToArray())); sbScript.AppendFormat(" 'P': \"@{0}\",\r\n", string.Join("@", P_List.ToArray())); sbScript.AppendFormat(" 'Q': \"@{0}\",\r\n", string.Join("@", Q_List.ToArray())); sbScript.AppendFormat(" 'R': \"@{0}\",\r\n", string.Join("@", R_List.ToArray())); sbScript.AppendFormat(" 'S': \"@{0}\",\r\n", string.Join("@", S_List.ToArray())); sbScript.AppendFormat(" 'T': \"@{0}\",\r\n", string.Join("@", T_List.ToArray())); sbScript.AppendFormat(" 'U': \"@{0}\",\r\n", string.Join("@", U_List.ToArray())); sbScript.AppendFormat(" 'V': \"@{0}\",\r\n", string.Join("@", V_List.ToArray())); sbScript.AppendFormat(" 'W': \"@{0}\",\r\n", string.Join("@", W_List.ToArray())); // sbScript.AppendFormat(" 'X': \"@{0}\",\r\n", string.Join("@", X_List.ToArray())); sbScript.AppendFormat(" 'Y': \"@{0}\",\r\n", string.Join("@", Y_List.ToArray())); sbScript.AppendFormat(" 'Z': \"@{0}\"\r\n", string.Join("@", Z_List.ToArray())); } sbScript.Append(" };\r\n"); sbScript.Append(" $$.module.address.source.fltdomestic_keyWord = $s2t(\"(可直接输入城市名称查找)\");\r\n"); } } catch (Exception ex) { PnrAnalysis.LogText.LogWrite("获取城市数据:" + ex.Message, "GetCity"); } return(sbScript.ToString()); }
/// <summary> /// 更新数据库的舱位运价 /// </summary> /// <param name="FD">运价结果信息</param> public static void UpdateDataBasePriceInfo(FDInfo FD) { BaseDataManage Manage = new BaseDataManage(System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase + "\\Dal.dll"); #region 航线舱位价格数据处理 //删除航线舱位价格数据 string tmpSQL = " FromCityCode='" + FD.FromCity + "' and ToCityCode='" + FD.ToCity + "' "; bool DelFlag = (bool)(Manage.CallMethod("Bd_Air_CabinDiscount", "DeleteBySQL", null, new object[] { tmpSQL })); if (!DelFlag) { Log.Record("UpdateClassPrice.log", "UpdateDataBasePriceInfo:处理出现错误!删除Bd_Air_CabinDiscount数据:" + FD.FromCity + "|" + FD.ToCity); return; } //循环插入数据 for (int i = 0; i < FD.ClassPriceList.Count; i++) { try { Bd_Air_CabinDiscount tmpCabinDiscount = new Bd_Air_CabinDiscount(); tmpCabinDiscount.AirCode = FD.ClassPriceList[i].CarrierCode; tmpCabinDiscount.Cabin = FD.ClassPriceList[i].ClassCode; tmpCabinDiscount.CabinName = FD.ClassPriceList[i].ClassLevel; tmpCabinDiscount.CabinPrice = decimal.Parse(FD.ClassPriceList[i].ClassPrice); tmpCabinDiscount.FromCityCode = FD.FromCity; tmpCabinDiscount.ToCityCode = FD.ToCity; tmpCabinDiscount.IsGN = 0; //添加数据 bool AddFlag = (bool)Manage.CallMethod("Bd_Air_CabinDiscount", "Insert", null, new object[] { tmpCabinDiscount }); if (!AddFlag) { Log.Record("UpdateClassPrice.log", "UpdateDataBasePriceInfo:处理出现错误!添加Bd_Air_CabinDiscount数据:" + FD.ClassPriceList[i].CarrierCode + "|" + FD.ClassPriceList[i].ClassCode + "|" + FD.FromCity + "|" + FD.ToCity + "|" + FD.ClassPriceList[i].ClassPrice); } } catch (Exception ex) { Log.Record("UpdateClassPrice.log", ex, "UpdateDataBasePriceInfo:处理出现错误!添加Bd_Air_CabinDiscount数据"); } } #endregion 航线舱位价格数据处理 #region 航线价格数据处理 //删除航线舱位价格数据 tmpSQL = " FromCityCode='" + FD.FromCity + "' and ToCityCode='" + FD.ToCity + "' "; DelFlag = (bool)(Manage.CallMethod("Bd_Air_Fares", "DeleteBySQL", null, new object[] { tmpSQL })); if (!DelFlag) { Log.Record("UpdateClassPrice.log", "UpdateDataBasePriceInfo:处理出现错误!删除Bd_Air_Fares航线价格数据:" + FD.FromCity + "|" + FD.ToCity); return; } //循环插入数据 for (int i = 0; i < FD.FullPriceList.Count; i++) { try { Bd_Air_Fares tmpAirFares = new Bd_Air_Fares(); tmpAirFares.CarryCode = FD.FullPriceList[i].carrier; tmpAirFares.FromCityCode = FD.FromCity; tmpAirFares.ToCityCode = FD.ToCity; tmpAirFares.FareFee = decimal.Parse(FD.FullPriceList[i].fullPrice); tmpAirFares.IsDomestic = 0; tmpAirFares.Mileage = int.Parse(FD.Mileage); //添加数据 bool AddFlag = (bool)Manage.CallMethod("Bd_Air_Fares", "Insert", null, new object[] { tmpAirFares }); if (!AddFlag) { Log.Record("UpdateClassPrice.log", "UpdateDataBasePriceInfo:处理出现错误!添加Bd_Air_Fares数据:" + FD.FullPriceList[i].carrier + "|" + FD.FullPriceList[i].fullPrice + "|" + FD.FromCity + "|" + FD.ToCity); } } catch (Exception ex) { Log.Record("UpdateClassPrice.log", ex, "UpdateDataBasePriceInfo:处理出现错误!添加Bd_Air_Fares数据"); } } #endregion 航线价格数据处理 }
/// <summary> /// 更新票价处理 /// </summary> public static void AutoUpdate() { string StartTime = m_UpdatePriceWorkInfo.beginendtime.Split('|')[0]; string EndTime = m_UpdatePriceWorkInfo.beginendtime.Split('|')[1]; while (true) { try { #region 自动更新处理 WebManage.ServerIp = m_UpdatePriceWorkInfo.serverip; WebManage.ServerPort = m_UpdatePriceWorkInfo.serverport; //如果指定了出发到达城市,则直接调用更新价格 if ((m_UpdatePriceWorkInfo.fromcityflag) && (m_UpdatePriceWorkInfo.tocityflag)) { UpdatePrice(m_UpdatePriceWorkInfo.fromcity, m_UpdatePriceWorkInfo.tocity); m_UpdatePriceWorkInfo.EndFlag = true; m_UpdatePriceWorkInfo.EndTime = DateTime.Now; //调用label的invoke方法 tmpFrm.WriteLog("价格更新完毕!\r\n"); break; } else { #region 获取待更新的数据集 string tmpSQL = " 1=1 "; //检查上次 if (m_UpdatePriceWorkInfo.startfromtocityid != "") { tmpSQL += " and id>='" + m_UpdatePriceWorkInfo.startfromtocityid + "' "; } //检查是否指定了出发城市 if (m_UpdatePriceWorkInfo.fromcityflag) { tmpSQL += " and FromCityCode='" + m_UpdatePriceWorkInfo.fromcity + "'"; } //检查是否指定了到达城市 if (m_UpdatePriceWorkInfo.tocityflag) { tmpSQL += " and ToCityCode='" + m_UpdatePriceWorkInfo.tocity + "'"; } tmpSQL += " order by id"; BaseDataManage Manage = new BaseDataManage(System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase + "\\Dal.dll"); List <Bd_Air_Fares> list = Manage.CallMethod("Bd_Air_Fares", "GetList", null, new object[] { tmpSQL }) as List <Bd_Air_Fares>; #endregion 获取待更新的数据集 for (int i = 0; i < list.Count; i++) { //获取待操作的记录 Bd_Air_Fares tmpBd_Air_Fares = list[i]; //赋值当前操作的记录id m_UpdatePriceWorkInfo.startfromtocityid = tmpBd_Air_Fares.id.ToString(); //出发城市 string tmpfromcity = tmpBd_Air_Fares.FromCityCode; //到达城市 string tmptocity = tmpBd_Air_Fares.ToCityCode; UpdatePrice(tmpfromcity, tmptocity); #region 检查自动更新时间限制 if (m_UpdatePriceWorkInfo.timeflag) { //检查当前开始、结束时间 string tmpNowTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); string tmpStartTime = DateTime.Now.ToString("yyyy-MM-dd ") + StartTime; string tmpEndTime = DateTime.Now.ToString("yyyy-MM-dd ") + EndTime; if (!CheckIfInAutoUpdateTime(DateTime.Parse(tmpStartTime), DateTime.Parse(tmpEndTime))) { //不在自动更新时间内,则退出线程处理 m_UpdatePriceWorkInfo.PreEndTime = tmpNowTime; //调用label的invoke方法 tmpFrm.WriteLog("更新到:" + tmpfromcity + tmptocity + "\r\n当前时间已经超过结束时间,中止更新等待下次自动更新!\r\n"); break; } } #endregion 检查自动更新时间限制 } m_UpdatePriceWorkInfo.EndFlag = true; m_UpdatePriceWorkInfo.EndTime = DateTime.Now; //调用label的invoke方法 tmpFrm.WriteLog("价格更新完毕!\r\n"); break; } #endregion 自动更新处理 #region 检查自动更新时间限制 if (m_UpdatePriceWorkInfo.timeflag) { //检查当前开始、结束时间 string tmpNowTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); string tmpStartTime = DateTime.Now.ToString("yyyy-MM-dd ") + StartTime; string tmpEndTime = DateTime.Now.ToString("yyyy-MM-dd ") + EndTime; if (!CheckIfInAutoUpdateTime(DateTime.Parse(tmpStartTime), DateTime.Parse(tmpEndTime))) { //不在自动更新时间内,则退出线程处理 //调用label的invoke方法 tmpFrm.WriteLog("当前时间已经超过结束时间,中止更新等待下次自动更新!\r\n"); break; } } #endregion 检查自动更新时间限制 } catch (Exception ex) { //记录错误日志 Log.Record("UpdateClassPrice.log", ex, "AutoUpdate:自动更新票价线程处理出错!"); } } }
public List <Tb_Ticket_Policy> GetListByStrWhere(string StrWhere) { //return new Dal.ControlBase.BaseData<Tb_Ticket_Policy>().GetBySQLList(StrWhere); return(baseDataManage.CallMethod("Tb_Ticket_Policy", "GetList", null, new Object[] { StrWhere }) as List <Tb_Ticket_Policy>); }
protected void Page_Load(object sender, EventArgs e) { //日志 StringBuilder sbLog = new StringBuilder(); try { Param pm = GetReuest(sbLog); if (pm.Msg == "") { string UseCpyNo = string.Empty; BaseDataManage Manage = new BaseDataManage(); string sqlWhere = string.Format(" LoginName='{0}' ", pm.LoginName); List <User_Employees> empList = Manage.CallMethod("User_Employees", "GetList", null, new object[] { sqlWhere }) as List <User_Employees>; if (empList != null && empList.Count > 0) { User_Employees m_UserEmployees = empList[0]; UseCpyNo = m_UserEmployees.CpyNo; User_Company m_UserCompany = null; sqlWhere = string.Format(" UninAllName='{0}' and UninCode='{1}'", pm.CompanyName, m_UserEmployees.CpyNo); List <User_Company> comList = Manage.CallMethod("User_Company", "GetList", null, new object[] { sqlWhere }) as List <User_Company>; if (comList != null && comList.Count > 0) { m_UserCompany = comList[0]; UseCpyNo = m_UserCompany.UninCode; } } sqlWhere = string.Format(" TripNum='{0}' and UseCpyNo='{1}' ", pm.TripNo, UseCpyNo); List <Tb_TripDistribution> TripList = Manage.CallMethod("Tb_TripDistribution", "GetList", null, new object[] { sqlWhere }) as List <Tb_TripDistribution>; if (TripList != null && TripList.Count > 0) { List <string> sqlList = new List <string>(); if (pm.OpType == "create") { //创建成功 sqlList.Add(string.Format(" update Tb_TripDistribution set TripStatus=9,TicketNum='{0}' where TripNum='{1}' and id='{2}' ", pm.TicketNo, pm.TripNo, TripList[0].id.ToString())); } else if (pm.OpType == "void") { //作废成功 sqlList.Add(string.Format(" update Tb_TripDistribution set TripStatus=6 where TripNum='{0}' and id='{1}' ", pm.TripNo, TripList[0].id.ToString())); } if (sqlList.Count > 0) { string err = ""; if (Manage.ExecuteSqlTran(sqlList, out err)) { sbLog.Append("时间:" + System.DateTime.Now.ToString("yyy-MM-dd HH:mm:ss") + " 公司编号:" + UseCpyNo + " 行程单号:" + pm.TripNo + "同步成功!\r\n\r\n"); } else { sbLog.Append("时间:" + System.DateTime.Now.ToString("yyy-MM-dd HH:mm:ss") + " 公司编号:" + UseCpyNo + " 行程单号:" + pm.TripNo + "同步失败!\r\n\r\n"); } } } else { sbLog.Append("时间:" + System.DateTime.Now.ToString("yyy-MM-dd HH:mm:ss") + " 公司编号:" + UseCpyNo + " 行程单号:" + pm.TripNo + " 不存在!\r\n\r\n"); } } else { sbLog.Append("时间:" + System.DateTime.Now.ToString("yyy-MM-dd HH:mm:ss") + " " + pm.Msg + "\r\n\r\n"); } } catch (Exception ex) { sbLog.Append("异常:" + ex.Message); } finally { PnrAnalysis.LogText.LogWrite(sbLog.ToString(), "TongBuTrip"); } }
/// <summary> /// BindDictionary /// </summary> public void BindDictionary() { //先从参数获取可以设置的开关 string childid = Request.QueryString["Cpychildid"]; string currentuserid = Request["currentuserid"].ToString(); SessionContent sessionContent = new SessionContent(); //sessionContent = Session[currentuserid] as SessionContent; sessionContent = Application[currentuserid] as SessionContent; this.CpyNo = sessionContent.COMPANY.UninCode; string sqlParams = "SetName='" + PbProject.Model.definitionParam.paramsName.gongYingKongZhiFenXiao + "' and CpyNo='" + this.CpyNo + "'"; List <Bd_Base_Parameters> bbpList = Manage.CallMethod("Bd_Base_Parameters", "GetList", null, new object[] { sqlParams }) as List <Bd_Base_Parameters>; string sql = " ParentName='权限标识管理 (重要标识)' and a1=0 and ChildID in ('-1'";//默认一个不存在的,便于拼接字符串 if (bbpList != null && bbpList.Count > 0) { string[] strsSetValue = bbpList[0].SetValue.Split('|'); foreach (string item in strsSetValue) { if (item.Trim() != "") { sql += ",'" + item + "'"; } } } sql += ") order by cast(ChildID as int)"; //再获取开关的名称,值,绑定到控件 List <Bd_Base_Dictionary> objList = Manage.CallMethod("Bd_Base_Dictionary", "GetList", null, new object[] { sql }) as List <Bd_Base_Dictionary>; string sqlParamsfx = "SetName='" + PbProject.Model.definitionParam.paramsName.gongYingKongZhiFenXiao + "' and CpyNo='" + childid + "'"; List <Bd_Base_Parameters> fxlist = Manage.CallMethod("Bd_Base_Parameters", "GetList", null, new object[] { sqlParamsfx }) as List <Bd_Base_Parameters>; if (objList != null && objList.Count != 0) { foreach (Bd_Base_Dictionary item in objList) { ListItem LItem = new ListItem(); LItem.Text = item.ChildName; LItem.Value = item.ChildID.ToString(); LItem.Attributes.Add("title", item.ChildDescription); //LItem.Attributes.Add("title", item.ChildDescription); ck_ImportBox.Items.Add(LItem); if (fxlist != null && fxlist.Count != 0) { if (childid.Length >= 24)//二级分销以及采购都直接继承一级分销的供应控制分销参数 { LItem.Selected = true; } else { if (fxlist[0].SetValue.ToString().Contains("|" + LItem.Value + "|")) { LItem.Selected = true; } } } } } }
/// <summary> /// 生成没有政策信息的订单,确定订单时回写政策数据 /// </summary> /// <param name="FQP"></param> /// <param name="msg"></param> /// <returns></returns> private bool GenerationOrder(UserLoginInfo userLogin, List <Tb_Ticket_SkyWay> skyWay, List <Tb_Ticket_Passenger> pasList, RePnrObj pnrInfo, out string msg) { bool IsSuc = false; msg = ""; //儿童备注关联成人编码 string RmkAdultPnr = ""; //是否为两个订单 bool IsSecOrder = false; bool IsExistAdult = false; bool IsExistCHD = false; bool IsExistINF = false; try { Tb_Ticket_Order AdultOrder = null, ChildOrder = null; if (userLogin.Company == null || userLogin.BaseParametersList == null) { msg = "mCompany公司信息丢失"; return(IsSuc); } //订单管理 Tb_Ticket_OrderBLL OrderManage = new Tb_Ticket_OrderBLL(); OrderInputParam OrderParam = new OrderInputParam(); OrderMustParamModel ParamModel = new OrderMustParamModel(); //构造生成订单需要的信息 List <Tb_Ticket_SkyWay> SkyWay1 = skyWay; //构造乘客信息 List <Tb_Ticket_Passenger> Paslist = pasList; //订单日志记录 Log_Tb_AirOrder logOrder = new Log_Tb_AirOrder(); logOrder.OperTime = DateTime.Now; logOrder.OperType = "创建订单"; logOrder.OperContent = userLogin.User.LoginName + "于" + logOrder.OperTime + "创建订单。"; logOrder.OperLoginName = userLogin.User.LoginName; logOrder.OperUserName = userLogin.User.UserName; logOrder.CpyNo = userLogin.Company.UninCode; logOrder.CpyName = userLogin.Company.UninName; logOrder.CpyType = userLogin.Company.RoleType; logOrder.WatchType = 5; if (IsExistCHD) { //添加权限 是否可以预定儿童票 未加 if (userLogin.FQP.GongYingKongZhiFenXiao != null && userLogin.FQP.GongYingKongZhiFenXiao.Contains("|90|")) { msg = "目前暂时无法预订儿童票!"; } } //关联成人订单号 if (isAsAdultOrder) { #region 关联成人订单号 //开启儿童编码必须关联成人编码或者成人订单号 if (userLogin.FQP.KongZhiXiTong != null && userLogin.FQP.KongZhiXiTong.Contains("|95|")) { string sqlWhere = ""; //儿童订单关联成人订单号 if (cHDAssociationAdultOrderId == "") { msg = "关联成人订单不能为空!"; } else { sqlWhere = string.Format(" OrderId='{0}' ", cHDAssociationAdultOrderId); List <Tb_Ticket_Order> list = baseDataManage.CallMethod("Tb_Ticket_Order", "GetList", null, new object[] { sqlWhere }) as List <Tb_Ticket_Order>; if (list != null && list.Count > 0) { if (list[0].IsChdFlag) { msg = "该订单非成人订单!"; } else { if (string.IsNullOrEmpty(list[0].PNR)) { msg = "该订单还未生成编码!"; } else if (list[0].OrderStatusCode < 4) { msg = "关联成人订单未出票!"; } else { RmkAdultPnr = list[0].PNR; } //添加权限是否验证 儿童航段与关联成人航段信息是否一致 还未加权限 if (userLogin.FQP.KongZhiXiTong == null || !userLogin.FQP.KongZhiXiTong.Contains("|91|")) { if (msg == "" && !ValSkyWay(cHDAssociationAdultOrderId, SkyWay1)) { msg = "成人订单航程与儿童订单航程信息不一致,无法预定!"; } } } } else { msg = "关联成人订单不存在!"; } } } #endregion } //关联订单号通过 if (msg == "") { #region 生成编码记录编码信息 //航空公司 出票Office 和儿童编码所备注的成人编码 string defaultOffice = userLogin.Configparam.Office.Split('^')[0]; string CpyNo = userLogin.Company.UninCode, CarryCode = SkyWay1[0].CarryCode; string PrintOffice = GetPrintOffice(CpyNo, CarryCode); if (!string.IsNullOrEmpty(PrintOffice)) { //Office = PrintOffice; } //记录指令 SaveInsInfo(pnrInfo, userLogin); pnrInfo.PrintOffice = PrintOffice; //记录Pnr日志Id= List <string> pnrLogList = new List <string>(); string AdultPnr = string.Empty; string childPnr = string.Empty; //成人预订信息编码记录 if (pnrInfo.AdultYudingList.Count > 0) { AdultPnr = pnrInfo.AdultPnr; if (string.IsNullOrEmpty(AdultPnr) || AdultPnr.Trim().Length != 6) { //提示pnr失败信息 string yudingRecvData = pnrInfo.AdultYudingList.Values[0]; msg = ShowPnrFailInfo(1, yudingRecvData); AdultPnr = ""; } //记录编码日志 YuDingPnrLog(userLogin, pnrInfo, pnrInfo.AdultYudingList.Keys[0], pnrInfo.AdultYudingList.Values[0], AdultPnr, pnrInfo.Office, ref pnrLogList); if (AdultPnr.Length == 6 && (pnrInfo.PatModelList[0] == null || pnrInfo.PatModelList[0].PatList.Count == 0)) { msg = "成人编码" + AdultPnr + "未能PAT取到价格,原因如下:<br />" + pnrInfo.PatList[0]; } } //儿童预订信息编码记录 if (pnrInfo.ChildYudingList.Count > 0) { childPnr = pnrInfo.childPnr; if (string.IsNullOrEmpty(childPnr) || childPnr.Trim().Length != 6) { //提示pnr失败信息 string yudingRecvData = pnrInfo.ChildYudingList.Values[0]; msg = ShowPnrFailInfo(2, yudingRecvData); childPnr = ""; } //记录编码日志 YuDingPnrLog(userLogin, pnrInfo, pnrInfo.ChildYudingList.Keys[0], pnrInfo.ChildYudingList.Values[0], childPnr, pnrInfo.Office, ref pnrLogList); if (childPnr.Length == 6 && (pnrInfo.PatModelList[1] == null || pnrInfo.PatModelList[1].PatList.Count == 0)) { msg = "儿童编码" + childPnr + "未能PAT取到价格,原因如下:<br />" + pnrInfo.PatList[0]; } } #endregion #region 组合生成订单所需要的实体数据 //成人+婴儿 成人+成人 儿童+备注成人订单号 只生成一个订单 //成人+儿童且没有备注订单号 成人+儿童+婴儿 生成两个订单 //存在儿童 也存在成人 if (IsExistCHD && IsExistAdult) { if (!isAsAdultOrder) { IsSecOrder = true; //生成儿童订单 List <Tb_Ticket_SkyWay> SkyWay2 = skyWay; //儿童乘客列表 List <Tb_Ticket_Passenger> ChildList = new List <Tb_Ticket_Passenger>(); foreach (Tb_Ticket_Passenger pas in Paslist) { if (pas.PassengerType == 2) { ChildList.Add(pas); } } ChildOrder = GetOrder(userLogin, true, ChildList, SkyWay2); Log_Tb_AirOrder logOrder1 = new Log_Tb_AirOrder(); logOrder1.OperTime = DateTime.Now; logOrder1.OperType = "创建订单"; logOrder1.OperContent = userLogin.User.LoginName + "于" + logOrder.OperTime + "创建订单。"; logOrder1.OperLoginName = userLogin.User.LoginName; logOrder1.OperUserName = userLogin.User.UserName; logOrder1.CpyNo = userLogin.Company.UninCode; logOrder1.CpyName = userLogin.Company.UninName; logOrder1.CpyType = userLogin.Company.RoleType; logOrder1.WatchType = 5; //加入参数 OrderMustParamModel ParamModel1 = new OrderMustParamModel(); OrderParam.PnrInfo = pnrInfo; ParamModel1.PasList = ChildList; ParamModel1.SkyList = SkyWay2; ParamModel1.Order = ChildOrder; ParamModel1.LogOrder = logOrder1; //加入集合 OrderParam.OrderParamModel.Add(ParamModel1); } } //为两个订单时 if (IsSecOrder) { //排除儿童乘客 List <Tb_Ticket_Passenger> NotCHDList = new List <Tb_Ticket_Passenger>(); foreach (Tb_Ticket_Passenger item in Paslist) { if (item.PassengerType != 2) { NotCHDList.Add(item); } } Paslist = NotCHDList; AdultOrder = GetOrder(userLogin, false, Paslist, SkyWay1); } else { //为一个订单时 AdultOrder = GetOrder(userLogin, IsExistCHD, Paslist, SkyWay1); if (isAsAdultOrder) { AdultOrder.PNR = RmkAdultPnr; AdultOrder.AssociationOrder = cHDAssociationAdultOrderId; } } // 是否有婴儿 AdultOrder.HaveBabyFlag = IsExistINF; // OrderParam.PnrInfo = pnrInfo; ParamModel.PasList = Paslist; ParamModel.SkyList = SkyWay1; ParamModel.Order = AdultOrder; ParamModel.LogOrder = logOrder; //加入集合 OrderParam.OrderParamModel.Add(ParamModel); #endregion if (pnrLogList.Count > 0 && !(AdultPnr == "" && childPnr == "")) { string UpdatePnrLogSQL = string.Format(" update Log_Pnr set OrderFlag=1 where id in({0}) ", string.Join(",", pnrLogList.ToArray())); OrderParam.ExecSQLList.Add(UpdatePnrLogSQL); } } //前面都通过 if (msg == "") { string ErrMsg = ""; //生成订单 IsSuc = OrderManage.CreateOrder(ref OrderParam, out ErrMsg); List <string> Paramlist = new List <string>(); //两个订单url处理 foreach (OrderMustParamModel item in OrderParam.OrderParamModel) { if (item.Order.IsChdFlag) { Paramlist.Add("ChildOrderId=" + item.Order.OrderId); } else { Paramlist.Add("AdultOrderId=" + item.Order.OrderId); } } if (IsSuc) { msg = string.Join("&", Paramlist.ToArray()); } else { //出错信息 msg = ErrMsg; } } } catch (Exception ex) { //异常信息 msg = ex.Message; IsSuc = false; } return(IsSuc); }
public override void Query(ResponseWriter writer, System.Collections.Specialized.NameValueCollection parames) { userInfo = AuthLogin.GetUserInfo(Username); AirQueryCommon airQuery = new AirQueryCommon(); string cacheNameGuid = parames["cacheNameGuid"]; string fullFlightNo = parames["fullFlightNo"]; //航班号如3U8881 string cairrGuid = parames["cairrGuid"]; //航班唯一编号 string policyGuid = parames["policyGuid"]; //政策唯一编号 #region 取基础航班信息 PbProject.WebCommon.Utility.Cache.CacheByNet pwucc = new PbProject.WebCommon.Utility.Cache.CacheByNet(); DataSet dsCacheData = pwucc.GetCacheData(cacheNameGuid); if (dsCacheData == null) { writer.WriteEx(541, "cache timeout", "缓存过期"); } var dr = dsCacheData.Tables[fullFlightNo].Select("guid='" + cairrGuid + "'").FirstOrDefault(); if (dr == null) { writer.WriteEx(541, "not found filght", "没有找到航班信息"); } string CarrCode = (string)dr["CarrCode"]; //承运人 string FlightNo = (string)dr["FlightNo"]; //航班号 string StartCityCode = (string)dr["StartCityCode"]; //起飞城市 string ToCityCode = (string)dr["ToCityCode"]; //抵达城市 string StartTime = (string)dr["StartTime"]; //起飞时间 string EndTime = (string)dr["EndTime"]; //抵达时间 string StartDate = (string)dr["StartDate"]; //起飞日期 string Space = (string)dr["Space"]; //舱位 string ABFare = (string)dr["ABFee"]; //机建 string RQFare = (string)dr["FuelAdultFee"]; //燃油 string XSFee = (string)dr["XSFee"]; //舱位价格 #endregion #region 取政策 string DownPoint, DownReturnMoney, SpacePrice; List <Tb_Ticket_Policy> objList = Manage.CallMethod("Tb_Ticket_Policy", "GetList", null, new object[] { "id='" + policyGuid + "'" }) as List <Tb_Ticket_Policy>; if (objList.Count() == 0) { List <Tb_Ticket_BookPolicy> bList = Manage.CallMethod("Tb_Ticket_BookPolicy", "GetList", null, new object[] { "PolicyId='" + policyGuid + "'" }) as List <Tb_Ticket_BookPolicy>; if (bList.Count() == 0) { writer.WriteEx(564, "not found policy", "没有找到政策:" + policyGuid); return; } else { var pi = bList[0]; DownPoint = (pi.PReturn * 100).ToString(); DownReturnMoney = "0"; SpacePrice = "0"; } } else { var policyInfo = objList[0]; DownPoint = policyInfo.DownPoint.ToString(); //政策 DownReturnMoney = policyInfo.DownReturnMoney.ToString(); //现返 SpacePrice = policyInfo.SpacePrice.ToString(); //固定特价 } #endregion bool isGuding = false; if (airQuery.IsSpecialSpace(userInfo, Space, CarrCode)) { SpecialPrice sp = PlyMatch(userInfo, StartCityCode, ToCityCode, StartTime, EndTime, StartDate, Space, CarrCode, FlightNo, DownPoint, DownReturnMoney, cairrGuid, SpacePrice, ABFare, RQFare, isGuding, XSFee); if (sp == null) { writer.WriteEx(580, "get data error", "未查询到特价"); } else { writer.Write(sp); } } else { writer.WriteEx(570, "not a special space", "该舱位不是特价舱位"); } }