.NET使用Javascript甘特圖Gantt Chart
 
為了從SQL資料抓出後依各種日期產生Gantt Chart,找了網路上的資料,很多都是要付費的,不過要錢的真的比較漂亮。最後找到的這個免費Javascript的甘特圖,請參考:http://www.codeproject.com/Articles/23951/SIcon-Gantt-Chart
 
將Javascript埋入.Net程式中,後端程式撈SQL資料後,產生Javascript程式碼就完成了我的需求。
 
感謝這免費的甘特圖,我稍微改寫了一下,
1. 改
g.AddTaskDetail(new Task(起始日, 終止日, 左邊工作主旨, 進度條右側的文字, 中間黑線完成進度百分比));
g.AddTaskDetail(new Task(起始日, 終止日, 左邊工作主旨, 主旨的hint title, 進度條右側的文字, 進度條的hint title, 中間黑線完成進度百分比));
 
2. 改成如無傳起始日及終止日則不畫出條狀圖,但仍顯示左邊前方的工作說明。
 
 

test.aspx

 

<%@ Page Language="C#" Debug="true"%>

 

<script language="c#" runat="server">

    protected void Page_Load(object sender, EventArgs e)

    {

 

    }

 

protected void Button1_Click(object sender, EventArgs e)    {

string javascriptString = "<script>";

 javascriptString += "var g = new Gantt(document.all.GanttChart);";

javascriptString += "g.AddTaskDetail(new Task('4/11/2012', '4/19/2012', '<b>測試第一項的文字在這裡test</b>', '這是主旨1的title', '不急的工作', 'title測試第一項&#13第二列說明&#13第三列說明文字', 50));"; //&#13 title及alt斷行用

javascriptString += "g.AddTaskDetail(new Task('4/23/2012', '5/2/2012', '&nbsp;&nbsp;&nbsp;測試2test', '這是主旨2的title', 'walile', 'title測試第二項', 50));";

javascriptString += "g.AddTaskDetail(new Task('', '', '<b>測試3test無設日期</b>', 'title3', '工作無日期', 'title測試第三項', '50'));";

javascriptString += "g.AddTaskDetail(new Task('4/8/2012', '4/10/2012', '<b>測試4test</b>', 'title4', 'Adams的工作', 'title測試第四項', 50));";

javascriptString += "g.Draw();";

javascriptString += "<";

javascriptString += "/script>";

ClientScript.RegisterStartupScript(typeof(Page), "", javascriptString);

}

</script>

 

 

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

<script>

function Task(from, to, task, task_title, resource, resource_title, progress)

{

var _from = new Date();        

var _to = new Date();

var _task = task;

var _task_title = task_title;

var _resource = resource;                                                

var _progress = progress;

var _resource_title = resource_title;

var dvArr = from.split('/');

_from.setFullYear(parseInt(dvArr[2], 10), parseInt(dvArr[0], 10) - 1, parseInt(dvArr[1], 10));

dvArr = to.split('/');

_to.setFullYear(parseInt(dvArr[2], 10), parseInt(dvArr[0], 10) - 1, parseInt(dvArr[1], 10));                

 

this.getFrom = function(){ return _from};

this.getTo = function(){ return _to};

this.getTask = function(){ return _task};

this.getTask_title = function(){ return _task_title};

this.getResource = function(){ return _resource};

this.getProgress = function(){ return _progress};

this.getResource_title = function(){ return _resource_title};

}

 

function Gantt(gDiv)

