shiyongshenqing_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 ShiYongShenQing_Manager
  extends RecordManager
{
  public ShiYongShenQing_Manager()
  {
  }

  protected final static String TableName = "ShiYongShenQing"; //定义声明本类操作表名称
  protected final static String IDFieldName = "ID"; //定义声明主键或者可以确定唯一记录的字段名称为“ID”，必须为自增整型
  protected final static String[] NumericFieldsName =
    {
    "ShiFouDanWeiYongHu","DanWeiXingZhiLeiXing","HangYeID"
    }; //声明数值型字段名称
  protected final static String[] StringFieldsName =
    {
    "XingMing","ChengHu","E_mail","LianXiDianHua","DanWeiMingCheng","ZhiWei","ChuanZhen","ZhuYeDiZhi","TongXunDiZhi",
    "YouZhengBianMa","ShiYongChanPinIDs","ShouJiHaoMa","SuoZaiBuMen"
    }; //声明字符型字段名称
  protected final static String[] DatetimeFieldsName =
    {"DengJiShiJian"}; //声明日期时间型字段名称
  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 strShiFouDanWeiYongHu,
                                         String strDanWeiMingCheng,
                                         String strZhiWei,
                                         String strDanWeiXingZhiLeiXing,
                                         String strHangYeID,
                                         String strChuanZhen,
                                         String strZhuYeDiZhi,
                                         String strTongXunDiZhi,
                                         String strYouZhengBianMa,
                                         String strShiYongChanPinIDs,
                                         String strDengJiShiJian,
                                         String strShouJiHaoMa,
                                         String StrSuoZaiBuMen,
                                         String strOrderBy,
                                         String strIsDesc)
  {
    String strSQL = "SELECT a.[ID],a.[XingMing],a.[ChengHu],a.[E_mail],a.[LianXiDianHua],a.[ShiFouDanWeiYongHu],"+
                    "a.[DanWeiMingCheng],a.[ZhiWei],a.[DanWeiXingZhiLeiXing],a.[HangYeID],a.[ChuanZhen],a.[ZhuYeDiZhi],"+
                    "a.[ShiFouYunXuShiYong],a.[ShenPiShiJian],a.[ShenPiYongHuID],a.[ShenPineiRong],a.[YunXuShiYongXiTongIDs],"+
                    "a.[ShiYongYongHuMing],a.[ShiYongChuShiMiMa],a.[ShiYongJieZhiShiJian],a.[ShiFouZhongZhiShiYong],a.[ZhongZhiShiYongYuanYin],"+
                    "a.[TongXunDiZhi],a.[YouZhengBianMa],a.[ShiYongChanPinIDs],a.[DengJiShiJian],b.[HangYeMingCheng],c.[XingZhiMingCheng],a.[ShouJiHaoMa],a.[SuoZaiBuMen] FROM "
                     + TableName + " AS a LEFT OUTER JOIN [SuoShuHangYe] AS b ON (a.[HangYeID] = b.[ID]) LEFT OUTER JOIN [DanWeiXingZhiBiao] AS c ON (a.[DanWeiXingZhiLeiXing] = 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 (strShiFouDanWeiYongHu.equalsIgnoreCase("True"))
    {
     strSQL += " AND a.[ShiFouDanWeiYongHu] = 1";
     }
     else
     {
     strSQL += " AND a.[ShiFouDanWeiYongHu] = 0";
    }
    if (strDanWeiMingCheng.trim().length() > 0)
    {
    strSQL += " AND a.[DanWeiMingCheng] like '%" + strDanWeiMingCheng +"%'" ;
    }
    if (strZhiWei.trim().length() > 0)
    {
    strSQL += " AND a.[ZhiWei]  '%" + strZhiWei+"%'" ;
    }
    if (strDanWeiXingZhiLeiXing.trim().length() > 0)
    {
    strSQL += " AND a.[DanWeiXingZhiLeiXing] = " + strDanWeiXingZhiLeiXing ;
    }
    if (strHangYeID.trim().length() > 0)
    {
    strSQL += " AND a.[HangYeID] = " + strHangYeID ;
    }
    if (strChuanZhen.trim().length() > 0)
    {
    strSQL += " AND a.[ChuanZhen] like '%" + strChuanZhen+"%'" ;
    }
    if (strZhuYeDiZhi.trim().length() > 0)
    {
    strSQL += " AND a.[ZhuYeDiZhi] like '%" + strZhuYeDiZhi+"%'" ;
    }
    if (strTongXunDiZhi.trim().length() > 0)
    {
    strSQL += " AND a.[TongXunDiZhi] like '%" + strTongXunDiZhi +"%'";
    }
    if (strYouZhengBianMa.trim().length() > 0)
    {
    strSQL += " AND a.[YouZhengBianMa] like '%" + strYouZhengBianMa+"%'" ;
    }
    if (strShiYongChanPinIDs.trim().length() > 0)
    {
    strSQL += " AND a.[ShiYongChanPinIDs] like '%" + strShiYongChanPinIDs+"%'" ;
    }
    if (strDengJiShiJian.trim().length() > 0)
    {
    strSQL += " AND a.[DengJiShiJian] = " + strDengJiShiJian ;
    }
    if (StrSuoZaiBuMen.trim().length() > 0)
   {
   strSQL += " AND a.[SuoZaiBuMen] like '%" + StrSuoZaiBuMen+"%'" ;
   }
   if (strShouJiHaoMa.trim().length() > 0)
  {
  strSQL += " AND a.[ShouJiHaoMa] like '%" + strShouJiHaoMa+"%'" ;
  }


    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)
  {
    int iErrCode = super.DeleteByID(iID);
    return iErrCode;
  }

  /**
    * 新增记录
    * @param m_request 包含新目录记录的Request请求
    * @return  新目录的ID（大于等于1）或者错误代码（小于1）
    */
   public int InsertRecord(Request m_request)
   {
      int iErrCode = super.InsertRecord(m_request);
      return iErrCode;
   }

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

  public int UpdateRecord(Request m_request)
  {
    int iErrCode = super.UpdateRecord(m_request);
      return iErrCode;
  }
  /**
   * 根据ID修改该条记录
   * @param strID ID
   * @param strShiFouYunXuShiYong 是否允许试用
   * @param strShenPiShiJian 审批时间
   * @param strShenPiYongHuID 审批用户ID
   * @param strShenPiNeiRong 审批内容
   * @param strYunxuShiYongXiTongIDs 允许试用IDS
   * @param strShiYongJieZhiShiJian String
   * @param strShiFouZhongZhiShiYong String
   * @param strZhongZhiShiYongYuanYin String
   * @return int
   */
  public int UpdateRecord(String strID,
                        String strShiFouYunXuShiYong,
                        String strShenPiYongHuID,
                        String strShenPiNeiRong,
                        String strYunxuShiYongXiTongIDs,
                        String strShiYongJieZhiShiJian,
                        String strShiFouZhongZhiShiYong,
                        String strZhongZhiShiYongYuanYin
                        )
  {
    if (strID.trim().length()>0)
    {
      String SQLUpdate="";
      if (strShiFouYunXuShiYong.trim().length()==0)
      {
      strShiFouYunXuShiYong="False";
      }
      if (strShenPiYongHuID.trim().length()==0)
      {
        strShenPiYongHuID="";
      }
      if (strShenPiNeiRong.trim().length()==0)
      {
      strShenPiNeiRong="";
      }
      if (strYunxuShiYongXiTongIDs.trim().length()==0)
      {
      strYunxuShiYongXiTongIDs="";
      }
      if (strShiFouZhongZhiShiYong.trim().length()==0)
      {
      strShiFouZhongZhiShiYong="False";
      }
      if (strZhongZhiShiYongYuanYin.trim().length()==0)
      {
      strZhongZhiShiYongYuanYin="";
      }
      SQLUpdate += "Update "+ TableName +" set ShiFouYunXuShiYong = " + strShiFouYunXuShiYong + "," +
                                         " ShenPiShiJian = '" + StringNew.GetDateString(new Date(), "yyyy-MM-dd HH:mm") + "'," +
                                         " ShenPiYongHuID = " + strShenPiYongHuID + "," +
                                         " ShenPiNeiRong = '" + strShenPiNeiRong + "'," +
                                         " YunxuShiYongXiTongIDs = '" + strYunxuShiYongXiTongIDs + "',";

      if (strShiYongJieZhiShiJian.trim().length()>0)
      {
      SQLUpdate += " ShiYongJieZhiShiJian = '" + strShiYongJieZhiShiJian + "',";
      }
      else
      {
      SQLUpdate += " ShiYongJieZhiShiJian = NULL,";
      }
      SQLUpdate += " ShiFouZhongZhiShiYong = " + strShiFouZhongZhiShiYong + "," +
                   " ZhongZhiShiYongYuanYin = '" + strZhongZhiShiYongYuanYin +"'"+
                   " WHERE ID = " + strID;

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