代码升级

1：修改Add方法：
/// <summary>
        /// 添加一条记录。
        /// </summary>
        /// <param name="detail">一条记录</param>
        /// <returns>true 成功 false 失败</returns>
        /// <example>调用案例：
        /// <code>
        /// TableBN bn = new TableBN();
        /// OrderDT baseDT = new OrderDT();
        /// baseDT.ID = 1;
        /// baseDT.Name = "订单1";
        /// bool result = bn.Add(baseDT);
        /// </code>
        /// </example>
        public new bool Add(BaseDT detail)
        {
            Data.ObjectBroker.Create(detail);
            return true;
        }

2：添加DT类的配置文件：
RecorderDT.hbm.xml：
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
  <class name="Data.RecorderDT, Data" table="Recorder" discriminator-value="C">
    <id name="RedId" type="Int32" column="RedId" unsaved-value="0">
      <generator class="identity"/>
    </id>
    <property name="CreateDate" type="String" column="CreateDate" insert="false" />
    <property name="RecDate" type="String" column="RecDate" />
    <property name="RecType" type="Int32" column="RecType" />
    <property name="RecValue" type="Decimal" column="RecValue" />
    <property name="Remark" type="String(250)" column="Remark" />
  </class>
</hibernate-mapping>

RecorderDT.cs：
/// <copyright>Xumingxsh  1999-2006</copyright>
/// <version>1.0</version>
/// <author>Xuming</author>
/// <email>Xumingxsh21@126.com</email>
/// <log date="2006-05-30">创建</log>

using System;
using System.Data;

namespace Data
{
 /// <summary>
 /// Recorder表的描述类。
 /// </summary>
 /// <author>Xuming</author>
 /// <log date="2006-05-30">创建</log>
 public class RecorderDT : BaseDataDT
 {
  public RecorderDT() : base()
  {
  }

  /// <summary>
  /// 记录ID。
  /// </summary>
  /// <author>Xuming</author>
  /// <log date="2006-05-30">创建</log>
  private int _RedId;

  /// <summary>
  /// 记录时间。
  /// </summary>
  /// <author>Xuming</author>
  /// <log date="2006-05-30">创建</log>
  private string _CreateDate;

  /// <summary>
  /// 花销日期。
  /// </summary>
  /// <author>Xuming</author>
  /// <log date="2006-05-30">创建</log>
  private string _RecDate;

  /// <summary>
  /// 花销类型。
  /// </summary>
  /// <author>Xuming</author>
  /// <log date="2006-05-30">创建</log>
  private int _RecType;

  /// <summary>
  /// 花销金额。
  /// </summary>
  /// <author>Xuming</author>
  /// <log date="2006-05-30">创建</log>
  private decimal _RecValue;

  /// <summary>
  /// 备注。
  /// </summary>
  /// <author>Xuming</author>
  /// <log date="2006-05-30">创建</log>
  private string _Remark;

  /// <summary>
  /// 记录ID。
  /// </summary>
  /// <author>Xuming</author>
  /// <log date="2006-05-30">创建</log>
  public int RedId
  {
   set
   {
    _RedId = value;
   }
   get
   {
    return _RedId;
   }
  }

  /// <summary>
  /// 记录时间。
  /// </summary>
  /// <author>Xuming</author>
  /// <log date="2006-05-30">创建</log>
  public string CreateDate
  {
   set
   {

    _CreateDate = value;
   }
   get
   {
    return _CreateDate;
   }
  }

  /// <summary>
  /// 花销日期。
  /// </summary>
  /// <author>Xuming</author>
  /// <log date="2006-05-30">创建</log>
  public string RecDate
  {
   set
   {

    _RecDate = value;
   }
   get
   {
    return _RecDate;
   }
  }

  /// <summary>
  /// 花销类型。
  /// </summary>
  /// <author>Xuming</author>
  /// <log date="2006-05-30">创建</log>
  public int RecType
  {
   set
   {

    _RecType = value;
   }
   get
   {
    return _RecType;
   }
  }

