/// <summary> /// Prints the preview report. /// </summary> /// <param name="frmParent">The FRM parent.</param> /// <param name="reportId">The s report identifier.</param> /// <param name="isPint">if set to <c>true</c> [is pint].</param> public void PrintPreviewReport(XtraForm frmParent, string reportId, bool isPint) { try { Cursor.Current = Cursors.WaitCursor; _reportListModel = ReportLists.Find(item => item.ReportID == reportId); if (_reportListModel == null) { return; } _frmParentForm = frmParent; var reportListSource = GetDataSource(frmParent, _reportListModel); if (reportListSource == null) { return; } if (reportListSource.Count <= 0) { XtraMessageBox.Show("Dữ liệu lấy lên báo cáo Không có bản ghi nào.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (!string.IsNullOrEmpty(_reportListModel.TableName)) { DataMember = _reportListModel.TableName.Trim(); } DisplayReport(ref reportListSource, _reportListModel, false, frmParent, false, isPint, DateTime.MinValue); } catch (Exception ex) { XtraMessageBox.Show(ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Prints the preview report by report. /// </summary> /// <param name="frmParent">The FRM parent.</param> /// <param name="param">The e parameter.</param> /// <param name="isPrint">if set to <c>true</c> [is print].</param> public void PrintPreviewReportByReport(XtraForm frmParent, DrilldownReportParam param, bool isPrint) { try { Cursor.Current = Cursors.WaitCursor; _reportListModel = ReportLists.Find(item => item.ReportID == param.ArgParameter[0].ToString()); if (_reportListModel == null) { return; } _frmParentForm = frmParent; var reportListSource = GetDrillDownDataSource(frmParent, _reportListModel, param.ArgParameter); if (reportListSource == null || reportListSource.Count <= 0) { return; } if (reportListSource.Count > 0) { if (!string.IsNullOrEmpty(_reportListModel.TableName)) { DataMember = _reportListModel.TableName.Trim(); } DisplayReport(ref reportListSource, _reportListModel, false, frmParent, false, isPrint, DateTime.MinValue); } else { XtraMessageBox.Show("Không có bản ghi nào", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { XtraMessageBox.Show(ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public void PrintPreviewReport(XtraForm frmParent, string reportID, bool isPint) { try { List <ReportListModel> reportList = _reportListPresenter.GetAllReportList(); ReportListModel _reportListModel = reportList.Find(item => item.ReportID == reportID); if (_reportListModel == null) { return; } // var reportListSource = GetDataSource(frmParent, _reportListModel); List <C30BBModel> lstC30BB = new List <C30BBModel>(); for (int i = 0; i < gridViewDetail.RowCount; i++) { var rowData = (C30BBModel)gridViewDetail.GetRow(i); lstC30BB.Add(rowData); } if (lstC30BB.Count <= 0) { XtraMessageBox.Show("Dữ liệu lấy lên báo cáo Không có bản ghi nào.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } var reportHelper = new ReportHelper(); // reportHelper.DisplayReport(ref lstC30BB, _reportListModel, false, frmParent, false, false, DateTime.MinValue); // DisplayReport(ref reportListSource, _reportListModel, false, frmParent, false, isPint, DateTime.MinValue); // DisplayReport(lstC30BB, _reportListModel, false, frmParent, false, isPint, DateTime.MinValue); } catch (Exception ex) { XtraMessageBox.Show(ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Gets the data source. /// </summary> /// <param name="frmParent">The FRM parent.</param> /// <param name="reportList">The report list.</param> /// <returns></returns> private ICollection GetDataSource(XtraForm frmParent, ReportListModel reportList) { IList dataSource = null; try { if (!string.IsNullOrEmpty(reportList.InputTypeName)) { var type = Assembly.GetExecutingAssembly().GetType((GetType().Namespace + "." + reportList.InputTypeName)); var target = (BaseReport)Activator.CreateInstance(type); if (!string.IsNullOrEmpty(reportList.ProcedureName)) { if (CommonVariable == null) { CommonVariable = new GlobalVariable(); } CommonVariable.StoreProcedureName = reportList.ProcedureName; CommonVariable.ReportList = reportList; CommonVariable.IsDrillDownReport = false; var args = new object[] { frmParent, CommonVariable, _rsTool }; dataSource = (IList)(type.InvokeMember(reportList.FunctionReportName, BindingFlags.InvokeMethod, null, target, args)); } } } catch (Exception ex) { XtraMessageBox.Show(ex.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(dataSource); }
private ReportListModel GetReportList(IEnumerable <AppReport> rptDataList, int tileID = 0) { string userAlias = Session["UserName"] == null ? "" : Session["UserName"].ToString(); ReportListModel rptList = new ReportListModel(); foreach (AppReport data in rptDataList) { ReportItem item = new ReportItem(); item.ID = data.Id.GetValueOrDefault(); item.ReportName = data.Title; item.ReprotStatus = data.Status.Name; item.ReportDescription = data.Description; item.ReportFeaturePics = data.Images; item.ReportOwners = data.Owners; item.ReportTags = data.Tags; item.ReprotContent = data.Content; item.ReportCategory = data.Categories.Where(_ => _.ParentId != null).Select(_ => new AppCategory() { CategoryName = _.CategoryName, Id = _.Id }).ToList <AppCategory>(); bool IsOwner = data.Owners.Any(u => string.Compare(u.UserName, userAlias, true) == 0); // if current user is site admin or data owner if (userAlias != "") { if (IsOwner || service.GetUserAdminTeams(userAlias).Count() > 0) { item.Editable = true; } } else { item.Editable = false; } if (tileID == SystemDefinedTile.MyReports_Recommended.SystemDefinedTileId) { //foreach (var rec in data.Recommendations) //{ // ReportRecommendViewModel recViewModel = new ReportRecommendViewModel(); // recViewModel.UserName = rec.Recommender.DisplayName; // recViewModel.Comment = rec.Comment; // item.RecommendList.Add(recViewModel); //} } //GetOpenSetting(ref item, data); rptList.ReportItemList.Add(item); } return(rptList); }
/// <summary> /// Displays the report. /// </summary> /// <param name="dataSource">The data source.</param> /// <param name="reportList">The report list.</param> /// <param name="isVoucher">if set to <c>true</c> [b is voucher].</param> /// <param name="frmForm">The form.</param> /// <param name="isShowDialog">if set to <c>true</c> [b show dialog].</param> /// <param name="isPrint">if set to <c>true</c> [is print].</param> /// <param name="voucherDate">The d voucher date.</param> public void DisplayReport(ref ICollection dataSource, ReportListModel reportList, bool isVoucher, XtraForm frmForm, bool isShowDialog, bool isPrint, DateTime voucherDate) { try { Cursor.Current = Cursors.WaitCursor; if (dataSource == null) { return; } //CommonVariable = new GlobalVariable(); var oRsTool = ReportSharpTool; var str = GlobalVariable.ReportPath + (string.IsNullOrEmpty(oRsTool.ReportFileName) ? reportList.ReportFile : oRsTool.ReportFileName); oRsTool.RssObject.VoucherDate = voucherDate; oRsTool.ListDataSource = dataSource; oRsTool.DataMember = reportList.TableName.Trim(); oRsTool.LayoutReportPath = GlobalVariable.ReportPath; oRsTool.ReportFileName = str; if (!AddParameter(ref dataSource)) { return; } oRsTool.IsPrint = isPrint; oRsTool.ReportTitle = reportList.ReportName; oRsTool.ProductName = GlobalVariable.ProducName; oRsTool.DisplayProductName = false; _frmParentForm = frmForm; var model = new Model(); //tam thoi comment CurrencyModels = model.GetCurrencies(); NumberToWord.Currencies = new List <Currency>(); foreach (var currencyModel in CurrencyModels) { NumberToWord.Currencies.Add(new Currency { //CurrencyId = currencyModel.CurrencyId, CurrencyCode = currencyModel.CurrencyCode, CurrencyName = currencyModel.CurrencyName, Prefix = currencyModel.Prefix, Suffix = currencyModel.Suffix }); } oRsTool.RunReport(frmForm, isShowDialog); } catch (Exception ex) { XtraMessageBox.Show(ex.ToString() + ex.InnerException, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { Cursor.Current = Cursors.Default; } }
public void ExtractXMLKhoBac(string reportId) { _reportListModel = ReportLists.Find(item => item.ReportId == reportId); if (!string.IsNullOrEmpty(_reportListModel.InputTypeName)) { var type = Assembly.GetExecutingAssembly().GetType(GetType().Namespace + "." + "ExportXML"); var target = (BaseReport)Activator.CreateInstance(type); if (!string.IsNullOrEmpty(_reportListModel.ProcedureName)) { var args = new object[] { ReportParameter, _rsTool, null, false }; var dataSource = (IList)(type.InvokeMember(_reportListModel.FunctionReportName + "XML", BindingFlags.InvokeMethod, null, target, args)); } } }
private DataSet GetDataSet(XtraForm frmParent, ReportListModel reportList, object[] parms) { DataSet ds = new DataSet(); if (!string.IsNullOrEmpty(reportList.InputTypeName)) { var type = Assembly.GetExecutingAssembly().GetType(GetType().Namespace + "." + reportList.InputTypeName); var target = (BaseReport)Activator.CreateInstance(type); if (!string.IsNullOrEmpty(reportList.ProcedureName)) { var args = new object[] { reportList.ProcedureName, parms }; ds = (DataSet)(type.InvokeMember(reportList.FunctionReportName, BindingFlags.InvokeMethod, null, target, args)); } } return(ds); }
public static void PreviewReport(XtraForm frmParent, ReportListModel reportListModel, object[] paramStore, Dictionary <string, object> paramReport) { try { Cursor.Current = Cursors.WaitCursor; var reportHelper = new ReportHelper(); reportHelper.PreviewReportUsingDataSet(frmParent, reportListModel, paramStore, paramReport); } catch (Exception ex) { XtraMessageBox.Show("Lỗi: " + ex.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } finally { Cursor.Current = Cursors.Default; } }
public void PreviewReportUsingDataSet(XtraForm frmParent, ReportListModel reportListModel, object[] paramStore, Dictionary <string, object> paramReport) { if (reportListModel == null) { return; } _frmParentForm = frmParent; ParamReport = paramReport; var dataSet = GetDataSet(frmParent, reportListModel, paramStore); if (dataSet == null) { return; } DisplayReport(dataSet, reportListModel, frmParent); }
public ActionResult ReportResults(ReportModel model, ReportListModel models) { /* * var mods = new List<ReportModel>(); * * var rec1 = new ReportModel(); * rec1.LName = "Bolden"; * rec1.FName = "Robert"; * rec1.Amount = 100.0; * * mods.Add(rec1); */ ViewBag.MyModel = ReportModel.getReport(model, models); return(View()); }
public IActionResult GetList([FromQuery] ReportViewModel model) { var messages = _messageRepository.GetMessagesByDavaId(model.DavaId).ToList(); var documents = _documentRepository.GetDocuments().Where(d => d.DavaId == model.DavaId).ToList(); var masrafs = _masrafRepository.GetMasrafs().Where(d => d.DavaId == model.DavaId).ToList(); if (model.DateDisabled) { messages.Where(m => m.Date <= model.EndDate && m.Date >= model.StartDate).ToList(); documents.Where(m => m.Date <= model.EndDate && m.Date >= model.StartDate).ToList(); masrafs.Where(m => m.Date <= model.EndDate && m.Date >= model.StartDate).ToList(); } var reportListModel = new ReportListModel() { Masrafs = masrafs, Documents = documents, Messages = messages }; var result = _mapper.Map <ReportListViewModel>(reportListModel); return(Ok(result)); }
private DataTable GetDataSourceDataTable(XtraForm frmParent, ReportListModel reportList) { DataTable dataSource = null; try { if (!string.IsNullOrEmpty(reportList.InputTypeName)) { var type = Assembly.GetExecutingAssembly().GetType(GetType().Namespace + "." + reportList.InputTypeName); var target = (BaseReport)Activator.CreateInstance(type); if (!string.IsNullOrEmpty(reportList.ProcedureName)) { var args = new object[] { ReportParameter, _rsTool }; dataSource = (DataTable)(type.InvokeMember(reportList.FunctionReportName, BindingFlags.InvokeMethod, null, target, args)); } } } catch (Exception ex) { XtraMessageBox.Show("Có lỗi xảy ra trong quá trình truy vấn dữ liệu!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(dataSource); }
private string GetReports() { string userName = Session["UserName"] == null ? "" : Session["UserName"].ToString(); string output; string siteType = Request["siteType"]; string teamGuid = Request["SiteGuid"]; JavaScriptSerializer jss = new JavaScriptSerializer(); var paramDes = jss.Deserialize <WebApplication1.Models.QueryParameterViewModel>(Request["queryParam"]); int tileId = int.Parse(paramDes.TileId); // Get the reports from the reports list using (MainDBUnitWorkContext context = new MainDBUnitWorkContext()) { ReportRepository rep = new ReportRepository(context); TileRepository tileRep = new TileRepository(context); TileQueryLogicRepository tileQuery = new TileQueryLogicRepository(context); TileServices tService = new TileServices(tileRep, null, null, null, null, null, tileQuery); var tile = tService.GetTileById(tileId); EditReportService editReport = new EditReportService(rep, null, null, null, null, tileRep, tileQuery); #region Get ReportFilter ReportFilter filer = new ReportFilter(); foreach (WebApplication1.Models.FilterModel vm in paramDes.FilterEntityList) { switch (vm.FilterType) { case "Tag": filer.TagsIdCollection = (from fl in vm.FilterItemList select int.Parse(fl.Value)).ToList(); break; case "Owner": filer.OwnerIdCollection = (from fl in vm.FilterItemList select fl.Value).ToList(); break; case "Sub Category": filer.SubCategoryIdCollection = (from fl in vm.FilterItemList select int.Parse(fl.Value)).ToList(); break; default: break; } } #endregion // TO-DO: Team admin is set to true var reports = editReport.GetReportsByTeamWithReportsRequire(teamGuid, tileId, filer, true, userName, paramDes.CurrentPage, paramDes.PageSize, SortField.ReportTitle, (paramDes.SortAscending ? SortOrder.ASC : SortOrder.DESC)).ToArray(); ReportListModel rptList = GetReportList(reports, Convert.ToInt32(paramDes.TileId)); output = jss.Serialize(rptList); return(output); } }
public int ModifyTemplateReport(ReportListModel model) { return(dal.ModifyTemplateReport(model)); }
public int EnableReport(ReportListModel model) { return(dal.EnableReport(model)); }
public void DisplayReport(DataSet dataSource, ReportListModel reportList, XtraForm frmForm) { dataSource.DataSetName = "DataSource"; var manager = new ReportManager(); manager.GetReportParameter += manager_GetReportParameter; manager.OwnerForm = frmForm; if (string.IsNullOrEmpty(reportList.TableName)) { return; } var objectPointerCollection = new ObjectPointerCollection(); // Các table name cách nhau = dấu ; var _listTableName = reportList.TableName.Split(';'); if (_listTableName.Length > dataSource.Tables.Count || (dataSource.Tables.Count > 0 && dataSource.Tables[0].Rows.Count <= 0)) { XtraMessageBox.Show("Dữ liệu báo cáo không có bản ghi nào!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } for (int i = 0; i < _listTableName.Length; i++) { DataTable dt = new DataTable(); dt = dataSource.Tables[i]; dt.TableName = _listTableName[i]; var colDecimalPlaces = new DataColumn(); colDecimalPlaces.ColumnName = nameof(TextFormat.DecimalPlaces); // Số chữ số sau dấu phẩy colDecimalPlaces.DataType = typeof(int); colDecimalPlaces.DefaultValue = ReportSharpTool?.RssObject?.CurrencyFormat?.DecimalPlaces; var colDecimalSeparator = new DataColumn(); colDecimalSeparator.ColumnName = nameof(TextFormat.DecimalSeparator); colDecimalSeparator.DataType = typeof(string); colDecimalSeparator.DefaultValue = ReportSharpTool?.RssObject?.CurrencyFormat?.DecimalSeparator; var colGroupSeparator = new DataColumn(); colGroupSeparator.ColumnName = nameof(TextFormat.GroupSeparator); colGroupSeparator.DataType = typeof(string); colGroupSeparator.DefaultValue = ReportSharpTool?.RssObject?.CurrencyFormat?.GroupSeparator; dt.Columns.AddRange(new DataColumn[] { colDecimalPlaces, colDecimalSeparator, colGroupSeparator }); objectPointerCollection.Add(dt.TableName, dt); } //objectPointerCollection.Add(nameof(dataSource), dataSource); manager.DataSources = objectPointerCollection; var reportSlot = new FileReportSlot { FilePath = GlobalVariable.ReportPath + reportList.ReportFile }; manager.Reports.Add(reportSlot); AddParamSystem(); reportSlot.RenderDocument(); reportSlot.Document.Name = reportList.ReportName; var previewForm = new PreviewForm(reportSlot); previewForm.WindowState = FormWindowState.Maximized; previewForm.ReportViewer.DocumentLoaded += ReportViewer_DocumentLoaded; previewForm.ShowDialog(); }
/// <summary> /// Updates the report list. /// </summary> /// <param name="reportListModel">The report list model.</param> /// <returns></returns> public string UpdateReportList(ReportListModel reportListModel) { return(null); //return Model.UpdateReportList(reportListModel); }
/// <summary> /// Updates the report list. /// </summary> /// <param name="reportListModel">The report list model.</param> /// <returns></returns> public string UpdateReportList(ReportListModel reportListModel) { return(Model.UpdateReportList(reportListModel)); }