📄 datamodule1.java
字号:
colOrdersShipCountry.setColumnName("SHIPCOUNTRY");
colOrdersShipCountry.setDataType(com.borland.dx.dataset.Variant.STRING);
colOrdersShipCountry.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colOrdersBillAddr1.setColumnName("BILLADDR1");
colOrdersBillAddr1.setDataType(com.borland.dx.dataset.Variant.STRING);
colOrdersBillAddr1.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colOrdersBillAddr2.setColumnName("BILLADDR2");
colOrdersBillAddr2.setDataType(com.borland.dx.dataset.Variant.STRING);
colOrdersBillAddr2.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colOrdersBillCity.setColumnName("BILLCITY");
colOrdersBillCity.setDataType(com.borland.dx.dataset.Variant.STRING);
colOrdersBillCity.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colOrdersBillState.setColumnName("BILLSTATE");
colOrdersBillState.setDataType(com.borland.dx.dataset.Variant.STRING);
colOrdersBillState.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colOrdersBillPostalCode.setColumnName("BILLPOSTALCODE");
colOrdersBillPostalCode.setDataType(com.borland.dx.dataset.Variant.STRING);
colOrdersBillPostalCode.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colOrdersBillCountry.setColumnName("BILLCOUNTRY");
colOrdersBillCountry.setDataType(com.borland.dx.dataset.Variant.STRING);
colOrdersBillCountry.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colOrdersCustomerName.setCalcType(com.borland.dx.dataset.CalcType.CALC);
colOrdersCustomerName.setColumnName("CUSTOMERNAME");
colOrdersCustomerName.setDataType(com.borland.dx.dataset.Variant.STRING);
colOrdersCustomerName.setResolvable(false);
colOrdersCustomerName.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
orderDataSet.setColumns(new Column[] {
colOrdersID,
colOrdersCustomerID,
colOrdersOrderDate,
colOrdersStatus,
colOrdersShipDate,
colOrdersOrderTrackNum,
colOrdersCustomerPONum,
colOrdersPayMethod,
colOrdersCreditCardNum,
colOrdersWirePaymentInstr,
colOrdersShipMethod,
colOrdersAmtPaid,
colOrdersShipName,
colOrdersShipAddr1,
colOrdersShipAddr2,
colOrdersShipCity,
colOrdersShipState,
colOrdersShipPostalCode,
colOrdersShipCountry,
colOrdersBillAddr1,
colOrdersBillAddr2,
colOrdersBillCity,
colOrdersBillState,
colOrdersBillPostalCode,
colOrdersBillCountry,
colOrdersCustomerName
});
// OrderItem
colOrderItemQty.setCaption(res.getString("DM_Qty"));
colOrderItemQty.setColumnName("QTY");
colOrderItemQty.setDataType(com.borland.dx.dataset.Variant.INT);
colOrderItemQty.setDefault("1");
colOrderItemProductID.setCaption(res.getString("DM_Product_ID"));
colOrderItemProductID.setColumnName("PRODUCTID");
colOrderItemProductID.setDataType(com.borland.dx.dataset.Variant.INT);
colOrderItemProductID.addColumnChangeListener(new DataModule1_colOrderItemProductID_columnChangeAdapter(this));
// Create a pickList for the ProductID column of the OrderItem dataset
colOrderItemProductID.setPickList(new com.borland.dx.dataset.PickListDescriptor(productDataSet, new String[] {"ID", "BASEPRICE"}, new String[] {"ID", "NAME", "BASEPRICE"}, new String[] {"PRODUCTID", "SALEPRICE"}, false));
colOrderItemProductName.setCaption(res.getString("DM_Name"));
colOrderItemProductName.setColumnName("PRODUCTNAME");
colOrderItemProductName.setDataType(com.borland.dx.dataset.Variant.STRING);
colOrderItemProductName.setCalcType(com.borland.dx.dataset.CalcType.CALC);
colOrderItemProductName.setEditable(false);
colOrderItemProductName.setResolvable(false);
colOrderItemSalePrice.setCaption(res.getString("DM_Sale_Price"));
colOrderItemSalePrice.setCurrency(true);
colOrderItemSalePrice.setColumnName("SALEPRICE");
colOrderItemSalePrice.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
colOrderItemSalePrice.setLocale(new java.util.Locale("en", "US", ""));
colOrderItemSalePrice.setDefault("0");
colOrderItemExtendedPrice.setCalcType(com.borland.dx.dataset.CalcType.CALC);
colOrderItemExtendedPrice.setCaption(res.getString("DM_Ext_Price"));
colOrderItemExtendedPrice.setCurrency(true);
colOrderItemExtendedPrice.setColumnName("EXTENDEDPRICE");
colOrderItemExtendedPrice.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
colOrderItemExtendedPrice.setLocale(new java.util.Locale("en", "US", ""));
colOrderItemExtendedPrice.setDefault("0");
colOrderItemExtendedPrice.setReadOnly(true);
colOrderItemExtendedPrice.setResolvable(false);
colOrderItemSubtotal.setCalcType(com.borland.dx.dataset.CalcType.AGGREGATE);
colOrderItemSubtotal.setCaption(res.getString("DM_SubTotal"));
colOrderItemSubtotal.setCurrency(true);
colOrderItemSubtotal.setColumnName("SUBTOTAL");
colOrderItemSubtotal.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
colOrderItemSubtotal.setLocale(new java.util.Locale("en", "US", ""));
colOrderItemSubtotal.setDefault("0");
colOrderItemSubtotal.setReadOnly(true);
colOrderItemSubtotal.setResolvable(false);
// Set AggregationDescriptor for calculated column
colOrderItemSubtotal.setAgg(new AggDescriptor( new String[] { "ORDERID" },
"EXTENDEDPRICE",
new SumAggOperator() ));
colOrderItemOrderID.setCaption(res.getString("DM_Order_ID"));
colOrderItemOrderID.setColumnName("ORDERID");
colOrderItemOrderID.setDataType(com.borland.dx.dataset.Variant.INT);
colOrderItemOrderID.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colOrderItemTax.setCaption(res.getString("DM_Tax"));
colOrderItemTax.setCurrency(true);
colOrderItemTax.setCalcType(com.borland.dx.dataset.CalcType.AGGREGATE);
colOrderItemTax.setColumnName("TAX");
colOrderItemTax.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
colOrderItemTax.setLocale(new java.util.Locale("en", "US", ""));
colOrderItemTax.setDefault("0");
colOrderItemTax.setResolvable(false);
// Set AggregationDescriptor for calculated column
colOrderItemTax.setAgg(new AggDescriptor( new String[] { "ORDERID" },
"EXTENDEDPRICE",
null ));
colOrderItemShipping.setCaption(res.getString("DM_Shipping"));
colOrderItemShipping.setCurrency(true);
colOrderItemShipping.setCalcType(com.borland.dx.dataset.CalcType.AGGREGATE);
colOrderItemShipping.setColumnName("SHIPPING");
colOrderItemShipping.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
colOrderItemShipping.setLocale(new java.util.Locale("en", "US", ""));
colOrderItemShipping.setDefault("0");
colOrderItemShipping.setResolvable(false);
// Set AggregationDescriptor for calculated column
colOrderItemShipping.setAgg(new AggDescriptor( new String[] { "ORDERID" },
"EXTENDEDPRICE",
null ));
colOrderItemAmtDue.setCalcType(com.borland.dx.dataset.CalcType.AGGREGATE);
colOrderItemAmtDue.setCaption(res.getString("DM_Amt_Due"));
colOrderItemAmtDue.setCurrency(true);
colOrderItemAmtDue.setColumnName("AMTDUE");
colOrderItemAmtDue.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
colOrderItemAmtDue.setLocale(new java.util.Locale("en", "US", ""));
colOrderItemAmtDue.setDefault("0");
colOrderItemAmtDue.setResolvable(false);
// Set AggregationDescriptor for calculated column
colOrderItemAmtDue.setAgg(new AggDescriptor( new String[] { "ORDERID" },
"EXTENDEDPRICE",
null ));
orderItemDataSet.setColumns(new Column[] {
colOrderItemQty,
colOrderItemProductID,
colOrderItemProductName,
colOrderItemSalePrice,
colOrderItemExtendedPrice,
colOrderItemSubtotal,
colOrderItemOrderID,
colOrderItemTax,
colOrderItemShipping,
colOrderItemAmtDue
});
// Customer
colCustomerID.setCaption(res.getString("DM_CustomerDS_ID"));
colCustomerID.setColumnName("ID");
colCustomerID.setDataType(com.borland.dx.dataset.Variant.INT);
colCustomerFirstName.setCaption(res.getString("DM_CustomerDS_FIRSTNAME"));
colCustomerFirstName.setColumnName("FIRSTNAME");
colCustomerFirstName.setDataType(com.borland.dx.dataset.Variant.STRING);
colCustomerMI.setCaption(res.getString("DM_CustomerDS_MI"));
colCustomerMI.setColumnName("MI");
colCustomerMI.setDataType(com.borland.dx.dataset.Variant.STRING);
colCustomerLastName.setCaption(res.getString("DM_CustomerDS_LASTNAME"));
colCustomerLastName.setColumnName("LASTNAME");
colCustomerLastName.setDataType(com.borland.dx.dataset.Variant.STRING);
colCustomerPhone.setCaption(res.getString("DM_CustomerDS_PHONE"));
colCustomerPhone.setColumnName("PHONE");
colCustomerPhone.setDataType(com.borland.dx.dataset.Variant.STRING);
colCustomerFax.setColumnName("FAX");
colCustomerFax.setDataType(com.borland.dx.dataset.Variant.STRING);
colCustomerFax.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colCustomerEmail.setColumnName("EMAIL");
colCustomerEmail.setDataType(com.borland.dx.dataset.Variant.STRING);
colCustomerEmail.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colCustomerAddr1.setColumnName("ADDR1");
colCustomerAddr1.setDataType(com.borland.dx.dataset.Variant.STRING);
colCustomerAddr1.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colCustomerAddr2.setColumnName("ADDR2");
colCustomerAddr2.setDataType(com.borland.dx.dataset.Variant.STRING);
colCustomerAddr2.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colCustomerCity.setColumnName("CITY");
colCustomerCity.setDataType(com.borland.dx.dataset.Variant.STRING);
colCustomerCity.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colCustomerState.setColumnName("STATE");
colCustomerState.setDataType(com.borland.dx.dataset.Variant.STRING);
colCustomerState.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colCustomerPostalCode.setColumnName("POSTALCODE");
colCustomerPostalCode.setDataType(com.borland.dx.dataset.Variant.STRING);
colCustomerPostalCode.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colCustomerCountry.setColumnName("COUNTRY");
colCustomerCountry.setDataType(com.borland.dx.dataset.Variant.STRING);
colCustomerCountry.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colCustomerShipName.setColumnName("SHIPNAME");
colCustomerShipName.setDataType(com.borland.dx.dataset.Variant.STRING);
colCustomerShipName.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colCustomerShipAddr1.setColumnName("SHIPADDR1");
colCustomerShipAddr1.setDataType(com.borland.dx.dataset.Variant.STRING);
colCustomerShipAddr1.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colCustomerShipAddr2.setColumnName("SHIPADDR2");
colCustomerShipAddr2.setDataType(com.borland.dx.dataset.Variant.STRING);
colCustomerShipAddr2.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colCustomerShipCity.setColumnName("SHIPCITY");
colCustomerShipCity.setDataType(com.borland.dx.dataset.Variant.STRING);
colCustomerShipCity.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colCustomerShipState.setColumnName("SHIPSTATE");
colCustomerShipState.setDataType(com.borland.dx.dataset.Variant.STRING);
colCustomerShipState.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colCustomerShipPostalCode.setColumnName("SHIPPOSTALCODE");
colCustomerShipPostalCode.setDataType(com.borland.dx.dataset.Variant.STRING);
colCustomerShipPostalCode.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colCustomerShipCountry.setColumnName("SHIPCOUNTRY");
colCustomerShipCountry.setDataType(com.borland.dx.dataset.Variant.STRING);
colCustomerShipCountry.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
customerDataSet.setColumns(new Column[] {
colCustomerID,
colCustomerFirstName,
colCustomerMI,
colCustomerLastName,
colCustomerPhone,
colCustomerFax,
colCustomerEmail,
colCustomerAddr1,
colCustomerAddr2,
colCustomerCity,
colCustomerState,
colCustomerPostalCode,
colCustomerCountry,
colCustomerShipName,
colCustomerShipAddr1,
colCustomerShipAddr2,
colCustomerShipCity,
colCustomerShipState,
colCustomerShipPostalCode,
colCustomerShipCountry
});
// Customer Order
colCustOrderID.setColumnName("ID");
colCustOrderID.setDataType(com.borland.dx.dataset.Variant.INT);
colCustOrderID.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colCustOrderCustomerID.setColumnName("CUSTOMERID");
colCustOrderCustomerID.setDataType(com.borland.dx.dataset.Variant.INT);
colCustOrderCustomerID.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colCustOrderOrderDate.setCaption(res.getString("DM_CustOrderDS_ORDERDATE"));
colCustOrderOrderDate.setColumnName("ORDERDATE");
colCustOrderOrderDate.setDisplayMask(res.getString("DM_DateDisplayMask"));
colCustOrderOrderDate.setDataType(com.borland.dx.dataset.Variant.TIMESTAMP);
colCustOrderStatus.setCaption(res.getString("DM_CustOrderDS_STATUS"));
colCustOrderStatus.setColumnName("STATUS");
colCustOrderStatus.setDataType(com.borland.dx.dataset.Variant.STRING);
colCustOrderStatus.addColumnChangeListener(new DataModule1_colOrdersStatus_columnChangeAdapter(this));
colCustOrderShipDate.setCaption(res.getString("DM_CustOrderDS_SHIPDATE"));
colCustOrderShipDate.setColumnName("SHIPDATE");
colCustOrderShipDate.setDisplayMask(res.getString("DM_DateDisplayMask"));
colCustOrderShipDate.setDataType(com.borland.dx.dataset.Variant.TIMESTAMP);
custOrderDataSet.setColumns(new Column[] {
colCustOrderID,
colCustOrderCustomerID,
colCustOrderOrderDate,
colCustOrderStatus,
colCustOrderShipDate
});
// Product
colProductID.setCaption(res.getString("DM_ID"));
colProductID.setColumnName("ID");
colProductID.setDataType(com.borland.dx.dataset.Variant.INT);
colProductIsActive.setCaption(res.getString("DM_Is_Active"));
colProductIsActive.setColumnName("ISACTIVE");
colProductIsActive.setDataType(com.borland.dx.dataset.Variant.SHORT);
colProductIsActive.setDefault("1");
colProductName.setCaption(res.getString("DM_Name"));
colProductName.setColumnName("NAME");
colProductName.setDataType(com.borland.dx.dataset.Variant.STRING);
colProductCategory.setCaption(res.getString("DM_Category"));
colProductCategory.setColumnName("CATEGORY");
colProductCategory.setDataType(com.borland.dx.dataset.Variant.STRING);
colProductCategory.setDefault(res.getString("DM_Active_Wear"));
colProductCategory.setPickList(new com.borland.dx.dataset.PickListDescriptor(categoryDataSet, new String [] { "CATEGORY" }, new String [] { "CATEGORY" }, new String [] { "CATEGORY" }, null, false));
colProductBasePrice.setCaption(res.getString("DM_Base_Price"));
colProductBasePrice.setDisplayMask("#0.00");
colProductBasePrice.setLocale(new java.util.Locale("en", "US", ""));
colProductBasePrice.setColumnName("BASEPRICE");
colProductBasePrice.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
colProductBasePrice.setDefault("0");
colProductBasePrice.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colProductDiscountPct.setCaption(res.getString("DM_Discount_%"));
colProductDiscountPct.setColumnName("DISCOUNTPCT");
colProductDiscountPct.setDisplayMask("##0.00");
colProductDiscountPct.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
colProductDiscountPct.setMax("100");
colProductDiscountPct.setDefault("0");
colProductDiscountPct.setMin("0");
colProductDiscountPct.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
colProductStockQty.setCaption(res.getString("DM_Stock_Qty"));
colProductStockQty.setColumnName("STOCKQTY");
colProductStockQty.setDataType(com.borland.dx.dataset.Variant.INT);
colProductStockQty.setDefault("0");
colProductMinReorderQty.setCaption(res.getString("DM_Min_ReOrder_Qty"));
colProductMinReorderQty.setColumnName("MINREORDERQTY");
colProductMinReorderQty.setDataType(com.borland.dx.dataset.Variant.INT);
colProductMinReorderQty.setDefault("0");
colProductMinReorderQty.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
productDataSet.setColumns(new Column[] {
colProductID,
colProductIsActive,
colProductName,
colProductCategory,
colProductBasePrice,
colProductDiscountPct,
colProductStockQty,
colProductMinReorderQty
});
categoryColumn.setCaption(res.getString("DM_CategoryDS_CATEGORY"));
categoryColumn.setColumnName("CATEGORY");
categoryColumn.setDataType(com.borland.dx.dataset.Variant.STRING);
categoryDataSet.setColumns(new Column[] {categoryColumn});
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -