From 8ec3d69f02da17b688a50b9a5db81ed24e3c0f7d Mon Sep 17 00:00:00 2001
From: Administrator <Administrator@DESKTOP-5BIMHQ3>
Date: 星期二, 16 七月 2024 09:35:08 +0800
Subject: [PATCH] Merge branch 'wxw'
---
Wms/WMS.BLL/LogServer/OperationSOServer.cs | 51 +++++++++++--------------
Wms/Wms/Controllers/BllSoController.cs | 15 ++-----
Wms/WMS.IBLL/ILogServer/IOperationSOServer.cs | 6 ++-
3 files changed, 31 insertions(+), 41 deletions(-)
diff --git a/Wms/WMS.BLL/LogServer/OperationSOServer.cs b/Wms/WMS.BLL/LogServer/OperationSOServer.cs
index f8cff57..f59a724 100644
--- a/Wms/WMS.BLL/LogServer/OperationSOServer.cs
+++ b/Wms/WMS.BLL/LogServer/OperationSOServer.cs
@@ -3,6 +3,7 @@
using System.Linq;
using System.Linq.Expressions;
using System.Text;
+using System.Threading.Tasks;
using Model.ModelDto.LogDto;
using SqlSugar;
using WMS.BLL.SysServer;
@@ -21,43 +22,35 @@
public OperationSOServer() : base(Db)
{
}
- public List<OperationDto> GetLogOperationSoList(string menuName, string type, string msg, string startTime, string endTime, int page, int limit, out int count)
+ public async Task<List<OperationDto>> GetLogOperationSoList(string menuName, string type, string msg, string startTime, string endTime, int page, int limit, RefAsync<int> count)
{
- try
- {
- var item = Expressionable.Create<LogOperationSO>()
+ var item = Expressionable.Create<LogOperationSO>()
.AndIF(!string.IsNullOrWhiteSpace(menuName), it => it.MenuName.Contains(menuName.Trim()))
.AndIF(!string.IsNullOrWhiteSpace(type), it => it.Type == type)
.AndIF(!string.IsNullOrWhiteSpace(msg), it => it.Msg.Contains(msg.Trim()))
.AndIF(!string.IsNullOrWhiteSpace(startTime), it => it.CreateTime >= Convert.ToDateTime(startTime))
.AndIF(!string.IsNullOrWhiteSpace(endTime), it => it.CreateTime <= Convert.ToDateTime(endTime).AddDays(1))
.ToExpression();//娉ㄦ剰 杩欎竴鍙� 涓嶈兘灏�
- var total = 0;
- var list = GetAllWhereAsync(item)
- .LeftJoin<SysDictionary>((it, dic) => it.Type == dic.Id.ToString())
- .LeftJoin<SysUserInfor>((it, dic, users) => it.CreateUser == users.Id)
- .Select((it, dic, users) => new OperationDto()
- {
- Id = it.Id,
- ParentNo = it.ParentNo,
- MenuNo = it.MenuNo,
- MenuName = it.MenuName,
- FkNo = it.FkNo,
- Type = dic.DictName,
- Msg = it.Msg,
- CreateTime = it.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"),
- CreateUserName = users.RealName,
- })
- .OrderByDescending(it => it.CreateTime)
- .ToOffsetPage(page, limit, ref total);
- count = total;
- return list.OrderByDescending(m => m.CreateTime).ToList();
- }
- catch (Exception e)
- {
- throw new Exception(e.Message);
- }
+ var list = await GetAllWhereAsync(item)
+ .LeftJoin<SysDictionary>((it, dic) => it.Type == dic.Id.ToString())
+ .LeftJoin<SysUserInfor>((it, dic, users) => it.CreateUser == users.Id)
+ .Select((it, dic, users) => new OperationDto()
+ {
+ Id = it.Id,
+ ParentNo = it.ParentNo,
+ MenuNo = it.MenuNo,
+ MenuName = it.MenuName,
+ FkNo = it.FkNo,
+ Type = dic.DictName,
+ Msg = it.Msg,
+ CreateTime = it.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"),
+ CreateUserName = users.RealName,
+ })
+ .OrderByDescending(it => it.CreateTime)
+ .ToPageListAsync(page, limit, count);
+
+ return list.OrderByDescending(m => m.CreateTime).ToList();
}
public bool AddLogOperationSo(string parentNo, string menuName, string fkNo, string type, string msg, int userId)
{
diff --git a/Wms/WMS.IBLL/ILogServer/IOperationSOServer.cs b/Wms/WMS.IBLL/ILogServer/IOperationSOServer.cs
index 0197a1a..5043705 100644
--- a/Wms/WMS.IBLL/ILogServer/IOperationSOServer.cs
+++ b/Wms/WMS.IBLL/ILogServer/IOperationSOServer.cs
@@ -1,7 +1,9 @@
锘縰sing System;
using System.Collections.Generic;
using System.Text;
+using System.Threading.Tasks;
using Model.ModelDto.LogDto;
+using SqlSugar;
namespace WMS.IBLL.ILogServer
{
@@ -19,8 +21,8 @@
/// <param name="limit"></param>
/// <param name="count"></param>
/// <returns></returns>
- List<OperationDto> GetLogOperationSoList(string menuName, string type, string msg, string startTime,
- string endTime, int page, int limit, out int count);
+ Task<List<OperationDto>> GetLogOperationSoList(string menuName, string type, string msg, string startTime,
+ string endTime, int page, int limit, RefAsync<int> count);
/// <summary>
/// 娣诲姞鍑哄簱鎿嶄綔鏃ュ織
/// </summary>
diff --git a/Wms/Wms/Controllers/BllSoController.cs b/Wms/Wms/Controllers/BllSoController.cs
index 5300f86..438391d 100644
--- a/Wms/Wms/Controllers/BllSoController.cs
+++ b/Wms/Wms/Controllers/BllSoController.cs
@@ -850,18 +850,13 @@
/// <param name="model"></param>
/// <returns></returns>
[HttpPost]
- public IActionResult GetLogOperationSoList(GetOperationVm model)
+ [ServiceFilter(typeof(ApiResponseActionFilter))]
+ public async Task<SqlSugarPagedList> GetLogOperationSoList(GetOperationVm model)
{
- try
- {
- var bolls = _logSvc.GetLogOperationSoList(model.MenuName, model.Type, model.Msg, model.StartTime, model.EndTime,model.Page, model.Limit, out int count);
+ RefAsync<int> count = new RefAsync<int>();
+ var bolls = await _logSvc.GetLogOperationSoList(model.MenuName, model.Type, model.Msg, model.StartTime, model.EndTime, model.Page, model.Limit, count);
- return Ok(new { code = 0, count, msg = "鍑哄簱鎿嶄綔鏃ュ織淇℃伅", data = bolls });
- }
- catch (Exception e)
- {
- return Ok(new { code = 1, msg = e.Message });
- }
+ return new SqlSugarPagedList() { Items = bolls, Total = count };
}
#endregion
--
Gitblit v1.8.0