protected void Page_Load(object sender, EventArgs e)
{
LogInfo("进入汇付天下自动出票回调...", false);
m_Key = System.Configuration.ConfigurationManager.AppSettings["HuifuAutoKey"];
client = new ChinaPnrClient(System.Configuration.ConfigurationManager.AppSettings["HuifuAutoIP"]);
if (string.IsNullOrEmpty(m_Key))
{
string msg = PnrNo + "_FAIL未配置Key";
LogInfo("未配置Key", false);
client.Send(AddHeadLen(msg));
return;
}
GetParams();
PbProject.Model.Tb_Ticket_Order orderList = new PbProject.Logic.Order.Tb_Ticket_OrderBLL().GetTicketOrderByOrderId(m_GUID);
if (orderList == null)
{
string msg = PnrNo + "_FAIL未找到相应订单";
LogInfo("未找到相应订单", false);
client.Send(AddHeadLen(msg));
return;
}
PnrNo = orderList.PNR;
if (!CheckParams())
{
if (!string.IsNullOrEmpty(m_DrawResult) && m_DrawResult.Trim() != "000000")
{
RollBackTicketOrderState(orderList, "出票失败,原因:回调参数不完整");
}
string msg = PnrNo + "_FAIL参数不完整";
LogInfo(string.Format("参数不完整，订单号：{0}，PNR：{1}", orderList.OrderId, PnrNo), false);
client.Send(AddHeadLen(msg));
return;
}
if (!CheckSign())
{
if (m_DrawResult.Trim() != "000000")
{
RollBackTicketOrderState(orderList, "出票失败,原因:回调签名验证失败");
}
string msg = PnrNo + "_FAIL签名验证失败";
LogInfo(string.Format("签名验证失败，订单号：{0}，PNR：{1}", orderList.OrderId, PnrNo), false);
client.Send(AddHeadLen(msg));
return;
}
if (orderList.OrderStatusCode == 4)
{
string msg = PnrNo + "_FAIL已出票";
LogInfo(string.Format("已经出票，无需重复出票，订单号：{0}，PNR：{1}", orderList.OrderId, PnrNo), false);
client.Send(AddHeadLen(msg));
return;
}
//Login(orderList);
//更新票号
UpdateTicketOrder(orderList);
}
/// <summary>
/// 出票Socket调用
/// </summary>
/// <param name="orderMange"></param>
/// <param name="client"></param>
/// <param name="order"></param>
/// <param name="comModel"></param>
/// <param name="data"></param>
private void ChinapnrTicketWork(PbProject.Logic.Order.Tb_Ticket_OrderBLL orderMange, ChinaPnrClient client, PbProject.Model.Tb_Ticket_Order order, string data, int AutoCount, ListParam Pm, B2BShowLog Log)
{
int times = AutoCount; //至少一次
for (int i = 0; i < times; i++) //调用次数
{
//调用ChinaPnrClient对象的Send方法，获取发送结果
string result = client.Send(data);//合法请求：0011QUERY_VALID；非法请求：0021QUERY_INVALID 错误描述。
if (result.Contains("0011QUERY_VALID"))
{
order.A10 = "1";//标识出票成功
string SQL = " update Tb_Ticket_Order set A10=1 where OrderId='" + order.OrderId + "'";
PbProject.Logic.SQLEXBLL.SQLEXBLL_Base ss = new PbProject.Logic.SQLEXBLL.SQLEXBLL_Base();
ss.ExecuteNonQuerySQLInfo(SQL);
//ShowChinapnrMsg("出票请求成功，订单ID:" + order.OrderId);
//infoLog.Info("出票请求成功，订单ID:" + order.OrderId);
Log(3, "出票请求成功，订单ID:" + order.OrderId);
break;
}
else
{
string logDbMsg = "";
if (string.IsNullOrEmpty(result))
{
logDbMsg = "出票请求失败。原因:服务器响应超时";
string msg = string.Format("出票请求失败。原因:服务器响应超时,订单ID:{0}", order.OrderId);
//ShowChinapnrMsg(msg);
//infoLog.Info(msg);
Log(3, msg);
}
else
{
string errorStr = result.Substring(17, result.Length - 17).Trim();
if (errorStr.ToLower().IndexOf("airlines") > 0)
{
logDbMsg = string.Format("出票请求失败。原因:{0},航空公司二字码:{1}", errorStr, order.CarryCode);
string msg = string.Format("出票请求失败。原因:{0},航空公司二字码:{1},订单ID:{2}", errorStr, order.CarryCode, order.OrderId);
//ShowChinapnrMsg(msg);
//infoLog.Info(msg);
Log(3, msg);
}
else
{
logDbMsg = string.Format("出票请求失败。原因:{0}", errorStr);
string msg = string.Format("出票请求失败。原因:{0},订单ID:{1}", errorStr, order.OrderId);
//ShowChinapnrMsg(msg);
//infoLog.Info(msg);
Log(3, msg);
}
}
if (i == times - 1)
{
string msg = string.Format("已达到最大失败次数,已改为手动出票,订单ID:{0}", order.OrderId);
ChinapnrAutofailed(order, msg, Pm, Log);
//FailedLogToDb(order, logDbMsg + ",已改为手动出票");
OrderLog(order.OrderId, logDbMsg + ",已改为手动出票", Pm, "2");
}
}
Thread.Sleep(3000);
}
}
/// <summary>
/// 出票流程
/// </summary>
private void ChinapnrWork(List <string> CpyNoList, List <ListParam> LPList, B2BShowLog Log)
{
try
{
List <string> removeList = new List <string>();
foreach (string CpyNo in CpyNoList)
{
string KonZhiXT = GetGYParameters(CpyNo);
if (KonZhiXT != null && !KonZhiXT.Contains("|22|"))//开启B2B自动出票
{
removeList.Add(CpyNo);
}
}
if (removeList.Count > 0)
{
foreach (string item in removeList)
{
if (CpyNoList.Contains(item))
{
Log(3, string.Format("公司编号:{0} B2B自动出票未开启\r\n", item));
CpyNoList.Remove(item);
}
}
}
PbProject.Logic.Order.Tb_Ticket_OrderBLL orderMange = new PbProject.Logic.Order.Tb_Ticket_OrderBLL();
PbProject.Logic.Order.Tb_Ticket_PassengerBLL passengerManage = new PbProject.Logic.Order.Tb_Ticket_PassengerBLL();
ChinaPnrClient client = new ChinaPnrClient(System.Configuration.ConfigurationManager.AppSettings["HuifuAutoIP"]);
while (true)
{
try
{
PbProject.Model.definitionParam.BaseSwitch BS = new PbProject.Model.definitionParam.BaseSwitch();
string sqlWhere = string.Format(" left(CPCpyNo,12) in({0}) and cast( isnull(AutoPrintTimes,'0') as int) < 3 and PolicyType=1 and AutoPrintFlag=2 and OrderStatusCode=3 and A10<>1 ", string.Join(",", CpyNoList.ToArray()));
List <PbProject.Model.Tb_Ticket_Order> orderList = Manage.CallMethod("Tb_Ticket_Order", "GetList", null, new object[] { sqlWhere }) as List <PbProject.Model.Tb_Ticket_Order>;
if (orderList.Count == 0)
{
Thread.Sleep(m_ChinapnrRefreshTime * 1000);
continue;
}
foreach (PbProject.Model.Tb_Ticket_Order order in orderList)
{
if (order.CPCpyNo.Length >= 12)
{
PbProject.Model.User_Company mTopcom = new PbProject.Logic.User.User_CompanyBLL().GetCompany(order.CPCpyNo.Substring(0, 12));
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());
BS = PbProject.WebCommon.Utility.BaseParams.getParams(ParList);
}
else
{
continue;
}
ListParam LPM = LPList.Find(delegate(ListParam _pm)
{
return(_pm.CpyNo == order.CPCpyNo.Substring(0, 12));
});
IList <PbProject.Model.Tb_Ticket_Passenger> orderPassenger = passengerManage.GetPasListByOrderID(order.OrderId);
decimal faceValue = 0;
foreach (PbProject.Model.Tb_Ticket_Passenger passenger in orderPassenger)
{
faceValue += passenger.PMFee;
}
//格式：自动出票方式(1，支付宝本票通；2，汇付天下出票窗)^帐号|是否签约(1，已签约；2，未签)^帐号|密码|支付方式(1，信用账户；2，付款账户)
if (string.IsNullOrEmpty(BS.AutoPayAccount.Split('^')[3]) || BS.AutoPayAccount.Split('^')[3].Split('|').Length < 3)
{
string msg = "未绑定汇付天下账号，不能自动出票，该共功能已停止!，订单ID:" + order.OrderId;
//StopChinapnrThread(msg);
Log(3, msg);
continue;
}
//格式：CA:xxx//xxx^^^CZ:xxx//xxx^^^MU:xxx//xxx
string Acc = "";
string pwd = "";
string[] CarrList = BS.AutoAccount.Split(new string[] { "^^^" }, StringSplitOptions.RemoveEmptyEntries);//Regex.Split(BS.AutoAccount, "^^^", RegexOptions.IgnoreCase);
for (int i = 0; i < CarrList.Length; i++)
{
if (CarrList[i].Contains(order.CarryCode))
{
Acc = CarrList[i].Split(new string[] { "//" }, StringSplitOptions.None)[0].Split(':')[1]; //Regex.Split(CarrList[i].Split(':')[1], "//", RegexOptions.IgnoreCase)[0];
pwd = CarrList[i].Split(new string[] { "//" }, StringSplitOptions.None)[1]; //Regex.Split(CarrList[i].Split(':')[1], "//", RegexOptions.IgnoreCase)[1];
break;
}
}
if (string.IsNullOrEmpty(Acc) || string.IsNullOrEmpty(pwd))
{
string msg = "航空公司帐号和密码为空，不能自动出票，改为手动出票，订单ID:" + order.OrderId;
ChinapnrAutofailed(order, msg, LPM, Log);
continue;
}
//根据订单信息，构造参数实体类ChinaPnrParams，参数构造见接口文档
ChinaPnrParams chinaPnrParams = new ChinaPnrParams();
chinaPnrParams.PNRNo = order.BigCode;
chinaPnrParams.GUID = order.OrderId;
chinaPnrParams.Airlines = order.CarryCode.Split('/')[0];
chinaPnrParams.FaceValue = faceValue.ToString();
chinaPnrParams.Username = Acc;
chinaPnrParams.B2BPswd = pwd;
chinaPnrParams.CPNROper = BS.AutoPayAccount.Split('^')[3].Split('|')[0];
chinaPnrParams.CPNRPswd = StringUtils.GetMd5(BS.AutoPayAccount.Split('^')[3].Split('|')[1]);
chinaPnrParams.PayType = BS.AutoPayAccount.Split('^')[3].Split('|')[2];
chinaPnrParams.PartnerCode = "63";
string data = ChinaPnrParams.ChinaPnrParamsToString(chinaPnrParams);
ChinapnrTicketWork(orderMange, client, order, data, Convert.ToInt32(BS.AutoPayAccount.Split('^')[1]), LPM, Log);
}
//在出票结果会出现在ChinaPnrParams中配置的RetURL链接中，在对应的RetURL里执行返回操作，这里业务逻辑结束
Thread.Sleep(m_ChinapnrRefreshTime * 1000);
}
catch (Exception e)
{
try
{
if (e is ThreadAbortException)
{
return;
}
// errorLog.Error(e.Message, e);
Log(3, e.Message);
//ShowChinapnrMsg(string.Format("发生不可预料的异常:{0}该功能暂停，1分钟后重新开始！", e.Message));
Log(3, string.Format("发生不可预料的异常:{0}该功能暂停，1分钟后重新开始！", e.Message));
Thread.Sleep(60000);
}
catch (Exception)
{
}
}
}
}
catch (Exception e)
{
try
{
if (e is ThreadAbortException)
{
return;
}
// errorLog.Error(e.Message, e);
// ShowChinapnrMsg(string.Format("发生不可预料的异常:{0}该功能停止，如果继续发生请联系开发人员解决，谢谢！", e.Message));
Log(3, "发生不可预料的异常:" + e.Message + "该功能停止，如果继续发生请联系开发人员解决，谢谢！");
}
catch (Exception)
{
}
}
}
