using MudTools.OfficeInterop;
using MudTools.OfficeInterop.Word;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using Newtonsoft.Json;

// 數(shù)據(jù)模型
public class Employee
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string Department { get; set; }
    public decimal Salary { get; set; }
    public decimal Bonus { get; set; }
    public DateTime HireDate { get; set; }
}

// 數(shù)據(jù)訪問服務(wù)
public class DataService
{
    /// <summary>
    /// 從SQL Server數(shù)據(jù)庫讀取員工數(shù)據(jù)
    /// </summary>
    /// <param name="connectionString">數(shù)據(jù)庫連接字符串</param>
    /// <returns>員工數(shù)據(jù)列表</returns>
    public List<Employee> GetEmployeesFromDatabase(string connectionString)
    {
        var employees = new List<Employee>();
        
        try
        {
            using (var connection = new SqlConnection(connectionString))
            {
                connection.Open();
                var command = new SqlCommand("SELECT Id, Name, Department, Salary, Bonus, HireDate FROM Employees", connection);
                using (var reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        employees.Add(new Employee
                        {
                            Id = reader.GetInt32("Id"),
                            Name = reader.GetString("Name"),
                            Department = reader.GetString("Department"),
                            Salary = reader.GetDecimal("Salary"),
                            Bonus = reader.GetDecimal("Bonus"),
                            HireDate = reader.GetDateTime("HireDate")
                        });
                    }
                }
            }
        }
        catch (Exception ex)
        {
            Console.WriteLine($"從數(shù)據(jù)庫讀取員工數(shù)據(jù)時(shí)發(fā)生錯(cuò)誤: {ex.Message}");
        }
        
        return employees;
    }
    
    /// <summary>
    /// 從Excel文件讀取員工數(shù)據(jù)
    /// </summary>
    /// <param name="excelFilePath">Excel文件路徑</param>
    /// <returns>員工數(shù)據(jù)列表</returns>
    public List<Employee> GetEmployeesFromExcel(string excelFilePath)
    {
        var employees = new List<Employee>();
        
        try
        {
            // 這里應(yīng)該使用適當(dāng)?shù)腅xcel讀取庫，如EPPlus或NPOI
            // 為簡(jiǎn)化示例，我們直接返回模擬數(shù)據(jù)
            employees.Add(new Employee
            {
                Id = 1,
                Name = "張三",
                Department = "技術(shù)部",
                Salary = 15000,
                Bonus = 3000,
                HireDate = new DateTime(2020, 1, 15)
            });
            
            employees.Add(new Employee
            {
                Id = 2,
                Name = "李四",
                Department = "銷售部",
                Salary = 12000,
                Bonus = 5000,
                HireDate = new DateTime(2019, 3, 22)
            });
        }
        catch (Exception ex)
        {
            Console.WriteLine($"從Excel文件讀取員工數(shù)據(jù)時(shí)發(fā)生錯(cuò)誤: {ex.Message}");
        }
        
        return employees;
    }
    
    /// <summary>
    /// 從JSON文件讀取員工數(shù)據(jù)
    /// </summary>
    /// <param name="jsonFilePath">JSON文件路徑</param>
    /// <returns>員工數(shù)據(jù)列表</returns>
    public List<Employee> GetEmployeesFromJson(string jsonFilePath)
    {
        var employees = new List<Employee>();
        
        try
        {
            if (File.Exists(jsonFilePath))
            {
                var jsonContent = File.ReadAllText(jsonFilePath);
                employees = JsonConvert.DeserializeObject<List<Employee>>(jsonContent);
            }
        }
        catch (Exception ex)
        {
            Console.WriteLine($"從JSON文件讀取員工數(shù)據(jù)時(shí)發(fā)生錯(cuò)誤: {ex.Message}");
        }
        
        return employees;
    }
}

using MudTools.OfficeInterop;
using MudTools.OfficeInterop.Word;
using System;
using System.Collections.Generic;

// 綜合數(shù)據(jù)服務(wù)
public class ComprehensiveDataService
{
    private readonly DataService _dataService;
    
    public ComprehensiveDataService()
    {
        _dataService = new DataService();
    }
    
