/// <summary> /// 修改审核状态 /// </summary> /// <param name="tickets">门票编号</param> /// <param name="operatorId">审核用户编号</param> /// <param name="es">审核状态</param> /// <returns></returns> public bool UpdateExamineStatus(string tickets, int operatorId, ExamineStatus es) { bool result = false; if (!string.IsNullOrEmpty(tickets) && operatorId > 0) { result = dal.UpdateExamineStatus(tickets, operatorId, es); } return(result); }
/// <summary> /// 修改审核状态 /// </summary> /// <param name="tickets">门票编号</param> /// <param name="operatorId">审核用户编号</param> /// <param name="es">审核状态</param> /// <returns></returns> public virtual bool UpdateExamineStatus(string tickets, int operatorId, ExamineStatus es) { string sql = "UPDATE tbl_ScenicTickets SET ExamineStatus = @ExamineStatus,ExamineOperator = @ExamineOperator WHERE TicketsId = @tickets"; DbCommand comm = this._db.GetSqlStringCommand(sql); this._db.AddInParameter(comm, "@ExamineStatus", DbType.Byte, (int)es); this._db.AddInParameter(comm, "@ExamineOperator", DbType.Int32, operatorId); this._db.AddInParameter(comm, "@tickets", DbType.AnsiStringFixedLength, tickets); return(DbHelper.ExecuteSql(comm, this._db) > 0 ? true : false); }
protected string GetStatus(ScenicTicketsStatus status, ExamineStatus examineStatus) { if (examineStatus == ExamineStatus.待审核) { return(ExamineStatus.待审核.ToString()); } else { return(status.ToString()); } }
/// <summary> /// 修改景区审核状态 /// </summary> /// <param name="operatorId">审核用户编号</param> /// <param name="es">状态</param> /// <param name="scenicId">景区编号</param> /// <returns></returns> public bool UpdateExamineStatus(int operatorId, ExamineStatus es, params string[] scenicId) { bool result = false; if (operatorId > 0 && scenicId != null && scenicId.Length > 0) { StringBuilder scenic = new StringBuilder(); for (int i = 0; i < scenicId.Length; i++) { scenic.AppendFormat("{0},", scenicId[i]); } result = dal.UpdateExamineStatus(scenic.ToString().Substring(0, scenic.ToString().Length - 1), operatorId, es); } return(result); }