paymentserviceimpl.java

SSH示范

package com.iplan.portal.order.service;

import java.util.List;

import com.iplan.portal.framework.base.BaseService;
import com.iplan.portal.order.pojo.Payment;

/**
 * http://www.hao-se.cn
 * 
 * @author ws
 */
public class PaymentServiceImpl extends BaseService implements IPaymentService {

	public Payment getPaymentById(String id) {
		return (Payment) this.getCommonDAO().get(Payment.class, id);
	}

	public List getPaymentList(String userId) {
		StringBuffer sql = new StringBuffer();
		sql.append("select * from PAYMENT where userid = ? order by CREATETIME DESC");
		List list = this.getCommonDAO().findBySQL(sql.toString(),
				new Object[] { userId }).getRows();

		return list;
	}

	public List getCustomerListByCusName(String userId, String payDateStr1,
			String payDateStr2, String customerName) {
		StringBuffer sql = new StringBuffer();
		sql.append("select * from PAYMENT where userid ='" + userId + "' ");
		if (customerName != null && !"".equals(customerName)) {
			sql.append("and customername like '%" + customerName + "%' ");
		}
		if (payDateStr1 != null && !"".equals(payDateStr1)) {
			sql.append("and SUBSTRING(CONVERT(paydate,VARCHAR),1,10) >= '"
					+ convert(payDateStr1) + "' ");
		}
		if (payDateStr2 != null && !"".equals(payDateStr2)) {
			sql.append("and SUBSTRING(CONVERT(paydate,VARCHAR),1,10) <= '"
					+ convert(payDateStr2) + "' ");
		}
		sql.append("order by CREATETIME DESC");
		
		List list = this.getCommonDAO().findBySQL(sql.toString()).getRows();
		
		return list;
	}

	public void savePayment(Payment payment) {
		this.getCommonDAO().save(payment);
	}

	public void updatePayment(Payment payment) {
		this.getCommonDAO().update(payment);
	}

	public void deletePayment(Payment payment) {
		this.getCommonDAO().delete(payment);
	}

	private String convert(String date) {
		String str = "";
		str = date.replaceAll("/", "-");
		return str;
	}
}