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

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

namespace Business.Domain
{
    /// <summary>
    /// 供应商
    /// </summary>
    [Comment("供应商")]
    [CollectionName("dopbase", "srm_supplier")]
    [Index(nameof(supplier_no), nameof(tenant_id), nameof(factory_id), IsUnique = true)]
    public class srm_supplier : BaseEntity
    {
        ///// <summary>
        ///// 供应商主键id
        ///// </summary>
        //[Key]
        //[Comment("供应商主键id")]
        //public long supplier_id { get; set; }

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

        /// <summary>
        /// 供应商名称
        /// </summary>
        [StringLength(255)]
        [Comment("供应商名称")]
        public string supplier_name { get; set; }

        /// <summary>
        /// 供应商全称
        /// </summary>
        [StringLength(255)]
        [Comment("供应商全称")]
        public string supplier_full_name { get; set; }

        /// <summary>
        /// 供应商助记码
        /// </summary>
        [StringLength(80)]
        [Comment("供应商助记码")]
        public string supplier_help_code { get; set; }

        /// <summary>
        /// 供应商简称
        /// </summary>
        [StringLength(255)]
        [Comment("供应商简称")]
        public string supplier_short_name { get; set; }

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

        /// <summary>
        /// 状态
        /// </summary>
        [Comment("状态")]
        [StringLength(80)]
        public string state { get; set; }

        /// <summary>
        /// 区域
        /// </summary>
        [StringLength(255)]
        [Comment("区域")]
        public string region { get; set; }

        /// <summary>
        /// 行业
        /// </summary>
        [StringLength(255)]
        [Comment("行业")]
        public string trade { get; set; }


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

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

        /// <summary>
        /// 移动电话
        /// </summary>
        [StringLength(80)]
        [Comment("移动电话")]
        public string mobile { get; set; }

        /// <summary>
        /// 传真号码
        /// </summary>
        [StringLength(80)]
        [Comment("传真号码")]
        public string fax { get; set; }

        /// <summary>
        /// 邮政编码
        /// </summary>
        [StringLength(80)]
        [Comment("邮政编码")]
        public string post_code { get; set; }

        /// <summary>
        /// 邮件地址
        /// </summary>
        [StringLength(80)]
        [Comment("邮件地址")]
        public string email { get; set; }


        /// <summary>
        /// 税务登记号
        /// </summary>
        [StringLength(255)]
        [Comment("税务登记号")]
        public string taxid { get; set; }

        /// <summary>
        /// 开户银行
        /// </summary>
        [StringLength(255)]
        [Comment("开户银行")]
        public string bank { get; set; }

        /// <summary>
        /// 银行账号
        /// </summary>
        [StringLength(80)]
        [Comment("银行账号")]
        public string bank_account { get; set; }

        /// <summary>
        /// 增值税率
        /// </summary>
        [Precision(23, 10)]
        [Comment("增值税率")]
        public decimal? value_add_rate { get; set; }

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

        /// <summary>
        /// 采购模式
        /// </summary>
        [StringLength(80)]
        [Comment("采购模式")]
        public string po_mode { get; set; }

        /// <summary>
        /// VMI仓
        /// </summary>
        [StringLength(255)]
        [Comment("VMI仓")]
        public string vmi_stock { get; set; }

        /// <summary>
        /// 受托代销虚仓
        /// </summary>
        [StringLength(255)]
        [Comment("受托代销虚仓")]
        public string stockid_assignee { get; set; }

        /// <summary>
        /// 分支机构信息
        /// </summary>
        [StringLength(255)]
        [Comment("分支机构信息")]
        public string branch_info { get; set; }

        /// <summary>
        /// 注册商标
        /// </summary>
        [StringLength(255)]
        [Comment("注册商标")]
        public string regmark { get; set; }

        /// <summary>
        /// 营业执照
        /// </summary>
        [StringLength(255)]
        [Comment("营业执照")]
        public string licence { get; set; }

        /// <summary>
        /// 注册日期
        /// </summary>
        [Comment("注册日期")]
        public DateTime? regster_date { get; set; }

        /// <summary>
        /// 批准日期
        /// </summary>
        [Comment("批准日期")]
        public DateTime? approve_date { get; set; }

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

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

        /// <summary>
        /// 供应商等级
        /// </summary>
        [StringLength(80)]
        [Comment("供应商等级")]
        public string supply_grade { get; set; }

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

        /// <summary>
        /// 公司类别
        /// </summary>
        [StringLength(80)]
        [Comment("公司类别")]
        public string company_type { get; set; }

        /// <summary>
        /// 交货自动生成收货单据
        /// </summary>
        [Comment("交货自动生成收货单据")]
        [DefaultValue(false)]
        public bool? auto_create_mr { get; set; }

        /// <summary>
        /// 自动确认订单
        /// </summary>
        [DefaultValue(false)]
        [Comment("自动确认订单")]
        public bool? auto_validate_order { get; set; }

        /// <summary>
        /// 启用供应商门户
        /// </summary>
        [Comment("启用供应商门户")]
        [DefaultValue(true)]
        public bool? isuse_supplier_portal { get; set; }

        /// <summary>
        /// 分管部门
        /// </summary>
        [StringLength(80)]
        [Comment("分管部门")]
        public string department { get; set; }

        /// <summary>
        /// 专营业务员
        /// </summary>
        [StringLength(80)]
        [Comment("专营业务员")]
        public string employee_name { get; set; }

        /// <summary>
        /// 专营业务员_工号
        /// </summary>
        [StringLength(80)]
        [Comment("专营业务员_工号")]
        public string employee_no { get; set; }

        /// <summary>
        /// 结算币种
        /// </summary>
        [StringLength(80)]
        [Comment("结算币种")]
        public string currency { get; set; }

        /// <summary>
        /// 结算方式
        /// </summary>
        [StringLength(80)]
        [Comment("结算方式")]
        public string settlement { get; set; }

        /// <summary>
        /// 英文名称
        /// </summary>
        [StringLength(255)]
        [Comment("英文名称")]
        public string name_en { get; set; }

        /// <summary>
        /// 英文地址
        /// </summary>
        [StringLength(255)]
        [Comment("英文地址")]
        public string addr_en { get; set; }

        /// <summary>
        /// 国别地区
        /// </summary>
        [StringLength(255)]
        [Comment("国别地区")]
        public string country { get; set; }

        /// <summary>
        /// 审核人
        /// </summary>
        [StringLength(80)]
        [Comment("审核人")]
        public string checker { get; set; }

        /// <summary>
        /// 操作时间
        /// </summary>
        [Comment("操作时间")]
        public DateTime? op_time { get; set; }
    }
}