schedule.java

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

                    if (rs != null && rs.next())
                    {

                        request.setAttribute("m_id",id);
                        request.setAttribute("cur_date",rs.getString(1));
                        request.setAttribute("start_time",rs.getString(2));
                        request.setAttribute("stop_time",rs.getString(3));
                        request.setAttribute("event_subject",rs.getString(4));
                        request.setAttribute("event_location",rs.getString(5));
                        request.setAttribute("event_code",rs.getString(6));
                        request.setAttribute("alert_days",rs.getInt(7)+"");
                        request.setAttribute("event_desc",rs.getString(8));
                        request.setAttribute("deal_desc",rs.getString(9));
                        request.setAttribute("deal_flag",rs.getString(10));
                        request.setAttribute("priv_flag",rs.getString(11));

                        outFlag = "1";

                    }else
                    {
                        outFlag = "0";
                    }
                }

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

                vct = pageQuery.dividePage(1,100);
        }
        catch(Exception e)
        {
            Debug.println("modify failed");
            outFlag = "0" ;
        }

    }

    //更新
    protected void m_update(HttpServletRequest request)
    {
        try
        {
                //处理传入的参数
                String cur_date = request.getParameter("cur_date");
                String start_hour = request.getParameter("start_hour");
                String stop_hour = request.getParameter("stop_hour");
                String start_min = request.getParameter("start_min");
                String stop_min = request.getParameter("stop_min");
                String alert_days = request.getParameter("alert_days");
                String event_code = request.getParameter("event_code");
                String event_subject = request.getParameter("event_subject");
                String event_location = request.getParameter("event_location");
                String event_desc = request.getParameter("event_desc");
                String deal_desc = request.getParameter("deal_desc");
                String deal_flag = request.getParameter("deal_flag");
                String priv_flag = request.getParameter("priv_flag");

                cur_date = (cur_date==null ? "" : cur_date.trim());
                start_hour = (start_hour==null ? "" : start_hour.trim());
                stop_hour = (stop_hour==null ? "" : stop_hour.trim());
                start_min = (start_min==null ? "" : start_min.trim());
                stop_min = (stop_min==null ? "" : stop_min.trim());
                alert_days = (alert_days==null ? "" : alert_days.trim());
                event_code = (event_code==null ? "" : event_code.trim());
                event_subject = (event_subject==null ? "" : event_subject.trim());
                event_location = (event_location==null ? "" : event_location.trim());
                event_desc = (event_desc==null ? "" : event_desc.trim());
                deal_desc = (deal_desc==null ? "" : deal_desc.trim());
                deal_flag = (deal_flag==null ? "" : deal_flag.trim());
                priv_flag = (priv_flag==null ? "" : priv_flag.trim());

                cur_date = (cur_date.length()<1 ? strToday : cur_date);
                deal_flag = (deal_flag.length()<1 ? "N" : deal_flag);
                priv_flag = (priv_flag.length()<1 ? "N" : priv_flag);
                alert_days = (alert_days.length()<1 ? "0" : alert_days);

                String mColon = new CommonDate().getColon(); //小时分钟分隔符 :
                String start_time = start_hour + mColon + start_min;
                String stop_time = stop_hour + mColon + stop_min;

                String log_no = request.getParameter("m_id");
                log_no = (log_no==null ? "" : log_no.trim());

                // get event_code,event_name from event_code
                int pos = event_code.indexOf("__");
                int len = event_code.length();
                String event_name = "" ;
                if (pos >= 0)
                {
                    event_name = event_code.substring(pos+2,len);
                    event_code = event_code.substring(0,pos);
                }
                // 得到event_name

                if (log_no.length()<1 || event_code.length()<1 || event_subject.length()<1)
                {
                    outFlag = "0" ;

                }else
                {
                    sql = "update sam_user_event set cur_date='" + cur_date
                        + "',start_time='" + start_time + "',stop_time='" + stop_time
                        + "',alert_days=" + alert_days + ",event_code='" + event_code
                        + "',event_name='" + event_name + "',event_subject='" + event_subject
                        + "',event_location='" + event_location + "',event_desc='" + event_desc
                        + "',deal_desc='" + deal_desc + "',deal_flag='" + deal_flag
                        + "',priv_flag='" + priv_flag + "' where company_code='" + companyCode
                        + "' and log_no=" + log_no ;

                    Debug.println("sql="+sql);
                    boolean bFlag = pageQuery.simpleUpdate(sql);
                    outFlag = (bFlag ? "1" : "0");
                }
        }
        catch(Exception e)
        {
            Debug.println("update failed");
            outFlag = "0" ;
        }

    }

    //插入
    protected void m_insert(HttpServletRequest request)
    {
        try
        {
                //处理传入的参数
                String cur_date = request.getParameter("cur_date");
                String start_hour = request.getParameter("start_hour");
                String stop_hour = request.getParameter("stop_hour");
                String start_min = request.getParameter("start_min");
                String stop_min = request.getParameter("stop_min");
                String alert_days = request.getParameter("alert_days");
                String event_code = request.getParameter("event_code");
                String event_subject = request.getParameter("event_subject");
                String event_location = request.getParameter("event_location");
                String event_desc = request.getParameter("event_desc");
                String deal_desc = request.getParameter("deal_desc");
                String deal_flag = request.getParameter("deal_flag");
                String priv_flag = request.getParameter("priv_flag");

                cur_date = (cur_date==null ? "" : cur_date.trim());
                start_hour = (start_hour==null ? "" : start_hour.trim());
                stop_hour = (stop_hour==null ? "" : stop_hour.trim());
                start_min = (start_min==null ? "" : start_min.trim());
                stop_min = (stop_min==null ? "" : stop_min.trim());
                alert_days = (alert_days==null ? "" : alert_days.trim());
                event_code = (event_code==null ? "" : event_code.trim());
                event_subject = (event_subject==null ? "" : event_subject.trim());
                event_location = (event_location==null ? "" : event_location.trim());
                event_desc = (event_desc==null ? "" : event_desc.trim());
                deal_desc = (deal_desc==null ? "" : deal_desc.trim());
                deal_flag = (deal_flag==null ? "" : deal_flag.trim());
                priv_flag = (priv_flag==null ? "" : priv_flag.trim());

                cur_date = (cur_date.length()<1 ? strToday : cur_date);
                deal_flag = (deal_flag.length()<1 ? "N" : deal_flag);
                priv_flag = (priv_flag.length()<1 ? "N" : priv_flag);
                alert_days = (alert_days.length()<1 ? "0" : alert_days);

                String mColon = new CommonDate().getColon(); //小时分钟分隔符 :
                String start_time = start_hour + mColon + start_min;
                String stop_time = stop_hour + mColon + stop_min;

                // get event_code,event_name from event_code
                int pos = event_code.indexOf("__");
                int len = event_code.length();
                String event_name = "" ;
                if (pos >= 0)
                {
                    event_name = event_code.substring(pos+2,len);
                    event_code = event_code.substring(0,pos);
                }
                // 得到event_name

                Debug.println("insert now");
                if (event_code.length()<1 || event_subject.length()<1)
                {
                    Debug.println("event_code="+event_code+",event_subject="+event_subject);
                    outFlag = "0" ;
                }else
                {
                    sql = "insert into sam_user_event(company_code,log_no,user_unique_no,cur_date,"
                        + "start_time,stop_time,event_subject,event_location,event_code,event_name,"
                        + "alert_days,event_desc,deal_desc,deal_flag,priv_flag) "
                        + " values('" + companyCode + "'," + CerpGetNo.getNo(companyCode,"sam_user_event")
                        + ",'" + userUniqueNo + "','" + cur_date + "','" + start_time + "','" + stop_time
                        + "','" + event_subject + "','" + event_location + "','" + event_code
                        + "','" + event_name + "'," + alert_days + ",'" + event_desc + "','"
                        + deal_desc + "','" + deal_flag + "','" + priv_flag + "')" ;

                    Debug.println("sql=" + sql);
                    boolean bFlag = pageQuery.simpleUpdate(sql);
                    outFlag = (bFlag ? "1" : "0");

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

    }

    protected abstract void  m_initParams(HttpServletRequest request);
    protected abstract void  m_setAttr(HttpServletRequest request);
    protected abstract void  m_query(HttpServletRequest request);
    protected abstract void  m_delAll(HttpServletRequest request);
}