efs.rar_efs_efs java_ext 框架_html

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