  /// <summary>
  /// 花销金额。
  /// </summary>
  /// <author>Xuming</author>
  /// <log date="2006-05-30">创建</log>
  public decimal RecValue
  {
   set
   {
    _RecValue = value;
   }
   get
   {
    return _RecValue;
   }
  }

  /// <summary>
  /// 备注。
  /// </summary>
  /// <author>Xuming</author>
  /// <log date="2006-05-30">创建</log>
  public string Remark
  {
   set
   {

    _Remark = value;
   }
   get
   {
    return _Remark;
   }
  }
 }
}


RectypeDT.hbm.xml：
<?xml version="1.0" encoding="utf-8" ?>
 <hibernate-mapping xmlns="urn:nhibernate-mapping-2.0" >
  <class name="Data.RectypeDT, Data" table="RecType">
   <id name="RecTypeId" type="Int32" column="RecTypeId">
    <generator class="identity"/>
   </id>
   <property name="RecTypeName" type="String(10)" column="RecTypeName" />
   </class>
</hibernate-mapping>

RectypeDT.cs：
/// <copyright>Xumingxsh  1999-2006</copyright>
/// <version>1.0</version>
/// <author>Xuming</author>
/// <email>Xumingxsh21@126.com</email>
/// <log date="2006-05-30">创建</log>

using System;
using System.Data;

namespace Data
{
 /// <summary>
 /// Rectype表的描述类。
 /// </summary>
 /// <author>Xuming</author>
 /// <log date="2006-05-30">创建</log>
 [Serializable()]
 public class RectypeDT : BaseDataDT
 {
  public RectypeDT() : base()
  {
  }

  /// <summary>
  /// 花销类型编号。
  /// </summary>
  /// <author>Xuming</author>
  /// <log date="2006-05-30">创建</log>
  private int _RecTypeId;

  /// <summary>
  /// 花销类型名称。
  /// </summary>
  /// <author>Xuming</author>
  /// <log date="2006-05-30">创建</log>
  private string _RecTypeName;

  /// <summary>
  /// 花销类型编号。
  /// </summary>
  /// <author>Xuming</author>
  /// <log date="2006-05-30">创建</log>
  public int RecTypeId
  {
   set
   {
    _RecTypeId = value;
   }
   get
   {
    return _RecTypeId;
   }
  }

  /// <summary>
  /// 花销类型名称。
  /// </summary>
  /// <author>Xuming</author>
  /// <log date="2006-05-30">创建</log>
  public string RecTypeName
  {
   set
   {

    _RecTypeName = value;
   }
   get
   {
    return _RecTypeName;
   }
  }
 }
}

3：修改添加记录：
/// <summary>
  /// 添加花销记录。
  /// </summary>
  public void AddRecorder(RecorderDV detail)
  {
   int recId = GetTypeId(detail.RecTypeName);

   detail.RecType = recId;
            this.Add(detail);
  }

/// <summary>
  /// 取得类型编号。
  /// </summary>
  /// <param name="recTypeName"></param>
  /// <returns></returns>
  private int GetTypeId(string recTypeName)
  {
   if (!IsExistType(recTypeName))
   {
    RectypeDT detail = new RectypeDT();
    detail.RecTypeName = recTypeName;
    this.Add(detail);
   }

   RectypeSQL sql = new RectypeSQL();
   SqlInfo info = sql.GetTypeID(recTypeName);

   return this.GetRows(info);
  }

修改后的AddRecorder：
/// <summary>
        /// 添加花销记录。
        /// </summary>
        public void AddRecorder(RecorderDV detail)
        {
            int recId = GetTypeId(detail.RecTypeName);

            detail.RecType = recId;

            RecorderDT dtDetail = new RecorderDT();
            dtDetail.RecDate = detail.RecDate;
            dtDetail.RecType = detail.RecType;
            dtDetail.RecValue = detail.RecValue;
            dtDetail.Remark = detail.Remark;
            this.Add(dtDetail);
        }

4：接下来，是把取得花销类型ID和添加花销记录合起来，用NHibernate实现。
步骤：1）修改DT类；2）修改配置文件；3）修改AddRecorder和GetTypeId方法。