public static byte[] GetExportData(ASPxGridViewExporter exporter, ExportType type)
{
byte[] data = null;
if (exporter != null)
{
exporter.DataBind();
using (MemoryStream ms = new MemoryStream())
{
switch (type)
{
case ExportType.XLS:
exporter.WriteXls(ms);
break;
case ExportType.PDF:
exporter.WritePdf(ms);
break;
case ExportType.CSV:
exporter.WriteCsv(ms);
break;
case ExportType.RTF:
exporter.WriteRtf(ms);
break;
default:
break;
}
data = ms.GetBuffer();
}
}
return(data);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
using (MemoryStream ms = new MemoryStream())
{
PrintableComponentLink pcl = new PrintableComponentLink(new PrintingSystem());
ASPxGridViewExporter export = (ASPxGridViewExporter)Session["exporter"];
export.Styles.Header.Wrap = DevExpress.Utils.DefaultBoolean.True;
export.MaxColumnWidth = 180;
pcl.Component = export;
pcl.Margins.Left = pcl.Margins.Right = 10;
pcl.Landscape = true;
pcl.CreateDocument(false);
pcl.PrintingSystem.Document.AutoFitToPagesWidth = 0;
pcl.ExportToPdf(ms);
WriteResponse(this.Response, ms.ToArray(), System.Net.Mime.DispositionTypeNames.Inline.ToString());
}
}
catch (Exception ex)
{
cm.log.Error("Kontrolka : generowanie pdf :" + ex.Message);
}
}
// Public Methods (3)
public static void ExportData(ASPxGridViewExporter exporter, ExportType type)
{
if (exporter != null)
{
exporter.DataBind();
switch (type)
{
case ExportType.XLS:
exporter.WriteXlsToResponse();
break;
case ExportType.PDF:
exporter.WritePdfToResponse();
break;
case ExportType.CSV:
exporter.WriteCsvToResponse();
break;
case ExportType.RTF:
exporter.WriteRtfToResponse();
break;
default:
break;
}
}
}
protected void Grid_ContextMenuItemClick(object sender, ASPxGridViewContextMenuItemClickEventArgs e)
{
try
{
switch (e.Item.Name)
{
case "ExportToPDF":
ASPxGridViewExporter.WritePdfToResponse();
break;
case "ExportToXLS":
ASPxGridViewExporter.WriteXlsToResponse();
break;
case "ExportToWORD":
ASPxGridViewExporter.WriteRtfToResponse();
break;
case "ExportToCSV":
ASPxGridViewExporter.WriteCsvToResponse();
break;
}
}
catch (Exception ex)
{
_Security.ErrorDesscription = ex.Message;
_Security.ErrorModule = "Exporting Deleted Loan Applications Inquiry";
_Security.SaveError();
}
}
private void SetupASPxGridViewExporter()
{
gridExporter = new ASPxGridViewExporter {
ID = "ASPxGridViewExporter",
GridViewID = ChildGrid.ID
};
PlaceHolder1.Controls.Add(gridExporter);
}
void webExportController_CustomExport(object sender, CustomExportEventArgs e)
{
if (e.ExportTarget == ExportTarget.Pdf)
{
ASPxGridViewExporter exporter = e.Printable as ASPxGridViewExporter;
exporter.Styles.Default.Font.Name = "Angsana"; //TH SarabunPSK
}
}
public ASPxGridViewExporter CreateGridExport()
{
masterGridExport = new ASPxGridViewExporter();
masterGridExport.GridViewID = string.Concat(tableMeta.Children[0], "GridView");
masterGridExport.ID = "GridExport";
masterGridExport.ExportedRowType = GridViewExportedRowType.All;
return(masterGridExport);
}
protected override void CustomExport(object sender, DevExpress.ExpressApp.SystemModule.CustomExportEventArgs e)
{
base.CustomExport(sender, e);
//Export only selected rows
ASPxGridViewExporter exporter = e.Printable as ASPxGridViewExporter;
if (exporter != null)
{
exporter.ExportSelectedRowsOnly = true;
}
}
protected ASPxGridViewExporter GetGridExporter()
{
foreach (Control item in this.Controls)
{
ASPxGridViewExporter exp = item as ASPxGridViewExporter;
if (exp != null)
{
return(exp);
}
}
return(null);
}
public static void ExportGridToPdf(string fileName, string gridId, ASPxGridViewExporter exporter)
{
exporter.GridViewID = gridId;
exporter.Landscape = true;
exporter.ExportEmptyDetailGrid = false;
exporter.LeftMargin = 10;
exporter.RightMargin = 10;
exporter.MaxColumnWidth = 100;
exporter.TopMargin = 10;
exporter.BottomMargin = 10;
exporter.WritePdfToResponse(fileName, true);
}
public static void ExportToPDFFitToPage(ASPxGridViewExporter GridViewExporter, Page pg)
{
using (MemoryStream ms = new MemoryStream())
{
PrintableComponentLinkBase pcl = new PrintableComponentLinkBase(new DevExpress.XtraPrinting.PrintingSystemBase());
pcl.Component = GridViewExporter;
pcl.Margins.Left = pcl.Margins.Right = 50;
pcl.Landscape = true;
pcl.CreateDocument(false);
pcl.PrintingSystemBase.Document.AutoFitToPagesWidth = 1;
pcl.ExportToPdf(ms);
WriteResponse(pg.Response, ms.ToArray(), System.Net.Mime.DispositionTypeNames.Inline.ToString());
}
}
/// <summary>
/// Creates detail grid view and its header (H3) in a container.
/// </summary>
/// <param name="container">The container control in which this template is instantiated.</param>
public void InstantiateIn(Control container)
{
parent = container;
masterKey = ((GridViewDetailRowTemplateContainer)parent).KeyValue;
var gridCreator = new DetailGridCreator(detailTable, masterTableMeta, masterKey, connectionString, permissions);
btnExport = buttonExportGrid();
masterGridExport = CreateGridExport();
if (masterTableMeta.Caption.ToLower() == "alterations" || masterTableMeta.Caption.ToLower() == "vehicleorders" ||
masterTableMeta.Caption.ToLower() == "packinglists" || masterTableMeta.Caption.ToLower() == "dialogs" || masterTableMeta.Caption.ToLower() == "productionsequence")
{
parent.Controls.Add(btnExport);
}
parent.Controls.Add(new LiteralControl(string.Format("<h3>{0}</h3>", detailTable.Caption)));
parent.Controls.Add(gridCreator.CreateDetailGrid());
parent.Controls.Add(masterGridExport);
}
public void InstantiateIn(Control container)
{
this.grid = (ExportGridView)((GridViewPagerBarTemplateContainer)container).Grid;
Table tblContent = new Table();
tblContent.Width = Unit.Percentage(100);
TableRow rwContent = new TableRow();
TableCell cellPager = new TableCell();
ASPxGridViewTemplateReplacement replacement = new ASPxGridViewTemplateReplacement();
replacement.ID = "Pager";
replacement.ReplacementType = GridViewTemplateReplacementType.Pager;
cellPager.Controls.Add(replacement);
rwContent.Cells.Add(cellPager);
if (this.ExportTypes != ExportType.none)
{
String callBackID = String.IsNullOrEmpty(this.grid.ClientInstanceName) ? this.grid.UniqueID.Remove(0, this.grid.UniqueID.LastIndexOf("$") + 1) : this.grid.ClientInstanceName;
ASPxGridViewExporter exporter = new ASPxGridViewExporter();
exporter.ID = callBackID + "_Exporter";
exporter.GridViewID = this.grid.ID;
this.grid.Controls.Add(exporter);
TableCell cellExportTable = new TableCell();
cellExportTable.Width = Unit.Percentage(100);
Table tblExport = new Table();
tblExport.HorizontalAlign = HorizontalAlign.Right;
TableRow rwExport = new TableRow();
TableCell exportCell = new TableCell();
exportCell.Text = "Export";
rwExport.Cells.Add(exportCell);
rwExport.Cells.AddRange(this.GetExportCells(callBackID));
cellExportTable.Controls.Add(tblExport);
tblExport.Rows.Add(rwExport);
rwContent.Cells.Add(cellExportTable);
}
tblContent.Rows.Add(rwContent);
container.Controls.Add(tblContent);
}
protected void btnXlsExport_Click(object sender, EventArgs e)
{
string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url);
using (Utils utility = new Utils())
{
utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod());
}
try
{
this.hdnClick.Value = "0";
DataSet dataSet = new DataSet();
dataSet = (DataSet)this.Session["TransferGridData"];
this.grdTransfer.DataSource = dataSet;
this.grdTransfer.DataBind();
ASPxGridViewExporter aSPxGridViewExporter = this.gridExport;
DateTime now = DateTime.Now;
aSPxGridViewExporter.FileName = string.Concat("Transfer_Details(", now.ToString("ddMMMMyyyy"), ")");
this.gridExport.WriteXlsToResponse();
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
using (Utils utility = new Utils())
{
utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod());
}
string str2 = "Error Request=" + id + ".Please share with Technical support.";
base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2);
}
//Method End
using (Utils utility = new Utils())
{
utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod());
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.GridID))
throw new NullReferenceException("GridID property is null.");
grid = NamingContainer.FindControl(GridID) as ASPxGridView;
if (grid == null)
throw new InvalidOperationException("ASPxGridView control was not found in NamingContainer.");
if (string.IsNullOrEmpty(this.SqlDataSourceID))
throw new NullReferenceException("SqlDataSourceID property is null.");
sqlDataSource = NamingContainer.FindControl(SqlDataSourceID) as SqlDataSource;
if (sqlDataSource == null)
throw new InvalidOperationException("SqlDataSourceID control was not found in NamingContainer.");
if (string.IsNullOrEmpty(this.GridViewExportID))
throw new NullReferenceException("GridViewExportID property is null.");
gridViewExport = NamingContainer.FindControl(GridViewExportID) as ASPxGridViewExporter;
if (gridViewExport == null)
throw new InvalidOperationException("ASPxGridViewExporter control was not found in NamingContainer.");
CreateControlCheckBoxes();
}
private void ExportRegister_Execute(object sender, SimpleActionExecuteEventArgs e)
{
ASPxGridListEditor listEditor = ((ListView)View).Editor as ASPxGridListEditor;
Type TypeObject = View.ObjectTypeInfo.Type;
string strObj="";
int countobj = 0;
if (View.ObjectTypeInfo.Type == typeof(ReportData))
{
foreach (ReportData obj in View.SelectedObjects)
{
strObj = (strObj == "" ? string.Format("ReportName='{0}'", obj.ReportName) : string.Format("{0} or ReportName='{1}'", strObj, obj.ReportName));
countobj++;
}
}
else
{
foreach (BaseObject obj in View.SelectedObjects)
{
strObj = (strObj == "" ? string.Format("Oid='{0}'", obj.Oid) : string.Format("{0} or Oid='{1}'", strObj, obj.Oid));
countobj++;
}
}
if (countobj > 2000)
throw new UserFriendlyException(string.Format("Không thể export dữ liệu nhiều hơn 2000 dòng. Bạn đã chọn {0} dòng!!", countobj));
if (strObj != "")
{
if (listEditor != null)
{
ASPxGridView gv = listEditor.Grid;
using (ASPxGridViewExporter gridViewExporter = new ASPxGridViewExporter())
{
using (MemoryStream stream = new MemoryStream())
{
//gridViewExporter.WriteXlsToResponse();
gridViewExporter.GridViewID = gv.ID;
gridViewExporter.Page = gv.Page;
gv.Parent.Controls.Add(gridViewExporter);
gv.BeginUpdate();
gv.DataSource = new XPCollection(View.ObjectSpace.Session, TypeObject,
CriteriaOperator.Parse(strObj));
gv.DataBind();
gv.EndUpdate();
gridViewExporter.DataBind();
XlsExportOptions xlsExportOptions = new DevExpress.XtraPrinting.XlsExportOptions();
xlsExportOptions.SheetName = View.Caption.Replace(" ", "");
xlsExportOptions.TextExportMode = DevExpress.XtraPrinting.TextExportMode.Value;
xlsExportOptions.ShowGridLines = true;
gridViewExporter.WriteXls(stream, xlsExportOptions);
byte[] buffer = stream.GetBuffer();
string contentType = "application/ms-excel";
string contentDisposition = "attachment; filename=Export_Result.xls";
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Buffer = false;
HttpContext.Current.Response.AppendHeader("Content-Type", contentType);
HttpContext.Current.Response.AppendHeader("Content-Transfer-Encoding", "binary");
HttpContext.Current.Response.AppendHeader("Content-Disposition", contentDisposition);
HttpContext.Current.Response.BinaryWrite(buffer);
HttpContext.Current.Response.End();
}
}
}
}
}
internal static void ToolBarClick(ucABM ucABM1, string itemName, ASPxGridView gv, ASPxGridViewExporter ASPxGridViewExporter1)
{
switch (itemName)
{
case "btnAdd":
ucABM1.LimpiarControles();
FormsHelper.ShowOrHideButtons(ucABM1.tablaABM, FormsHelper.eAccionABM.Add);
ucABM1.Visible = true;
ucABM1.HeaderText = "Agregar Registro";
break;
case "btnEdit":
if (FormsHelper.GetSelectedId(gv) != null)
{
ucABM1.LimpiarControles();
var entity = ucABM1.ReadMethod(FormsHelper.GetSelectedId(gv).Value);
FormsHelper.FillControls(entity, ucABM1.tablaABM);
FormsHelper.ShowOrHideButtons(ucABM1.tablaABM, FormsHelper.eAccionABM.Edit);
ucABM1.Attributes.Add("RecId", entity.RecId.ToString());
ucABM1.Visible = true;
ucABM1.HeaderText = "Modificar Registro";
}
else
{
ucABM1.Visible = false;
}
break;
case "btnDelete":
if (FormsHelper.GetSelectedId(gv) != null)
{
FormsHelper.ShowOrHideButtons(ucABM1.tablaABM, FormsHelper.eAccionABM.Delete);
ucABM1.Attributes.Add("RecId", FormsHelper.GetSelectedId(gv).ToString());
ucABM1.Visible = true;
ucABM1.HeaderText = "Eliminar Registros";
}
else
{
ucABM1.Visible = false;
}
break;
case "btnExport":
case "btnExportXls":
if (ASPxGridViewExporter1 != null)
ASPxGridViewExporter1.WriteXlsToResponse();
break;
case "btnExportPdf":
if (ASPxGridViewExporter1 != null)
ASPxGridViewExporter1.WritePdfToResponse();
break;
default:
break;
}
}
/// <summary>
/// Page Init event; creates all required controls in a page.
/// </summary>
/// <param name="sender">The page sending the event.</param>
/// <param name="e"></param>
protected void Page_Init(object sender, EventArgs e)
{
var user = HttpContext.Current.Session["user"] as User;
int userId = 0;
if (user != null)
{
userId = user.Id;
}
int assemblyTypeId = HttpContext.Current.Session["assemblyType"].ToString().ToInt32(0);
//if (userId == 0 || assemblyTypeId == 0)
//{
// invalid state. forced to logout
// TODO: User RolePermissionHelper.Logout
// RolePermissionHelper.RedirectToLogin();
// Response.Redirect("/Account/Logout.aspx");
//}
var masterPage = this.Controls[0] as IMainMaster;
if (masterPage == null)
{
Response.Write("<p>Your master page must implement IMainMaster interface.</p>");
}
//Schema is loaded during login
var schemaInfo = Application["SchemaInfo"] as SchemaInfo;
tableMeta = schemaInfo.Tables.Where(s => s.Name.Equals(tableName, StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault();
if (tableMeta == null)
{
var page = this.Controls[0] as IMainMaster;
page.MainContent.Controls.Add(new LiteralControl(string.Format("<h2>{0}</h2>", "Invalid Page")));
return;
}
//header info
string StationAct = Request.QueryString["StationAct"].ToString();
int ProductionLineId = Convert.ToInt32(Request.QueryString["ProductionLineId"]);
string Date1 = Request.QueryString["Date1"].ToString();
//DateTime Date = DateTime.Parse(dt);
string header = "";
//parameter to the stored procedure
//if it is a stored procedure, use comma as separator for paramater/filter. do not user AND/OR logical operation
string queryFilter = null;
if (tableMeta.TableType == ETableType.StoredProcedure)
{
queryFilter = string.Format("Date1={0}{1}ProductionLineId={2}{3}StationAct={4}", Date1, AppConfiguration.SP_FILTER_SEPARATOR, ProductionLineId, AppConfiguration.SP_FILTER_SEPARATOR, StationAct);
}
else
{
if (StationAct != "")
{
queryFilter = "StationAct=" + StationAct;
if (ProductionLineId > 0)
{
queryFilter += " AND ProductionLineId=" + ProductionLineId;
}
if (Date1 != null)
{
queryFilter += " AND Date=" + Date1;
}
}
}
//create the page
var gridCreator = new MasterGrid(this, this.tableMeta);
masterGrid = gridCreator.Render(userId, assemblyTypeId, queryFilter);
//create filter panel
var filterPanelCreator = new FilterPanel(this, this.tableMeta);
filterPanel = filterPanelCreator.Render(userId, assemblyTypeId);
//create hidden field to store temporary data
var field = new ASPxHiddenField();
field.ID = HIDDEN_FIELD_ID;
field.ClientInstanceName = HIDDEN_FIELD_ID;
//var scriptManager = new ASPxScriptManager();
var panel = new System.Web.UI.WebControls.Panel();
panel.CssClass = "mainContent";
panel.Controls.Add(new LiteralControl(string.Format("<h2 class='grid-header'>{0}</h2>", tableMeta.Caption)));
panel.Controls.Add(new LiteralControl(string.Format("<p>" + StationAct + " Line " + ProductionLineId + " On " + Date1 + "</p>")));
if (filterPanel != null)
{
panel.Controls.Add(filterPanel);
}
panel.Controls.Add(masterGrid);
if (masterGrid.Width.Value > 0)
{
panel.Width = masterGrid.Width;
}
panel.Controls.Add(field);
if (tableMeta.ShowExportButton)
{
var buttonPanel = new System.Web.UI.WebControls.Panel();
buttonPanel.CssClass = "grid-button-panel";
buttonPanel.Width = new Unit("100%");
//buttonPanel.BorderWidth = new Unit("1px");
//add export button
ASPxButton btnExport = new ASPxButton();
btnExport.ID = "btnExportGrid";
btnExport.Text = "Export to Excel";
btnExport.Click += btnExport_click;
btnExport.CssClass = "btn-export-xls";
//btnExport.Width = new Unit("100%");
#if _BTN_NATIVE_
btnExport.CssClass = "btn btn-export btn-xs";
btnExport.Native = true;
#endif
buttonPanel.Controls.Add(btnExport);
panel.Controls.Add(buttonPanel);
//add exporter grid
gridExporter = new ASPxGridViewExporter();
gridExporter.GridViewID = masterGrid.ID; //string.Concat(table, "GridView");
gridExporter.ID = "GridExport";
gridExporter.FileName = tableMeta.Name + " (" + header + ")";
gridExporter.ExportedRowType = GridViewExportedRowType.All;
panel.Controls.Add(gridExporter);
////add script manager
//panel.Controls.Add(scriptManager);
}
masterPage.MainContent.Controls.Add(panel);
masterPage.PageTitle.Controls.Add(new LiteralControl(tableMeta.Caption));
////re-apply the filtering if necessary
//if (tableMeta.ShowFilterPanel)
//{
// GridViewHelper.ApplyGridViewFilter(masterGrid, filterPanel, tableMeta);
//}
//else
//{
// masterGrid.DataBind();
//}
}
static internal void ToolBarClick(ucABM ucABM1, string itemName, ASPxGridView gv, ASPxGridViewExporter ASPxGridViewExporter1)
{
switch (itemName)
{
case "btnAdd":
ucABM1.LimpiarControles();
FormsHelper.ShowOrHideButtons(ucABM1.tablaABM, FormsHelper.eAccionABM.Add);
ucABM1.Visible = true;
ucABM1.HeaderText = "Agregar Registro";
break;
case "btnEdit":
if (FormsHelper.GetSelectedId(gv) != null)
{
ucABM1.LimpiarControles();
var entity = ucABM1.ReadMethod(FormsHelper.GetSelectedId(gv).Value);
FormsHelper.FillControls(entity, ucABM1.tablaABM);
FormsHelper.ShowOrHideButtons(ucABM1.tablaABM, FormsHelper.eAccionABM.Edit);
ucABM1.Attributes.Add("RecId", entity.RecId.ToString());
ucABM1.Visible = true;
ucABM1.HeaderText = "Modificar Registro";
}
else
{
ucABM1.Visible = false;
}
break;
case "btnDelete":
if (FormsHelper.GetSelectedId(gv) != null)
{
FormsHelper.ShowOrHideButtons(ucABM1.tablaABM, FormsHelper.eAccionABM.Delete);
ucABM1.Attributes.Add("RecId", FormsHelper.GetSelectedId(gv).ToString());
ucABM1.Visible = true;
ucABM1.HeaderText = "Eliminar Registros";
}
else
{
ucABM1.Visible = false;
}
break;
case "btnExport":
case "btnExportXls":
if (ASPxGridViewExporter1 != null)
{
ASPxGridViewExporter1.WriteXlsToResponse();
}
break;
case "btnExportPdf":
if (ASPxGridViewExporter1 != null)
{
ASPxGridViewExporter1.WritePdfToResponse();
}
break;
default:
break;
}
}
