internal bool UpdateStatus(string code, FailMqMessageStatus status, int count = 0) { DataCenterHelper dataCenter = new DataCenterHelper(); var paramList = new List <SqlParameter> { new SqlParameter() { ParameterName = "@status", Value = (int)status, SqlDbType = System.Data.SqlDbType.Int }, new SqlParameter() { ParameterName = "@code", Value = code, SqlDbType = System.Data.SqlDbType.VarChar, Size = 36 }, }; if (count == 0) { return(dataCenter.ExecuteNonQuery("UPDATE FailMqMessage SET STATUS=@status,UpdateTime=GetDate() WHERE Code = @code", paramList.ToArray())); } else { paramList.Add(new SqlParameter() { ParameterName = "@RetryNumber", Value = count, SqlDbType = System.Data.SqlDbType.Int }); return(dataCenter.ExecuteNonQuery("UPDATE FailMqMessage SET STATUS=@status,UpdateTime=GetDate(),RetryNumber=RetryNumber+@RetryNumber WHERE Code = @code", paramList.ToArray())); } }
/// <summary> /// 重置处理中的状态为待处理 /// </summary> public void ResetStatus() { DataCenterHelper dataCenter = new DataCenterHelper(); var paramList = new List <SqlParameter> { new SqlParameter() { ParameterName = "@status", Value = 0, SqlDbType = System.Data.SqlDbType.Int }, new SqlParameter() { ParameterName = "@status1", Value = 1, SqlDbType = System.Data.SqlDbType.Int }, }; dataCenter.ExecuteNonQuery("UPDATE FailMqMessage SET STATUS=@status,UpdateTime=GetDate() WHERE STATUS=@status1", paramList.ToArray()); }