{

var _GanttDiv = gDiv;

var _taskList = new Array();                

this.AddTaskDetail = function(value)

{

_taskList.push(value);

 

}

this.Draw = function()

{

var _offSet = 0;

var _dateDiff = 0;

var _currentDate = new Date();

var _maxDate = new Date();

var _minDate = new Date();        

var _dTemp = new Date();

var _firstRowStr = "<table border=1 style='border-collapse:collapse'><tr><td rowspan='2' width='200px' style='width:200px;'><div class='GTaskTitle' style='width:200px;'>Task</div></td>";

var _thirdRow = "";

var _gStr = "";                

var _colSpan = 0;

var counter = 0;

 

_currentDate.setFullYear(_currentDate.getFullYear(), _currentDate.getMonth(), _currentDate.getDate());

if(_taskList.length > 0)

{

_maxDate.setFullYear(_taskList[0].getTo().getFullYear(), _taskList[0].getTo().getMonth(), _taskList[0].getTo().getDate());

_minDate.setFullYear(_taskList[0].getFrom().getFullYear(), _taskList[0].getFrom().getMonth(), _taskList[0].getFrom().getDate());

for(i = 0; i < _taskList.length; i++)

{

if(Date.parse(_taskList[i].getFrom()) < Date.parse(_minDate))

_minDate.setFullYear(_taskList[i].getFrom().getFullYear(), _taskList[i].getFrom().getMonth(), _taskList[i].getFrom().getDate());

if(Date.parse(_taskList[i].getTo()) > Date.parse(_maxDate))

_maxDate.setFullYear(_taskList[i].getTo().getFullYear(), _taskList[i].getTo().getMonth(), _taskList[i].getTo().getDate());                                                

}

 

//---- Fix _maxDate value for better displaying-----

// Add at least 5 days

 

if(_maxDate.getMonth() == 11) //December

{

if(_maxDate.getDay() + 5 > getDaysInMonth(_maxDate.getMonth() + 1, _maxDate.getFullYear()))                                        

_maxDate.setFullYear(_maxDate.getFullYear() + 1, 1, 5); //The fifth day of next month will be used

else

_maxDate.setFullYear(_maxDate.getFullYear(), _maxDate.getMonth(), _maxDate.getDate() + 5); //The fifth day of next month will be used

}

else

{

if(_maxDate.getDay() + 5 > getDaysInMonth(_maxDate.getMonth() + 1, _maxDate.getFullYear()))                                        

_maxDate.setFullYear(_maxDate.getFullYear(), _maxDate.getMonth() + 1, 5); //The fifth day of next month will be used

else

_maxDate.setFullYear(_maxDate.getFullYear(), _maxDate.getMonth(), _maxDate.getDate() + 5); //The fifth day of next month will be used

}

 

//--------------------------------------------------

 

_gStr = "";

_gStr += "</tr><tr>";

_thirdRow = "<tr><td>&nbsp;</td>";

_dTemp.setFullYear(_minDate.getFullYear(), _minDate.getMonth(), _minDate.getDate());

while(Date.parse(_dTemp) <= Date.parse(_maxDate))

{        

if(_dTemp.getDay() % 6 == 0) //Weekend

{

_gStr += "<td class='GWeekend'><div style='width:24px;'>" + _dTemp.getDate() + "</div></td>";

if(Date.parse(_dTemp) == Date.parse(_currentDate))                                                

_thirdRow += "<td id='GC_" + (counter++) + "' class='GToDay' style='height:" + (_taskList.length * 21) + "'>&nbsp;</td>";

else

_thirdRow += "<td id='GC_" + (counter++) + "' class='GWeekend' style='height:" + (_taskList.length * 21) + "'>&nbsp;</td>";

}

else

{

_gStr += "<td class='GDay'><div style='width:24px;'>" + _dTemp.getDate() + "</div></td>";

if(Date.parse(_dTemp) == Date.parse(_currentDate))                                                

_thirdRow += "<td id='GC_" + (counter++) + "' class='GToDay' style='height:" + (_taskList.length * 21) + "'>&nbsp;</td>";

else

_thirdRow += "<td id='GC_" + (counter++) + "' class='GDay'>&nbsp;</td>";

}

if(_dTemp.getDate() < getDaysInMonth(_dTemp.getMonth() + 1, _dTemp.getFullYear()))

{

if(Date.parse(_dTemp) == Date.parse(_maxDate))

{                                                        

_firstRowStr += "<td class='GMonth' colspan='" + (_colSpan + 1) + "'>" + _dTemp.getFullYear() + "年/" + (_dTemp.getMonth() + 1) + "月</td>";                                                        

}

_dTemp.setDate(_dTemp.getDate() + 1);

_colSpan++;

}                                        

else

{

_firstRowStr += "<td class='GMonth' colspan='" + (_colSpan + 1) + "'>" + _dTemp.getFullYear() + "年/" + (_dTemp.getMonth() + 1) + "月</td>";

_colSpan = 0;

if(_dTemp.getMonth() == 11) //December

{

_dTemp.setFullYear(_dTemp.getFullYear() + 1, 0, 1);

}

else

{

_dTemp.setFullYear(_dTemp.getFullYear(), _dTemp.getMonth() + 1, 1);

}

}                                        

}

_thirdRow += "</tr>";                                 

_gStr += "</tr>" + _thirdRow;                                

_gStr += "</table>";

_gStr = _firstRowStr + _gStr;                                

for(i = 0; i < _taskList.length; i++)

{

if (!isNaN(_taskList[i].getFrom()) && !isNaN(_taskList[i].getTo()))

{

_offSet = (Date.parse(_taskList[i].getFrom()) - Date.parse(_minDate)) / (24 * 60 * 60 * 1000);

_dateDiff = (Date.parse(_taskList[i].getTo()) - Date.parse(_taskList[i].getFrom())) / (24 * 60 * 60 * 1000) + 1;

_gStr += "<div style='position:absolute; top:" + (20 * (i + 2)) + "; left:" + (_offSet * 27 + 204) + "; width:" + (27 * _dateDiff - 1 + 100) + "'><div title='" + _taskList[i].getResource_title() + "' alt='" + _taskList[i].getResource_title() + "' class='GTask' style='float:left; width:" + (27 * _dateDiff - 1) + "px;'>" + getProgressDiv(_taskList[i].getProgress()) + "</div><div style='float:left; padding-left:3'>" + _taskList[i].getResource() + "</div></div>";

_gStr += "<div title='" + _taskList[i].getTask_title() + "' alt='" + _taskList[i].getTask_title() + "' style='position:absolute; top:" + (20 * (i + 2) + 1) + "; left:5px'>" + _taskList[i].getTask() + "</div>";

}

else

{

_gStr += "<div title='" + _taskList[i].getTask_title() + "' alt='" + _taskList[i].getTask_title() + "' style='position:absolute; top:" + (20 * (i + 2) + 1) + "; left:5px'>" + _taskList[i].getTask() + "</div>";

}

}

_GanttDiv.innerHTML = _gStr;

}

}

}                

 

