/**********************************************************
Copyright (C),2004-8-13, Beijing  USTB.
All rights reserved.
Filename: RuleBean.java
Author: 鄒晨
Version 1.0
Date:2004-8-13
Description:規(guī)則管理
Other:
Variable List:

Function List:
History:

 
***********************************************************/
package kjb2.library.bean;

import java.text.*;
import java.util.*;
import java.lang.*;
import java.io.*;
import java.sql.*;
import kjb.main.*;

public class RuleBean extends ParentBean
{
	private String id = "-1";

	//設(shè)置規(guī)則ID
	public void setID(String i)
	{
		id = i;
	}

	//取得所有信息內(nèi)容
	public Vector getData() 
	{
		String sql = "";
		sql = "select * from KJB2_KJXX_RULE order by RULEID";
		return searchData(sql);
	}
	
	//分頁(yè)取得所有信息
	public Vector getPageData(int page)
	{
		String sql ="";
		sql="select * from KJB2_KJXX_RULE";
		return  getOnePage(sql,page,20);
	}

	//根據(jù)規(guī)則的詳細(xì)信息
	public Hashtable getOneData(String id)
	{
		String sql="";
		sql = "select * from KJB2_KJXX_RULE where RULEID="+id+"";
		return searchOneData(sql);
	}

	//新增規(guī)則
	public int addRule(Hashtable hash)
	{
		int intID = makeID("KJB2_KJXX_RULE","RULEID","","",true);
		String strGZMC = ds.toString((String)hash.get("GZMC"));
		String strKJYSJ = ds.toString((String)hash.get("KJYSJ"));
		String strKJYGCDID = ds.toString((String)hash.get("KJYGCDID"));
		String strKXJSJ = ds.toString((String)hash.get("KXJSJ"));
		String strKXJCS = ds.toString((String)hash.get("KXJCS"));
		String strKYYSJ = ds.toString((String)hash.get("KYYSJ"));

		Vector vect = new Vector();
		vect.add("KJB2_KJXX_RULE");
		vect.add(addVector("RULEID",String.valueOf(intID),"NUM"));
		vect.add(addVector("GZMC",strGZMC,"CHAR"));
		vect.add(addVector("KJYSJ",strKJYSJ,"NUM"));
		vect.add(addVector("KJYGCDID",strKJYGCDID,"CHAR"));
		vect.add(addVector("KXJSJ",strKXJSJ,"NUM"));
		vect.add(addVector("KXJCS",strKXJCS,"NUM"));
		vect.add(addVector("KYYSJ",strKYYSJ,"NUM"));
		return insertRecord(vect);
	}

	//修規(guī)則信息
	public int modRule(Hashtable hash)
	{
		String strID = ds.toString((String)hash.get("RULEID"));
		String strGZMC = ds.toString((String)hash.get("GZMC"));
		String strKJYSJ = ds.toString((String)hash.get("KJYSJ"));
		String strKJYGCDID = ds.toString((String)hash.get("KJYGCDID"));
		String strKXJSJ = ds.toString((String)hash.get("KXJSJ"));
		String strKXJCS = ds.toString((String)hash.get("KXJCS"));
		String strKYYSJ = ds.toString((String)hash.get("KYYSJ"));

		Vector vect = new Vector();
		vect.add("KJB2_KJXX_RULE");
		vect.add(addVector("GZMC",strGZMC,"CHAR"));
		vect.add(addVector("KJYSJ",strKJYSJ,"NUM"));
		vect.add(addVector("KJYGCDID",strKJYGCDID,"CHAR"));
		vect.add(addVector("KXJSJ",strKXJSJ,"NUM"));
		vect.add(addVector("KXJCS",strKXJCS,"NUM"));
		vect.add(addVector("KYYSJ",strKYYSJ,"NUM"));
		vect.add("RULEID = "+strID);

		return updateRecord(vect);
	}


	//刪除規(guī)則信息
	public int delRule(String id)
	{
		String sql="";
		sql="delete from KJB2_KJXX_RULE where RULEID="+id;
		return deleteRecord(sql);
	}

	//取得所有規(guī)則名稱的字符串組合";"
	public String getAllRuleName()
	{
		String sql="";
		String strNames="";
		sql="select GZMC from  KJB2_KJXX_RULE";
		Vector vect =(Vector)searchData(sql);
		int n=vect.size();
		for(int i=0;i<n;i++)
		{
			Hashtable hash=(Hashtable)vect.get(i);
			String strName = ds.toString((String)hash.get("GZMC"));
			if(strNames.equals(""))
				strNames=strName;
			else
				strNames+=";"+strName;
		}
		return strNames;
	}

	//判斷某規(guī)則中是否有某館藏
	public boolean isContain(String ruleid,String storeid)
	{
		String sql="";
		if(ruleid.equals(""))
			return false;
		sql="select * from KJB2_KJXX_RULE where RULEID="+ruleid+" and KJYGCDID like '%"+storeid+"%'";
		Hashtable hash =(Hashtable)searchOneData(sql);
		if(hash.isEmpty())
			return false;
		else
			return true;
	}


	//取得所有有讀者的規(guī)則ID的組合";"
	public String getAllRuleID()
	{
		String sql="";
		String strIDs="";
		sql="select distinct RULEID from KJB2_KJXX_READER";
		Vector vect =(Vector)searchData(sql);
		int n=vect.size();
		for(int i=0;i<n;i++)
		{
			Hashtable hash=(Hashtable)vect.get(i);
			String strID = ds.toString((String)hash.get("RULEID"));
			if(strIDs.equals(""))
				strIDs=strID;
			else
				strIDs+=";"+strID;
		}
		return strIDs;
	}

	//查找所有的統(tǒng)一函數(shù)
	private Vector searchData(String sql) 
	{
		Vector vect = new Vector();
		ResultSet rs = selectRecord(sql);

		//取得列數(shù)和列名
		Statement stmt = null;
		try{
			ResultSetMetaData rsmd = rs.getMetaData();
			int cols = rsmd.getColumnCount();
			while(rs.next())
			{	
				Hashtable hash = new Hashtable();
				for(int i=1;i<=cols;i++)
				{
					String field = ds.toString(rsmd.getColumnName(i));
					String value = ds.toString(rs.getString(i));
					hash.put(field,value);
				}
				vect.add(hash);
			}
		}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}		
		}
		return vect;	
	}

	//查找一條記錄統(tǒng)一函數(shù)
	private Hashtable searchOneData(String sql) 
	{
		Hashtable hash = new Hashtable();
		ResultSet rs = selectRecord(sql);

		Statement stmt = null;
		try{
			//取得列數(shù)和列名
			ResultSetMetaData rsmd = rs.getMetaData();
			int cols = rsmd.getColumnCount();
			if(rs.next())
			{	
				for(int i=1;i<=cols;i++)
				{
					String field = ds.toString(rsmd.getColumnName(i));
					String value = ds.toString(rs.getString(i));
					hash.put(field,value);
				}
			}
		}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}		
		}
		return hash;
	}	
}