private List<Tablebill> getTableBill(){
		List<Tablebill> list = new ArrayList<Tablebill>();
		String sql = "select a.ZDBH,a.xfks,a.ZWBH,a.DQJE,a.KZSJ,b.ipadbh ,c.id,c.tableno from "+DataBase.POSNAME+".dbo.B_ZWK as a left join "+DataBase.MENAME+".dbo.transtable as b on a.ZWMC = b.ZWMC left join "+DataBase.MENAME+".dbo.dtable as c on b.ipadbh = c.id where len(a.ZDBH) >1";
		try {
			conn = DataBase.startConn(conn);
			pstmt = conn.prepareStatement(sql);
			rs = pstmt.executeQuery();
			laudsfdfsdfsdyer:
			while(rs.next()){
				Tablebill tb = new Tablebill();
				try{
					tb.setTableid(rs.getInt("id"));
				}catch(Exception e){
					e.printStackTrace();
					break laudsfdfsdfsdyer;
				}
				tb.setTableno(rs.getString("tableno"));
				tb.setSerBillno(rs.getString("ZDBH"));
				tb.setSerTableno(rs.getString("ZWBH"));
				tb.setAmount(rs.getDouble("DQJE"));
				tb.setStarttime(rs.getString("KZSJ"));
				tb.setDinningpeople(rs.getInt("xfks"));
				list.add(tb);

			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return list;
	}