package?appComp_WF_ManuBefore.bizlet;
import?java.sql.Connection;
import?java.sql.ResultSet;
import?java.sql.Statement;

import?org.w3c.dom.*;

import?com.primeton.tp.common.xml.xmlUtil;
import?com.primeton.tp.core.api.BizContext;
/**
?*?@author?wenj
?*?@version?1.0
?*?@date?2009-12-28
?*?@class_displayName?baseOperation
?*/

public?class?baseOperation?{

	/**
	?*?判斷輸入的零件條碼是否存在
	?*?@param?doc?type:?Document?DOM;
	?*?@param?param?type:?BizContext;
	?*?@return:?int?運算邏輯返回值，如果不存在返回0，存在返回1?
	?*?@throws?Exception?
	?*?

	?*?**?bizlet?的顯示名稱?**
	?*?@bizlet_displayName?BL_existsBarcode
	?*?@bizlet_param?passing=“in_out“?type=“field“?value=“/“?name=““?desc=“待檢查的零件條碼“
	?*?@bizlet_param?passing=“in_out“?type=“field“?value=“/“?name=““?desc=“派工單ID“
	?*/
	public?static?int?BL_existsBarcode（Document?doc?BizContext?param）
		throws?Exception?{
		Node?param0?=?（Node）?param.getParaobjectAt（0）;
		Node?param1?=?（Node）?param.getParaobjectAt（1）;
		int?returnCode?=?0;
		
		Connection?conn?=?param.getDBBroker（）.getConnection（）;
		Statement?st?=?null;
		ResultSet?rs?=?null;
		
		String?barCode?=?xmlUtil.getNodeValue（param0）;
		String?dispatchID?=?xmlUtil.getNodeValue（param1）;
		try{
			String?queryStr?=?“select?*?from?PART_CARD_BARCODE?where?PART_CARD_BARCODE.PART_BAR_CODE=‘“+barCode+“‘?and?PART_CARD_BARCODE.Process_Card_Id?in“
								+“（select?process_card_procedure.process_card_id?from?process_card_procedure?where?process_card_procedure.process_card_procedure_id?in“
								+“（select?dispatch_bill.process_card_procedure_id?from?dispatch_bill?where?dispatch_bill.dispatch_bill_id=“+dispatchID+“））“;
			st?=?conn.createStatement（）;
			rs?=?st.executeQuery（queryStr）;

			while（rs.next（））{
				returnCode?=?1;
			}
		}catch（Exception?e）{
			throw?e;
		}finally{
			rs.close（）;
			st.close（）;
		}
		
		return?returnCode;
	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????2585??2011-11-07?22:41??MES11\.classpath

?????文件????????121??2010-09-16?09:18??MES11\.eos

?????文件????????569??2010-09-16?09:18??MES11\.project

?????文件????????138??2010-12-23?10:35??MES11\addGx\.eos

?????文件??????16531??2011-05-30?19:31??MES11\addGx\biztishi1.bzg

?????文件????????190??2010-12-23?10:35??MES11\addGx\biz\.eos

?????文件??????54613??2011-02-04?14:32??MES11\addGx\biz\bizdaoru.bzg

?????文件?????174168??2011-06-09?08:47??MES11\addGx\biz\bizGetDataBySk.bzg

?????文件??????20893??2011-10-28?15:53??MES11\addGx\biz\bizPROCESS_CARDQuery.bzg

?????文件??????16531??2011-05-30?19:31??MES11\addGx\biz\biztishi1.bzg

?????文件????????186??2010-12-23?10:35??MES11\addGx\bizlet\.eos

?????文件????????178??2010-12-23?10:35??MES11\addGx\data\.eos

?????文件????????184??2010-12-23?10:35??MES11\addGx\page\.eos

?????文件???????7184??2011-06-13?10:56??MES11\addGx\page\pgDPlanQueResult.jsp

?????文件??????24311??2010-12-01?13:29??MES11\addGx\page\pgTaskEdit.jsp

?????文件???????4891??2011-10-28?15:52??MES11\addGx\page\PROCESS_CARDQueryInput.jsp

?????文件???????7496??2011-10-28?15:53??MES11\addGx\page\PROCESS_CARDQueryResult.jsp

?????文件????????189??2010-12-23?10:35??MES11\addGx\pr\.eos

?????文件??????16058??2010-12-23?11:07??MES11\addGx\pr\prPROCESS_CARDQuery.prg

?????文件????????182??2010-12-23?10:35??MES11\addGx\report\.eos

?????文件????????189??2010-12-23?10:35??MES11\addGx\wf\.eos

?????文件????????365??2010-09-16?09:18??MES11\appComp_batchPlanMgr\.eos

?????文件????????190??2010-09-16?09:18??MES11\appComp_batchPlanMgr\biz\.eos

?????文件??????40899??2010-09-16?09:18??MES11\appComp_batchPlanMgr\biz\bizBatchPlanQue.bzg

?????文件??????30623??2010-09-16?09:18??MES11\appComp_batchPlanMgr\biz\bizGetOrg.bzg

?????文件??????26019??2010-09-16?09:18??MES11\appComp_batchPlanMgr\biz\bizGetOrgName.bzg

?????文件??????18098??2010-09-16?09:18??MES11\appComp_batchPlanMgr\biz\bizQueryTechList.bzg

?????文件??????27947??2010-09-16?09:18??MES11\appComp_batchPlanMgr\biz\bizTechQuery.bzg

?????文件????????184??2010-09-16?09:18??MES11\appComp_batchPlanMgr\page\.eos

?????文件???????7291??2010-09-16?09:18??MES11\appComp_batchPlanMgr\page\pgBatchPlanQue.jsp

............此處省略8515個文件信息