//***********************************************************************
//功能:将XML流程文件内容保存至数据库中
//参数:WorkFlowNo --流程编号
//返回值:
//***********************************************************************
function SaveFlowToSQL(WorkFlowNo){
var FlowxmlDoc=checkFlowxmlDocObj("data/"+WorkFlowNo+".xml");
var Proc=FlowxmlDoc.getElementsByTagName("Proc");
var Step=FlowxmlDoc.getElementsByTagName("Step");
var WorkFlowNo=FlowxmlDoc.documentElement.attributes[4].value;
var Sql="";
var ProcNo,ProcName,procType,procwaittime;
for(i = 0; i<Proc.length; i++){
ProcNo= Proc[i].childNodes[0].attributes[0].value; //节点英文名称
ProcName= Proc[i].childNodes[0].attributes[1].value; //节点中文名称
procType= Proc[i].childNodes[0].attributes[2].value; //节点类型(开始、结束、普通)
procwaittime=Proc[i].childNodes[0].attributes[4].value; //办理期限
var NextStep=""; //后续节点
for(j = 0; j<Step.length; j++){
alert(Step.length);
var From=Step[j].childNodes[0].attributes[2].value;//from
if(From==ProcNo){
NextStep=NextStep+Step[j].childNodes[0].attributes[3].value+"|"; //to累加
}
alert(NextStep);
}
if (NextStep!=""){
NextStep=NextStep.substring(0,NextStep.length-1);
}
if (NextStep==""){
NextStep=ProcNo;
}
Sql=Sql+" select '"+WorkFlowNo+"','"+ProcNo+"','"ProcName+"','"+procwaittime+"','"+procType+"','"+NextStep+"' Union all ";
}
Sql=Sql.substring(0,Sql.length-11);
return Sql;
}
//功能:将XML流程文件内容保存至数据库中
//参数:WorkFlowNo --流程编号
//返回值:
//***********************************************************************
function SaveFlowToSQL(WorkFlowNo){
var FlowxmlDoc=checkFlowxmlDocObj("data/"+WorkFlowNo+".xml");
var Proc=FlowxmlDoc.getElementsByTagName("Proc");
var Step=FlowxmlDoc.getElementsByTagName("Step");
var WorkFlowNo=FlowxmlDoc.documentElement.attributes[4].value;
var Sql="";
var ProcNo,ProcName,procType,procwaittime;
for(i = 0; i<Proc.length; i++){
ProcNo= Proc[i].childNodes[0].attributes[0].value; //节点英文名称
ProcName= Proc[i].childNodes[0].attributes[1].value; //节点中文名称
procType= Proc[i].childNodes[0].attributes[2].value; //节点类型(开始、结束、普通)
procwaittime=Proc[i].childNodes[0].attributes[4].value; //办理期限
var NextStep=""; //后续节点
for(j = 0; j<Step.length; j++){
alert(Step.length);
var From=Step[j].childNodes[0].attributes[2].value;//from
if(From==ProcNo){
NextStep=NextStep+Step[j].childNodes[0].attributes[3].value+"|"; //to累加
}
alert(NextStep);
}
if (NextStep!=""){
NextStep=NextStep.substring(0,NextStep.length-1);
}
if (NextStep==""){
NextStep=ProcNo;
}
Sql=Sql+" select '"+WorkFlowNo+"','"+ProcNo+"','"ProcName+"','"+procwaittime+"','"+procType+"','"+NextStep+"' Union all ";
}
Sql=Sql.substring(0,Sql.length-11);
return Sql;
}
Sql=Sql+" select '"+WorkFlowNo+"','"+ProcNo+"','"ProcName+"','"+procwaittime+"','"+procType+"','"+NextStep+"' Union all ";
改成
Sql = Sql + " select '" + WorkFlowNo + "','" + ProcNo + "','" + ProcName + "','" + procwaittime + "','" + procType + "','" + NextStep + "' Union all ";
下次问题说明清楚
告诉下alert到什么地方出错 这样节省别人的时间