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 Stardust.Data.Platform;
/// <summary>项目用户关系。项目与用户之间的多对多关系</summary>
[Serializable]
[DataObject]
[Description("项目用户关系。项目与用户之间的多对多关系")]
[BindIndex("IU_ProjectUser_ProjectId_UserId", true, "ProjectId,UserId")]
[BindIndex("IX_ProjectUser_UserId", false, "UserId")]
[BindTable("ProjectUser", Description = "项目用户关系。项目与用户之间的多对多关系", ConnName = "Stardust", DbType = DatabaseType.None)]
public partial class ProjectUser
{
#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 Int32 _ProjectId;
/// <summary>项目</summary>
[DisplayName("项目")]
[Description("项目")]
[DataObjectField(false, false, false, 0)]
[BindColumn("ProjectId", "项目", "")]
public Int32 ProjectId { get => _ProjectId; set { if (OnPropertyChanging("ProjectId", value)) { _ProjectId = value; OnPropertyChanged("ProjectId"); } } }
private Int32 _UserId;
/// <summary>用户</summary>
[DisplayName("用户")]
[Description("用户")]
[DataObjectField(false, false, false, 0)]
[BindColumn("UserId", "用户", "")]
public Int32 UserId { get => _UserId; set { if (OnPropertyChanging("UserId", value)) { _UserId = value; OnPropertyChanged("UserId"); } } }
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 _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 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 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,
"ProjectId" => _ProjectId,
"UserId" => _UserId,
"Enable" => _Enable,
"CreateUserId" => _CreateUserId,
"CreateTime" => _CreateTime,
"CreateIP" => _CreateIP,
"UpdateUserId" => _UpdateUserId,
"UpdateTime" => _UpdateTime,
"UpdateIP" => _UpdateIP,
"Remark" => _Remark,
_ => base[name]
};
set
{
switch (name)
{
case "Id": _Id = value.ToInt(); break;
case "ProjectId": _ProjectId = value.ToInt(); break;
case "UserId": _UserId = value.ToInt(); break;
case "Enable": _Enable = value.ToBoolean(); break;
case "CreateUserId": _CreateUserId = value.ToInt(); break;
case "CreateTime": _CreateTime = value.ToDateTime(); break;
case "CreateIP": _CreateIP = Convert.ToString(value); break;
case "UpdateUserId": _UpdateUserId = value.ToInt(); 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 GalaxyProject Project => Extends.Get(nameof(Project), k => GalaxyProject.FindById(ProjectId));
/// <summary>项目</summary>
[Map(nameof(ProjectId), typeof(GalaxyProject), "Id")]
public String ProjectName => Project?.ToString();
/// <summary>用户</summary>
[XmlIgnore, IgnoreDataMember, ScriptIgnore]
public XCode.Membership.User User => Extends.Get(nameof(User), k => XCode.Membership.User.FindByID(UserId));
/// <summary>用户</summary>
[Map(nameof(UserId), typeof(XCode.Membership.User), "ID")]
public String UserName => User?.ToString();
#endregion
#region 扩展查询
/// <summary>根据项目查找</summary>
/// <param name="projectId">项目</param>
/// <returns>实体列表</returns>
public static IList<ProjectUser> FindAllByProjectId(Int32 projectId)
{
if (projectId < 0) return [];
// 实体缓存
if (Meta.Session.Count < 1000) return Meta.Cache.FindAll(e => e.ProjectId == projectId);
return FindAll(_.ProjectId == projectId);
}
#endregion
#region 字段名
/// <summary>取得项目用户关系字段信息的快捷方式</summary>
public partial class _
{
/// <summary>编号</summary>
public static readonly Field Id = FindByName("Id");
/// <summary>项目</summary>
public static readonly Field ProjectId = FindByName("ProjectId");
/// <summary>用户</summary>
public static readonly Field UserId = FindByName("UserId");
/// <summary>启用</summary>
public static readonly Field Enable = FindByName("Enable");
/// <summary>创建者</summary>
public static readonly Field CreateUserId = FindByName("CreateUserId");
/// <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 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 ProjectId = "ProjectId";
/// <summary>用户</summary>
public const String UserId = "UserId";
/// <summary>启用</summary>
public const String Enable = "Enable";
/// <summary>创建者</summary>
public const String CreateUserId = "CreateUserId";
/// <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 UpdateTime = "UpdateTime";
/// <summary>更新地址</summary>
public const String UpdateIP = "UpdateIP";
/// <summary>描述</summary>
public const String Remark = "Remark";
}
#endregion
}
|