上下導航

 public string[] getPreNextID( string tableName ,string recID )
        {
           string[] retIDAry = new string[2] { "",""};
            try
            {
                //如果要跨資料庫請進行相應的修改
                if (recID == "-1") return retIDAry;
                string mySql = " select ( SELECT max(ID) FROM " + tableName + " where id < '" + recID + "') as preID,( SELECT min(ID) FROM " + tableName + " where id > '" + recID + "' ) as nextID ";
                IDbPaladin dbp = baseProcess.getDbPaladin();//todo:orachange
                DataView dv = dbp.runSqlQuery(mySql);
                if ( dv!=null && dv.Count >0 )
                {
                    retIDAry[0] = dv[0][0].ToString();//preID
                    retIDAry[1] = dv[0][1].ToString();//nextID
                }                
            }
            catch (Exception )
            {
            }
            return retIDAry;
        }