From f9a3bc1bfcb80239e5da8e0c5908ba0aa43e15d1 Mon Sep 17 00:00:00 2001
From: Demo <Demo@DESKTOP-CPA90BF>
Date: 星期三, 31 一月 2024 11:26:01 +0800
Subject: [PATCH] 添加箱码信息表及接口实现
---
Wms/Model/ModelVm/BllAsnVm/LabelBoxVm.cs | 12 ++
Wms/WMS.Entity/BllAsnEntity/BllLabelBoxNo.cs | 183 ++++++++++++++++++++++++++++++++++++
Wms/WMS.IBLL/IBllAsnServer/IBllLabelBoxNoServer.cs | 19 +++
Wms/WMS.BLL/BllAsnServer/BllLabelBoxNoServer.cs | 82 ++++++++++++++++
4 files changed, 296 insertions(+), 0 deletions(-)
diff --git a/Wms/Model/ModelVm/BllAsnVm/LabelBoxVm.cs b/Wms/Model/ModelVm/BllAsnVm/LabelBoxVm.cs
new file mode 100644
index 0000000..f414ea8
--- /dev/null
+++ b/Wms/Model/ModelVm/BllAsnVm/LabelBoxVm.cs
@@ -0,0 +1,12 @@
+锘縰sing System;
+using System.Collections.Generic;
+using System.Text;
+
+namespace Model.ModelVm.BllAsnVm
+{
+ public class LabelBoxVm:IndexPage
+ {
+ public string AsnNo { get; set; }
+ public string BoxNo { get; set; }
+ }
+}
diff --git a/Wms/WMS.BLL/BllAsnServer/BllLabelBoxNoServer.cs b/Wms/WMS.BLL/BllAsnServer/BllLabelBoxNoServer.cs
new file mode 100644
index 0000000..e936662
--- /dev/null
+++ b/Wms/WMS.BLL/BllAsnServer/BllLabelBoxNoServer.cs
@@ -0,0 +1,82 @@
+锘縰sing System;
+using System.Collections.Generic;
+using System.Linq.Expressions;
+using System.Text;
+using Model.ModelVm.BllAsnVm;
+using SqlSugar;
+using WMS.DAL;
+using WMS.Entity.BllAsnEntity;
+using WMS.Entity.Context;
+using WMS.Entity.SysEntity;
+using WMS.IBLL.IBllAsnServer;
+
+namespace WMS.BLL.BllAsnServer
+{
+ public class BllLabelBoxNoServer : DbHelper<BllLabelBoxNo>, IBllLabelBoxNoServer
+ {
+ private static readonly SqlSugarScope Db = DataContext.Db;
+
+ public BllLabelBoxNoServer() : base(Db)
+ {
+ }
+
+ //鑾峰彇鏍囩绠辩爜淇℃伅
+ public List<BllLabelBoxNo> GetLabelBoxList(LabelBoxVm model, out int count)
+ {
+ try
+ {
+ Expression<Func<BllLabelBoxNo, bool>> item = Expressionable.Create<BllLabelBoxNo>()
+ .AndIF(!string.IsNullOrWhiteSpace(model.AsnNo), it => it.ASNNo.Contains(model.AsnNo.Trim()))
+ .AndIF(!string.IsNullOrWhiteSpace(model.BoxNo), it => it.BoxNo.Contains(model.BoxNo.Trim()))
+ //.AndIF(!string.IsNullOrWhiteSpace(model.StartTime), it => it.CreateTime >= Convert.ToDateTime(model.StartTime))
+ //.AndIF(!string.IsNullOrWhiteSpace(model.EndTime), it => it.CreateTime <= Convert.ToDateTime(model.EndTime).AddDays(1))
+ .And(it => it.IsDel == "0")
+ .ToExpression();
+ var total = 0;
+ var data = GetAllWhereAsync(item)
+ .LeftJoin<SysUserInfor>((a, b) => a.CreateUser == b.Id)
+ .LeftJoin<SysUserInfor>((a, b, c) => a.UpdateUser == c.Id)
+ .Select((a, b, c) => new BllLabelBoxNo()
+ {
+ Id = a.Id,
+ ASNNo = a.ASNNo,
+ ASNDetailNo = a.ASNDetailNo,
+ BoxNo = a.BoxNo,
+ ParentBoxNo = a.ParentBoxNo,
+ Qty = a.Qty,
+ SkuNo = a.SkuNo,
+ SkuName = a.SkuName,
+ LotNo = a.LotNo,
+ LotText = a.LotText,
+ SupplierName = a.SupplierName,
+ SupplierLot = a.SupplierLot,
+ ProductionTime = a.ProductionTime,
+ ExpirationTime = a.ExpirationTime,
+ InspectTime = a.InspectTime,
+ CompleteTime = a.CompleteTime,
+ IsUse = a.IsUse,
+ Level = a.Level,
+ QtyCount = a.QtyCount,
+ QtyOrd = a.QtyOrd,
+ UDF1 = a.UDF1,
+ UDF2 = a.UDF2,
+ UDF3 = a.UDF3,
+ UDF4 = a.UDF4,
+ UDF5 = a.UDF5,
+
+ //CreateUserName = b.RealName,
+ //UpdateUserName = c.RealName,
+ CreateTime = a.CreateTime,
+ UpdateTime = a.UpdateTime
+
+ }).OrderByDescending(a => a.CreateTime).OrderBy(a => a.BoxNo).ToOffsetPage(model.Page, model.Limit, ref total);
+ count = total;
+ //return data;
+ }
+ catch (Exception e)
+ {
+ throw new Exception(e.Message);
+ }
+ }
+ }
+}
diff --git a/Wms/WMS.Entity/BllAsnEntity/BllLabelBoxNo.cs b/Wms/WMS.Entity/BllAsnEntity/BllLabelBoxNo.cs
new file mode 100644
index 0000000..32e1075
--- /dev/null
+++ b/Wms/WMS.Entity/BllAsnEntity/BllLabelBoxNo.cs
@@ -0,0 +1,183 @@
+锘縰sing System;
+using System.Collections.Generic;
+using System.Text;
+using SqlSugar;
+
+namespace WMS.Entity.BllAsnEntity
+{
+ ///<summary>
+ ///绠辨敮淇℃伅琛�
+ ///</summary>
+ [SugarTable("BllLabelBoxNo")]
+ public class BllLabelBoxNo : BaseEntity
+ {
+ /// <summary>
+ /// Desc:鍏ュ簱鍗曞彿
+ /// Default:
+ /// Nullable:True
+ /// </summary>
+ public string ASNNo { get; set; }
+
+ /// <summary>
+ /// Desc:鍏ュ簱鏄庣粏鍙�
+ /// Default:
+ /// Nullable:True
+ /// </summary>
+ public int? ASNDetailNo { get; set; }
+
+ /// <summary>
+ /// Desc:绠卞彿
+ /// Default:
+ /// Nullable:True
+ /// </summary>
+ public string BoxNo { get; set; }
+
+ /// <summary>
+ /// Desc:鐖剁骇绠辩爜鍙�
+ /// Default:
+ /// Nullable:True
+ /// </summary>
+ public string ParentBoxNo { get; set; }
+
+ /// <summary>
+ /// Desc:鏁伴噺
+ /// Default:
+ /// Nullable:False
+ /// </summary>
+ public int Qty { get; set; }
+
+ /// <summary>
+ /// Desc:鐗╂枡缂栫爜
+ /// Default:
+ /// Nullable:True
+ /// </summary>
+ public string SkuNo { get; set; }
+
+ /// <summary>
+ /// Desc:鐗╂枡鍚嶇О
+ /// Default:
+ /// Nullable:True
+ /// </summary>
+ public string SkuName { get; set; }
+
+ /// <summary>
+ /// Desc:鎵规鍙�
+ /// Default:
+ /// Nullable:True
+ /// </summary>
+ public string LotNo { get; set; }
+
+ /// <summary>
+ /// Desc:鎵规鎻忚堪
+ /// Default:
+ /// Nullable:True
+ /// </summary>
+ public string LotText { get; set; }
+
+ /// <summary>
+ /// Desc:鐢熶骇鏃ユ湡
+ /// Default:
+ /// Nullable:True
+ /// </summary>
+ public DateTime? ProductionTime { get; set; }
+
+ /// <summary>
+ /// Desc:杩囨湡鏃堕棿
+ /// Default:
+ /// Nullable:True
+ /// </summary>
+ public DateTime? ExpirationTime { get; set; }
+
+ /// <summary>
+ /// Desc:澶嶉獙鏈�
+ /// Default:0
+ /// Nullable:True
+ /// </summary>
+ public DateTime? InspectTime { get; set; }
+
+ /// <summary>
+ /// Desc:瀹屾垚鏃堕棿
+ /// Default:
+ /// Nullable:True
+ /// </summary>
+ public DateTime? CompleteTime { get; set; }
+
+ /// <summary>
+ /// Desc:渚涜揣鍟嗗悕绉�
+ /// Default:
+ /// Nullable:True
+ /// </summary>
+ public string SupplierName { get; set; }
+
+ /// <summary>
+ /// Desc:渚涜揣鎵规
+ /// Default:
+ /// Nullable:True
+ /// </summary>
+ public string SupplierLot { get; set; }
+
+ /// <summary>
+ /// Desc:鏄惁浣跨敤
+ /// Default: 0 鏈娇鐢� 1宸蹭娇鐢�
+ /// Nullable:False
+ /// </summary>
+ public string IsUse { get; set; }
+
+ /// <summary>
+ /// Desc:绠辩爜绾у埆
+ /// Default: 1涓�绾� 2浜岀骇 3涓夌骇
+ /// Nullable:False
+ /// </summary>
+ public string Level { get; set; }
+
+ /// <summary>
+ /// Desc:鎬讳欢鏁�
+ /// Default:
+ /// Nullable:True
+ /// </summary>
+ public int? QtyCount { get; set; }
+
+ /// <summary>
+ /// Desc:绗嚑浠�
+ /// Default:
+ /// Nullable:True
+ /// </summary>
+ public int? QtyOrd { get; set; }
+
+ /// <summary>
+ /// Desc:澶囩敤
+ /// Default:
+ /// Nullable:True
+ /// </summary>
+ public string UDF1 { get; set; }
+
+ /// <summary>
+ /// Desc:澶囩敤
+ /// Default:
+ /// Nullable:True
+ /// </summary>
+ public string UDF2 { get; set; }
+
+ /// <summary>
+ /// Desc:澶囩敤
+ /// Default:
+ /// Nullable:True
+ /// </summary>
+ public string UDF3 { get; set; }
+
+ /// <summary>
+ /// Desc:澶囩敤
+ /// Default:
+ /// Nullable:True
+ /// </summary>
+ public string UDF4 { get; set; }
+
+ /// <summary>
+ /// Desc:澶囩敤
+ /// Default:
+ /// Nullable:True
+ /// </summary>
+ public string UDF5 { get; set; }
+
+ }
+}
diff --git a/Wms/WMS.IBLL/IBllAsnServer/IBllLabelBoxNoServer.cs b/Wms/WMS.IBLL/IBllAsnServer/IBllLabelBoxNoServer.cs
new file mode 100644
index 0000000..1934115
--- /dev/null
+++ b/Wms/WMS.IBLL/IBllAsnServer/IBllLabelBoxNoServer.cs
@@ -0,0 +1,19 @@
+锘縰sing System;
+using System.Collections.Generic;
+using System.Text;
+using Model.ModelVm.BllAsnVm;
+using WMS.Entity.BllAsnEntity;
+
+namespace WMS.IBLL.IBllAsnServer
+{
+ public interface IBllLabelBoxNoServer
+ {
+ /// <summary>
+ /// 鑾峰彇鏍囩绠辩爜淇℃伅
+ /// </summary>
+ /// <param name="model">鏌ヨ鏉′欢</param>
+ /// <param name="count">鏁伴噺</param>
+ /// <returns>鏍囩绠辩爜淇℃伅</returns>
+ List<BllLabelBoxNo> GetLabelBoxList(LabelBoxVm model, out int count);
+ }
+}
--
Gitblit v1.8.0