直接取oracle的sequence的方法
private void SetTenpoGroup()
{
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.Append( "INSERT INTO \n ");
sqlBuilder.Append( "SMD_M_TENPOGROUP \n ");
sqlBuilder.Append( "( \n ");
sqlBuilder.Append( "LOGSEQ\n ");
sqlBuilder.Append( ") \n ");
sqlBuilder.Append( "VALUES \n ");
sqlBuilder.Append( "( \n ");
sqlBuilder.Append( ":LOGSEQ\n ");
sqlBuilder.Append( ") \n ");
Hashtable param = new Hashtable();
param.Add( "TENPOGROUPCD ", "6 ");
using (SmoodsBatchOracle oracle = new SmoodsBatchOracle())
{
oracle.Open();
oracle.BeginTransaction();
try
{
int ret = oracle.ExecuteNonQuery(
sqlBuilder.ToString(),