目前拥有的框架是基于DataSet的,支持多表关联,已经可以彻底的摆脱Insert/Update/Delete语句了,后来又增加了UpdateObject 和 DeleteObject 来减少基于DataSet而能导致的Sql语句执行的次数烦多的缘故。现在为了减少程序员编码的痛苦,同时,又能得到编译时类型控制,往Data层增加Entity,一般是贫血Object,纯粹拥有属性,没有方法的.
前一段时间看了一阵子的ORM,感觉有单表的都还简单,最头痛的就是如何控制多表关联那些没必要的SQL语句,可能自己还没什么仔细看的缘故吧。
目前拥有的框架是基于DataSet的,支持多表关联,已经可以彻底的摆脱Insert/Update/Delete语句了,后来又增加了UpdateObject 和 DeleteObject 来减少基于DataSet而能导致的Sql语句执行的次数烦多的缘故。现在为了减少程序员编码的痛苦,同时,又能得到编译时类型控制,往Data层增加Entity,一般是贫血Object,纯粹拥有属性,没有方法的。
原来是一个DataSet 囊括了构建DataTable的功能。现在增加BaseEntity ,BaseDataTable类。BaseEntity 有一个属性RowIndex ,用来保存对应的行号,如果是新增RowIndex=-1 否则对应行号。BaseDataTable 有3个虚方法:1。获取实体类 public virtual BaseEntity GetEntity(int rowIndex) 2。创建一个实体类 public virtual BaseEntity CreateEntity() 3。 把实体值转入DataRow中 public virtual bool SetEntity(BaseEntity entity)
这样,我们就可以使用代码生成器来构建我们需要的对象。
比如
OrdersDataSet 需要拥有 OrdersTable ItemsTable DeliveriesTable OrdersEntity ItemsEntity DeliveriesEntity
OrdersDataSet 只需要拥有3个Public 的 OrdersTable ItemsTable DeliveriesTable
OrdersTable 需要Override那三个方法,然后 使用OrdersEntity
ItemsTable以此类推.....
1.获取实体以及修改保存
OrdersEntity entity=ordersDataSet.OrdersTable.GetEntity(0) as OrdersEntity ;
Console.WirteLine("Order ID is"+entity.OrderID);
entity.Quantity=20;
ordersDataSet.OrdersTable.SetEntity(entity);
2.新增一个实体,并设置值以及保存入表格
OrdersEntity newEntity=ordersDataSet.OrdersTable.CreateEntity() as OrdersEntity;
newEntity.OrderID="xxxxx";
ordersDataSet.OrdersTable.SetEntity(newEntity);
当然了,如上的代码,如果移植到.Net2.0就可以充分的利用泛型,但是还有几个网站在1.1下, 不敢一下子更换。.........
通过这种封装,我们可以减少原本基于DataRow的赋值和获取值的麻烦,而且类型也是编译时安全的。
当然了,我知道这不可能时ORM :)因为我是使用硬编码,只是通过代码生成器可以减少编写这么多麻烦的重复的代码。事实也证明了这种方式的开发的快速性,不过,不够OO,因为是基于Table的。相对来说,对于大企业的大系统不适合,中小企业还可以吧,个人觉得:)
呵呵,虽然自己的框架不是优秀的,但是,用的习惯了,觉得还是很快的,虽然没有拥有那么多令人骄傲的特色,没有那么OO,但是也足够我自己用了~_~ ! 自己是多么的不求上进,但是依然要写很多Select语句来获取复杂的查询数据。
sample code 如下:
using System;
using FishSky.Data.Base;
namespace FishSky.Data.Chateau
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
{
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////<summary>
/// SendOutEntity实体类
///</summary>
public class SendOutEntity : BaseEntity
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
构造函数#region 构造函数
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////<summary>
// 构造函数
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////</summary>
public SendOutEntity()
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
}
#endregion
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
出库单#region 出库单
private String mSendOutNo;
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////<summary>
// 出库单
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////</summary>
public String SendOutNo
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{ return mSendOutNo; }
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{ mSendOutNo = value; }
}
#endregion
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
发票号#region 发票号
private String mInvoiceNo;
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////<summary>
// 发票号
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////</summary>
public String InvoiceNo
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{ return mInvoiceNo; }
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{ mInvoiceNo = value; }
}
#endregion
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
总计#region 总计
private Decimal mAmount;
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////<summary>
// 总计
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////</summary>
public Decimal Amount
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{ return mAmount; }
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{ mAmount = value; }
}
#endregion
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
操作员#region 操作员
private String mUserName;
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////<summary>
// 操作员
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////</summary>
public String UserName
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{ return mUserName; }
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{ mUserName = value; }
}
#endregion
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
操作员中文名#region 操作员中文名
private String mChineseName;
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////<summary>
// 操作员中文名
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////</summary>
public String ChineseName
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{ return mChineseName; }
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{ mChineseName = value; }
}
#endregion
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
客户代码#region 客户代码
private String mCustomerCode;
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////<summary>
// 客户代码
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////</summary>
public String CustomerCode
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{ return mCustomerCode; }
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{ mCustomerCode = value; }
}
#endregion
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
客户中文名#region 客户中文名
private String mCustomerName;
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////<summary>
// 客户中文名
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////</summary>
public String CustomerName
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{ return mCustomerName; }
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{ mCustomerName = value; }
}
#endregion
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
备注#region 备注
private String mRemark;
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////<summary>
// 备注
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////</summary>
public String Remark
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{ return mRemark; }
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{ mRemark = value; }
}
#endregion
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
货款付讫#region 货款付讫
private String mIsPaid;
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////<summary>
// 货款付讫
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////</summary>
public String IsPaid
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{ return mIsPaid; }
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{ mIsPaid = value; }
}
#endregion
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
出售日期#region 出售日期
private DateTime mSendOutDate;
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////<summary>
// 出售日期
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////</summary>
public DateTime SendOutDate
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{ return mSendOutDate; }
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{ mSendOutDate = value; }
}
#endregion
}
}
using System;
using System.Data;
using FishSky.Data.Base;
namespace FishSky.Data.Chateau
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
{
public class SendOutDataTable : BaseDataTable
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
表格常量#region 表格常量
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
/// 定义对象数据集表名:SendOut
/// </summary>
public const String TBL_SendOut = "SendOut";
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
///出库单
/// </summary>
public const String SendOutNo_SendOut = "SendOutNo";
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
///发票号
/// </summary>
public const String InvoiceNo_SendOut = "InvoiceNo";
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
///总计
/// </summary>
public const String Amount_SendOut = "Amount";
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
///操作员
/// </summary>
public const String UserName_SendOut = "UserName";
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
///操作员中文名
/// </summary>
public const String ChineseName_SendOut = "ChineseName";
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
///客户代码
/// </summary>
public const String CustomerCode_SendOut = "CustomerCode";
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
///客户中文名
/// </summary>
public const String CustomerName_SendOut = "CustomerName";
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
///备注
/// </summary>
public const String Remark_SendOut = "Remark";
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
///货款付讫
/// </summary>
public const String IsPaid_SendOut = "IsPaid";
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
///出售日期
/// </summary>
public const String SendOutDate_SendOut = "SendOutDate";
#endregion
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
构造函数#region 构造函数
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////<summary>
/// 构造函数
///</summary>
public SendOutDataTable()
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
this.TableName = TBL_SendOut;
DataColumnCollection columns = this.Columns;
DataColumn column;
column = new DataColumn(SendOutNo_SendOut, typeof (String));
column.ExtendedProperties.Add(BaseConst.isPrimaryKeyColumn, true);
column.ExtendedProperties.Add(BaseConst.isSecondaryKeyColumn, false);
column.ExtendedProperties.Add(BaseConst.isValidColumn, true);
column.MaxLength = 50;
column.DefaultValue = " ";
columns.Add(column);
column = new DataColumn(InvoiceNo_SendOut, typeof (String));
column.ExtendedProperties.Add(BaseConst.isPrimaryKeyColumn, false);
column.ExtendedProperties.Add(BaseConst.isSecondaryKeyColumn, false);
column.ExtendedProperties.Add(BaseConst.isValidColumn, true);
column.MaxLength = 50;
column.DefaultValue = " ";
columns.Add(column);
column = new DataColumn(Amount_SendOut, typeof (Decimal));
column.ExtendedProperties.Add(BaseConst.isPrimaryKeyColumn, false);
column.ExtendedProperties.Add(BaseConst.isSecondaryKeyColumn, false);
column.ExtendedProperties.Add(BaseConst.isValidColumn, true);
column.DefaultValue = 0;
columns.Add(column);
column = new DataColumn(UserName_SendOut, typeof (String));
column.ExtendedProperties.Add(BaseConst.isPrimaryKeyColumn, false);
column.ExtendedProperties.Add(BaseConst.isSecondaryKeyColumn, false);
column.ExtendedProperties.Add(BaseConst.isValidColumn, true);
column.MaxLength = 20;
column.DefaultValue = " ";
columns.Add(column);
column = new DataColumn(ChineseName_SendOut, typeof (String));
column.ExtendedProperties.Add(BaseConst.isPrimaryKeyColumn, false);
column.ExtendedProperties.Add(BaseConst.isSecondaryKeyColumn, false);
column.ExtendedProperties.Add(BaseConst.isValidColumn, true);
column.MaxLength = 50;
column.DefaultValue = " ";
columns.Add(column);
column = new DataColumn(CustomerCode_SendOut, typeof (String));
column.ExtendedProperties.Add(BaseConst.isPrimaryKeyColumn, false);
column.ExtendedProperties.Add(BaseConst.isSecondaryKeyColumn, false);
column.ExtendedProperties.Add(BaseConst.isValidColumn, true);
column.MaxLength = 20;
column.DefaultValue = " ";
columns.Add(column);
column = new DataColumn(CustomerName_SendOut, typeof (String));
column.ExtendedProperties.Add(BaseConst.isPrimaryKeyColumn, false);
column.ExtendedProperties.Add(BaseConst.isSecondaryKeyColumn, false);
column.ExtendedProperties.Add(BaseConst.isValidColumn, true);
column.MaxLength = 50;
column.DefaultValue = " ";
columns.Add(column);
column = new DataColumn(Remark_SendOut, typeof (String));
column.ExtendedProperties.Add(BaseConst.isPrimaryKeyColumn, false);
column.ExtendedProperties.Add(BaseConst.isSecondaryKeyColumn, false);
column.ExtendedProperties.Add(BaseConst.isValidColumn, true);
column.MaxLength = 100;
column.DefaultValue = " ";
columns.Add(column);
column = new DataColumn(IsPaid_SendOut, typeof (String));
column.ExtendedProperties.Add(BaseConst.isPrimaryKeyColumn, false);
column.ExtendedProperties.Add(BaseConst.isSecondaryKeyColumn, false);
column.ExtendedProperties.Add(BaseConst.isValidColumn, true);
column.MaxLength = 1;
column.DefaultValue = " ";
columns.Add(column);
column = new DataColumn(SendOutDate_SendOut, typeof (DateTime));
column.ExtendedProperties.Add(BaseConst.isPrimaryKeyColumn, false);
column.ExtendedProperties.Add(BaseConst.isSecondaryKeyColumn, false);
column.ExtendedProperties.Add(BaseConst.isValidColumn, true);
column.DefaultValue = DateTime.Now;
columns.Add(column);
}
#endregion
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
创建实体#region 创建实体
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////<summary>
/// 创建实体
///</summary>
///<returns>实体</returns>
public override BaseEntity CreateEntity()
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return new SendOutEntity();
}
#endregion
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
获取指定行号的实体#region 获取指定行号的实体
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////<summary>
/// 获取指定行号的实体
///</summary>
/// <param name="rowIndex">行号</param>
/// <returns>实体</returns>
public override BaseEntity GetEntity(int rowIndex)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
if (rowIndex >= 0 && rowIndex <= this.Rows.Count)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
SendOutEntity entity = new SendOutEntity();
entity.RowIndex = rowIndex;
DataRow dr = this.Rows[rowIndex];
entity.SendOutNo = dr[SendOutNo_SendOut].ToString();
entity.InvoiceNo = dr[InvoiceNo_SendOut].ToString();
entity.Amount = Convert.ToDecimal(dr[Amount_SendOut]);
entity.UserName = dr[UserName_SendOut].ToString();
entity.ChineseName = dr[ChineseName_SendOut].ToString();
entity.CustomerCode = dr[CustomerCode_SendOut].ToString();
entity.CustomerName = dr[CustomerName_SendOut].ToString();
entity.Remark = dr[Remark_SendOut].ToString();
entity.IsPaid = dr[IsPaid_SendOut].ToString();
entity.SendOutDate = Convert.ToDateTime(dr[SendOutDate_SendOut]);
return entity;
}
else
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
throw new ApplicationException("提示:您输入的行号有误!");
}
}
#endregion
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
设置实体值到DataTable#region 设置实体值到DataTable
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**////<summary>
/// 设置实体值到DataTable
///</summary>
///<param name="baseEntity">实体</param>
///<returns>是否设置成功</returns>
public override bool SetEntity(BaseEntity baseEntity)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
int rowIndex = baseEntity.RowIndex;
SendOutEntity entity = baseEntity as SendOutEntity;
if (entity == null)
return false;
DataRow dr;
if (rowIndex == -1)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
dr = this.NewRow();
dr[SendOutNo_SendOut] = entity.SendOutNo;
dr[InvoiceNo_SendOut] = entity.InvoiceNo;
dr[Amount_SendOut] = entity.Amount;
dr[UserName_SendOut] = entity.UserName;
dr[ChineseName_SendOut] = entity.ChineseName;
dr[CustomerCode_SendOut] = entity.CustomerCode;
dr[CustomerName_SendOut] = entity.CustomerName;
dr[Remark_SendOut] = entity.Remark;
dr[IsPaid_SendOut] = entity.IsPaid;
dr[SendOutDate_SendOut] = entity.SendOutDate;
this.Rows.Add(dr);
return true;
}
else
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
if (rowIndex >= 0 && rowIndex < this.Rows.Count)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
try
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
dr = this.Rows[rowIndex];
//只要是Key的值都不可以更改
dr[InvoiceNo_SendOut] = entity.InvoiceNo;
dr[Amount_SendOut] = entity.Amount;
dr[UserName_SendOut] = entity.UserName;
dr[ChineseName_SendOut] = entity.ChineseName;
dr[CustomerCode_SendOut] = entity.CustomerCode;
dr[CustomerName_SendOut] = entity.CustomerName;
dr[Remark_SendOut] = entity.Remark;
dr[IsPaid_SendOut] = entity.IsPaid;
dr[SendOutDate_SendOut] = entity.SendOutDate;
return true;
}
catch
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return false;
}
}
else
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return false;
}
}
}
#endregion
}
}
using System;
using System.Runtime.Serialization;
using FishSky.Data.Base;
namespace FishSky.Data.Chateau
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
{
[Serializable]
public class SendOutDataSet : BaseDataSet
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
表格常量及数据表#region 表格常量及数据表
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
/// 定义对象数据集表:SendOutDataTable
/// </summary>
public SendOutDataTable SendOutTable = new SendOutDataTable();
#endregion
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
构造函数#region 构造函数
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
/// 构造函数
/// </summary>
public SendOutDataSet() : base()
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
}
#endregion
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
序列化的构造函数#region 序列化的构造函数
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
/// 序列化的构造函数
/// </summary>
public SendOutDataSet(SerializationInfo info, StreamingContext context) : base(info, context)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
}
#endregion
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
建立数据集的表格#region 建立数据集的表格
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
/// 建立数据集的表格
/// </summary>
protected override void BuildDataTables()
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
this.Tables.Add(SendOutTable);
//设置新增自动生成key字段
this.KeyTypeID = "SendOutNo";
}
#endregion
}
}