ORM设计的软件中,对数据保存处理??高手请进??

[jsjkhanwei]

我在用ORM过程有一事不明白,请高手指导?
如:我做了一张采购入库单. 如果用ORM把数据保后的同时,要求把库存给增加,并把合给减少,这三个步骤,如果执行中间时出错呢?第一步的采购入库单,已被保存到数据库了,而后,两步没有执行,在以前我用事务处理,可以把这三个放在同一个事务中,如果有一个失败,数据会被自动恢复.如今在ORM中,如何实现?????

[jsjkhanwei]

如:我做了一张采购入库单. 如果用ORM把数据保后的同时,要求把库存增加,并把合同有采购数量同时减少,这三个步骤,如果执行时,中间有一个出错?第一步的采购入库单,已被保存到数据库了,而后,两步没有执行,在以前我用事务处理,可以把这三个放在同一个事务中,如果有一个失败,数据会被自动恢复.如今在ORM中,如何实现?????

[cuike519]

还是用事务啊...

[cuike519]

至于具体怎么用要看你的ORM框架如何支持了。

[wuyq11]

还是要使用事务处理，如LINQ,spring.net

[jsjkhanwei]

在框加上如何添加事务处理???在.NET下有什么好的ORM工具?

[ourola]

依然用事务..事务有很多种啊..

       /// <summary>
        /// 保存明细和单据
        /// </summary>
        /// <param name="dt">要保存的DataTable</param>
        /// <param name="hash">包含insert,update,delete的Hashtable</param>
        /// <returns>功能T,失败F</returns>
        public bool UpdateDetailAndBill(DataTable dt, Hashtable hash)
        {
            if (trans == null)
            {
                trans = conn.BeginTransaction();
                _billCommand.Transaction = trans;
            }

            SqlCommand _deleteCommand = new SqlCommand(hash["delete"].ToString(), conn, trans);
            _deleteCommand.CommandType = CommandType.StoredProcedure;

            SqlCommand insertCommand = new SqlCommand(hash["insert"].ToString(), conn, trans);
            insertCommand.CommandType = CommandType.StoredProcedure;

            DataMapping dmaping = new DataMapping(conn);
            _detailCommand = new SqlCommand(hash["update"].ToString(), conn, trans);
            _detailCommand.CommandType = CommandType.StoredProcedure;
            SqlDataAdapter da = new SqlDataAdapter();

            _detailCommand = dmaping.getStroeProcedureParamsByName(_detailCommand);
            _deleteCommand = dmaping.getStroeProcedureParamsByName(_deleteCommand);
            insertCommand = dmaping.getStroeProcedureParamsByName(insertCommand);

            da.InsertCommand = insertCommand;
            da.UpdateCommand = _detailCommand;
            da.DeleteCommand = _deleteCommand;
            da.InsertCommand.UpdatedRowSource = UpdateRowSource.OutputParameters;
            da.UpdateCommand.UpdatedRowSource = UpdateRowSource.OutputParameters;
            da.DeleteCommand.UpdatedRowSource = UpdateRowSource.OutputParameters;
            da.UpdateBatchSize = 1;
            try
            {
                //_deleteCommand.ExecuteNonQuery();
                int j = _billCommand.ExecuteNonQuery();
                int i = da.Update(dt);
                dt.AcceptChanges();
                trans.Commit();();//如果成功,提交事务
                return true;
            }
            catch (Exception ex)
            {
                trans.Rollback();//如果失败,回滚事务
                throw ex;
            }
            finally
            {
                conn.Close();
            }
        }

[laomeng520]

学习了

[zhou5157]

存储过程

[ladyuncle]

事务！

[talen_lu]

