零售前台开票增加字段

String goodsid = resultdbmodel.getItemValue(r, "goodsid");
			sql="select to_char(wm_concat(b.ybname)) as ybname\n" +
					"  from npbusi_yb_goods_ref a, npbusi_yb_company_v b\n" + 
					" where a.ybid = b.ybid\n" + 
					"   and a.goodsid = ? \n" + 
					"   and b.companyid = ? ";
			sh = new SelectHelper(sql);
			sh.bindParam(goodsid);
			sh.bindParam(placepointid);
			DBTableModel ybnamesmodel =sh.executeSelect(con, 0, Integer.MAX_VALUE-1);
			String ybnames="";
			if(!ObjectUtils.isNULL(ybnamesmodel)) {
				ybnames=ybnamesmodel.getItemValue(0, "ybname");
				resultdbmodel.setItemValue(r, "ybnames", ybnames);
			}

江西浩心大药房项目，可以搜相关关键字