/// <summary>
/// 保存指令信息到数据库
/// </summary>
/// <returns></returns>
public bool SaveInsInfo(RePnrObj PnrInfo, User_Employees m_user, User_Company m_company)
{
bool IsSuc = true;
string errMsg = "";
try
{
List <string> sqlList = new List <string>();
if (PnrInfo != null && PnrInfo.InsList.Count > 0)
{
//一组指令ID
string GroupID = System.DateTime.Now.Ticks.ToString();
DateTime _sendtime = Convert.ToDateTime("1900-01-01");
DateTime _recvtime = Convert.ToDateTime("1900-01-01");
string UserAccount = userInfo.User.LoginName, CpyNo = userInfo.Company.UninCode, serverIPPort = PnrInfo.ServerIP + ":" + PnrInfo.ServerPort, Office = PnrInfo.Office;
string[] strArr = null;
List <string> Removelist = new List <string>();
Removelist.Add("id");
foreach (KeyValuePair <string, string> KV in PnrInfo.InsList)
{
strArr = KV.Key.Split(new string[] { PnrInfo.SplitChar }, StringSplitOptions.None);
if (strArr.Length == 4)
{
Tb_SendInsData ins = new Tb_SendInsData();
ins.SendIns = strArr[0];
if (DateTime.TryParse(strArr[1], out _sendtime))
{
ins.SendTime = _sendtime;
}
if (DateTime.TryParse(strArr[2], out _recvtime))
{
ins.RecvTime = _recvtime;
}
if (strArr[3] != "")
{
ins.Office = strArr[3];
}
ins.RecvData = KV.Value;
ins.Office = Office;
ins.ServerIPAndPort = serverIPPort + "|" + GroupID;
ins.UserAccount = UserAccount;
ins.CpyNo = CpyNo;
ins.SendInsType = 12;//特价指令
sqlList.Add(PbProject.Dal.Mapping.MappingHelper <Tb_SendInsData> .CreateInsertModelSql(ins, Removelist));
}
}
if (sqlList.Count > 0)
{
IsSuc = Manage.ExecuteSqlTran(sqlList, out errMsg);
}
}
}
catch (Exception ex)
{
IsSuc = false;
errMsg = ex.Message + ex.StackTrace.ToString();
PnrAnalysis.LogText.LogWrite("【时间:" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.ff") + " 方法:SaveInsInfo】================================================================\r\n 异常信息:" + errMsg + "\r\n", "SpPatAjax");
}
return(IsSuc);
}
/// <summary>
/// 记录指令到数据库
/// </summary>
/// <param name="sendins"></param>
/// <returns></returns>
public static bool LogData(Tb_SendInsData sendins)
{
bool Insert = false;
try
{
if (sendins != null)
{
List <string> sqlList = new List <string>();
List <string> Removelist = new List <string>();
Removelist.Add("id");
sqlList.Add(PbProject.Dal.Mapping.MappingHelper <Tb_SendInsData> .CreateInsertModelSql(sendins, Removelist));
if (sqlList.Count > 0)
{
string errMsg = "";
Insert = Manage.ExecuteSqlTran(sqlList, out errMsg);
}
}
}
catch (Exception)
{
}
return(Insert);
}
/* BSP常见错误信息
* MRT:HT0LYJ IGNORED
* INCOMPLETE PNR/FN
* PLEASE CHECK TKT ELEMENT
* CHECK BLINK CODE
* ELE NBR
*/
/// <summary>
/// BSP订单处理
/// </summary>
/// <param name="Order"></param>
private void BspHandle(Tb_Ticket_Order Order, List <ListParam> LPList, BSPShowLog Log)
{ //订单日志
StringBuilder sbLog = new StringBuilder();
if (Order != null)
{
//订单出票公司信息
ListParam TicketLP = LPList.Find(delegate(ListParam _tempLP)
{
return(Order.OwnerCpyNo.Contains(_tempLP.CpyNo));
});
//编码解析类
PnrAnalysis.FormatPNR pnrFormat = new PnrAnalysis.FormatPNR();
//判断标识
List <string> NumTickList = new List <string>();
List <string> PTList = null;
List <Tb_Ticket_Passenger> PasList = null;
try
{
Log(0, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "订单号:" + Order.OrderId + "=======================start=====================\r\n");
string GYCpyNo = Order.OwnerCpyNo;
if (GYCpyNo.Length >= 12)
{
GYCpyNo = GYCpyNo.Substring(0, 12);
}
string CarrayCode = Order.CarryCode.Split('/')[0];
Tb_Ticket_PrintOffice PrintOffice = GetPrintOffice(GYCpyNo, CarrayCode);
if (PrintOffice == null || PrintOffice.PrintCode == "")
{
Log(0, string.Format("{0}未设置打票机号,请手动出票!", CarrayCode));
sbLog.Append(string.Format("{0}未设置打票机号,请手动出票!", CarrayCode));
return;
}
//出票Office
string pOffice = string.IsNullOrEmpty(PrintOffice.OfficeCode) ? Order.PrintOffice : PrintOffice.OfficeCode;
string PrintCode = PrintOffice.PrintCode;
string Pnr = Order.PNR;//Pnr编码
if (pOffice == "")
{
Log(0, string.Format("{0}出票Office不能为空！", CarrayCode));
sbLog.Append(string.Format("{0}出票Office不能为空！", CarrayCode));
return;
}
//获取乘客
string sqlWhere = string.Format(" OrderId='{0}' order by PassengerType", Order.OrderId);
Tb_Ticket_Passenger pMode = null;
PasList = Manage.CallMethod("Tb_Ticket_Passenger", "GetList", null, new object[] { sqlWhere }) as List <Tb_Ticket_Passenger>;
if (PasList == null || PasList.Count == 0)
{
Log(0, string.Format("订单号:{0}没有找到对应的乘客信息!", Order.OrderId));
sbLog.Append(string.Format("订单号:{0}没有找到对应的乘客信息!", Order.OrderId));
return;
}
else
{
pMode = PasList[0];
}
List <Bd_Base_Parameters> baseParamList = Manage.CallMethod("Bd_Base_Parameters", "GetList", null, new Object[] { "CpyNo='" + GYCpyNo + "'" }) as List <Bd_Base_Parameters>;
ConfigParam config = Bd_Base_ParametersBLL.GetConfigParam(baseParamList);
//指令管理类
//SendInsManage SendManage = new SendInsManage(Order.OwnerCpyNo, GYCpyNo, config);
if (config == null)
{
Log(0, string.Format("订单号{0},公司{1}未设置使用配置信息,请设置！", Order.OrderId, CarrayCode));
sbLog.Append(string.Format("订单号{0},公司{1}未设置使用配置信息,请设置！", Order.OrderId, CarrayCode));
return;
}
if (string.IsNullOrEmpty(Order.PNR))
{
Log(0, string.Format("订单号{0}中没有PNR,请检查！", Order.OrderId));
sbLog.Append(string.Format("订单号{0}中没有PNR,请检查！", Order.OrderId));
return;
}
ParamObject PM = new ParamObject();
PM.ServerIP = config.WhiteScreenIP;
PM.ServerPort = int.Parse(config.WhiteScreenPort);
PM.Office = pOffice;
//发送指令
string SendIns = "RT" + Pnr;
//返回数据
string Recvdata = string.Empty;
PM.code = SendIns;
PM.IsPn = true;
// Recvdata = SendNewPID.SendCommand(PM);
Recvdata = WriteLogDB(PM, TicketLP);
//指令日志
Log(0, string.Format("\r\n【订单号{0}】发送指令>{1}\r\n接收数据:\r\n{2}\r\n", Order.OrderId, SendIns, Recvdata));
//授权检查
if (Recvdata.ToUpper().Contains("授权"))
{
Log(0, string.Format("订单号{0},编码{1} 出票Office{2},发送指令需要授权！", Order.OrderId, Pnr, pOffice));
sbLog.Append(string.Format("订单号{0},编码{1} 出票Office{2},发送指令需要授权！", Order.OrderId, Pnr, pOffice));
return;
}
else if (Recvdata.ToUpper().Contains("CANCELLED"))
{
Log(0, string.Format("订单号{0},编码{1} 出票Office{2},编码已取消，出票失败！", Order.OrderId, Pnr, pOffice));
sbLog.Append(string.Format("订单号{0},编码{1} 出票Office{2},编码已取消，出票失败！", Order.OrderId, Pnr, pOffice));
return;
}
string Msg = "";
string Xe = "", RR = "";
string PnrStatus = pnrFormat.GetPnrStatus(Recvdata, out Msg);
if (PnrStatus.Contains("NO"))
{
Log(0, string.Format("订单号{0},编码{1} 出票Office{2},编码状态为{3},不能自动出票!！", Order.OrderId, Pnr, pOffice, PnrStatus));
sbLog.Append(string.Format("订单号{0},编码{1} 出票Office{2},编码状态为{3},不能自动出票!！", Order.OrderId, Pnr, pOffice, PnrStatus));
return;
}
//存在的票号
PTList = GetTicketNum(Pnr, Recvdata.ToUpper(), pnrFormat);
List <string> RRList = null;
List <string> XEList = null;
if (PTList.Count == 0)
{
Start:
{
//进行出票
HashObject hash = GetNumList(Recvdata);
XEList = hash["XEList"] as List <string>;
RRList = hash["RRList"] as List <string>;
List <string> StartXeList = hash["StartXeList"] as List <string>;
//XE项
if (StartXeList.Count > 0)
{
for (int i = 0; i < StartXeList.Count; i++)
{
string XeStr = StartXeList[i];
if (XeStr != "")
{
//发送指令
SendIns = "RT" + Pnr + "|XE" + XeStr + "|@";
PM.code = SendIns;
PM.IsPn = false;
//Recvdata = SendNewPID.SendCommand(PM);// MRT:JG61M2 IGNORED
Recvdata = WriteLogDB(PM, TicketLP);
//指令日志
Log(0, string.Format("\r\n【订单号{0}】发送指令>{1}\r\n接收数据:\r\n{2}\r\n", Order.OrderId, SendIns, Recvdata));
//判断是否XE成功
if (pnrFormat.INFMarkIsOK(Recvdata, out Msg))
{
/* 3U8881 E TU30APR CTUPEK HK1 0730 1005
* JG61M2 - 航空公司使用自动出票时限, 请检查PNR
*** 预订酒店指令HC, 详情 HC:HELP ***
*/
//发送指令
SendIns = "RT" + Pnr;
PM.code = SendIns;
PM.IsPn = true;
//Recvdata = SendNewPID.SendCommand(PM);
Recvdata = WriteLogDB(PM, TicketLP);
//指令日志
Log(0, string.Format("\r\n【订单号{0}】发送指令>{1}\r\n接收数据:\r\n{2}\r\n", Order.OrderId, SendIns, Recvdata));
goto Start;
}
}
}
}
}
string patPrice = "pat:a";
if (!Order.IsChdFlag)
{
//成人
patPrice = "pat:a";
}
else
{
//儿童
patPrice = "pat:a*ch";
}
//发送指令
SendIns = "RT" + Pnr + "|" + patPrice;
PM.code = SendIns;
PM.IsPn = false;
//Recvdata = SendNewPID.SendCommand(PM);
Recvdata = WriteLogDB(PM, TicketLP);
//指令日志
Log(0, string.Format("\r\n【订单号{0}】发送指令>{1}\r\n接收数据:\r\n{2}\r\n", Order.OrderId, SendIns, Recvdata));
if (Recvdata.IndexOf("PAT") == -1)
{
//发送指令
Log(0, string.Format("订单号{0},编码{1} 出票Office{2},编码已取消，未能PAT出票价,出票失败！", Order.OrderId, Pnr, pOffice));
sbLog.Append(string.Format("订单号{0},编码{1} 出票Office{2},编码已取消，未能PAT出票价,出票失败！", Order.OrderId, Pnr, pOffice));
return;
}
//比较
string xuhao = "", Seat = "", Err = "";
decimal _xsFare = 0m;
bool IsExistParice = false;
PnrAnalysis.PatModel PAT = pnrFormat.GetPATInfo(Recvdata.Replace("\r", ""), out Err);
foreach (PatInfo pat in PAT.UninuePatList)
{
decimal.TryParse(pat.Fare, out _xsFare);
//存在此价格
if (_xsFare == pMode.PMFee)
{
IsExistParice = true;
xuhao = pat.SerialNum;
Seat = pat.SeatGroup;
break;
}
}
if (!IsExistParice)
{
Log(0, string.Format("订单号{0},编码{1} 出票Office{2},舱位价{3}与Pat价格{4}不一致，出票失败！", Order.OrderId, Pnr, pOffice, pMode.PMFee, _xsFare));
sbLog.Append(string.Format("订单号{0},编码{1} 出票Office{2},舱位价{3}与Pat价格{4}不一致，出票失败！", Order.OrderId, Pnr, pOffice, pMode.PMFee, _xsFare));
return;
}
//做价格进去
SendIns = "RT" + Pnr + "|" + patPrice + "|SFC:" + xuhao + "|@";
PM.code = SendIns;
PM.IsPn = false;
//Recvdata = SendNewPID.SendCommand(PM);
Recvdata = WriteLogDB(PM, TicketLP);
//指令日志
Log(0, string.Format("\r\n【订单号{0}】发送指令>{1}\r\n接收数据:\r\n{2}\r\n", Order.OrderId, SendIns, Recvdata));
if (Recvdata.Contains("超时") || Recvdata.Contains("NO PNR"))
{
//Recvdata = SendNewPID.SendCommand(PM);
Recvdata = WriteLogDB(PM, TicketLP);
//指令日志
Log(0, string.Format("\r\n【订单号{0}】发送指令>{1}\r\n接收数据:\r\n{2}\r\n", Order.OrderId, SendIns, Recvdata));
}
//做备注
decimal _Discount = 0m;
if (decimal.TryParse(Order.Discount, out _Discount) && Order.Space.IndexOf("Y") == -1 && Order.Space.IndexOf("C") == -1 && Order.Space.IndexOf("F") == -1 && _Discount < 100)
{
//做价格进去
SendIns = "RT" + Pnr + "|EI:不得签转|@";
PM.code = SendIns;
PM.IsPn = false;
//Recvdata = SendNewPID.SendCommand(PM);
Recvdata = WriteLogDB(PM, TicketLP);
//指令日志
Log(0, string.Format("\r\n【订单号{0}】发送指令>{1}\r\n接收数据:\r\n{2}\r\n", Order.OrderId, SendIns, Recvdata));
if (Recvdata != "" && Recvdata.Contains("超时"))
{
//Recvdata = SendNewPID.SendCommand(PM);
Recvdata = WriteLogDB(PM, TicketLP);
//指令日志
Log(0, string.Format("\r\n【订单号{0}】发送指令>{1}\r\n接收数据:\r\n{2}\r\n", Order.OrderId, SendIns, Recvdata));
}
}
foreach (string item in XEList)
{
if (item != "")
{
Xe += "XE" + item + "|";
}
}
foreach (string item in RRList)
{
if (item != "")
{
RR += item + "RR" + "|";
}
}
if (Xe.Trim(new char[] { '|' }) == "")
{
Xe = "";
}
else
{
Xe = "|" + Xe.Trim('|') + "|";
}
if (RR.Trim(new char[] { '|' }) == "")
{
RR = "";
}
else
{
RR = "|" + RR.Trim('|') + "|";
}
if (RR == "")
{
RR = "|";
}
if (XEList == null || XEList.Count == 0 || Xe == "")
{
Log(0, string.Format("订单号{0},编码{1} 出票Office{2},编码状态为{3},未能取出出票时限!！", Order.OrderId, Pnr, pOffice, PnrStatus));
sbLog.Append(string.Format("订单号{0},编码{1} 出票Office{2},编码状态为{3},未能取出出票时限!！", Order.OrderId, Pnr, pOffice, PnrStatus));
return;
}
//组合打票指令
string etdz = "rt" + Pnr + Xe + RR.TrimEnd('|') + "|ETDZ " + PrintCode;
etdz = etdz.Replace("||", "|");
//出票
SendIns = etdz;
PM.code = SendIns;
PM.IsPn = false;
// Recvdata = SendNewPID.SendCommand(PM);
Recvdata = WriteLogDB(PM, TicketLP);
//指令日志
Log(0, string.Format("\r\n【订单号{0}】发送指令>{1}\r\n接收数据:\r\n{2}\r\n", Order.OrderId, SendIns, Recvdata));
if (Recvdata.Contains("超时") || Recvdata.Contains("NO PNR"))
{
//Recvdata = SendNewPID.SendCommand(PM);
Recvdata = WriteLogDB(PM, TicketLP);
//指令日志
Log(0, string.Format("\r\n【订单号{0}】发送指令>{1}\r\n接收数据:\r\n{2}\r\n", Order.OrderId, SendIns, Recvdata));
}
if (Recvdata.Contains("请输入证件信息"))
{
Log(0, string.Format("订单号{0},编码{1} 出票Office{2},编码状态为{3},编码中没有证件号,请输入证件信息,否则不能出票！", Order.OrderId, Pnr, pOffice, PnrStatus));
sbLog.Append(string.Format("订单号{0},编码{1} 出票Office{2},编码状态为{3},编码中没有证件号,请输入证件信息,否则不能出票！", Order.OrderId, Pnr, pOffice, PnrStatus));
return;
}
if (Recvdata.ToUpper().Contains("STOCK"))
{
Log(0, string.Format("订单号{0},编码{1} 出票Office{2},编码状态为{3}," + Recvdata + "没有票号了！", Order.OrderId, Pnr, pOffice, PnrStatus));
sbLog.Append(string.Format("订单号{0},编码{1} 出票Office{2},编码状态为{3}," + Recvdata + "没有票号了！", Order.OrderId, Pnr, pOffice, PnrStatus));
return;
}
//出票成功
if (Recvdata.Contains("CNY") && Recvdata.ToUpper().Contains(Pnr.ToUpper()))
{
/*CNY2730.00 HF9550
* 876-3250823439 876-3250823441 */
SendIns = "RT" + Pnr;
PM.code = SendIns;
PM.IsPn = true;
//Recvdata = SendNewPID.SendCommand(PM);
Recvdata = WriteLogDB(PM, TicketLP);
//指令日志
Log(0, string.Format("\r\n【订单号{0}】发送指令>{1}\r\n接收数据:\r\n{2}\r\n", Order.OrderId, SendIns, Recvdata));
//存在的票号
PTList = GetTicketNum(Pnr, Recvdata.ToUpper(), pnrFormat);
}
else
{
//出票失败 重试
if (!Recvdata.ToUpper().Contains("**ELECTRONIC TICKET PNR**") &&
Recvdata.ToUpper().Contains("SSR TKNE") &&
Recvdata.ToUpper().Contains("/DPN") &&
Recvdata.ToUpper().Contains("RMK " + CarrayCode + "/"))
{
//"ETRY:" 重试指令
SendIns = "RT" + Pnr + "|ETRY:";
PM.code = SendIns;
PM.IsPn = false;
//Recvdata = SendNewPID.SendCommand(PM);
Recvdata = WriteLogDB(PM, TicketLP);
//指令日志
Log(0, string.Format("\r\n【订单号{0}】发送指令>{1}\r\n接收数据:\r\n{2}\r\n", Order.OrderId, SendIns, Recvdata));
}
else
{
Log(0, string.Format("订单号{0},编码{1} 出票Office{2},编码状态为{3}," + "出票失败,{4}", Order.OrderId, Pnr, pOffice, PnrStatus, Recvdata));
sbLog.Append(string.Format("订单号{0},编码{1} 出票Office{2},编码状态为{3}," + "出票失败,{4}", Order.OrderId, Pnr, pOffice, PnrStatus, Recvdata));
}
}
}
}
catch (Exception ex)
{
Log(0, string.Format("订单号{0},出票异常：{1}", Order.OrderId, ex.Message + ex.Source + ex.StackTrace.ToString()));
sbLog.Append(string.Format("订单号{0},出票异常：{1}", Order.OrderId, ex.Message + ex.Source + ex.StackTrace.ToString()));
}
finally
{
string TicketMsg = "";
Log_Tb_AirOrder OrderLog = new Log_Tb_AirOrder();
//执行SQl语句
List <string> sqlList = new List <string>();
//修改订单数据列表
List <string> OrderList = new List <string>();
if (TicketLP != null)
{
//解锁
OrderList.Add(" LockCpyNo='' ");
OrderList.Add(" LockLoginName='' ");
OrderList.Add(" LockTime='1900-01-01' ");
OrderList.Add(" CPTime=getdate() ");
OrderList.Add(" CPName='管理员' ");
OrderList.Add(string.Format(" CPCpyNo='{0}' ", TicketLP.CpyNo));
OrderList.Add(" CPRemark='BSP自动出票' ");
OrderList.Add(string.Format(" CPCpyName='{0}' ", TicketLP.UninAllName));
//日志
OrderLog.id = Guid.NewGuid();
OrderLog.OrderId = Order.OrderId;
OrderLog.OperType = "出票";
OrderLog.OperTime = DateTime.Now;
OrderLog.OperLoginName = "管理员";
OrderLog.OperUserName = "******";
OrderLog.CpyNo = TicketLP.CpyNo;
OrderLog.CpyType = 1;
OrderLog.CpyName = TicketLP.UninAllName;
}
if (PTList != null && PTList.Count > 0 && PasList != null && PasList.Count > 0)
{
string PasName = "", TicketNumber = "";
for (int i = 0; i < PTList.Count; i++)
{
if (PTList[i].Split('|').Length == 2)
{
TicketNumber = PTList[i].Split('|')[0];
PasName = PTList[i].Split('|')[1];
Tb_Ticket_Passenger Passenger = PasList.Find(delegate(Tb_Ticket_Passenger _tempPassenger)
{
return(PTList[i].ToUpper().Trim().Contains(_tempPassenger.PassengerName.ToUpper().Trim()));
});
if (Passenger != null)
{
sqlList.Add(string.Format(" update Tb_Ticket_Passenger set TicketNumber='{0}',TicketStatus=2 where id='{1}' and PassengerName='{2}' ", TicketNumber, Passenger.id.ToString(), Passenger.PassengerName));
}
}
}
//修改订单数据
OrderList.Add(" TicketStatus=2 ");
OrderList.Add(" OrderStatusCode=4 ");
if (OrderList.Count > 0)
{
sqlList.Add(string.Format(" update Tb_Ticket_Order set {0} where id='{1}' ", string.Join(",", OrderList.ToArray()), Order.id.ToString()));
}
//出票成功
TicketMsg = "出票成功";
OrderLog.WatchType = 5;
//日志
OrderLog.OperContent = "订单号:" + Order.OrderId + " BSP自动出票成功," + string.Format(",", PasList.ToArray());
//修改数据库状态
}
else
{
//出票失败
TicketMsg = "出票失败";
//修改订单自动出票尝试次数
if (Order.AutoPrintTimes > 3)//尝试次数大于3改为手动出票
{
sqlList.Add(string.Format(" update Tb_Ticket_Order set AutoPrintFlag=0,AutoPrintTimes=CAST(AutoPrintTimes as int)+1 where id='{0}' ", Order.id.ToString()));
}
else
{
sqlList.Add(string.Format(" update Tb_Ticket_Order set AutoPrintTimes=CAST(AutoPrintTimes as int)+1 where id='{0}' ", Order.id.ToString()));
}
OrderLog.WatchType = 2;
//日志
OrderLog.OperContent = "BSP自动出票失败," + sbLog.ToString();
}
//日志
string tempSql = Dal.Mapping.MappingHelper <Log_Tb_AirOrder> .CreateInsertModelSql(OrderLog);
sqlList.Add(tempSql);
string Msg = "";
//修改数据库
if (!Manage.ExecuteSqlTran(sqlList, out Msg))
{
Log(0, string.Format("订单号{0},修改数据库失败：{1}", Order.OrderId, Msg));
}
Log(0, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "订单号:" + Order.OrderId + " " + TicketMsg + "=======================end=====================\r\n");
}
}
}
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");
}
}
