stockoutmanager.java

基于J2EE的网络物流系统 用户操作： 1． 录入出库商品信息 2． 查询出库单信息 3． 录入入库商品信息 4． 查询入库单信息 5． 查询商品位置信息 6． 查询商品信息 7． 查

package com.logistic.business;

import com.logistic.data.DataConnect;
import java.sql.ResultSet;
import java.sql.Statement;
import com.logistic.dao.IStockOutDAO;
import java.util.Vector;
import com.logistic.model.StockOutInfo;
import com.logistic.business.PageAble;

public class StockOutManager implements IStockOutDAO{

	DataConnect dc=new DataConnect();
	Statement   stat=null;
	ResultSet   rs=null;
	
	public int AddStockOut(String stockoutid,String stockoutdate,String chargeid,String goodsid,int goodsoutnum,String goodsreceiveid,String typeid,String commodityid,String stockoutmemo){
		
		int flag=-10;
		try{	
			String outid=stockoutid;
			String outdate=stockoutdate;
			String chid=chargeid;
			String gid=goodsid;
			int    outnum=goodsoutnum;
			String receivid=goodsreceiveid;
			String tid=typeid;
			String comid=commodityid;
			String outmemo=stockoutmemo;
			
			String sqls="insert into stockoutinfotable(StockOutId,StockOutDate,ChargeId,GoodsId,GoodsOutNumber,GoodsReceiveId,TypeId,CommodityId,GoodsOutMemo)values" +
					  "('"+outid+"','"+outdate+"','"+chid+"','"+gid+"','"+outnum+"','"+receivid+"','"+tid+"','"+comid+"','"+outmemo+"')";
			flag=0;
			
			flag=dc.updata(sqls);
			if(flag>0){
				System.out.print("入库单数据插入成功!");
			}else{
				
				 System.out.print("入库单数据插入失败!");
			    }
			}catch(Exception ex){
				flag=-1;
				
				ex.printStackTrace();
				
			}finally{dc.close();}
			
			return flag;
		}
		
	public Vector StockOutSearch(String strsql,int page){
		
		Vector items=new Vector();
		try{
			
			stat=dc.getStmtread();
			rs  =stat.executeQuery(strsql);
	    if(rs.next()){
			PageAble pgb=new PageAble(rs);
			pgb.setPagesize(5);
			pgb.setCurrentpage(1);
			pgb.gotoPage(page);
			rs.absolute(pgb.getRowscount());
			
			int i=0;
			do{
				
				items.add(new StockOutInfo(rs.getString("StockOutId"),rs.getString("StockOutDate"),rs.getString("ChargeId"),rs.getString("GoodsId"),rs.getInt("GoodsOutNumber"),rs.getString("GoodsReceiveId"),
						    rs.getString("TypeId"),rs.getString("CommodityId"),rs.getString("GoodsOutMemo")));
				
			   }while(rs.next()&&i<pgb.getCurrentPageRowsCount());
	     }else{
	    	 System.out.println("出库单数据为空！");
	     }
			
		}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
		
		return items;
		
	}

	public int DelStockOut(String stockoutid){
		
		String strsql="delete from stockoutinfotable where StockOutId="+stockoutid;
		
		int flag=0;
		try{
			
			flag=dc.updata(strsql);
			if(flag>0){
				System.out.print("编号为:"+stockoutid+"出库单信息删除成功");
			  }else{
				System.out.print("编号为:"+stockoutid+"出库单信息删除失败"); 
			  }
			
		}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
		
		return flag;
		
	}

	public int ModifyStockOut(String stockoutid,String stockoutdate,String chargeid,String goodsid,int goodsoutnum,String goodsreceiveid,String typeid,String commodityid,String stockoutmemo){
		
		int flag=-10;
		try{
			
			String soutid=stockoutid;
			String soutdate=stockoutdate;
			String cid=chargeid;
			String gid=goodsid;
			int    goutnum=goodsoutnum;
			String grid=goodsreceiveid;
			String tid=typeid;
			String commid=commodityid;
			String soutmemo=stockoutmemo;
			
			String strsql="update stockoutinfotable set StockOutDate='"+soutdate+"',ChargeId='"+cid+"',GoodsId='"+gid+"',GoodsOutNumber='"+goutnum+"',GoodsReceiveId='"+grid+"',TypeId='"+tid+"',CommodityId='"+commid+"',GoodsOutMemo='"+soutmemo+"' where StockInId="+soutid;
			flag=dc.updata(strsql);
			if(flag>0){
				System.out.println("编号="+soutid+"的出库单信息更新成功!");
			}else{
				System.out.println("编号="+soutid+"的出库单信息更新失败!");
			}
			
		}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
	return flag;	
	}

    public StockOutInfo StockOutSearchById(String stockoutid){
    	
    	String strsql="select * from stockoutinfotable where StockOutId="+stockoutid;
    	StockOutInfo soi=new StockOutInfo();
    	
    	try{
    		stat=dc.getStmtread();
    		rs  =stat.executeQuery(strsql);
    		while(rs.next()){   			
    			soi.setStockoutid(rs.getString("StockOutId"));
    			soi.setStockoutdate(rs.getString("StockOutDate"));
    			soi.setChargeid(rs.getString("ChargeId"));
    			soi.setGoodsid(rs.getString("GoodsId"));
    			soi.setGoodsoutnumber(rs.getInt("GoodsOutNumber"));
    			soi.setGoodsreceiveid(rs.getString("GoodsReceiveId"));
    			soi.setTypeid(rs.getString("TypeId"));
    			soi.setCommodityid(rs.getString("CommodityId"));
    			soi.setGoodsoutmemo(rs.getString("GoodsOutMemo"));
    		}
    		
    	}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
    return soi;	
    }
}