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);
}
