404 lines
14 KiB
C#
404 lines
14 KiB
C#
using System.Runtime.Serialization;
|
|
|
|
namespace SuperMap.RealEstate.Personnel.Running.Interface
|
|
{
|
|
#region T_SALARYPAYROLL_OFFICE ISALARYPAYROLL_OFFICE 接口
|
|
/// <summary>
|
|
/// T_SALARYPAYROLL_OFFICE 接口
|
|
/// </summary>
|
|
public interface ISALARYPAYROLL_OFFICE
|
|
{
|
|
/// <summary>
|
|
/// 应扣工资
|
|
/// </summary>
|
|
System.Double? DEDUCTION_SALARY { get; set; }
|
|
/// <summary>
|
|
/// 应发工资
|
|
/// </summary>
|
|
System.Double? WAGES_PAYABLE { get; set; }
|
|
/// <summary>
|
|
/// 养老保险
|
|
/// </summary>
|
|
System.Double? ENDOWMENT_INSURANCE { get; set; }
|
|
/// <summary>
|
|
/// 医疗保险
|
|
/// </summary>
|
|
System.Double? MEDICAL_INSURANCE { get; set; }
|
|
/// <summary>
|
|
/// 失业保险
|
|
/// </summary>
|
|
System.Double? UNEMPLOYMENT_INSURANCE { get; set; }
|
|
/// <summary>
|
|
/// 住房公积金
|
|
/// </summary>
|
|
System.Double? HOUSING_PROVIDENT_FUND { get; set; }
|
|
/// <summary>
|
|
/// 实发工资
|
|
/// </summary>
|
|
System.Double? FINAL_WAGES { get; set; }
|
|
/// <summary>
|
|
/// 应扣税款
|
|
/// </summary>
|
|
System.Double? DEDUCTION_TAX { get; set; }
|
|
/// <summary>
|
|
/// 代扣伙食费
|
|
/// </summary>
|
|
System.Double? MEAL_EXPENSE { get; set; }
|
|
/// <summary>
|
|
/// 实领工资
|
|
/// </summary>
|
|
System.Double? TAKE_WAGES { get; set; }
|
|
/// <summary>
|
|
/// 备注
|
|
/// </summary>
|
|
System.String SALARYPAYROLL_OFFICE_DESC { get; set; }
|
|
/// <summary>
|
|
/// 内码
|
|
/// </summary>
|
|
System.Int32? SALARYPAYROLL_OFFICE_ID { get; set; }
|
|
/// <summary>
|
|
/// 内码 的加密字符串
|
|
/// </summary>
|
|
string SALARYPAYROLL_OFFICE_ID_Encrypt { get; set; }
|
|
/// <summary>
|
|
/// 流程内码
|
|
/// </summary>
|
|
System.Int32? PERSONNELPROINST_ID { get; set; }
|
|
/// <summary>
|
|
/// 薪资日期
|
|
/// </summary>
|
|
System.String SALARY_DATE { get; set; }
|
|
/// <summary>
|
|
/// 所属单位内码
|
|
/// </summary>
|
|
System.Int32? UNIT_ID { get; set; }
|
|
/// <summary>
|
|
/// 所属单位名称
|
|
/// </summary>
|
|
System.String UNIT_NAME { get; set; }
|
|
/// <summary>
|
|
/// 部门内码
|
|
/// </summary>
|
|
System.Int32? DEPARTMENT_ID { get; set; }
|
|
/// <summary>
|
|
/// 部门名称
|
|
/// </summary>
|
|
System.String DEPARTMENT_NAME { get; set; }
|
|
/// <summary>
|
|
/// 职工数量
|
|
/// </summary>
|
|
System.Int32? STAFF_NUM { get; set; }
|
|
/// <summary>
|
|
/// 固定部分小计
|
|
/// </summary>
|
|
System.Double? FIXED_SALARY { get; set; }
|
|
/// <summary>
|
|
/// 月绩效工资
|
|
/// </summary>
|
|
System.Double? KPI_SALARY_MONTH { get; set; }
|
|
/// <summary>
|
|
/// 年绩效调剂小计
|
|
/// </summary>
|
|
System.Double? KPI_SALARY_YEAR { get; set; }
|
|
}
|
|
#endregion
|
|
|
|
#region T_SALARYPAYROLL_OFFICE IModifySALARYPAYROLL_OFFICE 接口
|
|
/// <summary>
|
|
/// T_SALARYPAYROLL_OFFICE 接口
|
|
/// </summary>
|
|
public interface IModifySALARYPAYROLL_OFFICE
|
|
{
|
|
/// <summary>
|
|
/// 应扣工资 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_DEDUCTION_SALARY { get; set; }
|
|
/// <summary>
|
|
/// 应发工资 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_WAGES_PAYABLE { get; set; }
|
|
/// <summary>
|
|
/// 养老保险 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_ENDOWMENT_INSURANCE { get; set; }
|
|
/// <summary>
|
|
/// 医疗保险 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_MEDICAL_INSURANCE { get; set; }
|
|
/// <summary>
|
|
/// 失业保险 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_UNEMPLOYMENT_INSURANCE { get; set; }
|
|
/// <summary>
|
|
/// 住房公积金 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_HOUSING_PROVIDENT_FUND { get; set; }
|
|
/// <summary>
|
|
/// 实发工资 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_FINAL_WAGES { get; set; }
|
|
/// <summary>
|
|
/// 应扣税款 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_DEDUCTION_TAX { get; set; }
|
|
/// <summary>
|
|
/// 代扣伙食费 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_MEAL_EXPENSE { get; set; }
|
|
/// <summary>
|
|
/// 实领工资 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_TAKE_WAGES { get; set; }
|
|
/// <summary>
|
|
/// 备注 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_SALARYPAYROLL_OFFICE_DESC { get; set; }
|
|
/// <summary>
|
|
/// 内码 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_SALARYPAYROLL_OFFICE_ID { get; set; }
|
|
/// <summary>
|
|
/// 流程内码 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_PERSONNELPROINST_ID { get; set; }
|
|
/// <summary>
|
|
/// 薪资日期 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_SALARY_DATE { get; set; }
|
|
/// <summary>
|
|
/// 所属单位内码 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_UNIT_ID { get; set; }
|
|
/// <summary>
|
|
/// 所属单位名称 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_UNIT_NAME { get; set; }
|
|
/// <summary>
|
|
/// 部门内码 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_DEPARTMENT_ID { get; set; }
|
|
/// <summary>
|
|
/// 部门名称 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_DEPARTMENT_NAME { get; set; }
|
|
/// <summary>
|
|
/// 职工数量 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_STAFF_NUM { get; set; }
|
|
/// <summary>
|
|
/// 固定部分小计 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_FIXED_SALARY { get; set; }
|
|
/// <summary>
|
|
/// 月绩效工资 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_KPI_SALARY_MONTH { get; set; }
|
|
/// <summary>
|
|
/// 年绩效调剂小计 是否被修改,不建议直接对其赋值操作
|
|
/// </summary>
|
|
bool Modify_KPI_SALARY_YEAR { get; set; }
|
|
}
|
|
#endregion
|
|
|
|
#region T_SALARYPAYROLL_OFFICE 的表明、字段名、字段描述
|
|
/// <summary>
|
|
/// T_SALARYPAYROLL_OFFICE_机关工资汇总表 的字段类
|
|
/// </summary>
|
|
public class TableSchema_SALARYPAYROLL_OFFICE
|
|
{
|
|
/// <summary>
|
|
/// 序列名 (用于Oracle主键)
|
|
/// </summary>
|
|
public const string SequenceName = "seq_salarypayroll_office";
|
|
/// <summary>
|
|
/// 表名
|
|
/// </summary>
|
|
public const string TableName = "T_SALARYPAYROLL_OFFICE";
|
|
/// <summary>
|
|
/// 表注释
|
|
/// </summary>
|
|
public const string Comment_TableName = "机关工资汇总表";
|
|
/// <summary>
|
|
/// 主键
|
|
/// </summary>
|
|
public const string KeyFieldName = "SALARYPAYROLL_OFFICE_ID";
|
|
/// <summary>
|
|
/// 应扣工资
|
|
/// </summary>
|
|
public const string DEDUCTION_SALARY = "DEDUCTION_SALARY";
|
|
/// <summary>
|
|
/// 应发工资
|
|
/// </summary>
|
|
public const string WAGES_PAYABLE = "WAGES_PAYABLE";
|
|
/// <summary>
|
|
/// 养老保险
|
|
/// </summary>
|
|
public const string ENDOWMENT_INSURANCE = "ENDOWMENT_INSURANCE";
|
|
/// <summary>
|
|
/// 医疗保险
|
|
/// </summary>
|
|
public const string MEDICAL_INSURANCE = "MEDICAL_INSURANCE";
|
|
/// <summary>
|
|
/// 失业保险
|
|
/// </summary>
|
|
public const string UNEMPLOYMENT_INSURANCE = "UNEMPLOYMENT_INSURANCE";
|
|
/// <summary>
|
|
/// 住房公积金
|
|
/// </summary>
|
|
public const string HOUSING_PROVIDENT_FUND = "HOUSING_PROVIDENT_FUND";
|
|
/// <summary>
|
|
/// 实发工资
|
|
/// </summary>
|
|
public const string FINAL_WAGES = "FINAL_WAGES";
|
|
/// <summary>
|
|
/// 应扣税款
|
|
/// </summary>
|
|
public const string DEDUCTION_TAX = "DEDUCTION_TAX";
|
|
/// <summary>
|
|
/// 代扣伙食费
|
|
/// </summary>
|
|
public const string MEAL_EXPENSE = "MEAL_EXPENSE";
|
|
/// <summary>
|
|
/// 实领工资
|
|
/// </summary>
|
|
public const string TAKE_WAGES = "TAKE_WAGES";
|
|
/// <summary>
|
|
/// 备注
|
|
/// </summary>
|
|
public const string SALARYPAYROLL_OFFICE_DESC = "SALARYPAYROLL_OFFICE_DESC";
|
|
/// <summary>
|
|
/// 内码
|
|
/// </summary>
|
|
public const string SALARYPAYROLL_OFFICE_ID = "SALARYPAYROLL_OFFICE_ID";
|
|
/// <summary>
|
|
/// 流程内码
|
|
/// </summary>
|
|
public const string PERSONNELPROINST_ID = "PERSONNELPROINST_ID";
|
|
/// <summary>
|
|
/// 薪资日期
|
|
/// </summary>
|
|
public const string SALARY_DATE = "SALARY_DATE";
|
|
/// <summary>
|
|
/// 所属单位内码
|
|
/// </summary>
|
|
public const string UNIT_ID = "UNIT_ID";
|
|
/// <summary>
|
|
/// 所属单位名称
|
|
/// </summary>
|
|
public const string UNIT_NAME = "UNIT_NAME";
|
|
/// <summary>
|
|
/// 部门内码
|
|
/// </summary>
|
|
public const string DEPARTMENT_ID = "DEPARTMENT_ID";
|
|
/// <summary>
|
|
/// 部门名称
|
|
/// </summary>
|
|
public const string DEPARTMENT_NAME = "DEPARTMENT_NAME";
|
|
/// <summary>
|
|
/// 职工数量
|
|
/// </summary>
|
|
public const string STAFF_NUM = "STAFF_NUM";
|
|
/// <summary>
|
|
/// 固定部分小计
|
|
/// </summary>
|
|
public const string FIXED_SALARY = "FIXED_SALARY";
|
|
/// <summary>
|
|
/// 月绩效工资
|
|
/// </summary>
|
|
public const string KPI_SALARY_MONTH = "KPI_SALARY_MONTH";
|
|
/// <summary>
|
|
/// 年绩效调剂小计
|
|
/// </summary>
|
|
public const string KPI_SALARY_YEAR = "KPI_SALARY_YEAR";
|
|
/// <summary>
|
|
/// 应扣工资
|
|
/// </summary>
|
|
public const string Comment_DEDUCTION_SALARY = "应扣工资";
|
|
/// <summary>
|
|
/// 应发工资
|
|
/// </summary>
|
|
public const string Comment_WAGES_PAYABLE = "应发工资";
|
|
/// <summary>
|
|
/// 养老保险
|
|
/// </summary>
|
|
public const string Comment_ENDOWMENT_INSURANCE = "养老保险";
|
|
/// <summary>
|
|
/// 医疗保险
|
|
/// </summary>
|
|
public const string Comment_MEDICAL_INSURANCE = "医疗保险";
|
|
/// <summary>
|
|
/// 失业保险
|
|
/// </summary>
|
|
public const string Comment_UNEMPLOYMENT_INSURANCE = "失业保险";
|
|
/// <summary>
|
|
/// 住房公积金
|
|
/// </summary>
|
|
public const string Comment_HOUSING_PROVIDENT_FUND = "住房公积金";
|
|
/// <summary>
|
|
/// 实发工资
|
|
/// </summary>
|
|
public const string Comment_FINAL_WAGES = "实发工资";
|
|
/// <summary>
|
|
/// 应扣税款
|
|
/// </summary>
|
|
public const string Comment_DEDUCTION_TAX = "应扣税款";
|
|
/// <summary>
|
|
/// 代扣伙食费
|
|
/// </summary>
|
|
public const string Comment_MEAL_EXPENSE = "代扣伙食费";
|
|
/// <summary>
|
|
/// 实领工资
|
|
/// </summary>
|
|
public const string Comment_TAKE_WAGES = "实领工资";
|
|
/// <summary>
|
|
/// 备注
|
|
/// </summary>
|
|
public const string Comment_SALARYPAYROLL_OFFICE_DESC = "备注";
|
|
/// <summary>
|
|
/// 内码
|
|
/// </summary>
|
|
public const string Comment_SALARYPAYROLL_OFFICE_ID = "内码";
|
|
/// <summary>
|
|
/// 流程内码
|
|
/// </summary>
|
|
public const string Comment_PERSONNELPROINST_ID = "流程内码";
|
|
/// <summary>
|
|
/// 薪资日期
|
|
/// </summary>
|
|
public const string Comment_SALARY_DATE = "薪资日期";
|
|
/// <summary>
|
|
/// 所属单位内码
|
|
/// </summary>
|
|
public const string Comment_UNIT_ID = "所属单位内码";
|
|
/// <summary>
|
|
/// 所属单位名称
|
|
/// </summary>
|
|
public const string Comment_UNIT_NAME = "所属单位名称";
|
|
/// <summary>
|
|
/// 部门内码
|
|
/// </summary>
|
|
public const string Comment_DEPARTMENT_ID = "部门内码";
|
|
/// <summary>
|
|
/// 部门名称
|
|
/// </summary>
|
|
public const string Comment_DEPARTMENT_NAME = "部门名称";
|
|
/// <summary>
|
|
/// 职工数量
|
|
/// </summary>
|
|
public const string Comment_STAFF_NUM = "职工数量";
|
|
/// <summary>
|
|
/// 固定部分小计
|
|
/// </summary>
|
|
public const string Comment_FIXED_SALARY = "固定部分小计";
|
|
/// <summary>
|
|
/// 月绩效工资
|
|
/// </summary>
|
|
public const string Comment_KPI_SALARY_MONTH = "月绩效工资";
|
|
/// <summary>
|
|
/// 年绩效调剂小计
|
|
/// </summary>
|
|
public const string Comment_KPI_SALARY_YEAR = "年绩效调剂小计";
|
|
}
|
|
#endregion
|
|
}
|