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> 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="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)); }