saleinfo.java

java阿里巴巴代码

package com.saas.biz.saleMgr;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;

import com.saas.biz.attachMgr.Attachinfo;
import com.saas.biz.commen.commMethodMgr;
import com.saas.biz.dao.saleDAO.SaleDAO;
import com.saas.biz.dao.saleDAO.SaleExt;
import com.saas.biz.dao.votesubjectDAO.VotesubjectExt;
import com.saas.sys.buffer.Buffers;
import com.saas.sys.dbm.Dbtable;
import com.saas.sys.exp.SaasApplicationException;
import com.saas.sys.log.Logger;

public class SaleInfo {
	Dbtable tradeQuery;

	Logger log;

	Buffers inBuffer;

	Buffers outBuffer;

	ArrayList queryResult = new ArrayList();

	public SaleInfo()
		{
			log = new Logger(this);
			tradeQuery = new Dbtable();
		}

	public void setTradeQuery(Dbtable tradeQuery)
		{
			this.tradeQuery = tradeQuery;
		}

	public Dbtable getTradeQuery()
		{
			return this.tradeQuery;
		}

	public void setOutBuffer(Buffers outBuffer)
		{
			this.outBuffer = outBuffer;
		}

	public Buffers getOutBuffer()
		{
			return this.outBuffer;
		}

	public ArrayList getQueryResult()
		{
			return this.queryResult;
		}

	public void setQueryResult(ArrayList queryResult)
		{
			this.queryResult = queryResult;
		}
 
	public void addsaleinfo(Buffers inbuffer)
	{
			this.outBuffer = inbuffer;
			log.LOG_INFO("进入addsaleinfo方法...");
			SaleDAO  saledao = new SaleDAO();
			saledao.setSale_id(inbuffer.getString("SALE_ID"));
			saledao.setTitle(inbuffer.getString("TITLE"));
			saledao.setContent(inbuffer.getString("CONTENT"));
			saledao.setSale_addr(inbuffer.getString("SALE_ADDR"));
			saledao.setCommodity_price(inbuffer.getString("COMMODITY_PRICE"));
			saledao.setPrice_type(inbuffer.getString("PRICE_TYPE"));
			saledao.setSale_price(inbuffer.getString("SALE_PRICE"));
			saledao.setStart_date(inbuffer.getString("START_DATE"));
			saledao.setEnd_date(inbuffer.getString("END_DATE"));
			saledao.setSale_unit(inbuffer.getString("SESSION_CUST_ID"));
			saledao.setPublish_user_id(inbuffer.getString("SESSION_USER_ID"));
			saledao.setAudit_user_id(inbuffer.getString("SESSION_USER_ID"));
			int iResult = -1;	
			try
			{
				iResult =addsaleinfo(saledao);
			}
			catch(SaasApplicationException e)
			{
			log.LOG_INFO(e.getMessage());					
			}
			if (iResult != 0) {
				this.outBuffer.setInt("RESULT_CODE", -1);
				this.outBuffer.setString("RESULT_INFO", "业务处理失败！");

			} else {
				this.outBuffer.setInt("RESULT_CODE", 0);
				this.outBuffer.setString("RESULT_INFO", "业务处理成功！");
			}
			log.LOG_INFO("退出addsaleInfo方法...");
	}
	public int addsaleinfo(SaleDAO saledao) throws SaasApplicationException
	{
			SaleExt saleExt = new SaleExt();
			commMethodMgr comm = new commMethodMgr();
			saleExt.setParam(":VSALE_ID",saledao.getSale_id());
			saleExt.setParam(":VSALE_UNIT", saledao.getSale_unit());
			saleExt.setParam(":VTITLE", saledao.getTitle());
			saleExt.setParam(":VCONTENT", saledao.getContent());
			saleExt.setParam(":VSALE_ADDR", saledao.getSale_addr());
			saleExt.setParam(":VCOMMODITY_PRICE", saledao.getCommodity_price());
			saleExt.setParam(":VSTART_DATE", saledao.getStart_date());
			saleExt.setParam(":VEND_DATE", saledao.getEnd_date());
			saleExt.setParam(":VATTACH_TAG", "0");
			saleExt.setParam(":VSALE_PRICE", saledao.getSale_price());
			saleExt.setParam(":VPUBLISH_USER_ID",saledao.getPublish_user_id()); 
			saleExt.setParam(":VAUDIT_USER_ID",saledao.getAudit_user_id()); 
			saleExt.setParam(":VREMARK","");
			saleExt.setParam(":VVALIDITY","0");
			saleExt.setParam(":VSALE_CLASS","0");
			saleExt.setParam(":VSALE_TYPE","0");
			saleExt.setParam(":VPRICE_TYPE","0");
			tradeQuery.executeBy(saleExt.insBy("INS_BY_ALL"));
			this.outBuffer.setString("ROOT_ID",saledao.getSale_id());
			return 0;
	}
	public void genSale(Buffers inbuffer)
		{
			log.LOG_INFO("进入genSale方法...");

			try
			{
				this.queryResult = genSale();
			} catch (SaasApplicationException e)
			{
				log.LOG_INFO(e.getMessage());
			}
			log.LOG_INFO("退出genSale方法...");
		}

