private void ReadGroupHeaderBand(XtraReportBase xtraReport, GroupHeaderBand xtraBand, StiPage page)
{
StiGroupHeaderBand band = new StiGroupHeaderBand();
page.Components.Add(band);
ReadBand(xtraBand, band);
}
private void ReadGroupHeaderBand(XmlNode node, StiPage page)
{
StiGroupHeaderBand band = new StiGroupHeaderBand();
page.Components.Add(band);
ReadBand(node, band);
string condition = ReadString(node, "Condition", band.Name);
band.Condition.Value = condition;
}
public IReportBuilder WithGroupHeaderBand(string expression, List <string> groupTitles = null, double height = 0.2)
{
CurrentGroupHeader = new StiGroupHeaderBand(MakeRectangle(0, 0, 0, height))
{
Condition = { Value = expression }
};
Page.Components.Add(CurrentGroupHeader);
var spaces = " ";
var titles = string.Join(spaces, groupTitles);
var stiText = _textBuilder.New(titles).WithSize(ContentWidth, height).WithFont(FontStyle.Bold)
.WithBorder(StiBorderSides.None).WithWordWrap(true).WithVAlign(StiVertAlignment.Bottom).Then();
CurrentGroupHeader.Components.Add(stiText);
return(this);
}
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_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);
}
protected override bool WfExecReport(Stimulsoft.Report.StiReport pReport)
{
//DataSet ds;
vw_invr410 invr410Model;
StringBuilder sbSql = null;
string sqlBody = "";
DataTable dtIlaTb;
List <QueryInfo> queryInfoList;
QueryInfo queryModel;
string strQueryRange, strWhere;
StringBuilder sbQuerySingle = null;
List <SqlParameter> sqlParmList;
List <Master> resultList = null;
try
{
invr410Model = DrMaster.ToItem <vw_invr410>();
resultList = new List <Master>();
queryInfoList = new List <QueryInfo>();
#region range 處理
if (!GlobalFn.varIsNull(invr410Model.ila03))
{
queryModel = new QueryInfo();
queryModel.TableName = "ila_tb";
queryModel.ColumnName = "ila03";
queryModel.ColumnType = TabMaster.DtSource.Columns["ila03"].DataType.Name;
queryModel.Value = invr410Model.ila03;
queryInfoList.Add(queryModel);
}
if (!GlobalFn.varIsNull(invr410Model.ila04))
{
queryModel = new QueryInfo();
queryModel.TableName = "ila_tb";
queryModel.ColumnName = "ila04";
queryModel.ColumnType = TabMaster.DtSource.Columns["ila04"].DataType.Name;
queryModel.Value = invr410Model.ila04;
queryInfoList.Add(queryModel);
}
if (!GlobalFn.varIsNull(invr410Model.ila05))
{
queryModel = new QueryInfo();
queryModel.TableName = "ila_tb";
queryModel.ColumnName = "ila05";
queryModel.ColumnType = TabMaster.DtSource.Columns["ila05"].DataType.Name;
queryModel.Value = invr410Model.ila05;
queryInfoList.Add(queryModel);
}
sqlParmList = new List <SqlParameter>();
strQueryRange = BoMaster.WfGetQueryString(queryInfoList, out sqlParmList);
#endregion
#region single 處理
sbQuerySingle = new StringBuilder();
if (!GlobalFn.varIsNull(invr410Model.ila02_s))
{
sbQuerySingle.AppendLine("AND ila02>=@ila02_s");
sqlParmList.Add(new SqlParameter("@ila02_s", invr410Model.ila02_s));
}
if (!GlobalFn.varIsNull(invr410Model.ila02_e))
{
sbQuerySingle.AppendLine("AND ila02<=@ila02_e");
sqlParmList.Add(new SqlParameter("@ila02_e", invr410Model.ila02_e));
}
if (invr410Model.conf_yn != "0")
{
if (invr410Model.conf_yn == "1")
{
sbQuerySingle.AppendLine("AND ilaconf = 'Y'");
}
if (invr410Model.conf_yn == "2")
{
sbQuerySingle.AppendLine("AND ilaconf = 'N'");
}
}
if (invr410Model.close_yn != "0")
{
if (invr410Model.close_yn == "1")//未結案
{
sbQuerySingle.AppendLine("AND (ilb05-ilb15) >0 ");
}
if (invr410Model.close_yn == "2")//已結案
{
sbQuerySingle.AppendLine("AND (ilb05-ilb15) <=0 ");
}
}
#endregion
strWhere = strQueryRange + " " + sbQuerySingle.ToString();
var strSecurity = WfGetSecurityString(); //取得權限字串
if (!GlobalFn.varIsNull(strSecurity))
{
strWhere += strSecurity;
}
//取得單頭
sqlBody = @"
SELECT
ila01,ila02,ila03,sca03 as ila03_c ,
ilb02,ila04,bec02 AS ila04_c,ila05,beb03 AS ila05_c,
ilb03,ilb04,ilb05,'' as ilb05_str,ilb06,
bej03,ilb11,
ilb15,'' as ilb15_str,
ilb16
FROM ila_tb
LEFT JOIN ilb_tb ON ila01=ilb01
LEFT JOIN sca_tb ON ila03=sca01
LEFT JOIN bec_tb ON ila04=bec01
LEFT JOIN beb_tb ON ila05=beb01
LEFT JOIN bej_tb ON ilb06=bej01
WHERE ilaconf='Y'
AND ilb01 IS NOT NULL
";
dtIlaTb = BoMaster.OfGetDataTable(string.Concat(sqlBody, strWhere), sqlParmList.ToArray());
dtIlaTb.TableName = "Master";
if (dtIlaTb != null)
{
resultList.AddRange(dtIlaTb.ToList <Master>());
}
if (resultList == null || resultList.Count == 0)
{
WfShowErrorMsg("查無資料,請重新過濾條件!");
return(false);
}
foreach (Master masterModel in resultList)
{
//數量處理
masterModel.ilb05_str = string.Format("{0:N" + masterModel.bej03 + "}", masterModel.ilb05); //數量
masterModel.ilb15_str = string.Format("{0:N" + masterModel.bej03 + "}", masterModel.ilb15); //數量
}
pReport.RegData("master", resultList);
pReport.CacheAllData = true;
//處理排序--這裡利用group來達到
StiGroupHeaderBand stiGroupHeaderBand1 = (StiGroupHeaderBand)pReport.GetComponents()["GroupHeaderBand1"];
switch (invr410Model.order_by)
{
case "1": //1.依出庫日期
stiGroupHeaderBand1.Condition.Value = "{Master.ila02}";
break;
case "2": //2.依客戶
stiGroupHeaderBand1.Condition.Value = "{Master.ila03}";
break;
case "3": //3.依部門
stiGroupHeaderBand1.Condition.Value = "{Master.ila05}";
break;
case "4": //4.依業務
stiGroupHeaderBand1.Condition.Value = "{Master.ila04}";
break;
case "5": //4.依出庫倉
stiGroupHeaderBand1.Condition.Value = "{Master.ila11}";
break;
}
//處理跳頁
StiDataBand dataBand1 = (StiDataBand)pReport.GetComponents()["DataBand1"];
if (invr410Model.jump_yn.ToUpper() == "Y")
{
dataBand1.NewPageAfter = true;
dataBand1.ResetPageNumber = true;
}
else
{
dataBand1.NewPageAfter = false;
dataBand1.ResetPageNumber = false;
}
pReport.Compile();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
protected override bool WfExecReport(Stimulsoft.Report.StiReport pReport)
{
//DataSet ds;
vw_stpr410 stpr410Model;
StringBuilder sbSql = null;
string sqlBody = "";
DataTable dtSgaTb, dtShaTb;
List <QueryInfo> queryInfoList;
QueryInfo queryModel;
string strQueryRange, strWhere;
StringBuilder sbQuerySingle = null;
List <SqlParameter> sqlParmList;
List <MasterA> resultList = null;
try
{
stpr410Model = DrMaster.ToItem <vw_stpr410>();
resultList = new List <MasterA>();
#region 處理銷售
if (stpr410Model.sale_type == "0" || stpr410Model.sale_type == "1")
{
queryInfoList = new List <QueryInfo>();
#region range 處理
if (!GlobalFn.varIsNull(stpr410Model.sga03))
{
queryModel = new QueryInfo();
queryModel.TableName = "sga_tb";
queryModel.ColumnName = "sga03";
queryModel.ColumnType = TabMaster.DtSource.Columns["sga03"].DataType.Name;
queryModel.Value = stpr410Model.sga03;
queryInfoList.Add(queryModel);
}
if (!GlobalFn.varIsNull(stpr410Model.sga04))
{
queryModel = new QueryInfo();
queryModel.TableName = "sga_tb";
queryModel.ColumnName = "sga04";
queryModel.ColumnType = TabMaster.DtSource.Columns["sga04"].DataType.Name;
queryModel.Value = stpr410Model.sga04;
queryInfoList.Add(queryModel);
}
if (!GlobalFn.varIsNull(stpr410Model.sga05))
{
queryModel = new QueryInfo();
queryModel.TableName = "sga_tb";
queryModel.ColumnName = "sga05";
queryModel.ColumnType = TabMaster.DtSource.Columns["sga05"].DataType.Name;
queryModel.Value = stpr410Model.sga05;
queryInfoList.Add(queryModel);
}
sqlParmList = new List <SqlParameter>();
strQueryRange = BoMaster.WfGetQueryString(queryInfoList, out sqlParmList);
#endregion
#region single 處理
sbQuerySingle = new StringBuilder();
if (!GlobalFn.varIsNull(stpr410Model.sga02_s))
{
sbQuerySingle.AppendLine("AND sga02>=@sga02_s");
sqlParmList.Add(new SqlParameter("@sga02_s", stpr410Model.sga02_s));
}
if (!GlobalFn.varIsNull(stpr410Model.sga02_e))
{
sbQuerySingle.AppendLine("AND sga02<=@sga02_e");
sqlParmList.Add(new SqlParameter("@sga02_e", stpr410Model.sga02_e));
}
if (stpr410Model.confirm_type == "1")
{
sbQuerySingle.AppendLine("AND sgaconf ='Y'");
}
else if (stpr410Model.confirm_type == "2")
{
sbQuerySingle.AppendLine("AND ISNULL(sgaconf,'') <>'Y'");
}
#endregion
strWhere = strQueryRange + " " + sbQuerySingle.ToString();
var strSecurity = WfGetSecurityString(); //取得權限字串
if (!GlobalFn.varIsNull(strSecurity))
{
strWhere += strSecurity;
}
//取得單頭
sqlBody = @"
SELECT
'銷貨' AS sale_type,
sga01,sga02,sga03,sca03 as sga03_c ,
sgb02,sga04,bec02 AS sga04_c,sga05,beb03 AS sga05_c,
sga10,sga21,
sgb03,sgb04,sgb05,'' as sgb05_str,sgb06,
bej03,
0.0 as price,'' as price_string,
sgb10,'' as sgb10_string,
sgb10t,'' as sgb10t_string,
sgb16
FROM sga_tb
LEFT JOIN sgb_tb ON sga01=sgb01
LEFT JOIN sca_tb ON sga03=sca01
LEFT JOIN bec_tb ON sga04=bec01
LEFT JOIN beb_tb ON sga05=beb01
LEFT JOIN bej_tb ON sgb06=bej01
WHERE sgb01 IS NOT NULL
";
dtSgaTb = BoMaster.OfGetDataTable(string.Concat(sqlBody, strWhere), sqlParmList.ToArray());
dtSgaTb.TableName = "Master";
if (dtSgaTb != null)
{
resultList.AddRange(dtSgaTb.ToList <YR.ERP.DAL.YRModel.Reports.Stp.Stpr410.MasterA>());
}
}
#endregion
#region 處理退貨/折讓
if (stpr410Model.sale_type == "0" || stpr410Model.sale_type == "2")
{
queryInfoList = new List <QueryInfo>();
#region range 處理
if (!GlobalFn.varIsNull(stpr410Model.sga03))
{
queryModel = new QueryInfo();
queryModel.TableName = "sha_tb";
queryModel.ColumnName = "sha03";
queryModel.ColumnType = TabMaster.DtSource.Columns["sga03"].DataType.Name;
queryModel.Value = stpr410Model.sga03;
queryInfoList.Add(queryModel);
}
if (!GlobalFn.varIsNull(stpr410Model.sga04))
{
queryModel = new QueryInfo();
queryModel.TableName = "sha_tb";
queryModel.ColumnName = "sha04";
queryModel.ColumnType = TabMaster.DtSource.Columns["sga04"].DataType.Name;
queryModel.Value = stpr410Model.sga04;
queryInfoList.Add(queryModel);
}
if (!GlobalFn.varIsNull(stpr410Model.sga05))
{
queryModel = new QueryInfo();
queryModel.TableName = "sha_tb";
queryModel.ColumnName = "sha05";
queryModel.ColumnType = TabMaster.DtSource.Columns["sga05"].DataType.Name;
queryModel.Value = stpr410Model.sga05;
queryInfoList.Add(queryModel);
}
sqlParmList = new List <SqlParameter>();
strQueryRange = BoMaster.WfGetQueryString(queryInfoList, out sqlParmList);
#endregion
#region single 處理
sbQuerySingle = new StringBuilder();
if (!GlobalFn.varIsNull(stpr410Model.sga02_s))
{
sbQuerySingle.AppendLine("AND sha02>=@sha02_s");
sqlParmList.Add(new SqlParameter("@sha02_s", stpr410Model.sga02_s));
}
if (!GlobalFn.varIsNull(stpr410Model.sga02_e))
{
sbQuerySingle.AppendLine("AND sha02<=@sha02_e");
sqlParmList.Add(new SqlParameter("@sha02_e", stpr410Model.sga02_e));
}
if (stpr410Model.confirm_type == "1")
{
sbQuerySingle.AppendLine("AND shaconf ='Y'");
}
else if (stpr410Model.confirm_type == "2")
{
sbQuerySingle.AppendLine("AND ISNULL(shaconf,'') <>'Y'");
}
#endregion
strWhere = strQueryRange + " " + sbQuerySingle.ToString();
var strSecurity = WfGetSecurityString(); //取得權限字串
if (!GlobalFn.varIsNull(strSecurity))
{
strWhere += strSecurity;
}
//取得單頭
sqlBody = @"
SELECT
CASE WHEN shb17='1' THEN '銷退' ELSE '折讓' END AS sale_type,
sha01 AS sga01,sha02 AS sga02,sha03 AS sga03,sca03 as sga03_c ,
shb02 AS sgb02,sha04 AS sga04,bec02 AS sga04_c,sha05 AS sga05,beb03 AS sga05_c,
sha10 AS sga10,shb19 AS sga21,
shb03 AS sgb03,shb04 AS sgb04,shb05 AS sgb05,'' as sgb05_str,shb06 AS sgb06,
bej03,
0.0 as price,'' as price_string,
-1*shb10 AS sgb10,'' as sgb10_string,
-1*shb10t AS sgb10t,'' as sgb10t_string,
shb16 AS sgb16
FROM sha_tb
LEFT JOIN shb_tb ON sha01=shb01
LEFT JOIN sca_tb ON sha03=sca01
LEFT JOIN bec_tb ON sha04=bec01
LEFT JOIN beb_tb ON sha05=beb01
LEFT JOIN bej_tb ON shb06=bej01
WHERE shb01 IS NOT NULL
";
dtSgaTb = BoMaster.OfGetDataTable(string.Concat(sqlBody, strWhere), sqlParmList.ToArray());
dtSgaTb.TableName = "Master";
if (dtSgaTb != null)
{
resultList.AddRange(dtSgaTb.ToList <YR.ERP.DAL.YRModel.Reports.Stp.Stpr410.MasterA>());
}
}
#endregion
if (resultList == null || resultList.Count == 0)
{
WfShowErrorMsg("查無資料,請重新過濾條件!");
return(false);
}
foreach (MasterA masterModel in resultList)
{
var bekModel = BoBas.OfGetBekModel(masterModel.sga10);
//處理單價
if (masterModel.sgb05 > 0)
{
masterModel.price = Math.Round((masterModel.sgb10 / masterModel.sgb05), Convert.ToInt16(bekModel.bek03), MidpointRounding.AwayFromZero);
}
else
{
masterModel.price = masterModel.sgb10;
}
masterModel.price_string = string.Format("{0:N" + bekModel.bek03 + "}", masterModel.price);
masterModel.sgb10_string = string.Format("{0:N" + bekModel.bek04 + "}", masterModel.sgb10);
masterModel.sgb10t_string = string.Format("{0:N" + bekModel.bek04 + "}", masterModel.sgb10t);
//數量處理
masterModel.sgb05_str = string.Format("{0:N" + masterModel.bej03 + "}", masterModel.sgb05);//數量
}
pReport.RegData("master", resultList);
pReport.CacheAllData = true;
//處理排序--這裡利用group來達到
StiGroupHeaderBand stiGroupHeaderBand1 = (StiGroupHeaderBand)pReport.GetComponents()["GroupHeaderBand1"];
StiDataBand StiDataBand1 = (StiDataBand)pReport.GetComponents()["DataBand1"];
switch (stpr410Model.order_by)
{
case "1": //1.依出庫日期
stiGroupHeaderBand1.Condition.Value = "{Master.sga02}";
StiDataBand1.Sort = new string[6] {
"ASC",
"sga02",
"ASC",
"sga01",
"ASC",
"sgb02",
};
break;
case "2": //2.依客戶
stiGroupHeaderBand1.Condition.Value = "{Master.sga03}";
StiDataBand1.Sort = new string[6] {
"ASC",
"sga03",
"ASC",
"sga01",
"ASC",
"sgb02",
};
break;
case "3": //3.依部門
stiGroupHeaderBand1.Condition.Value = "{Master.sga05}";
StiDataBand1.Sort = new string[6] {
"ASC",
"sga05",
"ASC",
"sga01",
"ASC",
"sgb02",
};
break;
case "4": //4.依業務
stiGroupHeaderBand1.Condition.Value = "{Master.sga04}";
StiDataBand1.Sort = new string[6] {
"ASC",
"sga04",
"ASC",
"sga01",
"ASC",
"sgb02",
};
break;
}
//處理跳頁
StiGroupFooterBand footerBand1 = (StiGroupFooterBand)pReport.GetComponents()["GroupFooterBand1"];
if (stpr410Model.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;
}
}
protected override bool WfExecReport(Stimulsoft.Report.StiReport pReport)
{
vw_glar311 glar311Model;
StringBuilder sbSql = null;
string sqlBody = "";
string sqlOrderBy = "";
DataTable dtMaster;
List <Master> masterList;
List <QueryInfo> queryInfoList;
QueryInfo queryModel;
string strQueryRange, strWhere;
StringBuilder sbQuerySingle = null;
List <SqlParameter> sqlParmList;
try
{
glar311Model = DrMaster.ToItem <vw_glar311>();
queryInfoList = new List <QueryInfo>();
#region range 處理
if (!GlobalFn.varIsNull(glar311Model.gfa01))
{
queryModel = new QueryInfo();
queryModel.TableName = "gfa_tb";
queryModel.ColumnName = "gfa01";
queryModel.ColumnType = TabMaster.DtSource.Columns["gfa01"].DataType.Name;
queryModel.Value = glar311Model.gfa01;
queryInfoList.Add(queryModel);
}
sqlParmList = new List <SqlParameter>();
strQueryRange = BoMaster.WfGetQueryString(queryInfoList, out sqlParmList);
#endregion
#region single 處理
sbQuerySingle = new StringBuilder();
if (!GlobalFn.varIsNull(glar311Model.gfa02_s))
{
sbQuerySingle.AppendLine("AND gfa02>=@gfa02_s");
sqlParmList.Add(new SqlParameter("@gfa02_s", glar311Model.gfa02_s));
}
if (!GlobalFn.varIsNull(glar311Model.gfa02_e))
{
sbQuerySingle.AppendLine("AND gfa02<=@gfa02_e");
sqlParmList.Add(new SqlParameter("@gfa02_e", glar311Model.gfa02_e));
}
//過帳否
if (glar311Model.gfapost == "1")
{
sbQuerySingle.AppendLine("AND gfapost='N'");
}
else if (glar311Model.gfapost == "2")
{
sbQuerySingle.AppendLine("AND gfapost='Y'");
}
//有效否
if (glar311Model.gfaconf == "1")
{
sbQuerySingle.AppendLine("AND gfaconf <>'X' ");
}
else if (glar311Model.gfaconf == "2")
{
sbQuerySingle.AppendLine("AND gfapost='X' ");
}
#endregion
strWhere = strQueryRange + " " + sbQuerySingle.ToString();
var strSecurity = WfGetSecurityString(); //取得權限字串
if (!GlobalFn.varIsNull(strSecurity))
{
strWhere += strSecurity;
}
//取得單頭
sqlBody = @"SELECT
gfa01,gfa02,gfa03,gfa04,gfa05,
gfa06,gfa07,gfa08,gfa09,
gfaprno,gfaconf,gfacond,gfaconu,
gfapost,gfaposd,gfaposu,
gfacreu,gfacred,
gac02 as gfa01_c,
gfb02,gfb03,gfb04,gfb05,
gfb06,gfb07,gfb08,gfb09,gfb10,
gba02 AS gfb03_c,
beb03 AS gfb05_c,
bek04,
gba05
FROM gfa_tb
LEFT JOIN gfb_tb ON gfa01=gfb01
LEFT JOIN baa_tb ON 1=1
LEFT JOIN gac_tb ON substring(gfa01,1,baa06)=gac01
LEFT JOIN gba_tb ON gfb03=gba01
LEFT JOIN bek_tb ON gfb08=bek01
LEFT JOIN beb_tb ON gfb05=beb01
WHERE 1=1
";
#region 排序處理
if (!GlobalFn.varIsNull(glar311Model.order1))
{
switch (glar311Model.order1)
{
case "1":
sqlOrderBy = "ORDER BY gfa01";
break;
case "2":
sqlOrderBy = "ORDER BY gfa02";
break;
case "3":
sqlOrderBy = "ORDER BY gfb03";
break;
case "4":
sqlOrderBy = "ORDER BY gfb05";
break;
case "5":
sqlOrderBy = "ORDER BY gfb02";
break;
case "6":
sqlOrderBy = "ORDER BY gfa06";
break;
}
}
if (!GlobalFn.varIsNull(glar311Model.order2))
{
if (GlobalFn.varIsNull(sqlOrderBy))
{
switch (glar311Model.order2)
{
case "1":
sqlOrderBy = "ORDER BY gfa01";
break;
case "2":
sqlOrderBy = "ORDER BY gfa02";
break;
case "3":
sqlOrderBy = "ORDER BY gfb03";
break;
case "4":
sqlOrderBy = "ORDER BY gfb05";
break;
case "5":
sqlOrderBy = "ORDER BY gfb02";
break;
case "6":
sqlOrderBy = "ORDER BY gfa06";
break;
}
}
else
{
switch (glar311Model.order2)
{
case "1":
sqlOrderBy += ",gfa01";
break;
case "2":
sqlOrderBy += ",gfa02";
break;
case "3":
sqlOrderBy += ",gfb03";
break;
case "4":
sqlOrderBy += ",gfb05";
break;
case "5":
sqlOrderBy += ",gfb02";
break;
case "6":
sqlOrderBy += ",gfa06";
break;
}
}
}
if (!GlobalFn.varIsNull(glar311Model.order3))
{
if (GlobalFn.varIsNull(sqlOrderBy))
{
switch (glar311Model.order3)
{
case "1":
sqlOrderBy = "ORDER BY gfa01";
break;
case "2":
sqlOrderBy = "ORDER BY gfa02";
break;
case "3":
sqlOrderBy = "ORDER BY gfb03";
break;
case "4":
sqlOrderBy = "ORDER BY gfb05";
break;
case "5":
sqlOrderBy = "ORDER BY gfb02";
break;
case "6":
sqlOrderBy = "ORDER BY gfa06";
break;
}
}
else
{
switch (glar311Model.order3)
{
case "1":
sqlOrderBy += ",gfa01";
break;
case "2":
sqlOrderBy += ",gfa02";
break;
case "3":
sqlOrderBy += ",gfb03";
break;
case "4":
sqlOrderBy += ",gfb05";
break;
case "5":
sqlOrderBy += ",gfb02";
break;
case "6":
sqlOrderBy += ",gfa06";
break;
}
}
}
#endregion
dtMaster = BoMaster.OfGetDataTable(string.Concat(sqlBody, strWhere, sqlOrderBy), sqlParmList.ToArray());
dtMaster.TableName = "Master";
if (dtMaster == null || dtMaster.Rows.Count == 0)
{
WfShowErrorMsg("查無資料,請重新過濾條件!");
return(false);
}
masterList = dtMaster.ToList <Master>(true);
//取得本幣資料
var baaModel = BoBas.OfGetBaaModel();
if (baaModel == null)
{
WfShowErrorMsg("未設定基本參數,請先設定!");
return(false);
}
var baa04 = baaModel.baa04;
var bekUsModel = BoBas.OfGetBekModel(baa04);
if (bekUsModel == null)
{
WfShowErrorMsg("查無本幣資料,請先設定!");
return(false);
}
masterList = dtMaster.ToList <Master>(true);
foreach (Master masterModel in masterList)
{
if (masterModel.gfb06 == "1")
{
masterModel.gfb07d = masterModel.gfb07;
masterModel.gfb07d_str = string.Format("{0:N" + bekUsModel.bek04 + "}", masterModel.gfb07);
masterModel.gfb10d = masterModel.gfb10;
masterModel.gfb10d_str = string.Format("{0:N" + masterModel.bek04 + "}", masterModel.gfb10);
}
else
{
masterModel.gfb07c = masterModel.gfb07;
masterModel.gfb07c_str = string.Format("{0:N" + bekUsModel.bek04 + "}", masterModel.gfb07);
masterModel.gfb10c = masterModel.gfb10;
masterModel.gfb10c_str = string.Format("{0:N" + masterModel.bek04 + "}", masterModel.gfb10);
}
}
pReport.RegData("Master", masterList);
pReport.CacheAllData = true;
#region 列印選項處理
StiGroupHeaderBand headerBand1 = (StiGroupHeaderBand)pReport.GetComponents()["GroupHeaderBand1"];
StiGroupFooterBand footerBand1 = (StiGroupFooterBand)pReport.GetComponents()["GroupFooterBand1"];
StiGroupHeaderBand headerBand2 = (StiGroupHeaderBand)pReport.GetComponents()["GroupHeaderBand2"];
StiGroupFooterBand footerBand2 = (StiGroupFooterBand)pReport.GetComponents()["GroupFooterBand2"];
StiGroupHeaderBand headerBand3 = (StiGroupHeaderBand)pReport.GetComponents()["GroupHeaderBand3"];
StiGroupFooterBand footerBand3 = (StiGroupFooterBand)pReport.GetComponents()["GroupFooterBand3"];
if (!GlobalFn.varIsNull(glar311Model.order1) &&
(glar311Model.order1_jump_yn == "Y" || glar311Model.order1_sum_yn == "Y"))
{
switch (glar311Model.order1)
{
case "1":
headerBand1.Condition.Value = "{Master.gfa01}";
break;
case "2":
headerBand1.Condition.Value = "{Master.gfa02}";
break;
case "3":
headerBand1.Condition.Value = "{Master.gfb03}";
break;
case "4":
headerBand1.Condition.Value = "{Master.gfb05}";
break;
case "5":
headerBand1.Condition.Value = "{Master.gfb02}";
break;
case "6":
headerBand1.Condition.Value = "{Master.gfa06}";
break;
}
//處理跳頁
if (glar311Model.order1_jump_yn == "Y")
{
headerBand1.NewPageBefore = true;
headerBand1.ResetPageNumber = true;
}
else
{
headerBand1.NewPageBefore = false;
headerBand1.ResetPageNumber = false;
}
//處理小計
if (glar311Model.order1_sum_yn.ToUpper() != "Y")
{
footerBand1.Enabled = false;
}
}
else
{
footerBand1.Enabled = false;
}
if (!GlobalFn.varIsNull(glar311Model.order2) &&
(glar311Model.order2_jump_yn == "Y" || glar311Model.order2_sum_yn == "Y"))
{
switch (glar311Model.order2)
{
case "1":
headerBand2.Condition.Value = "{Master.gfa01}";
break;
case "2":
headerBand2.Condition.Value = "{Master.gfa02}";
break;
case "3":
headerBand2.Condition.Value = "{Master.gfb03}";
break;
case "4":
headerBand2.Condition.Value = "{Master.gfb05}";
break;
case "5":
headerBand2.Condition.Value = "{Master.gfb02}";
break;
case "6":
headerBand2.Condition.Value = "{Master.gfa06}";
break;
}
//處理跳頁
if (glar311Model.order2_jump_yn.ToUpper() == "Y")
{
headerBand2.NewPageBefore = true;
headerBand2.ResetPageNumber = true;
}
else
{
headerBand2.NewPageBefore = false;
headerBand2.ResetPageNumber = false;
}
//處理小計
if (glar311Model.order2_sum_yn.ToUpper() != "Y")
{
footerBand2.Enabled = false;
}
}
else
{
footerBand2.Enabled = false;
}
if (!GlobalFn.varIsNull(glar311Model.order3) &&
(glar311Model.order3_jump_yn == "Y" || glar311Model.order3_sum_yn == "Y"))
{
switch (glar311Model.order3)
{
case "1":
headerBand3.Condition.Value = "{Master.gfa01}";
break;
case "2":
headerBand3.Condition.Value = "{Master.gfa02}";
break;
case "3":
headerBand3.Condition.Value = "{Master.gfb03}";
break;
case "4":
headerBand3.Condition.Value = "{Master.gfb05}";
break;
case "5":
headerBand3.Condition.Value = "{Master.gfb02}";
break;
case "6":
headerBand3.Condition.Value = "{Master.gfa06}";
break;
}
//處理跳頁
if (glar311Model.order3_jump_yn.ToUpper() == "Y")
{
headerBand3.NewPageBefore = true;
headerBand3.ResetPageNumber = true;
}
else
{
headerBand3.NewPageBefore = false;
headerBand3.ResetPageNumber = false;
}
//處理小計
if (glar311Model.order3_sum_yn.ToUpper() != "Y")
{
footerBand3.Enabled = false;
}
}
else
{
footerBand3.Enabled = false;
}
#endregion
return(true);
}
catch (Exception ex)
{
throw ex;
}
}