transact_control.jsp

一个做得非常好的电子政务系统

<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="com.ijipin.tool.*" %>
<%@ page import="com.ijipin.database.*" %>
<%@ page import="com.ijipin.property.*" %>
<%@ include file="/userinfor.jsp" %>
<%@ page import="com.ijipin.oa.document.*" %>
<%@ page import="com.ijipin.flow.*" %>
<%
    final String strLevel = Draft.strLevel;  //本页所在的层次
    final int iModuleID   = Draft.iModuleID;
    String strLink_action = "transact_list.jsp";
    String strSWLB = "38";
%>
<%@ include file="/share/page/page_request_upload.jsp" %>
<%@include file="/share/page/page_form_upload.jsp"%>
<%
    String strMessage = "操作出现异常！";
    boolean flag = false;
    if (strACTION.equals("ADD")) {
        strACTION = "UPDATE";
    }
    String mBLID = Convert.toZeroStr(mySmartUpload.getRequest().getParameter("BLID")).trim();
    String mRecordID = Convert.uploadGBK(mySmartUpload.getRequest().getParameter("RECORDID")).trim();
    String ISSEND = Convert.toZeroStr(mySmartUpload.getRequest().getParameter("ISSEND")).trim();
%>
<%
    DataConn dataConn = new DataConn();
    try {
        ////2004-04-22
        FieldInfor fieldInfor = null;
        Field field = new Field(dataConn);

        String sCond = "ZDSX="+iModuleID + " ORDER BY ZDBJSX";
        Collection collField = field.getList(sCond);
        int iFieldCount = collField.size();
        Iterator iterField = collField.iterator();

        String str_value = "";   //临时变量，放字段的值
        String str_field = "";   //字段的名称
        String str_type  = "";   //字段类型
        String key_field = "";
        String key_value = "0";
        int    key_index = 0;

        Module module = new Module(dataConn);
        moduleInfor_session = (ModuleInfor)module.getInfor(iModuleID);
        String sTable = moduleInfor_session.getSXBM();
        String field_str[] = new String[iFieldCount];
        String value_str[] = new String[iFieldCount];

        iFieldCount = 0;
        while (iterField != null && iterField.hasNext()) {
            fieldInfor = (FieldInfor)iterField.next();
            //////列表
            str_value = Convert.uploadGBK(mySmartUpload.getRequest().getParameter(fieldInfor.getZDMC())).trim();

            if (!fieldInfor.getZDLX().equals("int")) {
                str_value = "'" + str_value + "'";
            } else {
                str_value = Convert.toZeroStr(str_value);
            }

            ///关键字
            if (fieldInfor.getZDLB() == 2) {
                key_field = fieldInfor.getZDMC();
                key_value = str_value;
                key_index = iFieldCount;
            }

            field_str[iFieldCount] = fieldInfor.getZDMC();
            value_str[iFieldCount] = str_value;
            iFieldCount ++;
        }

        String idArray[] = mySmartUpload.getRequest().getParameterValues("C_ID");
        String sYGIDS[]  = mySmartUpload.getRequest().getParameterValues("YGID_USER");
        //////////////附件
        Annex annex = new Annex(moduleInfor_session.getSXFJ(), dataConn);
        boolean hasAnnex = false;
        if (!Convert.toSpaceStr(moduleInfor_session.getSXFJ()).equals("")) {
            hasAnnex = true;
        }
        /////////////管理
        boolean hasManager = false;  //管理
        if (!Convert.toSpaceStr(moduleInfor_session.getSXGL()).equals("")) {
            hasManager = true;
        }

        ///////////////
        DataAction dataAction = new DataAction(dataConn);
        try {
            ////////////根据recordid获得KEY_VALUE
            Statement stmt = dataConn.getConnection().createStatement();
            DataList dataList = new DataList(stmt);
            ResultSet rs = dataList.getResultSet(sTable, "WZID", "RECORDID='"+ mRecordID + "'");
            if (rs.next()) {
                key_value = Convert.toSpaceStr(rs.getString("WZID"));
                value_str[key_index] = key_value;
            }
            stmt.close();

            if (strACTION.equals("ADD")) {
                //flag = dataAction.add(sTable, field_str, value_str);
            } else if (strACTION.equals("UPDATE")) {
                sCond = key_field + "='" + key_value + "'";
                flag = dataAction.update(sTable, field_str, value_str, sCond);

                if (flag && hasAnnex) {
                    String delete_FJID = Convert.toZeroStr(mySmartUpload.getRequest().getParameter("delete_FJID"));
                    flag = annex.update(mySmartUpload,
                                        userInfor_session.getYGZH(),
                                        moduleInfor_session.getSXFJLJ(),
                                        key_value,
                                        rootPath_session,
                                        delete_FJID);
                }
            } else if (strACTION.equals("DELETE")) {
                //flag = dataAction.delete(sTable, key_field, idArray);
            }

            if (flag && hasManager) {
                Manager manager = new Manager(moduleInfor_session.getSXGL(),dataConn);
                flag = manager.add(Integer.parseInt(key_value), sYGIDS);
                if (!flag) {
                    strMessage = manager.getMessage();
                }
            }

            strMessage = dataAction.getMessage();
        }
        catch(Exception e) {
            System.out.println("Error="+e);
        }

        ////////////正文已经保存好了，现在处理流程
        Transact transact = new Transact(dataConn);
        if (ISSEND.equals("1")) { //发送
            transact.flowNodePassMultipart(
                    mySmartUpload.getRequest(),
                    strSWLB,
                    Integer.parseInt(key_value),
                    sTable,
                    Integer.parseInt(mBLID)
                    );
        } else if (ISSEND.equals("2")) { //退回

        } else if (ISSEND.equals("3")) { //否决
            transact.flowRejectMultipart(
                    mySmartUpload.getRequest(),
                    strSWLB,
                    Integer.parseInt(key_value),
                    sTable,
                    Integer.parseInt(mBLID)
                    );
        } else if (ISSEND.equals("5")) { //办结
            transact.flowFinishMultipart(
                    mySmartUpload.getRequest(),
                    strSWLB,
                    Integer.parseInt(key_value),
                    sTable,
                    Integer.parseInt(mBLID)
                    );
        }
    }
    catch(java.lang.Exception ex) {
        System.out.println("错误信息:" + ex.getMessage());
    }
    finally {
        if (dataConn != null) {
            dataConn.close();
        }
    }
%>
<%
    if (!flag) {
        out.println("<Script Language='javaScript'>");
        out.println("alert('" + strMessage + "');");
        out.println("history.go(-1);");
        out.println("</Script>");
    } else {
        out.println("<Script Language='javaScript'>");
        out.println("formPage.action='" + strLink_action + "'");
        out.println("formPage.submit();");
        out.println("</Script>");
    }
%>