CREATE TABLE [dbo].[QualityTestingAppeal] ( [ID] [bigint] NOT NULL IDENTITY(1, 1), [QualityTestingId] [bigint] NOT NULL, [OldState] [int] NOT NULL, [CreateTime] [datetime] NOT NULL, [CreateId] [bigint] NOT NULL, [AppealReason] [nvarchar] (512) COLLATE Chinese_PRC_CI_AS NULL, [AppealEnclosure] [varchar] (256) COLLATE Chinese_PRC_CI_AS NULL, [HandleAppealAUID] [bigint] NULL, [HandleAppealTime] [datetime] NULL, [HandleState] [int] NOT NULL CONSTRAINT [DF__QualityTe__Handl__59B11114] DEFAULT ((0)) ) 通过表设计生成带注释的实体C#类
时间: 2023-08-18 08:40:48 浏览: 221
您好,请参考以下代码,这是通过表设计生成带注释的实体C#类:
```csharp
using System;
/// <summary>
/// 实体类QualityTestingAppeal。(属性说明自动提取数据库字段的描述信息)
/// </summary>
[Serializable]
public partial class QualityTestingAppeal
{
public QualityTestingAppeal()
{ }
#region Model
private long _id;
private long _qualitytestingid;
private int _oldstate;
private DateTime _createtime = DateTime.Now;
private long _createid;
private string _appealreason;
private string _appealenclosure;
private long? _handleappealauid;
private DateTime? _handleappealtime;
private int _handlestate = 0;
/// <summary>
/// 自增长ID
/// </summary>
public long ID
{
set { _id = value; }
get { return _id; }
}
/// <summary>
/// 质检ID
/// </summary>
public long QualityTestingId
{
set { _qualitytestingid = value; }
get { return _qualitytestingid; }
}
/// <summary>
/// 原状态
/// </summary>
public int OldState
{
set { _oldstate = value; }
get { return _oldstate; }
}
/// <summary>
/// 创建时间
/// </summary>
public DateTime CreateTime
{
set { _createtime = value; }
get { return _createtime; }
}
/// <summary>
/// 创建者ID
/// </summary>
public long CreateId
{
set { _createid = value; }
get { return _createid; }
}
/// <summary>
/// 申诉原因
/// </summary>
public string AppealReason
{
set { _appealreason = value; }
get { return _appealreason; }
}
/// <summary>
/// 申诉附件
/// </summary>
public string AppealEnclosure
{
set { _appealenclosure = value; }
get { return _appealenclosure; }
}
/// <summary>
/// 处理申诉的管理员ID
/// </summary>
public long? HandleAppealAUID
{
set { _handleappealauid = value; }
get { return _handleappealauid; }
}
/// <summary>
/// 处理申诉时间
/// </summary>
public DateTime? HandleAppealTime
{
set { _handleappealtime = value; }
get { return _handleappealtime; }
}
/// <summary>
/// 处理状态(0:未处理,1:已处理)
/// </summary>
public int HandleState
{
set { _handlestate = value; }
get { return _handlestate; }
}
#endregion Model
}
```
希望这个代码可以帮到您。
阅读全文