workloadlist.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 WorkloadList 
{
	private Workload[] workloadList;
	private boolean forMa;
	private boolean c_store;
	
	public WorkloadList(String maReportId)
	{
		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_WorkLoad where MaReportId = " + Integer.parseInt(maReportId);
			rs=dbf.executeQuery(sql);					
			Workload aWorkload;
			int numOfWorkload = 0;
			Workload[] temp=new Workload[100];
			//maObjects = new MaObject[13];
			while ((rs.next()) && (numOfWorkload < 100))
			{	
				aWorkload=new Workload();			
				
				aWorkload.setProjectId(rs.getString("ProjectId"));
				aWorkload.setTaskId(rs.getString("taskid"));
				aWorkload.setPlanWorkload(rs.getString("WorkloadP"));
				aWorkload.setActualWorkload(rs.getString("WorkloadA"));
				aWorkload.setLag(rs.getString("WorkloadLag"));
				aWorkload.setLagRate(rs.getString("WorkloadLagRate"));
				aWorkload.setTaskName(rs.getString("TaskName"));
				aWorkload.setMaReportId(rs.getString("MaReportId"));
				if (rs.getString("WorkloadLagFlag").equals("1"))
					aWorkload.setWorkloadLagFlag("yes");
				else 	aWorkload.setWorkloadLagFlag("no");
				
				temp[numOfWorkload] = aWorkload;		
				numOfWorkload++;
				System.out.println("numOfWorkload=" + numOfWorkload);	
			}
			workloadList=new Workload[numOfWorkload];
			System.arraycopy(temp,0,workloadList,0,numOfWorkload);
			
			if(rs!=null) rs.close();
			if(dbf!=null) dbf.close();
		}
		catch (Exception e)   	
		{
			System.out.println("Exception in createWorkloadList:" + e.getMessage());
		}
	}
	
	public WorkloadList(boolean c_ma,String projId,String layer,double windageGate,String taskId)
	{
		/*
		workloadList=new Workload[2];
		workloadList[0]=new Workload();
		workloadList[1]=new Workload();
		
		if (layer.equals("1"))
		{
			workloadList[0].setProjectId("cmmi");
			workloadList[0].setTaskId("0");
			workloadList[0].setTaskName("设计");
			workloadList[0].setLayer("1");
			workloadList[0].setPlanWorkload("100");
			workloadList[0].setActualWorkload("80");
			workloadList[0].setMaReportId("0");
		
			workloadList[1].setProjectId("cmmi");
			workloadList[1].setTaskId("1");
			workloadList[1].setTaskName("编码");
			workloadList[1].setLayer("1");
			workloadList[1].setPlanWorkload("100");
			workloadList[1].setActualWorkload("300");
			workloadList[1].setMaReportId("0");
		}
		else
		{
			workloadList[0].setProjectId("cmmi");
			workloadList[0].setTaskId("0");
			workloadList[0].setTaskName("MA域的设计");
			workloadList[0].setLayer("2");
			workloadList[0].setPlanWorkload("20");
			workloadList[0].setActualWorkload("30");
			workloadList[0].setMaReportId("0");
		
			workloadList[1].setProjectId("cmmi");
			workloadList[1].setTaskId("1");
			workloadList[1].setTaskName("CM域的设计");
			workloadList[1].setLayer("2");
			workloadList[1].setPlanWorkload("20");
			workloadList[1].setActualWorkload("30");
			workloadList[1].setMaReportId("0");
		}
		*/
		
		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); 					
			Workload aWorkload;
			int numOfWorkload = 0;
			Workload[] temp=new Workload[100];
			//maObjects = new MaObject[13];
			System.out.println("layer="+layer);
			while ((rs.next()) && (numOfWorkload < 100))
			{
				String tempLayer=rs.getString("layer");
				if ((getLayer(tempLayer).equals(layer))&&(isBrance(tempLayer,taskId)||(!c_ma)))
				{	
					aWorkload=new Workload();			
				
					aWorkload.setProjectId(projId);
					aWorkload.setTaskId(rs.getString("taskid"));
					aWorkload.setTaskName(rs.getString("taskname"));
					aWorkload.setLayer(layer);
					//aWorkload.setPlanWorkload(rs.getString("taskid"));
					aWorkload.setActualWorkload(rs.getString("workload"));
					aWorkload.setWindageGate(windageGate);
					aWorkload.setMaReportId(taskId);
					aWorkload.getPlanWorkloadFormDb();
					temp[numOfWorkload] = aWorkload;		
					numOfWorkload++;
					System.out.println("numOfWorkload=" + numOfWorkload);	
				}
			}
			workloadList=new Workload[numOfWorkload];
			System.arraycopy(temp,0,workloadList,0,numOfWorkload);
			if(rs!=null) rs.close();
			if(dbf!=null) dbf.close();
		}
		catch (Exception e)   	
		{
			System.out.println("Exception in createWorkloadList:" + e.getMessage());
		}
		
		if(c_ma)
		{
			for(int i=0;i<workloadList.length;i++)
				workloadList[i].ma();
		}
	}
	
	public Workload[] getWorkloadList() 
	{
		return workloadList;
	}

	public void setWorkloadList(Workload[] workloadList) 
	{
		this.workloadList = new Workload[workloadList.length];
		System.arraycopy(workloadList,0,this.workloadList,0,workloadList.length);
	}
	
	public void store()
	{
		if (!c_store)
		{
			for(int i=0;i<workloadList.length;i++)
			{
				workloadList[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++;
		}
		System.out.println("layer="+layer+"layerInt="+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;
	}
	
}