/// <summary> /// Get Value from sql /// </summary> /// <param name="trxName">trx</param> /// <param name="sql">sql</param> /// <param name="int_param1">parameter 1</param> /// <returns>value or -1</returns> public static int ExecuteQuery(String sql, SqlParams[] param1, Trx trx, bool error) { //try //{ System.Data.SqlClient.SqlParameter[] param = GetSqlParameter(param1); //Trx trx = trxName == null ? null : Trx.Get(trxName, true); if (trx != null) { return(trx.ExecuteNonQuery(sql, param, trx)); } else { return(VAdvantage.SqlExec.ExecuteQuery.ExecuteNonQuery(sql, param)); } //} //catch (System.Data.Common.DbException ex) //{ // if (ignoreError) // { // log.Log(Level.WARNING, trxName, ex.Message); // } // else // { // log.Log(Level.SEVERE, trxName, ex); // log.SaveError("DBExecuteError", ex); // } // return -1; //} //catch (Exception ex) //{ // log.Severe(ex.ToString()); // //log.SaveError(ex.ToString()); // return -1; //} }