private void _003CInitEvent_003Eb__b() { pdfStatus = PDFStatus.匯出中; btnExport.Visibility = Visibility.Collapsed; btnDownload.Visibility = Visibility.Collapsed; txtStatus.Text = pdfStatus.ToString(); }
/// <summary> /// Select values from PDFStatus by primary key(s). /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="connectionKeyName">Connection key name located in config file.</param> /// <param name="pdfStatusID"></param> /// <returns>Object of type PDFStatus.</returns> public PDFStatus PDFStatusSelectAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, string connectionKeyName, int pdfStatusID) { SqlConnection connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings(connectionKeyName), sqlConnection); SqlTransaction transaction = sqlTransaction; using (SqlCommand command = CustomSqlHelper.CreateCommand("PDFStatusSelectAuto", connection, transaction, CustomSqlHelper.CreateInputParameter("PdfStatusID", SqlDbType.Int, null, false, pdfStatusID))) { using (CustomSqlHelper <PDFStatus> helper = new CustomSqlHelper <PDFStatus>()) { CustomGenericList <PDFStatus> list = helper.ExecuteReader(command); if (list.Count > 0) { PDFStatus o = list[0]; list = null; return(o); } else { return(null); } } } }
/// <summary> /// Manage PDFStatus object. /// If the object is of type CustomObjectBase, /// then either insert values into, delete values from, or update values in PDFStatus. /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="value">Object of type PDFStatus.</param> /// <returns>Object of type CustomDataAccessStatus<PDFStatus>.</returns> public CustomDataAccessStatus <PDFStatus> PDFStatusManageAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, PDFStatus value) { return(PDFStatusManageAuto(sqlConnection, sqlTransaction, "BHL", value)); }
/// <summary> /// Update values in PDFStatus. Returns an object of type PDFStatus. /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="value">Object of type PDFStatus.</param> /// <returns>Object of type PDFStatus.</returns> public PDFStatus PDFStatusUpdateAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, PDFStatus value) { return(PDFStatusUpdateAuto(sqlConnection, sqlTransaction, "BHL", value)); }
private void InitUI() { sb.Begin(); if (Singleton_PDFFactory.IsPDFInWork(fileItem.ID)) { sb.Begin(); } else if (File.Exists(Path.Combine(fileItem.UnZipFilePath, "PDF.pdf")) && fileItem.FileType == MeetingFileType.已下載完成) { sb.Stop(); pdfStatus = PDFStatus.匯出成功; txtStatus.Text = pdfStatus.ToString(); } else { sb.Stop(); pdfStatus = PDFStatus.尚未匯出; txtStatus.Text = pdfStatus.ToString(); } PDFStatus pDFStatus = pdfStatus; if (pDFStatus == PDFStatus.匯出成功) { btnExport.Visibility = Visibility.Visible; btnDownload.Visibility = Visibility.Visible; } }
private void InitUI() { //this.txtIndex.Text = index.ToString(); //this.txtFileName.Text = fileItem.FileName; sb.Begin(); if (Singleton_PDFFactory.IsPDFInWork(fileItem.ID) == true) { //PDFStatus.匯出中; sb.Begin(); } else if (File.Exists(System.IO.Path.Combine(fileItem.UnZipFilePath, "PDF.pdf")) == true && fileItem.FileType == MeetingFileType.已下載完成) { sb.Stop(); pdfStatus = PDFStatus.匯出成功; txtStatus.Text = pdfStatus.ToString(); } else { sb.Stop(); pdfStatus = PDFStatus.尚未匯出; txtStatus.Text = pdfStatus.ToString(); } switch (pdfStatus) { case PDFStatus.匯出成功: btnExport.Visibility = Visibility.Visible; btnDownload.Visibility = Visibility.Visible; break; } }
private void _003CInitEvent_003Eb__d() { sb.Stop(); pdfStatus = PDFStatus.尚未匯出; btnExport.Visibility = Visibility.Collapsed; btnDownload.Visibility = Visibility.Collapsed; txtStatus.Text = pdfStatus.ToString(); }
private void _003CInitEvent_003Eb__c() { sb.Stop(); pdfStatus = PDFStatus.匯出成功; btnExport.Visibility = Visibility.Visible; btnDownload.Visibility = Visibility.Visible; txtStatus.Text = pdfStatus.ToString(); }
/// <summary> /// Update values in PDFStatus. Returns an object of type PDFStatus. /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="connectionKeyName">Connection key name located in config file.</param> /// <param name="value">Object of type PDFStatus.</param> /// <returns>Object of type PDFStatus.</returns> public PDFStatus PDFStatusUpdateAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, string connectionKeyName, PDFStatus value) { return(PDFStatusUpdateAuto(sqlConnection, sqlTransaction, connectionKeyName, value.PdfStatusID, value.PdfStatusName)); }
/// <summary> /// Manage PDFStatus object. /// If the object is of type CustomObjectBase, /// then either insert values into, delete values from, or update values in PDFStatus. /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="connectionKeyName">Connection key name located in config file.</param> /// <param name="value">Object of type PDFStatus.</param> /// <returns>Object of type CustomDataAccessStatus<PDFStatus>.</returns> public CustomDataAccessStatus <PDFStatus> PDFStatusManageAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, string connectionKeyName, PDFStatus value) { if (value.IsNew && !value.IsDeleted) { PDFStatus returnValue = PDFStatusInsertAuto(sqlConnection, sqlTransaction, connectionKeyName, value.PdfStatusID, value.PdfStatusName); return(new CustomDataAccessStatus <PDFStatus>( CustomDataAccessContext.Insert, true, returnValue)); } else if (!value.IsNew && value.IsDeleted) { if (PDFStatusDeleteAuto(sqlConnection, sqlTransaction, connectionKeyName, value.PdfStatusID)) { return(new CustomDataAccessStatus <PDFStatus>( CustomDataAccessContext.Delete, true, value)); } else { return(new CustomDataAccessStatus <PDFStatus>( CustomDataAccessContext.Delete, false, value)); } } else if (value.IsDirty && !value.IsDeleted) { PDFStatus returnValue = PDFStatusUpdateAuto(sqlConnection, sqlTransaction, connectionKeyName, value.PdfStatusID, value.PdfStatusName); return(new CustomDataAccessStatus <PDFStatus>( CustomDataAccessContext.Update, true, returnValue)); } else { return(new CustomDataAccessStatus <PDFStatus>( CustomDataAccessContext.NA, false, value)); } }
/// <summary> /// Update values in PDFStatus. Returns an object of type PDFStatus. /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="connectionKeyName">Connection key name located in config file.</param> /// <param name="value">Object of type PDFStatus.</param> /// <returns>Object of type PDFStatus.</returns> public PDFStatus PDFStatusUpdateAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, string connectionKeyName, PDFStatus value) { return PDFStatusUpdateAuto(sqlConnection, sqlTransaction, connectionKeyName, value.PdfStatusID, value.PdfStatusName); }
/// <summary> /// Update values in PDFStatus. Returns an object of type PDFStatus. /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="value">Object of type PDFStatus.</param> /// <returns>Object of type PDFStatus.</returns> public PDFStatus PDFStatusUpdateAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, PDFStatus value) { return PDFStatusUpdateAuto(sqlConnection, sqlTransaction, "BHL", value ); }
/// <summary> /// Manage PDFStatus object. /// If the object is of type CustomObjectBase, /// then either insert values into, delete values from, or update values in PDFStatus. /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="connectionKeyName">Connection key name located in config file.</param> /// <param name="value">Object of type PDFStatus.</param> /// <returns>Object of type CustomDataAccessStatus<PDFStatus>.</returns> public CustomDataAccessStatus<PDFStatus> PDFStatusManageAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, string connectionKeyName, PDFStatus value) { if (value.IsNew && !value.IsDeleted) { PDFStatus returnValue = PDFStatusInsertAuto(sqlConnection, sqlTransaction, connectionKeyName, value.PdfStatusID, value.PdfStatusName); return new CustomDataAccessStatus<PDFStatus>( CustomDataAccessContext.Insert, true, returnValue); } else if (!value.IsNew && value.IsDeleted) { if (PDFStatusDeleteAuto(sqlConnection, sqlTransaction, connectionKeyName, value.PdfStatusID)) { return new CustomDataAccessStatus<PDFStatus>( CustomDataAccessContext.Delete, true, value); } else { return new CustomDataAccessStatus<PDFStatus>( CustomDataAccessContext.Delete, false, value); } } else if (value.IsDirty && !value.IsDeleted) { PDFStatus returnValue = PDFStatusUpdateAuto(sqlConnection, sqlTransaction, connectionKeyName, value.PdfStatusID, value.PdfStatusName); return new CustomDataAccessStatus<PDFStatus>( CustomDataAccessContext.Update, true, returnValue); } else { return new CustomDataAccessStatus<PDFStatus>( CustomDataAccessContext.NA, false, value); } }
/// <summary> /// Manage PDFStatus object. /// If the object is of type CustomObjectBase, /// then either insert values into, delete values from, or update values in PDFStatus. /// </summary> /// <param name="sqlConnection">Sql connection or null.</param> /// <param name="sqlTransaction">Sql transaction or null.</param> /// <param name="value">Object of type PDFStatus.</param> /// <returns>Object of type CustomDataAccessStatus<PDFStatus>.</returns> public CustomDataAccessStatus<PDFStatus> PDFStatusManageAuto( SqlConnection sqlConnection, SqlTransaction sqlTransaction, PDFStatus value) { return PDFStatusManageAuto( sqlConnection, sqlTransaction, "BHL", value ); }
private void InitEvent() { btnExport.MouseEnter += (sender, e) => { MouseTool.ShowHand(); }; btnExport.MouseLeave += (sender, e) => { MouseTool.ShowArrow(); }; btnExport.MouseLeftButtonDown += (sender, e) => { Task.Factory.StartNew(() => { Singleton_PDFFactory.AddBookInPDFWork(fileItem.ID); this.Dispatcher.BeginInvoke(new Action(() => { btnExport.Visibility = Visibility.Collapsed; btnDownload.Visibility = Visibility.Collapsed; sb.Begin(); DataTable dt = MSCE.GetDataTable("select PDFFactoryParameterJson from FileRow where userid=@1 and id=@2" , fileItem.UserID , fileItem.ID); if (dt.Rows.Count > 0) { PDFFactoryParameter pdfFactoryParameter = JsonConvert.DeserializeObject <PDFFactoryParameter>(dt.Rows[0][0].ToString()); Home home = Application.Current.Windows.OfType <Home>().First(); if (home.IsInSync == true) { pdfFactoryParameter.UserAccount += "_Sync"; } Singleton_PDFFactory.SavePDF(pdfFactoryParameter); } })); Singleton_PDFFactory.RemoveBookInPDFWork(fileItem.ID); }); }; btnDownload.MouseEnter += (sender, e) => { MouseTool.ShowHand(); }; btnDownload.MouseLeave += (sender, e) => { MouseTool.ShowArrow(); }; btnDownload.MouseLeftButtonDown += (sender, e) => { Microsoft.Win32.SaveFileDialog dlg = new Microsoft.Win32.SaveFileDialog(); //Environment.SpecialFolder.MyDocuments //This cannot be found as it is not a valid path, so nothing gets selected. dlg.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments); dlg.FileName = FileNameTool.PureFileName(fileItem.FileName); // Default file name dlg.DefaultExt = ".pdf"; // Default file extension dlg.Filter = "PDF documents (.pdf)|*.pdf"; // Filter files by extension // Show save file dialog box Nullable <bool> result = dlg.ShowDialog(); // Process save file dialog box results if (result == true) { // Save document string srcFilePath = System.IO.Path.Combine(fileItem.UnZipFilePath, "PDF.pdf"); string saveFilePath = dlg.FileName; if (File.Exists(srcFilePath) == true) { File.Copy(srcFilePath, saveFilePath, true); } } }; //偵測是否轉檔中 timer = new DispatcherTimer(); timer.Interval = TimeSpan.FromMilliseconds(1100); timer.Tick += (sender, e) => { if (Singleton_PDFFactory.IsPDFInWork(fileItem.ID) == true) { //this.Dispatcher.BeginInvoke(new Action(() => // { // //Console.Write(sb.GetIsPaused()); // //sb.Begin(); // })); this.Dispatcher.BeginInvoke(new Action(() => { pdfStatus = PDFStatus.匯出中; btnExport.Visibility = Visibility.Collapsed; btnDownload.Visibility = Visibility.Collapsed; txtStatus.Text = pdfStatus.ToString(); })); } else if (File.Exists(System.IO.Path.Combine(fileItem.UnZipFilePath, "PDF.pdf")) == true && fileItem.FileType == MeetingFileType.已下載完成) { this.Dispatcher.BeginInvoke(new Action(() => { sb.Stop(); pdfStatus = PDFStatus.匯出成功; btnExport.Visibility = Visibility.Visible; btnDownload.Visibility = Visibility.Visible; txtStatus.Text = pdfStatus.ToString(); })); } else { this.Dispatcher.BeginInvoke(new Action(() => { sb.Stop(); pdfStatus = PDFStatus.尚未匯出; btnExport.Visibility = Visibility.Collapsed; btnDownload.Visibility = Visibility.Collapsed; txtStatus.Text = pdfStatus.ToString(); })); } }; timer.Start(); }