    /// <summary>
    /// 獲取綜合員工數(shù)據(jù)
    /// </summary>
    /// <returns>綜合員工數(shù)據(jù)列表</returns>
    public List<ComprehensiveEmployeeData> GetComprehensiveEmployeeData()
    {
        var comprehensiveDataList = new List<ComprehensiveEmployeeData>();
        
        try
        {
            // 從不同數(shù)據(jù)源獲取數(shù)據(jù)
            var hrEmployees = _dataService.GetEmployeesFromDatabase("HR數(shù)據(jù)庫連接字符串");
            // var financeData = _dataService.GetEmployeesFromExcel("財(cái)務(wù)數(shù)據(jù)Excel路徑");
            // var projectData = _dataService.GetEmployeesFromJson("項(xiàng)目數(shù)據(jù)JSON路徑");
            
            // 整合數(shù)據(jù)
            foreach (var employee in hrEmployees)
            {
                var comprehensiveData = new ComprehensiveEmployeeData
                {
                    Id = employee.Id,
                    Name = employee.Name,
                    Department = employee.Department,
                    Salary = employee.Salary,
                    Bonus = employee.Bonus,
                    HireDate = employee.HireDate,
                    // 這里可以添加從其他數(shù)據(jù)源獲取的信息
                    PerformanceRating = CalculatePerformanceRating(employee),
                    ProjectsCompleted = GetProjectsCompleted(employee.Id)
                };
                
                comprehensiveDataList.Add(comprehensiveData);
            }
        }
        catch (Exception ex)
        {
            Console.WriteLine($"獲取綜合員工數(shù)據(jù)時(shí)發(fā)生錯(cuò)誤: {ex.Message}");
        }
        
        return comprehensiveDataList;
    }
    
    /// <summary>
    /// 計(jì)算績(jī)效評(píng)級(jí)
    /// </summary>
    /// <param name="employee">員工信息</param>
    /// <returns>績(jī)效評(píng)級(jí)</returns>
    private string CalculatePerformanceRating(Employee employee)
    {
        // 簡(jiǎn)化的績(jī)效評(píng)級(jí)計(jì)算邏輯
        if (employee.Salary > 15000)
            return "優(yōu)秀";
        else if (employee.Salary > 10000)
            return "良好";
        else
            return "合格";
    }
    
    /// <summary>
    /// 獲取完成的項(xiàng)目數(shù)量
    /// </summary>
    /// <param name="employeeId">員工ID</param>
    /// <returns>完成的項(xiàng)目數(shù)量</returns>
    private int GetProjectsCompleted(int employeeId)
    {
        // 模擬數(shù)據(jù)
        return employeeId switch
        {
            1 => 5,
            2 => 3,
            _ => 0
        };
    }
}

/// <summary>
/// 綜合員工數(shù)據(jù)模型
/// </summary>
public class ComprehensiveEmployeeData
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string Department { get; set; }
    public decimal Salary { get; set; }
    public decimal Bonus { get; set; }
    public DateTime HireDate { get; set; }
    public string PerformanceRating { get; set; }
    public int ProjectsCompleted { get; set; }
    
    /// <summary>
    /// 獲取總收入（薪資+獎(jiǎng)金）
    /// </summary>
    public decimal TotalIncome => Salary + Bonus;
    
    /// <summary>
    /// 獲取工作年限
    /// </summary>
    public int YearsOfService => DateTime.Now.Year - HireDate.Year;
}

using MudTools.OfficeInterop;
using MudTools.OfficeInterop.Word;
using System;
using System.Collections.Generic;

