goodsinbusiness.java

企业进销存源码

package com.business;
import java.util.HashMap;

import com.business.vo.GoodsIn;
import com.dao.util.DaoImp;
import com.web.util.WebTools;
/**
 * @author Administrator
 *
 * To change this generated comment edit the template variable "typecomment":
 * Window>Preferences>Java>Templates.
 * To enable and disable the creation of type comments go to
 * Window>Preferences>Java>Code Generation.
 */
public class GoodsInBusiness {	
	public String getGoodsIdById(String id) throws Exception{
		try{
			String str = "select goodsId from GoodsIn where id = "+id;
			DaoImp dao = new DaoImp();
			return WebTools.showEx(dao.find(str).get("GOODSID"));
		}catch(Exception e){
			return "";
		}
	}
	public void add(GoodsIn vo) throws Exception{
		try{
			String str = "insert into GoodsIn(goodsId,inDate,inNum,supplierId,cfqy,bianhao) values('"+vo.getGoodsId()+"','"+vo.getInDate()+"','"+vo.getInNum()+"','"+vo.getSupplierId()+"','"+vo.getCfqy()+"','"+vo.getBianhao()+"')";
			DaoImp dao = new DaoImp();
			dao.insert(str);
		}catch(Exception e){
			throw e;
		}
	}
	public void edit(GoodsIn vo) throws Exception{
		try{
			String str = "update goodsIn set goodsId = '"+vo.getGoodsId()+"',inDate = '"+vo.getInDate()+"',inNum = '"+vo.getInNum()+"',supplierId = '"+vo.getSupplierId()+"' ,bianhao='"+vo.getBianhao()+"'where Id = "+vo.getId();
			DaoImp dao = new DaoImp();
			dao.insert(str);
		}catch(Exception e){
			throw e;
		}
	}
	public void remove(GoodsIn vo) throws Exception{
		try{
			String str = "delete from GoodsIn where Id = "+vo.getId();
			DaoImp dao = new DaoImp();
			dao.insert(str);
		}catch(Exception e){
			throw e;
		}
	} 
	
	public HashMap find(String key) throws Exception{
		try{
			String str = "select * from GoodsIn where Id = "+key+"";
			DaoImp dao = new DaoImp();
			return dao.find(str);
		}catch(Exception e){
			return null;
		}
	} 
}