public MovieGroup GetMatchDataByContents(MovieContents myContents) { bool IsSite = (myContents.Kind == MovieContents.KIND_SITE); bool IsFile = (myContents.Kind == MovieContents.KIND_FILE); //bool IsContentsSite = (myContents.Kind == MovieContents.KIND_CONTENTS && myContents.SiteName != null && myContents.SiteName.Length > 0); //bool IsContentsFile = (myContents.Kind == MovieContents.KIND_CONTENTS && (myContents.SiteName == null || myContents.SiteName.Length <= 0)); Regex regex = null; if (IsSite) { regex = new Regex(".*" + Regex.Escape(myContents.Label) + "$", RegexOptions.IgnoreCase); } foreach (MovieGroup data in listMovieGroup) { if (IsSite)// || IsContentsSite) { if (data.Kind != MovieGroup.KIND_SITE) continue; } else if (IsFile) { if (data.Kind != MovieGroup.KIND_DIR) continue; } if (IsSite) { if (data.Label.ToUpper() == myContents.SiteName.ToUpper() && regex.IsMatch(data.Explanation)) return data; continue; } else if (IsFile) { if (data.Explanation.Length > 0 && data.Explanation.ToUpper() == myContents.Label.ToUpper()) return data; continue; } else //if (IsContentsSite) { if (data.Label.ToUpper() == myContents.SiteName.ToUpper()) { if (Directory.Exists(Path.Combine(data.Explanation, myContents.Name))) return data; } if (File.Exists(Path.Combine(data.Explanation, myContents.Name))) return data; continue; } } return null; }
public void Delete(MovieContents myData) { listMovieContens.Remove(myData); }
public static List<MovieContents> GetDbViewContents(DbConnection myDbCon) { List<MovieContents> listMContents = new List<MovieContents>(); if (myDbCon == null) myDbCon = new DbConnection(); string queryString = "SELECT KIND " + " , ID, NAME, SIZE " + " , FILE_DATE, MOVIE_NEWDATE, SELL_DATE " + " , RATING, LABEL, COMMENT, REMARK " + " , SITE_NAME " + " , PRODUCT_NUMBER " + " , FILE_COUNT, MOVIE_COUNT, PHOTO_COUNT " + " , EXTENSION, CREATE_DATE, UPDATE_DATE " + " , TAG " + " FROM V_MOVIE_CONTENTS " + "" + ""; SqlDataReader reader = null; try { reader = myDbCon.GetExecuteReader(queryString); do { if (reader.IsClosed) { _logger.Debug("V_MOVIE_CONTENTS reader.IsClosed"); throw new Exception("COMPANY_ARREARS_DETAILの残高の取得でreaderがクローズされています"); } while (reader.Read()) { MovieContents data = new MovieContents(); data.Kind = DbExportCommon.GetDbInt(reader, 0); data.Id = DbExportCommon.GetDbInt(reader, 1); data.Name = DbExportCommon.GetDbString(reader, 2); data.Size = DbExportCommon.GetLong(reader, 3); data.FileDate = DbExportCommon.GetDbDateTime(reader, 4); data.MovieNewDate = DbExportCommon.GetDbDateTime(reader, 5); data.SellDate = DbExportCommon.GetDbDateTime(reader, 6); data.Rating = DbExportCommon.GetDbInt(reader, 7); data.Label = DbExportCommon.GetDbString(reader, 8); data.Comment = DbExportCommon.GetDbString(reader, 9); data.Remark = DbExportCommon.GetDbString(reader, 10); data.SiteName = DbExportCommon.GetDbString(reader, 11); data.ProductNumber = DbExportCommon.GetDbString(reader, 12); data.FileCount = DbExportCommon.GetDbInt(reader, 13); data.MovieCount = DbExportCommon.GetDbString(reader, 14); data.PhotoCount = DbExportCommon.GetDbString(reader, 15); data.Extension = DbExportCommon.GetDbString(reader, 16); data.CreateDate = DbExportCommon.GetDbDateTime(reader, 17); data.UpdateDate = DbExportCommon.GetDbDateTime(reader, 18); data.Tag = DbExportCommon.GetDbString(reader, 19); //data.ChildTableName = MovieContents.TABLE_KIND_MOVIE_FILESCONTENTS; listMContents.Add(data); } } while (reader.NextResult()); } finally { if (reader != null ) reader.Close(); } myDbCon.closeConnection(); return listMContents; }
public void RefrectData(MovieContents myData) { if (myData == null) return; if (myData.Name != null && myData.Name.Length > 0 && Name != myData.Name.Trim()) Name = myData.Name; if (myData.Tag != null && myData.Tag.Length > 0 && Tag != myData.Tag.Trim()) Tag = myData.Tag; if (myData.Label != null && myData.Label.Length > 0 && Label != myData.Label.Trim()) Label = myData.Label; if (myData.SellDate.Year != 1900) SellDate = myData.SellDate; if (myData.ProductNumber != null && myData.ProductNumber.Length > 0 && ProductNumber != myData.ProductNumber.Trim()) ProductNumber = myData.ProductNumber; if (myData.Extension != null && myData.Extension.Length > 0 && Extension != myData.Extension.ToUpper().Trim()) Extension = myData.Extension.ToUpper().Trim(); return; }
private void OnDisplayImage(MovieContents myMovieContents, MovieGroup myTargetGroup) { // パラメータがnullの場合は画像表示を全てクリア if (myMovieContents == null) { imagePackage.Source = null; return; } if (image == null) image = new common.Image(myMovieContents, myTargetGroup); // PackageImage // Visibleの場合のみ表示 FileInfo fileInfoPackage = image.GetDefaultPackageFileInfo(); if (fileInfoPackage != null && fileInfoPackage.Exists) { string path = myMovieContents.GetExistPath(myTargetGroup); if (path != null) { txtStatusBar.Text = myMovieContents.ExistMovie[0]; txtStatusBarFileLength.Text = CommonMethod.GetDisplaySize(myMovieContents.Size); imagePackage.Source = ImageMethod.GetImageStream(fileInfoPackage.FullName); } } else { imagePackage.Source = null; } // ImageContents // Visibleの場合のみ表示 // Kind == 1 ( File ) // isThumbnail // true サムネイル画像を表示 // false Dirがあれば、Dir内の画像、無い場合はパッケージを表示、ImagePackageを非表示 // Kind == 2 ( Site ) if (image.IsThumbnail()) { List<FileInfo> listFileInfo = image.listImageFileInfo; if (listFileInfo != null && listFileInfo.Count >= 1) { imageSitesImageOne.Source = ImageMethod.GetImageStream(listFileInfo[0].FullName); imageSitesImageOne.ToolTip = listFileInfo[0].Name; imageSitesImageTwo.Visibility = Visibility.Collapsed; imageSitesImageThree.Visibility = Visibility.Collapsed; imageSitesImageFour.Visibility = Visibility.Collapsed; imageSitesImageOne.SetValue(Grid.RowSpanProperty, 2); imageSitesImageOne.SetValue(Grid.ColumnSpanProperty, 2); BitmapImage bitmapImage = (BitmapImage)imageSitesImageOne.Source; imageSitesImageOne.Width = lgridMain.ColumnDefinitions[MAIN_COLUMN_NO_CONTENTS].ActualWidth; imageSitesImageOne.Height = (imageSitesImageOne.Width / bitmapImage.Width) * bitmapImage.Height; imageSitesImageOne.Stretch = Stretch.Uniform; } } else { List<FileInfo> listFileInfo = image.listImageFileInfo; txtbImageInfo.Text = image.DisplayPage; txtStatusBar.Text = Path.Combine(myMovieContents.Label, myMovieContents.Name); txtStatusBarFileLength.Text = CommonMethod.GetDisplaySize(myMovieContents.Size); if (listFileInfo.Count > 1) { imageSitesImageOne.SetValue(Grid.RowSpanProperty, 1); imageSitesImageOne.SetValue(Grid.ColumnSpanProperty, 1); imageSitesImageOne.Width = imageSitesImageTwo.Width; imageSitesImageOne.Height = imageSitesImageTwo.Height; if (listFileInfo.Count >= 1) { imageSitesImageOne.Source = ImageMethod.GetImageStream(listFileInfo[0].FullName); imageSitesImageOne.ToolTip = listFileInfo[0].Name; imageSitesImageOne.Visibility = Visibility.Visible; } if (listFileInfo.Count >= 2) { imageSitesImageTwo.Source = ImageMethod.GetImageStream(listFileInfo[1].FullName); imageSitesImageTwo.ToolTip = listFileInfo[1].Name; imageSitesImageTwo.Visibility = Visibility.Visible; } else imageSitesImageTwo.Visibility = Visibility.Collapsed; if (listFileInfo.Count >= 3) { imageSitesImageThree.Source = ImageMethod.GetImageStream(listFileInfo[2].FullName); imageSitesImageThree.ToolTip = listFileInfo[2].Name; imageSitesImageThree.Visibility = Visibility.Visible; } else imageSitesImageThree.Visibility = Visibility.Collapsed; if (listFileInfo.Count >= 4) { imageSitesImageFour.Source = ImageMethod.GetImageStream(listFileInfo[3].FullName); imageSitesImageFour.ToolTip = listFileInfo[3].Name; imageSitesImageFour.Visibility = Visibility.Visible; } else imageSitesImageFour.Visibility = Visibility.Collapsed; } else { if (listFileInfo.Count >= 1) { imageSitesImageOne.Source = ImageMethod.GetImageStream(listFileInfo[0].FullName); imageSitesImageOne.ToolTip = listFileInfo[0].Name; imageSitesImageOne.Visibility = Visibility.Visible; } else imageSitesImageOne.Source = null; imageSitesImageTwo.Visibility = Visibility.Collapsed; imageSitesImageThree.Visibility = Visibility.Collapsed; imageSitesImageFour.Visibility = Visibility.Collapsed; imageSitesImageOne.SetValue(Grid.RowSpanProperty, 2); imageSitesImageOne.SetValue(Grid.ColumnSpanProperty, 2); } } }
private MovieContents GetMovieContentsFromTextbox( TextBox myTextBoxName , TextBox myTextBoxTag , TextBox myTextBoxLabel , TextBox myTextBoxSellDate , TextBox myTextBoxProductNumber , TextBox myTextBoxExtension , TextBox myTextBoxFileDate , TextBox myTextBoxFileCount) { MovieContents data = new MovieContents(); if (myTextBoxName != null && myTextBoxName.Text.Trim().Length > 0) data.Name = myTextBoxName.Text; if (myTextBoxTag != null && myTextBoxTag.Text.Trim().Length > 0) data.Tag = myTextBoxTag.Text; if (myTextBoxLabel != null && myTextBoxLabel.Text.Trim().Length > 0) data.Label = myTextBoxLabel.Text; if (myTextBoxSellDate != null && myTextBoxSellDate.Text.Trim().Length > 0) data.SellDate = Convert.ToDateTime(myTextBoxSellDate.Text); if (myTextBoxProductNumber != null && myTextBoxProductNumber.Text.Trim().Length > 0) data.ProductNumber = myTextBoxProductNumber.Text; if (myTextBoxExtension != null && myTextBoxExtension.Text.Trim().Length > 0) data.Extension = myTextBoxExtension.Text; if (myTextBoxFileDate != null && myTextBoxFileDate.Text.Trim().Length > 0) data.FileDate = Convert.ToDateTime(myTextBoxFileDate.Text); if (myTextBoxFileCount != null && myTextBoxFileCount.Text.Trim().Length > 0) data.FileCount = Convert.ToInt32(myTextBoxFileCount.Text); return data; }
private void dgridMovieContents_SelectionChanged(object sender, SelectionChangedEventArgs e) { dispinfoSelectContents = (MovieContents)dgridMovieContents.SelectedItem; image = null; if (dispinfoSelectContents != null) { txtLargeComment.Text = dispinfoSelectContents.Comment; cmbLargeRating.SelectedValue = dispinfoSelectContents.Rating; } else return; dispinfoTargetGroupBySelectContents = ColViewMovieGroup.GetMatchDataByContents(dispinfoSelectContents); if (dispinfoTargetGroupBySelectContents == null) txtStatusBar.Text = "" + dispinfoSelectContents.Label + "に一致するグループが存在しませんでした"; OnDisplayImage(dispinfoSelectContents, dispinfoTargetGroupBySelectContents); if (dispinfoContentsVisibleKind == CONTENTS_VISIBLE_KIND_DETAIL) { if (dispinfoSelectContents == null) return; if (dispinfoSelectContents.Kind == MovieContents.KIND_FILE || dispinfoSelectContents.Kind == MovieContents.KIND_CONTENTS) { lgridSiteDetail.Visibility = Visibility.Collapsed; lgridFileDetail.Visibility = Visibility.Visible; ColViewFileDetail = new detail.FileDetail(dispinfoSelectContents, dispinfoTargetGroupBySelectContents); dgridFileDetail.ItemsSource = ColViewFileDetail.listFileInfo; OnRefreshFileDetailInfo(null, null); return; } lgridSiteDetail.Visibility = Visibility.Visible; lgridFileDetail.Visibility = Visibility.Collapsed; txtSiteDetailContentsName.Text = dispinfoSelectContents.Name; txtSiteDetailContentsTag.Text = dispinfoSelectContents.Tag; string path = dispinfoSelectContents.GetExistPath(dispinfoTargetGroupBySelectContents); txtSiteDetailContentsPath.Text = path; txtSiteDetailContentsComment.Text = dispinfoSelectContents.Comment; if (path != null) { ScreenDisableBorderSiteDetail.Width = 0; ScreenDisableBorderSiteDetail.Height = 0; ScreenDisableBorderImageContents.Width = 0; ScreenDisableBorderImageContents.Height = 0; txtSiteDetailContentsPath.Text = path; txtSiteDetailContentsComment.Text = dispinfoSelectContents.Comment; ColViewSiteDetail = new SiteDetail(txtSiteDetailContentsPath.Text); dgridSiteDetail.ItemsSource = ColViewSiteDetail.listFileInfo; btnSiteDetailImage.Content = "Image (" + ColViewSiteDetail.ImageCount + ")"; btnSiteDetailMovie.Content = "Movie (" + ColViewSiteDetail.MovieCount + ")"; btnSiteDetailList.Content = "List (" + ColViewSiteDetail.ListCount + ")"; imageSiteDetail.Source = ImageMethod.GetImageStream(ColViewSiteDetail.StartImagePathname); } // 存在しないpathの場合 else { ScreenDisableBorderSiteDetail.Width = Double.NaN; ScreenDisableBorderSiteDetail.Height = Double.NaN; ScreenDisableBorderImageContents.Width = Double.NaN; ScreenDisableBorderImageContents.Height = Double.NaN; dgridSiteDetail.ItemsSource = null; imageSiteDetail.Source = null; } } }