private void ReadPictureObject(XmlNode node, StiBand band) { StiImage image = new StiImage(); band.Components.Add(image); ReadComp(node, image); image.DataColumn = ReadString(node, "DataColumn", ""); }
public virtual StiReport CreateReport([NotNull] OrderReportModel model) { Assert.ArgumentNotNull(model, "model"); StiReport report = new StiReport(); string language = string.IsNullOrEmpty(model.LanguageCode) ? Sitecore.Context.Language.Name : model.LanguageCode; string reportFilePath = FileUtil.MapPath(this.ReportFile); StiConfig.ApplicationDirectory = FileUtil.GetParentPath(reportFilePath); string reportFileName = Path.GetFileNameWithoutExtension(reportFilePath); reportFileName = string.Concat(reportFileName, "-", language, ".dll"); string compiledReportFile = FileUtil.MakePath(StiConfig.ApplicationDirectory, reportFileName); if (!this.reportHelper.CheckIfCompiledReportExists(compiledReportFile)) { report.Load(reportFilePath); report.Dictionary.Variables[UrlKey].Value = this.GetLogoUrl(); report.AutoLocalizeReportOnRun = true; this.reportTranslator.Translate(report, language); StiImage image = (StiImage)report.GetComponentByName(LogoImageKey); string reportLogoFilePath = FileUtil.MapPath(this.LogoFile); image.Image = System.Drawing.Image.FromFile(reportLogoFilePath); this.reportHelper.CompileReport(report, compiledReportFile); } else { report = this.reportHelper.GetCompiledReport(compiledReportFile); } if (model.CompanyMasterData != null) { model.CompanyMasterData.ReadData(); } if (model.Order != null) { report.RegData("Order", model); } return(report); }
private void ReadPictureBox(XRPictureBox xtraControl, StiContainer parent) { StiImage image = new StiImage(); parent.Components.Add(image); ReadComp(xtraControl, image); ReadBrush(xtraControl, image); ReadTextBrush(xtraControl, image); ReadBorder(xtraControl, image); ReadFont(xtraControl, image); image.ImageURL.Value = xtraControl.ImageUrl; image.Image = xtraControl.Image; #region Sizing switch (xtraControl.Sizing) { case DevExpress.XtraPrinting.ImageSizeMode.AutoSize: case DevExpress.XtraPrinting.ImageSizeMode.StretchImage: image.Stretch = true; break; case DevExpress.XtraPrinting.ImageSizeMode.CenterImage: image.HorAlignment = StiHorAlignment.Center; image.VertAlignment = StiVertAlignment.Center; break; case DevExpress.XtraPrinting.ImageSizeMode.ZoomImage: image.AspectRatio = true; image.Stretch = true; break; } #endregion }
private void AddPage(StiPage page, DataTable dataTable) { #region Page Parameters page.TitleBeforeHeader = true; page.Orientation = StiPageOrientation.Landscape; //log.OpenNode("Page Parameters"); //log.CloseNode(); #endregion #region Components //log.OpenNode("Page Components"); #region First pass bands = new List <StiBand>(); bandsTop = new List <double>(); foreach (DataRow dr in dataTable.Rows) { dataRow = dr; ObjType objType = (ObjType)GetInt("OBJTYPE"); int objCode = GetInt("OBJCODE"); double height = GetDouble("HEIGHT"); double width = GetDouble("WIDTH"); switch (objType) { case ObjType.Bandinfo: var band = TypeBand(objCode); band.Height = fru(height); page.Components.Add(band); bands.Add(band); bandsTop.Add(((bandsTop.Count == 0) ? 0 : bandsTop[bandsTop.Count - 1]) + height + headerHeight); break; case ObjType.Variable: var variable = new StiVariable(); variable.Name = GetString("NAME"); variable.Alias = variable.Name; variable.InitBy = StiVariableInitBy.Expression; variable.Value = GetString("EXPR"); variable.Type = typeof(object); variable.RequestFromUser = true; page.Report.Dictionary.Variables.Add(variable); break; } } #endregion #region Second pass foreach (DataRow dr in dataTable.Rows) { dataRow = dr; ObjType objType = (ObjType)GetInt("OBJTYPE"); int objCode = GetInt("OBJCODE"); double height = GetDouble("HEIGHT"); double width = GetDouble("WIDTH"); switch (objType) { case ObjType.Label: var stiText5 = new StiText(); AddToBandAndGetCommonProperties(stiText5); stiText5.TextBrush = new StiSolidBrush(GetPenColor()); stiText5.Brush = GetFillBrush(); string stiText5Expr = GetString("EXPR"); stiText5.Text = stiText5Expr.Substring(1, stiText5Expr.Length - 2); stiText5.Font = GetFont(); break; case ObjType.Field: var stiText8 = new StiText(); AddToBandAndGetCommonProperties(stiText8); stiText8.TextBrush = new StiSolidBrush(GetPenColor()); stiText8.Brush = GetFillBrush(); stiText8.Text = ConvertExpression("{" + GetString("EXPR") + "}", stiText8); stiText8.Font = GetFont(); #region TextFormat string fillChar = GetString("FILLCHAR"); if (fillChar == "N") { StiNumberFormatService format = new StiNumberFormatService(); string picture = GetString("PICTURE"); if (!string.IsNullOrEmpty(picture)) { int pos = picture.IndexOf("."); if (pos == -1) { format.DecimalDigits = 0; } else { format.DecimalDigits = picture.Substring(pos + 1).Length; } } stiText8.TextFormat = format; } if (fillChar == "D") { StiDateFormatService format = new StiDateFormatService(); stiText8.TextFormat = format; } #endregion #region Alignment int alignment = GetInt("OFFSET"); if (alignment == 1) { stiText8.HorAlignment = StiTextHorAlignment.Right; } if (alignment == 2) { stiText8.HorAlignment = StiTextHorAlignment.Center; } #endregion break; case ObjType.Line: StiLinePrimitive line = null; if (width > height) { line = new StiHorizontalLinePrimitive(); } else { line = new StiVerticalLinePrimitive(); } AddToBandAndGetCommonProperties(line); line.Color = GetPenColor(); line.Style = GetPenStyle(); line.Size = GetPenSize(); break; case ObjType.RectangleOrShape: //проверять - если есть заливка - то надо Shape StiRectanglePrimitive rectangle = null; int offset = GetInt("OFFSET"); if (offset == 0) { rectangle = new StiRectanglePrimitive(); } else { rectangle = new StiRoundedRectanglePrimitive(); (rectangle as StiRoundedRectanglePrimitive).Round = offset; } AddToBandAndGetCommonProperties(rectangle); rectangle.Color = GetPenColor(); rectangle.Style = GetPenStyle(); rectangle.Size = GetPenSize(); break; case ObjType.PictureOrOle: var image = new StiImage(); AddToBandAndGetCommonProperties(image); int sourceType = GetInt("OFFSET"); if (sourceType == 0) { image.ImageURL.Value = GetString("PICTURE").Trim(); } if (sourceType == 1) { image.DataColumn = ConvertExpression("{" + GetString("NAME").Trim() + "}", image); } if (sourceType == 2) { string imageName = GetString("NAME").Trim(); if (imageName.StartsWith("(") && imageName.EndsWith(")")) { imageName = imageName.Substring(1, imageName.Length - 2); } image.ImageData = new StiImageDataExpression(ConvertExpression("{" + imageName + "}", image)); } break; case ObjType.Variable: var variable = new StiVariable(); variable.Name = GetString("NAME"); variable.Alias = variable.Name; variable.InitBy = StiVariableInitBy.Expression; string varValue = ConvertExpression("{" + GetString("EXPR") + "}", null); variable.Value = varValue.Substring(1, varValue.Length - 2); variable.Type = typeof(object); variable.RequestFromUser = true; page.Report.Dictionary.Variables.Add(variable); break; case ObjType.Bandinfo: case ObjType.Font: //none, skip break; default: //log.WriteNode(string.Format("Unsupported OBJTYPE={0}", objType)); break; } } #endregion //log.CloseNode(); #endregion page.DockToContainer(); page.Correct(); }
private void InitializeComponent() { T_Detail = new T_DetailDataSource(); Dictionary.Variables.Add(new StiVariable("", "MyCompanyName", "MyCompanyName", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyTaxCode", "MyCompanyTaxCode", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyDirectorName", "MyCompanyDirectorName", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyCountryCode", "MyCompanyCountryCode", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyCountryName", "MyCompanyCountryName", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyCity", "MyCompanyCity", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyPostalCode", "MyCompanyPostalCode", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyAddress", "MyCompanyAddress", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyPhone", "MyCompanyPhone", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyFax", "MyCompanyFax", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyBankName", "MyCompanyBankName", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyBankCode", "MyCompanyBankCode", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyBankAccountNumber", "MyCompanyBankAccountNumber", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyVATPayerFlag", "MyCompanyVATPayerFlag", "", typeof(bool), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyConditionalUnitCurrencyCode", "MyCompanyConditionalUnitCurrencyCode", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyDefaultTradingCurrencyCode", "MyCompanyDefaultTradingCurrencyCode", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyConditionalUnitCurrencyRate", "MyCompanyConditionalUnitCurrencyRate", "", typeof(decimal), "", false, false, false)); NeedsCompiling = false; // Variables init // Variables init MyCompanyName = ""; MyCompanyTaxCode = ""; MyCompanyDirectorName = ""; MyCompanyCountryCode = ""; MyCompanyCountryName = ""; MyCompanyCity = ""; MyCompanyPostalCode = ""; MyCompanyAddress = ""; MyCompanyPhone = ""; MyCompanyFax = ""; MyCompanyBankName = ""; MyCompanyBankCode = ""; MyCompanyBankAccountNumber = ""; MyCompanyVATPayerFlag = false; MyCompanyConditionalUnitCurrencyCode = ""; MyCompanyDefaultTradingCurrencyCode = ""; MyCompanyConditionalUnitCurrencyRate = 0m; EngineVersion = StiEngineVersion.EngineV2; ReferencedAssemblies = new[] { "System.Dll", "System.Drawing.Dll", "System.Windows.Forms.Dll", "System.Data.Dll", "System.Xml.Dll", "Stimulsoft.Controls.Dll", "Stimulsoft.Base.Dll", "Stimulsoft.Report.Dll" }; ReportAlias = "Rpt Produc Location Price"; ReportAuthor = "Programmer.GE"; // // ReportChanged // ReportChanged = new DateTime(2011, 6, 12, 21, 55, 48, 0); // // ReportCreated // ReportCreated = new DateTime(2009, 6, 28, 22, 3, 23, 0); ReportDescription = "პრაისი"; ReportFile = "D:\\User\\Documents\\Projects\\Apothex\\Source\\Class Library\\Apothex.Reporting\\Product" + "ion\\RptProducLocationPrice.mrt"; ReportGuid = "e242476ffaeb44b39344532841ed84f0"; ReportName = "RptProducLocationPrice"; ReportUnit = StiReportUnitType.Centimeters; ReportVersion = "2010.3.900"; ScriptLanguage = StiReportLanguageType.CSharp; // // Page1 // Page1 = new StiPage(); Page1.Columns = 2; Page1.Guid = "0edad2017ef5402da56612e0faa7a32a"; Page1.Name = "Page1"; Page1.PageHeight = 29.7; Page1.PageWidth = 21; Page1.PaperSize = PaperKind.A4; Page1.Border = new StiBorder(StiBorderSides.None, Color.Black, 2, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); Page1.Brush = new StiSolidBrush(Color.Transparent); // // PageHeaderBand1 // PageHeaderBand1 = new StiPageHeaderBand(); PageHeaderBand1.ClientRectangle = new RectangleD(0, 0.4, 20, 2.2); PageHeaderBand1.Name = "PageHeaderBand1"; PageHeaderBand1.PrintOn = StiPrintOnType.OnlyFirstPage; PageHeaderBand1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); PageHeaderBand1.Brush = new StiSolidBrush(Color.Transparent); // // Text4 // Text4 = new StiText(); Text4.ClientRectangle = new RectangleD(2.4, 0, 7.6, 2); Text4.Name = "Text4"; Text4.GetValue += new StiGetValueEventHandler(Text4__GetValue); Text4.VertAlignment = StiVertAlignment.Center; Text4.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); Text4.Brush = new StiSolidBrush(Color.Transparent); Text4.Font = new Font("BPG Glaho Arial", 7F, FontStyle.Bold); Text4.Guid = null; Text4.Interaction = null; Text4.Margins = new StiMargins(0, 0, 0, 0); Text4.TextBrush = new StiSolidBrush(Color.Black); Text4.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None); // // Image1 // Image1 = new StiImage(); Image1.AspectRatio = true; Image1.ClientRectangle = new RectangleD(0, 0, 2, 2); Image1.Guid = "b4725dd4d92a41f5a0f373916b5b430e"; Image1.HorAlignment = StiHorAlignment.Center; Image1.Name = "Image1"; Image1.Stretch = true; Image1.VertAlignment = StiVertAlignment.Center; Image1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); Image1.Brush = new StiSolidBrush(Color.Transparent); Image1.Image = null; Image1.Interaction = null; PageHeaderBand1.Guid = null; PageHeaderBand1.Interaction = null; // // PageFooterBand1 // PageFooterBand1 = new StiPageFooterBand(); PageFooterBand1.ClientRectangle = new RectangleD(0, 28.1, 20, 0.6); PageFooterBand1.Name = "PageFooterBand1"; PageFooterBand1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); PageFooterBand1.Brush = new StiSolidBrush(Color.Transparent); // // Text3 // Text3 = new StiText(); Text3.ClientRectangle = new RectangleD(0, 0, 19, 0.6); Text3.HorAlignment = StiTextHorAlignment.Center; Text3.Name = "Text3"; Text3.GetValue += new StiGetValueEventHandler(Text3__GetValue); Text3.VertAlignment = StiVertAlignment.Center; Text3.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); Text3.Brush = new StiSolidBrush(Color.Transparent); Text3.Font = new Font("Arial", 8F); Text3.Guid = null; Text3.Interaction = null; Text3.Margins = new StiMargins(0, 0, 0, 0); Text3.TextBrush = new StiSolidBrush(Color.Black); Text3.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None); PageFooterBand1.Guid = null; PageFooterBand1.Interaction = null; // // HeaderVW_ProductLocation // HeaderVW_ProductLocation = new StiHeaderBand(); HeaderVW_ProductLocation.ClientRectangle = new RectangleD(0, 3.4, 10, 0.6); HeaderVW_ProductLocation.Name = "HeaderVW_ProductLocation"; HeaderVW_ProductLocation.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); HeaderVW_ProductLocation.Brush = new StiSolidBrush(Color.Transparent); // // HeaderVW_ProductLocation_MedicamentName // HeaderVW_ProductLocation_MedicamentName = new StiText(); HeaderVW_ProductLocation_MedicamentName.ClientRectangle = new RectangleD(0, 0, 5.2, 0.6); HeaderVW_ProductLocation_MedicamentName.HorAlignment = StiTextHorAlignment.Center; HeaderVW_ProductLocation_MedicamentName.Name = "HeaderVW_ProductLocation_MedicamentName"; HeaderVW_ProductLocation_MedicamentName.GetValue += new StiGetValueEventHandler(HeaderVW_ProductLocation_MedicamentName__GetValue); HeaderVW_ProductLocation_MedicamentName.VertAlignment = StiVertAlignment.Center; HeaderVW_ProductLocation_MedicamentName.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); HeaderVW_ProductLocation_MedicamentName.Brush = new StiSolidBrush(Color.Gainsboro); HeaderVW_ProductLocation_MedicamentName.Font = new Font("BPG Glaho Arial", 7F, FontStyle.Bold); HeaderVW_ProductLocation_MedicamentName.Guid = null; HeaderVW_ProductLocation_MedicamentName.Interaction = null; HeaderVW_ProductLocation_MedicamentName.Margins = new StiMargins(0, 0, 0, 0); HeaderVW_ProductLocation_MedicamentName.TextBrush = new StiSolidBrush(Color.Black); HeaderVW_ProductLocation_MedicamentName.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // HeaderVW_ProductLocation_CountryName // HeaderVW_ProductLocation_CountryName = new StiText(); HeaderVW_ProductLocation_CountryName.ClientRectangle = new RectangleD(5.2, 0, 2.2, 0.6); HeaderVW_ProductLocation_CountryName.HorAlignment = StiTextHorAlignment.Center; HeaderVW_ProductLocation_CountryName.Name = "HeaderVW_ProductLocation_CountryName"; HeaderVW_ProductLocation_CountryName.GetValue += new StiGetValueEventHandler(HeaderVW_ProductLocation_CountryName__GetValue); HeaderVW_ProductLocation_CountryName.VertAlignment = StiVertAlignment.Center; HeaderVW_ProductLocation_CountryName.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); HeaderVW_ProductLocation_CountryName.Brush = new StiSolidBrush(Color.Gainsboro); HeaderVW_ProductLocation_CountryName.Font = new Font("BPG Glaho Arial", 7F, FontStyle.Bold); HeaderVW_ProductLocation_CountryName.Guid = null; HeaderVW_ProductLocation_CountryName.Interaction = null; HeaderVW_ProductLocation_CountryName.Margins = new StiMargins(0, 0, 0, 0); HeaderVW_ProductLocation_CountryName.TextBrush = new StiSolidBrush(Color.Black); HeaderVW_ProductLocation_CountryName.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // HeaderVW_ProductLocation_ListPrice // HeaderVW_ProductLocation_ListPrice = new StiText(); HeaderVW_ProductLocation_ListPrice.ClientRectangle = new RectangleD(9, 0, 1, 0.6); HeaderVW_ProductLocation_ListPrice.HorAlignment = StiTextHorAlignment.Center; HeaderVW_ProductLocation_ListPrice.Name = "HeaderVW_ProductLocation_ListPrice"; HeaderVW_ProductLocation_ListPrice.GetValue += new StiGetValueEventHandler(HeaderVW_ProductLocation_ListPrice__GetValue); HeaderVW_ProductLocation_ListPrice.VertAlignment = StiVertAlignment.Center; HeaderVW_ProductLocation_ListPrice.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); HeaderVW_ProductLocation_ListPrice.Brush = new StiSolidBrush(Color.Gainsboro); HeaderVW_ProductLocation_ListPrice.Font = new Font("BPG Glaho Arial", 7F, FontStyle.Bold); HeaderVW_ProductLocation_ListPrice.Guid = null; HeaderVW_ProductLocation_ListPrice.Interaction = null; HeaderVW_ProductLocation_ListPrice.Margins = new StiMargins(0, 0, 0, 0); HeaderVW_ProductLocation_ListPrice.TextBrush = new StiSolidBrush(Color.Black); HeaderVW_ProductLocation_ListPrice.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // Text2 // Text2 = new StiText(); Text2.ClientRectangle = new RectangleD(7.4, 0, 1.6, 0.6); Text2.Guid = "b2ee6a7204874db4bc1e2bae90edc3a9"; Text2.HorAlignment = StiTextHorAlignment.Center; Text2.Name = "Text2"; Text2.GetValue += new StiGetValueEventHandler(Text2__GetValue); Text2.Type = StiSystemTextType.Expression; Text2.VertAlignment = StiVertAlignment.Center; Text2.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); Text2.Brush = new StiSolidBrush(Color.Gainsboro); Text2.Font = new Font("BPG Glaho Arial", 7F, FontStyle.Bold); Text2.Interaction = null; Text2.Margins = new StiMargins(0, 0, 0, 0); Text2.TextBrush = new StiSolidBrush(Color.Black); Text2.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); HeaderVW_ProductLocation.Guid = null; HeaderVW_ProductLocation.Interaction = null; // // DataVW_ProductLocation // DataVW_ProductLocation = new StiDataBand(); DataVW_ProductLocation.ClientRectangle = new RectangleD(0, 4.8, 10, 0.6); DataVW_ProductLocation.DataSourceName = "T_Detail"; DataVW_ProductLocation.Name = "DataVW_ProductLocation"; DataVW_ProductLocation.Sort = new[] { "ASC", "ProductName" }; DataVW_ProductLocation.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); DataVW_ProductLocation.Brush = new StiSolidBrush(Color.Transparent); DataVW_ProductLocation.BusinessObjectGuid = null; // // DataVW_ProductLocation_MedicamentName // DataVW_ProductLocation_MedicamentName = new StiText(); DataVW_ProductLocation_MedicamentName.CanGrow = true; DataVW_ProductLocation_MedicamentName.ClientRectangle = new RectangleD(0, 0, 5.2, 0.6); DataVW_ProductLocation_MedicamentName.Name = "DataVW_ProductLocation_MedicamentName"; DataVW_ProductLocation_MedicamentName.GetValue += new StiGetValueEventHandler(DataVW_ProductLocation_MedicamentName__GetValue); DataVW_ProductLocation_MedicamentName.VertAlignment = StiVertAlignment.Center; DataVW_ProductLocation_MedicamentName.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); DataVW_ProductLocation_MedicamentName.Brush = new StiSolidBrush(Color.Transparent); DataVW_ProductLocation_MedicamentName.Font = new Font("BPG Glaho Arial", 6F); DataVW_ProductLocation_MedicamentName.Guid = null; DataVW_ProductLocation_MedicamentName.Interaction = null; DataVW_ProductLocation_MedicamentName.Margins = new StiMargins(0, 0, 0, 0); DataVW_ProductLocation_MedicamentName.TextBrush = new StiSolidBrush(Color.Black); DataVW_ProductLocation_MedicamentName.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // DataVW_ProductLocation_CountryName // DataVW_ProductLocation_CountryName = new StiText(); DataVW_ProductLocation_CountryName.CanGrow = true; DataVW_ProductLocation_CountryName.ClientRectangle = new RectangleD(5.2, 0, 2.2, 0.6); DataVW_ProductLocation_CountryName.HorAlignment = StiTextHorAlignment.Right; DataVW_ProductLocation_CountryName.Name = "DataVW_ProductLocation_CountryName"; DataVW_ProductLocation_CountryName.GetValue += new StiGetValueEventHandler(DataVW_ProductLocation_CountryName__GetValue); DataVW_ProductLocation_CountryName.VertAlignment = StiVertAlignment.Center; DataVW_ProductLocation_CountryName.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); DataVW_ProductLocation_CountryName.Brush = new StiSolidBrush(Color.Transparent); DataVW_ProductLocation_CountryName.Font = new Font("BPG Glaho Arial", 6F); DataVW_ProductLocation_CountryName.Guid = null; DataVW_ProductLocation_CountryName.Interaction = null; DataVW_ProductLocation_CountryName.Margins = new StiMargins(0, 0, 0, 0); DataVW_ProductLocation_CountryName.TextBrush = new StiSolidBrush(Color.Black); DataVW_ProductLocation_CountryName.TextFormat = new StiPercentageFormatService(0, 0, ",", 4, " ", 3, "%", true, false, " "); DataVW_ProductLocation_CountryName.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // DataVW_ProductLocation_ListPrice // DataVW_ProductLocation_ListPrice = new StiText(); DataVW_ProductLocation_ListPrice.CanGrow = true; DataVW_ProductLocation_ListPrice.ClientRectangle = new RectangleD(9, 0, 1, 0.6); DataVW_ProductLocation_ListPrice.HorAlignment = StiTextHorAlignment.Right; DataVW_ProductLocation_ListPrice.Name = "DataVW_ProductLocation_ListPrice"; DataVW_ProductLocation_ListPrice.GetValue += new StiGetValueEventHandler(DataVW_ProductLocation_ListPrice__GetValue); DataVW_ProductLocation_ListPrice.VertAlignment = StiVertAlignment.Center; DataVW_ProductLocation_ListPrice.Border = new StiBorder(StiBorderSides.Right, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); DataVW_ProductLocation_ListPrice.Brush = new StiSolidBrush(Color.Transparent); DataVW_ProductLocation_ListPrice.Font = new Font("BPG Glaho Arial", 6F); DataVW_ProductLocation_ListPrice.Guid = null; DataVW_ProductLocation_ListPrice.Interaction = null; DataVW_ProductLocation_ListPrice.Margins = new StiMargins(0, 0, 0, 0); DataVW_ProductLocation_ListPrice.TextBrush = new StiSolidBrush(Color.Black); DataVW_ProductLocation_ListPrice.TextFormat = new StiNumberFormatService(1, ",", 2, " ", 3, true, false, " "); DataVW_ProductLocation_ListPrice.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // Text1 // Text1 = new StiText(); Text1.CanGrow = true; Text1.ClientRectangle = new RectangleD(7.4, 0, 1.6, 0.6); Text1.Guid = "5cfcbb441d534f4ba95c949ddd2c6da5"; Text1.HorAlignment = StiTextHorAlignment.Right; Text1.Name = "Text1"; Text1.GetValue += new StiGetValueEventHandler(Text1__GetValue); Text1.Type = StiSystemTextType.DataColumn; Text1.VertAlignment = StiVertAlignment.Center; Text1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); Text1.Brush = new StiSolidBrush(Color.Transparent); Text1.Font = new Font("BPG Glaho Arial", 6F); Text1.Interaction = null; Text1.Margins = new StiMargins(0, 0, 0, 0); Text1.TextBrush = new StiSolidBrush(Color.Black); Text1.TextFormat = new StiPercentageFormatService(0, 0, ",", 2, " ", 3, "%", true, true, " "); Text1.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); DataVW_ProductLocation.DataRelationName = null; DataVW_ProductLocation.Guid = null; DataVW_ProductLocation.Interaction = null; DataVW_ProductLocation.MasterComponent = null; Page1.ExcelSheetValue = null; Page1.Interaction = null; Page1.Margins = new StiMargins(0.5, 0.5, 0.5, 0.5); Page1_Watermark = new StiWatermark(); Page1_Watermark.Font = new Font("Arial", 100F); Page1_Watermark.Image = null; Page1_Watermark.TextBrush = new StiSolidBrush(Color.FromArgb(50, 0, 0, 0)); Page1.Rendering += new EventHandler(Page1_Rendering); RptProducLocationPrice_PrinterSettings = new StiPrinterSettings(); PrinterSettings = RptProducLocationPrice_PrinterSettings; Page1.Report = this; Page1.Watermark = Page1_Watermark; PageHeaderBand1.Page = Page1; PageHeaderBand1.Parent = Page1; Text4.Page = Page1; Text4.Parent = PageHeaderBand1; Image1.Page = Page1; Image1.Parent = PageHeaderBand1; PageFooterBand1.Page = Page1; PageFooterBand1.Parent = Page1; Text3.Page = Page1; Text3.Parent = PageFooterBand1; HeaderVW_ProductLocation.Page = Page1; HeaderVW_ProductLocation.Parent = Page1; HeaderVW_ProductLocation_MedicamentName.Page = Page1; HeaderVW_ProductLocation_MedicamentName.Parent = HeaderVW_ProductLocation; HeaderVW_ProductLocation_CountryName.Page = Page1; HeaderVW_ProductLocation_CountryName.Parent = HeaderVW_ProductLocation; HeaderVW_ProductLocation_ListPrice.Page = Page1; HeaderVW_ProductLocation_ListPrice.Parent = HeaderVW_ProductLocation; Text2.Page = Page1; Text2.Parent = HeaderVW_ProductLocation; DataVW_ProductLocation.Page = Page1; DataVW_ProductLocation.Parent = Page1; DataVW_ProductLocation_MedicamentName.Page = Page1; DataVW_ProductLocation_MedicamentName.Parent = DataVW_ProductLocation; DataVW_ProductLocation_CountryName.Page = Page1; DataVW_ProductLocation_CountryName.Parent = DataVW_ProductLocation; DataVW_ProductLocation_ListPrice.Page = Page1; DataVW_ProductLocation_ListPrice.Parent = DataVW_ProductLocation; Text1.Page = Page1; Text1.Parent = DataVW_ProductLocation; EndRender += new EventHandler(RptProducLocationPriceWordsToEnd__EndRender); // // Add to PageHeaderBand1.Components // PageHeaderBand1.Components.Clear(); PageHeaderBand1.Components.AddRange(new StiComponent[] { Text4, Image1 }); // // Add to PageFooterBand1.Components // PageFooterBand1.Components.Clear(); PageFooterBand1.Components.AddRange(new StiComponent[] { Text3 }); // // Add to HeaderVW_ProductLocation.Components // HeaderVW_ProductLocation.Components.Clear(); HeaderVW_ProductLocation.Components.AddRange(new StiComponent[] { HeaderVW_ProductLocation_MedicamentName, HeaderVW_ProductLocation_CountryName, HeaderVW_ProductLocation_ListPrice, Text2 }); // // Add to DataVW_ProductLocation.Components // DataVW_ProductLocation.Components.Clear(); DataVW_ProductLocation.Components.AddRange(new StiComponent[] { DataVW_ProductLocation_MedicamentName, DataVW_ProductLocation_CountryName, DataVW_ProductLocation_ListPrice, Text1 }); // // Add to Page1.Components // Page1.Components.Clear(); Page1.Components.AddRange(new StiComponent[] { PageHeaderBand1, PageFooterBand1, HeaderVW_ProductLocation, DataVW_ProductLocation }); // // Add to Pages // Pages.Clear(); Pages.AddRange(new[] { Page1 }); T_Detail.Columns.AddRange(new[] { new StiDataColumn("ProductID", "ProductID", "ProductID", typeof(int)), new StiDataColumn("ProductName", "ProductName", "ProductName", typeof(string)), new StiDataColumn("CountryName", "CountryName", "CountryName", typeof(string)), new StiDataColumn("Serie", "Serie", "Serie", typeof(string)), new StiDataColumn("UnitPrice", "UnitPrice", "UnitPrice", typeof(decimal)), new StiDataColumn("Discount", "Discount", "Discount", typeof(decimal)) }); DataSources.Add(T_Detail); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int reqID = Convert.ToInt32(Request.QueryString["r"]); DataTable request = business.GetCheckOutInfoByReqId(reqID); int s = Convert.ToInt32(request.Rows[0]["RequestLogId"]); issuerID = business.GetCheckOutStudentIDByReqID(reqID); CheckOutStatusEnum.FareghReqStatus status = new CheckOutStatusEnum.FareghReqStatus(); status = (CheckOutStatusEnum.FareghReqStatus)s; _signList = business.GetAllSigns(); //string stcode = business.GetCheckOutStudentIDByReqID(reqID); this.StiWebViewer1.ResetReport(); StiWebViewer1.Visible = true; StiReport rpt = new StiReport(); rpt.Load(Server.MapPath("../Reports/CheckOutPrint2.mrt")); rpt.ReportCacheMode = StiReportCacheMode.On; rpt.Dictionary.Databases.Clear(); rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.ReportConnection.ToString())); if (status >= CheckOutStatusEnum.FareghReqStatus.amoozesh_ok) { StiImage amoozesh = rpt.GetComponents()["Table1_Cell10"] as StiImage; amoozesh.Image = byteArrayToImage((int)CheckOutStatusEnum.FareghReqStatus.amoozesh_ok, reqID); } if (status >= CheckOutStatusEnum.FareghReqStatus.daneshjooyi_ok) { StiImage daneshjooyi = rpt.GetComponents()["Table1_Cell16"] as StiImage; daneshjooyi.Image = byteArrayToImage((int)CheckOutStatusEnum.FareghReqStatus.daneshjooyi_ok, reqID); } if (status >= CheckOutStatusEnum.FareghReqStatus.pajohesh_ok) { StiImage pajoohesh = rpt.GetComponents()["Table1_Cell22"] as StiImage; pajoohesh.Image = byteArrayToImage((int)CheckOutStatusEnum.FareghReqStatus.pajohesh_ok, reqID); } if (status >= CheckOutStatusEnum.FareghReqStatus.refah_ok) { StiImage refah = rpt.GetComponents()["Table1_Cell28"] as StiImage; refah.Image = byteArrayToImage((int)CheckOutStatusEnum.FareghReqStatus.refah_ok, reqID); } if (status >= CheckOutStatusEnum.FareghReqStatus.maali_ok) { StiImage maali = rpt.GetComponents()["Table1_Cell7"] as StiImage; maali.Image = byteArrayToImage((int)CheckOutStatusEnum.FareghReqStatus.maali_ok, reqID); } if (status >= CheckOutStatusEnum.FareghReqStatus.mashmulan_ok) { StiImage mashmoolan = rpt.GetComponents()["Table1_Cell19"] as StiImage; bool isMale = business.isMale(issuerID); if (isMale) { bool ismashmool = isMashmool(issuerID); if (ismashmool) { bool bayganiOk = Convert.ToBoolean(request.Rows[0]["BayganiOk"]); if (bayganiOk) { mashmoolan.Image = byteArrayToImage((int)CheckOutStatusEnum.FareghReqStatus.mashmulan_ok, reqID); } else { mashmoolan.Image = GetImageFromFile(imagetype.mashmool); } } else { mashmoolan.Image = byteArrayToImage((int)CheckOutStatusEnum.FareghReqStatus.mashmulan_ok, reqID); } } else { mashmoolan.Image = GetImageFromFile(imagetype.woman); } } if (status >= CheckOutStatusEnum.FareghReqStatus.fani_ok) { StiImage fani = rpt.GetComponents()["Table1_Cell13"] as StiImage; fani.Image = byteArrayToImage((int)CheckOutStatusEnum.FareghReqStatus.fani_ok, reqID); } if (status >= CheckOutStatusEnum.FareghReqStatus.archive_ok) { DataTable dtUserID = new DataTable(); dtUserID = business.getArchiveUserSignByStudentStcode(issuerID); decimal userID = 0; if (dtUserID.Rows[0]["userID"] != DBNull.Value) { userID = Convert.ToDecimal(dtUserID.Rows[0]["userID"]); } StiImage archive = rpt.GetComponents()["Table1_Cell25"] as StiImage; archive.Image = byteArrayToImageArchive((int)CheckOutStatusEnum.FareghReqStatus.archive_ok, userID, reqID); } rpt.Compile(); rpt.CompiledReport.DataSources["[Request].[SP_GetStudentInfoForCheckOut2]"].Parameters["@stdcode"].ParameterValue = issuerID; rpt.CompiledReport.DataSources["[Request].[SP_Get_StudentLoanInfo]"].Parameters["@stcode"].ParameterValue = issuerID; //DataTable dtResault = new DataTable(); //rpt.RegData(dtResault); StiWebViewer1.Report = rpt; StiWebViewer1.Visible = true; } }