概述
摘要：在asp.net上使用GanttMaster甘特图，实现数据异步读取显示，修改显示效果私人化，打印及导出MSProject(.mpp)功能。
一、GANT_MST.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="GANT_MST.aspx.cs" Inherits="WebApp.XMKApp.ZDCB._15_GCJD.GANT_MST" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<meta http-equiv="X-UA-Compatible" content="IE=9; IE=8; IE=7; IE=EDGE"/>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
<title>开店任务甘特图</title>
<link rel=stylesheet href="../../../jQueryGanttMaster/platform.css" type="text/css">
<link rel=stylesheet href="../../../jQueryGanttMaster/libs/dateField/jquery.dateField.css" type="text/css">
<link rel=stylesheet href="../../../jQueryGanttMaster/gantt.css" type="text/css">
<link rel=stylesheet href="../../../jQueryGanttMaster/print.css" type="text/css" media="print">
<script type="text/javascript" src="http://libs.baidu.com/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript" src="http://libs.baidu.com/jqueryui/1.8.22/jquery-ui.min.js "></script>
<script type="text/javascript" src="../../../jQueryGanttMaster/libs/jquery.livequery.min.js"></script>
<script type="text/javascript" src="../../../jQueryGanttMaster/libs/jquery.timers.js"></script>
<script type="text/javascript" src="../../../jQueryGanttMaster/libs/platform.js"></script>
<script type="text/javascript" src="../../../jQueryGanttMaster/libs/date.js"></script>
<script type="text/javascript" src="../../../jQueryGanttMaster/libs/i18nJs.js" charset="gbk"></script>
<script type="text/javascript" src="../../../jQueryGanttMaster/libs/dateField/jquery.dateField.js"></script>
<script type="text/javascript" src="../../../jQueryGanttMaster/libs/JST/jquery.JST.js"></script>
<link rel="stylesheet" type="text/css" href="../../../jQueryGanttMaster/libs/jquery.svg.css">
<script type="text/javascript" src="../../../jQueryGanttMaster/libs/jquery.svg.min.js"></script>
<!--In case of jquery 1.7-->
<!--<script type="text/javascript" src="libs/jquery.svgdom.pack.js"></script>-->
<!--In case of jquery 1.8-->
<script type="text/javascript" src="../../../jQueryGanttMaster/libs/jquery.svgdom.1.8.js"></script>
<script type="text/javascript" src="../../../jQueryGanttMaster/ganttUtilities.js"></script>
<script type="text/javascript" src="../../../jQueryGanttMaster/ganttTask.js"></script>
<script type="text/javascript" src="../../../jQueryGanttMaster/ganttDrawerSVG.js"></script>
<!--<script src="ganttDrawer.js"></script>-->
<script type="text/javascript" src="../../../jQueryGanttMaster/ganttGridEditor.js"></script>
<script type="text/javascript" src="../../../jQueryGanttMaster/ganttMaster.js"></script>
</head>
<body style="background-color: #fff;">
<div id="query_hint" class="query_hint" style="display:none;">
<img src="../../../jQuery-EasyUI/themes/default/images/loading.gif" />正在导出，请等待...
</div>
<div id="workSpace" style="padding:0px; overflow-y:auto; overflow-x:hidden;border:1px solid #e5e5e5;position:relative;margin:0 5px"></div>
<div id="taZone" style="display:none;" class="noprint">
<textarea rows="8" cols="150" id="ta">
{"tasks":[
{"id":-1,"name":"Gantt editor","code":"","level":0,"status":"STATUS_ACTIVE","canWrite":true,"start":1396994400000,"duration":21,"end":1399672799999,"startIsMilestone":true,"endIsMilestone":false,"collapsed":false,"assigs":[],"hasChild":true}
,{"id":-2,"name":"coding","code":"","level":1,"status":"STATUS_ACTIVE","canWrite":true,"start":1396994400000,"duration":10,"end":1398203999999,"startIsMilestone":false,"endIsMilestone":false,"collapsed":false,"assigs":[],"description":"","progress":0,"hasChild":true}
,{"id":-3,"name":"gantt part","code":"","level":2,"status":"STATUS_ACTIVE","canWrite":true,"start":1396994400000,"duration":2,"end":1397167199999,"startIsMilestone":false,"endIsMilestone":false,"collapsed":false,"assigs":[],"depends":"","hasChild":false}
,{"id":-4,"name":"editor part","code":"","level":2,"status":"STATUS_SUSPENDED","canWrite":true,"start":1397167200000,"duration":4,"end":1397685599999,"startIsMilestone":false,"endIsMilestone":false,"collapsed":false,"assigs":[],"depends":"3","hasChild":false}
,{"id":-5,"name":"testing","code":"","level":1,"status":"STATUS_SUSPENDED","canWrite":true,"start":1398981600000,"duration":6,"end":1399672799999,"startIsMilestone":false,"endIsMilestone":false,"collapsed":false,"assigs":[],"depends":"2:5","description":"","progress":0,"hasChild":true}
,{"id":-6,"name":"test on safari","code":"","level":2,"status":"STATUS_SUSPENDED","canWrite":true,"start":1398981600000,"duration":2,"end":1399327199999,"startIsMilestone":false,"endIsMilestone":false,"collapsed":false,"assigs":[],"depends":"","hasChild":false}
,{"id":-7,"name":"test on ie","code":"","level":2,"status":"STATUS_SUSPENDED","canWrite":true,"start":1399327200000,"duration":3,"end":1399586399999,"startIsMilestone":false,"endIsMilestone":false,"collapsed":false,"assigs":[],"depends":"6","hasChild":false}
,{"id":-8,"name":"test on chrome","code":"","level":2,"status":"STATUS_SUSPENDED","canWrite":true,"start":1399327200000,"duration":2,"end":1399499999999,"startIsMilestone":false,"endIsMilestone":false,"collapsed":false,"assigs":[],"depends":"6","hasChild":false}
],"selectedRow":0,"canWrite":true,"canWriteOnParent":true} </textarea>
<button οnclick="loadGanttFromServer();">load</button>
</div>
<style>
.resEdit {
padding: 15px;
}
.resLine {
width: 95%;
padding: 3px;
margin: 5px;
border: 1px solid #d0d0d0;
}
body {
overflow: hidden;
}
.ganttButtonBar h1{
color: #000000;
font-weight: bold;
font-size: 28px;
margin-left: 10px;
}
</style>
<style>
.query_hint{
border:5px solid #939393;
width:250px;
height:50px;
line-height:55px;
padding:0 20px;
position:absolute;
left:50%;
margin-left:-140px;
top:50%;
margin-top:-40px;
font-size:15px;
color:#333;
font-weight:bold;
text-align:center;
background-color:#f9f9f9;
}
.query_hint img{position:relative;top:10px;left:-8px;}
</style>
<form id="gimmeBack" style="display:none;" action="../gimmeBack.jsp" method="post" target="_blank"><input type="hidden" name="prj" id="gimBaPrj"></form>
<script type="text/javascript">
//显示等待效果
function show_query_hint(query_hint) {
var query_hint = document.getElementById(query_hint);
query_hint.style.display = "block";
}
//关闭等待效果
function queryHintCallback(query_hint) {
var query_hint = document.getElementById(query_hint);
query_hint.style.display = "none";
}
function GetQueryString(name) {
var reg = new RegExp("(^|&)" + name + "=([^&]*)(&|$)");
var r = window.location.search.substr(1).match(reg);
//if (r != null) return unescape(r[2]); return null;
if (r != null) return r[2]; return null;
}
var gKDJHNO;
var gBASENOPostData;
var ge; //this is the hugly but very friendly global var for the gantt editor
$(function () {
queryHintCallback('query_hint');
//load templates
$("#ganttemplates").loadTemplates();
// here starts gantt initialization
ge = new GanttMaster();
ge.canWriteOnParent = false;
ge.canWrite = false;
var workSpace = $("#workSpace");
workSpace.css({ width: $(window).width() - 20, height: $(window).height() - 40 });
ge.init(workSpace);
//inject some buttons (for this demo only)
//.append("<button οnclick='clearGantt();' class='button'>clear</button>").append(" ")
// $(".ganttButtonBar div")
// .append("<button οnclick='getFile();' class='button'>导出</button>");
$(".ganttButtonBar h1").html("<a href='' title='Twproject the friendly project and work management tool' target='_blank'><img width='80%' src='res/twBanner.jpg'></a>");
$(".ganttButtonBar div").addClass('buttons');
//overwrite with localized ones
loadI18n();
//simulate a data load from a server.
loadGanttFromServer();
//fill default Teamwork roles if any
if (!ge.roles || ge.roles.length == 0) {
setRoles();
}
//fill default Resources roles if any
if (!ge.resources || ge.resources.length == 0) {
setResource();
}
/*/debug time scale
$(".splitBox2").mousemove(function(e){
var x=e.clientX-$(this).offset().left;
var mill=Math.round(x/(ge.gantt.fx) + ge.gantt.startMillis)
$("#ndo").html(x+" "+new Date(mill))
});*/
$(window).resize(function () {
workSpace.css({ width: $(window).width() - 20, height: $(window).height() - 40 });
workSpace.trigger("resize.gantt");
})
});
function loadGanttFromServer(taskId, callback) {//(taskId,callback) old param
//this is a simulation: load data from the local storage if you have already played with the demo or a textarea with starting demo data
//loadFromLocalStorage();
//this is the real implementation
//var taskId = $("#taskSelector").val();
var prof = new Profiler("loadServerSide");
prof.reset();
var postData;
var KDJHNO = GetQueryString('KDJHNO');
gKDJHNO = KDJHNO;
if (KDJHNO == null || KDJHNO == '') {
var BASENO = GetQueryString('BASENO');
if (BASENO == null || BASENO == '') {
return;
}
var ItemName = GetQueryString('ItemName');
var PBDATE_FROM = GetQueryString('PBDATE_FROM');
var PBDATE_TO = GetQueryString('PBDATE_TO');
var DEPT = GetQueryString('DEPT');
postData = {
action: "GetProject"
, BASENO: BASENO
, ItemName: ItemName
, PBDATE_FROM: PBDATE_FROM
, PBDATE_TO: PBDATE_TO
, DEPT: DEPT
};
gBASENOPostData = postData;
} else {
postData = {
action: "GetGanttData"
, KDJHNO: KDJHNO
};
}
$.getJSON("GANT_MSTServer.ashx", postData, function (msg) {
//console.debug(response);
if (msg.Statue == "ok") {
prof.stop();
ge.loadProject(msg.data);
ge.checkpoint(); //empty the undo stack
if (typeof(callback)=="function") {
callback(msg);
}
} else {
alert(msg.data);
}
});
}
function saveGanttOnServer() {
if (!ge.canWrite)
return;
//this is a simulation: save data to the local storage or to the textarea
saveInLocalStorage();
/*
var prj = ge.saveProject();
delete prj.resources;
delete prj.roles;
var prof = new Profiler("saveServerSide");
prof.reset();
if (ge.deletedTaskIds.length>0) {
if (!confirm("TASK_THAT_WILL_BE_REMOVEDn"+ge.deletedTaskIds.length)) {
return;
}
}
$.ajax("ganttAjaxController.jsp", {
dataType:"json",
data: {CM:"SVPROJECT",prj:JSON.stringify(prj)},
type:"POST",
success: function(response) {
if (response.ok) {
prof.stop();
if (response.project) {
ge.loadProject(response.project); //must reload as "tmp_" ids are now the good ones
} else {
ge.reset();
}
} else {
var errMsg="Errors saving projectn";
if (response.message) {
errMsg=errMsg+response.message+"n";
}
if (response.errorMessages.length) {
errMsg += response.errorMessages.join("n");
}
alert(errMsg);
}
}
});
*/
}
//------------------------------------------- Create some demo data ------------------------------------------------------
function setRoles() {
ge.roles = [
{
id: "tmp_1",
name: "Project Manager"
},
{
id: "tmp_2",
name: "Worker"
},
{
id: "tmp_3",
name: "Stakeholder/Customer"
}
];
}
function setResource() {
var res = [];
for (var i = 1; i <= 10; i++) {
res.push({ id: "tmp_" + i, name: "Resource " + i });
}
ge.resources = res;
}
function editResources() {
}
function clearGantt() {
ge.reset();
}
function loadI18n() {
GanttMaster.messages = {
"CANNOT_WRITE": "不能编辑",
"CHANGE_OUT_OF_SCOPE": "没有超出编辑范围更新父级的权限",
"START_IS_MILESTONE": "开始是里程碑",
"END_IS_MILESTONE": "结束时里程碑",
"TASK_HAS_CONSTRAINTS": "任务包含约束",
"GANTT_ERROR_DEPENDS_ON_OPEN_TASK": "错误：特定于开放的任务",
"GANTT_ERROR_DESCENDANT_OF_CLOSED_TASK": "错误：衍生于关闭的任务",
"TASK_HAS_EXTERNAL_DEPS": "任务包含外部依赖",
"GANTT_ERROR_LOADING_DATA_TASK_REMOVED": "错误：加载被删除的任务",
"ERROR_SETTING_DATES": "日期时间设置错误（依赖时间关系或父级任务工期）",
"CIRCULAR_REFERENCE": "有无限循环参照",
"CANNOT_DEPENDS_ON_ANCESTORS": "不能依赖父级任务",
"CANNOT_DEPENDS_ON_DESCENDANTS": "不能依赖子级任务",
"INVALID_DATE_FORMAT": "无效日期格式",
"TASK_MOVE_INCONSISTENT_LEVEL": "任务移动非连续级别",
"GANTT_QUARTER_SHORT": "trim.",
"GANTT_SEMESTER_SHORT": "sem."
};
}
//------------------------------------------- Get project file as JSON (used for migrate project from gantt to Teamwork) ------------------------------------------------------
function getFile() {
$("#gimBaPrj").val(JSON.stringify(ge.saveProject()));
$("#gimmeBack").submit();
$("#gimBaPrj").val("");
/* var uriContent = "data:text/html;charset=utf-8," + encodeURIComponent(JSON.stringify(prj));
neww=window.open(uriContent,"dl");*/
}
function exportMpp() {
//var prjData = JSON.stringify(ge.saveProject());
var prjData = ge.saveProject();
if (prjData == null || prjData.length <= 0) {
alert('没有数据，不能导出');
return;
}
var postData;
if (gKDJHNO == null || gKDJHNO == '') {
postData = {
action: "ExportMppExt"
, BASENO: gBASENOPostData.BASENO
, ItemName: gBASENOPostData.ItemName
, PBDATE_FROM: gBASENOPostData.PBDATE_FROM
, PBDATE_TO: gBASENOPostData.PBDATE_TO
, DEPT: gBASENOPostData.DEPT
//, JSON_DATA: JSON.stringify(prjData)
};
} else {
postData = {
action: "ExportMpp"
, KDJHNO: gKDJHNO
//, JSON_DATA: JSON.stringify(prjData)
};
}
//show_query_hint
$.ajax({
url: 'GANT_MSTServer.ashx',
type: 'POST',
data: postData,
dataType: 'json',
async: true,
beforeSend: function (XMLHttpRequest) {
show_query_hint('query_hint');
},
success: function (msg) {
queryHintCallback('query_hint');
if (msg.Statue == "ok") {
downloadMpp(msg.data);
} else {
alert(msg.data);
}
},
error: function (XMLHttpRequest, textStatus, errorThrown) {
alert(errorThrown);
queryHintCallback('query_hint');
}
});
}
function downloadMpp(mppname) {
var formData = [];
var form = $("<form>"); //定义一个form表单
form.attr("style", "display:none");
form.attr("target", "");
form.attr("method", "post");
form.attr("action", "GANT_MSTServer.ashx?action=DownloadMpp&FILE=" + mppname);
$("body").append(form);
for (var i = 0; i < formData.length; i++) {
var input = $("<input>");
input.attr("type", "hidden");
input.attr("name", "" + formData[i].name + "");
input.attr("value", formData[i].value);
form.append(input);
}
try {
form.submit(); //表单提交
} catch (e) {
alert(e);
}
}
//------------------------------------------- LOCAL STORAGE MANAGEMENT (for this demo only) ------------------------------------------------------
Storage.prototype.setObject = function (key, value) {
this.setItem(key, JSON.stringify(value));
};
Storage.prototype.getObject = function (key) {
return this.getItem(key) && JSON.parse(this.getItem(key));
};
function loadFromLocalStorage() {
var ret;
if (localStorage) {
if (localStorage.getObject("teamworkGantDemo")) {
ret = localStorage.getObject("teamworkGantDemo");
}
} else {
$("#taZone").show();
}
if (!ret || !ret.tasks || ret.tasks.length == 0) {
ret = JSON.parse($("#ta").val());
//actualiza data
var offset = new Date().getTime() - ret.tasks[0].start;
for (var i = 0; i < ret.tasks.length; i++)
ret.tasks[i].start = ret.tasks[i].start + offset;
}
ge.loadProject(ret);
ge.checkpoint(); //empty the undo stack
}
function saveInLocalStorage() {
var prj = ge.saveProject();
if (localStorage) {
localStorage.setObject("teamworkGantDemo", prj);
} else {
$("#ta").val(JSON.stringify(prj));
}
}
//------------------------------------------- Open a black popup for managing resources. This is only an axample of implementation (usually resources come from server) ------------------------------------------------------
function editResources() {
//make resource editor
var resourceEditor = $.JST.createFromTemplate({}, "RESOURCE_EDITOR");
var resTbl = resourceEditor.find("#resourcesTable");
for (var i = 0; i < ge.resources.length; i++) {
var res = ge.resources[i];
resTbl.append($.JST.createFromTemplate(res, "RESOURCE_ROW"))
}
//bind add resource
resourceEditor.find("#addResource").click(function () {
resTbl.append($.JST.createFromTemplate({ id: "new", name: "resource" }, "RESOURCE_ROW"))
});
//bind save event
resourceEditor.find("#resSaveButton").click(function () {
var newRes = [];
//find for deleted res
for (var i = 0; i < ge.resources.length; i++) {
var res = ge.resources[i];
var row = resourceEditor.find("[resId=" + res.id + "]");
if (row.size() > 0) {
//if still there save it
var name = row.find("input[name]").val();
if (name && name != "")
res.name = name;
newRes.push(res);
} else {
//remove assignments
for (var j = 0; j < ge.tasks.length; j++) {
var task = ge.tasks[j];
var newAss = [];
for (var k = 0; k < task.assigs.length; k++) {
var ass = task.assigs[k];
if (ass.resourceId != res.id)
newAss.push(ass);
}
task.assigs = newAss;
}
}
}
//loop on new rows
resourceEditor.find("[resId=new]").each(function () {
var row = $(this);
var name = row.find("input[name]").val();
if (name && name != "")
newRes.push(new Resource("tmp_" + new Date().getTime(), name));
});
ge.resources = newRes;
closeBlackPopup();
ge.redraw();
});
var ndo = createBlackPage(400, 500).append(resourceEditor);
}
//------------------------print() xuezt add ----------------------------------
function printPage() {
print();
}
function myPrint() {
bdhtml = window.document.body.innerHTML;
sprnstr = "<!--startprint-->";
eprnstr = "<!--endprint-->";
//debugger;
prnhtml = bdhtml.substr(bdhtml.indexOf(sprnstr) + 17);
prnhtml = prnhtml.substring(0, prnhtml.indexOf(eprnstr));
prnhtml = $('#workSpace').html();
var newBdhtml = '';
newBdhtml = newBdhtml + '<!doctype html>';
newBdhtml = newBdhtml + '<html lang="en">';
newBdhtml = newBdhtml + ' <head>';
newBdhtml = newBdhtml + ' <meta charset="gb2312">';
newBdhtml = newBdhtml + ' <meta http-equiv="X-UA-Compatible" content="IE=Edge;chrome=1" >';
newBdhtml = newBdhtml + ' <link rel=stylesheet href="../../../jQueryGanttMaster/platform.css" type="text/css">';
newBdhtml = newBdhtml + ' <link rel=stylesheet href="../../../jQueryGanttMaster/libs/dateField/jquery.dateField.css" type="text/css">';
newBdhtml = newBdhtml + ' <link rel=stylesheet href="../../../jQueryGanttMaster/gantt.css" type="text/css">';
newBdhtml = newBdhtml + ' <link rel=stylesheet href="../../../jQueryGanttMaster/print.css" type="text/css" media="print">';
newBdhtml = newBdhtml + ' <script type="text/javascript" src="http://libs.baidu.com/jquery/1.8.3/jquery.min.js"></script>';
newBdhtml = newBdhtml + ' <script type="text/javascript" src="http://libs.baidu.com/jqueryui/1.8.22/jquery-ui.min.js "></script>';
newBdhtml = newBdhtml + ' <script type="text/javascript" src="../../../jQueryGanttMaster/libs/jquery.livequery.min.js"></script>';
newBdhtml = newBdhtml + ' <script type="text/javascript" src="../../../jQueryGanttMaster/libs/jquery.timers.js"></script>';
newBdhtml = newBdhtml + ' <script type="text/javascript" src="../../../jQueryGanttMaster/libs/platform.js"></script>';
newBdhtml = newBdhtml + ' <script type="text/javascript" src="../../../jQueryGanttMaster/libs/date.js"></script>';
newBdhtml = newBdhtml + ' <script type="text/javascript" src="../../../jQueryGanttMaster/libs/i18nJs.js" charset="gbk"></script>';
newBdhtml = newBdhtml + ' <script type="text/javascript" src="../../../jQueryGanttMaster/libs/dateField/jquery.dateField.js"></script>';
newBdhtml = newBdhtml + ' <script type="text/javascript" src="../../../jQueryGanttMaster/libs/JST/jquery.JST.js"></script>';
newBdhtml = newBdhtml + ' <link rel="stylesheet" type="text/css" href="../../../jQueryGanttMaster/libs/jquery.svg.css">';
newBdhtml = newBdhtml + ' <script type="text/javascript" src="../../../jQueryGanttMaster/libs/jquery.svg.min.js"></script>';
newBdhtml = newBdhtml + ' <script type="text/javascript" src="../../../jQueryGanttMaster/libs/jquery.svgdom.1.8.js"></script>';
newBdhtml = newBdhtml + ' <script type="text/javascript" src="../../../jQueryGanttMaster/ganttUtilities.js"></script>';
newBdhtml = newBdhtml + ' <script type="text/javascript" src="../../../jQueryGanttMaster/ganttTask.js"></script>';
newBdhtml = newBdhtml + ' <script type="text/javascript" src="../../../jQueryGanttMaster/ganttDrawerSVG.js"></script>';
newBdhtml = newBdhtml + ' <script type="text/javascript" src="../../../jQueryGanttMaster/ganttGridEditor.js"></script>';
newBdhtml = newBdhtml + ' <script type="text/javascript" src="../../../jQueryGanttMaster/ganttMaster.js"></script>';
newBdhtml = newBdhtml + ' </head>';
newBdhtml = newBdhtml + ' <body class="easyui-layout">';
newBdhtml = newBdhtml + prnhtml;
newBdhtml = newBdhtml + ' </body>';
newBdhtml = newBdhtml + '</html>';
var newwindow = window.open("", "甘特图打印");
//newwindow.document.write("abcdefg");
//newwindow.document.body.innerHTML = prnhtml;
newwindow.document.write(newBdhtml);
newwindow.print();
}
</script>
<div id="gantEditorTemplates" style="display:none;">
<!-- 可替换 -->
<div class="__template__" type="GANTBUTTONS">
<div class="ganttButtonBar noprint">
<%--<h1 style="float:left">task tree/gantt</h1>--%>
<div class="buttons">
<%--<button οnclick="$('#workSpace').trigger('undo.gantt');" class="button textual" title="撤销"><span class="teamworkIcon">'</span></button>
<button οnclick="$('#workSpace').trigger('redo.gantt');" class="button textual" title="重做"><span class="teamworkIcon">·</span></button>
<span class="ganttButtonSeparator"></span>
<button οnclick="$('#workSpace').trigger('addAboveCurrentTask.gantt');" class="button textual" title="上面插入"><span class="teamworkIcon">l</span></button>
<button οnclick="$('#workSpace').trigger('addBelowCurrentTask.gantt');" class="button textual" title="下面插入"><span class="teamworkIcon">X</span></button>
<span class="ganttButtonSeparator"></span>
<button οnclick="$('#workSpace').trigger('indentCurrentTask.gantt');" class="button textual" title="留守空格"><span class="teamworkIcon">.</span></button>
<button οnclick="$('#workSpace').trigger('outdentCurrentTask.gantt');" class="button textual" title="非留守空格"><span class="teamworkIcon">:</span></button>
<span class="ganttButtonSeparator"></span>
<button οnclick="$('#workSpace').trigger('moveUpCurrentTask.gantt');" class="button textual" title="上移"><span class="teamworkIcon">k</span></button>
<button οnclick="$('#workSpace').trigger('moveDownCurrentTask.gantt');" class="button textual" title="下移"><span class="teamworkIcon">j</span></button>
<span class="ganttButtonSeparator"></span>--%>
<button οnclick="$('#workSpace').trigger('zoomMinus.gantt');" class="button textual" title="缩小"><span class="teamworkIcon">)</span></button>
<button οnclick="$('#workSpace').trigger('zoomPlus.gantt');" class="button textual" title="放大"><span class="teamworkIcon">(</span></button>
<%--<span class="ganttButtonSeparator"></span>--%>
<%--<button οnclick="$('#workSpace').trigger('deleteCurrentTask.gantt');" class="button textual" title="删除"><span class="teamworkIcon">¢</span></button>--%>
<span class="ganttButtonSeparator"></span>
<%--<button οnclick="printPage();" class="button textual" title="打印"><span class="teamworkIcon">p</span></button>--%>
<button οnclick="printPage();" title="打印">打印</button>
<button οnclick='exportMpp();' title="导出">导出</button>
<%-- <span class="ganttButtonSeparator"></span>--%>
<%--<button οnclick="ge.gantt.showCriticalPath=!ge.gantt.showCriticalPath; ge.redraw();" class="button textual" title="Critical Path"><span class="teamworkIcon">£</span></button>
<span class="ganttButtonSeparator"></span>
<button οnclick="editResources();" class="button textual" title="edit resources"><span class="teamworkIcon">M</span></button>
<button οnclick="saveGanttOnServer();" class="button first big" title="保存">保存</button>--%>
</div></div>
</div>
<div class="__template__" type="TASKSEDITHEAD">
<table class="gdfTable" cellspacing="0" cellpadding="0">
<thead>
<tr style="height:40px">
<th class="gdfColHeader" style="width:35px;"></th>
<th class="gdfColHeader" style="width:25px;"></th>
<th class="gdfColHeader gdfResizable" style="width:0px;">任务编号</th>
<th class="gdfColHeader gdfResizable" style="width:300px;">任务名称</th>
<th class="gdfColHeader gdfResizable" style="width:80px;">开始</th>
<th class="gdfColHeader gdfResizable" style="width:80px;">结束</th>
<th class="gdfColHeader gdfResizable" style="width:50px;">工期</th>
<th class="gdfColHeader gdfResizable" style="width:50px;">前置任务</th>
<%--<th class="gdfColHeader gdfResizable" style="width:200px;">负责人</th>--%>
</tr>
</thead>
</table>
</div>
<div class="__template__" type="TASKROW"><!--
<tr taskId="(#=obj.id#)" class="taskEditRow" level="(#=level#)">
<th class="gdfCell edit" align="right" style="cursor:pointer;"><span class="taskRowIndex">(#=obj.getRow()+1#)</span> <span class="teamworkIcon" style="font-size:12px;" >e</span></th>
<td class="gdfCell noClip" align="center"><div class="taskStatus cvcColorSquare" status="(#=obj.status#)"></div></td>
<td class="gdfCell"><input type="text" name="code" value="(#=obj.code?obj.code:''#)"></td>
<td class="gdfCell indentCell" style="padding-left:(#=obj.level*10#)px;">
<div class="(#=obj.isParent()?'exp-controller expcoll exp':'exp-controller'#)" align="center"></div>
<input type="text" name="name" value="(#=obj.name#)">
</td>
<td class="gdfCell"><input type="text" name="start" value="" class="date"></td>
<td class="gdfCell"><input type="text" name="end" value="" class="date"></td>
<td class="gdfCell"><input type="text" name="duration" value="(#=obj.duration#)"></td>
<td class="gdfCell"><input type="text" name="depends" value="(#=obj.depends#)" (#=obj.hasExternalDep?"readonly":""#)></td>
<td class="gdfCell taskAssigs">(#=obj.getAssigsString()#)</td>
</tr>
--></div>
<div class="__template__" type="TASKEMPTYROW"><!--
<tr class="taskEditRow emptyRow" >
<th class="gdfCell" align="right"></th>
<td class="gdfCell noClip" align="center"></td>
<td class="gdfCell"></td>
<td class="gdfCell"></td>
<td class="gdfCell"></td>
<td class="gdfCell"></td>
<td class="gdfCell"></td>
<td class="gdfCell"></td>
<td class="gdfCell"></td>
</tr>
--></div>
<div class="__template__" type="TASKBAR"><!--
<div class="taskBox taskBoxDiv" taskId="(#=obj.id#)" >
<div class="layout (#=obj.hasExternalDep?'extDep':''#)">
<div class="taskStatus" status="(#=obj.status#)"></div>
<div class="taskProgress" style="width:(#=obj.progress>100?100:obj.progress#)%; background-color:(#=obj.progress>100?'red':'rgb(153,255,51);'#);"></div>
<div class="milestone (#=obj.startIsMilestone?'active':''#)" ></div>
<div class="taskLabel"></div>
<div class="milestone end (#=obj.endIsMilestone?'active':''#)" ></div>
</div>
</div>
--></div>
<div class="__template__" type="CHANGE_STATUS"><!--
<div class="taskStatusBox">
<div class="taskStatus cvcColorSquare" status="STATUS_ACTIVE" title="active"></div>
<div class="taskStatus cvcColorSquare" status="STATUS_DONE" title="completed"></div>
<div class="taskStatus cvcColorSquare" status="STATUS_FAILED" title="failed"></div>
<div class="taskStatus cvcColorSquare" status="STATUS_SUSPENDED" title="suspended"></div>
<div class="taskStatus cvcColorSquare" status="STATUS_UNDEFINED" title="undefined"></div>
</div>
--></div>
<div class="__template__" type="TASK_EDITOR"><!--
<div class="ganttTaskEditor">
<table width="100%">
<tr>
<td>
<table cellpadding="5">
<tr>
<td><label for="code">code/short name</label><br><input type="text" name="code" id="code" value="" class="formElements"></td>
</tr><tr>
<td><label for="name">name</label><br><input type="text" name="name" id="name" value="" size="35" class="formElements"></td>
</tr>
<tr></tr>
<td>
<label for="description">description</label><br>
<textarea rows="5" cols="30" id="description" name="description" class="formElements"></textarea>
</td>
</tr>
</table>
</td>
<td valign="top">
<table cellpadding="5">
<tr>
<td colspan="2"><label for="status">status</label><br><div id="status" class="taskStatus" status=""></div></td>
<tr>
<td colspan="2"><label for="progress">progress</label><br><input type="text" name="progress" id="progress" value="" size="3" class="formElements"></td>
</tr>
<tr>
<td><label for="start">start</label><br><input type="text" name="start" id="start" value="" class="date" size="10" class="formElements"><input type="checkbox" id="startIsMilestone"> </td>
<td rowspan="2" class="graph" style="padding-left:50px"><label for="duration">dur.</label><br><input type="text" name="duration" id="duration" value="" size="5" class="formElements"></td>
</tr><tr>
<td><label for="end">end</label><br><input type="text" name="end" id="end" value="" class="date" size="10" class="formElements"><input type="checkbox" id="endIsMilestone"></td>
</table>
</td>
</tr>
</table>
<h2>assignments</h2>
<table cellspacing="1" cellpadding="0" width="100%" id="assigsTable">
<tr>
<th style="width:100px;">name</th>
<th style="width:70px;">role</th>
<th style="width:30px;">est.wklg.</th>
<th style="width:30px;" id="addAssig"><span class="teamworkIcon" style="cursor: pointer">+</span></th>
</tr>
</table>
<div style="text-align: right; padding-top: 20px"><button id="saveButton" class="button big">save</button></div>
</div>
--></div>
<div class="__template__" type="ASSIGNMENT_ROW"><!--
<tr taskId="(#=obj.task.id#)" assigId="(#=obj.assig.id#)" class="assigEditRow" >
<td ><select name="resourceId" class="formElements" (#=obj.assig.id.indexOf("tmp_")==0?"":"disabled"#) ></select></td>
<td ><select type="select" name="roleId" class="formElements"></select></td>
<td ><input type="text" name="effort" value="(#=getMillisInHoursMinutes(obj.assig.effort)#)" size="5" class="formElements"></td>
<td align="center"><span class="teamworkIcon delAssig" style="cursor: pointer">d</span></td>
</tr>
--></div>
<div class="__template__" type="RESOURCE_EDITOR"><!--
<div class="resourceEditor" style="padding: 5px;">
<h2>Project team</h2>
<table cellspacing="1" cellpadding="0" width="100%" id="resourcesTable">
<tr>
<th style="width:100px;">name</th>
<th style="width:30px;" id="addResource"><span class="teamworkIcon" style="cursor: pointer">+</span></th>
</tr>
</table>
<div style="text-align: right; padding-top: 20px"><button id="resSaveButton" class="button big">save</button></div>
</div>
--></div>
<div class="__template__" type="RESOURCE_ROW"><!--
<tr resId="(#=obj.id#)" class="resRow" >
<td ><input type="text" name="name" value="(#=obj.name#)" style="width:100%;" class="formElements"></td>
<td align="center"><span class="teamworkIcon delRes" style="cursor: pointer">d</span></td>
</tr>
--></div>
</div>
<script type="text/javascript">
$.JST.loadDecorator("ASSIGNMENT_ROW", function (assigTr, taskAssig) {
var resEl = assigTr.find("[name=resourceId]");
for (var i in taskAssig.task.master.resources) {
var res = taskAssig.task.master.resources[i];
var opt = $("<option>");
opt.val(res.id).html(res.name);
if (taskAssig.assig.resourceId == res.id)
opt.attr("selected", "true");
resEl.append(opt);
}
var roleEl = assigTr.find("[name=roleId]");
for (var i in taskAssig.task.master.roles) {
var role = taskAssig.task.master.roles[i];
var optr = $("<option>");
optr.val(role.id).html(role.name);
if (taskAssig.assig.roleId == role.id)
optr.attr("selected", "true");
roleEl.append(optr);
}
if (taskAssig.task.master.canWrite && taskAssig.task.canWrite) {
assigTr.find(".delAssig").click(function () {
var tr = $(this).closest("[assigId]").fadeOut(200, function () {
$(this).remove();
});
});
}
});
</script>
</body>
</html>
二、后台代码 .ashx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.SessionState;
using MSProject = Microsoft.Office.Interop.MSProject;
using System.IO;
namespace WebApp.XMKApp.ZDCB._15_GCJD
{
/// <summary>
/// GANT_MSTServer 的摘要说明
/// </summary>
public class GANT_MSTServer : IHttpHandler, IRequiresSessionState
{
public bool IsReusable
{
get
{
return false;
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "application/json";
string action = Operate.getParameter(context, "action");
switch (action)
{
case "GetProject"://查询数据 旧方法
GetProject(context);
break;
case "GetGanttData"://查询数据
GetGanttData(context);
break;
case "ExportMpp"://导出MSProject
ExportMpp(context);
break;
case "ExportMppExt"://导出MSProject
ExportMppExt(context);
break;
case "DownloadMpp"://下载MSProject
DownloadMpp(context);
break;
default:
{
string ret = Operate.getJSONResult("error", "方法参数传递错误");
context.Response.Write(ret);
}
break;
}
}
#region 取得甘特图数
private void GetProject(HttpContext context)
{
string ret = "";
try
{
string BASENO = Operate.getParameter(context, "BASENO") != "" ? Operate.getParameter(context, "BASENO") : "";
string ItemName = Operate.getParameter(context, "ItemName") != "" ? Operate.getParameter(context, "ItemName") : "";
string PBDATE_FROM = Operate.getParameter(context, "PBDATE_FROM") != "" ? Operate.getParameter(context, "PBDATE_FROM") : "";
string PBDATE_TO = Operate.getParameter(context, "PBDATE_TO") != "" ? Operate.getParameter(context, "PBDATE_TO") : "";
string DEPT = Operate.getParameter(context, "DEPT") != "" ? Operate.getParameter(context, "DEPT") : "";
if (!string.IsNullOrEmpty(ItemName))
{
ItemName = HttpUtility.UrlDecode(ItemName);
}
if (!string.IsNullOrEmpty(DEPT))
{
DEPT = HttpUtility.UrlDecode(DEPT);
}
NRSS.BLL.XMK_Z_KDJH bll = new NRSS.BLL.XMK_Z_KDJH();
List<NRSS.Model.XMK_Z_KDJH_GANTT> lstModels = bll.GetListForGanttExt(BASENO, ItemName, PBDATE_FROM, PBDATE_TO, DEPT);
ProjectData prjData = convertToGanttData(lstModels);
string DataJson = JsonHelper.ToJSON(prjData);
ret = Operate.getObjectToJSONResult("ok", DataJson);
}
catch (Exception ex)
{
ret = Operate.getJSONResult("error", ex.Message);
}
context.Response.Write(ret);
}
private void GetGanttData(HttpContext context)
{
string ret = "";
try
{
string KDJHNO = Operate.getParameter(context, "KDJHNO") != "" ? Operate.getParameter(context, "KDJHNO") : "";
NRSS.BLL.XMK_Z_KDJH bll = new NRSS.BLL.XMK_Z_KDJH();
List<NRSS.Model.XMK_Z_KDJH_GANTT> lstModels = bll.GetListForGantt(KDJHNO);
ProjectData prjData = convertToGanttData(lstModels);
string DataJson = JsonHelper.ToJSON(prjData);
ret = Operate.getObjectToJSONResult("ok", DataJson);
}
catch (Exception ex)
{
ret = Operate.getJSONResult("error", ex.Message);
}
context.Response.Write(ret);
}
private ProjectData convertToGanttData(List<NRSS.Model.XMK_Z_KDJH_GANTT> lstModels)
{
ProjectData prjData = new ProjectData();
Dictionary<string, int> dicNoToId = new Dictionary<string, int>();
Dictionary<int, int> dicTaskLevel = new Dictionary<int, int>();
/* 创建task数据 */
int id = 1;
foreach (NRSS.Model.XMK_Z_KDJH_GANTT model in lstModels)
{
TaskData taskData = new TaskData();
taskData.id = -1 * id;
id++;
taskData.name = model.JHNAME;
taskData.code = model.JHNO.ToString();
dicNoToId.Add(taskData.code, taskData.id);
if (model.ISFINISH == 1)
{
if (model.BDATE == null)
{
throw new Exception("该项目任务开始日期不能空！");
}
if (model.EDATE == null)
{
throw new Exception("该项目任务结束日期不能空！");
}
taskData.start = ToMillisecondDate(model.BDATE);
long end = ToMillisecondDate(model.EDATE);
taskData.duration = CountWorkDays(model.BDATE.Value, model.EDATE.Value);
}
else
{
if (model.PBDATE == null)
{
throw new Exception("该项目任务开始日期不能空！");
}
if (model.PEDATE == null)
{
throw new Exception("该项目任务结束日期不能空！");
}
taskData.start = ToMillisecondDate(model.PBDATE);
long end = ToMillisecondDate(model.PEDATE);
taskData.duration = CountWorkDays(model.PBDATE.Value, model.PEDATE.Value);
}
taskData.depends = model.QZJH;
taskData.description = model.DEPT + "[" + model.DUSER + "]";
taskData.progress = model.PERATE == null ? (decimal)0.00 : model.PERATE.Value;//进度值，例:65%的话值是65
if (model.PNO != null)
{
if (dicTaskLevel.ContainsKey(model.PNO.Value))
{
int iParentLevel = dicTaskLevel[model.PNO.Value];
taskData.level = iParentLevel + 1;
}
}
prjData.tasks.Add(taskData);
if (!dicTaskLevel.ContainsKey(model.JHNO))
{
dicTaskLevel.Add(model.JHNO, taskData.level);
}
switch (model.FLAG)
{
case 1:
taskData.status = "STATUS_FAILED";
break;
case 2:
taskData.status = "STATUS_ACTIVE";
break;
case 3:
taskData.status = "STATUS_SUSPENDED";
break;
case 4:
taskData.status = "STATUS_DONE";
break;
default:
taskData.status = "STATUS_UNDEFINED";
break;
}
}
/* 解析赋值依赖信息 */
for (int i = 0; i < prjData.tasks.Count; i++)
{
TaskData task = prjData.tasks[i];
if (!string.IsNullOrEmpty(task.depends))
{
string[] arrQZNO = task.depends.Split(',');
string depends = "";
for (int j = 0; j < arrQZNO.Length; j++)
{
if (dicNoToId.ContainsKey(arrQZNO[j]))
{
if (j > 0)
{
depends += ",";
}
int QZid = dicNoToId[arrQZNO[j]];
if (QZid < 0) { QZid = QZid * (-1); }
depends += QZid.ToString();
}
}
prjData.tasks[i].depends = depends;
}
}
return prjData;
}
private static readonly DateTime StartTime = TimeZone.CurrentTimeZone.ToLocalTime(new System.DateTime(1970, 1, 2)).Date;
private static long ToMillisecondDate(DateTime? dt)
{
if (dt == null) return 0;
DateTime date = dt.Value;
return Convert.ToInt64((date.Date - StartTime.Date).TotalSeconds * 1000);
}
private static DateTime ConvertToDateTime(long timeSpan)
{
DateTime dt = StartTime.AddSeconds(timeSpan / 1000);
return dt;
}
private static int CountWorkDays(DateTime start, DateTime end)
{
TimeSpan ts1 = end.Subtract(start);//TimeSpan得到dt1和dt2的时间间隔
int countday = ts1.Days;//获取两个日期间的总天数
int workkdays = 0;//工作日
//循环用来扣除总天数中的双休日
for (int i = 0; i < countday; i++)
{
DateTime tempdt = start.Date.AddDays(i);
if (tempdt.DayOfWeek != System.DayOfWeek.Saturday && tempdt.DayOfWeek != System.DayOfWeek.Sunday)
{
workkdays++;
}
}
return workkdays;
}
private static DateTime CountEndDateTime(DateTime start, long duration)
{
DateTime dtEnd = start;
long count = duration;
while (count > 0)
{
dtEnd = dtEnd.AddDays(1);
if (dtEnd.DayOfWeek != System.DayOfWeek.Saturday && dtEnd.DayOfWeek != System.DayOfWeek.Sunday)
{
count--;
}
}
return dtEnd;
}
private class ProjectData
{
public List<TaskData> tasks;
public int selectedRow;
public bool canWrite;
public bool canWriteOnParent;
public ProjectData()
{
selectedRow = 0;
canWrite = false;
canWriteOnParent = false;
tasks = new List<TaskData>();
}
}
private class TaskData
{
public int id {get;set;}
public string name { get; set; }
public string code { get; set; }
public int level { get; set; }
public string status { get; set; }
public bool canWrite { get; set; }
public long start { get; set; }
public long duration { get; set; }
public long end { get; set; }
public bool startIsMilestone { get; set; }
public bool endIsMilestone { get; set; }
public bool collapsed { get; set; }
public List<object> assigs { get; set; }
public string depends { get; set; }
public bool hasChild { get; set; }
public string description { get; set; }
public decimal progress { get; set; }
public TaskData()
{
code = "";
level = 0;
canWrite = false;
assigs = new List<object>();
hasChild = false;
}
}
#endregion
#region 导出MPP
private void ExportMpp(HttpContext context)
{
string ret = "";
try
{
string KDJHNO = Operate.getParameter(context, "KDJHNO") != "" ? Operate.getParameter(context, "KDJHNO") : "";
string strMPPNAME = "开店任务_"+ KDJHNO +"_"+ DateTime.Now.ToString("yyyy_MM_dd_hh_mm_ss") + ".mpp";
string strDirectory = context.Server.MapPath("~/tempfile");
string strFullName = strDirectory +"/" + strMPPNAME;
checkAndCreatePath(strDirectory);
//string DataJson = Operate.getParameter(context, "JSON_DATA") != "" ? Operate.getParameter(context, "JSON_DATA") : "";
//ProjectData prjData = JsonHelper.Deserialize<ProjectData>(DataJson);
//createMppFromJson(strFullName, prjData);
NRSS.BLL.XMK_Z_KDJH bll = new NRSS.BLL.XMK_Z_KDJH();
List<NRSS.Model.XMK_Z_KDJH_GANTT> lstModels = bll.GetListForGantt(KDJHNO);
createMppFromDB(strFullName, lstModels);
ret = Operate.getJSONResult("ok", strMPPNAME);
}
catch (Exception ex)
{
ret = Operate.getJSONResult("error", "导出失败："+ex.Message);
}
context.Response.Write(ret);
}
private void ExportMppExt(HttpContext context)
{
string ret = "";
try
{
string BASENO = Operate.getParameter(context, "BASENO") != "" ? Operate.getParameter(context, "BASENO") : "";
string ItemName = Operate.getParameter(context, "ItemName") != "" ? Operate.getParameter(context, "ItemName") : "";
string PBDATE_FROM = Operate.getParameter(context, "PBDATE_FROM") != "" ? Operate.getParameter(context, "PBDATE_FROM") : "";
string PBDATE_TO = Operate.getParameter(context, "PBDATE_TO") != "" ? Operate.getParameter(context, "PBDATE_TO") : "";
string DEPT = Operate.getParameter(context, "DEPT") != "" ? Operate.getParameter(context, "DEPT") : "";
if (!string.IsNullOrEmpty(ItemName))
{
ItemName = HttpUtility.UrlDecode(ItemName);
}
if (!string.IsNullOrEmpty(DEPT))
{
DEPT = HttpUtility.UrlDecode(DEPT);
}
NRSS.BLL.XMK_Z_KDJH bll = new NRSS.BLL.XMK_Z_KDJH();
List<NRSS.Model.XMK_Z_KDJH_GANTT> lstModels = bll.GetListForGanttExt(BASENO, ItemName, PBDATE_FROM, PBDATE_TO, DEPT);
string strMPPNAME = "开店任务_" + BASENO + "_" + DateTime.Now.ToString("yyyy_MM_dd_hh_mm_ss") + ".mpp";
string strDirectory = context.Server.MapPath("~/tempfile");
string strFullName = strDirectory + "/" + strMPPNAME;
checkAndCreatePath(strDirectory);
//string DataJson = Operate.getParameter(context, "JSON_DATA") != "" ? Operate.getParameter(context, "JSON_DATA") : "";
//ProjectData prjData = JsonHelper.Deserialize<ProjectData>(DataJson);
//createMppFromJson(strFullName, prjData);
createMppFromDB(strFullName, lstModels);
ret = Operate.getJSONResult("ok", strMPPNAME);
}
catch (Exception ex)
{
ret = Operate.getJSONResult("error", "导出失败：" + ex.Message);
}
context.Response.Write(ret);
}
private void createMppFromJson(string prjFileName, ProjectData prjData)
{
MSProject.ApplicationClass prj = null;
int i = 0;
try
{
Object missing = Type.Missing;
prj = new MSProject.ApplicationClass();
MSProject.PjFileFormat format = MSProject.PjFileFormat.pjMPP;//format定义
prj.Visible = false;
prj.FileNew(Type.Missing, Type.Missing, Type.Missing, false);
MSProject.Project myProject = prj.ActiveProject;
MSProject.Task task = null;
if (prjData != null && prjData.tasks != null)
{
for (i = 0; i < prjData.tasks.Count; i++)
{
TaskData srcData = prjData.tasks[i];
srcData.name = srcData.name.Replace('n', ' ');
task = myProject.Tasks.Add(srcData.name, (i+1));
DateTime dtStart = ConvertToDateTime(srcData.start);
task.Start = dtStart;
task.Finish = CountEndDateTime(dtStart,srcData.duration);
//task.Duration = srcData.duration;
task.PercentComplete = srcData.progress;
if (srcData.level > 0)
{
task.OutlineLevel = (short)srcData.level;
}
}
}
//task = myProject.Tasks.Add("zhi", 1);
//task.Start = "2008-8-1";
//task.Finish = "2008-8-18";
//task.SetField(MSProject.PjField.pjTaskNotes, "Task1");
//task = null;
//task = myProject.Tasks.Add("wenzhixing", 2);
//task.Start = "2008-8-8";
//task.Finish = "2008-8-28";
//task.ActualStart = "2008-9-8 8:00";
//task.ActualFinish = "2008-9-28 17:00";
//task.OutlineLevel = 2;
//task.SetField(MSProject.PjField.pjTaskResourceNames, "wenzhi");
//task = null;
//task = myProject.Tasks.Add("wen", 3);
//task.Start = "2008-8-11";
//task.Finish = "2008-8-18";
//task.SetField(MSProject.PjField.pjTaskNotes, "Task2");
//task.Notes += "hehe";
//task.OutlineLevel = 1;
//task = null;
//task = myProject.Tasks.Add("wen", 4);
//task.Start = "2008-8-18";
//task.Finish = "2008-8-28";
//task.OutlineLevel = 2;
//task.SetField(MSProject.PjField.pjTaskResourceNames, "wenzhi");
prj.FileSaveAs(prjFileName, format
, Type.Missing, false, Type.Missing, Type.Missing, Type.Missing
, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing
, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
}
catch (Exception ex)
{
throw new Exception("[任务行("+(i+1)+")]"+ex.Message);
}
finally
{
if (prj != null)
{
try
{
prj.FileClose(MSProject.PjSaveType.pjDoNotSave);
prj.Quit(MSProject.PjSaveType.pjDoNotSave);
}
catch { }
}
}
}
private void createMppFromDB(string prjFileName, List<NRSS.Model.XMK_Z_KDJH_GANTT> lstModels)
{
MSProject.ApplicationClass prj = null;
int i = 0;
try
{
Object missing = Type.Missing;
prj = new MSProject.ApplicationClass();
MSProject.PjFileFormat format = MSProject.PjFileFormat.pjMPP;//format定义
prj.Visible = false;
prj.FileNew(Type.Missing, Type.Missing, Type.Missing, false);
MSProject.Project myProject = prj.ActiveProject;
MSProject.Task task = null;
Dictionary<int, int> dicIndex = new Dictionary<int, int>();
Dictionary<int, short> dicTaskLevel = new Dictionary<int, short>();
NRSS.Model.XMK_Z_KDJH_GANTT model = null;
if (lstModels != null && lstModels.Count > 0)
{
for (i = 0; i < lstModels.Count; i++)
{
model = lstModels[i];
model.JHNAME = model.JHNAME.Replace('n', ' ');
model.DEPT = model.DEPT.Replace('n', ' ');
task = myProject.Tasks.Add(model.JHNAME, Type.Missing);
task.Start = model.PBDATE.Value;
task.Finish = model.PEDATE.Value;
if (model.ISFINISH == 1 || model.PERATE >= 100)
{
if (model.BDATE != null && model.EDATE != null)
{
task.ActualStart = model.BDATE.Value;
task.ActualFinish = model.EDATE.Value;
}
}
task.PercentComplete = model.PERATE;
short level = 1;
if (model.PNO != null)
{
if (dicTaskLevel.ContainsKey(model.PNO.Value))
{
short iParentLevel = dicTaskLevel[model.PNO.Value];
level = iParentLevel;
level++;
}
}
if (!dicTaskLevel.ContainsKey(model.JHNO))
{
dicTaskLevel.Add(model.JHNO, level);
}
if (level > 0)
{
task.OutlineLevel = level;
}
task.SetField(MSProject.PjField.pjTaskResourceNames, model.DEPT + "(" + model.DUSER + ")");
if (!dicIndex.ContainsKey(model.JHNO))
{
dicIndex.Add(model.JHNO, i);
}
}
for (i = 0; i < lstModels.Count; i++)
{
model = lstModels[i];
if (!string.IsNullOrEmpty(model.QZJH))
{
string[] arrQZNO = model.QZJH.Split(',');
foreach (string preNO in arrQZNO)
{
int iPreNO = int.Parse(preNO);
if (dicIndex.ContainsKey(iPreNO))
{
int index = dicIndex[iPreNO];
string JHNAME = lstModels[index].JHNAME;
//myProject.Tasks[i].Parent.Add(JHNAME, Type.Missing);
//myProject.Tasks[i].Predecessors = myProject.Tasks[index].ID.ToString();
myProject.Tasks[i+1].TaskDependencies.Add(myProject.Tasks[index+1], MSProject.PjTaskLinkType.pjFinishToStart, Type.Missing);
}
}
}
}
}
prj.FileSaveAs(prjFileName, format
, Type.Missing, false, Type.Missing, Type.Missing, Type.Missing
, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing
, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
}
catch (Exception ex)
{
throw new Exception("[任务行(" + (i + 1) + ")]" + ex.Message);
}
finally
{
if (prj != null)
{
try {
prj.FileClose(MSProject.PjSaveType.pjDoNotSave);
prj.Quit(MSProject.PjSaveType.pjDoNotSave);
}
catch { }
}
}
}
private void DownloadMpp(HttpContext context)
{
string ret = "";
try
{
string fileName = Operate.getParameter(context, "FILE") != "" ? Operate.getParameter(context, "FILE") : "";
string filePath = context.Server.MapPath("~/tempfile/" + fileName);
downloadMSProject(context, fileName, filePath);
}
catch (Exception ex)
{
ret = Operate.getJSONResult("error", ex.Message);
}
}
private void downloadMSProject(HttpContext context, string fileName, string strFullPath)
{
// 取得下载文件
string strFileName = fileName;
{
context.Response.Buffer = true;
context.Response.Clear();
context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
context.Response.ContentType = "application/ms-project;charset=gb2312";
string downFile = System.IO.Path.GetFileName(strFileName);
string EncodeFileName = HttpUtility.UrlEncode(downFile, System.Text.Encoding.UTF8);
context.Response.AddHeader("Content-Disposition", "attachment;filename=" + EncodeFileName + ";");
context.Response.BinaryWrite(System.IO.File.ReadAllBytes(strFullPath));//返回文件数据给客户端下载
context.Response.Flush();
HttpContext.Current.ApplicationInstance.CompleteRequest();
}
}
private void checkAndCreatePath(string path)
{
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
}
#endregion
}
}
3.1 jQueryGanttMasterlibsi18nJs.js
Date.monthNames = ["一月","二月","三月","四月","五月","六月","七月","八月","九月","十月","十一月","十二月"];
// Month abbreviations. Change this for local month names
Date.monthAbbreviations = ["一月", "二月", "三月", "四月", "五月", "六月", "七月", "八月", "九月", "十月", "十一月", "十二月"];
// Full day names. Change this for local month names
Date.dayNames = ["日", "一", "二", "三", "四", "五", "六"];
// Day abbreviations. Change this for local month names
Date.dayAbbreviations = ["日", "一", "二", "三", "四", "五", "六"];3.2 gantt.css
/* FLAG:2 红 */
.taskStatus[status=STATUS_ACTIVE]{
background-color: #CD0000;
}
/* FLAG:4 浅绿 */
.taskStatus[status=STATUS_DONE]
{
background-color: #4EEE94;
}
/* FLAG:1 蓝 */
.taskStatus[status=STATUS_FAILED]{
background-color: #4876FF;
}
/* FLAG:3 深绿 */
.taskStatus[status=STATUS_SUSPENDED]{
background-color: #3CB371;
}
.taskStatus[status=STATUS_UNDEFINED]{
background-color: #ffffff;
}3.3 ganttDrawerSVG.js
函数_createTaskSVG 可根据需要修改
3.4 ganttGridEditor.js 修改日期格式
GridEditor.prototype.refreshTaskRow = function (task) {
//console.debug("refreshTaskRow")
//var profiler = new Profiler("editorRefreshTaskRow");
var row = task.rowElement;
row.find(".taskRowIndex").html(task.getRow() + 1);
row.find(".indentCell").css("padding-left", task.level * 16 + 12);
row.find("[name=name]").val(task.name);
row.find("[name=code]").val(task.code);
row.find("[status]").attr("status", task.status);
row.find("[name=duration]").val(task.duration);
row.find("[name=start]").val(new Date(task.start).format('yyyy-MM-dd')).updateOldValue(); // called on dates only because for other field is called on focus event
row.find("[name=end]").val(new Date(task.end).format('yyyy-MM-dd')).updateOldValue();
row.find("[name=depends]").val(task.depends);
row.find(".taskAssigs").html(task.getAssigsString());
//profiler.stop();
};以上仅供参考
最后
以上就是成就小蜜蜂为你收集整理的GanttMaster甘特图的扩展使用的全部内容，希望文章能够帮你解决GanttMaster甘特图的扩展使用所遇到的程序开发问题。
如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。
本图文内容来源于网友提供，作为学习参考使用，或来自网络收集整理，版权属于原作者所有。
发表评论 取消回复