public static int UpdateSql(this DBModel dbmodel, string sql, OracleTransaction trans = null)
{
if (trans != null)
{
return(OracleDBPoolHelper.ExecuteNonQuery(trans, System.Data.CommandType.Text, sql, null));
}
return(OracleDBPoolHelper.ExecuteNonQuery(System.Data.CommandType.Text, sql, null));
}
public static int ExeNullQuery(this string sql, OracleTransaction trans = null)
{
if (trans != null)
{
return(OracleDBPoolHelper.ExecuteNonQuery(trans, System.Data.CommandType.Text, sql, null));
}
return(OracleDBPoolHelper.ExecuteNonQuery(System.Data.CommandType.Text, sql, null));
}
public static int Update(this DBModel dbmodel, string tablename, string keyname, OracleTransaction trans = null)
{
string sql = Common_DB2.GetUpdateSqlCache(dbmodel, tablename, keyname);
if (trans != null)
{
return(OracleDBPoolHelper.ExecuteNonQuery(trans, System.Data.CommandType.Text, sql, null));
}
return(OracleDBPoolHelper.ExecuteNonQuery(System.Data.CommandType.Text, sql, null));
}
