费控管理系统搭建：需求到上线全流程

// 费用实体类示例
public class Expense
{
    public int Id { get; set; }
    public string EmployeeId { get; set; }
    public decimal Amount { get; set; }
    public DateTime ExpenseDate { get; set; }
    public string Category { get; set; }
    public string Description { get; set; }
    public string Status { get; set; } // 状态：待审批、已批准、已拒绝
}

// 预算检查服务示例
public class BudgetService
{
    public bool CheckBudget(string department, decimal amount)
    {
        // 实现预算检查逻辑
        // 返回true表示预算充足，false表示超出预算
        return true;
    }
}

-- 创建费用表
CREATE TABLE Expenses (
    Id INT PRIMARY KEY IDENTITY,
    EmployeeId NVARCHAR(50) NOT NULL,
    Amount DECIMAL(18, 2) NOT NULL,
    ExpenseDate DATETIME NOT NULL,
    Category NVARCHAR(100) NOT NULL,
    Description NVARCHAR(500),
    Status NVARCHAR(20) DEFAULT 'Pending',
    CreatedDate DATETIME DEFAULT GETDATE(),
    UpdatedDate DATETIME DEFAULT GETDATE()
);

-- 创建预算表
CREATE TABLE Budgets (
    Id INT PRIMARY KEY IDENTITY,
    Department NVARCHAR(100) NOT NULL,
    Category NVARCHAR(100) NOT NULL,
    BudgetAmount DECIMAL(18, 2) NOT NULL,
    Period NVARCHAR(20) NOT NULL, -- 月度、季度、年度
    StartDate DATE NOT NULL,
    EndDate DATE NOT NULL
);

// 审批流程控制器示例
class ApprovalWorkflow {
  constructor() {
    this.rules = [];
  }
  
  // 添加审批规则
  addRule(condition, approver, priority) {
    this.rules.push({ condition, approver, priority });
    this.rules.sort((a, b) => a.priority - b.priority);
  }
  
  // 执行审批流程
  execute(expense) {
    for (const rule of this.rules) {
      if (rule.condition(expense)) {
        return this.notifyApprover(rule.approver, expense);
      }
    }
    return '无需审批';
  }
  
  // 通知审批人
  notifyApprover(approver, expense) {
    // 实现通知逻辑，如发送邮件、短信等
    console.log(`通知审批人: ${approver}, 费用ID: ${expense.id}`);
    return `已通知${approver}审批`;
  }
}

// 使用示例
const workflow = new ApprovalWorkflow();
workflow.addRule(expense => expense.amount > 5000, '财务总监', 1);
workflow.addRule(expense => expense.amount > 2000, '部门经理', 2);

-- 初始化部门预算数据
INSERT INTO Budgets (Department, Category, BudgetAmount, Period, StartDate, EndDate)
VALUES 
('销售部', '差旅费', 50000.00, '月度', '2023-10-01', '2023-10-31'),
('技术部', '培训费', 20000.00, '季度', '2023-10-01', '2023-12-31'),
('市场部', '活动经费', 30000.00, '月度', '2023-10-01', '2023-10-31');

-- 初始化审批规则配置
INSERT INTO ApprovalRules (ConditionType, ConditionValue, ApproverRole, Priority)
VALUES 
('Amount', 5000, 'FinanceDirector', 1),
('Amount', 2000, 'DepartmentManager', 2),
('Category', '招待费', 'DepartmentManager', 3);