单位基本数据之类（代码）

package com.ly.view.xtgl.xxzzjg.dwjbsjzl;

import com.ly.jwxt.xtgl.xxzzjg.VO.XtglDwjbsjzlViewImpl;
import com.ly.jwxt.xtgl.xxzzjg.VO.XtglDwjbsjzlViewRowImpl;
import com.ly.jwxt.xtgl.xxzzjg.VO.XtglGroupViewRowImpl;
import com.ly.jwxt.xtgl.xxzzjg.VO.XtglUserGroupViewRowImpl;
import com.ly.view.utils.ADFUtils;
import com.ly.view.xtgl.dmj.ggdmj.BxlxmBean;

import java.io.Serializable;

import javax.faces.event.ActionEvent;

import oracle.adf.share.logging.ADFLogger;

import com.ly.view.utils.ADFUtils;

import com.ly.view.utils.ErrorStringKey;
import com.ly.view.utils.JSFUtils;

import com.ly.view.utils.Noty;

import java.text.SimpleDateFormat;

import java.util.Iterator;

import java.util.List;

import javax.faces.component.UIComponent;

import oracle.adf.model.BindingContext;
import oracle.adf.model.binding.DCBindingContainer;

import oracle.adf.model.binding.DCIteratorBinding;

import oracle.adf.view.rich.component.rich.data.RichTree;

import oracle.adf.view.rich.component.rich.input.RichInputText;

import oracle.adf.view.rich.component.rich.layout.RichPanelFormLayout;
import oracle.adf.view.rich.context.AdfFacesContext;
import oracle.adf.view.rich.event.DialogEvent;
import oracle.adf.view.rich.event.PopupFetchEvent;

import oracle.binding.OperationBinding;

import oracle.jbo.JboException;

import oracle.jbo.Key;
import oracle.jbo.Row;
import oracle.jbo.RowSetIterator;
import oracle.jbo.ViewCriteria;
import oracle.jbo.ViewCriteriaItem;
import oracle.jbo.ViewCriteriaRow;
import oracle.jbo.ViewObject;

import oracle.jbo.uicli.binding.JUCtrlHierBinding;

import oracle.jbo.uicli.binding.JUCtrlHierNodeBinding;

import oracle.jbo.uicli.binding.JUCtrlHierTypeBinding;

import org.apache.myfaces.trinidad.event.SelectionEvent;
import org.apache.myfaces.trinidad.model.CollectionModel;
import org.apache.myfaces.trinidad.model.RowKeySet;

/**
 * 单位信息Bean
 * @author caihuihai
 */
public class DwjbsjBean implements Serializable {
    private ADFLogger log = ADFLogger.createADFLogger(BxlxmBean.class);
    private static final long serialVersionUID = 1L;
    private RichInputText dwdmCompId; //单位代码组件id
    private RichTree treePanel; //tree组件
    private RichPanelFormLayout formPanel; //form组件

    public DwjbsjBean() {
    }

    /**
     * 新增操作
     * @param actionEvent
     */
    public void addButton(ActionEvent actionEvent) {
        try {
            ADFUtils.createRowByBinding("XtglDwjbsjzlView1Iterator");
            dwdmCompId.setDisabled(false);
            ADFUtils.executeByOperation("setRowUpdateAble");
        } catch (Exception e) {
            log.severe(e);
            Noty.error(ErrorStringKey.ADD_ERROR);
        }

    }

