danweixingzhibiao_manager.java

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

/**
 * yinrubao
 */
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 DanWeiXingZhiBiao_Manager
  extends RecordManager
{
  public DanWeiXingZhiBiao_Manager()
  {
  }
  /**
   * 定义声明本类操作表名称
   */
  protected final static String TableName = "DanWeiXingZhiBiao";
  protected final static String IDFieldName = "ID"; //定义声明主键或者可以确定唯一记录的字段名称为“ID”，必须为自增整型
  protected final static String[] NumericFieldsName =
    {
    "ShiFouMoRen","ShiFouShanChu","PaiXuBianHao"
    }; //声明数值型字段名称
  protected final static String[] StringFieldsName =
    {
    "XingZhiMingCheng","BeiZhu","XiTongBeiZhu","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;
  }
  /**
   *
   * @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 strXingZhiMingCheng,
                                         String strShiFouMoRen,
                                         String strBeiZhu,
                                         String strPaiXuBianHao,
                                         String strShiFouShanChu,
                                         String strXiTongBeiZhu,
                                         String strBeiYongZiDuan,
                                         String strOrderBy,
                                         String strIsDesc)
  {
    String strSQL = "SELECT a.[ID],a.[XingZhiMingCheng],a.[ShiFouMoRen],a.[BeiZhu],a.[PaiXuBianHao],a.[ShiFouShanChu],"+
                    "a.[XiTongBeiZhu],a.[BeiYongZiDuan] FROM "
                     + TableName + " AS a WHERE a.[ID]>0";
    if (strID.trim().length() > 0)
    {
      strSQL += " AND a.[ID] in (" + strID + ")";
    }
    if (strXingZhiMingCheng.trim().length() > 0)
    {
      strSQL += " AND a.[XingZhiMingCheng] in (" + strXingZhiMingCheng + ")";
    }
    if (strShiFouMoRen.trim().length() > 0)
    {
      strSQL += " AND a.[ShiFouMoRen] in (" + strShiFouMoRen + ")";
    }
    if (strBeiZhu.trim().length() > 0)
    {
      strSQL += " AND a.[BeiZhu] in (" + strBeiZhu + ")";
    }
    if (strPaiXuBianHao.trim().length() > 0)
    {
      strSQL += " AND a.[PaiXuBianHao] in (" + strPaiXuBianHao + ")";
    }
    if (strShiFouShanChu.equalsIgnoreCase("True"))
    {
     strSQL += " AND a.[ShiFouShanChu] = 1";
     }
     else
     {
     strSQL += " AND a.[ShiFouShanChu] = 0";
     }
     if (strXiTongBeiZhu.trim().length() > 0)
     {
     strSQL += " AND a.[XiTongBeiZhu] = " + strXiTongBeiZhu ;
     }
    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;
    }
  }
}