//后台通过IUAPqueryBS 访问数据库:
import nc.itf.uap.IUAPQueryBS;
import nc.bs.framework.common.NCLocator;
IUAPQueryBS query=NCLocator.getInstance().lookup(IUAPQueryBS.class);
Object carNum=null;
StringBuffer sql = new StringBuffer();
sql.append("select f.name ");
sql.append(" from so_saleorder a ");
sql.append(" inner join (select distinct b.csourcebillhid, c.cgeneralhid ");
sql.append(" from ic_saleout_b b ");
sql.append(" inner join ic_saleout_h c ");
sql.append(" on b.cgeneralhid = c.cgeneralhid) d &#