public static void GenerateNewReport(DataTable tbl, string path, string caption) { StiReport report = new StiReport(); //Add tbl to datastore report.RegData("tbl", tbl); //Fill dictionary report.Dictionary.Synchronize(); report.Dictionary.DataSources[0].Name = "tbl"; report.Dictionary.DataSources[0].Alias = "tbl"; //StiPage page = report.Pages[0]; foreach (StiPage page in report.Pages) { //Create header if (report.Pages.IndexOf(page) == 0) { StiText header = new StiText(new RectangleD(0, 0, page.Width, page.Height / 20), caption); StiText period = new StiText(new RectangleD(0, page.Height / 20, page.Width, page.Height / 20), tbl.TableName); header.HorAlignment = StiTextHorAlignment.Center; header.Font = new Font("Arial", 22.5f); period.HorAlignment = StiTextHorAlignment.Center; header.Font = new Font("Arial", 12f); page.Components.Add(header); page.Components.Add(period); header.Render(); period.Render(); } //Create HeaderBand StiHeaderBand headerBand = new StiHeaderBand(); headerBand.Height = 0.5; headerBand.Name = "HeaderBand"; page.Components.Add(headerBand); //Create Databand StiDataBand dataBand = new StiDataBand(); dataBand.DataSourceName = "tbl"; dataBand.Height = 0.5; dataBand.Name = "DataBand"; page.Components.Add(dataBand); //Create texts double pos = 0; double columnWidth = StiAlignValue.AlignToMinGrid(page.Width / tbl.Columns.Count, 0.1, true); int nameIndex = 1; foreach (DataColumn dataColumn in tbl.Columns) { //Create text on header StiText headerText = new StiText(new RectangleD(pos, page.Height / 10, columnWidth, 0.5)); headerText.Text.Value = dataColumn.Caption; headerText.HorAlignment = StiTextHorAlignment.Center; headerText.Name = "HeaderText" + nameIndex.ToString(); headerText.Brush = new StiSolidBrush(Color.LightGray); headerText.Border.Side = StiBorderSides.All; headerBand.Components.Add(headerText); //Create text on Data Band StiText dataText = new StiText(new RectangleD(pos, 0, columnWidth, 0.5)); dataText.Text.Value = "{tbl." + Stimulsoft.Report.CodeDom.StiCodeDomSerializator.ReplaceSymbols(dataColumn.ColumnName) + "}"; dataText.Name = "DataText" + nameIndex.ToString(); dataText.Border.Side = StiBorderSides.All; //Add highlight StiCondition condition = new StiCondition(); condition.BackColor = Color.DarkGray; condition.TextColor = Color.Black; condition.Expression = "(Line & 1) == 1"; condition.Item = StiFilterItem.Expression; dataText.Conditions.Add(condition); dataBand.Components.Add(dataText); pos = pos + columnWidth; nameIndex++; } //Create FooterBand StiFooterBand footerBand = new StiFooterBand(); footerBand.Height = 0.5; footerBand.Name = "FooterBand"; page.Components.Add(footerBand); //Create text on footer StiText footerText = new StiText(new RectangleD(0, 0, page.Width, 0.5)); footerText.Text.Value = "Всего записей - {Count()}"; footerText.HorAlignment = StiTextHorAlignment.Right; footerText.Name = "FooterText"; footerText.Brush = new StiSolidBrush(Color.Gray); footerBand.Components.Add(footerText); report.Show(); } }
public IReportBuilder WithFooterBand(List <string> titles, double[] sizes, List <TextAlign> aligns = null, double height = 0.3) { CurrentFooter = new StiFooterBand(MakeRectangle(0, 0, 0, height)); Page.Components.Add(CurrentFooter); var x = 0.0; for (var i = 0; i < titles.Count; i++) { var align = TextAlign.Right; if (aligns != null) { align = aligns[i]; } var stiText = _textBuilder.New(titles[i]).WithFormat(MakeFormat(titles[i])).WithPosition(x).WithSize(sizes[i]) .WithAlign((StiTextHorAlignment)align).WithFont(FontStyle.Bold).Then(); x += sizes[i]; CurrentFooter.Components.Add(stiText); } CurrentFooter.BeforePrintEvent = new StiBeforePrintEvent("Xdec=Xdec+1;"); CurrentFooter.AfterPrintEvent = new StiAfterPrintEvent("Xdec=Xdec+1;"); var xdec = _textBuilder.New("{Xdec}").WithPosition(0.2, 0.2).WithSize(2).WithAlign(StiTextHorAlignment.Center) .WithFont(FontStyle.Bold, 18).Then(); CurrentFooter.Components.Add(xdec); return(this); }
private void ReadPageFooterBand(XtraReportBase xtraReport, PageFooterBand xtraBand, StiPage page) { StiFooterBand band = new StiFooterBand(); band.PrintOnAllPages = true; page.Components.Add(band); ReadBand(xtraBand, band); }
private void ReadDataFooterBand(XmlNode node, StiPage page, StiBand masterBand) { StiFooterBand band = new StiFooterBand(); page.Components.Add(band); ReadBand(node, band); band.KeepFooterTogether = ReadBool(node, "KeepWithData", band, false); }
private void ReadReportFooterBand(XtraReportBase xtraReport, ReportFooterBand xtraBand, StiPage page) { StiBand band = null; if (detailLevel == 0) { band = new StiReportSummaryBand(); } else { band = new StiFooterBand(); (band as StiFooterBand).PrintOnAllPages = false; } page.Components.Add(band); ReadBand(xtraBand, band); }
protected override bool WfExecReport(Stimulsoft.Report.StiReport pReport) { //DataSet ds; vw_stpr500 stpr500Model; StringBuilder sbSql = null; DataTable dtSeaTb, dtSebTb; List <QueryInfo> queryInfoList; QueryInfo queryModel; string strQueryRange, strWhere; StringBuilder sbQuerySingle = null; List <SqlParameter> sqlParmList; try { if (Vw_Stpr500 != null) //他窗引用時 { stpr500Model = Vw_Stpr500; } else { stpr500Model = DrMaster.ToItem <vw_stpr500>(); } queryInfoList = new List <QueryInfo>(); #region range 處理 if (!GlobalFn.varIsNull(stpr500Model.sha01)) { queryModel = new QueryInfo(); queryModel.TableName = "sha_tb"; queryModel.ColumnName = "sha01"; queryModel.ColumnType = TabMaster.DtSource.Columns["sha01"].DataType.Name; queryModel.Value = stpr500Model.sha01; queryInfoList.Add(queryModel); } if (!GlobalFn.varIsNull(stpr500Model.sha03)) { queryModel = new QueryInfo(); queryModel.TableName = "sha_tb"; queryModel.ColumnName = "sha03"; queryModel.ColumnType = TabMaster.DtSource.Columns["sha03"].DataType.Name; queryModel.Value = stpr500Model.sha03; queryInfoList.Add(queryModel); } sqlParmList = new List <SqlParameter>(); strQueryRange = BoMaster.WfGetQueryString(queryInfoList, out sqlParmList); #endregion #region single 處理 sbQuerySingle = new StringBuilder(); if (!GlobalFn.varIsNull(stpr500Model.sha02_s)) { sbQuerySingle.AppendLine("AND sha02>=@sha02_s"); sqlParmList.Add(new SqlParameter("@sha02_s", stpr500Model.sha02_s)); } if (!GlobalFn.varIsNull(stpr500Model.sha02_e)) { sbQuerySingle.AppendLine("AND sha02<=@sha02_e"); sqlParmList.Add(new SqlParameter("@sha02_e", stpr500Model.sha02_e)); } #endregion strWhere = strQueryRange + " " + sbQuerySingle.ToString(); var strSecurity = WfGetSecurityString(); //取得權限字串 if (!GlobalFn.varIsNull(strSecurity)) { strWhere += strSecurity; } //取得單頭 sbSql = new StringBuilder(); sbSql.AppendLine("SELECT sha_tb.*,"); sbSql.AppendLine(" sca03 AS sha03_c,"); sbSql.AppendLine(" bec02 AS sha04_c,"); sbSql.AppendLine(" beb02 AS sha05_c,"); sbSql.AppendLine(" bab02 AS sha01_c,"); sbSql.AppendLine(" bea04,"); sbSql.AppendLine(" bea05,"); sbSql.AppendLine(" bea06"); sbSql.AppendLine("FROM sha_tb"); sbSql.AppendLine(" LEFT JOIN sca_tb ON sha03=sca01"); sbSql.AppendLine(" LEFT JOIN bec_tb ON sha04=bec01"); sbSql.AppendLine(" LEFT JOIN beb_tb ON sha05=beb01"); sbSql.AppendLine(" LEFT JOIN baa_tb ON 1=1"); sbSql.AppendLine(" LEFT JOIN bab_tb ON substring(sha01,1,baa06)=bab01"); sbSql.AppendLine(" LEFT JOIN bea_tb ON beacomp=shacomp"); sbSql.AppendLine("WHERE 1=1"); sbSql.AppendLine(" AND shaconf='Y'"); dtSeaTb = BoMaster.OfGetDataTable(string.Concat(sbSql.ToString(), strWhere), sqlParmList.ToArray()); dtSeaTb.TableName = "Master"; if (dtSeaTb == null || dtSeaTb.Rows.Count == 0) { WfShowErrorMsg("查無資料,請重新過濾條件!"); return(false); } //取得明細 sbSql = new StringBuilder(); sbSql.AppendLine("SELECT * FROM shb_tb"); sbSql.AppendLine("WHERE EXISTS("); sbSql.AppendLine(" SELECT 1 FROM sha_tb"); sbSql.AppendLine(" WHERE sha01=shb01"); sbSql.AppendLine(strWhere); sbSql.AppendLine(")"); dtSebTb = BoMaster.OfGetDataTable(sbSql.ToString(), sqlParmList.ToArray()); dtSebTb.TableName = "Detail"; pReport.RegData(dtSeaTb); pReport.RegData(dtSebTb); pReport.CacheAllData = true; //處理排序 StiDataBand stiDataBand1 = (StiDataBand)pReport.GetComponents()["DataBand1"]; switch (stpr500Model.order_by) { case "1": //1.依出貨日期 stiDataBand1.Sort = new string[] { "ASC", "sha02" }; break; case "2": //2.依客戶 stiDataBand1.Sort = new string[] { "ASC", "sha03" }; break; } //處理跳頁 StiFooterBand footerBand1 = (StiFooterBand)pReport.GetComponents()["FooterBand1"]; if (stpr500Model.jump_yn.ToUpper() == "Y") { footerBand1.NewPageAfter = true; footerBand1.ResetPageNumber = true; } else { footerBand1.NewPageAfter = false; footerBand1.ResetPageNumber = false; } //pReport.Compile(); return(true); } catch (Exception ex) { throw ex; } }
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(); }
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 buttonCreate_Click(object sender, EventArgs e) { var report = new StiReport(); // Add data to datastore var dataSet = StiJsonToDataSetConverterV2.GetDataSetFromFile(@"Data\Demo.json"); report.RegData(dataSet); // Fill dictionary report.Dictionary.Synchronize(); var page = report.Pages[0]; // Create HeaderBand var headerBand = new StiHeaderBand(); headerBand.Height = 0.5; headerBand.Name = "HeaderBand"; page.Components.Add(headerBand); // Create text on header var headerText = new StiText(new RectangleD(0, 0, 5, 0.5)); headerText.Text = "CompanyName"; headerText.HorAlignment = StiTextHorAlignment.Center; headerText.Name = "HeaderText"; headerText.Brush = new StiSolidBrush(System.Drawing.Color.LightGreen); headerBand.Components.Add(headerText); // Create Databand var dataBand = new StiDataBand(); dataBand.DataSourceName = "Customers"; dataBand.Height = 0.5; dataBand.Name = "DataBand"; page.Components.Add(dataBand); // Create text var dataText = new StiText(new RectangleD(0, 0, 5, 0.5)); dataText.Text = "{Line}.{Customers.CompanyName}"; dataText.Name = "DataText"; dataBand.Components.Add(dataText); // Create FooterBand var footerBand = new StiFooterBand(); footerBand.Height = 0.5; footerBand.Name = "FooterBand"; page.Components.Add(footerBand); // Create text on footer var footerText = new StiText(new RectangleD(0, 0, 5, 0.5)); footerText.Text = "Count - {Count()}"; footerText.HorAlignment = StiTextHorAlignment.Right; footerText.Name = "FooterText"; footerText.Brush = new StiSolidBrush(System.Drawing.Color.LightGreen); footerBand.Components.Add(footerText); report.Show(); }
private void InitializeComponent() { VW_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 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(); }
private void print_Click(object sender, EventArgs e) { StiReport report = new StiReport(); report.ScriptLanguage = StiReportLanguageType.CSharp; //Add data to datastore report.RegData("MyList", model); //Fill dictionary report.Dictionary.Synchronize(); StiPage page = report.Pages.Items[0]; page.Orientation = StiPageOrientation.Landscape; //Create HeaderBand StiHeaderBand headerBand = new StiHeaderBand(); headerBand.Name = "HeaderBand"; page.Components.Add(headerBand); //Create Dataaband StiDataBand dataBand = new StiDataBand(); dataBand.DataSourceName = "MyList"; dataBand.Height = 0.5f; dataBand.Name = "DataBand"; page.Components.Add(dataBand); StiDataSource dataSource = report.Dictionary.DataSources[0]; //Create texts Double pos = 0; Double columnWidth = StiAlignValue.AlignToMinGrid((page.Width * 3 * 1.1) / 44, 0.1, true); Double AddressWidth = StiAlignValue.AlignToMinGrid((page.Width) / 4, 0.1, true); int nameIndex = 1; foreach (StiDataColumn column in dataSource.Columns) { if (column.Name == "mantagheName" || column.Name == "Senn" || column.Name == "_ID" || column.Name == "_Current" || column.Name == "checkbox" || column.Name == "codegrid" || column.Name == "datetime" || column.Name == "Address1" || column.Name == "Address2" || column.Name == "Address3") { continue; } //Create text on header StiText headerText = null; if (column.Name == "Address") { headerText = new StiText(new RectangleD(pos, 0, AddressWidth, 0.5f)); } else { headerText = new StiText(new RectangleD(pos, 0, columnWidth, 0.5f)); } headerText.WordWrap = false; string val = bringPersionName(column.Name); headerText.Text.Value = val;// headerText.HorAlignment = StiTextHorAlignment.Center; headerText.VertAlignment = StiVertAlignment.Center; headerText.Name = "HeaderText" + nameIndex.ToString(); headerText.Brush = new StiSolidBrush(Color.LightGreen); headerText.Border.Side = StiBorderSides.All; headerBand.Components.Add(headerText); //Create text on Data Band StiText dataText = null; if (column.Name == "Address") { dataText = new StiText(new RectangleD(pos, 0, AddressWidth, 0.5f)); } else { dataText = new StiText(new RectangleD(pos, 0, columnWidth, 0.5f)); } dataText.WordWrap = false; if (column.Name != "Address" || column.Name != "phones") { dataText.HorAlignment = StiTextHorAlignment.Center; } dataText.VertAlignment = StiVertAlignment.Center; dataText.Text.Value = "{MyList." + column.Name + "}"; dataText.Name = "DataText" + nameIndex.ToString(); dataText.Border.Side = StiBorderSides.All; dataText.RightToLeft = true; //Add highlight //dataText.HighlightCondition.Brush = new StiSolidBrush(Color.CornflowerBlue); //dataText.HighlightCondition.TextBrush = new StiSolidBrush(Color.Black); //dataText.HighlightCondition.Condition.Value = "(Line & 1) == 1"; //uncomment this line for VB.Net //dataText.HighlightCondition.Condition.Value = "(Line And 1) = 1"; dataBand.Components.Add(dataText); pos += columnWidth; nameIndex++; } //Create FooterBand StiFooterBand footerBand = new StiFooterBand(); footerBand.Height = 0.5f; footerBand.Name = "FooterBand"; page.Components.Add(footerBand); //Create text on footer StiText footerText = new StiText(new RectangleD(0, 0, page.Width, 0.5f)); footerText.Text.Value = "Count - {Count()}"; footerText.HorAlignment = StiTextHorAlignment.Right; footerText.Name = "FooterText"; footerText.Brush = new StiSolidBrush(Color.LightGreen); footerBand.Components.Add(footerText); //Render without progress bar report.Render(false); report.Show(); //For checking created report you can uncomment this line //report.Design(); }
static StiReport MakeReport(DBGrid grid, ReportCreateParam param) { JMXSchema schema = grid.Schema; DataTable dt = grid.BaseTable; double top = 0; float fontSize = param.FontSize; string tableName = TableAliasDefault;; StiReport report = new StiReport { ScriptLanguage = StiReportLanguageType.CSharp, ReportName = schema.Name }; //report.RegData(tableName, dt); report.RegData(tableName, grid.GetBindingSource()); report.Dictionary.Synchronize(); report.Dictionary.DataSources[0].Name = tableName; report.Dictionary.DataSources[0].Alias = tableName; StiPage page = report.Pages.Items[0]; page.Margins.Left = 1; page.Margins.Right = 1; page.AlignToGrid(); //ReportTitle bool titleOnPage = param.TitleOnPage; StiReportTitleBand titleBand = new StiReportTitleBand { Height = 0.5f, CanGrow = true, Name = "TitleBand" }; page.Components.Add(titleBand); //Period bool period = param.Period; if (period) { StiText periodText = new StiText(new RectangleD(0, 0, page.Width, 0.5f)); periodText.Text.Value = rth.Za(); periodText.HorAlignment = StiTextHorAlignment.Right; periodText.Name = "periodText"; periodText.Border.Side = StiBorderSides.None; //periodText.DockStyle = StiDockStyle.Right; periodText.Font = new Font(grid.Font.FontFamily.Name, fontSize, FontStyle.Bold); titleBand.Components.Add(periodText); top += periodText.Height; } //Title StiText titleText = new StiText(new RectangleD(0, period ? 0.5f : 0, page.Width, 1f)); titleText.Text.Value = grid.Schema.Name; titleText.HorAlignment = StiTextHorAlignment.Center; titleText.Name = "titleText"; titleText.Border.Side = StiBorderSides.None; titleText.Font = new Font(grid.Font.FontFamily.Name, 12f, FontStyle.Bold); titleText.WordWrap = true; titleText.CanGrow = true; titleBand.Components.Add(titleText); top += titleText.Height; //Create HeaderBand StiBand headBand; StiHeaderBand headerBand = new StiHeaderBand { Height = 0.5f, Name = "HeaderBand" }; if (titleOnPage) { page.Components.Add(headerBand); headBand = headerBand; } else { headBand = titleBand; } //Create Databand StiDataBand dataBand = new StiDataBand { DataSourceName = tableName, Height = 0.5f, Name = "DataBand" }; page.Components.Add(dataBand); //Create FooterBand StiFooterBand footerBand = new StiFooterBand { Height = 0.5f, CanGrow = true, Name = "FooterBand", CanBreak = false }; page.Components.Add(footerBand); Double pos = 0; int nameIndex = 1; int i = 0; bool multiLine = param.MultiLine; int border = param.Border; bool totals = false; List <StiText> footerList = new List <StiText>(); foreach (DataGridViewColumn column in grid.Columns) { bool visible = (column.Visible && column.Width > 1); if (visible) { Double columnWidth = StiAlignValue.AlignToMinGrid(column.Width / 33, 0.03, true); //Create text on header StiText headerText = new StiText(new RectangleD(pos, titleOnPage ? 0: top, columnWidth, 0.5f)); headerText.Text.Value = column.HeaderText; headerText.HorAlignment = StiTextHorAlignment.Center; headerText.Name = "HeaderText" + nameIndex.ToString(); if (border == 0) { headerText.Border.Side = StiBorderSides.Top | StiBorderSides.Bottom; } else { headerText.Border.Side = StiBorderSides.All; } headerText.CanGrow = true; headerText.GrowToHeight = true; headerText.WordWrap = multiLine; headerText.Font = new Font(grid.ColumnHeadersDefaultCellStyle.Font.FontFamily.Name, fontSize); headBand.Components.Add(headerText); MacroType tt = DBGridBase.GetMacroType(schema.Attributes[i].DataType); string format = column.DefaultCellStyle.Format; if (string.IsNullOrEmpty(format) && tt == MacroType.date) { format = vbo.DateFormat; } StiTextHorAlignment horAlign; switch (column.DefaultCellStyle.Alignment) { case DataGridViewContentAlignment.MiddleRight: horAlign = StiTextHorAlignment.Right; break; case DataGridViewContentAlignment.MiddleLeft: horAlign = StiTextHorAlignment.Left; break; default: horAlign = StiTextHorAlignment.Center; break; } //Create text on Data Band StiText dataText = new StiText(new RectangleD(pos, 0, columnWidth, 0.5f)); string field = tableName + "." + Stimulsoft.Report.CodeDom.StiCodeDomSerializator.ReplaceSymbols(column.DataPropertyName); if (AccntFormat.ValidFormat(format)) { dataText.Text.Value = "{Substring(" + field + ",0,5)+" + "-".Qt() + "+Substring(" + field + ",5,3)+" + "-".Qt() + "+Substring(" + field + ",8,1)+" + "-".Qt() + "+Substring(" + field + ",9,4)+" + "-".Qt() + "+Substring(" + field + ",13,7)" + "}"; } else { dataText.Text.Value = "{" + field + "}"; } dataText.Name = "DataText" + nameIndex.ToString(); dataText.CanGrow = true; dataText.GrowToHeight = true; dataText.WordWrap = multiLine; dataText.HorAlignment = horAlign; //dataText.VertAlignment = StiVertAlignment.Center; if (border == 0) { dataText.Border.Side = StiBorderSides.None; } else if (border == 1) { dataText.Border.Side = StiBorderSides.Bottom; } else { dataText.Border.Side = StiBorderSides.All; } if (grid.RowsDefaultCellStyle.Font == null) { dataText.Font = new Font(grid.Font.FontFamily.Name, fontSize); } else { dataText.Font = new Font(grid.RowsDefaultCellStyle.Font.FontFamily.Name, fontSize); } dataText.TextFormat = ParseFormat(format); if (tt == MacroType.num) { dataText.ExcelValue.Value = "{" + field + "}"; } dataBand.Components.Add(dataText); //Create text on footer string summary = schema.Attributes[i].Agregate.ToLower(); if (summary == "sum") { summary = "Sum(" + field + ")"; } else if (summary == "rcnt") { summary = "Count()"; } else if (summary == "ave") { summary = "Avg(" + field + ")"; } else if (summary == "min") { summary = "Min(" + field + ")"; } else if (summary == "max") { summary = "Max(" + field + ")"; } else { summary = string.Empty; } bool summaryEmpty = string.IsNullOrEmpty(summary); int footerIndex = i; //if (!string.IsNullOrEmpty(grid.FooterText(footerIndex))) if (!summaryEmpty) { totals = true; } StiText footerText = new StiText(new RectangleD(pos, 0, columnWidth, 0.5f)); if (footerIndex == 0 && summaryEmpty) { footerText.Text.Value = grid.FooterCaption; } else if (footerIndex == 0) { footerText.Text.Value = "{" + (grid.FooterCaption + vbo.vbTab).Qt() + "+" + summary + "}"; } else if (!summaryEmpty) { footerText.Text.Value = "{" + summary + "}"; footerText.ExcelValue.Value = "{" + summary + "}"; } else { footerText.Text.Value = grid.FooterText(footerIndex); } footerText.Name = "FooterText" + nameIndex.ToString(); if (border == 0) { footerText.Border.Side = StiBorderSides.Top | StiBorderSides.Bottom; } else { footerText.Border.Side = StiBorderSides.All; } if (!summaryEmpty && summary != "Count()") { footerText.TextFormat = (StiFormatService)dataText.TextFormat.Clone(); } footerText.HorAlignment = horAlign; //footerText.VertAlignment = StiVertAlignment.Center; footerText.Font = new Font(grid.Font.FontFamily.Name, fontSize); footerList.Add(footerText); pos += columnWidth; nameIndex++; } i++; } if (totals) { footerBand.Components.AddRange(footerList.ToArray()); } if ((pos - page.Width) < 1.6f) { page.Margins.Right = 0; page.Margins.Left /= 2; } else if (pos > page.Width) { page.Orientation = StiPageOrientation.Landscape; titleText.Width = page.Width; if (period) { titleBand.Components[titleBand.Components.IndexOf("periodText")].Width = page.Width; } if (pos > page.Width) { page.Margins.Right = 0; page.Margins.Left /= 2; } if (pos > page.Width) { page.Width = pos; } } if (param.Sign) { footerList.Clear(); //StiText footerText = new StiText(new RectangleD(0, 0.5f, page.Width, 0.5f)); //footerList.Add(footerText); //footerText = new StiText(new RectangleD(0, 1f, page.Width / 2, 0.5f)); //footerText.Text.Value = "{CSetup.Setup.Properties(" + vbo.Qt("President") + ", " + vbo.Qt("") + ")}"; //footerText.HorAlignment = StiTextHorAlignment.Right; //footerText.Font = new Font(grid.ColumnHeadersDefaultCellStyle.Font.FontFamily.Name, 10); //footerList.Add(footerText); //footerText = new StiText(new RectangleD(page.Width / 2, 1f, page.Width / 4, 0.5f)); //footerList.Add(footerText); //footerText = new StiText(new RectangleD(page.Width * 3 / 4, 1f, page.Width / 4, 0.5f)); //footerText.Text.Value = "{CSetup.Setup.Properties(" + vbo.Qt("PresidentName") + ", " + vbo.Qt("") + ")}"; //footerText.HorAlignment = StiTextHorAlignment.Left; //footerText.Font = new Font(grid.ColumnHeadersDefaultCellStyle.Font.FontFamily.Name, 10); //footerList.Add(footerText); //footerText = new StiText(new RectangleD(0, 1.5f, page.Width, 0.5f)); //footerList.Add(footerText); //footerText = new StiText(new RectangleD(0, 2f, page.Width / 2, 0.5f)); //footerText.Text.Value = "{CSetup.Setup.Properties(" + vbo.Qt("ChifAccount") + ", " + vbo.Qt("") + ")}"; //footerText.HorAlignment = StiTextHorAlignment.Right; //footerText.Font = new Font(grid.ColumnHeadersDefaultCellStyle.Font.FontFamily.Name, 10); //footerList.Add(footerText); //footerText = new StiText(new RectangleD(page.Width / 2, 2f, page.Width / 4, 0.5f)); //footerList.Add(footerText); //footerText = new StiText(new RectangleD(page.Width * 3 / 4, 2f, page.Width / 4, 0.5f)); //footerText.Text.Value = "{CSetup.Setup.Properties(" + vbo.Qt("ChifAccountName") + ", " + vbo.Qt("") + ")}"; //footerText.HorAlignment = StiTextHorAlignment.Left; //footerText.Font = new Font(grid.ColumnHeadersDefaultCellStyle.Font.FontFamily.Name, 10); //footerList.Add(footerText); //footerBand.Height = 2.5f; //footerBand.Components.AddRange(footerList.ToArray()); } return(report); }
private void PrintDataGrid(DataGrid sender) { DataView dataView = (DataView)sender.DataSource; StiReport report = new StiReport(); report.ScriptLanguage = StiReportLanguageType.CSharp; //Add data to datastore report.RegData("view", dataView); //Fill dictionary report.Dictionary.Synchronize(); StiPage page = report.Pages.Items[0]; //Create HeaderBand StiHeaderBand headerBand = new StiHeaderBand(); headerBand.Height = 0.5f; headerBand.Name = "HeaderBand"; page.Components.Add(headerBand); //Create Dataaband StiDataBand dataBand = new StiDataBand(); dataBand.DataSourceName = "view" + dataView.Table.TableName; dataBand.Height = 0.5f; dataBand.Name = "DataBand"; page.Components.Add(dataBand); //Create texts Double pos = 0; Double columnWidth = StiAlignValue.AlignToMinGrid(page.Width / dataView.Table.Columns.Count, 0.1, true); int nameIndex = 1; foreach (DataColumn column in dataView.Table.Columns) { //Create text on header StiText headerText = new StiText(new RectangleD(pos, 0, columnWidth, 0.5f)); headerText.Text.Value = column.Caption; headerText.HorAlignment = StiTextHorAlignment.Center; headerText.Name = "HeaderText" + nameIndex.ToString(); headerText.Brush = new StiSolidBrush(Color.LightGreen); headerText.Border.Side = StiBorderSides.All; headerBand.Components.Add(headerText); //Create text on Data Band StiText dataText = new StiText(new RectangleD(pos, 0, columnWidth, 0.5f)); dataText.Text.Value = "{view" + dataView.Table.TableName + "." + Stimulsoft.Report.CodeDom.StiCodeDomSerializator.ReplaceSymbols(column.ColumnName) + "}"; dataText.Name = "DataText" + nameIndex.ToString(); dataText.Border.Side = StiBorderSides.All; //Add highlight StiCondition condition = new StiCondition(); condition.BackColor = Color.CornflowerBlue; condition.TextColor = Color.Black; condition.Expression = "(Line & 1) == 1"; condition.Item = StiFilterItem.Expression; dataText.Conditions.Add(condition); dataBand.Components.Add(dataText); pos += columnWidth; nameIndex++; } //Create FooterBand StiFooterBand footerBand = new StiFooterBand(); footerBand.Height = 0.5f; footerBand.Name = "FooterBand"; page.Components.Add(footerBand); //Create text on footer StiText footerText = new StiText(new RectangleD(0, 0, page.Width, 0.5f)); footerText.Text.Value = "Count - {Count()}"; footerText.HorAlignment = StiTextHorAlignment.Right; footerText.Name = "FooterText"; footerText.Brush = new StiSolidBrush(Color.LightGreen); footerBand.Components.Add(footerText); //Render without progress bar report.Render(false); report.Show(); }
private void ShowReport() { StiReport report = new StiReport(); float columnsWidth = 0; DataTable table = new DataTable("ReportData"); for (int i = 0; i < dgvList.Columns.Count; i++) { table.Columns.Add(dgvList.Columns[i].Name, dgvList.Columns[i].ValueType); columnsWidth += dgvList.Columns[i].Width; } for (int i = 0; i < dgvList.Rows.Count; i++) { DataRow row = table.NewRow(); for (int j = 0; j < dgvList.Columns.Count; j++) { row[dgvList.Columns[j].Name] = dgvList[j, i].Value; } table.Rows.Add(row); } report.RegData(table); report.Dictionary.Synchronize(); StiPage page = report.Pages[0]; StiReportTitleBand titleBand = new StiReportTitleBand(); titleBand.Height = 1.0; titleBand.Name = "TitleBand"; page.Components.Add(titleBand); StiText titleText = new StiText(new RectangleD(0, 0, page.Width, 1)); titleText.Name = "TitleText"; titleText.Text = Text + " " + pickPlan.Value.ToShortDateString(); titleText.Width = page.Width; titleText.HorAlignment = StiTextHorAlignment.Center; titleText.Font = new Font("Arial", 10); titleBand.Components.Add(titleText); //Create HeaderBand StiHeaderBand headerBand = new StiHeaderBand(); headerBand.Height = 0.5; headerBand.Name = "HeaderBand"; page.Components.Add(headerBand); float bandWidth = (float)page.Width; float multiplier = bandWidth / columnsWidth; float previousWidth = 0; //Create text on header for (int i = 0; i < dgvList.Columns.Count; i++) { StiText headerText = new StiText(new RectangleD(previousWidth, 0, dgvList.Columns[i].Width * multiplier, 0.5)); headerText.Text = dgvList.Columns[i].HeaderText; headerText.HorAlignment = StiTextHorAlignment.Center; headerText.Name = "HeaderText" + i.ToString(); headerText.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid); headerText.Brush = new StiSolidBrush(Color.LightGreen); headerBand.Components.Add(headerText); previousWidth += dgvList.Columns[i].Width * multiplier; } //Create Databand StiDataBand dataBand = new StiDataBand(); dataBand.DataSourceName = "ReportData"; dataBand.Height = 0.5; dataBand.Name = "DataBand"; page.Components.Add(dataBand); previousWidth = 0; //Create text for (int i = 0; i < dgvList.Columns.Count; i++) { RectangleD rectangle = new RectangleD(previousWidth, 0, dgvList.Columns[i].Width * multiplier, 1); StiText dataText = new StiText(rectangle); dataText.Format = dgvList.Columns[i].DefaultCellStyle.Format; dataText.Text = "{ReportData." + dgvList.Columns[i].Name + "}"; dataText.Name = "DataText" + i.ToString(); dataText.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid); dataBand.Components.Add(dataText); previousWidth += dgvList.Columns[i].Width * multiplier; } //Create FooterBand StiFooterBand footerBand = new StiFooterBand(); footerBand.Height = 0.5; footerBand.Name = "FooterBand"; page.Components.Add(footerBand); //Create text on footer StiText footerText = new StiText(new RectangleD(0, 0, 5, 0.5)); footerText.Text = "Всего - {Count()} строк"; footerText.HorAlignment = StiTextHorAlignment.Right; footerText.Name = "FooterText"; footerText.Brush = new StiSolidBrush(Color.LightGreen); footerBand.Components.Add(footerText); report.Save("D:\\report.mrt"); report.Show(); }
private void InitializeComponent() { VW_Country = new VW_CountryDataSource(); NeedsCompiling = false; EngineVersion = StiEngineVersion.EngineV2; ReferencedAssemblies = new[] { "System.Dll", "System.Drawing.Dll", "System.Windows.Forms.Dll", "System.Data.Dll", "System.Xml.Dll", "Stimulsoft.Controls.Dll", "Stimulsoft.Base.Dll", "Stimulsoft.Report.Dll" }; ReportAlias = "Rpt Country"; // // ReportChanged // ReportChanged = new DateTime(2009, 2, 7, 14, 30, 56, 0); // // ReportCreated // ReportCreated = new DateTime(2008, 9, 2, 21, 7, 22, 0); ReportFile = "D:\\User\\Documents\\Projects\\Apothex\\Source\\Class Library\\Apothex.Reporting\\Dictionary\\RptCountry.mrt"; ReportGuid = "af5c1e936cdf4e129cbdeae2455e3cea"; ReportName = "RptCountry"; ReportUnit = StiReportUnitType.Centimeters; ReportVersion = "2008.2.300"; ScriptLanguage = StiReportLanguageType.CSharp; // // Page1 // Page1 = new StiPage(); Page1.ColumnGaps = 1; Page1.Columns = 2; Page1.ColumnWidth = 9; Page1.Guid = "cace94e76442472aa8acc7b42034809c"; Page1.Name = "Page1"; Page1.PageHeight = 29.7; Page1.PageWidth = 21; Page1.PaperSize = PaperKind.A4; Page1.Border = new StiBorder(StiBorderSides.None, Color.Black, 2, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false); Page1.Brush = new StiSolidBrush(Color.Transparent); // // ReportTitle // ReportTitle = new StiReportTitleBand(); ReportTitle.ClientRectangle = new RectangleD(0, 0.4, 9, 0.8); ReportTitle.Name = "ReportTitle"; ReportTitle.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false); ReportTitle.Brush = new StiSolidBrush(Color.Transparent); // // ReportTitleText // ReportTitleText = new StiText(); ReportTitleText.ClientRectangle = new RectangleD(0, 0, 19, 0.8); ReportTitleText.HorAlignment = StiTextHorAlignment.Center; ReportTitleText.Name = "ReportTitleText"; ReportTitleText.GetValue += new StiGetValueEventHandler(ReportTitleText__GetValue); ReportTitleText.Type = StiSystemTextType.Expression; ReportTitleText.VertAlignment = StiVertAlignment.Center; ReportTitleText.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false); ReportTitleText.Brush = new StiSolidBrush(Color.Transparent); ReportTitleText.Font = new Font("BPG Glaho Arial", 12F, FontStyle.Bold); ReportTitleText.Guid = null; ReportTitleText.Indicator = null; ReportTitleText.Interaction = null; ReportTitleText.Margins = new StiMargins(0, 0, 0, 0); ReportTitleText.TextBrush = new StiSolidBrush(Color.Black); ReportTitleText.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None); ReportTitle.Guid = null; ReportTitle.Interaction = null; // // Header // Header = new StiHeaderBand(); Header.ClientRectangle = new RectangleD(0, 2, 9, 0.8); Header.Name = "Header"; Header.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false); Header.Brush = new StiSolidBrush(Color.Transparent); // // HeaderText1 // HeaderText1 = new StiText(); HeaderText1.ClientRectangle = new RectangleD(0, 0, 2, 0.8); HeaderText1.Name = "HeaderText1"; HeaderText1.GetValue += new StiGetValueEventHandler(HeaderText1__GetValue); HeaderText1.Type = StiSystemTextType.Expression; HeaderText1.VertAlignment = StiVertAlignment.Center; HeaderText1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false); HeaderText1.Brush = new StiSolidBrush(Color.Transparent); HeaderText1.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold); HeaderText1.Guid = null; HeaderText1.Indicator = null; HeaderText1.Interaction = null; HeaderText1.Margins = new StiMargins(0, 0, 0, 0); HeaderText1.TextBrush = new StiSolidBrush(Color.Black); HeaderText1.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None); // // HeaderText2 // HeaderText2 = new StiText(); HeaderText2.ClientRectangle = new RectangleD(2, 0, 7, 0.8); HeaderText2.Name = "HeaderText2"; HeaderText2.GetValue += new StiGetValueEventHandler(HeaderText2__GetValue); HeaderText2.Type = StiSystemTextType.Expression; HeaderText2.VertAlignment = StiVertAlignment.Center; HeaderText2.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false); HeaderText2.Brush = new StiSolidBrush(Color.Transparent); HeaderText2.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold); HeaderText2.Guid = null; HeaderText2.Indicator = null; HeaderText2.Interaction = null; HeaderText2.Margins = new StiMargins(0, 0, 0, 0); HeaderText2.TextBrush = new StiSolidBrush(Color.Black); HeaderText2.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None); Header.Guid = null; Header.Interaction = null; // // DataVW_Country // DataVW_Country = new StiDataBand(); DataVW_Country.ClientRectangle = new RectangleD(0, 3.6, 9, 0.6); DataVW_Country.DataSourceName = "VW_Country"; DataVW_Country.Name = "DataVW_Country"; DataVW_Country.Sort = new[] { "ASC", "CountryCode" }; DataVW_Country.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false); DataVW_Country.Brush = new StiSolidBrush(Color.Transparent); DataVW_Country.BusinessObjectGuid = null; // // DataText1 // DataText1 = new StiText(); DataText1.ClientRectangle = new RectangleD(0, 0, 2, 0.6); DataText1.GrowToHeight = true; DataText1.Name = "DataText1"; DataText1.GetValue += new StiGetValueEventHandler(DataText1__GetValue); DataText1.Type = StiSystemTextType.Expression; DataText1.VertAlignment = StiVertAlignment.Center; DataText1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false); DataText1.Brush = new StiSolidBrush(Color.Transparent); DataText1.Font = new Font("BPG Glaho Arial", 10F); DataText1.Guid = null; DataText1.Indicator = null; DataText1.Interaction = null; DataText1.Margins = new StiMargins(0, 0, 0, 0); DataText1.TextBrush = new StiSolidBrush(Color.Black); DataText1.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None); // // DataText2 // DataText2 = new StiText(); DataText2.CanGrow = true; DataText2.ClientRectangle = new RectangleD(2, 0, 7, 0.6); DataText2.Name = "DataText2"; DataText2.GetValue += new StiGetValueEventHandler(DataText2__GetValue); DataText2.Type = StiSystemTextType.Expression; DataText2.VertAlignment = StiVertAlignment.Center; DataText2.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false); DataText2.Brush = new StiSolidBrush(Color.Transparent); DataText2.Font = new Font("BPG Glaho Arial", 10F); DataText2.Guid = null; DataText2.Indicator = null; DataText2.Interaction = null; DataText2.Margins = new StiMargins(0, 0, 0, 0); DataText2.TextBrush = new StiSolidBrush(Color.Black); DataText2.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); DataVW_Country.Guid = null; DataVW_Country.Interaction = null; DataVW_Country.MasterComponent = null; // // Footer // Footer = new StiFooterBand(); Footer.ClientRectangle = new RectangleD(0, 5, 9, 0.6); Footer.Name = "Footer"; Footer.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false); Footer.Brush = new StiSolidBrush(Color.Transparent); Footer.Guid = null; Footer.Interaction = null; Page1.ExcelSheetValue = null; Page1.Interaction = null; Page1.Margins = new StiMargins(1, 1, 1, 1); Page1_Watermark = new StiWatermark(); Page1_Watermark.Font = new Font("Arial", 100F); Page1_Watermark.Image = null; Page1_Watermark.TextBrush = new StiSolidBrush(Color.FromArgb(50, 0, 0, 0)); RptCountry_PrinterSettings = new StiPrinterSettings(); PrinterSettings = RptCountry_PrinterSettings; Page1.Report = this; Page1.Watermark = Page1_Watermark; ReportTitle.Page = Page1; ReportTitle.Parent = Page1; ReportTitleText.Page = Page1; ReportTitleText.Parent = ReportTitle; Header.Page = Page1; Header.Parent = Page1; HeaderText1.Page = Page1; HeaderText1.Parent = Header; HeaderText2.Page = Page1; HeaderText2.Parent = Header; DataVW_Country.Page = Page1; DataVW_Country.Parent = Page1; DataText1.Page = Page1; DataText1.Parent = DataVW_Country; DataText2.Page = Page1; DataText2.Parent = DataVW_Country; Footer.Page = Page1; Footer.Parent = Page1; // // Add to ReportTitle.Components // ReportTitle.Components.Clear(); ReportTitle.Components.AddRange(new StiComponent[] { ReportTitleText }); // // Add to Header.Components // Header.Components.Clear(); Header.Components.AddRange(new StiComponent[] { HeaderText1, HeaderText2 }); // // Add to DataVW_Country.Components // DataVW_Country.Components.Clear(); DataVW_Country.Components.AddRange(new StiComponent[] { DataText1, DataText2 }); // // Add to Page1.Components // Page1.Components.Clear(); Page1.Components.AddRange(new StiComponent[] { ReportTitle, Header, DataVW_Country, Footer }); // // Add to Pages // Pages.Clear(); Pages.AddRange(new[] { Page1 }); VW_Country.Columns.AddRange(new[] { new StiDataColumn("Approver", "Approver", "Approver", typeof(string)), new StiDataColumn("ApproverUserID", "ApproverUserID", "ApproverUserID", typeof(int)), new StiDataColumn("CountryCode", "CountryCode", "CountryCode", typeof(string)), new StiDataColumn("ModifiedDate", "ModifiedDate", "ModifiedDate", typeof(DateTime)), new StiDataColumn("ModifiedUserID", "ModifiedUserID", "ModifiedUserID", typeof(int)), new StiDataColumn("Modifier", "Modifier", "Modifier", typeof(string)), new StiDataColumn("Name", "Name", "Name", typeof(string)), new StiDataColumn("Status", "Status", "Status", typeof(byte)) }); DataSources.Add(VW_Country); }
async private void buttonBuildReport_Click(object sender, Windows.UI.Xaml.RoutedEventArgs e) { viewerControl.ShowProgressBar("Create Report..."); StiReport report = new StiReport(); //Add data to datastore report.RegBusinessObject("Customers", "Customers", new Data().Customers); //Fill dictionary report.Dictionary.SynchronizeBusinessObjects(); StiPage page = report.Pages[0]; //Create HeaderBand var headerBand = new StiHeaderBand(); headerBand.Height = 0.5; headerBand.Name = "HeaderBand"; page.Components.Add(headerBand); //Create text on header var headerText = new StiText(new RectangleD(0, 0, 5, 0.5)); headerText.Text = "CompanyName"; headerText.HorAlignment = StiTextHorAlignment.Center; headerText.Name = "HeaderText"; headerText.Brush = new StiSolidBrush(Colors.LightGreen); headerBand.Components.Add(headerText); //Create Databand StiDataBand dataBand = new StiDataBand(); dataBand.BusinessObjectGuid = report.Dictionary.BusinessObjects[0].Guid; dataBand.Height = 0.5; dataBand.Name = "DataBand"; page.Components.Add(dataBand); //Create text StiText dataText = new StiText(new RectangleD(0, 0, 5, 0.5)); dataText.Text = "{Line}.{Customers.CompanyName}"; dataText.Name = "DataText"; dataBand.Components.Add(dataText); //Create FooterBand StiFooterBand footerBand = new StiFooterBand(); footerBand.Height = 0.5; footerBand.Name = "FooterBand"; page.Components.Add(footerBand); //Create text on footer StiText footerText = new StiText(new RectangleD(0, 0, 5, 0.5)); footerText.Text = "Count - {Count()}"; footerText.HorAlignment = StiTextHorAlignment.Right; footerText.Name = "FooterText"; footerText.Brush = new StiSolidBrush(Colors.LightGreen); footerBand.Components.Add(footerText); await report.RenderAsync(); viewerControl.Report = report; viewerControl.HideProgressBar(); }
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 InitializeComponent() { VW_Product = new VW_ProductDataSource(); NeedsCompiling = false; EngineVersion = StiEngineVersion.EngineV2; ReferencedAssemblies = new[] { "System.Dll", "System.Drawing.Dll", "System.Windows.Forms.Dll", "System.Data.Dll", "System.Xml.Dll", "Stimulsoft.Controls.Dll", "Stimulsoft.Base.Dll", "Stimulsoft.Report.Dll" }; ReportAlias = "Rpt Product Bar Code"; // // ReportChanged // ReportChanged = new DateTime(2009, 6, 8, 10, 23, 13, 687); // // ReportCreated // ReportCreated = new DateTime(2009, 3, 24, 21, 40, 37, 0); ReportGuid = "17d6a2b4761540d58d5510314b329565"; ReportName = "RptProductBarCode"; ReportUnit = StiReportUnitType.Centimeters; ScriptLanguage = StiReportLanguageType.CSharp; // // Page1 // Page1 = new StiPage(); Page1.Columns = 2; Page1.Guid = "53d0355db4644f9d9ba6c964bafb28f0"; Page1.Name = "Page1"; Page1.Orientation = StiPageOrientation.Landscape; Page1.PageHeight = 21; Page1.PageWidth = 29.7; Page1.Border = new StiBorder(StiBorderSides.None, Color.Black, 2, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); Page1.Brush = new StiSolidBrush(Color.Transparent); // // HeaderVW_Product // HeaderVW_Product = new StiHeaderBand(); HeaderVW_Product.ClientRectangle = new RectangleD(0, 0.4, 13.85, 0.8); HeaderVW_Product.Name = "HeaderVW_Product"; HeaderVW_Product.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); HeaderVW_Product.Brush = new StiSolidBrush(Color.Transparent); // // HeaderVW_Product_MedicamentName // HeaderVW_Product_MedicamentName = new StiText(); HeaderVW_Product_MedicamentName.ClientRectangle = new RectangleD(0, 0, 6.8, 0.8); HeaderVW_Product_MedicamentName.Name = "HeaderVW_Product_MedicamentName"; HeaderVW_Product_MedicamentName.GetValue += new StiGetValueEventHandler(HeaderVW_Product_MedicamentName__GetValue); HeaderVW_Product_MedicamentName.Type = StiSystemTextType.Expression; HeaderVW_Product_MedicamentName.VertAlignment = StiVertAlignment.Center; HeaderVW_Product_MedicamentName.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); HeaderVW_Product_MedicamentName.Brush = new StiSolidBrush(Color.Transparent); HeaderVW_Product_MedicamentName.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold); HeaderVW_Product_MedicamentName.Guid = null; HeaderVW_Product_MedicamentName.Interaction = null; HeaderVW_Product_MedicamentName.Margins = new StiMargins(0, 0, 0, 0); HeaderVW_Product_MedicamentName.TextBrush = new StiSolidBrush(Color.Black); HeaderVW_Product_MedicamentName.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // Text1 // Text1 = new StiText(); Text1.ClientRectangle = new RectangleD(6.8, 0, 7, 0.8); Text1.Name = "Text1"; Text1.GetValue += new StiGetValueEventHandler(Text1__GetValue); Text1.Type = StiSystemTextType.Expression; Text1.VertAlignment = StiVertAlignment.Center; Text1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); Text1.Brush = new StiSolidBrush(Color.Transparent); Text1.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold); Text1.Guid = null; Text1.Interaction = null; Text1.Margins = new StiMargins(0, 0, 0, 0); Text1.TextBrush = new StiSolidBrush(Color.Black); Text1.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None); HeaderVW_Product.Guid = null; HeaderVW_Product.Interaction = null; // // DataVW_Product // DataVW_Product = new StiDataBand(); DataVW_Product.ClientRectangle = new RectangleD(0, 2, 13.85, 2); DataVW_Product.DataSourceName = "VW_Product"; DataVW_Product.Name = "DataVW_Product"; DataVW_Product.Sort = new String[0]; DataVW_Product.Border = new StiBorder(StiBorderSides.All, Color.Black, 0.5, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); DataVW_Product.Brush = new StiSolidBrush(Color.Transparent); // // DataVW_Product_ProductID // DataVW_Product_ProductID = new StiText(); DataVW_Product_ProductID.CanGrow = true; DataVW_Product_ProductID.ClientRectangle = new RectangleD(0, 0, 6.6, 2); DataVW_Product_ProductID.GrowToHeight = true; DataVW_Product_ProductID.Name = "DataVW_Product_ProductID"; DataVW_Product_ProductID.GetValue += new StiGetValueEventHandler(DataVW_Product_ProductID__GetValue); DataVW_Product_ProductID.Type = StiSystemTextType.Expression; DataVW_Product_ProductID.VertAlignment = StiVertAlignment.Center; DataVW_Product_ProductID.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); DataVW_Product_ProductID.Brush = new StiSolidBrush(Color.Transparent); DataVW_Product_ProductID.Font = new Font("BPG Glaho Arial", 8F); DataVW_Product_ProductID.Guid = null; DataVW_Product_ProductID.Interaction = null; DataVW_Product_ProductID.Margins = new StiMargins(0, 0, 0, 0); DataVW_Product_ProductID.TextBrush = new StiSolidBrush(Color.Black); DataVW_Product_ProductID.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None); // // BarCode1 // BarCode1 = new StiBarCode(); BarCode1.BackColor = Color.White; BarCode1.ClientRectangle = new RectangleD(6.8, 0, 7, 2); BarCode1.GetBarCode += new StiValueEventHandler(BarCode1__GetBarCode); BarCode1.ForeColor = Color.Black; BarCode1.Name = "BarCode1"; BarCode1.VertAlignment = StiVertAlignment.Center; BarCode1.BarCodeType = new StiEAN128aBarCodeType(13F, 1F); BarCode1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Dot, false, 4, new StiSolidBrush(Color.Black)); BarCode1.Font = new Font("Arial", 8F, FontStyle.Bold, GraphicsUnit.Pixel); BarCode1.Guid = null; BarCode1.Interaction = null; DataVW_Product.Guid = null; DataVW_Product.Interaction = null; DataVW_Product.MasterComponent = null; // // FooterVW_Product // FooterVW_Product = new StiFooterBand(); FooterVW_Product.ClientRectangle = new RectangleD(0, 4.8, 13.85, 0.8); FooterVW_Product.Name = "FooterVW_Product"; FooterVW_Product.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); FooterVW_Product.Brush = new StiSolidBrush(Color.Transparent); FooterVW_Product.Guid = null; FooterVW_Product.Interaction = null; Page1.ExcelSheetValue = null; Page1.Interaction = null; Page1.Margins = new StiMargins(1, 1, 1, 1); Page1_Watermark = new StiWatermark(); Page1_Watermark.Font = new Font("Arial", 100F); Page1_Watermark.Image = null; Page1_Watermark.TextBrush = new StiSolidBrush(Color.FromArgb(50, 0, 0, 0)); RptProductBarCode_PrinterSettings = new StiPrinterSettings(); PrinterSettings = RptProductBarCode_PrinterSettings; Page1.Page = Page1; Page1.Report = this; Page1.Watermark = Page1_Watermark; HeaderVW_Product.Page = Page1; HeaderVW_Product.Parent = Page1; HeaderVW_Product_MedicamentName.Page = Page1; HeaderVW_Product_MedicamentName.Parent = HeaderVW_Product; Text1.Page = Page1; Text1.Parent = HeaderVW_Product; DataVW_Product.Page = Page1; DataVW_Product.Parent = Page1; DataVW_Product_ProductID.Page = Page1; DataVW_Product_ProductID.Parent = DataVW_Product; BarCode1.Page = Page1; BarCode1.Parent = DataVW_Product; FooterVW_Product.Page = Page1; FooterVW_Product.Parent = Page1; // // Add to HeaderVW_Product.Components // HeaderVW_Product.Components.Clear(); HeaderVW_Product.Components.AddRange(new StiComponent[] { HeaderVW_Product_MedicamentName, Text1 }); // // Add to DataVW_Product.Components // DataVW_Product.Components.Clear(); DataVW_Product.Components.AddRange(new StiComponent[] { DataVW_Product_ProductID, BarCode1 }); // // Add to Page1.Components // Page1.Components.Clear(); Page1.Components.AddRange(new StiComponent[] { HeaderVW_Product, DataVW_Product, FooterVW_Product }); // // Add to Pages // Pages.Clear(); Pages.AddRange(new[] { Page1 }); VW_Product.Columns.AddRange(new[] { new StiDataColumn("ProductID", "ProductID", "ProductID", typeof(int)), new StiDataColumn("PurchaseOrderDetailID", "PurchaseOrderDetailID", "PurchaseOrderDetailID", typeof(Guid)), new StiDataColumn("MedicamentCategoryID", "MedicamentCategoryID", "MedicamentCategoryID", typeof(int)), new StiDataColumn("MedicamentCategoryName", "MedicamentCategoryName", "MedicamentCategoryName", typeof(string)), new StiDataColumn("MedicamentSubcategoryID", "MedicamentSubcategoryID", "MedicamentSubcategoryID", typeof(int)), new StiDataColumn("MedicamentSubcategoryName", "MedicamentSubcategoryName", "MedicamentSubcategoryName", typeof(string)), new StiDataColumn("MedicamentID", "MedicamentID", "MedicamentID", typeof(int)), new StiDataColumn("MedicamentName", "MedicamentName", "MedicamentName", typeof(string)), new StiDataColumn("Serie", "Serie", "Serie", typeof(string)), new StiDataColumn("PurchaseUnitPriceCU", "PurchaseUnitPriceCU", "PurchaseUnitPriceCU", typeof(decimal)), new StiDataColumn("SaleUnitPriceCU", "SaleUnitPriceCU", "SaleUnitPriceCU", typeof(decimal)), new StiDataColumn("Quantity", "Quantity", "Quantity", typeof(decimal)), new StiDataColumn("UnitsInStock", "UnitsInStock", "UnitsInStock", typeof(decimal)), new StiDataColumn("FinishedGoodsFlag", "FinishedGoodsFlag", "FinishedGoodsFlag", typeof(bool)), new StiDataColumn("SafetyStockLevel", "SafetyStockLevel", "SafetyStockLevel", typeof(short)), new StiDataColumn("ValidDate", "ValidDate", "ValidDate", typeof(DateTime)), new StiDataColumn("Color", "Color", "Color", typeof(string)), new StiDataColumn("CountryCode", "CountryCode", "CountryCode", typeof(string)), new StiDataColumn("CountryName", "CountryName", "CountryName", typeof(string)), new StiDataColumn("Size", "Size", "Size", typeof(string)), new StiDataColumn("SizeUnitMeasureCode", "SizeUnitMeasureCode", "SizeUnitMeasureCode", typeof(string)), new StiDataColumn("Weight", "Weight", "Weight", typeof(decimal)), new StiDataColumn("WeightUnitMeasureCode", "WeightUnitMeasureCode", "WeightUnitMeasureCode", typeof(string)), new StiDataColumn("Class", "Class", "Class", typeof(string)), new StiDataColumn("Style", "Style", "Style", typeof(string)), new StiDataColumn("SellStartDate", "SellStartDate", "SellStartDate", typeof(DateTime)), new StiDataColumn("SellEndDate", "SellEndDate", "SellEndDate", typeof(DateTime)), new StiDataColumn("DiscontinuedDate", "DiscontinuedDate", "DiscontinuedDate", typeof(DateTime)), new StiDataColumn("Status", "Status", "Status", typeof(byte)), new StiDataColumn("ModifiedUserID", "ModifiedUserID", "ModifiedUserID", typeof(int)), new StiDataColumn("Modifier", "Modifier", "Modifier", typeof(string)), new StiDataColumn("ModifiedDate", "ModifiedDate", "ModifiedDate", typeof(DateTime)), new StiDataColumn("PurchaseUnitPrice", "PurchaseUnitPrice", "PurchaseUnitPrice", typeof(decimal)), new StiDataColumn("SaleUnitPrice", "SaleUnitPrice", "SaleUnitPrice", typeof(decimal)), new StiDataColumn("Action", "Action", "Action", typeof(int)) }); DataSources.Add(VW_Product); }