增加完工入库批次表

Rodney Chen

2024-11-12 606bc04a01c35aeff25ab512c65d517bc29e36ca

增加完工入库批次表

 Tiger.Business.MESTests/MesTests.cs

@@ -19,6 +19,9 @@
            dic.Add("2", "222");
            var dicStr = dic.ToJson();

            var ai = new ActiveInfo() { ExpiryDate = DateTime.Now };
            var aiStr = ai.ToJson();

            var date = new DateTime(2021,1,2);
            
            var firstDay = new DateTime(date.Year, 1, 1);
@@ -28,5 +31,11 @@
            var str = $"{year.ToString().Substring(2, 2)}{week:00}";
            ;
        }

        public class ActiveInfo
        {
            public string Mac { get; set; }
            public DateTime? ExpiryDate { get; set; }
        }
    }
}

 Tiger.Model.Net/Entitys/WMS/BIZ_ERP_PROD_IN_BTH.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,141 @@
using System;
using SqlSugar;
using System.Linq;
using System.ComponentModel;
using System.Collections.Generic;

namespace Tiger.Model
{
    /// <summary>
    /// å®žä½“：完工入库批次表
    /// </summary>
    [Description("Primary:ID")]
    [DisplayName("完工入库批次表")]
    [Serializable]
    [SugarTable("BIZ_ERP_PROD_IN_BTH")]
    public class BIZ_ERP_PROD_IN_BTH : DbEntityWithAuth
    {
        #region æž„造函数
        /// <summary>
        /// å®žä½“：完工入库批次表
        /// </summary>
        public BIZ_ERP_PROD_IN_BTH() {}
        #endregion

        #region å…¬å…±å±žæ€§
        /// <summary>
        /// å…¥åº“单号
        /// </summary>
        [DisplayName("入库单号")]
        public string ORDER_NO { get; set; }
        /// <summary>
        /// å·¥å•æ‰¹æ¬¡å·
        /// </summary>
        [DisplayName("工单批次号")]
        public string BATCH_NO { get; set; }
        /// <summary>
        /// å·¥å•å·
        /// </summary>
        [DisplayName("工单号")]
        public string WORK_ORDER { get; set; }
        /// <summary>
        /// ç‰©æ–™ç¼–码
        /// </summary>
        [DisplayName("物料编码")]
        public string ITEM_CODE { get; set; }
        /// <summary>
        /// ç‰©æ–™åç§°
        /// </summary>
        [DisplayName("物料名称")]
        public string ITEM_NAME { get; set; }
        /// <summary>
        /// å·²æ‰«ææ•°é‡
        /// </summary>
        [DisplayName("已扫描数量")]
        public double SCAN_QTY { get; set; }
        /// <summary>
        /// æ˜¯å¦æ‰«æå®Œæˆ(Y/N)
        /// </summary>
        [DisplayName("是否扫描完成(Y/N)")]
        public string IS_SCANED { get; set; }
        /// <summary>
        /// æ‰«æå®Œæˆæ—¶é—´
        /// </summary>
        [DisplayName("扫描完成时间")]
        public DateTime SCANED_DATE { get; set; } = DateTime.MinValue;
        /// <summary>
        /// æ˜¯å¦ä»“库点收(Y/N)
        /// </summary>
        [DisplayName("是否仓库点收(Y/N)")]
        public string IS_RECEIVED { get; set; }
        /// <summary>
        /// ä»“库点收时间
        /// </summary>
        [DisplayName("仓库点收时间")]
        public DateTime RECEIVED_DATE { get; set; } = DateTime.MinValue;
        /// <summary>
        /// æ˜¯å¦ä¸Šæž¶å®Œæˆ(Y/N)
        /// </summary>
        [DisplayName("是否上架完成(Y/N)")]
        public string IS_IN_STORE { get; set; }
        /// <summary>
        /// ä¸Šæž¶å®Œæˆæ—¶é—´
        /// </summary>
        [DisplayName("上架完成时间")]
        public DateTime IN_STORE_DATE { get; set; } = DateTime.MinValue;
        /// <summary>
        /// æ˜¯å¦å·²åŒæ­¥ERP(Y/N)
        /// </summary>
        [DisplayName("是否已同步ERP(Y/N)")]
        public string IS_HANDLED { get; set; }
        /// <summary>
        /// åŒæ­¥ERP时间
        /// </summary>
        [DisplayName("同步ERP时间")]
        public DateTime HANDLED_DATE { get; set; } = DateTime.MinValue;
        /// <summary>
        /// å¤‡æ³¨
        /// </summary>
        [DisplayName("备注")]
        public string REMARK { get; set; }
        #endregion

        #region è™šæ‹Ÿå±žæ€§
        /*例子
        [SugarColumn(IsIgnore = true)]
        public string FieldName { get; set; }
        */
        #endregion

        #region å¤–键属性
        /*例子
        //一对一外键导航
        [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_ERP_PROD_IN_BTH类里面的外键ID字段
        public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
        //一对多外键导航
        [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_ERP_PROD_IN_BTHId))]//ClassA表中的BIZ_ERP_PROD_IN_BTHId
        public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
        //多对多外键导航
        [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_ERP_PROD_IN_BTHId), nameof(MappingClass.ClassAId))]//注意顺序
        public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
        */
        #endregion

        #region æžšä¸¾å˜é‡
        /*例子
        public enum FieldNames
        {
            [Description("枚举描述0")]
            Enum0,
            [Description("枚举描述1")]
            Enum1,
        }
        */
        #endregion

        #region å…¬å…±æ–¹æ³•

        #endregion

    }//endClass
}

 Tiger.Model.Net/Tiger.Model.Net.csproj

@@ -244,6 +244,7 @@
    <Compile Include="Entitys\MengQi\Customer.cs" />
    <Compile Include="Entitys\MengQi\TestData.cs" />
    <Compile Include="Entitys\MengQi\User.cs" />
    <Compile Include="Entitys\WMS\BIZ_ERP_PROD_IN_BTH.cs" />
    <Compile Include="Entitys\WMS\V_MONTH_IN_SUM.cs" />
    <Compile Include="Entitys\WMS\V_WH_ITEM_SUM.cs" />
    <Compile Include="Entitys\WMS\V_WMS_ITEM_Y.cs" />