From 01c5166aad248cf4de78d7aeb53c31f961835f02 Mon Sep 17 00:00:00 2001
From: yanjinhui <3306209981@qq.com>
Date: 星期日, 27 四月 2025 08:46:23 +0800
Subject: [PATCH] 1

---
 项目代码/WCS/WIDESEAWCS_Server/WIDESEAWCS_TelescopicService/MaintenanceTeamService.cs |   97 +++++++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 94 insertions(+), 3 deletions(-)

diff --git "a/\351\241\271\347\233\256\344\273\243\347\240\201/WCS/WIDESEAWCS_Server/WIDESEAWCS_TelescopicService/MaintenanceTeamService.cs" "b/\351\241\271\347\233\256\344\273\243\347\240\201/WCS/WIDESEAWCS_Server/WIDESEAWCS_TelescopicService/MaintenanceTeamService.cs"
index 317b221..44f9d69 100644
--- "a/\351\241\271\347\233\256\344\273\243\347\240\201/WCS/WIDESEAWCS_Server/WIDESEAWCS_TelescopicService/MaintenanceTeamService.cs"
+++ "b/\351\241\271\347\233\256\344\273\243\347\240\201/WCS/WIDESEAWCS_Server/WIDESEAWCS_TelescopicService/MaintenanceTeamService.cs"
@@ -1,10 +1,13 @@
-锘縰sing System;
+锘縰sing SqlSugar;
+using System;
 using System.Collections.Generic;
 using System.Linq;
 using System.Text;
 using System.Threading.Tasks;
+using WIDESEAWCS_Core;
 using WIDESEAWCS_Core.BaseRepository;
 using WIDESEAWCS_Core.BaseServices;
+using WIDESEAWCS_DTO.Telescopic;
 using WIDESEAWCS_Model.Models;
 
 namespace WIDESEAWCS_ITelescopicService
@@ -12,12 +15,100 @@
     public class MaintenanceTeamService : ServiceBase<Dt_MaintenanceTeam, IRepository<Dt_MaintenanceTeam>>, IMaintenanceTeamService
     {
         public IRepository<Dt_MaintenanceTeam> Repository => BaseDal;
+        private readonly IRepository<Sys_User> _user;
 
-        public MaintenanceTeamService(IRepository<Dt_MaintenanceTeam> BaseDal) : base(BaseDal)
+        public MaintenanceTeamService(IRepository<Dt_MaintenanceTeam> BaseDal,IRepository<Sys_User> user) : base(BaseDal)
         {
-
+            _user = user;
         }
 
 
+        /// <summary>
+        /// 妫�淇缃褰�
+        /// </summary>
+        /// <returns></returns>
+        /// <exception cref="NotImplementedException"></exception>
+        public WebResponseContent MaintenanceSettingRecord(PaginationDTO pagination)
+        {
+            try
+            {
+                int totalCount = 0;
+
+                var sys = _user.Db.Queryable<Sys_User>();
+                var main = Db.Queryable<Dt_MaintenanceTeam>();
+
+
+                //妯$硦鏌ヨ
+                var query = sys.InnerJoin<Dt_MaintenanceTeam>((a, b) => a.UserTrueName == b.OperatorName);
+                if (!string .IsNullOrEmpty(pagination.searchKeyword))
+                {
+                   
+                    query = query.Where((a, b) =>
+                       b.OperatorName.Contains(pagination.searchKeyword) ||
+                       b.TeamName.Contains(pagination.searchKeyword) ||
+                       b.Modifier.Contains(pagination.searchKeyword)
+                   );
+                }
+                //鏃堕棿鏌ヨ
+                if (pagination.startDate.HasValue&&pagination.endDate.HasValue)
+                {
+                    query = query.Where((a, b) => b.DistributionTime >= pagination.startDate && b.DistributionTime <= pagination.endDate);
+                }
+                //鎺掑簭
+                if (!string.IsNullOrEmpty(pagination.sortField))
+                {
+                    var isAsc = pagination.sortOrder?.ToLower() == "asc";
+                    query = pagination.sortField.ToLower() switch
+                    {
+                        //"OperatorName" => isAsc ? query.OrderBy((a, b) => b.OperatorName) : query.OrderByDescending((a, b) => b.OperatorName),
+
+                        //"TeamName" => isAsc ? query.OrderBy((a, b) => b.TeamName) : query.OrderByDescending((a, b) => b.TeamName),
+
+                        "distributiontime" => isAsc ? query.OrderBy((a, b) => b.DistributionTime) : query.OrderByDescending((a, b) => b.DistributionTime),
+
+                        //"Modifier" => isAsc ? query.OrderBy((a, b) => b.Modifier) : query.OrderByDescending((a, b) => b.Modifier),
+
+                        _ => query.OrderByDescending((a, b) => b.Creater), // 榛樿鎸夊垱寤烘椂闂撮檷搴�
+                    };
+
+                }
+                else
+                {
+                    //榛樿鎸夊垱寤烘椂闂撮檷搴忔帓搴�
+                    query = query.OrderByDescending((a, b) => b.Creater);
+                }
+
+                //杩斿洖缁撴灉
+                var result=query
+                .Select((a, b) => new
+                {
+                    a.User_Id,
+                    b.OperatorName,
+                    b.TeamName,
+                    a.HeadImageUrl,
+                    b.DistributionTime,
+                    b.Modifier,
+                }).ToPageList(pagination.pageIndex, pagination.pageSize, ref totalCount);
+                return new WebResponseContent
+                {
+                    Status = true,
+                    Data = new
+                    {
+                        TotalCount = totalCount,//鎬绘暟
+                        PageIndex = pagination.pageIndex,//椤垫暟
+                        PageSize = pagination.pageSize,//涓�椤靛灏戜釜鏁版嵁
+                        Items = result
+                    }
+                };
+
+            }
+            catch (Exception ex)
+            {
+
+                return new WebResponseContent { Status = false,Message="閿欒淇℃伅锛�"+ex.Message };
+            }
+
+        }
+
     }
 }

--
Gitblit v1.9.3