/// <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));
}
public int UpdateInterRefundAndInterRefundRemark(InterRefund refundModel, InterRefundRemark model)
{
var acr = CgtTicketDB.GetInstance();
int i = 0;
try
{
acr.BeginTransaction();
acr.Insert(model);
i += acr.Execute(@"UPDATE [InterRefund] SET ModifyUserId=@0,ModifyUserName=@1,ModifyTime=@2,[Status]=@4 WHERE [orderid]=@3", refundModel.ModifyUserId, refundModel.ModifyUserName, refundModel.ModifyTime, refundModel.OrderID, refundModel.Status);
acr.CompleteTransaction();
}
catch (Exception ex)
{
acr.AbortTransaction();
throw ex;
}
return(i);
}
/// <summary>
/// 插入
/// </summary>
/// <param name="model"></param>
public void Insert(InterRefundRemark model)
{
CgtTicketDB.GetInstance().Insert(model);
}
