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);
}
/// <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);
}
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);
}
protected void btnFilter_Click(object sender, EventArgs e)
{
BaseDataManage maange = new BaseDataManage();
HashObject queryParamter = new HashObject();
string strData = string.Join("|", txtPnrs.Value.Split(new string[] { "|", " ", ",", "\r\n", "\r", "\n" }, StringSplitOptions.RemoveEmptyEntries));
queryParamter.Add("SourceSql", strData);
queryParamter.Add("StrSeprate", "|");
System.Data.DataTable table = maange.EexcProc("IsPlatformByPnr", queryParamter);
if (table != null && table.Rows.Count > 0)
{
txtResult.Value = table.Rows[0][0] != DBNull.Value ? table.Rows[0][0].ToString() : "";
}
else
{
txtResult.Value = "未找到结果";
}
}
/// <summary>
/// 获取订单提醒数据
/// </summary>
/// <returns></returns>
public string GetOrderPrompt()
{
StringBuilder sbPromptData = new StringBuilder();
string result = "";
string CpyNo = GetVal("CpyNo", "");
string RoleType = GetVal("RoleType", "");
string currentuserid = GetVal("currentuserid", "");
string LoginName = GetVal("cudspeb", "");
string LoginPwd = GetVal("cpdwpdb", "");
string CurUrl = getRootURL();
string ReUrl = CurUrl + "Login.aspx?cudspeb=" + LoginName + "&cpdwpdb=" + LoginPwd + "&ctdyppbe=cydepsb&OrderPrompt=1";
HashObject hash = new HashObject();
hash.Add("CpyNo", CpyNo);
BaseDataManage baseDataManage = new BaseDataManage();
DataTable table = baseDataManage.EexcProc("GetOrderPrompt", hash);
int Num = 0;
if (table != null && table.Rows.Count > 0)
{
DataRow dr = table.Rows[0];
string param = "¤tuserid=" + currentuserid;
string url = "";
if (dr["待出票订单数"] != DBNull.Value && dr["待出票订单数"].ToString() != "0")
{
//待出票订单数
url = HttpUtility.UrlEncode(CurUrl + "Order/OrderProcessList.aspx?prompt=1" + param);
sbPromptData.Append("<tr><td align='left' height='28px' ><span style='font-size:12px;'>已有<a href=\"" + ReUrl + "&ourl=" + url + "\" target=\"_blank\" style=\" text-decoration:none;\"><strong style=\"color:red;font-size:20px;\">" + dr["待出票订单数"].ToString() + "</strong></a>张机票等待出票 </td></tr>");
Num++;
}
if (dr["申请改签订单数"] != DBNull.Value && dr["申请改签订单数"].ToString() != "0")
{
//申请改签订单数
url = HttpUtility.UrlEncode(CurUrl + "Order/OrderTGQList.aspx?prompt=4" + param);
sbPromptData.Append("<tr><td align='left' height='28px' ><span style='font-size:12px;'>已有<a href=\"" + ReUrl + "&ourl=" + url + "\" target=\"_blank\" style=\" text-decoration:none;\"><strong style=\"color:red;font-size:20px;\">" + dr["申请改签订单数"].ToString() + "</strong></a>张机票申请改签 </td></tr>");
Num++;
}
if (dr["申请退票订单数"] != DBNull.Value && dr["申请退票订单数"].ToString() != "0")
{
//申请退票订单数
url = HttpUtility.UrlEncode(CurUrl + "Order/OrderTGQList.aspx?prompt=2" + param);
sbPromptData.Append("<tr><td align='left' height='28px' ><span style='font-size:12px;'>已有<a href=\"" + ReUrl + "&ourl=" + url + "\" target=\"_blank\" style=\" text-decoration:none;\"><strong style=\"color:red;font-size:20px;\">" + dr["申请退票订单数"].ToString() + "</strong></a>张机票申请退票 </td></tr>");
Num++;
}
if (dr["申请废票订单数"] != DBNull.Value && dr["申请废票订单数"].ToString() != "0")
{
//申请废票订单数
url = HttpUtility.UrlEncode(CurUrl + "Order/OrderTGQList.aspx?prompt=3" + param);
sbPromptData.Append("<tr><td align='left' height='28px' ><span style='font-size:12px;'>已有<a href=\"" + ReUrl + "&ourl=" + url + "\" target=\"_blank\" style=\" text-decoration:none;\"><strong style=\"color:red;font-size:20px;\">" + dr["申请废票订单数"].ToString() + "</strong></a>张机票申请废票 </td></tr>");
Num++;
}
if (dr["异地退废改签订单数"] != DBNull.Value && dr["异地退废改签订单数"].ToString() != "0")
{
//异地退废改签订单数
url = HttpUtility.UrlEncode(CurUrl + "Order/OrderTGQList.aspx?prompt=8" + param);
sbPromptData.Append("<tr><td align='left' height='28px' ><span style='font-size:12px;'>已有<a href=\"" + ReUrl + "&ourl=" + url + "\" target=\"_blank\" style=\" text-decoration:none;\"><strong style=\"color:red;font-size:20px;\">" + dr["异地退废改签订单数"].ToString() + "</strong></a>张异地退废改签订单</td></tr>");
Num++;
}
if (dr["退款中的订单"] != DBNull.Value && dr["退款中的订单"].ToString() != "0")
{
//退款中的订单
url = HttpUtility.UrlEncode(CurUrl + "Order/OrderTGQList.aspx?prompt=9" + param);
sbPromptData.Append("<tr><td align='left' height='28px' ><span style='font-size:12px;'>已有<a href=\"" + ReUrl + "&ourl=" + url + "\" target=\"_blank\" style=\" text-decoration:none;\"><strong style=\"color:red;font-size:20px;\">" + dr["退款中的订单"].ToString() + "</strong></a>张退款中的订单</td></tr>");
Num++;
}
if (dr["待收银订单数"] != DBNull.Value && dr["待收银订单数"].ToString() != "0")
{
//显示数据
url = HttpUtility.UrlEncode(CurUrl + "Order/OrderCashierList.aspx?prompt=1" + param);
sbPromptData.Append("<tr><td align='left' height='28px' ><span style='font-size:12px;'>已有<a href=\"" + ReUrl + "&ourl=" + url + "\" target=\"_blank\" style=\" text-decoration:none;\"><strong style=\"color:red;font-size:20px;\">" + dr["待收银订单数"].ToString() + "</strong></a>张待收银订单</td></tr>");
Num++;
}
if (dr["审核中的订单数"] != DBNull.Value && dr["审核中的订单数"].ToString() != "0")
{
//审核中的订单数
url = HttpUtility.UrlEncode(CurUrl + "Order/OrderTGQList.aspx?prompt=10" + param);
sbPromptData.Append("<tr><td align='left' height='28px' ><span style='font-size:12px;'>已有<a href=\"" + ReUrl + "&ourl=" + url + "\" target=\"_blank\" style=\" text-decoration:none;\"><strong style=\"color:red;font-size:20px;\">" + dr["审核中的订单数"].ToString() + "</strong></a>张审核中的订单</td></tr>");
Num++;
}
if (dr["审核通过待退款"] != DBNull.Value && dr["审核通过待退款"].ToString() != "0")
{
//审核通过待退款
url = HttpUtility.UrlEncode(CurUrl + "Order/OrderTGQList.aspx?prompt=5" + param);
sbPromptData.Append("<tr><td align='left' height='28px' ><span style='font-size:12px;'>已有<a href=\"" + ReUrl + "&ourl=" + url + "\" target=\"_blank\" style=\" text-decoration:none;\"><strong style=\"color:red;font-size:20px;\">" + dr["审核通过待退款"].ToString() + "</strong></a>张审核通过，待退款订单</td></tr>");
Num++;
}
if (dr["线下订单申请"] != DBNull.Value && dr["线下订单申请"].ToString() != "0")
{
//线下订单申请
url = HttpUtility.UrlEncode(CurUrl + "Order/LineOrderProcess.aspx?prompt=5" + param);
sbPromptData.Append("<tr><td align='left' height='28px' ><span style='font-size:12px;'>已有<a href=\"" + ReUrl + "&ourl=" + url + "\" target=\"_blank\" style=\" text-decoration:none;\"><strong style=\"color:red;font-size:20px;\">" + dr["线下订单申请"].ToString() + "</strong></a>张线下订单,等待处理</td></tr>");
Num++;
}
}
StringBuilder PromptUI = new StringBuilder();
if (sbPromptData.ToString() != "")
{
int x1 = 224;
int x2 = 230;
x2 = Num * 28;
x1 = Num * 28;
if (x2 < 150)
{
x2 = 150;
x1 = 170;
}
PromptUI.Append("<table>");
PromptUI.Append(sbPromptData.ToString());
PromptUI.Append("</table>");
}
result = PromptUI.ToString();
return(result);
}
/// <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());
}
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>
/// 更新数据库的舱位运价
/// </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：自动更新票价线程处理出错！");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//string result = "<?xml version=\"1.0\" encoding=\"gb2312\" ?><orderinfo><pnr>HF5N1R</pnr><code>1</code><message /><orderno></orderno><orderstatus>1</orderstatus><paystatus>1</paystatus><pnrsrcid>0101912051714341204</pnrsrcid ><payprice>543.6</ payprice><tradeno>2012051773929436</tradeno><tickets><ticket><passenger>张平</passenger><tktno>876-2037972475</tktno></ticket></tickets></orderinfo>";
//System.Threading.Thread.Sleep(50000);
OnErrorNew("进入 Pay_AutoPayByAlipayNotifyUrl_Load（）", true);
try
{
if (Request.Form["ticketnoinfo"] != null && Request.Form["ticketnoinfo"].ToString() != "")
{
string ticketnoinfo = Request.Form["ticketnoinfo"].ToString();
ticketnoinfo = HttpUtility.UrlDecode(ticketnoinfo, Encoding.GetEncoding("gb2312"));
OnErrorNew("ticketnoinfo内容：" + ticketnoinfo, false);
XmlDocument doc = new XmlDocument();
doc.LoadXml(ticketnoinfo);
DataSet ds = new DataSet();
StringReader rea = new StringReader(doc.InnerXml);
XmlTextReader xmlReader = new XmlTextReader(rea);
ds.ReadXml(xmlReader);
PbProject.Model.Tb_Ticket_Order Order = new PbProject.Logic.Order.Tb_Ticket_OrderBLL().GetTicketOrderByOrderId(ds.Tables[0].Rows[0]["pnrsrcid"].ToString());
//Login(Order);
if (ticketnoinfo.IndexOf("支付成功后，取票号失败，请您手工操作") > -1)
{
#region 记录操作日志
//添加操作订单的内容
PbProject.Model.Log_Tb_AirOrder OrderLog = new PbProject.Model.Log_Tb_AirOrder();
OrderLog.id = Guid.NewGuid();
OrderLog.OrderId = Order.OrderId;
OrderLog.OperType = "修改";
OrderLog.OperTime = DateTime.Now;
OrderLog.OperContent = "于 " + DateTime.Now + " 航空公司已出票，自动取票号失败，请您手工出票！";
OrderLog.WatchType = 2;
string tempSql = PbProject.Dal.Mapping.MappingHelper <PbProject.Model.Log_Tb_AirOrder> .CreateInsertModelSql(OrderLog);
#endregion
OnErrorNew("支付成功后，取票号失败，请您手工操作！", false);
return;
}
if (Order.OrderStatusCode == 4)
{
OnErrorNew("该票号已经出票", false);
return;
}
int tcount = 0;
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
PbProject.Logic.Order.Tb_Ticket_PassengerBLL psb = new PbProject.Logic.Order.Tb_Ticket_PassengerBLL();
List <PbProject.Model.Tb_Ticket_Passenger> psmList = psb.GetPasListByOrderID(ds.Tables[0].Rows[0]["pnrsrcid"].ToString());
OnErrorNew("开始修改票号", false);
for (int i = 0; i < psmList.Count; i++)
{
for (int j = 0; j < ds.Tables[2].Rows.Count; j++)
{
if (ds.Tables[2].Rows[j]["tktno"].ToString() != "")
{
if (psmList[i].PassengerName.ToUpper() == ds.Tables[2].Rows[j]["passenger"].ToString().ToUpper() || psmList[i].PassengerName.ToUpper() == HttpUtility.UrlDecode(ds.Tables[2].Rows[j]["passenger"].ToString().ToUpper(), Encoding.Default) || psmList[i].PassengerName.ToUpper() == HttpUtility.UrlDecode(ds.Tables[2].Rows[j]["passenger"].ToString().ToUpper()))
{
psmList[i].TicketStatus = 2;
psmList[i].TicketNumber = ds.Tables[2].Rows[j]["tktno"].ToString().Trim();
tcount++;
}
}
}
}
if (tcount != psmList.Count)
{
#region 记录操作日志
//添加操作订单的内容
PbProject.Logic.SQLEXBLL.SQLEXBLL_Base sqlbase = new PbProject.Logic.SQLEXBLL.SQLEXBLL_Base();
PbProject.Model.Log_Tb_AirOrder OrderLog = new PbProject.Model.Log_Tb_AirOrder();
OrderLog.id = Guid.NewGuid();
OrderLog.OrderId = Order.OrderId;
OrderLog.OperType = "修改";
OrderLog.OperTime = DateTime.Now;
OrderLog.OperContent = "自动回填票号失败:乘机人与票号不符，需要手动操作!";
OrderLog.WatchType = 2;
string tempSql = PbProject.Dal.Mapping.MappingHelper <PbProject.Model.Log_Tb_AirOrder> .CreateInsertModelSql(OrderLog);
sqlbase.ExecuteNonQuerySQLInfo(tempSql);
#endregion
}
decimal payprice = 0;
try
{
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 &&
!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["payprice"].ToString()) &&
!ds.Tables[0].Rows[0]["payprice"].ToString().Contains("-"))
{
payprice = payprice = Convert.ToDecimal(ds.Tables[0].Rows[0]["payprice"].ToString());
}
}
catch (Exception)
{
}
if (payprice != 0)
{
Order.AirPoint = 1 - (payprice - Order.ABFee - Order.FuelFee) / Order.PMFee;
Order.AirPoint = Math.Round(Order.AirPoint, 3);
}
//是否更改订单状态
//默认更改状态
bool IsUpdateOrderStatus = true;
try
{
foreach (PbProject.Model.Tb_Ticket_Passenger item in psmList)
{
//婴儿没有回帖票号 不修改状态
if (item.PassengerType == 3 && string.IsNullOrEmpty(item.TicketNumber.Trim()))
{
IsUpdateOrderStatus = false;
break;
}
}
if ((IsUpdateOrderStatus) && (tcount == psmList.Count))
{
Order.OrderStatusCode = 4;
}
}
catch (Exception)
{
}
List <PbProject.Model.User_Company> mCompany = new PbProject.Logic.ControlBase.BaseDataManage().
CallMethod("User_Company", "GetList", null, new Object[] { "UninCode='" + Order.CPCpyNo + "'" }) as List <PbProject.Model.User_Company>;
List <PbProject.Model.User_Employees> mUser = new PbProject.Logic.ControlBase.BaseDataManage().
CallMethod("User_Employees", "GetList", null, new Object[] { " IsAdmin=0 and CpyNo='" + Order.CPCpyNo + "'" }) as List <PbProject.Model.User_Employees>;
bool reuslt = new PbProject.Logic.Order.Tb_Ticket_OrderBLL().OperOrderCP(Order, psmList, mUser[0], mCompany[0], (IsUpdateOrderStatus ? "B2B自动出票" : "B2B自动出票【婴儿票请手动处理】"));
if (reuslt)
{
//零时改回状态
BaseDataManage manage = new BaseDataManage();
manage.ExecuteNonQuerySQLInfo("update Tb_Ticket_Order set OrderStatusCode=" + Order.OrderStatusCode + " where OrderId='" + Order.OrderId + "'");
#region 票宝开放服务接口异步通知出票
if (Order.OrderSourceType == 5)
{
PbProject.Logic.PTInterface.PbInterfaceNotify pbInterfaceCmd = new PbProject.Logic.PTInterface.PbInterfaceNotify();
if (pbInterfaceCmd != null)
{
bool pbNotifyResult = pbInterfaceCmd.NotifyTicketNo(Order);
}
}
#endregion
OnErrorNew(string.Format("出票成功.订单号:{0},PNR:{1}", Order.OrderId, Order.PNR), false);
}
else
{
OnErrorNew(string.Format("出票失败.订单号:{0},PNR:{1}", Order.OrderId, Order.PNR), false);
}
}
}
}
catch (Exception ex)
{
#region 记录数据日志
try
{
OnErrorNew("报错：" + ex.Message, false);
}
catch { }
#endregion
}
}
