WorkTaskNewsBeanDBHelper.java

package com.jiuqi.njt.db;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import android.annotation.SuppressLint;
import android.content.Context;
import android.util.Log;
import com.j256.ormlite.dao.Dao;
import com.jiuqi.mobile.nigo.comeclose.bean.app.news.CarTaskNewsBean;
import com.jiuqi.mobile.nigo.comeclose.bean.app.news.SupplyAndDemandTaskNewsBean;
import com.jiuqi.mobile.nigo.comeclose.bean.app.news.WorkTaskNewsBean;
import com.jiuqi.mobile.nigo.comeclose.bean.base.AdminAreaBean;
import com.jiuqi.mobile.nigo.comeclose.bean.base.DataDictionaryBean;
import com.jiuqi.mobile.nigo.comeclose.bean.base.KindsOfCarBean;
import com.jiuqi.njt.data.AdminAreaBeanLocal;
import com.jiuqi.njt.data.DataDictionaryBeanLocal;
import com.jiuqi.njt.data.KindsOfCarBeanLocal;
import com.jiuqi.njt.data.WorkTaskBeanLocal;

public class WorkTaskNewsBeanDBHelper {

	private DatabaseHelper helper;
	private Dao<WorkTaskBeanLocal, Integer> dao;

	@SuppressWarnings("unchecked")
	public WorkTaskNewsBeanDBHelper(Context context) {
		try {
			helper = DatabaseHelper.getHelper(context);
			dao = helper.getDao(WorkTaskBeanLocal.class);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public List<WorkTaskBeanLocal> queryAll() {
		List<WorkTaskBeanLocal> retList = new ArrayList<WorkTaskBeanLocal>();
		try {
			retList = dao.queryForAll();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return retList;
	}

	public int delect(WorkTaskBeanLocal msg) {
		int i = -9;
		try {
			i = dao.delete(msg);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return i;
	}

	/**
	 * // 0保存 1提交 根据状态获取数据
	 * 
	 * @param state
	 * @return
	 */
	public List<WorkTaskBeanLocal> queryWorkTaskBeanLocalsByState(int state) {
		List<WorkTaskBeanLocal> workTaskNewsBeansList = new ArrayList<WorkTaskBeanLocal>();
		try {
			workTaskNewsBeansList = dao.queryForEq("submitState", state);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return workTaskNewsBeansList;
	}

	public WorkTaskBeanLocal queryWorkTaskBeanLocalByGuid(String guid) {
		WorkTaskBeanLocal wBean = new WorkTaskBeanLocal();
		List<WorkTaskBeanLocal> list;
		try {
			list = dao.queryForEq("guid", guid);
			if (list != null && list.size() > 0) {
				wBean = list.get(0);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return wBean;

	}

	public void create(List<WorkTaskBeanLocal> wList) {
		for (WorkTaskBeanLocal wBean : wList) {
			try {
				dao.create(wBean);
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
	}

	@SuppressLint("NewApi")
	public void create(WorkTaskBeanLocal wBean) {
		try {
			dao.create(wBean);
		} catch (Exception e) {
			e.printStackTrace();
			Log.wtf("e", e+"");
		}
	}

	public int deleteById(String worktaskId) {
		int i = -1;
		try {
			WorkTaskBeanLocal wtb = new WorkTaskBeanLocal();
			// wtb.setGuid(worktaskId);
			i = dao.delete(wtb);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return i;
	}

	public void deleteByGuid(String Guid) {
		try {
			List<WorkTaskBeanLocal> list = queryByGuid(Guid);
			if (list != null) {
				for (WorkTaskBeanLocal workTaskNewsBean : list) {
					dao.delete(workTaskNewsBean);
				}
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}

	}

	public List<WorkTaskBeanLocal> queryByGuid(String Guid) {

		List<WorkTaskBeanLocal> IndexItemSuccesslist = null;
		try {
			WorkTaskBeanLocal bean = new WorkTaskBeanLocal();
			bean.setGuid(Guid);
			IndexItemSuccesslist = dao.queryForMatching(bean);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return IndexItemSuccesslist;
	}

	public List<WorkTaskBeanLocal> queryForState(int state) {
		List<WorkTaskBeanLocal> queryForEq = new ArrayList<WorkTaskBeanLocal>();
		try {
			queryForEq = dao.queryForEq("state", state);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return queryForEq;
	}

	public boolean isSubmitLicense(String license) {
		List<WorkTaskBeanLocal> queryForEq = new ArrayList<WorkTaskBeanLocal>();
		try {
			WorkTaskBeanLocal file = new WorkTaskBeanLocal();
			// file.setCrossLicense(license);
			file.setState(1);
			queryForEq = dao.queryForMatching(file);
		} catch (SQLException e) {
			e.printStackTrace();
		}

		if (queryForEq != null && queryForEq.size() > 0) {
			return true;
		}
		return false;
	}

	/**
	 * @param bean
	 *            作业面积bean转本地
	 * @return
	 */
	public WorkTaskBeanLocal getBeanToLocal(WorkTaskNewsBean bean) {
		WorkTaskBeanLocal wLocal = new WorkTaskBeanLocal();
		wLocal.setGuid(bean.getGuid());
		wLocal.setAddPersonGuid(bean.getAddPersonGuid());
		wLocal.setAddPersonName(bean.getAddPersonName());
		wLocal.setAddPersonMobileNumber(bean.getAddPersonMobileNumber());
		wLocal.setAddress(bean.getAddress());
		wLocal.setAdminAreaCode(getAdminBeanToLocal(bean.getAdminAreaCode()));
		wLocal.setNewsType(getDataDictionaryToLocal(bean.getNewsType()));
		wLocal.setWorkType(getDataDictionaryToLocal(bean.getWorkType()));
		// 需转化
		wLocal.setMus(bean.getMus());
		wLocal.setMinPrice(bean.getMinPrice());
		wLocal.setMaxPrice(bean.getMaxPrice());
		wLocal.setContactMobileNumber(bean.getContactMobileNumber());
		wLocal.setComments(bean.getComments());
		wLocal.setContactor(bean.getContactor());
		wLocal.setCreateDate(bean.getCreateDate());
		wLocal.setStartDate(bean.getStartDate());
		wLocal.setEndDate(bean.getEndDate());
		wLocal.setLatitude(bean.getLatitude());
		wLocal.setLongitude(bean.getLongitude());
		wLocal.setIsPush(bean.getIsPush());
		return wLocal;
	}

	/**
	 * @param 本地bean转作业面积bean
	 * @return
	 */
	public WorkTaskNewsBean getLocalToBean(WorkTaskBeanLocal bean) {
		WorkTaskNewsBean wLocal = new WorkTaskNewsBean();
		wLocal.setGuid(bean.getGuid());
		wLocal.setAddPersonGuid(bean.getAddPersonGuid());
		wLocal.setAddPersonName(bean.getAddPersonName());
		wLocal.setAddPersonMobileNumber(bean.getAddPersonMobileNumber());
		wLocal.setAddress(bean.getAddress());
		// 需转化
		wLocal.setAdminAreaCode(getAdminLocalToBean(bean.getAdminAreaCode()));
		wLocal.setNewsType(getDataDictionaryLocalToBean(bean.getNewsType()));
		wLocal.setWorkType(getDataDictionaryLocalToBean(bean.getWorkType()));
		wLocal.setMus(bean.getMus());
		wLocal.setMinPrice(bean.getMinPrice());
		wLocal.setMaxPrice(bean.getMaxPrice());
		wLocal.setContactMobileNumber(bean.getContactMobileNumber());
		wLocal.setComments(bean.getComments());
		wLocal.setContactor(bean.getContactor());
		wLocal.setCreateDate(bean.getCreateDate());
		wLocal.setStartDate(bean.getStartDate());
		wLocal.setEndDate(bean.getEndDate());
		wLocal.setLatitude(bean.getLatitude());
		wLocal.setLongitude(bean.getLongitude());
		wLocal.setIsPush(bean.getIsPush());
		return wLocal;
	}

	/**
	 * @param bean商品bean
	 *            转本地bean
	 * @return
	 */
	public WorkTaskBeanLocal getBeanToLocalForSupply(
			SupplyAndDemandTaskNewsBean bean) {
		WorkTaskBeanLocal sApBean = new WorkTaskBeanLocal();
		sApBean.setGuid(bean.getGuid());
		sApBean.setAddPersonGuid(bean.getAddPersonGuid());
		sApBean.setAddPersonName(bean.getAddPersonName());
		sApBean.setAddPersonMobileNumber(bean.getAddPersonMobileNumber());
		sApBean.setAddress(bean.getAddress());
		sApBean.setAdminAreaCode(getAdminBeanToLocal(bean.getAdminAreaCode()));
		// 需转化
		sApBean.setNewsType(getDataDictionaryToLocal(bean.getNewsType()));
		sApBean.setGoodsType(getDataDictionaryToLocal(bean.getGoodsType()));
		sApBean.setGoodsUnit(getDataDictionaryToLocal(bean.getGoodsUnit()));
		sApBean.setGoodsName(bean.getGoodsName());
		sApBean.setCount(bean.getCount());
		sApBean.setPrice(bean.getPrice());
		//
		sApBean.setContactMobileNumber(bean.getContactMobileNumber());
		sApBean.setComments(bean.getComments());
		sApBean.setContactor(bean.getContactor());
		sApBean.setCreateDate(bean.getCreateDate());
		sApBean.setStartDate(bean.getStartDate());
		sApBean.setEndDate(bean.getEndDate());
		sApBean.setLatitude(bean.getLatitude());
		sApBean.setLongitude(bean.getLongitude());
		// sApBean.setIsPush(bean.getIsPush());
		return sApBean;
	}

	/**
	 * @param bean本地bean转商品bean
	 * @return
	 */
	public SupplyAndDemandTaskNewsBean getLocalToBeanForSupply(
			WorkTaskBeanLocal bean) {
		SupplyAndDemandTaskNewsBean sApBean = new SupplyAndDemandTaskNewsBean();
		sApBean.setGuid(bean.getGuid());
		sApBean.setAddPersonGuid(bean.getAddPersonGuid());
		sApBean.setAddPersonName(bean.getAddPersonName());
		sApBean.setAddPersonMobileNumber(bean.getAddPersonMobileNumber());
		sApBean.setAddress(bean.getAddress());
		sApBean.setAdminAreaCode(getAdminLocalToBean(bean.getAdminAreaCode()));
		// 需转化
		sApBean.setNewsType(getDataDictionaryLocalToBean(bean.getNewsType()));
		sApBean.setGoodsType(getDataDictionaryLocalToBean(bean.getGoodsType()));
		sApBean.setGoodsUnit(getDataDictionaryLocalToBean(bean.getGoodsUnit()));
		sApBean.setGoodsName(bean.getGoodsName());
		sApBean.setCount(bean.getCount());
		sApBean.setPrice(bean.getPrice());
		//
		sApBean.setContactMobileNumber(bean.getContactMobileNumber());
		sApBean.setComments(bean.getComments());
		sApBean.setContactor(bean.getContactor());
		sApBean.setCreateDate(bean.getCreateDate());
		sApBean.setStartDate(bean.getStartDate());
		sApBean.setEndDate(bean.getEndDate());
		sApBean.setLatitude(bean.getLatitude());
		sApBean.setLongitude(bean.getLongitude());
		// sApBean.setIsPush(bean.getIsPush());
		return sApBean;
	}

	/**
	 * 农机bean 转本地bean
	 * 
	 * @param bean
	 * @return
	 */
	public WorkTaskBeanLocal getBeanToLocalForCar(CarTaskNewsBean bean) {
		WorkTaskBeanLocal carBean = new WorkTaskBeanLocal();
		carBean.setGuid(bean.getGuid());
		carBean.setAddPersonGuid(bean.getAddPersonGuid());
		carBean.setAddPersonName(bean.getAddPersonName());
		carBean.setAddPersonMobileNumber(bean.getAddPersonMobileNumber());
		carBean.setAddress(bean.getAddress());
		carBean.setAdminAreaCode(getAdminBeanToLocal(bean.getAdminAreaCode()));
		// 需转化
		carBean.setNewsType(getDataDictionaryToLocal(bean.getNewsType()));
		carBean.setWorkType(getDataDictionaryToLocal(bean.getCropType()));
		carBean.setCarTypeNew(getCarTaskNewsBeanToLocal(bean.getCarTypeNew()));
		carBean.setMus(bean.getCount());
		carBean.setMinPrice(bean.getMinPrice());
		carBean.setMaxPrice(bean.getMaxPrice());
		//
		carBean.setContactMobileNumber(bean.getContactMobileNumber());
		carBean.setComments(bean.getComments());
		carBean.setContactor(bean.getContactor());
		carBean.setCreateDate(bean.getCreateDate());
		carBean.setStartDate(bean.getStartDate());
		carBean.setEndDate(bean.getEndDate());
		carBean.setLatitude(bean.getLatitude());
		carBean.setLongitude(bean.getLongitude());
		// sApBean.setIsPush(bean.getIsPush());
		return carBean;
	}

	/**
	 * 本地bean转农机bean
	 * 
	 * @param bean
	 * @return
	 */
	public CarTaskNewsBean getLocalToBeanForCar(WorkTaskBeanLocal bean) {
		CarTaskNewsBean carBean = new CarTaskNewsBean();
		carBean.setGuid(bean.getGuid());
		carBean.setAddPersonGuid(bean.getAddPersonGuid());
		carBean.setAddPersonName(bean.getAddPersonName());
		carBean.setAddPersonMobileNumber(bean.getAddPersonMobileNumber());
		carBean.setAddress(bean.getAddress());
		carBean.setAdminAreaCode(getAdminLocalToBean(bean.getAdminAreaCode()));
		// 需转化
		carBean.setNewsType(getDataDictionaryLocalToBean(bean.getNewsType()));
		carBean.setCropType(getDataDictionaryLocalToBean(bean.getWorkType()));
		carBean.setCarTypeNew(getCarTaskNewsBeanLocalToBean(bean.getCarTypeNew()));
		carBean.setCount(bean.getMus());
		carBean.setMinPrice(bean.getMinPrice());
		carBean.setMaxPrice(bean.getMaxPrice());
		//
		carBean.setContactMobileNumber(bean.getContactMobileNumber());
		carBean.setComments(bean.getComments());
		carBean.setContactor(bean.getContactor());
		carBean.setCreateDate(bean.getCreateDate());
		carBean.setStartDate(bean.getStartDate());
		carBean.setEndDate(bean.getEndDate());
		carBean.setLatitude(bean.getLatitude());
		carBean.setLongitude(bean.getLongitude());
		// sApBean.setIsPush(bean.getIsPush());
		return carBean;
	}

	/**
	 * @param bean
	 * @return
	 */
	public AdminAreaBean getAdminLocalToBean(AdminAreaBeanLocal bean) {
		AdminAreaBean adAreaBean = new AdminAreaBean();
		adAreaBean.setAdminAreaAd(bean.getAdminAreaAd());
		adAreaBean.setCityCode(bean.getCityCode());
		adAreaBean.setCityName(bean.getCountryName());
		adAreaBean.setCode(bean.getCode());
		adAreaBean.setCountryCode(bean.getCityCode());
		adAreaBean.setCountryName(bean.getCountryName());
		adAreaBean.setCreateDate(bean.getCreateDate());
		adAreaBean.setCreateDateStr(bean.getCreateDateStr());
		adAreaBean.setCreateDateTimeStr(bean.getCreateDateTimeStr());
		adAreaBean.setGuid(bean.getGuid());
		adAreaBean.setLatitude(bean.getLatitude());
		adAreaBean.setLongitude(bean.getLatitude());
		adAreaBean.setName(bean.getName());
		adAreaBean.setpCode(bean.getpCode());
		adAreaBean.setProvinceCode(bean.getProvinceCode());
		adAreaBean.setProvinceName(bean.getProvinceName());
		adAreaBean.setTownCode(bean.getTownCode());
		adAreaBean.setTownName(bean.getTownName());
		adAreaBean.setVillageCode(bean.getVillageCode());
		adAreaBean.setVillageName(bean.getVillageName());
		return adAreaBean;
	}

	/**
	 * @param bean
	 * @return
	 */
	public AdminAreaBeanLocal getAdminBeanToLocal(AdminAreaBean bean) {
		AdminAreaBeanLocal adAreaBeanlLocal = new AdminAreaBeanLocal();
		adAreaBeanlLocal.setAdminAreaAd(bean.getAdminAreaAd());
		adAreaBeanlLocal.setCityCode(bean.getCityCode());
		adAreaBeanlLocal.setCityName(bean.getCountryName());
		adAreaBeanlLocal.setCode(bean.getCode());
		adAreaBeanlLocal.setCountryCode(bean.getCityCode());
		adAreaBeanlLocal.setCountryName(bean.getCountryName());
		adAreaBeanlLocal.setCreateDate(bean.getCreateDate());
		adAreaBeanlLocal.setCreateDateStr(bean.getCreateDateStr());
		adAreaBeanlLocal.setCreateDateTimeStr(bean.getCreateDateTimeStr());
		adAreaBeanlLocal.setGuid(bean.getGuid());
		adAreaBeanlLocal.setLatitude(bean.getLatitude());
		adAreaBeanlLocal.setLongitude(bean.getLatitude());
		adAreaBeanlLocal.setName(bean.getName());
		adAreaBeanlLocal.setpCode(bean.getpCode());
		adAreaBeanlLocal.setProvinceCode(bean.getProvinceCode());
		adAreaBeanlLocal.setProvinceName(bean.getProvinceName());
		adAreaBeanlLocal.setTownCode(bean.getTownCode());
		adAreaBeanlLocal.setTownName(bean.getTownName());
		adAreaBeanlLocal.setVillageCode(bean.getVillageCode());
		adAreaBeanlLocal.setVillageName(bean.getVillageName());
		return adAreaBeanlLocal;
	}

	/**
	 * @param bean
	 * @return
	 */
	public DataDictionaryBeanLocal getDataDictionaryToLocal(
			DataDictionaryBean bean) {
		DataDictionaryBeanLocal bLocal = new DataDictionaryBeanLocal();
		bLocal.setCode(bean.getCode());
		bLocal.setCoGuid(bean.getCoGuid() == null ? "" : bean.getCoGuid());
		bLocal.setCreateDate(bean.getCreateDate());
		bLocal.setGuid(bean.getGuid());
		bLocal.setMark(bean.getMark());
		bLocal.setMarkName(bean.getMarkName());
		bLocal.setName(bean.getName());
		bLocal.setPCode(bean.getPCode());
		return bLocal;
	}

	/**
	 * @param bean
	 * @return
	 */
	public DataDictionaryBean getDataDictionaryLocalToBean(
			DataDictionaryBeanLocal bean) {
		DataDictionaryBean bbean = new DataDictionaryBean();
		bbean.setCode(bean.getCode());
		bbean.setCoGuid(bean.getCoGuid());
		bbean.setCreateDate(bean.getCreateDate());
		bbean.setGuid(bean.getGuid());
		bbean.setMark(bean.getMark());
		bbean.setMarkName(bean.getMarkName());
		bbean.setName(bean.getName());
		bbean.setPCode(bean.getPCode());
		return bbean;
	}

	//
	/**
	 * @param bean
	 * @return
	 */
	public KindsOfCarBeanLocal getCarTaskNewsBeanToLocal(
			KindsOfCarBean bean) {
		KindsOfCarBeanLocal bLocal = new KindsOfCarBeanLocal();
		bLocal.setCode(bean.getCode());
		bLocal.setName(bean.getName());
		return bLocal;
	}

	/**
	 * @param bean
	 * @return
	 */
	public KindsOfCarBean getCarTaskNewsBeanLocalToBean(
			KindsOfCarBeanLocal bean) {
		KindsOfCarBean bLocal = new KindsOfCarBean();
		bLocal.setCode(bean.getCode());
		bLocal.setName(bean.getName());
		return bLocal;
	}
}