actionent_customer_request.java

公司CRM部分原代码,采用的是java技术.

package GDPE.customer.request;

import java.util.StringTokenizer;

import levin.base.*;
import levin.util.*;

import javax.servlet.http.*;

import GDPE.customer.linkman.DAOLinkMan;
import GDPE.customer.linkman.EnENT_CUSTOMER_LINKMAN;

public class ActionEnt_Customer_request extends Service
{
   
  public ActionEnt_Customer_request()
  {
  }

  public String execute(HttpServletRequest request, HttpServletResponse response) throws Exception
  {
    throw new Exception("Error on doType=" + request.getParameter("doType") + ".");
  }

  public String summary(HttpServletRequest request, HttpServletResponse response) throws Exception
  {
	//String id = request.getParameter("id");
	EnEnt_Customer_request aEnEnt_Customer_request[]=null;
	//if(id==null) {
    aEnEnt_Customer_request = (EnEnt_Customer_request[])(DAOBase.findAll(new DbAccess(),EnEnt_Customer_request.class.getName()));
    
	//}else {
	//	aEnEnt_Customer_request = (EnEnt_Customer_request[])(DAOBase.findAll(new DbAccess(),EnEnt_Customer_request.class.getName()));
	
	//}
	for(int i=0;i<aEnEnt_Customer_request.length;i++){
    	if(!aEnEnt_Customer_request[i].getDtCommitTime().equals(""))
    		aEnEnt_Customer_request[i].setDtCommitTime(aEnEnt_Customer_request[i].getDtCommitTime().substring(0,10));
    	if(!aEnEnt_Customer_request[i].getDtComplete_Time().equals(""))
    		aEnEnt_Customer_request[i].setDtComplete_Time(aEnEnt_Customer_request[i].getDtComplete_Time().substring(0,10));
    	if(!aEnEnt_Customer_request[i].getDtRequest_Time().equals(""))
    		aEnEnt_Customer_request[i].setDtRequest_Time(aEnEnt_Customer_request[i].getDtRequest_Time().substring(0,10));
  
        if(aEnEnt_Customer_request[i].getDtCommitTime().startsWith("1900"))
        	aEnEnt_Customer_request[i].setDtCommitTime("");
        if(aEnEnt_Customer_request[i].getDtComplete_Time().startsWith("1900"))
        	aEnEnt_Customer_request[i].setDtComplete_Time("");
        if(aEnEnt_Customer_request[i].getDtRequest_Time().startsWith("1900"))
        	aEnEnt_Customer_request[i].setDtRequest_Time("");
	 }
    request.setAttribute("aEnEnt_Customer_request", aEnEnt_Customer_request);
    request.setAttribute("chooseType", "checkbox");
    return this.getTargetPage("summary");
  }

  public String addQuery(HttpServletRequest request, HttpServletResponse response) throws Exception
  {
    EnEnt_Customer_request cEnEnt_Customer_request = new EnEnt_Customer_request();
    request.setAttribute("cEnEnt_Customer_request", cEnEnt_Customer_request);
    request.setAttribute("doType","add");
    return this.getTargetPage("detail");
  }

  public String add(HttpServletRequest request, HttpServletResponse response) throws Exception
  {
    EnEnt_Customer_request cEnEnt_Customer_request = (EnEnt_Customer_request)request.getAttribute("cEnEnt_Customer_request");
    DbAccess db = new DbAccess();
    try
    {
      db.beginTransaction();
      DAOBase.insert(db,cEnEnt_Customer_request);
      db.commit();
    }
    catch(Exception ex)
    {
      db.rollback();
      throw ex;
    }
    levin.iMessage msg = levin.iMessage.getNewInstance("客户请求",
        "新增成功.",
        "openTop(\"GDPE.customer.request.ActionEnt_Customer_request.do?doType=summary\");");
    msg.save(request);
    return this.getTargetPage("Message");
  }

  public String modifyQuery(HttpServletRequest request, HttpServletResponse response) throws Exception
  {
    String id = request.getParameter("id");
    EnEnt_Customer_request cEnEnt_Customer_request = (EnEnt_Customer_request)DAOBase.findByPK(new DbAccess(),EnEnt_Customer_request.class.getName(),id);
    if(!cEnEnt_Customer_request.getDtCommitTime().equals(""))
    {
        String year=cEnEnt_Customer_request.getDtCommitTime().substring(0,4);
        String month=cEnEnt_Customer_request.getDtCommitTime().substring(5,7);
        String day=cEnEnt_Customer_request.getDtCommitTime().substring(8,10);
        cEnEnt_Customer_request.setDtCommitTime(year+month+day);
    }

    if(!cEnEnt_Customer_request.getDtComplete_Time().equals("")){
     String year=cEnEnt_Customer_request.getDtComplete_Time().substring(0,4);
     String month=cEnEnt_Customer_request.getDtComplete_Time().substring(5,7);
     String day=cEnEnt_Customer_request.getDtComplete_Time().substring(8,10);
     cEnEnt_Customer_request.setDtComplete_Time(year+month+day);
 }
    if(!cEnEnt_Customer_request.getDtRequest_Time().equals("")){
        String year=cEnEnt_Customer_request.getDtRequest_Time().substring(0,4);
        String month=cEnEnt_Customer_request.getDtRequest_Time().substring(5,7);
        String day=cEnEnt_Customer_request.getDtRequest_Time().substring(8,10);
        cEnEnt_Customer_request.setDtRequest_Time(year+month+day);
    }
    request.setAttribute("cEnEnt_Customer_request",cEnEnt_Customer_request);
    request.setAttribute("doType","modify");
    return this.getTargetPage("detail");
  }

