Ejemplo n.º 1
0
  /**
   * 该函数筛选出某部门上报没有通过的项目记录
   *
   * @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;
  }
Ejemplo n.º 2
0
  /**
   * ********************************************区分管领导对项目的操作!!*********************************************
   */
  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;
  }