supplierbusiness.java

企业进销存源码

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

import com.business.vo.Supplier;
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 SupplierBusiness {
	public String getNameById(String id) throws Exception {
		try {
			String str = "select name from supplier where id = " + id;
			DaoImp dao = new DaoImp();
			return WebTools.showEx(dao.find(str).get("NAME"));
		} catch (Exception e) {
			return "";
		}
	}

	public void add(Supplier vo) throws Exception {
		try {
			String str =
				"insert into Supplier(name,address,tel,zh,type) values('"
					+ vo.getName()
					+ "','"				
					+ vo.getAddress()
					+ "','"
					+ vo.getTel()
					+ "','"
					+ vo.getZh()
					+ "','"
					+ vo.getType()
					+ "')";
			DaoImp dao = new DaoImp();
			dao.insert(str);
		} catch (Exception e) {
			throw e;
		}
	}
	public void edit(Supplier vo) throws Exception {
		try {
			String str =
				"update supplier set name = '"
					+ vo.getName()					
					+ "',address = '"
					+ vo.getAddress()
					+ "',tel = '"
					+ vo.getTel()					
					+ "',zh = '"
					+ vo.getZh()
					+ "',type = '"
					+ vo.getType()
					+ "' where Id = "
					+ vo.getId();
			DaoImp dao = new DaoImp();
			dao.insert(str);
		} catch (Exception e) {
			throw e;
		}
	}
	public void remove(Supplier vo) throws Exception {
		try {
			String str = "delete from Supplier 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 Supplier where Id = " + key + "";
			DaoImp dao = new DaoImp();
			return dao.find(str);
		} catch (Exception e) {
			return null;
		}
	}
	public List select()throws Exception {
		try {
			String str = "select TOP 9 * from Supplier order by id desc";
			DaoImp dao = new DaoImp();
			return dao.select(str);
		} catch (Exception e) {
			return null;
		}
	}
}