/// <summary>
/// 获取国际票改期列表
/// </summary>
/// <param name="pageindex"></param>
/// <param name="pagesize"></param>
/// <param name="model"></param>
/// <returns></returns>
public Page <dynamic> GetInterChangeList(int pageindex, int pagesize, DateTime?startDate, DateTime?endDate, InterChange model)
{
string wherestr = string.Empty;
if (!string.IsNullOrEmpty(model.OrderID))
{
wherestr += " AND InterChange.OrderID = @0";
}
else if (!string.IsNullOrEmpty(model.OrderOrderId))
{
wherestr += " AND [order].OrderID = @1";
}
if (model.AffairStatus != -1)
{
wherestr += " AND [InterChange].AffairStatus = @2";
}
if (model.Status != -1)
{
wherestr += " AND [InterChange].Status = @3";
}
if (startDate.HasValue)
{
wherestr += string.Format(@" AND InterChange.CreateTime>='{0}'", startDate.Value.ToString("yyyy-MM-dd HH:mm:ss"));
}
if (endDate.HasValue)
{
wherestr += string.Format(@" AND InterChange.CreateTime<='{0}' ", endDate.Value.ToString("yyyy-MM-dd 23:59:59"));
}
string sql = string.Format(@"select [order].OrderID as OrderOrderId,[order].Platform,ReapalAccount,InterChange.* from [order] join
InterChange on[order].LocalId = InterChange.OrderID WHERE 1 = 1 {0}", wherestr);
return(CgtTicketDB.GetInstance().Page <dynamic>(pageindex, pagesize, sql, model.OrderID, model.OrderOrderId,
model.AffairStatus, model.Status));
}
/// <summary>
/// 获取国际票订单列表（分页）
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public Page <Order> GetOrderPage(int pageindex, int pagesize, DateTime?startDate, DateTime?endDate, Order model)
{
string wherestr = string.Empty;
if (!string.IsNullOrEmpty(model.OrderId))
{
wherestr += " AND OrderId=@0 ";
}
if (!string.IsNullOrEmpty(model.LocalId))
{
wherestr += " AND LocalId=@1 ";
}
if (model.TravelType.HasValue)
{
wherestr += " AND TravelType=@2 ";
}
if (model.Status != -1)
{
wherestr += " AND [Status] = @3";
}
if (startDate.HasValue)
{
wherestr += string.Format(@" AND CreateTime>='{0}'", startDate.Value.ToString("yyyy-MM-dd HH:mm:ss"));
}
if (endDate.HasValue)
{
wherestr += string.Format(@" AND CreateTime<='{0}' ", endDate.Value.ToString("yyyy-MM-dd 23:59:59"));
}
string sql = string.Format(@"select * from [dbo].[Order] where 1 = 1 {0} ", wherestr);
return(CgtTicketDB.GetInstance().Page <Order>(pageindex, pagesize, sql, model.OrderId, model.LocalId, model.TravelType, model.Status));
}
/// <summary>
/// 国际票改期乘客列表
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public IEnumerable<Passenger> GetInterChangeTicketPassengerList(Passenger model)
{
string wherestr = string.Empty;
if (!string.IsNullOrEmpty(model.Order))
{
wherestr += " AND Passenger.[Order]=@0 ";
}
string sql = string.Format(@"select * from InterChangeTicket inner join [Passenger]
on InterChangeTicket.PassengerId=Passenger.Id where 1 = 1 {0} ", wherestr);
return CgtTicketDB.GetInstance().Query<Passenger>(sql, model.Order);
}
/// <summary>
/// 获取国际票退票备注表
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public IEnumerable <InterRefundRemark> GetInterRefundRemarkList(InterRefundRemark model)
{
string wherestr = string.Empty;
if (!string.IsNullOrEmpty(model.OrderId))
{
wherestr += " AND OrderId=@0 ";
}
string sql = string.Format(@"select * from [InterRefundRemark] where 1 = 1 {0} ", wherestr);
return(CgtTicketDB.GetInstance().Query <InterRefundRemark>(sql, model.OrderId));
}
/// <summary>
/// 乘客列表
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public IEnumerable <Passenger> GetPassengerList(Passenger model)
{
string wherestr = string.Empty;
if (!string.IsNullOrEmpty(model.Order))
{
wherestr += " AND [Order]=@0 ";
}
string sql = string.Format(@"select * from [dbo].[Passenger] where 1 = 1 {0} ", wherestr);
return(CgtTicketDB.GetInstance().Query <Passenger>(sql, model.Order));
}
/// <summary>
/// 获取订单列表
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public IEnumerable <dynamic> GetOrderList(Order model)
{
string wherestr = string.Empty;
if (!string.IsNullOrEmpty(model.OrderId))
{
wherestr += " AND a.OrderId=@0 ";
}
if (!string.IsNullOrEmpty(model.LocalId))
{
wherestr += " AND a.LocalId=@1 ";
}
string sql = string.Format(@"select a.*,b.AffairStatus,b.ModifyUserId from [dbo].[Order] a inner join [dbo].[InterRefund] b on a.LocalId=b.OrderID where 1 = 1 {0} ", wherestr);
return(CgtTicketDB.GetInstance().Query <dynamic>(sql, model.OrderId, model.LocalId));
}
public int UpdateInterChangeAndInterChangeRemark(InterChange ChangeModel, InterChangeRemark model)
{
var acr = CgtTicketDB.GetInstance();
int i = 0;
try
{
acr.BeginTransaction();
acr.Insert(model);
i += acr.Execute(@"UPDATE [InterChange] SET ModifyUserId=@0,ModifyUserName=@1,ModifyTime=@2,[Status]=@4 WHERE [orderid]=@3", ChangeModel.ModifyUserId, ChangeModel.ModifyUserName, ChangeModel.ModifyTime, ChangeModel.OrderID, ChangeModel.Status);
acr.CompleteTransaction();
}
catch (Exception ex)
{
acr.AbortTransaction();
throw ex;
}
return(i);
}
/// <summary>
/// 退票列表下载
/// </summary>
/// <returns></returns>
public List <dynamic> GetInterRefundDownload(InterRefund model)
{
string wherestr = string.Empty;
string sql = string.Format(@"SELECT a.OrderID AS OrderOrderId ,
a.[Platform] ,
a.ReapalAccount ,
b.Amount ,
b.OrderID ,
b.CreateTime ,
b.ModifyUserName ,
b.[Status],
(CASE WHEN b.AffairStatus = 0 THEN '未锁定'
WHEN b.AffairStatus = 1 THEN '锁定'
ELSE NULL
END ) AS AffairStatus
FROM [order] a WITH(nolock)
INNER JOIN InterRefund b WITH(nolock) ON a.LocalId = b.OrderID
WHERE 1 = 1 ", wherestr);
return(CgtTicketDB.GetInstance().Query <dynamic>(sql).ToList());
}
/// <summary>
/// 插入
/// </summary>
/// <param name="model"></param>
public void Insert(InterRefundRemark model)
{
CgtTicketDB.GetInstance().Insert(model);
}
/// <summary>
/// 插入
/// </summary>
/// <param name="model"></param>
public void Insert(InterChangeRemark model)
{
CgtTicketDB.GetInstance().Insert(model);
}
/// <summary>
/// 修改锁单状态
/// </summary>
public int ModtifyInterChangeAffairStatus(InterChange model)
{
return(CgtTicketDB.GetInstance().Execute("UPDATE [InterChange] set AffairStatus=@0 where OrderID=@1", model.AffairStatus.Value.ToString(), model.OrderID));
}
/// <summary>
/// 插入
/// </summary>
/// <param name="model"></param>
public void Insert(Order model)
{
CgtTicketDB.GetInstance().Insert(model);
}
