/// <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", "该舱位不是特价舱位");
}
}