  public String modify(HttpServletRequest request, HttpServletResponse response) throws Exception
  {
    EnEnt_Customer_request cEnEnt_Customer_request = (EnEnt_Customer_request)request.getAttribute("cEnEnt_Customer_request");
    DbAccess db = new DbAccess();
    try
    {
      db.beginTransaction();
      DAOBase.update(db,cEnEnt_Customer_request);
      db.commit();
    }
    catch(Exception ex)
    {
      db.rollback();
      throw ex;
    }
    levin.iMessage msg = levin.iMessage.getNewInstance("客户请求",
        "修改成功.",
        "openTop(\"GDPE.customer.request.ActionEnt_Customer_request.do?doType=summary\");");
    msg.save(request);
    return this.getTargetPage("Message");
  }

  public String view(HttpServletRequest request, HttpServletResponse response) throws Exception
  {
    String id = request.getParameter("id");
    EnEnt_Customer_request cEnEnt_Customer_request = (EnEnt_Customer_request)DAOBase.findByPK(new DbAccess(),EnEnt_Customer_request.class.getName(),id);
		if(!cEnEnt_Customer_request.getDtComplete_Time().equals(""))
	    {
	        String year=cEnEnt_Customer_request.getDtComplete_Time().substring(0,4);
	        String month=cEnEnt_Customer_request.getDtComplete_Time().substring(6,7);
	        String day=cEnEnt_Customer_request.getDtComplete_Time().substring(9,10);
	        cEnEnt_Customer_request.setDtComplete_Time(year+month+day);
	    }
		if(!cEnEnt_Customer_request.getDtCommitTime().equals(""))
	    {
	        String year=cEnEnt_Customer_request.getDtCommitTime().substring(0,4);
	        String month=cEnEnt_Customer_request.getDtCommitTime().substring(6,7);
	        String day=cEnEnt_Customer_request.getDtCommitTime().substring(9,10);
	        cEnEnt_Customer_request.setDtCommitTime(year+month+day);
	    }
		if(!cEnEnt_Customer_request.getDtRequest_Time().equals(""))
	    {
	        String year=cEnEnt_Customer_request.getDtRequest_Time().substring(0,4);
	        String month=cEnEnt_Customer_request.getDtRequest_Time().substring(6,7);
	        String day=cEnEnt_Customer_request.getDtRequest_Time().substring(9,10);
	        cEnEnt_Customer_request.setDtRequest_Time(year+month+day);
	    }
    
    request.setAttribute("cEnEnt_Customer_request",cEnEnt_Customer_request);
    request.setAttribute("doType","view");
    return this.getTargetPage("detail");
  }

