private double remaining_amount(Oracle.DataAccess.Client.OracleConnection conn)
{
if (Request.Params["Admin"] == "YES")
{
return(0);
}
string sSQL = "select pkg_trn_budget.total_cushion_budget_remaining(" + ViewState["Employee_Number"].ToString() + "," + ViewState["App_Processing_Year"].ToString() + ") from dual";
Oracle.DataAccess.Client.OracleCommand cmd =
new Oracle.DataAccess.Client.OracleCommand(sSQL, conn);
object obj = null;
try
{
obj = cmd.ExecuteScalar();
}
finally
{
cmd.Dispose();
}
double dblValue;
try
{
dblValue = Convert.ToDouble(obj.ToString());
}
catch
{
dblValue = 0;
}
return(dblValue);
}
//有返回值的SQL执行
public object ExecuteScalar(string cmdText)
{
cmdText = SqlTransfer(cmdText);
object retVal = null;
using (Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(connStr))
{
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand(cmdText, conn);
cmd.CommandType = CommandType.Text;
try
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
retVal = cmd.ExecuteScalar();
}
catch (Exception exp)
{
LogWriter.Error(exp, cmdText);
//retVal = (object)exp.Message;
throw exp;
}
finally
{
conn.Close();
}
}
return(retVal);
}
public void InsertRecord(string SQLStatement)
{
if (SQLStatement.Length > 0)
{
if (connOracle.State.ToString().Equals("Open"))
{
sqlCommandOracle =
new Oracle.DataAccess.Client.OracleCommand(SQLStatement, connOracle);
sqlCommandOracle.ExecuteScalar();
}
}
}
/// <summary>
/// execute a sql statement, return an Int64.
/// </summary>
public long ExecuteScalar(string sql)
{
using (XSqlCommand cmd = new XSqlCommand(sql, Conn))
{
object oResult = cmd.ExecuteScalar();
Assert.IsNotNull("Expecting result, instead got null. (sql=" + sql + ")");
Assert.IsInstanceOfType(typeof(long), oResult, "Expecting 'long' result from query " + sql + ", instead got type " + oResult.GetType());
return (long)oResult;
}
}
