package com.hxzkoa.services;

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;

import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import com.hxzkoa.util.IsInStartAndEndTime;

@Service
public class CaozuoService {
	@PersistenceContext
	private EntityManager em;
	
	@Transactional
	public void tb_caozuo(String tablename,int state) {
		String sql = null;
		Query query = null;
		String addtime = IsInStartAndEndTime.DataTostr();
		sql = "UPDATE tb_caozuo SET state=:state,addtime=:addtime WHERE tablename=:tablename";
		query = this.em.createNativeQuery(sql);
		query.setParameter("state",state);
		query.setParameter("addtime",addtime);
		query.setParameter("tablename",tablename);
		query.executeUpdate();
	}
}