actionent_record_contract.java

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

 package GDPE.contract.manager;

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

import javax.servlet.http.*;

import java.util.Calendar;
import java.util.StringTokenizer;
import levin.UserInfo;
import java.util.Date;
import java.text.DateFormat;
import java.text.Format;
import java.text.SimpleDateFormat;
import java.util.Locale;
import java.sql.*;

public class ActionEnt_Record_Contract extends Service
{  
  public ActionEnt_Record_Contract()
  {
  }
  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
  {
      EnEnt_Record_Contract aEnEnt_Record_Contract[] = (EnEnt_Record_Contract[])(DAOBase.findByCondition(new DbAccess(),EnEnt_Record_Contract.class.getName(),"","dtRecordTime desc"));
    //EnEnt_Record_Contract aEnEnt_Record_Contract[] = (EnEnt_Record_Contract[])(DAOBase.findAll(new DbAccess(),EnEnt_Record_Contract.class.getName()));
      // System.out.print("shijian-------2---------"+aEnEnt_Record_Contract[0].getDtContractBeginTime());
       for(int i=0;i<aEnEnt_Record_Contract.length;i++)
       {
       if(!aEnEnt_Record_Contract[i].getDtContractBeginTime().equals(""))
           aEnEnt_Record_Contract[i].setDtContractBeginTime(aEnEnt_Record_Contract[i].getDtContractBeginTime().substring(0,10));
       if(!aEnEnt_Record_Contract[i].getDtContractEndTime().equals(""))
           aEnEnt_Record_Contract[i].setDtContractEndTime(aEnEnt_Record_Contract[i].getDtContractEndTime().substring(0,10));
       if(!aEnEnt_Record_Contract[i].getDtRecordTime().equals(""))
           aEnEnt_Record_Contract[i].setDtRecordTime(aEnEnt_Record_Contract[i].getDtRecordTime().substring(0,10));

       if(aEnEnt_Record_Contract[i].getDtContractBeginTime().startsWith("1900"))
           aEnEnt_Record_Contract[i].setDtContractBeginTime("");
       if(aEnEnt_Record_Contract[i].getDtContractEndTime().startsWith("1900"))
           aEnEnt_Record_Contract[i].setDtContractEndTime("");
       if(aEnEnt_Record_Contract[i].getDtRecordTime().startsWith("1900"))
           aEnEnt_Record_Contract[i].setDtRecordTime("");
       }
       
       
    request.setAttribute("aEnEnt_Record_Contract", aEnEnt_Record_Contract);
    request.setAttribute("chooseType","checkbox");
    return this.getTargetPage("summary");
  }
  public String addQuery(HttpServletRequest request, HttpServletResponse response) throws Exception
  {
    HttpSession session = request.getSession(false);
    UserInfo userInfor = (UserInfo) session.getAttribute("UserInfo_Object");
    EnEnt_Record_Contract cEnEnt_Record_Contract = new EnEnt_Record_Contract();
    cEnEnt_Record_Contract.setChRecordUserId(userInfor.getId());
    cEnEnt_Record_Contract.setChRecordUserName(userInfor.getName());
    java.sql.Date now = new java.sql.Date(System.currentTimeMillis());
      
    
      
    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
   //- SimpleDateFormat sdf=new SimpleDateFormat("dd-Mon-yyyy");
    //Calendar c=Calendar.getInstance();
    String timestamp = sdf.format(now);
    
    //java.sql.Date now1=java.sql.Date.valueOf(timestamp);
    //System.out.println("ssssssssssssssss:-------"+now1.toString()+"--"+timestamp);
    
    cEnEnt_Record_Contract.setDtRecordTime(timestamp);
    //request.setAttribute("dtContractBeginTime","null");"TO_DATE('"+timestamp.trim()+"','dd-mm-yyyy')"
   // request.setAttribute("dtContractEndTime","########");, Locale.SIMPLIFIED_CHINESE
    //request.setAttribute("dtRecordTime",timestamp);
    request.setAttribute("cEnEnt_Record_Contract", cEnEnt_Record_Contract);
    request.setAttribute("doType","add");
    return this.getTargetPage("detail");
  }

