数智化售后管理平台搭建：全流程实施指南

前端：React/Vue.js + TypeScript
后端：.NET Core/Spring Boot
数据库：SQL Server/MySQL
实时通信：WebSocket
数据分析：Python + Pandas

public class WorkOrder
{
    public int Id { get; set; }
    public string CustomerId { get; set; }
    public WorkOrderStatus Status { get; set; }
    public DateTime CreatedTime { get; set; }
    public DateTime? ResolvedTime { get; set; }
    
    public void UpdateStatus(WorkOrderStatus newStatus)
    {
        if (Status == WorkOrderStatus.Closed)
            throw new InvalidOperationException("已关闭的工单不能修改状态");
            
        Status = newStatus;
        if (newStatus == WorkOrderStatus.Resolved)
            ResolvedTime = DateTime.Now;
    }
}

public enum WorkOrderStatus
{
    Pending,
    Assigned,
    InProgress,
    Resolved,
    Closed
}

-- 获取服务响应时间统计
SELECT 
    TechnicianId,
    AVG(DATEDIFF(MINUTE, CreatedTime, AssignedTime)) AS AvgResponseTime,
    AVG(DATEDIFF(MINUTE, AssignedTime, ResolvedTime)) AS AvgResolutionTime,
    COUNT(*) AS TotalTickets
FROM WorkOrders
WHERE Status = 'Resolved'
    AND CreatedTime >= DATEADD(MONTH, -1, GETDATE())
GROUP BY TechnicianId
ORDER BY AvgResolutionTime ASC;

# Docker Compose 部署配置示例
version: '3.8'
services:
  web:
    image: after-sales-web:latest
    ports:
      - "80:80"
    environment:
      - DB_CONNECTION_STRING=Server=db;Database=AfterSales;User=sa;Password=your_password;
  
  api:
    image: after-sales-api:latest
    ports:
      - "5000:5000"
    depends_on:
      - db
  
  db:
    image: mcr.microsoft.com/mssql/server:2019-latest
    environment:
      - SA_PASSWORD=your_password
      - ACCEPT_EULA=Y