#include <datalib.h>

Inheritance diagram for HNumber:

Public Member Functions
	HNumber (QString sqlc, QString ex, QString tit, QString t, QString def)

	HNumber (HNumber *t)

	~HNumber (void)

virtual bool	acceptFunction (void)

virtual bool	acceptSubselect (void)

virtual QVariant	dbValueToDispValue (QVariant v)

void	deepcopy_from (HNumber *x)

virtual HDataField *	get_clone (void)

long int	getMaximum (void)

long int	getMinimum (void)

virtual QString	getSQLValue (void)

virtual QString	getSQLValueAsString (void)

virtual QVariant	getValue (void)

virtual QString	lowerValidate (void)

virtual int	setDefval (QVariant v)

void	setMaximum (long int m)

void	setMinimum (long int m)

virtual int	setValue (QVariant v, bool sdisabled=false)

virtual QString	sqlCreateStringPart (QString switches="")

virtual QString	sqlInsertHead (void)

virtual QString	sqlInsertValue (void)

virtual QString	sqlSelectHead (void)

virtual QString	sqlUpdate (void)

Public Member Functions inherited from HDataField
	HDataField (QString _sqlColumn, QString _explain, QString tit, QString _tailstr="", bool _editable=true)

	HDataField (HDataField *t)

	~HDataField (void)

void	addMark (QString mark)

void	addMark (QStringList pmarkers)

void	addNotValidValue (QString v)

void	addRole (HDataFieldRole role)

QStringList	allMarker (void)

HDataField *	asColored (int r, int g, int b)

HDataField *	asConstant (void)

HDataField *	asHide (void)

void	clearMarkers (void)

void	clearNotValidValues (void)

void	clearRoles (void)

void	clearSqlSynced (void)

void	deepcopy_from_hdatafield (HDataField *x)

QVariant	defvalParser (QString s)

void	delRole (QString name)

void	doSet (void)

int	editBoxMaxWidth (void)

int	getBColor (void)

QString	getDefaultValue (void)

virtual QVariant	getDispValue ()

QString	getExplainText (void)

QString	getFunction (void)

int	getGColor (void)

bool	getLastValidateStatus ()

bool	getPermanentValidateStatus ()

int	getPrintCellWidth (void)

int	getRColor (void)

QString	getSpecDisplaySortMode (void)

QString	getSubselect (void)

QString	getTailText (void)

QString	getTitleText (void)

bool	hasMark (QString mark)

bool	isEditable (void)

bool	isGuienabled (void)

bool	isLogged (void)

bool	isMeldedWithNext (void)

bool	isNoMiddleStretch (void)

bool	isPrintCellWrap (void)

bool	isReallyChanged (void)

bool	isSet (void)

bool	isShow (void)

bool	isSQLField (void)

void	meldWithNext (void)

void	noMiddleStretch (void)

void	notSet (void)

void	resetFunction (void)

void	resetLogging (void)

void	resetMeldWithNext (void)

void	resetNoMiddleStretch (void)

void	resetSubselect (void)

void	resetValidateStatus ()

int	returnToDefault (void)

void	setColor (int r, int g, int b)

void	setData (QString _sqlColumn, QString _explain, QString tit, QString _tailstr="", bool _editable=true)

void	setEditable (void)

void	setEditBoxMaxWidth (int max)

void	setExplainText (QString expl)

void	setFunction (QString func)

void	setGuidisabled (void)

void	setGuienabled (void)

void	setHide (void)

void	setLogging (void)

void	setMaulallyValidateError (QString message)

void	setNotValidValues (QStringList nvl)

void	setPrintCellNoWrap (void)

void	setPrintCellWidth (int w)

void	setPrintCellWrap (void)

void	setReadonly (void)

void	setShow (void)

void	setSpecDisplaySortMode (QString m)

void	setSubselect (QString subs)

void	setTailText (QString tail)

void	setTitleText (QString titl)

void	setValidator (QString v="")

void	sqlSynced (HDataChangeLogger *dclog=NULL, bool forcechange=false, bool forcelog=false)

void	useRole (QString name)

QString	validate (void)

virtual void	value_changed ()

Public Member Functions inherited from HSqlHandler
	HSqlHandler (void)

	~HSqlHandler (void)

QSqlQuery *	allocateQSqlQuery (void)

