package com.house.project.S1.M11.C110;

import com.house.project.exception.SQLException;
import com.house.project.S1.C1Bean;
import com.house.util.DBAction;
import com.house.util.PageControl;
import com.house.util.PageToObj;

public class C110Dao {
	private DBAction db;

	public C110Dao() {
		db = new DBAction();
	}

	public PageControl searchParaByName(String parm1, String parm2,
			int curPage) {
		// 產生查詢sql語句, 進行綜合查詢
		String sql = "SELECT * FROM TBL_CHUSHIDENGJI_INFO WHERE LX in ( 'gr', 'dwxj', 'dwjz' ) ";
		if (parm1 != null) {
			sql = sql + " AND Sqr like '%" + parm1 + "%'";
		}
		if (parm2 != null) {
			sql = sql + " AND Xmmc like '%" + parm2 + "%'";
		}
		 sql = sql + " AND CSZT != '2'";

		// sql, 每頁顯示記錄數, 當前頁面(從控制器中取得)
		PageToObj page = null;
		try {
			page = new PageToObj(sql,
					com.house.project.util.Properties.RECORDS_PER_PAGE,
					curPage, "com.house.project.S1.C1Bean");
		} catch (Exception e) {
			e.printStackTrace();
		}

		return new PageControl(page);
	}

	public void insertItem(C1Bean bean) throws SQLException {
	    try 
	    {
			String[] except = {"id"};
			db.executeProcInsertExceptField(bean, except,"prApp_TBL_CHUSHIDENGJI_INFO_Insert");
	    }
	    catch (Exception e)
	    {		
			e.printStackTrace();
			throw new SQLException("房屋所有權初始登記出錯");
	    }
	}

	public void removeItems(String[] procID) throws SQLException {
		for (int i = 0; i < procID.length; i++)
		{
			try
			{
				db.executeProcDelete(Integer.parseInt(procID[i]), "prApp_TBL_CHUSHIDENGJI_INFO_Delete");
			}
			catch (Exception e)
			{
				e.printStackTrace();
				throw new SQLException("刪除房屋所有權初始登記出錯");
			}
		}
	}

	public void updateItem(C1Bean bean) throws SQLException {
	    try
	    {
	    	db.executeProcUpdate(bean, "prApp_TBL_CHUSHIDENGJI_INFO_Update");
	    } 
		catch (Exception e)
		{
			e.printStackTrace();
			throw new SQLException("更新房屋所有權初始登記出錯");
		}
	}

	public C1Bean getItem(int id) throws SQLException {
		try
		{
			return (C1Bean) db.executeProcSearch(C1Bean.class.getName(), "prApp_TBL_CHUSHIDENGJI_INFO_Select", id);
		}
		catch (Exception e)
		{
			e.printStackTrace();
			throw new SQLException("獲得房屋所有權初始登記出錯");
		}
	}


}