com.commander4j.db

Class JDBMaterialLocation

java.lang.Object

com.commander4j.db.JDBMaterialLocation

public class JDBMaterialLocation
extends java.lang.Object

JDBMaterialLocation class is used to insert/update/delete records from the APP_MATERIAL_LOCATION table. This table contains a list of valid locations for a Material and if enabled via the system key SSCC_LOCATION_VALIDATION will prevent a pallet from being moved to a Location which is not valid for its material.

See Also:

JDBMaterial

Field Summary

Fields

Modifier and Type	Field and Description
static int	field_Location_id
static int	field_Material_id
static int	field_Status

Constructor Summary

Constructors

Constructor and Description
JDBMaterialLocation(java.lang.String host, java.lang.String session)

Method Summary

Modifier and Type	Method and Description
void	clear()
boolean	create(java.lang.String material, java.lang.String location)
boolean	delete()
java.lang.String	getErrorMessage()
java.lang.String	getLocation()
java.lang.String	getMaterial()
java.sql.ResultSet	getMaterialLocationDataResultSet(java.sql.PreparedStatement criteria)
boolean	getMaterialLocationProperties()
boolean	getMaterialLocationProperties(java.lang.String mat, java.lang.String locn)
void	getPropertiesfromResultSet(java.sql.ResultSet rs)
java.lang.String	getStatus()
boolean	isValidMaterialLocation()
boolean	isValidMaterialLocation(java.lang.String mat, java.lang.String locn)
boolean	isValidSSCCMaterialLocation()
void	setLocation(java.lang.String location)
void	setMaterial(java.lang.String material)
void	setStatus(java.lang.String status)
boolean	update()

Methods inherited from class java.lang.Object

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

Field Detail

field_Material_id

public static int field_Material_id

field_Location_id

public static int field_Location_id

field_Status

public static int field_Status

Constructor Detail

JDBMaterialLocation

public JDBMaterialLocation(java.lang.String host,
                           java.lang.String session)

Method Detail

clear

public void clear()

getMaterialLocationProperties

public boolean getMaterialLocationProperties(java.lang.String mat,
                                             java.lang.String locn)

getMaterialLocationProperties

public boolean getMaterialLocationProperties()

create

public boolean create(java.lang.String material,
                      java.lang.String location)

delete

public boolean delete()

getErrorMessage

public java.lang.String getErrorMessage()

getLocation

public java.lang.String getLocation()

getMaterial

public java.lang.String getMaterial()

getMaterialLocationDataResultSet

public java.sql.ResultSet getMaterialLocationDataResultSet(java.sql.PreparedStatement criteria)

getPropertiesfromResultSet

public void getPropertiesfromResultSet(java.sql.ResultSet rs)

getStatus

public java.lang.String getStatus()

isValidMaterialLocation

public boolean isValidMaterialLocation()

isValidSSCCMaterialLocation

public boolean isValidSSCCMaterialLocation()

isValidMaterialLocation

public boolean isValidMaterialLocation(java.lang.String mat,
                                       java.lang.String locn)

setLocation

public void setLocation(java.lang.String location)

setMaterial

public void setMaterial(java.lang.String material)

setStatus

public void setStatus(java.lang.String status)

update

public boolean update()