package com.ld.igds.m.service;

import java.util.Date;
import java.util.HashMap;
import java.util.Map;
import org.apache.commons.lang3.StringUtils;
import org.hibernate.Session;
import org.springframework.stereotype.Repository;
import com.bstek.bdf2.core.orm.hibernate.HibernateDao;
import com.bstek.dorado.data.provider.Page;
import com.ld.igds.models.InoutDriver;
import com.ld.igds.util.ContextUtil;

@Repository
public class HInoutDriverService extends HibernateDao {

	public void pageQuery(Page<InoutDriver> page, Map<String, Object> param)
			throws Exception {

		String hql = " from " + InoutDriver.class.getName()
				+ " where companyId=:companyId";

		Map<String, Object> args = new HashMap<String, Object>();
		args.put("companyId", ContextUtil.getCompanyId());

		if (null != param) {
			String str = (String) param.get("id");
			if (StringUtils.isNotEmpty(str)) {
				hql += " and id=:id";
				args.put("id", str);
			}

			str = (String) param.get("name");
			if (StringUtils.isNotEmpty(str)) {
				hql += " and name like:name";
				args.put("name", "%" + str + "%");
			}
		}

		String countHql = " select count(*) " + hql;

		hql += " order by id";

		this.pagingQuery(page, hql, countHql, args);
	}

	public String saveOrUpdataData(InoutDriver data) {
		Session session = this.getSessionFactory().openSession();
		try {
			if (StringUtils.isEmpty(data.getCompanyId())) {
				data.setCompanyId(ContextUtil.getCompanyId());
				data.setUpdateTime(new Date());
				session.save(data);
			} else {
				session.update(data);
			}
		} finally {
			session.flush();
			session.close();
		}
		return null;
	}

	public String delData(InoutDriver data) {
		Session session = this.getSessionFactory().openSession();
		try {
			session.delete(data);
		} finally {
			session.flush();
			session.close();
		}
		return null;
	}

}