id相同名称不同多条数据，名字进行累加

           

aspx.cs

dataset dst=得到查询所有的信息

//判断订单号
            List<string> listTid = new List<string>();
            foreach (DataRow row in dst.Tables[0].Rows)
            {

//判断是否有重复的id

                if (false == listTid.Contains(row["TOrderId"].ToString()))
                {
                    listTid.Add(row["TOrderId"].ToString());
                }
            }

//创建一个datatable
            DataTable dt = new DataTable();
            dt.Columns.Add("TOrderId");
            dt.Columns.Add("PassengerName");
            dt.Columns.Add("DepartureTime");
            dt.Columns.Add("DepartureAirport");
            dt.Columns.Add("DestinationAirport");
            dt.Columns.Add("FlightNO");
            dt.Columns.Add("UserName");
            dt.Columns.Add("PriceDue");
            dt.Columns.Add("Status");
            foreach (string str in listTid)
            {
                DataRow[] r = dst.Tables[0].Select("TOrderId='" + str + "'");
                DataRow dtrow = dt.NewRow();
                dtrow["TOrderId"] = str;
                string DepartureTime = string.Empty;
                string DepartureAirport = string.Empty;
                string FlightNO = string.Empty;
                string DestinationAirport = string.Empty;
                string strPname = string.Empty;
                string UserName = string.Empty;
                string PriceDue = string.Empty;
                string Status = string.Empty;
                //乘机人累加
                    for (int i = 0; i < r.Length; i++)
                    {
                        //一个订单可能同一个人订二份,显示一个人
                        if (strPname.Contains(r[i]["PassengerName"].ToString()))
                        {
                            strPname = r[i]["PassengerName"].ToString();
                        }
                        else
                        {
                            strPname += r[i]["PassengerName"].ToString() + ",";
                        }
                        DepartureTime = r[i]["DepartureTime"].ToString();
                        DepartureAirport = r[i]["DepartureAirport"].ToString();
                        DestinationAirport = r[i]["DestinationAirport"].ToString();
                        FlightNO = r[i]["FlightNO"].ToString();
                        UserName = r[i]["UserName"].ToString();
                        PriceDue = r[i]["PriceDue"].ToString();
                        Status = r[i]["Status"].ToString();
                    }
                    if (strPname.Contains(','))
                    {
                        strPname = strPname.Substring(0, strPname.Length - 1);
                    }
                dtrow["PassengerName"] = strPname;
                dtrow["DepartureTime"] = DepartureTime;
                dtrow["DestinationAirport"] = DestinationAirport;
                dtrow["DepartureAirport"] = DepartureAirport;
                dtrow["FlightNO"] = FlightNO;
                dtrow["UserName"] = UserName;
                dtrow["PriceDue"] = string.Format("{0:f2}", Convert.ToDecimal(PriceDue));
                dtrow["Status"] = Status;
                dt.Rows.Add(dtrow);
            }