package com.sitech.database.dao;

import java.util.HashMap;
import java.util.List;

import com.sitech.database.domain.TbCfgOidMib;
import com.sitech.ismp.app.event.ExpressionHelper;


public class TbCfgOidMibDao extends BaseDao{	
	@SuppressWarnings("unchecked")
	public List<TbCfgOidMib> queryMibCfgByUnitId(String unitId) {
		String condition = ExpressionHelper.genCondition(unitId);
		String sql = "select * from TB_CFG_OID_MIB where 1=1 and (" + condition + ")";

		try {
			return sqlmapClient.queryForList("queryMibCfgByUnitId", sql);
		} catch (Exception e) {
			error.error("Exception while queryMibCfgByUnitId("+unitId+")", e);
			return null;
		}		
	}
	
	@SuppressWarnings("unchecked")
	public List<TbCfgOidMib> queryMibCfgByKpiId(String kpiId) {
		String sql = "select * from TB_CFG_OID_MIB where 1=1 and KPI_ID='"
				+ kpiId + "'";

		try {
			return sqlmapClient.queryForList("queryMibCfgByKpiId", sql);
		} catch (Exception e) {
			error.error("Exception while queryMibCfgByKpiId("+kpiId+")", e);
			return null;
		}		
	}

	@SuppressWarnings("unchecked")
	public List<TbCfgOidMib> queryMibCfgAll(){		
		try {
			return (List<TbCfgOidMib>) sqlmapClient.queryForList("queryMibCfgAll", null);
		} catch (Exception e) {
			error.error("Exception while queryMibCfgAll.", e);
			return null;
		}
	}



	public int deleteTbCfgOidMib(String[] guid) {
		HashMap<String, String[]> params = new HashMap<String, String[]>();
		params.put("GUID", guid);

		try {
			return sqlmapClient.delete("deleteTbCfgOidMib", params);
		} catch (Exception e) {
			error.error("Exception while deleteTbCfgOidMib.", e);
			return -1;
		}		
	}
	
	public int deleteTbCfgOidMibAll() {
		try {
			return sqlmapClient.delete("deleteTbCfgOidMibAll", null);
		} catch (Exception e) {
			error.error("Exception while deleteTbCfgOidMib.", e);
			return -1;
		}		
	}
	
	public void insertTbCfgOidMib(TbCfgOidMib tbCfgOidMib) {
		try {
			sqlmapClient.insert("insertTbCfgOidMib", tbCfgOidMib);
		} catch (Exception e) {
			error.error("Exception while insertTbCfgOidMib.", e);
		}
	}



}