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