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();
}