[Quote=引用 6 楼 ourola 的回复:]
依然用事务..事务有很多种啊..
C# code///<summary>/// 保存明细和单据///</summary>///<param name="dt">要保存的DataTable</param>///<param name="hash">包含insert,update,delete的Hashtable</param>///<returns>功能T,失败F</returns>publicbool UpdateDetailAndBill(DataTable dt, Hashtable hash)
{if (trans==null)
{
trans= conn.BeginTransaction();
_billCommand.Transaction= trans;
}

SqlCommand _deleteCommand=new SqlCommand(hash["delete"].ToString(), conn, trans);
_deleteCommand.CommandType= CommandType.StoredProcedure;

SqlCommand insertCommand=new SqlCommand(hash["insert"].ToString(), conn, trans);
insertCommand.CommandType= CommandType.StoredProcedure;

DataMapping dmaping=new DataMapping(conn);
_detailCommand=new SqlCommand(hash["update"].ToString(), conn, trans);
_detailCommand.CommandType= CommandType.StoredProcedure;
SqlDataAdapter da=new SqlDataAdapter();

_detailCommand= dmaping.getStroeProcedureParamsByName(_detailCommand);
_deleteCommand= dmaping.getStroeProcedureParamsByName(_deleteCommand);
insertCommand= dmaping.getStroeProcedureParamsByName(insertCommand);

da.InsertCommand= insertCommand;
da.UpdateCommand= _detailCommand;
da.DeleteCommand= _deleteCommand;
da.InsertCommand.UpdatedRowSource= UpdateRowSource.OutputParameters;
da.UpdateCommand.UpdatedRowSource= UpdateRowSource.OutputParameters;
da.DeleteCommand.UpdatedRowSource= UpdateRowSource.OutputParameters;
da.UpdateBatchSize=1;try
{//_deleteCommand.ExecuteNonQuery();int j= _billCommand.ExecuteNonQuery();int i= da.Update(dt);
dt.AcceptChanges();
trans.Commit();();//如果成功,提交事务returntrue;
}catch (Exception ex)
{
trans.Rollback();//如果失败,回滚事务throw ex;
}finally
{
conn.Close();
}
}
[/Quote]
对sql可能就成功，对oracole db2会出错

[Taiyangchen]

[Quote=引用 4 楼 wuyq11 的回复:]
还是要使用事务处理，如LINQ,spring.net
[/Quote]up

[aspdiannet]

存储过程
。。。

[acqy]

支持C#的ORM？常见的就是NHibernate，它可以通过session来获得transaction对象，从而实现事务处理。
其次就是基于NHibernate的Castle Active Record。严格的说它并不能算是ORM，虽然有保存、读取数据的能力。因为它把业务对象和持久化的技术细节混在一起了。
再就是可以使用.NET 4.0的Entity Framework，在Entity Framework中，事务会由Entity Framework控制，一般情况下开发人员可以不用太担心事务的问题。

[acqy]

贴一段基于NHibernate框架所实现的事务utility类以作参考：

    /// <summary>
    /// Represents the NHibernate version of the transaction context, which is
    /// the default transaction context implementation used by Apworks Server Application.
    /// </summary>
    public sealed class DbTransactionContext : TransactionContextBase
    {
        #region Private Fields
        /// <summary>
        /// The <see cref="NHibernate.ITransaction"/> object that handles transactions.
        /// </summary>
        private ITransaction transaction;

        #endregion

        #region Constructors
        /// <summary>
        /// Constructs the transaction context by using the default isolation level (Unspecified level).
        /// </summary>
        public DbTransactionContext() : base() { }

        /// <summary>
        /// Constructs the transaction context by using the given isolation level.
        /// </summary>
        /// <param name="isolationLevel">The isolation level which is used for initializing the 
        /// transaction context.</param>
        public DbTransactionContext(IsolationLevel isolationLevel) : base(isolationLevel) { }
        #endregion

        public ISession Session { get { return DatabaseSessionFactory.Instance.Session; } }

        #region ITransactionContext Members
        /// <summary>
        /// Begins a transaction.
        /// </summary>
        public override void BeginTransaction()
        {
            transaction = DatabaseSessionFactory.Instance.Session.BeginTransaction(this.isolationLevel);
        }
        /// <summary>
        /// Commits the transaction.
        /// </summary>
        public override void Commit()
        {
            transaction.Commit();
        }
        /// <summary>
        /// Rolls back the transaction.
        /// </summary>
        public override void Rollback()
        {
            transaction.Rollback();
        }
        #endregion

        #region IDisposable Members
        /// <summary>
        /// Disposes the transaction context.
        /// </summary>
        public override void Dispose()
        {
            // Disposes the transaction object.
            transaction.Dispose();
            // If the session used by the transaction context exists and is still
            // open, close the session. This ensures that when next time the client
            // access the database, new session will be opened.
            ISession databaseSession = DatabaseSessionFactory.Instance.Session;
            if (databaseSession != null && databaseSession.IsOpen)
            {
                //databaseSession.Flush();
                databaseSession.Close();
            }
        }

        #endregion

使用：

// 此处将获得一个DbTransactionContext的实例
using (ITransactionContext transContext = TransactionContextManager.GetContext())
{
   try
   {
      transContext.BeginTransaction();
      // ... 你的逻辑
      transContext.Commit()
   }
   catch
   {
      transContext.Rollback();
      throw;
   }
}

[qqselliter]

java 的一个翻版
问问java同志们就知道了。

[cuike519]

看看Hibernate...

.NET版本的叫NHibernate