22

schangxiang@126.com

2024-11-25 158cee87388cd002fc5c920138d2b7446f670fc2

22

 DBScript/01_DDL/03_DDL_VIEW.sql

@@ -24,4 +24,55 @@
AND station.PlaceStatus=1  -- 1表示 æ­£å¸¸
AND svs.Id IS NULL 

GO

 /**
 **  æœºå™¨äººç¼“存库的库位查询视图
 **/
IF EXISTS(SELECT 1 FROM sys.views WHERE name='V_Station_Quan') 
   DROP VIEW V_Station_Quan 
GO 
CREATE VIEW V_Station_Quan
AS

 SELECT

station.Id, station.PlaceCode, station.PlaceName, station.PlaceType, station.PlaceTypeName, station.[Length], 
station.Width, station.Height, station.Thick, station.PlaceStatus, station.AreaId, station.AreaCode, station.AreaName, station.RowNo,
 station.ColumnNo, station.LayerNo, station.LaneNo, station.IsVirtually, station.IsDisabled,
 station.CreateTime, station.UpdateTime, station.CreateUserId, station.CreateUserName, station.UpdateUserId, station.UpdateUserName, station.IsDelete,
 svs.InTime,svs.Upi,svs.DetailName,svs.PlanNo,svs.OrderId,svs.PackageCode,
 svs.Length,svs.Width,svs.Thk,svs.StockStatus,svs.StockStatusName,
  svs.OperReason,svs.OperUser,svs.OperTime,svs.LockStatus,svs.LockReason,svs.LockUser,svs.LockTime

FROM dbo.wms_base_place as station
LEFT JOIN dbo.wms_stock_quan as svs ON station.placeCode=svs.placeCode


GO


/**
 **  æœºå™¨äººç¼“存库的库存查询视图
 **/
IF EXISTS(SELECT 1 FROM sys.views WHERE name='V_Station_Quan') 
   DROP VIEW V_Station_Quan 
GO 
CREATE VIEW V_Station_Quan
AS

 SELECT

station.Id, station.PlaceCode, station.PlaceName, station.PlaceType, station.PlaceTypeName, station.[Length], 
station.Width, station.Height, station.Thick, station.PlaceStatus, station.AreaId, station.AreaCode, station.AreaName, station.RowNo,
 station.ColumnNo, station.LayerNo, station.LaneNo, station.IsVirtually, station.IsDisabled,
 station.CreateTime, station.UpdateTime, station.CreateUserId, station.CreateUserName, station.UpdateUserId, station.UpdateUserName, station.IsDelete,
 svs.InTime,svs.Upi,svs.DetailName,svs.PlanNo,svs.OrderId,svs.PackageCode,
 svs.Length,svs.Width,svs.Thk,svs.StockStatus,svs.StockStatusName,
  svs.OperReason,svs.OperUser,svs.OperTime,svs.LockStatus,svs.LockReason,svs.LockUser,svs.LockTime

FROM dbo.wms_base_place as station
LEFT JOIN dbo.wms_stock_quan as svs ON station.placeCode=svs.placeCode


GO

 LA24030_LuLiPackageLine_Wms/Admin.NET.Application/View/WmsStockQuan/V_Station_Quan.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,155 @@
using Admin.NET.Application;
using Admin.NET.Core;


namespace Admin.NET.Application.Entity
{
    /// <summary>
    /// æœºå™¨äººç¼“存库的库位查询视图
    /// </summary>
    [MySugarTableViewAttribute("V_Station_Quan", "机器人缓存库的库存查询视图")]
    public class V_Station_Quan : WmsBasePlace
    {
        /// <summary>
        /// è¿›å…¥æ—¶é—´
        /// </summary>

        [SugarColumn(ColumnName = "InTime", ColumnDescription = "进入时间")]
        public DateTime? InTime { get; set; }



        /// <summary>
        /// éƒ¨ä»¶æ¡ç 
        /// </summary>
        [Required]
        [SugarColumn(ColumnName = "Upi", ColumnDescription = "部件条码", Length = 100)]
        public string Upi { get; set; }

        /// <summary>
        /// éƒ¨ä»¶åç§°
        /// </summary>
        [Required]
        [SugarColumn(ColumnName = "DetailName", ColumnDescription = "部件名称", Length = 100)]
        public string DetailName { get; set; }

        /// <summary>
        /// æ‰¹æ¬¡
        /// </summary>
        [Required]
        [SugarColumn(ColumnName = "PlanNo", ColumnDescription = "批次", Length = 100)]
        public string PlanNo { get; set; }

        /// <summary>
        /// è®¢å•å·
        /// </summary>
        [Required]
        [SugarColumn(ColumnName = "OrderId", ColumnDescription = "订单号", Length = 100)]
        public string OrderId { get; set; }



        /// <summary>
        /// åŒ…装号
        /// </summary>
        [Required]
        [SugarColumn(ColumnName = "PackageCode", ColumnDescription = "包装号", Length = 100)]
        public string PackageCode { get; set; }

        [SugarColumn(ColumnName = "Length", ColumnDescription = "长")]
        public float Length { get; set; }

        [SugarColumn(ColumnName = "Width", ColumnDescription = "宽")]
        public float Width { get; set; }

        [SugarColumn(ColumnName = "Thk", ColumnDescription = "厚")]
        public float Thk { get; set; }



        #region åº“存状态

        /// <summary>
        /// åº“存状态
        /// </summary>
        [Required]

        [SugarColumn(ColumnName = "StockStatus", ColumnDescription = "库存状态")]
        public StockStatusEnum StockStatus { get; set; }


        /// <summary>
        /// åº“存状态名称
        /// </summary>
        [Required]
        [SugarColumn(ColumnName = "StockStatusName", ColumnDescription = "库存状态名称", Length = 50)]

        public string StockStatusName { get; set; }





        /// <summary>
        /// æ“ä½œåŽŸå› 
        /// </summary>
        [SugarColumn(ColumnName = "OperReason", ColumnDescription = "操作原因", Length = 255)]

        public string? OperReason { get; set; }


        /// <summary>
        /// æ“ä½œäºº
        /// </summary>
        [SugarColumn(ColumnName = "OperUser", ColumnDescription = "操作人", Length = 50)]

        public string? OperUser { get; set; }


        /// <summary>
        /// æ“ä½œæ—¶é—´
        /// </summary>

        [SugarColumn(ColumnName = "OperTime", ColumnDescription = "操作时间")]
        public DateTime? OperTime { get; set; }

        #region é”å®š

        /// <summary>
        /// é”å®šçŠ¶æ€
        /// </summary>
        [Required]

        [SugarColumn(ColumnName = "LockStatus", ColumnDescription = "锁定状态")]
        public LockStatusEnum LockStatus { get; set; }


        /// <summary>
        /// é”å®šåŽŸå› 
        /// </summary>
        [SugarColumn(ColumnName = "LockReason", ColumnDescription = "锁定原因", Length = 255)]

        public string? LockReason { get; set; }


        /// <summary>
        /// é”å®šäºº
        /// </summary>
        [SugarColumn(ColumnName = "LockUser", ColumnDescription = "锁定人", Length = 50)]

        public string? LockUser { get; set; }


        /// <summary>
        /// é”å®šæ—¶é—´
        /// </summary>

        [SugarColumn(ColumnName = "LockTime", ColumnDescription = "锁定时间")]
        public DateTime? LockTime { get; set; }

        #endregion


        #endregion
    }
}