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 void ReadLabel(XRLabel xtraControl, StiContainer parent)
{
StiText text = new StiText();
parent.Components.Add(text);
ReadComp(xtraControl, text);
text.Angle = xtraControl.Angle;
text.AutoWidth = xtraControl.AutoWidth;
ReadBrush(xtraControl, text);
ReadTextBrush(xtraControl, text);
ReadBorder(xtraControl, text);
ReadFont(xtraControl, text);
ReadTextAlignment(xtraControl, text);
text.WordWrap = xtraControl.WordWrap;
#region ProcessDuplicates
switch (xtraControl.ProcessDuplicates)
{
case ValueSuppressType.Leave:
text.ProcessingDuplicates = StiProcessingDuplicatesType.None;
break;
case ValueSuppressType.Suppress:
text.ProcessingDuplicates = StiProcessingDuplicatesType.Hide;
break;
case ValueSuppressType.SuppressAndShrink:
text.ProcessingDuplicates = StiProcessingDuplicatesType.Merge;
break;
}
#endregion
#region ProcessNullValues
text.HideZeros = xtraControl.ProcessNullValues == ValueSuppressType.Suppress || xtraControl.ProcessNullValues == ValueSuppressType.SuppressAndShrink;
#endregion
text.Text.Value = xtraControl.Text;
foreach (XRBinding bind in xtraControl.DataBindings)
{
switch (bind.PropertyName)
{
case "Text":
text.Text.Value = "{" + ParseExpression(bind.DataMember) + "}";
break;
case "Bookmark":
text.Bookmark.Value = "{" + ParseExpression(bind.DataMember) + "}";
break;
case "Hyperlink":
text.Hyperlink.Value = "{" + ParseExpression(bind.DataMember) + "}";
break;
}
}
}
private static void AddPageHeader(ref StiPage page, ref StiText headerText)
{
#region Header
//Create TitleBand
StiPageHeaderBand pageHeaderBand = new StiPageHeaderBand();
pageHeaderBand.Height = 0.5;
pageHeaderBand.Name = "pageHeaderBand";
pageHeaderBand.Enabled = true;
page.Components.Add(pageHeaderBand);
//Create Title text on header
headerText.Text = DateTime.Now.ToString(); // Common.Date.GetGregorianDate(currentDateTime, Common.Date.DateStringType.Short);
headerText.Height = 0.5;
headerText.HorAlignment = StiTextHorAlignment.Right;
headerText.Name = "TitleHeader";
//headerText.Font = new System.Drawing.Font("Nazanin", 12F);
pageHeaderBand.Components.Add(headerText);
// Create Title text on header
StiText pageNumberText = new StiText(new RectangleD(0, 0, page.Width, 0.5));
headerText.Height = 0.5;
pageNumberText.Text = "{PageNumber}" + "-" + "{TotalPageCount}";
pageNumberText.HorAlignment = StiTextHorAlignment.Left;
pageNumberText.Name = "pageNumberText";
//headerText.Font = new System.Drawing.Font("Nazanin", 12F);
pageHeaderBand.Components.Add(pageNumberText);
#endregion
}
public void SetLabelBottom3(StiProperties P, string Text, StiProperties generalProp = null)
{
LabelBottom3 = new StiText();
LabelBottom3.ClientRectangle = P.RectangleD; //new RectangleD(144.94, 0.9, 17.02, 5.08)
LabelBottom3.HorAlignment = P.TextHorAlignment;
LabelBottom3.Name = "LabelBottom3";
LabelBottom3.Text = Text != null ? Text : LabelBottom3.Text.Value;
LabelBottom3.VertAlignment = P.TextVertAlignment;
LabelBottom3.Border = new StiBorder(StiBorderSides.None, Color.Black,
1, StiPenStyle.Solid);
LabelBottom3.Brush = new StiSolidBrush(Color.Transparent);
LabelBottom3.Font = P.Font != null
? P.Font
: new Font("B Nazanin", 9.75F, FontStyle.Bold,
GraphicsUnit.Point, 178);
LabelBottom3.Guid = Guid.NewGuid().ToString();
LabelBottom3.Margins =
P.Margins != null ? P.Margins : new StiMargins(0, 0, 0, 0);
LabelBottom3.TextBrush = P.ForeColor != null
? P.ForeColor
: new StiSolidBrush(Color.Black);
LabelBottom3.TextOptions = P.TextOptions != null
? P.TextOptions
: new StiTextOptions(true, false, false, 0F,
System.Drawing.Text.HotkeyPrefix.None, StringTrimming.None);
LabelBottom3.Enabled = true;
}
public IActionResult GetReport()
{
var report = new StiReport();
//Load and add font to the resources
var fileContent = System.IO.File.ReadAllBytes(StiNetCoreHelper.MapPath(this, "Fonts/Roboto-Black.ttf"));
var resource = new StiResource("Roboto-Black", "Roboto-Black", false, StiResourceType.FontTtf, fileContent, false);
report.Dictionary.Resources.Add(resource);
//Add resource font to the font collection
StiFontCollection.AddResourceFont(resource.Name, resource.Content, "ttf", resource.Alias);
//Create a text component
var dataText = new StiText();
dataText.ClientRectangle = new RectangleD(1, 1, 3, 2);
dataText.Text = "Sample Text";
dataText.Font = StiFontCollection.CreateFont("Roboto-Black", 12, FontStyle.Regular);
dataText.Border.Side = StiBorderSides.All;
report.Pages[0].Components.Add(dataText);
return(StiNetCoreDesigner.GetReportResult(this, report));
}
public static StiReport ShowReportList(List <DraftModel> draftModels)
{
var mainReport = new StiReport();
mainReport.Load(Application.StartupPath + "\\ReportList.mrt");
DraftCrud draftCrud = new DraftCrud();
List <draftReportObj> data = new List <draftReportObj>();
int SumOfValue = 0;
foreach (var item in draftModels)
{
draftReportObj itemrr = new draftReportObj();
string finalCarTage = CartTagFunc(item.CarTag);
itemrr.DraftReports = " کامیون " + getTrucksType().Where(z => z.ID == Int32.Parse(item.TruckID)).FirstOrDefault().Name + " به شماره پلاک " + finalCarTage + " جهت حمل " + item.TypeID + " به مقدار " + item.Value + "تن،از مبدا " + item.Origin + " به مقصد " + item.Destination + " به شماره " + item.Number + " تاریخ " + item.Date;
data.Add(itemrr);
SumOfValue += item.Value;
}
mainReport.RegBusinessObject("DraftReports", data);
StiText Part1 = new StiText();
Part1 = (StiText)mainReport.GetComponentByName("TxtSumValue");
Part1.Text = "مجموع کل حواله ها برابر با " + SumOfValue + " تن است";
return(mainReport);
}
private void bindReport(string singleprojectid)
{
BLL.T_SingleProject_BLL spBLL = new T_SingleProject_BLL();
Model.T_SingleProject_MDL spMDL = spBLL.GetModel(Common.ConvertEx.ToInt(singleprojectid));
string strWhere = "SingleProjectID=" + singleprojectid;
if (Common.Session.GetSession("SuperAdmin").ToLower() == "true" || Common.Session.GetSession("IsCompany") == false.ToString().ToLower())
{//Leo 超级管理员看全部
}
else if (spMDL != null && spMDL.CompanyUserID == Common.ConvertEx.ToInt(Common.Session.GetSession("UserID")))
{//Leo 工程管理员也看全部,档案馆的人也可以看全部
}
else
{
strWhere += " and operateuserid=" + Common.Session.GetSession("UserID");
}
DataSet dsarchive = new DataSet();
//Leo 要改
//dsarchive = (new T_FileList_BLL()).GetClientList(strWhere);
dsarchive = (new T_FileList_BLL()).GetList(strWhere);
Recursion(dsarchive.Tables[0], 0, 0);
string str_gcmc = "归档目录";
BLL.T_SingleProject_BLL singproject = new T_SingleProject_BLL();
DataSet dssingleproject = singproject.GetList("singleprojectid=" + singleprojectid);
if (dssingleproject.Tables[0].Rows.Count > 0)
{
str_gcmc = dssingleproject.Tables[0].Rows[0]["gcmc"].ToString() + "归档目录列表";
}
// //取报表文件和打印数据
// DigiPower.Onlinecol.Standard.BLL.Record record = new DigiPower.Onlinecol.Standard.BLL.Record();
// DataSet ds = new DataSet();
string strReport = Server.MapPath(@"../ReportTemplate/20100409001.mrt");
StiReport report = new StiReport();
report.Load(strReport);
report.RegData("报表", dsarchive);
//获取工程
StiText sti_gcmc = (StiText)report.GetComponentByName("txtGCMC");
if (sti_gcmc != null)
{
sti_gcmc.Text = str_gcmc; //动态设置制表单位
}
// if (_printType == "1" || _printType == "2" || _printType == "5")
// StiReportResponse.ResponseAsPdf(this, report, false);
// else
report.Compile();
report.Render(false);
StiWebViewer1.Report = report;
}
public void DoFill()
{
if (m_dataTable == null || m_fieldPrefix == null || m_fieldPrefix.Length <= 0)
{
return;
}
if (m_dataTable.Columns.Count < m_fieldPrefix.Length + 1)
{
return;
}
string strColName;
for (int j = 0; j < m_dataTable.Rows.Count; j++)
{
//先取索引
StiRow sr = m_dataTable.Rows[j];
strColName = m_dataTable.Columns[0].Name;
string strIndex = sr[strColName].ToString();
//赋值
for (int i = 1; i <= m_fieldPrefix.Length; i++)
{
strColName = m_dataTable.Columns[i].Name;
string strValue = sr[strColName] == null ? "" : sr[strColName].ToString(); //数据集中取出值
StiText st = (StiText)ReportScript.ReflectVar(m_container, m_fieldPrefix[i - 1] + strIndex); //用反射取得StiText控件
if (st != null)
{
st.TextValue = strValue;
}
}
}
}
private void LoadParameters()
{
if (IsFormPrint)
{
StiText Pt = (StiText)Rp.GetComponentByName("ProjectTitle");
Pt.Text = Commons.CompanyName;
StiText Rt = (StiText)Rp.GetComponentByName("RpTitle");
Rt.Text = Messages.ReportTitle + ReportTitle;
StiText Pd = (StiText)Rp.GetComponentByName("PersianDate");
Pd.Text = "تاریخ: " + Commons.GetCurrentPersianDate();
StiText Thm = (StiText)Rp.GetComponentByName("TimeHM");
Thm.Text = "ساعت: " + DateTime.Now.Hour.ToString("00") + ":" + DateTime.Now.Minute.ToString("00");
}
if (IsBillPrint)
{
StiText Wn = (StiText)Rp.GetComponentByName("WaterAndWastewaterAuthorityName");
Wn.Text = Commons.WaterAndWastewaterAuthorityName;
StiText Wn2 = (StiText)Rp.GetComponentByName("WaterAndWastewaterAuthorityName2");
Wn2.Text = Commons.WaterAndWastewaterAuthorityName;
StiText Bm = (StiText)Rp.GetComponentByName("BillMessage");
Bm.Text = Commons.BillMessage;
StiText Ad = (StiText)Rp.GetComponentByName("Address");
Ad.Text = Commons.Address;
StiText Tl = (StiText)Rp.GetComponentByName("Tel");
Tl.Text = Commons.Tel;
StiText Cd = (StiText)Rp.GetComponentByName("CurrentDate");
Cd.Text = Commons.GetCurrentPersianDate();
StiText Pr = (StiText)Rp.GetComponentByName("Period");
Pr.Text = Commons.GetShortPeriodName(Commons.CPeriod.DateFrom, Commons.CPeriod.DateTo);
StiText Cy = (StiText)Rp.GetComponentByName("CurrentYear");
Cy.Text = Commons.CurrentYear.ToString();
StiText Dpd = (StiText)Rp.GetComponentByName("DeadLinePaymentDate");
Dpd.Text = Commons.GetDeadLinePaymentDate();
}
}
private void ReadCheckBox(XRCheckBox xtraControl, StiContainer parent)
{
#region Read CheckBox
StiCheckBox check = new StiCheckBox();
parent.Components.Add(check);
ReadComp(xtraControl, check);
ReadBrush(xtraControl, check);
ReadTextBrush(xtraControl, check);
ReadBorder(xtraControl, check);
ReadFont(xtraControl, check);
check.Width = check.Height;
#endregion
#region Read Text
StiText text = new StiText();
parent.Components.Add(text);
ReadComp(xtraControl, text);
text.Name += "_Text";
text.Left += check.Width;
text.Width -= check.Width;
ReadBrush(xtraControl, text);
ReadTextBrush(xtraControl, text);
ReadBorder(xtraControl, text);
ReadFont(xtraControl, text);
ReadTextAlignment(xtraControl, text);
text.Text.Value = xtraControl.Text;
#endregion
}
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
}
public bool AddTextToCol(int col, StiText stiTxt)
{
if (col > m_txtCount - 1 || col < 0)
{
return(false);
}
(m_txtCtrls[(int)col]).Add(stiTxt);
return(true);
}
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 DrawTitleB(StiContainer content, DateTime startDate, DateTime endDate, double dynamicWidth)
{
double left = 0, top = 0, basicHeight = .2;
var border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid);
var artistText = new StiText(new RectangleD(left, top, 1.2, basicHeight))
{
Text = "作家",
Font = new Font("Meiryo", 6),
Border = border,
HorAlignment = StiTextHorAlignment.Center,
VertAlignment = StiVertAlignment.Center
};
content.Components.Add(artistText);
left += 1.2;
for (var date = startDate; date.Date <= endDate.Date; date = date.AddDays(1))
{
var dateText = new StiText(new RectangleD(left, top, dynamicWidth * 3, basicHeight))
{
Text = date.ToString(Constants.ExactMonthDayFormatJP),
Font = new Font("Meiryo", 6),
Border = border,
HorAlignment = StiTextHorAlignment.Center,
VertAlignment = StiVertAlignment.Center
};
content.Components.Add(dateText);
left += dateText.Width;
}
var totalOfContractArtist = new StiText(new RectangleD(left, top, .6, basicHeight))
{
Text = "本数",
Font = new Font("Meiryo", 6),
Border = border,
HorAlignment = StiTextHorAlignment.Center,
VertAlignment = StiVertAlignment.Center
};
content.Components.Add(totalOfContractArtist);
left += .6;
var subTotalArtist = new StiText(new RectangleD(left, top, 1.1, basicHeight))
{
Text = "小計",
Font = new Font("Meiryo", 6),
Border = border,
HorAlignment = StiTextHorAlignment.Center,
VertAlignment = StiVertAlignment.Center
};
content.Components.Add(subTotalArtist);
}
internal static object PrepareVariableValue(StiVariable var, StiReport report, StiText textBox = null)
{
if (textBox == null)
{
textBox = new StiText
{
Name = "**ReportVariables**",
Page = report.Pages[0]
};
}
object obj = null;
if (var.Type.IsValueType || var.Type == typeof(string))
{
if (var.InitBy == StiVariableInitBy.Value)
{
obj = var.ValueObject;
}
else
{
obj = StiVisualFoxProParser.ParseTextValue("{" + var.Value + "}", textBox);
}
}
else
{
obj = Activator.CreateInstance(var.Type);
if (obj is Range)
{
var range = obj as Range;
if (var.InitBy == StiVariableInitBy.Value)
{
range.FromObject = (var.ValueObject as Range).FromObject;
range.ToObject = (var.ValueObject as Range).ToObject;
}
else
{
range.FromObject = StiVisualFoxProParser.ParseTextValue("{" + var.InitByExpressionFrom + "}", textBox);
range.ToObject = StiVisualFoxProParser.ParseTextValue("{" + var.InitByExpressionTo + "}", textBox);
}
}
}
//store calculated value in variables hash
report[var.Name] = obj;
return(obj);
}
internal static void CheckForDataBandsUsedInPageTotals(StiText stiText)
{
try
{
StiReport report = stiText.Report;
bool storeToPrint = false;
object result = ParseTextValue(stiText.Text.Value, stiText, ref storeToPrint, false, true);
}
catch (Exception ex)
{
string str = string.Format("Expression in Text property of '{0}' can't be evaluated! {1}", stiText.Name, ex.Message);
StiLogService.Write(stiText.GetType(), str);
StiLogService.Write(stiText.GetType(), ex.Message);
stiText.Report.WriteToReportRenderingMessages(str);
}
}
public ActionResult FromLoadFileReport()
{
var formValues = StiMvcViewer.GetFormValues(this.HttpContext);
CarModels cm = new CarModels();
if (formValues.Count != 0)
{
cm.Vin = formValues.GetValues("vin").GetValue(0).ToString();
}
else
{
cm.Vin = "NAS0";
}
try
{
Qccastt qccastt = new Qccastt();
qccastt.Vin = cm.GetVin();
DataSet dsCardInfo = new DataSet();
if (!string.IsNullOrEmpty(cm.Vin))
{
Object[] obj = null;
dsCardInfo = QccasttUtility.GetCarDefect(qccastt, out obj);
dsCardInfo.Tables[0].TableName = "CarDefects";
}
StiReport report = new StiReport();
report.Load(Server.MapPath("/Content/ReportsFile/QCCard2.mrt"));
StiText stitxtVin = (StiText)report.GetComponentByName("txtVin");
stitxtVin.Text = cm.GetVin();
// BCVin
StiBarCode stiBCVin = (StiBarCode)report.GetComponentByName("BCVin");
stiBCVin.Code = new StiBarCodeExpression(cm.GetVin());
//report.RegBusinessObject("driverReport", dsCardInfo.Tables[0]);
//int i = dsCardInfo.Tables[0].Rows.Count;
//report.Compile();
report.RegData(dsCardInfo);
return(StiMvcViewer.GetReportSnapshotResult(HttpContext, report));
}
catch (Exception ex)
{
// lblVinMessage.Text = "خطا در دریافت اطلاعات";
return(View());
}
}
private string ConvertExpression(string input, StiComponent comp)
{
if (comp == null)
{
comp = new StiText();
comp.Name = "*TextBox*";
comp.Page = report.Pages[0];
}
var storeToPrint = false;
//object aa = StiVisualFoxProParser.ParseTextValue(input, comp, comp, ref storeToPrint, false, true);
object aa = StiVisualFoxProParser.ParseTextValue(input, comp, comp, ref storeToPrint, false);
if (aa != null)
{
return(aa.ToString());
}
return(input);
}
public static StiReport ShowReport(int ID)
{
var stiReportResearcher = new StiReport();
DraftCrud draftCrud = new DraftCrud();
var findedDraft = draftCrud.findDraftByID(ID);
stiReportResearcher = new StiReport();
stiReportResearcher.Load(Application.StartupPath + "\\Report.mrt");
StiText Part1 = new StiText();
Part1 = (StiText)stiReportResearcher.GetComponentByName("Part1");
Part1.Text = "مدیریت محترم : " + findedDraft.Origin;
StiText txtDate = new StiText();
txtDate = (StiText)stiReportResearcher.GetComponentByName("txtDate");
txtDate.Text = "تاریخ : " + findedDraft.Date;
StiText txtNumber = new StiText();
txtNumber = (StiText)stiReportResearcher.GetComponentByName("txtNumber");
txtNumber.Text = "شماره گزارش : " + findedDraft.Number;
StiText Part2 = new StiText();
Part2 = (StiText)stiReportResearcher.GetComponentByName("Part2");
string carrTag = findedDraft.CarTag;
string finalCarTag = CartTagFunc(carrTag);
Part2.Text = " کامیون " + getTrucksType().Where(z => z.ID == Int32.Parse(findedDraft.TruckID)).FirstOrDefault().Name + " به شماره پلاک " + finalCarTag + " به رانندگی " + findedDraft.Driver + " شماره گواهینامه " + findedDraft.CertificateDriver + " جهت حمل " + findedDraft.TypeID + " به مقدار " + findedDraft.Value + " تن به مقصد " + findedDraft.Destination + " حضورتان معرفی میگردد";
return(stiReportResearcher);
}
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()
{
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);
}
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();
}
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 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();
}
public PageTextProperties(IPageHeaderTextBox builder, StiPageHeaderBand band, StiText currentText) : base(currentText)
{
_builder = builder;
_band = band;
}
internal static StiText CreateHeaderStiText(string name, string s, double x, double y, double width, double height)
{
StiText text = new StiText(new RectangleD(x, y, width, height), s) {
Name = name,
VertAlignment = StiVertAlignment.Center,
HorAlignment = StiTextHorAlignment.Center,
Border = new StiBorder(StiBorderSides.All, (System.Drawing.Color) System.Drawing.Color.Black, 1.0, StiPenStyle.Solid, false, 4.0, new StiSolidBrush((System.Drawing.Color) System.Drawing.Color.Black))
};
text.TextOptions.WordWrap = true;
text.Font = (System.Drawing.Font) new System.Drawing.Font("Arial", 10f, System.Drawing.FontStyle.Bold);
text.Editable = true;
return text;
}
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);
}
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();
}
internal static void AddStitexts(StiText headerText, StiText dataText, ref StiReportTitleBand titleBand, ref StiDataBand dataBand, ref double x, double width)
{
titleBand.Components.Add(headerText);
dataBand.Components.Add(dataText);
x = (double) (x + width);
}
internal static StiText CreateDataStiText(string name, string s, bool align_center, double x, double y, double width, double height)
{
StiText text = new StiText(new RectangleD(x, y, width, height), s) {
Name = name,
VertAlignment = StiVertAlignment.Center,
HorAlignment = StiTextHorAlignment.Center,
Border = new StiBorder(StiBorderSides.All, (System.Drawing.Color) System.Drawing.Color.Black, 1.0, StiPenStyle.Solid, false, 4.0, new StiSolidBrush((System.Drawing.Color) System.Drawing.Color.Black))
};
text.TextOptions.WordWrap = true;
text.VertAlignment = StiVertAlignment.Center;
text.HorAlignment = align_center ? StiTextHorAlignment.Center : StiTextHorAlignment.Left;
return text;
}
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 void AddPage(StiPage page, DataTable dataTable)
{
#region Page Parameters
page.TitleBeforeHeader = true;
page.Orientation = StiPageOrientation.Landscape;
//log.OpenNode("Page Parameters");
//log.CloseNode();
#endregion
#region Components
//log.OpenNode("Page Components");
#region First pass
bands = new List <StiBand>();
bandsTop = new List <double>();
foreach (DataRow dr in dataTable.Rows)
{
dataRow = dr;
ObjType objType = (ObjType)GetInt("OBJTYPE");
int objCode = GetInt("OBJCODE");
double height = GetDouble("HEIGHT");
double width = GetDouble("WIDTH");
switch (objType)
{
case ObjType.Bandinfo:
var band = TypeBand(objCode);
band.Height = fru(height);
page.Components.Add(band);
bands.Add(band);
bandsTop.Add(((bandsTop.Count == 0) ? 0 : bandsTop[bandsTop.Count - 1]) + height + headerHeight);
break;
case ObjType.Variable:
var variable = new StiVariable();
variable.Name = GetString("NAME");
variable.Alias = variable.Name;
variable.InitBy = StiVariableInitBy.Expression;
variable.Value = GetString("EXPR");
variable.Type = typeof(object);
variable.RequestFromUser = true;
page.Report.Dictionary.Variables.Add(variable);
break;
}
}
#endregion
#region Second pass
foreach (DataRow dr in dataTable.Rows)
{
dataRow = dr;
ObjType objType = (ObjType)GetInt("OBJTYPE");
int objCode = GetInt("OBJCODE");
double height = GetDouble("HEIGHT");
double width = GetDouble("WIDTH");
switch (objType)
{
case ObjType.Label:
var stiText5 = new StiText();
AddToBandAndGetCommonProperties(stiText5);
stiText5.TextBrush = new StiSolidBrush(GetPenColor());
stiText5.Brush = GetFillBrush();
string stiText5Expr = GetString("EXPR");
stiText5.Text = stiText5Expr.Substring(1, stiText5Expr.Length - 2);
stiText5.Font = GetFont();
break;
case ObjType.Field:
var stiText8 = new StiText();
AddToBandAndGetCommonProperties(stiText8);
stiText8.TextBrush = new StiSolidBrush(GetPenColor());
stiText8.Brush = GetFillBrush();
stiText8.Text = ConvertExpression("{" + GetString("EXPR") + "}", stiText8);
stiText8.Font = GetFont();
#region TextFormat
string fillChar = GetString("FILLCHAR");
if (fillChar == "N")
{
StiNumberFormatService format = new StiNumberFormatService();
string picture = GetString("PICTURE");
if (!string.IsNullOrEmpty(picture))
{
int pos = picture.IndexOf(".");
if (pos == -1)
{
format.DecimalDigits = 0;
}
else
{
format.DecimalDigits = picture.Substring(pos + 1).Length;
}
}
stiText8.TextFormat = format;
}
if (fillChar == "D")
{
StiDateFormatService format = new StiDateFormatService();
stiText8.TextFormat = format;
}
#endregion
#region Alignment
int alignment = GetInt("OFFSET");
if (alignment == 1)
{
stiText8.HorAlignment = StiTextHorAlignment.Right;
}
if (alignment == 2)
{
stiText8.HorAlignment = StiTextHorAlignment.Center;
}
#endregion
break;
case ObjType.Line:
StiLinePrimitive line = null;
if (width > height)
{
line = new StiHorizontalLinePrimitive();
}
else
{
line = new StiVerticalLinePrimitive();
}
AddToBandAndGetCommonProperties(line);
line.Color = GetPenColor();
line.Style = GetPenStyle();
line.Size = GetPenSize();
break;
case ObjType.RectangleOrShape:
//проверять - если есть заливка - то надо Shape
StiRectanglePrimitive rectangle = null;
int offset = GetInt("OFFSET");
if (offset == 0)
{
rectangle = new StiRectanglePrimitive();
}
else
{
rectangle = new StiRoundedRectanglePrimitive();
(rectangle as StiRoundedRectanglePrimitive).Round = offset;
}
AddToBandAndGetCommonProperties(rectangle);
rectangle.Color = GetPenColor();
rectangle.Style = GetPenStyle();
rectangle.Size = GetPenSize();
break;
case ObjType.PictureOrOle:
var image = new StiImage();
AddToBandAndGetCommonProperties(image);
int sourceType = GetInt("OFFSET");
if (sourceType == 0)
{
image.ImageURL.Value = GetString("PICTURE").Trim();
}
if (sourceType == 1)
{
image.DataColumn = ConvertExpression("{" + GetString("NAME").Trim() + "}", image);
}
if (sourceType == 2)
{
string imageName = GetString("NAME").Trim();
if (imageName.StartsWith("(") && imageName.EndsWith(")"))
{
imageName = imageName.Substring(1, imageName.Length - 2);
}
image.ImageData = new StiImageDataExpression(ConvertExpression("{" + imageName + "}", image));
}
break;
case ObjType.Variable:
var variable = new StiVariable();
variable.Name = GetString("NAME");
variable.Alias = variable.Name;
variable.InitBy = StiVariableInitBy.Expression;
string varValue = ConvertExpression("{" + GetString("EXPR") + "}", null);
variable.Value = varValue.Substring(1, varValue.Length - 2);
variable.Type = typeof(object);
variable.RequestFromUser = true;
page.Report.Dictionary.Variables.Add(variable);
break;
case ObjType.Bandinfo:
case ObjType.Font:
//none, skip
break;
default:
//log.WriteNode(string.Format("Unsupported OBJTYPE={0}", objType));
break;
}
}
#endregion
//log.CloseNode();
#endregion
page.DockToContainer();
page.Correct();
}
public static StiReport GenerateReportFromDataTable(System.Data.DataTable dataTable, string reportHeader, StiPageOrientation orientation)
{
if ((dataTable == null) || (dataTable.Rows.get_Count() == 0))
{
throw new System.ApplicationException("Не сформирован входящий набор данных.");
}
StiReport report = new StiReport();
report.RegData("data", (System.Data.DataTable) dataTable);
report.Dictionary.Synchronize();
report.Dictionary.DataSources[0].Name = "data";
report.Dictionary.DataSources[0].Alias = "data";
StiReportTitleBand titleBand = new StiReportTitleBand {
Height = 2.0,
Name = "TitleBand"
};
StiText component = new StiText(new RectangleD(0.0, 0.0, 30.0, 1.0), reportHeader) {
DockStyle = StiDockStyle.Top,
HorAlignment = StiTextHorAlignment.Center,
Name = "TextHeader",
Font = (System.Drawing.Font) new System.Drawing.Font("Arial", 12f, System.Drawing.FontStyle.Regular),
Editable = true
};
titleBand.Components.Add(component);
StiDataBand dataBand = new StiDataBand {
DataSourceName = "data",
Height = 1.0,
Name = "DataBand"
};
double x = 0.0;
double y = 0.0;
double height = 1.0;
System.Data.DataView view = new System.Data.DataView(dataTable);
view.set_Sort("OrderColumn");
int num4 = 0;
foreach (System.Data.DataRow row in view.ToTable("OutputTable").Rows)
{
if (System.Convert.ToBoolean(row.get_Item("PrintColumn")))
{
double width = System.Convert.ToDouble(row.get_Item("WidthColumn"));
component = CreateHeaderStiText("TextHeader" + ((int) num4), row.get_Item("HeaderColumn").ToString(), x, 1.0, width, 1.0);
StiText dataText = CreateDataStiText("TextData" + ((int) num4), row.get_Item("DataColumn").ToString(), System.Convert.ToBoolean(row.get_Item("AlignColumn")), x, y, width, height);
AddStitexts(component, dataText, ref titleBand, ref dataBand, ref x, width);
}
num4 = (int) (num4 + 1);
}
report.Pages[0].Components.Add(titleBand);
report.Pages[0].Components.Add(dataBand);
report.Pages[0].Orientation = orientation;
report.Pages[0].Margins = new StiMargins(0.5, 0.5, 0.5, 0.5);
return report;
}
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();
}
