c# - 在 C# 中更新 NHibernate 3.3 中的子级

Question

我一直在寻找如何更新父实体的子实体，但找不到符合我要求的东西。我正在使用数据 GridView 控件将这些子数据绑定(bind)到我的表单和数据集中。我需要能够知道数据网格中的哪些行被修改、删除和添加，这就是我需要将其传递给数据集的原因。

以下是我的父级和子级映射:

父级:Fees.hbm.xml

<class name="Fees" table="fees">
<id name="Id" column="id">
  <generator class="guid" />
</id>
<property name="Code" column="code" />
<property name="Description" column="description" />
<property name="Status" column="status" />
<bag name="FeesDetails" table="fees_lines" inverse="true" cascade="all">
  <key column="fees_id" />
  <one-to-many class="FeesLines" />
</bag>

子级:FeesLines.hbm.xml

<class name="FeesLines" table="fees_lines">
<id name="Id" column="id">
  <generator class="guid" />
</id>
<property name="FeesId" column="fees_id" type="System.Guid" insert="false" update="false" />
<property name="Description" column="description" />
<property name="Amount" column="amount" />

<many-to-one name="Fee" class="Fees" column="fees_id" />

我需要能够使用 NHibernate 更新我的子记录，那么该怎么做呢？

Answer 1

我找到了一种更新我的 child 记录的方法，我是这样做的:

public bool UpdateFees(string id, string code, string desc, DataSet details)
    {
        bool success = false;

        using (ITransaction transaction = Session.BeginTransaction())
        {
            try
            {
                Fees fees = (Fees)Session.Get("EnrollmentSystem.Domain.Fees", Guid.Parse(id));
                fees.Code = code;
                fees.Description = desc;

                if (details.HasChanges())
                {
                    if (details.HasChanges(DataRowState.Added))
                    {
                        DataSet tempDataSet = details.GetChanges(DataRowState.Added);
                        foreach (DataRow row in tempDataSet.Tables[0].Rows)
                        {
                            FeesLines lines = new FeesLines();
                            lines.Fee = fees;
                            lines.Id = Guid.NewGuid();
                            lines.Description = row["Description"].ToString();
                            lines.Amount = (row["Amount"].ToString() == "") ? 0 : Convert.ToDecimal(row["Amount"].ToString());
                            fees.FeesDetails.Add(lines);
                            Session.Save(lines);
                        }
                    }

                    if (details.HasChanges(DataRowState.Modified))
                    {
                        DataSet editedSet = details.GetChanges(DataRowState.Modified);
                        foreach (DataRow row in editedSet.Tables[0].Rows)
                        {
                            var item = (from f in fees.FeesDetails
                                        where f.Id.Equals(Guid.Parse(row["Id"].ToString()))
                                        select f).SingleOrDefault();
                            if (item != null)
                            {
                                item.Description = row["Description"].ToString();
                                item.Amount = Convert.ToDecimal(row["Amount"].ToString());
                                Session.SaveOrUpdate(item);
                            }
                        }
                    }

                    if (details.HasChanges(DataRowState.Deleted))
                    {
                        DataSet deleted = details.GetChanges(DataRowState.Deleted);

                        for (int row = 0; row < deleted.Tables[0].Rows.Count; row++ )
                        {
                            var item = (from f in fees.FeesDetails
                                        where f.Id.Equals(Guid.Parse(deleted.Tables[0].Rows[row][0, DataRowVersion.Original].ToString()))
                                        select f).SingleOrDefault();
                            if (item != null)
                            {
                                fees.FeesDetails.Remove(item);
                            }
                        }
                    }
                }

                Session.SaveOrUpdate(fees);

                transaction.Commit();
                success = transaction.WasCommitted;
            }
            catch (Exception ex)
            {
                transaction.Rollback();
                throw;
            }
        }

        return success;
    }

我创建了一个函数，在其中传递父数据的新值，并传递保存新的/修改的/删除的子数据集的 DataSet。