package com.shlanbao.tzsc.pms.equ.param.service.impl;


import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.shlanbao.tzsc.base.dao.EqmParamDaoI;
import com.shlanbao.tzsc.base.mapping.EqmParam;
import com.shlanbao.tzsc.base.model.DataGrid;
import com.shlanbao.tzsc.base.model.PageParams;
import com.shlanbao.tzsc.pms.equ.param.service.EqmParamServiceI;
import com.shlanbao.tzsc.utils.tools.StringUtil;

@Service
public class EqmParamServiceImpl implements EqmParamServiceI {

	@Autowired
	public  EqmParamDaoI eqmParamDaoI;
	
	@Override
	public EqmParam queryBeanById(String id) {
		return eqmParamDaoI.findById(EqmParam.class, id);
	}

	/**
	 * 查询
	 */
	@Override
	public List<EqmParam> queryBeanListByBean(EqmParam bean) {
		String hql="from EqmParam o where 1=1 ";
		StringBuffer params=new StringBuffer();
		if(StringUtil.notNull(bean.getId())) params.append("and o.id='"+bean.getId()+"' ");
		if(StringUtil.notNull(bean.getCode())) params.append("and o.code='"+bean.getCode()+"' ");
		if(StringUtil.notNull(bean.getName())) params.append("and o.name='"+bean.getName()+"' ");
		return eqmParamDaoI.query(hql.concat(params.toString()));
	}

	/**
	 * 界面查询，返回DataGrid
	 */
	@Override
	public DataGrid queryBeanGridByBean(EqmParam bean,PageParams pageParams) {
		String hql="from EqmParam o where 1=1 ";
		StringBuffer params=new StringBuffer();
		if(StringUtil.notNull(bean.getId())) params.append("and o.id='"+bean.getId()+"' ");
		if(StringUtil.notNull(bean.getCode())) params.append("and o.code='"+bean.getCode()+"' ");
		if(StringUtil.notNull(bean.getName())) params.append("and o.name like '%"+bean.getName()+"%' ");
		List<EqmParam> lists=eqmParamDaoI.queryByPage(hql.concat(params.toString()), pageParams);
		hql = "select count(*) from EqmParam o where 1=1  ";
		long total = eqmParamDaoI.queryTotal(hql.concat(params.toString()));
		return new DataGrid(lists,total);
	}

	/**
	 * 添加或修改
	 */
	@Override
	public boolean addOrUpdateBean(EqmParam bean) {
		return eqmParamDaoI.saveOrUpdate(bean);
	}
}