예제 #1
0
        public static ArrayList GetWebBookMarks(string serverPath,string clientID, MySqlWrapper dbConn)
        {
            ArrayList webBookmarks = new ArrayList();
            try
            {
                string sql = "select bookmark_title,bookmark_url from ctool_bookmark where bookmark_ownerid = " + clientID;
                ArrayList recordset = dbConn.Execute(sql);
                foreach(ArrayList record in recordset)
                {
                    WebBookMark entry = new WebBookMark((string)record[0],(string)record[1]);
                    webBookmarks.Add(entry);
                }

                sql = "select bookmark_title,bookmark_url from ctool_bookmark,ctool_bmtouser where bookmark_id = bmtouser_bookmark_id AND bmtouser_mid = " + clientID;
                recordset = dbConn.Execute(sql);
                foreach(ArrayList record in recordset)
                {
                    WebBookMark entry = new WebBookMark((string)record[0],(string)record[1]);
                    webBookmarks.Add(entry);
                }

            }
            catch(Exception ee)
            {
            //	MessageBox.Show(ee.Message);
            }
            return webBookmarks;
        }
예제 #2
0
        public static ArrayList GetWebBookMarks(string serverPath, string clientID, MySqlWrapper dbConn)
        {
            ArrayList webBookmarks = new ArrayList();

            try
            {
                string    sql       = "select bookmark_title,bookmark_url from ctool_bookmark where bookmark_ownerid = " + clientID;
                ArrayList recordset = dbConn.Execute(sql);
                foreach (ArrayList record in recordset)
                {
                    WebBookMark entry = new WebBookMark((string)record[0], (string)record[1]);
                    webBookmarks.Add(entry);
                }

                sql       = "select bookmark_title,bookmark_url from ctool_bookmark,ctool_bmtouser where bookmark_id = bmtouser_bookmark_id AND bmtouser_mid = " + clientID;
                recordset = dbConn.Execute(sql);
                foreach (ArrayList record in recordset)
                {
                    WebBookMark entry = new WebBookMark((string)record[0], (string)record[1]);
                    webBookmarks.Add(entry);
                }
            }
            catch (Exception ee)
            {
                //	MessageBox.Show(ee.Message);
            }
            return(webBookmarks);
        }