package com.shlanbao.tzsc.base.dao.impl;
|
|
|
import java.util.List;
|
|
import org.springframework.stereotype.Repository;
|
|
import com.shlanbao.tzsc.base.dao.CosIncompleteStandardDaoI;
|
import com.shlanbao.tzsc.base.mapping.CosIncompleteStandard;
|
import com.shlanbao.tzsc.utils.tools.StringUtil;
|
/**
|
*
|
* @ClassName: CosIncompleteStandardDaoImpl
|
* @Description: 机台对应班次储烟量维护 Dao实现层
|
* @author luoliang
|
* @date 2015-1-4 上午08:42:30
|
*
|
*/
|
@Repository
|
public class CosIncompleteStandardDaoImpl extends BaseDaoImpl<CosIncompleteStandard> implements CosIncompleteStandardDaoI {
|
|
@Override
|
public double queryBeanByShiftAndEqpType(String shiftId,String equipmentId){
|
StringBuffer hql=new StringBuffer();
|
hql.append("from CosIncompleteStandard o inner join fetch o.mdEqupType mdtype inner join fetch mdtype.mdEquipments equip where 1=1 ");
|
if(StringUtil.notNull(shiftId)){
|
hql.append("and o.mdShift.id='"+shiftId+"' ");
|
}
|
if(StringUtil.notNull(equipmentId)){
|
hql.append("and equip.id='"+equipmentId+"' ");
|
}
|
List<CosIncompleteStandard> list=this.query(hql.toString());
|
if(list.size()>0){
|
return list.get(0).getStorage_smoke();
|
}
|
return 0.0;
|
}
|
|
|
}
|
