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_DTL")]
|
public class BAS_CODE_DTL : DbEntityWithAuth
|
{
|
#region 构造函数
|
/// <summary>
|
/// 实体：条码规则明细定义
|
/// </summary>
|
public BAS_CODE_DTL() {}
|
#endregion
|
|
#region 公共属性
|
/// <summary>
|
/// 规则ID
|
/// </summary>
|
[DisplayName("规则ID")]
|
public string RULE_ID { get; set; }
|
/// <summary>
|
/// 规则顺序(从1开始累计加1)
|
/// </summary>
|
[DisplayName("规则顺序(从1开始累计加1)")]
|
public int RULE_SEQ { get; set; }
|
/// <summary>
|
/// 明细描述
|
/// </summary>
|
[DisplayName("明细描述")]
|
public string DESCRIPTION { get; set; }
|
/// <summary>
|
/// 数据类型(0Character纯字母|1Numeric纯数字|2FixedCode固定值|3SerialCode流水号|4DateCode日期|5TimeCode时间|6DbCheck关联校验|7NoCheck不校验)
|
/// </summary>
|
[DisplayName("数据类型(0Character纯字母|1Numeric纯数字|2FixedCode固定值|3SerialCode流水号|4DateCode日期|5TimeCode时间|6DbCheck关联校验|7NoCheck不校验)")]
|
public int DATA_TYPE { get; set; }
|
/// <summary>
|
/// 数据选择值(纯字母,日期,时间选择值)
|
/// </summary>
|
[DisplayName("数据选择值(纯字母,日期,时间选择值)")]
|
public string DATA_CASE { get; set; }
|
/// <summary>
|
/// 数据值(固定值填写值)
|
/// </summary>
|
[DisplayName("数据值(固定值填写值)")]
|
public string DATA_VALUE { get; set; }
|
/// <summary>
|
/// 流水号最小值
|
/// </summary>
|
[DisplayName("流水号最小值")]
|
public int SERIAL_MIN { get; set; }
|
/// <summary>
|
/// 流水号最大值
|
/// </summary>
|
[DisplayName("流水号最大值")]
|
public int SERIAL_MAX { get; set; }
|
/// <summary>
|
/// 流水号重置类型(0Default默认|1Year年|2Month月|3Week周|4Day日|5NotReset不重置)
|
/// </summary>
|
[DisplayName("流水号重置类型(0Default默认|1Year年|2Month月|3Week周|4Day日|5NotReset不重置)")]
|
public int SERIAL_RESET { get; set; }
|
/// <summary>
|
/// 流水号取号间隔
|
/// </summary>
|
[DisplayName("流水号取号间隔")]
|
public int SERIAL_INTERVAL { get; set; } = 1;
|
/// <summary>
|
/// 流水号跳号(取号时跳过以设置号码结尾的流水号)
|
/// </summary>
|
[DisplayName("流水号跳号(取号时跳过以设置号码结尾的流水号)")]
|
public string SERIAL_IGNORE { get; set; }
|
/// <summary>
|
/// 是否不包含固定值(Y/N)
|
/// </summary>
|
[DisplayName("是否不包含固定值(Y/N)")]
|
public string FIXED_NOTLIKE { get; set; }
|
/// <summary>
|
/// 关联表
|
/// </summary>
|
[DisplayName("关联表")]
|
public string CHECK_TABLE { get; set; }
|
/// <summary>
|
/// 关联字段
|
/// </summary>
|
[DisplayName("关联字段")]
|
public string CHECK_FIELD { get; set; }
|
/// <summary>
|
/// 校验长度(默认是1)
|
/// </summary>
|
[DisplayName("校验长度(默认是1)")]
|
public int CHECK_LENGTH { get; set; }
|
/// <summary>
|
/// 匹配次数(默认是1)
|
/// </summary>
|
[DisplayName("匹配次数(默认是1)")]
|
public int REPEAT_TIMES { get; set; }
|
/// <summary>
|
/// 起始位置(从0开始)
|
/// </summary>
|
[DisplayName("起始位置(从0开始)")]
|
public string START_DIGIT { get; set; }
|
/// <summary>
|
/// 校验表达式
|
/// </summary>
|
[DisplayName("校验表达式")]
|
public string DATA_REGEX { get; set; }
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[DisplayName("备注")]
|
public string REMARK { get; set; }
|
#endregion
|
|
#region 虚拟属性
|
/*例子
|
[SugarColumn(IsIgnore = true)]
|
public string FieldName { get; set; }
|
*/
|
/// <summary>
|
/// Regex 对象, 正则表达式：^(DATA_REGEX)$
|
/// </summary>
|
[SugarColumn(IsIgnore = true)]
|
public Regex Regex => new Regex($"^{DATA_REGEX}$");
|
/// <summary>
|
/// 分组的校验表达式，使用RULE_SEQ分组
|
/// </summary>
|
[SugarColumn(IsIgnore = true)]
|
public string DATA_REGEX_WithGroup => $"(?<{RULE_SEQ}>{DATA_REGEX})";
|
/// <summary>
|
/// 校验正则表达式
|
/// </summary>
|
[SugarColumn(IsIgnore = true)]
|
public Regex GroupRegex => new Regex(DATA_REGEX_WithGroup);
|
/// <summary>
|
/// 数据值(生成条码时的值)
|
/// </summary>
|
[SugarColumn(IsIgnore = true)]
|
public string CodeValue { get; set; }
|
#endregion
|
|
#region 外键属性
|
/*例子
|
//一对一外键导航
|
[Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BAS_CODE_DTL类里面的外键ID字段
|
public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
|
//一对多外键导航
|
[Navigate(NavigateType.OneToMany, nameof(ClassA.BAS_CODE_DTLId))]//ClassA表中的BAS_CODE_DTLId
|
public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
|
//多对多外键导航
|
[Navigate(typeof(MappingClass), nameof(MappingClass.BAS_CODE_DTLId), nameof(MappingClass.ClassAId))]//注意顺序
|
public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
|
*/
|
#endregion
|
|
#region 枚举变量
|
/// <summary>
|
/// 数据类型(0Character纯字母|1Numeric纯数字|2FixedCode固定值|3SerialCode流水号|4DateCode日期|5TimeCode时间|6DbCheck关联校验|7NoCheck不校验)
|
/// </summary>
|
public enum DATA_TYPEs
|
{
|
[Description("纯字母")]
|
Character,
|
[Description("纯数字")]
|
Numeric,
|
[Description("固定值")]
|
FixedCode,
|
[Description("流水号")]
|
SerialCode,
|
[Description("日期")]
|
DateCode,
|
[Description("时间")]
|
TimeCode,
|
[Description("关联校验")]
|
DbCheck,
|
[Description("不校验")]
|
NoCheck,
|
}
|
/// <summary>
|
/// 大小写(0NotSet不限制|1Upper全大写|2Lower全小写)
|
/// </summary>
|
//public enum DATA_CASEs
|
//{
|
// [Description("不限制")]
|
// NotSet,
|
// [Description("全大写")]
|
// Upper,
|
// [Description("全小写")]
|
// Lower,
|
//}
|
/// <summary>
|
/// 流水号重置类型(0Default默认|1Year年|2Month月|3Week周|4Day日|5NotReset不重置)
|
/// </summary>
|
public enum SERIAL_RESETs
|
{
|
[Description("默认")]
|
Default,
|
[Description("年")]
|
Year,
|
[Description("月")]
|
Month,
|
[Description("周")]
|
Week,
|
[Description("日")]
|
Day,
|
[Description("不重置")]
|
NotReset,
|
}
|
#endregion
|
|
#region 公共方法
|
|
#endregion
|
|
}//endClass
|
}
|
