Sunji-posv-net/pos/POSV.Entity/Visitor.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Newtonsoft.Json;
using NPoco;

namespace POSV.Entity
{
    [Serializable]
    [JsonObject(MemberSerialization.OptIn)]
    [TableName("pos_visitor")]
    [PrimaryKey(new string[] { "id" } , AutoIncrement = false)]
    public class Visitor : BaseEntity
    {
        /// <summary>
        /// 租户ID
        /// </summary>
        [JsonProperty(PropertyName = "tenantId")]
        [Column("tenantId")]
        public string TenantId { get; set; }

        /// <summary>
        /// 门店ID
        /// </summary>
        [JsonProperty(PropertyName = "storeId")]
        [Column("storeId")]
        public string StoreId { get; set; }

        /// <summary>
        /// 编号
        /// </summary>
        [JsonProperty(PropertyName = "no")]
        [Column("no")]
        public string No { get; set; } = "999";

        /// <summary>
        /// 名称
        /// </summary>
        [JsonProperty(PropertyName = "name")]
        [Column("name")]
        public string Name { get; set; }

        /// <summary>
        /// 来电号码
        /// </summary>
        [JsonProperty(PropertyName = "tel")]
        [Column("tel")]
        public string Tel { get; set; }

        /// <summary>
        /// 拼音码
        /// </summary>
        [JsonProperty(PropertyName = "spell")]
        [Column("spell")]
        public string Spell { get; set; } = "";

        /// <summary>
        /// 性别(0-女;1-男;)
        /// </summary>
        [JsonProperty(PropertyName = "sex")]
        [Column("sex")]
        public int Sex { get; set; } = 1;

        /// <summary>
        /// 称谓(先生;女士;小姐;夫人;教授等)
        /// </summary>
        [JsonProperty(PropertyName = "title")]
        [Column("title")]
        public string Title { get; set; } = string.Empty;

        /// <summary>
        /// 职位
        /// </summary>
        [JsonProperty(PropertyName = "position")]
        [Column("position")]
        public string Position { get; set; } = string.Empty;

        /// <summary>
        /// 联系方式一
        /// </summary>
        [JsonProperty(PropertyName = "fphone")]
        [Column("fphone")]
        public string Phone1 { get; set; } = string.Empty;

        /// <summary>
        /// 联系方式二
        /// </summary>
        [JsonProperty(PropertyName = "sphone")]
        [Column("sphone")]
        public string Phone2 { get; set; } = string.Empty;

        /// <summary>
        /// 备注说明
        /// </summary>
        [JsonProperty(PropertyName = "description")]
        [Column("description")]
        public string Description { get; set; } = "收银前台添加";

        /// <summary>
        /// 是否新增
        /// </summary>
        [JsonProperty(PropertyName = "upload")]
        [Column("upload")]
        public int Upload { get; set; } = 0;

        /// <summary>
        /// 扩展字段1
        /// </summary>
        [JsonProperty(PropertyName = "ext1")]
        [Column("ext1")]
        public string Ext1 { get; set; }

        /// <summary>
        /// 扩展字段2
        /// </summary>
        [JsonProperty(PropertyName = "ext2")]
        [Column("ext2")]
        public string Ext2 { get; set; }

        /// <summary>
        /// 扩展字段3
        /// </summary>
        [JsonProperty(PropertyName = "ext3")]
        [Column("ext3")]
        public string Ext3 { get; set; }


        /// <summary>
        /// 近期购物地址
        /// </summary>
        [JsonProperty(PropertyName = "address")]
        [Reference(ReferenceType.Many, ColumnName = "Id", ReferenceMemberName = "VisitorId")]
        public List<VisitorAddress> Address { get; set; } = new List<VisitorAddress>();
    }
}