public static string affairTypeList(string strXML) { QueryDoc obj_Query = new QueryDoc(strXML); int int_PageSize = obj_Query.getIntPageSize(); int int_CurrentPage = obj_Query.getIntCurrentPage(); 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; return CommonQuery.basicListQuery(str_Select, str_From, str_Where, Field.AFFAIRTYPEID, int_PageSize, int_CurrentPage); }
public static string ErrLogList(string strXML) { QueryDoc obj_Query = new QueryDoc(strXML); int int_PageSize = obj_Query.getIntPageSize(); int int_CurrentPage = obj_Query.getIntCurrentPage(); string str_Select = Table.S + Common.DOT + Field.SQLID + Common.SPACE + Field.SQLID + Common.COMMA + Table.S + Common.DOT + Field.APPLYDATE + Common.SPACE + Field.APPLYDATE + Common.COMMA + Table.S + Common.DOT + Field.OBJID + Common.SPACE + Field.OBJID + Common.COMMA + Table.S + Common.DOT + Field.ERRDES1 + Common.SPACE + Field.ERRDES1 + Common.COMMA + Table.S + Common.DOT + Field.SQLSCRIPT + Common.SPACE + Field.SQLSCRIPT; string str_From = Table.SQLSTORAGE + Common.SPACE + Table.S; string str_Where = obj_Query.getConditions(); str_Where = General.empty(str_Where) ? str_Where : Common.WHERE + str_Where; return CommonQuery.basicListQuery(str_Select, str_From, str_Where, Field.SQLID + Common.S_DESC, int_PageSize, int_CurrentPage); }
/// <summary> /// 查询编码类型信息列表(列表返回) /// </summary> /// <param name="strXML"></param> /// <returns></returns> public static string maxidtypeList(string strXML) { QueryDoc obj_Query = new QueryDoc(strXML); int int_PageSize = obj_Query.getIntPageSize(); int int_CurrentPage = obj_Query.getIntCurrentPage(); string str_Select = Table.S + Common.DOT + Field.IDTYPE + Common.SPACE + Field.IDTYPE + Common.COMMA + Table.S + Common.DOT + Field.IDNAME + Common.SPACE + Field.IDNAME + Common.COMMA + Table.S + Common.DOT + Field.IDSIZE + Common.SPACE + Field.IDSIZE + Common.COMMA + Table.S + Common.DOT + Field.IDPARA + Common.SPACE + Field.IDPARA + Common.COMMA + Table.S + Common.DOT + Field.IDLOOP + Common.SPACE + Field.IDLOOP + Common.COMMA + Table.S + Common.DOT + Field.IDMIN + Common.SPACE + Field.IDMIN + Common.COMMA + Table.S + Common.DOT + Field.IDMAX + Common.SPACE + Field.IDMAX + Common.COMMA + Table.S + Common.DOT + Field.IDDES + Common.SPACE + Field.IDDES; string str_From = Table.MAXIDTYPE + Common.SPACE + Table.S; string str_Where = obj_Query.getConditions(); str_Where = General.empty(str_Where) ? str_Where : Common.WHERE + str_Where; return CommonQuery.basicListQuery(str_Select, str_From, str_Where, Field.IDTYPE, int_PageSize, int_CurrentPage); }
/// <summary> /// 查询字典内容的简单列表 /// </summary> /// <param name="strXML">标准 XML 数据信息</param> /// <param name="strDicName">字典名称</param> /// <returns></returns> public static string dicDataList(string strXML, string strDicName) { QueryDoc obj_Query = new QueryDoc(strXML); XmlElement ele_Condition = obj_Query.getCondition(); int int_PageSize = obj_Query.getIntPageSize(); int int_CurrentPage = obj_Query.getIntCurrentPage(); string str_Select = Table.S + Common.DOT + Field.DICNAME + Common.SPACE + Field.DICNAME + Common.COMMA + Table.S + Common.DOT + Field.DIC_CODE + Common.SPACE + Field.DIC_CODE + Common.COMMA + Table.S + Common.DOT + Field.DIC_TEXT + Common.SPACE + Field.DIC_TEXT + Common.COMMA + Table.S + Common.DOT + Field.DIC_VALID + Common.SPACE + Field.DIC_VALID; string str_From = Table.DICDATA + 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) ? str_Where + Common.SPACE + Field.DICNAME + Common.EQUAL + General.addQuotes(strDicName) : Common.S_WHERE + Field.DICNAME + Common.EQUAL + General.addQuotes(strDicName); return CommonQuery.basicListQuery(str_Select, str_From, str_Where, Field.DIC_CODE, int_PageSize, int_CurrentPage); }
public static string eventTypeList(string strXML) { QueryDoc obj_Query = new QueryDoc(strXML); int int_PageSize = obj_Query.getIntPageSize(); int int_CurrentPage = obj_Query.getIntCurrentPage(); string str_Select = Table.S + Common.DOT + Field.EVENTTYPEID + Common.SPACE + Field.EVENTTYPEID + Common.COMMA + Table.S + Common.DOT + Field.EVENTTYPENAME + Common.SPACE + Field.EVENTTYPENAME + Common.COMMA + Table.S + Common.DOT + Field.AFFAIRTYPENAME + Common.SPACE + Field.AFFAIRTYPENAME + Common.COMMA + Table.S + Common.DOT + Field.BEGINEVENT + Common.SPACE + Field.BEGINEVENT + Common.COMMA + Table.S + Common.DOT + Field.DISABLED + Common.SPACE + Field.DISABLED + Common.COMMA + Table.S + Common.DOT + Field.SHORTCUT + Common.SPACE + Field.SHORTCUT + Common.COMMA + Table.S + Common.DOT + Field.VISIBLE + Common.SPACE + Field.VISIBLE; string str_From = Table.VW_EVENTTYPE + Common.SPACE + Table.S; string str_Where = obj_Query.getConditions(); str_Where = General.empty(str_Where) ? str_Where : Common.WHERE + str_Where; return CommonQuery.basicListQuery(str_Select, str_From, str_Where, Field.EVENTTYPEID, int_PageSize, int_CurrentPage); }
public static string dicList(string strXML) { QueryDoc obj_Query = new QueryDoc(strXML); int int_PageSize = obj_Query.getIntPageSize(); int int_CurrentPage = obj_Query.getIntCurrentPage(); string str_Select = Table.S + Common.DOT + Field.DICNAME + Common.SPACE + Field.DICNAME + Common.COMMA + Table.S + Common.DOT + Field.DICDES + Common.SPACE + Field.DICDES + Common.COMMA + Table.S + Common.DOT + Field.CODELEN + Common.SPACE + Field.CODELEN + Common.COMMA + Table.S + Common.DOT + Field.TEXTLEN + Common.SPACE + Field.TEXTLEN + Common.COMMA + Table.S + Common.DOT + Field.EDITABLE + Common.SPACE + Field.EDITABLE; string str_From = Table.DICLIST + Common.SPACE + Table.S; string str_Where = obj_Query.getConditions(); str_Where = General.empty(str_Where) ? str_Where : Common.WHERE + str_Where; return CommonQuery.basicListQuery(str_Select, str_From, str_Where, Field.DICNAME, int_PageSize, int_CurrentPage); }
/// <summary> /// 查询日志列表 /// </summary> /// <param name="strXML"></param> /// <returns></returns> public static string sysLogList(string strXML) { QueryDoc obj_Query = new QueryDoc(strXML); int int_PageSize = obj_Query.getIntPageSize(); int int_CurrentPage = obj_Query.getIntCurrentPage(); string str_Select = Table.S + Common.DOT + Field.LOGID + Common.SPACE + Field.LOGID + Common.COMMA + Table.S + Common.DOT + Field.USERID + Common.SPACE + Field.USERID + Common.COMMA + Table.S + Common.DOT + Field.USERNAME + Common.SPACE + Field.USERNAME + Common.COMMA + Table.S + Common.DOT + Field.UNITNAME + Common.SPACE + Field.UNITNAME + Common.COMMA + Table.S + Common.DOT + Field.LOGINIP + Common.SPACE + Field.LOGINIP + Common.COMMA + Table.S + Common.DOT + Field.ENTERTIME + Common.SPACE + Field.ENTERTIME + Common.COMMA + Table.S + Common.DOT + Field.LEAVETIME + Common.SPACE + Field.LEAVETIME + Common.COMMA + Table.S + Common.DOT + Field.MAC + Common.SPACE + Field.MAC; string str_From = Table.SYSLOG + Common.SPACE + Table.S; string str_Where = obj_Query.getConditions(); str_Where = General.empty(str_Where) ? str_Where : Common.WHERE + str_Where; return CommonQuery.basicListQuery(str_Select, str_From, str_Where, Field.LOGID + Common.SPACE + Common.S_DESC, int_PageSize, int_CurrentPage); }
/// <summary> /// 班级信息查询 /// </summary> /// <param name="strXML"></param> /// <returns></returns> public static string stuClassList(string strXML) { QueryDoc obj_Query = new QueryDoc(strXML); // 每页查询多少条记录 int int_PageSize = obj_Query.getIntPageSize(); // 查询第几页 int int_CurrentPage = obj_Query.getIntCurrentPage(); // 将xml分析成标准的where语句 string str_Where = obj_Query.getConditions(); str_Where = General.empty(str_Where) ? str_Where : Common.WHERE + str_Where; string str_Select = "s.CLASSID,s.CLASSNAME"; string str_From = "STUCLASS s"; return CommonQuery.basicListQuery(str_Select, str_From, str_Where, "CLASSID ASC", int_PageSize, int_CurrentPage); }
public static string spellList(string strXML) { QueryDoc obj_Query = new QueryDoc(strXML); int int_PageSize = obj_Query.getIntPageSize(); int int_CurrentPage = obj_Query.getIntCurrentPage(); string str_Select = Table.S + Common.DOT + Field.WORD + Common.SPACE + Field.WORD + Common.COMMA + Table.S + Common.DOT + Field.SPELL + Common.SPACE + Field.SPELL + Common.COMMA + Table.S + Common.DOT + Field.ASPELL + Common.SPACE + Field.ASPELL; string str_From = Table.SPELL + Common.SPACE + Table.S; string str_Where = obj_Query.getConditions(); str_Where = General.empty(str_Where) ? str_Where : Common.WHERE + str_Where; return CommonQuery.basicListQuery(str_Select, str_From, str_Where, Field.SPELL, int_PageSize, int_CurrentPage); }
/// <summary> /// 查询单位列表 /// </summary> /// <param name="strXML"></param> /// <returns></returns> public static string munitList(string strXML) { QueryDoc obj_Query = new QueryDoc(strXML); int int_PageSize = obj_Query.getIntPageSize(); int int_CurrentPage = obj_Query.getIntCurrentPage(); string str_Select = "s." + Field.MUNITID + " " + Field.MUNITID + "," + "s." + Field.MUNITNAME + " " + Field.MUNITNAME + "," + "s." + Field.MSUNITID + " " + Field.MSUNITID + "," + "s." + Field.MTYPE + " " + Field.MTYPE + "," + "s." + Field.MLEVEL + " " + Field.MLEVEL + "," + "s." + Field.VALID + " " + Field.VALID; string str_From = Table.MANAGEUNIT + " s"; string str_Where = obj_Query.getConditions(); str_Where = General.empty(str_Where) ? str_Where : Common.WHERE + str_Where; if (General.empty(str_Where)) { str_Where = " WHERE " + Field.MTYPE + "!=" + General.addQuotes("AA"); } else { str_Where = str_Where + " AND " + Field.MTYPE + "!=" + General.addQuotes("AA"); } return CommonQuery.basicListQuery(str_Select, str_From, str_Where, Field.MUNITID, int_PageSize, int_CurrentPage); }
/// <summary> /// 学生查询 /// </summary> /// <param name="strXML">标准的查询型XML</param> /// <returns>xml数据</returns> public static string personList(string strXML) { QueryDoc obj_Query = new QueryDoc(strXML); // 每页查询多少条记录 int int_PageSize = obj_Query.getIntPageSize(); // 查询第几页 int int_CurrentPage = obj_Query.getIntCurrentPage(); // 将xml分析成标准的where语句 string str_Where = obj_Query.getConditions(); str_Where = General.empty(str_Where) ? str_Where : Common.WHERE + str_Where; string str_Select = "s.PERSONID,s.NAME,s.SEX,s.IDCARD,s.YEAROLD"; string str_From = "PERSON s"; return CommonQuery.basicListQuery(str_Select, str_From, str_Where, "PERSONID DESC", int_PageSize, int_CurrentPage); }
/// <summary> /// 用户列表查询 /// </summary> /// <param name="strXML"></param> /// <returns></returns> public static string userList(string strXML) { QueryDoc obj_Query = new QueryDoc(strXML); int int_PageSize = obj_Query.getIntPageSize(); int int_CurrentPage = obj_Query.getIntCurrentPage(); 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; return CommonQuery.basicListQuery(str_Select, str_From, str_Where, Field.USERID, int_PageSize, int_CurrentPage); }
/// <summary> /// 订单基本信息列表查询 /// </summary> /// <param name="strXML"></param> /// <returns></returns> public static string ordersList(string strXML) { QueryDoc obj_Query = new QueryDoc(strXML); // 每页查询多少条记录 int int_PageSize = obj_Query.getIntPageSize(); // 查询第几页 int int_CurrentPage = obj_Query.getIntCurrentPage(); // 将xml分析成标准的where语句 string str_Where = obj_Query.getConditions(); str_Where = General.empty(str_Where) ? str_Where : Common.WHERE + str_Where; string str_Select = "*"; string str_From = "PIPELINE s"; return CommonQuery.basicListQuery(str_Select, str_From, str_Where, "PIPEID DESC", int_PageSize, int_CurrentPage); }