// 文檔生成服務(wù)
public class DocumentGenerationService
{
    /// <summary>
    /// 生成員工工資條
    /// </summary>
    /// <param name="templatePath">模板路徑</param>
    /// <param name="outputDirectory">輸出目錄</param>
    /// <param name="employees">員工數(shù)據(jù)列表</param>
    public void GeneratePaySlips(string templatePath, string outputDirectory, List<Employee> employees)
    {
        foreach (var employee in employees)
        {
            try
            {
                // 基于模板創(chuàng)建新文檔
                using var wordApp = WordFactory.CreateFrom(templatePath);
                var document = wordApp.ActiveDocument;
                
                // 隱藏Word應(yīng)用程序以提高性能
                wordApp.Visibility = WordAppVisibility.Hidden;
                wordApp.DisplayAlerts = WdAlertLevel.wdAlertsNone;
                
                // 使用書簽填充數(shù)據(jù)
                FillDataUsingBookmarks(document, employee);
                
                // 生成文件名
                string fileName = $"工資條_{employee.Name}_{DateTime.Now:yyyyMM}.docx";
                string outputPath = Path.Combine(outputDirectory, fileName);
                
                // 保存文檔
                document.SaveAs(outputPath, WdSaveFormat.wdFormatXMLDocument);
                document.Close();
                
                Console.WriteLine($"已生成工資條: {fileName}");
            }
            catch (Exception ex)
            {
                Console.WriteLine($"為員工 {employee.Name} 生成工資條時(shí)發(fā)生錯(cuò)誤: {ex.Message}");
            }
        }
    }
    
    /// <summary>
    /// 使用書簽填充數(shù)據(jù)
    /// </summary>
    /// <param name="document">Word文檔</param>
    /// <param name="employee">員工數(shù)據(jù)</param>
    private void FillDataUsingBookmarks(IWordDocument document, Employee employee)
    {
        // 填充基本信息
        SetBookmarkText(document, "EmployeeName", employee.Name);
        SetBookmarkText(document, "EmployeeId", employee.Id.ToString());
        SetBookmarkText(document, "Department", employee.Department);
        SetBookmarkText(document, "PayPeriod", DateTime.Now.ToString("yyyy年MM月"));
        
        // 填充薪資信息
        SetBookmarkText(document, "BaseSalary", employee.Salary.ToString("C"));
        SetBookmarkText(document, "Bonus", employee.Bonus.ToString("C"));
        SetBookmarkText(document, "TotalIncome", (employee.Salary + employee.Bonus).ToString("C"));
        SetBookmarkText(document, "Deductions", "0.00");
        SetBookmarkText(document, "NetPay", (employee.Salary + employee.Bonus).ToString("C"));
        
        // 填充日期信息
        SetBookmarkText(document, "PayDate", DateTime.Now.ToString("yyyy年MM月dd日"));
        SetBookmarkText(document, "HireDate", employee.HireDate.ToString("yyyy年MM月dd日"));
    }
    
    /// <summary>
    /// 設(shè)置書簽文本
    /// </summary>
    /// <param name="document">Word文檔</param>
    /// <param name="bookmarkName">書簽名稱</param>
    /// <param name="text">文本內(nèi)容</param>
    private void SetBookmarkText(IWordDocument document, string bookmarkName, string text)
    {
        try
        {
            var bookmark = document.Bookmarks[bookmarkName];
            if (bookmark != null)
            {
                bookmark.Range.Text = text;
            }
        }
        catch (Exception ex)
        {
            Console.WriteLine($"設(shè)置書簽 {bookmarkName} 文本時(shí)發(fā)生錯(cuò)誤: {ex.Message}");
        }
    }
    
    /// <summary>
    /// 使用查找替換填充數(shù)據(jù)
    /// </summary>
    /// <param name="document">Word文檔</param>
    /// <param name="employee">員工數(shù)據(jù)</param>
    private void FillDataUsingFindReplace(IWordDocument document, Employee employee)
    {
        // 使用查找替換填充數(shù)據(jù)
        document.FindAndReplace("[員工姓名]", employee.Name);
        document.FindAndReplace("[員工編號(hào)]", employee.Id.ToString());
        document.FindAndReplace("[部門]", employee.Department);
        document.FindAndReplace("[薪資月份]", DateTime.Now.ToString("yyyy年MM月"));
        document.FindAndReplace("[基本工資]", employee.Salary.ToString("C"));
        document.FindAndReplace("[獎(jiǎng)金]", employee.Bonus.ToString("C"));
        document.FindAndReplace("[總收入]", (employee.Salary + employee.Bonus).ToString("C"));
        document.FindAndReplace("[扣除項(xiàng)]", "0.00");
        document.FindAndReplace("[實(shí)發(fā)工資]", (employee.Salary + employee.Bonus).ToString("C"));
        document.FindAndReplace("[發(fā)放日期]", DateTime.Now.ToString("yyyy年MM月dd日"));
        document.FindAndReplace("[入職日期]", employee.HireDate.ToString("yyyy年MM月dd日"));
    }
}

