DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/SRM/srm_purchase.cs

using Business.Core.Attributes;
using Microsoft.EntityFrameworkCore;
using System;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace Business.Domain
{
    /// <summary>
    /// 物料采购报价单
    /// </summary>
    [CollectionName("dopbase", "srm_purchase")]
    [Comment("物料采购报价单")]
    [Index(nameof(number), nameof(supplier_number), nameof(tenant_id), nameof(company_id), nameof(factory_id), IsUnique = true)]
    public class srm_purchase : BaseEntity
    {

        public srm_purchase(long Id) : base(Id)
        {
        }
        /// <summary>
        /// 物料id
        /// </summary>
        [Required]
        [Comment("物料id")]
        public long icitem_id { get; set; }

        /// <summary>
        /// 物料编码
        /// </summary>]
        [StringLength(20)]
        [Comment("物料编码")]
        public string number { get; set; }

        /// <summary>
        /// 物料名称
        /// </summary>
        [StringLength(80)]
        [Comment("物料名称")]
        public string icitem_name { get; set; }
        /// <summary>
        /// 货源清单编号
        /// </summary>
        [Comment("货源清单编号")]
        [StringLength(80)]
        public string sourcelist_number { get; set; }

        /// <summary>
        /// 供应商id
        /// </summary>
        [Comment("供应商id")]
        public long? supplier_id { get; set; }
        /// <summary>
        /// 供应商编码
        /// </summary>
        [StringLength(80)]
        [Comment("供应商编码")]
        public string supplier_number { get; set; }
        /// <summary>
        /// 供应商名称
        /// </summary>
        [StringLength(80)]
        [Comment("供应商名称")]
        public string supplier_name { get; set; }
        /// <summary>
        /// 采购组
        /// </summary>
        [StringLength(80)]
        [Comment("采购组")]
        public string purchgroup { get; set; }
        /// <summary>
        /// 采购员
        /// </summary>
        [StringLength(80)]
        [Comment("采购员")]
        public string purcher { get; set; }
        /// <summary>
        /// 采购计量单位
        /// </summary>
        [StringLength(80)]
        [Comment("采购计量单位")]
        public string purchase_unit { get; set; }
        /// <summary>
        /// 采购净价（不含税）
        /// </summary>
        [Precision(23, 10)]
        [Comment("采购净价（不含税）")]
        public decimal? netpurchase_price { get; set; }
        /// <summary>
        /// 税率
        /// </summary>
        [Precision(23, 10)]
        [Comment("税率")]
        public decimal? taxrate { get; set; }
        /// <summary>
        /// 币种
        /// </summary>
        [Comment("币种")]
        public long? currency_type { get; set; }

        /// <summary>
        /// 采购负责人
        /// </summary>
        [StringLength(80)]
        [Comment("采购负责人")]
        public string order_rector_name { get; set; }
        /// <summary>
        /// 采购负责人_工号
        /// </summary>
        [StringLength(80)]
        [Comment("采购负责人_工号")]
        public string order_rector_num { get; set; }
        /// <summary>
        /// 工厂编码
        /// </summary>
        [StringLength(80)]
        [Comment("工厂编码")]
        public string factory_code { get; set; }
        /// <summary>
        /// 采购部门
        /// </summary>
        [StringLength(80)]
        [Comment("采购部门")]
        public string order_dept { get; set; }
        /// <summary>
        /// 采购单价
        /// </summary>
        [Precision(23, 10)]
        [Comment("采购单价")]
        public decimal? order_price { get; set; }
        /// <summary>
        /// 销售单价
        /// </summary>
        [Precision(23, 10)]
        [Comment("销售单价")]
        public decimal? sale_price { get; set; }
        /// <summary>
        /// 最小订货量
        /// </summary>
        [Precision(23, 10)]
        [Comment("最小订货量")]
        public decimal? qty_min { get; set; }
        /// <summary>
        /// 批量增量
        /// </summary>
        [Precision(23, 10)]
        [Comment("批量增量")]
        public decimal? batch_append_qty { get; set; }

        /*/// <summary>
        /// 是否周期送货
        /// </summary>
        [Comment("是否周期送货")]
        public bool is_week { get; set; }

        /// <summary>
        /// 每周几送货
        /// </summary>
        [StringLength(80)]
        [Comment("每周几送货")]
        public string is_days { get; set; }*/

        /// <summary>
        /// 计算ID
        /// </summary>
        [Comment("计算id")]
        [NotMapped]
        public long? bang_id { get; set; }

        /// <summary>
        /// 供应类别
        /// </summary>
        [StringLength(80)]
        [Comment("供应类别")]
        public string supplier_type { get; set; }


        /// <summary>
        /// 关税
        /// </summary>
        [Precision(18, 5)]
        [Comment("关税")]
        public decimal? tariff { get; set; }

        /// <summary>
        /// 运费
        /// </summary>
        [Precision(18, 5)]
        [Comment("运费")]
        public decimal? freight { get; set; }

        /// <summary>
        /// 生效日期
        /// </summary>
        [Comment("生效日期")]
        public DateTime? effective_date { get; set; }

        /// <summary>
        /// 失效日期
        /// </summary>
        [Comment("失效日期")]
        public DateTime? expiring_date { get; set; }

        /// <summary>
        /// 配额比例
        /// </summary>
        [Precision(18, 5)]
        [Comment("配额比例")]
        public decimal? quota_rate { get; set; }

        /// <summary>
        /// 采购提前期
        /// </summary>
        [Precision(18, 5)]
        [Comment("采购提前期")]
        public decimal? lead_time { get; set; }

        /// <summary>
        /// 价格条款
        /// </summary>
        [StringLength(64)]
        [Comment("价格条款")]
        public string? price_terms { get; set; }

        /// <summary>
        /// 每箱包装数量
        /// </summary>
        [Precision(18, 5)]
        [Comment("每箱包装数量")]
        public decimal? packaging_qty { get; set; }

        /// <summary>
        /// 采购类型 0,采购申请 1,要货令
        /// </summary>
        [Comment("采购类型")]
        public int IsRequireGoods { get; set; }

        /// <summary>
        /// 配额优先级
        /// </summary>
        [Comment("配额优先级")]
        public int quota_priority { get; set; }

        /// <summary>
        /// 失效
        /// </summary>
        [StringLength(64)]
        [Comment("失效")]
        public string? is_active { get; set; }
    }
}