void	cloneSqlSettingsFrom (HSqlHandler *other)

void	commit (void)

bool	errorStatus (void)

void	rollback (void)

bool	submit0ResultQuery (QString q, QString err, bool tdisabled=false)

QVariant	submit1ResultQuery (QString q, QString err, bool tdisabled=false)

HPlainDataMatrix *	submitNResultQuery (int N, QString q, QString err, bool tdisabled=false)

void	transaction (void)

QSqlDatabase	workDB (void)

Public Member Functions inherited from HSqlInterface
	HSqlInterface ()

	~HSqlInterface ()

void	cloneSqlInterfaceSettingsFrom (HSqlInterface *other)

HSqlSingleInterface *	myInterface (void)

QString	sqlConcatenateToLocal (QString string)

QString	sqlConcatenateToLocal (QStringList fields)

Public Member Functions inherited from HBase
	HBase (void)

	~HBase (void)

QString	getWhoami (void)

Protected Attributes
long int	maximum

long int	minimum

int	value

Protected Attributes inherited from HDataField
int	color_b

int	color_g

int	color_r

QString	defval

QString	derived

bool	editable

int	editboxmaxwidth

QString	explain

QString	function

bool	guienabled

bool	lastvalidate_result

bool	logged

QString	manual_validate_error

QStringList	markers

bool	meldwithnext

bool	nomiddlestretch

QStringList	notvalid

bool	permanentvalidate_result

QList< HDataFieldRole >	roles

int	set

bool	show

QString	spec_disp_sort

bool	sql

QString	sqlColumn

bool	sync_valueInSql

QString	tailstr

QString	title

QString	valid

QString	valueInSql

bool	wcell_print

int	wcellw_print

Protected Attributes inherited from HSqlHandler
bool	query_error_occured

Protected Attributes inherited from HBase
QString	whoami

Additional Inherited Members
Public Slots inherited from HDataField
void	disableControlSlot (void)

void	enableControlSlot (void)

Signals inherited from HDataField
void	dataChanged (void)

void	disableControl (void)

void	enableControl (void)

void	updateStaticDisplayElementsSignal (void)

Signals inherited from HSqlHandler
void	errorSignal (QString err)

Static Public Member Functions inherited from HSqlHandler
static void	setCustomSqlDatabase (QString databaseName, QString sqlinterfacename="")

static void	setDefaultSqlDatabase (void)

Static Public Member Functions inherited from HSqlInterface
static HSqlSingleInterface *	currentDefaultSqlInterface (void)

static HSqlSingleInterface *	getSqlInterface (QString interfacename)

static void	setSqlMode (QString modename)

static void	setSqlModeBackToFirst (void)

Public Attributes inherited from HDataField
QString	conn_sqlTable

bool	connected

Static Public Attributes inherited from HSqlHandler
static int	trans = 0

Detailed Description

This is a field type class.
HNumber holds an integer value, which is a numeric value in the sql database too.

Gui appearance: Numeric select box, one line high (QSpinBox)

Definition at line 2902 of file datalib.h.

Constructor & Destructor Documentation

HNumber::HNumber	(	QString	sqlc,
		QString	ex,
		QString	tit,
		QString	t,
		QString	def
	)

Creates a HNumber field.

Parameters

sqlc	the sql name of the field
ex	the explain text of the field
tit	the title text of the field
t	the tail string of the field
def	the default text of the field

Definition at line 6269 of file datalib.cpp.

HNumber::~HNumber ( void )

Destructor

Definition at line 6282 of file datalib.cpp.

HNumber::HNumber ( HNumber * t )

Deepcopy constructor

Definition at line 6287 of file datalib.cpp.

Member Function Documentation

virtual bool HNumber::acceptFunction ( void )

inlinevirtual

If this functions returns true then the field accepts sql functions. Otherwise the setFunction() function is do nothing This function can be redefined in descendats!

See Also: setFunction

Reimplemented from HDataField.

Definition at line 2938 of file datalib.h.

virtual bool HNumber::acceptSubselect ( void )

inlinevirtual

If this functions returns true then the field accepts sql subselects instead of read a simple value. Otherwise setSubselect() function is do nothing This function can be redefined in descendats!

See Also: setSubselect

Reimplemented from HDataField.

Definition at line 2939 of file datalib.h.

QVariant HNumber::dbValueToDispValue ( QVariant v )

