public int UpdateOrder(TraInterFaceOrderModel t, string[] properties = null)
{
TraInterFaceOrderEntity traInterFaceOrderEntity =
AutoMapperHelper.DoMap <TraInterFaceOrderModel, TraInterFaceOrderEntity>(t);
return(_dal.Update(traInterFaceOrderEntity, properties));
}
public int Update(TraInterFaceOrderEntity t, string[] properties = null)
{
using (BrightourDbContext db = new BrightourDbContext())
{
return(db.Update(t, properties));
}
}
public int Insert(TraInterFaceOrderEntity t)
{
using (BrightourDbContext db = new BrightourDbContext())
{
var log = db.InterFaceOrder.Add(t);
db.SaveChanges();
return(log.InterfaceId);
}
}
public TraOrderCancelResponseModel RequestCancelOrder(int orderId)
{
TraInterFaceOrderEntity traInterFaceOrderEntity =
_traInterFaceOrderDal.Query <TraInterFaceOrderEntity>(n => n.OrderId == orderId.ToString())
.FirstOrDefault();
if (traInterFaceOrderEntity == null)
{
return(null);
}
int status = traInterFaceOrderEntity.Status;
if (status == (int)OrderTypeEnum.OrderCancel)
{
return(null);
}
TraOrderCancelResponseModel responseModel = null;
string isServer = AppSettingsHelper.GetAppSettings(AppSettingsEnum.IsServer);
if (isServer == "T")
{
responseModel = _requestCancelOrderBll.RequestCancelOrder(new TraOrderCancelModel()
{
orderid = orderId.ToString(),
transactionid = traInterFaceOrderEntity.Transactionid
});
}
else
{
responseModel = new TraOrderCancelResponseModel()
{
success = true
};
}
if (responseModel.success)
{
traInterFaceOrderEntity.Status = (int)OrderTypeEnum.OrderCancel;
_traInterFaceOrderDal.Update <TraInterFaceOrderEntity>(traInterFaceOrderEntity, new[] { "Status" });
_traOrderOperateDal.Insert <TraOrderOperateEntity>(new TraOrderOperateEntity()
{
AfterOperateStatus = (int)OrderTypeEnum.OrderCancel,
InterfaceId = traInterFaceOrderEntity.InterfaceId,
Operate = (int)OrderTypeEnum.OrderCancel,
OperateTime = traInterFaceOrderEntity.CreateTime,
BeforOperateStatus = status
});
}
return(responseModel);
}
public int Delete(TraInterFaceOrderEntity t)
{
using (BrightourDbContext db = new BrightourDbContext())
{
db.InterFaceOrder.Attach(t);
db.InterFaceOrder.Remove(t);
int i = db.SaveChanges();
//string sql = $"delete from dbo.Tra_HoldSeatCallBackLog where logid={t.LogId}";
//db.Database.ExecuteSqlCommand(sql);
if (i > 0)
{
return(0);
}
return(-1);
}
}
public TraOrderConfirmResponseModel RequestPrintTicket(int orderId)
{
TraInterFaceOrderEntity traInterFaceOrderEntity =
_traInterFaceOrderDal.Query <TraInterFaceOrderEntity>(n => n.OrderId == orderId.ToString())
.FirstOrDefault();
if (traInterFaceOrderEntity == null)
{
return(null);
}
int status = traInterFaceOrderEntity.Status;
if (traInterFaceOrderEntity.CreateTime.AddMinutes(30) < DateTime.Now)
{
return(new TraOrderConfirmResponseModel()
{
success = false,
msg = "该订单已经超过出票时间范围"
});
}
if (status == (int)OrderTypeEnum.MakingTicket)
{
return(new TraOrderConfirmResponseModel()
{
success = false,
msg = "该订单已经发起出票请求了"
});
}
if (status == (int)OrderTypeEnum.TicketSuccess)
{
return(new TraOrderConfirmResponseModel()
{
success = false,
msg = "该订单已经出票了"
});
}
if (status == (int)OrderTypeEnum.OrderCancel)
{
return(new TraOrderConfirmResponseModel()
{
success = false,
msg = "该订单已经取消了"
});
}
string isServer = AppSettingsHelper.GetAppSettings(AppSettingsEnum.IsServer);
TraOrderConfirmResponseModel responseModel = null;
if (isServer == "T")
{
responseModel = _requestPrintTicketBll.RequestPrintTicket(new TraOrderConfirmModel()
{
orderid = orderId.ToString(),
transactionid = traInterFaceOrderEntity.Transactionid
});
}
else
{
responseModel = new TraOrderConfirmResponseModel()
{
success = true,
ordernumber = "ETest" + DateTime.Now.ToString("yyyyMMdd") + new Random().Next(1000)
};
}
if (responseModel.success)
{
traInterFaceOrderEntity.Status = (int)OrderTypeEnum.MakingTicket;
traInterFaceOrderEntity.OrderNumber = responseModel.ordernumber;
_traInterFaceOrderDal.Update <TraInterFaceOrderEntity>(traInterFaceOrderEntity, new[] { "Status", "OrderNumber" });
_traOrderOperateDal.Insert <TraOrderOperateEntity>(new TraOrderOperateEntity()
{
AfterOperateStatus = (int)OrderTypeEnum.TicketSuccess,
InterfaceId = traInterFaceOrderEntity.InterfaceId,
Operate = (int)OrderTypeEnum.MakingTicket,
OperateTime = traInterFaceOrderEntity.CreateTime,
BeforOperateStatus = status
});
}
return(responseModel);
}
/// <summary>
/// 获取抢票异步成功通知，并做处理
/// 则自动生成火车订单，通知抢票发起者
/// </summary>
public void GetGrabTicketSuccessNotice(GrabTicketSuccessedDataAsyncResponseModel successedData)
{
int orderid = Convert.ToInt32(successedData.orderid);
#region 1.更新抢票信息状态
TraGrabTicketEntity traGrabTicketEntity =
_traGrabTicketDal.Query <TraGrabTicketEntity>(n => n.OrderId == orderid).FirstOrDefault();
if (traGrabTicketEntity == null)
{
throw new Exception("未找到对应的系统订单");
}
traGrabTicketEntity.GrabStatus = TrainGrabStatusEnum.S.ToString();
_traGrabTicketDal.Update(traGrabTicketEntity, new string[] { "GrabStatus" });
#endregion
#region 2.1 根据订单获取预设订单信息
TraOrderEntity traOrderEntity = _traOrderDal.Find <TraOrderEntity>(orderid);
if (traOrderEntity == null)
{
throw new Exception("订单信息异常");
}
if (traOrderEntity.OrderType == 0)
{
throw new Exception("该订单已经回调");
}
TraOrderDetailEntity traOrderDetailEntity =
_traOrderDetailDal.Query <TraOrderDetailEntity>(n => n.OrderId == traOrderEntity.OrderId)
.FirstOrDefault();
if (traOrderDetailEntity == null)
{
throw new Exception("订单信息异常");
}
TraOrderStatusEntity traOrderStatusEntity =
_traOrderStatusDal.Query <TraOrderStatusEntity>(n => n.OrderId == traOrderEntity.OrderId)
.FirstOrDefault();
if (traOrderStatusEntity == null)
{
throw new Exception("订单信息异常");
}
List <TraPassengerEntity> traPassengerEntities =
_traPassengerDal.Query <TraPassengerEntity>(n => n.OdId == traOrderDetailEntity.OdId).ToList();
if (traPassengerEntities.Count == 0)
{
throw new Exception("订单信息异常");
}
#endregion
#region 2.2根据返回结果，更新预设订单信息
traOrderEntity.TransactionId = successedData.transactionid;
traOrderEntity.OrderType = 0;
if (successedData.refund_online == "1")
{
traOrderEntity.IsRefundBy12306 = false;
}
else
{
traOrderEntity.IsRefundBy12306 = true;
}
traOrderDetailEntity.OrderId12306 = successedData.ordernumber;
traOrderDetailEntity.StartName = successedData.from_station_name;
traOrderDetailEntity.StartCode = successedData.from_station_code;
traOrderDetailEntity.StartTime = Convert.ToDateTime(successedData.start_time);
TraAddressEntity startAddressEntity =
_traAddressDal.Query <TraAddressEntity>(n => n.Addr_Name == traOrderDetailEntity.StartName)
.FirstOrDefault();
if (startAddressEntity != null)
{
traOrderDetailEntity.StartNameId = startAddressEntity.Aid;
}
traOrderDetailEntity.EndName = successedData.to_station_name;
traOrderDetailEntity.EndCode = successedData.to_station_code;
traOrderDetailEntity.EndTime = Convert.ToDateTime(successedData.arrive_time);
TraAddressEntity endAddressEntity =
_traAddressDal.Query <TraAddressEntity>(n => n.Addr_Name == traOrderDetailEntity.EndName)
.FirstOrDefault();
if (endAddressEntity != null)
{
traOrderDetailEntity.EndNameId = endAddressEntity.Aid;
}
traOrderDetailEntity.TrainNo = successedData.checi;
traOrderDetailEntity.FacePrice = Convert.ToDecimal(successedData.orderamount) / 2;
traOrderDetailEntity.TotalPrice = traOrderDetailEntity.FacePrice + traOrderDetailEntity.ServiceFee;
foreach (TraPassengerEntity traPassengerEntity in traPassengerEntities)
{
GrabTicketSuccessedPassengerAsyncResponseModel grabTicketPassenger = successedData.passengers.Find(
n => n.passengersename == traPassengerEntity.Name && n.passportseno == traPassengerEntity.CardNo);
traPassengerEntity.FacePrice = Convert.ToDecimal(grabTicketPassenger.price);
List <string> cxinList = grabTicketPassenger.cxin.Split(',').ToList();
if (cxinList.Count == 2)
{
traPassengerEntity.PlaceCar = cxinList[0];
traPassengerEntity.PlaceSeatNo = cxinList[1];
}
traPassengerEntity.PlaceGrade = grabTicketPassenger.zwname;
traPassengerEntity.TicketNo = grabTicketPassenger.ticket_no;
_traPassengerDal.Update(traPassengerEntity,
new string[] { "FacePrice", "PlaceCar", "PlaceSeatNo", "PlaceGrade", "TicketNo" });
}
traOrderEntity.TotalMoney = traPassengerEntities.Sum(n => (n.ServiceFee ?? 0) + (n.FacePrice ?? 0));
traOrderEntity.PayAmount = traOrderEntity.TotalMoney;
traOrderStatusEntity.IsBuy = 1;
traOrderStatusEntity.ProccessStatus = traOrderStatusEntity.ProccessStatus + 1 + 8 + 64; //已付款，已预定
traOrderStatusEntity.RealPayOid = "sys";
traOrderStatusEntity.RealPayDatetime = DateTime.Now;
//更新订单
_traOrderDal.Update(traOrderEntity,
new string[] { "TransactionId", "IsRefundBy12306", "TotalMoney", "PayAmount", "OrderType" });
//更新行程
_traOrderDetailDal.Update(traOrderDetailEntity,
new string[]
{
"OrderId12306", "StartName", "StartCode", "StartTime", "EndName", "EndCode", "EndTime",
"TrainNo",
"FacePrice", "TotalPrice"
});
//更新订单状态
_traOrderStatusDal.Update(traOrderStatusEntity,
new[] { "IsBuy", "ProccessStatus", "RealPayOid", "RealPayDatetime" });
#endregion
#region 2.3 设置付款信息，并记录日志
PaySupplierEvent?.Invoke(this, new CommonEventArgs <AccountDetailModel>(new AccountDetailModel()
{
Aid = 81,
Amount = traPassengerEntities.Sum(n => (n.FacePrice ?? 0)) + 5, //抢票订单+5块
Detailtype = "火车票付票款",
Oid = "sys",
CreateTime = DateTime.Now,
Source = "火车票付票款",
OrderId = traOrderEntity.OrderId,
OrderType = "Tra",
Provider = 0,
CollectionRemark = "",
EstimateId = 0
}));
_traOrderLogDal.Insert(new TraOrderLogEntity()
{
OrderId = traOrderEntity.OrderId,
CreateOid = "sys",
CreateTime = DateTime.Now,
LogContent = "抢票出票回调，自动勾已预定、已付票款、已采购",
LogType = "修改"
});
#endregion
#region 2.3插入Tra_InterFaceOrder表，以便退改签流程
TraInterFaceOrderEntity traInterFaceOrderEntity =
_traInterFaceOrderDal.Insert <TraInterFaceOrderEntity>(new TraInterFaceOrderEntity()
{
OrderId = traOrderEntity.OrderId.ToString(),
CreateTime = DateTime.Now,
Status = (int)OrderTypeEnum.TicketSuccess,
Transactionid = traOrderEntity.TransactionId,
OrderNumber = traOrderDetailEntity.OrderId12306
});
_traOrderOperateDal.Insert(new TraOrderOperateEntity()
{
InterfaceId = traInterFaceOrderEntity.InterfaceId,
AfterOperateStatus = (int)OrderTypeEnum.TicketSuccess,
BeforOperateStatus = 0,
OperateTime = DateTime.Now
});
#endregion
}
public TraOrderSubmitResponseModel RequestHoldSeat(TraAddOrderModel addModel)
{
TraOrderSubmitResponseModel responseModel = null;
string isServer = AppSettingsHelper.GetAppSettings(AppSettingsEnum.IsServer);
if (isServer == "T")
{
//请求接口
#region 封装接口请求参数
TraOrderSubmitModel model = new TraOrderSubmitModel()
{
orderid = addModel.Order.OrderId.ToString(),
checi = addModel.OrderDetailList[0].TrainNo,
from_station_code = addModel.OrderDetailList[0].StartCode,
from_station_name = addModel.OrderDetailList[0].StartName,
to_station_code = addModel.OrderDetailList[0].EndCode,
to_station_name = addModel.OrderDetailList[0].EndName,
train_date = addModel.OrderDetailList[0].StartTime.ToString("yyyy-MM-dd"),
passengers = new List <TraOrderSubmitPassengerModel>(),
LoginUserName = "",
LoginUserPassword = "",
is_accept_standing = addModel.IsAcceptStanding,
is_choose_seats = addModel.IsChooseSeats,
choose_seats = addModel.ChooseSeats
};
model.passengers = new List <TraOrderSubmitPassengerModel>();
foreach (var p in addModel.OrderDetailList[0].PassengerList)
{
TraOrderSubmitPassengerModel pp = new TraOrderSubmitPassengerModel();
pp.passengersename = p.Name.Replace("/", " ");
pp.passportseno = p.CardNo;
pp.passporttypeseidname = p.CardNoType.ToDescription();
if (p.CardNoType == CardTypeEnum.Certificate)
{
pp.passporttypeseid = "1";
}
else if (p.CardNoType == CardTypeEnum.HongKongAndMacaoPass)
{
pp.passporttypeseid = "C";
}
else if (p.CardNoType == CardTypeEnum.Passport)
{
pp.passporttypeseid = "B";
}
else if (p.CardNoType == CardTypeEnum.TaiwanEntryPermit || p.CardNoType == CardTypeEnum.MTP)
{
pp.passporttypeseid = "G";
pp.passporttypeseidname = "台湾通行证";
}
//pp.passporttypeseid = ((int) p.CardNoType).ToString();
pp.piaotype = "1";
pp.ticket_no = "";
pp.piaotypename = "成人票";
if (addModel.OrderDetailList[0].PlaceGrade != "无座")
{
pp.zwcode = TrainTypeEnum.GetTypeCodeByName(addModel.OrderDetailList[0].PlaceGrade);
pp.zwname = addModel.OrderDetailList[0].PlaceGrade;
}
else
{
//如果当前是无座则根据当前车次选择最低座位
List <string> cTypeList = new List <string>()
{
"G", "C", "D"
};
if (!string.IsNullOrEmpty(model.checi) && model.checi.Length > 0 &&
cTypeList.Contains(model.checi.Substring(0, 1).ToUpper()))
{
pp.zwcode = TrainTypeEnum.GetTypeCodeByName("二等座");
pp.zwname = "二等座";
}
else
{
pp.zwcode = TrainTypeEnum.GetTypeCodeByName("硬座");
pp.zwname = "硬座";
}
}
pp.cxin = "";
pp.price = addModel.OrderDetailList[0].FacePrice.ToString("0.00");
model.passengers.Add(pp);
}
#endregion
responseModel = _requestHoldSeatBll.RequestHoldSeatInterface(model);
}
else
{
responseModel = new TraOrderSubmitResponseModel()
{
success = true, orderid = "Test" + DateTime.Now.ToString("yyyyMMddHHmmssfff")
};
}
#region 请求成功后操作
if (responseModel.success)//请求占位成功
{
int count =
_traInterFaceOrderDal.Query <TraInterFaceOrderEntity>(a => a.Transactionid == responseModel.orderid,
true).Count();
if (count == 0)//如果没有当前接口的订单号，则插入该条信息
{
TraInterFaceOrderEntity traInterFaceOrderEntity = new TraInterFaceOrderEntity
{
CreateTime = DateTime.Now,
OrderId = addModel.Order.OrderId.ToString(),
Status = (int)OrderTypeEnum.ApplyHoldSeat,
Transactionid = responseModel.orderid
};
traInterFaceOrderEntity =
_traInterFaceOrderDal.Insert <TraInterFaceOrderEntity>(traInterFaceOrderEntity);
_traOrderOperateDal.Insert <TraOrderOperateEntity>(new TraOrderOperateEntity()
{
AfterOperateStatus = (int)OrderTypeEnum.MakingTicket,
InterfaceId = traInterFaceOrderEntity.InterfaceId,
Operate = (int)OrderTypeEnum.ApplyHoldSeat,
OperateTime = traInterFaceOrderEntity.CreateTime
});
}
}
#endregion
return(responseModel);
}
