zaixianzixun_manager.java

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

package com.gforce.gfoa;

/**
 * <p>Title: 吉力科技网站</p>
 * <p>Description: 吉力科技网站</p>
 * <p>Copyright: 版权所有 2003 (c) Ts  Copyright (c) 2003 Ts Sceince & Technology</p>
 * <p>Company: Ts (Ts Sceince & Technology)</p>
 * @exception 用户在线咨询管理类
 * @author 李霞
 * @version 1.0
 */

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

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

  protected final static String TableName = "ZaiXianZiXun"; //定义声明本类操作表名称
  protected final static String IDFieldName = "ID"; //定义声明主键或者可以确定唯一记录的字段名称为“ID”，必须为自增整型
  protected final static String[] NumericFieldsName =
    {
    "ShiFouBMLXFangShi", "ShiFouBMNeiRong", "DaFuYongHuID"
  }; //声明数值型字段名称
  protected final static String[] StringFieldsName =
    {
    "XingMing", "ChengHu", "E_mail", "LianXiDianHua", "QiTaLianXiFangShi", "ZhuYeDiZhi", "BiaoTi", "NeiRong", "ZiXunIPDiZhi",
    "DaFuNeiRong"
  }; //声明字符型字段名称
  protected final static String[] DatetimeFieldsName =
    {
    "ZiXunShiJian", "DaFuShiJian"}; //声明日期时间型字段名称
  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;
  }

  /**
   *
   * @param strID String
   * @param strChuanZhenID String
   * @param strShiFouQianDan String
   * @param strOrderBy String
   * @param strIsDesc String
   * @return String
   */
  public static Vector getRecordBySearch(String strID)
  {
    return getRecordBySearch(strID, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "");
  }

  public static Vector getRecordBySearch(String strID,
                                         String strXingMing,
                                         String strChengHu,
                                         String strE_mail,
                                         String strLianXiDianHua,
                                         String strQiTaLianXiFangShi,
                                         String strZhuYeDiZhi,
                                         String strBiaoTi,
                                         String strNeiRong,
                                         String strShiFouBMLXFangShi,
                                         String strShiFouBMNeiRong,
                                         String strZiXunShiJian,
                                         String strZiXunIPDiZhi,
                                         String strDaFuNeiRong,
                                         String strDaFuShiJian,
                                         String strDaFuYongHuID,
                                         String strOrderBy,
                                         String strIsDesc)
  {
    String strSQL = "SELECT a.[ID],a.[XingMing],a.[ChengHu],a.[E_mail],a.[LianXiDianHua],a.[QiTaLianXiFangShi]," +
      "a.[ZhuYeDiZhi],a.[BiaoTi],a.[NeiRong],a.[ShiFouBMLXFangShi],a.[ShiFouBMNeiRong],a.[ZiXunShiJian]," +
      "a.[ZiXunIPDiZhi],a.[DaFuNeiRong],a.[DaFuShiJian],a.[DaFuYongHuID],c.[Name] FROM "
      + TableName + " AS a LEFT OUTER JOIN [UserInfo] AS b ON (a.[DaFuYongHuID] = b.[ID]) LEFT OUTER JOIN [PersonnelInfo] AS c ON (b.[PersonnelID] = c.[ID]) WHERE a.[ID]>0";
    if (strID.trim().length() > 0)
    {
      strSQL += " AND a.[ID] in (" + strID + ")";
    }
    if (strXingMing.trim().length() > 0)
    {
      strSQL += " AND a.[XingMing] like '%" + strXingMing + "%'";
    }
    if (strChengHu.trim().length() > 0)
    {
      strSQL += " AND a.[ChengHu] like '%" + strChengHu + "%'";
    }
    if (strE_mail.trim().length() > 0)
    {
      strSQL += " AND a.[E_mail] like '%" + strE_mail + "%'";
    }
    if (strLianXiDianHua.trim().length() > 0)
    {
      strSQL += " AND a.[LianXiDianHua] like '%" + strLianXiDianHua + "%'";
    }
    if (strQiTaLianXiFangShi.trim().length() > 0)
    {
      strSQL += " AND a.[QiTaLianXiFangShi] like '%" + strQiTaLianXiFangShi + "%'";
    }
    if (strShiFouBMLXFangShi.trim().length() > 0)
    {
      if (strShiFouBMLXFangShi.equalsIgnoreCase("true"))
      {
        strSQL += " AND a.[ShiFouBMLXFangShi] = 1";
      }
      else
      {
        strSQL += " AND a.[ShiFouBMLXFangShi] = 0";
      }
    }
    if (strShiFouBMNeiRong.trim().length() > 0)
    {
      if (strShiFouBMNeiRong.equalsIgnoreCase("true"))
      {
        strSQL += " AND a.[ShiFouBMNeiRong] = 1";
      }
      else
      {
        strSQL += " AND a.[ShiFouBMNeiRong] = 0";
      }
    }
    if (strZhuYeDiZhi.trim().length() > 0)
    {
      strSQL += " AND a.[ZhuYeDiZhi] like '%" + strZhuYeDiZhi + "%'";
    }

    if (strZiXunShiJian.trim().length() > 0)
    {
      strSQL += " AND a.[ZiXunShiJian] '%" + strZiXunShiJian + "%'";
    }
    if (strDaFuShiJian.trim().length() > 0)
    {
      strSQL += " AND a.[DaFuShiJian] = '%" + strDaFuShiJian + "%'";
    }

    if (strDaFuYongHuID.trim().length() > 0)
    {
      strSQL += " AND a.[DaFuYongHuID] like '%" + strDaFuYongHuID + "%'";
    }
    if (strBiaoTi.trim().length() > 0)
    {
      strSQL += " AND a.[BiaoTi] like '%" + strBiaoTi + "%'";
    }
    if (strNeiRong.trim().length() > 0)
    {
      strSQL += " AND a.[NeiRong] like '%" + strNeiRong + "%'";
    }
    if (strZiXunIPDiZhi.trim().length() > 0)
    {
      strSQL += " AND a.[ZiXunIPDiZhi] like '%" + strZiXunIPDiZhi + "%'";
    }
    if (strDaFuNeiRong.trim().length() > 0)
    {
      strSQL += " AND a.[DaFuNeiRong] like '%" + strDaFuNeiRong + "%'";
    }
    if (strOrderBy.trim().length() > 0)
    {
      if (strIsDesc.trim().length() > 0)
      {
        strSQL += " ORDER BY " + strOrderBy + " Desc";
      }
      else
      {
        strSQL += " ORDER BY " + strOrderBy;
      }
    }

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

  public static Vector getRecordByID(String strID)
  {
    Vector vt = getRecordBySearch(strID);
    return vt;
  }

  /**
   *
   * @param strID String
   * @param strZhuYeDiZhi String
   * @param strBiaoTi String
   * @param strNeiRong String
   * @param strDaFuNeiRong String
   * @param strDaFuYongHuID String
   * @return int
   */
  public int UpdateRecord(String strID,
                          String strZhuYeDiZhi,
                          String strBiaoTi,
                          String strNeiRong,
                          String strDaFuNeiRong,
                          String strDaFuYongHuID
    )
  {
    if (strID.trim().length() > 0)
    {
      String SQLUpdate = "";
      SQLUpdate += "Update " + TableName + " set ZhuYeDiZhi = '" + strZhuYeDiZhi + "'," +
        "BiaoTi = '" + strBiaoTi + "'," +
        "NeiRong = '" + strNeiRong + "'," +
        " DaFuYongHuID = " + strDaFuYongHuID + "," +
        " DaFuShiJian = '" + StringNew.GetDateString(new Date(),"yyyy-MM-dd HH:mm") + "'," +
        " DaFuNeiRong = '" + strDaFuNeiRong + "' where ID=" + strID;

      int iErrCode = SQLManager.ExcuteSQL(SQLUpdate);
      return iErrCode;
    }
    else
    {
      return -999;
    }
  }
}