	  public ArrayList genSale() throws SaasApplicationException
		{
			ArrayList saleList = new ArrayList();
			ArrayList itemsList = new ArrayList();
			SaleExt saleExt = new SaleExt();

			saleList = saleExt.selByList("SEL_BY_ALL");
			/*for (Iterator it = saleList.iterator(); it.hasNext();)
			{
				HashMap saleListMap = (HashMap) it.next();
				String title = "";
				String sale_id = "";
				HashMap saleMap = new HashMap();
				if (saleListMap.get("sale_id") != null)
					sale_id = saleListMap.get("sale_id").toString();
				if (saleListMap.get("title") != null)
					title = saleListMap.get("title").toString();
				saleMap.put("title", title);
				saleMap.put("sale_id", sale_id);
				itemsList.add(saleMap);
			}*/
			return saleList;
		}

	// get spec sale list
	public void genSpecSale(Buffers inbuffer)
		{
			log.LOG_INFO("进入genSpecSale方法...");
			String sale_unit = inbuffer.getString("SESSION_CUST_ID");
			String  query_param = inbuffer.getString("QUERY_PARAM"); 
			try
			{
				if(query_param.equals(""))
				this.queryResult = genSpecSale(sale_unit);
				else this.queryResult =searchSale(query_param,sale_unit);
			} catch (SaasApplicationException e)
			{
				log.LOG_INFO(e.getMessage());
			}
			log.LOG_INFO("退出genSpecSale方法...");
		}

	public ArrayList genSpecSale(String sale_unit) throws SaasApplicationException
	{
			ArrayList saleList = new ArrayList();
			SaleExt saleExt = new SaleExt();
			saleExt.setParam(":VSALE_UNIT", sale_unit);
			saleList = saleExt.selByList("SEL_SPEC_SALE");
			return saleList;
	}
	//获取单个
	public void genOneSale(Buffers inbuffer)
		{
			this.outBuffer = inbuffer;
			this.inBuffer = inbuffer;
			log.LOG_INFO("进入genOneSale方法...");
			String sale_id = inbuffer.getString("SALE_ID");
			try
			{
				this.queryResult = genOneSale(sale_id);
			} catch (SaasApplicationException e)
			{
				log.LOG_INFO(e.getMessage());
			}
			log.LOG_INFO("退出genOneSale方法...");
		}