virtual

Converting function, you can give a HDataFiled(or descendant) value to this function, and you get the corresponding sql value of the given value.
This function usally redefined in descendats!
In simple typed fields this function do a trivial conversion for example a text field do "text"->"'text'" conversion. Other cases where the field is more complex (HSqlChoose for example) this conversion can be more complex.

In HSqlChoose can be:
"Joe Black" -> "id_0123"
"Little Richard" -> "id_03453"
"John Wayne" -> "id_0197"
etc...

In a HCharHash the result can be:
"Animal" -> "a"
"Plant" -> "p"
"Objects" -> "o"
etc...

Reimplemented from HDataField.

Definition at line 6305 of file datalib.cpp.

void HNumber::deepcopy_from ( HNumber * x )

Deepcopy from the given parameter

Definition at line 6293 of file datalib.cpp.

HDataField * HNumber::get_clone ( void )

virtual

Returns a clone of this field

Reimplemented from HDataField.

Definition at line 6300 of file datalib.cpp.

long int HNumber::getMaximum ( void )

inline

Returns the maximum value of the field (check in validation)

Definition at line 2954 of file datalib.h.

long int HNumber::getMinimum ( void )

inline

Returns the minimum value of the field (check in validation)

Definition at line 2952 of file datalib.h.

QString HNumber::getSQLValue ( void )

virtual

Returns the value of the field in that format which accepted by the sql database.

Reimplemented from HDataField.

Definition at line 6343 of file datalib.cpp.

QString HNumber::getSQLValueAsString ( void )

virtual

Returns string format of the field's value. Very similar to getSQLValue() but the result is always acceptable in an sql varchar field. (Mostly used by the logger system, when every kind of values are stored in varchar. The gsafe try to keep the value as close to the original sql database value as possible)

Reimplemented from HDataField.

Definition at line 6348 of file datalib.cpp.

QVariant HNumber::getValue ( void )

virtual

Returns the value of the field.

Reimplemented from HDataField.

Definition at line 6338 of file datalib.cpp.

QString HNumber::lowerValidate ( void )

virtual

Subtype (descendant) specific validation. (In HDataField this function does nothing) Descendants can be redefine this function to handle their validations.

Returns: it returns an empty string if the value passed, otherwise the error string

Reimplemented from HDataField.

Definition at line 6310 of file datalib.cpp.

int HNumber::setDefval ( QVariant v )

virtual

Sets the default value of the field.

Returns: 0 if success.

Reimplemented from HDataField.

Definition at line 6331 of file datalib.cpp.

void HNumber::setMaximum ( long int m )

inline

Sets the maximum value of the field (check in validation)

Definition at line 2950 of file datalib.h.

void HNumber::setMinimum ( long int m )

inline

Sets the minimum value of the field (check in validation)

Definition at line 2948 of file datalib.h.

int HNumber::setValue	(	QVariant	v,
		bool	sdisabled = `false`
	)

virtual

Sets the value of the field.

Parameters

sdisabled if this parameter is true the dataChanged() signal is disabled

Returns: 0 if success.

Reimplemented from HDataField.

Definition at line 6319 of file datalib.cpp.

QString HNumber::sqlCreateStringPart ( QString switches = "" )

virtual

Returns the part of the CREATE TABLE sql command which creates this field

Reimplemented from HDataField.

Definition at line 6373 of file datalib.cpp.

QString HNumber::sqlInsertHead ( void )

virtual

Returns the sql name of the field (in insert) This function can be redefined in descendats!

Reimplemented from HDataField.

Definition at line 6353 of file datalib.cpp.

QString HNumber::sqlInsertValue ( void )

virtual

Returns the sql value of the field (in insert) This function can be redefined in descendats!

Reimplemented from HDataField.

Definition at line 6358 of file datalib.cpp.

QString HNumber::sqlSelectHead ( void )

virtual

Returns the sql name of the field (in select) This function can be redefined in descendats!

Reimplemented from HDataField.

Definition at line 6368 of file datalib.cpp.

QString HNumber::sqlUpdate ( void )

virtual

Returns the sql update part of the field ( name='VALUE' ) This function can be redefined in descendats!

Reimplemented from HDataField.

Definition at line 6363 of file datalib.cpp.

The documentation for this class was generated from the following files:

Public Member Functions

Protected Attributes

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

Member Function Documentation