private void map(PMPaymentInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.PayDate = Util.TrimDateNull(tempdr["PayDate"]);
oParam.PMSysNo = Util.TrimIntNull(tempdr["PMSysNo"]);
oParam.PayAmt = Util.TrimDecimalNull(tempdr["PayAmt"]);
oParam.StockAmt = Util.TrimDecimalNull(tempdr["StockAmt"]);
oParam.DateStamp = Util.TrimDateNull(tempdr["DateStamp"]);
}
public void Insert(PMPaymentInfo oParam)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
new PMPaymentDac().Insert(oParam);
scope.Complete();
}
}
public int Insert(PMPaymentInfo oParam)
{
string sql = @"INSERT INTO PMPayment
(
PayDate, PMSysNo, PayAmt, StockAmt,
DateStamp
)
VALUES (
@PayDate, @PMSysNo, @PayAmt, @StockAmt,
@DateStamp
);set @SysNo = SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramPayDate = new SqlParameter("@PayDate", SqlDbType.DateTime);
SqlParameter paramPMSysNo = new SqlParameter("@PMSysNo", SqlDbType.Int, 4);
SqlParameter paramPayAmt = new SqlParameter("@PayAmt", SqlDbType.Decimal, 9);
SqlParameter paramStockAmt = new SqlParameter("@StockAmt", SqlDbType.Decimal, 9);
SqlParameter paramDateStamp = new SqlParameter("@DateStamp", SqlDbType.DateTime);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.PayDate != AppConst.DateTimeNull)
{
paramPayDate.Value = oParam.PayDate;
}
else
{
paramPayDate.Value = System.DBNull.Value;
}
if (oParam.PMSysNo != AppConst.IntNull)
{
paramPMSysNo.Value = oParam.PMSysNo;
}
else
{
paramPMSysNo.Value = System.DBNull.Value;
}
if (oParam.PayAmt != AppConst.DecimalNull)
{
paramPayAmt.Value = oParam.PayAmt;
}
else
{
paramPayAmt.Value = System.DBNull.Value;
}
if (oParam.StockAmt != AppConst.DecimalNull)
{
paramStockAmt.Value = oParam.StockAmt;
}
else
{
paramStockAmt.Value = System.DBNull.Value;
}
if (oParam.DateStamp != AppConst.DateTimeNull)
{
paramDateStamp.Value = oParam.DateStamp;
}
else
{
paramDateStamp.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramPayDate);
cmd.Parameters.Add(paramPMSysNo);
cmd.Parameters.Add(paramPayAmt);
cmd.Parameters.Add(paramStockAmt);
cmd.Parameters.Add(paramDateStamp);
return(SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo));
}
