DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/SRM/srm_pr_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_pr_main")]
    [Comment("采购申请单")]
    [Index(nameof(pr_billno), nameof(tenant_id), nameof(company_id), nameof(factory_id), IsUnique = true)]
    public class srm_pr_main : BaseEntity
    {
        /// <summary>
        /// pr单号
        /// </summary>
        [StringLength(80)]
        [Comment("pr单号")]
        public string pr_billno { get; set; }
        /// <summary>
        /// 关联工单号
        /// </summary>
        [StringLength(80)]
        [Comment("关联工单号")]
        public string pr_mono { get; set; }

        /// <summary>
        /// 关联的pr单号
        /// </summary>
        [StringLength(80)]
        [Comment("关联pr单号")]
        public string refer_pr_billno { get; set; }
        /// <summary>
        /// 工单行号
        /// </summary>
        [Comment("工单行号")]
        public int? entity_id { get; set; }
        /// <summary>
        /// 供应商id
        /// </summary>
        [Required]
        [Comment("供应商id")]
        public long? pr_purchaseid { get; set; }
        /// <summary>
        /// 供应商编码
        /// </summary>
        [StringLength(80)]
        [Comment("供应商编码")]
        public string pr_purchasenumber { get; set; }
        /// <summary>
        /// 供应商名称
        /// </summary>
        [StringLength(80)]
        [Comment("供应商名称")]
        public string pr_purchasename { get; set; }
        /// <summary>
        /// 采购员
        /// </summary>
        [StringLength(80)]
        [Comment("采购员")]
        public string pr_purchaser { get; set; }
        /// <summary>
        /// 采购员工号（采购信息表）
        /// </summary>
        [StringLength(80)]
        [Comment("采购员工号")]
        public string pr_purchaser_num { get; set; }
        /// <summary>
        /// 需求数量
        /// </summary>
        [Precision(23, 10)]
        [Comment("需求数量")]
        public decimal? pr_rqty { get; set; }
        /// <summary>
        /// 申请数量
        /// </summary>
        [Precision(23, 10)]
        [Comment("申请数量")]
        public decimal? pr_aqty { get; set; }
        /// <summary>
        /// 建议数量
        /// </summary>
        [Precision(23, 10)]
        [Comment("建议数量")]
        public decimal? pr_sqty { get; set; }
        /// <summary>
        /// 物料id
        /// </summary>
        [Required]
        [Comment("物料id")]
        public long? icitem_id { get; set; }
        /// <summary>
        /// 物料名称
        /// </summary>
        [StringLength(80)]
        [Comment("物料名称")]
        public string icitem_name { get; set; }
        /// <summary>
        /// 单据类型
        /// </summary>
        [Comment("单据类型")]
        public int? pr_order_type { get; set; }
        /// <summary>
        /// 系统建议下单日期
        /// </summary>
        [Comment("系统建议下单日期")]
        public DateTime? pr_ssend_date { get; set; }
        /// <summary>
        /// 系统建议到达日期（建议到货日期）
        /// </summary>
        [Comment("系统建议到达日期")]
        public DateTime? pr_sarrive_date { get; set; }
        /// <summary>
        /// 采购员建议到货日期
        /// </summary>
        [Comment("采购员建议到货日期")]
        public DateTime? pr_bsarrive_date { get; set; }
        /// <summary>
        /// 订单到货日期
        /// </summary>
        [Comment("订单到货日期")]
        public DateTime? pr_oarrive_date { get; set; }
        /// <summary>
        /// 计划下单日期
        /// </summary>
        [Comment("计划下单日期")]
        public DateTime? pr_psend_date { get; set; }
        /// <summary>
        /// 计划到达日期
        /// </summary>
        [Comment("计划到达日期")]
        public DateTime? pr_parrive_date { get; set; }
        /// <summary>
        /// 需求到货日期
        /// </summary>
        [Comment("需求到货日期")]
        public DateTime? pr_rarrive_date { get; set; }
        /// <summary>
        /// 再计划到货日期
        /// </summary>
        [Comment("再计划到货日期")]
        public DateTime? pr_rparrive_date { get; set; }
        /// <summary>
        /// 采购确认到货日期
        /// </summary>
        [Comment("采购确认到货日期")]
        public DateTime? pr_pur_affirm_date { get; set; }
        /// <summary>
        /// 系统价格（含税）
        /// </summary>
        [Precision(23, 10)]
        [Comment("系统价格（含税）")]
        public decimal? pr_sysprice { get; set; }
        /// <summary>
        /// 订单价格（含税）
        /// </summary>
        [Precision(23, 10)]
        [Comment("订单价格（含税）")]
        public decimal? pr_orderprice { get; set; }
        /// <summary>
        /// 采购净价（不含税）
        /// </summary>
        [Precision(23, 10)]
        [Comment("采购净价（不含税）")]
        public decimal? pr_price { get; set; }
        /// <summary>
        /// 税率
        /// </summary>
        [Precision(23, 10)]
        [Comment("税率")]
        public decimal? pr_rate { get; set; }
        /// <summary>
        /// 单位
        /// </summary>
        [StringLength(20)]
        [Comment("单位")]
        public string pr_unit { get; set; }
        /// <summary>
        /// 状态 0,关闭;1,新增;    暂时不考虑这种状态，影响PR重新生成，如增加需调整PR代码。2,提交;3,未通过;4,评审通过
        /// </summary>
        [Comment("状态")]
        public int? state { get; set; }
        /// <summary>
        /// 已申请数量
        /// </summary>
        [Precision(23, 10)]
        [Comment("已申请数量")]
        public decimal? old_apply_aqty { get; set; }
        /// <summary>
        /// 申请类型
        /// </summary>
        [Comment("申请类型")]
        public int? pr_type { get; set; }
        /// <summary>
        /// 币种
        /// </summary>
        [Required]
        [Comment("币种")]
        public long? currencytype { get; set; }
        /// <summary>
        /// 安全库存触发采购比例
        /// </summary>
        [Precision(23, 10)]
        [Comment("安全库存触发采购比例")]
        public decimal? secInv_ratio { get; set; }
        /// <summary>
        /// 备注
        /// </summary>
        [StringLength(1000)]
        [Comment("备注")]
        public string remark { get; set; }
        /// <summary>
        /// 拒绝原因
        /// </summary>
        [StringLength(1000)]
        [Comment("拒绝原因")]
        public string pr_rreason { get; set; }

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

        /// <summary>
        /// 订单行id
        /// </summary>
        [Comment("订单行id")]
        public long? sentry_id { get; set; }

        /// <summary>
        /// 项次号
        /// </summary>
        [StringLength(50)]
        [Comment("项次号")]
        public string? num { get; set; }

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

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