departmentctrl.java

文件的上传和下载的实现,用JAva编写,非常简单

package edu.whut.cwts.pg.hexiao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

public class DepartmentCtrl {
	public static String formZddm(String zddm){
		if(zddm.substring(0,1).equals("0"))zddm="000000";
		return zddm;
	}

	public static int getLogicLevel(String zddm){
		int departmentlogicLevel=0;
		zddm=formZddm(zddm);
		
		  if(zddm.equals("000000"))
          {
			//System.out.println("征稽处");
			departmentlogicLevel=0;
		   }
		  else if(zddm.equals(" "))
          {
			//System.out.println("用户个人");
			departmentlogicLevel=9;
		   }
				  
		  

		
	      else if(zddm.equals("100000"))
		  {
			//System.out.println("征稽处征收科");
	    	 departmentlogicLevel=3;
		   }
		
		  else if(zddm.substring(2).equals("0000")){
			departmentlogicLevel=1;//中心站或直属站
		   }
        
		
		
		  else if(zddm.substring(2,4).equals("00")){
			if(!zddm.substring(4,6).equals("00"))departmentlogicLevel=3;//征稽点或征稽分站
			
		   }
		
		  else if(!zddm.substring(2,4).equals("00") && zddm.substring(4,6).equals("00") ){
			if(zddm.substring(2,4).equals("01"))departmentlogicLevel=3;//中心站或直属站征收科
			else departmentlogicLevel=2;//征稽站
			
		   }
		
		  else if(!zddm.substring(2,4).equals("00") && zddm.substring(4,6).equals("01")){
			departmentlogicLevel=3;//征稽站直征点
			
		   }
		
		  else if(!zddm.substring(2,4).equals("00") && !zddm.substring(4,6).equals("00") && !zddm.substring(4,6).equals("01")){
			if(!zddm.substring(2,4).equals("01"))departmentlogicLevel=3;//征稽点
		   }

	
		return departmentlogicLevel;
	}
	//////////////////////取得站点级别////////////////////////////////
	public static String getLevel(String zddm){
		String departmentLevel="#";
		zddm=formZddm(zddm);
		
		if(zddm.equals("000000"))
        {
			//System.out.println("征稽处");
			departmentLevel="0";
		}
		
	     else if(zddm.equals("100000"))
		{
			//System.out.println("征稽处征收科");
	    	 departmentLevel="1";
		}
		
		else if(zddm.substring(2).equals("0000")){
			departmentLevel="2";//中心站或直属站
		}
        
		
		
		else if(zddm.substring(2,4).equals("00")){
			if(!zddm.substring(4,6).equals("00"))departmentLevel="6";//征稽点或征稽分站
			
		}
		
		else if(!zddm.substring(2,4).equals("00") && zddm.substring(4,6).equals("00") ){
			if(zddm.substring(2,4).equals("01"))departmentLevel="5";//中心站或直属站征收科
			else departmentLevel="3";//征稽站
			
		}
		
		else if(!zddm.substring(2,4).equals("00") && zddm.substring(4,6).equals("01")){
			departmentLevel="7";//征稽站直征点
			
		}
		
		else if(!zddm.substring(2,4).equals("00") && !zddm.substring(4,6).equals("00") && !zddm.substring(4,6).equals("01")){
			if(!zddm.substring(2,4).equals("01"))departmentLevel="4";//征稽点
		}
	
		return departmentLevel;
	}
	
	
	//获得本单位的下属级别一般的票据下发过程取得站点单位
	public static ArrayList getSubsites(String zddm)throws SQLException
	{
		ArrayList result=new ArrayList();
		if(getLogicLevel(zddm)==0)
		{
			Assert.p("站点级别为"+getLogicLevel(zddm));
			String sql="select * from zdxxb where substring(zddm,3,4)='0000' and substring(zddm,1,2)<>'00'";
			Assert.p(sql);
			ConnectDB conn=new ConnectDB();
			ResultSet rs=conn.executeQuery(sql);
			while(rs.next())
			{
				result.add(new Department(rs.getString("zddm"),rs.getString("zdmc")));
			}
			conn.close();
			return result;
		}
		
		//第二级站点返回所有直属的下属征稽站，征收科，征稽分站等
		if(getLogicLevel(zddm)==1)
		{
			Assert.p("站点级别为"+getLogicLevel(zddm));
			String pre=zddm.substring(0,2);
			String sql="select * from zdxxb where substring(zddm,1,2)='"+pre+"' and substring(zddm,5,2)='00' and substring(zddm,3,2)<>'00'";
			Assert.p(sql);
			ConnectDB conn=new ConnectDB();
			ResultSet rs=conn.executeQuery(sql);
			while(rs.next())
			{
				result.add(new Department(rs.getString("zddm"),rs.getString("zdmc")));
			}
			
			sql="select * from zdxxb where substring(zddm,1,2)='"+pre+"' and substring(zddm,5,2)<>'00' and substring(zddm,3,2)='00'";
			Assert.p(sql);
			rs=conn.executeQuery(sql);
			while(rs.next())
			{
				result.add(new Department(rs.getString("zddm"),rs.getString("zdmc")));
			}
			conn.close();
			return result;
		}
		
		if(getLogicLevel(zddm)==2)
		{
			Assert.p("站点级别为"+getLogicLevel(zddm));
			String pre=zddm.substring(0,4);
			String sql="select * from zdxxb where substring(zddm,1,4)='"+pre+"' and substring(zddm,5,2)<>'00'";
			Assert.p(sql);
			ConnectDB conn=new ConnectDB();
			ResultSet rs=conn.executeQuery(sql);
			while(rs.next())
			{
				result.add(new Department(rs.getString("zddm"),rs.getString("zdmc")));
			}
			conn.close();
			return result;
		}
		
		
		//当用户返回的级别为3时此时已经到达最低级别，此时直接返回属于此级的打票员就可以了
		else
		{
			Assert.p("站点级别为"+getLogicLevel(zddm));
			return result;
		}
	}
	public static String findByZddm(String zddm)throws java.sql.SQLException{
	    //根据站点代码获取站点名称
    	ArrayList result = new ArrayList();
    	ConnectDB conndb = new ConnectDB();
    	String sql = "SELECT zdmc from zdxxb where zddm='"+zddm.trim()+"'";
    	Assert.pl(sql);
    	ResultSet rs = conndb.executeQuery(sql);
    	if (rs == null)
    		return null;
    	while (rs.next()) {
			result.add(rs.getString("zdmc"));    		
    	}
		conndb.close();
		String mc=(String) result.get(0);
		return mc;    	
    }
	/*
	//用户选择统缴证后列出相关的下属站点来供用户选择将票据下发到什么地方
	public static List getSubsites(String zddm)throws SQLException
	{
		ArrayList result=new ArrayList();
		if(getLogicLevel(zddm)==0)
		{
			Assert.p("站点级别为"+getLogicLevel(zddm));
			String sql="select * from zdxxb where substring(zddm,3,4)='0000' and substring(zddm,1,2)<>'00'";
			Assert.p(sql);
			ConnectDB conn=new ConnectDB();
			ResultSet rs=conn.executeQuery(sql);
			while(rs.next())
			{
				result.add(new Department(rs.getString("zddm"),rs.getString("zdmc")));
			}
			conn.close();
			return result;
		}
		
		if(getLogicLevel(zddm)==1)
		{
			Assert.p("站点级别为"+getLogicLevel(zddm));
			String pre=zddm.substring(0,2);
			String sql="select * from zdxxb where substring(zddm,1,2)='"+pre+"' and substring(zddm,5,2)='00' and substring(zddm,3,2)<>'00'";
			Assert.p(sql);
			ConnectDB conn=new ConnectDB();
			ResultSet rs=conn.executeQuery(sql);
			while(rs.next())
			{
				result.add(new Department(rs.getString("zddm"),rs.getString("zdmc")));
			}
			conn.close();
			return result;
		}
		if(getLogicLevel(zddm)==2)
		{
			Assert.p("站点级别为"+getLogicLevel(zddm));
			String pre1=zddm.substring(0,4);
			String sql="select * from zdxxb where substring(zddm,1,4)='"+pre1+"' and substring(zddm,5,2)='01'";
			Assert.p(sql);
			ConnectDB conn=new ConnectDB();
			ResultSet rs=conn.executeQuery(sql);
			while(rs.next())
			{
				result.add(new Department(rs.getString("zddm"),rs.getString("zdmc")));
			}
			conn.close();
			return result;
		}
		else
		{
			return result;
		}
	}
	
	*/

	//////////////////////判断是否PDA//////////////////////////////
	/*public boolean isPDA(String zddm){
		boolean pda=false;
		zddm=this.formZddm(zddm);
		System.out.println(zddm);
		String last=zddm.substring(6);
		if(!last.equals("#"))pda=true;
		return pda;
	}*/
	///////////////////////取直接下级站点////////////////////////////

/*	public static void main(String[] args) {
		
		int i=getLogicLevel("110200");
		System.out.print(i);
		try{
		getSubsites("210200");
		}
		catch(SQLException e)
		{
			e.printStackTrace();
		}
	}
	*/
	public static void main(String args[]) throws SQLException
	{
		int i=getLogicLevel(" ");
			System.out.println(i);
	}

}