From 1e12c140c041c0cb52306a0db9ff0ba18354d0d8 Mon Sep 17 00:00:00 2001
From: dengjunjie <dengjunjie@hnkhzn.com>
Date: 星期四, 03 四月 2025 18:01:52 +0800
Subject: [PATCH] 优化WMS前端首页,货位查询column数据库关键字处理
---
项目代码/WMS/WIDESEA_WMSServer/WIDESEA_DTO/Stock/StockViewDTO.cs | 65 ++++++++++++++++++++++++++++++++
1 files changed, 65 insertions(+), 0 deletions(-)
diff --git "a/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_DTO/Stock/StockViewDTO.cs" "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_DTO/Stock/StockViewDTO.cs"
index ae06f8b..b86f4ae 100644
--- "a/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_DTO/Stock/StockViewDTO.cs"
+++ "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_DTO/Stock/StockViewDTO.cs"
@@ -56,4 +56,69 @@
[Navigate(NavigateType.OneToMany, nameof(Dt_StockInfoDetail.StockId), nameof(StockId))]
public List<Dt_StockInfoDetail> Details { get; set; }
}
+
+ public class StockViewDTO1
+ {
+ [SugarColumn(IsPrimaryKey = true, IsIdentity = true, ColumnDescription = "涓婚敭")]
+ public int StockId { get; set; }
+ public string LocationCode { get; set; }
+ public string PalletCode { get; set; }
+ public DateTime? InDate { get; set; }
+
+ public string MaterielCode { get; set; }
+
+ public string MaterielName { get; set; }
+
+ [Navigate(NavigateType.OneToMany, nameof(Dt_StockInfoDetail.StockId), nameof(StockId))]
+ public List<Dt_StockInfoDetail> Details { get; set; }
+ }
+ public class LocationStockView
+ {
+ public int AreaId { get; set; }
+
+ public string LocationCode { get; set; }
+
+ public string LocationName { get; set; }
+
+ public int Column { get; set; }
+
+ public int Row { get; set; }
+
+ public int Layer { get; set; }
+
+ public int Depth { get; set; }
+
+ public int LocationStatus { get; set; }
+
+ public int LocationType { get; set; }
+
+ public string RoadwayNo { get; set; }
+
+ public int EnalbeStatus { get; set; }
+
+ public string PalletCode { get; set; }
+
+ public int Quantity { get; set; }
+
+ public DateTime? InDate { get; set; }
+
+ public string MaterielCode { get; set; }
+
+ public string MaterielName { get; set; }
+
+ public string OrderNo { get; set; }
+
+ public string BatchNo { get; set; }
+ }
+ public class LocationLayer
+ {
+ public int index { get; set; }
+ public List<LocationRow> rows { get; set; }
+ }
+ public class LocationRow
+ {
+ public int index { get; set; }
+
+ public List<LocationStockView> cols { get; set; }
+ }
}
--
Gitblit v1.9.3