|
发表于 2014-8-26 11:53:26
|
显示全部楼层
public static Table getEntrustInfo(String sBillID,String sRptType,String sRptID){
String mssql = "select a.*,b.* "
+" from lims_EntrustBill a,lims_AllReportInfo b,"
+" where a.fid=b.fBillID ";
HashMap<String,String> sqlMap = new HashMap<String,String>();
sqlMap.put("MSSQL",mssql);
System.out.print("mssql----"+mssql);
Table table = SQL.select(sqlMap,null,"/gxjc_lims/detectFlow/data");
System.out.println(new com.justep.system.transform.Table2Row().transform(table,null).asXML());
return table;
}
|
|