From a619299816f2f632c7c6ba3a1bb869e2c212797d Mon Sep 17 00:00:00 2001
From: fcx <2246384483@qq.com>
Date: 星期五, 19 十二月 2025 14:12:33 +0800
Subject: [PATCH] 对添加巡检单物料编码进行去重
---
StandardPda/MES.Service/service/Warehouse/MesInvItemArnManager.cs | 58 ----------------------------------------------------------
1 files changed, 0 insertions(+), 58 deletions(-)
diff --git a/StandardPda/MES.Service/service/Warehouse/MesInvItemArnManager.cs b/StandardPda/MES.Service/service/Warehouse/MesInvItemArnManager.cs
index c382c5c..d7a41fe 100644
--- a/StandardPda/MES.Service/service/Warehouse/MesInvItemArnManager.cs
+++ b/StandardPda/MES.Service/service/Warehouse/MesInvItemArnManager.cs
@@ -1,66 +1,8 @@
锘縰sing MES.Service.DB;
-using MES.Service.Dto.service;
using MES.Service.Modes;
-using SqlSugar;
namespace MES.Service.service.Warehouse;
public class MesInvItemArnManager : Repository<MesInvItemArn>
{
- //褰撳墠绫诲凡缁忕户鎵夸簡 Repository 澧炪�佸垹銆佹煡銆佹敼鐨勬柟娉�
-
- //杩欓噷闈㈠啓鐨勪唬鐮佷笉浼氱粰瑕嗙洊,濡傛灉瑕侀噸鏂扮敓鎴愯鍒犻櫎 MesInvItemArnManager.cs
- public List<MesInvItemArn> GetPagedResults(WarehouseQuery query)
- {
- // 鏌ヨ骞跺垎椤�
- var result = Db.Queryable<MesInvItemArn, MesDepots, MesSupplier>(
- (a, d, f) => new object[]
- {
- JoinType.Left,
- a.DepotsCode == d.DepotCode && d.Factory == a.Factory &&
- d.Company == a.Company,
- JoinType.Left, a.SuppNo == f.SuppNo
- })
- .Where((a, d, f) => a.BillTypeId == 700
- && a.TransctionNo == "701"
- && a.Factory == "1000"
- && a.Company == "1000"
- && a.IsVisual == 0)
- .WhereIF(query.id != null, (a, d, f) => a.Id == query.id)
- .Select((a, d, f) => new MesInvItemArn
- {
- Status = a.Status,
- SuppNo = a.SuppNo,
- FType = a.FType,
- Fstatus = a.Fstatus,
- Remark = a.Remark,
- Insdate = a.Insdate,
- CheckDate = a.CheckDate,
- DepotsCode = a.DepotsCode,
- Id = a.Id,
- UrgentFlag = a.UrgentFlag,
- CreateBy = a.CreateBy,
- BillNo = a.BillNo,
- PaperBillNo = a.PaperBillNo,
- DepotName = d.DepotName,
- SuppName = f.SuppName
- }).OrderByDescending(a => a.BillNo)
- .ToPageList(query.PageIndex, query.Limit);
-
- return result;
- }
-
- public List<MesSupplier> GetSuppliers()
- {
- return Db.Queryable<MesInvItemArn, MesSupplier>((a, b) =>
- new JoinQueryInfos(JoinType.Left, a.SuppNo == b.SuppNo))
- .GroupBy((a, b) => new { b.Id, a.SuppNo, b.SuppName })
- .Select((a, b) => new MesSupplier
- {
- SuppNo = a.SuppNo,
- SuppName = b.SuppName,
- Id = b.Id
- })
- .ToList();
- }
}
\ No newline at end of file
--
Gitblit v1.9.3