	public ArrayList genOneSale(String sale_id) throws SaasApplicationException
		{
			ArrayList saleList = new ArrayList();
			SaleExt saleExt = new SaleExt();
			saleExt.setParam(":VSALE_ID", sale_id);
			saleList = saleExt.selByList("SEL_ONE_SALE");		
			return saleList;
}
//修改
public void changsaleinfo(Buffers inbuffer)
	{
			this.outBuffer = inbuffer;
			log.LOG_INFO("进入changsaleinfo方法...");
			SaleDAO  saledao = new SaleDAO();
			saledao.setSale_id(inbuffer.getString("SALE_ID"));
			saledao.setTitle(inbuffer.getString("TITLE"));
			saledao.setContent(inbuffer.getString("CONTENT"));
			saledao.setSale_addr(inbuffer.getString("SALE_ADDR"));
			saledao.setCommodity_price(inbuffer.getString("COMMODITY_PRICE"));
			saledao.setPrice_type(inbuffer.getString("PRICE_TYPE"));
			saledao.setSale_price(inbuffer.getString("SALE_PRICE"));
			saledao.setStart_date(inbuffer.getString("START_DATE"));
			saledao.setEnd_date(inbuffer.getString("END_DATE"));
			saledao.setAudit_user_id(inbuffer.getString("SESSION_USER_ID"));
			int iResult = -1;	
			try
			{
				iResult =changsaleinfo(saledao);
			}
			catch(SaasApplicationException e)
			{
			log.LOG_INFO(e.getMessage());					
			}
			if (iResult != 0) {
				this.outBuffer.setInt("RESULT_CODE", -1);
				this.outBuffer.setString("RESULT_INFO", "业务处理失败！");

			} else {
				this.outBuffer.setInt("RESULT_CODE", 0);
				this.outBuffer.setString("RESULT_INFO", "业务处理成功！");
			}
			log.LOG_INFO("退出addsaleInfo方法...");
	}
	public int changsaleinfo(SaleDAO saledao) throws SaasApplicationException
	{
			SaleExt saleExt = new SaleExt();
			saleExt.setParam(":VSALE_ID",saledao.getSale_id());
			saleExt.setParam(":VTITLE", saledao.getTitle());
			saleExt.setParam(":VCONTENT", saledao.getContent());
			saleExt.setParam(":VSALE_ADDR", saledao.getSale_addr());
			saleExt.setParam(":VCOMMODITY_PRICE", saledao.getCommodity_price());
			saleExt.setParam(":VSTART_DATE", saledao.getStart_date());
			saleExt.setParam(":VEND_DATE", saledao.getEnd_date());
			saleExt.setParam(":VSALE_PRICE", saledao.getSale_price());
			saleExt.setParam(":VAUDIT_USER_ID",saledao.getAudit_user_id()); 
			saleExt.setParam(":VPRICE_TYPE",saledao.getPrice_type());
			tradeQuery.executeBy(saleExt.insBy("UPDATE_BY_ONE"));
			return 0;
	}
//删除
public void delsaleinfo(Buffers inbuffer)
	{
			this.outBuffer = inbuffer;
			log.LOG_INFO("进入changsaleinfo方法...");
			int iResult = -1;	
			try
			{
				iResult =delsaleinfo(inbuffer.getString("SALE_ID"));
			}
			catch(SaasApplicationException e)
			{
			log.LOG_INFO(e.getMessage());					
			}
			if (iResult != 0) {
				this.outBuffer.setInt("RESULT_CODE", -1);
				this.outBuffer.setString("RESULT_INFO", "业务处理失败！");

			} else {
				this.outBuffer.setInt("RESULT_CODE", 0);
				this.outBuffer.setString("RESULT_INFO", "业务处理成功！");
			}
			log.LOG_INFO("退出delsaleinfo方法...");
	}
	public int delsaleinfo(String  sale_id) throws SaasApplicationException
	{
			SaleExt saleExt = new SaleExt();
			saleExt.setParam(":VSALE_ID",sale_id);
			tradeQuery.executeBy(saleExt.insBy("DEL_BY_ID"));
			return 0;
	}
	//供应商查询 add by sjp  date:2007-06-08
	public void searchCust(Buffers inbuffer) 
		{
			log.LOG_INFO("进入searchCust方法...");
			this.outBuffer = inbuffer;
			String  saler_name = inbuffer.getString("SALER_NAME");
			try 
			{
				this.queryResult = searchCust(saler_name);
			} 
				catch (SaasApplicationException e)
				{
					log.LOG_INFO(e.getMessage());

				}
				log.LOG_INFO("退出searchCust方法...");
			}
public ArrayList searchCust(String saler_name) throws SaasApplicationException 
{
	ArrayList itemsList = new ArrayList();
	SaleExt saleExt = new SaleExt();
	saleExt.setParam(":VCUST_NAME",saler_name);
	itemsList = saleExt.selByList("SEL_BY_SALER");	 
	return itemsList;
}
public ArrayList searchSale(String title,String sale_unit) throws SaasApplicationException 
{
	ArrayList itemsList = new ArrayList();
	SaleExt saleExt = new SaleExt();
	saleExt.setParam(":VTITLE","%"+title+"%");
	saleExt.setParam(":VSALE_UNIT",sale_unit);
	itemsList = saleExt.selByList("SEL_BY_SEARCH");	 
	return itemsList;
}
	
