|
楼主 |
发表于 2015-5-19 13:56:07
|
显示全部楼层
- public static Table querySupplierOfferInfo(){
- String id = ContextHelper.getPerson().getID();
- System.out.println(id);
-
-
- String s = "select y.*,b.fid as nid from " +
- "(select x.*,s.ifCommit from " +
- "(select fid,bidno,bidname,etime from hd_project " +
- "where state='5' " +
- "order by createdate desc " +
- ") x left join hd_supplieroffer s on x.fid=s.pid) y " +
- "left join " +
- "(select fid,pid from HD_BidNotice where bidsupplierid='3D2DE7DA72EB486DB4BB457D439D168D' " +
- ") b on y.fid=b.pid";
-
- Map<String, String> sql = new HashMap<String, String>();
- sql.put(DatabaseProduct.MYSQL.toString(), s);
- Table table = SQL.select(sql, null, "/HDPP/pm/data");
-
- // table.addColumn("fid", "String");
- // table.addColumn("bidno", "String");
- // table.addColumn("bidname", "String");
- // table.addColumn("etime", "DateTime");
- // table.addColumn("nid", "String");
- // table.addColumn("ifCommit", "String");
- table.getProperties().put(Table.PROP_NAME_ROWID, "fid");
-
- return table;
- }
复制代码 |
|