seikyulogic.java

用strutshibernate做的项目

		return list_mess;
	}

	/**
	 * ?��HikikaeNinkiSearchKen.jsp�aHikikaeNinkiSearchZen.jsp?�ʎ�v?���I�\�i���I�M��
	 * 
	 * @param form
	 * @param list
	 * @return List list
	 * @author �����????? 2006-04-13
	 */
	public static List message_list_lv(HikikaeNinkiActionForm form, List list,
			int m) {

		List list_mess = new ArrayList();
		List list_nu = new ArrayList();
		int nen = Integer.parseInt(form.getNen());
		int gyousya_mei = Integer.parseInt(form.getGyousya_mei());
		String flag = "";
		// String sql_str = "SELECT * FROM SEIKYU WHERE NEN = " + nen
		// + " AND HAGAKI_ID = " + gyousya_mei;
		String sql_str = " AND A.NEN = " + nen + " AND A.HAGAKI_ID = "
				+ gyousya_mei;
		if (form.getKyoku_id() != null && !form.getKyoku_id().equals("")) {
			String kyoku_id = form.getKyoku_id();
			int kyoku_id_first = Integer.parseInt(kyoku_id.substring(0, 2));
			String kyoku_id_last = kyoku_id.substring(2, 5);
			sql_str = sql_str + " AND A.KEN_ID = " + kyoku_id_first
					+ " AND A.KYOKU_ID = '" + kyoku_id_last + "'";
		}
		if (form.getKen_id() != null && !form.getKen_id().equals("")) {
			System.out.println("cha xun shu ju ku");
			flag = list.get(0).toString();
			for (int i = 1; i < list.size(); i++) {

				if (list.get(i) == null || list.get(i).toString().equals("")) {
				} else {
					flag = flag + ","
							+ Integer.parseInt(list.get(i).toString());
				}
			}
			sql_str = sql_str + " AND A.KEN_ID in(" + flag + ")";
			System.out.println("sql_str eeeeeeee>>>>" + sql_str);
		}
		
		list_mess = Syouhin.num_l(sql_str, m);
		return list_mess;
	}

	/**
	 * ?K?????h-?h?A????????
	 * 
	 * @param str1
	 * @return String str
	 * @author????? 2006-04-19
	 */
	public static String nen_S(String str1) {

		String str = null;
		StringTokenizer st = new StringTokenizer(str1, "-");
		str = st.nextToken() + st.nextToken() + st.nextToken();
		System.out.println("str nen d zhi shi ++++++>>>" + str);
		return str;
	}

		
		/**
		 * ���̊֐��̍�该函数获取葉書区分List���܂�
		 * @return List
		 * @author �杨丽娟 2006-04-05
		 */
		public List getHagakicd(){
			List HagakicdList = Hagakicd.getHagakicd();
			return HagakicdList;
		}
		
		/**
		 * ���̊֐��̍�该函数用于获得邮局信息List
		 * @param KEN_ID, KYOKU_ID���܂�
		 * @return List
		 * @author �杨丽娟 2006-04-05
		 */
		public List getKyokusyo(String KEN_ID, String KYOKU_ID){
			List KyokuList = new ArrayList();
			int ken_id = Integer.parseInt(KEN_ID);
			String sqlstr = "SELECT * FROM KYOKUSYO "
							+ "WHERE KEN_ID = " + ken_id
							+ " AND KYOKU_ID = '" + KYOKU_ID + "'";
			System.out.println("~~~~~>" + sqlstr);
			KyokuList = Kyokusyo.getKyokuData(sqlstr);
			return KyokuList;
		}

		/**
		 * ���̊֐��̍�该函数用于获得等级List���܂�
		 * @return List
		 * @author �杨丽娟 2006-04-05
		 */
		public List getToukyucd(){
			List ToukyucdList = Toukyucd.getToukyucd();
			return ToukyucdList;
		}
		
		/**
		 * 该函数用于IdoInput页面查询符合条件的数据
		 * 根据form填入内容拼凑查询语句
		 * @param form,num,page
		 * @return List
		 * @author �杨丽娟 2006-04-10
		 */
		public List getSearchDate(IdouInputActionForm form,int num,int page){
			int nen = Integer.parseInt(form.getNian());
			int hagaki_id = Integer.parseInt(form.getYeshuqufen());
			List SearchDate = new ArrayList();
			String sqlstr = "SELECT * FROM SEIKYU WHERE NEN = " 
							+ nen + " AND HAGAKI_ID = " + hagaki_id
							+ " AND DEL_FLG = 0";
			if(form.getShoufufanhao()!=null && !form.getShoufufanhao().equals("")){
				int i = form.getShoufufanhao().length() - 6;
				int id = Integer
							.parseInt(form.getShoufufanhao()
											.substring(i));
				sqlstr = sqlstr + " AND ID = " + id;
			}
			if(form.getDengji()!=null && !form.getDengji().equals("")){
				int toukyu_id = Integer.parseInt(form.getDengji());
				sqlstr = sqlstr + " AND TOUKYU_ID = " + toukyu_id;
			}
			if(form.getZufanhao()!=null && !form.getZufanhao().equals("")){
				String kumi = form.getZufanhao();
				sqlstr = sqlstr + " AND KUMI = '" + kumi + "'";
			}
			if(form.getFanhao()!=null && !form.getFanhao().equals("")){
				String bangou = form.getFanhao();
				sqlstr = sqlstr + " AND BANGOU = '" + bangou + "'";
			}
			if(form.getJusuokodo()!=null && !form.getJusuokodo().equals("")){
				int ken_id = Integer.parseInt(form.getJusuokodo().substring(0,2));
				String kyoku_id = form.getJusuokodo().substring(2);
				sqlstr = sqlstr + "AND KEN_ID = " + ken_id 
						+ " AND KYOKU_ID = '" + kyoku_id + "'";
			}
			if(form.getQingqiushangpinkodo()!=null 
					&& !form.getQingqiushangpinkodo().equals("")){
				int syouhin_id = Integer.parseInt(form.getQingqiushangpinkodo());
				sqlstr = sqlstr + " AND SYOUHIN_ID = " + syouhin_id;
			}
			if(form.getYidongjuedingdate()!=null 
					&& !form.getYidongjuedingdate().equals("")){
				String kettei_date = form.getYidongjuedingdate();
				sqlstr = sqlstr + " AND KETTEI_DATE = '"
						+ kettei_date + "'";
			}
			if(form.getJi()!=null && form.getJi().equals("")){
				int taisyo_flg = Integer.parseInt(form.getJi().substring(0,1));
				int kettei_flg = Integer.parseInt(form.getJi().substring(1));
				sqlstr = sqlstr + " AND TAISYO_FLG = " + taisyo_flg
						+ " AND KETTEI_FLG = " + kettei_flg;
			}
			sqlstr = sqlstr + " ORDER BY ID DESC,NEN DESC,HAGAKI_ID ASC,TOUKYU_ID ASC";
			System.out.println("sqlstr is 8888>>**" + sqlstr);
			SearchDate = Seikyu.getPageBeanList(sqlstr,num,page);
			return SearchDate;
		}
		
		/**
		 * 该方法用于获得IdouSearch页面的
		 * 每页显示的第一条数据和最后一条数据的标号�Ŗʂ�
		 * �Ő��根据form填入内容拼凑查询语句���܂�
		 * @param num 每页显示条数
		 * @param page 当前页数
		 * @return
		 */
		public int[] getIdouSearchPagenumbers(int num,int page,IdouInputActionForm form){
			int[] pagenum = new int[4];
			int nen = Integer.parseInt(form.getNian());
			int hagaki_id = Integer.parseInt(form.getYeshuqufen());
			String sqlstr = "SELECT * FROM SEIKYU WHERE NEN = " 
							+ nen + " AND HAGAKI_ID = " + hagaki_id
							+ " AND DEL_FLG = 0";
			if(form.getShoufufanhao()!=null && !form.getShoufufanhao().trim().equals("")){
				int i = form.getShoufufanhao().length() - 6;
				int id = Integer
							.parseInt(form.getShoufufanhao()
											.substring(i));
				sqlstr = sqlstr + " AND ID = " + id;
			}
			if(form.getDengji()!=null && !form.getDengji().trim().equals("")){
				int toukyu_id = Integer.parseInt(form.getDengji());
				sqlstr = sqlstr + " AND TOUKYU_ID = " + toukyu_id;
			}
			if(form.getZufanhao()!=null && !form.getZufanhao().trim().equals("")){
				String kumi = form.getZufanhao();
				sqlstr = sqlstr + " AND KUMI = '" + kumi + "'";
			}
			if(form.getFanhao()!=null && !form.getFanhao().trim().equals("")){
				String bangou = form.getFanhao();
				sqlstr = sqlstr + " AND BANGOU = '" + bangou + "'";
			}
			if(form.getJusuokodo()!=null && !form.getJusuokodo().trim().equals("")){
				int ken_id = Integer.parseInt(form.getJusuokodo().substring(0,2));
				String kyoku_id = form.getJusuokodo().substring(2);
				sqlstr = sqlstr + "AND KEN_ID = " + ken_id 
						+ " AND KYOKU_ID = '" + kyoku_id + "'";
			}
			if(form.getQingqiushangpinkodo()!=null 
					&& !form.getQingqiushangpinkodo().trim().equals("")){
				int syouhin_id = Integer.parseInt(form.getQingqiushangpinkodo());
				sqlstr = sqlstr + " AND SYOUHIN_ID = " + syouhin_id;
			}
			if(form.getYidongjuedingdate()!=null 
					&& !form.getYidongjuedingdate().trim().equals("")){
				String kettei_date = form.getYidongjuedingdate();
				sqlstr = sqlstr + " AND KETTEI_DATE = '"
						+ kettei_date + "'";
			}
			if(form.getJi()!=null && form.getJi().trim().equals("")){
				int taisyo_flg = Integer.parseInt(form.getJi().substring(0,1));
				int kettei_flg = Integer.parseInt(form.getJi().substring(1));
				sqlstr = sqlstr + " AND TAISYO_FLG = " + taisyo_flg
						+ " AND KETTEI_FLG = " + kettei_flg;
			}
			sqlstr = sqlstr + " ORDER BY ID DESC,NEN DESC,HAGAKI_ID ASC,TOUKYU_ID ASC";
			System.out.println("sqlstr si -->" + sqlstr);
			int[] getnum = Seikyu.getPagenum(num,page,sqlstr);
			for(int i = 0; i < 3; i++){
				pagenum[i] = getnum[i];
			}
			pagenum[3] = Seikyu.getCont(sqlstr);
			return pagenum;
		}
			
		/**
		 * ���̊֐��̍�该函数用于获得IdouKetteidate页面的数据���܂�
		 * @return List
		 * @author �杨丽娟 2006-04-10
		 */
		public List getIdouKetteidate(){
			String Sqlstr = "SELECT * FROM SEIKYU "
							+ "WHERE TAISYO_FLG = 1 " 
							+ "AND KETTEI_FLG = 0"
							+ "AND DEL_FLG = 0"
							+ "ORDER BY ID DESC,"
							+ "NEN DESC,"
							+ "HAGAKI_ID ASC,"
							+ "TOUKYU_ID ASC,"
							+ "BANGOU ASC";
			List IdouKetList = Seikyu.getBeanList(Sqlstr);
			return IdouKetList;
		}
		

		
		/**
		 * ���̊֐��̍�该函数用于获得��SeikyuSearch�ŖʂɕŐ���页面的
		 * 信息总数以及每页显示的第一条数据和最后一条数据的标号���܂�
		 * @param num 每页显示信息条数
		 * @param page 当前页数
		 * @param jusuokodo 邮局号
		 * @return int[]
		 * @author 杨丽娟 2006-04-11
		 */
		public int[] getSeikyuSearchPagenum(int num,int page,String jusuokodo){
			int[] pagenum = new int[4];
			int ken_id = Integer
							.parseInt(jusuokodo.substring(0,2));
			String kyoku_id = jusuokodo.substring(2);
			String sqlstr = "SELECT * FROM SEIKYU "
							+"WHERE KEN_ID = " + ken_id
							+ " AND KYOKU_ID = '" + kyoku_id + "'"
							+" ORDER BY ID DESC,"
							+ "NEN DESC,"
							+ "HAGAKI_ID ASC,"
							+ "TOUKYU_ID ASC,"
							+ "BANGOU ASC";
			int[] number = Seikyu.getPagenum(num,page,sqlstr);
			for(int i = 0; i < 3; i++){
				pagenum[i] = number[i];
			}
			pagenum[3] = Seikyu.getCont(sqlstr);
			return pagenum;
		}
		

		
		/**
		 * 该函数用于获得SeikyuSearch页面要显示的数据List���܂���
		 * @param num 每页显示条数
		 * @param page 当前页数
		 * @return List
		 * @author� 杨丽娟 2006-04-11
		 */
		public List getSeikyuSearchdata(int num,int page,String jusuokodo){
			List pList = new ArrayList();
			int ken_id = Integer
							.parseInt(jusuokodo.substring(0,2));
			String kyoku_id = jusuokodo.substring(2);
			String sqlstr = "SELECT * FROM SEIKYU "
							+"WHERE KEN_ID = " + ken_id
							+ " AND KYOKU_ID = '" + kyoku_id + "'"
				            +" ORDER BY ID DESC,"
							+ "NEN DESC,"
							+ "HAGAKI_ID ASC,"
							+ "TOUKYU_ID ASC,"
							+ "BANGOU ASC";
			pList = Seikyu.getPageBeanList(sqlstr,num,page);
			return pList;
		}
		
		/**
		 * 该函数用于获得IdouKettei页面显示的数据List
		 * @return List
		 * @author� 杨丽娟 2006-04-13
		 */
		public List getIdouKetteiData(){
			List KetteiList = new ArrayList();
			String sqlstr = "SELECT * FROM SEIKYU "
							+ "WHERE TAISYO_FLG = 1 "
							+ "AND KETTEI_FLG = 0 "
							+ "AND DEL_FLG = 0"
							+" ORDER BY ID DESC,"
							+ "NEN DESC,"
							+ "HAGAKI_ID ASC,"
							+ "TOUKYU_ID ASC,"
							+ "BANGOU ASC";
			KetteiList = Seikyu.getBeanList(sqlstr);
			return KetteiList;
		}
		
		/**
		 * 该函数用于获得IdouKettei页面显示的信息总数
		 * @return int
		 * @author 杨丽娟 2006-04-13
		 */
		public int getIdouKetteiCont(){
			int cont = 0;
			String sqlstr = "SELECT * FROM SEIKYU "
				+ "WHERE TAISYO_FLG = 1 "
				+ "AND KETTEI_FLG = 0 "
				+ "AND DEL_FLG = 0"
				+" ORDER BY ID DESC,"
				+ "NEN DESC,"
				+ "HAGAKI_ID ASC,"
				+ "TOUKYU_ID ASC,"
				+ "BANGOU ASC";
			cont = Seikyu.getCont(sqlstr);
			return cont;
		}
		
		
		/**
		 * 该函数用于检查数据库记录的修改时间是否大于当前系统时间
		 * 是则返回false，否则返回true
		 * @param nowdatetime 获取的当前系统时间
		 * @return boolean
		 * @author� 杨丽娟 2006-04-17
		 */
		public boolean checkUpdate_DateTime(String nowdatetime){
			boolean flag = false;
			/*
			 * 将格式化好的系统时间字符串分割