public int AddItem(RMARevertInfo oParam) { TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { foreach (int registerSysNo in oParam.ItemHash.Keys) { RMARevertItemInfo oRevertItem = new RMARevertItemInfo(); oRevertItem.RegisterSysNo = registerSysNo; oRevertItem.RevertSysNo = oParam.SysNo; //��Register�ֿ��д��RMA_Revert_Item int revertStockSysNo = AppConst.IntNull; DataRow regdr = RMARegisterManager.GetInstance().GetRegisterRow(registerSysNo); revertStockSysNo = Util.TrimIntNull(regdr["RevertStockSysNo"]); oRevertItem.StockSysNo = Util.TrimIntNull(revertStockSysNo); this.InsertRevertItem(oRevertItem); } scope.Complete(); return oParam.SysNo; } }
public void InsertRevertItem(RMARevertItemInfo oInfo) { new RMARevertDac().InsertRevertItem(oInfo); }
public int InsertRevertItem(RMARevertItemInfo oParam) { string sql = @"INSERT INTO RMA_Revert_Item ( RevertSysNo, RegisterSysNo, StockSysNo ,Cost ) VALUES ( @RevertSysNo, @RegisterSysNo, @StockSysNo ,@Cost );set @SysNo = SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int,4); SqlParameter paramRevertSysNo = new SqlParameter("@RevertSysNo", SqlDbType.Int,4); SqlParameter paramRegisterSysNo = new SqlParameter("@RegisterSysNo", SqlDbType.Int,4); SqlParameter paramStockSysNo = new SqlParameter("@StockSysNo", SqlDbType.Int,4); SqlParameter paramCost = new SqlParameter("@Cost",SqlDbType.Decimal,9); paramSysNo.Direction = ParameterDirection.Output; if ( oParam.SysNo != AppConst.IntNull) paramSysNo.Value = oParam.SysNo; else paramSysNo.Value = System.DBNull.Value; if ( oParam.RevertSysNo != AppConst.IntNull) paramRevertSysNo.Value = oParam.RevertSysNo; else paramRevertSysNo.Value = System.DBNull.Value; if ( oParam.RegisterSysNo != AppConst.IntNull) paramRegisterSysNo.Value = oParam.RegisterSysNo; else paramRegisterSysNo.Value = System.DBNull.Value; if ( oParam.StockSysNo != AppConst.IntNull) paramStockSysNo.Value = oParam.StockSysNo; else paramStockSysNo.Value = System.DBNull.Value; if (oParam.Cost != AppConst.DecimalNull) paramCost.Value = oParam.Cost; else paramCost.Value = System.DBNull.Value; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramRevertSysNo); cmd.Parameters.Add(paramRegisterSysNo); cmd.Parameters.Add(paramStockSysNo); cmd.Parameters.Add(paramCost); return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo); }