projectprocess.java

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

package com.cmmi2pms.ma;

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

import com.cmmi2pms.common.comdb.*;
import com.cmmi2pms.common.DateOp;

public class ProjectProcess 
{
	private  String   projectId;
	private  String   taskId;
	private  String   taskName;
	private  String   layer;
	private	 String   startTimeP;
	private	 String   stopTimeP;
	private	 String   startTimeA;
	private	 String   stopTimeA;
	private  String   planProcess;
	private  String   actualProcess;
	private  String   lag;
	private  int	  lagDou;
	private	 String   lagRate;
	private  double   lagRateDou;
	private	 String	  processLagFlag;
	private  boolean  forMa;
	private  double   windageGate;
	private  DateOp   datashow;
	private  String   maReportId;
	
	
	public String  getProcessLagFlag() {
		return processLagFlag;
	}

	public void setProcessLagFlag(String  processLagFlag) {
		this.processLagFlag = processLagFlag;
	}
	
	public String  getMaReportId() {
		return maReportId;
	}

	public void setMaReportId(String  maReportId) {
		this.maReportId = maReportId;
	}
	
	public ProjectProcess()
	{
		System.out.println("ProjectProcess()");
		datashow=new DateOp();
	} 
	
	
	public String getStartTimeP() {
		return startTimeP;
	}

	public void setStartTimeP(String startTimeP) {
		this.startTimeP = startTimeP;
	}
	
	public String getStopTimeP() {
		return stopTimeP;
	}

	public void setStopTimeP(String stopTimeP) {
		this.stopTimeP = stopTimeP;
	}
	
	public String getStartTimeA() {
		return startTimeA;
	}

	public void setStartTimeA(String startTimeA) {
		this.startTimeA = startTimeA;
	}
	
	public String getStopTimeA() {
		return stopTimeA;
	}

	public void setStopTimeA(String stopTimeA) {
		this.stopTimeA = stopTimeA;
	}
	
	
	public double getWindageGate() {
		return windageGate;
	}

	public void setWindageGate(double windageGate) {
		this.windageGate = windageGate;
	}
	
	public String getProjectId() {
		return projectId;
	}

	public void setProjectId(String projectId) {
		this.projectId = projectId;
	}
			
	public String getTaskId() {
		return taskId;
	}

	public void setTaskId(String taskId) {
		this.taskId = taskId;
	}
	
	public String getTaskName() {
		return taskName;
	}

	public void setTaskName(String taskName) {
		this.taskName = taskName;
	}
	
	public String getLayer() {
		return layer;
	}

	public void setLayer(String layer) {
		this.layer = layer;
	}
	
	public String getPlanProcess() {
		return planProcess;
	}

	public void setPlanProcess(String planProcess) {
		this.planProcess = planProcess;
	}
	public String getActualProcess() {
		return actualProcess;
	}

	public void setActualProcess(String actualProcess) {
		this.actualProcess = actualProcess;
	}
	
	public String getLag() {
		return lag;
	}

	public void setLag(String lag) {
		this.lag = lag;
	}
	
	public String getLagRate() {
		return lagRate;
	}

	public void setLagRate(String lagRate) {
		this.lagRate = lagRate;
	}
	
	public void getFormDb()
	{
		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_proestimate where projectID = '" + projectId + "' and TaskId = "+taskId;
			rs=dbf.executeQuery(sql); 					
			if (rs.next())
			{
				this.startTimeP=rs.getString("orgplanstart");
				this.stopTimeP=rs.getString("orgplanend");
			}
			
			rs = null;
			int tempInt=Integer.parseInt(taskId);
			System.out.println("Integer.toString(-tempInt)"+Integer.toString(-tempInt));
			sql = "SELECT * FROM pp_proestimate where projectID = '" + projectId + "' and TaskId = "+Integer.toString(-tempInt);
			rs=dbf.executeQuery(sql);					
			
			if (rs.next())
			{
				this.startTimeA=rs.getString("curplanstart");
				this.stopTimeA=rs.getString("curplanend");
			}
			if(rs!=null) rs.close();
			if(dbf!=null) dbf.close();
		}
		catch (Exception e)   	
		{
			System.out.println("Exception in createProcess:" + e.getMessage());
		}
	}
	
	
	public void 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_Process` VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)");
		    
		    	System.out.println("before sql");
			java.sql.Date tempTime; 
			
			dbf.setInt(1,Integer.parseInt(taskId));
			dbf.setString(2,projectId);
			tempTime = new java.sql.Date(datashow.getDate(startTimeP).getTime());
			dbf.setDate(3,tempTime);
			tempTime = new java.sql.Date(datashow.getDate(stopTimeP).getTime());
			dbf.setDate(4,tempTime);
			tempTime = new java.sql.Date(datashow.getDate(startTimeA).getTime());
			dbf.setDate(5,tempTime);
			tempTime = new java.sql.Date(datashow.getDate(startTimeA).getTime());
			dbf.setDate(6,tempTime);
			dbf.setInt(7,lagDou);
			dbf.setDouble(8,lagRateDou);
			if (processLagFlag.equals("yes"))
				dbf.setInt(9,1);
			else	dbf.setInt(9,0);
			dbf.setInt(10,Integer.parseInt(planProcess));
			dbf.setInt(11,Integer.parseInt(actualProcess));
			dbf.setString(12,taskName);
			dbf.setInt(13,Integer.parseInt(maReportId));
			
			dbf.execute();
			//List results of changes.
			if(dbf!=null) dbf.close();  
		}
		catch (Exception e)   	
		{
			System.out.println("Exception in createMaProcess:" + e.getMessage());
		}
	}
	
	public void ma()
	{
		int temp1,temp2;
		temp1=datashow.subDayNum(startTimeP,stopTimeP);
		temp2=datashow.subDayNum(startTimeA,stopTimeA);
		planProcess=Integer.toString(temp1);
		actualProcess=Integer.toString(temp2);
		lagDou=temp2-temp1;
		//lag="30";
		lag=Integer.toString(lagDou);
		lagRateDou=100*((double)lagDou)/temp1;
		lagRate=Double.toString(lagRateDou);
		if (lagRate.length()>5)
			lagRate=lagRate.substring(0,5);
		if(lagRateDou>=windageGate)
			processLagFlag="yes";
		else	processLagFlag="no";
		//lagRate="0.8";
	}
	
}