function getProgressDiv(progress)

{

return "<div class='GProgress' style='width:" + progress + "%; overflow:hidden'></div>"

}

// GET NUMBER OF DAYS IN MONTH

function getDaysInMonth(month, year) 

{

 

var days;                

switch(month)

{

case 1:

case 3:

case 5:

case 7:

case 8:

case 10:

case 12:

days = 31;

break;

case 4:

case 6:

case 9:

case 11:

days = 30;

break;

case 2:

if (((year% 4)==0) && ((year% 100)!=0) || ((year% 400)==0))                                

days = 29;                                

else                                                                

days = 28;                                

break;

}

return (days);

}                                

/*----- END OF MY CODE FOR Gantt CHART GENERATOR -----*/

</script>

<style>

/*----- SICON GANTT CHART STYLE CLASSES --------------------------

 * DESCRIPTION        : Theses class is required for SIcon Gantt Chart

 * NOTE                        : Should change the color, the text style only

 *----------------------------------------------------------------*/

.Gantt

{

font-family:tahoma, arial, verdana;

font-size:11px;

}

 

.GTaskTitle

{

font-family:tahoma, arial, verdana;

font-size:11px;

font-weight:bold;

}

 

.GMonth

{

padding-left:5px;

font-family:tahoma, arial, verdana;

font-size:11px;

font-weight:bold;        

}

 

.GToday

{

background-color: #FDFDE0;        

}

 

.GWeekend

{

font-family:tahoma, arial, verdana;

font-size:11px;

background-color:#F5F5F5;

text-align:center;

}

 

.GDay

{

font-family:tahoma, arial, verdana;

font-size:11px;

text-align:center;

}

 

.GTask

{

border-top:1px solid #CACACA;

border-bottom:1px solid #CACACA;

height:14px;

background-color:yellow;

}

 

.GProgress

{

background-color:black;

height:2px;

overflow: hidden;

margin-top:5px;

}

</style>

 

</head>

<body>

<div style="position:relative" class="Gantt" id="GanttChart"></div>

    <form id="form1" runat="server">

<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="確定" />

    </form>

</body>

 

</html>

 

 

arrow
arrow
    全站熱搜

    adamschen9921 發表在 痞客邦 留言(0) 人氣()