// 批量文檔生成系統(tǒng)
public class BatchDocumentGenerationSystem
{
    private readonly DataService _dataService;
    private readonly DocumentGenerationService _documentService;
    
    public BatchDocumentGenerationSystem()
    {
        _dataService = new DataService();
        _documentService = new DocumentGenerationService();
    }
    
    /// <summary>
    /// 批量生成員工工資條
    /// </summary>
    /// <param name="templatePath">模板路徑</param>
    /// <param name="outputDirectory">輸出目錄</param>
    /// <param name="dataSourceType">數(shù)據(jù)源類型</param>
    /// <param name="dataSourcePath">數(shù)據(jù)源路徑</param>
    public void BatchGeneratePaySlips(string templatePath, string outputDirectory, 
        DataSourceType dataSourceType, string dataSourcePath)
    {
        try
        {
            // 確保輸出目錄存在
            if (!Directory.Exists(outputDirectory))
            {
                Directory.CreateDirectory(outputDirectory);
            }
            
            // 根據(jù)數(shù)據(jù)源類型獲取員工數(shù)據(jù)
            List<Employee> employees = dataSourceType switch
            {
                DataSourceType.Database => _dataService.GetEmployeesFromDatabase(dataSourcePath),
                DataSourceType.Excel => _dataService.GetEmployeesFromExcel(dataSourcePath),
                DataSourceType.Json => _dataService.GetEmployeesFromJson(dataSourcePath),
                _ => throw new ArgumentException("不支持的數(shù)據(jù)源類型")
            };
            
            Console.WriteLine($"從{dataSourceType}數(shù)據(jù)源獲取到 {employees.Count} 名員工的數(shù)據(jù)");
            
            // 生成工資條
            _documentService.GeneratePaySlips(templatePath, outputDirectory, employees);
            
            Console.WriteLine($"批量工資條生成完成，共生成 {employees.Count} 份工資條");
        }
        catch (Exception ex)
        {
            Console.WriteLine($"批量生成工資條時(shí)發(fā)生錯(cuò)誤: {ex.Message}");
        }
    }
    
    /// <summary>
    /// 批量生成客戶合同
    /// </summary>
    /// <param name="templatePath">模板路徑</param>
    /// <param name="outputDirectory">輸出目錄</param>
    /// <param name="customers">客戶數(shù)據(jù)列表</param>
    public void BatchGenerateContracts(string templatePath, string outputDirectory, List<Customer> customers)
    {
        try
        {
            // 確保輸出目錄存在
            if (!Directory.Exists(outputDirectory))
            {
                Directory.CreateDirectory(outputDirectory);
            }
            
            foreach (var customer in customers)
            {
                try
                {
                    // 基于模板創(chuàng)建新文檔
                    using var wordApp = WordFactory.CreateFrom(templatePath);
                    var document = wordApp.ActiveDocument;
                    
                    // 隱藏Word應(yīng)用程序以提高性能
                    wordApp.Visibility = WordAppVisibility.Hidden;
                    wordApp.DisplayAlerts = WdAlertLevel.wdAlertsNone;
                    
                    // 填充客戶數(shù)據(jù)
                    FillCustomerContractData(document, customer);
                    
                    // 生成文件名
                    string fileName = $"合同_{customer.Name}_{DateTime.Now:yyyyMMdd}.docx";
                    string outputPath = Path.Combine(outputDirectory, fileName);
                    
                    // 保存文檔
                    document.SaveAs(outputPath, WdSaveFormat.wdFormatXMLDocument);
                    document.Close();
                    
                    Console.WriteLine($"已生成合同: {fileName}");
                }
                catch (Exception ex)
                {
                    Console.WriteLine($"為客戶 {customer.Name} 生成合同時(shí)發(fā)生錯(cuò)誤: {ex.Message}");
                }
            }
            
            Console.WriteLine($"批量合同生成完成，共生成 {customers.Count} 份合同");
        }
        catch (Exception ex)
        {
            Console.WriteLine($"批量生成合同時(shí)發(fā)生錯(cuò)誤: {ex.Message}");
        }
    }
    
