oracle 新增自增字段,SQL server、Oracle中拿到新增列时的自增字段值

#region 增删改数据访问

///

///增删改数据访问///

/// 语句

/// 参数

///

public static int EditData(string CommandText, OracleParameter[] OraParams = null)

{int num = 0;try{string connstr =ShopDal.conntion();

OracleConnection conn= newOracleConnection(connstr);if (conn.State ==ConnectionState.Closed)

{

conn.Open();

}

OracleCommand command=conn.CreateCommand();

command.Connection=conn;

command.CommandText=CommandText;for (int i = 0; i < OraParams.Length; i++)

{

command.Parameters.Add(OraParams[i]);

}

num=command.ExecuteNonQuery();

command.Parameters.Clear();

conn.Close();

}catch(Exception ex)

{throw;

}returnnum;

}#endregion

#region 获取主键ID

///

///获取主键ID///

///

public static stringMarkSenumber()

{string Senumber = string.Empty;try{string connstr =ShopDal.conntion();

OracleConnection conn= newOracleConnection(connstr);if (conn.State ==ConnectionState.Closed)

{

conn.Open();

}

OracleCommand command=conn.CreateCommand();

command.Connection=conn;

command.CommandText= "Select WEB_FEEDBACK_SEQ.nextval from dual";

Senumber=command.ExecuteScalar().ToString(); ;

command.Parameters.Clear();

conn.Close();

}catch(Exception ex)

{throw;

}returnSenumber;

}#endregion

#region 添加

public static int SubmitFeed_Methods(stringTITLE)

{//获取主键ID

string Senumber =MarkSenumber();

OracleParameter[] OraParams= new OracleParameter[2];

OraParams[0] = new OracleParameter(":ID", OracleDbType.Varchar2, 25);

OraParams[1] = new OracleParameter(":TITLE", OracleDbType.Int32);

OraParams[0].Value =Senumber;

OraParams[1].Value =Convert.ToInt32(TITLE);string CommandText = @"insert into web_feedback(ID, TITLE) values(:ID,:TITLE)";int num =EditData(CommandText, OraParams);returnnum;

}#endregion