pactnumber.java

sso呵呵

package com.mdcl.mocha.jlcmcc.contract.serviceimp.pactnumber;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;


import com.mdcl.mocha.jlcmcc.DBconnection.DBConnectionManager;


/**
 * <strong>Title : pactNumber<br></strong>
 * <strong>Description : </strong>吉林移动BPM合同编号接口类<br>
 * <strong>Create on : 2007-9-13<br></strong>
 * <p>
 * <strong>Copyright (C) Mocha Software Co.,Ltd.<br></strong>
 * <p>
 * @author [e-mail]<br>
 * @version <strong>Mocha BPM v6.2</strong><br>
 * <br>
 * <strong>修改历史:</strong><br>
 * 修改人	：zhanghd	修改日期: 2007-10-14	<br>
 * 修改描述: 增加了得到合同编号一个list的方法<br>
 * -------------------------------------------<br>
 * <br>
 * <br>
 */
public class pactNumber {

	/**
	 *
	 * 根据部门编号、合同小类ID获得合同编号
	 *
	 *@param departmentID
	 *            <i>部门编号</i>
	 *@param smallID
	 *            <i>合同小类ID</i>
	 * @return 合同编号
	 */
	public String getPactNumber(String departmentID,String smallID){
		String result=null;
		String companyCODE=null;
		String companyNUM=null;
		String departmentCODE=null;
		String departmentNUM=null;
		String smallCODE=null;
		DBConnectionManager db=DBConnectionManager.getInstance();
	    Connection con = null;
		Statement stmt =null;
		try
		{
			con=db.getConnection("idb");
			con.setAutoCommit(false);
			stmt = con.createStatement();

			//获得部门代字和所属公司ID
			String companyID=null;
			String sql="select CODE,COMPANY_ID from contr_dept_code where ID='"+departmentID+"'";
			ResultSet rs = stmt.executeQuery(sql);
			if(rs.next()){
				departmentCODE=rs.getString("CODE");
				companyID=rs.getString("COMPANY_ID");
			}
			else return null;

			//根据所属公司ID获得公司代字
			sql="select CODE from contr_company_code where ID='"+companyID+"'";
			rs=null;
			rs = stmt.executeQuery(sql);
			if(rs.next()){
				companyCODE=rs.getString("CODE");
			}
			else return null;

			//获得新公司流水号和部门流水号
			sql="select contr_company_code_sequence.nextval,CONTR_DEPT_CODE_SEQUENCE.nextval from dual";
			rs=null;
			rs = stmt.executeQuery(sql);
			if(rs.next()){
				companyNUM=rs.getString(1);
				departmentNUM=rs.getString(2);
			}
			else return null;
			for(int i=companyNUM.length();i<4;i++){
				companyNUM="0"+companyNUM;
			}
			for(int i=departmentNUM.length();i<4;i++){
				departmentNUM="0"+departmentNUM;
			}

			//将获得新公司流水号和部门流水号存入数据库
			sql="update contr_company_code set NUM='"+companyNUM+"' where ID='"+companyID+"'";
			stmt.executeUpdate(sql);
			sql="update contr_dept_code set NUM='"+departmentNUM+"' where ID='"+departmentID+"'";
			stmt.executeUpdate(sql);

			//根据合同小类名获得合同小类编号
			sql="select CODE from contract_small_type where ID='"+smallID+"'";
			rs=null;
			rs = stmt.executeQuery(sql);
			if(rs.next()){
				smallCODE=rs.getString("CODE");
			}
			else return null;

			con.commit();
			con.setAutoCommit(true);
		} catch (SQLException e) {

			e.printStackTrace();
			try {
				con.rollback();
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}

		}finally{
			try {
				con.setAutoCommit(true);
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			db.freeConnection("idb",con);
		}

		//操作失败返回null
		if(companyCODE==null||departmentCODE==null||smallCODE==null||departmentNUM==null||companyNUM==null)return null;

		//获得合同编号
		SimpleDateFormat data = new SimpleDateFormat ( "yyyyMMdd" );
		result="JLMC-"+companyCODE+"-"+departmentCODE+"-"+smallCODE+"-"+data.format( new Date())+"-"+departmentNUM+"/"+companyNUM+"号";

		return result;
	}

	/**
	 * 方法描述 通过调用 getPactNumber 得到合同编号的list
	 * @param departmentID 部门编号
	 * @param smallID 合同小类ID
	 * @param Num 合同数
	 * @return  ListNumber 合同编号的list
	 */
	public List getListNumber(String departmentID,String smallID,int Num)
	{
		List ListNumber = new ArrayList();
		for(int i=0;i<Num;i++){
			String pactNum = getPactNumber( departmentID, smallID);
			ListNumber.add(pactNum);
		}
		return ListNumber;
	}
}