  public String add(HttpServletRequest request, HttpServletResponse response) throws Exception
  {
     String chContractNo = request.getParameter("chContractNo");
     EnEnt_Record_Contract searchContract = new  EnEnt_Record_Contract();
     searchContract.setChContractNo(chContractNo);
     String sqlCondition = "chContractNo = '"+chContractNo+"'";
     String order = "chContractNo desc";
     EnEnt_Record_Contract[] aEnEnt_Record_Contract = (EnEnt_Record_Contract[])(DAOBase.findByCondition(new DbAccess(),EnEnt_Record_Contract.class.getName(),sqlCondition,order));
     if(aEnEnt_Record_Contract.length!=0){
        levin.iMessage msg = levin.iMessage.getNewInstance("合同管理",
        "有相同合同编号,请输入前校验.", "openTop(\"GDPE.contract.manager.ActionEnt_Record_Contract.do?doType=addQuery\");");
         msg.save(request);
         return this.getTargetPage("Message");
     }
    
    EnEnt_Record_Contract cEnEnt_Record_Contract = (EnEnt_Record_Contract)request.getAttribute("cEnEnt_Record_Contract");
   // System.out.print("---8--->"+cEnEnt_Record_Contract.getDtRecordTime()+"%%%%%");
    DbAccess db = new DbAccess();
    try
    {
      db.beginTransaction();
      DAOBase.insert(db,cEnEnt_Record_Contract);
      db.commit();
    }
    catch(Exception ex)
    {
      db.rollback();
      throw ex;
    }
    levin.iMessage msg = levin.iMessage.getNewInstance("合同管理",
        "新增成功.",
        "openTop(\"GDPE.contract.manager.ActionEnt_Record_Contract.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 chContractNo = request.getParameter("chContractNo");
    String chEnterpriseName = request.getParameter("chEnterpriseName");
    String chContractFollowUserName = request.getParameter("chContractFollowUserName");
    String startTime = request.getParameter("startTime");
    String endTime = request.getParameter("endTime");
    String chProtocol = request.getParameter("chProtocol");
    String chLoginStationName = request.getParameter("chLoginStationName");
    
    //System.out.print("startTime----1------->"+startTime);
    //Format f=new SimpleDateFormat("yyyy-MM-dd");
    //Date d=new Date();
    
    //System.out.print("-------?> d----"+d.toString());
    //String s=f.format(startTime);
    //System.out.print("startTime------2----->"+s);
    
    EnEnt_Record_Contract searchContract = new  EnEnt_Record_Contract();

    searchContract.setChContractNo(chContractNo);
    searchContract.setChEnterpriseName(chEnterpriseName);
    searchContract.setChContractFollowUserName(chContractFollowUserName);
    searchContract.setChProtocol(chProtocol);
    searchContract.setChLoginStationName(chLoginStationName);

    EnEnt_Record_Contract aEnEnt_Record_Contract [] = ( EnEnt_Record_Contract[]) (DAOContract.searcheEnContract(db, searchContract,startTime,endTime));

    for(int i=0;i<aEnEnt_Record_Contract.length;i++)
     {
     if(!aEnEnt_Record_Contract[i].getDtContractBeginTime().equals(""))
         aEnEnt_Record_Contract[i].setDtContractBeginTime(aEnEnt_Record_Contract[i].getDtContractBeginTime().substring(0,10));
     if(!aEnEnt_Record_Contract[i].getDtContractEndTime().equals(""))
         aEnEnt_Record_Contract[i].setDtContractEndTime(aEnEnt_Record_Contract[i].getDtContractEndTime().substring(0,10));
     if(!aEnEnt_Record_Contract[i].getDtRecordTime().equals(""))
         aEnEnt_Record_Contract[i].setDtRecordTime(aEnEnt_Record_Contract[i].getDtRecordTime().substring(0,10));

     if(aEnEnt_Record_Contract[i].getDtContractBeginTime().startsWith("1900"))
         aEnEnt_Record_Contract[i].setDtContractBeginTime("");
     if(aEnEnt_Record_Contract[i].getDtContractEndTime().startsWith("1900"))
         aEnEnt_Record_Contract[i].setDtContractEndTime("");
     if(aEnEnt_Record_Contract[i].getDtRecordTime().startsWith("1900"))
        aEnEnt_Record_Contract[i].setDtRecordTime("");
       }

    request.setAttribute("aEnEnt_Record_Contract", aEnEnt_Record_Contract);

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

  }

  public String modifyQuery(HttpServletRequest request, HttpServletResponse response) throws Exception
  {

    String chContractNo = request.getParameter("chContractNo");
    EnEnt_Record_Contract cEnEnt_Record_Contract = (EnEnt_Record_Contract)DAOBase.findByPK(new DbAccess(),EnEnt_Record_Contract.class.getName(),chContractNo);
    if(!cEnEnt_Record_Contract.getDtContractBeginTime().equals(""))
    {
        String year=cEnEnt_Record_Contract.getDtContractBeginTime().substring(0,4);
        String month=cEnEnt_Record_Contract.getDtContractBeginTime().substring(5,7);
        String day=cEnEnt_Record_Contract.getDtContractBeginTime().substring(8,10);
        cEnEnt_Record_Contract.setDtContractBeginTime(year+month+day);
    }

    if(!cEnEnt_Record_Contract.getDtContractEndTime().equals(""))
 {
     String year=cEnEnt_Record_Contract.getDtContractEndTime().substring(0,4);
     String month=cEnEnt_Record_Contract.getDtContractEndTime().substring(5,7);
     String day=cEnEnt_Record_Contract.getDtContractEndTime().substring(8,10);
     cEnEnt_Record_Contract.setDtContractEndTime(year+month+day);
 }



    request.setAttribute("cEnEnt_Record_Contract",cEnEnt_Record_Contract);
    request.setAttribute("doType","modify");
    return this.getTargetPage("detail");
  }

  public String modify(HttpServletRequest request, HttpServletResponse response) throws Exception
  {
    EnEnt_Record_Contract cEnEnt_Record_Contract = (EnEnt_Record_Contract)request.getAttribute("cEnEnt_Record_Contract");
    if(!cEnEnt_Record_Contract.getDtRecordTime().equals(""))
    {
        String year=cEnEnt_Record_Contract.getDtRecordTime().substring(0,4);
        String month=cEnEnt_Record_Contract.getDtRecordTime().substring(5,7);
        String day=cEnEnt_Record_Contract.getDtRecordTime().substring(8,10);
        cEnEnt_Record_Contract.setDtRecordTime(year+month+day);
    }
   // System.out.println("c-----------------------------------------2->"+cEnEnt_Record_Contract.getDtRecordTime());
    DbAccess db = new DbAccess();
    try
    {
      db.beginTransaction();
      DAOBase.update(db,cEnEnt_Record_Contract);
      db.commit();
    }
    catch(Exception ex)
    {
      db.rollback();
      throw ex;
    }
    levin.iMessage msg = levin.iMessage.getNewInstance("合同管理",
        "修改成功.",
        "openTop(\"GDPE.contract.manager.ActionEnt_Record_Contract.do?doType=summary\");");
    msg.save(request);
    return this.getTargetPage("Message");
  }

  public String view(HttpServletRequest request, HttpServletResponse response) throws Exception
  {
    String chContractNo = request.getParameter("chContractNo");
    EnEnt_Record_Contract cEnEnt_Record_Contract = (EnEnt_Record_Contract)DAOBase.findByPK(new DbAccess(),EnEnt_Record_Contract.class.getName(),chContractNo);
    if(!cEnEnt_Record_Contract.getDtContractBeginTime().equals(""))
    {
        String year=cEnEnt_Record_Contract.getDtContractBeginTime().substring(0,4);
        String month=cEnEnt_Record_Contract.getDtContractBeginTime().substring(5,7);
        String day=cEnEnt_Record_Contract.getDtContractBeginTime().substring(8,10);
        cEnEnt_Record_Contract.setDtContractBeginTime(year+month+day);
    }

    if(!cEnEnt_Record_Contract.getDtContractEndTime().equals(""))
 {
     String year=cEnEnt_Record_Contract.getDtContractEndTime().substring(0,4);
     String month=cEnEnt_Record_Contract.getDtContractEndTime().substring(5,7);
     String day=cEnEnt_Record_Contract.getDtContractEndTime().substring(8,10);
     cEnEnt_Record_Contract.setDtContractEndTime(year+month+day);
 }


    request.setAttribute("cEnEnt_Record_Contract",cEnEnt_Record_Contract);
    request.setAttribute("doType","view");
    return this.getTargetPage("detail");
  }

  public String delete(HttpServletRequest request, HttpServletResponse response) throws Exception
  {
    String chContractNo = request.getParameter("chContractNo");
    DbAccess db = new DbAccess();
    try
    {
      db.beginTransaction();
      StringTokenizer st = new StringTokenizer(chContractNo, ",");//
      while (st.hasMoreElements()) {
            String index = (String) st.nextElement();
            DAOBase.delete(db,EnEnt_Record_Contract.class.getName(), index);
        }
      db.commit();
    }
    catch(Exception ex)
    {
      db.rollback();
      throw ex;
    }
    levin.iMessage msg = levin.iMessage.getNewInstance("合同管理",
        "删除成功.",
        "openTop(\"GDPE.contract.manager.ActionEnt_Record_Contract.do?doType=summary\");");
    msg.save(request);
    return this.getTargetPage("Message");
  }

 public String check(HttpServletRequest request, HttpServletResponse response)
    throws Exception
{
     String chContractNo = request.getParameter("chContractNo");

     EnEnt_Record_Contract searchContract = new  EnEnt_Record_Contract();

     searchContract.setChContractNo(chContractNo);
     String sqlCondition = "chContractNo = '"+chContractNo+"'";
     String order = "chContractNo desc";

     EnEnt_Record_Contract[] aEnEnt_Record_Contract = (EnEnt_Record_Contract[])(DAOBase.findByCondition(new DbAccess(),EnEnt_Record_Contract.class.getName(),sqlCondition,order));

     EnEnt_Record_Contract cEnEnt_Record_Contract = new EnEnt_Record_Contract();
     cEnEnt_Record_Contract.setChContractNo(chContractNo);

     request.setAttribute("cEnEnt_Record_Contract",cEnEnt_Record_Contract);
     if(aEnEnt_Record_Contract.length==0){
          //levin.iMessage msg = levin.iMessage.getNewInstance("合同管理",
        // "没有相同编号.", "closeWindow();");
        levin.iMessage msg = levin.iMessage.getNewInstance("合同管理",
        "没有相同编号.", "closeSelf()");
          msg.save(request);
          return this.getTargetPage("Message");

     }else{

        // levin.iMessage msg = levin.iMessage.getNewInstance("合同管理",
       // "有相同编号.", "openWindow(\"GDPE.contract.manager.ActionEnt_Record_Contract.do?doType=addQuery&chContractNo="+chContractNo+"\");");

        levin.iMessage msg = levin.iMessage.getNewInstance("合同管理",
        "有相同编号.", "closeSelf()");
          msg.save(request);
         return this.getTargetPage("Message");
     }

  }

}