schedule.java

哈工大CERP系统Java源码及开发说明.rar 内容十分详尽

package com.huiton.mainframe.control.web.handlers;

/**
 * Title:        CERP测试框架
 * Description:  处理工作日程
 * Copyright:    Copyright (c) 2002
 * Company:      BRITC
 * @author 张爱军
 * @version 1.0
 */
import com.huiton.pub.dbx.*;
import java.sql.*;
import java.util.*;
import com.huiton.cerp.pub.util.functions.*;
import javax.servlet.http.*;
import com.huiton.mainframe.util.tracer.Debug;

public abstract class Schedule
{

    protected static final int times = 3; // times try to get pageQuery

    //成员
    protected PageQuery pageQuery = null;
    protected String companyCode = null ; //公司
    protected String userUniqueNo = null ; //用户唯一号
    protected String strFields = null ; //查询字段
    protected String strTables = null ; //查询的表
    protected ResultSet rs = null; //结果集
    protected String opFlag = null; //操作标记
    protected String outFlag = "1"; //操作结果标记
    protected String sql = null; //查询串
    protected int pageSize = 15; //每页显示数
    protected String condition = "" ;  // 查询条件
    protected String strToday = null ; //当日
    protected Vector vct = null; //

    //构造器
    public Schedule(String companyCode,String userUniqueNo)
    {
        created();
        this.companyCode = companyCode ;
        this.userUniqueNo = userUniqueNo ;
    }

    //禁用的构造器
    public Schedule() throws Exception
    {
        throw new Exception("The right usage is Schedule(companyCode,userUniqueNo)");
    }

    //pageQuery initialize
    private boolean created()
    {
        try
        {
            for (int i=0; i<times && (pageQuery==null) ;i++)
            {
                pageQuery = new PageQuery("","sam");
            }
            return true ;
        }
        catch (Exception e)
        {
            return false ;
        }
    }

    //公开方法

    //新增
    public void addNew(HttpServletRequest request)
    {
        m_initParams(request);
        m_addNew(request);
        m_setAttr(request);
    }

    //插入
    public void insert(HttpServletRequest request)
    {
        m_initParams(request);
        m_insert(request);
        m_query(request);
        m_setAttr(request);

    }

    //保存继续
    public void insMore(HttpServletRequest request)
    {
        m_initParams(request);
        m_insert(request);
        m_addNew(request);
        m_setAttr(request);
    }

    //修改
    public void modify(HttpServletRequest request)
    {
        m_initParams(request);
        m_modify(request);
        m_setAttr(request);
    }

     //更新
    public void update(HttpServletRequest request)
    {
        m_initParams(request);
        m_update(request);
        m_query(request);
        m_setAttr(request);
    }

     //删除
    public void delete(HttpServletRequest request)
    {
        m_initParams(request);
        m_delete(request);
        m_query(request);
        m_setAttr(request);
    }

     //全删
    public void delAll(HttpServletRequest request)
    {
        m_initParams(request);
        m_delAll(request);
        m_setAttr(request);
    }

     //查看一条记录
    public void  review(HttpServletRequest request)
    {
        //修改
        modify(request);
    }

     //查询
    public void  query(HttpServletRequest request)
    {
        m_initParams(request);
        m_query(request);
        m_setAttr(request);
    }

    //保护方法
    //删除
    protected void m_delete(HttpServletRequest request)
    {
        try
        {
            // 删除选中记录
            String [] id = request.getParameterValues("id");
            if (id !=null)
            {
                    for (int ii=0;ii<id.length;ii++)
                    {

                        String delSql = "delete from sam_user_event "
                            + " where company_code='" + companyCode
                            + "' and log_no=" + id[ii];

                        pageQuery.simpleUpdate(delSql);
                    }
            }

        }
        catch(Exception e)
        {
            Debug.println("delete failed");
            outFlag = "0" ;
        }

    }

    //新增
    protected void m_addNew(HttpServletRequest request)
    {
        vct = null;

        try
        {
            pageQuery.getData("event_code,event_name",
                    "sam_event_type",
                    "company_code='" + companyCode + "'",100);

            vct = pageQuery.dividePage(1,100);
        }
        catch(Exception e)
        {}
    }

    //修改
    protected void m_modify(HttpServletRequest request)
    {
        try
        {
            String id = request.getParameter("m_id");
                id = (id==null ? "" : id.trim());
                if (id.length()<1) // error
                {
                    outFlag = "0";
                }
                else
                {
                    sql = "select cur_date,start_time,stop_time,event_subject,"
                        + "event_location,event_code,"
                        + "alert_days,event_desc,deal_desc,deal_flag,priv_flag "
                        + " from sam_user_event where company_code='" + companyCode
                        + "' and log_no=" + id ;

                    Debug.println("sql=" + sql);
                    rs = pageQuery.getData(sql);