querydao.java

一套完整的工商12315的源程序jsp部分在12315里,后台JAVA部分在gs12315src里,没有打包数据库.

package com.gs.pageBuilder.dao;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */
import java.util.*;
import java.util.ArrayList;
import com.gs.util.*;
import com.gs.pageBuilder.*;
import com.gs.pageBuilder.model.*;

public interface QueryDAO{

	/**
	 * 修改个体注册号
	 * 应用:
	 * 返回 int 0:代表成功，1：代表重复
	 */

	public int saveUnitRegister(String SN,String BID,String DJJG,String regid,String oldregid) throws AppException;
	/**
		* 获得
		* 应用:
		* 返回  ArryList
		*/

 public ArrayList getBackRecordFieldList(String innerID,String BID,String DJJG,String GXDW,String page_code,String yearCheckupY) throws AppException;



	/**
	 * 获得未年检企业mail List
	 * 应用:年检查询
	 */
	public ArrayList getUnPassYearcheckupPrintList(String tempSql,ArrayList querySelectPrintItem) throws AppException;


	/**
	 * 获得查询结果打印
	 * 应用: 未通过,正在受理中打印
	 */
	public ArrayList getUnPassYearCheckupPrintList(String tempSql,ArrayList querySelectPrintItem) throws AppException;

	/**
	 * 获得查询结果打印
	 * 应用: 超级查询 查询 IN_YEARVALI
	 */
	public ArrayList getSuperYearCheckupPrintList(String tempSql,ArrayList querySelectPrintItem) throws AppException;

	/**
	 * 获得企业信息
	 * 应用:
	 */
	public QuerytBusinessInfoModel getBusinessInfo(String innerID,String BID,String yearCheckupY) throws AppException;

	/**
	 * 获得查询结果
	 * 应用: 超级查询 查询basisc02
	 */

	public ArrayList getSuperQuery(String tempSql,int nowPageNum,int listNum) throws AppException;

    public ArrayList getSuperBiaodashiQuery(String tempSql,int nowPageNum,int listNum,String basisorsub) throws AppException;//add by yuxiaogang

    public String getSuperBiaodashiQueryCount(String tempSql,String basisorsub) throws AppException;//add by yuxiaogang

    public ArrayList getSuperBiaodashiPrintList(String tempSql,ArrayList querySelectPrintItem,String basisorsub) throws AppException;


	/**
	 * 获得查询结果
	 * 应用: 年检查询 查询basisc02 bid=07
	 */
	public ArrayList getYearCheckupQuery(String tempSql,int nowPageNum,int listNum) throws AppException;

	/**
	 * 获得查询结果（模糊查询，年检结果）
	 * 应用: IN_YEARVALI
	 * 返回  SN BID
	 */

	public ArrayList getYearCheckupShow(String BID,String innerID,String DJJG,String GXDW,String yearCheckupY) throws AppException;

	/**
	 * 获得查询结果记录集合总数
	 * 应用: 超级查询 查询basisc02
	 */
	public String getSuperQueryCount(String tempSql) throws AppException;

	/**
	 * 获得查询结果记录集合总数
	 * 应用: 年检查询 查询basisc02
	 */
	public String getYearCheckupCount(String tempSql) throws AppException;

	/**
	 * 获得查询结果
	 * 应用: 超级查询 查询basisc02
	 */
	public ArrayList getSuperPrintList(String tempSql,ArrayList querySelectPrintItem) throws AppException;

	/**
	 * 获得查询结果
	 * 应用: 未年检企业(未通过) 查询basisc02
	 */
	public ArrayList getUnPassYearCheckup(String tempSql,int nowPageNum,int listNum) throws AppException;

	/**
	 * 获得查询结果计算总数
	 * 应用: 未年检企业(未通过) 查询basisc02
	 */
	public String getUnPassYearCheckupCount(String tempSql) throws AppException;

	/**
	 * 获取查询页面的页面信息
	 * 返回  QueryPageDefine
	 */
	public QueryPageDefine getQueryPageDefine(String code) throws AppException;

	/**
	 * 获得查询页面的字段信息
	 * 应用:
	 * 返回  QueryPageDefine
	 */
	public ArrayList getQueryFieldList(String innerID,String BID,String DJJG,String GXDW,String page_code,String yearCheckupY,String SN) throws AppException;

	/**
	 * 获得查询页面的字段信息
	 * 应用:
	 * 返回  ArrayList
	 */
	public ArrayList getqueryPageList(String BID,String DJJG,String GXDW) throws AppException;

	/**
	 * 获得查询页面的字段信息
	 * 应用:
	 * 返回  ArrayList
	 */

	public ArrayList getqueryPageList(String BID,String DJJG,String GXDW,String page_type,String category1,String category2,String category3) throws
		AppException;

	/**
	 * 添加定义页面
	 * 应用:添加定义页面
	 */
	public String addQueryPageDefine(QueryPageDefine queryPageDefine) throws AppException;

	/**
	 * 删除定义页面
	 * 应用:删除定义页面
	 */
	public boolean dellQueryPageDefine(String page_code) throws AppException;

	/**
	 *获得备案修改 变更信息修改 修改页面的可修改信息
	 * @param	SN,BID,DJJG,GXDW,page_code,innerID
	 * @return   ArrayList 元素类型为QueryPageChangeFieldDefine
	 * @author  glt
	 * @exception AppException
	 */
	public ArrayList getQueryChangeFieldList(String SN,String BID,String DJJG,String GXDW,String page_code,String innerID) throws AppException;

	/**
	 *Get the max SN of in_sub_insdel.
	 * @param	innerID
	 * @return   MSN
	 * @author  glt
	 * @exception AppException
	 */
	public String getChangeMaxSN(String innerID) throws AppException;


	/**
	 * 获得变更查询结果
	 * 应用: get change_item,in_change
	 */
	public ArrayList getChangeList(String orderID,String BID) throws AppException;

	/**
	 * 获得子表字段植
	 * add by yuxiaogang 20040413 13:50
	 */

	 public ArrayList getQuerySubTableFieldList(String SN,String subtablename) throws AppException;

	 public HashMap getEnterpriseOpenInfo(String SN) throws AppException;
	 public String getModifyNameSqlSN(String innerID) throws AppException;
     /**
      * 得到年检综合情况查询企业结果
      * @param tempSql
      * @param nowPageNum
      * @param listNum
      * @param checkYear
      * @return ArrayList
      * @throws AppException
      * @author glt 2004-06-23
      */
     public ArrayList getSuperQueryCheckUp(String tempSql,int nowPageNum,int listNum,String checkYear) throws AppException;
     /**
      * 得到年检综合情况查询企业结果总记录数
      * @param tempSql
      * @param checkYear
      * @return String
      * @throws AppException
      * @author glt 2004-06-23
      */
     public String getSuperQueryCountCheckUp(String tempSql,String checkYear) throws AppException;
     /**
      * 获得年检综合查询打印结果
      * @param tempSql
      * @param querySelectPrintItem
      * @param yearCheckupYear
      * @return ArrayList
      * @throws AppException
      * @author glt 2004-06-24
      */
     public ArrayList getSuperPrintListCheckUp(String tempSql,ArrayList querySelectPrintItem,String yearCheckupYear) throws AppException;

}