package com.shlanbao.tzsc.pms.sch.workorder.service.impl;

import java.util.List;

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

import com.shlanbao.tzsc.base.dao.SchWorkorderCraftDaoI;
import com.shlanbao.tzsc.base.mapping.SchWorkorderCraft;
import com.shlanbao.tzsc.base.model.DataGrid;
import com.shlanbao.tzsc.base.service.BaseService;
import com.shlanbao.tzsc.pms.sch.workorder.beans.CraftBean;
import com.shlanbao.tzsc.pms.sch.workorder.service.CraftServiceI;
import com.shlanbao.tzsc.utils.tools.BeanConvertor;
import com.shlanbao.tzsc.utils.tools.DateUtil;
import com.shlanbao.tzsc.utils.tools.StringUtil;
@Service
public class CraftServiceImpl extends BaseService implements CraftServiceI{
	@Autowired
	private SchWorkorderCraftDaoI schWorkorderCraftDao;

	@Override
	public DataGrid queryCraftByWorkOrder(String workOrderId) {
		/*try {
			//String hql = "select o.id,o.parameterCode,o.parameterName,o.pcp,o.qc,o.pval,o.zval,o.cpk,o.cp,o.pp,o.ppk,o.ppm,o.std,o.uval,o.lval, o.cuval,o.clval,o.wuval,o.wlval,o.dtm,o.dtmuval,o.dtmlval,o.paramType from SchWorkorderCraft o ,SchWorkorder b where  o.parameterSetRevision=b.parameterSetRevision and b.id=?";
			String sql="SELECT o.* FROM SCH_WORKORDER_CRAFT o, SCH_WORKORDER b WHERE o.PARAMETER_SETREVISION = b.parameter_Set_Revision and b.id='"+workOrderId+"' ";
			return new DataGrid(BeanConvertor.copyList(schWorkorderCraftDao.queryBySql(sql),CraftBean.class), 0L);
		} catch (Exception e) {
			log.error("查询工单ID:["+workOrderId+"]的工艺参数异常", e);
		}
		return null;*/
		try {
			String hql = "from SchWorkorderCraft o where o.parameterSetRevision in (select  a.parameterSetRevision from SchWorkorder a where a.id=?)";
			return new DataGrid(BeanConvertor.copyList(schWorkorderCraftDao.query(hql, workOrderId),CraftBean.class), 0L);
		} catch (Exception e) {
			log.error("查询工单ID:["+workOrderId+"]的工艺参数异常", e);
		}
		return null;
	}
	
	/*@Override
	public DataGrid queryCraftByWorkOrder(String workOrderId) {
		try {
			String hql = "from SchWorkorderCraft o where o.materialCode=(select  a.mdMat from SchWorkorder a where a.id=?)";
			return new DataGrid(BeanConvertor.copyList(schWorkorderCraftDao.query(hql, workOrderId),CraftBean.class), 0L);
		} catch (Exception e) {
			log.error("查询工单ID:["+workOrderId+"]的工艺参数异常", e);
		}
		return null;
	}*/

	@Override
	public void saveCraft(SchWorkorderCraft craft) {
		schWorkorderCraftDao.save(craft);
	}

	@Override
	public SchWorkorderCraft queryByMatAndCode(String matCode, String paramCode) {
		String sql="SELECT id from SCH_WORKORDER_CRAFT where MATERIAL_CODE='"+matCode+"' and PARAMETER_CODE='"+paramCode+"'";
		List<?> ls=schWorkorderCraftDao.queryBySql(sql);
		if(ls!=null && ls.size()>0){
			return new SchWorkorderCraft(StringUtil.convertObjToString(ls.get(0)));
		}
		return null;
	}

	@Override
	public void saveOrUpdateCraft(SchWorkorderCraft craft) {
		//保存
		//schWorkorderCraftDao.saveOrUpdate(craft);
		schWorkorderCraftDao.save(craft);
	}

	
	@Override
	public void deleteByCraft(String parameterSetRevision, String materialCode) {
		try {
			schWorkorderCraftDao.updateBySql("delete SCH_WORKORDER_CRAFT where effect_remark='"+parameterSetRevision+materialCode+"'", null);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	
	
	
}