Package org.compiere.model

Examples of org.compiere.model.Query

1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
 
  private List<MPPProductBOM> getBOMs(String productValue)
  {
    int ad_client_id = Env.getAD_Client_ID(getCtx());
    String filter = MPPProductBOM.COLUMNNAME_Value+"=? AND AD_Client_ID=?";
    return new Query (getCtx(), MPPProductBOM.Table_Name, filter, null)
          .setParameters(new Object[]{productValue, ad_client_id})
          .list();
   
  }
View Full Code Here
1019
1020
1021
1022
1023
1024
1025
1026
1027
  }
  private List<MPPProductBOM> getBOMs(int M_Product_ID, boolean onlyActiveRecords)
  {
    String filter = MPPProductBOM.COLUMNNAME_M_Product_ID+"=?"
            +(onlyActiveRecords ? " AND IsActive='Y'" : "");
    return new Query(getCtx(), MPPProductBOM.Table_Name, filter, null)
          .setParameters(new Object[]{M_Product_ID})
          .list();
  }
View Full Code Here
1027
1028
1029
1030
1031
1032
1033
1034
1035
  }
 
  private List<MPPProductBOMLine> getBOMLines(int M_Product_ID)
  {
    String filter = MPPProductBOMLine.COLUMNNAME_M_Product_ID+"=?";
    return new Query(getCtx(), MPPProductBOMLine.Table_Name, filter, null)
            .setParameters(new Object[]{M_Product_ID})
            .list();
  }
View Full Code Here
524
525
526
527
528
529
530
531
532
533
534
    public Object getCellEditorValue() {
      String locatorValue = editor.getText();
      MLocator loc = null;
      try {
        // Lookup locator using value
        loc = new Query(Env.getCtx(), MLocator.Table_Name, "value=?", null)
                  .setParameters(new Object[]{locatorValue})
                  .setClient_ID()
                  .first();
        // Set new keyNamePair for minitable
        currentValue = getLocatorKeyNamePair(loc.get_ID());
View Full Code Here
295
296
297
298
299
300
301
302
303
    {
      whereClause.append(" AND ").append(MProduct.COLUMNNAME_ProductType).append("=?");
      params.add(p_ProductType);
    }

    return new Query(getCtx(),MProduct.Table_Name, whereClause.toString(), get_TrxName())
    .setParameters(params)
    .list();
  }
View Full Code Here
251
252
253
254
255
256
257
258
259
260
261
      orderClause.append("M_Requisition_ID, ");
    }
    orderClause.append("(SELECT DateRequired FROM M_Requisition r WHERE M_RequisitionLine.M_Requisition_ID=r.M_Requisition_ID),");
    orderClause.append("M_Product_ID, C_Charge_ID, M_AttributeSetInstance_ID");
   
    POResultSet<MRequisitionLine> rs = new Query(getCtx(), MRequisitionLine.Table_Name, whereClause.toString(), get_TrxName())
                      .setParameters(params)
                      .setOrderBy(orderClause.toString())
                      .setClient_ID()
                      .scroll();
    try
View Full Code Here
511
512
513
514
515
516
517
518
519
520
521
      return true;
   
    if (m_excludedVendors.contains(C_BPartner_ID))
      return false;
    //
    boolean match = new Query(getCtx(), MBPartner.Table_Name, "C_BPartner_ID=? AND C_BP_Group_ID=?", get_TrxName())
    .setParameters(new Object[]{C_BPartner_ID, p_C_BP_Group_ID})
    .match();
    if (!match)
    {
      m_excludedVendors.add(C_BPartner_ID);
View Full Code Here
47
48
49
50
51
52
53
    }
    return true;
  }

  public List<MSCScale> getLines() {
    return new Query(getCtx(), I_SC_Scale.Table_Name, "SC_ServerSettings_ID=?", get_TrxName()).setParameters(get_ID()).list();
  }
View Full Code Here
TOP

Related Classes of org.compiere.model.Query

  • org.compiere.grid.VCreateFromShipmentUI$InnerLocatorTableCellEditor
  • org.compiere.process.RequisitionPOCreate
  • org.eevolution.form.VTreeBOM
  • org.eevolution.process.RollupBillOfMaterial
  • ve.net.dcs.sc.idempiere.model.MSCServerSettings
    • 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.