assetservice.java

固定资产管理系统包括一个基本的部分

package com.shenlong.assetmanage.service;

import java.sql.SQLException;
import java.util.List;

import com.shenlong.assetmanage.dao.AssetDao;
import com.shenlong.assetmanage.daoImplSQLserver.AssetDaoImpl;
import com.shenlong.assetmanage.domain.Asset;

public class AssetService {

	private AssetDao assetdao=new AssetDaoImpl();
	public Asset queryAssetById(int id) throws SQLException{
		return assetdao.queryAssetById(id);
	}
	
	
	public int saveNewAsset (Asset asset) throws SQLException{
		return assetdao.saveNewAsset(asset);
	}
	
	
	public List<Asset> queryAssetByName(String name) throws SQLException{
		return assetdao.queryAssetByName(name);
	}
	
	
	public List<Asset> queryAssetByName(String name, int page, int total) throws SQLException{
		return assetdao.queryAssetByName(name, page, total);
	}
	
	
	public int getAssetCountByName(String name) throws SQLException{
		return assetdao.getAssetCountByName(name);
	}
	
	
	
	public List<Asset> queryAssetByClass(int class2Id, int page, int total) throws SQLException{
		return assetdao.queryAssetByClass(class2Id, page, total);
	}
	
	
	public int getAssetCountByClass(int class2Id) throws SQLException{
		return assetdao.getAssetCountByClass(class2Id);
	}
	
	
	public int getAssetCountByEmpName(String empName) throws SQLException{
		return assetdao.getAssetCountByEmpName(empName);
	}
	
	
	public List<Asset> queryAssetByEmpName(String empName, int page, int total) throws SQLException{
		return assetdao.queryAssetByEmpName(empName, page, total);
	}
	
	
	public int modifyAsset(Asset asset) throws SQLException{
		return assetdao.modifyAsset(asset);
	}
	
	
	public int deleteAssetById(int id) throws SQLException{
		return assetdao.deleteAssetById(id);
	}
	
	
	public int updateEmpId(int assetId, int empId) throws SQLException{
		return assetdao.updateEmpId(assetId, empId);
	}
}