public static int GetMaxID(string FieldName, string TableName)
{
string strsql = "select max (to_number(" + FieldName + "))+1 from " + TableName;
object obj = OracleDBHelperSQL.GetSingle(strsql);
if (obj == null)
{
return(1);
}
else
{
return(int.Parse(obj.ToString()));
}
}
public static bool Exists(string strSql, params OracleParameter[] cmdParms)
{
object obj = OracleDBHelperSQL.GetSingle(strSql, cmdParms);
int cmdresult;
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
cmdresult = 0;
}
else
{
cmdresult = int.Parse(obj.ToString());
}
if (cmdresult == 0)
{
return(false);
}
else
{
return(true);
}
}