jquery表格排序(17)

             v_current_page = "1";
         }
         if(StringUtil.isEmpty(v_order_type)){
         v_order_type = "DESC";//按降序排列
         }
         String v_sql_where = " 1=1";//查询条件
         if(StringUtil.isNotEmpty(datapatchInf.getSerialnumber())){
             v_sql_where+=" and upper(SERIAL_NUMBER) like'%"+datapatchInf.getSerialnumber().toUpperCase()+"%'";
         }
         if(StringUtil.isNotEmpty(datapatchInf.getSystem())){
             v_sql_where+=" and U_SYS='"+datapatchInf.getSystem()+"'";
         }
         if(StringUtil.isNotEmpty(datapatchInf.getService())){
             v_sql_where+=" and U_SYSTEM='"+datapatchInf.getService()+"'";
         }
         if(StringUtil.isNotEmpty(datapatchInf.getSa())){
             v_sql_where+=" and SA_USERID='"+datapatchInf.getSa()+"'";
         }
         if(StringUtil.isNotEmpty(datapatchInf.getRaisedby())){
             v_sql_where+=" and U_USERID='"+datapatchInf.getRaisedby()+"'";
         }
         if(StringUtil.isNotEmpty(datapatchInf.getPriority())){
             v_sql_where+=" and U_PRIORITY='"+datapatchInf.getPriority()+"'";
         }
         if(StringUtil.isNotEmpty(datapatchInf.getDeveloper())){
             v_sql_where+=" and ITD_DEV_USERID="+datapatchInf.getDeveloper()+"";
         }
         if(StringUtil.isNotEmpty(datapatchInf.getStatus())){
             v_sql_where+=" and ITD_STATUS='"+datapatchInf.getStatus()+"'";