我总结的三层结构之一：Model示例
简单字典表的C# Model类示例
数据表tFolk定义：
create table tFolk (
Id int identity(1,1) primary key,
Title nvarchar(50) not null unique
);
go
这是个简单的字典表，Id是主键；Title不允许空值，有唯一性约束。其对应Model类如下：
//============================================================
// Module: C# model class of data table [tFolk]
// Auto generated by: mySagasoft CodeAssistant for MSPetShop3Tiers of sagahu@163.com, at 2012-07-29 14:50:40
// Usage:
// Last modified by: sagahu@163.com
// Last modified at: 2012-07-29 14:50:40
//============================================================
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
namespace mySagasoft.CodeTemplates.Models // 命名空间需要根据实际项目修改
{
[Serializable]
public partial class Folk
{
#region Constructors
public Folk() { }
public Folk(int? id, string title)
: this()
{
this.Id = id;
this.Title = title;
}
public Folk(DataRow dr)
: this()
{
if (Convert.IsDBNull(dr["Id"])) this.Id = (int)dr["Id"];
if (Convert.IsDBNull(dr["Title"])) this.Title = (string)dr["Title"];
}
#endregion
#region Member variables
private int? _Id;
private string _Title;
#endregion
#region Properties
public int? Id
{
get { return this._Id; }
set { this._Id = value; }
}
public string Title
{
get { return this._Title; }
set { this._Title = value; }
}
#endregion
#region Methods
public virtual string ToXmlString()
{
StringBuilder sb = new StringBuilder();
sb.Append("<Entity>");
sb.Append("<Id>"); sb.Append(this._Id.ToString()); sb.Append("</Id>");
sb.Append("<Title>"); sb.Append(this._Title); sb.Append("</Title>");
sb.Append("</Entity>");
return sb.ToString();
}
#endregion
}
}
简单业务数据表的C# Model类示例
数据表tStudent定义：
create table tStudent (
Id int identity(1,1) primary key,
Name nvarchar(50) not null,
Birthday datetime,
FolkId int,
IdentityCode varchar(20) not null unique,
Photo image
);
go
这是个比较简单的业务表，Id是主键；IdentityCode不允许空值，有唯一性约束；Photo是大对象（large object）类型的字段。
//============================================================
// Module: C# model class of data table [tStudent]
// Auto generated by: mySagasoft CodeAssistant for MSPetShop3Tiers of sagahu@163.com, at 2012-07-29 14:50:40
// Usage:
// Last modified by: sagahu@163.com
// Last modified at: 2012-07-29 14:50:40
//============================================================
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
namespace mySagasoft.CodeTemplates.Models // 命名空间需要根据实际项目修改
{
[Serializable]
public partial class Student
{
#region Constructors
public Student() { }
public Student(int? id, string name, DateTime? birthday, int? folkId, string identityCode,
byte[] photo)
: this()
{
this.Id = id;
this.Name = name;
this.Birthday = birthday;
this.FolkId = folkId;
this.IdentityCode = identityCode;
this.Photo = photo; // large object特殊处理
}
public Student(DataRow dr)
: this()
{
if (Convert.IsDBNull(dr["Id"])) this.Id = (int)dr["Id"];
if (Convert.IsDBNull(dr["Name"])) this.Name = (string)dr["Name"];
if (Convert.IsDBNull(dr["Birthday"])) this.Birthday = (DateTime)dr["Birthday"];
if (Convert.IsDBNull(dr["FolkId"])) this.FolkId = (int)dr["FolkId"];
if (Convert.IsDBNull(dr["IdentityCode"])) this.IdentityCode = (string)dr["IdentityCode"];
if (Convert.IsDBNull(dr["Photo"])) this.Photo = (byte[])dr["Photo"];
}
#endregion
#region Member variables
private int? _Id;
private string _Name;
private DateTime? _Birthday;
private int? _FolkId;
private string _IdentityCode; // 身份证代码，唯一性值的字段
private byte[] _Photo; // large object 字段，需要特殊处理
#endregion
#region Properties
public int? Id
{
get { return this._Id; }
set { this._Id = value; }
}
public string Name
{
get { return this._Name; }
set { this._Name = value; }
}
public DateTime? Birthday
{
get { return this._Birthday; }
set { this._Birthday = value; }
}
public int? FolkId
{
get { return this._FolkId; }
set { this._FolkId = value; }
}
public string IdentityCode
{
get { return this._IdentityCode; }
set { this._IdentityCode = value; }
}
public byte[] Photo
{
get { return this._Photo; }
set { this._Photo = value; }
}
#endregion
#region Methods
public virtual string ToXmlString()
{
StringBuilder sb = new StringBuilder();
sb.Append("<Entity>");
sb.Append("<Id>"); sb.Append(this._Id.ToString()); sb.Append("</Id>");
sb.Append("<Name>"); sb.Append(this._Name); sb.Append("</Name>");
sb.Append("<Birthday>"); sb.Append(this._Birthday.ToString()); sb.Append("</Birthday>");
sb.Append("<FolkId>"); sb.Append(this._FolkId.ToString()); sb.Append("</FolkId>");
sb.Append("<IdentityCode>"); sb.Append(this._IdentityCode); sb.Append("</IdentityCode>");
// sb.Append("<Photo>"); sb.Append(this._Photo); sb.Append("</Photo>"); // large object不加入这个方法
sb.Append("</Entity>");
return sb.ToString();
}
#endregion
}
}
简单视图的C# Model类示例
视图vwStudentView定义：
create view vwStudentView
as
select s.Id,s.Name,s.Birthday,s.FolkId,f.Title,s.IdentityCode,s.Photo from tStudent as s
left join tFolk as f on s.FolkId=f.Id;
go
在这个简单视图里，Id、IdentityCode是唯一性键值。
//============================================================
// Module: C# model class of data view [vwStudentView]
// Auto generated by: mySagasoft CodeAssistant for MSPetShop3Tiers of sagahu@163.com, at 2012-07-29 14:50:40
// Usage:
// Last modified by: sagahu@163.com
// Last modified at: 2012-07-29 14:50:40
//============================================================
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
namespace mySagasoft.CodeTemplates.Models // 命名空间需要根据实际项目修改
{
[Serializable]
public partial class StudentView
{
#region Constructors
public StudentView() { }
public StudentView(int? id, string name, DateTime? birthday, int? folkId, string folkTitle,
string _IdentityCode, byte[] photo)
: this()
{
this.Id = id;
this.Name = name;
this.Birthday = birthday;
this.FolkId = folkId;
this.FolkTitle = folkTitle;
this.IdentityCode = IdentityCode;
this.Photo = Photo; // large object特殊处理
}
public StudentView(DataRow dr)
: this()
{
if (Convert.IsDBNull(dr["Id"])) this.Id = (int)dr["Id"];
if (Convert.IsDBNull(dr["Name"])) this.Name = (string)dr["Name"];
if (Convert.IsDBNull(dr["Birthday"])) this.Birthday = (DateTime)dr["Birthday"];
if (Convert.IsDBNull(dr["FolkId"])) this.FolkId = (int)dr["FolkId"];
if (Convert.IsDBNull(dr["FolkTitle"])) this.FolkTitle = (string)dr["FolkTitle"];
if (Convert.IsDBNull(dr["IdentityCode"])) this.IdentityCode = (string)dr["IdentityCode"];
if (Convert.IsDBNull(dr["Photo"])) this.Photo = (byte[])dr["Photo"];
}
#endregion
#region Member variables
private int? _Id;
private string _Name;
private DateTime? _Birthday;
private int? _FolkId;
private string _FolkTitle;
private string _IdentityCode; // 身份证代码，唯一性值的字段
private byte[] _Photo; // large object 字段，需要特殊处理
#endregion
#region Properties
public int? Id
{
get { return this._Id; }
set { this._Id = value; }
}
public string Name
{
get { return this._Name; }
set { this._Name = value; }
}
public DateTime? Birthday
{
get { return this._Birthday; }
set { this._Birthday = value; }
}
public int? FolkId
{
get { return this._FolkId; }
set { this._FolkId = value; }
}
public string FolkTitle
{
get { return this._FolkTitle; }
set { this._FolkTitle = value; }
}
public string IdentityCode
{
get { return this._IdentityCode; }
set { this._IdentityCode = value; }
}
public byte[] Photo
{
get { return this._Photo; }
set { this._Photo = value; }
}
#endregion
#region Methods
public virtual string ToXmlString()
{
StringBuilder sb = new StringBuilder();
sb.Append("<Entity>");
sb.Append("<Id>"); sb.Append(this._Id.ToString()); sb.Append("</Id>");
sb.Append("<Name>"); sb.Append(this._Name); sb.Append("</Name>");
sb.Append("<Birthday>"); sb.Append(this._Birthday.ToString()); sb.Append("</Birthday>");
sb.Append("<FolkId>"); sb.Append(this._FolkId.ToString()); sb.Append("</FolkId>");
sb.Append("<FolkTitle>"); sb.Append(this._FolkTitle.ToString()); sb.Append("</FolkTitle>");
sb.Append("<IdentityCode>"); sb.Append(this._IdentityCode); sb.Append("</IdentityCode>");
// sb.Append("<Photo>"); sb.Append(this._Photo); sb.Append("</Photo>"); // large object不加入这个方法
sb.Append("</Entity>");
return sb.ToString();
}
#endregion
}
}