    /// <summary>
    /// 填充客戶合同數(shù)據(jù)
    /// </summary>
    /// <param name="document">Word文檔</param>
    /// <param name="customer">客戶數(shù)據(jù)</param>
    private void FillCustomerContractData(IWordDocument document, Customer customer)
    {
        // 使用書簽填充數(shù)據(jù)
        SetBookmarkText(document, "CustomerName", customer.Name);
        SetBookmarkText(document, "CustomerAddress", customer.Address);
        SetBookmarkText(document, "CustomerPhone", customer.Phone);
        SetBookmarkText(document, "ContractDate", DateTime.Now.ToString("yyyy年MM月dd日"));
        SetBookmarkText(document, "ContractAmount", customer.ContractAmount.ToString("C"));
        SetBookmarkText(document, "ServiceDescription", customer.ServiceDescription);
        SetBookmarkText(document, "ContractTerm", customer.ContractTerm);
    }
    
    /// <summary>
    /// 設(shè)置書簽文本
    /// </summary>
    /// <param name="document">Word文檔</param>
    /// <param name="bookmarkName">書簽名稱</param>
    /// <param name="text">文本內(nèi)容</param>
    private void SetBookmarkText(IWordDocument document, string bookmarkName, string text)
    {
        try
        {
            var bookmark = document.Bookmarks[bookmarkName];
            if (bookmark != null)
            {
                bookmark.Range.Text = text;
            }
        }
        catch (Exception ex)
        {
            Console.WriteLine($"設(shè)置書簽 {bookmarkName} 文本時(shí)發(fā)生錯(cuò)誤: {ex.Message}");
        }
    }
}

/// <summary>
/// 數(shù)據(jù)源類型枚舉
/// </summary>
public enum DataSourceType
{
    Database,
    Excel,
    Json
}

/// <summary>
/// 客戶數(shù)據(jù)模型
/// </summary>
public class Customer
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string Address { get; set; }
    public string Phone { get; set; }
    public decimal ContractAmount { get; set; }
    public string ServiceDescription { get; set; }
    public string ContractTerm { get; set; }
}

// 工資條模板創(chuàng)建器
public class PaySlipTemplateCreator
{
    /// <summary>
    /// 創(chuàng)建工資條模板
    /// </summary>
    /// <param name="templatePath">模板保存路徑</param>
    public void CreatePaySlipTemplate(string templatePath)
    {
        try
        {
            // 創(chuàng)建新文檔
            using var wordApp = WordFactory.BlankWorkbook();
            var document = wordApp.ActiveDocument;
            
            // 隱藏Word應(yīng)用程序以提高性能
            wordApp.Visibility = WordAppVisibility.Hidden;
            wordApp.DisplayAlerts = WdAlertLevel.wdAlertsNone;
            
            // 設(shè)置文檔格式
            SetupDocumentFormat(document);
            
            // 添加模板內(nèi)容
            AddTemplateContent(document);
            
            // 添加書簽
            AddBookmarks(document);
            
            // 保存為模板
            document.SaveAs(templatePath, WdSaveFormat.wdFormatXMLTemplate);
            document.Close();
            
            Console.WriteLine($"工資條模板已創(chuàng)建: {templatePath}");
        }
        catch (Exception ex)
        {
            Console.WriteLine($"創(chuàng)建工資條模板時(shí)發(fā)生錯(cuò)誤: {ex.Message}");
        }
    }
    
    /// <summary>
    /// 設(shè)置文檔格式
    /// </summary>
    /// <param name="document">Word文檔</param>
    private void SetupDocumentFormat(IWordDocument document)
    {
        // 設(shè)置頁面格式
        foreach (IWordSection section in document.Sections)
        {
            var pageSetup = section.PageSetup;
            pageSetup.PaperSize = WdPaperSize.wdPaperA4;
            pageSetup.Orientation = WdOrientation.wdOrientPortrait;
            pageSetup.TopMargin = 36;  // 0.5英寸
            pageSetup.BottomMargin = 36;
            pageSetup.LeftMargin = 36;
            pageSetup.RightMargin = 36;
        }
    }
    
