ASP.Net 利用GridView做时间线图 甘特图

利用GridView做时间线图（甘特图）

找了N多种方法，发现做甘特图不是那么简单。

以下是一个GridView配合涂色做成的会议室占用的图表。

DataTable dt = new DataTable();
            dt.Clear();
            string sql = @"SELECT * FROM dbo.ERPMeetingKW ek WHERE ek.MeetingDate>=CAST(CONVERT(NVARCHAR(20),getdate(),23) AS DATE)
                         AND ek.MeetingDate=CAST(CONVERT(NVARCHAR(20),getdate()+2,23) AS DATE)
                         and MeetingRoom='" + Room + "'";
            dt = FTD.DBUnit.DbHelperSQL.GetDataTable(sql);
            for (int n = 0; n < dt.Rows.Count; n++)
            {
                if (dt.Rows[n]["StartTime"].ToString().Substring(3, 2) == "00" &&
                    dt.Rows[n]["EndTime"].ToString().Substring(3, 2) == "00")
                {
                    int m = 0, j = 0;
                    m = int.Parse(dt.Rows[n]["StartTime"].ToString().Substring(0, 2)) + 15;
                    j = int.Parse(dt.Rows[n]["EndTime"].ToString().Substring(0, 2)) + 15;
                    for (int n1 = m; n1 < j; n1++)
                    {
                        GridView1.Rows[c].Cells[n1].BackColor = System.Drawing.Color.LightGreen;
                        GridView1.Rows[c].Cells[n1].ToolTip = "部門:" + dt.Rows[n]["Department"].ToString()
                            + " \n時間:" + dt.Rows[n]["StartTime"].ToString() + "-" + dt.Rows[n]["EndTime"].ToString()
                            + " \n申請人:" + dt.Rows[n]["AddBy"].ToString()
                            + " \n電話:" + dt.Rows[n]["Tel"].ToString();
                    }
                }
                else if (dt.Rows[n]["StartTime"].ToString().Substring(3, 2) == "00" &&
                    dt.Rows[n]["EndTime"].ToString().Substring(3, 2) != "00")
                {
                    int m = 0, j = 0;
                    m = int.Parse(dt.Rows[n]["StartTime"].ToString().Substring(0, 2)) + 15;
                    j = int.Parse(dt.Rows[n]["EndTime"].ToString().Substring(0, 2)) + 15;
                    for (int n1 = m; n1 <= j; n1++)
                    {
                        GridView1.Rows[c].Cells[n1].BackColor = System.Drawing.Color.LightGreen;
                        GridView1.Rows[c].Cells[n1].ToolTip = "部門:" + dt.Rows[n]["Department"].ToString()
                            + " \n時間:" + dt.Rows[n]["StartTime"].ToString() + "-" + dt.Rows[n]["EndTime"].ToString()
                            + " \n申請人:" + dt.Rows[n]["AddBy"].ToString()
                            + " \n電話:" + dt.Rows[n]["Tel"].ToString();
                    }
                }
                else if (dt.Rows[n]["StartTime"].ToString().Substring(3, 2) != "00" &&
                    dt.Rows[n]["EndTime"].ToString().Substring(3, 2) == "00")
                {
                    int m = 0, j = 0;
                    m = int.Parse(dt.Rows[n]["StartTime"].ToString().Substring(0, 2)) + 15;
                    j = int.Parse(dt.Rows[n]["EndTime"].ToString().Substring(0, 2)) + 15;
                    for (int n1 = m; n1 < j; n1++)
                    {
                        GridView1.Rows[c].Cells[n1].BackColor = System.Drawing.Color.LightGreen;
                        GridView1.Rows[c].Cells[n1].ToolTip = "部門:" + dt.Rows[n]["Department"].ToString()
                            + " \n時間:" + dt.Rows[n]["StartTime"].ToString() + "-" + dt.Rows[n]["EndTime"].ToString()
                            + " \n申請人:" + dt.Rows[n]["AddBy"].ToString()
                            + " \n電話:" + dt.Rows[n]["Tel"].ToString();
                    }
                }
                else if (dt.Rows[n]["StartTime"].ToString().Substring(3, 2) != "00" &&
                    dt.Rows[n]["EndTime"].ToString().Substring(3, 2) != "00")
                {
                    int m = 0, j = 0;
                    m = int.Parse(dt.Rows[n]["StartTime"].ToString().Substring(0, 2)) + 15;
                    j = int.Parse(dt.Rows[n]["EndTime"].ToString().Substring(0, 2)) + 15;
                    for (int n1 = m; n1 <= j; n1++)
                    {
                        GridView1.Rows[c].Cells[n1].BackColor = System.Drawing.Color.LightGreen;
                        GridView1.Rows[c].Cells[n1].ToolTip = "部門:" + dt.Rows[n]["Department"].ToString()
                            + " \n時間:" + dt.Rows[n]["StartTime"].ToString() + "-" + dt.Rows[n]["EndTime"].ToString()
                            + " \n申請人:" + dt.Rows[n]["AddBy"].ToString()
                            + " \n電話:" + dt.Rows[n]["Tel"].ToString();
                    }
                }
            }