assetturnoverdetaildao.java

固定资产管理系统 资产的增删改查 借出 管理 自动报废 统计功能等等

package com.qrsx.asset.dao;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import com.qrsx.asset.model.Asset;
import com.qrsx.asset.model.AssetTurnoverDetail;
import com.qrsx.asset.model.Page;
import com.qrsx.asset.model.Storage;

/**
 * 
 * Author  : 马利永<br>
 * Company : qrsx<br>
 * Version : 1.0<br>
 * Date    : apr 14, 2009<br>
 */
public class AssetTurnoverDetailDAO extends BaseDAO{
	/**
	 * 创建台帐信息
	 */
	public void create(AssetTurnoverDetail assetTurnoverDetail) throws Exception {
		String sql = "insert into assetturnoverdetail(assetId, dependDate, " +
				" givebackPlanDate, employeeId, borrowMan ,borrowCompany, state) values(?,?,?,?,?,?,?)";

		ps = conn.prepareStatement(sql);
		processStatement1(assetTurnoverDetail, ps, sql);

		ps.executeUpdate();
	}

	/**
	 * 删除台帐信息
	 */
	public void delete(Integer id) throws Exception {
		String sql = "delete from assetturnoverdetail where id = ?";

		ps = conn.prepareStatement(sql);
		ps.setInt(1, id);

		ps.executeUpdate();
	}

	/**
	 * 更新台帐信息
	 */
	public void update(AssetTurnoverDetail assetTurnoverDetail) throws Exception {
		String sql = "update assetturnoverdetail set dependDate=?, givebackPlanDate=?, " +
				" employeeId=?, borrowMan=?, borrowCompany=? , state =? where id=?  ";

		ps = conn.prepareStatement(sql);
		processStatement1(assetTurnoverDetail, ps, sql);

		ps.executeUpdate();
	}

	/**
	 * 根据ID检索台帐信息
	 */
	public AssetTurnoverDetail findById(Integer id,String state) throws Exception {
		String sql = "select * from assetturnoverdetail where assetId = ? AND state = ? ";

		ps = conn.prepareStatement(sql);
		ps.setInt(1, id);
		ps.setString(2, state);
		ResultSet rs = ps.executeQuery();
        
		AssetTurnoverDetail assetTurnoverDetail = new AssetTurnoverDetail();
		
		if (rs.next()) {
			processResultset(assetTurnoverDetail, rs);		
		}
		//组装级联的asset对象
		AssetDAO dao = new  AssetDAO();
		Asset  asset1=dao.findById(id);
		assetTurnoverDetail.setAsset(asset1);
		return assetTurnoverDetail;
	}

	/**
	 * 检索全部台帐信息
	 */
	public List<AssetTurnoverDetail> findAll() throws Exception {
		String sql = "select * from assetturnoverdetail ";

		ps = conn.prepareStatement(sql);
		ResultSet rs = ps.executeQuery();
		List<AssetTurnoverDetail> list = new ArrayList<AssetTurnoverDetail>();
		while (rs.next()) {
			AssetTurnoverDetail assetTurnoverDetail = new AssetTurnoverDetail();
			processResultset(assetTurnoverDetail, rs);
			list.add(assetTurnoverDetail);
		}
		return list;

	}

	/**
	 * 动态检索台帐信息
	 */
	public Object[] list(AssetTurnoverDetail assetTurnoverDetail, Integer currentpage) throws Exception {
		String sql = "select * from assetturnoverdetail where 1=1 ";
		String s=assetTurnoverDetail.getState();
		if (s!=null&&s.trim().length()>0) {
			sql = sql + " and state = "+assetTurnoverDetail.getState()+"  ";
		}
		ps = conn.prepareStatement(sql);
		ResultSet rs = ps.executeQuery();
		
		Page page = new Page();
		pageIndex(page,rs,currentpage);      
		List<AssetTurnoverDetail> list = new ArrayList<AssetTurnoverDetail>();	
		AssetDAO dao = new  AssetDAO();
		while (rs.next()&&list.size()<page.getSize()){
			AssetTurnoverDetail assetTurnoverDetail1 = new AssetTurnoverDetail();
			processResultset(assetTurnoverDetail1, rs);
			//组装级联的asset对象
			Asset asset1=new Asset();
			asset1=dao.findById(assetTurnoverDetail1.getAssetId());
			assetTurnoverDetail1.setAsset(asset1);
			list.add(assetTurnoverDetail1);		
		}	
		Object[] object = {list,page};
		return object;
	}
	
}