    /// <summary>
    /// 添加模板內(nèi)容
    /// </summary>
    /// <param name="document">Word文檔</param>
    private void AddTemplateContent(IWordDocument document)
    {
        var content = document.Content;
        
        // 添加標(biāo)題
        content.Text = "員工工資條\n\n";
        content.Font.Name = "微軟雅黑";
        content.Font.Size = 16;
        content.Font.Bold = true;
        content.ParagraphFormat.Alignment = WdParagraphAlignment.wdAlignParagraphCenter;
        
        // 添加基本信息表格
        var infoRange = content.Duplicate;
        infoRange.Collapse(WdCollapseDirection.wdCollapseEnd);
        infoRange.Text = "基本信息\n";
        infoRange.Font.Size = 12;
        infoRange.Font.Bold = true;
        infoRange.ParagraphFormat.Alignment = WdParagraphAlignment.wdAlignParagraphLeft;
        
        // 創(chuàng)建基本信息表格（3行4列）
        var infoTable = document.Tables.Add(infoRange, 3, 4);
        infoTable.Borders.Enable = 1;
        infoTable.AllowAutoFit = true;
        
        // 設(shè)置表頭
        infoTable.Cell(1, 1).Range.Text = "員工姓名";
        infoTable.Cell(1, 2).Range.Text = "[員工姓名]";
        infoTable.Cell(1, 3).Range.Text = "員工編號(hào)";
        infoTable.Cell(1, 4).Range.Text = "[員工編號(hào)]";
        
        infoTable.Cell(2, 1).Range.Text = "部門";
        infoTable.Cell(2, 2).Range.Text = "[部門]";
        infoTable.Cell(2, 3).Range.Text = "薪資月份";
        infoTable.Cell(2, 4).Range.Text = "[薪資月份]";
        
        infoTable.Cell(3, 1).Range.Text = "入職日期";
        infoTable.Cell(3, 2).Range.Text = "[入職日期]";
        infoTable.Cell(3, 3).Range.Text = "發(fā)放日期";
        infoTable.Cell(3, 4).Range.Text = "[發(fā)放日期]";
        
        // 添加薪資明細(xì)
        var salaryRange = infoRange.Duplicate;
        salaryRange.Collapse(WdCollapseDirection.wdCollapseEnd);
        salaryRange.Text = "\n薪資明細(xì)\n";
        salaryRange.Font.Size = 12;
        salaryRange.Font.Bold = true;
        salaryRange.ParagraphFormat.Alignment = WdParagraphAlignment.wdAlignParagraphLeft;
        
        // 創(chuàng)建薪資明細(xì)表格（4行2列）
        var salaryTable = document.Tables.Add(salaryRange, 4, 2);
        salaryTable.Borders.Enable = 1;
        salaryTable.AllowAutoFit = true;
        
        // 設(shè)置表頭
        salaryTable.Cell(1, 1).Range.Text = "項(xiàng)目";
        salaryTable.Cell(1, 2).Range.Text = "金額";
        
        salaryTable.Cell(2, 1).Range.Text = "基本工資";
        salaryTable.Cell(2, 2).Range.Text = "[基本工資]";
        
        salaryTable.Cell(3, 1).Range.Text = "獎(jiǎng)金";
        salaryTable.Cell(3, 2).Range.Text = "[獎(jiǎng)金]";
        
        salaryTable.Cell(4, 1).Range.Text = "總收入";
        salaryTable.Cell(4, 2).Range.Text = "[總收入]";
        
        // 添加扣除項(xiàng)和實(shí)發(fā)工資
        var deductionRange = salaryRange.Duplicate;
        deductionRange.Collapse(WdCollapseDirection.wdCollapseEnd);
        deductionRange.Text = "\n";
        
        // 創(chuàng)建扣除項(xiàng)表格（3行2列）
        var deductionTable = document.Tables.Add(deductionRange, 3, 2);
        deductionTable.Borders.Enable = 1;
        deductionTable.AllowAutoFit = true;
        
        deductionTable.Cell(1, 1).Range.Text = "扣除項(xiàng)";
        deductionTable.Cell(1, 2).Range.Text = "[扣除項(xiàng)]";
        
        deductionTable.Cell(2, 1).Range.Text = "實(shí)發(fā)工資";
        deductionTable.Cell(2, 2).Range.Text = "[實(shí)發(fā)工資]";
        
        deductionTable.Cell(3, 1).Range.Text = "大寫金額";
        deductionTable.Cell(3, 2).Range.Text = "人民幣[大寫實(shí)發(fā)工資]";
    }
    
