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;
 }
Example #4
0
        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;
        }