/// <summary>
/// 根据分区id获取队列数量
/// </summary>
/// <param name="partitionId"></param>
/// <returns></returns>
public int GetPartitionQueue(DbConn conn, int partitionId, EnumMqPathPartitionState state)
{
return(SqlHelper.Visit((ps) =>
{
string sql = "SELECT COUNT(1) FROM tb_mqpath_partition WITH(NOLOCK) WHERE partitionId=@partitionId AND stage=@stage";
ps.Add("@partitionId", partitionId);
ps.Add("@stage", Convert.ToInt32(state));
object obj = conn.ExecuteScalar(sql, ps.ToParameters());
if (obj != DBNull.Value && obj != null)
{
return Convert.ToInt32(obj);
}
return 0;
}));
}
/// <summary>
/// ���ݷ���id��ȡ��������
/// </summary>
/// <param name="partitionId"></param>
/// <returns></returns>
public int GetPartitionQueue(DbConn conn, int partitionId, EnumMqPathPartitionState state)
{
return SqlHelper.Visit((ps) =>
{
string sql = "SELECT COUNT(1) FROM tb_mqpath_partition WITH(NOLOCK) WHERE partitionId=@partitionId AND stage=@stage";
ps.Add("@partitionId", partitionId);
ps.Add("@stage", Convert.ToInt32(state));
object obj = conn.ExecuteScalar(sql, ps.ToParameters());
if (obj != DBNull.Value && obj != null)
{
return Convert.ToInt32(obj);
}
return 0;
});
}
