processlist.java

本人课程设计时做的一个用struts框架实现的基于cmmi2的项目管理系统的原型。还有部分功能尚未实现

package com.cmmi2pms.ma;

import java.sql.ResultSet;
import java.sql.SQLException;
//import java.util.*;

import com.cmmi2pms.common.comdb.*;

public class ProcessList 
{
	private ProjectProcess[] processList;
	private boolean forMa;
	private boolean c_store;
	
	public ProcessList(String maReportId)
	{
		c_store=true;
		System.out.println("maReportId="+maReportId);
		c_store=true;
		try{
			//PooledConnectionMgr.getInstance().initialize(30,"192.168.15.150",3306,"CMMI2PM");
			//Get an instance reference to the DbFacade object
			SqlDB dbf = null;
			dbf = new SqlDB();
			
			ResultSet rs = null;
			String sql = "SELECT * FROM  MA_Process where MaReportId = " + Integer.parseInt(maReportId);
			rs=dbf.executeQuery(sql);					
			ProjectProcess aProjectProcess;
			int numOfProjectProcess = 0;
			ProjectProcess[] temp=new ProjectProcess[100];
			//maObjects = new MaObject[13];
			while ((rs.next()) && (numOfProjectProcess < 100))
			{	
				aProjectProcess=new ProjectProcess();			
				
				aProjectProcess.setProjectId(rs.getString("ProjectId"));
				aProjectProcess.setTaskId(rs.getString("taskid"));
				aProjectProcess.setStartTimeP(rs.getString("StartTimeP").substring(0,10));
				aProjectProcess.setStartTimeA(rs.getString("StartTimeA").substring(0,10));
				aProjectProcess.setStopTimeP(rs.getString("StopTimeP").substring(0,10));
				aProjectProcess.setStopTimeA(rs.getString("StopTimeP").substring(0,10));
				aProjectProcess.setPlanProcess(rs.getString("StopTimeP"));
				aProjectProcess.setActualProcess(rs.getString("WorkDateP"));
				aProjectProcess.setLag(rs.getString("WorkDateA"));
				aProjectProcess.setLagRate(rs.getString("ProcessLagRate"));
				aProjectProcess.setTaskName(rs.getString("TaskNme"));
				aProjectProcess.setMaReportId(rs.getString("MaReportId"));
				if (rs.getString("ProcessLagFlag").equals("1"))
					aProjectProcess.setProcessLagFlag("yes");
				else 	aProjectProcess.setProcessLagFlag("no");
				
				temp[numOfProjectProcess] = aProjectProcess;		
				numOfProjectProcess++;
				System.out.println("numOfProjectProcess=" + numOfProjectProcess);	
			}
			processList=new ProjectProcess[numOfProjectProcess];
			System.arraycopy(temp,0,processList,0,numOfProjectProcess);
			if(rs!=null) rs.close();
			if(dbf!=null) dbf.close();
		}
		catch (Exception e)   	
		{
			System.out.println("Exception in createprocessList:" + e.getMessage());
		}
	}
	
