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