    /// <summary>
    /// 添加書簽
    /// </summary>
    /// <param name="document">Word文檔</param>
    private void AddBookmarks(IWordDocument document)
    {
        // 定義書簽映射
        var bookmarkMappings = new Dictionary<string, string>
        {
            { "EmployeeName", "[員工姓名]" },
            { "EmployeeId", "[員工編號(hào)]" },
            { "Department", "[部門]" },
            { "PayPeriod", "[薪資月份]" },
            { "HireDate", "[入職日期]" },
            { "PayDate", "[發(fā)放日期]" },
            { "BaseSalary", "[基本工資]" },
            { "Bonus", "[獎(jiǎng)金]" },
            { "TotalIncome", "[總收入]" },
            { "Deductions", "[扣除項(xiàng)]" },
            { "NetPay", "[實(shí)發(fā)工資]" }
        };
        
        // 為每個(gè)占位符添加書簽
        foreach (var mapping in bookmarkMappings)
        {
            AddBookmarkToPlaceholder(document, mapping.Key, mapping.Value);
        }
    }
    
    /// <summary>
    /// 為占位符添加書簽
    /// </summary>
    /// <param name="document">Word文檔</param>
    /// <param name="bookmarkName">書簽名稱</param>
    /// <param name="placeholder">占位符文本</param>
    private void AddBookmarkToPlaceholder(IWordDocument document, string bookmarkName, string placeholder)
    {
        try
        {
            var range = document.Content.Duplicate;
            if (range.FindAndReplace(placeholder, "") > 0)
            {
                document.Bookmarks.Add(bookmarkName, range);
            }
        }
        catch (Exception ex)
        {
            Console.WriteLine($"為占位符 {placeholder} 添加書簽時(shí)發(fā)生錯(cuò)誤: {ex.Message}");
        }
    }
}

using MudTools.OfficeInterop;
using MudTools.OfficeInterop.Word;
using System;
using System.Collections.Generic;
using System.IO;

// 完整的工資條生成系統(tǒng)
public class CompletePaySlipGenerationSystem
{
    private readonly DataService _dataService;
    private readonly PaySlipTemplateCreator _templateCreator;
    private readonly DocumentGenerationService _documentService;
    
    public CompletePaySlipGenerationSystem()
    {
        _dataService = new DataService();
        _templateCreator = new PaySlipTemplateCreator();
        _documentService = new DocumentGenerationService();
    }
    
    /// <summary>
    /// 運(yùn)行完整的工資條生成流程
    /// </summary>
    /// <param name="dataSourceType">數(shù)據(jù)源類型</param>
    /// <param name="dataSourcePath">數(shù)據(jù)源路徑</param>
    /// <param name="outputDirectory">輸出目錄</param>
    public void RunPaySlipGenerationProcess(DataSourceType dataSourceType, string dataSourcePath, string outputDirectory)
    {
        try
        {
            Console.WriteLine("開始工資條生成流程...");
            
            // 1. 創(chuàng)建模板（如果不存在）
            string templatePath = Path.Combine(outputDirectory, "工資條模板.dotx");
            if (!File.Exists(templatePath))
            {
                _templateCreator.CreatePaySlipTemplate(templatePath);
            }
            
            // 2. 從數(shù)據(jù)源獲取員工數(shù)據(jù)
            List<Employee> employees = GetEmployeeData(dataSourceType, dataSourcePath);
            if (employees == null || employees.Count == 0)
            {
                Console.WriteLine("未獲取到員工數(shù)據(jù)，流程終止");
                return;
            }
            
            Console.WriteLine($"成功獲取 {employees.Count} 名員工的數(shù)據(jù)");
            
            // 3. 生成工資條
            _documentService.GeneratePaySlips(templatePath, outputDirectory, employees);
            
            Console.WriteLine($"工資條生成流程完成，共生成 {employees.Count} 份工資條");
        }
        catch (Exception ex)
        {
            Console.WriteLine($"運(yùn)行工資條生成流程時(shí)發(fā)生錯(cuò)誤: {ex.Message}");
        }
    }
    