    /**
     * 选择树节点操作
     * @param selectionEvent
     */
    public void mySelectListener(SelectionEvent selectionEvent) {
        try {
            RichTree tree = (RichTree)selectionEvent.getSource();
            RowKeySet rowKeySet = selectionEvent.getAddedSet();
            Iterator rksIterator = rowKeySet.iterator();
            while (rksIterator.hasNext()) {
                List key = (List)rksIterator.next();
                JUCtrlHierBinding treeBinding = null;
                CollectionModel collectionModel = (CollectionModel)tree.getValue();
                treeBinding = (JUCtrlHierBinding)collectionModel.getWrappedData();
                JUCtrlHierNodeBinding nodeBinding = treeBinding.findNodeByKeyPath(key);
                Row rw = nodeBinding.getRow();
                String dwdm = (String)rw.getAttribute("Dwdm");
                //根据左边树节点id查找详细信息，显示在右边区域
                DCIteratorBinding dcIteratorBinding = ADFUtils.findIterator("XtglDwjbsjzlView1Iterator");
                XtglDwjbsjzlViewImpl vo = (XtglDwjbsjzlViewImpl)dcIteratorBinding.getViewObject();
                vo.setWhereClause("dwdm = '"+dwdm+"'");
                vo.setRowReadonly();
            }
        } catch (Exception e) {
            log.severe(e);
            Noty.error(ErrorStringKey.OPERATOR_ERROR);
        }
    }

    /**
     * 提交操作
     * @param actionEvent
     */
    public void tjButton(ActionEvent actionEvent) {
        try {
            String cz = JSFUtils.resolveExpression("#{pageFlowScope.cz}").toString();
            String dwdm = (String)ADFUtils.getBoundAttributeValue("Dwdm");
            String dwmc = (String)ADFUtils.getBoundAttributeValue("Dwmc");
            String lsdwh = (String)ADFUtils.getBoundAttributeValue("Lsdwh");
            if (cz.equals("add")) { ///新增时创建行
                ADFUtils.executeByOperation("CreateInsert");
                ADFUtils.setBoundAttributeValue("Zbh", dwdm);
            }
            ADFUtils.setBoundAttributeValue("Zmc", dwmc);
            ADFUtils.setBoundAttributeValue("Sszbh", lsdwh);
            ADFUtils.executeByOperation("Commit");
            ADFUtils.executeByOperation("setRowReadonly");
            ADFUtils.executeByOperation("Execute");
            ADFUtils.executeByOperation("Execute1");
            AdfFacesContext.getCurrentInstance().addPartialTarget(treePanel); //刷新tree组件
            AdfFacesContext.getCurrentInstance().addPartialTarget(formPanel); //刷新form表单
            Noty.success(ErrorStringKey.COMMMIT_SCUUESS);
        } catch (Exception e) {
            log.severe(e);
            Noty.error(ErrorStringKey.COMMMIT_ERROR);
        }

    }

    /**
     * 修改操作
     * @param actionEvent
     */
    public void editButton(ActionEvent actionEvent) {
        try {
            ADFUtils.executeByOperation("setRowUpdateAble");
            dwdmCompId.setDisabled(true);
        } catch (Exception e) {
            log.severe(e);
            Noty.error(ErrorStringKey.UPDATE_ERROR);
        }
    }

