Beispiel #1
0
 public static void main(String args[]) throws Exception {
   DBAccess dba = new DBAccess(true);
   GoodsPrice goodPrice = new GoodsPrice();
   String result = goodPrice.getGoodPriceInfo(dba, "00008", DBConst.default_OperatorID, "SR");
   System.out.println("商品单价信息:" + result);
   dba.close();
 }
Beispiel #2
0
 public String getGoodPriceInfo(
     DBAccess dba, String ptypeid, String OperatorID, String priceMode) {
   JSONArray result = new JSONArray();
   try {
     String sql =
         "exec FN_FZGetPriceAndDiscount @ptypeid=?,@priceMode=?,@searStr=N'%%',@OperatorID=?,@shopid=N'0'";
     List<Object> paramList = new ArrayList<Object>();
     paramList.add(ptypeid);
     paramList.add(priceMode);
     paramList.add(OperatorID);
     ResultSet rs = dba.executeQuery(sql, paramList);
     List<GoodsPrice> goodPriceList = new ArrayList<GoodsPrice>();
     while (rs.next()) {
       String displayName = rs.getString("DisplayName"); // 采购价种类
       String price = rs.getString("price"); // 价格
       String priceTypeID = rs.getString("PriceTypeID"); // 采购价种类标识
       GoodsPrice goodPrice = new GoodsPrice();
       goodPrice.setDisplayName(displayName);
       goodPrice.setPrice(price);
       goodPrice.setPriceTypeID(priceTypeID);
       goodPriceList.add(goodPrice);
     }
     result = JSONArray.fromObject(goodPriceList);
   } catch (Exception e) {
     e.printStackTrace();
   }
   return result.toString();
 }