Package systextil.dao
Class PedidoCompra
java.lang.Object
systextil.dao.PedidoCompra
Representa a tabela
SUPR_090-
Field Summary
FieldsModifier and TypeFieldDescriptionfinal Stringfinal intfinal intfinal intfinal intfinal intfinal intfinal intfinal intfinal intfinal Datefinal Datefinal Datefinal Datefinal Stringfinal Datefinal Stringfinal intfinal intfinal intfinal CNPJfinal intDeprecated, for removal: This API element is subject to removal in a future version.final intDeprecated, for removal: This API element is subject to removal in a future version.final intDeprecated, for removal: This API element is subject to removal in a future version.final Stringfinal intfinal intfinal Stringfinal Stringfinal intfinal intfinal intfinal Stringfinal Doublefinal Stringfinal intfinal intfinal Stringfinal Datefinal intfinal intfinal intfinal CNPJfinal intDeprecated, for removal: This API element is subject to removal in a future version.final intDeprecated, for removal: This API element is subject to removal in a future version.final intDeprecated, for removal: This API element is subject to removal in a future version.final Stringfinal intfinal Doublefinal Doublefinal Stringfinal int -
Method Summary
Modifier and TypeMethodDescriptionstatic PedidoCompraget(br.com.intersys.systextil.connection.AppConnection conn, int pedidoCompra) static intupdateFornPedForneByPk(br.com.intersys.systextil.connection.AppConnection conn, CNPJ fornPedForne, int pedidoCompra) static intupdateTranPedForneByPk(br.com.intersys.systextil.connection.AppConnection conn, CNPJ tranPedForne, int pedidoCompra)
-
Field Details
-
pedidoCompra
public final int pedidoCompra -
dtEmisPedComp
-
condPgtoCompra
public final int condPgtoCompra -
fornPedForne9
Deprecated, for removal: This API element is subject to removal in a future version. -
fornPedForne4
Deprecated, for removal: This API element is subject to removal in a future version. -
fornPedForne2
Deprecated, for removal: This API element is subject to removal in a future version. -
fornPedForne
-
dataPrevEntr
-
tranPedForne9
Deprecated, for removal: This API element is subject to removal in a future version. -
tranPedForne4
Deprecated, for removal: This API element is subject to removal in a future version. -
tranPedForne2
Deprecated, for removal: This API element is subject to removal in a future version. -
tranPedForne
-
tipoFrete
public final int tipoFrete -
codEndEntrega
public final int codEndEntrega -
codEndCobranca
public final int codEndCobranca -
codigoComprador
public final int codigoComprador -
vendedorContato
-
codCancelamento
public final int codCancelamento -
situacaoPedido
public final int situacaoPedido -
valorFrete
-
valorOutras
-
codPortador
public final int codPortador -
codigoEmpresa
public final int codigoEmpresa -
valEncFinan
public final int valEncFinan -
tabPreco
public final int tabPreco -
codigoTransacao
public final int codigoTransacao -
flagExportado
public final int flagExportado -
codMoeda
public final int codMoeda -
datetimePedido
-
timePedido
-
pesoTotal
-
executaTrigger
public final int executaTrigger -
observacao
-
dataChegada
-
volume
public final int volume -
tipoFreteRedespacho
public final int tipoFreteRedespacho -
numeroCompraObc
-
eMail
-
assuntoEmail
-
textoEmail
-
tipoPedido
public final int tipoPedido -
enviaEmailEmergencial
public final int enviaEmailEmergencial -
pedidoRegistro
-
reutilizaSdcvObc
-
ordemServico
public final int ordemServico -
dataAtualizacaoApi
-
pedidoPai
public final int pedidoPai -
usuarioDigitador
-
incoterm
-
modalidadeCompra
public final int modalidadeCompra -
indIntegNarwal
public final int indIntegNarwal -
descricaoStatusNarwal
-
-
Method Details
-
get
public static PedidoCompra get(br.com.intersys.systextil.connection.AppConnection conn, int pedidoCompra) - Returns:
- pedido de compra obtida do banco, ou nulo se não for encontrada.
-
updateFornPedForneByPk
public static int updateFornPedForneByPk(br.com.intersys.systextil.connection.AppConnection conn, CNPJ fornPedForne, int pedidoCompra) - Parameters:
conn-fornPedForne- , para atualizar as colunasFORN_PED_FORNE_R,FORN_PED_FORNE_OeFORN_PED_FORNE2pedidoCompra- , a PK- Returns:
- mesmo resultado que
Statement.getUpdateCount()
-
updateTranPedForneByPk
public static int updateTranPedForneByPk(br.com.intersys.systextil.connection.AppConnection conn, CNPJ tranPedForne, int pedidoCompra) - Parameters:
conn-tranPedForne- , para atualizar as colunasTRAN_PED_FORNE_R,TRAN_PED_FORNE_OeTRAN_PED_FORNE2pedidoCompra- , a PK- Returns:
- mesmo resultado que
Statement.getUpdateCount()
-