jobinfomanager.java

一个目前正在上线运行的JSP企业网站系统

package com.gforce.gfoa;
/**
 * <p>Title: 西部信托网站项目</p>
 * <p>Description: 西部信托网站项目</p>
 * <p>Copyright: 版权所有 2004 (c) 西安吉力科技发展有限公司  Copyright (c) 2004 GForce Sceince & Technology</p>
 * <p>Company: 西安吉力科技发展有限公司 (GForce Sceince & Technology)</p>
 * @author 马登军
 * @version 1.0
 */

import com.gforce.currency.*;
import com.gforce.currency.database.*;
import java.sql.*;
import java.util.*;


public class JobInfoManager
    extends RecordManager {
    public JobInfoManager() {
    }

    protected final static String TableName = "JobInfo"; //定义声明本类操作表名称
    protected final static String IDFieldName = "ID"; //定义声明主键或者可以确定唯一记录的字段名称为“ID”，必须为自增整型
    protected final static String[] NumericFieldsName = {"RequestNumber","UpdateUserID","IsShow"}; //声明数值型字段名称
    protected final static String[] StringFieldsName = {"JobName","JobContent","UntilTime","JobRequest","PayAndDeal","MultUserID","MultSysID","Remark"}; //声明字符型字段名称
    protected final static String[] DatetimeFieldsName = {"UpdateTime",}; //声明日期时间型字段名称
    protected final static String[] TextFieldsName =        {}; //声明大字符串型字段名称

    /**
     * 根据字段名称获取插入数据时表单元素名称
     * @param strFieldName  字段名称
     * @return  表单素名称
     */
    protected String InsertParament(String strFieldName) {
        return "" + strFieldName + ""; //可以根据需要加前缀、后缀
    }

    /**
     * 根据字段名称获取修改数据时表单元素名称
     * @param strFieldName  字段名称
     * @return  表单素名称
     */
    protected String UpdateParament(String strFieldName) {
        return "" + strFieldName + ""; //可以根据需要加前缀、后缀
    }

    /**
     * 获取本类操作表名称
     * @return  表名称
     */
    public String getTableName() { //获取本类操作表名称
        return TableName;
    }

    protected String getIDFieldName() { //获取主键或者可以确定唯一记录的字段名称
        return IDFieldName;
    }

    protected String[] getNumericFieldsName() { //获取数值型字段名称
        return NumericFieldsName;
    }

    protected String[] getStringFieldsName() { //获取字符型字段名称
        return StringFieldsName;
    }

    protected String[] getDatetimeFieldsName() { //获取日期时间型字段名称
        return DatetimeFieldsName;
    }

    protected String[] getTextFieldsName() { //获取大字符串型字段名称
        return TextFieldsName;
    }

    /**
     * 获取指定系统、指定用户ID的图片友情链接记录
     * @return 指定系统、指定用户ID的图片友情链接记录
     */
    public static Vector getPicRecordBySysAndUserID(String strSysID,String strUserID)
    {
        Vector vt = SQLManager.GetResultSet("SELECT top 5 * FROM " + TableName + " where MultSysID = '"+ strSysID +"'and MultUserID = '"+ strUserID +"' and IsPicLink = '1' and IsShow = '1' order by UpdateTime desc ");
        return vt;
    }
    /**
     * 获取指定系统、指定用户ID的文字友情链接记录
     * @return 指定系统、指定用户ID的图片友情链接记录
     */
     public static Vector getWordRecordBySysAndUserID(String strSysID,String strUserID)
     {
       Vector vt = SQLManager.GetResultSet("SELECT top 5 * FROM " + TableName + " where MultSysID = '"+ strSysID +"'and MultUserID = '"+ strUserID +"' and IsPicLink = '0' and IsShow = '1' order by UpdateTime desc ");
       return vt;
      }

    /**
     * 获取风格名称
     * @param iStyleID 风格ID
     * @return 指定风格名称
     */
    public static String getStyleNameByID(int iStyleID)
    {
        String strReturnValue="未知风格";
        Vector vt =SQLManager.GetResultSet("SELECT Name FROM "+ TableName +
                                            " WHERE ID = " + iStyleID + "");
         if (vt.size() == 1)
         {
            strReturnValue = ((Vector)vt.get(0)).get(0).toString();
         }
         return strReturnValue;
    }

    /**
     * 获取指定ID的风格记录数据集
     * @param iID 风格ID
     * @return 指定ID的风格记录数据集
     */
    public static Vector getRecordByID(int iID)
    {
        Vector vt = SQLManager.GetResultSet("SELECT * FROM " + TableName + " where ID = " + iID);
        return vt;
    }

    public static Vector getRecordByIDs(String strIDs)
    {
      return getRecordBySearch(strIDs,"","","","","","","","","","","","","","","","","");
    }

        /**
       * 获取符合条件的数据集
       * @param strIDs String
       * @param strJobName String
       * @param strRequestNumberL String
       * @param strJobContent String
       * @param strUntilTime String
       * @param strUpdateStartDate String
       * @param strUpdateEndDate String
       * @param strUpdateUserID String
       * @param strRemark String
       * @param strIsShow String
       * @param strJobRequest String
       * @param strPayAndDeal String
       * @param strUserID String
       * @param strUserName String
       * @param strMultUserID String
       * @param strMultSysID String
       * @param strOrderBy String
       * @param strIsDesc String
       * @return Vector 获取符合条件的数据集
       */

    public static Vector getRecordBySearch(String strIDs,String strJobName,String strRequestNumber,String strJobContent,String strUntilTime,String strUpdateStartDate,String strUpdateEndDate,String strUpdateUserID,String strRemark,String strIsShow,String strJobRequest,String strPayAndDeal,String strUserID,String strUserName,String strMultUserID,String strMultSysID,String strOrderBy,String strIsDesc)
    {
      String strSQL = "select a.[ID],a.[JobName],a.[RequestNumber],a.[JobContent],a.[UntilTime],a.[UpdateTime],a.[UpdateUserID],a.[Remark],a.[IsShow],a.[JobRequest],a.[PayAndDeal],b.[ID],b.[UserName],a.[MultUserID],a.[MultSysID],c.[Name] from " + TableName + " as a left outer join UserInfo as b on (a.[UpdateUserID]=b.[ID]) left outer join PersonnelInfo as c on (c.[ID]=b.[PersonnelID]) WHERE a.[ID] > 0";
      if (strIDs.trim().length() > 0)
         {
           strSQL += " and (a.[ID] in (" + strIDs + "))";
         }

         if (strJobName.trim().length() > 0)
         {
           strSQL += " and a.[JobName] like '%" + strJobName + "%'";
         }
         if (strRequestNumber.trim().length() > 0)
         {
            strSQL += " and (a.[RequestNumber] in (" + strRequestNumber + "))";
         }
         if (strJobContent.trim().length() > 0)
         {
           strSQL += " and a.[JobContent] like '%" + strJobContent + "%'";
         }
         if (strUntilTime.trim().length() > 0)
         {
           strSQL += " and a.[UntilTime] like '%" + strUntilTime + "%'";
         }
         if (strUpdateStartDate.trim().length() > 0 && strUpdateEndDate.trim().length() > 0 )
         {
           strSQL += " and a.[UpdateTime] >= '" + strUpdateStartDate + " 00:00:00.000' and a.[UpdateTime]<='" + strUpdateEndDate + " 23:59:59.999'";

         }
         if (strUpdateUserID.trim().length() > 0)
         {
           strSQL += " and (a.[UpdateUserID] in (" + strUpdateUserID + "))";

         }
         if (strRemark.trim().length() > 0)
         {
           strSQL += " and a.[Remark] like '%" + strRemark + "%'";
         }
         if (strIsShow.trim().length() > 0)
         {
           if (strIsShow.equalsIgnoreCase("True"))
           {
             strSQL += " and a.[IsShow] = 1";
           }
           else if (strIsShow.equalsIgnoreCase("False"))
           {
             strSQL += " and a.[IsShow] = 0";
           }
         }
         if (strJobRequest.trim().length() > 0)
         {
           strSQL += " and a.[JobRequest] like '%" + strJobRequest + "%'";
         }
         if (strPayAndDeal.trim().length() > 0)
         {
           strSQL += " and a.[PayAndDeal] like '%" + strPayAndDeal + "%'";
         }
         if (strUserID.trim().length() > 0)
         {
           strSQL += " and (b.[ID] in (" + strUserID + "))";

         }
         if (strUserName.trim().length() > 0)
         {
           strSQL += " and c.[Name] like '%" + strUserName + "%'";
         }

         if (strMultUserID.trim().length() > 0)
         {
           strSQL += " and a.[MultUserID] like '%" + strMultUserID + "%'";
         }
         if (strMultSysID.trim().length() > 0)
         {
           strSQL += " and a.[MultSysID] like '%" + strMultSysID + "%'";
         }
         if (strOrderBy.trim().length() > 0)
         {
           if (strIsDesc.equalsIgnoreCase("True"))
           {
             strSQL += " Order by " + strOrderBy + " desc";
           }
           else
           {
             strSQL += " Order by " + strOrderBy + "";
           }
         }
         else
         {
           strSQL += " Order by a.[UpdateTime]";
         }

      Vector vt = SQLManager.GetResultSet(strSQL);
      return vt;
  }

}