Package com.sun.star.wizards.db

Examples of com.sun.star.wizards.db.FieldColumn

70
71
72
73
74
75
76
77
78
79
80
        xGridColumnFactory = (XGridColumnFactory) UnoRuntime.queryInterface(XGridColumnFactory.class, oGridModel);
        xComponent = (XComponent) UnoRuntime.queryInterface(XComponent.class, oGridModel);
       
//      Helper.setUnoPropertyValue(oGridModel, "Name", _sname);
        for (int i = 0; i < fieldcolumns.length; i++){ 
            FieldColumn curfieldcolumn = fieldcolumns[i];
            if (curfieldcolumn.FieldType == DataType.TIMESTAMP){
                TimeStampControl oControl = new TimeStampControl(new Resource(_xMSF, "", "dbw"),this, curfieldcolumn);
            }
            else{
                Control oControl = new DatabaseControl(this, curfieldcolumn);
View Full Code Here
230
231
232
233
234
235
236
237
238
239
240
                CurControlRow = oControlRows[i];
                if (CurControlRow.isEnabled()) {
                    if (CurControlRow.isComplete()) {
                        String curFieldName = CurControlRow.getSelectedFieldName();
                        int curOperator = (int) CurControlRow.getSelectedOperator() + 1;
                        FieldColumn CurFieldColumn = oQueryMetaData.getFieldColumnByDisplayName(curFieldName);
                        if (CurFieldColumn.StandardFormatKey == oQueryMetaData.getNumberFormatter().getTextFormatKey())
                            curValue = "'" + CurControlRow.getValue() + "'";
//// TODO the following code is bound to be deprecated as soon as the query composer is able to handle date/time values as numbers
                        else if ((CurFieldColumn.StandardFormatKey == oQueryMetaData.getNumberFormatter().getDateFormatKey()) || (CurFieldColumn.StandardFormatKey == oQueryMetaData.getNumberFormatter().getDateTimeFormatKey())){
                            String sDate = CurControlRow.getDateTimeString(true);
View Full Code Here
292
293
294
295
296
297
298
299
300
301
302
    public static String getDisplayCondition(String _BaseString, PropertyValue _filtercondition, QueryMetaData _CurDBMetaData) {
        try {
            String FieldName;
            if (_CurDBMetaData != null) {
                FieldColumn CurDBFieldColumn = _CurDBMetaData.getFieldColumnByDisplayName(_filtercondition.Name);
                FieldName = CurDBFieldColumn.FieldTitle;
            } else
                FieldName = _filtercondition.Name;
            String sreturn = JavaTools.replaceSubString(_BaseString, FieldName, "<FIELDNAME>");
            String soperator = sLogicOperators[_filtercondition.Handle - 1];
View Full Code Here
129
130
131
132
133
134
135
136
137
138
139
                    case SOFOURTHFIELDNAME:
                        scontrolname = getControlName(EventObject.Source);
                        String scontrolnameSuffix = sIncSuffix + "_" + scontrolname.substring(scontrolname.length() - 1, scontrolname.length());
                        XListBox xCurFieldListBox = (XListBox) UnoRuntime.queryInterface(XListBox.class, CurUnoDialog.xDlgContainer.getControl(scontrolname));
                        String CurDisplayFieldName = xCurFieldListBox.getSelectedItem();
                        FieldColumn CurFieldColumn = new FieldColumn(oQueryMetaData, CurDisplayFieldName);
                        XControl xValueControl = CurUnoDialog.xDlgContainer.getControl("txtValue" + scontrolnameSuffix);
                        XInterface xValueModel = (XInterface) UnoDialog.getModel(xValueControl);
                        Helper.setUnoPropertyValue(xValueModel, "TreatAsNumber", new Boolean(CurFieldColumn.bIsNumberFormat));
                        oQueryMetaData.getNumberFormatter().setNumberFormat(xValueModel, CurFieldColumn.DBFormatKey, oQueryMetaData.getNumberFormatter());
                        break;
View Full Code Here
377
378
379
380
381
382
383
384
385
386
        // throw new UnsupportedOperationException("Not supported yet.");
        final int GroupCount = GroupFieldVector.size();
        if (GroupCount < MAXIMUM_GROUPCOUNT)
        {
            // removeGroupNamesofRecordTable(iSelCount);
            final FieldColumn CurFieldColumn = getRecordParser().getFieldColumnByTitle(CurGroupTitle);
            GroupFieldVector.addElement(CurFieldColumn.FieldName);
        }
        return true;
    }
View Full Code Here
396
397
398
399
400
401
402
403
//    }

    public void liveupdate_removeGroupName(String[] NewSelGroupNames, String CurGroupTitle, Vector GroupFieldVector)
    {
        // throw new UnsupportedOperationException("Not supported yet.");
        final FieldColumn CurFieldColumn = getRecordParser().getFieldColumnByTitle(CurGroupTitle);
        GroupFieldVector.removeElement(CurFieldColumn.FieldName);
    }
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
85
            xComponent = (XComponent) UnoRuntime.queryInterface(XComponent.class, oGridModel);

//      Helper.setUnoPropertyValue(oGridModel, "Name", _sname);
            for (int i = 0; i < fieldcolumns.length; i++)
            {
                FieldColumn curfieldcolumn = fieldcolumns[i];
                if (curfieldcolumn.getFieldType() == DataType.TIMESTAMP)
                {
                    TimeStampControl oControl = new TimeStampControl(new Resource(_xMSF, "", "dbw"), this, curfieldcolumn);
                }
                else
                {
View Full Code Here
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
                    if (CurControlRow.isConditionComplete())
                    {
                        Object aValue;
                        String sFieldName = CurControlRow.getSelectedFieldName();
                        int nOperator = (int) CurControlRow.getSelectedOperator();
                        FieldColumn aFieldColumn = oQueryMetaData.getFieldColumnByDisplayName(sFieldName);
                        if (aFieldColumn.getStandardFormatKey() == oQueryMetaData.getNumberFormatter().getTextFormatKey())
                        {
                            aValue = "'" + CurControlRow.getValue() + "'";
                        }
//// TODO the following code is bound to be deprecated as soon as the query composer is able to handle date/time values as numbers
                        else if ((aFieldColumn.getStandardFormatKey() == oQueryMetaData.getNumberFormatter().getDateFormatKey()) ||
                                (aFieldColumn.getStandardFormatKey() == oQueryMetaData.getNumberFormatter().getDateTimeFormatKey()))
                        {
                            String sDate = CurControlRow.getDateTimeString(true);
                            aValue = "{D '" + sDate + "' }";  // FormatsSupplier
                        }
                        else if (aFieldColumn.getStandardFormatKey() == oQueryMetaData.getNumberFormatter().getTimeFormatKey())
                        {
                            String sTime = CurControlRow.getDateTimeString(true);
                            aValue = "'{T '" + sTime + "' }";
                        }
                        else
                        {
                            aValue = CurControlRow.getValue();
                            // if void
                            if (! AnyConverter.isVoid(aValue))
                            {
                                switch (aFieldColumn.getFieldType())
                                {
                                    case DataType.TINYINT:
                                    case DataType.BIGINT:
                                    case DataType.INTEGER:
                                    case DataType.SMALLINT:
View Full Code Here
403
404
405
406
407
408
409
410
411
412
413
414
        try
        {
            String FieldName;
            if (_CurDBMetaData != null)
            {
                FieldColumn CurDBFieldColumn = _CurDBMetaData.getFieldColumnByDisplayName(_filtercondition.Name);
                FieldName = CurDBFieldColumn.getFieldTitle();
            }
            else
            {
                FieldName = _filtercondition.Name;
            }
View Full Code Here
379
380
381
382
383
384
385
386
387
388
        // throw new UnsupportedOperationException("Not supported yet.");
        final int GroupCount = GroupFieldVector.size();
        if (GroupCount < MAXIMUM_GROUPCOUNT)
        {
            // removeGroupNamesofRecordTable(iSelCount);
            final FieldColumn CurFieldColumn = getRecordParser().getFieldColumnByTitle(CurGroupTitle);
            GroupFieldVector.addElement(CurFieldColumn.getFieldName());
        }
        return true;
    }
View Full Code Here
TOP

Related Classes of com.sun.star.wizards.db.FieldColumn

  • com.sun.star.wizards.document.GridControl
  • com.sun.star.wizards.query.QuerySummary
  • com.sun.star.wizards.reportbuilder.ReportBuilderImplementation
  • com.sun.star.wizards.ui.FilterComponent
  • com.sun.star.wizards.ui.FilterComponent$ItemListenerImpl
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.