Esempio n. 1
0
    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);
    }
Esempio n. 2
0
    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);
    }
Esempio n. 3
0
    /// <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);
    }
Esempio n. 4
0
      /// <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);
      }
Esempio n. 5
0
    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);
    }
Esempio n. 6
0
      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);
      }
Esempio n. 7
0
        /// <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);
        }
Esempio n. 8
0
        /// <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);
        }
Esempio n. 9
0
        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);
        }
Esempio n. 10
0
    /// <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);
    }
Esempio n. 11
0
    /// <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);
    }
Esempio n. 12
0
    /// <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);
    }
Esempio n. 13
0
        /// <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);
        }