	public ProcessList(boolean c_ma,String projId,String layer,double windageGate,String taskId)
	{
		/*
		System.out.println("ProcessList()"+layer);
		processList =new ProjectProcess[2];
		processList[0]=new ProjectProcess();
		processList[1]=new ProjectProcess();
		
		if (layer.equals("1"))
		{
			processList[0].setProjectId("cmmi");
			processList[0].setTaskId("0");
			processList[0].setTaskName("设计");
			processList[0].setLayer("1");
			processList[0].setStartTimeP("2004-02-01");
			processList[0].setStopTimeP("2004-03-01");
			processList[0].setStartTimeA("2004-02-10");
			processList[0].setStopTimeA("2004-02-25");
			processList[0].setMaReportId(taskId);
		
			processList[1].setProjectId("cmmi");
			processList[1].setTaskId("1");
			processList[1].setTaskName("编码");
			processList[1].setLayer("1");
			processList[1].setStartTimeP("2004-03-01");
			processList[1].setStopTimeP("2004-04-01");
			processList[1].setStartTimeA("2004-02-25");
			processList[1].setStopTimeA("2004-04-25");
			processList[1].setMaReportId(taskId);
		}
		else
		{
			processList[0].setProjectId("cmmi");
			processList[0].setTaskId("0");
			processList[0].setTaskName("MA域的设计");
			processList[0].setLayer("2");
			processList[0].setStartTimeP("2004-03-01");
			processList[0].setStopTimeP("2004-04-01");
			processList[0].setStartTimeA("2004-02-25");
			processList[0].setStopTimeA("2004-04-25");
			processList[0].setMaReportId(taskId);
		
			processList[1].setProjectId("cmmi");
			processList[1].setTaskId("1");
			processList[1].setTaskName("CM域的设计");
			processList[1].setLayer("2");
			processList[1].setStartTimeP("2004-03-01");
			processList[1].setStopTimeP("2004-04-01");
			processList[1].setStartTimeA("2004-02-25");
			processList[1].setStopTimeA("2004-04-25");
			processList[1].setMaReportId(taskId);
		}
		*/
		c_store=false;
		try{
			//PooledConnectionMgr.getInstance().initialize(30,"192.168.15.150",3306,"CMMI2PM");
			//Get an instance reference to the DbFacade object
			SqlDB dbf = null;
			dbf = new SqlDB();
			
			ResultSet rs = null;
			//String sql = "SELECT projectID,projectName,description,DepartName,starttime,name,stage FROM project,employee,depart ";
			//sql = sql + " where project.PM = employee.userID and project.depart = depart.departID and projectID = '" + projectID + "'";
			String sql = "SELECT * FROM  pp_workloadestimate where projectID = '" + projId + "' and trackid = 2" ; 
			rs=dbf.executeQuery(sql);					
			ProjectProcess aProcess;
			int numOfProcess = 0;
			ProjectProcess[] temp=new ProjectProcess[100];
			//maObjects = new MaObject[13];
			
			String tempLayer; 
			while ((rs.next()) && (numOfProcess < 100))
			{	
				tempLayer=rs.getString("layer");
				if ((getLayer(tempLayer).equals(layer))&&(isBrance(tempLayer,taskId)||(!c_ma)))	
				{	
					aProcess=new ProjectProcess();			
				
					aProcess.setProjectId(projId);
					aProcess.setTaskId(rs.getString("taskid"));
					aProcess.setTaskName(rs.getString("taskname"));
					aProcess.setLayer(layer);
					aProcess.setMaReportId(taskId);
					aProcess.setWindageGate(windageGate);
					aProcess.getFormDb();
					
					temp[numOfProcess] = aProcess;		
					numOfProcess++;
					System.out.println("numOfProcess=" + numOfProcess);	
				}
			}
			processList=new ProjectProcess[numOfProcess];
			System.arraycopy(temp,0,processList,0,numOfProcess);
			if(rs!=null) rs.close();
			if(dbf!=null) dbf.close();
		}
		catch (Exception e)   	
		{
			System.out.println("Exception in createProcessList:" + e.getMessage());
		}
		
		if(c_ma)
		{
			for(int i=0;i<processList.length;i++)
				processList[i].ma();
		}
		System.out.println("end ProcessList()");
	}
	
	public ProjectProcess[] getProcessList() 
	{
		return processList;
	}

	public void setProcessList(ProjectProcess[] processList) 
	{
		this.processList = new ProjectProcess[processList.length];
		System.arraycopy(processList,0,this.processList,0,processList.length);
	}
	
	public void store()
	{
		if(!c_store)
		{
			for(int i=0;i<processList.length;i++)
			{
				processList[i].store();
			}
		}
		/*
		try{
			//PooledConnectionMgr.getInstance().initialize(30,"192.168.15.150",3306,"CMMI2PM");
			//Get an instance reference to the DbFacade object
			SqlDB dbf = null;
			dbf = new SqlDB();
			
			//java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd",java.util.Locale.CHINA);
	
			//java.util.Date d = sdf.parse(theProjectForm.getStartTime());  
	
			//java.sql.Date startTime = new java.sql.Date(d.getTime());
			
			dbf.setSql("INSERT INTO `MA_MAObject` VALUES (?,?,?,?,?,?)");
		    
		    	System.out.println("before sql");
			
			dbf.setString(1,projectID);
			System.out.println(tranMaObjectName(maObject));
			dbf.setInt(2,tranMaObjectName(maObject));
			dbf.setInt(3,Integer.parseInt(analyst));
			dbf.setString(4,gatherCircle);
			dbf.setString(5,analysisCircle);
			dbf.setDouble(6,Double.parseDouble(windageGate));//临时
			dbf.execute();
			//List results of changes.  
		}
		catch (Exception e)   	
		{
			System.out.println("Exception in createMaObject:" + e.getMessage());
		}
		*/
	}
	
	private String getLayer(String layer)
	{
		int	layerInt=1;
		
		for(int i=0;i<layer.length();i++)
		{
			if((layer.charAt(i))=='.')
				layerInt++;
		}
		return	Integer.toString(layerInt);
	}
	
	private boolean isBrance(String layer,String note)
	{
		int beginFlag=0;
		int endFlag,n;
		for(n=0;n<layer.length();n++)
		{
			if((layer.charAt(n))=='.')
			{
				endFlag=beginFlag;
				beginFlag=n;
				if (layer.substring(endFlag,beginFlag).equals(note))
					return true;
				else beginFlag++;
			}
		}
		return false;
	} 
	
	
}