public ActionResult Index()
        {
            IndexInfo info = new IndexInfo();

            using (var db0 = getDB0())
            {
                #region banner
                info.banners = db0.Banner.Where(x => !x.i_Hide & x.i_Lang == System.Globalization.CultureInfo.CurrentCulture.Name).OrderByDescending(x => x.sort)
                               .Select(x => new m_Banner()
                {
                    banner_id   = x.banner_id,
                    banner_name = x.banner_name
                }).ToList();
                foreach (var i in info.banners)
                {
                    i.imgsrc = GetImg(i.banner_id.ToString(), "Banner", "Active", "BannerData", null);
                }
                #endregion
                if (System.Globalization.CultureInfo.CurrentCulture.Name == "ja-JP")
                {
                    #region get other img
                    info.NewProuctImgSrc = GetImg("IndexImg", "NewProduct_jp", "Active", "ParmData", null);
                    info.About1ImgSrc    = GetImg("IndexImg", "About1_jp", "Active", "ParmData", null);
                    info.About2ImgSrc    = GetImg("IndexImg", "About2_jp", "Active", "ParmData", null);
                    info.NewsImgSrc      = GetImg("IndexImg", "EXHIBITION_jp", "Active", "ParmData", null);
                    info.SupportImgSrc   = GetImg("IndexImg", "SUPPORT_jp", "Active", "ParmData", null);
                    #endregion
                    #region get other url
                    var open = openLogic();
                    info.url_1 = (string)open.getParmValue(ParmDefine.url_1_jp);
                    info.url_2 = (string)open.getParmValue(ParmDefine.url_2_jp);
                    info.url_3 = (string)open.getParmValue(ParmDefine.url_3_jp);
                    info.url_4 = (string)open.getParmValue(ParmDefine.url_4_jp);
                    info.url_5 = (string)open.getParmValue(ParmDefine.url_5_jp);
                    #endregion
                }
                else
                {
                    #region get other img
                    info.NewProuctImgSrc = GetImg("IndexImg", "NewProduct", "Active", "ParmData", null);
                    info.About1ImgSrc    = GetImg("IndexImg", "About1", "Active", "ParmData", null);
                    info.About2ImgSrc    = GetImg("IndexImg", "About2", "Active", "ParmData", null);
                    info.NewsImgSrc      = GetImg("IndexImg", "EXHIBITION", "Active", "ParmData", null);
                    info.SupportImgSrc   = GetImg("IndexImg", "SUPPORT", "Active", "ParmData", null);
                    #endregion
                    #region get other url
                    var open = openLogic();
                    info.url_1 = (string)open.getParmValue(ParmDefine.url_1);
                    info.url_2 = (string)open.getParmValue(ParmDefine.url_2);
                    info.url_3 = (string)open.getParmValue(ParmDefine.url_3);
                    info.url_4 = (string)open.getParmValue(ParmDefine.url_4);
                    info.url_5 = (string)open.getParmValue(ParmDefine.url_5);
                    #endregion
                }
            }
            return(View("Index", info));
        }
        public ActionResult Index()
        {
            IndexInfo info = new IndexInfo();
            using (var db0 = getDB0())
            {
                #region banner
                info.banners = db0.Banner.Where(x => !x.i_Hide & x.i_Lang == System.Globalization.CultureInfo.CurrentCulture.Name).OrderByDescending(x => x.sort)
                                         .Select(x => new m_Banner()
                                         {
                                             banner_id = x.banner_id,
                                             banner_name = x.banner_name
                                         }).ToList();
                foreach (var i in info.banners)
                {
                    i.imgsrc = GetImg(i.banner_id.ToString(), "Banner", "Active", "BannerData", null);
                }
                #endregion
                if (System.Globalization.CultureInfo.CurrentCulture.Name == "ja-JP")
                {
                    #region get other img
                    info.NewProuctImgSrc = GetImg("IndexImg", "NewProduct_jp", "Active", "ParmData", null);
                    info.About1ImgSrc = GetImg("IndexImg", "About1_jp", "Active", "ParmData", null);
                    info.About2ImgSrc = GetImg("IndexImg", "About2_jp", "Active", "ParmData", null);
                    info.NewsImgSrc = GetImg("IndexImg", "EXHIBITION_jp", "Active", "ParmData", null);
                    info.SupportImgSrc = GetImg("IndexImg", "SUPPORT_jp", "Active", "ParmData", null);
                    #endregion
                    #region get other url
                    var open = openLogic();
                    info.url_1 = (string)open.getParmValue(ParmDefine.url_1_jp);
                    info.url_2 = (string)open.getParmValue(ParmDefine.url_2_jp);
                    info.url_3 = (string)open.getParmValue(ParmDefine.url_3_jp);
                    info.url_4 = (string)open.getParmValue(ParmDefine.url_4_jp);
                    info.url_5 = (string)open.getParmValue(ParmDefine.url_5_jp);
                    #endregion
                }
                else {
                    #region get other img
                    info.NewProuctImgSrc = GetImg("IndexImg", "NewProduct", "Active", "ParmData", null);
                    info.About1ImgSrc = GetImg("IndexImg", "About1", "Active", "ParmData", null);
                    info.About2ImgSrc = GetImg("IndexImg", "About2", "Active", "ParmData", null);
                    info.NewsImgSrc = GetImg("IndexImg", "EXHIBITION", "Active", "ParmData", null);
                    info.SupportImgSrc = GetImg("IndexImg", "SUPPORT", "Active", "ParmData", null);
                    #endregion
                    #region get other url
                    var open = openLogic();
                    info.url_1 = (string)open.getParmValue(ParmDefine.url_1);
                    info.url_2 = (string)open.getParmValue(ParmDefine.url_2);
                    info.url_3 = (string)open.getParmValue(ParmDefine.url_3);
                    info.url_4 = (string)open.getParmValue(ParmDefine.url_4);
                    info.url_5 = (string)open.getParmValue(ParmDefine.url_5);
                    #endregion
                }

            }
            return View("Index", info);
        }
        public ActionResult Index()
        {
            Page_Load();//人次計數
            IndexInfo info = new IndexInfo();

            using (var db0 = getDB0())
            {
                #region banner
                info.banners = db0.Banner.Where(x => !x.i_Hide).OrderByDescending(x => new { x.sort, x.banner_id })
                               .Select(x => new m_Banner()
                {
                    banner_id   = x.banner_id,
                    banner_name = x.banner_name,
                    banner_url  = x.banner_url
                }).ToList();
                foreach (var i in info.banners)
                {
                    i.imgsrc = GetImg(i.banner_id.ToString(), "Banner", "Active", "BannerData", null, false);
                }
                #endregion
                #region news
                info.news = db0.News.Where(x => !x.i_Hide).OrderByDescending(x => new { x.sort, x.day, x.news_id })
                            .Select(x => new m_News()
                {
                    news_id    = x.news_id,
                    day        = x.day,
                    news_title = x.news_title,
                    news_info  = x.news_info
                }).Take(3).ToList();
                #endregion
                #region banner
                info.brands = db0.Brand.Where(x => !x.i_Hide).OrderByDescending(x => new { x.sort, x.brand_id })
                              .Select(x => new m_Brand()
                {
                    brand_category_id = x.brand_category_id,
                    brand_id          = x.brand_id,
                    category_name     = x.BrandCategory.category_name,
                    brand_name        = x.brand_name
                }).ToList();
                foreach (var i in info.brands)
                {
                    i.imgsrc = GetImg(i.brand_id.ToString(), "Banner", "Active", "BrandData", null, true);
                }
                #endregion
                #region facebook
                var open = openLogic();
                info.facebook_url       = (string)open.getParmValue(ParmDefine.FacebookUrl);
                info.isClickIndex_Count = (int)open.getParmValue(ParmDefine.Count);
                #endregion
            }
            return(View("Index", info));
        }
 public ActionResult Index()
 {
     Page_Load();//人次計數
     IndexInfo info = new IndexInfo();
     using (var db0 = getDB0())
     {
         #region banner
         info.banners = db0.Banner.Where(x => !x.i_Hide).OrderByDescending(x => new { x.sort, x.banner_id })
                                  .Select(x => new m_Banner()
                                  {
                                      banner_id = x.banner_id,
                                      banner_name = x.banner_name,
                                      banner_url = x.banner_url
                                  }).ToList();
         foreach (var i in info.banners)
         {
             i.imgsrc = GetImg(i.banner_id.ToString(), "Banner", "Active", "BannerData", null, false);
         }
         #endregion
         #region news
         info.news = db0.News.Where(x => !x.i_Hide).OrderByDescending(x => new { x.sort, x.day, x.news_id })
                                  .Select(x => new m_News()
                                  {
                                      news_id = x.news_id,
                                      day = x.day,
                                      news_title = x.news_title,
                                      news_info = x.news_info
                                  }).Take(3).ToList();
         #endregion
         #region banner
         info.brands = db0.Brand.Where(x => !x.i_Hide).OrderByDescending(x => new { x.sort, x.brand_id })
                                  .Select(x => new m_Brand()
                                  {
                                      brand_category_id = x.brand_category_id,
                                      brand_id = x.brand_id,
                                      category_name = x.BrandCategory.category_name,
                                      brand_name = x.brand_name
                                  }).ToList();
         foreach (var i in info.brands)
         {
             i.imgsrc = GetImg(i.brand_id.ToString(), "Banner", "Active", "BrandData", null, true);
         }
         #endregion
         #region facebook
         var open = openLogic();
         info.facebook_url = (string)open.getParmValue(ParmDefine.FacebookUrl);
         info.isClickIndex_Count = (int)open.getParmValue(ParmDefine.Count);
         #endregion
     }
     return View("Index", info);
 }
        public ActionResult Index()
        {
            IndexInfo info = new IndexInfo();
            info.p_hot = new List<m_Product>();
            info.p_new = new List<m_Product>();
            info.p_top = new List<m_Product>();
            info.news = new List<m_News>();
            #region Get AllProductList
            using (var db0 = getDB0())
            {
                #region banner&firm
                info.banners = db0.Banner.Where(x => !x.i_Hide & x.type == (int)BannerType.banner).OrderByDescending(x => x.sort)
                                         .Select(x => new m_Banner()
                                         {
                                             banner_id = x.banner_id,
                                             banner_name = x.banner_name,
                                             show_name = x.show_name,
                                             style_string = x.style_string
                                         }).ToList();
                foreach (var i in info.banners)
                {
                    i.imgsrc = GetImg(i.banner_id.ToString(), "Banner", "Active", "BannerData", null);
                }
                info.firms = db0.Banner.Where(x => !x.i_Hide & x.type == (int)BannerType.firm).OrderByDescending(x => x.sort)
                         .Select(x => new m_Banner()
                         {
                             banner_id = x.banner_id,
                             banner_name = x.banner_name
                         }).ToList();
                foreach (var i in info.firms)
                {
                    i.imgsrc = GetImg(i.banner_id.ToString(), "Firm", "Active", "BannerData", null);
                }
                #endregion
                #region products
                var items = db0.Product.AsQueryable();
                info.p_hot = items.Where(x => !x.i_Hide & x.is_Hot).OrderByDescending(x => x.sort)
                                             .Select(x => new m_Product()
                                             {
                                                 product_no = x.product_no,
                                                 product_name = x.product_name,
                                                 price = x.price,//實際銷售價格
                                                 price_gen = x.price_gen,//一般價格
                                                 kvalue = x.kvalue,
                                                 i_InsertDateTime = x.i_InsertDateTime,
                                                 shipping_state = x.shipping_state
                                             }).Take(48).ToList();//只取前48筆
                info.p_new = items.Where(x => !x.i_Hide).OrderByDescending(x => x.i_InsertDateTime)
                                             .Select(x => new m_Product()
                                             {
                                                 product_no = x.product_no,
                                                 product_name = x.product_name,
                                                 price = x.price,//實際銷售價格
                                                 price_gen = x.price_gen,//一般價格
                                                 kvalue = x.kvalue,
                                                 i_InsertDateTime = x.i_InsertDateTime,
                                                 shipping_state = x.shipping_state
                                             }).Take(48).ToList();//只取前48筆
                info.p_top = items.Where(x => !x.i_Hide & x.is_TopSales).OrderByDescending(x => x.sort)
                                             .Select(x => new m_Product()
                                             {
                                                 product_no = x.product_no,
                                                 product_name = x.product_name,
                                                 price = x.price,//實際銷售價格
                                                 price_gen = x.price_gen,//一般價格
                                                 kvalue = x.kvalue,
                                                 i_InsertDateTime = x.i_InsertDateTime,
                                                 shipping_state = x.shipping_state
                                             }).Take(48).ToList();//只取前48筆

                foreach (var i in info.p_hot)
                {
                    i.imgsrc = GetImg(i.product_no, "List", "Active", "Product", null);//顯示list圖片
                }
                foreach (var i in info.p_new)
                {
                    i.imgsrc = GetImg(i.product_no, "List", "Active", "Product", null);//顯示list圖片
                }
                foreach (var i in info.p_top)
                {
                    i.imgsrc = GetImg(i.product_no, "List", "Active", "Product", null);//顯示list圖片
                }
                #endregion
                #region news
                info.news = db0.News.Where(x => !x.i_Hide).OrderByDescending(x => x.sort)
                                                             .Select(x => new m_News()
                                                             {
                                                                 news_id = x.news_id,
                                                                 news_content = x.news_content,
                                                                 news_title = x.news_title,
                                                                 news_date = x.news_date
                                                             }).Take(2).ToList();//只取前兩筆

                foreach (var i in info.news)
                {
                    if (i.news_content != null)
                    {
                        i.news_content = RemoveHTMLTag(i.news_content);
                    }
                    i.imgsrc = GetImg(i.news_id.ToString(), "List", "Active", "News", null);//顯示list圖片
                }
                #endregion
            }
            #endregion 
            return View("Index", info);
        }
        public ActionResult Index()
        {
            IndexInfo info = new IndexInfo();
            using (var db0 = getDB0())
            {
                #region Banner
                info.banner = db0.Banner.Where(x => x.i_Hide == false & x.i_Lang == System.Globalization.CultureInfo.CurrentCulture.Name).OrderByDescending(x => x.sort).Take(5).ToList();

                foreach (var item in info.banner)
                {
                    item.imgsrc = GetImg(item.banner_id, "Banner", "Banner", "Banner");//顯示列表圖
                }
                #endregion
                #region 行程
                string lang = System.Globalization.CultureInfo.CurrentCulture.Name;
                info.hot = db0.StudyAbroad.Where(x => x.i_Hide == false & x.is_hot & !x.is_past & x.i_Lang == System.Globalization.CultureInfo.CurrentCulture.Name).OrderByDescending(x => x.sort).Take(6).ToList();

                info.vacations = db0.All_Category_L2.Where(x => x.all_category_l1_id == CategoryType.Vacation_2 && x.i_Hide == false)
                                  .OrderByDescending(x => x.sort)
                                  .Take(2)
                                  .Select(x => new Vacation()
                                  {
                                      vacation_id = x.all_category_l2_id,
                                      vacation_name = x.l2_name,
                                      data = db0.StudyAbroad
                                                .Where(y => !y.i_Hide & !y.is_past & y.vacation_category == x.all_category_l2_id & y.i_Lang == lang)
                                                .OrderByDescending(y => y.sort).Take(6).ToList()
                                  }).ToList();

                foreach (var item in info.hot)
                {
                    item.imgsrc = GetImg(item.study_abroad_id, "Photo1", "StudyAbroad", "Photo");//顯示列表圖
                }
                foreach (var item in info.vacations)
                {
                    foreach (var i in item.data)
                    {
                        i.imgsrc = GetImg(i.study_abroad_id, "Photo1", "StudyAbroad", "Photo");//顯示列表圖
                    }
                }
                #endregion
                #region 最新消息
                info.news = db0.News.Where(x => x.i_Hide == false & x.i_Lang == System.Globalization.CultureInfo.CurrentCulture.Name).OrderByDescending(x => x.date).Take(4).ToList();
                foreach (var item in info.news)
                {
                    item.imgsrc = GetImg(item.news_id, "Photo1", "News", "Photo");//顯示列表圖
                }
                #endregion
                #region 留學遊學資訊
                info.helpfulinfo = db0.HelpfulInfo.Where(x => x.i_Hide == false && x.show_index & x.i_Lang == System.Globalization.CultureInfo.CurrentCulture.Name).OrderByDescending(x => x.sort).Take(4).ToList();
                foreach (var item in info.helpfulinfo)
                {
                    item.imgsrc = GetImg(item.helpful_info_id, "Photo1", "HelpfulInfo", "Photo");//顯示列表圖
                }
                #endregion
                #region 心得分享
                info.feedback = db0.Feedback.Where(x => x.i_Hide == false & x.i_Lang == System.Globalization.CultureInfo.CurrentCulture.Name).OrderByDescending(x => x.sort).Take(4).ToList();
                foreach (var item in info.feedback)
                {
                    item.imgsrc = GetImg(item.feedback_id, "Photo1", "Feedback", "Photo");//顯示列表圖
                    item.feedback_content = item.feedback_content == null ? "" : RemoveHTMLTag(item.feedback_content);
                }
                #endregion
                #region 精彩照片集
                info.albums = db0.Albums.Where(x => x.i_Hide == false & x.i_Lang == System.Globalization.CultureInfo.CurrentCulture.Name).OrderByDescending(x => x.sort).Take(8).ToList();
                foreach (var item in info.albums)
                {
                    item.imgsrc = GetImg(item.albums_id, "Photo1", "Albums", "Photo");//顯示列表圖
                }
                #endregion
            }
            return View(info);
        }