public static void GenerateNewReport(DataTable tbl, string path, string caption)
{
StiReport report = new StiReport();
//Add tbl to datastore
report.RegData("tbl", tbl);
//Fill dictionary
report.Dictionary.Synchronize();
report.Dictionary.DataSources[0].Name = "tbl";
report.Dictionary.DataSources[0].Alias = "tbl";
//StiPage page = report.Pages[0];
foreach (StiPage page in report.Pages)
{
//Create header
if (report.Pages.IndexOf(page) == 0)
{
StiText header = new StiText(new RectangleD(0, 0, page.Width, page.Height / 20), caption);
StiText period = new StiText(new RectangleD(0, page.Height / 20, page.Width, page.Height / 20), tbl.TableName);
header.HorAlignment = StiTextHorAlignment.Center;
header.Font = new Font("Arial", 22.5f);
period.HorAlignment = StiTextHorAlignment.Center;
header.Font = new Font("Arial", 12f);
page.Components.Add(header);
page.Components.Add(period);
header.Render();
period.Render();
}
//Create HeaderBand
StiHeaderBand headerBand = new StiHeaderBand();
headerBand.Height = 0.5;
headerBand.Name = "HeaderBand";
page.Components.Add(headerBand);
//Create Databand
StiDataBand dataBand = new StiDataBand();
dataBand.DataSourceName = "tbl";
dataBand.Height = 0.5;
dataBand.Name = "DataBand";
page.Components.Add(dataBand);
//Create texts
double pos = 0;
double columnWidth = StiAlignValue.AlignToMinGrid(page.Width / tbl.Columns.Count, 0.1, true);
int nameIndex = 1;
foreach (DataColumn dataColumn in tbl.Columns)
{
//Create text on header
StiText headerText = new StiText(new RectangleD(pos, page.Height / 10, columnWidth, 0.5));
headerText.Text.Value = dataColumn.Caption;
headerText.HorAlignment = StiTextHorAlignment.Center;
headerText.Name = "HeaderText" + nameIndex.ToString();
headerText.Brush = new StiSolidBrush(Color.LightGray);
headerText.Border.Side = StiBorderSides.All;
headerBand.Components.Add(headerText);
//Create text on Data Band
StiText dataText = new StiText(new RectangleD(pos, 0, columnWidth, 0.5));
dataText.Text.Value = "{tbl." + Stimulsoft.Report.CodeDom.StiCodeDomSerializator.ReplaceSymbols(dataColumn.ColumnName) + "}";
dataText.Name = "DataText" + nameIndex.ToString();
dataText.Border.Side = StiBorderSides.All;
//Add highlight
StiCondition condition = new StiCondition();
condition.BackColor = Color.DarkGray;
condition.TextColor = Color.Black;
condition.Expression = "(Line & 1) == 1";
condition.Item = StiFilterItem.Expression;
dataText.Conditions.Add(condition);
dataBand.Components.Add(dataText);
pos = pos + columnWidth;
nameIndex++;
}
//Create FooterBand
StiFooterBand footerBand = new StiFooterBand();
footerBand.Height = 0.5;
footerBand.Name = "FooterBand";
page.Components.Add(footerBand);
//Create text on footer
StiText footerText = new StiText(new RectangleD(0, 0, page.Width, 0.5));
footerText.Text.Value = "Всего записей - {Count()}";
footerText.HorAlignment = StiTextHorAlignment.Right;
footerText.Name = "FooterText";
footerText.Brush = new StiSolidBrush(Color.Gray);
footerBand.Components.Add(footerText);
report.Show();
}
}
public IReportBuilder WithDataBand(List <string> fields, double[] sizes, List <TextAlign> aligns = null, string dataSetName = "dataset", double height = 0.2)
{
CurrentData = new StiDataBand(MakeRectangle(0, 0, 0, height))
{
DataSourceName = dataSetName
};
var condition = new StiCondition
{
BackColor = Color.FromArgb(0),
TextColor = Color.Transparent,
Expression = "(Line & 1) == 1",
Item = StiFilterItem.Expression
};
CurrentData.Conditions.Add(condition);
Page.Components.Add(CurrentData);
var newVariable = new StiVariable()
{
Name = "Xdec",
Alias = "Xdec",
Value = "10",
Type = typeof(int)
};
Report.Dictionary.Variables.Add(newVariable);
CurrentData.BeforePrintEvent = new StiBeforePrintEvent("Xdec=Xdec+1;");
CurrentData.AfterPrintEvent = new StiAfterPrintEvent("Xdec=Xdec+1;");
var x = 0.0;
for (var i = 0; i < fields.Count; i++)
{
TextAlign align;
if (aligns != null)
{
align = aligns[i];
}
else
{
align = Fields.FirstOrDefault(a => string.Equals(a.Item1, fields[i], StringComparison.CurrentCultureIgnoreCase))?.Item3 ?? TextAlign.Right;
}
var text = "{" + $"{dataSetName}.{fields[i]}" + "}";
var stiText = _textBuilder.New(text).WithFormat(MakeFormat(fields[i])).WithPosition(x)
.WithSize(sizes[i]).WithAlign((StiTextHorAlignment)align).Then();
x += sizes[i];
CurrentData.Components.Add(stiText);
}
return(this);
}
private void PrintDataGrid(DataGrid sender)
{
DataView dataView = (DataView)sender.DataSource;
StiReport report = new StiReport();
report.ScriptLanguage = StiReportLanguageType.CSharp;
//Add data to datastore
report.RegData("view", dataView);
//Fill dictionary
report.Dictionary.Synchronize();
StiPage page = report.Pages.Items[0];
//Create HeaderBand
StiHeaderBand headerBand = new StiHeaderBand();
headerBand.Height = 0.5f;
headerBand.Name = "HeaderBand";
page.Components.Add(headerBand);
//Create Dataaband
StiDataBand dataBand = new StiDataBand();
dataBand.DataSourceName = "view" + dataView.Table.TableName;
dataBand.Height = 0.5f;
dataBand.Name = "DataBand";
page.Components.Add(dataBand);
//Create texts
Double pos = 0;
Double columnWidth = StiAlignValue.AlignToMinGrid(page.Width / dataView.Table.Columns.Count, 0.1, true);
int nameIndex = 1;
foreach (DataColumn column in dataView.Table.Columns)
{
//Create text on header
StiText headerText = new StiText(new RectangleD(pos, 0, columnWidth, 0.5f));
headerText.Text.Value = column.Caption;
headerText.HorAlignment = StiTextHorAlignment.Center;
headerText.Name = "HeaderText" + nameIndex.ToString();
headerText.Brush = new StiSolidBrush(Color.LightGreen);
headerText.Border.Side = StiBorderSides.All;
headerBand.Components.Add(headerText);
//Create text on Data Band
StiText dataText = new StiText(new RectangleD(pos, 0, columnWidth, 0.5f));
dataText.Text.Value = "{view" + dataView.Table.TableName + "." + Stimulsoft.Report.CodeDom.StiCodeDomSerializator.ReplaceSymbols(column.ColumnName) + "}";
dataText.Name = "DataText" + nameIndex.ToString();
dataText.Border.Side = StiBorderSides.All;
//Add highlight
StiCondition condition = new StiCondition();
condition.BackColor = Color.CornflowerBlue;
condition.TextColor = Color.Black;
condition.Expression = "(Line & 1) == 1";
condition.Item = StiFilterItem.Expression;
dataText.Conditions.Add(condition);
dataBand.Components.Add(dataText);
pos += columnWidth;
nameIndex++;
}
//Create FooterBand
StiFooterBand footerBand = new StiFooterBand();
footerBand.Height = 0.5f;
footerBand.Name = "FooterBand";
page.Components.Add(footerBand);
//Create text on footer
StiText footerText = new StiText(new RectangleD(0, 0, page.Width, 0.5f));
footerText.Text.Value = "Count - {Count()}";
footerText.HorAlignment = StiTextHorAlignment.Right;
footerText.Name = "FooterText";
footerText.Brush = new StiSolidBrush(Color.LightGreen);
footerBand.Components.Add(footerText);
//Render without progress bar
report.Render(false);
report.Show();
}
public StiReport GetReport(SystemReportType SRT, SystemReportTypeFilterConditions SrtFilterConditions)
{
try
{
ReportHelper reportHelper = ReportHelper.Instance("شرکت طرح و پردازش غدیر", BUser.CurrentUser.ID, BUser.CurrentUser.Person.Name, new List <decimal>(), Guid.NewGuid().ToString(), string.Empty, false, string.Empty, string.Empty, new List <decimal>());
StiReport stiReport = new StiReport();
double columnWidth = 0;
double dataBandRowHeight = 1.0;
double dataBandHeight = 4;
double dataHeaderRowHeight = 1;
double dataHeaderHeight = 3;
Font dataBandFont = new Font("Tahoma", 8, FontStyle.Bold);
Font headerBandFont = new Font("arial", 11, FontStyle.Bold);
Font titleBandFont = new Font("Tahoma", 16, FontStyle.Bold);
Font groupBandFont = new Font("Tahoma", 10, FontStyle.Bold);
Font pageHeaderFont = new Font("Tahoma", 18, FontStyle.Bold);
stiReport.Unit = Stimulsoft.Report.Units.StiUnit.Centimeters;
StiPage page = stiReport.Pages[0];
page.Orientation = StiPageOrientation.Landscape;
page.Width = 29.7;
page.Height = 21;
page.Margins.Bottom = 0.5;
page.Margins.Left = 0.5;
page.Margins.Right = 0.5;
page.Margins.Top = 0.5;
StiPageHeaderBand pageHeader = new StiPageHeaderBand();
pageHeader.Height = 2;
pageHeader.Width = page.Width;
pageHeader.Name = "PageHeader";
pageHeader.Border.Side = StiBorderSides.All;
pageHeader.Border.Color = Color.Cornsilk;
page.Components.Add(pageHeader);
StiText officeNameText_pageHeader = new StiText(new RectangleD(0, 0, 10.6, 0.6));
officeNameText_pageHeader.Left = (page.Width / 2) - 5.3;
officeNameText_pageHeader.Top = 0;
IList <Presentaion_Helper.Proxy.DataAccessProxy> dataAccessList = new BDataAccess().GetAllByUserId(DataAccessParts.Corporation, BUser.CurrentUser.ID);
string headerText = string.Empty;
if (dataAccessList != null && dataAccessList.Count > 0)
{
headerText = dataAccessList.FirstOrDefault().Name;
}
officeNameText_pageHeader.Text = headerText;
officeNameText_pageHeader.HorAlignment = StiTextHorAlignment.Center;
officeNameText_pageHeader.VertAlignment = StiVertAlignment.Center;
officeNameText_pageHeader.Name = "OfficeNameHeader";
officeNameText_pageHeader.Font = pageHeaderFont;
officeNameText_pageHeader.Height = 1;
pageHeader.Components.Add(officeNameText_pageHeader);
StiText reportNameText_pageHeader = new StiText(new RectangleD(0, 0, 10.6, 0.6));
reportNameText_pageHeader.Left = (page.Width / 2) - 5.3;
reportNameText_pageHeader.Top = 1;
reportNameText_pageHeader.HorAlignment = StiTextHorAlignment.Center;
reportNameText_pageHeader.VertAlignment = StiVertAlignment.Center;
reportNameText_pageHeader.Name = "reportNameText";
reportNameText_pageHeader.Font = pageHeaderFont;
reportNameText_pageHeader.Height = 1;
pageHeader.Components.Add(reportNameText_pageHeader);
StiText reportCreateDateLabelText_pageHeader = new StiText(new RectangleD(0, 0, 2.6, 0.6));
reportCreateDateLabelText_pageHeader.Left = 2.4;
reportCreateDateLabelText_pageHeader.Top = 0;
switch (BLanguage.CurrentLocalLanguage)
{
case LanguagesName.Unknown:
reportCreateDateLabelText_pageHeader.Text = ": تاریخ تهیه گزارش";
break;
case LanguagesName.Parsi:
reportCreateDateLabelText_pageHeader.Text = ": تاریخ تهیه گزارش";
break;
case LanguagesName.English:
reportCreateDateLabelText_pageHeader.Text = "Report Date :";
break;
default:
break;
}
reportCreateDateLabelText_pageHeader.HorAlignment = StiTextHorAlignment.Center;
reportCreateDateLabelText_pageHeader.VertAlignment = StiVertAlignment.Center;
reportCreateDateLabelText_pageHeader.Name = "reportCreateDateLabelText";
reportCreateDateLabelText_pageHeader.Font = dataBandFont;
reportCreateDateLabelText_pageHeader.TextBrush = new StiSolidBrush(Color.FromArgb(89, 89, 89));
pageHeader.Components.Add(reportCreateDateLabelText_pageHeader);
StiText reportCreateDateText_pageHeader = new StiText(new RectangleD(0, 0, 2.4, 0.6));
reportCreateDateText_pageHeader.Left = 0;
reportCreateDateText_pageHeader.Top = 0;
reportCreateDateText_pageHeader.Text = ReportHelper.Instance().ShamsiGetNow();
reportCreateDateText_pageHeader.HorAlignment = StiTextHorAlignment.Center;
reportCreateDateText_pageHeader.VertAlignment = StiVertAlignment.Center;
reportCreateDateText_pageHeader.Name = "reportCreateDateText";
reportCreateDateText_pageHeader.Font = dataBandFont;
reportCreateDateText_pageHeader.TextBrush = new StiSolidBrush(Color.FromArgb(183, 117, 64));
pageHeader.Components.Add(reportCreateDateText_pageHeader);
StiText reportCreatorLabelText_pageHeader = new StiText(new RectangleD(0, 0, 2, 0.6));
reportCreatorLabelText_pageHeader.Left = 3;
reportCreatorLabelText_pageHeader.Top = 0.6;
switch (BLanguage.CurrentLocalLanguage)
{
case LanguagesName.Unknown:
reportCreatorLabelText_pageHeader.Text = ": تهیه کننده";
break;
case LanguagesName.Parsi:
reportCreatorLabelText_pageHeader.Text = ": تهیه کننده";
break;
case LanguagesName.English:
reportCreatorLabelText_pageHeader.Text = "Creator :";
break;
default:
break;
}
reportCreatorLabelText_pageHeader.HorAlignment = StiTextHorAlignment.Center;
reportCreatorLabelText_pageHeader.VertAlignment = StiVertAlignment.Center;
reportCreatorLabelText_pageHeader.Name = "reportCreatorLabelText";
reportCreatorLabelText_pageHeader.Font = dataBandFont;
reportCreatorLabelText_pageHeader.TextBrush = new StiSolidBrush(Color.FromArgb(89, 89, 89));
pageHeader.Components.Add(reportCreatorLabelText_pageHeader);
StiText reportCreatorText_pageHeader = new StiText(new RectangleD(0, 0, 3, 0.6));
reportCreatorText_pageHeader.Left = 0;
reportCreatorText_pageHeader.Top = 0.6;
reportCreatorText_pageHeader.Text = ReportHelper.Instance().UserName;
reportCreatorText_pageHeader.HorAlignment = StiTextHorAlignment.Center;
reportCreatorText_pageHeader.VertAlignment = StiVertAlignment.Center;
reportCreatorText_pageHeader.Name = "reportCreatorText";
reportCreatorText_pageHeader.Font = dataBandFont;
reportCreatorText_pageHeader.TextBrush = new StiSolidBrush(Color.FromArgb(183, 117, 64));
pageHeader.Components.Add(reportCreatorText_pageHeader);
StiHeaderBand headerBand = new StiHeaderBand();
headerBand.Name = "HeaderBand";
headerBand.Width = page.Width;
headerBand.Border.Side = StiBorderSides.All;
headerBand.Border.Color = Color.DimGray;
page.Components.Add(headerBand);
StiDataBand dataBand = new StiDataBand();
dataBand.Name = "DataBand";
dataBand.Width = page.Width;
dataBand.Border.Side = StiBorderSides.All;
dataBand.Border.Color = Color.Gainsboro;
StiCondition conditionDataBand = new StiCondition("{Line%2==0}", Color.Black, Color.PeachPuff, dataBandFont, true);
dataBand.Conditions.Add(conditionDataBand);
page.Components.Add(dataBand);
DataTable dtReport = new DataTable();
string modelReportName = string.Empty;
switch (SRT)
{
case SystemReportType.SystemBusinessReport:
IList <GTS.Clock.Model.Report.SystemBusinessReport> SystemBusinessReportList = this.GetSystemBusinessReportList(SRT, SrtFilterConditions);
dtReport = Utility.ListToDataTable <GTS.Clock.Model.Report.SystemBusinessReport>(SystemBusinessReportList);
reportNameText_pageHeader.Text = "System Business Report";
modelReportName = dataBand.DataSourceName = typeof(GTS.Clock.Model.Report.SystemBusinessReport).Name;
dataBand.Height = dataBandHeight;
headerBand.Height = dataHeaderHeight;
break;
case SystemReportType.SystemEngineReport:
IList <GTS.Clock.Model.Report.SystemEngineReport> SystemEngineReportList = this.GetSystemEngineReportList(SRT, SrtFilterConditions);
dtReport = Utility.ListToDataTable <GTS.Clock.Model.Report.SystemEngineReport>(SystemEngineReportList);
reportNameText_pageHeader.Text = "System Engine Report";
modelReportName = dataBand.DataSourceName = typeof(GTS.Clock.Model.Report.SystemEngineReport).Name;
dataBand.Height = dataBandHeight;
headerBand.Height = dataHeaderHeight;
break;
case SystemReportType.SystemWindowsServiceReport:
IList <GTS.Clock.Model.Report.SystemWindowsServiceReport> SystemWindowsServiceReportList = this.GetSystemWindowsServiceReportList(SRT, SrtFilterConditions);
dtReport = Utility.ListToDataTable <GTS.Clock.Model.Report.SystemWindowsServiceReport>(SystemWindowsServiceReportList);
reportNameText_pageHeader.Text = "System Windows Service Report";
modelReportName = dataBand.DataSourceName = typeof(GTS.Clock.Model.Report.SystemWindowsServiceReport).Name;
dataBand.Height = dataBandHeight;
headerBand.Height = dataHeaderHeight;
break;
case SystemReportType.SystemUserActionReport:
IList <GTS.Clock.Model.Report.SystemUserActionReport> SystemUserActionReportList = this.GetSystemUserActionReportList(SRT, SrtFilterConditions);
dtReport = Utility.ListToDataTable <GTS.Clock.Model.Report.SystemUserActionReport>(SystemUserActionReportList);
reportNameText_pageHeader.Text = "System User Action Report";
modelReportName = dataBand.DataSourceName = typeof(GTS.Clock.Model.Report.SystemUserActionReport).Name;
dataBand.Height = dataBandHeight;
headerBand.Height = dataHeaderHeight;
break;
case SystemReportType.SystemEngineDebugReport:
IList <GTS.Clock.Model.Report.SystemEngineDebugReport> SystemEngineDebugReportList = this.GetSystemEngineDebugReportList(SRT, SrtFilterConditions);
dtReport = Utility.ListToDataTable <GTS.Clock.Model.Report.SystemEngineDebugReport>(SystemEngineDebugReportList);
reportNameText_pageHeader.Text = "System Engine Debug Report";
modelReportName = dataBand.DataSourceName = typeof(GTS.Clock.Model.Report.SystemEngineDebugReport).Name;
dataBand.Height = dataBandHeight;
headerBand.Height = dataHeaderHeight;
break;
case SystemReportType.SystemDataCollectorReport:
IList <GTS.Clock.Model.Report.SystemDataCollectorReport> SystemDataCollectorReportList = this.GetSystemDataCollectorReportList(SRT, SrtFilterConditions);
dtReport = Utility.ListToDataTable <GTS.Clock.Model.Report.SystemDataCollectorReport>(SystemDataCollectorReportList);
reportNameText_pageHeader.Text = "System Data Collector Report";
modelReportName = dataBand.DataSourceName = typeof(GTS.Clock.Model.Report.SystemDataCollectorReport).Name;
dataBand.Height = dataBandHeight;
headerBand.Height = dataHeaderHeight;
break;
}
columnWidth = (page.Width) / (dtReport.Columns.Count - 2);
stiReport.RegData(dtReport);
stiReport.Dictionary.Synchronize();
double pos = 0;
int nameIndex = 1;
for (int i = 0; i < dtReport.Columns.Count; i++)
{
StiText headerColumnText;
switch (dtReport.Columns[i].ColumnName.ToLower())
{
case "exception":
{
headerColumnText = new StiText(new RectangleD(columnWidth, 1, (page.Width - columnWidth), 1));
break;
}
case "message":
{
headerColumnText = new StiText(new RectangleD(columnWidth, 2, (page.Width - columnWidth), 1));
break;
}
case "id":
{
if (SRT == SystemReportType.SystemUserActionReport)
{
headerColumnText = new StiText(new RectangleD(pos, 0, columnWidth, 1));
}
else
{
headerColumnText = new StiText(new RectangleD(pos, 0, columnWidth, dataHeaderHeight));
}
break;
}
case "cnpname":
{
headerColumnText = new StiText(new RectangleD(columnWidth, 1, (page.Width - columnWidth), 1));
break;
}
default:
headerColumnText = new StiText(new RectangleD(pos, 0, columnWidth, 1));
headerColumnText.Width = columnWidth;
break;
}
headerColumnText.HorAlignment = StiTextHorAlignment.Center;
headerColumnText.VertAlignment = StiVertAlignment.Center;
headerColumnText.Name = "HeaderText" + nameIndex.ToString();
headerColumnText.Brush = new StiSolidBrush(Color.FromArgb(191, 191, 191));
headerColumnText.Border.Side = StiBorderSides.All;
headerColumnText.Font = headerBandFont;
headerColumnText.Text.Value = dtReport.Columns[i].Caption;
headerBand.Components.Add(headerColumnText);
StiText dataText;
switch (dtReport.Columns[i].ColumnName.ToLower())
{
case "exception":
{
dataText = new StiText(new RectangleD(columnWidth, dataBandRowHeight, (page.Width - columnWidth), 1.5));
pos = pos - columnWidth;
break;
}
case "message":
{
dataText = new StiText(new RectangleD(columnWidth, dataBandRowHeight + 1.5, (page.Width - columnWidth), 1.5));
pos = pos - columnWidth;
break;
}
case "id":
{
if (SRT == SystemReportType.SystemUserActionReport)
{
dataText = new StiText(new RectangleD(pos, 0, columnWidth, 1));
}
else
{
dataText = new StiText(new RectangleD(pos, 0, columnWidth, dataBandHeight));
}
break;
}
case "cnpname":
{
dataText = new StiText(new RectangleD(columnWidth, dataBandRowHeight, (page.Width - columnWidth), 1.5));
pos = pos - columnWidth;
break;
}
default:
dataText = new StiText(new RectangleD(pos, 0, columnWidth, dataBandRowHeight));
break;
}
dataText.Type = StiSystemTextType.DataColumn;
dataText.Text = "{Trim(" + modelReportName + "." + Stimulsoft.Report.CodeDom.StiCodeDomSerializator.ReplaceSymbols(dtReport.Columns[i].ColumnName) + ")}";
dataText.HorAlignment = StiTextHorAlignment.Center;
dataText.VertAlignment = StiVertAlignment.Center;
dataText.Name = "DataText" + nameIndex.ToString();
dataText.Border.Side = StiBorderSides.All;
dataText.Font = dataBandFont;
dataText.WordWrap = true;
dataBand.Components.Add(dataText);
pos = pos + columnWidth;
nameIndex++;
}
stiReport.Compile();
return(stiReport);
}
catch (Exception)
{
throw;
}
}
