private void LoadReports() { BPQuickReports bp = new BPQuickReports(); ddlReports.DataSource = bp.SelectAll(); ddlReports.DataMember = "tbl_QuickReports"; ddlReports.DataTextField = "QuickReportAlias"; ddlReports.DataValueField = "QuickReportID"; ddlReports.DataBind(); ddlReports.Items.Insert(0,new ListItem("All Reports","0")); }
private void LoadTables() { ddlTables.Items.Clear(); BPQuickReports bp = new BPQuickReports(); if (ddlReports.SelectedValue == "0") { //ddlTables.DataSource = bp.SelectAll(); } else { ddlTables.DataSource = bp.SelectByID(Convert.ToInt32(ddlReports.SelectedValue)); } ddlTables.DataMember = "tbl_QuickReports"; ddlTables.DataTextField = "TableName"; ddlTables.DataValueField = "QuickReportID"; ddlTables.DataBind(); ddlTables.Items.Insert(0,new ListItem("Select Table","0")); }
private void btnCancel_Click(object sender, System.EventArgs e) { if(GeneratedReportType == QuickReport.GeneratedReportTypes.Report) { Response.Redirect("BrowseQuickReports.aspx?QuickReportID=" + Convert.ToInt32(QuickReportID)); } else { BPQuickReports bp = new BPQuickReports(); DSQuickReports = bp.SelectByID(QuickReportID); BEQuickReports.tbl_QuickReportsRow quickReport = DSQuickReports.tbl_QuickReports.FindByQuickReportID(QuickReportID); Response.Redirect(quickReport.BrowsePage); } }
private void btnGenerate_Click(object sender, EventArgs e) { if (GeneratedReportID == 0) { lblError.Visible = true; } else { if (GeneratedReportType == QuickReport.GeneratedReportTypes.Browse) { BPQuickReports bp = new BPQuickReports(); DSQuickReports = bp.SelectByID(QuickReportID); BEQuickReports.tbl_QuickReportsRow quickReport = DSQuickReports.tbl_QuickReports.FindByQuickReportID(QuickReportID); Response.Redirect(quickReport.BrowsePage + "?GeneratedReportID=" + GeneratedReportID); } else { Response.Redirect("ViewReport.aspx?GeneratedReportID=" + GeneratedReportID + "&CompanyID=" + CompanyID); } } }
private void GetQuickReportID() { DataSet ds; BPQuickReports bp = new BPQuickReports(); string PageName = Request.ServerVariables["script_name"]; PageName = PageName.Substring(PageName.LastIndexOf('/') + 1); ds = bp.SelectQuickReportIdByBrowsePage(PageName); switch (ds.Tables[0].Rows.Count) { case 0: break; case 1: QuickReportID = Convert.ToInt32(ds.Tables[0].Rows[0][0]); break; default: break; } }
public LinkButtonTemplate(string columnName, int generatedReportID) { _ColumnName = columnName; BPQuickReports bp = new BPQuickReports(); BEQuickReports DSQuickReports = new BEQuickReports(); DSQuickReports = bp.SelectByGeneratedReportID(generatedReportID); _editPage = ((BEQuickReports.tbl_QuickReportsRow) DSQuickReports.tbl_QuickReports.Rows[0]).EditPage; _primaryKey = ((BEQuickReports.tbl_QuickReportsRow) DSQuickReports.tbl_QuickReports.Rows[0]).TablePrimaryKey; }
private void GetQuickReportID() { BPQuickReports bp = new BPQuickReports(); DSGeneratedReports = bp.SelectByGeneratedReportID(GeneratedReportID); if (DSGeneratedReports.tbl_QuickReports.Count > 0) { BEQuickReports.tbl_QuickReportsRow row = DSGeneratedReports.tbl_QuickReports[0]; QuickReportID = row.QuickReportID; // lblTitle.Text = row.GeneratedReportName; } }