/** * 订购入库列表查询 * * @param orderNo * @return List 查询结果 */ public List orderInList(String orderNo) { List<String[]> orderInfoList = new ArrayList<String[]>(); try { // 查询订购中的某订单零件PO信息 String strHql = "from PoForm as po where po.orderNo= :orderNo and po.orderStatus='B'"; ArrayList<QueryParameter> paramList = new ArrayList<QueryParameter>(); QueryParameter param = new QueryParameter(); param.setName("orderNo"); param.setValue(orderNo); param.setHbType(Hibernate.STRING); paramList.add(param); List<PoForm> orderList = this.getDao().parameterQuery(strHql, paramList); for (int i = 0; orderList != null && i < orderList.size(); i++) { PoForm pf = orderList.get(i); String[] temp = new String[13]; temp[0] = pf.getPoNo().toString(); temp[1] = pf.getStuffNo(); temp[2] = pf.getModelCode(); temp[3] = pf.getSaleNo(); temp[4] = pf.getCustomerName(); temp[5] = pf.getDeliveryTime(); temp[6] = pf.getShippingAddress(); temp[7] = pf.getOrderNum().toString(); temp[8] = Operate.toFix(pf.getPerQuote(), 2); temp[9] = pf.getCreateDate().toLocaleString(); temp[10] = Operate.toFix( pf.getPerQuote() * CommonSearch.getInstance().getExchangeRate(pf.getSaleNo()), 2); temp[11] = pf.getTransportMode(); temp[12] = pf.getSkuCode(); orderInfoList.add(temp); } } catch (Exception e) { e.printStackTrace(); } return orderInfoList; }
private ArrayList queryCondition(SaleDetailForm form) { ArrayList paramList = new ArrayList(); where = " where pa.delFlag=0 and sif.stockStatus = 'A' and sif.stuffNo=pa.stuffNo"; if (form != null) { if (form.getSaleNo() != null && !form.getSaleNo().equals("")) { where = where + " and pa.saleNo like :saleNo"; QueryParameter param = new QueryParameter(); param.setName("saleNo"); param.setValue(form.getSaleNo()); param.setHbType(Hibernate.STRING); paramList.add(param); } if (form.getStuffNo() != null && !form.getStuffNo().equals("")) { where = where + " and pa.stuffNo like :stuffNo "; QueryParameter param = new QueryParameter(); param.setName("stuffNo"); param.setValue(form.getStuffNo()); param.setHbType(Hibernate.STRING); paramList.add(param); } if (form.getSkuCode() != null && !form.getSkuCode().equals("")) { where = where + " and pa.skuCode like :skuCode "; QueryParameter param = new QueryParameter(); param.setName("skuCode"); param.setValue(form.getSkuCode()); param.setHbType(Hibernate.STRING); paramList.add(param); } if (form.getModelCode() != null && !form.getModelCode().equals("")) { where = where + " and pa.modelCode like :modelCode "; QueryParameter param = new QueryParameter(); param.setName("modelCode"); param.setValue(form.getModelCode()); param.setHbType(Hibernate.STRING); paramList.add(param); } if (form.getModelSerialNo() != null && !form.getModelSerialNo().equals("")) { where = where + " and pa.modelSerialNo like :modelSerialNo "; QueryParameter param = new QueryParameter(); param.setName("modelSerialNo"); param.setValue(form.getModelSerialNo()); param.setHbType(Hibernate.STRING); paramList.add(param); } if (form.getCreateBy() != null && form.getCreateBy() != 0) { where = where + " and pa.createBy = :createBy"; QueryParameter param = new QueryParameter(); param.setName("createBy"); param.setValue(form.getCreateBy()); param.setHbType(Hibernate.LONG); paramList.add(param); } if (form.getPartStatus() != null && !form.getPartStatus().equals("")) { where = where + " and pa.partStatus = :partStatus"; QueryParameter param = new QueryParameter(); param.setName("partStatus"); param.setValue(form.getPartStatus()); param.setHbType(Hibernate.STRING); paramList.add(param); } if (form.getInDate1() != null && !form.getInDate1().equals("")) { where += " and pa.createDate >= :inDate1"; QueryParameter param = new QueryParameter(); param.setName("inDate1"); param.setValue(Operate.toDate(form.getInDate1())); param.setHbType(Hibernate.DATE); paramList.add(param); } if (form.getInDate2() != null && !form.getInDate2().equals("")) { where += " and pa.createDate < :inDate2"; QueryParameter param = new QueryParameter(); param.setName("inDate2"); param.setValue(Operate.getNextDate(form.getInDate2())); param.setHbType(Hibernate.DATE); paramList.add(param); } } return paramList; }
private ArrayList queryCondition(RepairPartForm form) { whereIn = " where 1=1 "; ArrayList paramList = new ArrayList(); if (form != null) { if (form.getServiceSheetNo() != null && !"".equals(form.getServiceSheetNo())) { whereIn += " and rsf.serviceSheetNo like :serviceSheetNo"; QueryParameter param = new QueryParameter(); param.setName("serviceSheetNo"); param.setValue(form.getServiceSheetNo()); param.setHbType(Hibernate.STRING); paramList.add(param); } if (form.getSkuCode() != null && !form.getSkuCode().equals("")) { whereIn += " and rsf.skuCode like :skuCode"; QueryParameter param = new QueryParameter(); param.setName("skuCode"); param.setValue(form.getSkuCode()); param.setHbType(Hibernate.STRING); paramList.add(param); } if (form.getStandard() != null && !form.getStandard().equals("")) { whereIn += " and rsf.standard like :standard"; QueryParameter param = new QueryParameter(); param.setName("standard"); param.setValue(form.getStandard()); param.setHbType(Hibernate.STRING); paramList.add(param); } if (form.getStuffNo() != null && !form.getStuffNo().equals("")) { whereIn += " and rsf.stuffNo like :stuffNo"; QueryParameter param = new QueryParameter(); param.setName("stuffNo"); param.setValue(form.getStuffNo()); param.setHbType(Hibernate.STRING); paramList.add(param); } if (form.getSkuUnit() != null && !form.getSkuUnit().equals("")) { whereIn += " and rsf.skuUnit = :skuUnit"; QueryParameter param = new QueryParameter(); param.setName("skuUnit"); param.setValue(form.getSkuUnit()); param.setHbType(Hibernate.STRING); paramList.add(param); } if (form.getRepairPartType() != null && !form.getRepairPartType().equals("")) { whereIn += " and rsf.repairPartType = :repairPartType"; QueryParameter param = new QueryParameter(); param.setName("repairPartType"); param.setValue(form.getRepairPartType()); param.setHbType(Hibernate.STRING); paramList.add(param); } if (form.getRepairPartStatus() != null && !form.getRepairPartStatus().equals("")) { whereIn += " and rsf.repairPartStatus = :repairPartStatus"; QueryParameter param = new QueryParameter(); param.setName("repairPartStatus"); param.setValue(form.getRepairPartStatus()); param.setHbType(Hibernate.STRING); paramList.add(param); } if (form.getWarrantyType() != null && !form.getWarrantyType().equals("")) { whereIn += " and rsf.warrantyType = :warrantyType"; QueryParameter param = new QueryParameter(); param.setName("warrantyType"); param.setValue(form.getWarrantyType()); param.setHbType(Hibernate.STRING); paramList.add(param); } if (form.getCreateBy() != null && form.getCreateBy().longValue() != 0) { whereIn += " and rsf.createBy = :createBy"; QueryParameter param = new QueryParameter(); param.setName("createBy"); param.setValue(form.getCreateBy()); param.setHbType(Hibernate.LONG); paramList.add(param); } if (form.getUpdateBy() != null && form.getUpdateBy().longValue() != 0) { whereIn += " and rsf.updateBy = :updateBy"; QueryParameter param = new QueryParameter(); param.setName("updateBy"); param.setValue(form.getUpdateBy()); param.setHbType(Hibernate.LONG); paramList.add(param); } } return paramList; }