    /**
     * 删除操作
     * @param dialogEvent
     */
    public void deleteListener(DialogEvent dialogEvent) {
        try {
            String dwdm = (String)ADFUtils.getBoundAttributeValue("Dwdm"); //单位代码主键
            XtglDwjbsjzlViewImpl dwjbsjVo = (XtglDwjbsjzlViewImpl)ADFUtils.findIterator("XtglDwjbsjzlView1Iterator").getViewObject(); //单位基本数据信息
            ViewObject groupVo = ADFUtils.findIterator("XtglGroupView1Iterator").getViewObject(); //组信息
            ViewObject userGroupVo = ADFUtils.findIterator("XtglUserGroupView1Iterator").getViewObject(); //用户组
            dwjbsjVo.setWhereClause(null);
            dwjbsjVo.setWhereClause(" Lsdwh = '"+dwdm+"'");
            dwjbsjVo.executeQuery();
            if(dwjbsjVo.getEstimatedRangePageCount() > 0){
                Noty.error("请先删除子节点数据");
                return;
            }
            dwjbsjVo.setWhereClause(null);
            //-----------
//            dwjbsjVo.setWhereClause(null);
//            ViewCriteria vc = dwjbsjVo.createViewCriteria();
//            vc.setName("criteria");
//            ViewCriteriaRow vcRow = vc.createViewCriteriaRow();
//            ViewCriteriaItem item = vcRow.ensureCriteriaItem("Lsdwh");
//            item.setOperator("=");
//            item.setValue(dwdm);
//            vc.add(vcRow);
//            dwjbsjVo.applyViewCriteria(vc);
//            dwjbsjVo.executeQuery();
//            dwjbsjVo.findByViewCriteria(vc, -1, ViewObject.QUERY_MODE_SCAN_ENTITY_ROWS);
//            if(dwjbsjVo.getEstimatedRowCount() > 0){
//                Noty.error("请先删除子节点数据");
//                return;
//            }
//            dwjbsjVo.removeViewCriteria("criteria");
            dwjbsjVo.executeQuery();
            log.info("sql:"+dwjbsjVo.getQuery());
            Row dwjbRow = ADFUtils.getRowByKey(dwjbsjVo, 33);
            log.info("dwjbRow:"+dwjbRow);
            //row.remove();
//            Row gRow = ADFUtils.getRowByKey(groupVo, Integer.parseInt(dwdm));
//            gRow.remove();
//            Row uRow = ADFUtils.getRowByKey(userGroupVo, Integer.parseInt(dwdm));
//            uRow.remove();
//            dwjbsjVo.setWhereClause(null);
//            dwjbsjVo.setWhereClause(" Dwdm = '" + dwdm + "'");
//            dwjbsjVo.executeQuery();
//            RowSetIterator dwjbsjIterator = dwjbsjVo.createRowSetIterator(null);
//            while (dwjbsjIterator.hasNext()) {
//                XtglDwjbsjzlViewRowImpl dwjbsjrow = (XtglDwjbsjzlViewRowImpl)dwjbsjIterator.next();
//                dwjbsjrow.remove(); //删除单位信息表
//            }
//            dwjbsjIterator.closeRowSetIterator();
//            groupVo.setWhereClause(" Zbh='" + dwdm + "'");
//            groupVo.executeQuery();
//            RowSetIterator groupIterator = groupVo.createRowSetIterator(null);
//            while (groupIterator.hasNext()) {
//                XtglGroupViewRowImpl groupRow = (XtglGroupViewRowImpl)groupIterator.next();
//                groupRow.remove(); //删除组信息表
//            }
//            groupIterator.closeRowSetIterator();
//            userGroupVo.setWhereClause(" Zbh='" + dwdm + "'");
//            userGroupVo.executeQuery();
//            RowSetIterator userIterator = userGroupVo.createRowSetIterator(null);
//            while (userIterator.hasNext()) {
//                XtglUserGroupViewRowImpl userGroupRow = (XtglUserGroupViewRowImpl)userIterator.next();
//                userGroupRow.remove(); //删除用户组信息表
//            }
//            userIterator.closeRowSetIterator();
            ADFUtils.executeByOperation("Commit");
            ADFUtils.executeByOperation("Execute");
            ADFUtils.executeByOperation("Execute1");
            AdfFacesContext.getCurrentInstance().addPartialTarget(treePanel); //刷新tree组件
            AdfFacesContext.getCurrentInstance().addPartialTarget(formPanel); //刷新form表单
            Noty.success(ErrorStringKey.DELETE_SCUUESS);
        } catch (Exception e) {
            log.severe(e);
            Noty.error(ErrorStringKey.DELETE_ERROR);
        }
    }

    public void setDwdmCompId(RichInputText dwdmCompId) {
        this.dwdmCompId = dwdmCompId;
    }

    public RichInputText getDwdmCompId() {
        return dwdmCompId;
    }

    public void setTreePanel(RichTree treePanel) {
        this.treePanel = treePanel;
    }

    public RichTree getTreePanel() {
        return treePanel;
    }

    public void setFormPanel(RichPanelFormLayout formPanel) {
        this.formPanel = formPanel;
    }

    public RichPanelFormLayout getFormPanel() {
        return formPanel;
    }
}

 留底