cn.sucang.core.dao

Interface FormQueryDao

All Superinterfaces:

IBase<FormQuery>, IBaseDao<FormQuery>

public interface FormQueryDao
extends IBaseDao<FormQuery>

Method Summary

Modifier and Type	Method and Description
FormQueryButton	getBtnById(java.lang.String btnid)
java.util.List<FormQueryButton>	getBtnsByPageId(java.lang.String pageId, int btnType, int permissionType, java.lang.String hqlWhere) 返回指定的类型的按钮（菜单，Tab按钮）
java.util.List<FormQueryButton>	getBtnsByPageId(java.lang.String pageId, int btnType, java.lang.String hqlWhere) 返回指定的类型的按钮（菜单，Tab按钮）
java.util.List<FormQueryButton>	getBtnsByWhere(java.lang.String hqlWhere)
PageList<java.util.Map>	getDataByUserSql(java.lang.String sql, int page, int maxPerPage, java.lang.String where, java.lang.String keyField) 根据定义SQL返回分页数据
FormQueryData	getDataFieldsById(java.lang.String fieldId)
java.util.List<FormQueryData>	getDataFieldsByPageId(java.lang.String pageId)
java.util.List<FormQuerySearch>	getQuerysByPageId(java.lang.String pageId)
FormQuerySearch	getQuerySearchById(java.lang.String searchid)
java.util.List<FormQueryData>	getViewFieldsByPageId(java.lang.String pageId) 返回显示的查询页的字段列，如果隐藏的则不返回，需要返回所有列请调用接口getDataFieldsByPageId(pageid)
int	removeDataRowById(java.lang.String ids) 根据FormQueryData.id删除FormQueryData对象
int	removeFromPageBtn(java.lang.String ids)
int	removeQueryRowById(java.lang.String id) 根据FormQuerySearch.id删除FormQuerySearch对象

Methods inherited from interface cn.sucang.core.dao.IBaseDao

evict, evict, evictAll, flush, getByWhere, getByWhere, getListByWhere, getListByWhere, replicate, update

Methods inherited from interface cn.sucang.core.IBase

executeUpdate, executeUpdate, getById, getById, getByQuery, getByWhere, getByWhere, getCounts, getCounts, getJdbcDao, getJdbcTemplate, getList, getListByWhere, getListByWhere, getListForQuery, getListForQuery, getNewItem, getPageList, getPageList, getPageListForQuery, remove, removeById, removeByObject, save, saveOrUpdate, saveOrUpdateByObject, updateLabelByOldLabel

Method Detail

removeQueryRowById

int removeQueryRowById(java.lang.String id)

根据FormQuerySearch.id删除FormQuerySearch对象

Parameters:

id - as String

Returns:

int

removeDataRowById

int removeDataRowById(java.lang.String ids)

根据FormQueryData.id删除FormQueryData对象

Parameters:

id - as String

Returns:

int

removeFromPageBtn

int removeFromPageBtn(java.lang.String ids)

getQuerysByPageId

java.util.List<FormQuerySearch> getQuerysByPageId(java.lang.String pageId)

getQuerySearchById

FormQuerySearch getQuerySearchById(java.lang.String searchid)

getDataFieldsByPageId

java.util.List<FormQueryData> getDataFieldsByPageId(java.lang.String pageId)

getViewFieldsByPageId

java.util.List<FormQueryData> getViewFieldsByPageId(java.lang.String pageId)

返回显示的查询页的字段列，如果隐藏的则不返回，需要返回所有列请调用接口getDataFieldsByPageId(pageid)

Parameters:

pageId -

Returns:

getDataFieldsById

FormQueryData getDataFieldsById(java.lang.String fieldId)

getBtnsByPageId

java.util.List<FormQueryButton> getBtnsByPageId(java.lang.String pageId,
                                                int btnType,
                                                java.lang.String hqlWhere)

返回指定的类型的按钮（菜单，Tab按钮）

Parameters:

pageId - as String //可以为多个用并用逗号分隔

btnType - as int //见QueryFormButton.TYPE_**,-1 返回所有

hqlWhere - as String //限制条件，默认为null

Returns:

getBtnsByPageId

java.util.List<FormQueryButton> getBtnsByPageId(java.lang.String pageId,
                                                int btnType,
                                                int permissionType,
                                                java.lang.String hqlWhere)

返回指定的类型的按钮（菜单，Tab按钮）

Parameters:

pageId - as String

btnType - as int //见QueryFormButton.TYPE_**

permissionType - as int //见Constant.OPT_**

hqlWhere - as String //限制条件，默认为null

Returns:

getBtnsByWhere

java.util.List<FormQueryButton> getBtnsByWhere(java.lang.String hqlWhere)

getBtnById

FormQueryButton getBtnById(java.lang.String btnid)

getDataByUserSql

PageList<java.util.Map> getDataByUserSql(java.lang.String sql,
                                         int page,
                                         int maxPerPage,
                                         java.lang.String where,
                                         java.lang.String keyField)

根据定义SQL返回分页数据

Parameters:

sql - as String

where - as String

Returns: