From ce9702d2e5699c4c9acbed52da1fb6052ec68c6c Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期二, 15 四月 2025 16:45:39 +0800
Subject: [PATCH] 1.生产补料优化 2.登录图标查询优化 3.采购退货优化
---
entity/Base/ItemDetailModel.cs | 3 +
service/Warehouse/MesCgthSqManager.cs | 32 +++++++++++-----
service/Warehouse/MesItemBlManager.cs | 68 +++++++++++++++++++++++----------
service/base/LoginService.cs | 4 +
4 files changed, 74 insertions(+), 33 deletions(-)
diff --git a/entity/Base/ItemDetailModel.cs b/entity/Base/ItemDetailModel.cs
index d31e62c..423cbb1 100644
--- a/entity/Base/ItemDetailModel.cs
+++ b/entity/Base/ItemDetailModel.cs
@@ -16,6 +16,7 @@
public decimal? DSQty { get; set; } // 寰呮壂鏁伴噺
public decimal? RQty { get; set; } // 璋冨叆宸叉壂鏁伴噺
public string Pid { get; set; } // 鍏宠仈瀛楁
- public string FMaterialId { get; set; } // 鏉愭枡 ID
+ public string FMaterialId { get; set; } // 鏉愭枡
+ public string DAA001 { get; set; } // 鏉愭枡 ID
public string Id { get; set; } // 涓婚敭 ID
}
\ No newline at end of file
diff --git a/service/Warehouse/MesCgthSqManager.cs b/service/Warehouse/MesCgthSqManager.cs
index 3c77c8c..d4634cf 100644
--- a/service/Warehouse/MesCgthSqManager.cs
+++ b/service/Warehouse/MesCgthSqManager.cs
@@ -4,6 +4,7 @@
using NewPdaSqlServer.DB;
using NewPdaSqlServer.Dto.service;
using NewPdaSqlServer.entity;
+using NewPdaSqlServer.entity.Base;
using SqlSugar;
namespace NewPdaSqlServer.service.Warehouse;
@@ -14,27 +15,38 @@
{
return Db.Queryable<MesCgthSq>()
.Where(s => s.Status == true)
+ .OrderByDescending(s => s.CreateDate)
.ToList();
}
- public OutItemDto GetSumItem(WarehouseQuery query)
+ public ProductionPickDto GetSumItem(WarehouseQuery query)
{
+ if (string.IsNullOrEmpty(query.billNo)) throw new Exception("鐢宠鍗曞彿涓虹┖");
+
var mesInvItemOuts = base.GetSingle(it => it.BillNo == query.billNo);
if (mesInvItemOuts == null) throw new Exception("閲囪喘閫�璐х敵璇峰崟涓嶅瓨鍦�");
- var dto = new OutItemDto();
- dto.SumItem = GetItems(query);
+ var sql = string.Format(@"SELECT c.item_no ItemNo,c.item_name ItemName,c.item_model ItemModel,A.SQ_NUM FQty,A.YS_NUM SQty,A.SQ_NUM - A.YS_NUM DSQty,
+ dbo.F_QX_GETRECODEPOTSE(A.ITEM_ID) as RecoKw
+fROM MES_CGTH_SQ_DETAIL A
+ LEFT JOIN MES_CGTH_SQ B ON A.MID = B.ID
+ LEFT JOIN MES_ITEMS C ON A.ITEM_ID = C.item_id
+WHERE B.BILL_NO = '{0}'", query.billNo);
- var mesInvItemStocks = Db.Queryable<MesInvItemStocks>()
- .Where(a => a.ItemBarcode == query.barcode).Single();
+ var womdabs = Db.Ado.SqlQuery<ItemDetailModel>(sql);
- if (mesInvItemStocks == null) return dto;
- var mesItems = Db.Queryable<MesItems>()
- .Where(s => s.Id == mesInvItemStocks.ItemId).Single();
+ var DS_list = womdabs.Where(s => s.DSQty > 0).ToList();
- dto.ItemNo = mesItems.ItemNo;
- dto.Quantity = mesInvItemStocks.Quantity;
+ var YS_list = womdabs.Where(s => s.SQty > 0).ToList();
+
+ var dto = new ProductionPickDto
+ {
+ //daa001 = womdaa.Daa001,
+ //PlanNo = womcaa.Caa020,
+ items = DS_list,
+ Ysitems = YS_list
+ };
return dto;
}
diff --git a/service/Warehouse/MesItemBlManager.cs b/service/Warehouse/MesItemBlManager.cs
index a85bd93..1dcfb9a 100644
--- a/service/Warehouse/MesItemBlManager.cs
+++ b/service/Warehouse/MesItemBlManager.cs
@@ -2,6 +2,7 @@
using NewPdaSqlServer.DB;
using NewPdaSqlServer.Dto.service;
using NewPdaSqlServer.entity;
+using NewPdaSqlServer.entity.Base;
using NewPdaSqlServer.util;
using SqlSugar;
@@ -19,8 +20,9 @@
{
var list = Db.Queryable<MesItemBl>()
.Where(s => (s.Bl018 ?? false) == true
- && (s.Bl019 ?? false) == false
+ //&& (s.Bl019 ?? false) == false
&& s.Bl008 == query.Type)
+ .OrderByDescending(s => s.Bl006)
.Select(s => s.BlNo)
.ToList();
return list;
@@ -31,7 +33,7 @@
/// </summary>
/// <param name="billNo">琛ユ枡鍗曞彿</param>
/// <returns>琛ユ枡鍗曟槑缁嗗垪琛�</returns>
- public (string bl001, List<MesItemBlDetail> item)
+ public ProductionPickDto
GetMesItemBlDetailByBillNo(
WarehouseQuery query)
{
@@ -46,26 +48,50 @@
if (mesItemBl == null)
throw new Exception("鍗曟嵁鍙蜂笉瀛樺湪鎴栨湭瀹℃牳锛�");
- if (mesItemBl.Bl019 == true)
- throw new Exception("鍗曟嵁鍙峰凡瀹屾垚锛�");
+ //if (mesItemBl.Bl019 == true)
+ // throw new Exception("鍗曟嵁鍙峰凡瀹屾垚锛�");
- // 鑾峰彇鏈畬鎴愮殑琛ユ枡鍗曟槑缁�
- var blDetails = Db.Queryable<MesItemBl, MesItemBlDetail>((a, b) =>
- new JoinQueryInfos(JoinType.Left, a.Id == b.Mid))
- .Where((a, b) => a.BlNo == query.billNo
- && (b.Bld007 ?? 0) - (b.Bld008 ?? 0) > 0)
- .Select((a, b) => new MesItemBlDetail
- {
- Bld012 = b.Bld012,
- Bld002 = b.Bld002,
- Bld003 = b.Bld003,
- Bld004 = b.Bld004,
- Bld007 = b.Bld007,
- Bld008 = b.Bld008
- })
- .ToList();
+ //// 鑾峰彇鏈畬鎴愮殑琛ユ枡鍗曟槑缁�
+ //var blDetails = Db.Queryable<MesItemBl, MesItemBlDetail>((a, b) =>
+ // new JoinQueryInfos(JoinType.Left, a.Id == b.Mid))
+ // .Where((a, b) => a.BlNo == query.billNo
+ // && (b.Bld007 ?? 0) - (b.Bld008 ?? 0) > 0)
+ // .Select((a, b) => new MesItemBlDetail
+ // {
+ // Bld012 = b.Bld012,
+ // Bld002 = b.Bld002,
+ // Bld003 = b.Bld003,
+ // Bld004 = b.Bld004,
+ // Bld007 = b.Bld007,
+ // Bld008 = b.Bld008
+ // })
+ // .ToList();
- return (mesItemBl.Bl001, blDetails);
+ //return (mesItemBl.Bl001, blDetails);
+ var sql = string.Format(@"SELECT c.item_no ItemNo,c.item_name ItemName,c.item_model ItemModel,A.BLD007 FQty,A.BLD008 SQty,A.BLD007 - A.BLD008 DSQty,
+ dbo.F_QX_GETRECODEPOTSE(A.bld012) as RecoKw,D.daa001
+fROM MES_ITEM_BL_DETAIL A
+ LEFT JOIN MES_ITEM_BL B ON A.MID = B.ID
+ LEFT JOIN MES_ITEMS C ON A.bld012 = CAST(C.item_id AS VARCHAR(50))
+ LEFT JOIN WOMDAA D ON B.about_guid = D.guid
+WHERE B.bl_no = '{0}'", query.billNo);
+
+ var womdabs = Db.Ado.SqlQuery<ItemDetailModel>(sql);
+
+
+ var DS_list = womdabs.Where(s => s.DSQty > 0).ToList();
+
+ var YS_list = womdabs.Where(s => s.SQty > 0).ToList();
+
+ var dto = new ProductionPickDto
+ {
+ daa001 = womdabs[0].DAA001,
+ //PlanNo = womcaa.Caa020,
+ items = DS_list,
+ Ysitems = YS_list
+ };
+
+ return dto;
}
/// <summary>
@@ -331,7 +357,7 @@
PbillNo = query.billNo,
ItemId = blDetail.Bld012,
Unit = blDetail.Bld009,
- DepotId = (int)stockBarcode.DepotsId,
+ DepotId = (int)stockBarcode.DepotId,
EbelnK3id = womdab.Eid,
LineK3id = womdab.Erpid
}).IgnoreColumns(true).ExecuteCommand();
diff --git a/service/base/LoginService.cs b/service/base/LoginService.cs
index c483032..89fcf9d 100644
--- a/service/base/LoginService.cs
+++ b/service/base/LoginService.cs
@@ -65,7 +65,9 @@
foreach (var pageView in group)
{
var mesFile = Db.Queryable<MesFile>()
- .Where(s => s.ParentGuid == pageView.Guid).First();
+ .Where(s => s.ParentGuid == pageView.Guid)
+ .OrderByDescending(s => s.CreateDate)
+ .First();
var icoimg = "";
if (mesFile != null)
--
Gitblit v1.9.3