/**
* 该函数筛选出某部门上报没有通过的项目记录
*
* @param leadDeparmtentId 上报部门编号
* @return
*/
public ArrayList<ProjectMonthRecordBean> searchProjectFaildByLeadDepatrment(
String leadDeparmtentId) {
ArrayList<ProjectMonthRecordBean> list = new ArrayList<ProjectMonthRecordBean>();
String selectSQL =
"select Project.projectId,Project.projectName,evaForm.isMoney,evaForm.evaluationContent,Project.totalProgress,resDep.departmentName,Project.evaContent,ProjectMonthRecord.taskMonth,ProjectMonthRecord.status,ProjectMonthRecord.monthFinish,ProjectMonthRecord.monthMoney,ProjectMonthRecord.monthProgress,ProjectMonthRecord.submitTime,ProjectMonthRecord.firstView,ProjectMonthRecord.secondView,ProjectMonthRecord.thirdView,Project.currentFinish,Project.firstClassify, Project.secondClassify "
+ "from (((project inner join Department as resDep on Project.resDepartmentId=resDep.departmentID ) inner join EvaluationForm as evaForm on evaForm.evaluationId=Project.evaluationId and evaForm.leadDepartmentId='"
+ leadDeparmtentId
+ "' )inner join ProjectMonthRecord on Project.projectId=ProjectMonthRecord.projectId ) where status like '%F%';";
ResultSet rs = this.SelectDB(selectSQL);
try {
while (rs.next()) {
ProjectMonthRecordBean pmrb = new ProjectMonthRecordBean();
pmrb.setProjectId(rs.getString("projectId"));
pmrb.setProjectName(rs.getString("projectName"));
pmrb.setIsMoney(rs.getString("isMoney"));
pmrb.setTotalProgress(rs.getDouble("totalProgress"));
pmrb.setResDepartmentName(rs.getString("departmentName"));
pmrb.setEvaluationContent(rs.getString("evaluationContent"));
pmrb.setProjectEvaContent(rs.getString("evaContent"));
pmrb.setEvaMonth(rs.getInt("taskMonth"));
pmrb.setStatus(rs.getString("status"));
pmrb.setMonthFinish(rs.getString("monthFinish"));
pmrb.setMonthProgress(rs.getDouble("monthMoney"));
pmrb.setMonthProgress(rs.getDouble("monthProgress"));
pmrb.setSubmitTime(rs.getString("submitTime"));
pmrb.setMonthFinish(rs.getString("currentFinish"));
pmrb.setFirstView(rs.getString("firstView"));
pmrb.setSecondView(rs.getString("secondView"));
pmrb.setThirdView(rs.getString("thirdView"));
list.add(pmrb);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
/**
* ********************************************区分管领导对项目的操作！！*********************************************
*/
public ArrayList<ProjectMonthRecordBean> QianTouLeaderViewList(String leadarName) {
ArrayList<ProjectMonthRecordBean> list = new ArrayList<ProjectMonthRecordBean>();
String selectSQL =
"select Project.projectId,Project.projectName,evaForm.isMoney,evaForm.evaluationContent,evaForm.separateLeader,Project.totalProgress,resDep.departmentName,Project.evaContent,ProjectMonthRecord.taskMonth,ProjectMonthRecord.status,ProjectMonthRecord.monthFinish,ProjectMonthRecord.monthMoney,ProjectMonthRecord.monthProgress,ProjectMonthRecord.submitTime,ProjectMonthRecord.firstView,ProjectMonthRecord.secondView,ProjectMonthRecord.thirdView,Project.currentFinish,Project.firstClassify, Project.secondClassify "
+ "from (((project inner join Department as resDep on Project.resDepartmentId=resDep.departmentID ) inner join EvaluationForm as evaForm on evaForm.evaluationId=Project.evaluationId )left outer join ProjectMonthRecord on Project.projectId=ProjectMonthRecord.projectId ) where status='T00' and separateLeader='"
+ leadarName
+ "';";
System.out.println(selectSQL);
ResultSet rs = this.SelectDB(selectSQL);
try {
while (rs.next()) {
/*projectId projectName isMoney evaluationContent totalProgress
* departmentName evaContent taskMonth status monthFinish
* monthMoney monthProgress submitTime firstView secondView
* thirdView currentFinish firstClassify secondClassify
*/
ProjectMonthRecordBean pmrb = new ProjectMonthRecordBean();
pmrb.setProjectId(rs.getString("projectId"));
pmrb.setProjectName(rs.getString("projectName"));
pmrb.setIsMoney(rs.getString("isMoney"));
pmrb.setTotalProgress(rs.getDouble("totalProgress"));
pmrb.setResDepartmentName(rs.getString("departmentName"));
pmrb.setEvaluationContent(rs.getString("evaluationContent"));
pmrb.setProjectEvaContent(rs.getString("evaContent"));
pmrb.setEvaMonth(rs.getInt("taskMonth"));
pmrb.setStatus(rs.getString("status"));
pmrb.setMonthFinish(rs.getString("monthFinish"));
pmrb.setMonthProgress(rs.getDouble("monthMoney"));
pmrb.setMonthProgress(rs.getDouble("monthProgress"));
pmrb.setSubmitTime(rs.getString("submitTime"));
// pmrb.setMonthFinish(rs.getString("currentFinish"));
pmrb.setFirstView(rs.getString("firstView"));
pmrb.setSecondView(rs.getString("secondView"));
pmrb.setThirdView(rs.getString("thirdView"));
pmrb.setMonthMoney(rs.getDouble("monthMoney"));
list.add(pmrb);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}