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));
}
public static int Save(this DBModel dbmodel, string tablename, string seq, OracleTransaction trans = null)
{
string sql = Common_DB2.GetInertSqlCache(dbmodel, tablename, seq);
BILBasic.Basing.DbFactory dbFactory = new BILBasic.Basing.DbFactory(BILBasic.Basing.DbFactory.DbFactoryType.SQLSERVER);
if (trans != null)
{
return(dbFactory.ExecuteNonQuery(trans, System.Data.CommandType.Text, sql, null));
//return OracleDBPoolHelper.ExecuteNonQuery(trans, System.Data.CommandType.Text, sql, null);
}
return(dbFactory.ExecuteNonQuery(System.Data.CommandType.Text, sql, null));
//return OracleDBPoolHelper.ExecuteNonQuery(System.Data.CommandType.Text, sql, null);
}