public static object ExecuteScalar(string sql, SqlParams[] param1, Trx trx) { System.Data.SqlClient.SqlParameter[] param = GetSqlParameter(param1); //Trx trx = trxName == null ? null : Trx.Get(trxName, true); if (trx != null) { return(trx.ExecuteScalar(sql, param, trx)); } else { return(VAdvantage.SqlExec.ExecuteQuery.ExecuteScalar(sql, param)); } }