ordersimpl.java

来自「做的是一个客户关系管理系统」· Java 代码 · 共 41 行

package com.accp.impl;

import java.util.List;

import com.accp.dao.CstCustomerOrderDAO;
import com.accp.inf.OrdersInf;

public class OrdersImpl implements OrdersInf {

	private CstCustomerOrderDAO orderDAO;

	public CstCustomerOrderDAO getOrderDAO() {
		return orderDAO;
	}

	public void setOrderDAO(CstCustomerOrderDAO orderDAO) {
		this.orderDAO = orderDAO;
	}

	/**
	 * 实现一个通过客户名称查询用户订单的接口
	 */
	public List GetOrederByCustomerName(String custName) {
		// TODO Auto-generated method stub
		String sql = "select * from v_orders where odr_customer = '" + custName+"'";
		return orderDAO.Query(sql);
	}

	public Double GetSumPriceByOrderId(String id) {
		String sql = "select * from v_sumPrice where oid = "+Integer.parseInt(id);
		return orderDAO.QuerySumPriceById(sql);
	}

	public List GetProductByOrderId(String id)
	{
		String sql = "select * from v_productById where oid = " + Integer.parseInt(id);
		return orderDAO.QueryProductById(sql);
	}

}