public String getUserData() { ReportService rs = new ReportService(); String table = ""; foreach (flight f in flight_list) { table += "<div class=\"hr hr-18 dotted hr-double\"></div><div class=\"flight\"><h1>" + f.flight_name ; table +="<small><i class=\"ace-icon fa fa-angle-double-right\"></i>乘客列表</small></h1>" + "<div class=\"row\"><div class=\"col-xs-12\"><table id=\"simple-table\" class=\"table table-striped table-bordered table-hover\">" +"<thead><tr><th>乘客姓名</th><th>机票等级</th><th class=\"hidden-480\">座位号</th><th>PNR</th>" +"<th class=\"hidden-480\">特殊要求</th></tr></thead>"; table += "<tbody>"; List<order> orderList = rs.getOrderByFlightId(f.flight_id); foreach(order o in orderList) { table += "<tr>"; table += "<td>" + o.user.user_name + "</td>"; table += "<td>" + o.type + "</td>"; BitArray seat = new BitArray(o.seat); int seatNum = 0; for (int i= 0; seatNum < seat.Length; i++ ) { if (seat.Get(i) == true) seatNum = i; } table += "<td class=\"hidden-480\">"+ seatNum +"</td>"; table += "<td>" + o.PNR+ "</td>"; table += "<td class=\"hidden-480\">" + o.SSR + "</td></tr>"; } table += "</tbody></table></div></div></div>"; } return table; }
public String receipt() { ReportService rs = new ReportService(); List<order> orderList = rs.getOrderYesterday(); String html =""; foreach(order o in orderList) { html += "<tr>"; html += "<td>"+ o.user_id +"</td>"; html += "<td>"+ o.user.user_name +"</td>"; html += "<td>"+ o.flight.flight_name +"</td>"; html += "<td>"+ o.payment +"</td>"; html += "</tr>"; } return html; }
public String getData() { ReportService rs = new ReportService(); List<order> oList = rs.getOrderUser(uInDb.user_id); String html = ""; foreach(order o in oList) { html +="<tr>"; html += "<td>"+"<a href=\"#\">32SDAS422D</a>"+"</td>"; html += "<td>"+ o .flight.flight_name+"</td>"; html += "<td>"+ o .flight.departure_date+"</td>"; html += "<td>"+ o .flight.air_line.city_from+"</td>"; html += "<td>"+ o .flight.air_line.city_to+"</td>"; html +="</tr>"; } return html; }
public static String getFlightData() { ReportService rs = new ReportService(); List <flight>flight_list = rs.getFlightByTime(); String table = ""; foreach (flight f in flight_list) { table += "<tr>"; table += "<td>" + f.flight_name + "</td>"; table += "<td>" + f.air_line.city_from + "</td>"; table += "<td class=\"hidden-480\">" + f.air_line.city_to + "</td>"; table += "<td>" + f.air_line.schedule_departure + "</td>"; table += "<td class=\"hidden-480\">" + f.air_line.schedule_arrival + "</td>"; table += "<td>正常</td>"; table += "<td>" + f.air_line.schedule_departure + "</td>"; table += "<td>" + f.air_line.schedule_arrival + "</td>"; table += "</tr>"; } return table; }