public static List <Equipment> FindAll(int blockId)
        {
            var db = Equipment.GetDatabase();

            return(db.ExecuteQuery <Equipment>("SELECT * FROM Equipments WHERE BlockId =" + blockId));
        }
        public void Store(int categoryId)
        {
            var now        = DateTime.Now;
            var oldBlockId = this.BlockId;

            //更新
            //Blocks (未登録だったら追加、登録済みだったら取得)
            if (Block.Exists(this.Block.Name))
            {
                this.Block = Block.Find(this.Block.Name);
            }
            else
            {
                this.Block.UpdatedDateTime = now;
                this.Block.Store();
            }

            //Equipments(追加 or 更新)
            this.BlockId         = this.Block.Id;
            this.UpdatedDateTime = now;
            this.Store();

            //Blocks (変更によって以前のBlockが誰からも参照されなくなったら削除)
            if (oldBlockId != 0 && oldBlockId != this.BlockId)
            {
                var equipments = Equipment.FindAll(oldBlockId);
                if (equipments.Count == 0)
                {
                    Block.Delete(oldBlockId);
                }
            }

            //Texts(削除・追加)
            Text.Delete(this.Id);
            foreach (var text in this.Texts)
            {
                text.EquipmentId     = this.Id;
                text.UpdatedDateTime = now;
                text.Store();
            }

            //EquipmentSpecifications(削除・追加)
            EquipmentSpecification.Delete(this.Id);
            foreach (var spec in this.Specifications)
            {
                var equipSpec = new EquipmentSpecification();
                equipSpec.EquipmentId     = this.Id;
                equipSpec.SpecificationId = spec.Id;
                equipSpec.UpdatedDateTime = now;
                equipSpec.Store();
            }

            //SelectionCategoryDetails(新規の時 or カテゴリ替えた時は削除・追加)
            var currentDetails = SelectionCategoryDetail.Get(this.Id);

            if (!currentDetails.Exists(p => p.SelectionCategoryId == categoryId))
            {
                SelectionCategoryDetail.DeleteByEquipmentId(this.Id);

                var categoryDetail = new SelectionCategoryDetail();
                categoryDetail.EquipmentId         = this.Id;
                categoryDetail.SelectionCategoryId = categoryId;
                categoryDetail.SortNo          = SelectionCategoryDetail.GetMaxSortNo(categoryId) + 1;
                categoryDetail.UpdatedDateTime = now;
                categoryDetail.Store();
            }

            //RelatedEquipments(他のEquipに関連付けられているこのEquipは変更なし)
            //RelatedEquipments(このEquipに関連付けたEqiupは削除・追加)
            RelatedEquipment.Delete(this.Id);
            foreach (var relatedEquipment in this.RelatedEquipments)
            {
                relatedEquipment.EquipmentId     = this.Id;
                relatedEquipment.UpdatedDateTime = now;
                relatedEquipment.Store();
            }

            //EquipmentCustomActions
            EquipmentCustomAction.Delete(this.Id);
            foreach (var action in this.CustomActions)
            {
                var equipAction = new EquipmentCustomAction();
                equipAction.EquipmentId     = this.Id;
                equipAction.CustomActionId  = action.CustomActionId;
                equipAction.Parameter       = action.Parameter;
                equipAction.UpdatedDateTime = now;
                equipAction.Store();
            }
        }
        public static void Delete(int equipmentId)
        {
            var db = Equipment.GetDatabase();

            db.ExecuteNonQuery("DELETE FROM Equipments WHERE Id =" + equipmentId);
        }