	//查找图片路径
	public String searchfj(String commodity_id,String flag ) throws SaasApplicationException
	{		
		//log.LOG_INFO("进入searchfj方法...");
		Attachinfo attachInfo = new Attachinfo();
		String file_path=attachInfo.getAttachPath(commodity_id, flag, "0");			 
		//log.LOG_INFO("退出searchfj方法...");
		return file_path;
	}
	//分页查询
	public ArrayList gentSalesByCust_id(int iStart,String sale_unit) throws SaasApplicationException
	{
		ArrayList saleList = new ArrayList();
		if(iStart==0)
	    {
			iStart=0;
		}
		else 
		{
		    iStart = (iStart-1)*30;
		}
		SaleExt saleExt = new SaleExt();
		saleExt.setParam(":VSALE_UNIT", sale_unit);
		saleList = saleExt.selByList("SEL_SPEC_SALE",iStart,30);
		return saleList;
	}
	//统计总数
	public int getSaleListNumber(String sale_unit) throws SaasApplicationException
	{
		ArrayList saleList = new ArrayList();
		SaleExt saleExt = new SaleExt();
		saleExt.setParam(":VSALE_UNIT", sale_unit);
		saleList = saleExt.selByList("SEL_SPEC_SALE");
		if(saleList != null)
		{
			return saleList.size();
		}	 
		else 
		{
			return 0;
		}
	}
	//分页搜索查询
	public ArrayList getSaleListBySearch(int iStart,String Keys) throws SaasApplicationException
	{   
			if(iStart==0)
		    {
				iStart=0;
			}
			else 
			{
			    iStart = (iStart-1)*30;
			}
			ArrayList productList = new ArrayList();
			SaleExt productExt = new SaleExt();
			productExt.setParam(":VCONTENT","%"+Keys.trim()+"%");
			log.LOG_INFO("========"+Keys);
			try{
			productList = productExt.selByList("SEL_BY_KEYS",iStart,30);			
		}catch(Exception ex)
		{
			log.LOG_INFO(ex.getMessage());
		}
			return productList;
	}
	//分页搜索统计
	public int getSaleSearch(String Keys) throws SaasApplicationException
	{
	    ArrayList productList = new ArrayList();
		SaleExt productExt = new SaleExt();
		productExt.setParam(":VCONTENT","%"+Keys.trim()+"%");
		productList = productExt.selByList("SEL_BY_KEYS");			
		if(productList != null)
		{
			return productList.size();
		}	 
		else 
		{
			return 0;
		}
	} 	
	
	public ArrayList genSaleList( int num ) throws SaasApplicationException
	{
		ArrayList saleList = new ArrayList();
		  
		SaleExt saleExt = new SaleExt();
		 
		saleList = saleExt.selByList("SEL_BY_ALL",0,num );
	 
		return saleList;
	}
	
	
	public ArrayList genSaleListByCust_ID( String cust_id, int num ) throws SaasApplicationException
	{
		ArrayList saleList = new ArrayList();
		  
		SaleExt saleExt = new SaleExt();
		saleExt.setParam(":VSALE_UNIT", cust_id); 
		saleList = saleExt.selByList("SEL_BY_CUSTID",0,num );
	 
		return saleList;
	}
}