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> /// <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> public int ModtifyInterRefundAffairStatus(InterRefund model) { return(CgtTicketDB.GetInstance().Execute("UPDATE [InterRefund] set AffairStatus=@0 where OrderID=@1", model.AffairStatus.Value.ToString(), model.OrderID)); }
/// <summary> /// 获取退票列表 /// </summary> /// <param name="pageindex"></param> /// <param name="pagesize"></param> /// <param name="model"></param> /// <returns></returns> public Page <dynamic> GetInterRefundPage(int pageindex, int pagesize, DateTime?startDate, DateTime?endDate, InterRefund model) { string wherestr = string.Empty; if (!string.IsNullOrEmpty(model.OrderID)) { wherestr += " AND InterRefund.OrderID = @0"; } if (!string.IsNullOrEmpty(model.OrderOrderId)) { wherestr += " AND [order].OrderID = @1"; } if (model.AffairStatus != -1) { wherestr += " AND [InterRefund].AffairStatus = @2"; } if (model.Status != -1) { wherestr += " AND [InterRefund].Status = @3"; } if (startDate.HasValue) { wherestr += string.Format(@" AND InterRefund.CreateTime>='{0}'", startDate.Value.ToString("yyyy-MM-dd HH:mm:ss")); } if (endDate.HasValue) { wherestr += string.Format(@" AND InterRefund.CreateTime<='{0}' ", endDate.Value.ToString("yyyy-MM-dd 23:59:59")); } string sql = string.Format(@"select [order].OrderID as OrderOrderId,[order].Platform,ReapalAccount,InterRefund.* from [order] join InterRefund on[order].LocalId = InterRefund.OrderID WHERE 1 = 1 {0}", wherestr); return(CgtTicketDB.GetInstance().Page <dynamic>(pageindex, pagesize, sql, model.OrderID, model.OrderOrderId, model.AffairStatus, model.Status)); }