    /// <summary>
    /// 獲取員工數(shù)據(jù)
    /// </summary>
    /// <param name="dataSourceType">數(shù)據(jù)源類型</param>
    /// <param name="dataSourcePath">數(shù)據(jù)源路徑</param>
    /// <returns>員工數(shù)據(jù)列表</returns>
    private List<Employee> GetEmployeeData(DataSourceType dataSourceType, string dataSourcePath)
    {
        try
        {
            return dataSourceType switch
            {
                DataSourceType.Database => _dataService.GetEmployeesFromDatabase(dataSourcePath),
                DataSourceType.Excel => _dataService.GetEmployeesFromExcel(dataSourcePath),
                DataSourceType.Json => _dataService.GetEmployeesFromJson(dataSourcePath),
                _ => throw new ArgumentException("不支持的數(shù)據(jù)源類型")
            };
        }
        catch (Exception ex)
        {
            Console.WriteLine($"獲取員工數(shù)據(jù)時(shí)發(fā)生錯(cuò)誤: {ex.Message}");
            return new List<Employee>();
        }
    }
    
    /// <summary>
    /// 創(chuàng)建示例數(shù)據(jù)文件
    /// </summary>
    /// <param name="outputDirectory">輸出目錄</param>
    public void CreateSampleDataFiles(string outputDirectory)
    {
        try
        {
            // 創(chuàng)建示例JSON數(shù)據(jù)文件
            var sampleEmployees = new List<Employee>
            {
                new Employee
                {
                    Id = 1001,
                    Name = "張三",
                    Department = "技術(shù)部",
                    Salary = 15000,
                    Bonus = 3000,
                    HireDate = new DateTime(2020, 1, 15)
                },
                new Employee
                {
                    Id = 1002,
                    Name = "李四",
                    Department = "銷售部",
                    Salary = 12000,
                    Bonus = 5000,
                    HireDate = new DateTime(2019, 3, 22)
                },
                new Employee
                {
                    Id = 1003,
                    Name = "王五",
                    Department = "人事部",
                    Salary = 10000,
                    Bonus = 2000,
                    HireDate = new DateTime(2021, 5, 10)
                }
            };
            
            // 保存為JSON文件
            string jsonPath = Path.Combine(outputDirectory, "員工數(shù)據(jù).json");
            var jsonContent = Newtonsoft.Json.JsonConvert.SerializeObject(sampleEmployees, Newtonsoft.Json.Formatting.Indented);
            File.WriteAllText(jsonPath, jsonContent);
            
            Console.WriteLine($"示例數(shù)據(jù)文件已創(chuàng)建: {jsonPath}");
        }
        catch (Exception ex)
        {
            Console.WriteLine($"創(chuàng)建示例數(shù)據(jù)文件時(shí)發(fā)生錯(cuò)誤: {ex.Message}");
        }
    }
}

// 使用示例
class Program
{
    static void Main(string[] args)
    {
        var paySlipSystem = new CompletePaySlipGenerationSystem();
        
        // 創(chuàng)建輸出目錄
        string outputDirectory = @"C:\PaySlips";
        if (!Directory.Exists(outputDirectory))
        {
            Directory.CreateDirectory(outputDirectory);
        }
        
        // 創(chuàng)建示例數(shù)據(jù)文件
        paySlipSystem.CreateSampleDataFiles(outputDirectory);
        
        // 運(yùn)行工資條生成流程
        string jsonPath = Path.Combine(outputDirectory, "員工數(shù)據(jù).json");
        paySlipSystem.RunPaySlipGenerationProcess(DataSourceType.Json, jsonPath, outputDirectory);
        
        Console.WriteLine("工資條生成系統(tǒng)運(yùn)行完成！");
    }
}