protected void Page_Load(object sender, EventArgs e) { email = QueryHelper.GetString(Server.UrlDecode("email"), String.Empty); Guid subscriptionGUID = QueryHelper.GetGuid("guid", Guid.Empty); rsi = ReportSubscriptionInfoProvider.GetReportSubscriptionInfo(subscriptionGUID); if (rsi != null) { ri = ReportInfoProvider.GetReportInfo(rsi.ReportSubscriptionReportID); if (ri != null) { // Set info label based by subscription's report lblInfo.Text = String.Format(GetString("reportsubscription.unsubscription.info"), email, ri.ReportDisplayName); } } else { ShowError(GetString("reportsubscription.notfound")); pnlInfo.Visible = false; btnUnsubscribe.Enabled = false; } btnUnsubscribe.Text = GetString("reportsubscription.unsubscribe"); Title = GetString("reportsubscription.unsubscribe.title"); CurrentMaster.Title.TitleText = GetString("reportsubscription.unsubscribe.title"); CurrentMaster.Title.TitleImage = GetImageUrl("/CMSModules/CMS_Reporting/Subscription24.png"); }
public void SerializationTest() { const string ReportName = "Report"; const string KeyName = "item "; const string ValueName = "value "; const int ParamCount = 2; var reportParameters = new Dictionary<string, object>(); for (var i = 0; i < ParamCount; i++) { reportParameters.Add(KeyName + i, ValueName + i); } var report = new ReportInfo(ReportName, reportParameters); var serializedReport = report.ToString(); var deserializedReport = serializedReport.ToReportInfo(); Assert.AreEqual(deserializedReport.ReportName, ReportName); for (var i = 0; i < ParamCount; i++) { Assert.AreEqual(deserializedReport.ReportParametres[KeyName + i], ValueName + i); } }
public MsReportForm(string reportInfoName) : this() { m_reportInfo = ADInfoBll.Instance.GetReportInfo(reportInfoName); if (m_reportInfo == null) { throw new ArgumentException("不存在名为" + reportInfoName + "的ReportInfo!"); } string reportFile = ReportHelper.CreateMsReportFile(m_reportInfo.ReportDocument); this.reportViewer1.LocalReport.ReportPath = reportFile; m_dataSet = ReportHelper.CreateDataset(m_reportInfo.DatasetName); foreach (DataTable dt in m_dataSet.Tables) { this.reportViewer1.LocalReport.DataSources.Add( new Microsoft.Reporting.WinForms.ReportDataSource(m_dataSet.DataSetName + "_" + dt.TableName, dt)); } m_reportDataInfos = ADInfoBll.Instance.GetReportDataInfo(m_reportInfo.Name); foreach (ReportDataInfo reportDataInfo in m_reportDataInfos) { if (string.IsNullOrEmpty(reportDataInfo.SearchManagerClassName)) { throw new ArgumentException("ReportDataInfo of " + reportDataInfo.Name + " 's SearchManagerClassName must not be null!"); } ISearchManager sm = ServiceProvider.GetService<IManagerFactory>().GenerateSearchManager(reportDataInfo.SearchManagerClassName, reportDataInfo.SearchManagerClassParams); sm.EnablePage = false; m_sms.Add(sm); } this.FormClosed += new FormClosedEventHandler(MsReportForm_FormClosed); }
public void ItemName() { ReportInfo reportInfo = new ReportInfo("SomePath\\Logs\\MarketTestInput - Kernite - 2007.01.28 112233.txt"); Assert.AreEqual("Kernite", reportInfo.ItemName); reportInfo = new ReportInfo("SomePath\\Logs\\MarketTestInput-Kernite-2007.01.28 112233.txt"); Assert.AreEqual("Kernite", reportInfo.ItemName); }
public void Region() { ReportInfo reportInfo = new ReportInfo("SomePath\\Logs\\FunnyRegion - Kernite - 2007.01.28 112233.txt"); Assert.AreEqual("FunnyRegion", reportInfo.Region); reportInfo = new ReportInfo("SomePath\\Logs\\FunnyRegion-Kernite-2007.01.28 112233.txt"); Assert.AreEqual("FunnyRegion", reportInfo.Region); }
/// <summary> /// Returns true if graph belongs to report. /// </summary> /// <param name="report">Report to validate</param> public override bool IsValid(ReportInfo report) { ReportValueInfo rvi = ValueInfo; if ((report != null) && (rvi != null) && (report.ReportID == rvi.ValueReportID)) { return true; } return false; }
public void ItemsWithDashesInTheirName() { ReportInfo reportInfo = new ReportInfo("Lonetrek - Limited Ocular Filter - Beta - 2007.05.04 144310.txt"); Assert.AreEqual("Limited Ocular Filter - Beta", reportInfo.ItemName); reportInfo = new ReportInfo("Lonetrek - Limited Ocular Filter 'Gunslinger' - TXL-1 - 2007.05.04 144310.txt"); Assert.AreEqual("Limited Ocular Filter 'Gunslinger' - TXL-1", reportInfo.ItemName); reportInfo = new ReportInfo("Lonetrek-Limited Ocular Filter 'Gunslinger' - TXL-1-2007.05.04 144310.txt"); Assert.AreEqual("Limited Ocular Filter 'Gunslinger' - TXL-1", reportInfo.ItemName); }
public void ItemDateIsInTheFuture() { ReportInfo reportInfo = new ReportInfo("SomePath\\Logs\\MarketTestInput - Kernite - 5007.01.01 010101.txt"); // dates from the future should be clamped to the current date/time (accurate to the minute is good enough) string expected = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString(); Assert.AreEqual(expected, reportInfo.Date.ToShortDateString() + " " + reportInfo.Date.ToShortTimeString()); reportInfo = new ReportInfo("SomePath\\Logs\\MarketTestInput-Kernite-5007.01.01 010101.txt"); // dates from the future should be clamped to the current date/time (accurate to the minute is good enough) Assert.AreEqual(expected, reportInfo.Date.ToShortDateString() + " " + reportInfo.Date.ToShortTimeString()); }
public void ItemDate() { DateTime expected = new DateTime(2007, 01, 14, 9, 30, 13); ReportInfo reportInfo = new ReportInfo("SomePath\\Logs\\MarketTestInput - Kernite - 2007.01.14 093013.txt"); // dates should be reported in local time Assert.AreEqual(TimeZone.CurrentTimeZone.ToLocalTime(expected), reportInfo.Date); reportInfo = new ReportInfo("SomePath\\Logs\\MarketTestInput-Kernite-2007.01.14 093013.txt"); // dates should be reported in local time Assert.AreEqual(TimeZone.CurrentTimeZone.ToLocalTime(expected), reportInfo.Date); }
public MyReportForm(string reportInfoName) : this() { m_reportInfo = ADInfoBll.Instance.GetReportInfo(reportInfoName); if (m_reportInfo == null) { throw new ArgumentException("不存在名为" + reportInfoName + "的ReportInfo!"); } ReportDocument reportDocument = ReportHelper.CreateReportDocument(m_reportInfo.ReportDocument); this.crystalReportViewer1.CrystalHelper.ReportSource = reportDocument; this.crystalReportViewer1.TemplateDataSet = ReportHelper.CreateDataset(m_reportInfo.DatasetName); m_reportDataInfos = ADInfoBll.Instance.GetReportDataInfo(m_reportInfo.Name); //FillDataSet(data, this.TemplateDataSet); //if (m_reportInfo.AfterProcess != null) //{ // ADUtils.ExecuteProcess(ADInfoBll.Instance.GetProcessInfo(m_reportInfo.AfterProcess.Name), // new Dictionary<string, object> { { "masterForm", this } }); //} foreach (ReportDataInfo reportDataInfo in m_reportDataInfos) { if (string.IsNullOrEmpty(reportDataInfo.SearchManagerClassName)) { throw new ArgumentException("ReportDataInfo of " + reportDataInfo.Name + " 's SearchManagerClassName must not be null!"); } ISearchManager sm = ServiceProvider.GetService<IManagerFactory>().GenerateSearchManager(reportDataInfo.SearchManagerClassName, reportDataInfo.SearchManagerClassParams); sm.EnablePage = false; m_sms.Add(sm); } this.FormClosed += new FormClosedEventHandler(MyReportForm_FormClosed); }
protected void Page_Load(object sender, EventArgs e) { ucSelectString.Scope = ReportInfo.OBJECT_TYPE; ConnectionStringRow.Visible = MembershipContext.AuthenticatedUser.IsAuthorizedPerResource("cms.reporting", "SetConnectionString"); txtQueryQuery.FullScreenParentElementID = pnlWebPartForm_Properties.ClientID; // Test permission for query txtQueryQuery.Enabled = MembershipContext.AuthenticatedUser.IsAuthorizedPerResource("CMS.Reporting", "EditSQLQueries"); versionList.OnAfterRollback += versionList_onAfterRollback; // Register script for resize and rollback RegisterResizeAndRollbackScript("divFooter", divScrolable.ClientID); tabControlElem.TabItems.Add(new UITabItem { Text = GetString("general.general") }); tabControlElem.TabItems.Add(new UITabItem { Text = GetString("general.preview") }); tabControlElem.UsePostback = true; Title = "ReportGraph Edit"; PageTitle.HelpTopicName = HELP_TOPIC_LINK; rfvCodeName.ErrorMessage = GetString("general.requirescodename"); rfvDisplayName.ErrorMessage = GetString("general.requiresdisplayname"); Save += (s, ea) => { if (SetData(true)) { ltlScript.Text += ScriptHelper.GetScript("window.RefreshContent();CloseDialog();"); } }; int reportId = QueryHelper.GetInteger("reportid", 0); bool isPreview = QueryHelper.GetBoolean("preview", false); // If preview by URL -> select preview tab if (isPreview && !RequestHelper.IsPostBack()) { tabControlElem.SelectedTab = 1; } if (reportId > 0) { mReportInfo = ReportInfoProvider.GetReportInfo(reportId); } if (PersistentEditedObject == null) { if (mReportInfo != null) //must be valid reportid parameter { int id = QueryHelper.GetInteger("objectid", 0); // Try to load graph name from hidden field (adding new graph & preview) if (id == 0) { id = ValidationHelper.GetInteger(txtNewGraphHidden.Value, 0); } if (id > 0) { PersistentEditedObject = ReportGraphInfoProvider.GetReportGraphInfo(id); mReportGraphInfo = PersistentEditedObject as ReportGraphInfo; } } } else { mReportGraphInfo = PersistentEditedObject as ReportGraphInfo; } if (mReportInfo != null) { ucSelectString.DefaultConnectionString = mReportInfo.ReportConnectionString; } if (mReportGraphInfo != null) { PageTitle.TitleText = GetString("Reporting_ReportGraph_EditHTML.TitleText"); mGraphId = mReportGraphInfo.GraphID; if (ObjectVersionManager.DisplayVersionsTab(mReportGraphInfo)) { tabControlElem.TabItems.Add(new UITabItem { Text = GetString("objectversioning.tabtitle") }); versionList.Object = mReportGraphInfo; versionList.IsLiveSite = false; } } else { PageTitle.TitleText = GetString("Reporting_ReportGraph_EditHTML.NewItemTitleText"); mNewReport = true; } if (!RequestHelper.IsPostBack()) { // Load default data for new report if (mNewReport) { ucSelectString.Value = String.Empty; txtQueryNoRecordText.Text = GetString("attachmentswebpart.nodatafound"); txtItemValueFormat.Text = "{%yval%}"; txtSeriesItemTooltip.Text = "{%ser%}"; chkExportEnable.Checked = true; chkSubscription.Checked = true; } // Otherwise load saved data else { LoadData(); } } CurrentMaster.PanelContent.RemoveCssClass("dialog-content"); CurrentMaster.PanelContent.RemoveCssClass("ModalDialogContent"); }
public ReportInfo Decode(string qrinfo) { int key = 0; try { key = Convert.ToInt32(qrinfo.Substring(qrinfo.Length - 3, 3)); key = key - 256; } catch (Exception) { return(null); } string values = qrinfo.Substring(0, qrinfo.Length - 3); values = Reverse(values); string info = UnicodeToString(StringToUnicode(values, key)); ReportInfo result = null; if (info.IndexOf("|") != -1) { result = new ReportInfo(); string[] str = info.Split('|'); for (int i = 0; i < str.Length; i++) { switch (i) { case 0: result.ReportNum = str[i]; break; case 1: result.ProjectName = str[i]; break; case 2: result.StructPart = str[i]; break; case 3: result.CheckItem = str[i]; break; case 4: result.CheckParam = str[i]; break; case 5: if (!str[i].Equals("C") && !str[i].Equals("")) { result.Conclusion = "详见" + result.ReportNum + "报告"; } else { result.Conclusion = "详见" + str[i] + "报告"; } break; case 6: result.ReportDate = str[i]; break; case 7: result.AntiFakeLabel = str[i]; break; case 8: result.ItemCode = str[i]; break; case 9: result.UnitCode = str[i]; break; default: break; } } } return(result); }
/// <summary> /// Gets and bulk updates reports. Called when the "Get and bulk update reports" button is pressed. /// Expects the CreateReport method to be run first. /// </summary> private bool GetAndBulkUpdateReports() { // Prepare the parameters string where = "ReportName LIKE N'MyNewReport%'"; string orderby = ""; int topN = 0; string columns = ""; // Get the data DataSet reports = ReportInfoProvider.GetReports(where, orderby, topN, columns); if (!DataHelper.DataSourceIsEmpty(reports)) { // Loop through the individual items foreach (DataRow reportDr in reports.Tables[0].Rows) { // Create object from DataRow ReportInfo modifyReport = new ReportInfo(reportDr); // Update the properties modifyReport.ReportDisplayName = modifyReport.ReportDisplayName.ToUpper(); // Save the changes ReportInfoProvider.SetReportInfo(modifyReport); } return true; } return false; }
public override void Execute(ReportInfo RI) { string reportsResultFolder = string.Empty; HTMLReportsConfiguration currentConf = WorkSpace.Instance.Solution.HTMLReportsConfigurationSetList.Where(x => (x.IsSelected == true)).FirstOrDefault(); if (WorkSpace.Instance.RunsetExecutor.RunSetConfig.RunsetExecLoggerPopulated) { string runSetFolder = string.Empty; if (WorkSpace.Instance.RunsetExecutor.RunSetConfig.LastRunsetLoggerFolder != null) { runSetFolder = WorkSpace.Instance.RunsetExecutor.RunSetConfig.LastRunsetLoggerFolder; AutoLogProxy.UserOperationStart("Online Report"); } else { runSetFolder = ExecutionLogger.GetRunSetLastExecutionLogFolderOffline(); AutoLogProxy.UserOperationStart("Offline Report"); } if (!string.IsNullOrEmpty(selectedHTMLReportTemplateID.ToString())) { ObservableList <HTMLReportConfiguration> HTMLReportConfigurations = WorkSpace.Instance.SolutionRepository.GetAllRepositoryItems <HTMLReportConfiguration>(); if ((isHTMLReportFolderNameUsed) && (HTMLReportFolderName != null) && (HTMLReportFolderName != string.Empty)) { string currentHTMLFolderName = string.Empty; if (!isHTMLReportPermanentFolderNameUsed) { currentHTMLFolderName = HTMLReportFolderNameCalculated + "\\" + System.IO.Path.GetFileName(runSetFolder); } else { currentHTMLFolderName = HTMLReportFolderNameCalculated; } reportsResultFolder = Ginger.Reports.GingerExecutionReport.ExtensionMethods.CreateGingerExecutionReport(new ReportInfo(runSetFolder), false, HTMLReportConfigurations.Where(x => (x.ID == selectedHTMLReportTemplateID)).FirstOrDefault(), currentHTMLFolderName, isHTMLReportPermanentFolderNameUsed, currentConf.HTMLReportConfigurationMaximalFolderSize); } else { reportsResultFolder = Ginger.Reports.GingerExecutionReport.ExtensionMethods.CreateGingerExecutionReport(new ReportInfo(runSetFolder), false, HTMLReportConfigurations.Where(x => (x.ID == selectedHTMLReportTemplateID)).FirstOrDefault(), null, isHTMLReportPermanentFolderNameUsed); } } else { reportsResultFolder = Ginger.Reports.GingerExecutionReport.ExtensionMethods.CreateGingerExecutionReport(new ReportInfo(runSetFolder), false, null, null, isHTMLReportPermanentFolderNameUsed); } } else { Errors = "In order to get HTML report, please, perform executions before"; Reporter.HideStatusMessage(); Status = Ginger.Run.RunSetActions.RunSetActionBase.eRunSetActionStatus.Failed; return; } }
protected void Page_Load(object sender, EventArgs e) { ucSelectString.Scope = ReportInfo.OBJECT_TYPE; ConnectionStringRow.Visible = MembershipContext.AuthenticatedUser.IsAuthorizedPerResource("cms.reporting", "SetConnectionString"); txtQuery.FullScreenParentElementID = pnlWebPartForm_Properties.ClientID; // Test permission for query txtQuery.Enabled = MembershipContext.AuthenticatedUser.IsAuthorizedPerResource("CMS.Reporting", "EditSQLQueries"); versionList.OnAfterRollback += versionList_onAfterRollback; // Register common resize and refresh scripts RegisterScripts("divFooter", divScrolable.ClientID); tabControlElem.TabItems.Add(new UITabItem { Text = GetString("general.general") }); tabControlElem.TabItems.Add(new UITabItem { Text = GetString("general.preview") }); tabControlElem.UsePostback = true; rfvCodeName.ErrorMessage = GetString("general.requirescodename"); rfvDisplayName.ErrorMessage = GetString("general.requiresdisplayname"); Save += (s, ea) => { if (SetData(true)) { ltlScript.Text += ScriptHelper.GetScript("window.RefreshContent();CloseDialog();"); } }; int reportId = QueryHelper.GetInteger("reportid", 0); bool preview = QueryHelper.GetBoolean("preview", false); if (reportId > 0) { mReportInfo = ReportInfoProvider.GetReportInfo(reportId); } // If preview by URL -> select preview tab bool isPreview = QueryHelper.GetBoolean("preview", false); if (isPreview && !RequestHelper.IsPostBack()) { tabControlElem.SelectedTab = 1; } if (PersistentEditedObject == null) { if (mReportInfo != null) // Must be valid reportid parameter { int id = QueryHelper.GetInteger("objectid", 0); // Try to load tableName from hidden field (adding new graph & preview) if (id == 0) { id = ValidationHelper.GetInteger(txtNewTableHidden.Value, 0); } if (id > 0) { PersistentEditedObject = ReportTableInfoProvider.GetReportTableInfo(id); mReportTableInfo = PersistentEditedObject as ReportTableInfo; } } } else { mReportTableInfo = PersistentEditedObject as ReportTableInfo; } if (mReportInfo != null) { ucSelectString.DefaultConnectionString = mReportInfo.ReportConnectionString; // Control text initializations if (mReportTableInfo != null) { PageTitle.TitleText = GetString("Reporting_ReportTable_Edit.TitleText"); mTableId = mReportTableInfo.TableID; if (ObjectVersionManager.DisplayVersionsTab(mReportTableInfo)) { tabControlElem.TabItems.Add(new UITabItem { Text = GetString("objectversioning.tabtitle") }); versionList.Object = mReportTableInfo; versionList.IsLiveSite = false; } } else // New item { PageTitle.TitleText = GetString("Reporting_ReportTable_Edit.NewItemTitleText"); if (!RequestHelper.IsPostBack()) { ucSelectString.Value = String.Empty; txtPageSize.Text = "15"; txtQueryNoRecordText.Text = GetString("attachmentswebpart.nodatafound"); chkExportEnable.Checked = true; chkSubscription.Checked = true; } } if (!RequestHelper.IsPostBack()) { ControlsHelper.FillListControlWithEnum <PagerButtons>(drpPageMode, "PagerButtons"); // Preselect page numbers paging drpPageMode.SelectedValue = ((int)PagerButtons.Numeric).ToString(); LoadData(); } } if ((preview) && (!RequestHelper.IsPostBack())) { tabControlElem.SelectedTab = 1; ShowPreview(); } // In case of preview paging without saving table if (RequestHelper.IsPostBack() && tabControlElem.SelectedTab == 1) { // Reload default parameters FormInfo fi = new FormInfo(mReportInfo.ReportParameters); // Get datarow with required columns ctrlReportTable.ReportParameters = fi.GetDataRow(false); fi.LoadDefaultValues(ctrlReportTable.ReportParameters, true); // Collect data and put them in table info SetData(); ctrlReportTable.TableInfo = mReportTableInfo; } }
/// <summary> /// Returns report graph. /// </summary> private void GetReportGraph(ReportGraphInfo reportGraph) { // Check whether report graph is defined if (reportGraph == null) { return; } report = ReportInfoProvider.GetReportInfo(reportGraph.GraphReportID); if (report == null) { return; } // Check graph security settings if (!(CheckReportAccess(report) && CheckEmailModeSubscription(report, ValidationHelper.GetBoolean(ReportGraphInfo.GraphSettings["SubscriptionEnabled"], true)))) { Visible = false; return; } // Prepare query attributes QueryText = reportGraph.GraphQuery; QueryIsStoredProcedure = reportGraph.GraphQueryIsStoredProcedure; // Init parameters InitParameters(report.ReportParameters); // Init macro resolver InitResolver(); // Indicaates whether exception was throw during data loading errorOccurred = false; // Create graph data try { // Load data DataSource = LoadData(); } catch (Exception ex) { EventLogProvider.LogException("Get report graph", "E", ex); lblError.Text = ex.Message; lblError.Visible = true; errorOccurred = true; } if (DataHelper.DataSourceIsEmpty(DataSource) && EmailMode && SendOnlyNonEmptyDataSource) { Visible = false; return; } }
public ReportPrinter(ReportInfo info) { ReportInfo = info; }
/// <summary> /// Sets data to database. /// </summary> protected void SaveReport() { // Check 'Modify' permission if (!CMSContext.CurrentUser.IsAuthorizedPerResource("cms.reporting", "Modify")) { RedirectToAccessDenied("cms.reporting", "Modify"); } string errorMessage = new Validator().NotEmpty(txtReportDisplayName.Text.Trim(), rfvReportDisplayName.ErrorMessage).NotEmpty(txtReportName.Text.Trim(), rfvReportName.ErrorMessage).Result; if ((errorMessage == "") && (!ValidationHelper.IsCodeName(txtReportName.Text.Trim()))) { errorMessage = GetString("general.invalidcodename"); } ReportAccessEnum reportAccess = ReportAccessEnum.All; if (!chkReportAccess.Checked) { reportAccess = ReportAccessEnum.Authenticated; } if (String.IsNullOrEmpty(errorMessage)) { ReportInfo reportInfo = ReportInfoProvider.GetReportInfo(reportId); ReportInfo nri = ReportInfoProvider.GetReportInfo(txtReportName.Text.Trim()); // If report with given name already exists show error message if ((nri != null) && (nri.ReportID != reportInfo.ReportID)) { ShowError(GetString("Report_New.ReportAlreadyExists")); return; } if (reportInfo != null) { reportInfo.ReportLayout = htmlTemplateBody.ResolvedValue; // If there was a change in report code name change codenames in layout if (reportInfo.ReportName != txtReportName.Text.Trim()) { // part of old macro string oldValue = "?" + reportInfo.ReportName + "."; string newValue = "?" + txtReportName.Text.Trim() + "."; reportInfo.ReportLayout = reportInfo.ReportLayout.Replace(oldValue, newValue); // Set updated text back to HTML editor htmlTemplateBody.ResolvedValue = reportInfo.ReportLayout; } int categoryID = ValidationHelper.GetInteger(selectCategory.Value, reportInfo.ReportCategoryID); // If there was a change in display name refresh category tree if ((reportInfo.ReportDisplayName != txtReportDisplayName.Text.Trim()) || (reportInfo.ReportCategoryID != categoryID)) { ltlScript.Text += ScriptHelper.GetScript(@"if ((parent != null) && (parent.Refresh != null)) {parent.Refresh();}"); } reportInfo.ReportDisplayName = txtReportDisplayName.Text.Trim(); reportInfo.ReportName = txtReportName.Text.Trim(); reportInfo.ReportAccess = reportAccess; reportInfo.ReportCategoryID = categoryID; reportInfo.ReportEnableSubscription = chkEnableSubscription.Checked; reportInfo.ReportConnectionString = ValidationHelper.GetString(ucSelectString.Value, String.Empty); ReportInfoProvider.SetReportInfo(reportInfo); ShowChangesSaved(); // Reload header if changes were saved ScriptHelper.RefreshTabHeader(Page, GetString("general.general")); } } else { ShowError(errorMessage); } }
protected void Page_Load(object sender, EventArgs e) { ucSelectString.Scope = PredefinedObjectType.REPORT; pnlConnectionString.Visible = CMSContext.CurrentUser.IsAuthorizedPerResource("cms.reporting", "SetConnectionString"); Title = "Report General"; ScriptHelper.RegisterClientScriptBlock(this, typeof(string), "ReloadPage", ScriptHelper.GetScript("function ReloadPage() { \n" + Page.ClientScript.GetPostBackEventReference(btnHdnReload, null) + "}")); reportId = ValidationHelper.GetInteger(Request.QueryString["reportId"], 0); // control initializations rfvReportDisplayName.ErrorMessage = GetString("Report_New.EmptyDisplayName"); rfvReportName.ErrorMessage = GetString("Report_New.EmptyCodeName"); lblReportDisplayName.Text = GetString("Report_New.DisplayNameLabel"); lblReportName.Text = GetString("Report_New.NameLabel"); lblReportCategory.Text = GetString("Report_General.CategoryLabel"); lblLayout.Text = GetString("Report_General.LayoutLabel"); lblGraphs.Text = GetString("Report_General.GraphsLabel") + ":"; lblHtmlGraphs.Text = GetString("Report_General.HtmlGraphsLabel") + ":"; lblTables.Text = GetString("Report_General.TablesLabel") + ":"; lblValues.Text = GetString("Report_General.TablesValues") + ":"; lblReportAccess.Text = GetString("Report_General.ReportAccessLabel"); actionsElem.ActionsList.Add(new SaveAction(Page)); actionsElem.ActionPerformed += new CommandEventHandler(actionsElem_ActionPerformed); AttachmentTitle.TitleText = GetString("general.attachments"); attachmentList.AllowPasteAttachments = true; attachmentList.ObjectID = reportId; attachmentList.ObjectType = ReportingObjectType.REPORT; attachmentList.Category = MetaFileInfoProvider.OBJECT_CATEGORY_LAYOUT; // Get report info ri = ReportInfoProvider.GetReportInfo(reportId); if (!RequestHelper.IsPostBack()) { LoadData(); } htmlTemplateBody.AutoDetectLanguage = false; htmlTemplateBody.DefaultLanguage = Thread.CurrentThread.CurrentCulture.TwoLetterISOLanguageName; htmlTemplateBody.EditorAreaCSS = ""; ScriptHelper.RegisterClientScriptBlock(this, typeof(string), "ReportingHTML", ScriptHelper.GetScript(" var reporting_htmlTemplateBody = '" + htmlTemplateBody.ClientID + "'")); // initialize item list controls ilGraphs.Report = ri; ilTables.Report = ri; ilValues.Report = ri; ilHtmlGraphs.Report = ri; ilGraphs.EditUrl = "ReportGraph_Edit.aspx"; ilTables.EditUrl = "ReportTable_Edit.aspx"; ilValues.EditUrl = "ReportValue_Edit.aspx"; ilHtmlGraphs.EditUrl = "ReportHtmlGraph_Edit.aspx"; ilGraphs.ItemType = ReportItemType.Graph; ilTables.ItemType = ReportItemType.Table; ilValues.ItemType = ReportItemType.Value; ilHtmlGraphs.ItemType = ReportItemType.HtmlGraph; // Refresh script string script = "function RefreshWOpener(w) { if (w.refreshPageOnClose){ " + ControlsHelper.GetPostBackEventReference(this, "arg") + " }}"; ScriptHelper.RegisterClientScriptBlock(this, typeof(string), "ReportingRefresh", ScriptHelper.GetScript(script)); }
public abstract void Execute(ReportInfo RI);
internal void ExecuteWithRunPageBFES() { ReportInfo RI = new ReportInfo(App.RunsetExecutor.RunsetExecutionEnvironment, App.RunsetExecutor); RunAction(RI); }
/// <summary> /// Returns report graph. /// </summary> private void GetReportGraph(ReportGraphInfo reportGraph) { Visible = true; ucChart.Visible = true; int correctWidth = 0; if (ComputedWidth != 0) { correctWidth = ModifyGraphInfo(); } if (Width != String.Empty) { int graphWidth = ValidationHelper.GetInteger(Width, 0); if (graphWidth != 0) { reportGraph.GraphWidth = graphWidth; } } if (Height != 0) { reportGraph.GraphHeight = Height; } ReportGraph graph = new ReportGraph(); graph.ChartControl = ucChart; report = ReportInfoProvider.GetReportInfo(reportGraph.GraphReportID); if (report == null) { return; } // Check graph security settings if (report.ReportAccess != ReportAccessEnum.All) { if (!CMSContext.CurrentUser.IsAuthenticated()) { Visible = false; return; } } // Set default parametrs directly if not set if (ReportParameters == null) { // Load ReportInfo if (report != null) { FormInfo fi = new FormInfo(report.ReportParameters); // Get datarow with required columns ReportParameters = fi.GetDataRow(false); fi.LoadDefaultValues(ReportParameters, true); } } // If used via widget - this function ensure showing specific interval from actual time (f.e. last 6 weeks) ApplyTimeParameters(); // Only use base parameters in case of stored procedure if (QueryIsStoredProcedure) { AllParameters = SpecialFunctions.ConvertDataRowToParams(ReportParameters, null); } ContextResolver resolver = CMSContext.CurrentResolver.CreateContextChild(); errorOccurred = false; // Create graph image try { // Resolve parameters in query resolver.SourceParameters = AllParameters.ToArray(); // Resolve dynamic data macros if (DynamicMacros != null) { for (int i = 0; i <= DynamicMacros.GetUpperBound(0); i++) { resolver.AddDynamicParameter(DynamicMacros[i, 0], DynamicMacros[i, 1]); } } // Prepare query attributes QueryText = resolver.ResolveMacros(reportGraph.GraphQuery); QueryIsStoredProcedure = reportGraph.GraphQueryIsStoredProcedure; // LoadData DataSet dsGraphData = LoadData(); // Empty dataset, and flag not send empty dataset is set if (SendOnlyNonEmptyDataSource && EmailMode && DataHelper.DataSourceIsEmpty(dsGraphData)) { Visible = false; return; } // Test if dataset is empty if (DataHelper.DataSourceIsEmpty(dsGraphData)) { string noRecordText = CMSContext.ResolveMacros(ValidationHelper.GetString(reportGraph.GraphSettings["QueryNoRecordText"], String.Empty)); if (noRecordText != String.Empty) { ltlEmail.Text = noRecordText; lblInfo.Text = noRecordText; ucChart.Visible = false; menuCont.MenuID = String.Empty; EnableExport = false; plcInfo.Visible = true; } else { Visible = false; } } else { // Create Chart graph.CorrectWidth = correctWidth; if (EmailMode) { byte[] data = graph.CreateChart(reportGraph, dsGraphData, resolver, true); ltlEmail.Text = "##InlineImage##" + reportGraph.GraphName + "##InlineImage##"; ReportSubscriptionSender.AddToRequest(report.ReportName, "g" + reportGraph.GraphName, data); } else { graph.CreateChart(reportGraph, dsGraphData, resolver); } } // Check if subscription is allowed EnableSubscription = (EnableSubscription && ValidationHelper.GetBoolean(ReportGraphInfo.GraphSettings["SubscriptionEnabled"], true) && report.ReportEnableSubscription); if (EmailMode && !EnableSubscription) { this.Visible = false; return; } } catch (Exception ex) { EventLogProvider ev = new EventLogProvider(); ev.LogEvent("Get report graph", "E", ex); graph.CorrectWidth = correctWidth; graph.CreateInvalidDataGraph(reportGraph, "Reporting.Graph.InvalidDataGraph", false); errorOccurred = true; } }
/// <summary> /// Returns report graph. /// </summary> private void GetReportGraph(ReportGraphInfo reportGraph) { Visible = true; ucChart.Visible = true; int correctWidth = 0; if (ComputedWidth != 0) { correctWidth = GetGraphWidth(); } if (Width != String.Empty) { int graphWidth = ValidationHelper.GetInteger(Width, 0); if (graphWidth != 0) { reportGraph.GraphWidth = graphWidth; } } if (Height != 0) { reportGraph.GraphHeight = Height; } ReportGraph graph = new ReportGraph() { Colors = Colors }; graph.ChartControl = ucChart; mReport = ReportInfoProvider.GetReportInfo(reportGraph.GraphReportID); if (mReport == null) { return; } // Check graph security settings if (!(CheckReportAccess(mReport) && CheckEmailModeSubscription(mReport, ValidationHelper.GetBoolean(ReportGraphInfo.GraphSettings["SubscriptionEnabled"], true)))) { Visible = false; return; } // Prepare query attributes QueryText = reportGraph.GraphQuery; QueryIsStoredProcedure = reportGraph.GraphQueryIsStoredProcedure; // Init parameters InitParameters(mReport.ReportParameters); // Init macro resolver InitResolver(); mErrorOccurred = false; DataSet dsGraphData = null; // Ensure report item name for caching if (String.IsNullOrEmpty(ReportItemName)) { ReportItemName = String.Format("{0};{1}", mReport.ReportName, reportGraph.GraphName); } // Create graph image try { // LoadData dsGraphData = LoadData(); } catch (Exception ex) { EventLogProvider.LogException("Get report graph", "E", ex); graph.CorrectWidth = correctWidth; graph.CreateInvalidDataGraph(reportGraph, "Reporting.Graph.InvalidDataGraph", false); mErrorOccurred = true; } // Test if dataset is empty if (DataHelper.DataSourceIsEmpty(dsGraphData)) { if (EmailMode && SendOnlyNonEmptyDataSource) { // Empty dataset, and flag not send empty dataset is set Visible = false; return; } string noRecordText = ResolveMacros(ValidationHelper.GetString(reportGraph.GraphSettings["QueryNoRecordText"], String.Empty)); if (noRecordText != String.Empty) { ltlEmail.Text = noRecordText; lblInfo.Text = noRecordText; ucChart.Visible = false; menuCont.MenuID = String.Empty; EnableExport = false; lblInfo.Visible = true; } else { Visible = false; } } else { // Create chart graph.CorrectWidth = correctWidth; if (EmailMode) { byte[] data = graph.CreateChart(reportGraph, dsGraphData, ContextResolver, true); ltlEmail.Text = "##InlineImage##" + reportGraph.GraphName + "##InlineImage##"; ReportSubscriptionSender.AddToRequest(mReport.ReportName, "g" + reportGraph.GraphName, data); } else { graph.CreateChart(reportGraph, dsGraphData, ContextResolver); } } }
public override void Execute(ReportInfo RI) { //TODO: check number of chars and show err if more or update Errors field SMSEmail.Send(); }
/// <summary> /// Returns true if graph belongs to report. /// </summary> /// <param name="report">Report to validate</param> public override bool IsValid(ReportInfo report) { ReportTableInfo rti = TableInfo; if ((report != null) && (rti != null) && (report.ReportID == rti.TableReportID)) { return true; } return false; }
protected void Page_Load(object sender, EventArgs e) { ucSelectString.Scope = ReportInfo.OBJECT_TYPE; ConnectionStringRow.Visible = MembershipContext.AuthenticatedUser.IsAuthorizedPerResource("cms.reporting", "SetConnectionString"); txtQuery.FullScreenParentElementID = pnlWebPartForm_Properties.ClientID; // Test permission for query txtQuery.Enabled = MembershipContext.AuthenticatedUser.IsAuthorizedPerResource("CMS.Reporting", "EditSQLQueries"); versionList.OnAfterRollback += versionList_onAfterRollback; PageTitle.HelpTopicName = HELP_TOPIC_LINK; tabControlElem.TabItems.Add(new UITabItem { Text = GetString("general.general") }); tabControlElem.TabItems.Add(new UITabItem { Text = GetString("general.preview") }); tabControlElem.UsePostback = true; RegisterResizeAndRollbackScript("divFooter", divScrolable.ClientID); rfvCodeName.ErrorMessage = GetString("general.requirescodename"); rfvDisplayName.ErrorMessage = GetString("general.requiresdisplayname"); int reportId = QueryHelper.GetInteger("reportid", 0); bool preview = QueryHelper.GetBoolean("preview", false); if (reportId > 0) { mReportInfo = ReportInfoProvider.GetReportInfo(reportId); } if (mReportInfo != null) //must be valid reportid parameter { ucSelectString.DefaultConnectionString = mReportInfo.ReportConnectionString; // If preview by URL -> select preview tab bool isPreview = QueryHelper.GetBoolean("preview", false); if (isPreview && !RequestHelper.IsPostBack()) { tabControlElem.SelectedTab = 1; } if (PersistentEditedObject == null) { int id = QueryHelper.GetInteger("objectid", 0); if (id > 0) { PersistentEditedObject = ReportValueInfoProvider.GetReportValueInfo(id); mReportValueInfo = PersistentEditedObject as ReportValueInfo; } } else { mReportValueInfo = PersistentEditedObject as ReportValueInfo; } if (mReportValueInfo != null) { PageTitle.TitleText = GetString("Reporting_ReportValue_Edit.TitleText"); mValueId = mReportValueInfo.ValueID; if (ObjectVersionManager.DisplayVersionsTab(mReportValueInfo)) { tabControlElem.TabItems.Add(new UITabItem { Text = GetString("objectversioning.tabtitle") }); versionList.Object = mReportValueInfo; versionList.IsLiveSite = false; } } else //new item { PageTitle.TitleText = GetString("Reporting_ReportValue_Edit.NewItemTitleText"); chkSubscription.Checked = true; if (!RequestHelper.IsPostBack()) { ucSelectString.Value = String.Empty; } } if (!RequestHelper.IsPostBack()) { LoadData(); } } else { ShowError(GetString("Reporting_ReportValue_Edit.InvalidReportId")); } Save += (s, ea) => { if (SetData(true)) { ltlScript.Text += ScriptHelper.GetScript("window.RefreshContent();CloseDialog();"); } }; if (preview && !RequestHelper.IsPostBack()) { tabControlElem.SelectedTab = 1; ShowPreview(); } CurrentMaster.PanelContent.RemoveCssClass("dialog-content"); CurrentMaster.PanelContent.RemoveCssClass("ModalDialogContent"); }
protected void Page_Load(object sender, EventArgs e) { // Test permission for query if (!CMSContext.CurrentUser.IsAuthorizedPerResource("CMS.Reporting", "EditSQLQueries")) { txtQuery.Enabled = false; } else { txtQuery.Enabled = true; } versionList.OnAfterRollback += new EventHandler(versionList_onAfterRollback); string[,] tabs = new string[4, 4]; tabs[0, 0] = GetString("general.general"); tabs[0, 1] = "SetHelpTopic('helpTopic', 'report_value_properties')"; tabs[1, 0] = GetString("general.preview"); tabs[0, 1] = "SetHelpTopic('helpTopic', 'report_value_properties')"; tabControlElem.Tabs = tabs; tabControlElem.UsePostback = true; CurrentMaster.Title.HelpName = "helpTopic"; CurrentMaster.Title.HelpTopicName = "report_value_properties"; CurrentMaster.Title.TitleCssClass = "PageTitleHeader"; RegisterResizeAndRollbackScript(divFooter.ClientID, divScrolable.ClientID); rfvCodeName.ErrorMessage = GetString("general.requirescodename"); rfvDisplayName.ErrorMessage = GetString("general.requiresdisplayname"); int reportId = QueryHelper.GetInteger("reportid", 0); bool preview = QueryHelper.GetBoolean("preview", false); if (reportId > 0) { reportInfo = ReportInfoProvider.GetReportInfo(reportId); } if (reportInfo != null) //must be valid reportid parameter { if (PersistentEditedObject == null) { string valueName = ValidationHelper.GetString(Request.QueryString["itemname"], ""); if (ValidationHelper.IsIdentifier(valueName)) { PersistentEditedObject = ReportValueInfoProvider.GetReportValueInfo(reportInfo.ReportName + "." + valueName); valueInfo = PersistentEditedObject as ReportValueInfo; } } else { valueInfo = PersistentEditedObject as ReportValueInfo; } if (valueInfo != null) { CurrentMaster.Title.TitleText = GetString("Reporting_ReportValue_Edit.TitleText"); CurrentMaster.Title.TitleImage = GetImageUrl("Objects/Reporting_ReportValue/object.png"); valueId = valueInfo.ValueID; if (ObjectVersionManager.DisplayVersionsTab(valueInfo)) { tabs[2, 0] = GetString("objectversioning.tabtitle"); tabs[2, 1] = "SetHelpTopic('helpTopic', 'objectversioning_general');"; versionList.Object = valueInfo; versionList.IsLiveSite = false; } } else //new item { CurrentMaster.Title.TitleText = GetString("Reporting_ReportValue_Edit.NewItemTitleText"); CurrentMaster.Title.TitleImage = GetImageUrl("Objects/Reporting_ReportValue/new.png"); newValue = true; } // set help key CurrentMaster.Title.HelpTopicName = "report_value_properties"; if (!RequestHelper.IsPostBack()) { LoadData(); } } else { btnOk.Visible = false; lblError.Visible = true; lblError.Text = GetString("Reporting_ReportValue_Edit.InvalidReportId"); } btnOk.Text = GetString("General.OK"); btnCancel.Text = GetString("General.Cancel"); btnApply.Text = GetString("General.Apply"); if (preview) { tabControlElem.SelectedTab = 1; ShowPreview(); } }
public ReportInfo _reportInfo; // Setting this to private will cause it not to be visible for inheritated classes public void FeedReportInfo(ReportInfo info) { _reportInfo = info; }
protected void Page_Load(object sender, EventArgs e) { // Test permission for query if (!CMSContext.CurrentUser.IsAuthorizedPerResource("CMS.Reporting", "EditSQLQueries")) { txtQueryQuery.Enabled = false; } else { txtQueryQuery.Enabled = true; } versionList.OnAfterRollback += new EventHandler(versionList_onAfterRollback); // Own javascript tab change handling -> because tab control raises changetab after prerender - too late // Own selected tab change handling RegisterTabScript(hdnSelectedTab.ClientID, tabControlElem); // Register script for resize and rolback RegisterResizeAndRollbackScript(divFooter.ClientID, divScrolable.ClientID); string[,] tabs = new string[4, 4]; tabs[0, 0] = GetString("general.general"); tabs[0, 1] = "SetHelpTopic('helpTopic', 'report_htmlgraph_properties')"; tabs[1, 0] = GetString("general.preview"); tabs[1, 1] = "SetHelpTopic('helpTopic', 'report_htmlgraph_properties');"; tabControlElem.Tabs = tabs; tabControlElem.UsePostback = true; CurrentMaster.Title.TitleCssClass = "PageTitleHeader"; CurrentMaster.Title.HelpTopicName = "report_htmlgraph_properties"; CurrentMaster.Title.HelpName = "helpTopic"; Title = "ReportGraph Edit"; btnOk.Text = GetString("General.OK"); btnCancel.Text = GetString("General.Cancel"); btnApply.Text = GetString("General.apply"); rfvCodeName.ErrorMessage = GetString("general.requirescodename"); rfvDisplayName.ErrorMessage = GetString("general.requiresdisplayname"); int reportId = QueryHelper.GetInteger("reportid", 0); bool isPreview = QueryHelper.GetBoolean("preview", false); // If preview by URL -> select preview tab if (isPreview && !RequestHelper.IsPostBack()) { SelectedTab = 1; } if (reportId > 0) { reportInfo = ReportInfoProvider.GetReportInfo(reportId); } if (PersistentEditedObject == null) { if (reportInfo != null) //must be valid reportid parameter { string graphName = QueryHelper.GetString("itemname", ""); // try to load graphname from hidden field (adding new graph & preview) if (graphName == String.Empty) { graphName = txtNewGraphHidden.Value; } if (ValidationHelper.IsCodeName(graphName)) { PersistentEditedObject = ReportGraphInfoProvider.GetReportGraphInfo(reportInfo.ReportName + "." + graphName); graphInfo = PersistentEditedObject as ReportGraphInfo; } } } else { graphInfo = PersistentEditedObject as ReportGraphInfo; } if (graphInfo != null) { CurrentMaster.Title.TitleText = GetString("Reporting_ReportGraph_EditHTML.TitleText"); CurrentMaster.Title.TitleImage = GetImageUrl("Objects/Reporting_ReportGraph/object.png"); graphId = graphInfo.GraphID; if (ObjectVersionManager.DisplayVersionsTab(graphInfo)) { tabs[2, 0] = GetString("objectversioning.tabtitle"); tabs[2, 1] = "SetHelpTopic('helpTopic', 'objectversioning_general');"; versionList.Object = graphInfo; versionList.IsLiveSite = false; } } else { CurrentMaster.Title.TitleText = GetString("Reporting_ReportGraph_EditHTML.NewItemTitleText"); CurrentMaster.Title.TitleImage = GetImageUrl("Objects/Reporting_ReportGraph/new.png"); newReport = true; } if (!RequestHelper.IsPostBack()) { // Load default data for new report if (newReport) { txtQueryNoRecordText.Text = GetString("attachmentswebpart.nodatafound"); txtItemValueFormat.Text = "{%yval%}"; txtSeriesItemTooltip.Text = "{%ser%}"; chkExportEnable.Checked = true; } // Otherwise load saved data else { LoadData(); } } }
protected void Page_Load(object sender, EventArgs e) { bool newReport = false; ucSelectString.Scope = ReportInfo.OBJECT_TYPE; ConnectionStringRow.Visible = MembershipContext.AuthenticatedUser.IsAuthorizedPerResource("cms.reporting", "SetConnectionString"); txtQueryQuery.FullScreenParentElementID = pnlWebPartForm_Properties.ClientID; // Test permission for query txtQueryQuery.Enabled = MembershipContext.AuthenticatedUser.IsAuthorizedPerResource("CMS.Reporting", "EditSQLQueries"); versionList.OnAfterRollback += versionList_onAfterRollback; // Register script for resize and rollback RegisterScripts("divFooter", divScrolable.ClientID); tabControlElem.TabItems.Add(new UITabItem { Text = GetString("general.general") }); tabControlElem.TabItems.Add(new UITabItem { Text = GetString("general.preview") }); tabControlElem.UsePostback = true; Title = "ReportGraph Edit"; rfvCodeName.ErrorMessage = GetString("general.requirescodename"); rfvDisplayName.ErrorMessage = GetString("general.requiresdisplayname"); Save += (s, ea) => { if (SetData(true)) { ltlScript.Text += ScriptHelper.GetScript("window.RefreshContent();CloseDialog();"); } }; int reportId = QueryHelper.GetInteger("reportid", 0); bool isPreview = QueryHelper.GetBoolean("preview", false); // If preview by URL -> select preview tab if (isPreview && !RequestHelper.IsPostBack()) { tabControlElem.SelectedTab = 1; } if (reportId > 0) { mReportInfo = ReportInfoProvider.GetReportInfo(reportId); } if (PersistentEditedObject == null) { if (mReportInfo != null) //must be valid reportid parameter { int id = QueryHelper.GetInteger("objectid", 0); // Try to load graph name from hidden field (adding new graph & preview) if (id == 0) { id = ValidationHelper.GetInteger(txtNewGraphHidden.Value, 0); } if (id > 0) { PersistentEditedObject = ReportGraphInfoProvider.GetReportGraphInfo(id); mReportGraphInfo = PersistentEditedObject as ReportGraphInfo; } } } else { mReportGraphInfo = PersistentEditedObject as ReportGraphInfo; } if (mReportInfo != null) { ucSelectString.DefaultConnectionString = mReportInfo.ReportConnectionString; } if (mReportGraphInfo != null) { PageTitle.TitleText = GetString("Reporting_ReportGraph_EditHTML.TitleText"); mGraphId = mReportGraphInfo.GraphID; if (ObjectVersionManager.DisplayVersionsTab(mReportGraphInfo)) { tabControlElem.TabItems.Add(new UITabItem { Text = GetString("objectversioning.tabtitle") }); versionList.Object = mReportGraphInfo; versionList.IsLiveSite = false; } } else { PageTitle.TitleText = GetString("Reporting_ReportGraph_EditHTML.NewItemTitleText"); newReport = true; } if (!RequestHelper.IsPostBack()) { // Load default data for new report if (newReport) { ucSelectString.Value = String.Empty; txtQueryNoRecordText.Text = GetString("attachmentswebpart.nodatafound"); txtItemValueFormat.Text = "{%yval%}"; txtSeriesItemTooltip.Text = "{%ser%}"; chkExportEnable.Checked = true; chkSubscription.Checked = true; } // Otherwise load saved data else { LoadData(); } } }
protected void Page_Load(object sender, EventArgs e) { ucSelectString.Scope = PredefinedObjectType.REPORT; ConnectionStringRow.Visible = CMSContext.CurrentUser.IsAuthorizedPerResource("cms.reporting", "SetConnectionString"); txtQuery.FullScreenParentElementID = pnlWebPartForm_Properties.ClientID; // Test permission for query if (!CMSContext.CurrentUser.IsAuthorizedPerResource("CMS.Reporting", "EditSQLQueries")) { txtQuery.Enabled = false; } else { txtQuery.Enabled = true; } versionList.OnAfterRollback += new EventHandler(versionList_onAfterRollback); string[,] tabs = new string[4, 4]; tabs[0, 0] = GetString("general.general"); tabs[0, 1] = "SetHelpTopic('helpTopic', 'report_value_properties')"; tabs[1, 0] = GetString("general.preview"); tabs[0, 1] = "SetHelpTopic('helpTopic', 'report_value_properties')"; tabControlElem.Tabs = tabs; tabControlElem.UsePostback = true; CurrentMaster.Title.HelpName = "helpTopic"; CurrentMaster.Title.HelpTopicName = "report_value_properties"; CurrentMaster.Title.TitleCssClass = "PageTitleHeader"; // Own javascript tab change handling -> because tab control raises changetab after prerender - too late // Own selected tab change handling RegisterTabScript(hdnSelectedTab.ClientID, tabControlElem); RegisterResizeAndRollbackScript(divFooter.ClientID, divScrolable.ClientID); rfvCodeName.ErrorMessage = GetString("general.requirescodename"); rfvDisplayName.ErrorMessage = GetString("general.requiresdisplayname"); int reportId = QueryHelper.GetInteger("reportid", 0); bool preview = QueryHelper.GetBoolean("preview", false); if (reportId > 0) { reportInfo = ReportInfoProvider.GetReportInfo(reportId); } if (reportInfo != null) //must be valid reportid parameter { ucSelectString.DefaultConnectionString = reportInfo.ReportConnectionString; // If preview by URL -> select preview tab bool isPreview = QueryHelper.GetBoolean("preview", false); if (isPreview && !RequestHelper.IsPostBack()) { SelectedTab = 1; } if (PersistentEditedObject == null) { int id = QueryHelper.GetInteger("itemid", 0); if (id > 0) { PersistentEditedObject = ReportValueInfoProvider.GetReportValueInfo(id); valueInfo = PersistentEditedObject as ReportValueInfo; } } else { valueInfo = PersistentEditedObject as ReportValueInfo; } if (valueInfo != null) { CurrentMaster.Title.TitleText = GetString("Reporting_ReportValue_Edit.TitleText"); CurrentMaster.Title.TitleImage = GetImageUrl("Objects/Reporting_ReportValue/object_light.png"); valueId = valueInfo.ValueID; if (ObjectVersionManager.DisplayVersionsTab(valueInfo)) { tabs[2, 0] = GetString("objectversioning.tabtitle"); tabs[2, 1] = "SetHelpTopic('helpTopic', 'objectversioning_general');"; versionList.Object = valueInfo; versionList.IsLiveSite = false; } } else //new item { CurrentMaster.Title.TitleText = GetString("Reporting_ReportValue_Edit.NewItemTitleText"); CurrentMaster.Title.TitleImage = GetImageUrl("Objects/Reporting_ReportValue/new_light.png"); chkSubscription.Checked = true; newValue = true; if (!RequestHelper.IsPostBack()) { ucSelectString.Value = String.Empty; } } // set help key CurrentMaster.Title.HelpTopicName = "report_value_properties"; if (!RequestHelper.IsPostBack()) { LoadData(); } } else { btnOk.Visible = false; ShowError(GetString("Reporting_ReportValue_Edit.InvalidReportId")); } btnOk.Text = GetString("General.OK"); btnCancel.Text = GetString("General.Cancel"); btnApply.Text = GetString("General.Apply"); if (preview && !RequestHelper.IsPostBack()) { tabControlElem.SelectedTab = 1; ShowPreview(); } }
private void AddEndHistoryItem(ReportInfo info) { if(historyItem == null) { throw new Exception("History item not added."); } if(session != null) { historyItem.Statistics = session.Statistics; historyItem.Statistics.Errors += session.BeforeWipeErrors.Count + session.AfterWipeErrors.Count; } historyItem.EndTime = DateTime.Now; historyItem.ReportInfo = info; historyItem.Failed = historyItem.Statistics == null || historyItem.Statistics.FailedObjects > 0 || historyItem.Statistics.Errors > 0; if(_historyManager.SaveHistory(SecureDeleteLocations.GetScheduleHistoryFile()) == false) { Debug.ReportError("Failed to save history items"); } }
/// <summary> /// OnInit. /// </summary> protected override void OnInit(EventArgs e) { ScriptHelper.RegisterWOpenerScript(Page); PageTitle.TitleText = GetString("rep.webparts.reportparameterstitle"); // Load data for this form int reportID = QueryHelper.GetInteger("ReportID", 0); hdnGuid.Value = QueryHelper.GetString("GUID", String.Empty); ReportInfo ri = ReportInfoProvider.GetReportInfo(reportID); if (ri == null) { return; } FormInfo fi = new FormInfo(ri.ReportParameters); bfParameters.FormInformation = fi; bfParameters.SubmitButton.Visible = false; bfParameters.Mode = FormModeEnum.Update; // Get dataset from cache DataSet ds = (DataSet)WindowHelper.GetItem(hdnGuid.Value); DataRow dr = fi.GetDataRow(false); fi.LoadDefaultValues(dr, true); if (ds == null) { if (dr.ItemArray.Length > 0) { // Set up grid bfParameters.DataRow = RequestHelper.IsPostBack() ? fi.GetDataRow(false) : dr; } } // Set data set given from cache if ((ds != null) && (ds.Tables.Count > 0) && (ds.Tables[0].Rows.Count > 0)) { //Merge with default data from report MergeDefaultValuesWithData(dr, ds.Tables[0].Rows[0]); //Set row to basic form bfParameters.DataRow = dr; } // Test if there is any item visible in report parameters bool itemVisible = false; List <IDataDefinitionItem> items = fi.ItemsList; foreach (IDataDefinitionItem item in items) { FormFieldInfo ffi = item as FormFieldInfo; if (ffi != null && ffi.Visible) { itemVisible = true; break; } } if (!itemVisible) { ShowInformation(GetString("rep.parameters.noparameters")); } base.OnInit(e); }
/// <summary> /// Gets the report stream. /// </summary> /// <param name="item">The item.</param> /// <param name="reportName">Name of the report.</param> /// <returns>MemoryStream.</returns> private MemoryStream GetReportStream(IEditableRoot item, string reportName) { var dict = GetReportParametersDict(item); var reportProcessor = new ReportProcessor(); reportProcessor.Error += ReportProcessorError; var reportInfo = new ReportInfo(string.Format(CultureInfo.InvariantCulture, "?<customReport title=\"\" description=\"\" fileName=\"{0}\" />", reportName), dict); var reportSource = TheReportResolver.Resolve(reportInfo.ToString()); Telerik.Reporting.Processing.RenderingResult result; // Mq1ReportResolver changes the principal, so we'll have to restore it later. var user = ApplicationContext.User; try { result = reportProcessor.RenderReport("PDF", reportSource, null); } finally { ApplicationContext.User = user; } return new MemoryStream(result.DocumentBytes); }
private void OnReportCountChanged(int oldCount, int newCount, ReportInfo report) { UpdateAlert(report); }
/// <summary> /// Reload data. /// </summary> public override void ReloadData(bool forceLoad) { // Load value info object ReportValueInfo rvi = ValueInfo; if (rvi == null) { return; } ri = ReportInfoProvider.GetReportInfo(rvi.ValueReportID); if (ri == null) { return; } // Check security settings if (!(CheckReportAccess(ri) && CheckEmailModeSubscription(ri, ValidationHelper.GetBoolean(ValueInfo.ValueSettings["SubscriptionEnabled"], true)))) { Visible = false; return; } // Prepare query attributes QueryIsStoredProcedure = rvi.ValueQueryIsStoredProcedure; QueryText = rvi.ValueQuery; // Init parameters InitParameters(ri.ReportParameters); // Init macro resolver InitResolver(); DataSet ds = null; // Ensure report item name for caching if (String.IsNullOrEmpty(ReportItemName)) { ReportItemName = String.Format("{0};{1}", ri.ReportName, rvi.ValueName); } try { // Load data ds = LoadData(); } catch (Exception ex) { // Display error message, if data load fail lblError.Visible = true; lblError.Text = "[ReportValue.ascx] Error loading the data: " + ex.Message; EventLogProvider.LogException("Report value", "E", ex); } // If datasource is emptry, create empty dataset if (!DataHelper.DataSourceIsEmpty(ds)) { // Set literal text string value = rvi.ValueFormatString; if (String.IsNullOrEmpty(value)) { value = ValidationHelper.GetString(ds.Tables[0].Rows[0][0], String.Empty); } else { value = string.Format(value, ds.Tables[0].Rows[0].ItemArray); } if (EmailMode) { ltlEmail.Text = HTMLHelper.HTMLEncode(ResolveMacros(value)); ltlEmail.Visible = true; menuCont.Visible = false; } else { lblValue.Text = HTMLHelper.HTMLEncode(ResolveMacros(value)); } } else if (EmailMode && SendOnlyNonEmptyDataSource) { Visible = false; } }
public ReportingSteps(InputProjectDriver inputProjectDriver, ProjectSteps projectSteps, SpecFlowConfigurationDriver specFlowConfigurationDriver, ExecutionSteps executionSteps, ReportInfo reportInfo) { this.inputProjectDriver = inputProjectDriver; this.reportInfo = reportInfo; this.executionSteps = executionSteps; this.projectSteps = projectSteps; this.specFlowConfigurationDriver = specFlowConfigurationDriver; }
public static ReportPage GetSampleReportPage(string Xaml) { BusinessFlow BF1 = new BusinessFlow() { Name = "BF1 - Create Customer", Description = "Create any type of customer: Business/Residential..." }; BF1.Active = true; BF1.RunStatus = Amdocs.Ginger.CoreNET.Execution.eRunStatus.Passed; BF1.Activities = new ObservableList <Activity>(); BF1.Elapsed = 2364; //Activity 1 Activity a1 = new Activity() { ActivityName = "Launch Application & Login", Status = Amdocs.Ginger.CoreNET.Execution.eRunStatus.Passed }; BF1.Activities.Add(a1); ActGotoURL act1 = new ActGotoURL() { Description = "Goto URL www.abcd.com", Status = Amdocs.Ginger.CoreNET.Execution.eRunStatus.Passed, Elapsed = 3124 }; a1.Acts.Add(act1); ActReturnValue ARV1 = new ActReturnValue(); ARV1.Param = "RC"; ARV1.Expected = "123"; ARV1.Actual = "123"; ARV1.Status = ActReturnValue.eStatus.Passed; act1.ReturnValues.Add(ARV1); ActTextBox act2 = new ActTextBox() { Description = "Enter User ID", Status = Amdocs.Ginger.CoreNET.Execution.eRunStatus.Passed, Elapsed = 230 }; // Add sample screen shot Bitmap tempBmp = new Bitmap(Ginger.Properties.Resources.ScreenShot1); act2.ScreenShots.Add(GingerCore.General.BitmapImageToFile(tempBmp)); a1.Acts.Add(act2); ActTextBox act3 = new ActTextBox() { Description = "Enter Password", Status = Amdocs.Ginger.CoreNET.Execution.eRunStatus.Passed, Elapsed = 112 }; a1.Acts.Add(act3); ActSubmit act4 = new ActSubmit() { Description = "Click Submit Button", Status = Amdocs.Ginger.CoreNET.Execution.eRunStatus.Passed, Elapsed = 1282 }; a1.Acts.Add(act4); //Activity 2 Activity a2 = new Activity() { ActivityName = "Create New customer", Status = Amdocs.Ginger.CoreNET.Execution.eRunStatus.Failed }; BF1.Activities.Add(a2); ActTextBox acta21 = new ActTextBox() { Description = "Enter First Name", Status = Amdocs.Ginger.CoreNET.Execution.eRunStatus.Passed, Elapsed = 325 }; a2.Acts.Add(acta21); ActTextBox acta22 = new ActTextBox() { Description = "Enter Last Name", Status = Amdocs.Ginger.CoreNET.Execution.eRunStatus.Passed, Elapsed = 302 }; a2.Acts.Add(acta22); ActTextBox acta23 = new ActTextBox() { Description = "Enter City", Status = Amdocs.Ginger.CoreNET.Execution.eRunStatus.Failed, Elapsed = 820, Error = "Error: Element not found by ID 'City'", ExInfo = "Cannot find element" }; a2.Acts.Add(acta23); ActSubmit acta24 = new ActSubmit() { Description = "Click Create Button", Status = Amdocs.Ginger.CoreNET.Execution.eRunStatus.Pending }; a2.Acts.Add(acta24); //Add Variables BF1.Variables = new ObservableList <VariableBase>(); VariableString v1 = new VariableString() { Name = "FirstName", Value = "David Smith" }; BF1.Variables.Add(v1); VariableRandomNumber v2 = new VariableRandomNumber() { Name = "Random 1", Min = 1, Max = 100, Value = "55" }; BF1.Variables.Add(v2); //Add a few simple BFs BusinessFlow BF2 = new BusinessFlow() { Name = "BF2 - Customer Order Product", Description = "", Active = true }; BF2.Activities = new ObservableList <Activity>(); BF2.RunStatus = Amdocs.Ginger.CoreNET.Execution.eRunStatus.Failed; BF2.Elapsed = 1249; ProjEnvironment env = new ProjEnvironment() { Name = "Env1" }; //TODO: add more env info //cretae dummy GR, GMR RunsetExecutor GMR = new RunsetExecutor(); GingerRunner GR = new GingerRunner(); GR.BusinessFlows.Add(BF1); GR.BusinessFlows.Add(BF2); GR.CurrentSolution = App.UserProfile.Solution; GMR.Runners.Add(GR); ReportInfo RI = new ReportInfo(env, GMR); ReportPage RP = new ReportPage(RI, Xaml); return(RP); }
protected void Page_Load(object sender, EventArgs e) { // Test permission for query if (!CMSContext.CurrentUser.IsAuthorizedPerResource("CMS.Reporting", "EditSQLQueries")) { txtQuery.Enabled = false; } else { txtQuery.Enabled = true; } versionList.OnAfterRollback += new EventHandler(versionList_onAfterRollback); // Own javascript tab change handling -> because tab control raises changetab after prerender - too late // Own selected tab change handling RegisterTabScript(hdnSelectedTab.ClientID, tabControlElem); // Register common resize and refresh scripts RegisterResizeAndRollbackScript(divFooter.ClientID, divScrolable.ClientID); string[,] tabs = new string[4, 4]; tabs[0, 0] = GetString("general.general"); tabs[0, 1] = "SetHelpTopic('helpTopic', 'report_table_properties')"; tabs[1, 0] = GetString("general.preview"); tabs[0, 1] = "SetHelpTopic('helpTopic', 'report_table_properties')"; tabControlElem.Tabs = tabs; tabControlElem.UsePostback = true; CurrentMaster.Title.HelpName = "helpTopic"; CurrentMaster.Title.HelpTopicName = "report_table_properties"; CurrentMaster.Title.TitleCssClass = "PageTitleHeader"; rfvCodeName.ErrorMessage = GetString("general.requirescodename"); rfvDisplayName.ErrorMessage = GetString("general.requiresdisplayname"); btnApply.Text = GetString("General.apply"); btnOk.Text = GetString("General.OK"); btnCancel.Text = GetString("General.Cancel"); int reportId = QueryHelper.GetInteger("reportid", 0); bool preview = QueryHelper.GetBoolean("preview", false); if (reportId > 0) { reportInfo = ReportInfoProvider.GetReportInfo(reportId); } // If preview by URL -> select preview tab bool isPreview = QueryHelper.GetBoolean("preview", false); if (isPreview && !RequestHelper.IsPostBack()) { SelectedTab = 1; } if (PersistentEditedObject == null) { if (reportInfo != null) // Must be valid reportid parameter { string tableName = ValidationHelper.GetString(Request.QueryString["itemname"], ""); // Try to load tableName from hidden field (adding new graph & preview) if (tableName == String.Empty) { tableName = txtNewTableHidden.Value; } if (ValidationHelper.IsIdentifier(tableName)) { PersistentEditedObject = ReportTableInfoProvider.GetReportTableInfo(reportInfo.ReportName + "." + tableName); tableInfo = PersistentEditedObject as ReportTableInfo; } } } else { tableInfo = PersistentEditedObject as ReportTableInfo; } if (reportInfo != null) { // Control text initializations if (tableInfo != null) { CurrentMaster.Title.TitleText = GetString("Reporting_ReportTable_Edit.TitleText"); CurrentMaster.Title.TitleImage = GetImageUrl("Objects/Reporting_ReportTable/object.png"); tableId = tableInfo.TableID; if (ObjectVersionManager.DisplayVersionsTab(tableInfo)) { tabs[2, 0] = GetString("objectversioning.tabtitle"); tabs[2, 1] = "SetHelpTopic('helpTopic', 'objectversioning_general');"; versionList.Object = tableInfo; versionList.IsLiveSite = false; } } else // New item { CurrentMaster.Title.TitleText = GetString("Reporting_ReportTable_Edit.NewItemTitleText"); CurrentMaster.Title.TitleImage = GetImageUrl("Objects/Reporting_ReportTable/new.png"); if (!RequestHelper.IsPostBack()) { txtPageSize.Text = "15"; txtQueryNoRecordText.Text = GetString("attachmentswebpart.nodatafound"); chkExportEnable.Checked = true; } newTable = true; } // Set help key CurrentMaster.Title.HelpTopicName = "report_table_properties"; if (!RequestHelper.IsPostBack()) { DataHelper.FillListControlWithEnum(typeof(PagerButtons), drpPageMode, "PagerButtons.", null); // Preselect page numbers paging drpPageMode.SelectedValue = ((int)PagerButtons.Numeric).ToString(); LoadData(); } } if ((preview) && (!RequestHelper.IsPostBack())) { tabControlElem.SelectedTab = 1; ShowPreview(); } // In case of preview paging without saving table if (RequestHelper.IsPostBack() && tabControlElem.SelectedTab == 1) { // Reload deafult parameters FormInfo fi = new FormInfo(reportInfo.ReportParameters); // Get datarow with required columns ctrlReportTable.ReportParameters = fi.GetDataRow(); fi.LoadDefaultValues(ctrlReportTable.ReportParameters, true); // Colect data and put them in talbe info Save(false); ctrlReportTable.TableInfo = tableInfo; } }
protected override void OnPreRender(EventArgs e) { pnlReports.Attributes.Add("style", "margin-bottom:3px"); string reportName = ValidationHelper.GetString(usReports.Value, String.Empty); mReportInfo = ReportInfoProvider.GetReportInfo(reportName); if (mReportInfo != null) { usItems.Enabled = true; // Test if there is any item visible in report parameters FormInfo fi = new FormInfo(mReportInfo.ReportParameters); // Get dataset from cache DataSet ds = (DataSet)WindowHelper.GetItem(CurrentGuid()); DataRow dr = fi.GetDataRow(false); fi.LoadDefaultValues(dr, true); bool itemVisible = false; List <IField> items = fi.ItemsList; foreach (IField item in items) { FormFieldInfo ffi = item as FormFieldInfo; if (ffi != null) { if (ffi.Visible) { itemVisible = true; break; } } } ReportID = mReportInfo.ReportID; if (!itemVisible) { plcParametersButtons.Visible = false; } else { plcParametersButtons.Visible = true; } } else { if (ReportID == 0) { plcParametersButtons.Visible = false; usItems.Enabled = false; } } ltlScript.Text = ScriptHelper.GetScript("function refresh () {" + ControlsHelper.GetPostBackEventReference(pnlUpdate, String.Empty) + "}"); usReports.DropDownSingleSelect.AutoPostBack = true; if (!mDisplay) { pnlReports.Visible = false; plcParametersButtons.Visible = false; usItems.Enabled = true; } if (!ShowItemSelector) { pnlItems.Visible = false; } usItems.IsLiveSite = IsLiveSite; usReports.IsLiveSite = IsLiveSite; ugParameters.GridName = "~/CMSModules/Reporting/FormControls/ReportParametersList.xml"; ugParameters.ZeroRowsText = String.Empty; ugParameters.PageSize = "##ALL##"; ugParameters.Pager.DefaultPageSize = -1; BuildConditions(); if (mReportInfo == null) { usItems.SpecialFields.Add(new SpecialField() { Text = "(" + mFirstItemText + ")", Value = "0" }); } if (ShowItemSelector) { ReloadItems(); } if (mSetValues) { WindowHelper.Add(CurrentGuid(), CurrentDataSet); ScriptHelper.RegisterDialogScript(Page); ScriptHelper.RegisterStartupScript(Page, typeof(Page), "OpenModalWindowReportItem", ScriptHelper.GetScript("modalDialog('" + ResolveUrl("~/CMSModules/Reporting/Dialogs/ReportParametersSelector.aspx?ReportID=" + ReportID + "&guid=" + CurrentGuid().ToString()) + "','ReportParametersDialog', 700, 500);")); mKeepDataInWindowsHelper = true; } // Apply reportid condition if report was selected via uniselector if (mReportInfo != null) { DataSet ds = CurrentDataSet; ViewState["ParametersXmlData"] = null; ViewState["ParametersXmlSchema"] = null; if (!DataHelper.DataSourceIsEmpty(ds)) { ViewState["ParametersXmlData"] = ds.GetXml(); ViewState["ParametersXmlSchema"] = ds.GetXmlSchema(); } if (!mKeepDataInWindowsHelper) { WindowHelper.Remove(CurrentGuid().ToString()); } if (!DataHelper.DataSourceIsEmpty(ds)) { ds = DataHelper.DataSetPivot(ds, new string[] { "ParameterName", "ParameterValue" }); ugParameters.DataSource = ds; ugParameters.ReloadData(); pnlParameters.Visible = true; } else { pnlParameters.Visible = false; } } else { pnlParameters.Visible = false; } base.OnPreRender(e); }
/// <summary> /// Creates report. Called when the "Create report" button is pressed. /// </summary> private bool CreateReport() { // Get the report category ReportCategoryInfo category = ReportCategoryInfoProvider.GetReportCategoryInfo("MyNewCategory"); if (category != null) { // Create new report object ReportInfo newReport = new ReportInfo(); // Set the properties newReport.ReportDisplayName = "My new report"; newReport.ReportName = "MyNewReport"; newReport.ReportCategoryID = category.CategoryID; newReport.ReportAccess = ReportAccessEnum.All; newReport.ReportLayout = ""; newReport.ReportParameters = ""; // Save the report ReportInfoProvider.SetReportInfo(newReport); return true; } return false; }
protected void VerifyReportsImported(ViewGroup viewGroup, ReportInfo reportInfo) { foreach (var expectedReport in reportInfo.ReportOrViewSpecs) { var foundReports = Settings.Default.PersistedViews.GetViewSpecList(viewGroup.Id).ViewSpecs .Where(viewSpec => viewSpec.Name == expectedReport.Name) .ToArray(); Assert.AreEqual(1, foundReports.Length); } }
protected void Page_Load(object sender, EventArgs e) { // Test permission for query if (!CMSContext.CurrentUser.IsAuthorizedPerResource("CMS.Reporting", "EditSQLQueries")) { txtQuery.Enabled = false; } else { txtQuery.Enabled = true; } versionList.OnAfterRollback += new EventHandler(versionList_onAfterRollback); string[,] tabs = new string[4, 4]; tabs[0, 0] = GetString("general.general"); tabs[0, 1] = "SetHelpTopic('helpTopic', 'report_value_properties')"; tabs[1, 0] = GetString("general.preview"); tabs[0, 1] = "SetHelpTopic('helpTopic', 'report_value_properties')"; tabControlElem.Tabs = tabs; tabControlElem.UsePostback = true; CurrentMaster.Title.HelpName = "helpTopic"; CurrentMaster.Title.HelpTopicName = "report_value_properties"; CurrentMaster.Title.TitleCssClass = "PageTitleHeader"; RegisterResizeAndRollbackScript(divFooter.ClientID, divScrolable.ClientID); rfvCodeName.ErrorMessage = GetString("general.requirescodename"); rfvDisplayName.ErrorMessage = GetString("general.requiresdisplayname"); int reportId = QueryHelper.GetInteger("reportid", 0); bool preview = QueryHelper.GetBoolean("preview", false); if (reportId > 0) { reportInfo = ReportInfoProvider.GetReportInfo(reportId); } if (reportInfo != null) //must be valid reportid parameter { if (PersistentEditedObject == null) { string valueName = ValidationHelper.GetString(Request.QueryString["itemname"], ""); if (ValidationHelper.IsCodeName(valueName)) { PersistentEditedObject = ReportValueInfoProvider.GetReportValueInfo(reportInfo.ReportName + "." + valueName); valueInfo = PersistentEditedObject as ReportValueInfo; } } else { valueInfo = PersistentEditedObject as ReportValueInfo; } if (valueInfo != null) { CurrentMaster.Title.TitleText = GetString("Reporting_ReportValue_Edit.TitleText"); CurrentMaster.Title.TitleImage = GetImageUrl("Objects/Reporting_ReportValue/object.png"); valueId = valueInfo.ValueID; if (ObjectVersionManager.DisplayVersionsTab(valueInfo)) { tabs[2, 0] = GetString("objectversioning.tabtitle"); tabs[2, 1] = "SetHelpTopic('helpTopic', 'objectversioning_general');"; versionList.Object = valueInfo; versionList.IsLiveSite = false; } } else //new item { CurrentMaster.Title.TitleText = GetString("Reporting_ReportValue_Edit.NewItemTitleText"); CurrentMaster.Title.TitleImage = GetImageUrl("Objects/Reporting_ReportValue/new.png"); newValue = true; } // set help key CurrentMaster.Title.HelpTopicName = "report_value_properties"; if (!RequestHelper.IsPostBack()) { LoadData(); } } else { btnOk.Visible = false; lblError.Visible = true; lblError.Text = GetString("Reporting_ReportValue_Edit.InvalidReportId"); } btnOk.Text = GetString("General.OK"); btnCancel.Text = GetString("General.Cancel"); btnApply.Text = GetString("General.Apply"); if (preview) { tabControlElem.SelectedTab = 1; ShowPreview(); } }
protected void Page_Load(object sender, EventArgs e) { ucSelectString.Scope = ReportInfo.OBJECT_TYPE; ConnectionStringRow.Visible = MembershipContext.AuthenticatedUser.IsAuthorizedPerResource("cms.reporting", "SetConnectionString"); txtQueryQuery.FullScreenParentElementID = pnlWebPartForm_Properties.ClientID; // Test permission for query txtQueryQuery.Enabled = MembershipContext.AuthenticatedUser.IsAuthorizedPerResource("CMS.Reporting", "EditSQLQueries"); versionList.OnAfterRollback += versionList_onAfterRollback; tabControlElem.TabItems.Add(new UITabItem { Text = GetString("general.general") }); tabControlElem.TabItems.Add(new UITabItem { Text = GetString("general.preview") }); tabControlElem.UsePostback = true; Title = "ReportGraph Edit"; PageTitle.HelpTopicName = HELP_TOPIC_LINK; RegisterClientScript(); rfvCodeName.ErrorMessage = GetString("general.requirescodename"); rfvDisplayName.ErrorMessage = GetString("general.requiresdisplayname"); Save += (s, ea) => { if (SetData(true)) { ltlScript.Text += ScriptHelper.GetScript("window.RefreshContent();CloseDialog();"); } }; int reportId = QueryHelper.GetInteger("reportid", 0); bool isPreview = QueryHelper.GetBoolean("preview", false); // If preview by URL -> select preview tab if (isPreview && !RequestHelper.IsPostBack()) { tabControlElem.SelectedTab = 1; } if (reportId > 0) { // Get report info mReportInfo = ReportInfoProvider.GetReportInfo(reportId); } // Must be valid reportid parameter if (PersistentEditedObject == null) { if (mReportInfo != null) { int id = QueryHelper.GetInteger("objectid", 0); // Try to load graph name from hidden field (adding new graph & preview) if (id == 0) { id = ValidationHelper.GetInteger(txtNewGraphHidden.Value, 0); } if (id > 0) { PersistentEditedObject = ReportGraphInfoProvider.GetReportGraphInfo(id); mReportGraphInfo = PersistentEditedObject as ReportGraphInfo; } } } else { mReportGraphInfo = PersistentEditedObject as ReportGraphInfo; } if (mReportInfo != null) { ucSelectString.DefaultConnectionString = mReportInfo.ReportConnectionString; } if (mReportGraphInfo != null) { // Set title text and image PageTitle.TitleText = GetString("Reporting_ReportGraph_Edit.TitleText"); mGraphId = mReportGraphInfo.GraphID; // Show versions tab if (ObjectVersionManager.DisplayVersionsTab(mReportGraphInfo)) { tabControlElem.TabItems.Add(new UITabItem { Text = GetString("objectversioning.tabtitle") }); versionList.Object = mReportGraphInfo; versionList.IsLiveSite = false; } } else { // Current report graph is new object PageTitle.TitleText = GetString("Reporting_ReportGraph_Edit.NewItemTitleText"); mNewReport = true; } if (!RequestHelper.IsPostBack()) { // Fill border styles FillBorderStyle(drpLegendBorderStyle); FillBorderStyle(drpChartAreaBorderStyle); FillBorderStyle(drpPlotAreaBorderStyle); FillBorderStyle(drpSeriesBorderStyle); FillBorderStyle(drpSeriesLineBorderStyle); // Fill gradient styles FillGradientStyle(drpChartAreaGradient); FillGradientStyle(drpPlotAreaGradient); FillGradientStyle(drpSeriesGradient); // Fill axis's position FillPosition(drpYAxisTitlePosition); FillPosition(drpXAxisTitlePosition); FillTitlePosition(drpTitlePosition); // Fill legend's position FillLegendPosition(drpLegendPosition); // Fill font type FillChartType(drpChartType); // Fill Chart type controls FillBarType(drpBarDrawingStyle); FillStackedBarType(drpStackedBarDrawingStyle); FillPieType(drpPieDrawingStyle); FillDrawingDesign(drpPieDrawingDesign); FillLabelStyle(drpPieLabelStyle); FillPieRadius(drpPieDoughnutRadius); FillLineDrawingStyle(drpLineDrawingStyle); FillOrientation(drpBarOrientation); FillOrientation(drpBarStackedOrientation); FillBorderSkinStyle(); // FillSymbos FillSymbols(drpSeriesSymbols); if (!mNewReport) { LoadData(); } // Load default data else { chkExportEnable.Checked = ReportGraphDefaults.ExportEnable; chkSubscription.Checked = ReportGraphDefaults.Subscription; ucSelectString.Value = ReportGraphDefaults.SelectConnectionString; // Set default values for some controls txtQueryNoRecordText.Text = ResHelper.GetString("attachmentswebpart.nodatafound"); drpPieLabelStyle.SelectedValue = ReportGraphDefaults.PieLabelStyle; drpPieDoughnutRadius.SelectedValue = ReportGraphDefaults.PieDoughnutRadius; drpSeriesBorderStyle.SelectedValue = ReportGraphDefaults.SeriesBorderStyle; drpSeriesLineBorderStyle.SelectedValue = ReportGraphDefaults.SeriesLineBorderStyle; drpLegendBorderStyle.SelectedValue = ReportGraphDefaults.LegendBorderStyle; drpChartAreaBorderStyle.SelectedValue = ReportGraphDefaults.ChartAreaBorderStyle; drpPlotAreaBorderStyle.SelectedValue = ReportGraphDefaults.PlotAreaBorderStyle; // Border size txtSeriesLineBorderSize.Text = ReportGraphDefaults.SeriesLineBorderSize.ToString(); txtSeriesBorderSize.Text = ReportGraphDefaults.SeriesBorderSize.ToString(); txtChartAreaBorderSize.Text = ReportGraphDefaults.ChartAreaBorderSize.ToString(); txtPlotAreaBorderSize.Text = ReportGraphDefaults.PlotAreaBorderSize.ToString(); txtLegendBorderSize.Text = ReportGraphDefaults.LegendBorderSize.ToString(); // Border color ucPlotAreaBorderColor.SelectedColor = ReportGraphDefaults.PlotAreaBorderColor; ucChartAreaBorderColor.SelectedColor = ReportGraphDefaults.ChartAreaBorderColor; ucLegendBorderColor.SelectedColor = ReportGraphDefaults.LegendBorderColor; ucSeriesBorderColor.SelectedColor = ReportGraphDefaults.SeriesBorderColor; // Other values ucChartAreaPrBgColor.SelectedColor = ReportGraphDefaults.ChartAreaPrBgColor; ucChartAreaSecBgColor.SelectedColor = ReportGraphDefaults.ChartAreaSecBgColor; drpChartAreaGradient.SelectedValue = ReportGraphDefaults.ChartAreaGradient; ucTitleColor.SelectedColor = ReportGraphDefaults.TitleColor; drpBorderSkinStyle.SelectedValue = ReportGraphDefaults.BorderSkinStyle; txtChartWidth.Text = ReportGraphDefaults.ChartWidth.ToString(); txtChartHeight.Text = ReportGraphDefaults.ChartHeight.ToString(); chkShowGrid.Checked = ReportGraphDefaults.ShowGrid; chkYAxisUseXSettings.Checked = ReportGraphDefaults.YAxisUseXSettings; ucXAxisTitleColor.SelectedColor = ReportGraphDefaults.XAxisTitleColor; ucYAxisTitleColor.SelectedColor = ReportGraphDefaults.YAxisTitleColor; drpSeriesSymbols.SelectedValue = ReportGraphDefaults.SeriesSymbols; drpBarDrawingStyle.SelectedValue = ReportGraphDefaults.BarDrawingStyle; chkSeriesDisplayItemValue.Checked = ReportGraphDefaults.SeriesDisplayItemValue; txtXAxisInterval.Text = ReportGraphDefaults.XAxisInterval.ToString(); chkXAxisSort.Checked = ReportGraphDefaults.XAxisSort; drpPieDrawingStyle.SelectedValue = ReportGraphDefaults.PieDrawingStyle; drpPieDrawingDesign.SelectedValue = ReportGraphDefaults.PieDrawingDesign; drpStackedBarDrawingStyle.SelectedValue = ReportGraphDefaults.StackedBarDrawingStyle; } } HideChartTypeControls(drpChartType.SelectedIndex); ucXAxisTitleFont.SetOnChangeAttribute("xAxixTitleFontChanged ()"); // Font settings ucTitleFont.DefaultSize = 14; ucTitleFont.DefaultStyle = "bold"; ucXAxisTitleFont.DefaultSize = 11; ucXAxisTitleFont.DefaultStyle = "bold"; ucYAxisTitleFont.DefaultSize = 11; ucYAxisTitleFont.DefaultStyle = "bold"; txtRotateX.Enabled = chkShowAs3D.Checked; txtRotateY.Enabled = chkShowAs3D.Checked; chkBarOverlay.Enabled = chkShowAs3D.Checked; // Doughnut settings drpPieDoughnutRadius.Enabled = drpPieDrawingStyle.SelectedValue == "Doughnut"; CurrentMaster.PanelContent.RemoveCssClass("dialog-content"); }
protected void Page_Load(object sender, EventArgs e) { ucSelectString.Scope = ReportInfo.OBJECT_TYPE; ConnectionStringRow.Visible = MembershipContext.AuthenticatedUser.IsAuthorizedPerResource("cms.reporting", "SetConnectionString"); txtQuery.FullScreenParentElementID = pnlWebPartForm_Properties.ClientID; // Test permission for query txtQuery.Enabled = MembershipContext.AuthenticatedUser.IsAuthorizedPerResource("CMS.Reporting", "EditSQLQueries"); versionList.OnAfterRollback += versionList_onAfterRollback; PageTitle.HelpTopicName = HELP_TOPIC_LINK; tabControlElem.TabItems.Add(new UITabItem { Text = GetString("general.general") }); tabControlElem.TabItems.Add(new UITabItem { Text = GetString("general.preview") }); tabControlElem.UsePostback = true; RegisterResizeAndRollbackScript("divFooter", divScrolable.ClientID); rfvCodeName.ErrorMessage = GetString("general.requirescodename"); rfvDisplayName.ErrorMessage = GetString("general.requiresdisplayname"); int reportId = QueryHelper.GetInteger("reportid", 0); bool preview = QueryHelper.GetBoolean("preview", false); if (reportId > 0) { mReportInfo = ReportInfoProvider.GetReportInfo(reportId); } if (mReportInfo != null) //must be valid reportid parameter { ucSelectString.DefaultConnectionString = mReportInfo.ReportConnectionString; // If preview by URL -> select preview tab bool isPreview = QueryHelper.GetBoolean("preview", false); if (isPreview && !RequestHelper.IsPostBack()) { tabControlElem.SelectedTab = 1; } if (PersistentEditedObject == null) { int id = QueryHelper.GetInteger("objectid", 0); if (id > 0) { PersistentEditedObject = ReportValueInfoProvider.GetReportValueInfo(id); mReportValueInfo = PersistentEditedObject as ReportValueInfo; } } else { mReportValueInfo = PersistentEditedObject as ReportValueInfo; } if (mReportValueInfo != null) { PageTitle.TitleText = GetString("Reporting_ReportValue_Edit.TitleText"); mValueId = mReportValueInfo.ValueID; if (ObjectVersionManager.DisplayVersionsTab(mReportValueInfo)) { tabControlElem.TabItems.Add(new UITabItem { Text = GetString("objectversioning.tabtitle") }); versionList.Object = mReportValueInfo; versionList.IsLiveSite = false; } } else //new item { PageTitle.TitleText = GetString("Reporting_ReportValue_Edit.NewItemTitleText"); chkSubscription.Checked = true; if (!RequestHelper.IsPostBack()) { ucSelectString.Value = String.Empty; } } if (!RequestHelper.IsPostBack()) { LoadData(); } } else { ShowError(GetString("Reporting_ReportValue_Edit.InvalidReportId")); } Save += (s, ea) => { if (SetData(true)) { ltlScript.Text += ScriptHelper.GetScript("window.RefreshContent();CloseDialog();"); } }; if (preview && !RequestHelper.IsPostBack()) { tabControlElem.SelectedTab = 1; ShowPreview(); } CurrentMaster.PanelContent.RemoveCssClass("dialog-content"); }
public static void ProcessSubmitReport(HttpListenerContext context, IDictionary <string, string> data) { IDictionary <string, object> result = new Dictionary <string, object>() { { "success", false } }; if (!data.ContainsKey("id") || !data.ContainsKey("match") || !data.ContainsKey("account") || !data.ContainsKey("flags") || !int.TryParse(data["flags"], out int flags)) { result["message"] = "参数错误"; } else if (!data["account"].Split(',').All(accountManager.Accounts.ContainsKey)) { result["message"] = "账户不存在"; } else { SteamID steamID = SteamIdUtil.Parse(data["id"]); ulong matchID = 0; if (data["match"].StartsWith("steam://")) { matchID = ShareCode.Decode(data["match"].Substring(61)).MatchId; } else if (data["match"].StartsWith("CSGO-")) { matchID = ShareCode.Decode(data["match"]).MatchId; } else { ulong.TryParse(data["match"], out matchID); } if (steamID != null) { if (matchID == 0) { result["message"] = "请提供有效的Match ID."; } else if (AccountManager.IsWhitelisted(steamID)) { result["message"] = "举报目标在我们的白名单中,这通常说明举报目标不会作弊或是我们的机器人账号之一."; } else { var info = new ReportInfo() { SteamID = steamID, MatchID = matchID, AbusiveText = (flags & FLAG_ABUSIVE_TEXT) == FLAG_ABUSIVE_TEXT, AbusiveVoice = (flags & FLAG_ABUSIVE_VOICE) == FLAG_ABUSIVE_VOICE, Griefing = (flags & FLAG_GRIEFING) == FLAG_GRIEFING, AimHacking = (flags & FLAG_AIM_HACKING) == FLAG_AIM_HACKING, WallHacking = (flags & FLAG_WALL_HACKING) == FLAG_WALL_HACKING, OtherHacking = (flags & FLAG_OTHER_HACKING) == FLAG_OTHER_HACKING }; var submitted = data["account"].Split(','); var accounts = accountManager.Accounts.Where((kv) => submitted.Contains(kv.Key)); foreach (var kv in accounts) { kv.Value.QueueAction(info); } result["matchid"] = matchID; result["success"] = true; result["message"] = "Abusive Text:" + info.AbusiveText + "<br />" + "Abusive Voice:" + info.AbusiveVoice + "<br />" + "Griefing:" + info.Griefing + "<br />" + "Aim Hacking:" + info.AimHacking + "<br />" + "Wall Hacking:" + info.WallHacking + "<br />" + "Other Hacking:" + info.OtherHacking; } } else { result["message"] = "无法解析Steam ID,请提供有效的SteamID,SteamID3或SteamID64."; } } Server.SendResult(context, Body: JsonConvert.SerializeObject(result)); }
/// <summary> /// Reload data. /// </summary> public override void ReloadData(bool forceLoad) { if ((TableInfo == null) || ((GraphImageWidth != 0) && (ComputedWidth == 0))) { // Graph width is computed no need to create graph return; } Visible = true; EnsureChildControls(); LoadTable(); mReportInfo = ReportInfoProvider.GetReportInfo(TableInfo.TableReportID); if (mReportInfo == null) { return; } // Check security settings if (!(CheckReportAccess(mReportInfo) && CheckEmailModeSubscription(mReportInfo, ValidationHelper.GetBoolean(TableInfo.TableSettings["SubscriptionEnabled"], true)))) { Visible = false; return; } // Prepare query attributes QueryIsStoredProcedure = TableInfo.TableQueryIsStoredProcedure; QueryText = TableInfo.TableQuery; // Init parameters InitParameters(mReportInfo.ReportParameters); // Init macro resolver InitResolver(); mErrorOccurred = false; DataSet ds = null; try { // Load data ds = LoadData(); } catch (Exception ex) { // Display error message, if data load fail lblError.Visible = true; lblError.Text = "[ReportTable.ascx] Error loading the data: " + ex.Message; EventLogProvider.LogException("Report table", "E", ex); mErrorOccurred = true; } // If no data load, set empty dataset if (DataHelper.DataSourceIsEmpty(ds)) { if (EmailMode && SendOnlyNonEmptyDataSource) { Visible = false; return; } string noRecordText = ValidationHelper.GetString(TableInfo.TableSettings["QueryNoRecordText"], String.Empty); if (!String.IsNullOrEmpty(noRecordText)) { UIGridViewObject.Visible = false; lblInfo.Text = ResolveMacros(noRecordText); lblInfo.Visible = true; EnableExport = false; return; } if (!EmailMode) { Visible = false; return; } } else { UIGridViewObject.Visible = true; // Resolve macros in column names int i = 0; foreach (DataColumn dc in ds.Tables[0].Columns) { if (dc.ColumnName == "Column" + (i + 1)) { dc.ColumnName = ResolveMacros(ds.Tables[0].Rows[0][i].ToString()); } else { dc.ColumnName = ResolveMacros(dc.ColumnName); } i++; } // Resolve macros in dataset foreach (DataRow dr in ds.Tables[0].Rows) { foreach (DataColumn dc in ds.Tables[0].Columns) { if (dc.DataType.FullName.ToLowerCSafe() == "system.string") { dr[dc.ColumnName] = ResolveMacros(ValidationHelper.GetString(dr[dc.ColumnName], String.Empty)); } } } if (EmailMode) { // For some email formats, export data in csv format EmailFormatEnum format = EmailHelper.GetEmailFormat(ReportSubscriptionSiteID); if ((format == EmailFormatEnum.Both) || (format == EmailFormatEnum.PlainText)) { using (MemoryStream ms = MemoryStream.New()) { DataExportHelper deh = new DataExportHelper(ds); byte[] data = deh.ExportToCSV(ds, 0, ms, true); ReportSubscriptionSender.AddToRequest(mReportInfo.ReportName, "t" + TableInfo.TableName, data); } } // For plain text email show table only as attachment if (format == EmailFormatEnum.PlainText) { menuCont.Visible = false; ltlEmail.Visible = true; ltlEmail.Text = String.Format(GetString("reportsubscription.attachment"), TableInfo.TableName); return; } GenerateTableForEmail(ds); menuCont.Visible = false; return; } } // Databind to gridview control UIGridViewObject.DataSource = ds; EnsurePageIndex(); UIGridViewObject.DataBind(); if ((TableFirstColumnWidth != Unit.Empty) && (UIGridViewObject.Rows.Count > 0)) { UIGridViewObject.Rows[0].Cells[0].Width = TableFirstColumnWidth; } }
public override void Execute(ReportInfo RI) { try { if (!string.IsNullOrEmpty(SaveResultsInSolutionFolderName)) { Reporter.ToStatus(eStatusMsgKey.SaveItem, null, SaveResultsInSolutionFolderName, "Execution Summary"); string folder = Path.Combine(WorkSpace.Instance.Solution.Folder, @"ExecutionResults"); if (!Directory.Exists(folder)) { Directory.CreateDirectory(folder); } folder = Path.Combine(folder, SaveResultsInSolutionFolderName); if (!Directory.Exists(folder)) { Directory.CreateDirectory(folder); } SaveBFResults(RI, folder); Reporter.HideStatusMessage(); } if (!string.IsNullOrEmpty(SaveResultstoFolderName)) { Reporter.ToStatus(eStatusMsgKey.SaveItem, null, SaveResultstoFolderName, "Execution Summary"); SaveBFResults(RI, SaveResultstoFolderName); Reporter.HideStatusMessage(); } //****----- condition to check each business flow ***//// if (!string.IsNullOrEmpty(SaveResultsInSolutionFolderName) || !string.IsNullOrEmpty(SaveResultstoFolderName)) { if (SaveindividualBFReport) { ObservableList <BusinessFlow> BFs = new ObservableList <BusinessFlow>(); foreach (GingerRunner GR in WorkSpace.RunsetExecutor.Runners) { foreach (BusinessFlow bf in GR.BusinessFlows) { if (bf.Active == true) { if (bf.RunStatus.ToString() == nameof(eRunStatus.Passed) || bf.RunStatus.ToString() == nameof(eRunStatus.Failed) || bf.RunStatus.ToString() == nameof(eRunStatus.Stopped)) { // !!!!!!!!!!!!!!!!!!! ReportInfo BFRI = new ReportInfo(WorkSpace.AutomateTabGingerRunner.ProjEnvironment, bf); string TempRepFileName = RepositoryItemHelper.RepositoryItemFactory.GenerateTemplate(TemplateName, BFRI); String RepFileName = DateTime.Now.ToString("dMMMyyyy_HHmmss_fff") + "_" + WorkSpace.RunsetExecutor.RunSetConfig.Name + "_" + GR.Name + "_" + bf.Name + "_" + WorkSpace.RunsetExecutor.RunsetExecutionEnvironment.Name; while (RepFileName.Length > 250) { RepFileName = RepFileName.Substring(0, 250); } RepFileName = RepFileName + ".pdf"; if (!string.IsNullOrEmpty(SaveResultsInSolutionFolderName)) { System.IO.File.Copy(TempRepFileName, SaveResultsInSolutionFolderName + "\\" + RepFileName); } if (SaveResultsInSolutionFolderName != SaveResultstoFolderName) { if (!string.IsNullOrEmpty(SaveResultstoFolderName)) { System.IO.File.Copy(TempRepFileName, SaveResultstoFolderName + "\\" + RepFileName); } } if (System.IO.File.Exists(Path.GetTempPath() + RepFileName)) { System.IO.File.Delete(Path.GetTempPath() + RepFileName); } } } } } } } else { Errors = "Folder path not provided"; Reporter.HideStatusMessage(); Status = RunSetActionBase.eRunSetActionStatus.Failed; } } catch (Exception ex) { Errors = "Failed: " + ex.Message; Reporter.HideStatusMessage(); Status = RunSetActionBase.eRunSetActionStatus.Failed; } }
/// <summary> /// 查询报告单列表(根据病人ID) /// </summary> /// <param name="brid">病人ID</param> /// <param name="brlx">病人类型 1:门诊病人 2:住院病人</param> /// <param name="values">报告单信息</param> /// <param name="msg">出错信息</param> /// <returns>0:成功 大于0:出错 小于0:异常</returns> public int DB_QueryReportJCListByBRID(string brid, string brlx, out ArrayList values, out string msg) { string oracleConStr = GetJCReportDBConStr(); string hm = brid; values = new ArrayList(); if (WebConfigParameter.HospitalName() == AppUtils.HOSPITALNAME.WZSZXYJHYY || WebConfigParameter.HospitalName() == AppUtils.HOSPITALNAME.WZSCNXDSRMYY || WebConfigParameter.HospitalName() == AppUtils.HOSPITALNAME.WZSCNXDERMYY) { if (ConvertToBkhm(brid, brlx, out hm, out msg) != 0) { return 3; } } else if (WebConfigParameter.HospitalName() == AppUtils.HOSPITALNAME.WZSDEYY && null != brlx && brlx.Equals("2")) { if (ConvertToMZBridForWzsdeyy(brid, brlx, out hm, out msg) != 0) { return 3; } } OracleConnection connection = new OracleConnection(oracleConStr); OracleDataReader dr = null; values = new ArrayList(); try { bool _flag = false; string sql = _builder.GetSqlReportJCList(hm, brlx, out _flag, out msg); if (!_flag) { return 10; } int ret = -99; msg = ""; dr = DbHelperOra.ExecuteReader(sql, connection); if (dr.HasRows) { while (dr.Read()) { ReportInfo ri = new ReportInfo(); ri.bgdh = !dr.IsDBNull(0) ? Convert.ToString(dr.GetInt32(0)) : " "; ri.sjmd = !dr.IsDBNull(1) ? dr.GetString(1) : ""; ri.cjsj = !dr.IsDBNull(2) ? dr.GetString(2) : ""; ri.sjr = !dr.IsDBNull(3) ? dr.GetString(3) : ""; ri.jysj = !dr.IsDBNull(4) ? dr.GetString(4) : ""; ri.jyr = !dr.IsDBNull(5) ? dr.GetString(5) : ""; ri.shr = !dr.IsDBNull(6) ? dr.GetString(6) : ""; ri.jzch = !dr.IsDBNull(7) ? dr.GetString(7) : ""; ri.zdjg = !dr.IsDBNull(8) ? dr.GetString(8) : ""; ri.bbmc = !dr.IsDBNull(9) ? dr.GetString(9) : ""; ri.mzbz = !dr.IsDBNull(10) ? dr.GetString(10) : ""; ri.dyjb = !dr.IsDBNull(11) ? dr.GetString(11) : ""; ri.bz = !dr.IsDBNull(12) ? dr.GetString(12) : ""; ri.hzbh = !dr.IsDBNull(13) ? dr.GetString(13) : ""; ri.sbm = !dr.IsDBNull(14) ? dr.GetString(14) : ""; ri.brxm = !dr.IsDBNull(15) ? dr.GetString(15) : ""; ri.jgmc = WebConfigParameter.HospitalChinaName(); values.Add(ri); } ret = 0; } else { values = null; msg = "未能找到报告单"; ret = 2; } return ret; } catch (Exception ex) { UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex); values = null; msg = GetExceptionInfo(ex); return AppUtils.Default_Exception_Code; } finally { if (null != dr) { dr.Close(); } connection.Close(); } }
/// <summary> /// Reload data. /// </summary> public override void ReloadData(bool forceLoad) { try { // Load value info object ReportValueInfo rvi = ValueInfo; if (rvi != null) { //Test security ri = ReportInfoProvider.GetReportInfo(rvi.ValueReportID); if (ri.ReportAccess != ReportAccessEnum.All) { if (!CMSContext.CurrentUser.IsAuthenticated()) { Visible = false; return; } } EnableSubscription = (EnableSubscription && ValidationHelper.GetBoolean(ValueInfo.ValueSettings["SubscriptionEnabled"], true) && ri.ReportEnableSubscription); if (EmailMode && !EnableSubscription) { this.Visible = false; return; } ContextResolver resolver = CMSContext.CurrentResolver; // Resolve dynamic data macros if (DynamicMacros != null) { for (int i = 0; i <= DynamicMacros.GetUpperBound(0); i++) { resolver.AddDynamicParameter(DynamicMacros[i, 0], DynamicMacros[i, 1]); } } QueryIsStoredProcedure = rvi.ValueQueryIsStoredProcedure; QueryText = resolver.ResolveMacros(rvi.ValueQuery); //Set default parametrs directly if not set if (ReportParameters == null) { if (ri != null) { FormInfo fi = new FormInfo(ri.ReportParameters); // Get datarow with required columns ReportParameters = fi.GetDataRow(false); fi.LoadDefaultValues(ReportParameters, true); } } } // Only use base parameters in case of stored procedure if (QueryIsStoredProcedure) { AllParameters = SpecialFunctions.ConvertDataRowToParams(ReportParameters, null); } // Load data DataSet ds = LoadData(); // If datasource is emptry, create empty dataset if (!DataHelper.DataSourceIsEmpty(ds)) { // Set literal text string value = rvi.ValueFormatString; if ((value == null) || (value == "")) { value = ValidationHelper.GetString(ds.Tables[0].Rows[0][0], ""); } else { value = string.Format(value, ds.Tables[0].Rows[0].ItemArray); } if (EmailMode) { ltlEmail.Text = HTMLHelper.HTMLEncode(ResolveMacros(value)); ltlEmail.Visible = true; menuCont.Visible = false; } else { lblValue.Text = HTMLHelper.HTMLEncode(ResolveMacros(value)); } } else if (EmailMode && SendOnlyNonEmptyDataSource) { Visible = false; } } catch (Exception ex) { // Display error message, if data load fail lblError.Visible = true; lblError.Text = "[ReportValue.ascx] Error loading the data: " + ex.Message; EventLogProvider ev = new EventLogProvider(); ev.LogEvent("Report value", "E", ex); } }
/// <summary> /// 根据条形码或者报告单号报告明细 /// </summary> /// <param name="code">条形码或者报告单号</param> /// <param name="lx">号码类型 1:报告单号 2条码查询</param> /// <param name="values">报告信息</param> /// <param name="msg">出错信息</param> /// <returns>0:成功 大于0:出错 小于0:异常</returns> public int DB_QueryReportJCListByCode(string code, string lx, string brxm, out ArrayList values, out string msg) { string oracleConStr = GetJCReportDBConStr(); OracleConnection connection = new OracleConnection(oracleConStr); OracleDataReader dr = null; values = new ArrayList(); try { bool _flag = false; string sql = _builder.GetSqlReportJCDetail(code, lx, brxm, out _flag, out msg); if (!_flag) { return 10; } int ret = -99; msg = ""; dr = DbHelperOra.ExecuteReader(sql, connection); if (dr.HasRows) { while (dr.Read()) { ReportInfo ri = new ReportInfo(); ri.bgdh = !dr.IsDBNull(0) ? Convert.ToString(dr.GetInt32(0)) : ""; ri.sjmd = !dr.IsDBNull(1) ? dr.GetString(1) : ""; ri.cjsj = !dr.IsDBNull(2) ? dr.GetString(2) : ""; ri.sjr = !dr.IsDBNull(3) ? dr.GetString(3) : ""; ri.jysj = !dr.IsDBNull(4) ? dr.GetString(4) : ""; ri.jyr = !dr.IsDBNull(5) ? dr.GetString(5) : ""; ri.shr = !dr.IsDBNull(6) ? dr.GetString(6) : ""; ri.jzch = !dr.IsDBNull(7) ? dr.GetString(7) : ""; ri.zdjg = !dr.IsDBNull(8) ? dr.GetString(8) : ""; ri.bbmc = !dr.IsDBNull(9) ? dr.GetString(9) : ""; ri.mzbz = !dr.IsDBNull(10) ? dr.GetString(10) : ""; ri.dyjb = !dr.IsDBNull(11) ? dr.GetString(11) : ""; ri.bz = !dr.IsDBNull(12) ? dr.GetString(12) : ""; ri.hzbh = !dr.IsDBNull(13) ? dr.GetString(13) : ""; ri.sbm = !dr.IsDBNull(14) ? dr.GetString(14) : ""; ri.brxm = !dr.IsDBNull(15) ? dr.GetString(15) : ""; ri.jgmc = WebConfigParameter.HospitalChinaName(); ICollection<ReportDetail> rds; string child_msg; int rtDetail; if (AppUtils.HOSPITALNAME.WZSTXRMYY == WebConfigParameter.HospitalName()|| AppUtils.HOSPITALNAME.WZSRAZYY == WebConfigParameter.HospitalName()) { rtDetail = DB_QueryReportJCDetail(ri.hzbh, out rds, out child_msg); } else { rtDetail = DB_QueryReportJCDetail(ri.bgdh, out rds, out child_msg); } if (rtDetail == 0) { ri.details = rds; } else { msg += "[单号" + ri.bgdh + "详细查询错误]" + child_msg + ";"; ret = 3; } values.Add(ri); } ret = 0; } else { values = null; msg = "未能找到该编号的报告单,请检查编号"; ret = 2; } return ret; } catch (Exception ex) { UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex); values = null; msg = GetExceptionInfo(ex); return AppUtils.Default_Exception_Code; } finally { if (null != dr) { dr.Close(); } connection.Close(); } }
public override void Execute(ReportInfo RI) { if ((WorkSpace.Instance.RunsetExecutor.DefectSuggestionsList != null) && (WorkSpace.Instance.RunsetExecutor.DefectSuggestionsList.Count > 0)) { Dictionary <Guid, Dictionary <string, string> > defectsForOpening = new Dictionary <Guid, Dictionary <string, string> >(); ObservableList <ALMDefectProfile> ALMDefectProfiles = WorkSpace.Instance.SolutionRepository.GetAllRepositoryItems <ALMDefectProfile>(); ALMDefectProfile defaultALMDefectProfile = new ALMDefectProfile(); if ((ALMDefectProfiles != null) && (ALMDefectProfiles.Count > 0)) { defaultALMDefectProfile = ALMDefectProfiles.Where(z => z.ID == SelectedDefectsProfileID).ToList().FirstOrDefault(); if (defaultALMDefectProfile == null) { defaultALMDefectProfile = ALMDefectProfiles.Where(z => z.IsDefault).ToList().FirstOrDefault(); if (defaultALMDefectProfile == null) { defaultALMDefectProfile = ALMDefectProfiles.FirstOrDefault(); } } } if (DefectsOpeningModeForMarked) { foreach (DefectSuggestion defectSuggestion in WorkSpace.Instance.RunsetExecutor.DefectSuggestionsList.Where(x => x.AutomatedOpeningFlag == true).ToList()) { Dictionary <string, string> currentALMDefectFieldsValues = new Dictionary <string, string>(); try { currentALMDefectFieldsValues = defaultALMDefectProfile.ALMDefectProfileFields.Where(z => (z.SelectedValue != null && z.SelectedValue != string.Empty) || z.ExternalID == "description" || z.ExternalID == "Summary" || z.ExternalID == "name").ToDictionary(x => x.ExternalID, x => x.SelectedValue != null ? x.SelectedValue.Replace("&", "&") : x.SelectedValue = string.Empty) .ToDictionary(w => w.Key, w => w.Key == "description" ? defectSuggestion.Description : w.Value) .ToDictionary(w => w.Key, w => w.Key == "Summary" ? defectSuggestion.Summary : w.Value) .ToDictionary(w => w.Key, w => w.Key == "name" ? defectSuggestion.Summary : w.Value); } catch (Exception ex) { currentALMDefectFieldsValues.Add("Summary", defectSuggestion.Summary); currentALMDefectFieldsValues.Add("description", defectSuggestion.ErrorDetails); } currentALMDefectFieldsValues.Add("screenshots", String.Join(",", defectSuggestion.ScreenshotFileNames)); defectsForOpening.Add(defectSuggestion.DefectSuggestionGuid, currentALMDefectFieldsValues); } } else if (DefectsOpeningModeForAll) { foreach (DefectSuggestion defectSuggestion in WorkSpace.Instance.RunsetExecutor.DefectSuggestionsList) { Dictionary <string, string> currentALMDefectFieldsValues = new Dictionary <string, string>(); try { currentALMDefectFieldsValues = defaultALMDefectProfile.ALMDefectProfileFields.Where(z => (z.SelectedValue != null && z.SelectedValue != string.Empty) || z.ExternalID == "description" || z.ExternalID == "Summary" || z.ExternalID == "name").ToDictionary(x => x.ExternalID, x => x.SelectedValue != null ? x.SelectedValue.Replace("&", "&") : x.SelectedValue = string.Empty) .ToDictionary(w => w.Key, w => w.Key == "description" ? defectSuggestion.Description : w.Value) .ToDictionary(w => w.Key, w => w.Key == "Summary" ? defectSuggestion.Summary : w.Value) .ToDictionary(w => w.Key, w => w.Key == "name" ? defectSuggestion.Summary : w.Value); } catch (Exception ex) { currentALMDefectFieldsValues.Add("Summary", defectSuggestion.Summary); currentALMDefectFieldsValues.Add("description", defectSuggestion.ErrorDetails); } currentALMDefectFieldsValues.Add("screenshots", String.Join(",", defectSuggestion.ScreenshotFileNames)); defectsForOpening.Add(defectSuggestion.DefectSuggestionGuid, currentALMDefectFieldsValues); } } else { return; } var defectFields = defaultALMDefectProfile.ALMDefectProfileFields.Where(a => a.Mandatory || a.ToUpdate).ToList(); //update alm type to open defect RepositoryItemHelper.RepositoryItemFactory.CreateNewALMDefects(defectsForOpening, defectFields, defaultALMDefectProfile.AlmType); } }
/// <summary> /// Returns true if graph belongs to report. /// </summary> /// <param name="report">Report to validate</param> public override bool IsValid(ReportInfo report) { ReportGraphInfo rgi = ReportGraphInfo; // Test validity if ((report != null) && (rgi != null) && (report.ReportID == rgi.GraphReportID)) { return true; } return false; }
public string GenerateTemplate(string templatename, object o) { ReportInfo reportInfo = (ReportInfo)o; return(ReportTemplate.GenerateReport(templatename, reportInfo)); }
/// <summary> /// Sets data to database. /// </summary> protected void btnOK_Click(object sender, EventArgs e) { // Check 'Modify' permission if (!CMSContext.CurrentUser.IsAuthorizedPerResource("cms.reporting", "Modify")) { RedirectToAccessDenied("cms.reporting", "Modify"); } string errorMessage = new Validator().NotEmpty(txtReportDisplayName.Text.Trim(), rfvReportDisplayName.ErrorMessage).NotEmpty(txtReportName.Text.Trim(), rfvReportName.ErrorMessage).Result; if ((errorMessage == "") && (!ValidationHelper.IsCodeName(txtReportName.Text.Trim()))) { errorMessage = GetString("general.invalidcodename"); } if (ReportCategoryInfoProvider.GetReportCategoryInfo(categoryId) == null) { errorMessage = GetString("Report_General.InvalidReportCategory"); } ReportAccessEnum reportAccess = ReportAccessEnum.All; if (!chkReportAccess.Checked) { reportAccess = ReportAccessEnum.Authenticated; } if (errorMessage == "") { //if report with given name already exists show error message if (ReportInfoProvider.GetReportInfo(txtReportName.Text.Trim()) != null) { lblError.Visible = true; lblError.Text = GetString("Report_New.ReportAlreadyExists"); return; } ReportInfo ri = new ReportInfo(); ri.ReportDisplayName = txtReportDisplayName.Text.Trim(); ri.ReportName = txtReportName.Text.Trim(); ri.ReportCategoryID = categoryId; ri.ReportLayout = ""; ri.ReportParameters = ""; ri.ReportAccess = reportAccess; ReportInfoProvider.SetReportInfo(ri); ltlScript.Text += "<script type=\"text/javascript\">"; ltlScript.Text += @"if (parent.frames['reportcategorytree']) { parent.frames['reportcategorytree'].location.href = 'ReportCategory_tree.aspx?reportid=" + ri.ReportID + @"'; } if (parent.parent.frames['reportcategorytree']) { parent.parent.frames['reportcategorytree'].location.href = 'ReportCategory_tree.aspx?reportid=" + ri.ReportID + @"'; } this.location.href = 'Report_Edit.aspx?reportId=" + Convert.ToString(ri.ReportID) + @"&saved=1&categoryID=" + categoryId + @"' </script>"; } else { lblError.Visible = true; lblError.Text = errorMessage; } }
private void Update() { oxyText.text = GameController.manager.oxyData; heartText.text = GameController.manager.heartData; if (gameEnd) { return; } #if UNITY_EDITOR if (Input.GetKey(KeyCode.Space)) { value += Time.deltaTime * 0.2f; } else { //value -= Time.deltaTime * 0.2f; //value = Mathf.Clamp01(value); value = 0; } #else value = GetSliderValue(GetCurrentVolume()); #endif voiceSlider.fillAmount = Mathf.Lerp(voiceSlider.fillAmount, value, 0.1f); timer += Time.deltaTime; fallTimer += Time.deltaTime; if (!GameController.manager.isPaint && GameController.manager.levelMan.selectInfo.index != 5 && timer >= 600.0f) { SoundManager.manager.PlayMusicByPath("09006"); string r = resultList[UnityEngine.Random.Range(0, 6)]; GameController.manager.infoAlert.ShowWithText(r, () => { // save TODO ReportInfo info = new ReportInfo(); DateTime time = DateTime.Now; info.name = time.Year.ToString() + "-" + time.Month.ToString("00") + "-" + time.Day.ToString("00") + " " + time.Hour.ToString("00") + ":" + time.Minute.ToString("00") + ":" + time.Second.ToString("00"); info.type = 0; info.result = info.name + "\n" + GameController.manager.accountMan.selfInfo.name + "\n" + GameController.manager.levelMan.selectInfo.name + "\n" + r;; info.username = GameController.manager.accountMan.selfInfo.username; GameController.manager.reportMan.AddReport(info); SceneManager.LoadScene(1); GameController.manager.enterFromGame = true; }); gameEnd = true; return; } if (!GameController.manager.isPaint) { switch (GameController.manager.levelMan.selectInfo.index) { case 0: volumeParam = Mathf.Lerp(volumeParam, value, 0.02f); float scale = 1.0f + Mathf.Clamp01(volumeParam) * 3; ballImg.transform.localScale = new Vector3(scale, scale, 1.0f); break; case 1: //volumeParam = Mathf.Lerp(volumeParam, value, 0.02f); int index = Mathf.Clamp((int)(desertTimer / 3), 0, 3); desertSliderInner.fillAmount = index / 3.0f; backgroundImg.sprite = game2Sps[index]; break; case 2: // no end break; case 3: volumeParam = Mathf.Lerp(volumeParam, value * 80, 0.008f); windMillImg.transform.Rotate(new Vector3(0, 0, 1), volumeParam); break; case 4: if (fallTimer > 1.0f) { fallTimer -= 1.0f; fallSpawner.UpdateFallGo(value); } break; case 5: paintTimeText.text = Util.SecToTimeString(timer); break; case 6: if (value > 0.6) { backgroundImg.sprite = game6SucSp; } break; default: break; } if (value > 0.1f) { startVoice = true; noVoiceTimer = 0; noVoiceTimes = 0; showScoreTimer = 0; desertTimer += Time.deltaTime; } else if (value < 0.006) { if (noVoiceTimer > 20.0f) { desertTimer -= Time.deltaTime; desertTimer = Math.Max(0, desertTimer); } if (GameController.manager.levelMan.selectInfo.index != 1) { showScoreTimer += Time.deltaTime; if (showScoreTimer > 1.0f) { if (startVoice) { ShowScore(maxVolume); if (maxVolume > 0.6f) { sucTime += 1; if (GameController.manager.levelMan.selectInfo.index == 0) { ballImg.GetComponent <Animator>().SetTrigger("boom"); } } else { sucTime = 0; } maxVolume = -1.0f; if (!GameController.manager.isPaint && GameController.manager.levelMan.selectInfo.index == 6) { backgroundImg.sprite = game6NorSp; } } startVoice = false; showScoreTimer = 0; } } if (GameController.manager.isPaint || (!GameController.manager.isPaint && (GameController.manager.levelMan.selectInfo.index == 2 || GameController.manager.levelMan.selectInfo.index == 5))) { // do nothing } else { if (!stopGame) { noVoiceTimer += Time.deltaTime; } if (GameController.manager.levelMan.selectInfo.index != 1) { if (noVoiceTimer > 5.0f) { noVoiceTimer = 0; noVoiceTimes++; stopGame = true; StopCoroutine("ResetStopFlag"); StartCoroutine("ResetStopFlag"); if (noVoiceTimes == 3) { SoundManager.manager.PlayMusicByPath(GameController.manager.accountMan.selfInfo.sex.ToString() + "9005"); gameEnd = true; string r = resultList[UnityEngine.Random.Range(0, 6)]; GameController.manager.infoAlert.ShowWithText(r, () => { // save TODO ReportInfo info = new ReportInfo(); DateTime time = DateTime.Now; info.name = time.Year.ToString() + "-" + time.Month.ToString("00") + "-" + time.Day.ToString("00") + " " + time.Hour.ToString("00") + ":" + time.Minute.ToString("00") + ":" + time.Second.ToString("00"); info.type = 0; info.username = GameController.manager.accountMan.selfInfo.username; info.result = info.name + "\n" + GameController.manager.accountMan.selfInfo.name + "\n" + GameController.manager.levelMan.selectInfo.name + "\n" + r;; GameController.manager.reportMan.AddReport(info); SceneManager.LoadScene(1); GameController.manager.enterFromGame = true; }); StopCoroutine("EndGameOperation"); StartCoroutine("EndGameOperation"); return; } else { SoundManager.manager.PlayMusicByPath(GameController.manager.accountMan.selfInfo.sex.ToString() + GameController.manager.voiceType.ToString() + "00" + UnityEngine.Random.Range(0, 6)); } } } } } maxVolume = Mathf.Max(maxVolume, value); if (sucTime >= 3) { gameEnd = true; voiceSlider.fillAmount = 0; ballImg.gameObject.SetActive(false); fallSpawner.gameObject.SetActive(false); // save TODO SoundManager.manager.PlayMusicByPath(GameController.manager.accountMan.selfInfo.sex + "9004"); string r = resultList[UnityEngine.Random.Range(0, 6)]; GameController.manager.infoAlert.ShowWithText(r, () => { // save TODOpaintiii ReportInfo info = new ReportInfo(); DateTime time = DateTime.Now; info.name = time.Year.ToString() + "-" + time.Month.ToString("00") + "-" + time.Day.ToString("00") + " " + time.Hour.ToString("00") + ":" + time.Minute.ToString("00") + ":" + time.Second.ToString("00"); info.type = 0; info.username = GameController.manager.accountMan.selfInfo.username; info.result = info.name + "\n" + GameController.manager.accountMan.selfInfo.name + "\n" + GameController.manager.levelMan.selectInfo.name + "\n" + r;; GameController.manager.reportMan.AddReport(info); SceneManager.LoadScene(1); GameController.manager.enterFromGame = true; }); } } if ((!GameController.manager.isPaint && GameController.manager.levelMan.selectInfo.index == 5) || GameController.manager.isPaint) { #if UNITY_EDITOR if (Input.mousePosition.y > 200.0f && Input.mousePosition.y < Screen.height - 100.0f) { if (Input.GetMouseButtonDown(0)) { var go = Instantiate(linePrefab, linePrefab.transform.position, transform.rotation); go.transform.SetParent(lineParent, false); line = go.GetComponent <LineRenderer>();//获得该物体上的LineRender组件 line.startColor = paintInfo.color; line.endColor = paintInfo.color; line.startWidth = paintInfo.width; line.endWidth = paintInfo.width; line.sortingOrder = lineIndex; lineIndex++; touch1Idx = 0; } if (Input.GetMouseButton(0)) { touch1Idx++; line.positionCount = touch1Idx; //设置顶点数 line.SetPosition(touch1Idx - 1, Camera.main.ScreenToWorldPoint(new Vector3(Input.mousePosition.x, Input.mousePosition.y, 15))); //设置顶点位置 //line.enabled=false; } } #else if (Input.touches.Length > 0) { var touch0 = Input.GetTouch(0); if (touch0.phase == TouchPhase.Began) { var go = Instantiate(linePrefab, linePrefab.transform.position, transform.rotation); go.transform.SetParent(lineParent, false); line = go.GetComponent <LineRenderer>();//获得该物体上的LineRender组件 line.startColor = paintInfo.color; line.endColor = paintInfo.color; line.startWidth = paintInfo.width; line.endWidth = paintInfo.width; line.sortingOrder = lineIndex; lineIndex++; touch1Idx = 0; } else if (touch0.phase == TouchPhase.Moved) { touch1Idx++; line.positionCount = touch1Idx; //设置顶点数 line.SetPosition(touch1Idx - 1, Camera.main.ScreenToWorldPoint(new Vector3(Input.GetTouch(0).position.x, Input.GetTouch(0).position.y, 15))); //设置顶点位置 } if (Input.touches.Length > 1) { var touch1 = Input.GetTouch(1); if (touch1.phase == TouchPhase.Began) { var go = Instantiate(linePrefab, linePrefab.transform.position, transform.rotation); go.transform.SetParent(lineParent, false); line2 = go.GetComponent <LineRenderer>();//获得该物体上的LineRender组件 line2.startColor = paintInfo.color; line2.endColor = paintInfo.color; line2.startWidth = paintInfo.width; line2.endWidth = paintInfo.width; line2.sortingOrder = lineIndex; lineIndex++; touch2Idx = 0; } else if (touch1.phase == TouchPhase.Moved) { touch2Idx++; line2.positionCount = touch2Idx; //设置顶点数 line2.SetPosition(touch2Idx - 1, Camera.main.ScreenToWorldPoint(new Vector3(Input.GetTouch(1).position.x, Input.GetTouch(1).position.y, 15))); //设置顶点位置 } } } #endif } }
/// <summary> /// Clones the given report (including attachment files). /// </summary> /// <param name="reportId">Report id</param> protected void Clone(int reportId) { // Check 'Modify' permission if (!CMSContext.CurrentUser.IsAuthorizedPerResource("cms.reporting", "Modify")) { RedirectToAccessDenied("cms.reporting", "Modify"); } // Try to get report info ReportInfo oldri = ReportInfoProvider.GetReportInfo(reportId); if (oldri == null) { return; } DataSet graph_ds = ReportGraphInfoProvider.GetGraphs(reportId); DataSet table_ds = ReportTableInfoProvider.GetTables(reportId); DataSet value_ds = ReportValueInfoProvider.GetValues(reportId); // Duplicate report info object ReportInfo ri = new ReportInfo(oldri, false); ri.ReportID = 0; ri.ReportGUID = Guid.NewGuid(); // Duplicate report info string reportName = ri.ReportName; string oldReportName = ri.ReportName; string reportDispName = ri.ReportDisplayName; while (ReportInfoProvider.GetReportInfo(reportName) != null) { reportName = Increment(reportName, "_", "", 100); reportDispName = Increment(reportDispName, "(", ")", 450); } ri.ReportName = reportName; ri.ReportDisplayName = reportDispName; // Used to eliminate version from create object task using (CMSActionContext context = new CMSActionContext()) { context.CreateVersion = false; ReportInfoProvider.SetReportInfo(ri); } string name; // Duplicate graph data if (!DataHelper.DataSourceIsEmpty(graph_ds)) { foreach (DataRow dr in graph_ds.Tables[0].Rows) { // Duplicate the graph ReportGraphInfo rgi = new ReportGraphInfo(dr); rgi.GraphID = 0; rgi.GraphGUID = Guid.NewGuid(); rgi.GraphReportID = ri.ReportID; name = rgi.GraphName; // Replace layout based on HTML or regular graph type ri.ReportLayout = ReplaceMacro(ri.ReportLayout, rgi.GraphIsHtml ? REP_HTMLGRAPH_MACRO : REP_GRAPH_MACRO, rgi.GraphName, name, oldReportName, reportName); rgi.GraphName = name; ReportGraphInfoProvider.SetReportGraphInfo(rgi); } } // Duplicate table data if (!DataHelper.DataSourceIsEmpty(table_ds)) { foreach (DataRow dr in table_ds.Tables[0].Rows) { // Duplicate the table ReportTableInfo rti = new ReportTableInfo(dr); rti.TableID = 0; rti.TableGUID = Guid.NewGuid(); rti.TableReportID = ri.ReportID; name = rti.TableName; ri.ReportLayout = ReplaceMacro(ri.ReportLayout, REP_TABLE_MACRO, rti.TableName, name, oldReportName, reportName); rti.TableName = name; ReportTableInfoProvider.SetReportTableInfo(rti); } } // Duplicate value data if (!DataHelper.DataSourceIsEmpty(value_ds)) { foreach (DataRow dr in value_ds.Tables[0].Rows) { // Duplicate the value ReportValueInfo rvi = new ReportValueInfo(dr); rvi.ValueID = 0; rvi.ValueGUID = Guid.NewGuid(); rvi.ValueReportID = ri.ReportID; name = rvi.ValueName; ri.ReportLayout = ReplaceMacro(ri.ReportLayout, REP_VALUE_MACRO, rvi.ValueName, name, oldReportName, reportName); rvi.ValueName = name; ReportValueInfoProvider.SetReportValueInfo(rvi); } } List<Guid> convTable = new List<Guid>(); try { MetaFileInfoProvider.CopyMetaFiles(reportId, ri.ReportID, ReportingObjectType.REPORT, MetaFileInfoProvider.OBJECT_CATEGORY_LAYOUT, convTable); } catch (Exception e) { lblError.Visible = true; lblError.Text = e.Message; ReportInfoProvider.DeleteReportInfo(ri); return; } for (int i = 0; i < convTable.Count; i += 2) { Guid oldGuid = convTable[i]; Guid newGuid = convTable[i + 1]; ri.ReportLayout = ri.ReportLayout.Replace(oldGuid.ToString(), newGuid.ToString()); } ReportInfoProvider.SetReportInfo(ri); // Refresh tree ltlScript.Text += "<script type=\"text/javascript\">"; ltlScript.Text += @"if (parent.frames['reportcategorytree']) { parent.frames['reportcategorytree'].location.href = 'ReportCategory_tree.aspx?reportid=" + ri.ReportID + @"'; } if (parent.parent.frames['reportcategorytree']) { parent.parent.frames['reportcategorytree'].location.href = 'ReportCategory_tree.aspx?reportid=" + ri.ReportID + @"'; } this.location.href = 'Report_Edit.aspx?reportId=" + Convert.ToString(ri.ReportID) + @"&saved=1&categoryID=" + categoryId + @"' </script>"; }
/// <summary> /// Updates report information. /// </summary> /// <param name="info"></param> public static void UpdateReportInfo(ReportInfo info) { _context.ReportInfo = info; }