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();
}
}
private static void AddLineNo(ref StiText hText, ref StiText dataText, ref StiHeaderBand headerBand, ref StiDataBand dataBand)
{
double pos = 0;
int nameIndex = 1;
#region line
//Create text on header
hText = new StiText(new RectangleD(pos, 0, 1, 0.5));
hText.Text.Value = "ردیف";
hText.HorAlignment = StiTextHorAlignment.Center;
hText.VertAlignment = StiVertAlignment.Center;
hText.Font = new System.Drawing.Font("Tahoma", 10);
hText.Brush = new StiSolidBrush(Color.LightBlue);
hText.Name = "LineText" + nameIndex.ToString();
hText.WordWrap = true;
hText.CanGrow = true;
hText.GrowToHeight = true;
hText.Border.Side = StiBorderSides.All;
headerBand.Components.Add(hText);
dataText = new StiText(new RectangleD(pos, 0, 1, 0.5));
dataText.HorAlignment = StiTextHorAlignment.Center;
dataText.VertAlignment = StiVertAlignment.Center;
dataText.Font = new System.Drawing.Font("Tahoma", 10);
dataText.Text = "{Line}";
dataText.WordWrap = true;
dataText.CanGrow = true;
dataText.GrowToHeight = true;
dataText.Border.Side = StiBorderSides.All;
dataText.Interaction.SortingEnabled = true;
dataBand.Components.Add(dataText);
#endregion line
}
private void ReadPageHeaderBand(XtraReportBase xtraReport, PageHeaderBand xtraBand, StiPage page)
{
StiHeaderBand band = new StiHeaderBand();
band.PrintOnAllPages = true;
page.Components.Add(band);
ReadBand(xtraBand, band);
}
private void ReadDataHeaderBand(XmlNode node, StiPage page, StiBand masterBand)
{
StiHeaderBand band = new StiHeaderBand();
if (masterBand != null)
{
page.Components.Insert(page.Components.IndexOf(masterBand), band);
}
else
{
page.Components.Add(band);
}
ReadBand(node, band);
band.KeepHeaderTogether = ReadBool(node, "KeepWithData", band, false);
}
private void ReadReportHeaderBand(XtraReportBase xtraReport, ReportHeaderBand xtraBand, StiPage page)
{
StiBand band = null;
if (detailLevel == 0)
{
band = new StiReportTitleBand();
}
else
{
band = new StiHeaderBand();
(band as StiHeaderBand).PrintOnAllPages = false;
}
page.Components.Add(band);
ReadBand(xtraBand, band);
}
public IReportBuilder WithHeaderBand(List <string> titles, double[] sizes, double height = 0.3)
{
CurrentHeader = new StiHeaderBand(MakeRectangle(0, 0, 0, height));
Page.Components.Add(CurrentHeader);
CurrentHeader.BeforePrintEvent = new StiBeforePrintEvent("Xdec=Xdec+1;");
CurrentHeader.AfterPrintEvent = new StiAfterPrintEvent("Xdec=Xdec+1;");
var x = 0.0;
for (var i = 0; i < titles.Count; i++)
{
var stiText = _textBuilder.New(titles[i]).WithPosition(x).WithSize(sizes[i], height)
.WithAlign(StiTextHorAlignment.Center).WithFont(FontStyle.Bold).Then();
x += sizes[i];
CurrentHeader.Components.Add(stiText);
}
return(this);
}
private void CreateReport(DataTable table, DataGridView dgv, string title, string subtitle)
{
StiReport report = new StiReport();
StiDataTableSource sourceTable = new StiDataTableSource("DS", "DS", "DS");
report.Dictionary.DataSources.Add(sourceTable);
report.RegData("DS", "DS", table);
sourceTable.SynchronizeColumns();
StiPage page = report.Pages.Items[0];
page.Orientation = StiPageOrientation.Landscape;
double pageW = page.Width;
double pageH = page.Height;
//============заголовок
StiText headerReport = new StiText(new RectangleD(new PointD(0, 0), new SizeD(pageW, 0.6)),
"Заголовок1");
headerReport.Font = new Font("Arial", 10, FontStyle.Bold);
headerReport.HorAlignment = StiTextHorAlignment.Center;
headerReport.Text = "История обработок";
StiText subtitleReport = new StiText(new RectangleD(new PointD(0, 0.6), new SizeD(pageW, 0.4)),
"Подзаголовок1");
subtitleReport.Font = new Font("Arial", 10, FontStyle.Regular);
subtitleReport.HorAlignment = StiTextHorAlignment.Center;
subtitleReport.Text = subtitle;
PointD BrandLoc = new PointD(0, 0.4);
//хедер рапорта
StiReportTitleBand headerPage = new StiReportTitleBand(new RectangleD(BrandLoc, new SizeD(pageW, 1.2)));
page.Components.Add(headerPage);
headerPage.Components.Add(headerReport);
headerPage.Components.Add(subtitleReport);
//хедер таблицы
BrandLoc = new PointD(0, 1.2);
StiHeaderBand headerTable = new StiHeaderBand(new RectangleD(BrandLoc, new SizeD(pageW, 0.6)));
page.Components.Add(headerTable);
//область данных
PointD BrandDataLoc = new PointD(0, 1.8);
StiDataBand BrandData = new StiDataBand(new RectangleD(BrandDataLoc, new SizeD(pageW, 0.4)));
page.Components.Add(BrandData);
BrandData.DataSourceName = "DS";
StiPageFooterBand FooterBand = new StiPageFooterBand();
page.Components.Add(FooterBand);
FooterBand.Height = 0.6;
StiText FooterNameTxt = new StiText(new RectangleD(0, 0, pageW, 0.6));
FooterNameTxt.Text = title;
FooterNameTxt.ShrinkFontToFit = true;
FooterNameTxt.HorAlignment = StiTextHorAlignment.Right;
FooterNameTxt.ShrinkFontToFitMinimumSize = 8;
StiText FooterTxt = new StiText(new RectangleD(0, 0, 1, 0.6));
FooterTxt.Text = "Лист {PageNumber}";
FooterTxt.ShrinkFontToFit = true;
FooterTxt.ShrinkFontToFitMinimumSize = 8;
FooterBand.Components.Add(FooterNameTxt);
FooterBand.Components.Add(FooterTxt);
StiText TimeText = new StiText(new RectangleD(-0.2, -0.4, 3, 0.6));
TimeText.Text = "{Time}";
TimeText.ShrinkFontToFit = true;
TimeText.ShrinkFontToFitMinimumSize = 8;
page.Components.Add(TimeText);
double numWidth = .5;
double Wkoef = pageW / GetColumnWidth(table, dgv);
double prevX = 0; //numWidth;
//StiText headerNum = new StiText(new RectangleD(BrandLoc.X, 0, numWidth, 0.4));
//headerNum.Border.Side = StiBorderSides.All;
//headerNum.Border.Size = 1.5;
//headerNum.Text = "N п/п";
//headerNum.Font = new Font("Arial", 8, FontStyle.Bold);
//headerNum.HorAlignment = StiTextHorAlignment.Center;
//headerNum.ShrinkFontToFit = true;
//headerNum.ShrinkFontToFitMinimumSize = 8;
//headerTable.Components.Add(headerNum);
//StiText dataNum = new StiText(new RectangleD(BrandLoc.X, 0, numWidth, 0.4));
//dataNum.Border.Side = StiBorderSides.All;
//dataNum.ShrinkFontToFit = true;
//dataNum.ShrinkFontToFitMinimumSize = 8;
//dataNum.Text = "{Line}";
//dataNum.HorAlignment = StiTextHorAlignment.Right;
//dataNum.Font = new Font("Arial", 8, FontStyle.Regular);
//BrandData.Components.Add(dataNum);
foreach (DataColumn column in table.Columns) //добалвляем в область заголовка и в область данных
{
string colName = column.ColumnName;
DataGridViewColumn dgvColumn = dgv.Columns[colName];
StiText headerTXT = new StiText(new RectangleD(BrandLoc.X + prevX, 0,
dgvColumn.Width * Wkoef, 0.4));
headerTXT.Border.Side = StiBorderSides.All;
headerTXT.Border.Size = 1.5;
headerTXT.Text = dgvColumn.HeaderText;
headerTXT.Font = new Font("Arial", 8, FontStyle.Bold);
headerTXT.HorAlignment = StiTextHorAlignment.Center;
headerTXT.ShrinkFontToFit = true;
headerTXT.ShrinkFontToFitMinimumSize = 8;
headerTable.Components.Add(headerTXT);
StiText dataTXT = new StiText(new RectangleD(BrandLoc.X + prevX, 0,
dgvColumn.Width * Wkoef, 0.4));
dataTXT.Border.Side = StiBorderSides.All;
dataTXT.ShrinkFontToFit = true;
dataTXT.ShrinkFontToFitMinimumSize = 8;
dataTXT.Font = new Font("Arial", 8, FontStyle.Regular);
if (column.DataType == typeof(bool))
{
dataTXT.Text = "{IIF(DS." + colName + ", \"+\", \"\")}";
}
else
{
dataTXT.Text = "{DS." + colName + "}";
}
if (column.DataType == typeof(DateTime))
{
string dateFormat = "dd.MM.yyyy HH:mm";
dataTXT.TextFormat = new StiDateFormatService(dateFormat, "");
}
if (column.DataType == typeof(double))
{
dataTXT.TextFormat = new StiNumberFormatService(1, ".", 1, ",", 3, true, true, " ");
}
switch (dgvColumn.DefaultCellStyle.Alignment)
{
case DataGridViewContentAlignment.BottomCenter:
case DataGridViewContentAlignment.MiddleCenter:
case DataGridViewContentAlignment.TopCenter:
dataTXT.HorAlignment = StiTextHorAlignment.Center;
break;
case DataGridViewContentAlignment.BottomLeft:
case DataGridViewContentAlignment.MiddleLeft:
case DataGridViewContentAlignment.TopLeft:
dataTXT.HorAlignment = StiTextHorAlignment.Left;
break;
case DataGridViewContentAlignment.BottomRight:
case DataGridViewContentAlignment.MiddleRight:
case DataGridViewContentAlignment.TopRight:
dataTXT.HorAlignment = StiTextHorAlignment.Right;
break;
}
BrandData.Components.Add(dataTXT);
prevX += dgvColumn.Width * Wkoef;
}
report.Show();
}
public static Exception ExportToExcel(ref DataTable dt, string OutputPath, bool HasPageHeader = true, bool HasHeaderBand = true,
bool HasFooter = true, bool HasLineNo = false)
{
try
{
DateTime ExportTimeStart = DateTime.Now;
StiReport report = new StiReport();
StiPage page = report.Pages[0];
page.PaperSize = System.Drawing.Printing.PaperKind.Custom;
page.PageWidth = dt.Columns.Count * 1.2;
StiHeaderBand headerBand = new StiHeaderBand();
StiText headerText = new StiText(new RectangleD(0, 0, page.Width, 0.5));
page.RightToLeft = true;
dt.TableName = "Result";
if (HasPageHeader)
{
AddPageHeader(ref page, ref headerText);
}
if (HasFooter)
{
AddFooter(ref page);
}
HasHeaderBand = false;
if (HasHeaderBand)
{
AddHasHeaderBand(ref headerText, ref page, ref headerBand);
}
#region Data
//Create Databand
StiDataBand dataBand = new StiDataBand();
dataBand.DataSourceName = "Result";
dataBand.Height = 0.5;
dataBand.CanGrow = true;
dataBand.GrowToHeight = true;
headerText.HorAlignment = StiTextHorAlignment.Right;
dataBand.Name = "DataBand1";
page.Components.Add(dataBand);
#endregion data
double pos = 0;
double columnWidth = (page.Width - 1) / dt.Columns.Count;
int nameIndex = 1;
// StiDataTableSource userSource = new StiDataTableSource("Result", "Result", "Result");
StiText hText = new StiText();
StiText dataText = new StiText();
#region FillHeaderAndDate
foreach (DataColumn dataColumn in dt.Columns)
{
//userSource.Columns.Add(new Stimulsoft.Report.Dictionary.StiDataColumn(dataColumn.ColumnName, dataColumn.GetType()));
//Create text on header
// StiText
hText = new StiText(new RectangleD(pos, 0, columnWidth, 0.5));
hText.HorAlignment = StiTextHorAlignment.Center;
hText.VertAlignment = StiVertAlignment.Center;
hText.Font = new System.Drawing.Font("Tahoma", 10);
hText.Brush = new StiSolidBrush(Color.LightSteelBlue);
hText.Interaction.SortingEnabled = true;
hText.Interaction.SortingColumn = "DataBand." + Stimulsoft.Report.CodeDom.StiCodeDomSerializator.ReplaceSymbols(dataColumn.ColumnName);
hText.Text.Value = dataColumn.Caption;
hText.Name = "HeaderText" + nameIndex.ToString();
hText.WordWrap = true;
hText.CanGrow = true;
hText.GrowToHeight = true;
hText.Border.Side = StiBorderSides.All;
headerBand.Components.Add(hText);
//StiText
dataText = new StiText(new RectangleD(pos, 0, columnWidth, 0.5));
dataText.HorAlignment = StiTextHorAlignment.Center;
dataText.VertAlignment = StiVertAlignment.Center;
dataText.Font = new System.Drawing.Font("Tahoma", 10);
dataText.Text = "{Result." + Stimulsoft.Report.CodeDom.StiCodeDomSerializator.ReplaceSymbols(dataColumn.ColumnName) + "}";
dataText.Name = "DataText" + nameIndex.ToString();
dataText.WordWrap = true;
dataText.CanGrow = true;
dataText.GrowToHeight = true;
dataText.ShrinkFontToFit = true;
dataText.Border.Side = StiBorderSides.All;
dataText.Interaction.SortingEnabled = true;
dataBand.Components.Add(dataText);
pos = pos + columnWidth;
nameIndex++;
}
#endregion
if (HasLineNo)
{
AddLineNo(ref hText, ref dataText, ref headerBand, ref dataBand);
}
string rptPath = System.IO.Path.GetTempFileName();
report.RegData("Result", dt);
//report.Save(rptPath);
//report.Load(rptPath);
//report.RegData("Result", dt);
report.Design();
//userSource.SetData()
//userSource.Dictionary =
//report.CacheAllData = true;
report.Render(true);
StiExcel2007ExportService excelExport = new StiExcel2007ExportService();
//StiExcelExportService excelExport = new StiExcelExportService();
excelExport.ExportExcel(report, OutputPath);
DateTime ExportTimeEnd = DateTime.Now;
ExportTime = (ExportTimeEnd - ExportTimeStart);
return(null);
}
catch (Exception ex)
{
return(ex);
}
}
private static void AddHasHeaderBand(ref StiText headerText, ref StiPage page, ref StiHeaderBand headerBand)
{
//Create HeaderBand
headerBand.Height = 0.5;
headerBand.CanGrow = true;
headerBand.CanShrink = true;
headerText.HorAlignment = StiTextHorAlignment.Right;
headerBand.Name = "HeaderBand";
page.Components.Add(headerBand);
}
private void InitializeComponent()
{
SP_GetRequestHeader = new SP_GetRequestHeaderDataSource();
SP_GetRequestDetail = new SP_GetRequestDetailDataSource();
ParentSP_GetRequestHeader = new StiDataRelation("SP_GetRequestHeader_SP_GetRequestDetail", "SP_GetRequestHeader", "SP_GetRequestHeader", SP_GetRequestHeader, SP_GetRequestDetail, new[] {
"RequestID"
}, new[] {
"RequestID"
});
NeedsCompiling = false;
EngineVersion = StiEngineVersion.EngineV2;
ReferencedAssemblies = new[] {
"System.Dll",
"System.Drawing.Dll",
"System.Windows.Forms.Dll",
"System.Data.Dll",
"System.Xml.Dll",
"Stimulsoft.Controls.Dll",
"Stimulsoft.Base.Dll",
"Stimulsoft.Report.Dll"
};
ReportAlias = "RptRequestDetail";
ReportAuthor = "Programmer.GE";
//
// ReportChanged
//
ReportChanged = new DateTime(2010, 4, 30, 19, 58, 27, 845);
//
// ReportCreated
//
ReportCreated = new DateTime(2010, 3, 4, 16, 2, 4, 0);
ReportDescription = "პროდუქციის შეკვეთა";
ReportFile = "D:\\User\\Documents\\Projects\\Apothex\\Source\\Class Library\\Apothex.Reporting\\Product" +
"ion\\RptRequestDetail.mrt";
ReportGuid = "39889ce012f240ecbc7962a86ff663a7";
ReportName = "RptRequestDetail";
ReportUnit = StiReportUnitType.Centimeters;
ScriptLanguage = StiReportLanguageType.CSharp;
//
// Page1
//
Page1 = new StiPage();
Page1.Guid = "5d26ae79894e4dcebbc2212ba7686670";
Page1.Name = "Page1";
Page1.PageHeight = 29.7;
Page1.PageWidth = 21;
Page1.PaperSize = PaperKind.A4;
Page1.Border = new StiBorder(StiBorderSides.None, Color.Black, 2, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Page1.Brush = new StiSolidBrush(Color.Transparent);
//
// DataSP_GetRequestHeader
//
DataSP_GetRequestHeader = new StiDataBand();
DataSP_GetRequestHeader.ClientRectangle = new RectangleD(0, 0.4, 19, 0.6);
DataSP_GetRequestHeader.DataSourceName = "SP_GetRequestHeader";
DataSP_GetRequestHeader.Name = "DataSP_GetRequestHeader";
DataSP_GetRequestHeader.Sort = new String[0];
DataSP_GetRequestHeader.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataSP_GetRequestHeader.Brush = new StiSolidBrush(Color.Transparent);
DataSP_GetRequestHeader.BusinessObjectGuid = null;
//
// Text2
//
Text2 = new StiText();
Text2.ClientRectangle = new RectangleD(0, 0, 19, 0.6);
Text2.HorAlignment = StiTextHorAlignment.Center;
Text2.Name = "Text2";
Text2.GetValue += new StiGetValueEventHandler(Text2__GetValue);
Text2.VertAlignment = StiVertAlignment.Center;
Text2.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text2.Brush = new StiSolidBrush(Color.Transparent);
Text2.Font = new Font("BPG Glaho Arial", 10F);
Text2.Guid = null;
Text2.Interaction = null;
Text2.Margins = new StiMargins(0, 0, 0, 0);
Text2.TextBrush = new StiSolidBrush(Color.Black);
Text2.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
DataSP_GetRequestHeader.Guid = null;
DataSP_GetRequestHeader.Interaction = null;
DataSP_GetRequestHeader.MasterComponent = null;
//
// HeaderSP_GetRequestDetail
//
HeaderSP_GetRequestDetail = new StiHeaderBand();
HeaderSP_GetRequestDetail.ClientRectangle = new RectangleD(0, 1.8, 19, 0.6);
HeaderSP_GetRequestDetail.Name = "HeaderSP_GetRequestDetail";
HeaderSP_GetRequestDetail.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderSP_GetRequestDetail.Brush = new StiSolidBrush(Color.Transparent);
//
// HeaderSP_GetRequestDetail_OrdinalNumber
//
HeaderSP_GetRequestDetail_OrdinalNumber = new StiText();
HeaderSP_GetRequestDetail_OrdinalNumber.ClientRectangle = new RectangleD(0, 0, 0.8, 0.6);
HeaderSP_GetRequestDetail_OrdinalNumber.HorAlignment = StiTextHorAlignment.Center;
HeaderSP_GetRequestDetail_OrdinalNumber.Name = "HeaderSP_GetRequestDetail_OrdinalNumber";
HeaderSP_GetRequestDetail_OrdinalNumber.GetValue += new StiGetValueEventHandler(HeaderSP_GetRequestDetail_OrdinalNumber__GetValue);
HeaderSP_GetRequestDetail_OrdinalNumber.VertAlignment = StiVertAlignment.Center;
HeaderSP_GetRequestDetail_OrdinalNumber.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderSP_GetRequestDetail_OrdinalNumber.Brush = new StiSolidBrush(Color.Transparent);
HeaderSP_GetRequestDetail_OrdinalNumber.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
HeaderSP_GetRequestDetail_OrdinalNumber.Guid = null;
HeaderSP_GetRequestDetail_OrdinalNumber.Interaction = null;
HeaderSP_GetRequestDetail_OrdinalNumber.Margins = new StiMargins(0, 0, 0, 0);
HeaderSP_GetRequestDetail_OrdinalNumber.TextBrush = new StiSolidBrush(Color.Black);
HeaderSP_GetRequestDetail_OrdinalNumber.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// HeaderSP_GetRequestDetail_MedicamentName
//
HeaderSP_GetRequestDetail_MedicamentName = new StiText();
HeaderSP_GetRequestDetail_MedicamentName.ClientRectangle = new RectangleD(0.8, 0, 6, 0.6);
HeaderSP_GetRequestDetail_MedicamentName.HorAlignment = StiTextHorAlignment.Center;
HeaderSP_GetRequestDetail_MedicamentName.Name = "HeaderSP_GetRequestDetail_MedicamentName";
HeaderSP_GetRequestDetail_MedicamentName.GetValue += new StiGetValueEventHandler(HeaderSP_GetRequestDetail_MedicamentName__GetValue);
HeaderSP_GetRequestDetail_MedicamentName.VertAlignment = StiVertAlignment.Center;
HeaderSP_GetRequestDetail_MedicamentName.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderSP_GetRequestDetail_MedicamentName.Brush = new StiSolidBrush(Color.Transparent);
HeaderSP_GetRequestDetail_MedicamentName.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
HeaderSP_GetRequestDetail_MedicamentName.Guid = null;
HeaderSP_GetRequestDetail_MedicamentName.Interaction = null;
HeaderSP_GetRequestDetail_MedicamentName.Margins = new StiMargins(0, 0, 0, 0);
HeaderSP_GetRequestDetail_MedicamentName.TextBrush = new StiSolidBrush(Color.Black);
HeaderSP_GetRequestDetail_MedicamentName.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// HeaderSP_GetRequestDetail_RequestQty
//
HeaderSP_GetRequestDetail_RequestQty = new StiText();
HeaderSP_GetRequestDetail_RequestQty.ClientRectangle = new RectangleD(6.8, 0, 1.4, 0.6);
HeaderSP_GetRequestDetail_RequestQty.HorAlignment = StiTextHorAlignment.Center;
HeaderSP_GetRequestDetail_RequestQty.Name = "HeaderSP_GetRequestDetail_RequestQty";
HeaderSP_GetRequestDetail_RequestQty.GetValue += new StiGetValueEventHandler(HeaderSP_GetRequestDetail_RequestQty__GetValue);
HeaderSP_GetRequestDetail_RequestQty.VertAlignment = StiVertAlignment.Center;
HeaderSP_GetRequestDetail_RequestQty.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderSP_GetRequestDetail_RequestQty.Brush = new StiSolidBrush(Color.Transparent);
HeaderSP_GetRequestDetail_RequestQty.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
HeaderSP_GetRequestDetail_RequestQty.Guid = null;
HeaderSP_GetRequestDetail_RequestQty.Interaction = null;
HeaderSP_GetRequestDetail_RequestQty.Margins = new StiMargins(0, 0, 0, 0);
HeaderSP_GetRequestDetail_RequestQty.TextBrush = new StiSolidBrush(Color.Black);
HeaderSP_GetRequestDetail_RequestQty.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// HeaderSP_GetRequestDetail_CountryName1
//
HeaderSP_GetRequestDetail_CountryName1 = new StiText();
HeaderSP_GetRequestDetail_CountryName1.ClientRectangle = new RectangleD(8.2, 0, 2.8, 0.6);
HeaderSP_GetRequestDetail_CountryName1.HorAlignment = StiTextHorAlignment.Center;
HeaderSP_GetRequestDetail_CountryName1.Name = "HeaderSP_GetRequestDetail_CountryName1";
HeaderSP_GetRequestDetail_CountryName1.GetValue += new StiGetValueEventHandler(HeaderSP_GetRequestDetail_CountryName1__GetValue);
HeaderSP_GetRequestDetail_CountryName1.VertAlignment = StiVertAlignment.Center;
HeaderSP_GetRequestDetail_CountryName1.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderSP_GetRequestDetail_CountryName1.Brush = new StiSolidBrush(Color.Transparent);
HeaderSP_GetRequestDetail_CountryName1.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
HeaderSP_GetRequestDetail_CountryName1.Guid = null;
HeaderSP_GetRequestDetail_CountryName1.Interaction = null;
HeaderSP_GetRequestDetail_CountryName1.Margins = new StiMargins(0, 0, 0, 0);
HeaderSP_GetRequestDetail_CountryName1.TextBrush = new StiSolidBrush(Color.Black);
HeaderSP_GetRequestDetail_CountryName1.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// HeaderSP_GetRequestDetail_CountryName2
//
HeaderSP_GetRequestDetail_CountryName2 = new StiText();
HeaderSP_GetRequestDetail_CountryName2.ClientRectangle = new RectangleD(11, 0, 2.8, 0.6);
HeaderSP_GetRequestDetail_CountryName2.HorAlignment = StiTextHorAlignment.Center;
HeaderSP_GetRequestDetail_CountryName2.Name = "HeaderSP_GetRequestDetail_CountryName2";
HeaderSP_GetRequestDetail_CountryName2.GetValue += new StiGetValueEventHandler(HeaderSP_GetRequestDetail_CountryName2__GetValue);
HeaderSP_GetRequestDetail_CountryName2.VertAlignment = StiVertAlignment.Center;
HeaderSP_GetRequestDetail_CountryName2.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderSP_GetRequestDetail_CountryName2.Brush = new StiSolidBrush(Color.Transparent);
HeaderSP_GetRequestDetail_CountryName2.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
HeaderSP_GetRequestDetail_CountryName2.Guid = null;
HeaderSP_GetRequestDetail_CountryName2.Interaction = null;
HeaderSP_GetRequestDetail_CountryName2.Margins = new StiMargins(0, 0, 0, 0);
HeaderSP_GetRequestDetail_CountryName2.TextBrush = new StiSolidBrush(Color.Black);
HeaderSP_GetRequestDetail_CountryName2.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// HeaderSP_GetRequestDetail_BrandName1
//
HeaderSP_GetRequestDetail_BrandName1 = new StiText();
HeaderSP_GetRequestDetail_BrandName1.ClientRectangle = new RectangleD(13.8, 0, 2.6, 0.6);
HeaderSP_GetRequestDetail_BrandName1.HorAlignment = StiTextHorAlignment.Center;
HeaderSP_GetRequestDetail_BrandName1.Name = "HeaderSP_GetRequestDetail_BrandName1";
HeaderSP_GetRequestDetail_BrandName1.GetValue += new StiGetValueEventHandler(HeaderSP_GetRequestDetail_BrandName1__GetValue);
HeaderSP_GetRequestDetail_BrandName1.VertAlignment = StiVertAlignment.Center;
HeaderSP_GetRequestDetail_BrandName1.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderSP_GetRequestDetail_BrandName1.Brush = new StiSolidBrush(Color.Transparent);
HeaderSP_GetRequestDetail_BrandName1.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
HeaderSP_GetRequestDetail_BrandName1.Guid = null;
HeaderSP_GetRequestDetail_BrandName1.Interaction = null;
HeaderSP_GetRequestDetail_BrandName1.Margins = new StiMargins(0, 0, 0, 0);
HeaderSP_GetRequestDetail_BrandName1.TextBrush = new StiSolidBrush(Color.Black);
HeaderSP_GetRequestDetail_BrandName1.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// HeaderSP_GetRequestDetail_BrandName2
//
HeaderSP_GetRequestDetail_BrandName2 = new StiText();
HeaderSP_GetRequestDetail_BrandName2.ClientRectangle = new RectangleD(16.4, 0, 2.6, 0.6);
HeaderSP_GetRequestDetail_BrandName2.HorAlignment = StiTextHorAlignment.Center;
HeaderSP_GetRequestDetail_BrandName2.Name = "HeaderSP_GetRequestDetail_BrandName2";
HeaderSP_GetRequestDetail_BrandName2.GetValue += new StiGetValueEventHandler(HeaderSP_GetRequestDetail_BrandName2__GetValue);
HeaderSP_GetRequestDetail_BrandName2.VertAlignment = StiVertAlignment.Center;
HeaderSP_GetRequestDetail_BrandName2.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderSP_GetRequestDetail_BrandName2.Brush = new StiSolidBrush(Color.Transparent);
HeaderSP_GetRequestDetail_BrandName2.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
HeaderSP_GetRequestDetail_BrandName2.Guid = null;
HeaderSP_GetRequestDetail_BrandName2.Interaction = null;
HeaderSP_GetRequestDetail_BrandName2.Margins = new StiMargins(0, 0, 0, 0);
HeaderSP_GetRequestDetail_BrandName2.TextBrush = new StiSolidBrush(Color.Black);
HeaderSP_GetRequestDetail_BrandName2.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
HeaderSP_GetRequestDetail.Guid = null;
HeaderSP_GetRequestDetail.Interaction = null;
//
// DataSP_GetRequestDetail
//
DataSP_GetRequestDetail = new StiDataBand();
DataSP_GetRequestDetail.ClientRectangle = new RectangleD(0, 3.2, 19, 0.6);
DataSP_GetRequestDetail.DataRelationName = "SP_GetRequestHeader_SP_GetRequestDetail";
DataSP_GetRequestDetail.DataSourceName = "SP_GetRequestDetail";
DataSP_GetRequestDetail.Name = "DataSP_GetRequestDetail";
DataSP_GetRequestDetail.Sort = new[] {
"ASC",
"OrdinalNumber"
};
DataSP_GetRequestDetail.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataSP_GetRequestDetail.Brush = new StiSolidBrush(Color.Transparent);
DataSP_GetRequestDetail.BusinessObjectGuid = null;
//
// DataSP_GetRequestDetail_MedicamentName
//
DataSP_GetRequestDetail_MedicamentName = new StiText();
DataSP_GetRequestDetail_MedicamentName.CanGrow = true;
DataSP_GetRequestDetail_MedicamentName.ClientRectangle = new RectangleD(0.8, 0, 6, 0.6);
DataSP_GetRequestDetail_MedicamentName.GrowToHeight = true;
DataSP_GetRequestDetail_MedicamentName.Name = "DataSP_GetRequestDetail_MedicamentName";
DataSP_GetRequestDetail_MedicamentName.GetValue += new StiGetValueEventHandler(DataSP_GetRequestDetail_MedicamentName__GetValue);
DataSP_GetRequestDetail_MedicamentName.VertAlignment = StiVertAlignment.Center;
DataSP_GetRequestDetail_MedicamentName.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataSP_GetRequestDetail_MedicamentName.Brush = new StiSolidBrush(Color.Transparent);
DataSP_GetRequestDetail_MedicamentName.Font = new Font("BPG Glaho Arial", 8F);
DataSP_GetRequestDetail_MedicamentName.Guid = null;
DataSP_GetRequestDetail_MedicamentName.Interaction = null;
DataSP_GetRequestDetail_MedicamentName.Margins = new StiMargins(0, 0, 0, 0);
DataSP_GetRequestDetail_MedicamentName.TextBrush = new StiSolidBrush(Color.Black);
DataSP_GetRequestDetail_MedicamentName.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// DataSP_GetRequestDetail_OrdinalNumber
//
DataSP_GetRequestDetail_OrdinalNumber = new StiText();
DataSP_GetRequestDetail_OrdinalNumber.CanGrow = true;
DataSP_GetRequestDetail_OrdinalNumber.ClientRectangle = new RectangleD(0, 0, 0.8, 0.6);
DataSP_GetRequestDetail_OrdinalNumber.GrowToHeight = true;
DataSP_GetRequestDetail_OrdinalNumber.Name = "DataSP_GetRequestDetail_OrdinalNumber";
DataSP_GetRequestDetail_OrdinalNumber.GetValue += new StiGetValueEventHandler(DataSP_GetRequestDetail_OrdinalNumber__GetValue);
DataSP_GetRequestDetail_OrdinalNumber.VertAlignment = StiVertAlignment.Center;
DataSP_GetRequestDetail_OrdinalNumber.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataSP_GetRequestDetail_OrdinalNumber.Brush = new StiSolidBrush(Color.Transparent);
DataSP_GetRequestDetail_OrdinalNumber.Font = new Font("BPG Glaho Arial", 8F);
DataSP_GetRequestDetail_OrdinalNumber.Guid = null;
DataSP_GetRequestDetail_OrdinalNumber.Interaction = null;
DataSP_GetRequestDetail_OrdinalNumber.Margins = new StiMargins(0, 0, 0, 0);
DataSP_GetRequestDetail_OrdinalNumber.TextBrush = new StiSolidBrush(Color.Black);
DataSP_GetRequestDetail_OrdinalNumber.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// DataSP_GetRequestDetail_RequestQty
//
DataSP_GetRequestDetail_RequestQty = new StiText();
DataSP_GetRequestDetail_RequestQty.CanGrow = true;
DataSP_GetRequestDetail_RequestQty.ClientRectangle = new RectangleD(6.8, 0, 1.4, 0.6);
DataSP_GetRequestDetail_RequestQty.GrowToHeight = true;
DataSP_GetRequestDetail_RequestQty.HorAlignment = StiTextHorAlignment.Right;
DataSP_GetRequestDetail_RequestQty.Name = "DataSP_GetRequestDetail_RequestQty";
DataSP_GetRequestDetail_RequestQty.GetValue += new StiGetValueEventHandler(DataSP_GetRequestDetail_RequestQty__GetValue);
DataSP_GetRequestDetail_RequestQty.VertAlignment = StiVertAlignment.Center;
DataSP_GetRequestDetail_RequestQty.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataSP_GetRequestDetail_RequestQty.Brush = new StiSolidBrush(Color.Transparent);
DataSP_GetRequestDetail_RequestQty.Font = new Font("BPG Glaho Arial", 8F);
DataSP_GetRequestDetail_RequestQty.Guid = null;
DataSP_GetRequestDetail_RequestQty.Interaction = null;
DataSP_GetRequestDetail_RequestQty.Margins = new StiMargins(0, 0, 0, 0);
DataSP_GetRequestDetail_RequestQty.TextBrush = new StiSolidBrush(Color.Black);
DataSP_GetRequestDetail_RequestQty.TextFormat = new StiNumberFormatService(1, ",", 4, " ", 3, true, false, " ");
DataSP_GetRequestDetail_RequestQty.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// DataSP_GetRequestDetail_CountryName1
//
DataSP_GetRequestDetail_CountryName1 = new StiText();
DataSP_GetRequestDetail_CountryName1.CanGrow = true;
DataSP_GetRequestDetail_CountryName1.ClientRectangle = new RectangleD(8.2, 0, 2.8, 0.6);
DataSP_GetRequestDetail_CountryName1.GrowToHeight = true;
DataSP_GetRequestDetail_CountryName1.Name = "DataSP_GetRequestDetail_CountryName1";
DataSP_GetRequestDetail_CountryName1.GetValue += new StiGetValueEventHandler(DataSP_GetRequestDetail_CountryName1__GetValue);
DataSP_GetRequestDetail_CountryName1.VertAlignment = StiVertAlignment.Center;
DataSP_GetRequestDetail_CountryName1.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataSP_GetRequestDetail_CountryName1.Brush = new StiSolidBrush(Color.Transparent);
DataSP_GetRequestDetail_CountryName1.Font = new Font("BPG Glaho Arial", 8F);
DataSP_GetRequestDetail_CountryName1.Guid = null;
DataSP_GetRequestDetail_CountryName1.Interaction = null;
DataSP_GetRequestDetail_CountryName1.Margins = new StiMargins(0, 0, 0, 0);
DataSP_GetRequestDetail_CountryName1.TextBrush = new StiSolidBrush(Color.Black);
DataSP_GetRequestDetail_CountryName1.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// DataSP_GetRequestDetail_CountryName2
//
DataSP_GetRequestDetail_CountryName2 = new StiText();
DataSP_GetRequestDetail_CountryName2.CanGrow = true;
DataSP_GetRequestDetail_CountryName2.ClientRectangle = new RectangleD(11, 0, 2.8, 0.6);
DataSP_GetRequestDetail_CountryName2.GrowToHeight = true;
DataSP_GetRequestDetail_CountryName2.Name = "DataSP_GetRequestDetail_CountryName2";
DataSP_GetRequestDetail_CountryName2.GetValue += new StiGetValueEventHandler(DataSP_GetRequestDetail_CountryName2__GetValue);
DataSP_GetRequestDetail_CountryName2.VertAlignment = StiVertAlignment.Center;
DataSP_GetRequestDetail_CountryName2.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataSP_GetRequestDetail_CountryName2.Brush = new StiSolidBrush(Color.Transparent);
DataSP_GetRequestDetail_CountryName2.Font = new Font("BPG Glaho Arial", 8F);
DataSP_GetRequestDetail_CountryName2.Guid = null;
DataSP_GetRequestDetail_CountryName2.Interaction = null;
DataSP_GetRequestDetail_CountryName2.Margins = new StiMargins(0, 0, 0, 0);
DataSP_GetRequestDetail_CountryName2.TextBrush = new StiSolidBrush(Color.Black);
DataSP_GetRequestDetail_CountryName2.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// DataSP_GetRequestDetail_BrandName1
//
DataSP_GetRequestDetail_BrandName1 = new StiText();
DataSP_GetRequestDetail_BrandName1.CanGrow = true;
DataSP_GetRequestDetail_BrandName1.ClientRectangle = new RectangleD(13.8, 0, 2.6, 0.6);
DataSP_GetRequestDetail_BrandName1.Name = "DataSP_GetRequestDetail_BrandName1";
DataSP_GetRequestDetail_BrandName1.GetValue += new StiGetValueEventHandler(DataSP_GetRequestDetail_BrandName1__GetValue);
DataSP_GetRequestDetail_BrandName1.VertAlignment = StiVertAlignment.Center;
DataSP_GetRequestDetail_BrandName1.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataSP_GetRequestDetail_BrandName1.Brush = new StiSolidBrush(Color.Transparent);
DataSP_GetRequestDetail_BrandName1.Font = new Font("BPG Glaho Arial", 8F);
DataSP_GetRequestDetail_BrandName1.Guid = null;
DataSP_GetRequestDetail_BrandName1.Interaction = null;
DataSP_GetRequestDetail_BrandName1.Margins = new StiMargins(0, 0, 0, 0);
DataSP_GetRequestDetail_BrandName1.TextBrush = new StiSolidBrush(Color.Black);
DataSP_GetRequestDetail_BrandName1.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// DataSP_GetRequestDetail_BrandName2
//
DataSP_GetRequestDetail_BrandName2 = new StiText();
DataSP_GetRequestDetail_BrandName2.CanGrow = true;
DataSP_GetRequestDetail_BrandName2.ClientRectangle = new RectangleD(16.4, 0, 2.6, 0.6);
DataSP_GetRequestDetail_BrandName2.GrowToHeight = true;
DataSP_GetRequestDetail_BrandName2.Name = "DataSP_GetRequestDetail_BrandName2";
DataSP_GetRequestDetail_BrandName2.VertAlignment = StiVertAlignment.Center;
DataSP_GetRequestDetail_BrandName2.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataSP_GetRequestDetail_BrandName2.Brush = new StiSolidBrush(Color.Transparent);
DataSP_GetRequestDetail_BrandName2.Font = new Font("BPG Glaho Arial", 8F);
DataSP_GetRequestDetail_BrandName2.Guid = null;
DataSP_GetRequestDetail_BrandName2.Interaction = null;
DataSP_GetRequestDetail_BrandName2.Margins = new StiMargins(0, 0, 0, 0);
DataSP_GetRequestDetail_BrandName2.TextBrush = new StiSolidBrush(Color.Black);
DataSP_GetRequestDetail_BrandName2.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
DataSP_GetRequestDetail.Guid = null;
DataSP_GetRequestDetail.Interaction = null;
Page1.ExcelSheetValue = null;
Page1.Interaction = null;
Page1.Margins = new StiMargins(1, 1, 1, 1);
Page1_Watermark = new StiWatermark();
Page1_Watermark.Font = new Font("Arial", 100F);
Page1_Watermark.Image = null;
Page1_Watermark.TextBrush = new StiSolidBrush(Color.FromArgb(50, 0, 0, 0));
RptRequestDetail_PrinterSettings = new StiPrinterSettings();
PrinterSettings = RptRequestDetail_PrinterSettings;
Page1.Report = this;
Page1.Watermark = Page1_Watermark;
DataSP_GetRequestHeader.Page = Page1;
DataSP_GetRequestHeader.Parent = Page1;
Text2.Page = Page1;
Text2.Parent = DataSP_GetRequestHeader;
HeaderSP_GetRequestDetail.Page = Page1;
HeaderSP_GetRequestDetail.Parent = Page1;
HeaderSP_GetRequestDetail_OrdinalNumber.Page = Page1;
HeaderSP_GetRequestDetail_OrdinalNumber.Parent = HeaderSP_GetRequestDetail;
HeaderSP_GetRequestDetail_MedicamentName.Page = Page1;
HeaderSP_GetRequestDetail_MedicamentName.Parent = HeaderSP_GetRequestDetail;
HeaderSP_GetRequestDetail_RequestQty.Page = Page1;
HeaderSP_GetRequestDetail_RequestQty.Parent = HeaderSP_GetRequestDetail;
HeaderSP_GetRequestDetail_CountryName1.Page = Page1;
HeaderSP_GetRequestDetail_CountryName1.Parent = HeaderSP_GetRequestDetail;
HeaderSP_GetRequestDetail_CountryName2.Page = Page1;
HeaderSP_GetRequestDetail_CountryName2.Parent = HeaderSP_GetRequestDetail;
HeaderSP_GetRequestDetail_BrandName1.Page = Page1;
HeaderSP_GetRequestDetail_BrandName1.Parent = HeaderSP_GetRequestDetail;
HeaderSP_GetRequestDetail_BrandName2.Page = Page1;
HeaderSP_GetRequestDetail_BrandName2.Parent = HeaderSP_GetRequestDetail;
DataSP_GetRequestDetail.MasterComponent = DataSP_GetRequestHeader;
DataSP_GetRequestDetail.Page = Page1;
DataSP_GetRequestDetail.Parent = Page1;
DataSP_GetRequestDetail_MedicamentName.Page = Page1;
DataSP_GetRequestDetail_MedicamentName.Parent = DataSP_GetRequestDetail;
DataSP_GetRequestDetail_OrdinalNumber.Page = Page1;
DataSP_GetRequestDetail_OrdinalNumber.Parent = DataSP_GetRequestDetail;
DataSP_GetRequestDetail_RequestQty.Page = Page1;
DataSP_GetRequestDetail_RequestQty.Parent = DataSP_GetRequestDetail;
DataSP_GetRequestDetail_CountryName1.Page = Page1;
DataSP_GetRequestDetail_CountryName1.Parent = DataSP_GetRequestDetail;
DataSP_GetRequestDetail_CountryName2.Page = Page1;
DataSP_GetRequestDetail_CountryName2.Parent = DataSP_GetRequestDetail;
DataSP_GetRequestDetail_BrandName1.Page = Page1;
DataSP_GetRequestDetail_BrandName1.Parent = DataSP_GetRequestDetail;
DataSP_GetRequestDetail_BrandName2.Page = Page1;
DataSP_GetRequestDetail_BrandName2.Parent = DataSP_GetRequestDetail;
//
// Add to DataSP_GetRequestHeader.Components
//
DataSP_GetRequestHeader.Components.Clear();
DataSP_GetRequestHeader.Components.AddRange(new StiComponent[] {
Text2
});
//
// Add to HeaderSP_GetRequestDetail.Components
//
HeaderSP_GetRequestDetail.Components.Clear();
HeaderSP_GetRequestDetail.Components.AddRange(new StiComponent[] {
HeaderSP_GetRequestDetail_OrdinalNumber,
HeaderSP_GetRequestDetail_MedicamentName,
HeaderSP_GetRequestDetail_RequestQty,
HeaderSP_GetRequestDetail_CountryName1,
HeaderSP_GetRequestDetail_CountryName2,
HeaderSP_GetRequestDetail_BrandName1,
HeaderSP_GetRequestDetail_BrandName2
});
//
// Add to DataSP_GetRequestDetail.Components
//
DataSP_GetRequestDetail.Components.Clear();
DataSP_GetRequestDetail.Components.AddRange(new StiComponent[] {
DataSP_GetRequestDetail_MedicamentName,
DataSP_GetRequestDetail_OrdinalNumber,
DataSP_GetRequestDetail_RequestQty,
DataSP_GetRequestDetail_CountryName1,
DataSP_GetRequestDetail_CountryName2,
DataSP_GetRequestDetail_BrandName1,
DataSP_GetRequestDetail_BrandName2
});
//
// Add to Page1.Components
//
Page1.Components.Clear();
Page1.Components.AddRange(new StiComponent[] {
DataSP_GetRequestHeader,
HeaderSP_GetRequestDetail,
DataSP_GetRequestDetail
});
//
// Add to Pages
//
Pages.Clear();
Pages.AddRange(new[] {
Page1
});
Dictionary.Relations.Add(ParentSP_GetRequestHeader);
SP_GetRequestDetail.Columns.AddRange(new[] {
new StiDataColumn("RequestID", "RequestID", "RequestID", typeof(int)),
new StiDataColumn("RequestDetailID", "RequestDetailID", "RequestDetailID", typeof(int)),
new StiDataColumn("MedicamentID", "MedicamentID", "MedicamentID", typeof(int)),
new StiDataColumn("MedicamentName", "MedicamentName", "MedicamentName", typeof(string)),
new StiDataColumn("RequestQty", "RequestQty", "RequestQty", typeof(decimal)),
new StiDataColumn("CountryCode1", "CountryCode1", "CountryCode1", typeof(string)),
new StiDataColumn("CountryName1", "CountryName1", "CountryName1", typeof(string)),
new StiDataColumn("CountryCode2", "CountryCode2", "CountryCode2", typeof(string)),
new StiDataColumn("CountryName2", "CountryName2", "CountryName2", typeof(string)),
new StiDataColumn("BrandID", "BrandID", "BrandID", typeof(int)),
new StiDataColumn("BrandName", "BrandName", "BrandName", typeof(string)),
new StiDataColumn("OrdinalNumber", "OrdinalNumber", "OrdinalNumber", typeof(short)),
new StiDataColumn("Action", "Action", "Action", typeof(int))
});
DataSources.Add(SP_GetRequestDetail);
SP_GetRequestHeader.Columns.AddRange(new[] {
new StiDataColumn("RequestID", "RequestID", "RequestID", typeof(int)),
new StiDataColumn("BranchID", "BranchID", "BranchID", typeof(int)),
new StiDataColumn("BranchName", "BranchName", "BranchName", typeof(string)),
new StiDataColumn("RequestDate", "RequestDate", "RequestDate", typeof(DateTime)),
new StiDataColumn("Status", "Status", "Status", typeof(byte)),
new StiDataColumn("ModifierID", "ModifierID", "ModifierID", typeof(int)),
new StiDataColumn("Modifier", "Modifier", "Modifier", typeof(string)),
new StiDataColumn("ModifiedDate", "ModifiedDate", "ModifiedDate", typeof(DateTime)),
new StiDataColumn("ApproverID", "ApproverID", "ApproverID", typeof(int)),
new StiDataColumn("Approver", "Approver", "Approver", typeof(string))
});
DataSources.Add(SP_GetRequestHeader);
}
private void PrintDataGrid(DataGrid sender)
{
StiReport report = new StiReport();
report.ScriptLanguage = StiReportLanguageType.CSharp;
//Add data to datastore
report.RegData("MyList", list);
//Fill dictionary
report.Dictionary.Synchronize();
StiPage page = report.Pages.Items[0];
//Create HeaderBand
StiHeaderBand headerBand = new StiHeaderBand();
headerBand.Name = "HeaderBand";
page.Components.Add(headerBand);
//Create Dataaband
StiDataBand dataBand = new StiDataBand();
dataBand.DataSourceName = "MyList";
dataBand.Height = 0.5f;
dataBand.Name = "DataBand";
page.Components.Add(dataBand);
StiDataSource dataSource = report.Dictionary.DataSources[0];
//Create texts
Double pos = 0;
Double columnWidth = StiAlignValue.AlignToMinGrid(page.Width / dataSource.Columns.Count, 0.1, true);
int nameIndex = 1;
foreach (StiDataColumn column in dataSource.Columns)
{
if (column.Name == "_ID" || column.Name == "_Current")
{
continue;
}
//Create text on header
StiText headerText = new StiText(new RectangleD(pos, 0, columnWidth, 0.5f));
headerText.Text.Value = column.Name;
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 = "{MyList." + column.Name + "}";
dataText.Name = "DataText" + nameIndex.ToString();
dataText.Border.Side = StiBorderSides.All;
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();
//For checking created report you can uncomment this line
//report.Design();
}
static StiReport MakeReport(DBGrid grid, ReportCreateParam param)
{
JMXSchema schema = grid.Schema;
DataTable dt = grid.BaseTable;
double top = 0;
float fontSize = param.FontSize;
string tableName = TableAliasDefault;;
StiReport report = new StiReport
{
ScriptLanguage = StiReportLanguageType.CSharp,
ReportName = schema.Name
};
//report.RegData(tableName, dt);
report.RegData(tableName, grid.GetBindingSource());
report.Dictionary.Synchronize();
report.Dictionary.DataSources[0].Name = tableName;
report.Dictionary.DataSources[0].Alias = tableName;
StiPage page = report.Pages.Items[0];
page.Margins.Left = 1;
page.Margins.Right = 1;
page.AlignToGrid();
//ReportTitle
bool titleOnPage = param.TitleOnPage;
StiReportTitleBand titleBand = new StiReportTitleBand
{
Height = 0.5f,
CanGrow = true,
Name = "TitleBand"
};
page.Components.Add(titleBand);
//Period
bool period = param.Period;
if (period)
{
StiText periodText = new StiText(new RectangleD(0, 0, page.Width, 0.5f));
periodText.Text.Value = rth.Za();
periodText.HorAlignment = StiTextHorAlignment.Right;
periodText.Name = "periodText";
periodText.Border.Side = StiBorderSides.None;
//periodText.DockStyle = StiDockStyle.Right;
periodText.Font = new Font(grid.Font.FontFamily.Name, fontSize, FontStyle.Bold);
titleBand.Components.Add(periodText);
top += periodText.Height;
}
//Title
StiText titleText = new StiText(new RectangleD(0, period ? 0.5f : 0, page.Width, 1f));
titleText.Text.Value = grid.Schema.Name;
titleText.HorAlignment = StiTextHorAlignment.Center;
titleText.Name = "titleText";
titleText.Border.Side = StiBorderSides.None;
titleText.Font = new Font(grid.Font.FontFamily.Name, 12f, FontStyle.Bold);
titleText.WordWrap = true;
titleText.CanGrow = true;
titleBand.Components.Add(titleText);
top += titleText.Height;
//Create HeaderBand
StiBand headBand;
StiHeaderBand headerBand = new StiHeaderBand
{
Height = 0.5f,
Name = "HeaderBand"
};
if (titleOnPage)
{
page.Components.Add(headerBand);
headBand = headerBand;
}
else
{
headBand = titleBand;
}
//Create Databand
StiDataBand dataBand = new StiDataBand
{
DataSourceName = tableName,
Height = 0.5f,
Name = "DataBand"
};
page.Components.Add(dataBand);
//Create FooterBand
StiFooterBand footerBand = new StiFooterBand
{
Height = 0.5f,
CanGrow = true,
Name = "FooterBand",
CanBreak = false
};
page.Components.Add(footerBand);
Double pos = 0;
int nameIndex = 1;
int i = 0;
bool multiLine = param.MultiLine;
int border = param.Border;
bool totals = false;
List <StiText> footerList = new List <StiText>();
foreach (DataGridViewColumn column in grid.Columns)
{
bool visible = (column.Visible && column.Width > 1);
if (visible)
{
Double columnWidth = StiAlignValue.AlignToMinGrid(column.Width / 33, 0.03, true);
//Create text on header
StiText headerText = new StiText(new RectangleD(pos, titleOnPage ? 0: top, columnWidth, 0.5f));
headerText.Text.Value = column.HeaderText;
headerText.HorAlignment = StiTextHorAlignment.Center;
headerText.Name = "HeaderText" + nameIndex.ToString();
if (border == 0)
{
headerText.Border.Side = StiBorderSides.Top | StiBorderSides.Bottom;
}
else
{
headerText.Border.Side = StiBorderSides.All;
}
headerText.CanGrow = true;
headerText.GrowToHeight = true;
headerText.WordWrap = multiLine;
headerText.Font = new Font(grid.ColumnHeadersDefaultCellStyle.Font.FontFamily.Name, fontSize);
headBand.Components.Add(headerText);
MacroType tt = DBGridBase.GetMacroType(schema.Attributes[i].DataType);
string format = column.DefaultCellStyle.Format;
if (string.IsNullOrEmpty(format) && tt == MacroType.date)
{
format = vbo.DateFormat;
}
StiTextHorAlignment horAlign;
switch (column.DefaultCellStyle.Alignment)
{
case DataGridViewContentAlignment.MiddleRight:
horAlign = StiTextHorAlignment.Right;
break;
case DataGridViewContentAlignment.MiddleLeft:
horAlign = StiTextHorAlignment.Left;
break;
default:
horAlign = StiTextHorAlignment.Center;
break;
}
//Create text on Data Band
StiText dataText = new StiText(new RectangleD(pos, 0, columnWidth, 0.5f));
string field = tableName + "." + Stimulsoft.Report.CodeDom.StiCodeDomSerializator.ReplaceSymbols(column.DataPropertyName);
if (AccntFormat.ValidFormat(format))
{
dataText.Text.Value = "{Substring(" + field + ",0,5)+" + "-".Qt() +
"+Substring(" + field + ",5,3)+" + "-".Qt() +
"+Substring(" + field + ",8,1)+" + "-".Qt() +
"+Substring(" + field + ",9,4)+" + "-".Qt() +
"+Substring(" + field + ",13,7)" + "}";
}
else
{
dataText.Text.Value = "{" + field + "}";
}
dataText.Name = "DataText" + nameIndex.ToString();
dataText.CanGrow = true;
dataText.GrowToHeight = true;
dataText.WordWrap = multiLine;
dataText.HorAlignment = horAlign;
//dataText.VertAlignment = StiVertAlignment.Center;
if (border == 0)
{
dataText.Border.Side = StiBorderSides.None;
}
else if (border == 1)
{
dataText.Border.Side = StiBorderSides.Bottom;
}
else
{
dataText.Border.Side = StiBorderSides.All;
}
if (grid.RowsDefaultCellStyle.Font == null)
{
dataText.Font = new Font(grid.Font.FontFamily.Name, fontSize);
}
else
{
dataText.Font = new Font(grid.RowsDefaultCellStyle.Font.FontFamily.Name, fontSize);
}
dataText.TextFormat = ParseFormat(format);
if (tt == MacroType.num)
{
dataText.ExcelValue.Value = "{" + field + "}";
}
dataBand.Components.Add(dataText);
//Create text on footer
string summary = schema.Attributes[i].Agregate.ToLower();
if (summary == "sum")
{
summary = "Sum(" + field + ")";
}
else if (summary == "rcnt")
{
summary = "Count()";
}
else if (summary == "ave")
{
summary = "Avg(" + field + ")";
}
else if (summary == "min")
{
summary = "Min(" + field + ")";
}
else if (summary == "max")
{
summary = "Max(" + field + ")";
}
else
{
summary = string.Empty;
}
bool summaryEmpty = string.IsNullOrEmpty(summary);
int footerIndex = i;
//if (!string.IsNullOrEmpty(grid.FooterText(footerIndex)))
if (!summaryEmpty)
{
totals = true;
}
StiText footerText = new StiText(new RectangleD(pos, 0, columnWidth, 0.5f));
if (footerIndex == 0 && summaryEmpty)
{
footerText.Text.Value = grid.FooterCaption;
}
else if (footerIndex == 0)
{
footerText.Text.Value = "{" + (grid.FooterCaption + vbo.vbTab).Qt() + "+" + summary + "}";
}
else if (!summaryEmpty)
{
footerText.Text.Value = "{" + summary + "}";
footerText.ExcelValue.Value = "{" + summary + "}";
}
else
{
footerText.Text.Value = grid.FooterText(footerIndex);
}
footerText.Name = "FooterText" + nameIndex.ToString();
if (border == 0)
{
footerText.Border.Side = StiBorderSides.Top | StiBorderSides.Bottom;
}
else
{
footerText.Border.Side = StiBorderSides.All;
}
if (!summaryEmpty && summary != "Count()")
{
footerText.TextFormat = (StiFormatService)dataText.TextFormat.Clone();
}
footerText.HorAlignment = horAlign;
//footerText.VertAlignment = StiVertAlignment.Center;
footerText.Font = new Font(grid.Font.FontFamily.Name, fontSize);
footerList.Add(footerText);
pos += columnWidth;
nameIndex++;
}
i++;
}
if (totals)
{
footerBand.Components.AddRange(footerList.ToArray());
}
if ((pos - page.Width) < 1.6f)
{
page.Margins.Right = 0;
page.Margins.Left /= 2;
}
else if (pos > page.Width)
{
page.Orientation = StiPageOrientation.Landscape;
titleText.Width = page.Width;
if (period)
{
titleBand.Components[titleBand.Components.IndexOf("periodText")].Width = page.Width;
}
if (pos > page.Width)
{
page.Margins.Right = 0;
page.Margins.Left /= 2;
}
if (pos > page.Width)
{
page.Width = pos;
}
}
if (param.Sign)
{
footerList.Clear();
//StiText footerText = new StiText(new RectangleD(0, 0.5f, page.Width, 0.5f));
//footerList.Add(footerText);
//footerText = new StiText(new RectangleD(0, 1f, page.Width / 2, 0.5f));
//footerText.Text.Value = "{CSetup.Setup.Properties(" + vbo.Qt("President") + ", " + vbo.Qt("") + ")}";
//footerText.HorAlignment = StiTextHorAlignment.Right;
//footerText.Font = new Font(grid.ColumnHeadersDefaultCellStyle.Font.FontFamily.Name, 10);
//footerList.Add(footerText);
//footerText = new StiText(new RectangleD(page.Width / 2, 1f, page.Width / 4, 0.5f));
//footerList.Add(footerText);
//footerText = new StiText(new RectangleD(page.Width * 3 / 4, 1f, page.Width / 4, 0.5f));
//footerText.Text.Value = "{CSetup.Setup.Properties(" + vbo.Qt("PresidentName") + ", " + vbo.Qt("") + ")}";
//footerText.HorAlignment = StiTextHorAlignment.Left;
//footerText.Font = new Font(grid.ColumnHeadersDefaultCellStyle.Font.FontFamily.Name, 10);
//footerList.Add(footerText);
//footerText = new StiText(new RectangleD(0, 1.5f, page.Width, 0.5f));
//footerList.Add(footerText);
//footerText = new StiText(new RectangleD(0, 2f, page.Width / 2, 0.5f));
//footerText.Text.Value = "{CSetup.Setup.Properties(" + vbo.Qt("ChifAccount") + ", " + vbo.Qt("") + ")}";
//footerText.HorAlignment = StiTextHorAlignment.Right;
//footerText.Font = new Font(grid.ColumnHeadersDefaultCellStyle.Font.FontFamily.Name, 10);
//footerList.Add(footerText);
//footerText = new StiText(new RectangleD(page.Width / 2, 2f, page.Width / 4, 0.5f));
//footerList.Add(footerText);
//footerText = new StiText(new RectangleD(page.Width * 3 / 4, 2f, page.Width / 4, 0.5f));
//footerText.Text.Value = "{CSetup.Setup.Properties(" + vbo.Qt("ChifAccountName") + ", " + vbo.Qt("") + ")}";
//footerText.HorAlignment = StiTextHorAlignment.Left;
//footerText.Font = new Font(grid.ColumnHeadersDefaultCellStyle.Font.FontFamily.Name, 10);
//footerList.Add(footerText);
//footerBand.Height = 2.5f;
//footerBand.Components.AddRange(footerList.ToArray());
}
return(report);
}
private void InitializeComponent()
{
FN_GetSalesOrderHeaderPurchaseTotal = new FN_GetSalesOrderHeaderPurchaseTotalDataSource();
NeedsCompiling = false;
Text18_Sum1 = new StiSumDecimalFunctionService();
Text18_Sum2 = new StiSumDecimalFunctionService();
Text17_Sum = new StiSumDecimalFunctionService();
Text16_Sum = new StiSumDecimalFunctionService();
Text7_Sum1 = new StiSumDecimalFunctionService();
Text7_Sum2 = new StiSumDecimalFunctionService();
Text6_Sum = new StiSumDecimalFunctionService();
Text5_Sum = new StiSumDecimalFunctionService();
EngineVersion = StiEngineVersion.EngineV2;
ReferencedAssemblies = new[] {
"System.Dll",
"System.Drawing.Dll",
"System.Windows.Forms.Dll",
"System.Data.Dll",
"System.Xml.Dll",
"Stimulsoft.Controls.Dll",
"Stimulsoft.Base.Dll",
"Stimulsoft.Report.Dll"
};
ReportAlias = "Rpt Sales Order Header Purchase Total";
ReportAuthor = "Programmer.GE";
//
// ReportChanged
//
ReportChanged = new DateTime(2010, 2, 25, 21, 32, 48, 718);
//
// ReportCreated
//
ReportCreated = new DateTime(2009, 8, 6, 21, 34, 3, 0);
ReportDescription = "მოგების ჟურნალი (დაჯგუფებული)";
ReportFile = "D:\\My Documents\\Projects\\Apothex\\Source\\Class Library\\Apothex.Reporting\\Sales\\Rpt" +
"SalesOrderHeaderPurchaseTotal.mrt";
ReportGuid = "f49a941abd3949d8932cb0fdd662bc9e";
ReportName = "RptSalesOrderHeaderPurchaseTotal";
ReportUnit = StiReportUnitType.Centimeters;
ScriptLanguage = StiReportLanguageType.CSharp;
//
// Page1
//
Page1 = new StiPage();
Page1.Guid = "5bf063ac2d254cd28a26e54f9ff09381";
Page1.Name = "Page1";
Page1.PageHeight = 29.7;
Page1.PageWidth = 21;
Page1.PaperSize = PaperKind.A4;
Page1.Border = new StiBorder(StiBorderSides.None, Color.Black, 2, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Page1.Brush = new StiSolidBrush(Color.Transparent);
//
// ReportTitleBand1
//
ReportTitleBand1 = new StiReportTitleBand();
ReportTitleBand1.ClientRectangle = new RectangleD(0, 0.4, 19, 0.8);
ReportTitleBand1.Name = "ReportTitleBand1";
ReportTitleBand1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
ReportTitleBand1.Brush = new StiSolidBrush(Color.Transparent);
//
// Text1
//
Text1 = new StiText();
Text1.ClientRectangle = new RectangleD(0, 0, 19, 0.8);
Text1.HorAlignment = StiTextHorAlignment.Center;
Text1.Name = "Text1";
Text1.GetValue += new StiGetValueEventHandler(Text1__GetValue);
Text1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text1.Brush = new StiSolidBrush(Color.Transparent);
Text1.Font = new Font("BPG Glaho Arial", 12F, FontStyle.Bold);
Text1.Guid = null;
Text1.Interaction = null;
Text1.Margins = new StiMargins(0, 0, 0, 0);
Text1.TextBrush = new StiSolidBrush(Color.Black);
Text1.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
ReportTitleBand1.Guid = null;
ReportTitleBand1.Interaction = null;
//
// HeaderBand1
//
HeaderBand1 = new StiHeaderBand();
HeaderBand1.ClientRectangle = new RectangleD(0, 2, 19, 0.6);
HeaderBand1.Name = "HeaderBand1";
HeaderBand1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderBand1.Brush = new StiSolidBrush(Color.Transparent);
//
// Text8
//
Text8 = new StiText();
Text8.ClientRectangle = new RectangleD(0, 0, 5.8, 0.6);
Text8.HorAlignment = StiTextHorAlignment.Center;
Text8.Name = "Text8";
Text8.GetValue += new StiGetValueEventHandler(Text8__GetValue);
Text8.VertAlignment = StiVertAlignment.Center;
Text8.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text8.Brush = new StiSolidBrush(Color.Transparent);
Text8.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
Text8.Guid = null;
Text8.Interaction = null;
Text8.Margins = new StiMargins(0, 0, 0, 0);
Text8.TextBrush = new StiSolidBrush(Color.Black);
Text8.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text9
//
Text9 = new StiText();
Text9.ClientRectangle = new RectangleD(5.8, 0, 2, 0.6);
Text9.Guid = "f024598007b642c9b6f61c05578288bd";
Text9.HorAlignment = StiTextHorAlignment.Center;
Text9.Name = "Text9";
Text9.GetValue += new StiGetValueEventHandler(Text9__GetValue);
Text9.VertAlignment = StiVertAlignment.Center;
Text9.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text9.Brush = new StiSolidBrush(Color.Transparent);
Text9.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
Text9.Interaction = null;
Text9.Margins = new StiMargins(0, 0, 0, 0);
Text9.TextBrush = new StiSolidBrush(Color.Black);
Text9.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text10
//
Text10 = new StiText();
Text10.ClientRectangle = new RectangleD(7.8, 0, 2.4, 0.6);
Text10.Guid = "39898374932e4457b57d3316a524f5cb";
Text10.HorAlignment = StiTextHorAlignment.Center;
Text10.Name = "Text10";
Text10.GetValue += new StiGetValueEventHandler(Text10__GetValue);
Text10.VertAlignment = StiVertAlignment.Center;
Text10.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text10.Brush = new StiSolidBrush(Color.Transparent);
Text10.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
Text10.Interaction = null;
Text10.Margins = new StiMargins(0, 0, 0, 0);
Text10.TextBrush = new StiSolidBrush(Color.Black);
Text10.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text11
//
Text11 = new StiText();
Text11.ClientRectangle = new RectangleD(10.2, 0, 2.4, 0.6);
Text11.Guid = "95bb7db1a7624bec9498d8c9787dc960";
Text11.HorAlignment = StiTextHorAlignment.Center;
Text11.Name = "Text11";
Text11.GetValue += new StiGetValueEventHandler(Text11__GetValue);
Text11.VertAlignment = StiVertAlignment.Center;
Text11.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text11.Brush = new StiSolidBrush(Color.Transparent);
Text11.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
Text11.Interaction = null;
Text11.Margins = new StiMargins(0, 0, 0, 0);
Text11.TextBrush = new StiSolidBrush(Color.Black);
Text11.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text12
//
Text12 = new StiText();
Text12.ClientRectangle = new RectangleD(7.8, 0, 2.4, 0.6);
Text12.Guid = "07044fbd4db348d8a3ea69548d8d1c72";
Text12.HorAlignment = StiTextHorAlignment.Center;
Text12.Name = "Text12";
Text12.GetValue += new StiGetValueEventHandler(Text12__GetValue);
Text12.VertAlignment = StiVertAlignment.Center;
Text12.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text12.Brush = new StiSolidBrush(Color.Transparent);
Text12.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
Text12.Interaction = null;
Text12.Margins = new StiMargins(0, 0, 0, 0);
Text12.TextBrush = new StiSolidBrush(Color.Black);
Text12.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text13
//
Text13 = new StiText();
Text13.ClientRectangle = new RectangleD(10.2, 0, 2.4, 0.6);
Text13.Guid = "0974ed75540740f4af139745ad771e08";
Text13.HorAlignment = StiTextHorAlignment.Center;
Text13.Name = "Text13";
Text13.GetValue += new StiGetValueEventHandler(Text13__GetValue);
Text13.VertAlignment = StiVertAlignment.Center;
Text13.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text13.Brush = new StiSolidBrush(Color.Transparent);
Text13.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
Text13.Interaction = null;
Text13.Margins = new StiMargins(0, 0, 0, 0);
Text13.TextBrush = new StiSolidBrush(Color.Black);
Text13.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text14
//
Text14 = new StiText();
Text14.ClientRectangle = new RectangleD(12.6, 0, 2.4, 0.6);
Text14.Guid = "f11d8ef223974cbeb4dd9d4055d584bc";
Text14.HorAlignment = StiTextHorAlignment.Center;
Text14.Name = "Text14";
Text14.GetValue += new StiGetValueEventHandler(Text14__GetValue);
Text14.VertAlignment = StiVertAlignment.Center;
Text14.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text14.Brush = new StiSolidBrush(Color.Transparent);
Text14.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
Text14.Interaction = null;
Text14.Margins = new StiMargins(0, 0, 0, 0);
Text14.TextBrush = new StiSolidBrush(Color.Black);
Text14.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text15
//
Text15 = new StiText();
Text15.ClientRectangle = new RectangleD(15, 0, 4, 0.6);
Text15.Guid = "bbef06e2a66d48beb97e857e1eedbaec";
Text15.HorAlignment = StiTextHorAlignment.Center;
Text15.Name = "Text15";
Text15.GetValue += new StiGetValueEventHandler(Text15__GetValue);
Text15.VertAlignment = StiVertAlignment.Center;
Text15.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text15.Brush = new StiSolidBrush(Color.Transparent);
Text15.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
Text15.Interaction = null;
Text15.Margins = new StiMargins(0, 0, 0, 0);
Text15.TextBrush = new StiSolidBrush(Color.Black);
Text15.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
HeaderBand1.Guid = null;
HeaderBand1.Interaction = null;
//
// GroupHeaderBand2
//
GroupHeaderBand2 = new StiGroupHeaderBand();
GroupHeaderBand2.ClientRectangle = new RectangleD(0, 3.4, 19, 0.6);
GroupHeaderBand2.GetValue += new StiValueEventHandler(GroupHeaderBand2__GetValue);
GroupHeaderBand2.Guid = "d82d03aa1689442db9088bdf4fbd6f74";
GroupHeaderBand2.Name = "GroupHeaderBand2";
GroupHeaderBand2.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
GroupHeaderBand2.Brush = new StiSolidBrush(Color.Transparent);
//
// Text2
//
Text2 = new StiText();
Text2.ClientRectangle = new RectangleD(0, 0, 5.8, 0.6);
Text2.Guid = "b4b9c81160034475a70f8e58952c143c";
Text2.Name = "Text2";
Text2.GetValue += new StiGetValueEventHandler(Text2__GetValue);
Text2.VertAlignment = StiVertAlignment.Center;
Text2.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text2.Brush = new StiSolidBrush(Color.Transparent);
Text2.Font = new Font("BPG Glaho Arial", 10F);
Text2.Interaction = null;
Text2.Margins = new StiMargins(0, 0, 0, 0);
Text2.TextBrush = new StiSolidBrush(Color.Black);
Text2.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text3
//
Text3 = new StiText();
Text3.ClientRectangle = new RectangleD(5.8, 0, 2, 0.6);
Text3.Guid = "edcd73415b85450bacde997ae60d04b4";
Text3.HorAlignment = StiTextHorAlignment.Center;
Text3.Name = "Text3";
Text3.GetValue += new StiGetValueEventHandler(Text3__GetValue);
Text3.VertAlignment = StiVertAlignment.Center;
Text3.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text3.Brush = new StiSolidBrush(Color.Transparent);
Text3.Font = new Font("BPG Glaho Arial", 10F);
Text3.Interaction = null;
Text3.Margins = new StiMargins(0, 0, 0, 0);
Text3.TextBrush = new StiSolidBrush(Color.Black);
Text3.TextFormat = new StiDateFormatService("d", " ");
Text3.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text4
//
Text4 = new StiText();
Text4.ClientRectangle = new RectangleD(15, 0, 4, 0.6);
Text4.Name = "Text4";
Text4.GetValue += new StiGetValueEventHandler(Text4__GetValue);
Text4.VertAlignment = StiVertAlignment.Center;
Text4.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text4.Brush = new StiSolidBrush(Color.Transparent);
Text4.Font = new Font("BPG Glaho Arial", 10F);
Text4.Guid = null;
Text4.Interaction = null;
Text4.Margins = new StiMargins(0, 0, 0, 0);
Text4.TextBrush = new StiSolidBrush(Color.Black);
Text4.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text5
//
Text5 = new StiText();
Text5.ClientRectangle = new RectangleD(7.8, 0, 2.4, 0.6);
Text5.HorAlignment = StiTextHorAlignment.Right;
Text5.Name = "Text5";
//
// Text5_Sum
//
Text5.GetValue += new StiGetValueEventHandler(Text5__GetValue);
Text5.VertAlignment = StiVertAlignment.Center;
Text5.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text5.Brush = new StiSolidBrush(Color.Transparent);
Text5.Font = new Font("BPG Glaho Arial", 10F);
Text5.Guid = null;
Text5.Interaction = null;
Text5.Margins = new StiMargins(0, 0, 0, 0);
Text5.TextBrush = new StiSolidBrush(Color.Black);
Text5.TextFormat = new StiNumberFormatService(1, ",", 2, " ", 3, true, true, " ");
Text5.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text6
//
Text6 = new StiText();
Text6.ClientRectangle = new RectangleD(10.2, 0, 2.4, 0.6);
Text6.Guid = "1f0c8f611f96466a9776c640bd6c1ba7";
Text6.HorAlignment = StiTextHorAlignment.Right;
Text6.Name = "Text6";
//
// Text6_Sum
//
Text6.GetValue += new StiGetValueEventHandler(Text6__GetValue);
Text6.VertAlignment = StiVertAlignment.Center;
Text6.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text6.Brush = new StiSolidBrush(Color.Transparent);
Text6.Font = new Font("BPG Glaho Arial", 10F);
Text6.Interaction = null;
Text6.Margins = new StiMargins(0, 0, 0, 0);
Text6.TextBrush = new StiSolidBrush(Color.Black);
Text6.TextFormat = new StiNumberFormatService(1, ",", 2, " ", 3, true, true, " ");
Text6.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text7
//
Text7 = new StiText();
Text7.ClientRectangle = new RectangleD(12.6, 0, 2.4, 0.6);
Text7.Guid = "e1d414bc48834ba0ae5c02772f452d98";
Text7.HorAlignment = StiTextHorAlignment.Right;
Text7.Name = "Text7";
//
// Text7_Sum1
//
//
// Text7_Sum2
//
Text7.GetValue += new StiGetValueEventHandler(Text7__GetValue);
Text7.VertAlignment = StiVertAlignment.Center;
Text7.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text7.Brush = new StiSolidBrush(Color.Transparent);
Text7.Font = new Font("BPG Glaho Arial", 10F);
Text7.Interaction = null;
Text7.Margins = new StiMargins(0, 0, 0, 0);
Text7.TextBrush = new StiSolidBrush(Color.Black);
Text7.TextFormat = new StiNumberFormatService(1, ",", 2, " ", 3, true, true, " ");
Text7.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
GroupHeaderBand2.Interaction = null;
//
// DataFN_GetSalesOrderHeaderPurchaseTotal
//
DataFN_GetSalesOrderHeaderPurchaseTotal = new StiDataBand();
DataFN_GetSalesOrderHeaderPurchaseTotal.CalcInvisible = true;
DataFN_GetSalesOrderHeaderPurchaseTotal.ClientRectangle = new RectangleD(0, 4.8, 19, 0.8);
DataFN_GetSalesOrderHeaderPurchaseTotal.DataSourceName = "FN_GetSalesOrderHeaderPurchaseTotal";
DataFN_GetSalesOrderHeaderPurchaseTotal.Enabled = false;
DataFN_GetSalesOrderHeaderPurchaseTotal.Name = "DataFN_GetSalesOrderHeaderPurchaseTotal";
DataFN_GetSalesOrderHeaderPurchaseTotal.Sort = new[] {
"ASC",
"OrderDate",
"ASC",
"BranchName",
"ASC",
"PaymentMethodName"
};
DataFN_GetSalesOrderHeaderPurchaseTotal.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataFN_GetSalesOrderHeaderPurchaseTotal.Brush = new StiSolidBrush(Color.Transparent);
DataFN_GetSalesOrderHeaderPurchaseTotal.DataRelationName = null;
DataFN_GetSalesOrderHeaderPurchaseTotal.Guid = null;
DataFN_GetSalesOrderHeaderPurchaseTotal.Interaction = null;
DataFN_GetSalesOrderHeaderPurchaseTotal.MasterComponent = null;
//
// FooterBand1
//
FooterBand1 = new StiFooterBand();
FooterBand1.ClientRectangle = new RectangleD(0, 6.4, 19, 0.6);
FooterBand1.Name = "FooterBand1";
FooterBand1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
FooterBand1.Brush = new StiSolidBrush(Color.Transparent);
//
// Text16
//
Text16 = new StiText();
Text16.ClientRectangle = new RectangleD(7.8, 0, 2.4, 0.6);
Text16.HorAlignment = StiTextHorAlignment.Right;
Text16.Name = "Text16";
//
// Text16_Sum
//
Text16.GetValue += new StiGetValueEventHandler(Text16__GetValue);
Text16.VertAlignment = StiVertAlignment.Center;
Text16.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text16.Brush = new StiSolidBrush(Color.Transparent);
Text16.Font = new Font("BPG Glaho Arial", 10F);
Text16.Guid = null;
Text16.Interaction = null;
Text16.Margins = new StiMargins(0, 0, 0, 0);
Text16.TextBrush = new StiSolidBrush(Color.Black);
Text16.TextFormat = new StiNumberFormatService(1, ",", 2, " ", 3, true, true, " ");
Text16.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text17
//
Text17 = new StiText();
Text17.ClientRectangle = new RectangleD(10.2, 0, 2.4, 0.6);
Text17.Guid = "f2dd3d749ca7442996cf2f1d37916060";
Text17.HorAlignment = StiTextHorAlignment.Right;
Text17.Name = "Text17";
//
// Text17_Sum
//
Text17.GetValue += new StiGetValueEventHandler(Text17__GetValue);
Text17.VertAlignment = StiVertAlignment.Center;
Text17.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text17.Brush = new StiSolidBrush(Color.Transparent);
Text17.Font = new Font("BPG Glaho Arial", 10F);
Text17.Interaction = null;
Text17.Margins = new StiMargins(0, 0, 0, 0);
Text17.TextBrush = new StiSolidBrush(Color.Black);
Text17.TextFormat = new StiNumberFormatService(1, ",", 2, " ", 3, true, true, " ");
Text17.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text18
//
Text18 = new StiText();
Text18.ClientRectangle = new RectangleD(12.6, 0, 2.4, 0.6);
Text18.Guid = "5c8ac7b53c0e4fb8a58a0269915321bf";
Text18.HorAlignment = StiTextHorAlignment.Right;
Text18.Name = "Text18";
//
// Text18_Sum1
//
//
// Text18_Sum2
//
Text18.GetValue += new StiGetValueEventHandler(Text18__GetValue);
Text18.VertAlignment = StiVertAlignment.Center;
Text18.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text18.Brush = new StiSolidBrush(Color.Transparent);
Text18.Font = new Font("BPG Glaho Arial", 10F);
Text18.Interaction = null;
Text18.Margins = new StiMargins(0, 0, 0, 0);
Text18.TextBrush = new StiSolidBrush(Color.Black);
Text18.TextFormat = new StiNumberFormatService(1, ",", 2, " ", 3, true, true, " ");
Text18.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
FooterBand1.Guid = null;
FooterBand1.Interaction = null;
Page1.ExcelSheetValue = null;
Page1.Interaction = null;
Page1.Margins = new StiMargins(1, 1, 1, 1);
Page1_Watermark = new StiWatermark();
Page1_Watermark.Font = new Font("Arial", 100F);
Page1_Watermark.Image = null;
Page1_Watermark.TextBrush = new StiSolidBrush(Color.FromArgb(50, 0, 0, 0));
RptSalesOrderHeaderPurchaseTotal_PrinterSettings = new StiPrinterSettings();
PrinterSettings = RptSalesOrderHeaderPurchaseTotal_PrinterSettings;
Page1.Page = Page1;
Page1.Report = this;
Page1.Watermark = Page1_Watermark;
ReportTitleBand1.Page = Page1;
ReportTitleBand1.Parent = Page1;
Text1.Page = Page1;
Text1.Parent = ReportTitleBand1;
HeaderBand1.Page = Page1;
HeaderBand1.Parent = Page1;
Text8.Page = Page1;
Text8.Parent = HeaderBand1;
Text9.Page = Page1;
Text9.Parent = HeaderBand1;
Text10.Page = Page1;
Text10.Parent = HeaderBand1;
Text11.Page = Page1;
Text11.Parent = HeaderBand1;
Text12.Page = Page1;
Text12.Parent = HeaderBand1;
Text13.Page = Page1;
Text13.Parent = HeaderBand1;
Text14.Page = Page1;
Text14.Parent = HeaderBand1;
Text15.Page = Page1;
Text15.Parent = HeaderBand1;
GroupHeaderBand2.Page = Page1;
GroupHeaderBand2.Parent = Page1;
Text2.Page = Page1;
Text2.Parent = GroupHeaderBand2;
Text3.Page = Page1;
Text3.Parent = GroupHeaderBand2;
Text4.Page = Page1;
Text4.Parent = GroupHeaderBand2;
Text5.Page = Page1;
Text5.Parent = GroupHeaderBand2;
Text6.Page = Page1;
Text6.Parent = GroupHeaderBand2;
Text7.Page = Page1;
Text7.Parent = GroupHeaderBand2;
DataFN_GetSalesOrderHeaderPurchaseTotal.Page = Page1;
DataFN_GetSalesOrderHeaderPurchaseTotal.Parent = Page1;
FooterBand1.Page = Page1;
FooterBand1.Parent = Page1;
Text16.Page = Page1;
Text16.Parent = FooterBand1;
Text17.Page = Page1;
Text17.Parent = FooterBand1;
Text18.Page = Page1;
Text18.Parent = FooterBand1;
GroupHeaderBand2.BeginRender += new EventHandler(GroupHeaderBand2__BeginRender);
GroupHeaderBand2.EndRender += new EventHandler(GroupHeaderBand2__EndRender);
DataFN_GetSalesOrderHeaderPurchaseTotal.BeginRender += new EventHandler(DataFN_GetSalesOrderHeaderPurchaseTotal__BeginRender);
DataFN_GetSalesOrderHeaderPurchaseTotal.EndRender += new EventHandler(DataFN_GetSalesOrderHeaderPurchaseTotal__EndRender);
GroupHeaderBand2.Rendering += new EventHandler(GroupHeaderBand2__Rendering);
DataFN_GetSalesOrderHeaderPurchaseTotal.Rendering += new EventHandler(DataFN_GetSalesOrderHeaderPurchaseTotal__Rendering);
AggregateFunctions = new object[] {
Text5_Sum,
Text6_Sum,
Text7_Sum1,
Text7_Sum2,
Text16_Sum,
Text17_Sum,
Text18_Sum1,
Text18_Sum2
};
//
// Add to ReportTitleBand1.Components
//
ReportTitleBand1.Components.Clear();
ReportTitleBand1.Components.AddRange(new StiComponent[] {
Text1
});
//
// Add to HeaderBand1.Components
//
HeaderBand1.Components.Clear();
HeaderBand1.Components.AddRange(new StiComponent[] {
Text8,
Text9,
Text10,
Text11,
Text12,
Text13,
Text14,
Text15
});
//
// Add to GroupHeaderBand2.Components
//
GroupHeaderBand2.Components.Clear();
GroupHeaderBand2.Components.AddRange(new StiComponent[] {
Text2,
Text3,
Text4,
Text5,
Text6,
Text7
});
//
// Add to FooterBand1.Components
//
FooterBand1.Components.Clear();
FooterBand1.Components.AddRange(new StiComponent[] {
Text16,
Text17,
Text18
});
//
// Add to Page1.Components
//
Page1.Components.Clear();
Page1.Components.AddRange(new StiComponent[] {
ReportTitleBand1,
HeaderBand1,
GroupHeaderBand2,
DataFN_GetSalesOrderHeaderPurchaseTotal,
FooterBand1
});
//
// Add to Pages
//
Pages.Clear();
Pages.AddRange(new[] {
Page1
});
FN_GetSalesOrderHeaderPurchaseTotal.Columns.AddRange(new[] {
new StiDataColumn("SalesOrderID", "SalesOrderID", "SalesOrderID", typeof(int)),
new StiDataColumn("BranchID", "BranchID", "BranchID", typeof(int)),
new StiDataColumn("BranchName", "BranchName", "BranchName", typeof(string)),
new StiDataColumn("OrderDate", "OrderDate", "OrderDate", typeof(DateTime)),
new StiDataColumn("SalesSubTotal", "SalesSubTotal", "SalesSubTotal", typeof(decimal)),
new StiDataColumn("SalesTaxAmt", "SalesTaxAmt", "SalesTaxAmt", typeof(decimal)),
new StiDataColumn("SalesFreight", "SalesFreight", "SalesFreight", typeof(decimal)),
new StiDataColumn("SalesTotalDue", "SalesTotalDue", "SalesTotalDue", typeof(decimal)),
new StiDataColumn("PurchaseSubTotal", "PurchaseSubTotal", "PurchaseSubTotal", typeof(decimal)),
new StiDataColumn("PurchaseTaxAmt", "PurchaseTaxAmt", "PurchaseTaxAmt", typeof(decimal)),
new StiDataColumn("CurrencyCode", "CurrencyCode", "CurrencyCode", typeof(string)),
new StiDataColumn("PaymentMethodName", "PaymentMethodName", "PaymentMethodName", typeof(string)),
new StiDataColumn("Status", "Status", "Status", typeof(byte))
});
DataSources.Add(FN_GetSalesOrderHeaderPurchaseTotal);
}
protected void Page_Load(object sender, EventArgs e)
{
DataSet data = new DataSet();
data.ReadXmlSchema(Server.MapPath(@"Data\Demo.xsd"));
data.ReadXml(Server.MapPath(@"Data\Demo.xml"));
StiReport report = new StiReport();
report.RegData(data);
//Fill dictionary
report.Dictionary.Synchronize();
StiPage page = report.Pages[0];
//Create HeaderBand
StiHeaderBand headerBand = new StiHeaderBand();
headerBand.Height = 0.5;
headerBand.Name = "HeaderBand";
page.Components.Add(headerBand);
//Create text on header
StiText headerText = new StiText(new RectangleD(0, 0, 5, 0.5));
headerText.Text = "CompanyName";
headerText.HorAlignment = StiTextHorAlignment.Center;
headerText.Name = "HeaderText";
headerText.Brush = new StiSolidBrush(System.Drawing.Color.LightGreen);
headerBand.Components.Add(headerText);
//Create Databand
StiDataBand dataBand = new StiDataBand();
dataBand.DataSourceName = "Customers";
dataBand.Height = 0.5;
dataBand.Name = "DataBand";
page.Components.Add(dataBand);
//Create text
StiText dataText = new StiText(new RectangleD(0, 0, 5, 0.5));
dataText.Text = "{Line}.{Customers.CompanyName}";
dataText.Name = "DataText";
dataBand.Components.Add(dataText);
//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, 5, 0.5));
footerText.Text = "Count - {Count()}";
footerText.HorAlignment = StiTextHorAlignment.Right;
footerText.Name = "FooterText";
footerText.Brush = new StiSolidBrush(System.Drawing.Color.LightGreen);
footerBand.Components.Add(footerText);
StiWebViewer1.Report = report;
}
private void InitializeComponent()
{
VW_SalesOrderHeader = new VW_SalesOrderHeaderDataSource();
Dictionary.Variables.Add(new StiVariable("", "MyCompanyName", "MyCompanyName", typeof(string), "", false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyTaxCode", "MyCompanyTaxCode", typeof(string), "", false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyDirectorName", "MyCompanyDirectorName", typeof(string), "", false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyCountryCode", "MyCompanyCountryCode", typeof(string), "", false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyCountryName", "MyCompanyCountryName", typeof(string), "", false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyCity", "MyCompanyCity", typeof(string), "", false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyPostalCode", "MyCompanyPostalCode", typeof(string), "", false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyAddress", "MyCompanyAddress", typeof(string), "", false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyPhone", "MyCompanyPhone", typeof(string), "", false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyFax", "MyCompanyFax", typeof(string), "", false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyBankName", "MyCompanyBankName", typeof(string), "", false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyBankCode", "MyCompanyBankCode", typeof(string), "", false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyBankAccountNumber", "MyCompanyBankAccountNumber", typeof(string), "", false, false));
NeedsCompiling = false;
Text1_Sum = new StiSumDecimalFunctionService();
FooterText1_Count = new StiCountFunctionService();
// Variables init
// Variables init
MyCompanyName = "";
MyCompanyTaxCode = "";
MyCompanyDirectorName = "";
MyCompanyCountryCode = "";
MyCompanyCountryName = "";
MyCompanyCity = "";
MyCompanyPostalCode = "";
MyCompanyAddress = "";
MyCompanyPhone = "";
MyCompanyFax = "";
MyCompanyBankName = "";
MyCompanyBankCode = "";
MyCompanyBankAccountNumber = "";
EngineVersion = StiEngineVersion.EngineV2;
ReferencedAssemblies = new[] {
"System.Dll",
"System.Drawing.Dll",
"System.Windows.Forms.Dll",
"System.Data.Dll",
"System.Xml.Dll",
"Stimulsoft.Controls.Dll",
"Stimulsoft.Base.Dll",
"Stimulsoft.Report.Dll"
};
ReportAlias = "Rpt Sales Order Header";
ReportAuthor = "Programmer.GE";
//
// ReportChanged
//
ReportChanged = new DateTime(2009, 6, 17, 11, 6, 30, 0);
//
// ReportCreated
//
ReportCreated = new DateTime(2009, 2, 8, 17, 26, 28, 0);
ReportDescription = "გაყიდვების რეპორტი";
ReportGuid = "2f64cd76b33a4817bb677636d7597eee";
ReportName = "RptSalesOrderHeader";
ReportUnit = StiReportUnitType.Centimeters;
ScriptLanguage = StiReportLanguageType.CSharp;
//
// Page1
//
Page1 = new StiPage();
Page1.Guid = "08a406f7186b4a67b5f7a96a78aa664a";
Page1.Name = "Page1";
Page1.PageHeight = 29.7;
Page1.PageWidth = 21;
Page1.Border = new StiBorder(StiBorderSides.None, Color.Black, 2, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Page1.Brush = new StiSolidBrush(Color.Transparent);
//
// ReportTitle
//
ReportTitle = new StiReportTitleBand();
ReportTitle.ClientRectangle = new RectangleD(0, 0.4, 19, 0.8);
ReportTitle.Name = "ReportTitle";
ReportTitle.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
ReportTitle.Brush = new StiSolidBrush(Color.Transparent);
//
// ReportTitleText
//
ReportTitleText = new StiText();
ReportTitleText.ClientRectangle = new RectangleD(0, 0, 19, 0.8);
ReportTitleText.HorAlignment = StiTextHorAlignment.Center;
ReportTitleText.Name = "ReportTitleText";
ReportTitleText.GetValue += new StiGetValueEventHandler(ReportTitleText__GetValue);
ReportTitleText.Type = StiSystemTextType.Expression;
ReportTitleText.VertAlignment = StiVertAlignment.Center;
ReportTitleText.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
ReportTitleText.Brush = new StiSolidBrush(Color.Transparent);
ReportTitleText.Font = new Font("BPG Glaho Arial", 12F, FontStyle.Bold);
ReportTitleText.Guid = null;
ReportTitleText.Interaction = null;
ReportTitleText.Margins = new StiMargins(0, 0, 0, 0);
ReportTitleText.TextBrush = new StiSolidBrush(Color.Black);
ReportTitleText.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
ReportTitle.Guid = null;
ReportTitle.Interaction = null;
//
// Header
//
Header = new StiHeaderBand();
Header.ClientRectangle = new RectangleD(0, 2, 19, 0.8);
Header.Name = "Header";
Header.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Header.Brush = new StiSolidBrush(Color.Transparent);
//
// HeaderText1
//
HeaderText1 = new StiText();
HeaderText1.CanGrow = true;
HeaderText1.ClientRectangle = new RectangleD(0, 0, 2.8, 0.8);
HeaderText1.HorAlignment = StiTextHorAlignment.Center;
HeaderText1.Name = "HeaderText1";
HeaderText1.GetValue += new StiGetValueEventHandler(HeaderText1__GetValue);
HeaderText1.Type = StiSystemTextType.Expression;
HeaderText1.VertAlignment = StiVertAlignment.Center;
HeaderText1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderText1.Brush = new StiSolidBrush(Color.Transparent);
HeaderText1.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
HeaderText1.Guid = null;
HeaderText1.Interaction = null;
HeaderText1.Margins = new StiMargins(0, 0, 0, 0);
HeaderText1.TextBrush = new StiSolidBrush(Color.Black);
HeaderText1.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// HeaderText2
//
HeaderText2 = new StiText();
HeaderText2.CanGrow = true;
HeaderText2.ClientRectangle = new RectangleD(2.8, 0, 2, 0.8);
HeaderText2.HorAlignment = StiTextHorAlignment.Center;
HeaderText2.Name = "HeaderText2";
HeaderText2.GetValue += new StiGetValueEventHandler(HeaderText2__GetValue);
HeaderText2.Type = StiSystemTextType.Expression;
HeaderText2.VertAlignment = StiVertAlignment.Center;
HeaderText2.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderText2.Brush = new StiSolidBrush(Color.Transparent);
HeaderText2.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
HeaderText2.Guid = null;
HeaderText2.Interaction = null;
HeaderText2.Margins = new StiMargins(0, 0, 0, 0);
HeaderText2.TextBrush = new StiSolidBrush(Color.Black);
HeaderText2.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// HeaderText3
//
HeaderText3 = new StiText();
HeaderText3.CanGrow = true;
HeaderText3.ClientRectangle = new RectangleD(4.8, 0, 6.4, 0.8);
HeaderText3.HorAlignment = StiTextHorAlignment.Center;
HeaderText3.Name = "HeaderText3";
HeaderText3.GetValue += new StiGetValueEventHandler(HeaderText3__GetValue);
HeaderText3.Type = StiSystemTextType.Expression;
HeaderText3.VertAlignment = StiVertAlignment.Center;
HeaderText3.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderText3.Brush = new StiSolidBrush(Color.Transparent);
HeaderText3.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
HeaderText3.Guid = null;
HeaderText3.Interaction = null;
HeaderText3.Margins = new StiMargins(0, 0, 0, 0);
HeaderText3.TextBrush = new StiSolidBrush(Color.Black);
HeaderText3.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// HeaderText4
//
HeaderText4 = new StiText();
HeaderText4.CanGrow = true;
HeaderText4.ClientRectangle = new RectangleD(11.2, 0, 2.8, 0.8);
HeaderText4.HorAlignment = StiTextHorAlignment.Center;
HeaderText4.Name = "HeaderText4";
HeaderText4.GetValue += new StiGetValueEventHandler(HeaderText4__GetValue);
HeaderText4.Type = StiSystemTextType.Expression;
HeaderText4.VertAlignment = StiVertAlignment.Center;
HeaderText4.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderText4.Brush = new StiSolidBrush(Color.Transparent);
HeaderText4.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
HeaderText4.Guid = null;
HeaderText4.Interaction = null;
HeaderText4.Margins = new StiMargins(0, 0, 0, 0);
HeaderText4.TextBrush = new StiSolidBrush(Color.Black);
HeaderText4.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// HeaderText5
//
HeaderText5 = new StiText();
HeaderText5.CanGrow = true;
HeaderText5.ClientRectangle = new RectangleD(14, 0, 1.6, 0.8);
HeaderText5.HorAlignment = StiTextHorAlignment.Center;
HeaderText5.Name = "HeaderText5";
HeaderText5.GetValue += new StiGetValueEventHandler(HeaderText5__GetValue);
HeaderText5.Type = StiSystemTextType.Expression;
HeaderText5.VertAlignment = StiVertAlignment.Center;
HeaderText5.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderText5.Brush = new StiSolidBrush(Color.Transparent);
HeaderText5.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
HeaderText5.Guid = null;
HeaderText5.Interaction = null;
HeaderText5.Margins = new StiMargins(0, 0, 0, 0);
HeaderText5.TextBrush = new StiSolidBrush(Color.Black);
HeaderText5.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// HeaderText6
//
HeaderText6 = new StiText();
HeaderText6.CanGrow = true;
HeaderText6.ClientRectangle = new RectangleD(15.6, 0, 3.4, 0.8);
HeaderText6.HorAlignment = StiTextHorAlignment.Center;
HeaderText6.Name = "HeaderText6";
HeaderText6.GetValue += new StiGetValueEventHandler(HeaderText6__GetValue);
HeaderText6.Type = StiSystemTextType.Expression;
HeaderText6.VertAlignment = StiVertAlignment.Center;
HeaderText6.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderText6.Brush = new StiSolidBrush(Color.Transparent);
HeaderText6.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
HeaderText6.Guid = null;
HeaderText6.Interaction = null;
HeaderText6.Margins = new StiMargins(0, 0, 0, 0);
HeaderText6.TextBrush = new StiSolidBrush(Color.Black);
HeaderText6.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
Header.Guid = null;
Header.Interaction = null;
//
// GroupHeader0
//
GroupHeader0 = new StiGroupHeaderBand();
GroupHeader0.ClientRectangle = new RectangleD(0, 3.6, 19, 0.8);
GroupHeader0.GetValue += new StiValueEventHandler(GroupHeader0__GetValue);
GroupHeader0.Name = "GroupHeader0";
GroupHeader0.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
GroupHeader0.Brush = new StiSolidBrush(Color.Transparent);
//
// GroupHeaderText0
//
GroupHeaderText0 = new StiText();
GroupHeaderText0.CanGrow = true;
GroupHeaderText0.ClientRectangle = new RectangleD(0, 0, 19, 0.8);
GroupHeaderText0.Name = "GroupHeaderText0";
GroupHeaderText0.GetValue += new StiGetValueEventHandler(GroupHeaderText0__GetValue);
GroupHeaderText0.VertAlignment = StiVertAlignment.Center;
GroupHeaderText0.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
GroupHeaderText0.Brush = new StiSolidBrush(Color.Transparent);
GroupHeaderText0.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
GroupHeaderText0.Guid = null;
GroupHeaderText0.Interaction = null;
GroupHeaderText0.Margins = new StiMargins(0, 0, 0, 0);
GroupHeaderText0.TextBrush = new StiSolidBrush(Color.Black);
GroupHeaderText0.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
GroupHeader0.Guid = null;
GroupHeader0.Interaction = null;
//
// Data
//
Data = new StiDataBand();
Data.ClientRectangle = new RectangleD(0, 5.2, 19, 0.6);
Data.DataSourceName = "VW_SalesOrderHeader";
Data.Name = "Data";
Data.Sort = new[] {
"ASC",
"BranchName",
"ASC",
"OrderDate"
};
Data.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Data.Brush = new StiSolidBrush(Color.Transparent);
//
// DataText1
//
DataText1 = new StiText();
DataText1.ClientRectangle = new RectangleD(0, 0, 2.2, 0.6);
DataText1.Name = "DataText1";
DataText1.GetValue += new StiGetValueEventHandler(DataText1__GetValue);
DataText1.VertAlignment = StiVertAlignment.Center;
DataText1.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataText1.Brush = new StiSolidBrush(Color.Transparent);
DataText1.Font = new Font("BPG Glaho Arial", 10F);
DataText1.Guid = null;
DataText1.Interaction = null;
DataText1.Margins = new StiMargins(0, 0, 0, 0);
DataText1.TextBrush = new StiSolidBrush(Color.Black);
DataText1.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// DataText2
//
DataText2 = new StiText();
DataText2.ClientRectangle = new RectangleD(2.2, 0, 3.2, 0.6);
DataText2.Name = "DataText2";
DataText2.GetValue += new StiGetValueEventHandler(DataText2__GetValue);
DataText2.VertAlignment = StiVertAlignment.Center;
DataText2.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataText2.Brush = new StiSolidBrush(Color.Transparent);
DataText2.Font = new Font("BPG Glaho Arial", 10F);
DataText2.Guid = null;
DataText2.Interaction = null;
DataText2.Margins = new StiMargins(0, 0, 0, 0);
DataText2.TextBrush = new StiSolidBrush(Color.Black);
DataText2.TextFormat = new StiCustomFormatService("G");
DataText2.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// DataText3
//
DataText3 = new StiText();
DataText3.ClientRectangle = new RectangleD(5.4, 0, 5.8, 0.6);
DataText3.Name = "DataText3";
DataText3.GetValue += new StiGetValueEventHandler(DataText3__GetValue);
DataText3.Type = StiSystemTextType.Expression;
DataText3.VertAlignment = StiVertAlignment.Center;
DataText3.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataText3.Brush = new StiSolidBrush(Color.Transparent);
DataText3.Font = new Font("BPG Glaho Arial", 10F);
DataText3.Guid = null;
DataText3.Interaction = null;
DataText3.Margins = new StiMargins(0, 0, 0, 0);
DataText3.TextBrush = new StiSolidBrush(Color.Black);
DataText3.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// DataText4
//
DataText4 = new StiText();
DataText4.ClientRectangle = new RectangleD(11.2, 0, 2.8, 0.6);
DataText4.HorAlignment = StiTextHorAlignment.Right;
DataText4.Name = "DataText4";
DataText4.GetValue += new StiGetValueEventHandler(DataText4__GetValue);
DataText4.VertAlignment = StiVertAlignment.Center;
DataText4.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataText4.Brush = new StiSolidBrush(Color.Transparent);
DataText4.Font = new Font("BPG Glaho Arial", 10F);
DataText4.Guid = null;
DataText4.Interaction = null;
DataText4.Margins = new StiMargins(0, 0, 0, 0);
DataText4.TextBrush = new StiSolidBrush(Color.Black);
DataText4.TextFormat = new StiNumberFormatService(1, ",", 2, " ", 3, true, true, " ");
DataText4.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// DataText5
//
DataText5 = new StiText();
DataText5.ClientRectangle = new RectangleD(14, 0, 1.6, 0.6);
DataText5.HorAlignment = StiTextHorAlignment.Center;
DataText5.Name = "DataText5";
DataText5.GetValue += new StiGetValueEventHandler(DataText5__GetValue);
DataText5.VertAlignment = StiVertAlignment.Center;
DataText5.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataText5.Brush = new StiSolidBrush(Color.Transparent);
DataText5.Font = new Font("BPG Glaho Arial", 10F);
DataText5.Guid = null;
DataText5.Interaction = null;
DataText5.Margins = new StiMargins(0, 0, 0, 0);
DataText5.TextBrush = new StiSolidBrush(Color.Black);
DataText5.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// DataText6
//
DataText6 = new StiText();
DataText6.ClientRectangle = new RectangleD(15.6, 0, 3.4, 0.6);
DataText6.Name = "DataText6";
DataText6.GetValue += new StiGetValueEventHandler(DataText6__GetValue);
DataText6.VertAlignment = StiVertAlignment.Center;
DataText6.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataText6.Brush = new StiSolidBrush(Color.Transparent);
DataText6.Font = new Font("BPG Glaho Arial", 10F);
DataText6.Guid = null;
DataText6.Interaction = null;
DataText6.Margins = new StiMargins(0, 0, 0, 0);
DataText6.TextBrush = new StiSolidBrush(Color.Black);
DataText6.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
Data.Guid = null;
Data.Interaction = null;
Data.MasterComponent = null;
//
// GroupFooter0
//
GroupFooter0 = new StiGroupFooterBand();
GroupFooter0.ClientRectangle = new RectangleD(0, 6.6, 19, 0.4);
GroupFooter0.Name = "GroupFooter0";
GroupFooter0.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
GroupFooter0.Brush = new StiSolidBrush(Color.Transparent);
GroupFooter0.Guid = null;
GroupFooter0.Interaction = null;
//
// Footer
//
Footer = new StiFooterBand();
Footer.ClientRectangle = new RectangleD(0, 7.8, 19, 0.6);
Footer.Name = "Footer";
Footer.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Footer.Brush = new StiSolidBrush(Color.Transparent);
//
// FooterText1
//
FooterText1 = new StiText();
FooterText1.CanGrow = true;
FooterText1.ClientRectangle = new RectangleD(0, 0, 2.2, 0.6);
FooterText1.HorAlignment = StiTextHorAlignment.Center;
FooterText1.Name = "FooterText1";
//
// FooterText1_Count
//
FooterText1.GetValue += new StiGetValueEventHandler(FooterText1__GetValue);
FooterText1.Type = StiSystemTextType.Expression;
FooterText1.VertAlignment = StiVertAlignment.Center;
FooterText1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
FooterText1.Brush = new StiSolidBrush(Color.Transparent);
FooterText1.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
FooterText1.Guid = null;
FooterText1.Interaction = null;
FooterText1.Margins = new StiMargins(0, 0, 0, 0);
FooterText1.TextBrush = new StiSolidBrush(Color.Black);
FooterText1.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text1
//
Text1 = new StiText();
Text1.ClientRectangle = new RectangleD(11.2, 0, 2.8, 0.6);
Text1.HorAlignment = StiTextHorAlignment.Right;
Text1.Name = "Text1";
//
// Text1_Sum
//
Text1.GetValue += new StiGetValueEventHandler(Text1__GetValue);
Text1.Type = StiSystemTextType.Totals;
Text1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text1.Brush = new StiSolidBrush(Color.Transparent);
Text1.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
Text1.Guid = null;
Text1.Interaction = null;
Text1.Margins = new StiMargins(0, 0, 0, 0);
Text1.TextBrush = new StiSolidBrush(Color.Black);
Text1.TextFormat = new StiNumberFormatService(1, ",", 2, " ", 3, true, true, " ");
Text1.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
Footer.Guid = null;
Footer.Interaction = null;
Page1.ExcelSheetValue = null;
Page1.Interaction = null;
Page1.Margins = new StiMargins(1, 1, 1, 1);
Page1_Watermark = new StiWatermark();
Page1_Watermark.Font = new Font("Arial", 100F);
Page1_Watermark.Image = null;
Page1_Watermark.TextBrush = new StiSolidBrush(Color.FromArgb(50, 0, 0, 0));
RptSalesOrderHeader_PrinterSettings = new StiPrinterSettings();
PrinterSettings = RptSalesOrderHeader_PrinterSettings;
Page1.Page = Page1;
Page1.Report = this;
Page1.Watermark = Page1_Watermark;
ReportTitle.Page = Page1;
ReportTitle.Parent = Page1;
ReportTitleText.Page = Page1;
ReportTitleText.Parent = ReportTitle;
Header.Page = Page1;
Header.Parent = Page1;
HeaderText1.Page = Page1;
HeaderText1.Parent = Header;
HeaderText2.Page = Page1;
HeaderText2.Parent = Header;
HeaderText3.Page = Page1;
HeaderText3.Parent = Header;
HeaderText4.Page = Page1;
HeaderText4.Parent = Header;
HeaderText5.Page = Page1;
HeaderText5.Parent = Header;
HeaderText6.Page = Page1;
HeaderText6.Parent = Header;
GroupHeader0.Page = Page1;
GroupHeader0.Parent = Page1;
GroupHeaderText0.Page = Page1;
GroupHeaderText0.Parent = GroupHeader0;
Data.Page = Page1;
Data.Parent = Page1;
DataText1.Page = Page1;
DataText1.Parent = Data;
DataText2.Page = Page1;
DataText2.Parent = Data;
DataText3.Page = Page1;
DataText3.Parent = Data;
DataText4.Page = Page1;
DataText4.Parent = Data;
DataText5.Page = Page1;
DataText5.Parent = Data;
DataText6.Page = Page1;
DataText6.Parent = Data;
GroupFooter0.Page = Page1;
GroupFooter0.Parent = Page1;
Footer.Page = Page1;
Footer.Parent = Page1;
FooterText1.Page = Page1;
FooterText1.Parent = Footer;
Text1.Page = Page1;
Text1.Parent = Footer;
Data.BeginRender += new EventHandler(Data__BeginRender);
Data.EndRender += new EventHandler(Data__EndRender);
Data.Rendering += new EventHandler(Data__Rendering);
AggregateFunctions = new object[] {
FooterText1_Count,
Text1_Sum
};
//
// Add to ReportTitle.Components
//
ReportTitle.Components.Clear();
ReportTitle.Components.AddRange(new StiComponent[] {
ReportTitleText
});
//
// Add to Header.Components
//
Header.Components.Clear();
Header.Components.AddRange(new StiComponent[] {
HeaderText1,
HeaderText2,
HeaderText3,
HeaderText4,
HeaderText5,
HeaderText6
});
//
// Add to GroupHeader0.Components
//
GroupHeader0.Components.Clear();
GroupHeader0.Components.AddRange(new StiComponent[] {
GroupHeaderText0
});
//
// Add to Data.Components
//
Data.Components.Clear();
Data.Components.AddRange(new StiComponent[] {
DataText1,
DataText2,
DataText3,
DataText4,
DataText5,
DataText6
});
//
// Add to Footer.Components
//
Footer.Components.Clear();
Footer.Components.AddRange(new StiComponent[] {
FooterText1,
Text1
});
//
// Add to Page1.Components
//
Page1.Components.Clear();
Page1.Components.AddRange(new StiComponent[] {
ReportTitle,
Header,
GroupHeader0,
Data,
GroupFooter0,
Footer
});
//
// Add to Pages
//
Pages.Clear();
Pages.AddRange(new[] {
Page1
});
VW_SalesOrderHeader.Columns.AddRange(new[] {
new StiDataColumn("SalesOrderID", "SalesOrderID", "SalesOrderID", typeof(int)),
new StiDataColumn("BranchID", "BranchID", "BranchID", typeof(int)),
new StiDataColumn("BranchName", "BranchName", "BranchName", typeof(string)),
new StiDataColumn("OrderDate", "OrderDate", "OrderDate", typeof(DateTime)),
new StiDataColumn("OverheadNumber", "OverheadNumber", "OverheadNumber", typeof(string)),
new StiDataColumn("CustomerID", "CustomerID", "CustomerID", typeof(int)),
new StiDataColumn("CustomerName", "CustomerName", "CustomerName", typeof(string)),
new StiDataColumn("SubTotal", "SubTotal", "SubTotal", typeof(decimal)),
new StiDataColumn("TaxAmt", "TaxAmt", "TaxAmt", typeof(decimal)),
new StiDataColumn("Freight", "Freight", "Freight", typeof(decimal)),
new StiDataColumn("TotalDue", "TotalDue", "TotalDue", typeof(decimal)),
new StiDataColumn("CurrencyCode", "CurrencyCode", "CurrencyCode", typeof(string)),
new StiDataColumn("CurrencyRateID", "CurrencyRateID", "CurrencyRateID", typeof(int)),
new StiDataColumn("PaymentMethodID", "PaymentMethodID", "PaymentMethodID", typeof(int)),
new StiDataColumn("PaymentMethodName", "PaymentMethodName", "PaymentMethodName", typeof(string)),
new StiDataColumn("RevisionNumber", "RevisionNumber", "RevisionNumber", typeof(byte)),
new StiDataColumn("Status", "Status", "Status", typeof(byte)),
new StiDataColumn("ModifiedUserID", "ModifiedUserID", "ModifiedUserID", typeof(int)),
new StiDataColumn("Modifier", "Modifier", "Modifier", typeof(string)),
new StiDataColumn("ModifiedDate", "ModifiedDate", "ModifiedDate", typeof(DateTime)),
new StiDataColumn("ApproverUserID", "ApproverUserID", "ApproverUserID", typeof(int)),
new StiDataColumn("Approver", "Approver", "Approver", typeof(string))
});
DataSources.Add(VW_SalesOrderHeader);
}
public void AddStiHeaderBand(StiHeaderBand stiHeaderBand)
{
AddComponent(stiHeaderBand);
}
private void InitializeComponent()
{
T_Detail = new T_DetailDataSource();
Dictionary.Variables.Add(new StiVariable("", "MyCompanyName", "MyCompanyName", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyTaxCode", "MyCompanyTaxCode", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyDirectorName", "MyCompanyDirectorName", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyCountryCode", "MyCompanyCountryCode", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyCountryName", "MyCompanyCountryName", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyCity", "MyCompanyCity", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyPostalCode", "MyCompanyPostalCode", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyAddress", "MyCompanyAddress", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyPhone", "MyCompanyPhone", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyFax", "MyCompanyFax", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyBankName", "MyCompanyBankName", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyBankCode", "MyCompanyBankCode", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyBankAccountNumber", "MyCompanyBankAccountNumber", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyVATPayerFlag", "MyCompanyVATPayerFlag", "", typeof(bool), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyConditionalUnitCurrencyCode", "MyCompanyConditionalUnitCurrencyCode", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyDefaultTradingCurrencyCode", "MyCompanyDefaultTradingCurrencyCode", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyConditionalUnitCurrencyRate", "MyCompanyConditionalUnitCurrencyRate", "", typeof(decimal), "", false, false, false));
NeedsCompiling = false;
// Variables init
// Variables init
MyCompanyName = "";
MyCompanyTaxCode = "";
MyCompanyDirectorName = "";
MyCompanyCountryCode = "";
MyCompanyCountryName = "";
MyCompanyCity = "";
MyCompanyPostalCode = "";
MyCompanyAddress = "";
MyCompanyPhone = "";
MyCompanyFax = "";
MyCompanyBankName = "";
MyCompanyBankCode = "";
MyCompanyBankAccountNumber = "";
MyCompanyVATPayerFlag = false;
MyCompanyConditionalUnitCurrencyCode = "";
MyCompanyDefaultTradingCurrencyCode = "";
MyCompanyConditionalUnitCurrencyRate = 0m;
EngineVersion = StiEngineVersion.EngineV2;
ReferencedAssemblies = new[] {
"System.Dll",
"System.Drawing.Dll",
"System.Windows.Forms.Dll",
"System.Data.Dll",
"System.Xml.Dll",
"Stimulsoft.Controls.Dll",
"Stimulsoft.Base.Dll",
"Stimulsoft.Report.Dll"
};
ReportAlias = "Rpt Produc Location Price";
ReportAuthor = "Programmer.GE";
//
// ReportChanged
//
ReportChanged = new DateTime(2011, 6, 12, 21, 55, 48, 0);
//
// ReportCreated
//
ReportCreated = new DateTime(2009, 6, 28, 22, 3, 23, 0);
ReportDescription = "პრაისი";
ReportFile = "D:\\User\\Documents\\Projects\\Apothex\\Source\\Class Library\\Apothex.Reporting\\Product" +
"ion\\RptProducLocationPrice.mrt";
ReportGuid = "e242476ffaeb44b39344532841ed84f0";
ReportName = "RptProducLocationPrice";
ReportUnit = StiReportUnitType.Centimeters;
ReportVersion = "2010.3.900";
ScriptLanguage = StiReportLanguageType.CSharp;
//
// Page1
//
Page1 = new StiPage();
Page1.Columns = 2;
Page1.Guid = "0edad2017ef5402da56612e0faa7a32a";
Page1.Name = "Page1";
Page1.PageHeight = 29.7;
Page1.PageWidth = 21;
Page1.PaperSize = PaperKind.A4;
Page1.Border = new StiBorder(StiBorderSides.None, Color.Black, 2, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Page1.Brush = new StiSolidBrush(Color.Transparent);
//
// PageHeaderBand1
//
PageHeaderBand1 = new StiPageHeaderBand();
PageHeaderBand1.ClientRectangle = new RectangleD(0, 0.4, 20, 2.2);
PageHeaderBand1.Name = "PageHeaderBand1";
PageHeaderBand1.PrintOn = StiPrintOnType.OnlyFirstPage;
PageHeaderBand1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
PageHeaderBand1.Brush = new StiSolidBrush(Color.Transparent);
//
// Text4
//
Text4 = new StiText();
Text4.ClientRectangle = new RectangleD(2.4, 0, 7.6, 2);
Text4.Name = "Text4";
Text4.GetValue += new StiGetValueEventHandler(Text4__GetValue);
Text4.VertAlignment = StiVertAlignment.Center;
Text4.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text4.Brush = new StiSolidBrush(Color.Transparent);
Text4.Font = new Font("BPG Glaho Arial", 7F, FontStyle.Bold);
Text4.Guid = null;
Text4.Interaction = null;
Text4.Margins = new StiMargins(0, 0, 0, 0);
Text4.TextBrush = new StiSolidBrush(Color.Black);
Text4.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Image1
//
Image1 = new StiImage();
Image1.AspectRatio = true;
Image1.ClientRectangle = new RectangleD(0, 0, 2, 2);
Image1.Guid = "b4725dd4d92a41f5a0f373916b5b430e";
Image1.HorAlignment = StiHorAlignment.Center;
Image1.Name = "Image1";
Image1.Stretch = true;
Image1.VertAlignment = StiVertAlignment.Center;
Image1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Image1.Brush = new StiSolidBrush(Color.Transparent);
Image1.Image = null;
Image1.Interaction = null;
PageHeaderBand1.Guid = null;
PageHeaderBand1.Interaction = null;
//
// PageFooterBand1
//
PageFooterBand1 = new StiPageFooterBand();
PageFooterBand1.ClientRectangle = new RectangleD(0, 28.1, 20, 0.6);
PageFooterBand1.Name = "PageFooterBand1";
PageFooterBand1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
PageFooterBand1.Brush = new StiSolidBrush(Color.Transparent);
//
// Text3
//
Text3 = new StiText();
Text3.ClientRectangle = new RectangleD(0, 0, 19, 0.6);
Text3.HorAlignment = StiTextHorAlignment.Center;
Text3.Name = "Text3";
Text3.GetValue += new StiGetValueEventHandler(Text3__GetValue);
Text3.VertAlignment = StiVertAlignment.Center;
Text3.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text3.Brush = new StiSolidBrush(Color.Transparent);
Text3.Font = new Font("Arial", 8F);
Text3.Guid = null;
Text3.Interaction = null;
Text3.Margins = new StiMargins(0, 0, 0, 0);
Text3.TextBrush = new StiSolidBrush(Color.Black);
Text3.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
PageFooterBand1.Guid = null;
PageFooterBand1.Interaction = null;
//
// HeaderVW_ProductLocation
//
HeaderVW_ProductLocation = new StiHeaderBand();
HeaderVW_ProductLocation.ClientRectangle = new RectangleD(0, 3.4, 10, 0.6);
HeaderVW_ProductLocation.Name = "HeaderVW_ProductLocation";
HeaderVW_ProductLocation.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderVW_ProductLocation.Brush = new StiSolidBrush(Color.Transparent);
//
// HeaderVW_ProductLocation_MedicamentName
//
HeaderVW_ProductLocation_MedicamentName = new StiText();
HeaderVW_ProductLocation_MedicamentName.ClientRectangle = new RectangleD(0, 0, 5.2, 0.6);
HeaderVW_ProductLocation_MedicamentName.HorAlignment = StiTextHorAlignment.Center;
HeaderVW_ProductLocation_MedicamentName.Name = "HeaderVW_ProductLocation_MedicamentName";
HeaderVW_ProductLocation_MedicamentName.GetValue += new StiGetValueEventHandler(HeaderVW_ProductLocation_MedicamentName__GetValue);
HeaderVW_ProductLocation_MedicamentName.VertAlignment = StiVertAlignment.Center;
HeaderVW_ProductLocation_MedicamentName.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderVW_ProductLocation_MedicamentName.Brush = new StiSolidBrush(Color.Gainsboro);
HeaderVW_ProductLocation_MedicamentName.Font = new Font("BPG Glaho Arial", 7F, FontStyle.Bold);
HeaderVW_ProductLocation_MedicamentName.Guid = null;
HeaderVW_ProductLocation_MedicamentName.Interaction = null;
HeaderVW_ProductLocation_MedicamentName.Margins = new StiMargins(0, 0, 0, 0);
HeaderVW_ProductLocation_MedicamentName.TextBrush = new StiSolidBrush(Color.Black);
HeaderVW_ProductLocation_MedicamentName.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// HeaderVW_ProductLocation_CountryName
//
HeaderVW_ProductLocation_CountryName = new StiText();
HeaderVW_ProductLocation_CountryName.ClientRectangle = new RectangleD(5.2, 0, 2.2, 0.6);
HeaderVW_ProductLocation_CountryName.HorAlignment = StiTextHorAlignment.Center;
HeaderVW_ProductLocation_CountryName.Name = "HeaderVW_ProductLocation_CountryName";
HeaderVW_ProductLocation_CountryName.GetValue += new StiGetValueEventHandler(HeaderVW_ProductLocation_CountryName__GetValue);
HeaderVW_ProductLocation_CountryName.VertAlignment = StiVertAlignment.Center;
HeaderVW_ProductLocation_CountryName.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderVW_ProductLocation_CountryName.Brush = new StiSolidBrush(Color.Gainsboro);
HeaderVW_ProductLocation_CountryName.Font = new Font("BPG Glaho Arial", 7F, FontStyle.Bold);
HeaderVW_ProductLocation_CountryName.Guid = null;
HeaderVW_ProductLocation_CountryName.Interaction = null;
HeaderVW_ProductLocation_CountryName.Margins = new StiMargins(0, 0, 0, 0);
HeaderVW_ProductLocation_CountryName.TextBrush = new StiSolidBrush(Color.Black);
HeaderVW_ProductLocation_CountryName.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// HeaderVW_ProductLocation_ListPrice
//
HeaderVW_ProductLocation_ListPrice = new StiText();
HeaderVW_ProductLocation_ListPrice.ClientRectangle = new RectangleD(9, 0, 1, 0.6);
HeaderVW_ProductLocation_ListPrice.HorAlignment = StiTextHorAlignment.Center;
HeaderVW_ProductLocation_ListPrice.Name = "HeaderVW_ProductLocation_ListPrice";
HeaderVW_ProductLocation_ListPrice.GetValue += new StiGetValueEventHandler(HeaderVW_ProductLocation_ListPrice__GetValue);
HeaderVW_ProductLocation_ListPrice.VertAlignment = StiVertAlignment.Center;
HeaderVW_ProductLocation_ListPrice.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderVW_ProductLocation_ListPrice.Brush = new StiSolidBrush(Color.Gainsboro);
HeaderVW_ProductLocation_ListPrice.Font = new Font("BPG Glaho Arial", 7F, FontStyle.Bold);
HeaderVW_ProductLocation_ListPrice.Guid = null;
HeaderVW_ProductLocation_ListPrice.Interaction = null;
HeaderVW_ProductLocation_ListPrice.Margins = new StiMargins(0, 0, 0, 0);
HeaderVW_ProductLocation_ListPrice.TextBrush = new StiSolidBrush(Color.Black);
HeaderVW_ProductLocation_ListPrice.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text2
//
Text2 = new StiText();
Text2.ClientRectangle = new RectangleD(7.4, 0, 1.6, 0.6);
Text2.Guid = "b2ee6a7204874db4bc1e2bae90edc3a9";
Text2.HorAlignment = StiTextHorAlignment.Center;
Text2.Name = "Text2";
Text2.GetValue += new StiGetValueEventHandler(Text2__GetValue);
Text2.Type = StiSystemTextType.Expression;
Text2.VertAlignment = StiVertAlignment.Center;
Text2.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text2.Brush = new StiSolidBrush(Color.Gainsboro);
Text2.Font = new Font("BPG Glaho Arial", 7F, FontStyle.Bold);
Text2.Interaction = null;
Text2.Margins = new StiMargins(0, 0, 0, 0);
Text2.TextBrush = new StiSolidBrush(Color.Black);
Text2.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
HeaderVW_ProductLocation.Guid = null;
HeaderVW_ProductLocation.Interaction = null;
//
// DataVW_ProductLocation
//
DataVW_ProductLocation = new StiDataBand();
DataVW_ProductLocation.ClientRectangle = new RectangleD(0, 4.8, 10, 0.6);
DataVW_ProductLocation.DataSourceName = "T_Detail";
DataVW_ProductLocation.Name = "DataVW_ProductLocation";
DataVW_ProductLocation.Sort = new[] {
"ASC",
"ProductName"
};
DataVW_ProductLocation.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataVW_ProductLocation.Brush = new StiSolidBrush(Color.Transparent);
DataVW_ProductLocation.BusinessObjectGuid = null;
//
// DataVW_ProductLocation_MedicamentName
//
DataVW_ProductLocation_MedicamentName = new StiText();
DataVW_ProductLocation_MedicamentName.CanGrow = true;
DataVW_ProductLocation_MedicamentName.ClientRectangle = new RectangleD(0, 0, 5.2, 0.6);
DataVW_ProductLocation_MedicamentName.Name = "DataVW_ProductLocation_MedicamentName";
DataVW_ProductLocation_MedicamentName.GetValue += new StiGetValueEventHandler(DataVW_ProductLocation_MedicamentName__GetValue);
DataVW_ProductLocation_MedicamentName.VertAlignment = StiVertAlignment.Center;
DataVW_ProductLocation_MedicamentName.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataVW_ProductLocation_MedicamentName.Brush = new StiSolidBrush(Color.Transparent);
DataVW_ProductLocation_MedicamentName.Font = new Font("BPG Glaho Arial", 6F);
DataVW_ProductLocation_MedicamentName.Guid = null;
DataVW_ProductLocation_MedicamentName.Interaction = null;
DataVW_ProductLocation_MedicamentName.Margins = new StiMargins(0, 0, 0, 0);
DataVW_ProductLocation_MedicamentName.TextBrush = new StiSolidBrush(Color.Black);
DataVW_ProductLocation_MedicamentName.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// DataVW_ProductLocation_CountryName
//
DataVW_ProductLocation_CountryName = new StiText();
DataVW_ProductLocation_CountryName.CanGrow = true;
DataVW_ProductLocation_CountryName.ClientRectangle = new RectangleD(5.2, 0, 2.2, 0.6);
DataVW_ProductLocation_CountryName.HorAlignment = StiTextHorAlignment.Right;
DataVW_ProductLocation_CountryName.Name = "DataVW_ProductLocation_CountryName";
DataVW_ProductLocation_CountryName.GetValue += new StiGetValueEventHandler(DataVW_ProductLocation_CountryName__GetValue);
DataVW_ProductLocation_CountryName.VertAlignment = StiVertAlignment.Center;
DataVW_ProductLocation_CountryName.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataVW_ProductLocation_CountryName.Brush = new StiSolidBrush(Color.Transparent);
DataVW_ProductLocation_CountryName.Font = new Font("BPG Glaho Arial", 6F);
DataVW_ProductLocation_CountryName.Guid = null;
DataVW_ProductLocation_CountryName.Interaction = null;
DataVW_ProductLocation_CountryName.Margins = new StiMargins(0, 0, 0, 0);
DataVW_ProductLocation_CountryName.TextBrush = new StiSolidBrush(Color.Black);
DataVW_ProductLocation_CountryName.TextFormat = new StiPercentageFormatService(0, 0, ",", 4, " ", 3, "%", true, false, " ");
DataVW_ProductLocation_CountryName.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// DataVW_ProductLocation_ListPrice
//
DataVW_ProductLocation_ListPrice = new StiText();
DataVW_ProductLocation_ListPrice.CanGrow = true;
DataVW_ProductLocation_ListPrice.ClientRectangle = new RectangleD(9, 0, 1, 0.6);
DataVW_ProductLocation_ListPrice.HorAlignment = StiTextHorAlignment.Right;
DataVW_ProductLocation_ListPrice.Name = "DataVW_ProductLocation_ListPrice";
DataVW_ProductLocation_ListPrice.GetValue += new StiGetValueEventHandler(DataVW_ProductLocation_ListPrice__GetValue);
DataVW_ProductLocation_ListPrice.VertAlignment = StiVertAlignment.Center;
DataVW_ProductLocation_ListPrice.Border = new StiBorder(StiBorderSides.Right, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataVW_ProductLocation_ListPrice.Brush = new StiSolidBrush(Color.Transparent);
DataVW_ProductLocation_ListPrice.Font = new Font("BPG Glaho Arial", 6F);
DataVW_ProductLocation_ListPrice.Guid = null;
DataVW_ProductLocation_ListPrice.Interaction = null;
DataVW_ProductLocation_ListPrice.Margins = new StiMargins(0, 0, 0, 0);
DataVW_ProductLocation_ListPrice.TextBrush = new StiSolidBrush(Color.Black);
DataVW_ProductLocation_ListPrice.TextFormat = new StiNumberFormatService(1, ",", 2, " ", 3, true, false, " ");
DataVW_ProductLocation_ListPrice.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text1
//
Text1 = new StiText();
Text1.CanGrow = true;
Text1.ClientRectangle = new RectangleD(7.4, 0, 1.6, 0.6);
Text1.Guid = "5cfcbb441d534f4ba95c949ddd2c6da5";
Text1.HorAlignment = StiTextHorAlignment.Right;
Text1.Name = "Text1";
Text1.GetValue += new StiGetValueEventHandler(Text1__GetValue);
Text1.Type = StiSystemTextType.DataColumn;
Text1.VertAlignment = StiVertAlignment.Center;
Text1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text1.Brush = new StiSolidBrush(Color.Transparent);
Text1.Font = new Font("BPG Glaho Arial", 6F);
Text1.Interaction = null;
Text1.Margins = new StiMargins(0, 0, 0, 0);
Text1.TextBrush = new StiSolidBrush(Color.Black);
Text1.TextFormat = new StiPercentageFormatService(0, 0, ",", 2, " ", 3, "%", true, true, " ");
Text1.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
DataVW_ProductLocation.DataRelationName = null;
DataVW_ProductLocation.Guid = null;
DataVW_ProductLocation.Interaction = null;
DataVW_ProductLocation.MasterComponent = null;
Page1.ExcelSheetValue = null;
Page1.Interaction = null;
Page1.Margins = new StiMargins(0.5, 0.5, 0.5, 0.5);
Page1_Watermark = new StiWatermark();
Page1_Watermark.Font = new Font("Arial", 100F);
Page1_Watermark.Image = null;
Page1_Watermark.TextBrush = new StiSolidBrush(Color.FromArgb(50, 0, 0, 0));
Page1.Rendering += new EventHandler(Page1_Rendering);
RptProducLocationPrice_PrinterSettings = new StiPrinterSettings();
PrinterSettings = RptProducLocationPrice_PrinterSettings;
Page1.Report = this;
Page1.Watermark = Page1_Watermark;
PageHeaderBand1.Page = Page1;
PageHeaderBand1.Parent = Page1;
Text4.Page = Page1;
Text4.Parent = PageHeaderBand1;
Image1.Page = Page1;
Image1.Parent = PageHeaderBand1;
PageFooterBand1.Page = Page1;
PageFooterBand1.Parent = Page1;
Text3.Page = Page1;
Text3.Parent = PageFooterBand1;
HeaderVW_ProductLocation.Page = Page1;
HeaderVW_ProductLocation.Parent = Page1;
HeaderVW_ProductLocation_MedicamentName.Page = Page1;
HeaderVW_ProductLocation_MedicamentName.Parent = HeaderVW_ProductLocation;
HeaderVW_ProductLocation_CountryName.Page = Page1;
HeaderVW_ProductLocation_CountryName.Parent = HeaderVW_ProductLocation;
HeaderVW_ProductLocation_ListPrice.Page = Page1;
HeaderVW_ProductLocation_ListPrice.Parent = HeaderVW_ProductLocation;
Text2.Page = Page1;
Text2.Parent = HeaderVW_ProductLocation;
DataVW_ProductLocation.Page = Page1;
DataVW_ProductLocation.Parent = Page1;
DataVW_ProductLocation_MedicamentName.Page = Page1;
DataVW_ProductLocation_MedicamentName.Parent = DataVW_ProductLocation;
DataVW_ProductLocation_CountryName.Page = Page1;
DataVW_ProductLocation_CountryName.Parent = DataVW_ProductLocation;
DataVW_ProductLocation_ListPrice.Page = Page1;
DataVW_ProductLocation_ListPrice.Parent = DataVW_ProductLocation;
Text1.Page = Page1;
Text1.Parent = DataVW_ProductLocation;
EndRender += new EventHandler(RptProducLocationPriceWordsToEnd__EndRender);
//
// Add to PageHeaderBand1.Components
//
PageHeaderBand1.Components.Clear();
PageHeaderBand1.Components.AddRange(new StiComponent[] {
Text4,
Image1
});
//
// Add to PageFooterBand1.Components
//
PageFooterBand1.Components.Clear();
PageFooterBand1.Components.AddRange(new StiComponent[] {
Text3
});
//
// Add to HeaderVW_ProductLocation.Components
//
HeaderVW_ProductLocation.Components.Clear();
HeaderVW_ProductLocation.Components.AddRange(new StiComponent[] {
HeaderVW_ProductLocation_MedicamentName,
HeaderVW_ProductLocation_CountryName,
HeaderVW_ProductLocation_ListPrice,
Text2
});
//
// Add to DataVW_ProductLocation.Components
//
DataVW_ProductLocation.Components.Clear();
DataVW_ProductLocation.Components.AddRange(new StiComponent[] {
DataVW_ProductLocation_MedicamentName,
DataVW_ProductLocation_CountryName,
DataVW_ProductLocation_ListPrice,
Text1
});
//
// Add to Page1.Components
//
Page1.Components.Clear();
Page1.Components.AddRange(new StiComponent[] {
PageHeaderBand1,
PageFooterBand1,
HeaderVW_ProductLocation,
DataVW_ProductLocation
});
//
// Add to Pages
//
Pages.Clear();
Pages.AddRange(new[] {
Page1
});
T_Detail.Columns.AddRange(new[] {
new StiDataColumn("ProductID", "ProductID", "ProductID", typeof(int)),
new StiDataColumn("ProductName", "ProductName", "ProductName", typeof(string)),
new StiDataColumn("CountryName", "CountryName", "CountryName", typeof(string)),
new StiDataColumn("Serie", "Serie", "Serie", typeof(string)),
new StiDataColumn("UnitPrice", "UnitPrice", "UnitPrice", typeof(decimal)),
new StiDataColumn("Discount", "Discount", "Discount", typeof(decimal))
});
DataSources.Add(T_Detail);
}
async private void buttonBuildReport_Click(object sender, Windows.UI.Xaml.RoutedEventArgs e)
{
viewerControl.ShowProgressBar("Create Report...");
StiReport report = new StiReport();
//Add data to datastore
report.RegBusinessObject("Customers", "Customers", new Data().Customers);
//Fill dictionary
report.Dictionary.SynchronizeBusinessObjects();
StiPage page = report.Pages[0];
//Create HeaderBand
var headerBand = new StiHeaderBand();
headerBand.Height = 0.5;
headerBand.Name = "HeaderBand";
page.Components.Add(headerBand);
//Create text on header
var headerText = new StiText(new RectangleD(0, 0, 5, 0.5));
headerText.Text = "CompanyName";
headerText.HorAlignment = StiTextHorAlignment.Center;
headerText.Name = "HeaderText";
headerText.Brush = new StiSolidBrush(Colors.LightGreen);
headerBand.Components.Add(headerText);
//Create Databand
StiDataBand dataBand = new StiDataBand();
dataBand.BusinessObjectGuid = report.Dictionary.BusinessObjects[0].Guid;
dataBand.Height = 0.5;
dataBand.Name = "DataBand";
page.Components.Add(dataBand);
//Create text
StiText dataText = new StiText(new RectangleD(0, 0, 5, 0.5));
dataText.Text = "{Line}.{Customers.CompanyName}";
dataText.Name = "DataText";
dataBand.Components.Add(dataText);
//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, 5, 0.5));
footerText.Text = "Count - {Count()}";
footerText.HorAlignment = StiTextHorAlignment.Right;
footerText.Name = "FooterText";
footerText.Brush = new StiSolidBrush(Colors.LightGreen);
footerBand.Components.Add(footerText);
await report.RenderAsync();
viewerControl.Report = report;
viewerControl.HideProgressBar();
}
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;
}
}
private void butReport_Click(object sender, EventArgs e)
{
if (this.lisEmployeesColumns.Count == 0)
{
MessageBox.Show("هیج ستونی انتخاب نشده است.");
return;
}
EmployeesReport erEmployeesReport = new EmployeesReport();
erEmployeesReport.cnConnection = this.cnConnection;
erEmployeesReport.usUser = this.usUser;
erEmployeesReport.setSettings = this.setSettings;
//Report
StiReport srEmployees = new StiReport();
srEmployees.Pages[0].PaperSize = System.Drawing.Printing.PaperKind.A4;
//MessageBox.Show(srEmployees.Pages[0].PaperSize.ToString());
//srEmployees.
string strSColumnsName = "";
for (int i = 0; i < this.lisEmployeesColumns.Count; i++)
{
if (i != 0)
{
strSColumnsName += ", ";
}
strSColumnsName += this.lisEmployeesColumns[i].strName;
}
//DataBase
StiSqlDatabase dbDataBase1 = new StiSqlDatabase();
dbDataBase1.Alias = "dbDataBase1";
dbDataBase1.Name = "dbDataBase1";
dbDataBase1.ConnectionString = this.cnConnection.strConnectionStringPty;
srEmployees.Dictionary.Databases.Add(dbDataBase1);
//DataSource
StiSqlSource dsDataSource = new StiSqlSource();
dsDataSource.NameInSource = "dbDataBase1";
dsDataSource.Alias = "dsDataSource";
dsDataSource.Name = "dsDataSource";
dsDataSource.SqlCommand = Employee.GetSqlCommand(this.emSearch, strSColumnsName);
for (int i = 0; i < this.lisEmployeesColumns.Count; i++)
{
dsDataSource.Columns.Add(this.lisEmployeesColumns[i].strName, this.lisEmployeesColumns[i].typType);
}
srEmployees.DataSources.Add(dsDataSource);
//HeaderBand
StiHeaderBand headerBand1 = new StiHeaderBand();
headerBand1.Height = 0.5;
headerBand1.Name = "HeaderBand1";
srEmployees.Pages[0].Components.Add(headerBand1);
StiText headerText = new StiText(new RectangleD(5, 0.2, 9.6, 1));
headerText.Text = "کارکنان شرکت " + FamSetting.GetCoInformation(this.cnConnection).strName;
headerText.HorAlignment = StiTextHorAlignment.Center;
headerText.Name = "headerText1";
headerText.Font = new Font("B Titr", 17);
headerText.Brush = new StiSolidBrush(Color.Transparent);
headerBand1.Components.Add(headerText);
//ColumnHeaderBand
StiColumnHeaderBand columnHeaderBand1 = new StiColumnHeaderBand();
columnHeaderBand1.Height = 0.5;
columnHeaderBand1.Name = "columnHeaderBand1";
srEmployees.Pages[0].Components.Add(columnHeaderBand1);
StiText[] stColumnHeaders = new StiText[this.lisEmployeesColumns.Count];
double douX = 19;
for (int i = 0; i < this.lisEmployeesColumns.Count; i++)
{
stColumnHeaders[i] = new StiText(new RectangleD(douX - this.lisEmployeesColumns[i].douWidth, 1, this.lisEmployeesColumns[i].douWidth, 0.8));
stColumnHeaders[i].Text = this.lisEmployeesColumns[i].strCaption;
stColumnHeaders[i].Name = "ch" + this.lisEmployeesColumns[i].strName;
stColumnHeaders[i].Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid);
stColumnHeaders[i].Font = new Font("B Titr", 12);
stColumnHeaders[i].Brush = new StiSolidBrush(Color.Gray);
stColumnHeaders[i].HorAlignment = StiTextHorAlignment.Center;
stColumnHeaders[i].VertAlignment = StiVertAlignment.Center;
columnHeaderBand1.Components.Add(stColumnHeaders[i]);
douX -= this.lisEmployeesColumns[i].douWidth;
}
//DataBand
StiDataBand dataBand1 = new StiDataBand();
dataBand1.DataSourceName = "dsDataSource";
dataBand1.Height = 0.5;
dataBand1.Name = "dataBand1";
srEmployees.Pages[0].Components.Add(dataBand1);
StiText[] stDataText = new StiText[this.lisEmployeesColumns.Count];
douX = 19;
for (int i = 0; i < this.lisEmployeesColumns.Count; i++)
{
stDataText[i] = new StiText(new RectangleD(douX - this.lisEmployeesColumns[i].douWidth, 0, this.lisEmployeesColumns[i].douWidth, 0.6));
stDataText[i].Text = "{dsDataSource." + this.lisEmployeesColumns[i].strName + "}";
stDataText[i].Name = "db" + this.lisEmployeesColumns[i].strName;
stDataText[i].Font = new Font("B Nazanin", 10);
stDataText[i].Brush = new StiSolidBrush(Color.Transparent);
stDataText[i].HorAlignment = StiTextHorAlignment.Center;
stDataText[i].VertAlignment = StiVertAlignment.Center;
stDataText[i].Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid);
dataBand1.Components.Add(stDataText[i]);
douX -= this.lisEmployeesColumns[i].douWidth;
}
//Render
srEmployees.Dictionary.Synchronize();
srEmployees.Compile();
srEmployees.Render(false);
//srEmployees.Save(@"c:\rpt\report3.mrt");
erEmployeesReport.stvEmployees.Report = srEmployees;
erEmployeesReport.ShowDialog();
}
private void buttonCreate_Click(object sender, EventArgs e)
{
var report = new StiReport();
// Add data to datastore
var dataSet = StiJsonToDataSetConverterV2.GetDataSetFromFile(@"Data\Demo.json");
report.RegData(dataSet);
// Fill dictionary
report.Dictionary.Synchronize();
var page = report.Pages[0];
// Create HeaderBand
var headerBand = new StiHeaderBand();
headerBand.Height = 0.5;
headerBand.Name = "HeaderBand";
page.Components.Add(headerBand);
// Create text on header
var headerText = new StiText(new RectangleD(0, 0, 5, 0.5));
headerText.Text = "CompanyName";
headerText.HorAlignment = StiTextHorAlignment.Center;
headerText.Name = "HeaderText";
headerText.Brush = new StiSolidBrush(System.Drawing.Color.LightGreen);
headerBand.Components.Add(headerText);
// Create Databand
var dataBand = new StiDataBand();
dataBand.DataSourceName = "Customers";
dataBand.Height = 0.5;
dataBand.Name = "DataBand";
page.Components.Add(dataBand);
// Create text
var dataText = new StiText(new RectangleD(0, 0, 5, 0.5));
dataText.Text = "{Line}.{Customers.CompanyName}";
dataText.Name = "DataText";
dataBand.Components.Add(dataText);
// Create FooterBand
var footerBand = new StiFooterBand();
footerBand.Height = 0.5;
footerBand.Name = "FooterBand";
page.Components.Add(footerBand);
// Create text on footer
var footerText = new StiText(new RectangleD(0, 0, 5, 0.5));
footerText.Text = "Count - {Count()}";
footerText.HorAlignment = StiTextHorAlignment.Right;
footerText.Name = "FooterText";
footerText.Brush = new StiSolidBrush(System.Drawing.Color.LightGreen);
footerBand.Components.Add(footerText);
report.Show();
}
private void InitializeComponent()
{
VW_Country = new VW_CountryDataSource();
NeedsCompiling = false;
EngineVersion = StiEngineVersion.EngineV2;
ReferencedAssemblies = new[] {
"System.Dll",
"System.Drawing.Dll",
"System.Windows.Forms.Dll",
"System.Data.Dll",
"System.Xml.Dll",
"Stimulsoft.Controls.Dll",
"Stimulsoft.Base.Dll",
"Stimulsoft.Report.Dll"
};
ReportAlias = "Rpt Country";
//
// ReportChanged
//
ReportChanged = new DateTime(2009, 2, 7, 14, 30, 56, 0);
//
// ReportCreated
//
ReportCreated = new DateTime(2008, 9, 2, 21, 7, 22, 0);
ReportFile = "D:\\User\\Documents\\Projects\\Apothex\\Source\\Class Library\\Apothex.Reporting\\Dictionary\\RptCountry.mrt";
ReportGuid = "af5c1e936cdf4e129cbdeae2455e3cea";
ReportName = "RptCountry";
ReportUnit = StiReportUnitType.Centimeters;
ReportVersion = "2008.2.300";
ScriptLanguage = StiReportLanguageType.CSharp;
//
// Page1
//
Page1 = new StiPage();
Page1.ColumnGaps = 1;
Page1.Columns = 2;
Page1.ColumnWidth = 9;
Page1.Guid = "cace94e76442472aa8acc7b42034809c";
Page1.Name = "Page1";
Page1.PageHeight = 29.7;
Page1.PageWidth = 21;
Page1.PaperSize = PaperKind.A4;
Page1.Border = new StiBorder(StiBorderSides.None, Color.Black, 2, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false);
Page1.Brush = new StiSolidBrush(Color.Transparent);
//
// ReportTitle
//
ReportTitle = new StiReportTitleBand();
ReportTitle.ClientRectangle = new RectangleD(0, 0.4, 9, 0.8);
ReportTitle.Name = "ReportTitle";
ReportTitle.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false);
ReportTitle.Brush = new StiSolidBrush(Color.Transparent);
//
// ReportTitleText
//
ReportTitleText = new StiText();
ReportTitleText.ClientRectangle = new RectangleD(0, 0, 19, 0.8);
ReportTitleText.HorAlignment = StiTextHorAlignment.Center;
ReportTitleText.Name = "ReportTitleText";
ReportTitleText.GetValue += new StiGetValueEventHandler(ReportTitleText__GetValue);
ReportTitleText.Type = StiSystemTextType.Expression;
ReportTitleText.VertAlignment = StiVertAlignment.Center;
ReportTitleText.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false);
ReportTitleText.Brush = new StiSolidBrush(Color.Transparent);
ReportTitleText.Font = new Font("BPG Glaho Arial", 12F, FontStyle.Bold);
ReportTitleText.Guid = null;
ReportTitleText.Indicator = null;
ReportTitleText.Interaction = null;
ReportTitleText.Margins = new StiMargins(0, 0, 0, 0);
ReportTitleText.TextBrush = new StiSolidBrush(Color.Black);
ReportTitleText.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
ReportTitle.Guid = null;
ReportTitle.Interaction = null;
//
// Header
//
Header = new StiHeaderBand();
Header.ClientRectangle = new RectangleD(0, 2, 9, 0.8);
Header.Name = "Header";
Header.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false);
Header.Brush = new StiSolidBrush(Color.Transparent);
//
// HeaderText1
//
HeaderText1 = new StiText();
HeaderText1.ClientRectangle = new RectangleD(0, 0, 2, 0.8);
HeaderText1.Name = "HeaderText1";
HeaderText1.GetValue += new StiGetValueEventHandler(HeaderText1__GetValue);
HeaderText1.Type = StiSystemTextType.Expression;
HeaderText1.VertAlignment = StiVertAlignment.Center;
HeaderText1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false);
HeaderText1.Brush = new StiSolidBrush(Color.Transparent);
HeaderText1.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
HeaderText1.Guid = null;
HeaderText1.Indicator = null;
HeaderText1.Interaction = null;
HeaderText1.Margins = new StiMargins(0, 0, 0, 0);
HeaderText1.TextBrush = new StiSolidBrush(Color.Black);
HeaderText1.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// HeaderText2
//
HeaderText2 = new StiText();
HeaderText2.ClientRectangle = new RectangleD(2, 0, 7, 0.8);
HeaderText2.Name = "HeaderText2";
HeaderText2.GetValue += new StiGetValueEventHandler(HeaderText2__GetValue);
HeaderText2.Type = StiSystemTextType.Expression;
HeaderText2.VertAlignment = StiVertAlignment.Center;
HeaderText2.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false);
HeaderText2.Brush = new StiSolidBrush(Color.Transparent);
HeaderText2.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
HeaderText2.Guid = null;
HeaderText2.Indicator = null;
HeaderText2.Interaction = null;
HeaderText2.Margins = new StiMargins(0, 0, 0, 0);
HeaderText2.TextBrush = new StiSolidBrush(Color.Black);
HeaderText2.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
Header.Guid = null;
Header.Interaction = null;
//
// DataVW_Country
//
DataVW_Country = new StiDataBand();
DataVW_Country.ClientRectangle = new RectangleD(0, 3.6, 9, 0.6);
DataVW_Country.DataSourceName = "VW_Country";
DataVW_Country.Name = "DataVW_Country";
DataVW_Country.Sort = new[] {
"ASC",
"CountryCode"
};
DataVW_Country.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false);
DataVW_Country.Brush = new StiSolidBrush(Color.Transparent);
DataVW_Country.BusinessObjectGuid = null;
//
// DataText1
//
DataText1 = new StiText();
DataText1.ClientRectangle = new RectangleD(0, 0, 2, 0.6);
DataText1.GrowToHeight = true;
DataText1.Name = "DataText1";
DataText1.GetValue += new StiGetValueEventHandler(DataText1__GetValue);
DataText1.Type = StiSystemTextType.Expression;
DataText1.VertAlignment = StiVertAlignment.Center;
DataText1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false);
DataText1.Brush = new StiSolidBrush(Color.Transparent);
DataText1.Font = new Font("BPG Glaho Arial", 10F);
DataText1.Guid = null;
DataText1.Indicator = null;
DataText1.Interaction = null;
DataText1.Margins = new StiMargins(0, 0, 0, 0);
DataText1.TextBrush = new StiSolidBrush(Color.Black);
DataText1.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// DataText2
//
DataText2 = new StiText();
DataText2.CanGrow = true;
DataText2.ClientRectangle = new RectangleD(2, 0, 7, 0.6);
DataText2.Name = "DataText2";
DataText2.GetValue += new StiGetValueEventHandler(DataText2__GetValue);
DataText2.Type = StiSystemTextType.Expression;
DataText2.VertAlignment = StiVertAlignment.Center;
DataText2.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false);
DataText2.Brush = new StiSolidBrush(Color.Transparent);
DataText2.Font = new Font("BPG Glaho Arial", 10F);
DataText2.Guid = null;
DataText2.Indicator = null;
DataText2.Interaction = null;
DataText2.Margins = new StiMargins(0, 0, 0, 0);
DataText2.TextBrush = new StiSolidBrush(Color.Black);
DataText2.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
DataVW_Country.Guid = null;
DataVW_Country.Interaction = null;
DataVW_Country.MasterComponent = null;
//
// Footer
//
Footer = new StiFooterBand();
Footer.ClientRectangle = new RectangleD(0, 5, 9, 0.6);
Footer.Name = "Footer";
Footer.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false);
Footer.Brush = new StiSolidBrush(Color.Transparent);
Footer.Guid = null;
Footer.Interaction = null;
Page1.ExcelSheetValue = null;
Page1.Interaction = null;
Page1.Margins = new StiMargins(1, 1, 1, 1);
Page1_Watermark = new StiWatermark();
Page1_Watermark.Font = new Font("Arial", 100F);
Page1_Watermark.Image = null;
Page1_Watermark.TextBrush = new StiSolidBrush(Color.FromArgb(50, 0, 0, 0));
RptCountry_PrinterSettings = new StiPrinterSettings();
PrinterSettings = RptCountry_PrinterSettings;
Page1.Report = this;
Page1.Watermark = Page1_Watermark;
ReportTitle.Page = Page1;
ReportTitle.Parent = Page1;
ReportTitleText.Page = Page1;
ReportTitleText.Parent = ReportTitle;
Header.Page = Page1;
Header.Parent = Page1;
HeaderText1.Page = Page1;
HeaderText1.Parent = Header;
HeaderText2.Page = Page1;
HeaderText2.Parent = Header;
DataVW_Country.Page = Page1;
DataVW_Country.Parent = Page1;
DataText1.Page = Page1;
DataText1.Parent = DataVW_Country;
DataText2.Page = Page1;
DataText2.Parent = DataVW_Country;
Footer.Page = Page1;
Footer.Parent = Page1;
//
// Add to ReportTitle.Components
//
ReportTitle.Components.Clear();
ReportTitle.Components.AddRange(new StiComponent[] {
ReportTitleText
});
//
// Add to Header.Components
//
Header.Components.Clear();
Header.Components.AddRange(new StiComponent[] {
HeaderText1,
HeaderText2
});
//
// Add to DataVW_Country.Components
//
DataVW_Country.Components.Clear();
DataVW_Country.Components.AddRange(new StiComponent[] {
DataText1,
DataText2
});
//
// Add to Page1.Components
//
Page1.Components.Clear();
Page1.Components.AddRange(new StiComponent[] {
ReportTitle,
Header,
DataVW_Country,
Footer
});
//
// Add to Pages
//
Pages.Clear();
Pages.AddRange(new[] {
Page1
});
VW_Country.Columns.AddRange(new[] {
new StiDataColumn("Approver", "Approver", "Approver", typeof(string)),
new StiDataColumn("ApproverUserID", "ApproverUserID", "ApproverUserID", typeof(int)),
new StiDataColumn("CountryCode", "CountryCode", "CountryCode", typeof(string)),
new StiDataColumn("ModifiedDate", "ModifiedDate", "ModifiedDate", typeof(DateTime)),
new StiDataColumn("ModifiedUserID", "ModifiedUserID", "ModifiedUserID", typeof(int)),
new StiDataColumn("Modifier", "Modifier", "Modifier", typeof(string)),
new StiDataColumn("Name", "Name", "Name", typeof(string)),
new StiDataColumn("Status", "Status", "Status", typeof(byte))
});
DataSources.Add(VW_Country);
}
private void Button_Click(object sender, RoutedEventArgs e)
{
StiReport report = new StiReport();
//Add data to datastore
report.RegData(dataSet1);
//Fill dictionary
report.Dictionary.Synchronize();
StiPage page = report.Pages[0];
//Create HeaderBand
StiHeaderBand headerBand = new StiHeaderBand();
headerBand.Height = 0.5;
headerBand.Name = "HeaderBand";
page.Components.Add(headerBand);
//Create text on header
StiText headerText = new StiText(new RectangleD(0, 0, 5, 0.5));
headerText.Text = "CompanyName";
headerText.HorAlignment = StiTextHorAlignment.Center;
headerText.Name = "HeaderText";
headerText.Brush = new StiSolidBrush(System.Drawing.Color.LightGreen);
headerBand.Components.Add(headerText);
//Create Databand
StiDataBand dataBand = new StiDataBand();
dataBand.DataSourceName = "Customers";
dataBand.Height = 0.5;
dataBand.Name = "DataBand";
page.Components.Add(dataBand);
//Create text
StiText dataText = new StiText(new RectangleD(0, 0, 5, 0.5));
dataText.Text = "{Line}.{Customers.CompanyName}";
dataText.Name = "DataText";
dataBand.Components.Add(dataText);
//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, 5, 0.5));
footerText.Text = "Count - {Count()}";
footerText.HorAlignment = StiTextHorAlignment.Right;
footerText.Name = "FooterText";
footerText.Brush = new StiSolidBrush(System.Drawing.Color.LightGreen);
footerBand.Components.Add(footerText);
report.ShowWithWpf();
}
private void ShowReport()
{
StiReport report = new StiReport();
float columnsWidth = 0;
DataTable table = new DataTable("ReportData");
for (int i = 0; i < dgvList.Columns.Count; i++)
{
table.Columns.Add(dgvList.Columns[i].Name, dgvList.Columns[i].ValueType);
columnsWidth += dgvList.Columns[i].Width;
}
for (int i = 0; i < dgvList.Rows.Count; i++)
{
DataRow row = table.NewRow();
for (int j = 0; j < dgvList.Columns.Count; j++)
{
row[dgvList.Columns[j].Name] = dgvList[j, i].Value;
}
table.Rows.Add(row);
}
report.RegData(table);
report.Dictionary.Synchronize();
StiPage page = report.Pages[0];
StiReportTitleBand titleBand = new StiReportTitleBand();
titleBand.Height = 1.0;
titleBand.Name = "TitleBand";
page.Components.Add(titleBand);
StiText titleText = new StiText(new RectangleD(0, 0, page.Width, 1));
titleText.Name = "TitleText";
titleText.Text = Text + " " + pickPlan.Value.ToShortDateString();
titleText.Width = page.Width;
titleText.HorAlignment = StiTextHorAlignment.Center;
titleText.Font = new Font("Arial", 10);
titleBand.Components.Add(titleText);
//Create HeaderBand
StiHeaderBand headerBand = new StiHeaderBand();
headerBand.Height = 0.5;
headerBand.Name = "HeaderBand";
page.Components.Add(headerBand);
float bandWidth = (float)page.Width;
float multiplier = bandWidth / columnsWidth;
float previousWidth = 0;
//Create text on header
for (int i = 0; i < dgvList.Columns.Count; i++)
{
StiText headerText = new StiText(new RectangleD(previousWidth, 0, dgvList.Columns[i].Width * multiplier, 0.5));
headerText.Text = dgvList.Columns[i].HeaderText;
headerText.HorAlignment = StiTextHorAlignment.Center;
headerText.Name = "HeaderText" + i.ToString();
headerText.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid);
headerText.Brush = new StiSolidBrush(Color.LightGreen);
headerBand.Components.Add(headerText);
previousWidth += dgvList.Columns[i].Width * multiplier;
}
//Create Databand
StiDataBand dataBand = new StiDataBand();
dataBand.DataSourceName = "ReportData";
dataBand.Height = 0.5;
dataBand.Name = "DataBand";
page.Components.Add(dataBand);
previousWidth = 0;
//Create text
for (int i = 0; i < dgvList.Columns.Count; i++)
{
RectangleD rectangle = new RectangleD(previousWidth, 0, dgvList.Columns[i].Width * multiplier, 1);
StiText dataText = new StiText(rectangle);
dataText.Format = dgvList.Columns[i].DefaultCellStyle.Format;
dataText.Text = "{ReportData." + dgvList.Columns[i].Name + "}";
dataText.Name = "DataText" + i.ToString();
dataText.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid);
dataBand.Components.Add(dataText);
previousWidth += dgvList.Columns[i].Width * multiplier;
}
//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, 5, 0.5));
footerText.Text = "Всего - {Count()} строк";
footerText.HorAlignment = StiTextHorAlignment.Right;
footerText.Name = "FooterText";
footerText.Brush = new StiSolidBrush(Color.LightGreen);
footerBand.Components.Add(footerText);
report.Save("D:\\report.mrt");
report.Show();
}
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();
}
private void print_Click(object sender, EventArgs e)
{
StiReport report = new StiReport();
report.ScriptLanguage = StiReportLanguageType.CSharp;
//Add data to datastore
report.RegData("MyList", model);
//Fill dictionary
report.Dictionary.Synchronize();
StiPage page = report.Pages.Items[0];
page.Orientation = StiPageOrientation.Landscape;
//Create HeaderBand
StiHeaderBand headerBand = new StiHeaderBand();
headerBand.Name = "HeaderBand";
page.Components.Add(headerBand);
//Create Dataaband
StiDataBand dataBand = new StiDataBand();
dataBand.DataSourceName = "MyList";
dataBand.Height = 0.5f;
dataBand.Name = "DataBand";
page.Components.Add(dataBand);
StiDataSource dataSource = report.Dictionary.DataSources[0];
//Create texts
Double pos = 0;
Double columnWidth = StiAlignValue.AlignToMinGrid((page.Width * 3 * 1.1) / 44, 0.1, true);
Double AddressWidth = StiAlignValue.AlignToMinGrid((page.Width) / 4, 0.1, true);
int nameIndex = 1;
foreach (StiDataColumn column in dataSource.Columns)
{
if (column.Name == "mantagheName" || column.Name == "Senn" || column.Name == "_ID" || column.Name == "_Current" || column.Name == "checkbox" || column.Name == "codegrid" || column.Name == "datetime" || column.Name == "Address1" || column.Name == "Address2" || column.Name == "Address3")
{
continue;
}
//Create text on header
StiText headerText = null;
if (column.Name == "Address")
{
headerText = new StiText(new RectangleD(pos, 0, AddressWidth, 0.5f));
}
else
{
headerText = new StiText(new RectangleD(pos, 0, columnWidth, 0.5f));
}
headerText.WordWrap = false;
string val = bringPersionName(column.Name);
headerText.Text.Value = val;//
headerText.HorAlignment = StiTextHorAlignment.Center;
headerText.VertAlignment = StiVertAlignment.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 = null;
if (column.Name == "Address")
{
dataText = new StiText(new RectangleD(pos, 0, AddressWidth, 0.5f));
}
else
{
dataText = new StiText(new RectangleD(pos, 0, columnWidth, 0.5f));
}
dataText.WordWrap = false;
if (column.Name != "Address" || column.Name != "phones")
{
dataText.HorAlignment = StiTextHorAlignment.Center;
}
dataText.VertAlignment = StiVertAlignment.Center;
dataText.Text.Value = "{MyList." + column.Name + "}";
dataText.Name = "DataText" + nameIndex.ToString();
dataText.Border.Side = StiBorderSides.All;
dataText.RightToLeft = true;
//Add highlight
//dataText.HighlightCondition.Brush = new StiSolidBrush(Color.CornflowerBlue);
//dataText.HighlightCondition.TextBrush = new StiSolidBrush(Color.Black);
//dataText.HighlightCondition.Condition.Value = "(Line & 1) == 1";
//uncomment this line for VB.Net
//dataText.HighlightCondition.Condition.Value = "(Line And 1) = 1";
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();
//For checking created report you can uncomment this line
//report.Design();
}
private void StimulsoftWindow_OnLoaded(object sender, RoutedEventArgs e)
{
StiReport report = new StiReport();
// Add data to datastore
report.RegData(DataTable);
// Fill dictionary
report.Dictionary.Synchronize();
var page = report.Pages[0];
//Create HeaderBand
var headerBand = new StiHeaderBand {
Height = 0.5, Name = "HeaderBand"
};
page.Components.Add(headerBand);
//Create Databand
var dataBand = new StiDataBand
{
DataSourceName = "result",
Height = 0.5,
Name = "DataBand"
};
page.Components.Add(dataBand);
var width = page.Width / DataTable.Columns.Count;
foreach (DataColumn column in DataTable.Columns)
{
//Create text on header
var headerText = new StiText(new RectangleD(0, 0, width, 0.5))
{
Text = column.ColumnName,
HorAlignment = StiTextHorAlignment.Center,
Brush = new StiSolidBrush(Color.Gainsboro),
Dockable = true,
DockStyle = StiDockStyle.Left,
CanShrink = true,
CanGrow = true,
VertAlignment = StiVertAlignment.Center
};
headerBand.Components.Add(headerText);
//Create text
var dataText = new StiText(new RectangleD(0, 0, width, 0.5))
{
Text = "{result." + column.ColumnName + "}",
Dockable = true,
DockStyle = StiDockStyle.Left,
VertAlignment = StiVertAlignment.Center,
CanShrink = true,
CanGrow = true,
};
dataBand.Components.Add(dataText);
}
Viewer.Report = report;
report.Compile();
report.Render(true);
}
private void InitializeComponent()
{
VW_Product = new VW_ProductDataSource();
NeedsCompiling = false;
EngineVersion = StiEngineVersion.EngineV2;
ReferencedAssemblies = new[] {
"System.Dll",
"System.Drawing.Dll",
"System.Windows.Forms.Dll",
"System.Data.Dll",
"System.Xml.Dll",
"Stimulsoft.Controls.Dll",
"Stimulsoft.Base.Dll",
"Stimulsoft.Report.Dll"
};
ReportAlias = "Rpt Product Bar Code";
//
// ReportChanged
//
ReportChanged = new DateTime(2009, 6, 8, 10, 23, 13, 687);
//
// ReportCreated
//
ReportCreated = new DateTime(2009, 3, 24, 21, 40, 37, 0);
ReportGuid = "17d6a2b4761540d58d5510314b329565";
ReportName = "RptProductBarCode";
ReportUnit = StiReportUnitType.Centimeters;
ScriptLanguage = StiReportLanguageType.CSharp;
//
// Page1
//
Page1 = new StiPage();
Page1.Columns = 2;
Page1.Guid = "53d0355db4644f9d9ba6c964bafb28f0";
Page1.Name = "Page1";
Page1.Orientation = StiPageOrientation.Landscape;
Page1.PageHeight = 21;
Page1.PageWidth = 29.7;
Page1.Border = new StiBorder(StiBorderSides.None, Color.Black, 2, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Page1.Brush = new StiSolidBrush(Color.Transparent);
//
// HeaderVW_Product
//
HeaderVW_Product = new StiHeaderBand();
HeaderVW_Product.ClientRectangle = new RectangleD(0, 0.4, 13.85, 0.8);
HeaderVW_Product.Name = "HeaderVW_Product";
HeaderVW_Product.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderVW_Product.Brush = new StiSolidBrush(Color.Transparent);
//
// HeaderVW_Product_MedicamentName
//
HeaderVW_Product_MedicamentName = new StiText();
HeaderVW_Product_MedicamentName.ClientRectangle = new RectangleD(0, 0, 6.8, 0.8);
HeaderVW_Product_MedicamentName.Name = "HeaderVW_Product_MedicamentName";
HeaderVW_Product_MedicamentName.GetValue += new StiGetValueEventHandler(HeaderVW_Product_MedicamentName__GetValue);
HeaderVW_Product_MedicamentName.Type = StiSystemTextType.Expression;
HeaderVW_Product_MedicamentName.VertAlignment = StiVertAlignment.Center;
HeaderVW_Product_MedicamentName.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderVW_Product_MedicamentName.Brush = new StiSolidBrush(Color.Transparent);
HeaderVW_Product_MedicamentName.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
HeaderVW_Product_MedicamentName.Guid = null;
HeaderVW_Product_MedicamentName.Interaction = null;
HeaderVW_Product_MedicamentName.Margins = new StiMargins(0, 0, 0, 0);
HeaderVW_Product_MedicamentName.TextBrush = new StiSolidBrush(Color.Black);
HeaderVW_Product_MedicamentName.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text1
//
Text1 = new StiText();
Text1.ClientRectangle = new RectangleD(6.8, 0, 7, 0.8);
Text1.Name = "Text1";
Text1.GetValue += new StiGetValueEventHandler(Text1__GetValue);
Text1.Type = StiSystemTextType.Expression;
Text1.VertAlignment = StiVertAlignment.Center;
Text1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text1.Brush = new StiSolidBrush(Color.Transparent);
Text1.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
Text1.Guid = null;
Text1.Interaction = null;
Text1.Margins = new StiMargins(0, 0, 0, 0);
Text1.TextBrush = new StiSolidBrush(Color.Black);
Text1.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
HeaderVW_Product.Guid = null;
HeaderVW_Product.Interaction = null;
//
// DataVW_Product
//
DataVW_Product = new StiDataBand();
DataVW_Product.ClientRectangle = new RectangleD(0, 2, 13.85, 2);
DataVW_Product.DataSourceName = "VW_Product";
DataVW_Product.Name = "DataVW_Product";
DataVW_Product.Sort = new String[0];
DataVW_Product.Border = new StiBorder(StiBorderSides.All, Color.Black, 0.5, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataVW_Product.Brush = new StiSolidBrush(Color.Transparent);
//
// DataVW_Product_ProductID
//
DataVW_Product_ProductID = new StiText();
DataVW_Product_ProductID.CanGrow = true;
DataVW_Product_ProductID.ClientRectangle = new RectangleD(0, 0, 6.6, 2);
DataVW_Product_ProductID.GrowToHeight = true;
DataVW_Product_ProductID.Name = "DataVW_Product_ProductID";
DataVW_Product_ProductID.GetValue += new StiGetValueEventHandler(DataVW_Product_ProductID__GetValue);
DataVW_Product_ProductID.Type = StiSystemTextType.Expression;
DataVW_Product_ProductID.VertAlignment = StiVertAlignment.Center;
DataVW_Product_ProductID.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataVW_Product_ProductID.Brush = new StiSolidBrush(Color.Transparent);
DataVW_Product_ProductID.Font = new Font("BPG Glaho Arial", 8F);
DataVW_Product_ProductID.Guid = null;
DataVW_Product_ProductID.Interaction = null;
DataVW_Product_ProductID.Margins = new StiMargins(0, 0, 0, 0);
DataVW_Product_ProductID.TextBrush = new StiSolidBrush(Color.Black);
DataVW_Product_ProductID.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// BarCode1
//
BarCode1 = new StiBarCode();
BarCode1.BackColor = Color.White;
BarCode1.ClientRectangle = new RectangleD(6.8, 0, 7, 2);
BarCode1.GetBarCode += new StiValueEventHandler(BarCode1__GetBarCode);
BarCode1.ForeColor = Color.Black;
BarCode1.Name = "BarCode1";
BarCode1.VertAlignment = StiVertAlignment.Center;
BarCode1.BarCodeType = new StiEAN128aBarCodeType(13F, 1F);
BarCode1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Dot, false, 4, new StiSolidBrush(Color.Black));
BarCode1.Font = new Font("Arial", 8F, FontStyle.Bold, GraphicsUnit.Pixel);
BarCode1.Guid = null;
BarCode1.Interaction = null;
DataVW_Product.Guid = null;
DataVW_Product.Interaction = null;
DataVW_Product.MasterComponent = null;
//
// FooterVW_Product
//
FooterVW_Product = new StiFooterBand();
FooterVW_Product.ClientRectangle = new RectangleD(0, 4.8, 13.85, 0.8);
FooterVW_Product.Name = "FooterVW_Product";
FooterVW_Product.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
FooterVW_Product.Brush = new StiSolidBrush(Color.Transparent);
FooterVW_Product.Guid = null;
FooterVW_Product.Interaction = null;
Page1.ExcelSheetValue = null;
Page1.Interaction = null;
Page1.Margins = new StiMargins(1, 1, 1, 1);
Page1_Watermark = new StiWatermark();
Page1_Watermark.Font = new Font("Arial", 100F);
Page1_Watermark.Image = null;
Page1_Watermark.TextBrush = new StiSolidBrush(Color.FromArgb(50, 0, 0, 0));
RptProductBarCode_PrinterSettings = new StiPrinterSettings();
PrinterSettings = RptProductBarCode_PrinterSettings;
Page1.Page = Page1;
Page1.Report = this;
Page1.Watermark = Page1_Watermark;
HeaderVW_Product.Page = Page1;
HeaderVW_Product.Parent = Page1;
HeaderVW_Product_MedicamentName.Page = Page1;
HeaderVW_Product_MedicamentName.Parent = HeaderVW_Product;
Text1.Page = Page1;
Text1.Parent = HeaderVW_Product;
DataVW_Product.Page = Page1;
DataVW_Product.Parent = Page1;
DataVW_Product_ProductID.Page = Page1;
DataVW_Product_ProductID.Parent = DataVW_Product;
BarCode1.Page = Page1;
BarCode1.Parent = DataVW_Product;
FooterVW_Product.Page = Page1;
FooterVW_Product.Parent = Page1;
//
// Add to HeaderVW_Product.Components
//
HeaderVW_Product.Components.Clear();
HeaderVW_Product.Components.AddRange(new StiComponent[] {
HeaderVW_Product_MedicamentName,
Text1
});
//
// Add to DataVW_Product.Components
//
DataVW_Product.Components.Clear();
DataVW_Product.Components.AddRange(new StiComponent[] {
DataVW_Product_ProductID,
BarCode1
});
//
// Add to Page1.Components
//
Page1.Components.Clear();
Page1.Components.AddRange(new StiComponent[] {
HeaderVW_Product,
DataVW_Product,
FooterVW_Product
});
//
// Add to Pages
//
Pages.Clear();
Pages.AddRange(new[] {
Page1
});
VW_Product.Columns.AddRange(new[] {
new StiDataColumn("ProductID", "ProductID", "ProductID", typeof(int)),
new StiDataColumn("PurchaseOrderDetailID", "PurchaseOrderDetailID", "PurchaseOrderDetailID", typeof(Guid)),
new StiDataColumn("MedicamentCategoryID", "MedicamentCategoryID", "MedicamentCategoryID", typeof(int)),
new StiDataColumn("MedicamentCategoryName", "MedicamentCategoryName", "MedicamentCategoryName", typeof(string)),
new StiDataColumn("MedicamentSubcategoryID", "MedicamentSubcategoryID", "MedicamentSubcategoryID", typeof(int)),
new StiDataColumn("MedicamentSubcategoryName", "MedicamentSubcategoryName", "MedicamentSubcategoryName", typeof(string)),
new StiDataColumn("MedicamentID", "MedicamentID", "MedicamentID", typeof(int)),
new StiDataColumn("MedicamentName", "MedicamentName", "MedicamentName", typeof(string)),
new StiDataColumn("Serie", "Serie", "Serie", typeof(string)),
new StiDataColumn("PurchaseUnitPriceCU", "PurchaseUnitPriceCU", "PurchaseUnitPriceCU", typeof(decimal)),
new StiDataColumn("SaleUnitPriceCU", "SaleUnitPriceCU", "SaleUnitPriceCU", typeof(decimal)),
new StiDataColumn("Quantity", "Quantity", "Quantity", typeof(decimal)),
new StiDataColumn("UnitsInStock", "UnitsInStock", "UnitsInStock", typeof(decimal)),
new StiDataColumn("FinishedGoodsFlag", "FinishedGoodsFlag", "FinishedGoodsFlag", typeof(bool)),
new StiDataColumn("SafetyStockLevel", "SafetyStockLevel", "SafetyStockLevel", typeof(short)),
new StiDataColumn("ValidDate", "ValidDate", "ValidDate", typeof(DateTime)),
new StiDataColumn("Color", "Color", "Color", typeof(string)),
new StiDataColumn("CountryCode", "CountryCode", "CountryCode", typeof(string)),
new StiDataColumn("CountryName", "CountryName", "CountryName", typeof(string)),
new StiDataColumn("Size", "Size", "Size", typeof(string)),
new StiDataColumn("SizeUnitMeasureCode", "SizeUnitMeasureCode", "SizeUnitMeasureCode", typeof(string)),
new StiDataColumn("Weight", "Weight", "Weight", typeof(decimal)),
new StiDataColumn("WeightUnitMeasureCode", "WeightUnitMeasureCode", "WeightUnitMeasureCode", typeof(string)),
new StiDataColumn("Class", "Class", "Class", typeof(string)),
new StiDataColumn("Style", "Style", "Style", typeof(string)),
new StiDataColumn("SellStartDate", "SellStartDate", "SellStartDate", typeof(DateTime)),
new StiDataColumn("SellEndDate", "SellEndDate", "SellEndDate", typeof(DateTime)),
new StiDataColumn("DiscontinuedDate", "DiscontinuedDate", "DiscontinuedDate", typeof(DateTime)),
new StiDataColumn("Status", "Status", "Status", typeof(byte)),
new StiDataColumn("ModifiedUserID", "ModifiedUserID", "ModifiedUserID", typeof(int)),
new StiDataColumn("Modifier", "Modifier", "Modifier", typeof(string)),
new StiDataColumn("ModifiedDate", "ModifiedDate", "ModifiedDate", typeof(DateTime)),
new StiDataColumn("PurchaseUnitPrice", "PurchaseUnitPrice", "PurchaseUnitPrice", typeof(decimal)),
new StiDataColumn("SaleUnitPrice", "SaleUnitPrice", "SaleUnitPrice", typeof(decimal)),
new StiDataColumn("Action", "Action", "Action", typeof(int))
});
DataSources.Add(VW_Product);
}
