com.centit.framework.system.dao.OptDataScopeDao Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of framework-system-module Show documentation

定义了一组和core兼容的表结构，并用mybatis实现了表的增删改查

The newest version!

package com.centit.framework.system.dao;

import com.centit.framework.core.dao.CodeBook;
import com.centit.framework.jdbc.dao.BaseDaoImpl;
import com.centit.framework.jdbc.dao.DatabaseOptUtils;
import com.centit.framework.system.po.OptDataScope;
import com.centit.support.algorithm.CollectionsOpt;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

import java.util.*;

@Repository("optDataScopeDao")
public class OptDataScopeDao extends BaseDaoImpl {

    public Map getFilterField() {
        Map filterField = new HashMap<>();
        filterField.put("optId", CodeBook.EQUAL_HQL_ID);
        filterField.put("optScopeCode", CodeBook.EQUAL_HQL_ID);
        filterField.put("scopeName", CodeBook.LIKE_HQL_ID);
        return filterField;
    }

    /**
     * @return 所有的数据范围定义
     */

    @Transactional
    public List listAllDataScope() {
        return listObjects();
    }

    @Transactional
    public List getDataScopeByOptID(String sOptID) {
        return this.listObjectsByProperty("optId", sOptID);
    }



    @Transactional
    public void deleteDataScopeOfOptID(String sOptID) {
        this.deleteObjectsByProperties(
                CollectionsOpt.createHashMap("optId", sOptID));
    }


    @Transactional
    public String getNextOptCode() {
        Long nextValue = DatabaseOptUtils.getSequenceNextValue(this, "S_OPTDEFCODE");
        return nextValue==null?"":String.valueOf(nextValue);
    }


    @Transactional
    public List listDataFiltersByIds(Collection scopeCodes) {
        List objs = this.listObjectsByFilter(
                "WHERE OPT_SCOPE_CODE in (:optScopeCode)",
                CollectionsOpt.createHashMap("optScopeCode", scopeCodes));
        if(objs==null)
            return null;
        List filters = new ArrayList<>();
        for(OptDataScope scope:objs)
            filters.add(scope.getFilterCondition());
        return filters;
    }

    public void updateOptDataScope(OptDataScope optDataScope){
        super.updateObject(optDataScope);
    }

    public void saveNewOPtDataScope(OptDataScope optDataScope){
        super.saveNewObject(optDataScope);
    }

}