/// <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;
//}
}
