using System;
using SqlSugar;
using System.Linq;
using System.ComponentModel;
using System.Collections.Generic;
using System.Text.RegularExpressions;

namespace Tiger.Model
{
	/// <summary>
	/// 实体：条码规则
	/// </summary>
	[Description("Primary:ID")]
	[Serializable]
	[SugarTable("BAS_CODE_RULE")]
	public class BAS_CODE_RULE : DbEntityWithAuth
	{
		#region 构造函数
		/// <summary>
		/// 实体：条码规则
		/// </summary>
		public BAS_CODE_RULE() { }
		#endregion

		#region 公共属性
		/// <summary>
		/// 规则代码(系统自动生成，规则：LK+YYYYMMDD+三位流水码)
		/// </summary>
		public string RULE_CODE { get; set; }
		/// <summary>
		/// 规则名称
		/// </summary>
		public string RULE_NAME { get; set; }
		/// <summary>
		/// 规则描述
		/// </summary>
		public string RULE_DESC { get; set; }
		/// <summary>
		/// 规则类型（0Material物料条码|1SemiProduct半成品条码|2Product成品条码|3BizOrder单据号码）
		/// </summary>
		public int RULE_TYPE { get; set; }
        /// <summary>
		/// 优先级，大于0的整数，越小越优先度越高
		/// </summary>
		public int PRIORITY { get; set; }
        /// <summary>
		/// 是否启用(Y/N)
		/// </summary>
		[DisplayName("是否启用(Y/N)")]
        public string IS_ACTIVE { get; set; }
        /// <summary>
        /// 条码段分隔符
        /// </summary>
        [DisplayName("条码段分隔符")]
        public string SEPARATOR { get; set; }
        /// <summary>
        /// 条码长度
        /// </summary>
        public int CODE_LENGTH { get; set; }
		/// <summary>
		/// 校验类型（0RUL自身校验|1MUL关联校验）
		/// </summary>
		public int CHECK_TYPE { get; set; }
		/// <summary>
		/// 校验表达式
		/// </summary>
		public string CHECK_REGEX { get; set; }
		/// <summary>
		/// 备注
		/// </summary>
		public string REMARK { get; set; }
        #endregion

        #region 虚拟属性
        /*例子
		[SugarColumn(IsIgnore = true)]
		public string FieldName { get; set; }
		*/
        /// <summary>
        /// Regex 对象, 正则表达式：^(CHECK_REGEX)$
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        public Regex Regex => new Regex(Details.Any() ? $"^{string.Concat(Details.OrderBy(q => q.RULE_SEQ).Select(q => q.DATA_REGEX))}$"
                                                                                   : (CHECK_REGEX ?? "").StartsWith("^") ? CHECK_REGEX : $"^{CHECK_REGEX}$");
        /// <summary>
        /// 分组的校验表达式，使用RULE_SEQ分组
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        public string DATA_REGEX_WithGroup => Details.Any() ? $"^{string.Concat(Details.OrderBy(q => q.RULE_SEQ).Select(q => q.DATA_REGEX_WithGroup))}$" : "";
        /// <summary>
        /// 校验正则表达式
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        public Regex GroupRegex => new Regex(DATA_REGEX_WithGroup);
        #endregion

        #region 外键属性
        /*例子
		//一对一外键导航
		[Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BAS_CODE_RULE类里面的外键ID字段
		public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
		//一对多外键导航
		[Navigate(NavigateType.OneToMany, nameof(ClassA.BAS_CODE_RULEId))]//ClassA表中的BAS_CODE_RULEId
		public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
		//多对多外键导航
		[Navigate(typeof(MappingClass), nameof(MappingClass.BAS_CODE_RULEId), nameof(MappingClass.ClassAId))]//注意顺序
		public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
		*/
        /// <summary>
        /// 包含逻辑删除的数据
        /// </summary>
        [Navigate(NavigateType.OneToMany, nameof(BAS_CODE_DTL.RULE_ID))]//ClassA表中的BAS_CODE_RULEId
        public List<BAS_CODE_DTL> DetailsWithGhost { get; set; }//注意禁止手动赋值，只能是null
        /// <summary>
        /// 不包含逻辑删除的数据
        /// </summary>
		[SugarColumn(IsIgnore = true)]
        public List<BAS_CODE_DTL> Details => DetailsWithGhost?.Where(q => !q.GHOST_ROW).ToList() ?? new List<BAS_CODE_DTL>();
        [Navigate(NavigateType.OneToMany, nameof(BAS_CODE_GEN.RULE_ID))]//ClassA表中的BAS_CODE_RULEId
        public List<BAS_CODE_GEN> SerialsWithGhost { get; set; }//注意禁止手动赋值，只能是null
        [SugarColumn(IsIgnore = true)]
        public List<BAS_CODE_GEN> Serials => SerialsWithGhost?.Where(q => !q.GHOST_ROW).ToList();
        #endregion

        #region 枚举变量
        /// <summary>
        /// 校验类型（0RUL自身校验|1MUL关联校验）
        /// </summary>
        public enum CHECK_TYPEs
		{
            [Description("自身校验")]
            RUL,
            [Description("关联校验")]
            MUL,
		}
        /// <summary>
        /// 规则类型（0Material物料条码|1SemiProduct半成品条码|2Product成品条码|3BizOrder单据号码）
        /// </summary>
        public enum RULE_TYPEs
        {
            [Description("物料条码")]
            Material,
            [Description("半成品条码")]
            SemiProduct,
            [Description("成品条码")]
            Product,
            [Description("单据号码")]
            BizOrder,
        }
        #endregion

        #region 公共方法

        #endregion

    }//endClass
}