CREATE TABLE [dbo].AIChatRecord(
    [GUID] [nvarchar](50) NOT NULL,
    [UserID] [nvarchar](50) NOT NULL,
    [ModelType] [int] NOT NULL,
    [Question] [nvarchar](max) NOT NULL,
    [Attachments] [nvarchar](1000) NOT NULL,
    [Answer] [nvarchar](max) NOT NULL,
    [ProcessResult] [int] NOT NULL,
    [ErrorMessage] [nvarchar](max) NOT NULL,
    [CreateTime] [datetime] NOT NULL,
 CONSTRAINT [PK_AIChatRecord] PRIMARY KEY CLUSTERED 
(
    [GUID] ASC
)

class DeepSeekApiClient
{
    private readonly string _apiKey;
    private readonly HttpClient _httpClient;
    
    // 构造函数，传入你的API密钥
    public DeepSeekApiClient(string apiKey)
    {
        _apiKey = apiKey;
        _httpClient = new HttpClient();
        
        // 设置基础URL（根据DeepSeek API文档调整）
        _httpClient.BaseAddress = new Uri("https://api.deepseek.com/v1/");
        
        // 设置授权头
        _httpClient.DefaultRequestHeaders.Add("Authorization", $"Bearer {_apiKey}");
    }
    
    // 发送聊天请求的异步方法
    public async Task<string> SendChatRequestAsync(string prompt)
    {
        try
        {
            // 构造请求体
            var requestBody = new
            {
                model = "deepseek-chat", // 根据API文档调整模型名称
                messages = new[]
                {
                    new
                    {
                        role = "user",
                        content = prompt
                    }
                },
                temperature = 0.7,
                max_tokens = 1000
            };
            
            // 序列化为JSON
            var json = JsonSerializer.Serialize(requestBody);
            var content = new StringContent(json, Encoding.UTF8, "application/json");
            
            // 发送POST请求
            var response = await _httpClient.PostAsync("chat/completions", content);
            
            // 确保请求成功
            response.EnsureSuccessStatusCode();
            
            // 读取并返回响应内容
            var responseContent = await response.Content.ReadAsStringAsync();
            return responseContent;
        }
        catch (Exception ex)
        {
            Console.WriteLine($"Error calling DeepSeek API: {ex.Message}");
            throw;
        }
    }
}