/// <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);
}