  public String delete(HttpServletRequest request, HttpServletResponse response) throws Exception
  {
    String id = request.getParameter("id");
    DbAccess db = new DbAccess();
    try
    {   
      db.beginTransaction();
      StringTokenizer st = new StringTokenizer(id,",");
      while(st.hasMoreElements()){
    	  String index = (String)st.nextElement();
    	  DAOBase.delete(db,EnEnt_Customer_request.class.getName(),index);
      }     
      db.commit();
    }
    catch(Exception ex)
    {
      db.rollback();
      throw ex;
    }
    levin.iMessage msg = levin.iMessage.getNewInstance("客户请求",
        "删除成功.",
        "openTop(\"GDPE.customer.request.ActionEnt_Customer_request.do?doType=summary\");");
    msg.save(request);     
    return this.getTargetPage("Message");
  }
  public String search(HttpServletRequest request,
			HttpServletResponse response) throws Exception {
		levin.util.DbAccess db = new levin.util.DbAccess();	
		String chRequest_Tile = request.getParameter("chRequest_Tile");
		String chCustomer_Linkman_Tele = request.getParameter("chCustomer_Linkman_Tele");
		String dtRequest_Time = request.getParameter("startTime");

		EnEnt_Customer_request searchRequest = new EnEnt_Customer_request();

		searchRequest.setChRequest_Tile(chRequest_Tile);
		searchRequest.setChCustomer_Linkman_Tele(chCustomer_Linkman_Tele);
		if(!dtRequest_Time.equals("")){
			String year = dtRequest_Time.substring(0,4);   
			String month = dtRequest_Time.substring(5,6); 
			String day = dtRequest_Time.substring(6,8);
			//System.out.println("Time ================================================"+year+"-"+month+"-"+day);
			//System.out.println("++++++++++++++++++++++++++++"+month);
			String request_Time = year.concat("-").concat(month).concat("-").concat(day);
			searchRequest.setDtRequest_Time(request_Time);
			//System.out.println("request_Time========================================"+searchRequest.getDtRequest_Time());
		}

		EnEnt_Customer_request aEnEnt_Customer_request[] = (EnEnt_Customer_request[]) (DAORequest
				.searcheEnRequest(db, searchRequest));
		for(int i = 0;i<aEnEnt_Customer_request.length;i++){
			if(!aEnEnt_Customer_request[i].getDtComplete_Time().equals("")){
		        String year=aEnEnt_Customer_request[i].getDtComplete_Time().substring(0,4);
		        String month=aEnEnt_Customer_request[i].getDtComplete_Time().substring(5,7);
		        String day=aEnEnt_Customer_request[i].getDtComplete_Time().substring(8,10);
		        aEnEnt_Customer_request[i].setDtComplete_Time(year+month+day);
		    }
			if(!aEnEnt_Customer_request[i].getDtCommitTime().equals("")){
		        String year=aEnEnt_Customer_request[i].getDtCommitTime().substring(0,4);
		        String month=aEnEnt_Customer_request[i].getDtCommitTime().substring(5,7);
		        String day=aEnEnt_Customer_request[i].getDtCommitTime().substring(8,10);
		        aEnEnt_Customer_request[i].setDtCommitTime(year+month+day);
		    } 
			if(!aEnEnt_Customer_request[i].getDtRequest_Time().equals("")){
		        String year=aEnEnt_Customer_request[i].getDtRequest_Time().substring(0,4);
		        String month=aEnEnt_Customer_request[i].getDtRequest_Time().substring(5,7);
		        String day=aEnEnt_Customer_request[i].getDtRequest_Time().substring(8,10);
		        aEnEnt_Customer_request[i].setDtRequest_Time(year+month+day);
		    }
		}

		request.setAttribute("aEnEnt_Customer_request",aEnEnt_Customer_request);
		request.setAttribute("chooseType", "checkbox");
		request.setAttribute("doType", "search");
		return this.getTargetPage("summary");

	}
  public String enterpriseAdvice(HttpServletRequest request,
			HttpServletResponse response) throws Exception {
	  
	    levin.util.DbAccess db = new levin.util.DbAccess();	
		String iEnterpriseId = request.getParameter("iEnterpriseId");
		
		StringTokenizer st = new StringTokenizer(iEnterpriseId,",");
		//System.out.println("iEnterpriseId----------1-"+iEnterpriseId);
		
		//EnEnt_Customer_request searchRequest = new EnEnt_Customer_request();
		
		//searchRequest.setIEnterpriseId( Integer.parseInt(iEnterpriseId));
		
		//EnEnt_Customer_request aEnEnt_Customer_request[] = (EnEnt_Customer_request[]) (DAORequest
				//.searcheEnRequest(db, searchRequest));
		String sql = "select * from yang.Ent_Customer_request where iEnterpriseId = "+iEnterpriseId; 
		DataSet ds = db.executeQuery(sql);
		EnEnt_Customer_request[] aEnEnt_Customer_request = (EnEnt_Customer_request[]) DAOBase.resumeFromDataSet(ds, EnEnt_Customer_request.class.getName());
		for(int i=0;i<aEnEnt_Customer_request.length;i++){
	    	if(!aEnEnt_Customer_request[i].getDtCommitTime().equals(""))
	    		aEnEnt_Customer_request[i].setDtCommitTime(aEnEnt_Customer_request[i].getDtCommitTime().substring(0,10));
	    	if(!aEnEnt_Customer_request[i].getDtComplete_Time().equals(""))
	    		aEnEnt_Customer_request[i].setDtComplete_Time(aEnEnt_Customer_request[i].getDtComplete_Time().substring(0,10));
	    	if(!aEnEnt_Customer_request[i].getDtRequest_Time().equals(""))
	    		aEnEnt_Customer_request[i].setDtRequest_Time(aEnEnt_Customer_request[i].getDtRequest_Time().substring(0,10));
	  
	        if(aEnEnt_Customer_request[i].getDtCommitTime().startsWith("1900"))
	        	aEnEnt_Customer_request[i].setDtCommitTime("");
	        if(aEnEnt_Customer_request[i].getDtComplete_Time().startsWith("1900"))
	        	aEnEnt_Customer_request[i].setDtComplete_Time("");
	        if(aEnEnt_Customer_request[i].getDtRequest_Time().startsWith("1900"))
	        	aEnEnt_Customer_request[i].setDtRequest_Time("");
		 }
	    request.setAttribute("aEnEnt_Customer_request",aEnEnt_Customer_request);
		request.setAttribute("chooseType", "checkbox");
		return this.getTargetPage("summary");
  }
}