/// <summary>
/// 通过指令查询经停城市
/// </summary>
/// <param name="sdate"></param>
/// <param name="flyno"></param>
/// <returns></returns>
private string selStops(string sdate, string flyno, string guid)
{
try
{
flyno = flyno.Replace("*", "");
string dd = DateTime.Parse(sdate).ToString("dd");
string mm = DateTime.Parse(sdate).ToString("MM");
string zhiling = "FF:" + flyno + "/" + dd + strValue(mm);
//格式化编码内容类
PnrAnalysis.FormatPNR pnrformat = new PnrAnalysis.FormatPNR();
string strVale = string.Empty;
ParamEx pe = new ParamEx();
pe.UsePIDChannel = this.KongZhiXiTong != null && this.KongZhiXiTong.Contains("|48|") ? 2 : 0;
SendInsManage SendManage = new SendInsManage(mUser.LoginName, mCompany.UninCode, pe, this.configparam);
string Office = this.configparam.Office.Split('^')[0];
strVale = SendManage.Send(zhiling, ref Office, 9);
string msg = "";
LegStop ls = pnrformat.GetStop(strVale, out msg);
if (msg == "")
{
strVale = strReturn(ls);
}
return(strVale + "|" + guid);
}
catch (Exception ex)
{
return("");
}
}
/// <summary>
/// 分离或者取消编码
/// </summary>
/// <returns></returns>
private string PnrHandle(Tb_Ticket_Order Order, SendInsManage SendIns, StringBuilder sbLog, List <HashObject> selList, int INFCount)
{
string ErrMsg = "";
try
{
if (Order != null && Order.PNR != "" && Order.PNR.Trim().Length == 6)
{
PnrAnalysis.PnrModel pnrMode = SendIns.GetPnr(Order.PNR.Trim(), out ErrMsg);
if (pnrMode != null)
{
if (ErrMsg.Contains("授权"))
{
string[] strAuthArr = ErrMsg.Split('#')[1].Split('|');
ErrMsg = "";
foreach (string item in strAuthArr)
{
ErrMsg += "RMK TJ AUTH " + item + "<br/>";
}
ErrMsg = "需要授权,授权指令:<br />" + ErrMsg;
sbLog.Append("提取编码信息失败," + ErrMsg);
}
else
{
if (!pnrMode.PnrStatus.Contains("XX"))
{
if (pnrMode.PnrStatus.Contains("NO"))
{
ErrMsg = "编码（" + Order.PNR + "）状态为NO，系统取消编码失败！";
sbLog.Append(ErrMsg);
}
else if (pnrMode.PnrStatus.Contains("RR"))
{
ErrMsg = "编码（" + Order.PNR + "）状态为RR，该编码已出票，不能取消！";
sbLog.Append(ErrMsg);
}
else
{
string TicketNumber = "";
string Cmd = "", Office = "", RecvData = "";
//用于分离编码的乘客姓名 不含婴儿
List <string> pnameList = new List <string>();
//循环选择的乘机人
foreach (HashObject hashParam in selList)
{
if (hashParam["pasPType"].ToString() != "3")
{
pnameList.Add(hashParam["pasName"].ToString());
}
TicketNumber = hashParam["pasTicketNum"].ToString();
if (TicketNumber != "" && !KongZhiXiTong.Contains("|69|"))
{
Office = hashParam["office"].ToString();
Cmd = "DETR:TN/" + TicketNumber;
RecvData = SendIns.Send(Cmd, ref Office, 0);
if (!RecvData.Contains("OPEN FOR USE"))
{
ErrMsg = "票号（" + TicketNumber + "）状态异常，不能提交申请！";
sbLog.Append(ErrMsg);
break;
}
}
}
//没有出错时
if (ErrMsg == "")
{
if (INFCount > 0)
{
//编码状态不是已经出票的PNR
if (pnrMode != null && !pnrMode.PnrStatus.Contains("RR"))
{
//有婴儿直接提交
SendIns.CancelPnr(Order.PNR, Order.Office);
}
}
else
{
//编码状态不是已经出票的PNR
if (pnrMode != null)
{
if (!pnrMode.PnrStatus.Contains("RR"))
{
//取消编码
if (SendIns.CancelPnr(Order.PNR, Order.Office))
{
ErrMsg = "";
}
else
{
ErrMsg = "取消编码(" + Order.PNR + ")失败！";
}
}
else
{
ErrMsg = "编码状态为RR的编码,不能取消！";
}
}
}
}
}
}
}
}
else
{
sbLog.Append("提取编码信息失败，系统取消编码失败！");
}
}
else
{
sbLog.Append("订单不存在！");
}
}
catch (Exception ex)
{
ErrMsg = ex.Message;
}
finally
{
}
return(ErrMsg);
}
/// <summary>
/// 票号状态是否为Open for Use 状态 true为Open for Use 否则不是
/// </summary>
/// <param name="TicketNumber"></param>
/// <param name="Office"></param>
/// <returns></returns>
private bool PassengerTicketIsOpen(List <HashObject> pasList, List <HashObject> skyList, SendInsManage SendIns, out string errMsg)
{
bool IsOpen = false;
errMsg = "";
//第一航段
HashObject skyParam = skyList[0];
StringBuilder sbLog = new StringBuilder();
//格式化pnr类
PnrAnalysis.FormatPNR format = new PnrAnalysis.FormatPNR();
string TicketNumber = "", Office = "", Status = "", PassengerName = "", FlyDate = "";
bool IsSuc = false;
if (pasList != null && pasList.Count > 0)
{
foreach (HashObject param in pasList)
{
if (param.Count == 9 && param["IsChecked"].ToString() == "1")
{
PassengerName = param["pasName"].ToString().Trim(); //乘机人姓名
TicketNumber = param["pasTicketNum"].ToString().Trim(); //票号
Office = param["office"].ToString().Trim(); //Office
FlyDate = skyParam["FromDate"].ToString().Trim(); //乘机日期
if (TicketNumber == "")
{
continue;
}
//提取票号信息指令组合
string strInstruction = string.Format("DETR:TN/{0}", TicketNumber);
//发送指令
string recvData = SendIns.Send(strInstruction, ref Office, 0);
if ((recvData.ToUpper().Contains("NOT EXIST") || recvData.ToUpper().Contains("TICKET NUMBER") || recvData.ToUpper().Contains("NOT FOUND") || recvData.ToUpper().Contains("AUTHORITY") || recvData.ToUpper().Contains("没有权限")) && FlyDate != "")
{
//检查乘机日期
DateTime dt1 = System.DateTime.Parse("1901-01-01");
DateTime.TryParse(FlyDate, out dt1);
if (DateTime.Compare(dt1, System.DateTime.Now) < 0)
{
//乘机日期已过期 不能提交
IsSuc = true;
sbLog.AppendFormat("乘机人{0}票号{1}乘机日期已过期,不能提交申请退废票！", PassengerName, TicketNumber);
break;
}
else
{
continue;
}
}
//票号状态
Status = format.GetTicketStatus(recvData);
if (Status.ToUpper() != "OPEN FOR USE")
{
IsSuc = true;
if (Status == "")
{
sbLog.AppendFormat("乘机人{0}票号{1}为无效票号,不能提交申请退废票！", PassengerName, TicketNumber);
}
else
{
sbLog.AppendFormat("乘机人{0}票号（{1}）状态为{2},不能提交申请退废票！", PassengerName, TicketNumber, Status);
}
break;
}
}
}
if (!IsSuc)
{
IsOpen = true;
}
errMsg = sbLog.ToString();
}
return(IsOpen);
}
/// <summary>
/// 该乘机人票号 提示对应的行程单是否作废
/// </summary>
/// <param name="pas"></param>
/// <returns></returns>
private bool TripIsVoid(UserLoginInfo userInfo, List <HashObject> strList, SendInsManage SendIns, out string msg)
{
bool Isvoid = true;
msg = "";
try
{
StringBuilder sbLog = new StringBuilder();
string[] OfficeNum = userInfo.Configparam.Office.Split(new string[] { "|", " ", "/", ",", "，", "\\", "#" }, StringSplitOptions.RemoveEmptyEntries);
foreach (HashObject param in strList)
{
if (param.Count == 9 && param["IsChecked"].ToString() == "1")
{
string PasName = param["pasName"].ToString().Trim(); //乘机人姓名
string PasA8 = param["pasTravelNumber"].ToString().Trim(); //行程单号
string PasTicketNumber = param["pasTicketNum"].ToString().Trim(); //票号
//if (PasA8 != "")
//{
//Office
string office = param["office"].ToString().Trim();
//真实状态
string strInstruction = string.Format("DETR:TN/{0},F", PasTicketNumber);
string recvData = SendIns.Send(strInstruction, ref office, 0);
List <string> lst = new List <string>();
lst.AddRange(new string[] {
"没有权限",
"NOT EXIST",
"TICKET NUMBER",
"NOT FOUND",
"NO RECORD",
"超时",
"无法从传输连接中读取数据"
});
bool isContain = false;
foreach (string item in lst)
{
if (recvData.ToUpper().Contains(item))
{
isContain = true;
break;
}
}
if (recvData != "" && !isContain && recvData.ToUpper().Contains("RP" + PasA8))
{
Isvoid = false;
sbLog.AppendFormat("乘机人:{0} 票号{1}所关联的行程单号未作废<br />请先作废行程单后再操作！", PasName, PasTicketNumber);
}
else
{
if (recvData.Contains("授权"))
{
Isvoid = false;
sbLog.AppendFormat("乘机人:{0} 票号{1}验证行程单状态失败,需授权,授权指令:RMK TJ AUTH " + (office == "" ? OfficeNum[0] : office.Trim(new char[] { '$' })), PasName, PasTicketNumber);
}
}
// }
}
}
msg = sbLog.ToString();
}
catch (Exception)
{
}
return(Isvoid);
}
/// <summary>
/// 确认订单
/// </summary>
/// <param name="writer"></param>
/// <param name="parames"></param>
public override void Create(ResponseWriter writer, System.Collections.Specialized.NameValueCollection parames)
{
var userLogin = AuthLogin.GetUserInfo(Username);
string adultOrderId = parames["adultOrderId"];
string childOrderId = parames["childOrderId"];
string adultPolicyGuid = parames["adultPolicyGuid"]; //成人政策guid
string childPolicyGuid = parames["childPolicyGuid"]; //婴儿政策guid
string remark = parames["remark"];
var adultPolicy = PolicyCacheManager.Get(adultPolicyGuid) as PolicyParamForAPI;
var childPolicy = PolicyCacheManager.Get(childPolicyGuid) as PolicyParamForAPI;
OrderInputParam InputParam = createOrderInputParam(adultOrderId, childOrderId);
Tb_Ticket_OrderBLL orderBLL = new Tb_Ticket_OrderBLL();
if (adultPolicy == null)
{
writer.WriteEx(554, "Cache is disabled", "政策缓存已失效，请重新操作");
}
else
{
#region 更新订单 主要修改价格,政策和添加订单账单明细
Bill bill = new Bill();
Data d = new Data(userLogin.Company.UninCode);//采购佣金进舍规则: 0.舍去佣金保留到元、1.舍去佣金保留到角、2.舍去佣金保留到分
string ErrMsg = "";
bool IsSuc = false;
//扩展参数
ParamEx pe = new ParamEx();
pe.UsePIDChannel = userLogin.FQP.KongZhiXiTong != null && userLogin.FQP.KongZhiXiTong.Contains("|48|") ? 2 : 0;
//发送指令管理类
SendInsManage SendIns = new SendInsManage(userLogin.User.LoginName, userLogin.Company.UninCode, pe, userLogin.Configparam);
//提示
StringBuilder sbTip = new StringBuilder();
try
{
AjaxPolicyMatchOutData APM = new AjaxPolicyMatchOutData();
APM.OutPutPolicyList.Add(adultPolicy);
APM.OutPutPolicyList.Add(childPolicy);
//供应商Office
string GYOffice = userLogin.Configparam != null?userLogin.Configparam.Office.ToUpper() : "";
if (InputParam != null && APM != null && APM.OutPutPolicyList != null && APM.OutPutPolicyList.Count > 0)
{
AjAxPolicyParam AdultPolicy = adultPolicy;
AjAxPolicyParam ChildPolicy = childPolicy;
//至少选择一条政策 成人或者儿童
if (AdultPolicy == null && ChildPolicy == null)
{
writer.WriteEx(567, "choose one policy at least", "请选择一条政策数据");
}
else
{
PatInfo INFPrice = null;
if (HasBaby(InputParam))
{
//婴儿价格
INFPrice = GetINFPAT();
}
//订单实体需要更改数据的字段名
List <string> UpdateOrderFileds = new List <string>();
//订单修改字段
UpdateOrderFileds.AddRange(new string[] { "OldRerurnMoney", "OldPolicyPoint", "OutOrderPayMoney", "A7", "A13", "A1", "A11", "PrintOffice", "CPCpyNo", "YDRemark", "PolicyId", "AirPoint", "PolicyPoint", "ReturnPoint", "PolicyMoney", "PolicyCancelTime", "PolicyReturnTime",
"DiscountDetail", "PolicyType", "PolicySource", "AutoPrintFlag", "PolicyRemark", "PMFee", "ABFee", "FuelFee", "BabyFee", "PayMoney", "OrderMoney" });
//航段实体需要更改数据的字段名
List <string> UpdateSkyWayFileds = new List <string>();
//航段修改字段
UpdateSkyWayFileds.AddRange(new string[] { "SpacePrice", "ABFee", "FuelFee", "Discount" });
//乘客实体需要更改数据的字段名
List <string> UpdatePasFileds = new List <string>();
//修改乘机人
UpdatePasFileds.AddRange(new string[] { "PMFee", "ABFee", "FuelFee" });
//承运人二字码
string CarrayCode = string.Empty;
string orderIDs = "";
//婴儿与编码中的婴儿个数是否不一致 true不一致 false一致
bool IsINFCheck = false;
//婴儿与编码中的婴儿个数是否不一致提示
string INFCountCheckMsg = "<b class=\"red\">编码中婴儿个数与预订婴儿个数不一致，请手动补全编码中婴儿！</b>";
//Bill返回有无SQL
bool IsBillOK = false;
//修改实体相关的值后更新即可
for (int i = 0; i < InputParam.OrderParamModel.Count; i++)
{
OrderMustParamModel item = InputParam.OrderParamModel[i];
//承运人二字码
CarrayCode = item.Order.CarryCode.Split('/')[0].ToUpper().Trim();
if (orderIDs.Contains(item.Order.OrderId))
{
continue;
}
else
{
orderIDs += item.Order.OrderId + "|";
}
#region 设置需要更改数据的字段名集合
item.UpdateOrderFileds = UpdateOrderFileds;
item.UpdateSkyWayFileds = UpdateSkyWayFileds;
item.UpdatePassengerFileds = UpdatePasFileds;
#endregion
#region 实体处理
//订单中的总价
decimal TotalPMPrice = 0m, TotalABFare = 0, TotalRQFare = 0m;
//item.Order.YDRemark = remark;
//预订备注信息
item.Order.YDRemark = remark;
//订单处理 成人订单政策
if (!item.Order.IsChdFlag && AdultPolicy != null)
{
#region 成人或者婴儿实体价格赋值
//检测白屏预订婴儿个数与编码中的婴儿个数
if (item.Order.OrderSourceType == 1 || item.Order.OrderSourceType == 5)
{
IsINFCheck = yudingINFCheck(InputParam.PnrInfo, item.PasList);
}
//婴儿价格
decimal INFPMFee = 0m, INFABFare = 0m, INFRQFare = 0m;
if (INFPrice != null)
{
decimal.TryParse(INFPrice.Fare, out INFPMFee);
decimal.TryParse(INFPrice.TAX, out INFABFare);
decimal.TryParse(INFPrice.RQFare, out INFRQFare);
}
//成人价格
decimal PMFee = AdultPolicy.SeatPrice, ABFare = AdultPolicy.ABFare, RQFare = AdultPolicy.RQFare;
#region 特价缓存处理
//特价时特价缓存处理 为特价且PAT内容不为空
if (AdultPolicy.PolicyKind == 2 && item.SkyList[0].Pat.Trim() != "")
{
//白屏和PNR导入
if (item.Order.OrderSourceType == 1 || item.Order.OrderSourceType == 2 || item.Order.OrderSourceType == 6 || item.Order.OrderSourceType == 10)
{
//特价缓存
SpecialCabinPriceInfoBLL SpBll = new SpecialCabinPriceInfoBLL();
PnrAnalysis.FormatPNR pnrformat = new PnrAnalysis.FormatPNR();
string errMsg = "";
PnrAnalysis.PatModel Pat = pnrformat.GetPATInfo(item.SkyList[0].Pat.Trim(), out errMsg);
if (Pat.UninuePatList.Count > 0)
{
decimal m_Fare = 0m;
decimal m_TAX = 0m;
decimal m_RQFare = 0m;
decimal.TryParse(Pat.UninuePatList[0].Fare, out m_Fare);
decimal.TryParse(Pat.UninuePatList[0].TAX, out m_TAX);
decimal.TryParse(Pat.UninuePatList[0].RQFare, out m_RQFare);
//价格不相等
if (m_Fare != PMFee)
{
//存入缓存
SpBll.SaveSpPrice(item.SkyList[0].CarryCode.ToUpper(), item.SkyList[0].FlightCode, item.SkyList[0].FromDate, item.SkyList[0].FromCityCode, item.SkyList[0].ToCityCode, item.SkyList[0].Space, m_Fare, m_TAX, m_RQFare);
}
}
}
}
#endregion
//乘机人实体处理
for (int j = 0; j < item.PasList.Count; j++)
{
if (item.PasList[j].PassengerType == 1)
{
//成人
item.PasList[j].PMFee = PMFee;
item.PasList[j].ABFee = ABFare;
item.PasList[j].FuelFee = RQFare;
}
else
{
//婴儿
if (item.PasList[j].PassengerType == 3 && INFPrice != null)
{
item.PasList[j].PMFee = INFPMFee;
item.PasList[j].ABFee = INFABFare;
item.PasList[j].FuelFee = INFRQFare;
}
}
if (item.PasList[j].PassengerType == 1 || item.PasList[j].PassengerType == 3)
{
//订单价格
TotalPMPrice += item.PasList[j].PMFee;
TotalABFare += item.PasList[j].ABFee;
TotalRQFare += item.PasList[j].FuelFee;
}
}
//航段实体处理
//string Discount = "0";
for (int k = 0; k < item.SkyList.Count; k++)
{
item.SkyList[k].ABFee = ABFare;
item.SkyList[k].FuelFee = RQFare;
//只是单程才重新赋值
if (item.SkyList.Count == 1)
{
item.SkyList[k].SpacePrice = PMFee;
}
//item.SkyList[k].Discount = AdultPolicy.DiscountRate.ToString();
//if (Discount.Length > 10)
//{
// Discount = Discount.Substring(0, 10);
//}
//item.SkyList[k].Discount = Discount;
}
//成人订单(含有婴儿) 赋值
item.Order.PMFee = TotalPMPrice;
item.Order.ABFee = TotalABFare;
item.Order.FuelFee = TotalRQFare;
if (INFPrice != null)
{
//婴儿票面价
item.Order.BabyFee = INFPMFee;
}
item.Order.PolicyId = AdultPolicy.PolicyId;
item.Order.PolicyPoint = AdultPolicy.PolicyPoint;
item.Order.ReturnMoney = AdultPolicy.PolicyReturnMoney;
item.Order.AirPoint = AdultPolicy.AirPoint;
item.Order.ReturnPoint = AdultPolicy.ReturnPoint;
item.Order.LaterPoint = AdultPolicy.LaterPoint;
item.Order.PolicyMoney = AdultPolicy.PolicyYongJin;
item.Order.DiscountDetail = AdultPolicy.DiscountDetail;
item.Order.PolicyType = int.Parse(AdultPolicy.PolicyType);
item.Order.PolicySource = int.Parse(AdultPolicy.PolicySource);
item.Order.AutoPrintFlag = int.Parse(AdultPolicy.AutoPrintFlag);
item.Order.PolicyCancelTime = AdultPolicy.FPGQTime;
item.Order.PolicyReturnTime = AdultPolicy.PolicyReturnTime;
//出票公司编号
string CPCpyNo = string.IsNullOrEmpty(AdultPolicy.CPCpyNo) ? userLogin.mSupCompany.UninCode : AdultPolicy.CPCpyNo;
item.Order.CPCpyNo = CPCpyNo.Length > 12 ? CPCpyNo.Substring(0, 12) : CPCpyNo;
item.Order.PolicyRemark = AdultPolicy.PolicyRemark;//政策备注
//原始政策返点
item.Order.OldPolicyPoint = AdultPolicy.OldPolicyPoint;
//原始政策现返
item.Order.OldReturnMoney = AdultPolicy.OldPolicyReturnMoney;
item.Order.A1 = 1; //已确认
item.Order.A2 = AdultPolicy.PolicyKind; //政策种类
item.Order.A7 = AdultPolicy.AirPoint; //航空公司返点
item.Order.A11 = AdultPolicy.PatchPonit; //补点
////计算订单金额
//item.Order.PayMoney = d.CreateOrderPayMoney(item.Order, item.PasList);
////出票方收款金额
//item.Order.OrderMoney = d.CreateOrderOrderMoney(item.Order, item.PasList);
bill.CreateOrderAndTicketPayDetailNew(item.Order, item.PasList);
//出票Office
if (AdultPolicy.PolicyOffice != "")
{
item.Order.PrintOffice = AdultPolicy.PolicyOffice;
}
if ((item.Order.OrderSourceType == 1 || item.Order.OrderSourceType == 2))
{
//自动授权Office
if (AdultPolicy.PolicyOffice.Trim().Length == 6 && !GYOffice.Contains(AdultPolicy.PolicyOffice.Trim().ToUpper()))
{
SendIns.AuthToOffice(item.Order.PNR, AdultPolicy.PolicyOffice, item.Order.Office, out ErrMsg);
}
//备注HU的A舱要添加一个指令才能入库，OSI HU CKIN SSAC/S1
if (AdultPolicy.PolicySource == "1" && AdultPolicy.PolicyType == "1" && AdultPolicy.AutoPrintFlag == "2" && item.Order.PNR.Trim().Length == 6 && item.Order.CarryCode.ToUpper().Trim() == "HU" && item.Order.Space.ToUpper().Trim() == "A")
{
string Office = item.Order.Office, Cmd = string.Format("RT{0}|OSI HU CKIN SSAC/S1^\\", item.Order.PNR.Trim());
SendIns.Send(Cmd, ref Office, 10);
}
}
if (item.Order.PolicySource <= 2)
{
//本地政策提示
sbTip.Append("</br><ul><li>1.请于一小时内支付此订单,未支付将自动取消</li><li>2.编码内容中必须存在证件内容一项</li><li>3.PNR需要包含证件号</li><li>" + (IsINFCheck ? "4." + INFCountCheckMsg : "") + "</li></ul>");
}
else
{
//接口和共享政策提示
if (AdultPolicy.PolicyOffice.Trim().Length == 6)
{
sbTip.Append("</br><ul><li>1.编码内容中必须存在证件内容一项</li><li>2.PNR需要包含证件号</li><li>3.请授权,授权指令：RMK TJ AUTH " + AdultPolicy.PolicyOffice + "</li>" + (IsINFCheck ? "4." + INFCountCheckMsg : "") + "</ul>");
}
else
{
sbTip.Append("<ul ><li>1.编码内容中必须存在证件内容一项!</li><li>2.PNR需要包含证件号!</li>" + (IsINFCheck ? "3." + INFCountCheckMsg : "") + "</ul>");
}
}
#endregion
}
else
{
if (ChildPolicy != null)
{
#region 儿童实体赋值
//儿童订单政策
//儿童价格
decimal PMFee = ChildPolicy.SeatPrice, ABFare = ChildPolicy.ABFare, RQFare = ChildPolicy.RQFare;
//乘机人实体处理
for (int j = 0; j < item.PasList.Count; j++)
{
if (item.PasList[j].PassengerType == 2)
{
//儿童
item.PasList[j].PMFee = PMFee;
item.PasList[j].ABFee = ABFare;
item.PasList[j].FuelFee = RQFare;
//订单价格
TotalPMPrice += item.PasList[j].PMFee;
TotalABFare += item.PasList[j].ABFee;
TotalRQFare += item.PasList[j].FuelFee;
}
}
//航段实体处理
//string Discount = "0";
for (int k = 0; k < item.SkyList.Count; k++)
{
item.SkyList[k].ABFee = ABFare;
item.SkyList[k].FuelFee = RQFare;
//只是单程才重新赋值
if (item.SkyList.Count == 1)
{
item.SkyList[k].SpacePrice = PMFee;
}
//Discount = ChildPolicy.DiscountRate.ToString();
//if (Discount.Length > 10)
//{
// Discount = Discount.Substring(0, 10);
//}
//item.SkyList[k].Discount = Discount;
}
//儿童订单赋值
item.Order.PMFee = TotalPMPrice;
item.Order.ABFee = TotalABFare;
item.Order.FuelFee = TotalRQFare;
//出票公司编号
string CPCpyNo = string.IsNullOrEmpty(ChildPolicy.CPCpyNo) ? userLogin.mSupCompany.UninCode : ChildPolicy.CPCpyNo;
item.Order.CPCpyNo = CPCpyNo.Length > 12 ? CPCpyNo.Substring(0, 12) : CPCpyNo;
item.Order.PolicyId = ChildPolicy.PolicyId;
item.Order.AirPoint = ChildPolicy.AirPoint;
item.Order.PolicyPoint = ChildPolicy.PolicyPoint;
item.Order.ReturnPoint = ChildPolicy.ReturnPoint;
item.Order.LaterPoint = ChildPolicy.LaterPoint;
item.Order.ReturnMoney = ChildPolicy.PolicyReturnMoney;
item.Order.PolicyMoney = ChildPolicy.PolicyYongJin;
item.Order.DiscountDetail = ChildPolicy.DiscountDetail;
item.Order.PolicyType = int.Parse(ChildPolicy.PolicyType);
item.Order.PolicySource = int.Parse(ChildPolicy.PolicySource);
item.Order.AutoPrintFlag = int.Parse(ChildPolicy.AutoPrintFlag);
item.Order.PolicyCancelTime = ChildPolicy.FPGQTime;
item.Order.PolicyReturnTime = ChildPolicy.PolicyReturnTime;
item.Order.PolicyRemark = ChildPolicy.PolicyRemark;//政策备注
//原始政策返点
item.Order.OldPolicyPoint = ChildPolicy.OldPolicyPoint;
//原始政策现返
item.Order.OldReturnMoney = ChildPolicy.OldPolicyReturnMoney;
item.Order.A1 = 1; //已确认
item.Order.A7 = ChildPolicy.AirPoint; //航空公司返点
//政策种类
item.Order.A2 = ChildPolicy.PolicyKind;
////计算订单金额;
//item.Order.PayMoney = d.CreateOrderPayMoney(item.Order, item.PasList);
////出票方收款金额
//item.Order.OrderMoney = d.CreateOrderOrderMoney(item.Order, item.PasList);
bill.CreateOrderAndTicketPayDetailNew(item.Order, item.PasList);
//出票Office
if (ChildPolicy.PolicyOffice != "")
{
item.Order.PrintOffice = ChildPolicy.PolicyOffice;
}
//---------------------------------------
#endregion
}
}
//代付返点，金额
if (item.Order.PolicySource > 2)
{
// 接口 取原始政策
item.Order.A7 = item.Order.OldPolicyPoint;
item.Order.OutOrderPayMoney = d.CreateOrderIntfacePrice(item.Order, item.PasList);
}
else
{
//本地 取航空公司政策
decimal tempOldPolicyPoint = item.Order.OldPolicyPoint;
item.Order.OldPolicyPoint = item.Order.A7;
item.Order.OutOrderPayMoney = d.CreateOrderIntfacePrice(item.Order, item.PasList);
item.Order.OldPolicyPoint = tempOldPolicyPoint;
}
item.Order.A13 = d.CreateOrderIntfacePrice(item.Order, item.PasList);// 后返金额
#endregion
#region 添加订单账单明细sql
List <string> sqlList = bill.CreateOrderAndTicketPayDetailNew(item.Order, item.PasList);
if (sqlList != null && sqlList.Count > 0)
{
IsBillOK = true;
InputParam.ExecSQLList.AddRange(sqlList.ToArray());
}
#endregion
}//For结束
//订单金额是否有误
bool IsOrderPayZero = false;
foreach (OrderMustParamModel item in InputParam.OrderParamModel)
{
//判断金额是否正确
if (item.Order.PayMoney <= 0 || ((item.Order.PayMoney + item.Order.PayMoney * 0.003M) < item.Order.OrderMoney))
{
IsOrderPayZero = true;
PbProject.WebCommon.Log.Log.RecordLog("OrderServices", "PayMoneyError|" + ErrMsg + "订单：PayMoney=" + item.Order.PayMoney + " OrderMoney=" + item.Order.OrderMoney + "SQL:" + string.Join("\r\n ", InputParam.ExecSQLList.ToArray()), true, HttpContext.Current.Request);
// DataBase.LogCommon.Log.Error("OrderServices", new Exception(ErrMsg + "订单：PayMoney=" + item.Order.PayMoney + " OrderMoney=" + item.Order.OrderMoney + "SQL:" + string.Join("\r\n ", InputParam.ExecSQLList.ToArray())));
break;
}
}
#region 验证和修改订单
if (!IsBillOK)
{
ErrMsg = "订单生成失败！！";
PbProject.WebCommon.Log.Log.RecordLog("OrderServices", "时间:" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\t" + ErrMsg + "SQL:" + string.Join("\r\n ", InputParam.ExecSQLList.ToArray()), true, HttpContext.Current.Request);
}
else
{
if (!IsOrderPayZero)
{
//修改订单有关实体信息
IsSuc = orderBLL.UpdateOrder(ref InputParam, out ErrMsg);
if (IsSuc)
{
ErrMsg = "订单生成成功！" + sbTip.ToString();
}
else
{
PbProject.WebCommon.Log.Log.RecordLog("OrderServices", "时间:" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\t" + ErrMsg + "SQL:" + string.Join("\r\n ", InputParam.ExecSQLList.ToArray()), true, HttpContext.Current.Request);
ErrMsg = "订单生成失败！";
}
}
else
{
PbProject.WebCommon.Log.Log.RecordLog("OrderServices", "时间:" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\t" + ErrMsg + "SQL:" + string.Join("\r\n ", InputParam.ExecSQLList.ToArray()), true, HttpContext.Current.Request);
ErrMsg = "订单金额错误,生成订单失败！";
}
}
#endregion
}
}
else
{
ErrMsg = "未获取到政策数据，生成订单失败！";
}
}
catch (Exception ex)
{
PbProject.WebCommon.Log.Log.RecordLog("OrderServices", "时间:" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\t" + ErrMsg, true, HttpContext.Current.Request);
ErrMsg = "订单生成异常," + ex.Message;
DataBase.LogCommon.Log.Error("OrderServices" + userLogin.User.id.ToString(), ex);
}
finally
{
if (IsSuc)
{
writer.Write("ok");
}
else
{
writer.WriteEx(567, "confirm Order Error", ErrMsg);
}
}
#endregion
}
}
/// <summary>
/// 返回数据
/// </summary>
/// <param name="fromcity">起飞城市三字码</param>
/// <param name="tocity">抵达城市三字码</param>
/// <param name="totime">起飞时间</param>
/// <param name="arrtime">抵达时间</param>
/// <param name="starttime">起飞日期</param>
/// <param name="cw">舱位</param>
/// <param name="aircode">航空公司</param>
/// <param name="aircono">航班号</param>
/// <param name="fd">返点</param>
/// <param name="strYh">现返</param>
/// <param name="hidId">GUID</param>
/// <param name="Fare">固定特价</param>
/// <param name="TAX">基建</param>
/// <param name="RQFare">燃油</param>
/// <param name="isGuding">是否固定特价</param>
/// <param name="Yprice">是否固定特价</param>
private SpecialPrice PlyMatch(UserLoginInfo userInfo, string fromcity, string tocity, string totime, string arrtime, string starttime,
string cw, string aircode, string aircono, string fd, string strYh, string hidId,
string Fare, string TAX, string RQFare, bool isGuding, string Yprice
)
{
SpecialPrice sp = new SpecialPrice();
try
{
string[] strValue = new string[4];
//非固定特价PATA数据
if (!isGuding)
{
#region pat 数据
// ig|SS MU747/X/30NOV/KMGSHANN1/0730 1025|pat:a&kmg226#1
//发送指令获取
DateTime dt = DateTime.Parse(starttime);
string cmd = "SS " + aircode + aircono + "/" + cw + "/" + dt.ToString("R").Substring(4, 7).Replace(" ", "") + dt.Year.ToString().Substring(2) + "/" + fromcity + tocity + "NN1/" + totime.Replace(":", "") + " " + arrtime.Replace(":", "") + "|pat:a";
string zhiling = cmd;
string strVale = string.Empty;
//---------修改部分----------
if (userInfo.Configparam != null)
{
//开启使用特价缓存 true 开启 false关闭
bool IsUseSpCache = userInfo.FQP.KongZhiXiTong != null && userInfo.FQP.KongZhiXiTong.Contains("|99|");
//特价缓存
SpecialCabinPriceInfoBLL SpBll = new SpecialCabinPriceInfoBLL();
Tb_SpecialCabin_PriceInfo PriceInfo = null;
if (IsUseSpCache)
{
SpBll.GetSpPrice(aircode, aircono, DateTime.Parse(starttime + " " + totime + ":00"), fromcity, tocity, cw);
}
if (PriceInfo == null)
{
//格式化编码内容类
PnrAnalysis.FormatPNR pnrformat = new PnrAnalysis.FormatPNR();
//扩展参数
ParamEx pe = new ParamEx();
pe.UsePIDChannel = userInfo.FQP.KongZhiXiTong != null && userInfo.FQP.KongZhiXiTong.Contains("|48|") ? 2 : 0;
SendInsManage SendManage = new SendInsManage(userInfo.User.LoginName, userInfo.Company.UninCode, pe, userInfo.Configparam);
string Office = userInfo.Configparam.Office.Split('^')[0];
strVale = SendManage.Send(cmd, ref Office, 15);//发送获取特价指令
string error = "";
decimal spFare = 0m, spABFare = 0m, spRQFare = 0m;
//价格实体
PnrAnalysis.PatModel Pat = pnrformat.GetPATInfo(strVale, out error);
if (Pat != null && Pat.UninuePatList.Count > 0)
{
strValue[0] = Pat.UninuePatList[0].Fare; //舱位价
strValue[1] = Pat.UninuePatList[0].TAX; //基建
strValue[2] = Pat.UninuePatList[0].RQFare; //燃油
strValue[3] = Pat.UninuePatList[0].Price; //总计(舱位价+基建+燃油)
decimal.TryParse(strValue[0], out spFare);
decimal.TryParse(strValue[1], out spABFare);
decimal.TryParse(strValue[2], out spRQFare);
}
else
{
//-----------------2013-5-6添加----------------------------------------------
//没有PAT出价格 预订一个编码PAT价格后取消PNR 即使编码没有取消 后台程序自动取消
string ErrMsg = "";
if (ConfigIsSet(out ErrMsg))
{
//----------构造航段和乘客---------------
List <Tb_Ticket_Passenger> pList = GetPassengerList();
List <Tb_Ticket_SkyWay> skywaylist = new List <Tb_Ticket_SkyWay>();
Tb_Ticket_SkyWay sky = new Tb_Ticket_SkyWay();
sky.CarryCode = aircode;
sky.FlightCode = aircono;
sky.FromDate = DateTime.Parse(starttime + " " + totime + ":00");
sky.ToDate = DateTime.Parse(starttime + " " + arrtime + ":00");
sky.FromCityCode = fromcity;
sky.ToCityCode = tocity;
sky.Space = cw;
skywaylist.Add(sky);
//-------------------------
//预订编码 获取价格
RePnrObj pnrObj = GetPnrInfo(aircode, pList, skywaylist, out ErrMsg);
string AdultPnr = string.Empty;
Log_Pnr logAdultPnr = null;
//成人预订信息编码记录
if (pnrObj.AdultYudingList.Count > 0)
{
AdultPnr = pnrObj.AdultPnr;
if (string.IsNullOrEmpty(AdultPnr) || AdultPnr.Trim().Length != 6)
{
AdultPnr = "";
}
//记录编码日志
YuDingPnrLog(pnrObj, pnrObj.AdultYudingList.Keys[0], pnrObj.AdultYudingList.Values[0], AdultPnr, pnrObj.Office, out logAdultPnr);
}
if (!string.IsNullOrEmpty(pnrObj.AdultPnr))
{
//取消编码
if (SendManage.CancelPnr(pnrObj.AdultPnr, pnrObj.Office))
{
if (logAdultPnr != null)
{
//修改状态
logAdultPnr.Flag = true;
string tempSql = PbProject.Dal.Mapping.MappingHelper <Log_Pnr> .CreateUpdateModelSql(logAdultPnr, "id");
Manage.ExecuteNonQuerySQLInfo(tempSql);
}
}
}
//获取价格
if (pnrObj.PatModelList != null && pnrObj.PatModelList.Length > 0)
{
Pat = pnrObj.PatModelList[0];
if (Pat != null && Pat.UninuePatList.Count > 0)
{
strValue[0] = Pat.UninuePatList[0].Fare; //舱位价
strValue[1] = Pat.UninuePatList[0].TAX; //基建
strValue[2] = Pat.UninuePatList[0].RQFare; //燃油
strValue[3] = Pat.UninuePatList[0].Price; //总计(舱位价+基建+燃油)
decimal.TryParse(strValue[0], out spFare);
decimal.TryParse(strValue[1], out spABFare);
decimal.TryParse(strValue[2], out spRQFare);
}
}
}
//---------------------------------------------------------------
}
if (spFare != 0m)
{
//存入缓存
SpBll.SaveSpPrice(aircode.ToUpper(), aircono, DateTime.Parse(starttime + " " + totime + ":00"), fromcity, tocity, cw, spFare, spABFare, spRQFare);
}
}
else
{
strValue[0] = PriceInfo.SpPrice.ToString(); //舱位价
strValue[1] = PriceInfo.SpABFare.ToString(); //基建
strValue[2] = PriceInfo.SpRQFare.ToString(); //燃油
strValue[3] = (PriceInfo.SpPrice + PriceInfo.SpABFare + PriceInfo.SpRQFare).ToString();
}
}
#endregion
}
else
{
strValue[0] = Fare; //舱位价
strValue[1] = TAX; //基建
strValue[2] = RQFare; //燃油
strValue[3] = (decimal.Parse(Fare) + decimal.Parse(TAX) + decimal.Parse(RQFare)).ToString();
}
//实付金额
string sjvalue = new PbProject.Logic.Pay.Data(userInfo.Company.UninCode).CreatePassengerPayFee(decimal.Parse(strValue[0]), decimal.Parse(strValue[1]), decimal.Parse(strValue[2]), decimal.Parse(fd), decimal.Parse(strYh), 1).ToString();
string pyj = new PbProject.Logic.Pay.Data(userInfo.Company.UninCode).CreateCommissionCG(decimal.Parse(strValue[0]), decimal.Parse(fd)).ToString();
string ZK = "";
if (Yprice != "0")//如果传的有Y舱价格,则是特价类型的,则计算折扣
{
PbProject.Logic.Pay.DataAction plpd = new PbProject.Logic.Pay.DataAction();
//特价时候需要计算折扣,让前台计算加入哪一个折扣范围
decimal tempFare = 0;
decimal.TryParse(strValue[0], out tempFare);
decimal tempYprice = 0;
decimal.TryParse(Yprice, out tempYprice);
//计算特价的折扣
ZK = (new PbProject.Logic.Pay.DataAction().FourToFiveNum((tempFare / tempYprice), 4) * 100).ToString("f2");
decimal tempZK = 0;
decimal.TryParse(ZK, out tempZK);
ZK = plpd.FourToFiveNum(tempZK, 0).ToString();
}
if (strValue[0] != "" || strValue[1] != "" || strValue[2] != "" || strValue[3] != "")
{
decimal tempPrice = 0;
decimal.TryParse(strValue[0], out tempPrice);
#region pat 有数据
sp.SpacePrice = tempPrice.ToString("f0");
sp.Tax = strValue[1];
sp.RQFare = strValue[2];
sp.TotalPrice = strValue[3];
sp.RealPayPrice = sjvalue;
sp.Commission = pyj;
sp.GUID = hidId;
sp.Discount = ZK;
#endregion
}
else
{
#region pat 没有数据
#endregion pat 出来没有数据
}
//最终sb格式 0舱位价@1基建@2燃油@3总计(舱位价+基建+燃油)@4实付金额@5佣金@6guid@7特价计算的折扣
return(sp);
//Response.Write("");
}
catch (Exception ex)
{
return(sp);
}
}