DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/SRM/srm_po_main.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_po_main")]
    [Comment("采购订单")]
    [Index(nameof(po_billno), nameof(tenant_id), nameof(company_id), nameof(factory_id), IsUnique = true)]
    public class srm_po_main : BaseEntity
    {
        /// <summary>
        /// PO单号
        /// </summary>
        [StringLength(80)]
        [Comment("PO单号")]
        public string po_billno { get; set; }
        /// <summary>
        /// 采购员
        /// </summary>
        [StringLength(80)]
        [Comment("采购员")]
        public string po_purchaser { get; set; }
        /// <summary>
        /// 采购员工号
        /// </summary>
        [StringLength(80)]
        [Comment("采购员工号")]
        public string po_purchaser_no { get; set; }
        /// <summary>
        /// 下单日期
        /// </summary>
        [Comment("下单日期")]
        public DateTime? po_ssend_date { get; set; }
        /// <summary>
        /// 订单总价
        /// </summary>
        [Precision(23, 10)]
        [Comment("订单总价")]
        public decimal? po_total { get; set; }
        /// <summary>
        /// 交货方式
        /// </summary>
        [Required]
        [Comment("交货方式")]
        public long? po_delivery { get; set; }
        /// <summary>
        /// 税率
        /// </summary>
        [Precision(23, 10)]
        [Comment("税率")]
        public decimal? po_tax_rate { get; set; }
        /// <summary>
        /// 是否加急
        /// </summary>
        [Comment("是否加急")]
        public int? po_express { get; set; }
        /// <summary>
        /// 数据状态(0-新增、1-审核中、2-同意、3-关闭)
        /// </summary>
        [Comment("数据状态")]
        public int? state { get; set; }
        /// <summary>
        /// 备注
        /// </summary>
        [StringLength(1000)]
        [Comment("备注")]
        public string po_note { get; set; }
        /// <summary>
        /// 评审状态
        /// </summary>
        [Comment("评审状态")]
        public int? rstate { get; set; }
        /// <summary>
        /// 评审次数
        /// </summary>
        [Precision(23, 10)]
        [Comment("评审次数")]
        public decimal? rnumber { get; set; }
        /// <summary>
        /// 评审通过时间
        /// </summary>
        [Comment("评审通过时间")]
        public DateTime? review_rtime { get; set; }
        /// <summary>
        /// 单据类型
        /// </summary>
        [Comment("单据类型")]
        public int? po_order_type { get; set; }
        /// <summary>
        /// 币别
        /// </summary>
        [Required]
        [Comment("币别")]
        public long? currency { get; set; }
        /// <summary>
        /// 金蝶单据类型值（标准采购订单、标准委外订单）
        /// </summary>
        [Comment("金蝶单据类型值")]
        public int? bill_type { get; set; }

        /// <summary>
        /// 采购组织id
        /// </summary>
        [Comment("采购组织id")]
        public long? purchasing_orgid { get; set; }
        /// <summary>
        /// 采购组织名称
        /// </summary>
        [StringLength(50)]
        [Comment("采购组织名称")]
        public string purchasing_orgname { get; set; }

        /// <summary>
        /// 采购联系人电话
        /// </summary>
        [StringLength(80)]
        [Comment("采购联系人电话")]
        public string telephone { get; set; }

        /// <summary>
        /// 供应商id
        /// </summary>
        [Required]
        [Comment("供应商id")]
        public long? supplier_id { get; set; }
        /// <summary>
        /// 供应商名称
        /// </summary>
        [StringLength(80)]
        [Comment("供应商名称")]
        public string supplier_name { get; set; }

        /// <summary>
        /// 供应商编号
        /// </summary>
        [StringLength(80)]
        [Comment("供应商编号")]
        public string supplier_no { get; set; }

        /// <summary>
        /// 供应商联系人
        /// </summary>
        [StringLength(80)]
        [Comment("供应商联系人")]
        public string contact { get; set; }

        /// <summary>
        /// 供应商联系人电话
        /// </summary>
        [StringLength(80)]
        [Comment("供应商联系人电话")]
        public string suppliertelephone { get; set; }

        /// <summary>
        /// 收货地址
        /// </summary>
        [StringLength(200)]
        [Comment("收货地址")]
        public string deliveryaddress { get; set; }

        /// <summary>
        /// 供应地址
        /// </summary>
        [StringLength(200)]
        [Comment("供应地址")]
        public string supplierdddress { get; set; }


        /// <summary>
        /// 确认状态
        /// </summary>
        [Comment("确认状态")]
        public int? confirmstate { get; set; }

        /// <summary>
        /// 物流状态
        /// </summary>
        [Comment("物流状态")]
        public int? logisticsstate { get; set; }

        /// <summary>
        /// 财务状态
        /// </summary>
        [Comment("财务状态")]
        public int? financialstate { get; set; }

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

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