예제 #1
0
        private static List <SlideShowItem> Get(SqlCommand SqlCommand)
        {
            List <SlideShowItem> SlideShowItems = new List <SlideShowItem>();

            using (SqlConnection SqlConnection = ConnectionManager.GetConnection())
            {
                using (SqlCommand.Connection = SqlConnection)
                {
                    SqlConnection.Open();

                    SqlDataReader SqlDataReader = SqlCommand.ExecuteReader();

                    while (SqlDataReader.Read())
                    {
                        string   Id         = (string)SqlDataReader["Id"];
                        string   Image      = (string)SqlDataReader["Image"];
                        bool     Enable     = (bool)SqlDataReader["Enable"];
                        string   Url        = (string)SqlDataReader["Url"];
                        int      Sort       = (int)SqlDataReader["Sort"];
                        DateTime UpdateTime = (DateTime)SqlDataReader["UpdateTime"];
                        DateTime CreateTime = (DateTime)SqlDataReader["CreateTime"];

                        SlideShowItem SlideShowItem = new SlideShowItem(Id, Image, Enable, Url, Sort, UpdateTime, CreateTime);
                        SlideShowItems.Add(SlideShowItem);
                    }
                }
            }

            return(SlideShowItems);
        }
예제 #2
0
        public static void Save(SlideShowItem SlideShowItem)
        {
            SlideShowItem.UpdateTime = DateTime.Now;

            SlideShowItemCache.Remove(SlideShowItem);
            SlideShowItemCache.Add(SlideShowItem);
            SlideShowItemCache = SlideShowItemCache.OrderBy(b => b.Sort).ThenByDescending(c => c.CreateTime).ToList();

            //更新資料庫
            SlideShowItemAccessor.UpdateInsert(SlideShowItem);
        }
예제 #3
0
        public static void Remove(SlideShowItem SlideShowItem)
        {
            //更新資料庫
            SlideShowItemAccessor.Delete(SlideShowItem);

            //更新記憶体
            SlideShowItemCache.Remove(SlideShowItem);

            //刪除圖片
            if (string.IsNullOrWhiteSpace(SlideShowItem.Image) == false)
            {
                System.IO.File.Delete(SlideShowItemManager.GetPhysicalUploadPath() + SlideShowItem.Image);
            }
        }
예제 #4
0
        internal static void Delete(SlideShowItem SlideShowItem)
        {
            using (SqlConnection SqlConnection = ConnectionManager.GetConnection())
            {
                using (SqlCommand SqlCommand = SqlConnection.CreateCommand())
                {
                    SqlCommand.CommandText = "Delete "
                                             + " SlideShow_SlideShowItem "
                                             + "WHERE "
                                             + " Id = @Id ";

                    SqlCommand.Parameters.AddWithValue("Id", SlideShowItem.Id);

                    SqlConnection.Open();
                    SqlCommand.ExecuteNonQuery();
                }
            }
        }
예제 #5
0
        internal static void UpdateInsert(SlideShowItem SlideShowItem)
        {
            using (SqlConnection SqlConnection = ConnectionManager.GetConnection())
            {
                using (SqlCommand SqlCommand = SqlConnection.CreateCommand())
                {
                    SqlCommand.CommandText = "UPDATE "
                                             + " SlideShow_SlideShowItem "
                                             + "SET "
                                             + " Image = @Image "
                                             + " ,Enable = @Enable "
                                             + " ,Url = @Url "
                                             + " ,Sort = @Sort "
                                             + " ,UpdateTime = @UpdateTime "
                                             + " ,CreateTime = @CreateTime "
                                             + "WHERE "
                                             + " Id = @Id "

                                             + "IF @@ROWCOUNT = 0 "
                                             + "BEGIN "

                                             + "INSERT INTO "
                                             + " SlideShow_SlideShowItem "
                                             + "( Id, Image, Enable, Url, Sort, UpdateTime, CreateTime  ) "
                                             + "VALUES "
                                             + "( @Id, @Image, @Enable, @Url, @Sort, @UpdateTime, @CreateTime ) "

                                             + "END ";

                    SqlCommand.Parameters.AddWithValue("Id", SlideShowItem.Id);
                    SqlCommand.Parameters.AddWithValue("Image", SlideShowItem.Image);
                    SqlCommand.Parameters.AddWithValue("Enable", SlideShowItem.Enable);
                    SqlCommand.Parameters.AddWithValue("Url", SlideShowItem.Url);
                    SqlCommand.Parameters.AddWithValue("Sort", SlideShowItem.Sort);
                    SqlCommand.Parameters.AddWithValue("UpdateTime", SlideShowItem.UpdateTime);
                    SqlCommand.Parameters.AddWithValue("CreateTime", SlideShowItem.CreateTime);

                    SqlConnection.Open();
                    SqlCommand.ExecuteNonQuery();
                }
            }
        }