xitongcanshubiao.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 XiTongCanShuBiao
  extends RecordManager
{
  public XiTongCanShuBiao()
  {
  }

  protected final static String TableName = "XiTongCanShuBiao"; //定义声明本类操作表名称
  protected final static String IDFieldName = "ID"; //定义声明主键或者可以确定唯一记录的字段名称为“ID”，必须为自增整型
  protected final static String[] NumericFieldsName =
    {
    "PaiXuBianHao"
  }; //声明数值型字段名称
  protected final static String[] StringFieldsName =
    {
    "CanShuMingCheng", "MoRenZhi", "CanShuZhi", "BeiZhu", "BeiYongZiDuan"}; //声明字符型字段名称
  protected final static String[] DatetimeFieldsName =
    {}; //声明日期时间型字段名称
  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;
  }

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

  public static Vector getRecordBySearch(String strID, String strCanShuMingCheng,
                                         String strMoRenZhi,
                                         String strCanShuZhi,
                                         String strBeiZhu,
                                         String strPaiXuBianHao,
                                         String strShiFouShanChu,
                                         String strBeiYongZiDuan,
                                         String strOrderBy, String strIsDesc)
  {
    String strSQL = "SELECT a.[ID],a.[CanShuMingCheng],a.[MoRenZhi],a.[CanShuZhi],a.[BeiZhu],a.[PaiXuBianHao],a.[ShiFouShanChu],a.[ShanChuYongHuID],a.[ShanChuShiJian],a.[XinZengYongHuID],a.[XinZengShiJian],a.[XiuGaiYongHuID],a.[XiuGaiShiJian],a.[XiTongBeiZhu],a.[BeiYongZiDuan]  FROM "
      + TableName + " AS a WHERE a.[ID]>0";

    if (strID.trim().length() > 0)
    {
      strSQL += " AND a.[ID] in (" + strID + ")";
    }
    if (strCanShuMingCheng.trim().length() > 0)
    {
      strSQL += " AND a.[CanShuMingCheng]  LIKE '%" + strCanShuMingCheng + "%'";
    }
    if (strMoRenZhi.trim().length() > 0)
    {
      strSQL += " AND a.[MoRenZhi]  LIKE '%" + strMoRenZhi + "%'";
    }
    if (strCanShuZhi.trim().length() > 0)
    {
      strSQL += " AND a.[CanShuZhi]  LIKE '%" + strCanShuZhi + "%'";
    }
    if (strBeiZhu.trim().length() > 0)
    {
      strSQL += " AND a.[BeiZhu]  LIKE '%" + strBeiZhu + "%'";
    }

    if (strPaiXuBianHao.trim().length() > 0)
    {
      strSQL += " AND a.[PaiXuBianHao]  LIKE '%" + strPaiXuBianHao + "%'";
    }
    if (strShiFouShanChu.equalsIgnoreCase("True"))
    {
      strSQL += " AND a.[ShiFouShanChu] = 1";
    }
    else
    {
      strSQL += " AND a.[ShiFouShanChu] = 0";
    }
    if (strBeiYongZiDuan.trim().length() > 0)
    {
      strSQL += " AND a.[BeiYongZiDuan] >= (" + strBeiYongZiDuan + ")";
    }
    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;
  }

  /**
   * 删除指定ID记录
   * @param iID  记录ID
   * @return  错误代码（小于1表示错误，否则表示删除成功）
   */
  public int DeleteByID(int iID, int iUserID)
  {
    Vector vt = SQLManager.GetResultSet("Select ShiFouShanChu from " + TableName + " where " + IDFieldName + "=" + iID + "");
    if (vt.size() > 0)
    {
      if ( ( (Vector) vt.get(0)).get(0).toString().equalsIgnoreCase("True"))
      {
        /**
         * 该记录已经标记为已删除
         */
        return -7;
      }
      else
      {
        /**
         * 将记录标记更新为已删除，并插入删除用户和删除时间
         */
        SQLManager.ExcuteSQL("Update " + TableName + " set ShiFouShanChu=1 , ShanChuYongHuID=" + iUserID + ",ShanChuShiJian='"
                             + StringNew.GetDateString(new Date(), "yyyy-MM-dd HH:mm") + "' where " + IDFieldName + "=" + iID + "");
        /**
         * 删除成功
         */
        return 1;
      }
    }
    else
    {
      /**
       * 要删除的记录不存在
       */
      return -3;
    }
  }

  /**
    * 新增记录
    * @param m_request 包含新目录记录的Request请求
    * @return  新目录的ID（大于等于1）或者错误代码（小于1）
    */
   public int InsertRecord(Request m_request,int iUserID)
   {
      int iErrCode = super.InsertRecord(m_request);
      if (iErrCode>0)
      {
          /**
           *更新记录标记新增用户和新增时间、更新用户和更新时间
           */
          SQLManager.ExcuteSQL("Update " + TableName + " set ShiFouShanChu='0', XinZengYongHuID=" + iUserID + ",XinZengShiJian='"
                            + StringNew.GetDateString(new Date(), "yyyy-MM-dd HH:mm") + "',XiuGaiYongHuID=" + iUserID + ",XiuGaiShiJian='"
                            + StringNew.GetDateString(new Date(), "yyyy-MM-dd HH:mm") + "' where " + IDFieldName + "=" + iErrCode + "");
            return iErrCode;
        }
        else
        {
          /**
           * 返回错误代码
           */
           return iErrCode;
        }
    }

  /**
     * 修改目录记录
     * @param m_request 包含目录记录的Request请求
     * @return  目录的ID（大于等于1）或者错误代码（小于1）
     */

  public int UpdateRecord(Request m_request, int iUserID)
  {
    int iErrCode = super.UpdateRecord(m_request);
    if (iErrCode > 0)
    {
      /**
       * 更新记录标记更新用户和更新时间
       */
        SQLManager.ExcuteSQL("Update " + TableName + " set XiuGaiYongHuID=" + iUserID + ",XiuGaiShiJian='"
                             + StringNew.GetDateString(new Date(), "yyyy-MM-dd HH:mm") + "' where " + IDFieldName + "=" + m_request.GetInt(UpdateParament(IDFieldName)) + "");
        /**
         * 更新成功
         */
        return iErrCode;
    }
    else
    {
      /**
       * 返回错误代码
       */
      return iErrCode;
    }
  }

  /**
   * 获取执行名称的系统参数值
   * @param strCanShuMingCheng String 系统参数名称
   * @return String 系统参数值
   */
  public static String HuoQuXiTongCanShu(String strCanShuMingCheng)
  {
    String strSQL = "SELECT a.[MoRenZhi],a.[CanShuZhi],a.[BeiZhu],a.[PaiXuBianHao],a.[BeiYongZiDuan]  FROM "
      + TableName + " AS a WHERE a.[CanShuMingCheng]  LIKE '" + strCanShuMingCheng + "' Order by a.[ShiFouShanChu],a.[PaiXuBianHao]";
    Vector vt = SQLManager.GetResultSet(strSQL);
    if(vt.size()>0)
    {
      if(((Vector)vt.get(0)).get(1).toString().length()>0)
      {
        return ((Vector)vt.get(0)).get(1).toString();
      }
      else if(((Vector)vt.get(0)).get(0).toString().length()>0)
      {
        return ((Vector)vt.get(0)).get(0).toString();
      }
      else
      {
        SystemOut.InfoOut("系统参数“" +strCanShuMingCheng + "”设置不正确！");
        return "";
      }
    }
    else
    {
      SystemOut.ErrOut("请在系统维护-->系统参数管理中设置“" +strCanShuMingCheng + "”参数！！");
      return "请在系统维护-->系统参数管理中设置“" +strCanShuMingCheng + "”参数！";
    }
  }
}