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>
/// 支付宝自动出票
/// </summary>
/// <param name="passengerManage"></param>
/// <param name="order"></param>
/// <param name="Log"></param>
private void AlipayTicketWork(Tb_Ticket_PassengerBLL passengerManage, Tb_Ticket_Order order, ListParam LPm, B2BShowLog Log)
{
PbProject.Logic.Pay.AliPay alipay = new PbProject.Logic.Pay.AliPay();
PbProject.Model.definitionParam.BaseSwitch BS = new PbProject.Model.definitionParam.BaseSwitch();
string GYCpyNo = order.CPCpyNo;
if (GYCpyNo.Length >= 12)
{
GYCpyNo = GYCpyNo.Substring(0, 12);
PbProject.Model.User_Company mTopcom = new PbProject.Logic.User.User_CompanyBLL().GetCompany(GYCpyNo);
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);
string msg = "";
string UpdateFiled = "";
string sql = "";
try
{
//锁定订单
sql = string.Format(" update Tb_Ticket_Order set LockCpyNo='{0}' ,LockTime='{1}',LockLoginName='系统管理员' where OrderId='{2}' ", GYCpyNo, System.DateTime.Now, order.OrderId);
Manage.ExecuteNonQuerySQLInfo(sql);
bool IsOk = alipay.AutoPay(order, BS, ref msg);
//失败请求次数默认
int times = 3;
try
{
times = string.IsNullOrEmpty(BS.AutoPayAccount.Split('^')[1]) ? 1 : Convert.ToInt32(BS.AutoPayAccount.Split('^')[1]);
}
catch (Exception)
{
Log(2, "错误:失败次数未取到， 订单号:" + order.OrderId + " " + BS.AutoPayAccount + "\r\n");
}
//请求成功
if (IsOk)
{
//添加操作订单的内容
string LogCon = "于 " + DateTime.Now + " 自动出票启动成功，请等待航空公司出票后系统自动回帖票号";
OrderLog(order.OrderId, LogCon, LPm, "1");
Log(2, string.Format("出票成功，订单ID{0}", order.OrderId) + "\r\n");
UpdateFiled = " A10=1 ,";//标识已请求成功
}
else
{
Log(2, string.Format("订单ID{0},出票信息:{1}", order.OrderId, msg) + "\r\n");
for (int i = 0; i < times; i++)
{
IsOk = alipay.AutoPay(order, BS, ref msg);
Log(2, string.Format("订单ID{0},出票信息:{1}", order.OrderId, msg) + "\r\n");
if (IsOk)
{
//添加操作订单的内容
string LogCon = "于 " + DateTime.Now + " 自动出票启动成功，请等待航空公司出票后系统自动回帖票号";
OrderLog(order.OrderId, LogCon, LPm, "1");
Log(2, string.Format("出票成功，订单ID{0}", order.OrderId) + "\r\n");
UpdateFiled = " A10=1 ,";//标识已请求成功
break;
}
if (i >= times - 1)
{
#region 记录操作日志
//记录日志
if (msg == "未查到符合支付价格的政策")
{
msg = "与航空公司网站价格不符合";
}
string LogCon = "于 " + DateTime.Now + " 第" + (i + 1).ToString() + "次调用自动出票失败，失败原因：" + msg;
OrderLog(order.OrderId, LogCon, LPm, "1");
#endregion
UpdateFiled = " A10=2,AutoPrintFlag=0 ,";//标识已请求成功
}
Thread.Sleep(1);
}
}
}
catch (Exception ex)
{
try
{
Log(2, "发生不可预料的异常:" + ex.Message + "该功能停止，请重新启动，如果继续发生请联系开发人员解决，谢谢！\r\n");
if (ex is ThreadAbortException)
{
return;
}
}
catch (Exception)
{
}
}
finally
{
//解锁订单
sql = string.Format(" update Tb_Ticket_Order set " + UpdateFiled + " LockCpyNo='',LockLoginName='' ,LockTime='{0}' where OrderId='{1}' ", System.DateTime.Now, order.OrderId);
Manage.ExecuteNonQuerySQLInfo(sql);
}
}
}
/// <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)
{
}
}
}
/// <summary>
/// 获取充值收款账号
/// </summary>
/// <param name="payWay">支付方式:</param>
/// <returns></returns>
private string UseAct(string payWay, string mUserCpyNo)
{
string act = "";
try
{
string gYcpyNo = "";
if (mUser != null && !string.IsNullOrEmpty(mUser.CpyNo))
{
if (mUserCpyNo.Length == 12)
{
gYcpyNo = mUserCpyNo.Substring(0, 6);
}
else
{
gYcpyNo = mUserCpyNo.Substring(0, 12);
}
}
string wangYinZhangHao = PbProject.Model.definitionParam.paramsName.wangYinZhangHao;
string wangYinLeiXing = PbProject.Model.definitionParam.paramsName.wangYinLeiXing;
string sqlWhere = " CpyNo='" + gYcpyNo + "' and SetName='" + wangYinZhangHao + "'";
List <Bd_Base_Parameters> bParametersList = new PbProject.Logic.ControlBase.Bd_Base_ParametersBLL().GetParametersListByWhere(sqlWhere);
#region 测试数据
/*List<Bd_Base_Parameters> bParametersList = new List<Bd_Base_Parameters>();
* Bd_Base_Parameters ts = new Bd_Base_Parameters();
* ts.SetName = wangYinZhangHao;
* ts.SetValue = "[email protected]^[email protected]^0.001|[email protected]^[email protected]^0.001|[email protected]^[email protected]^0.001|[email protected]^[email protected]^0.001|";
* bParametersList.Add(ts);
*
* Bd_Base_Parameters ts1 = new Bd_Base_Parameters();
* ts1.SetName = wangYinLeiXing;
* ts1.SetValue = "6";
* bParametersList.Add(ts1);
*/
#endregion
if ((bParametersList != null && bParametersList.Count == 1) &&
!string.IsNullOrEmpty(bParametersList[0].SetValue) && bParametersList[0].SetValue.Contains("|"))
{
string[] setValues = bParametersList[0].SetValue.Split('|');
if (setValues.Length > 3)
{
int temp = -1;
switch (payWay)
{
#region 支付方式
case "1":
case "5":
temp = 0;
break;
case "2":
case "6":
temp = 1;
break;
case "3":
case "7":
temp = 2;
break;
case "4":
case "8":
case "40":
temp = 3;
break;
default:
break;
#endregion
}
if (temp != -1)
{
string[] setValuesNewS = setValues[temp].Split('^');
if (setValuesNewS.Length != 0 && !string.IsNullOrEmpty(setValuesNewS[1]))
{
act = setValuesNewS[1];
}
}
}
}
}
catch (Exception)
{
}
return(act.Trim());
}
/// <summary>
/// BindPayType
/// </summary>
private void BindPayType()
{
try
{
string gYcpyNo = mUser.CpyNo.Substring(0, 12);
string wangYinZhangHao = PbProject.Model.definitionParam.paramsName.wangYinZhangHao;
string wangYinLeiXing = PbProject.Model.definitionParam.paramsName.wangYinLeiXing;
string sqlWhere = " CpyNo='" + gYcpyNo + "' and (SetName='" + wangYinZhangHao + "' or SetName='" + wangYinLeiXing + "')";
List <Bd_Base_Parameters> bParametersList = new PbProject.Logic.ControlBase.Bd_Base_ParametersBLL().GetParametersListByWhere(sqlWhere);
#region 测试数据
/*List<Bd_Base_Parameters> bParametersList = new List<Bd_Base_Parameters>();
* Bd_Base_Parameters ts = new Bd_Base_Parameters();
* ts.SetName = wangYinZhangHao;
* ts.SetValue = "[email protected]^[email protected]^0.001|[email protected]^[email protected]^0.001|[email protected]^[email protected]^0.001|[email protected]^[email protected]^0.001|";
* bParametersList.Add(ts);
*
* Bd_Base_Parameters ts1 = new Bd_Base_Parameters();
* ts1.SetName = wangYinLeiXing;
* ts1.SetValue = "6";
* bParametersList.Add(ts1);
*/
#endregion
Bd_Base_Parameters zhangHao = null;
Bd_Base_Parameters leiXing = null;
if (bParametersList != null && bParametersList.Count > 1)
{
foreach (var item in bParametersList)
{
if (item.SetName == wangYinZhangHao)
{
zhangHao = item;
}
else if (item.SetName == wangYinLeiXing)
{
leiXing = item;
}
}
string temp = "";
if (zhangHao != null && !string.IsNullOrEmpty(zhangHao.SetValue) && zhangHao.SetValue.Contains("|"))
{
string[] setValues = zhangHao.SetValue.Split('|');
string[] setValue0 = setValues[0].Split('^');
if (!string.IsNullOrEmpty(setValue0[1]))
{
//支付宝
rblPayType.Items.Add(new ListItem("支付宝", "1"));
temp += "5,";
}
string[] setValue1 = setValues[1].Split('^');
if (!string.IsNullOrEmpty(setValue1[1]))
{
//快钱
rblPayType.Items.Add(new ListItem("快钱", "2"));
temp += "6,";
}
string[] setValue2 = setValues[2].Split('^');
if (!string.IsNullOrEmpty(setValue2[1]))
{
//汇付
rblPayType.Items.Add(new ListItem("汇付", "3"));
temp += "7,";
}
string[] setValue3 = setValues[3].Split('^');
if (!string.IsNullOrEmpty(setValue3[1]))
{
//财付通
rblPayType.Items.Add(new ListItem("财付通", "4"));
temp += "8,";
rblPayType.Items.Add(new ListItem("信用卡大额支付", "40"));
}
}
//判断网银
if (leiXing != null && !string.IsNullOrEmpty(leiXing.SetValue) && leiXing.SetValue != "0")
{
if (temp.Contains(leiXing.SetValue))
{
rblPayType.Items.Insert(0, new ListItem("网银", leiXing.SetValue));
hidWangYingType.Value = leiXing.SetValue;
}
}
if (rblPayType.Items.Count > 0)
{
rblPayType.Items[0].Selected = true;
hidPayWay.Value = rblPayType.Items[0].Value; //支付方式
spanid.Visible = true;
}
else
{
spanid.Visible = false;
Page.ClientScript.RegisterStartupScript(this.GetType(), DateTime.Now.Ticks.ToString(), "alert('不能进入该页面!');history.go(-1);", true);
}
}
}
catch (Exception)
{
}
}
/// <summary>
/// 加载数据
/// </summary>
private void UseReceivablesBind()
{
try
{
string tempSqlWhere = " CpyNo ='" + mUser.CpyNo + "' and SetName='" + PbProject.Model.definitionParam.paramsName.wangYinZhangHao + "'";
List <Bd_Base_Parameters> bParametersList = new PbProject.Logic.ControlBase.Bd_Base_ParametersBLL().GetParametersListByWhere(tempSqlWhere);
if (bParametersList != null && bParametersList.Count == 1 && bParametersList[0] != null)
{
if (!string.IsNullOrEmpty(bParametersList[0].SetValue))
{
#region 账号绑定
hidden_id.Value = bParametersList[0].id.ToString();
hidden_strValue.Value = bParametersList[0].SetValue;
string[] wangYinZhangHao = bParametersList[0].SetValue.Split('|');
for (int i = 0; i < wangYinZhangHao.Length; i++)
{
string[] wangYinZhangHaoValue = wangYinZhangHao[i].Split('^');
if (i == 0)
{
//支付宝
if (!string.IsNullOrEmpty(wangYinZhangHaoValue[0]))
{
txtZFB.Text = wangYinZhangHaoValue[0];
txtZFB.Enabled = true;
lbtnZFBSign.Visible = false;
btnZFBOK.Visible = false;
}
if (!string.IsNullOrEmpty(wangYinZhangHaoValue[1]))
{
txtZFB_Repay.Text = wangYinZhangHaoValue[1];
txtZFB_Repay.Enabled = true;
lbtnZFBSign_Repay.Visible = false;
btnZFBOK_Repay.Visible = false;
}
hidden_ZFB.Value = wangYinZhangHaoValue[2];
}
else if (i == 1)
{
//快钱
if (!string.IsNullOrEmpty(wangYinZhangHaoValue[0]))
{
txtKQ.Text = wangYinZhangHaoValue[0];
txtKQ.Enabled = true;
lbtnKQSign.Visible = false;
btnKQOK.Visible = false;
}
if (!string.IsNullOrEmpty(wangYinZhangHaoValue[1]))
{
txtKQ_Repay.Text = wangYinZhangHaoValue[1];
txtKQ_Repay.Enabled = true;
lbtnKQSign_Repay.Visible = false;
btnKQOK_Repay.Visible = false;
}
hidden_KQ.Value = wangYinZhangHaoValue[2];
}
else if (i == 2)
{
//汇付
if (!string.IsNullOrEmpty(wangYinZhangHaoValue[0]))
{
txtHF.Text = wangYinZhangHaoValue[0];
txtHF.Enabled = true;
lbtnHFSign.Visible = false;
btnHFOK.Visible = false;
}
if (!string.IsNullOrEmpty(wangYinZhangHaoValue[1]))
{
txtHF_Repay.Text = wangYinZhangHaoValue[1];
txtHF_Repay.Enabled = true;
lbtnHFSign_Repay.Visible = false;
btnHFOK_Repay.Visible = false;
}
hidden_HF.Value = wangYinZhangHaoValue[2];
}
else if (i == 3)
{
//财付通
if (!string.IsNullOrEmpty(wangYinZhangHaoValue[0]))
{
txtCFT.Text = wangYinZhangHaoValue[0];
txtCFT.Enabled = true;
lbtnCFTSign.Visible = false;
btnCFTOK.Visible = false;
}
if (!string.IsNullOrEmpty(wangYinZhangHaoValue[1]))
{
txtCFT_Repay.Text = wangYinZhangHaoValue[1];
txtCFT_Repay.Enabled = true;
lbtnCFTSign_Repay.Visible = false;
btnCFTOK_Repay.Visible = false;
}
hidden_CFT.Value = wangYinZhangHaoValue[2];
}
}
#endregion
if (mCompany.RoleType == 2 || mCompany.RoleType == 3)
{
thid.Visible = true;
tdzfb.Visible = true;
tdkq.Visible = true;
tbhf.Visible = true;
tbcft.Visible = true;
}
else if (mCompany.RoleType == 4)
{
lblShouKuan.Text = "收款账号";
}
else if (mCompany.RoleType == 1)
{
thid.Visible = true;
tdzfb.Visible = true;
tdkq.Visible = true;
tbhf.Visible = true;
tbcft.Visible = true;
lblShouKuan.Text = "手续费收款账号";
}
}
}
else
{
//没有数据 //返回上一页
//tbReceivables.Visible = false;
}
}
catch (Exception)
{
}
}
