如何做薪资核算系统

// 员工实体类
public class Employee
{
    public int Id { get; set; }
    public string EmployeeId { get; set; }
    public string Name { get; set; }
    public string Department { get; set; }
    public decimal BaseSalary { get; set; }
    public DateTime HireDate { get; set; }
    
    // 导航属性
    public virtual ICollection SalaryRecords { get; set; }
    public virtual ICollection AttendanceRecords { get; set; }
}

// 薪资记录实体类
public class SalaryRecord
{
    public int Id { get; set; }
    public int EmployeeId { get; set; }
    public int PayrollPeriodId { get; set; }
    public decimal BasicSalary { get; set; }
    public decimal OvertimePay { get; set; }
    public decimal Allowances { get; set; }
    public decimal Deductions { get; set; }
    public decimal NetSalary { get; set; }
    public DateTime CalculationDate { get; set; }
    
    // 导航属性
    public virtual Employee Employee { get; set; }
    public virtual PayrollPeriod PayrollPeriod { get; set; }
}

// 薪资计算服务
public class SalaryCalculationService
{
    private readonly IPayrollRepository _payrollRepository;
    private readonly ITaxCalculationService _taxService;
    
    public SalaryCalculationService(IPayrollRepository payrollRepository, 
                                   ITaxCalculationService taxService)
    {
        _payrollRepository = payrollRepository;
        _taxService = taxService;
    }
    
    // 计算员工薪资
    public async Task CalculateEmployeeSalary(int employeeId, int periodId)
    {
        var employee = await _payrollRepository.GetEmployeeAsync(employeeId);
        var attendance = await _payrollRepository.GetAttendanceRecordsAsync(employeeId, periodId);
        
        // 基础薪资计算
        var basicSalary = CalculateBasicSalary(employee, attendance);
        
        // 加班费计算
        var overtimePay = CalculateOvertimePay(attendance);
        
        // 津贴计算
        var allowances = CalculateAllowances(employee, attendance);
        
        // 扣款计算
        var deductions = CalculateDeductions(employee, basicSalary);
        
        // 个税计算
        var tax = _taxService.CalculateIncomeTax(basicSalary + overtimePay + allowances);
        
        var netSalary = basicSalary + overtimePay + allowances - deductions - tax;
        
        return new SalaryRecord
        {
            EmployeeId = employeeId,
            PayrollPeriodId = periodId,
            BasicSalary = basicSalary,
            OvertimePay = overtimePay,
            Allowances = allowances,
            Deductions = deductions + tax,
            NetSalary = netSalary,
            CalculationDate = DateTime.Now
        };
    }
    
    private decimal CalculateBasicSalary(Employee employee, List attendance)
    {
        // 实现基础薪资计算逻辑
        var workDays = attendance.Count(a => a.AttendanceType == AttendanceType.Normal);
        return employee.BaseSalary / DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month) * workDays;
    }
}

// 薪资查询组件
class SalaryQueryComponent {
  constructor() {
    this.currentPage = 1;
    this.pageSize = 20;
    this.initEventListeners();
  }
  
  // 初始化事件监听
  initEventListeners() {
    document.getElementById('queryBtn').addEventListener('click', () => this.querySalary());
    document.getElementById('exportBtn').addEventListener('click', () => this.exportSalary());
  }
  
  // 查询薪资数据
  async querySalary() {
    const department = document.getElementById('department').value;
    const period = document.getElementById('period').value;
    
    try {
      const response = await fetch('/api/salary/query', {
        method: 'POST',
        headers: {
          'Content-Type': 'application/json'
        },
        body: JSON.stringify({
          department,
          period,
          page: this.currentPage,
          pageSize: this.pageSize
        })
      });
      
      if (response.ok) {
        const data = await response.json();
        this.renderSalaryTable(data.records);
        this.updatePagination(data.totalCount);
      } else {
        throw new Error('查询失败');
      }
    } catch (error) {
      this.showError('查询薪资数据时发生错误：' + error.message);
    }
  }
  
  // 渲染薪资表格
  renderSalaryTable(records) {
    const tableBody = document.getElementById('salaryTableBody');
    tableBody.innerHTML = '';
    
    records.forEach(record => {
      const row = document.createElement('tr');
      row.innerHTML = `
        ${record.employeeName}
        ${record.department}
        ${record.basicSalary.toFixed(2)}
        ${record.overtimePay.toFixed(2)}
        ${record.netSalary.toFixed(2)}
      `;
      tableBody.appendChild(row);
    });
  }
  
  // 显示错误信息
  showError(message) {
    const errorDiv = document.getElementById('errorMessage');
    errorDiv.textContent = message;
    errorDiv.style.display = 'block';
    
    setTimeout(() => {
      errorDiv.style.display = 'none';
    }, 5000);
  }
}