merchantbizgroupownerdao.java

基于struts的网上商店源码

/*
 * 作者:刘云云
 * 时间:2007年11月28日
 * 功能:我的商业合作-＞我发起的商圈
 */
package com.mole.struts.dao;

import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;

import com.mole.struts.bean.MerchantBizGroupInfoBean;
import com.mole.struts.form.MerchantBizGroupOwnerForm;

public class MerchantBizGroupOwnerDAO extends AbstractPageDAO {

	private String activityId = "0";

	public MerchantBizGroupOwnerDAO() {
	}

	public MerchantBizGroupOwnerDAO(String column, String where, String id,
			String group, String order, int pageSize) {
		this.setColumnCondition(column);
		this.setWhereCondition(where);
		this.setIdCondition(id);
		this.setGroupCondition(group);
		this.setOrderCondition(order);
		this.setPageSize(pageSize);
	}

	public void setWhere(String storeId, String activityId) {
		this.activityId = activityId;
		String where = " v_BizGroupOwner WHERE StoreID=" + storeId;
		if (activityId != null && !activityId.equals("0"))
			where = where + " AND activityId=" + activityId;
		this.setWhereCondition(where);
	}

	// 获取自已发起的商圈的记录集
	public MerchantBizGroupInfoBean[] getBizGroupInfoPage(String storeId) {
		ArrayList<Object[]> arrayList = this.executeQuery(getSql());
		if (arrayList == null)
			return null;

		MerchantBizGroupInfoBean[] records = new MerchantBizGroupInfoBean[arrayList
				.size()];
		if (records.length == 0)
			return records;

		Iterator<Object[]> it = arrayList.iterator();
		int i = 0;
		while (it.hasNext()) {
			Object[] obj = it.next();
			MerchantBizGroupInfoBean record = new MerchantBizGroupInfoBean();
			record.setName(obj[0].toString());
			record.setActivityDes(obj[1].toString());
			record.setStartDate(obj[2].toString().substring(0, 10));
			record.setEndDate(obj[3].toString().substring(0, 10));
			record.setState(Integer.parseInt(obj[4].toString()));
			record.setActivityId(obj[5].toString());
			record.setId(obj[6].toString());
			record.setAttendCount(Integer.parseInt(obj[7].toString()));
			record.setAppCount(Integer.parseInt(obj[8].toString()));

			Date currentDate = new Date();
			SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
			String dateString = formatter.format(currentDate);
			if (record.getState() == 3) {
				record.setTig("delete");
			} else if (record.getState() == 2
					|| (record.getState() == 1 && dateString.compareTo(record
							.getEndDate()) > 0)
					|| (record.getState() == 0 && dateString.compareTo(record
							.getEndDate()) > 0)) {
				record.setTig("end");
			} else if (record.getState() == 1
					|| (record.getState() == 0
							&& dateString.compareTo(record.getEndDate()) <= 0 && dateString
							.compareTo(record.getStartDate()) >= 0)) {
				record.setTig("start");
			} else {
				record.setTig("ready");
			}
			records[i++] = record;
		}
		return records;
	}

	// 获取商圈详细信息
	public MerchantBizGroupInfoBean getBizGroupInfo(String sql) {
		MerchantBizGroupInfoBean bizgroupinfo = new MerchantBizGroupInfoBean();
		ArrayList<Object[]> al = this.executeQuery(sql);
		Object[] obj = al.get(0);
		bizgroupinfo.setId(obj[0].toString());
		bizgroupinfo.setName((String) obj[1].toString());
		bizgroupinfo.setDescription(obj[2].toString());
		bizgroupinfo.setStartDate(obj[3].toString().substring(0, 10));
		bizgroupinfo.setEndDate(obj[4].toString().substring(0, 10));
		bizgroupinfo.setState(Integer.parseInt(obj[5].toString()));
		bizgroupinfo.setActivityId(obj[6].toString());
		bizgroupinfo.setActivityDes(obj[7].toString());
		bizgroupinfo.setImage((String) obj[8]);
		return bizgroupinfo;
	}

	// 修改商圈
	public void updateBizGroupInfo(MerchantBizGroupOwnerForm form) {
		String sql = "update [BizGroup] set [Name]='" + form.getName()
				+ "',[Description]='" + form.getDescription()
				+ "',[startDate]='" + form.getStartDate() + "',[endDate]='"
				+ form.getEndDate() + "',[activityId]=" + form.getActivityId()
				+ ",[activityDes]='" + form.getActivityDes() + "',[Image]='"
				+ form.getImage() + "' where [id]='" + form.getId() + "'";
		this.executeUpdate(sql);
	}

	public String getActivityId() {
		return activityId;
	}
}