using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Runtime.Serialization;
using System.Web.Script.Serialization;
using System.Xml.Serialization;
using NewLife;
using NewLife.Data;
using XCode;
using XCode.Cache;
using XCode.Configuration;
using XCode.DataAccessLayer;
namespace AntJob.Data.DataSync;
/// <summary>数据同步。每个同步配置,对应一个调度作业</summary>
[Serializable]
[DataObject]
[Description("数据同步。每个同步配置,对应一个调度作业")]
[BindIndex("IU_MetaSync_Name", true, "Name")]
[BindIndex("IX_MetaSync_Enable", false, "Enable")]
[BindTable("MetaSync", Description = "数据同步。每个同步配置,对应一个调度作业", ConnName = "DataSync", DbType = DatabaseType.None)]
public partial class MetaSync
{
#region 属性
private Int32 _Id;
/// <summary>编号</summary>
[DisplayName("编号")]
[Description("编号")]
[DataObjectField(true, true, false, 0)]
[BindColumn("Id", "编号", "")]
public Int32 Id { get => _Id; set { if (OnPropertyChanging("Id", value)) { _Id = value; OnPropertyChanged("Id"); } } }
private String _Name;
/// <summary>名称</summary>
[DisplayName("名称")]
[Description("名称")]
[DataObjectField(false, false, false, 50)]
[BindColumn("Name", "名称", "", Master = true)]
public String Name { get => _Name; set { if (OnPropertyChanging("Name", value)) { _Name = value; OnPropertyChanged("Name"); } } }
private String _IgnoreTable;
/// <summary>忽略同步表。与同步表映射共同生效</summary>
[DisplayName("忽略同步表")]
[Description("忽略同步表。与同步表映射共同生效")]
[DataObjectField(false, false, true, 50)]
[BindColumn("IgnoreTable", "忽略同步表。与同步表映射共同生效", "")]
public String IgnoreTable { get => _IgnoreTable; set { if (OnPropertyChanging("IgnoreTable", value)) { _IgnoreTable = value; OnPropertyChanged("IgnoreTable"); } } }
private String _MapTable;
/// <summary>同步表映射。仅同步指定表,并映射到目标库,映射关系:分号分割映射表,逗号分割多组映射</summary>
[DisplayName("同步表映射")]
[Description("同步表映射。仅同步指定表,并映射到目标库,映射关系:分号分割映射表,逗号分割多组映射")]
[DataObjectField(false, false, true, 50)]
[BindColumn("MapTable", "同步表映射。仅同步指定表,并映射到目标库,映射关系:分号分割映射表,逗号分割多组映射", "")]
public String MapTable { get => _MapTable; set { if (OnPropertyChanging("MapTable", value)) { _MapTable = value; OnPropertyChanged("MapTable"); } } }
private Int32 _SourceId;
/// <summary>源库</summary>
[DisplayName("源库")]
[Description("源库")]
[DataObjectField(false, false, false, 0)]
[BindColumn("SourceId", "源库", "")]
public Int32 SourceId { get => _SourceId; set { if (OnPropertyChanging("SourceId", value)) { _SourceId = value; OnPropertyChanged("SourceId"); } } }
private Int32 _TargetId;
/// <summary>目标库</summary>
[DisplayName("目标库")]
[Description("目标库")]
[DataObjectField(false, false, false, 0)]
[BindColumn("TargetId", "目标库", "")]
public Int32 TargetId { get => _TargetId; set { if (OnPropertyChanging("TargetId", value)) { _TargetId = value; OnPropertyChanged("TargetId"); } } }
private Int32 _ErrorNum;
/// <summary>错误重试</summary>
[DisplayName("错误重试")]
[Description("错误重试")]
[DataObjectField(false, false, false, 0)]
[BindColumn("ErrorNum", "错误重试", "")]
public Int32 ErrorNum { get => _ErrorNum; set { if (OnPropertyChanging("ErrorNum", value)) { _ErrorNum = value; OnPropertyChanged("ErrorNum"); } } }
private Boolean _Enable;
/// <summary>启用</summary>
[DisplayName("启用")]
[Description("启用")]
[DataObjectField(false, false, false, 0)]
[BindColumn("Enable", "启用", "")]
public Boolean Enable { get => _Enable; set { if (OnPropertyChanging("Enable", value)) { _Enable = value; OnPropertyChanged("Enable"); } } }
private Int32 _TaskId;
/// <summary>管理任务。用于扫描源库的表信息变更,例如新增表和新增字段</summary>
[DisplayName("管理任务")]
[Description("管理任务。用于扫描源库的表信息变更,例如新增表和新增字段")]
[DataObjectField(false, false, false, 0)]
[BindColumn("TaskId", "管理任务。用于扫描源库的表信息变更,例如新增表和新增字段", "")]
public Int32 TaskId { get => _TaskId; set { if (OnPropertyChanging("TaskId", value)) { _TaskId = value; OnPropertyChanged("TaskId"); } } }
private DateTime _LastTime;
/// <summary>最后同步时间</summary>
[DisplayName("最后同步时间")]
[Description("最后同步时间")]
[DataObjectField(false, false, true, 0)]
[BindColumn("LastTime", "最后同步时间", "")]
public DateTime LastTime { get => _LastTime; set { if (OnPropertyChanging("LastTime", value)) { _LastTime = value; OnPropertyChanged("LastTime"); } } }
private Boolean _IsAllCopy;
/// <summary>原样拷贝,不会生成单独的表配置</summary>
[Category("模型")]
[DisplayName("原样拷贝")]
[Description("原样拷贝,不会生成单独的表配置")]
[DataObjectField(false, false, false, 0)]
[BindColumn("IsAllCopy", "原样拷贝,不会生成单独的表配置", "")]
public Boolean IsAllCopy { get => _IsAllCopy; set { if (OnPropertyChanging("IsAllCopy", value)) { _IsAllCopy = value; OnPropertyChanged("IsAllCopy"); } } }
private Boolean _IsAllSync;
/// <summary>整库同步,会自动创建定时任务同步表模型</summary>
[Category("模型")]
[DisplayName("整库同步")]
[Description("整库同步,会自动创建定时任务同步表模型")]
[DataObjectField(false, false, false, 0)]
[BindColumn("IsAllSync", "整库同步,会自动创建定时任务同步表模型", "")]
public Boolean IsAllSync { get => _IsAllSync; set { if (OnPropertyChanging("IsAllSync", value)) { _IsAllSync = value; OnPropertyChanged("IsAllSync"); } } }
private String _DBModel;
/// <summary>库模型</summary>
[Category("模型")]
[DisplayName("库模型")]
[Description("库模型")]
[DataObjectField(false, false, true, -1)]
[BindColumn("DBModel", "库模型", "Text")]
public String DBModel { get => _DBModel; set { if (OnPropertyChanging("DBModel", value)) { _DBModel = value; OnPropertyChanged("DBModel"); } } }
private Int32 _CreateUserID;
/// <summary>创建人</summary>
[Category("扩展")]
[DisplayName("创建人")]
[Description("创建人")]
[DataObjectField(false, false, false, 0)]
[BindColumn("CreateUserID", "创建人", "")]
public Int32 CreateUserID { get => _CreateUserID; set { if (OnPropertyChanging("CreateUserID", value)) { _CreateUserID = value; OnPropertyChanged("CreateUserID"); } } }
private String _CreateUser;
/// <summary>创建者</summary>
[Category("扩展")]
[DisplayName("创建者")]
[Description("创建者")]
[DataObjectField(false, false, true, 50)]
[BindColumn("CreateUser", "创建者", "")]
public String CreateUser { get => _CreateUser; set { if (OnPropertyChanging("CreateUser", value)) { _CreateUser = value; OnPropertyChanged("CreateUser"); } } }
private DateTime _CreateTime;
/// <summary>创建时间</summary>
[Category("扩展")]
[DisplayName("创建时间")]
[Description("创建时间")]
[DataObjectField(false, false, true, 0)]
[BindColumn("CreateTime", "创建时间", "")]
public DateTime CreateTime { get => _CreateTime; set { if (OnPropertyChanging("CreateTime", value)) { _CreateTime = value; OnPropertyChanged("CreateTime"); } } }
private String _CreateIP;
/// <summary>创建地址</summary>
[Category("扩展")]
[DisplayName("创建地址")]
[Description("创建地址")]
[DataObjectField(false, false, true, 50)]
[BindColumn("CreateIP", "创建地址", "")]
public String CreateIP { get => _CreateIP; set { if (OnPropertyChanging("CreateIP", value)) { _CreateIP = value; OnPropertyChanged("CreateIP"); } } }
private Int32 _UpdateUserID;
/// <summary>更新人</summary>
[Category("扩展")]
[DisplayName("更新人")]
[Description("更新人")]
[DataObjectField(false, false, false, 0)]
[BindColumn("UpdateUserID", "更新人", "")]
public Int32 UpdateUserID { get => _UpdateUserID; set { if (OnPropertyChanging("UpdateUserID", value)) { _UpdateUserID = value; OnPropertyChanged("UpdateUserID"); } } }
private String _UpdateUser;
/// <summary>更新者</summary>
[Category("扩展")]
[DisplayName("更新者")]
[Description("更新者")]
[DataObjectField(false, false, true, 50)]
[BindColumn("UpdateUser", "更新者", "")]
public String UpdateUser { get => _UpdateUser; set { if (OnPropertyChanging("UpdateUser", value)) { _UpdateUser = value; OnPropertyChanged("UpdateUser"); } } }
private DateTime _UpdateTime;
/// <summary>更新时间</summary>
[Category("扩展")]
[DisplayName("更新时间")]
[Description("更新时间")]
[DataObjectField(false, false, true, 0)]
[BindColumn("UpdateTime", "更新时间", "")]
public DateTime UpdateTime { get => _UpdateTime; set { if (OnPropertyChanging("UpdateTime", value)) { _UpdateTime = value; OnPropertyChanged("UpdateTime"); } } }
private String _UpdateIP;
/// <summary>更新地址</summary>
[Category("扩展")]
[DisplayName("更新地址")]
[Description("更新地址")]
[DataObjectField(false, false, true, 50)]
[BindColumn("UpdateIP", "更新地址", "")]
public String UpdateIP { get => _UpdateIP; set { if (OnPropertyChanging("UpdateIP", value)) { _UpdateIP = value; OnPropertyChanged("UpdateIP"); } } }
private String _Remark;
/// <summary>备注</summary>
[Category("扩展")]
[DisplayName("备注")]
[Description("备注")]
[DataObjectField(false, false, true, 500)]
[BindColumn("Remark", "备注", "")]
public String Remark { get => _Remark; set { if (OnPropertyChanging("Remark", value)) { _Remark = value; OnPropertyChanged("Remark"); } } }
#endregion
#region 获取/设置 字段值
/// <summary>获取/设置 字段值</summary>
/// <param name="name">字段名</param>
/// <returns></returns>
public override Object this[String name]
{
get => name switch
{
"Id" => _Id,
"Name" => _Name,
"IgnoreTable" => _IgnoreTable,
"MapTable" => _MapTable,
"SourceId" => _SourceId,
"TargetId" => _TargetId,
"ErrorNum" => _ErrorNum,
"Enable" => _Enable,
"TaskId" => _TaskId,
"LastTime" => _LastTime,
"IsAllCopy" => _IsAllCopy,
"IsAllSync" => _IsAllSync,
"DBModel" => _DBModel,
"CreateUserID" => _CreateUserID,
"CreateUser" => _CreateUser,
"CreateTime" => _CreateTime,
"CreateIP" => _CreateIP,
"UpdateUserID" => _UpdateUserID,
"UpdateUser" => _UpdateUser,
"UpdateTime" => _UpdateTime,
"UpdateIP" => _UpdateIP,
"Remark" => _Remark,
_ => base[name]
};
set
{
switch (name)
{
case "Id": _Id = value.ToInt(); break;
case "Name": _Name = Convert.ToString(value); break;
case "IgnoreTable": _IgnoreTable = Convert.ToString(value); break;
case "MapTable": _MapTable = Convert.ToString(value); break;
case "SourceId": _SourceId = value.ToInt(); break;
case "TargetId": _TargetId = value.ToInt(); break;
case "ErrorNum": _ErrorNum = value.ToInt(); break;
case "Enable": _Enable = value.ToBoolean(); break;
case "TaskId": _TaskId = value.ToInt(); break;
case "LastTime": _LastTime = value.ToDateTime(); break;
case "IsAllCopy": _IsAllCopy = value.ToBoolean(); break;
case "IsAllSync": _IsAllSync = value.ToBoolean(); break;
case "DBModel": _DBModel = Convert.ToString(value); break;
case "CreateUserID": _CreateUserID = value.ToInt(); break;
case "CreateUser": _CreateUser = Convert.ToString(value); break;
case "CreateTime": _CreateTime = value.ToDateTime(); break;
case "CreateIP": _CreateIP = Convert.ToString(value); break;
case "UpdateUserID": _UpdateUserID = value.ToInt(); break;
case "UpdateUser": _UpdateUser = Convert.ToString(value); break;
case "UpdateTime": _UpdateTime = value.ToDateTime(); break;
case "UpdateIP": _UpdateIP = Convert.ToString(value); break;
case "Remark": _Remark = Convert.ToString(value); break;
default: base[name] = value; break;
}
}
}
#endregion
#region 关联映射
/// <summary>源库</summary>
[XmlIgnore, IgnoreDataMember, ScriptIgnore]
public DataSource Source => Extends.Get(nameof(Source), k => DataSource.FindById(SourceId));
/// <summary>源库</summary>
[Map(nameof(SourceId), typeof(DataSource), "Id")]
public String SourceName => Source?.Name;
/// <summary>目标库</summary>
[XmlIgnore, IgnoreDataMember, ScriptIgnore]
public DataSource Target => Extends.Get(nameof(Target), k => DataSource.FindById(TargetId));
/// <summary>目标库</summary>
[Map(nameof(TargetId), typeof(DataSource), "Id")]
public String TargetName => Target?.Name;
#endregion
#region 字段名
/// <summary>取得数据同步字段信息的快捷方式</summary>
public partial class _
{
/// <summary>编号</summary>
public static readonly Field Id = FindByName("Id");
/// <summary>名称</summary>
public static readonly Field Name = FindByName("Name");
/// <summary>忽略同步表。与同步表映射共同生效</summary>
public static readonly Field IgnoreTable = FindByName("IgnoreTable");
/// <summary>同步表映射。仅同步指定表,并映射到目标库,映射关系:分号分割映射表,逗号分割多组映射</summary>
public static readonly Field MapTable = FindByName("MapTable");
/// <summary>源库</summary>
public static readonly Field SourceId = FindByName("SourceId");
/// <summary>目标库</summary>
public static readonly Field TargetId = FindByName("TargetId");
/// <summary>错误重试</summary>
public static readonly Field ErrorNum = FindByName("ErrorNum");
/// <summary>启用</summary>
public static readonly Field Enable = FindByName("Enable");
/// <summary>管理任务。用于扫描源库的表信息变更,例如新增表和新增字段</summary>
public static readonly Field TaskId = FindByName("TaskId");
/// <summary>最后同步时间</summary>
public static readonly Field LastTime = FindByName("LastTime");
/// <summary>原样拷贝,不会生成单独的表配置</summary>
public static readonly Field IsAllCopy = FindByName("IsAllCopy");
/// <summary>整库同步,会自动创建定时任务同步表模型</summary>
public static readonly Field IsAllSync = FindByName("IsAllSync");
/// <summary>库模型</summary>
public static readonly Field DBModel = FindByName("DBModel");
/// <summary>创建人</summary>
public static readonly Field CreateUserID = FindByName("CreateUserID");
/// <summary>创建者</summary>
public static readonly Field CreateUser = FindByName("CreateUser");
/// <summary>创建时间</summary>
public static readonly Field CreateTime = FindByName("CreateTime");
/// <summary>创建地址</summary>
public static readonly Field CreateIP = FindByName("CreateIP");
/// <summary>更新人</summary>
public static readonly Field UpdateUserID = FindByName("UpdateUserID");
/// <summary>更新者</summary>
public static readonly Field UpdateUser = FindByName("UpdateUser");
/// <summary>更新时间</summary>
public static readonly Field UpdateTime = FindByName("UpdateTime");
/// <summary>更新地址</summary>
public static readonly Field UpdateIP = FindByName("UpdateIP");
/// <summary>备注</summary>
public static readonly Field Remark = FindByName("Remark");
static Field FindByName(String name) => Meta.Table.FindByName(name);
}
/// <summary>取得数据同步字段名称的快捷方式</summary>
public partial class __
{
/// <summary>编号</summary>
public const String Id = "Id";
/// <summary>名称</summary>
public const String Name = "Name";
/// <summary>忽略同步表。与同步表映射共同生效</summary>
public const String IgnoreTable = "IgnoreTable";
/// <summary>同步表映射。仅同步指定表,并映射到目标库,映射关系:分号分割映射表,逗号分割多组映射</summary>
public const String MapTable = "MapTable";
/// <summary>源库</summary>
public const String SourceId = "SourceId";
/// <summary>目标库</summary>
public const String TargetId = "TargetId";
/// <summary>错误重试</summary>
public const String ErrorNum = "ErrorNum";
/// <summary>启用</summary>
public const String Enable = "Enable";
/// <summary>管理任务。用于扫描源库的表信息变更,例如新增表和新增字段</summary>
public const String TaskId = "TaskId";
/// <summary>最后同步时间</summary>
public const String LastTime = "LastTime";
/// <summary>原样拷贝,不会生成单独的表配置</summary>
public const String IsAllCopy = "IsAllCopy";
/// <summary>整库同步,会自动创建定时任务同步表模型</summary>
public const String IsAllSync = "IsAllSync";
/// <summary>库模型</summary>
public const String DBModel = "DBModel";
/// <summary>创建人</summary>
public const String CreateUserID = "CreateUserID";
/// <summary>创建者</summary>
public const String CreateUser = "CreateUser";
/// <summary>创建时间</summary>
public const String CreateTime = "CreateTime";
/// <summary>创建地址</summary>
public const String CreateIP = "CreateIP";
/// <summary>更新人</summary>
public const String UpdateUserID = "UpdateUserID";
/// <summary>更新者</summary>
public const String UpdateUser = "UpdateUser";
/// <summary>更新时间</summary>
public const String UpdateTime = "UpdateTime";
/// <summary>更新地址</summary>
public const String UpdateIP = "UpdateIP";
/// <summary>备注</summary>
public const String Remark = "Remark";
}
#endregion
}
|