/// <summary>
/// Muestra el Personnel Log en el DocumentViewer
/// </summary>
/// <history>
/// [emoguel] 17/10/2016 created
/// </history>
private async void btnPrintlog_Click(object sender, RoutedEventArgs e)
{
try
{
Mouse.OverrideCursor = Cursors.Wait;
List <GetPersonnelLog> lstPersonnelLog = dtgPersonnelLog.ItemsSource as List <GetPersonnelLog>;
FileInfo fileInfo = await ReportBuilder.CreateCustomExcelAsync(
TableHelper.GetDataTableFromList(lstPersonnelLog, true, true, true),
new List <Tuple <string, string> > {
Tuple.Create("Personnel ID", _idPersonnelLog)
},
"Personnel Log",
DateHelper.DateRangeFileName(DateTime.Today, DateTime.Today),
EpplusHelper.OrderColumns(dtgPersonnelLog.Columns.ToList(), clsFormatReport.RptPersonnelLog()));
if (fileInfo != null)
{
frmDocumentViewer documentViewver = new frmDocumentViewer(fileInfo, Context.User.HasPermission(EnumPermission.RptExcel, EnumPermisionLevel.ReadOnly), false);
documentViewver.Owner = this;
documentViewver.ShowDialog();
}
}
catch (Exception ex)
{
UIHelper.ShowMessage(ex);
}
finally
{
Mouse.OverrideCursor = null;
}
}
private void But_CreatExcel_Click(object sender, EventArgs e)
{
string exportpath = txt_exportpath.Text.Trim();
DataTable table = (DataTable)dgv_content.DataSource;
EpplusHelper.DataTableToExcel(table, "mysheet", exportpath);
MessageBox.Show("导出成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void But_CreatExcel_Click(object sender, EventArgs e)
{
string sql = rtb_sql.Text.TrimEnd();
DataTable dt = sqlContent.GetTable(sql);
string exportpath = txt_exportpath.Text.Trim();
EpplusHelper.DataTableToExcel(dt, "mysheet", exportpath);
MessageBox.Show("导出成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
public FilePathResult DownloadOrderDetile(OrderSearchCriteria csc)
{
HttpContext HttpCurrent = System.Web.HttpContext.Current;
var data = Ioc.Get <IOrderDetailService>().GetOrderDetail(csc);
string[] title = "1,2,3,4,5,6,7,8,9,10,11".Split(',');
string filename = $"~/file/excel/Export/Order{DateTime.Now.ToString("yyyyMMddHHmmss")}.xlsx";
filename = HttpCurrent.Server.MapPath(filename);
filename = EpplusHelper.SaveToExcel(data, filename, title);
return(File(filename, "application/octet-stream", $"订单{DateTime.Now.ToString("yyyyMMddHHmmss")}.xls"));
}
/// <summary>
/// Imprime el el Log del Guest
/// </summary>
/// <history>
/// [jorcanche] created 07/07/2016
/// [edgrodriguez] 05/09/2016 Modified. Se cambio el método CreateExcelCustom por CreatCustomExcel
/// </history>
private async void btnPrintGuestLog_Click(object sender, RoutedEventArgs e)
{
try
{
if (dgGuestLog == null)
{
return;
}
if (dgGuestLog.Items.Count == 0)
{
UIHelper.ShowMessage("There is no info to make a report");
return;
}
Mouse.OverrideCursor = Cursors.Wait;
FileInfo fileInfo = await ReportBuilder.CreateCustomExcelAsync(
TableHelper.GetDataTableFromList((List <GuestLogData>)dgGuestLog.ItemsSource, true, true, true),
new List <Tuple <string, string> > {
Tuple.Create("Guest Id", _idGuest.ToString())
},
"Guest Log",
DateHelper.DateRangeFileName(DateTime.Today, DateTime.Today),
EpplusHelper.OrderColumns(dgGuestLog.Columns.ToList(), clsFormatReports.RptGuestLog()));
if (fileInfo != null)
{
frmDocumentViewer documentViewver = new frmDocumentViewer(fileInfo, Context.User.HasPermission(EnumPermission.RptExcel, EnumPermisionLevel.ReadOnly), false);
documentViewver.Owner = this;
documentViewver.ShowDialog();
}
}
catch (Exception ex)
{
UIHelper.ShowMessage(ex);
}
finally
{
Mouse.OverrideCursor = null;
}
}
/// <summary>
/// Exporta los registros de grid a un archivo de excel.
/// </summary>
/// <history>
/// [edgrodriguez] 08/07/2016 Created
/// [edgrodriguez] 05/09/2016 Modified. Se cambio el método CreateExcelCustom por CreatCustomExcel
/// [emoguel] 08/09/2016 modified. Ahora abre el visor de reportes
/// </history>
private async void btnPrint_Click(object sender, RoutedEventArgs e)
{
if (((List <ExchangeRateLogData>)_cvsExchangeRate.Source).Any())
{
var fileinfo = await ReportBuilder.CreateCustomExcelAsync(TableHelper.GetDataTableFromList((List <ExchangeRateLogData>)_cvsExchangeRate.Source, true, true, true),
new List <Tuple <string, string> > {
Tuple.Create("Date Range", DateHelper.DateRange(DateTime.Today, DateTime.Today)), Tuple.Create("Gift ID", string.Join(",", ((List <ExchangeRateLogData>)_cvsExchangeRate.Source).Select(c => c.elcu).Distinct().ToList()))
},
"Exchange Rates Log", DateHelper.DateRangeFileName(DateTime.Today, DateTime.Today), EpplusHelper.OrderColumns(getExchangeRateLogDataGrid.Columns.ToList(), clsFormatReport.RptExchangeRatesLog()));
if (fileinfo != null)
{
frmDocumentViewer documentViewer = new frmDocumentViewer(fileinfo, Context.User.HasPermission(EnumPermission.RptExcel, EnumPermisionLevel.ReadOnly), false);
documentViewer.Owner = this;
documentViewer.ShowDialog();
}
}
else
{
UIHelper.ShowMessage("There is no info to make a report");
}
}
/// <summary>
/// Exporta los registros de grid a un archivo de excel.
/// </summary>
/// <history>
/// [edgrodriguez] 08/07/2016 Created
/// [edgrodriguez] 05/09/2016 Modified. Se cambio el método CreateExcelCustom por CreatCustomExcel
/// [emoguel] 08/09/2016 Modified. Ahora se abre el visor de reportes
/// </history>
private async void btnPrint_Click(object sender, RoutedEventArgs e)
{
if (((List <SalesRoomLogData>)_salesRoomLog.Source).Any())
{
var fileinfo = await ReportBuilder.CreateCustomExcelAsync(TableHelper.GetDataTableFromList((List <SalesRoomLogData>)_salesRoomLog.Source, true, true, true),
new List <Tuple <string, string> > {
Tuple.Create("Date Range", DateHelper.DateRange(DateTime.Today, DateTime.Today)), Tuple.Create("Sales Room ID", Context.User.SalesRoom.srID)
},
"Sales Rooms Log", DateHelper.DateRangeFileName(DateTime.Today, DateTime.Today), EpplusHelper.OrderColumns(dtgSalesRoomLog.Columns.ToList(), clsFormatReport.RptCloseSalesRoomLog()));
if (fileinfo != null)
{
frmDocumentViewer documentViewver = new frmDocumentViewer(fileinfo, Context.User.HasPermission(EnumPermission.RptExcel, EnumPermisionLevel.ReadOnly), false);
documentViewver.Owner = this;
documentViewver.ShowDialog();
}
}
else
{
UIHelper.ShowMessage("There is no info to make a report");
}
}
/// <summary>
/// Guarda un excel con los datos del grid
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <history>
/// [emoguel] created 01/07/2016
/// [edgrodriguez] 05/09/2016 Modified. Se cambio el método CreateExcelCustom por CreatCustomExcel
/// </history>
private async void btnPrint_Click(object sender, RoutedEventArgs e)
{
try
{
Mouse.OverrideCursor = Cursors.Wait;
var fileinfo = await ReportBuilder.CreateCustomExcelAsync(TableHelper.GetDataTableFromList((List <GiftLogData>)dgrGifsLog.ItemsSource, true, true, true), new List <Tuple <string, string> > {
Tuple.Create("GIFT ID", idGift)
},
$"Gift Logs - {idGift}", DateHelper.DateRangeFileName(DateTime.Today, DateTime.Today), EpplusHelper.OrderColumns(dgrGifsLog.Columns.ToList(), clsFormatReport.RptGiftLog()));
frmDocumentViewer documentViewver = new frmDocumentViewer(fileinfo, Context.User.HasPermission(EnumPermission.RptExcel, EnumPermisionLevel.ReadOnly), false);
documentViewver.Owner = this;
documentViewver.ShowDialog();
}
catch (Exception ex)
{
UIHelper.ShowMessage(ex);
}
finally
{
Mouse.OverrideCursor = null;
}
}