package?kaga.Dao.Impl;

import?java.sql.ResultSet;
import?java.text.DecimalFormat;
import?java.util.ArrayList;
import?java.util.List;
import?java.util.Map;

import?javax.servlet.http.HttpServletRequest;

import?org.apache.struts2.ServletActionContext;

import?com.opensymphony.xwork2.ActionContext;

import?kaga.it.Tools.JDBCUtil;
import?kaga.it.Model.PickShortage;
import?kaga.it.Model.InventoryReport;
import?kaga.it.Model.inboundHistory;
import?kaga.it.Model.inventory_summary;
import?kaga.it.Model.pickSummary;
import?kaga.it.Model.item;
import?kaga.it.Model.PickShortageByPO;
import?kaga.it.Model.InboundDetail;

public?class?WMSExcelExportDao?{
	/*
	?*?@ClassName:?WMS各功能導出
	?*?
	?*?@Description:dfdfd
	?*?
	?*?@author?Fish_Wang@kaga.com.cn
	?*?
	?*?@date?2012-11-21?下午04:19:27
	?*/
	private?java.sql.Connection?conn?=?null;
	private?java.sql.PreparedStatement?pstmt?=?null;
	private?ResultSet?rs?=?null;

	//?PickShortageByPO?List

	public?List?PickShortageByPO（String?keyword）?{

		System.out.println（“PickShortageByPO“）;

		List?list?=?new?ArrayList（）;
		try?{
			conn?=?JDBCUtil.getConn（）;
			pstmt?=?conn.prepareStatement（“select?*?from??kg_inbounditem“）;
			rs?=?pstmt.executeQuery（）;

			while?（rs.next（））?{

				PickShortageByPO?p?=?new?PickShortageByPO（）;

				p.setCODE（rs.getString（“ref_no“））;

				p.setDEscriptION（rs.getString（“part_desc1“））;

				p.setQTY（rs.getString（“qty_order“））;

				p.setHKGSTOCK（rs.getString（“ref_no“））;

				p.setSHORTAGE（rs.getString（“ref_no“））;

				p.setOVERAGE（rs.getString（“ref_no“））;

				p.setPONO（rs.getString（“pono_china“））;

				p.setKAGAJPPONO（rs.getString（“pono_kaga“））;

				p.setLOTNO（rs.getString（“lot_no“））;

				p.setLOTNOSEQ（rs.getString（“ref_no“））;

				list.add（p）;

			}
			JDBCUtil.free（rs?pstmt?conn）;
			//?write（list）;
		}?catch?（Exception?ce）?{
			System.out.println（“獲取記錄集失敗“）;
			ce.printStackTrace（）;
		}
		return?list;
	}

	//?PickShortage?Data?List

	public?List?PickShortage（String?keyword）?{
		
		ActionContext?actionContext?=?ActionContext.getContext（）;
		Map?session?=?actionContext.getSession（）;


		List?list?=?new?ArrayList（）;
		try?{
			conn?=?JDBCUtil.getConn（）;

			String?CurrentSQL?=?“select?sum（ROUND（OUB.dime_l*OUB.dime_w*OUB.dime_h/10000003））?as?CBMifnull（OUB.price_orig?0.00000）?as?price_origifnull（OUB.curr?‘‘）?as?currOUB.ctn_nwOUB.ctn_gwOUB.rmksOUB.partsnOUB.pallet_noOUB.ref_noOUB.outbound_idOUB.partno_cnOUB.partno_kagaOUB.part_desc1OUB.part_desc2OUB.part_desc3OUB.supplierOUB.cartonOUB.locationOUB.pick_idOUB.qty_packOUB.qty_pickOUB.mpqstatusOUB.rmksOUB.createdonOUB.createdbyOUB.partsnOUB.inbound_idOUB.ctn_gwOUB.dime_lOUB.dime_wOUB.dime_h?from?kg_outbounditem?as?OUB?where?OUB.ref_no=‘“
					+?keyword
					+?“‘?GROUP?BY??OUB.price_origOUB.currOUB.ctn_nwOUB.ctn_gwOUB.rmksOUB.partsnOUB.pallet_noOUB.ref_noOUB.outbound_idOUB.partno_cnOUB.partno_kagaOUB.part_d

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

?????文件????????511??2013-01-02?09:01??kgwms\.classpath

?????文件???????1002??2014-02-25?14:49??kgwms\.project

?????文件????????443??2012-09-13?15:05??kgwms\.settings\.jsdtscope

?????文件????????167??2012-12-22?09:57??kgwms\.settings\org.eclipse.core.resources.prefs

?????文件????????587??2013-01-02?09:01??kgwms\.settings\org.eclipse.jdt.core.prefs

?????文件??????10039??2012-09-17?16:13??kgwms\.settings\org.eclipse.jdt.ui.prefs

?????文件????????436??2014-02-25?14:49??kgwms\.settings\org.eclipse.wst.common.component

?????文件????????222??2012-09-13?15:05??kgwms\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2012-09-13?15:05??kgwms\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2012-09-13?15:05??kgwms\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件??????????2??2014-02-25?14:50??kgwms\.svn\entries

?????文件??????????2??2014-02-25?14:50??kgwms\.svn\format

?????文件????????288??2014-02-25?14:50??kgwms\.svn\pristine\01\01cc6b78e58da0020f537a711ac2dfd99bac8034.svn-base

?????文件??????28209??2014-02-25?14:50??kgwms\.svn\pristine\02\02484bf8557518a48bbb6412fc6bbc554aa3eb79.svn-base

?????文件?????367444??2014-02-25?14:50??kgwms\.svn\pristine\03\03b254c872b95141751f414e353a25c2ac261b51.svn-base

?????文件??????22759??2014-02-25?14:50??kgwms\.svn\pristine\05\055ddeef6668e93d5874144b7a1dfbafa94a0149.svn-base

?????文件???????1070??2014-02-25?14:50??kgwms\.svn\pristine\0b\0b4bd4d35a3166c5f1bfb137932f555cf9b0850c.svn-base

?????文件???????2770??2014-02-25?14:50??kgwms\.svn\pristine\0c\0c18a0785dfdd59558ffc00e986426a586adbd29.svn-base

?????文件?????168081??2014-02-25?14:50??kgwms\.svn\pristine\0c\0c3f31f4a65461c44e6697bf29070e638bef09d8.svn-base

?????文件???????2082??2014-02-25?14:50??kgwms\.svn\pristine\0d\0d39b328f2892c81fd0b97be709aa9b4a48fa43b.svn-base

?????文件?????725247??2014-02-25?14:50??kgwms\.svn\pristine\12\127948c04822fd5192828a9f4669472f410c3270.svn-base

?????文件??????10039??2014-02-25?14:50??kgwms\.svn\pristine\14\145776bc8dbc717bb0f874220869802f8a2a6ed6.svn-base

?????文件???????3446??2014-02-25?14:50??kgwms\.svn\pristine\15\1561c50b1b4808d29e62e03969454cbc0b2b4159.svn-base

?????文件???????2197??2014-02-25?14:50??kgwms\.svn\pristine\17\1719b2e966cf3e70c443d0518e34defacd48d7c1.svn-base

?????文件???????1868??2014-02-25?14:50??kgwms\.svn\pristine\1a\1a5834b7d78f2aff11abe174ab8e6581b41f7cf3.svn-base

?????文件????????167??2014-02-25?14:50??kgwms\.svn\pristine\1b\1b6346021d32412920ad1769c20964a0821a5a43.svn-base

?????文件???????6028??2014-02-25?14:50??kgwms\.svn\pristine\1c\1c575525c8f8fe8375e2d2fc8d9db3928101739d.svn-base

?????文件???????8645??2014-02-25?14:50??kgwms\.svn\pristine\20\2000c373052000fde8ee86d3c59d8e3523527a96.svn-base

?????文件???????8535??2014-02-25?14:50??kgwms\.svn\pristine\20\20b7958d4216fe24f631c3180c8e9eba2a32f99c.svn-base

?????文件???????3137??2014-02-25?14:50??kgwms\.svn\pristine\20\20bc83229d00fb84039fc128955f917fa1f68c12.svn-base

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