贤人必须成人,成人才能达己.

共同进步

  :: :: 博问 :: 闪存 :: 新随笔 :: :: :: 管理 ::

 string dt1 = DateTime.Now.Day.ToString();
                string dt2 = DateTime.Now.AddDays(1).Day.ToString();
                string dt3 = DateTime.Now.AddDays(2).Day.ToString();
                string dt4 = DateTime.Now.AddDays(3).Day.ToString();

                DataTable dtTemp = new DataTable("Result");
                DataColumn dc = new DataColumn("ScheduleID");
                dtTemp.Columns.Add(dc);
                dc = new DataColumn("StartTime");
                dc.DataType = typeof(DateTime);
                dtTemp.Columns.Add(dc);
                dc = new DataColumn("EndStation");
                dtTemp.Columns.Add(dc);
                dc = new DataColumn("StopStation");
                dtTemp.Columns.Add(dc);
                dc = new DataColumn("RouteName");
                dtTemp.Columns.Add(dc);
                dc = new DataColumn("BusType");
                dtTemp.Columns.Add(dc);
                dc = new DataColumn("SeatTypeID");
                dtTemp.Columns.Add(dc);
                dc = new DataColumn("CurrentPrice");
                dc.DataType = typeof(double);
                dtTemp.Columns.Add(dc);
                dc = new DataColumn("RunTime");
                dtTemp.Columns.Add(dc);
                dc = new DataColumn("SellStyleID");
                dtTemp.Columns.Add(dc);
                dc = new DataColumn(dt1.ToString());
                dtTemp.Columns.Add(dc);
                dc = new DataColumn(dt2.ToString());
                dtTemp.Columns.Add(dc);
                dc = new DataColumn(dt3.ToString());
                dtTemp.Columns.Add(dc);
                dc = new DataColumn(dt4.ToString());
                dtTemp.Columns.Add(dc);

                for (int i = 0; i < count; i++)
                {
                    DataRow dr = dtTemp.NewRow();
                    dr["ScheduleID"] = lti[i].ScheduleID;
                    dr["StartTime"] = lti[i].StartTime;
                    dr["EndStation"] = lti[i].EndStation;
                    dr["StopStation"] = lti[i].StopStation;
                    dr["RouteName"] = lti[i].RouteName;
                    dr["BusType"] = BusTypeConvert(int.Parse(lti[i].BusType));
                    dr["SeatTypeID"] = SeatTypeConvert(int.Parse (lti[i].SeatTypeID));
                    dr["CurrentPrice"] = lti[i].CurrentPrice;
                    dr["RunTime"] = lti[i].RunTime;
                    dr["SellStyleID"] = TicketsTypeConvert(lti[i].SellStyleID);
                    dr[dt1.ToString()] = (lti[i].LeftTickets[0].ToString ());
                    dr[dt2.ToString()] = (lti[i].LeftTickets[1].ToString ());
                    dr[dt3.ToString()] = (lti[i].LeftTickets[2].ToString ());
                    dr[dt4.ToString()] = (lti[i].LeftTickets[3].ToString ());
                    dtTemp.Rows.Add(dr);

                }

                //this.dataGridView3
                //this.dataGridView3.GenerateMemeber = false;
               
                this.dataGridView3.AutoGenerateColumns = false;
                Column11.HeaderText = dt1.ToString()+"日";
                Column11.DataPropertyName = dtTemp.Columns[dt1.ToString()].ToString ();
                Column12.HeaderText = dt2.ToString()+"日";
                Column12.DataPropertyName = dtTemp.Columns[dt2.ToString()].ToString();
                Column13.HeaderText = dt3.ToString()+"日";
                Column13.DataPropertyName = dtTemp.Columns[dt3.ToString()].ToString();
                Column14.HeaderText = dt4.ToString()+"日";
                Column14.DataPropertyName = dtTemp.Columns[dt4.ToString()].ToString();
                this.dataGridView3.AllowUserToAddRows = false;
                this.dataGridView3.DataSource = dtTemp;

posted on 2008-02-23 14:44  adi  阅读(538)  评论(0编辑  收藏  举报