protected void btnExcel_Click(object sender, EventArgs e)
{
System.IO.MemoryStream m_stream = new System.IO.MemoryStream();
rptStackBalance rpt = new rptStackBalance();
GRN_BL objSGRN = new GRN_BL();
rpt.DataSource = objSGRN.GetGRNStackBalanceReport(UserBLL.GetCurrentWarehouse(), new Guid(drpShed.SelectedValue), new Guid(drpInventoryCoordinatorLoad.SelectedValue), new Guid(drpStackNo.SelectedValue.ToString()));
rpt.PageSettings.Margins.Top = 0;
rpt.PageSettings.Orientation = DataDynamics.ActiveReports.Document.PageOrientation.Landscape;
rpt.Run();
if (this.xlsExport1 == null)
{
this.xlsExport1 = new DataDynamics.ActiveReports.Export.Xls.XlsExport();
}
// this.xlsExport1.MinColumnWidth = (float)(0.5);
this.xlsExport1.Export(rpt.Document, m_stream);
m_stream.Position = 0;
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("content-disposition", "inline; filename=MyExport.xls");
Response.BinaryWrite(m_stream.ToArray());
Response.End();
}
private void Viewer_ToolClick(object sender, DataDynamics.ActiveReports.Toolbar.ToolClickEventArgs e)
{
if (e.Tool.Id == 42)
{
SaveFileDialog dlg = new SaveFileDialog();
dlg.Filter = "Archivos PDF|*.pdf";
dlg.Title = "Guardar reporte como ...";
if (dlg.ShowDialog() == DialogResult.OK)
{
DataDynamics.ActiveReports.Export.Pdf.PdfExport pdf = new DataDynamics.ActiveReports.Export.Pdf.PdfExport();
pdf.Export(this.Viewer.Document, dlg.FileName.ToString());
}
}
if (e.Tool.Id == 43)
{
SaveFileDialog dlg = new SaveFileDialog();
dlg.Filter = "Archivos Excel|*.xls";
dlg.Title = "Guardar reporte como ...";
if (dlg.ShowDialog() == DialogResult.OK)
{
DataDynamics.ActiveReports.Export.Xls.XlsExport xls = new DataDynamics.ActiveReports.Export.Xls.XlsExport();
xls.Export(this.Viewer.Document, dlg.FileName.ToString());
}
}
}
private void InitializeComponent()
{
this.xlsExport1 = new DataDynamics.ActiveReports.Export.Xls.XlsExport();
//
// xlsExport1
//
this.xlsExport1.Tweak = 0;
}
private void viewer_ToolClick(object sender, DataDynamics.ActiveReports.Toolbar.ToolClickEventArgs e)
{
if (e.Tool.Id == 777)
{
saveFileDialogForExcelExport.FileName = "";
if (saveFileDialogForExcelExport.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
var xlsExport = new DataDynamics.ActiveReports.Export.Xls.XlsExport();
xlsExport.Export(viewer.Document, saveFileDialogForExcelExport.FileName);
helper.MsgBox.Info(Properties.Resources.MsgSucceeded);
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
System.IO.MemoryStream m_stream = new System.IO.MemoryStream();
GRN_BL objGrn = new GRN_BL();
rptWBServiceProvider rpt = new rptWBServiceProvider();
Guid warehouseId = new Guid(cboWarehouse.SelectedValue);
int wbServiceProviderId = cboWBServiceProvider.SelectedIndex == 0 ? -2 : int.Parse(cboWBServiceProvider.SelectedValue);
DateTime startDate = string.IsNullOrEmpty(txtStartDate.Text) ? DateTime.Parse("1/1/2010") : DateTime.Parse(txtStartDate.Text);
DateTime endDate = string.IsNullOrEmpty(txtEndDate.Text) ? DateTime.Now : DateTime.Parse(txtEndDate.Text);
int serviceType = int.Parse(cboServiceType.SelectedValue);
DataTable dt = objGrn.GetWBServiceProviderReport(warehouseId, wbServiceProviderId, startDate, endDate, serviceType);
decimal sumNumberOfBags, sumNetWeight;
int rowsCount = dt.Rows.Count;
string NoOfRegords = "";
if (rowsCount == 0)
{
Messages1.SetMessage("No record found with specified criteria.", WarehouseApplication.Messages.MessageType.Warning);
WebViewer1.ClearCachedReport();
return;
}
else
{
sumNumberOfBags = decimal.Parse(dt.Compute("Sum(NumberOfBags)", "").ToString());
sumNetWeight = decimal.Parse(dt.Compute("Sum(NetWeight)", "").ToString());
NoOfRegords = rowsCount == 1 ? "1 record found." : rowsCount + " records found.";
Messages1.SetMessage(NoOfRegords, WarehouseApplication.Messages.MessageType.Success);
rpt.SumNumberOfBags = sumNumberOfBags;
rpt.SumNetWeight = sumNetWeight;
}
rpt.Warehouse = cboWarehouse.SelectedItem.Text;
rpt.WBServiceProvider = cboWBServiceProvider.SelectedIndex == 0 ? "All" : cboWBServiceProvider.SelectedItem.Text;
rpt.DateFrom = string.IsNullOrEmpty(txtStartDate.Text) ? "No Limit" : txtStartDate.Text;
rpt.DateTo = string.IsNullOrEmpty(txtEndDate.Text) ? "Present Date" : txtEndDate.Text;
rpt.DataSource = dt;
rpt.Run();
if (this.xlsExport1 == null)
{
this.xlsExport1 = new DataDynamics.ActiveReports.Export.Xls.XlsExport();
}
// this.xlsExport1.MinColumnWidth = (float)(0.5);
this.xlsExport1.Export(rpt.Document, m_stream);
m_stream.Position = 0;
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("content-disposition", "inline; filename=MyExport.xls");
Response.BinaryWrite(m_stream.ToArray());
Response.End();
}
private void arvMainViwer_ToolClick(object sender, DataDynamics.ActiveReports.Toolbar.ToolClickEventArgs e)
{
if (e.Tool.Id == 25)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
Object RutaDir = Convert.ToString(Environment.CurrentDirectory);
saveFileDialog.Filter = "Microsoft Excel (*.xls)|*.xls|Acrobat Reader (*.pdf)|*.pdf|Página Web (*.html)|*.htm";
saveFileDialog.Title = "Exportar a archivo";
saveFileDialog.ShowDialog();
if (saveFileDialog.FileName != "")
{
try
{
string Extfile = (saveFileDialog.FileName.Substring(saveFileDialog.FileName.Length - 3, 3));
switch (Extfile.ToUpper())
{
case "XLS":
DataDynamics.ActiveReports.Export.Xls.XlsExport MyEx = new DataDynamics.ActiveReports.Export.Xls.XlsExport();
MyEx.RemoveVerticalSpace = false;
MyEx.DisplayGridLines = true;
MyEx.UseCellMerging = false;
MyEx.AutoRowHeight = true;
MyEx.MinRowHeight = (float)0.1;
MyEx.MultiSheet = false;
MyEx.Export(this.arvMainViwer.Document, saveFileDialog.FileName);
MyEx.Dispose();
break;
case "PDF":
DataDynamics.ActiveReports.Export.Pdf.PdfExport MyPd = new DataDynamics.ActiveReports.Export.Pdf.PdfExport();
MyPd.Export(this.arvMainViwer.Document, saveFileDialog.FileName);
MyPd.Dispose();
break;
case "TML":
DataDynamics.ActiveReports.Export.Html.HtmlExport MyHtml = new DataDynamics.ActiveReports.Export.Html.HtmlExport();
MyHtml.Export(this.arvMainViwer.Document, saveFileDialog.FileName);
MyHtml.Dispose();
break;
}
}
catch (Exception Ex) { throw new Exception(Ex.Message, Ex.InnerException); }
}
}
}
