antissoft / lvqianmeiye_ERP

- 重构为分步查询方式，避免子查询返回null导致的类型转换错误
- 使用SqlFunc.AggregateSum确保聚合函数返回0而不是null
- 在内存中使用FirstOrDefault和??操作符安全处理null值
- 确保ConsumedCount和RefundedCount始终为decimal类型
- 修复了会员剩余品项查询时的Index was outside the bounds of the array错误

- 修复LqKhxxService.cs中UserEntity类型未找到的错误
- 添加正确的using语句解决命名空间问题
- 优化开单记录表和拓客管理的导出功能
- 修复Excel导出中的数组越界错误
- 完善前端拓客管理页面的显示和交互
- 项目现在可以正常编译和运行

- 新增 TkjlbExportModel DTO 类，将导出模型从服务层分离到 DTO 层
- 修复拓客管理导出功能的下载地址500错误
- 优化拓客管理列表页面：
  * 将活动编号搜索改为下拉框选择
  * 调整列宽度，拓客编号列加宽，备注列移除宽度限制
  * 移除编辑、删除、批量删除按钮
  * 优化表格样式和用户体验
- 简化导出功能，固定导出字段，支持活动编号和截止时间筛选
- 修复开单记录表导出功能，添加中文名称显示
- 创建临时文件目录以支持文件导出功能

主要变更：
1. 删除部门管理模块 (lq_bmzb)
   - 删除实体类、服务类、接口类、DTO类
   - 删除前端页面和映射类
   - 更新相关文档

2. 修复预约记录服务错误
   - 修复 GetInfo 方法中 SqlFunc.Subqueryable 使用错误
   - 改为使用标准查询方式获取关联数据
   - 添加空值检查提升代码安全性

3. 其他优化
   - 更新客户信息相关字段映射
   - 优化邀约记录和拓客记录服务
   - 更新会员类型枚举定义

…d completion statistics. Introduce new LqStatisticsService methods for saving and querying technology department performance statistics. Update LqTkjlbService to associate member information with store IDs. Refactor LqKdKdjlbStringGenerator for cleaner output formatting.

…trieval endpoints, enhancing performance with database aggregation. Introduce personal performance statistics handling, including saving and querying capabilities. Update LqYcsdJsjService to temporarily disable T area creation logic pending business confirmation.

…w endpoints for gold triangle statistics and member data retrieval. Update LqKdKdjlbService to incorporate deduct amount calculations and streamline data handling. Modify LqKhxxService to remove obsolete fields and improve data structure. Enhance LqYaoyjlService and LqYcsdJsjService for better data output consistency and clarity. Adjust launch settings to disable browser launch for both NCC.API and NCC.API.Tenant projects.

…nual mapping for event output, update member retrieval logic, and streamline event type retrieval. Modify LqHytkHytkService to adjust entity relationships and improve data handling. Introduce deduct information handling in LqKdKdjlbService and update related DTOs for consistency. Enhance LqTkjlbService to improve data retrieval and organization. Update LqXhHyhkService to refine consumption tracking and improve data integrity.

…es; add manual time field settings to preserve time accuracy; implement GetEventTypes endpoint to retrieve event type enumeration; update LqTkjlb DTO to include eventId and eventName for better tracking of related events.

… for Excel import process; modify LqEventUser DTO to support TargetCount; update projectNumber type in LqKdPxmx DTO and entity to decimal for consistency.

…ce LqEventUser DTO with StoreId; implement Excel import functionality for LqEvent users; add UploadBase64Image method in FileService for user signature uploads.

…ndex.vue for improved layout and consistency; update LqKhxx DTOs and services for better structure and clarity.

…date multiple .DS_Store files for project consistency.

…thods in LqStatisticsService to enhance accessibility for API endpoints.

…和科技部老师业绩统计功能，优化查询逻辑和代码结构，确保代码整洁性和功能完整性。