using SqlSugar;
using System;

namespace MES.Service.Models
{
    /// <summary>
    /// 携客云条码信息表
    /// </summary>
    [SugarTable("TBL_BARCODE_INFORMATION")]
    public class TblBarcodeInformation
    {
        /// <summary>
        /// 主键Guid（SEQ_XKY）
        /// </summary>
        [SugarColumn(ColumnName = "id", IsPrimaryKey = true)]
        public Guid Id { get; set; }

        /// <summary>
        /// 产品编码
        /// </summary>
        [SugarColumn(ColumnName = "product_code")]
        public string ProductCode { get; set; }

        /// <summary>
        /// 小包条码
        /// </summary>
        [SugarColumn(ColumnName = "small_barcode")]
        public string SmallBarcode { get; set; }

        /// <summary>
        /// 大包条码
        /// </summary>
        [SugarColumn(ColumnName = "big_barcode")]
        public string BigBarcode { get; set; }

        /// <summary>
        /// 外箱条码
        /// </summary>
        [SugarColumn(ColumnName = "outer_barcode")]
        public string OuterBarcode { get; set; }

        /// <summary>
        /// 当前小包条码包含的数量
        /// </summary>
        [SugarColumn(ColumnName = "include_qty")]
        public string IncludeQty { get; set; }

        /// <summary>
        /// 小包条码-长
        /// </summary>
        [SugarColumn(ColumnName = "small_package_length")]
        public string SmallPackageLength { get; set; }

        /// <summary>
        /// 小包条码-宽
        /// </summary>
        [SugarColumn(ColumnName = "small_package_width")]
        public string SmallPackageWidth { get; set; }

        /// <summary>
        /// 小包条码-高
        /// </summary>
        [SugarColumn(ColumnName = "small_package_height")]
        public string SmallPackageHeight { get; set; }

        /// <summary>
        /// 大包条码-长
        /// </summary>
        [SugarColumn(ColumnName = "big_package_length")]
        public string BigPackageLength { get; set; }

        /// <summary>
        /// 大包条码-宽
        /// </summary>
        [SugarColumn(ColumnName = "big_package_width")]
        public string BigPackageWidth { get; set; }

        /// <summary>
        /// 大包条码-高
        /// </summary>
        [SugarColumn(ColumnName = "big_package_height")]
        public string BigPackageHeight { get; set; }

        /// <summary>
        /// 外箱条码-长
        /// </summary>
        [SugarColumn(ColumnName = "outer_package_length")]
        public string OuterPackageLength { get; set; }

        /// <summary>
        /// 外箱条码-宽
        /// </summary>
        [SugarColumn(ColumnName = "outer_package_width")]
        public string OuterPackageWidth { get; set; }

        /// <summary>
        /// 外箱条码-高
        /// </summary>
        [SugarColumn(ColumnName = "outer_package_height")]
        public string OuterPackageHeight { get; set; }

        /// <summary>
        /// 当前小包条码的流水码
        /// </summary>
        [SugarColumn(ColumnName = "small_package_sn")]
        public string SmallPackageSn { get; set; }

        /// <summary>
        /// 当前大包条码的流水码
        /// </summary>
        [SugarColumn(ColumnName = "big_package_sn")]
        public string BigPackageSn { get; set; }

        /// <summary>
        /// 当前外箱条码的流水码
        /// </summary>
        [SugarColumn(ColumnName = "out_package_sn")]
        public string OutPackageSn { get; set; }

        ///// <summary>
        ///// 条码规则中对应的动态字段的值
        ///// </summary>
        //[SugarColumn(ColumnName = "dynamic_data")]
        //public string DynamicData { get; set; }

        /// <summary>
        /// 包装层级
        /// </summary>
        [SugarColumn(ColumnName = "pack_level")]
        public string PackLevel { get; set; }

        /// <summary>
        /// 创建时间
        /// </summary>
        [SugarColumn(ColumnName = "create_time")]
        public DateTime CreateTime { get; set; } = DateTime.Now;

        /// <summary>
        /// 更新时间
        /// </summary>
        [SugarColumn(ColumnName = "update_time")]
        public DateTime UpdateTime { get; set; } = DateTime.Now;

        /// <summary>
        /// 送货单号
        /// </summary>
        [SugarColumn(ColumnName = "delivery_no")]
        public string DeliveryNo { get; set; }

        /// <summary>
        /// 采购单号
        /// </summary>
        [SugarColumn(ColumnName = "po_erp_no")]
        public string PoErpNo { get; set; }

        /// <summary>
        /// 送货单项次
        /// </summary>
        [SugarColumn(ColumnName = "dnLines")]
        public string DnLines { get; set; }

        /// <summary>
        /// 订单项次(ERP)
        /// </summary>
        [SugarColumn(ColumnName = "po_line_no")]
        public string PoLineNo { get; set; }

        /// <summary>
        /// 供应商编码
        /// </summary>
        [SugarColumn(ColumnName = "inner_vendor_code")]
        public string InnerVendorCode { get; set; }

        /// <summary>
        /// 自定义字段1（X）
        /// </summary>
        [SugarColumn(ColumnName = "customize1")]
        public string Customize1 { get; set; }

        /// <summary>
        /// 同步时间
        /// </summary>
        [SugarColumn(ColumnName = "SYNCHRONOUS_DATE")]
        public DateTime? SynchronousDate { get; set; }

        /// <summary>
        /// 生产日期
        /// </summary>
        [SugarColumn(ColumnName = "customize2")]
        public string Customize2 { get; set; }

        /// <summary>
        /// 有效期
        /// </summary>
        [SugarColumn(ColumnName = "customize3")]
        public string Customize3 { get; set; }
    }
}