Package systextil.dao

Class BalanceamentoOperacao

java.lang.Object

systextil.dao.BalanceamentoOperacao

public class BalanceamentoOperacao
extends Object

Representa a tabela PCPC_830

Field Summary

Fields

Modifier and Type	Field	Description
final int	codigo_balanceio
final int	codigo_operacao
final int	codigo_operador
final int	pecas_alocadas
final int	seq_operacao
final br.com.intersys.systextil.connection.Amount	tempo_alocado

Method Summary

Modifier and Type	Method	Description
static int	countDistinctCodOperador(br.com.intersys.systextil.connection.AppConnection cn, int codigoBalanceio)
static void	delete(br.com.intersys.systextil.connection.AppConnection cn, int codBalanceio, int seqOperacao)
static boolean	exists(br.com.intersys.systextil.connection.AppConnection cn, int codBalanceio, int codOperador, int seqOperacao)
static BalanceamentoOperacao	get(br.com.intersys.systextil.connection.AppConnection cn, int codOperacao, int seqOperacao)
static BalanceamentoOperacao	get(br.com.intersys.systextil.connection.AppConnection cn, int codBalanceio, int seqOperacao, int codOperador)
static Map<Double,Integer>	getTempoPecasAlocadas(br.com.intersys.systextil.connection.AppConnection cn, int codBalanceio, int codOperador)
static Map<Integer,Integer>	mapTotalAlocacoes(br.com.intersys.systextil.connection.AppConnection cn, int codBalanceio, int seqOperacao)
static double	sumTempoAlocadoBalanceio(br.com.intersys.systextil.connection.AppConnection cn, int codBalanceio)
static double	sumTempoAlocadoBySequencia(br.com.intersys.systextil.connection.AppConnection cn, int codBalanceio, int seqOperacao)
static double	sumTempoBalanceioAndOperador(br.com.intersys.systextil.connection.AppConnection cn, int codBalanceio, int codOperador)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

codigo_balanceio

public final int codigo_balanceio

seq_operacao

public final int seq_operacao

codigo_operacao

public final int codigo_operacao

codigo_operador

public final int codigo_operador

tempo_alocado

public final br.com.intersys.systextil.connection.Amount tempo_alocado

pecas_alocadas

public final int pecas_alocadas

Method Details

get

public static BalanceamentoOperacao get(br.com.intersys.systextil.connection.AppConnection cn,
 int codOperacao,
 int seqOperacao)

get

public static BalanceamentoOperacao get(br.com.intersys.systextil.connection.AppConnection cn,
 int codBalanceio,
 int seqOperacao,
 int codOperador)

exists

public static boolean exists(br.com.intersys.systextil.connection.AppConnection cn,
 int codBalanceio,
 int codOperador,
 int seqOperacao)

countDistinctCodOperador

public static int countDistinctCodOperador(br.com.intersys.systextil.connection.AppConnection cn,
 int codigoBalanceio)

sumTempoAlocadoBySequencia

public static double sumTempoAlocadoBySequencia(br.com.intersys.systextil.connection.AppConnection cn,
 int codBalanceio,
 int seqOperacao)

sumTempoAlocadoBalanceio

public static double sumTempoAlocadoBalanceio(br.com.intersys.systextil.connection.AppConnection cn,
 int codBalanceio)

delete

public static void delete(br.com.intersys.systextil.connection.AppConnection cn,
 int codBalanceio,
 int seqOperacao)

mapTotalAlocacoes

public static Map<Integer,Integer> mapTotalAlocacoes(br.com.intersys.systextil.connection.AppConnection cn,
 int codBalanceio,
 int seqOperacao)

sumTempoBalanceioAndOperador

public static double sumTempoBalanceioAndOperador(br.com.intersys.systextil.connection.AppConnection cn,
 int codBalanceio,
 int codOperador)

getTempoPecasAlocadas

public static Map<Double,Integer> getTempoPecasAlocadas(br.com.intersys.systextil.connection.AppConnection cn,
 int codBalanceio,
 int codOperador)