basepaymanager.java

一个完整的

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

/**
 *
 * <p>Title: 吉力科技办公自动化系统</p>
 * <p>Description: 吉力科技办公自动化系统</p>
 * <p>Copyright: 版权所有 2003 (c) 西安吉力科技发展有限公司  Copyright (c) 2003 GForce Sceince & Technology</p>
 * <p>Company: 西安吉力科技发展有限公司 (GForce Sceince & Technology)</p>
 * @author 王江涛
 * @version 1.0
 */
public class BasePayManager
    extends RecordManager
{
    public BasePayManager()
    {
    }

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

    /**
     * 获取所有工资记录集并按照用户ID，条目编号排序。
     * @return 所有资产记录集
     */
    public static Vector getAllRecord()
    {
      Vector vt = SQLManager.GetResultSet("Select * from " + TableName + "  Order By PersonnelID,(Select OrderNumber From PayTypeInfo Where "+TableName+".PayTypeID = PayTypeInfo.ID) ");
        return vt;
    }

    /**
     *获取指定用户的工资记录集
     * @return 工资记录集
     */
    public static Vector getRecordByPersonnelID(int PersonnelID)
    {
      Vector vt = SQLManager.GetResultSet("Select * from " + TableName + " Where PersonnelID = "+PersonnelID+" Order By (Select OrderNumber From PayTypeInfo Where "+TableName+".PayTypeID = PayTypeInfo.ID) ");
        return vt;
    }

    /**
     * 数据初始化
     * @return 是否成功
     */
    public static int Initalize()
    {
      int iOk = 1;
      Vector vt = SQLManager.GetResultSet("Select ID from PersonnelInfo where ID Not in(select DISTINCT PersonnelID from " + TableName + ") and (not Number like '%离职%')");
      if (vt.size()>0)
      {
        Vector vtPayType = PayTypeManager.getAllRecord();
        for(int i=0;i<vt.size();i++)
        {
          for (int j = 0; j < vtPayType.size(); j++)
          {
            SQLManager.ExcuteSQL("Insert Into " + TableName + " (PersonnelID,PayTypeID,Pay) VALUES ("
                                       + ( (Vector) vt.get(i)).get(0).toString() + ","
                                       + ( (Vector) vtPayType.get(j)).get(0).toString() + ",0)");
          }
        }
      }
      SQLManager.ExcuteSQL("Delete from " + TableName + " where PersonnelID in (Select ID from PersonnelInfo where Number like '%离职%')");
      vt = SQLManager.GetResultSet("Select ID from PayTypeInfo where ID Not in(select DISTINCT PayTypeID from " + TableName + ")");
      if (vt.size()>0)
      {
        Vector vtPersonnel = PersonnelManager.getAllRecord();
        for(int i=0;i<vt.size();i++)
        {
          for (int j = 0; j < vtPersonnel.size(); j++)
          {
            SQLManager.ExcuteSQL("Insert Into " + TableName + " (PayTypeID,PersonnelID,Pay) VALUES ("
                                       + ( (Vector) vt.get(i)).get(0).toString() + ","
                                       + ( (Vector) vtPersonnel.get(j)).get(0).toString() + ",0)");
          }
        }
      }
      return iOk;
    }
    /**
     * 基本工资的修改
     * @param m_request 修改的参数
     * @return 修改结果
     */
    public int UpdateRecord(Request m_request)
    {
        int iReturnValue = 0;
        int iPersonnelID = m_request.GetInt("PersonnelID");
        Vector vt = BasePayManager.getRecordByPersonnelID(iPersonnelID);
        if (vt.size() > 0)
        {
            for (int i = 0; i < vt.size(); i++)
            {
                String strPersonnelID = ( (Vector) vt.get(i)).get(1).toString();
                String strPayTypeID = ( (Vector) vt.get(i)).get(2).toString();
                String strPay = m_request.GetString("Name" + strPayTypeID);
                Vector vt1 = new Vector();
                vt1 = SQLManager.GetResultSet("Select * from BasePayInfo where (PersonnelID=" + strPersonnelID + " and PayTypeID=" + strPayTypeID + ")");
                if (vt1.size() > 0)
                {
                  iReturnValue = SQLManager.ExcuteSQL("UPDATE BasePayInfo SET Pay=" + strPay + " where (PersonnelID=" + strPersonnelID + " and PayTypeID=" + strPayTypeID + ")");
                }
                else
                {
               //   SQLManager.ExcuteSQL("Insert BasePayInfo (AssetID,FieldID,FieldValue) Values (" + strAssetID + "," + strFieldID + ",'" + strFieldValue + "')");
                }
             }
        }
        return iReturnValue;
    }

    /**
     * 获取工资类别的统计
     * @return 统计结果
     */
    public static Vector getSUMPayRecord()
    {
      Vector vt = SQLManager.GetResultSet("Select SUM(Pay) as SumPay,PayTypeID from " + TableName + " Group By PayTypeID  Order By (Select OrderNumber From PayTypeInfo Where "+TableName+".PayTypeID = PayTypeInfo.ID) ");
      return vt;
    }

    /**
     * 统一修改工资条目的金额
     * @param m_request 修改的数据参数
     * @return 修改的结果
     */
    public int UnifyEditePayRecord(Request m_request)
    {
      int iReture = 0;
      String strPayType = m_request.GetString("PayType");
      String strOperator = m_request.GetString("Operator");
      String strPay = m_request.GetString("Pay");
      if (strOperator.equalsIgnoreCase("="))
      {
        iReture = SQLManager.ExcuteSQL("Update " + TableName + " SET Pay = " + strPay
                                       + " WHERE PayTypeID = " + strPayType + "");
      }else
      {
        iReture = SQLManager.ExcuteSQL("Update " + TableName + " SET Pay = (Pay " + strOperator + strPay
                                       + ") WHERE PayTypeID = " + strPayType + "");
      }
      return iReture;
    }

    public int UnifyEditePayTypeRecord(Request m_request)
    {
      int iReture = 0;
      String strPayType = m_request.GetString("PayType");
      String strPayType1 = m_request.GetString("PayType1");
      Vector vt = SQLManager.GetResultSet("Select distinct PersonnelID from " + TableName + "");
      if (vt.size()>0)
      {
        for(int i = 0;i < vt.size();i++)
        {
          String strPersonnelID = ((Vector)vt.get(i)).get(0).toString();
          iReture = SQLManager.ExcuteSQL("Update " + TableName + " SET Pay = (Select Pay from " + TableName + " Where (PersonnelID = "+ strPersonnelID +")and(PayTypeID = "+ strPayType +")) Where (PersonnelID = "+ strPersonnelID +")and(PayTypeID = "+ strPayType1 +")");
        }
      }
      return iReture;
    }

    /**
     * 获取所有员工基本工资记录集
     * @return 工资记录集
     */
    public static Vector getRecord()
    {
      Vector vt = SQLManager.GetResultSet("Select a.*,b.Number,b.Name from " + TableName + " as a left outer join PersonnelInfo as b on(a.PersonnelID=b.ID) left outer join PayTypeInfo as c on(a.PayTypeID=c.ID)  Order By b.Number,c.OrderNumber");
      return vt;
    }


}