package efsframe.cn.baseManage;
import org.dom4j.Element;
import efsframe.cn.base.CommonQuery;
import efsframe.cn.base.QueryDoc;
import efsframe.cn.declare.Common;
import efsframe.cn.declare.Field;
import efsframe.cn.declare.Table;
import efsframe.cn.func.*;
/**
* IdentifyQueryBO 类
* 该类包含身份认证、后台管理部分的所有查询
*/
public class IdentifyQueryBO implements java.io.Serializable
{
private static final long serialVersionUID = 9159083083064620204L;
/**
* 查询用户信息列表（列表返回）
* @param strXML 标准查询条件结构
* @return XML 标准查询返回结构
*/
public static String userList(String strXML) throws Exception
{
QueryDoc obj_Query = new QueryDoc(strXML);
Element ele_Condition = obj_Query.getCondition();
//// 获得每页记录数
String str_Return = ele_Condition.attributeValue(Common.XML_PROP_RECORDSPERPAGE);
int int_PageSize = str_Return==null ? 10 : Integer.parseInt(str_Return);
/// 获得当前待查询页码
str_Return = ele_Condition.attributeValue(Common.XML_PROP_CURRENTPAGENUM);
int int_CurrentPage = str_Return==null ? 1 : Integer.parseInt(str_Return);
/// 获得记录总数
str_Return = ele_Condition.attributeValue(Common.XML_PROP_RECORDS);
int int_TotalRecords = str_Return==null ? 0 : Integer.parseInt(str_Return);
int int_CountTotal = int_TotalRecords>0 ? 1 : 0;
int int_TotalPages = 0;
String str_Select = Table.S + Common.DOT + Field.USERID + Common.SPACE + Field.USERID + Common.COMMA +
Table.S + Common.DOT + Field.USERTITLE + Common.SPACE + Field.USERTITLE + Common.COMMA +
Table.S + Common.DOT + Field.USERNAME + Common.SPACE + Field.USERNAME + Common.COMMA +
Table.S + Common.DOT + Field.SEX + Common.SPACE + Field.SEX + Common.COMMA +
Table.S + Common.DOT + Field.UNITID + Common.SPACE + Field.UNITID + Common.COMMA +
Table.S + Common.DOT + Field.UNITNAME + Common.SPACE + Field.UNITNAME + Common.COMMA +
Table.S + Common.DOT + Field.DISABLED + Common.SPACE + Field.DISABLED + Common.COMMA +
Table.S + Common.DOT + Field.CANEDITPASSWORD + Common.SPACE + Field.CANEDITPASSWORD + Common.COMMA +
Table.S + Common.DOT + Field.USERTYPE + Common.SPACE + Field.USERTYPE;
String str_From = Table.VW_USERLIST + Common.SPACE + Table.S;
String str_Where = obj_Query.getConditions();
str_Where = General.empty(str_Where) ? str_Where : Common.WHERE + str_Where;
// str_Where = General.empty(str_Where) ? Common.ORDER + Field.USERID : str_Where + Common.S_ORDER + Field.USERID;
String[] str_DicFieldList = {Field.DISABLED,
Field.CANEDITPASSWORD,
Field.SEX,
Field.USERTYPE};
String[] str_DicNameList = {Table.DIC_TRUEFALSE,
Table.DIC_ABLE,
Table.DIC_GENDER,
Table.DIC_USERTYPE};
return CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
Field.USERID,
str_DicFieldList,
str_DicNameList,
null,
int_TotalRecords,
int_TotalPages,
int_PageSize,
int_CurrentPage,
int_CountTotal);
}
/**
* 查询用户信息列表（列表返回）
* @param strXML 标准查询条件结构
* @return XML 标准查询返回结构
*/
public static String roleList(String strXML) throws Exception
{
QueryDoc obj_Query = new QueryDoc(strXML);
Element ele_Condition = obj_Query.getCondition();
/// 获得每页记录数
String str_Return = ele_Condition.attributeValue(Common.XML_PROP_RECORDSPERPAGE);
int int_PageSize = str_Return==null ? 10 : Integer.parseInt(str_Return);
/// 获得当前待查询页码
str_Return = ele_Condition.attributeValue(Common.XML_PROP_CURRENTPAGENUM);
int int_CurrentPage = str_Return==null ? 1 : Integer.parseInt(str_Return);
/// 获得记录总数
str_Return = ele_Condition.attributeValue(Common.XML_PROP_RECORDS);
int int_TotalRecords = str_Return==null ? 0 : Integer.parseInt(str_Return);
int int_CountTotal = int_TotalRecords>0 ? 1 : 0;
int int_TotalPages = 0;
String str_Select = Table.S + Common.DOT + Field.ROLEID + Common.SPACE + Field.ROLEID + Common.COMMA +
Table.S + Common.DOT + Field.ROLENAME + Common.SPACE + Field.ROLENAME + Common.COMMA +
Table.S + Common.DOT + Field.ROLEDES + Common.SPACE + Field.ROLEDES;
String str_From = Table.ROLEBASIC + Common.SPACE + Table.S;
String str_Where = obj_Query.getConditions();
str_Where = General.empty(str_Where) ? str_Where : Common.WHERE + str_Where;
// str_Where = General.empty(str_Where) ? Common.ORDER + Table.S + Common.DOT + Field.ROLEID : str_Where + Common.S_ORDER + Table.S + Common.DOT + Field.ROLEID;
String[] str_DicFieldList = null;
String[] str_DicNameList = null;
return CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
Field.ROLEID,
str_DicFieldList,
str_DicNameList,
null,
int_TotalRecords,
int_TotalPages,
int_PageSize,
int_CurrentPage,
int_CountTotal);
}
/**
* 查询事务类型列表（列表返回）
* @param strXML 标准查询条件结构
* @return XML 标准查询返回结构
*/
public static String affairTypeList(String strXML) throws Exception
{
QueryDoc obj_Query = new QueryDoc(strXML);
Element ele_Condition = obj_Query.getCondition();
/// 获得每页记录数
String str_Return = ele_Condition.attributeValue(Common.XML_PROP_RECORDSPERPAGE);
int int_PageSize = str_Return==null ? 10 : Integer.parseInt(str_Return);
/// 获得当前待查询页码
str_Return = ele_Condition.attributeValue(Common.XML_PROP_CURRENTPAGENUM);
int int_CurrentPage = str_Return==null ? 1 : Integer.parseInt(str_Return);
/// 获得记录总数
str_Return = ele_Condition.attributeValue(Common.XML_PROP_RECORDS);
int int_TotalRecords = str_Return==null ? 0 : Integer.parseInt(str_Return);
int int_CountTotal = int_TotalRecords>0 ? 1 : 0;
int int_TotalPages = 0;
String str_Select = Table.S + Common.DOT + Field.AFFAIRTYPEID + Common.SPACE + Field.AFFAIRTYPEID + Common.COMMA +
Table.S + Common.DOT + Field.AFFAIRTYPENAME + Common.SPACE + Field.AFFAIRTYPENAME + Common.COMMA +
Table.S + Common.DOT + Field.AFFAIRTYPEMODE + Common.SPACE + Field.AFFAIRTYPEMODE + Common.COMMA +
Table.S + Common.DOT + Field.AFFAIRTYPEDES + Common.SPACE + Field.AFFAIRTYPEDES;
String str_From = Table.AFFAIRTYPE + Common.SPACE + Table.S;
String str_Where = obj_Query.getConditions();
str_Where = General.empty(str_Where) ? str_Where : Common.WHERE + str_Where;
// str_Where = General
efs.rar_efs_efs java_ext 框架_html （1127个子文件） 
org.eclipse.core.resources.prefs.bak 257B General.class 16KB IdentifyQueryBO.class 15KB AjaxDoAction.class 15KB IdentifyAction.class 13KB XmlFunc.class 11KB CommonQuery.class 11KB ReturnDoc.class 9KB PageCommon.class 9KB DBConnectionManager.class 8KB SQLAnalyse.class 8KB Common.class 8KB ProductBO.class 7KB Dic.class 7KB DataDoc.class 7KB UserInfo.class 7KB RoleBO.class 6KB DicCache.class 5KB IdentifyBO.class 5KB Convertion.class 5KB PersonBO.class 5KB SpellCache.class 5KB QueryDoc.class 5KB UserCache.class 5KB DBConnectionManager$DBConnectionPool.class 4KB DBConnection.class 4KB Field.class 4KB DataStorage.class 4KB UserBO.class 4KB DateTimeUtil.class 4KB ClassesBO.class 4KB AjaxAction.class 4KB Crypt.class 4KB ClassesAction.class 3KB MUnitCache.class 3KB BaseAction.class 3KB MUnitInfo.class 3KB Operation.class 3KB NumAssign.class 3KB Pub.class 3KB UnitsBO.class 2KB Table.class 2KB StartPlug.class 2KB AffairTypeBO.class 2KB EventTypeBO.class 2KB UserLogonInfo.class 2KB ErrorLog.class 2KB SystemLog.class 2KB ProductAction.class 2KB CharacterEncodingFilter.class 1KB Spell.class 1KB MyActionServlet.class 901B MaxIDTypeBO.class 572B .classpath 2KB ext-all.css 82KB efs-all.css 5KB Thumbs.db 111KB Thumbs.db 71KB Thumbs.db 24KB Thumbs.db 7KB Thumbs.db 7KB Thumbs.db 7KB Thumbs.db 7KB Thumbs.db 6KB Thumbs.db 6KB Thumbs.db 6KB Thumbs.db 6KB Thumbs.db 6KB Thumbs.db 5KB
main.gif 27KB title1.gif 13KB title.gif 13KB loading.gif 11KB deng06.gif 9KB famlmain_top.gif 8KB logout.gif 6KB error_hint.gif 5KB php.gif 5KB fire.gif 5KB download.gif 4KB tip-sprite.gif 4KB error-tip-corners.gif 4KB tool-sprites.gif 4KB i_hint.gif 4KB large-loading.gif 3KB blue-loading.gif 3KB .net.gif 3KB tools-sprites-trans.gif 3KB wait-3.gif 3KB wait-2.gif 2KB wait-1.gif 2KB search-trigger.gif 2KB mssql.gif 2KB tabs-sprite.gif 2KB loading-balls.gif 2KB tb-sprite.gif 2KB checkbox.gif 2KB oracle.gif 2KB clear-trigger.gif 2KB trigger.gif 2KB共 1127 条
- 1
- 2
- 3
- 4
- 5
- 6
- 12
资源评论
APei
- 粉丝: 83
- 资源: 1万+
最新资源
- dnSpy-net-win32-222.zip
- mongoose-free-6.9
- 德普微一级代理 DP100N06MGL PDFN3.3*3.3 TRMOS N-MOSFET 60V, 8mΩ, 45A
- 【java毕业设计】SpringBoot+Vue幼儿园管理系统 源码+sql脚本+论文 完整版
- 德普微一级代理 DP021N03FGLI DFN5*6 DPMOS N-MOSFET 30V 180A 1.8mΩ
- 巨潮资讯网5000只股票orgId-dict加密字典
- 基于java实现的快速排序代码
- 德普微一级代理 DP3145D SOT23-6 USB PD 协议单口控制器
- 【一文搞懂：什么是集成学习-原理+python代码】
- 国际象棋检测7-YOLO（v5至v9）、COCO、CreateML、Darknet、Paligemma、TFRecord数据集合集.rar
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
