コード例 #1
0
        public LastContent getSuggestion()
        {
            LastContent lastContentObj = null;

            try
            {
                DataTable     lastContents = new DataTable();
                var           sql          = "SELECT * FROM Suggestion";
                SQLiteCommand command      = new SQLiteCommand(sql, m_dbConnection);
                lastContents.Load(command.ExecuteReader());
                command.Dispose();
                lastContentObj = new LastContent();

                for (int i = 0; i < lastContents.Rows.Count; i++)
                {
                    var productObj = new Pedia();
                    var type       = lastContents.Rows[i]["type"].ToString();

                    productObj.nid           = int.Parse(lastContents.Rows[i]["nid"].ToString());
                    productObj.picture       = lastContents.Rows[i]["picture"].ToString();
                    productObj.local_picture = lastContents.Rows[i]["local_picture"].ToString();
                    productObj.title         = lastContents.Rows[i]["title"].ToString();
                    productObj.url           = lastContents.Rows[i]["url"].ToString();


                    if (type == "product_kit")
                    {
                        if (lastContentObj.product_kit == null)
                        {
                            lastContentObj.product_kit = new List <Pedia>();
                        }
                        lastContentObj.product_kit.Add(productObj);
                    }
                    else if (type == "product")
                    {
                        if (lastContentObj.product == null)
                        {
                            lastContentObj.product = new List <Pedia>();
                        }
                        lastContentObj.product.Add(productObj);
                    }
                    else
                    {
                        if (lastContentObj.college == null)
                        {
                            lastContentObj.college = new List <Pedia>();
                        }
                        lastContentObj.college.Add(productObj);
                    }
                }
                return(lastContentObj);
            }
            catch (Exception e)
            {
                return(lastContentObj);
            }
        }
コード例 #2
0
        public Bookmark getBookmark()
        {
            Bookmark bookmarks = null;

            try
            {
                DataTable     lastContents = new DataTable();
                var           sql          = "SELECT * FROM Bookmark";
                SQLiteCommand command      = new SQLiteCommand(sql, m_dbConnection);
                lastContents.Load(command.ExecuteReader());
                command.Dispose();
                bookmarks = new Bookmark();

                for (int i = 0; i < lastContents.Rows.Count; i++)
                {
                    var pediaObj = new Pedia();
                    var type     = lastContents.Rows[i]["type"].ToString();

                    pediaObj.nid           = int.Parse(lastContents.Rows[i]["nid"].ToString());
                    pediaObj.picture       = lastContents.Rows[i]["picture"].ToString();
                    pediaObj.local_picture = lastContents.Rows[i]["local_picture"].ToString();
                    pediaObj.title         = lastContents.Rows[i]["title"].ToString();
                    pediaObj.url           = lastContents.Rows[i]["url"].ToString();

                    switch (type)
                    {
                    case "article":
                        if (bookmarks.article == null)
                        {
                            bookmarks.article = new List <Pedia>();
                        }
                        bookmarks.article.Add(pediaObj);
                        break;

                    case "blog":
                        if (bookmarks.blog == null)
                        {
                            bookmarks.blog = new List <Pedia>();
                        }
                        bookmarks.blog.Add(pediaObj);
                        break;

                    case "college":
                        if (bookmarks.college == null)
                        {
                            bookmarks.college = new List <Pedia>();
                        }
                        bookmarks.college.Add(pediaObj);
                        break;

                    case "designteam":
                        if (bookmarks.designteam == null)
                        {
                            bookmarks.designteam = new List <Pedia>();
                        }
                        bookmarks.designteam.Add(pediaObj);
                        break;

                    case "education":
                        if (bookmarks.education == null)
                        {
                            bookmarks.education = new List <Pedia>();
                        }
                        bookmarks.education.Add(pediaObj);
                        break;

                    case "film":
                        if (bookmarks.film == null)
                        {
                            bookmarks.film = new List <Pedia>();
                        }
                        bookmarks.film.Add(pediaObj);
                        break;

                    case "gallerynew":
                        if (bookmarks.gallerynew == null)
                        {
                            bookmarks.gallerynew = new List <Pedia>();
                        }
                        bookmarks.gallerynew.Add(pediaObj);
                        break;

                    case "pedia":
                        if (bookmarks.pedia == null)
                        {
                            bookmarks.pedia = new List <Pedia>();
                        }
                        bookmarks.pedia.Add(pediaObj);
                        break;

                    case "podcast":
                        if (bookmarks.podcast == null)
                        {
                            bookmarks.podcast = new List <Pedia>();
                        }
                        bookmarks.podcast.Add(pediaObj);
                        break;

                    case "product":
                        if (bookmarks.product == null)
                        {
                            bookmarks.product = new List <Pedia>();
                        }
                        bookmarks.product.Add(pediaObj);
                        break;

                    case "product_kit":
                        if (bookmarks.product_kit == null)
                        {
                            bookmarks.product_kit = new List <Pedia>();
                        }
                        bookmarks.product_kit.Add(pediaObj);
                        break;

                    case "publication":
                        if (bookmarks.publication == null)
                        {
                            bookmarks.publication = new List <Pedia>();
                        }
                        bookmarks.publication.Add(pediaObj);
                        break;
                    }
                }
                return(bookmarks);
            }
            catch (Exception e)
            {
                return(bookmarks);
            }
        }