Reading data from the Query Object
Query Nesnesinden veri okuma
public void getpictures_onClick(JLbsXUIControlEvent event)
{
IClientContext clientContext = event.getClientContext();
IQueryFactory queryFactory = clientContext.getQueryFactory();
QueryParams queryParameters = new QueryParams();
queryParameters.setCustomization(ProjectGlobals.getM_ProjectGUID());
queryParameters.getEnabledTerms().enable("T2");
queryParameters.getParameters().put("P_INFOREF", 3);
QueryBusinessObjects queryBusinessObjects = new QueryBusinessObjects();
JLbsImage imageComponent = (JLbsImage) event.getContainer().getComponentByTag(2000013);
try {
boolean first = queryFactory.first("CQFirmDoc", queryParameters, queryBusinessObjects, 1, false);
if (first) {
for (int i = 0; i < queryBusinessObjects.size(); i++) {
QueryBusinessObject queryBusinessObject = queryBusinessObjects.get(i);
ObjectPropertyValues properties = queryBusinessObject.getProperties();
byte[] byteArrProp = QueryUtil.getByteArrProp(properties, "LDATA");
ImageIcon icon = new ImageIcon(byteArrProp);
imageComponent.setIcon(icon);
}
}
} catch (QueryFactoryException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SessionTimeoutException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SessionReestablishedException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}To read and use material images stored in the database;
Image information is kept on company-dependent COMPANYDOCS table.
The recording format in the database is as follows. InfoRef is the associated material reference, and DOCNR is the image of the image. Because more than one image can be stored.
select DOCNR, LDATA from U_001_COMPANYDOCS where INFOTYPE = 20 AND INFOREF=10 AND DOCTYPE = 0We can read the first image of the material as follows and display it in an image object.
Read material picture
public void readDbimage_onClick(JLbsXUIControlEvent event)
{
int itemRef= 10;
IClientContext clientContext = event.getClientContext();
JLbsXUIPane container = event.getContainer();
MMBOItem item = (MMBOItem) UnityHelper.getBOByReference(clientContext, MMBOItem.class, itemRef, true);
if (item != null)
{
if (item.getMainImages().size() > 0)
{
GOBOAttachedDocument imageObject = item.getMainImages().get(0);
byte[] document = imageObject.getDocument();
ILbsImage imageComponent = (ILbsImage) container.getComponentByTag(2000030);
ImageIcon icon = new ImageIcon(document);
imageComponent.setIcon(icon);
}
}
}Below you can review the event handler source code of the material card. Here are a few examples of how to delete and update.
Material card eventhandler code
package com.lbs.unity.mm.forms;
/**
* <p>Title: MMXEItem </p>
* <p>Description: MMXEItem : XUI event handler for material item </p>
* <p>Copyright: Copyright (c) 2004</p>
* <p>Company: LBS</p>
* @author Turgay Ayta?
* @version 1.0
*/
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.List;
import javax.swing.InputVerifier;
import com.lbs.console.LbsConsole;
import com.lbs.control.interfaces.ILbsComboBox;
import com.lbs.control.interfaces.ILbsComboEdit;
import com.lbs.control.interfaces.ILbsComponent;
import com.lbs.control.interfaces.ILbsImage;
import com.lbs.control.interfaces.ILbsMaskedEdit;
import com.lbs.control.interfaces.ILbsMultiColGroupBox;
import com.lbs.control.interfaces.ILbsNumericEdit;
import com.lbs.control.interfaces.ILbsPopupMenuItem;
import com.lbs.control.interfaces.ILbsRadioButtonGroup;
import com.lbs.controls.JLbsImage;
import com.lbs.data.factory.FactoryParams;
import com.lbs.data.factory.IFactorySearchConstants;
import com.lbs.data.factory.IObjectFactory;
import com.lbs.data.objects.BusinessObjects;
import com.lbs.data.query.IQueryFactory;
import com.lbs.data.query.QueryBusinessObject;
import com.lbs.data.query.QueryBusinessObjects;
import com.lbs.data.query.QueryParams;
import com.lbs.doc.client.ClientDocumentServices;
import com.lbs.globalization.ILbsCultureInfo;
import com.lbs.globalization.JLbsCultureInfoTRTR;
import com.lbs.globalization.JLbsCurrenciesBase;
import com.lbs.grid.interfaces.ILbsGridBase;
import com.lbs.grid.interfaces.ILbsInplaceEditor;
import com.lbs.grid.interfaces.ILbsObjectListGrid;
import com.lbs.grids.GridColumn;
import com.lbs.grids.InplaceComboBoxOptions;
import com.lbs.grids.InplaceDateOptions;
import com.lbs.grids.InplaceEditorInfo;
import com.lbs.grids.InplaceTextOptions;
import com.lbs.grids.event.IGridInplaceSelectBoxListener;
import com.lbs.platform.interfaces.ILbsValidationError;
import com.lbs.platform.interfaces.ILbsValidationResult;
import com.lbs.remoteclient.IClientContext;
import com.lbs.unity.ILbsValidationErrorConstants;
import com.lbs.unity.UnityConstants;
import com.lbs.unity.UnityHelper;
import com.lbs.unity.UnityLanguageHelper;
import com.lbs.unity.am.bo.AMEOObjectTemp;
import com.lbs.unity.bo.GOBOAttachedDocument;
import com.lbs.unity.dialogs.IUODMessageConstants;
import com.lbs.unity.lo.LOHelper;
import com.lbs.unity.mm.MMHelper;
import com.lbs.unity.mm.bo.MMBOAssortConfigAsgs;
import com.lbs.unity.mm.bo.MMBOItem;
import com.lbs.unity.mm.bo.MMBOItemAttribute;
import com.lbs.unity.mm.bo.MMBOItemCardAttributeAsgs;
import com.lbs.unity.mm.bo.MMBOItemConfigForReferences;
import com.lbs.unity.mm.bo.MMBOItemForAssortConfigAsgs;
import com.lbs.unity.mm.bo.MMBOItemForSetItemAssignments;
import com.lbs.unity.mm.bo.MMBOItemLinkForItemConfig;
import com.lbs.unity.mm.bo.MMBOItemUnitAssignment;
import com.lbs.unity.mm.bo.MMBOSetItemAssignments;
import com.lbs.unity.mm.bo.MMBOUnitBarCode;
import com.lbs.unity.mm.bo.MMBOUnitSet;
import com.lbs.unity.mm.bo.MMBOUnitSetInfo;
import com.lbs.unity.mm.bo.MMBOUomDefinition;
import com.lbs.unity.mm.bo.MMBOUomLink;
import com.lbs.unity.mm.bo.MMEOItem;
import com.lbs.unity.mm.bo.MMEOItemImage;
import com.lbs.unity.mm.data.ILbsItemAttributeConstants;
import com.lbs.unity.mm.data.JLbsItemAttributeUtil;
import com.lbs.unity.mm.data.JLbsItemAttributeUtil.Caption;
import com.lbs.unity.mm.data.JLbsLocalizableListEntry;
import com.lbs.util.JLbsStringList;
import com.lbs.util.JLbsStringUtil;
import com.lbs.util.ObjectUtil;
import com.lbs.util.QueryUtil;
import com.lbs.validation.LbsValidationEvent;
import com.lbs.xui.ILbsXUIPane;
import com.lbs.xui.JLbsXUIAdapter;
import com.lbs.xui.JLbsXUIControl;
import com.lbs.xui.JLbsXUIDefinition;
import com.lbs.xui.JLbsXUIEntityRights;
import com.lbs.xui.JLbsXUILookupInfo;
import com.lbs.xui.JLbsXUIPane;
import com.lbs.xui.JLbsXUITypes;
public class MMXEItem extends JLbsXUIAdapter
{
public static final int MODE_ITEM = 0;
public static final int MODE_CLASS = 1;
public static final int MODE_FIXASS = 2;
public static final int MODE_SERVICE = 3;
public static final int MODE_SET = 4;
public static int AUTH_MODE;
public static final int DBERROR_UNITSETCHANGE = -1;
public static final int DBERROR_UNITMODULEASGS = -2;
private static String mainUnitCode = "";
private MMBOItem cloned;
// private boolean generalModified = false;
private boolean unitSetModified = false;
// private boolean optionsModified = false;
// private boolean trackingModified = false;
// private boolean intraStatModified = false;
private ILbsObjectListGrid m_UnitAsgGrid;
private IGridInplaceSelectBoxListener selectBoxListener = null;
private InputVerifier verifier = null;
private BigDecimal volumeTotal = new BigDecimal(0);
private BigDecimal weightTotal = new BigDecimal(0);
private int volumeMainUnitReference = 0;
private int weightMainUnitReference = 0;
private String volumeMainUnitCode = "";
private String weightMainUnitCode = "";
private int imageIndex = 0;
private boolean firstImage = false;
private Integer moduleFlags(MMBOItemUnitAssignment uAsg)
{
int flags = 0;
flags = (uAsg.getMM_Flag() == 0) ? flags : flags + 1;
flags = (uAsg.getPC_Flag() == 0) ? flags : flags + 2;
flags = (uAsg.getSD_Flag() == 0) ? flags : flags + 4;
return new Integer(flags);
}
private String firstBarCode(MMBOItemUnitAssignment uAsg)
{
String barCode = "";
if (uAsg.getBarCodes().size() != 0)
{
MMBOUnitBarCode firstBar = uAsg.getBarCodes().get(0);
barCode = firstBar.getBarCode();
}
return barCode;
}
public ILbsComponent getComponentInstance(JLbsXUIDefinition xuidef, JLbsXUIDefinition rootdef, int mode,
ILbsCultureInfo culture, JLbsCurrenciesBase currencies, IClientContext context, JLbsXUIEntityRights rights, int authMode)
{
if (xuidef.getTag() == 1000044)
return new JLbsImage(false);
return null;
}
public Object gridGetCellValue(ILbsGridBase grid, int row, int column, int columnTag, Object rowData, ILbsXUIPane container,
IClientContext context)
{
if (container.getControl(grid).getTag() == 300)
{
switch (columnTag)
{
case 3103:
return "=";
case 3105:
return mainUnitCode;
case 3107:
return firstBarCode((MMBOItemUnitAssignment) rowData);
case 3109:
return moduleFlags((MMBOItemUnitAssignment) rowData);
}
}
if (container.getControl(grid).getTag() == 2710)
{
MMBOItemCardAttributeAsgs attrAssignment = (MMBOItemCardAttributeAsgs) rowData;
AMEOObjectTemp attributeEO = (AMEOObjectTemp) attrAssignment.getAttributeEO();
switch (columnTag)
{
case 2713:
switch (attributeEO.getType())
{
case ILbsItemAttributeConstants.ATTR_VALUE_TEXT:
return attrAssignment.getValueStr();
case ILbsItemAttributeConstants.ATTR_VALUE_LIST:
if (attributeEO.getCode() == null)
return null;
return attributeEO.getValue();
/*
* case ILbsItemAttributeConstants.ATTR_VALUE_NUMERIC:
* return attrAssignment.getValueNumeric();
*/
case ILbsItemAttributeConstants.ATTR_VALUE_DATE:
return attrAssignment.getValueDate();
}
break;
case 2714:
switch (attributeEO.getType())
{
case ILbsItemAttributeConstants.ATTR_VALUE_TEXT:
// case ILbsItemAttributeConstants.ATTR_VALUE_NUMERIC:
case ILbsItemAttributeConstants.ATTR_VALUE_DATE:
return attrAssignment.getDescription();
case ILbsItemAttributeConstants.ATTR_VALUE_LIST:
if (attributeEO.getCode() == null)
return null;
return attributeEO.getValueDesc();
}
break;
}
}
return null;
}
/**
* @see com.lbs.xui.ILbsXUIEvents#gridSetCellEditValue(ILbsGridBase, int,
* int, Object, ILbsXUIPane, IClientContext)
*/
public boolean gridSetCellEditValue(ILbsGridBase grid, int row, int column, int columnTag, Object value, ILbsXUIPane container,
IClientContext context)
{
if (container.getControl(grid).getTag() == 300)
{
MMBOItem item = (MMBOItem) container.getData();
BusinessObjects uomList = item.getUOMList();
switch (columnTag)
{
case 3109:
if (value instanceof Integer)
{
int flags = ((Integer) value).intValue();
MMBOItemUnitAssignment rowData = (MMBOItemUnitAssignment) uomList.get(row);
rowData.setMM_Flag((flags & 1) != 0 ? 1 : 0);
rowData.setPC_Flag((flags & 2) != 0 ? 1 : 0);
rowData.setSD_Flag((flags & 4) != 0 ? 1 : 0);
return true;
}
}
}
return false;
}
private static void setMainUnitCode(MMBOItem item)
{
BusinessObjects uomList = item.getUOMList();
if (uomList != null)
{
for (int i = 0; i < uomList.size(); i++)
{
MMBOItemUnitAssignment asg = (MMBOItemUnitAssignment) uomList.get(i);
MMBOUomLink def = asg.getUOMDef();
if (def != null && def.getMainUnit() != 0)
{
mainUnitCode = def.getCode();
return;
}
}
}
}
private static MMBOUomLink getUOMLink(IObjectFactory factory, int ref)
{
MMBOUomLink link = null;
if (ref != 0)
link = (MMBOUomLink) UnityHelper.getBOByReference(factory, MMBOUomLink.class, ref);
return (link != null) ? link : new MMBOUomLink();
}
public static boolean recreateUnitsOfItem(Object data, IObjectFactory factory)
{
MMBOItem item = (MMBOItem) data;
MMBOUnitSetInfo uSet = item.getUnitSetInfo();
BusinessObjects uomList = item.getUOMList();
if (uomList == null)
uomList = new Bus...
Copyright © 2018 Logo Yazılım