新公司的事物管理

来源：互联网发布：诺顿杀毒知乎编辑：程序博客网时间：2024/04/27 17:37

                //#region 开始事务
                DbTransaction sqltrans = SqlExec.BeginTransaction(SystemType.WMS);
                foreach (OutStrategySet strategy in StrategySet)
                {
                    if (strategy.IsExit == 0)
                    {
                        if (!WMS_OutStrategy.InsertWMS_OutStrategySet(strategy,sqltrans))
                        {
                            SqlExec.endTransactionRollback(sqltrans);
                            SS += "插入失败";
                            return SS;
                        }
                    }
                    else
                    {
                        if (!WMS_OutStrategy.UpdateWMS_OutStrategySet(strategy,sqltrans))
                        {
                            SqlExec.endTransactionRollback(sqltrans);
                            SS += "修改失败";
                            return SS;
                        }
                    }

                }

                //#endregion

                //#region 提交事务

SqlExec.endTransactionCommit(sqltrans);