//List<ReportGroupDTO> ReportGroups { set; get; }
public ChartReportResolver(DR_Requester requester, int reportID, RR_ReportSourceRequest request, Unit initialReportWidth)
{
ChartReportReportDTO = bizEntityChartReport.GetEntityChartReport(requester, reportID, true);
//ReportGroups = groups;
reportWidth = initialReportWidth;
Request = request;
}
//private ListReportResolver(int reportID, RR_ReportSourceRequest request, Unit initialReportWidth)
//{
// ListReportReportDTO = bizEntityListReport.GetEntityListReport(reportID, true);
// ReportGroups = groups;
// reportWidth = initialReportWidth;
// Request = request;
//}
private ListReportResolver(EntityListReportDTO listReportDTO, RR_ReportSourceRequest request, Unit initialReportWidth, ListReportResolver parentListReportResolver, EntityListReportSubsDTO parentToChildSubReportDTO, int reportLevel)
{
ParentListReportResolver = parentListReportResolver;
ParentToChildSubReportDTO = parentToChildSubReportDTO;
ListReportReportDTO = listReportDTO;
reportWidth = initialReportWidth;
Request = request;
ReportLevel = reportLevel;
}
private void SetReport(DP_SearchRepository searchRepository)
{
SearchRepository = searchRepository;
//بالاخره درست شد. بعد از مدتها که اومدم سراغ گزارشات خطا میداد
// پروژه رست سرویس از اول ایجاد شد. از تمپلیت خود تلریک استفاده شد تو اد نیو پروژکت .فقط ریزولور رو اصلاح کردم و تو وب کانفیک کانکشن استرینگ رو ست کردم
//برای ویوئر هم مجددا با رایت کلیک و اد کردن یک ریپورت ویوئر wpf
//خودش یسری dll اشافه میکنه و همچنین app.config رو دستکاری میکنه
//یه مشکل با ورژن Newtonsoft.Json بود که با اصلاح خط زیر حل شد
// < dependentAssembly >
// < assemblyIdentity name = "Newtonsoft.Json" publicKeyToken = "30ad4fe6b2a6aeed" culture = "neutral" />
// < bindingRedirect oldVersion = "0.0.0.0-9.0.0.0" newVersion = "9.0.0.0" />
// </ dependentAssembly >
//به نظرم ریپورت اریا اینترنال و اکسترنال رو جدا کنم
if (searchRepository != null)
{
var request = new RR_ReportSourceRequest(AgentUICoreMediator.GetAgentUICoreMediator.GetRequester());
request.ReportID = AreaInitializer.ReportID;
request.SearchDataItems = searchRepository;
if (View.OrderColumnsVisibility)
{
request.OrderByEntityViewColumnID = View.GetOrderColumnID;
if (View.GetSortText == "Ascending")
{
request.SortType = Enum_OrderBy.Ascending;
}
else if (View.GetSortText == "Descending")
{
request.SortType = Enum_OrderBy.Descending;
}
}
var reportEngineConnection = "engine=RestService;uri=http://localhost/MyReportRestServices/api/reports;useDefaultCredentials=True";
List <Type> types = new List <Type>();
types.Add(typeof(DP_SearchRepository));
//types.Add(typeof(LogicPhrase));
types.Add(typeof(SearchProperty));
RemoveUnWantedTypes(request.SearchDataItems);
var uri = SerializeObject <RR_ReportSourceRequest>(request, types);
// uri = "MyReportRestServices.Report1, MyReportRestServices, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null";
var rpSource = new UriReportSource()
{
Uri = uri
};
//rpSource.Parameters.Add(new Parameter() { Name = "bb", Value = request });
View.SetReportSource(null, null);
View.SetReportSource(reportEngineConnection, rpSource);
}
//var rpSource = reportResolver.GetReportSource(request);
//View.SetReportSource(rpSource);
}
public ListReportResolver(DR_Requester requester, int reportID, RR_ReportSourceRequest request, Unit initialReportWidth)
{
//if (!isGroup)
//{
ListReportReportDTO = bizEntityListReport.GetEntityListReport(requester, reportID, true);
// ReportGroups = null;
//}
//else
//{
// ListReportGroupedDTO = bizEntityListReportGrouped.GetEntityListReportGrouped(reportID, true);
// ListReportReportDTO = ListReportGroupedDTO.EntityListReport;
// ReportGroups = ListReportGroupedDTO.ReportGroups;
//}
reportWidth = initialReportWidth;
Request = request;
}
public ReportSource GetReportSource(DR_Requester requester, RR_ReportSourceRequest request)
{
var report = bizEntityReport.GetEntityReport(request.Requester, request.ReportID, false);
if (report == null)
{
throw new Exception("دسترسی به گزارش به شناسه" + " " + request.ReportID + " " + "امکانپذیر نمی باشد");
}
if (report.SearchableReportType == ModelEntites.SearchableReportType.ListReport)
{
ListReportResolver listReportResolver = new ListReportResolver(requester, report.ID, request, Unit.Empty);
return(listReportResolver.GetListReport(requester));
}
else if (report.SearchableReportType == ModelEntites.SearchableReportType.CrosstabReport)
{
CrosstabReportResolver listReportResolver = new CrosstabReportResolver(requester, report.ID, request, Unit.Empty);
return(listReportResolver.GetCrosstabReport());
}
else if (report.SearchableReportType == ModelEntites.SearchableReportType.ChartReport)
{
var chartReport = new BizEntityChartReport().GetEntityChartReport(requester, report.ID, false);
if (chartReport.ChartType == ModelEntites.ChartType.Column)
{
ChartReportResolver chartReportResolver = new ChartReportResolver(requester, report.ID, request, Unit.Empty);
return(chartReportResolver.GetChartReport());
}
else if (chartReport.ChartType == ModelEntites.ChartType.Pie)
{
PieChartReportResolver chartReportResolver = new PieChartReportResolver(requester, report.ID, request, Unit.Empty);
return(chartReportResolver.GetChartReport());
}
else if (chartReport.ChartType == ModelEntites.ChartType.Line)
{
LineChartReportResolver chartReportResolver = new LineChartReportResolver(requester, report.ID, request, Unit.Empty);
return(chartReportResolver.GetChartReport());
}
else if (chartReport.ChartType == ModelEntites.ChartType.Radar)
{
RadarChartReportResolver chartReportResolver = new RadarChartReportResolver(requester, report.ID, request, Unit.Empty);
return(chartReportResolver.GetChartReport());
}
}
throw new Exception("Report type not found!");
}
private void SetReportDetails(DR_Requester requester, Report report, List <ColumnSizeLocation> columnsSizeLocation)
{
bool hasSub = ListReportReportDTO.EntityListReportSubs.Any();
var detail = new Telerik.Reporting.DetailSection();
detail.Height = Telerik.Reporting.Drawing.Unit.Cm(0.5);
detail.Name = "detail";
ReportStyles.SetReportDetailStyle(detail.Style);
report.Items.Add(detail);
Panel panel = new Panel();
panel.Width = reportWidth;
ReportStyles.SetDetailPanelStyle(panel.Style, hasSub);
detail.Items.Add(panel);
//سکوریتی بروی ستوها اعمال شود
var columns = ListReportReportDTO.EntityListView.EntityListViewAllColumns;
int index = 0;
foreach (var column in columns)
{
if (ListReportReportDTO.ReportGroups != null)
{
if (ListReportReportDTO.ReportGroups.Any(x => x.ListViewColumnID == column.ID))
{
continue;
}
}
var columnTextbox = new TextBox();
columnTextbox.CanGrow = false;
columnTextbox.Name = column.Column.Name;
ReportStyles.SetDetailTextboxStyle(columnTextbox.Style);
var columnSizeLocation = columnsSizeLocation.First(x => x.LictViewColumnID == column.ID);
columnTextbox.Width = columnSizeLocation.Width;
columnTextbox.Location = new PointU(columnSizeLocation.XLocation - Unit.Cm(0.0), Unit.Cm(0));
columnTextbox.Height = detail.Height;
//var columnName = "";
//if (column.RelationshipTailID == 0)
//{
// columnName = column.Column.Name + "0";// + "'";
//}
//else
//{
//}
columnTextbox.Value = string.Format("= Fields.{0}", column.RelativeColumnName);
panel.Items.Add(columnTextbox);
index++;
}
int subIndex = 0;
foreach (var subDTO in ListReportReportDTO.EntityListReportSubs)
{
if (CheckSubReportIsRepeated(subDTO))
{
continue;
}
SubReport subReport = new SubReport();
subReport.Width = reportWidth;
subReport.Top = detail.Height + Unit.Cm(subIndex * 0.5);
subIndex++;
RR_ReportSourceRequest newrequest = new RR_ReportSourceRequest(Request.Requester);
newrequest.Identity = Request.Identity;
newrequest.Name = Request.Name;
var tail = bizEntityRelationshipTail.GetEntityRelationshipTail(requester, subDTO.EntityRelationshipTailID);
newrequest.SearchDataItems = new DP_SearchRepository(tail.TargetEntityID);
var entityListReport = bizEntityListReport.GetEntityListReport(requester, subDTO.EntityListReportID, true);
newrequest.ReportID = entityListReport.ID;
Unit SubReportWidth = reportWidth - Unit.Cm(1);
// var relationshipTail = bizEntityRelationshipTail.GetEntityRelationshipTail(subDTO.EntityRelationshipTailID);
ListReportResolver listReportResolver = new ListReportResolver(entityListReport, newrequest, SubReportWidth, this, subDTO, ReportLevel + 1);
var subListReportSource = listReportResolver.GetListReport(requester);
subReport.ReportSource = subListReportSource;
subReport.Left = Unit.Cm(0.5);
ReportStyles.SetSubreportStyle(subReport.Style);
foreach (var relColumn in subDTO.SubsColumnsDTO)
{
var parameter = new Parameter();
parameter.Name = relColumn.ParentEntityListViewColumnRelativeName;
parameter.Value = string.Format("= Fields.{0}", relColumn.ParentEntityListViewColumnRelativeName);
subReport.Parameters.Add(parameter);
}
detail.Items.Add(subReport);
}
}
//private Telerik.Reporting.SqlDataSource sqlDataSource1;
//private Telerik.Reporting.ReportHeaderSection reportHeader;
//private Telerik.Reporting.TextBox titleTextBox;
//private Telerik.Reporting.DetailSection detail;
//private Telerik.Reporting.TextBox nameDataTextBox;
//private Telerik.Reporting.TextBox projectNumberDataTextBox;
//private Telerik.Reporting.TextBox hoursDataTextBox;
//private Telerik.Reporting.SqlDataSource sqlDataSource1;
//private Telerik.Reporting.ReportHeaderSection reportHeader;
//private Telerik.Reporting.TextBox titleTextBox;
//private Telerik.Reporting.DetailSection detail;
//private Telerik.Reporting.TextBox nameDataTextBox;
//private Telerik.Reporting.TextBox projectNumberDataTextBox;
//private Telerik.Reporting.TextBox hoursDataTextBox;
public ReportSource Resolve(string report)
{
//if the report is in XML format, you need to implement a logic to deserialize the report
//Telerik.Reporting.Report reportObject;
//if (report is Telerik.Reporting.Report)
// reportObject = report;
//else
// reportObject = Deserialize(report);
////get the information you need and pass it in the report
//var userId = GetUserFromCookie();
//reportObject.ReportParameters["UserId"].Value = userId;
////// var newreport = new Telerik.Reporting.Report();
////// this.sqlDataSource1 = new Telerik.Reporting.SqlDataSource();
////// this.reportHeader = new Telerik.Reporting.ReportHeaderSection();
////// this.titleTextBox = new Telerik.Reporting.TextBox();
////// this.detail = new Telerik.Reporting.DetailSection();
////// this.nameDataTextBox = new Telerik.Reporting.TextBox();
////// this.projectNumberDataTextBox = new Telerik.Reporting.TextBox();
////// this.hoursDataTextBox = new Telerik.Reporting.TextBox();
////// this.sqlDataSource1.ConnectionString = "Data Source=.;Initial Catalog=SampleDB;Integrated Security=True";
////// this.sqlDataSource1.Name = "sqlDataSource1";
////// this.sqlDataSource1.SelectCommand = @"SELECT Employee_Project.EmployeeSSN, Employee_Project.ProjectNumber, Project.Name, Employee_Project.Hours
//////FROM Employee_Project INNER JOIN
////// Project ON Employee_Project.ProjectNumber = Project.Number";
////// //
////// // reportHeader
////// //
////// this.reportHeader.Height = Telerik.Reporting.Drawing.Unit.Inch(0.20000001788139343D);
////// this.reportHeader.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
////// this.titleTextBox});
////// this.reportHeader.Name = "reportHeader";
////// //
////// // titleTextBox
////// //
////// this.titleTextBox.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D));
////// this.titleTextBox.Name = "titleTextBox";
////// this.titleTextBox.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(5.9999604225158691D), Telerik.Reporting.Drawing.Unit.Inch(0.20000001788139343D));
////// this.titleTextBox.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(230)))), ((int)(((byte)(230)))), ((int)(((byte)(230)))));
////// this.titleTextBox.Style.Font.Name = "B Yekan";
////// this.titleTextBox.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(10D);
////// this.titleTextBox.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
////// this.titleTextBox.StyleName = "Title";
////// this.titleTextBox.Value = "پروژه ها";
////// //
////// // detail
////// //
////// this.detail.Height = Telerik.Reporting.Drawing.Unit.Inch(0.22083334624767304D);
////// this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
////// this.nameDataTextBox,
////// this.projectNumberDataTextBox,
////// this.hoursDataTextBox});
////// this.detail.Name = "detail";
////// //
////// // nameDataTextBox
////// //
////// this.nameDataTextBox.CanGrow = true;
////// this.nameDataTextBox.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D));
////// this.nameDataTextBox.Name = "nameDataTextBox";
////// this.nameDataTextBox.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.125D), Telerik.Reporting.Drawing.Unit.Inch(0.22083334624767304D));
////// this.nameDataTextBox.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(248)))), ((int)(((byte)(248)))), ((int)(((byte)(248)))));
////// this.nameDataTextBox.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
////// this.nameDataTextBox.Style.BorderStyle.Left = Telerik.Reporting.Drawing.BorderType.None;
////// this.nameDataTextBox.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
////// this.nameDataTextBox.Style.Font.Name = "B Yekan";
////// this.nameDataTextBox.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
////// this.nameDataTextBox.StyleName = "Data";
////// this.nameDataTextBox.Value = "= Fields.Name";
////// //
////// // projectNumberDataTextBox
////// //
////// this.projectNumberDataTextBox.CanGrow = true;
////// this.projectNumberDataTextBox.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.1250789165496826D), Telerik.Reporting.Drawing.Unit.Inch(0D));
////// this.projectNumberDataTextBox.Name = "projectNumberDataTextBox";
////// this.projectNumberDataTextBox.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.14575457572937D), Telerik.Reporting.Drawing.Unit.Inch(0.22083334624767304D));
////// this.projectNumberDataTextBox.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(248)))), ((int)(((byte)(248)))), ((int)(((byte)(248)))));
////// this.projectNumberDataTextBox.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
////// this.projectNumberDataTextBox.Style.BorderStyle.Left = Telerik.Reporting.Drawing.BorderType.Solid;
////// this.projectNumberDataTextBox.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
////// this.projectNumberDataTextBox.Style.Font.Name = "B Yekan";
////// this.projectNumberDataTextBox.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
////// this.projectNumberDataTextBox.StyleName = "Data";
////// this.projectNumberDataTextBox.Value = "= Fields.ProjectNumber";
////// //
////// // hoursDataTextBox
////// //
////// this.hoursDataTextBox.CanGrow = true;
////// this.hoursDataTextBox.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(4.2709121704101562D), Telerik.Reporting.Drawing.Unit.Inch(0D));
////// this.hoursDataTextBox.Name = "hoursDataTextBox";
////// this.hoursDataTextBox.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.7290483713150024D), Telerik.Reporting.Drawing.Unit.Inch(0.22083334624767304D));
////// this.hoursDataTextBox.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(248)))), ((int)(((byte)(248)))), ((int)(((byte)(248)))));
////// this.hoursDataTextBox.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
////// this.hoursDataTextBox.Style.BorderStyle.Left = Telerik.Reporting.Drawing.BorderType.Solid;
////// this.hoursDataTextBox.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.None;
////// this.hoursDataTextBox.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
////// this.hoursDataTextBox.Style.Font.Name = "B Yekan";
////// this.hoursDataTextBox.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
////// this.hoursDataTextBox.StyleName = "Data";
////// this.hoursDataTextBox.Value = "= Fields.Hours";
////// //
////// // Report2
////// //
////// newreport.DataSource = this.sqlDataSource1;
////// //newreport.Filters.Add(new Telerik.Reporting.Filter("= Fields.EmployeeSSN", Telerik.Reporting.FilterOperator.Equal, "= Parameters.SSN.Value"));
////// newreport.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
////// this.reportHeader,this.detail });
////// newreport.Name = "Report2";
////// newreport.PageSettings.ContinuousPaper = false;
////// newreport.PageSettings.Landscape = false;
////// newreport.PageSettings.Margins = new Telerik.Reporting.Drawing.MarginsU(Telerik.Reporting.Drawing.Unit.Mm(5D), Telerik.Reporting.Drawing.Unit.Mm(5D), Telerik.Reporting.Drawing.Unit.Mm(5D), Telerik.Reporting.Drawing.Unit.Mm(5D));
////// newreport.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.A4;
////// //reportParameter1.Name = "SSN";
////// //reportParameter1.Type = Telerik.Reporting.ReportParameterType.Integer;
////// //reportParameter1.Value = "0";
////// //newreport.ReportParameters.Add(reportParameter1);
////// newreport.Style.BackgroundColor = System.Drawing.Color.Empty;
////// newreport.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(26)))), ((int)(((byte)(67)))), ((int)(((byte)(113)))));
////// newreport.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid;
////// newreport.Style.Font.Name = "B Yekan";
////// //styleRule1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
////// //new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextItemBase)),
////// //new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.HtmlTextBox))});
////// //styleRule1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(2D);
////// //styleRule1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(2D);
////// //styleRule2.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
////// //new Telerik.Reporting.Drawing.StyleSelector("Title")});
////// //styleRule2.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(105)))), ((int)(((byte)(103)))), ((int)(((byte)(109)))));
////// //styleRule2.Style.Font.Name = "Book Antiqua";
////// //styleRule2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(18D);
////// //styleRule3.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
////// //new Telerik.Reporting.Drawing.StyleSelector("Caption")});
////// //styleRule3.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(105)))), ((int)(((byte)(103)))), ((int)(((byte)(109)))));
////// //styleRule3.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(206)))), ((int)(((byte)(185)))), ((int)(((byte)(102)))));
////// //styleRule3.Style.Font.Name = "Book Antiqua";
////// //styleRule3.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(10D);
////// //styleRule3.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
////// //styleRule4.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
////// //new Telerik.Reporting.Drawing.StyleSelector("Data")});
////// //styleRule4.Style.Font.Name = "Book Antiqua";
////// //styleRule4.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
////// //styleRule4.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
////// //styleRule5.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
////// //new Telerik.Reporting.Drawing.StyleSelector("PageInfo")});
////// //styleRule5.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(160)))), ((int)(((byte)(160)))), ((int)(((byte)(160)))));
////// //styleRule5.Style.Font.Name = "Book Antiqua";
////// //styleRule5.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(8D);
////// //styleRule5.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
////// //newreport.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] {
////// //styleRule1,
////// //styleRule2,
////// //styleRule3,
////// //styleRule4,
////// //styleRule5});
////// newreport.Width = Telerik.Reporting.Drawing.Unit.Inch(6D);
////// return new Telerik.Reporting.InstanceReportSource { ReportDocument = newreport };
List <Type> types = new List <Type>();
types.Add(typeof(DP_SearchRepository));
types.Add(typeof(LogicPhraseDTO));
types.Add(typeof(SearchProperty));
RR_ReportSourceRequest request = Deserialize <RR_ReportSourceRequest>(report, types);
return(reportResolver.GetReportSource(request.Requester, request));
// return new ListReportResolver().GetListReport(null, null);
// return null;
}