AI驱动的自动化企业ERP工作流程系统_客户流失系统

// 客户流失评分服务 - 核心片段
public class ChurnPredictionService
{
    private readonly ErpDbContext _context;
    private readonly IModel _mlModel; // 预加载的ONNX模型

    public ChurnPredictionService(ErpDbContext context, IModel mlModel)
    {
        _context = context;
        _mlModel = mlModel;
    }

    public async Task<double> GetChurnProbabilityAsync(int customerId)
    {
        // 使用EF Core Code First方式查询最近订单、工单等聚合特征
        var recentOrder = await _context.Orders
            .Where(o => o.CustomerId == customerId)
            .OrderByDescending(o => o.OrderDate)
            .FirstOrDefaultAsync();

        var ticketCount = await _context.SupportTickets
            .CountAsync(t => t.CustomerId == customerId 
                         && t.CreatedAt >= DateTime.UtcNow.AddDays(-60));

        // 构造特征向量 (示例: 最近购买天数, 客单价, 退货率)
        var features = new float[] {
            (float)(DateTime.UtcNow - recentOrder?.OrderDate ?? TimeSpan.FromDays(90)).TotalDays,
            (float)(recentOrder?.TotalAmount ?? 0),
            ticketCount
        };

        // 执行模型推理 (伪代码, 实际使用ONNX Runtime)
        var prediction = _mlModel.Predict(features);
        return Math.Round(prediction, 4);
    }
}

// 前端展示组件 - 高风险客户看板 (ES6+)
interface HighRiskCustomer {
  id: number;
  name: string;
  churnProbability: number;
  lastOrderDate: Date;
}

const renderRiskList = (customers: HighRiskCustomer[]): void => {
  const container = document.getElementById('risk-panel');
  if (!container) return;

  const list = customers
    .filter(c => c.churnProbability > 0.65)
    .sort((a, b) => b.churnProbability - a.churnProbability)
    .map(c => `<li>${c.name} - 流失风险: ${(c.churnProbability * 100).toFixed(1)}%</li>`)
    .join('');

  container.innerHTML = `<ul>${list}</ul>`;
};