NHB中一对一，一对多，多对一的实例

本文将讲述品目类型、品目、品目标准、品目明细这类常见关系在NHB中的实现。

在这里品目类型和品目是一对多的关系，其中品目类型表的主键作为品目表的外键；品目标准和品目是一对一的关系，品目表的主键作为品目标准表的外键；品目明细和品目是多对一的关系，品目表的主键作为品目明细表的外键。所以我使用了one-to-one、one-to-many、many-to-one的关系模型来描述。

--以下是类文件

//品目类型的实体类

public class M_ItemType {private string _id;private string _typeName;private IList _items;virtual public string Id{get { return _id; }set { _id = value; }}virtual public string TypeName{get { return _typeName; }set { _typeName = value; }}virtual public IList Items{get{if (_items == null){_items = new ArrayList();}return _items;}set { _items = value; }} }

//品目的实体类
public class M_Item {private string _id;private string _itemName;private M_ItemType _itemtype;private M_ItemStand _itemstand;private IList _itemDetails;virtual public string Id{get { return _id; }set { _id = value; }}virtual public string ItemName{get { return _itemName; }set { _itemName = value; }}//品目类型表的主键作为品目表的外键virtual public M_ItemType ItemType{get { return _itemtype; }set { _itemtype = value; }}//主键被产品标准表作为外键,一对一关联virtual public M_ItemStand ItemStand{get { return _itemstand; }set { _itemstand = value; }}//主键被产品明细表作为外键,一对多关联virtual public IList ItemDetails{get { return _itemDetails; }set { _itemDetails = value; }} }

//品目标准的实体类
public class M_ItemStand {private string m_ID;private decimal m_DIA_MIN;private M_Item m_item;virtual public string Id{get { return m_ID; }set { m_ID = value; }}virtual public decimal DIA_MIN{get { return m_DIA_MIN; }set { m_DIA_MIN = value; }}//一对一外键关联virtual public M_Item Item{get { return m_item; }set { m_item = value; }} }

//品目明细的实体类
public class M_ItemDetail {private string m_serialNo;private M_Item m_item;virtual public string SerialNo{get { return m_serialNo; }set { m_serialNo = value; }}public virtual M_Item Item{get { return m_item; }set { m_item = value; }} }

--以下是映射文件：
//品目类型的XML文件
<?xml version="1.0" encoding="utf-8"?> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" schema="dbo"><class name="WareHouse.Entities.M_ItemType,WareHouse.Entities" table="M_Item_Type" ><id name="Id" column="Id" type="System.String"><generator class="assigned" /></id><property name="TypeName" column="Name" type="System.String" /><bag name="Items" table="M_Item" lazy="false"><key column="Type"/><one-to-many class="WareHouse.Entities.M_Item,WareHouse.Entities"/></bag></class> </hibernate-mapping>

//品目的XML文件
<?xml version="1.0" encoding="utf-8" ?> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" schema="dbo"><class name="WareHouse.Entities.M_Item,WareHouse.Entities" table="M_Item" ><id name="Id" column="Id" type="System.String"><generator class="native" /></id><property name="ItemName" column="Name" type="System.String" /><many-to-one name="ItemType" column="Type" class="WareHouse.Entities.M_ItemType,WareHouse.Entities" lazy="false" /><one-to-one name="ItemStand" class="WareHouse.Entities.M_ItemStand, WareHouse.Entities" property-ref="Item" /><bag name="ItemDetails" table="M_ItemDetail" lazy="true"><key column="ItemID"/><one-to-many class="WareHouse.Entities.M_ItemDetail,WareHouse.Entities"/></bag></class> </hibernate-mapping>

//品目标准的XML文件
<?xml version="1.0" encoding="utf-8" ?> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" schema="dbo"><class name="WareHouse.Entities.M_ItemStand,WareHouse.Entities" table="M_Item_Stand" ><id name="Id" column="Id" type="System.String"><generator class="native" /></id><property name="DIA_MIN" column="DIA_MIN" type="Decimal" /><many-to-one name="Item" column="ItemID" class="WareHouse.Entities.M_Item,WareHouse.Entities" unique="true" /></class> </hibernate-mapping>

//品目明细的XML文件
<?xml version="1.0" encoding="utf-8"?> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" schema="dbo"><class name="WareHouse.Entities.M_ItemDetail,WareHouse.Entities" table="M_ItemDetail" ><id name="MachineNo" column="MachineNo" type="System.String"><generator class="assigned" /></id><property name="SerialNo" column="SerialNo" type="System.String" /><many-to-one name="Item" column="ItemID" class="WareHouse.Entities.M_Item,WareHouse.Entities" /></class> </hibernate-mapping>

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！