private void InitializeComponent() { this.topMarginBand1 = new DevExpress.XtraReports.UI.TopMarginBand(); this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.detailBand1 = new DevExpress.XtraReports.UI.DetailBand(); this.xrPivotGrid1 = new DevExpress.XtraReports.UI.XRPivotGrid(); this.xrPivotGridField1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.xrPivotGridField2 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.xrPivotGridField3 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.xrPivotGridField4 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.xrPivotGridField5 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.xrPivotGridField6 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.xrPivotGridField7 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.bottomMarginBand1 = new DevExpress.XtraReports.UI.BottomMarginBand(); this.xrControlStyle1 = new DevExpress.XtraReports.UI.XRControlStyle(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // topMarginBand1 // this.topMarginBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel3, this.xrLabel2, this.xrLabel1 }); this.topMarginBand1.Name = "topMarginBand1"; // // xrLabel3 // this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(550F, 77F); this.xrLabel3.Name = "xrLabel3"; this.xrLabel3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel3.SizeF = new System.Drawing.SizeF(100F, 23F); this.xrLabel3.StylePriority.UseTextAlignment = false; this.xrLabel3.Text = "2015/12/1"; this.xrLabel3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // xrLabel2 // this.xrLabel2.AutoWidth = true; this.xrLabel2.Font = new System.Drawing.Font("微软雅黑", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(198.9583F, 37.5F); this.xrLabel2.Name = "xrLabel2"; this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel2.SizeF = new System.Drawing.SizeF(250F, 23F); this.xrLabel2.StylePriority.UseFont = false; this.xrLabel2.StylePriority.UseTextAlignment = false; this.xrLabel2.Text = "部门完工成品月报表"; this.xrLabel2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrLabel2.WordWrap = false; // // xrLabel1 // this.xrLabel1.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel1.SizeF = new System.Drawing.SizeF(86.45834F, 14.66667F); this.xrLabel1.StylePriority.UseFont = false; this.xrLabel1.Text = "报表编号"; // // detailBand1 // this.detailBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPivotGrid1 }); this.detailBand1.Name = "detailBand1"; this.detailBand1.StylePriority.UseTextAlignment = false; this.detailBand1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // xrPivotGrid1 // this.xrPivotGrid1.Appearance.Cell.BackColor = System.Drawing.Color.White; this.xrPivotGrid1.Appearance.Cell.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrPivotGrid1.Appearance.CustomTotalCell.BackColor = System.Drawing.Color.White; this.xrPivotGrid1.Appearance.CustomTotalCell.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrPivotGrid1.Appearance.FieldHeader.BackColor = System.Drawing.Color.White; this.xrPivotGrid1.Appearance.FieldHeader.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrPivotGrid1.Appearance.FieldValue.BackColor = System.Drawing.Color.White; this.xrPivotGrid1.Appearance.FieldValue.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrPivotGrid1.Appearance.FieldValueGrandTotal.BackColor = System.Drawing.Color.White; this.xrPivotGrid1.Appearance.FieldValueGrandTotal.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrPivotGrid1.Appearance.FieldValueTotal.BackColor = System.Drawing.Color.White; this.xrPivotGrid1.Appearance.FieldValueTotal.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrPivotGrid1.Appearance.FilterSeparator.BackColor = System.Drawing.Color.White; this.xrPivotGrid1.Appearance.FilterSeparator.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrPivotGrid1.Appearance.GrandTotalCell.BackColor = System.Drawing.Color.White; this.xrPivotGrid1.Appearance.GrandTotalCell.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrPivotGrid1.Appearance.HeaderGroupLine.BackColor = System.Drawing.Color.White; this.xrPivotGrid1.Appearance.HeaderGroupLine.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrPivotGrid1.Appearance.Lines.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrPivotGrid1.Appearance.TotalCell.BackColor = System.Drawing.Color.White; this.xrPivotGrid1.Appearance.TotalCell.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrPivotGrid1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.xrPivotGridField1, this.xrPivotGridField2, this.xrPivotGridField3, this.xrPivotGridField4, this.xrPivotGridField5, this.xrPivotGridField6, this.xrPivotGridField7 }); this.xrPivotGrid1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrPivotGrid1.Name = "xrPivotGrid1"; this.xrPivotGrid1.OptionsChartDataSource.UpdateDelay = 300; this.xrPivotGrid1.OptionsView.ShowColumnGrandTotalHeader = false; this.xrPivotGrid1.OptionsView.ShowColumnGrandTotals = false; this.xrPivotGrid1.OptionsView.ShowColumnHeaders = false; this.xrPivotGrid1.OptionsView.ShowColumnTotals = false; this.xrPivotGrid1.OptionsView.ShowDataHeaders = false; this.xrPivotGrid1.OptionsView.ShowFilterHeaders = false; this.xrPivotGrid1.OptionsView.ShowFilterSeparatorBar = false; this.xrPivotGrid1.OptionsView.ShowHorzLines = false; this.xrPivotGrid1.OptionsView.ShowRowGrandTotalHeader = false; this.xrPivotGrid1.OptionsView.ShowRowGrandTotals = false; this.xrPivotGrid1.OptionsView.ShowRowTotals = false; this.xrPivotGrid1.SizeF = new System.Drawing.SizeF(650F, 100F); // // xrPivotGridField1 // this.xrPivotGridField1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.xrPivotGridField1.AreaIndex = 0; this.xrPivotGridField1.Caption = "制造单元"; this.xrPivotGridField1.FieldName = "PLINE_NAME"; this.xrPivotGridField1.Name = "xrPivotGridField1"; this.xrPivotGridField1.Options.AllowExpand = DevExpress.Utils.DefaultBoolean.True; this.xrPivotGridField1.RowValueLineCount = 2; this.xrPivotGridField1.Width = 190; // // xrPivotGridField2 // this.xrPivotGridField2.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.xrPivotGridField2.AreaIndex = 1; this.xrPivotGridField2.Caption = "合同号"; this.xrPivotGridField2.FieldName = "PROJECT_CODE"; this.xrPivotGridField2.Name = "xrPivotGridField2"; this.xrPivotGridField2.Options.HideEmptyVariationItems = true; // // xrPivotGridField3 // this.xrPivotGridField3.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.xrPivotGridField3.AreaIndex = 2; this.xrPivotGridField3.Caption = "产品型号"; this.xrPivotGridField3.FieldName = "PRODUCT_SERIES"; this.xrPivotGridField3.Name = "xrPivotGridField3"; this.xrPivotGridField3.Width = 80; // // xrPivotGridField4 // this.xrPivotGridField4.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.xrPivotGridField4.AreaIndex = 3; this.xrPivotGridField4.Caption = "订单数量"; this.xrPivotGridField4.FieldName = "ORDER_QTY"; this.xrPivotGridField4.Name = "xrPivotGridField4"; this.xrPivotGridField4.Width = 70; // // xrPivotGridField5 // this.xrPivotGridField5.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.xrPivotGridField5.AreaIndex = 4; this.xrPivotGridField5.Caption = "完工数量"; this.xrPivotGridField5.FieldName = "INSTORE_QTY"; this.xrPivotGridField5.Name = "xrPivotGridField5"; this.xrPivotGridField5.Width = 70; // // xrPivotGridField6 // this.xrPivotGridField6.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.xrPivotGridField6.AreaIndex = 5; this.xrPivotGridField6.Caption = "当期完工数量"; this.xrPivotGridField6.FieldName = "PERIOD_QTY"; this.xrPivotGridField6.Name = "xrPivotGridField6"; this.xrPivotGridField6.Width = 90; // // xrPivotGridField7 // this.xrPivotGridField7.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.xrPivotGridField7.AreaIndex = 0; this.xrPivotGridField7.Name = "xrPivotGridField7"; this.xrPivotGridField7.Width = 22; // // bottomMarginBand1 // this.bottomMarginBand1.Name = "bottomMarginBand1"; // // xrControlStyle1 // this.xrControlStyle1.Name = "xrControlStyle1"; this.xrControlStyle1.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); // // Report_Exp2100 // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.topMarginBand1, this.detailBand1, this.bottomMarginBand1 }); this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] { this.xrControlStyle1 }); this.Version = "11.1"; ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); DevExpress.DataAccess.Sql.CustomSqlQuery customSqlQuery1 = new DevExpress.DataAccess.Sql.CustomSqlQuery(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Certification_Checklist_Summary)); DevExpress.XtraReports.Parameters.DynamicListLookUpSettings dynamicListLookUpSettings1 = new DevExpress.XtraReports.Parameters.DynamicListLookUpSettings(); this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components); this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.xrTable2 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell2 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell3 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand(); this.reportHeaderBand1 = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrLabel15 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel14 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel6 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel(); this.Title = new DevExpress.XtraReports.UI.XRControlStyle(); this.DetailCaption3 = new DevExpress.XtraReports.UI.XRControlStyle(); this.DetailData3 = new DevExpress.XtraReports.UI.XRControlStyle(); this.DetailData3_Odd = new DevExpress.XtraReports.UI.XRControlStyle(); this.DetailCaptionBackground3 = new DevExpress.XtraReports.UI.XRControlStyle(); this.PageInfo = new DevExpress.XtraReports.UI.XRControlStyle(); this.PageFooter = new DevExpress.XtraReports.UI.PageFooterBand(); this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.xrLabel7 = new DevExpress.XtraReports.UI.XRLabel(); this.xrPageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo(); this.xrLabel8 = new DevExpress.XtraReports.UI.XRLabel(); this.formattingRule1 = new DevExpress.XtraReports.UI.FormattingRule(); this.xrLabel9 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel10 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel11 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel13 = new DevExpress.XtraReports.UI.XRLabel(); this.GroupHeader1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.GroupFooter1 = new DevExpress.XtraReports.UI.GroupFooterBand(); this.xrPageBreak1 = new DevExpress.XtraReports.UI.XRPageBreak(); this.GroupHeader2 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.Project = new DevExpress.XtraReports.Parameters.Parameter(); this.z_odd_row = new DevExpress.XtraReports.UI.XRControlStyle(); this.Z_even_style = new DevExpress.XtraReports.UI.XRControlStyle(); this.calculatedField1 = new DevExpress.XtraReports.UI.CalculatedField(); this.xrPivotGridField1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // sqlDataSource1 // this.sqlDataSource1.ConnectionName = "DevDB"; this.sqlDataSource1.Name = "sqlDataSource1"; customSqlQuery1.Name = "rc_zainandfe"; customSqlQuery1.Sql = resources.GetString("customSqlQuery1.Sql"); this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { customSqlQuery1 }); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable2 }); this.Detail.HeightF = 25F; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.Detail.SortFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] { new DevExpress.XtraReports.UI.GroupField("src_title", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending) }); this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // xrTable2 // this.xrTable2.BackColor = System.Drawing.Color.Transparent; this.xrTable2.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable2.EvenStyleName = "Z_even_style"; this.xrTable2.LocationFloat = new DevExpress.Utils.PointFloat(0.9374164F, 0F); this.xrTable2.Name = "xrTable2"; this.xrTable2.OddStyleName = "z_odd_row"; this.xrTable2.Padding = new DevExpress.XtraPrinting.PaddingInfo(3, 3, 3, 3, 100F); this.xrTable2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow2 }); this.xrTable2.SizeF = new System.Drawing.SizeF(648.3126F, 25F); this.xrTable2.StyleName = "Z_even_style"; this.xrTable2.StylePriority.UseBackColor = false; this.xrTable2.StylePriority.UseBorders = false; this.xrTable2.StylePriority.UsePadding = false; // // xrTableRow2 // this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell2, this.xrTableCell3, this.xrTableCell4, this.xrTableCell5 }); this.xrTableRow2.Name = "xrTableRow2"; this.xrTableRow2.Weight = 1D; // // xrTableCell2 // this.xrTableCell2.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[src_title]") }); this.xrTableCell2.Name = "xrTableCell2"; this.xrTableCell2.Text = "Criteria #"; this.xrTableCell2.Weight = 0.46091648905287352D; // // xrTableCell3 // this.xrTableCell3.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[src_source]") }); this.xrTableCell3.Name = "xrTableCell3"; this.xrTableCell3.Text = "Criteria Source"; this.xrTableCell3.Weight = 0.57643430031947929D; // // xrTableCell4 // this.xrTableCell4.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[src_critical]") }); this.xrTableCell4.Name = "xrTableCell4"; this.xrTableCell4.Text = "SRC CSF"; this.xrTableCell4.Weight = 0.62161465227305546D; // // xrTableCell5 // this.xrTableCell5.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[src_criteria]") }); this.xrTableCell5.Name = "xrTableCell5"; this.xrTableCell5.Text = "Criteria Definition"; this.xrTableCell5.Weight = 2.3410345583545915D; // // xrLabel1 // this.xrLabel1.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[ch_title]") }); this.xrLabel1.Font = new System.Drawing.Font("Segoe UI", 20F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(0.375021F, 0F); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel1.SizeF = new System.Drawing.SizeF(648.8751F, 46.06546F); this.xrLabel1.StylePriority.UseFont = false; this.xrLabel1.Target = "_self"; this.xrLabel1.Text = "xrLabel1"; // // TopMargin // this.TopMargin.HeightF = 24F; this.TopMargin.Name = "TopMargin"; this.TopMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.TopMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // BottomMargin // this.BottomMargin.HeightF = 24F; this.BottomMargin.Name = "BottomMargin"; this.BottomMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // reportHeaderBand1 // this.reportHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel15, this.xrLabel14, this.xrLabel4, this.xrLabel6, this.xrLabel2 }); this.reportHeaderBand1.HeightF = 271.5893F; this.reportHeaderBand1.Name = "reportHeaderBand1"; // // xrLabel15 // this.xrLabel15.LocationFloat = new DevExpress.Utils.PointFloat(0F, 192.0417F); this.xrLabel15.Name = "xrLabel15"; this.xrLabel15.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel15.SizeF = new System.Drawing.SizeF(566.7084F, 79.54761F); this.xrLabel15.Text = resources.GetString("xrLabel15.Text"); // // xrLabel14 // this.xrLabel14.Bookmark = "Scope"; this.xrLabel14.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrLabel14.Font = new System.Drawing.Font("Segoe UI", 16F); this.xrLabel14.LocationFloat = new DevExpress.Utils.PointFloat(0F, 145.7083F); this.xrLabel14.Name = "xrLabel14"; this.xrLabel14.Padding = new DevExpress.XtraPrinting.PaddingInfo(8, 2, 0, 0, 100F); this.xrLabel14.SizeF = new System.Drawing.SizeF(566.7083F, 46.33334F); this.xrLabel14.StylePriority.UseBorders = false; this.xrLabel14.StylePriority.UseFont = false; this.xrLabel14.StylePriority.UsePadding = false; this.xrLabel14.StylePriority.UseTextAlignment = false; this.xrLabel14.Text = "Scope of Report"; this.xrLabel14.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // xrLabel4 // this.xrLabel4.Borders = DevExpress.XtraPrinting.BorderSide.Bottom; this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(0F, 59.04765F); this.xrLabel4.Name = "xrLabel4"; this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel4.SizeF = new System.Drawing.SizeF(100F, 23F); this.xrLabel4.StylePriority.UseBorders = false; this.xrLabel4.Text = "Project Name:"; // // xrLabel6 // this.xrLabel6.Borders = DevExpress.XtraPrinting.BorderSide.Bottom; this.xrLabel6.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[pro_name]") }); this.xrLabel6.LocationFloat = new DevExpress.Utils.PointFloat(100F, 59.04765F); this.xrLabel6.Name = "xrLabel6"; this.xrLabel6.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel6.SizeF = new System.Drawing.SizeF(547.4166F, 23F); this.xrLabel6.StylePriority.UseBorders = false; // // xrLabel2 // this.xrLabel2.Bookmark = "Summary"; this.xrLabel2.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrLabel2.Font = new System.Drawing.Font("Segoe UI", 16F); this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrLabel2.Name = "xrLabel2"; this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(8, 2, 0, 0, 100F); this.xrLabel2.SizeF = new System.Drawing.SizeF(566.7083F, 46.33334F); this.xrLabel2.StylePriority.UseBorders = false; this.xrLabel2.StylePriority.UseFont = false; this.xrLabel2.StylePriority.UsePadding = false; this.xrLabel2.StylePriority.UseTextAlignment = false; this.xrLabel2.Text = "Certification Checklist Summary"; this.xrLabel2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // Title // this.Title.BackColor = System.Drawing.Color.Transparent; this.Title.BorderColor = System.Drawing.Color.Black; this.Title.Borders = DevExpress.XtraPrinting.BorderSide.None; this.Title.BorderWidth = 1F; this.Title.Font = new System.Drawing.Font("Tahoma", 14F); this.Title.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(75)))), ((int)(((byte)(75)))), ((int)(((byte)(75))))); this.Title.Name = "Title"; // // DetailCaption3 // this.DetailCaption3.BackColor = System.Drawing.Color.Transparent; this.DetailCaption3.BorderColor = System.Drawing.Color.Transparent; this.DetailCaption3.Borders = DevExpress.XtraPrinting.BorderSide.None; this.DetailCaption3.Font = new System.Drawing.Font("Tahoma", 8F, System.Drawing.FontStyle.Bold); this.DetailCaption3.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(75)))), ((int)(((byte)(75)))), ((int)(((byte)(75))))); this.DetailCaption3.Name = "DetailCaption3"; this.DetailCaption3.Padding = new DevExpress.XtraPrinting.PaddingInfo(6, 6, 0, 0, 100F); this.DetailCaption3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // DetailData3 // this.DetailData3.Font = new System.Drawing.Font("Tahoma", 8F); this.DetailData3.ForeColor = System.Drawing.Color.Black; this.DetailData3.Name = "DetailData3"; this.DetailData3.Padding = new DevExpress.XtraPrinting.PaddingInfo(6, 6, 0, 0, 100F); this.DetailData3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // DetailData3_Odd // this.DetailData3_Odd.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(231)))), ((int)(((byte)(231)))), ((int)(((byte)(231))))); this.DetailData3_Odd.BorderColor = System.Drawing.Color.Transparent; this.DetailData3_Odd.Borders = DevExpress.XtraPrinting.BorderSide.None; this.DetailData3_Odd.BorderWidth = 1F; this.DetailData3_Odd.Font = new System.Drawing.Font("Tahoma", 8F); this.DetailData3_Odd.ForeColor = System.Drawing.Color.Black; this.DetailData3_Odd.Name = "DetailData3_Odd"; this.DetailData3_Odd.Padding = new DevExpress.XtraPrinting.PaddingInfo(6, 6, 0, 0, 100F); this.DetailData3_Odd.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // DetailCaptionBackground3 // this.DetailCaptionBackground3.BackColor = System.Drawing.Color.Transparent; this.DetailCaptionBackground3.BorderColor = System.Drawing.Color.FromArgb(((int)(((byte)(206)))), ((int)(((byte)(206)))), ((int)(((byte)(206))))); this.DetailCaptionBackground3.Borders = DevExpress.XtraPrinting.BorderSide.Top; this.DetailCaptionBackground3.BorderWidth = 2F; this.DetailCaptionBackground3.Name = "DetailCaptionBackground3"; // // PageInfo // this.PageInfo.Font = new System.Drawing.Font("Tahoma", 8F, System.Drawing.FontStyle.Bold); this.PageInfo.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(75)))), ((int)(((byte)(75)))), ((int)(((byte)(75))))); this.PageInfo.Name = "PageInfo"; this.PageInfo.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); // // PageFooter // this.PageFooter.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPageInfo1, this.xrLabel7, this.xrPageInfo2, this.xrLabel8 }); this.PageFooter.HeightF = 48.17708F; this.PageFooter.Name = "PageFooter"; // // xrPageInfo1 // this.xrPageInfo1.Font = new System.Drawing.Font("Segoe UI", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(591.1458F, 0F); this.xrPageInfo1.Name = "xrPageInfo1"; this.xrPageInfo1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo1.SizeF = new System.Drawing.SizeF(58.85419F, 35.50002F); this.xrPageInfo1.StylePriority.UseFont = false; this.xrPageInfo1.StylePriority.UseTextAlignment = false; this.xrPageInfo1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; // // xrLabel7 // this.xrLabel7.Font = new System.Drawing.Font("Segoe UI", 10.125F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel7.LocationFloat = new DevExpress.Utils.PointFloat(0.9374301F, 0F); this.xrLabel7.Name = "xrLabel7"; this.xrLabel7.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel7.SizeF = new System.Drawing.SizeF(197.2917F, 23.09373F); this.xrLabel7.StylePriority.UseFont = false; this.xrLabel7.StylePriority.UseTextAlignment = false; this.xrLabel7.Text = "Generated by ReadyCert® on:"; this.xrLabel7.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // xrPageInfo2 // this.xrPageInfo2.Font = new System.Drawing.Font("Segoe UI", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(0.9374301F, 23.09373F); this.xrPageInfo2.Name = "xrPageInfo2"; this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo2.PageInfo = DevExpress.XtraPrinting.PageInfo.DateTime; this.xrPageInfo2.SizeF = new System.Drawing.SizeF(269.2708F, 25.08335F); this.xrPageInfo2.StylePriority.UseFont = false; this.xrPageInfo2.StylePriority.UseTextAlignment = false; this.xrPageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // xrLabel8 // this.xrLabel8.Font = new System.Drawing.Font("Segoe UI", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel8.LocationFloat = new DevExpress.Utils.PointFloat(462.5F, 0F); this.xrLabel8.Name = "xrLabel8"; this.xrLabel8.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel8.SizeF = new System.Drawing.SizeF(128.6458F, 35.50002F); this.xrLabel8.StylePriority.UseFont = false; this.xrLabel8.StylePriority.UseTextAlignment = false; this.xrLabel8.Text = "page"; this.xrLabel8.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; this.xrLabel8.TextTrimming = System.Drawing.StringTrimming.None; // // formattingRule1 // this.formattingRule1.DataMember = "rc_rtm_checklists"; this.formattingRule1.Name = "formattingRule1"; // // xrLabel9 // this.xrLabel9.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrLabel9.Name = "xrLabel9"; this.xrLabel9.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel9.SizeF = new System.Drawing.SizeF(74.43752F, 23F); this.xrLabel9.Text = "SRC #"; // // xrLabel10 // this.xrLabel10.LocationFloat = new DevExpress.Utils.PointFloat(75.6419F, 0F); this.xrLabel10.Name = "xrLabel10"; this.xrLabel10.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel10.SizeF = new System.Drawing.SizeF(93.42738F, 23F); this.xrLabel10.Text = "Source"; // // xrLabel11 // this.xrLabel11.LocationFloat = new DevExpress.Utils.PointFloat(169.0693F, 0F); this.xrLabel11.Name = "xrLabel11"; this.xrLabel11.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel11.SizeF = new System.Drawing.SizeF(100.2016F, 23F); this.xrLabel11.Text = "CSF (T/F)"; // // xrLabel13 // this.xrLabel13.LocationFloat = new DevExpress.Utils.PointFloat(269.8194F, 0F); this.xrLabel13.Name = "xrLabel13"; this.xrLabel13.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel13.SizeF = new System.Drawing.SizeF(379.4306F, 23F); this.xrLabel13.Text = "Criteria"; // // GroupHeader1 // this.GroupHeader1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel9, this.xrLabel10, this.xrLabel11, this.xrLabel13 }); this.GroupHeader1.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] { new DevExpress.XtraReports.UI.GroupField("pro_name", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending) }); this.GroupHeader1.HeightF = 23F; this.GroupHeader1.Name = "GroupHeader1"; this.GroupHeader1.RepeatEveryPage = true; // // GroupFooter1 // this.GroupFooter1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPageBreak1 }); this.GroupFooter1.HeightF = 25.59525F; this.GroupFooter1.Level = 1; this.GroupFooter1.Name = "GroupFooter1"; // // xrPageBreak1 // this.xrPageBreak1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 10F); this.xrPageBreak1.Name = "xrPageBreak1"; // // GroupHeader2 // this.GroupHeader2.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel1 }); this.GroupHeader2.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] { new DevExpress.XtraReports.UI.GroupField("ch_title", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending) }); this.GroupHeader2.HeightF = 46.06546F; this.GroupHeader2.Level = 1; this.GroupHeader2.Name = "GroupHeader2"; this.GroupHeader2.RepeatEveryPage = true; // // Project // this.Project.Description = "Select a Project"; dynamicListLookUpSettings1.DataAdapter = null; dynamicListLookUpSettings1.DataMember = "rc_zainandfe"; dynamicListLookUpSettings1.DataSource = this.sqlDataSource1; dynamicListLookUpSettings1.DisplayMember = "pro_name"; dynamicListLookUpSettings1.ValueMember = "pro_name"; this.Project.LookUpSettings = dynamicListLookUpSettings1; this.Project.MultiValue = true; this.Project.Name = "Project"; // // z_odd_row // this.z_odd_row.BackColor = System.Drawing.Color.LemonChiffon; this.z_odd_row.BorderColor = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64))))); this.z_odd_row.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.z_odd_row.BorderWidth = 1F; this.z_odd_row.Font = new System.Drawing.Font("Segoe UI", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.z_odd_row.Name = "z_odd_row"; this.z_odd_row.Padding = new DevExpress.XtraPrinting.PaddingInfo(3, 3, 3, 3, 100F); this.z_odd_row.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // Z_even_style // this.Z_even_style.BackColor = System.Drawing.Color.LightBlue; this.Z_even_style.BorderColor = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64))))); this.Z_even_style.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid; this.Z_even_style.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.Z_even_style.BorderWidth = 1F; this.Z_even_style.Font = new System.Drawing.Font("Segoe UI", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.Z_even_style.Name = "Z_even_style"; this.Z_even_style.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.Z_even_style.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // calculatedField1 // this.calculatedField1.DataMember = "rc_zainandfe"; this.calculatedField1.Expression = "[src_title][].Count()"; this.calculatedField1.FieldType = DevExpress.XtraReports.UI.FieldType.String; this.calculatedField1.Name = "calculatedField1"; // // xrPivotGridField1 // this.xrPivotGridField1.Name = "xrPivotGridField1"; // // Certification_Checklist_Summary // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.reportHeaderBand1, this.PageFooter, this.GroupHeader1, this.GroupFooter1, this.GroupHeader2 }); this.Bookmark = "Certification Checklist Summary"; this.CalculatedFields.AddRange(new DevExpress.XtraReports.UI.CalculatedField[] { this.calculatedField1 }); this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] { this.sqlDataSource1 }); this.DataMember = "rc_zainandfe"; this.DataSource = this.sqlDataSource1; this.FilterString = "[pro_name] In (?Project)"; this.Font = new System.Drawing.Font("Segoe UI", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.Margins = new System.Drawing.Printing.Margins(100, 100, 24, 24); this.Parameters.AddRange(new DevExpress.XtraReports.Parameters.Parameter[] { this.Project }); this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] { this.Title, this.DetailCaption3, this.DetailData3, this.DetailData3_Odd, this.DetailCaptionBackground3, this.PageInfo, this.z_odd_row, this.Z_even_style }); this.Version = "17.2"; ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); DevExpress.DataAccess.Sql.StoredProcQuery storedProcQuery1 = new DevExpress.DataAccess.Sql.StoredProcQuery(); DevExpress.DataAccess.Sql.QueryParameter queryParameter1 = new DevExpress.DataAccess.Sql.QueryParameter(); DevExpress.DataAccess.Sql.QueryParameter queryParameter2 = new DevExpress.DataAccess.Sql.QueryParameter(); DevExpress.DataAccess.Sql.QueryParameter queryParameter3 = new DevExpress.DataAccess.Sql.QueryParameter(); DevExpress.DataAccess.Sql.QueryParameter queryParameter4 = new DevExpress.DataAccess.Sql.QueryParameter(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(CustodyTest)); DevExpress.XtraReports.Parameters.DynamicListLookUpSettings dynamicListLookUpSettings1 = new DevExpress.XtraReports.Parameters.DynamicListLookUpSettings(); this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand(); this.xrPivotGrid1 = new DevExpress.XtraReports.UI.XRPivotGrid(); this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components); this.Culture = new DevExpress.XtraReports.Parameters.Parameter(); this.CompanyId = new DevExpress.XtraReports.Parameters.Parameter(); this.CompanyName = new DevExpress.XtraReports.Parameters.Parameter(); this.User = new DevExpress.XtraReports.Parameters.Parameter(); this.MappingDeptIds = new DevExpress.XtraReports.Parameters.Parameter(); this.MappingEmpIds = new DevExpress.XtraReports.Parameters.Parameter(); this.DeptIds = new DevExpress.XtraReports.Parameters.Parameter(); this.fieldCustodyCat1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldEmpName1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldCode1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldEmpId1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldjobName1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldjobId1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fielddeptName1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fielddeptId1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldReceiveDate1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldDeliveryDate1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fielddeliveryStatus1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldQtyOfRecievedItem1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldCustodyCode1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldCustodyName1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldCustodyEnteringDate1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldCustodyTimeOutDate1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldCustodySerialNo1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldCustodyPurchaseDate1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldPurchaseAmount1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldInUse1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldReceiveStatus1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldInitialCustodyAmount1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldDisposal1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldCustodyCat12 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPivotGrid1 }); this.Detail.HeightF = 100F; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // TopMargin // this.TopMargin.HeightF = 11.80556F; this.TopMargin.Name = "TopMargin"; this.TopMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.TopMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // BottomMargin // this.BottomMargin.HeightF = 9.722222F; this.BottomMargin.Name = "BottomMargin"; this.BottomMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // xrPivotGrid1 // this.xrPivotGrid1.Appearance.Cell.Font = new System.Drawing.Font("Tahoma", 8F); this.xrPivotGrid1.Appearance.CustomTotalCell.Font = new System.Drawing.Font("Tahoma", 8F); this.xrPivotGrid1.Appearance.FieldHeader.Font = new System.Drawing.Font("Tahoma", 8F); this.xrPivotGrid1.Appearance.FieldValue.Font = new System.Drawing.Font("Tahoma", 8F); this.xrPivotGrid1.Appearance.FieldValueGrandTotal.Font = new System.Drawing.Font("Tahoma", 8F); this.xrPivotGrid1.Appearance.FieldValueTotal.Font = new System.Drawing.Font("Tahoma", 8F); this.xrPivotGrid1.Appearance.GrandTotalCell.Font = new System.Drawing.Font("Tahoma", 8F); this.xrPivotGrid1.Appearance.Lines.Font = new System.Drawing.Font("Tahoma", 8F); this.xrPivotGrid1.Appearance.TotalCell.Font = new System.Drawing.Font("Tahoma", 8F); this.xrPivotGrid1.DataMember = "SP_EmployeeCustody"; this.xrPivotGrid1.DataSource = this.sqlDataSource1; this.xrPivotGrid1.Fields.AddRange(new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField[] { this.fieldEmpName1, this.fieldCode1, this.fieldEmpId1, this.fieldjobName1, this.fieldjobId1, this.fielddeptName1, this.fielddeptId1, this.fieldReceiveDate1, this.fieldDeliveryDate1, this.fielddeliveryStatus1, this.fieldQtyOfRecievedItem1, this.fieldCustodyCode1, this.fieldCustodyName1, this.fieldCustodyEnteringDate1, this.fieldCustodyTimeOutDate1, this.fieldCustodySerialNo1, this.fieldCustodyPurchaseDate1, this.fieldCustodyCat1, this.fieldPurchaseAmount1, this.fieldInUse1, this.fieldReceiveStatus1, this.fieldInitialCustodyAmount1, this.fieldDisposal1, this.fieldCustodyCat12 }); this.xrPivotGrid1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrPivotGrid1.Name = "xrPivotGrid1"; this.xrPivotGrid1.OptionsPrint.FilterSeparatorBarPadding = 3; this.xrPivotGrid1.SizeF = new System.Drawing.SizeF(673.3333F, 100F); // // sqlDataSource1 // this.sqlDataSource1.ConnectionName = "HrContext"; this.sqlDataSource1.Name = "sqlDataSource1"; storedProcQuery1.Name = "SP_EmployeeCustody"; queryParameter1.Name = "@Culture"; queryParameter1.Type = typeof(DevExpress.DataAccess.Expression); queryParameter1.Value = new DevExpress.DataAccess.Expression("[Parameters.Culture]", typeof(string)); queryParameter2.Name = "@LoginCompanyId"; queryParameter2.Type = typeof(DevExpress.DataAccess.Expression); queryParameter2.Value = new DevExpress.DataAccess.Expression("[Parameters.CompanyId]", typeof(int)); queryParameter3.Name = "@deptName"; queryParameter3.Type = typeof(DevExpress.DataAccess.Expression); queryParameter3.Value = new DevExpress.DataAccess.Expression("[Parameters.MappingDeptIds]", typeof(string)); queryParameter4.Name = "@empIds"; queryParameter4.Type = typeof(DevExpress.DataAccess.Expression); queryParameter4.Value = new DevExpress.DataAccess.Expression("[Parameters.MappingEmpIds]", typeof(string)); storedProcQuery1.Parameters.Add(queryParameter1); storedProcQuery1.Parameters.Add(queryParameter2); storedProcQuery1.Parameters.Add(queryParameter3); storedProcQuery1.Parameters.Add(queryParameter4); storedProcQuery1.StoredProcName = "SP_EmployeeCustody"; this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { storedProcQuery1 }); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // Culture // this.Culture.Description = "Culture"; this.Culture.Name = "Culture"; this.Culture.ValueInfo = "ar-EG"; this.Culture.Visible = false; // // CompanyId // this.CompanyId.Description = "CompanyId"; this.CompanyId.Name = "CompanyId"; this.CompanyId.Type = typeof(int); this.CompanyId.ValueInfo = "0"; this.CompanyId.Visible = false; // // CompanyName // this.CompanyName.Description = "CompanyName"; this.CompanyName.Name = "CompanyName"; this.CompanyName.Visible = false; // // User // this.User.Description = "User"; this.User.Name = "User"; this.User.Visible = false; // // MappingDeptIds // this.MappingDeptIds.Description = "MappingDeptIds"; this.MappingDeptIds.Name = "MappingDeptIds"; this.MappingDeptIds.Visible = false; // // MappingEmpIds // this.MappingEmpIds.Description = "MappingEmpIds"; this.MappingEmpIds.Name = "MappingEmpIds"; this.MappingEmpIds.Visible = false; // // DeptIds // this.DeptIds.Description = "الإدارة"; dynamicListLookUpSettings1.DataAdapter = null; dynamicListLookUpSettings1.DataMember = "SP_EmployeeCustody"; dynamicListLookUpSettings1.DataSource = this.sqlDataSource1; dynamicListLookUpSettings1.DisplayMember = "deptName"; dynamicListLookUpSettings1.ValueMember = "deptId"; this.DeptIds.LookUpSettings = dynamicListLookUpSettings1; this.DeptIds.Name = "DeptIds"; this.DeptIds.Type = typeof(int); this.DeptIds.ValueInfo = "0"; // // fieldCustodyCat1 // this.fieldCustodyCat1.AreaIndex = 16; this.fieldCustodyCat1.FieldName = "CustodyCat"; this.fieldCustodyCat1.Name = "fieldCustodyCat1"; // // fieldEmpName1 // this.fieldEmpName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldEmpName1.AreaIndex = 3; this.fieldEmpName1.FieldName = "EmpName"; this.fieldEmpName1.MinWidth = 10; this.fieldEmpName1.Name = "fieldEmpName1"; this.fieldEmpName1.Options.ShowCustomTotals = false; this.fieldEmpName1.Options.ShowGrandTotal = false; this.fieldEmpName1.Options.ShowTotals = false; this.fieldEmpName1.TotalsVisibility = DevExpress.XtraPivotGrid.PivotTotalsVisibility.None; // // fieldCode1 // this.fieldCode1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldCode1.AreaIndex = 2; this.fieldCode1.FieldName = "Code"; this.fieldCode1.Name = "fieldCode1"; this.fieldCode1.Options.ShowCustomTotals = false; this.fieldCode1.Options.ShowGrandTotal = false; this.fieldCode1.Options.ShowTotals = false; this.fieldCode1.TotalsVisibility = DevExpress.XtraPivotGrid.PivotTotalsVisibility.None; // // fieldEmpId1 // this.fieldEmpId1.AreaIndex = 0; this.fieldEmpId1.FieldName = "EmpId"; this.fieldEmpId1.Name = "fieldEmpId1"; // // fieldjobName1 // this.fieldjobName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldjobName1.AreaIndex = 1; this.fieldjobName1.FieldName = "jobName"; this.fieldjobName1.Name = "fieldjobName1"; this.fieldjobName1.Options.ShowCustomTotals = false; this.fieldjobName1.Options.ShowGrandTotal = false; this.fieldjobName1.Options.ShowTotals = false; this.fieldjobName1.TotalsVisibility = DevExpress.XtraPivotGrid.PivotTotalsVisibility.None; // // fieldjobId1 // this.fieldjobId1.AreaIndex = 1; this.fieldjobId1.FieldName = "jobId"; this.fieldjobId1.Name = "fieldjobId1"; // // fielddeptName1 // this.fielddeptName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fielddeptName1.AreaIndex = 0; this.fielddeptName1.FieldName = "deptName"; this.fielddeptName1.Name = "fielddeptName1"; this.fielddeptName1.Options.ShowCustomTotals = false; this.fielddeptName1.Options.ShowGrandTotal = false; this.fielddeptName1.Options.ShowTotals = false; this.fielddeptName1.TotalsVisibility = DevExpress.XtraPivotGrid.PivotTotalsVisibility.None; // // fielddeptId1 // this.fielddeptId1.AreaIndex = 2; this.fielddeptId1.FieldName = "deptId"; this.fielddeptId1.Name = "fielddeptId1"; // // fieldReceiveDate1 // this.fieldReceiveDate1.AreaIndex = 3; this.fieldReceiveDate1.FieldName = "ReceiveDate"; this.fieldReceiveDate1.Name = "fieldReceiveDate1"; // // fieldDeliveryDate1 // this.fieldDeliveryDate1.AreaIndex = 4; this.fieldDeliveryDate1.FieldName = "DeliveryDate"; this.fieldDeliveryDate1.Name = "fieldDeliveryDate1"; // // fielddeliveryStatus1 // this.fielddeliveryStatus1.AreaIndex = 5; this.fielddeliveryStatus1.FieldName = "deliveryStatus"; this.fielddeliveryStatus1.Name = "fielddeliveryStatus1"; // // fieldQtyOfRecievedItem1 // this.fieldQtyOfRecievedItem1.AreaIndex = 6; this.fieldQtyOfRecievedItem1.FieldName = "QtyOfRecievedItem"; this.fieldQtyOfRecievedItem1.Name = "fieldQtyOfRecievedItem1"; // // fieldCustodyCode1 // this.fieldCustodyCode1.AreaIndex = 8; this.fieldCustodyCode1.FieldName = "CustodyCode"; this.fieldCustodyCode1.KPIGraphic = DevExpress.XtraPivotGrid.PivotKPIGraphic.Shapes; this.fieldCustodyCode1.Name = "fieldCustodyCode1"; this.fieldCustodyCode1.Options.ShowCustomTotals = false; this.fieldCustodyCode1.Options.ShowGrandTotal = false; this.fieldCustodyCode1.Options.ShowTotals = false; this.fieldCustodyCode1.TotalsVisibility = DevExpress.XtraPivotGrid.PivotTotalsVisibility.None; // // fieldCustodyName1 // this.fieldCustodyName1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldCustodyName1.AreaIndex = 1; this.fieldCustodyName1.FieldName = "CustodyName"; this.fieldCustodyName1.Name = "fieldCustodyName1"; this.fieldCustodyName1.Options.ShowCustomTotals = false; this.fieldCustodyName1.Options.ShowGrandTotal = false; this.fieldCustodyName1.Options.ShowTotals = false; this.fieldCustodyName1.TotalsVisibility = DevExpress.XtraPivotGrid.PivotTotalsVisibility.None; // // fieldCustodyEnteringDate1 // this.fieldCustodyEnteringDate1.AreaIndex = 7; this.fieldCustodyEnteringDate1.FieldName = "CustodyEnteringDate"; this.fieldCustodyEnteringDate1.Name = "fieldCustodyEnteringDate1"; // // fieldCustodyTimeOutDate1 // this.fieldCustodyTimeOutDate1.AreaIndex = 9; this.fieldCustodyTimeOutDate1.FieldName = "CustodyTimeOutDate"; this.fieldCustodyTimeOutDate1.Name = "fieldCustodyTimeOutDate1"; // // fieldCustodySerialNo1 // this.fieldCustodySerialNo1.AreaIndex = 10; this.fieldCustodySerialNo1.FieldName = "CustodySerialNo"; this.fieldCustodySerialNo1.Name = "fieldCustodySerialNo1"; // // fieldCustodyPurchaseDate1 // this.fieldCustodyPurchaseDate1.AreaIndex = 11; this.fieldCustodyPurchaseDate1.FieldName = "CustodyPurchaseDate"; this.fieldCustodyPurchaseDate1.Name = "fieldCustodyPurchaseDate1"; // // fieldPurchaseAmount1 // this.fieldPurchaseAmount1.AreaIndex = 12; this.fieldPurchaseAmount1.FieldName = "PurchaseAmount"; this.fieldPurchaseAmount1.Name = "fieldPurchaseAmount1"; // // fieldInUse1 // this.fieldInUse1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldInUse1.AreaIndex = 0; this.fieldInUse1.FieldName = "InUse"; this.fieldInUse1.KPIGraphic = DevExpress.XtraPivotGrid.PivotKPIGraphic.Shapes; this.fieldInUse1.Name = "fieldInUse1"; this.fieldInUse1.Options.ShowCustomTotals = false; this.fieldInUse1.Options.ShowGrandTotal = false; this.fieldInUse1.Options.ShowTotals = false; this.fieldInUse1.TotalsVisibility = DevExpress.XtraPivotGrid.PivotTotalsVisibility.None; // // fieldReceiveStatus1 // this.fieldReceiveStatus1.AreaIndex = 13; this.fieldReceiveStatus1.FieldName = "ReceiveStatus"; this.fieldReceiveStatus1.Name = "fieldReceiveStatus1"; // // fieldInitialCustodyAmount1 // this.fieldInitialCustodyAmount1.AreaIndex = 14; this.fieldInitialCustodyAmount1.FieldName = "InitialCustodyAmount"; this.fieldInitialCustodyAmount1.Name = "fieldInitialCustodyAmount1"; // // fieldDisposal1 // this.fieldDisposal1.AreaIndex = 15; this.fieldDisposal1.FieldName = "Disposal"; this.fieldDisposal1.Name = "fieldDisposal1"; // // fieldCustodyCat12 // this.fieldCustodyCat12.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldCustodyCat12.AreaIndex = 0; this.fieldCustodyCat12.FieldName = "CustodyCat_1"; this.fieldCustodyCat12.Name = "fieldCustodyCat12"; this.fieldCustodyCat12.Options.ShowCustomTotals = false; this.fieldCustodyCat12.Options.ShowGrandTotal = false; this.fieldCustodyCat12.Options.ShowTotals = false; this.fieldCustodyCat12.TotalsVisibility = DevExpress.XtraPivotGrid.PivotTotalsVisibility.None; // // CustodyTest // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin }); this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] { this.sqlDataSource1 }); this.Margins = new System.Drawing.Printing.Margins(10, 17, 12, 10); this.Parameters.AddRange(new DevExpress.XtraReports.Parameters.Parameter[] { this.Culture, this.CompanyId, this.CompanyName, this.User, this.MappingDeptIds, this.MappingEmpIds, this.DeptIds }); this.Version = "17.1"; ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); DevExpress.DataAccess.Sql.StoredProcQuery storedProcQuery1 = new DevExpress.DataAccess.Sql.StoredProcQuery(); DevExpress.DataAccess.Sql.QueryParameter queryParameter1 = new DevExpress.DataAccess.Sql.QueryParameter(); DevExpress.DataAccess.Sql.QueryParameter queryParameter2 = new DevExpress.DataAccess.Sql.QueryParameter(); DevExpress.DataAccess.Sql.QueryParameter queryParameter3 = new DevExpress.DataAccess.Sql.QueryParameter(); DevExpress.DataAccess.Sql.QueryParameter queryParameter4 = new DevExpress.DataAccess.Sql.QueryParameter(); DevExpress.DataAccess.Sql.QueryParameter queryParameter5 = new DevExpress.DataAccess.Sql.QueryParameter(); DevExpress.DataAccess.Sql.QueryParameter queryParameter6 = new DevExpress.DataAccess.Sql.QueryParameter(); DevExpress.DataAccess.Sql.QueryParameter queryParameter7 = new DevExpress.DataAccess.Sql.QueryParameter(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(en_DisposalEmployeesCustodies)); DevExpress.XtraReports.Parameters.DynamicListLookUpSettings dynamicListLookUpSettings1 = new DevExpress.XtraReports.Parameters.DynamicListLookUpSettings(); DevExpress.XtraReports.Parameters.DynamicListLookUpSettings dynamicListLookUpSettings2 = new DevExpress.XtraReports.Parameters.DynamicListLookUpSettings(); DevExpress.XtraReports.Parameters.DynamicListLookUpSettings dynamicListLookUpSettings3 = new DevExpress.XtraReports.Parameters.DynamicListLookUpSettings(); this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components); this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.xrPivotGrid1 = new DevExpress.XtraReports.UI.XRPivotGrid(); this.fielddeptName = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldEmpName = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldCustodyName = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldEmployeeCustodyPrice = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand(); this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.companyLogo = new DevExpress.XtraReports.UI.XRPictureBox(); this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.CompanyName = new DevExpress.XtraReports.Parameters.Parameter(); this.PageFooter = new DevExpress.XtraReports.UI.PageFooterBand(); this.xrPageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo(); this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.xrLabel10 = new DevExpress.XtraReports.UI.XRLabel(); this.User = new DevExpress.XtraReports.Parameters.Parameter(); this.xrLabel9 = new DevExpress.XtraReports.UI.XRLabel(); this.formattingRule1 = new DevExpress.XtraReports.UI.FormattingRule(); this.formattingRule2 = new DevExpress.XtraReports.UI.FormattingRule(); this.formattingRule3 = new DevExpress.XtraReports.UI.FormattingRule(); this.formattingRule4 = new DevExpress.XtraReports.UI.FormattingRule(); this.formattingRule5 = new DevExpress.XtraReports.UI.FormattingRule(); this.formattingRule6 = new DevExpress.XtraReports.UI.FormattingRule(); this.formattingRule7 = new DevExpress.XtraReports.UI.FormattingRule(); this.Odding = new DevExpress.XtraReports.UI.XRControlStyle(); this.GroupCaption3 = new DevExpress.XtraReports.UI.XRControlStyle(); this.xrControlStyle1 = new DevExpress.XtraReports.UI.XRControlStyle(); this.Title = new DevExpress.XtraReports.UI.XRControlStyle(); this.xrControlStyle4 = new DevExpress.XtraReports.UI.XRControlStyle(); this.xrControlStyle2 = new DevExpress.XtraReports.UI.XRControlStyle(); this.tbl_header_style = new DevExpress.XtraReports.UI.XRControlStyle(); this.tbl_even_detail = new DevExpress.XtraReports.UI.XRControlStyle(); this.tbl_odd_detail = new DevExpress.XtraReports.UI.XRControlStyle(); this.StatusImg = new DevExpress.XtraReports.UI.CalculatedField(); this.PeriodYear = new DevExpress.XtraReports.UI.CalculatedField(); this.PeriodMonth = new DevExpress.XtraReports.UI.CalculatedField(); this.PeriodDay = new DevExpress.XtraReports.UI.CalculatedField(); this.InUse = new DevExpress.XtraReports.Parameters.Parameter(); this.categoryIds = new DevExpress.XtraReports.Parameters.Parameter(); this.DeptIds = new DevExpress.XtraReports.Parameters.Parameter(); this.EmpIds = new DevExpress.XtraReports.Parameters.Parameter(); this.from = new DevExpress.XtraReports.Parameters.Parameter(); this.to = new DevExpress.XtraReports.Parameters.Parameter(); this.Culture = new DevExpress.XtraReports.Parameters.Parameter(); this.CompanyId = new DevExpress.XtraReports.Parameters.Parameter(); this.MappingEmpIds = new DevExpress.XtraReports.Parameters.Parameter(); this.MappingDeptIds = new DevExpress.XtraReports.Parameters.Parameter(); this.ReportName = new DevExpress.XtraReports.Parameters.Parameter(); this.MappingInUse = new DevExpress.XtraReports.Parameters.Parameter(); this.MappingCategoryIds = new DevExpress.XtraReports.Parameters.Parameter(); this.Custodystatus = new DevExpress.XtraReports.Parameters.Parameter(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // sqlDataSource1 // this.sqlDataSource1.ConnectionName = "HrContext"; this.sqlDataSource1.Name = "sqlDataSource1"; storedProcQuery1.Name = "SP_EmployeeCustody"; queryParameter1.Name = "@Culture"; queryParameter1.Type = typeof(DevExpress.DataAccess.Expression); queryParameter1.Value = new DevExpress.DataAccess.Expression("[Parameters.Culture]", typeof(string)); queryParameter2.Name = "@LoginCompanyId"; queryParameter2.Type = typeof(DevExpress.DataAccess.Expression); queryParameter2.Value = new DevExpress.DataAccess.Expression("[Parameters.CompanyId]", typeof(int)); queryParameter3.Name = "@deptName"; queryParameter3.Type = typeof(DevExpress.DataAccess.Expression); queryParameter3.Value = new DevExpress.DataAccess.Expression("[Parameters.MappingDeptIds]", typeof(string)); queryParameter4.Name = "@empIds"; queryParameter4.Type = typeof(DevExpress.DataAccess.Expression); queryParameter4.Value = new DevExpress.DataAccess.Expression("[Parameters.MappingEmpIds]", typeof(string)); queryParameter5.Name = "@inuse"; queryParameter5.Type = typeof(DevExpress.DataAccess.Expression); queryParameter5.Value = new DevExpress.DataAccess.Expression("[Parameters.MappingInUse]", typeof(string)); queryParameter6.Name = "@categoryIds"; queryParameter6.Type = typeof(DevExpress.DataAccess.Expression); queryParameter6.Value = new DevExpress.DataAccess.Expression("[Parameters.MappingCategoryIds]", typeof(string)); queryParameter7.Name = "@disposal"; queryParameter7.Type = typeof(string); queryParameter7.ValueInfo = "0"; storedProcQuery1.Parameters.Add(queryParameter1); storedProcQuery1.Parameters.Add(queryParameter2); storedProcQuery1.Parameters.Add(queryParameter3); storedProcQuery1.Parameters.Add(queryParameter4); storedProcQuery1.Parameters.Add(queryParameter5); storedProcQuery1.Parameters.Add(queryParameter6); storedProcQuery1.Parameters.Add(queryParameter7); storedProcQuery1.StoredProcName = "SP_EmployeeCustody"; this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { storedProcQuery1 }); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPivotGrid1 }); this.Detail.Dpi = 254F; this.Detail.HeightF = 394.3473F; this.Detail.KeepTogether = true; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F); this.Detail.SortFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] { new DevExpress.XtraReports.UI.GroupField("custodyName", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending), new DevExpress.XtraReports.UI.GroupField("custodyName", DevExpress.XtraReports.UI.XRColumnSortOrder.Descending), new DevExpress.XtraReports.UI.GroupField("delvryDate", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending), new DevExpress.XtraReports.UI.GroupField("delvryDate", DevExpress.XtraReports.UI.XRColumnSortOrder.Descending), new DevExpress.XtraReports.UI.GroupField("RecvDate", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending), new DevExpress.XtraReports.UI.GroupField("RecvDate", DevExpress.XtraReports.UI.XRColumnSortOrder.Descending), new DevExpress.XtraReports.UI.GroupField("CustodyCat", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending), new DevExpress.XtraReports.UI.GroupField("CustodyCat", DevExpress.XtraReports.UI.XRColumnSortOrder.Descending) }); this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // xrPivotGrid1 // this.xrPivotGrid1.Appearance.Cell.Font = new System.Drawing.Font("Tahoma", 8F); this.xrPivotGrid1.Appearance.CustomTotalCell.Font = new System.Drawing.Font("Tahoma", 8F); this.xrPivotGrid1.Appearance.FieldHeader.Font = new System.Drawing.Font("Tahoma", 8F); this.xrPivotGrid1.Appearance.FieldValue.Font = new System.Drawing.Font("Tahoma", 8F); this.xrPivotGrid1.Appearance.FieldValueGrandTotal.Font = new System.Drawing.Font("Tahoma", 8F); this.xrPivotGrid1.Appearance.FieldValueTotal.Font = new System.Drawing.Font("Tahoma", 8F); this.xrPivotGrid1.Appearance.GrandTotalCell.BackColor = System.Drawing.Color.Blue; this.xrPivotGrid1.Appearance.GrandTotalCell.Font = new System.Drawing.Font("Tahoma", 8F); this.xrPivotGrid1.Appearance.Lines.Font = new System.Drawing.Font("Tahoma", 8F); this.xrPivotGrid1.Appearance.TotalCell.Font = new System.Drawing.Font("Tahoma", 8F); this.xrPivotGrid1.DataMember = "SP_EmployeeCustody"; this.xrPivotGrid1.DataSource = this.sqlDataSource1; this.xrPivotGrid1.Dpi = 254F; this.xrPivotGrid1.Fields.AddRange(new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField[] { this.fielddeptName, this.fieldEmpName, this.fieldCustodyName, this.fieldEmployeeCustodyPrice }); this.xrPivotGrid1.LocationFloat = new DevExpress.Utils.PointFloat(10.58333F, 0F); this.xrPivotGrid1.Name = "xrPivotGrid1"; this.xrPivotGrid1.OptionsPrint.FilterSeparatorBarPadding = 3; this.xrPivotGrid1.OptionsPrint.PrintColumnHeaders = DevExpress.Utils.DefaultBoolean.False; this.xrPivotGrid1.OptionsPrint.PrintDataHeaders = DevExpress.Utils.DefaultBoolean.False; this.xrPivotGrid1.OptionsPrint.PrintFilterHeaders = DevExpress.Utils.DefaultBoolean.False; this.xrPivotGrid1.SizeF = new System.Drawing.SizeF(2940.07F, 329.8472F); // // fielddeptName // this.fielddeptName.Appearance.FieldHeader.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(210)))), ((int)(((byte)(215)))), ((int)(((byte)(227))))); this.fielddeptName.Appearance.FieldHeader.Font = new System.Drawing.Font("Frutiger LT Arabic 55 Roman", 9F, System.Drawing.FontStyle.Bold); this.fielddeptName.Appearance.FieldValue.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(239)))), ((int)(((byte)(243)))), ((int)(((byte)(250))))); this.fielddeptName.Appearance.FieldValue.Font = new System.Drawing.Font("Frutiger LT Arabic 55 Roman", 9F); this.fielddeptName.Appearance.FieldValueGrandTotal.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(128)))), ((int)(((byte)(128))))); this.fielddeptName.Appearance.FieldValueTotal.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(210)))), ((int)(((byte)(215)))), ((int)(((byte)(227))))); this.fielddeptName.Appearance.FieldValueTotal.Font = new System.Drawing.Font("Frutiger LT Arabic 55 Roman", 9F, System.Drawing.FontStyle.Bold); this.fielddeptName.Appearance.GrandTotalCell.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(255)))), ((int)(((byte)(128))))); this.fielddeptName.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fielddeptName.AreaIndex = 0; this.fielddeptName.Caption = "Department"; this.fielddeptName.FieldName = "deptName"; this.fielddeptName.Name = "fielddeptName"; this.fielddeptName.Width = 120; // // fieldEmpName // this.fieldEmpName.Appearance.FieldHeader.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(210)))), ((int)(((byte)(215)))), ((int)(((byte)(227))))); this.fieldEmpName.Appearance.FieldHeader.Font = new System.Drawing.Font("Frutiger LT Arabic 55 Roman", 9F, System.Drawing.FontStyle.Bold); this.fieldEmpName.Appearance.FieldValue.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(239)))), ((int)(((byte)(243)))), ((int)(((byte)(250))))); this.fieldEmpName.Appearance.FieldValue.Font = new System.Drawing.Font("Frutiger LT Arabic 55 Roman", 9F); this.fieldEmpName.Appearance.FieldValueGrandTotal.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(128)))), ((int)(((byte)(128))))); this.fieldEmpName.Appearance.GrandTotalCell.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(255)))), ((int)(((byte)(128))))); this.fieldEmpName.Appearance.TotalCell.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(255)))), ((int)(((byte)(255))))); this.fieldEmpName.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldEmpName.AreaIndex = 1; this.fieldEmpName.Caption = "Employee Name"; this.fieldEmpName.FieldName = "EmpName"; this.fieldEmpName.Name = "fieldEmpName"; this.fieldEmpName.Width = 120; // // fieldCustodyName // this.fieldCustodyName.Appearance.FieldValue.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(210)))), ((int)(((byte)(215)))), ((int)(((byte)(227))))); this.fieldCustodyName.Appearance.FieldValue.Font = new System.Drawing.Font("Frutiger LT Arabic 55 Roman", 9F, System.Drawing.FontStyle.Bold); this.fieldCustodyName.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldCustodyName.AreaIndex = 0; this.fieldCustodyName.Caption = "Custody Name"; this.fieldCustodyName.FieldName = "CustodyName"; this.fieldCustodyName.Name = "fieldCustodyName"; this.fieldCustodyName.Width = 120; // // fieldEmployeeCustodyPrice // this.fieldEmployeeCustodyPrice.Appearance.FieldHeader.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(239)))), ((int)(((byte)(243)))), ((int)(((byte)(250))))); this.fieldEmployeeCustodyPrice.Appearance.FieldHeader.Font = new System.Drawing.Font("Frutiger LT Arabic 55 Roman", 9F); this.fieldEmployeeCustodyPrice.Appearance.FieldValueGrandTotal.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(128))))); this.fieldEmployeeCustodyPrice.Appearance.FieldValueTotal.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(128))))); this.fieldEmployeeCustodyPrice.Appearance.GrandTotalCell.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(239)))), ((int)(((byte)(243)))), ((int)(((byte)(250))))); this.fieldEmployeeCustodyPrice.Appearance.GrandTotalCell.Font = new System.Drawing.Font("Frutiger LT Arabic 55 Roman", 9F); this.fieldEmployeeCustodyPrice.Appearance.TotalCell.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(210)))), ((int)(((byte)(215)))), ((int)(((byte)(227))))); this.fieldEmployeeCustodyPrice.Appearance.TotalCell.Font = new System.Drawing.Font("Frutiger LT Arabic 55 Roman", 9F, System.Drawing.FontStyle.Bold); this.fieldEmployeeCustodyPrice.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldEmployeeCustodyPrice.AreaIndex = 0; this.fieldEmployeeCustodyPrice.Caption = "Purchase of received Custodies"; this.fieldEmployeeCustodyPrice.FieldName = "EmployeeCustodyPrice"; this.fieldEmployeeCustodyPrice.Name = "fieldEmployeeCustodyPrice"; // // TopMargin // this.TopMargin.Dpi = 254F; this.TopMargin.HeightF = 0F; this.TopMargin.Name = "TopMargin"; this.TopMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F); this.TopMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // BottomMargin // this.BottomMargin.Dpi = 254F; this.BottomMargin.HeightF = 0F; this.BottomMargin.Name = "BottomMargin"; this.BottomMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F); this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // ReportHeader // this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.companyLogo, this.xrLabel4, this.xrLabel1 }); this.ReportHeader.Dpi = 254F; this.ReportHeader.HeightF = 219.9306F; this.ReportHeader.Name = "ReportHeader"; // // companyLogo // this.companyLogo.Dpi = 254F; this.companyLogo.LocationFloat = new DevExpress.Utils.PointFloat(10.58333F, 0F); this.companyLogo.Name = "companyLogo"; this.companyLogo.SizeF = new System.Drawing.SizeF(400F, 200F); this.companyLogo.Sizing = DevExpress.XtraPrinting.ImageSizeMode.Squeeze; // // xrLabel4 // this.xrLabel4.BorderColor = System.Drawing.Color.Transparent; this.xrLabel4.Dpi = 254F; this.xrLabel4.Font = new System.Drawing.Font("Frutiger LT Arabic 55 Roman", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel4.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(128))))); this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(825.6727F, 38.99773F); this.xrLabel4.Name = "xrLabel4"; this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrLabel4.SizeF = new System.Drawing.SizeF(1178.278F, 161.0023F); this.xrLabel4.StylePriority.UseBorderColor = false; this.xrLabel4.StylePriority.UseFont = false; this.xrLabel4.StylePriority.UseForeColor = false; this.xrLabel4.StylePriority.UseTextAlignment = false; this.xrLabel4.Text = "تقرير عهد الموظفين المستهلكة"; this.xrLabel4.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // xrLabel1 // this.xrLabel1.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding(this.CompanyName, "Text", "") }); this.xrLabel1.Dpi = 254F; this.xrLabel1.Font = new System.Drawing.Font("Frutiger LT Arabic 55 Roman", 14F, System.Drawing.FontStyle.Bold); this.xrLabel1.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(128))))); this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(2192.181F, 0F); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrLabel1.SizeF = new System.Drawing.SizeF(758.4722F, 139.5589F); this.xrLabel1.StylePriority.UseFont = false; this.xrLabel1.StylePriority.UseForeColor = false; this.xrLabel1.StylePriority.UseTextAlignment = false; this.xrLabel1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; // // CompanyName // this.CompanyName.Description = "CompanyName"; this.CompanyName.Name = "CompanyName"; this.CompanyName.Visible = false; // // PageFooter // this.PageFooter.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPageInfo2, this.xrPageInfo1, this.xrLabel10, this.xrLabel9 }); this.PageFooter.Dpi = 254F; this.PageFooter.HeightF = 77.61111F; this.PageFooter.Name = "PageFooter"; // // xrPageInfo2 // this.xrPageInfo2.Dpi = 254F; this.xrPageInfo2.Font = new System.Drawing.Font("Frutiger LT Arabic 55 Roman", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrPageInfo2.Format = "{0:yyyy-MM-dd h:mm tt}"; this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(10.58333F, 0F); this.xrPageInfo2.Name = "xrPageInfo2"; this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrPageInfo2.PageInfo = DevExpress.XtraPrinting.PageInfo.DateTime; this.xrPageInfo2.SizeF = new System.Drawing.SizeF(664.6506F, 58.42F); this.xrPageInfo2.StylePriority.UseFont = false; this.xrPageInfo2.StylePriority.UseTextAlignment = false; this.xrPageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // xrPageInfo1 // this.xrPageInfo1.Dpi = 254F; this.xrPageInfo1.Font = new System.Drawing.Font("Frutiger LT Arabic 55 Roman", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrPageInfo1.Format = "صفحة {0} من {1}"; this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(2696.653F, 8.308817F); this.xrPageInfo1.Name = "xrPageInfo1"; this.xrPageInfo1.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrPageInfo1.SizeF = new System.Drawing.SizeF(254F, 58.42F); this.xrPageInfo1.StylePriority.UseFont = false; this.xrPageInfo1.StylePriority.UseTextAlignment = false; this.xrPageInfo1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; // // xrLabel10 // this.xrLabel10.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding(this.User, "Text", "") }); this.xrLabel10.Dpi = 254F; this.xrLabel10.LocationFloat = new DevExpress.Utils.PointFloat(974.0002F, 5.364372F); this.xrLabel10.Name = "xrLabel10"; this.xrLabel10.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrLabel10.SizeF = new System.Drawing.SizeF(254F, 58.42F); this.xrLabel10.StylePriority.UseTextAlignment = false; this.xrLabel10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleJustify; // // User // this.User.Description = "User"; this.User.Name = "User"; this.User.Visible = false; // // xrLabel9 // this.xrLabel9.Dpi = 254F; this.xrLabel9.LocationFloat = new DevExpress.Utils.PointFloat(1228F, 5.364372F); this.xrLabel9.Name = "xrLabel9"; this.xrLabel9.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrLabel9.SizeF = new System.Drawing.SizeF(137.5833F, 58.41999F); this.xrLabel9.StylePriority.UseTextAlignment = false; this.xrLabel9.Text = "المستخدم"; this.xrLabel9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleJustify; // // formattingRule1 // this.formattingRule1.Condition = "[EmpStatus] == 0"; this.formattingRule1.DataMember = "EmployeeDetailsReport"; this.formattingRule1.Formatting.BackColor = System.Drawing.Color.White; this.formattingRule1.Formatting.BorderColor = System.Drawing.Color.White; this.formattingRule1.Formatting.BorderWidth = 10F; this.formattingRule1.Name = "formattingRule1"; // // formattingRule2 // this.formattingRule2.Condition = "[EmpStatus] == 1"; this.formattingRule2.DataMember = "EmployeeDetailsReport"; this.formattingRule2.Formatting.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(192)))), ((int)(((byte)(0))))); this.formattingRule2.Formatting.BorderColor = System.Drawing.Color.White; this.formattingRule2.Formatting.BorderWidth = 10F; this.formattingRule2.Name = "formattingRule2"; // // formattingRule3 // this.formattingRule3.Condition = "[EmpStatus] == 2"; this.formattingRule3.DataMember = "EmployeeDetailsReport"; this.formattingRule3.Formatting.BackColor = System.Drawing.Color.Yellow; this.formattingRule3.Formatting.BorderColor = System.Drawing.Color.White; this.formattingRule3.Formatting.BorderWidth = 10F; this.formattingRule3.Name = "formattingRule3"; // // formattingRule4 // this.formattingRule4.Condition = "[EmpStatus] == 3"; this.formattingRule4.DataMember = "EmployeeDetailsReport"; this.formattingRule4.Formatting.BackColor = System.Drawing.Color.Red; this.formattingRule4.Formatting.BorderColor = System.Drawing.Color.White; this.formattingRule4.Formatting.BorderWidth = 10F; this.formattingRule4.Name = "formattingRule4"; // // formattingRule5 // this.formattingRule5.Condition = "[EmpStatus] == 12"; this.formattingRule5.DataMember = "EmployeeDetailsReport"; this.formattingRule5.Formatting.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64))))); this.formattingRule5.Formatting.BorderColor = System.Drawing.Color.White; this.formattingRule5.Formatting.BorderWidth = 10F; this.formattingRule5.Name = "formattingRule5"; // // formattingRule6 // this.formattingRule6.Condition = "[EmpStatus]==1 Or ([EmpStatus] != 0 And [EmpStatus] != 3 And [EmpStatus] " + "!= 12 And [EmpStatus] != 2 )"; this.formattingRule6.DataMember = "EmployeeDetailsReport"; this.formattingRule6.Formatting.Visible = DevExpress.Utils.DefaultBoolean.True; this.formattingRule6.Name = "formattingRule6"; // // formattingRule7 // this.formattingRule7.Condition = "[CompanyId] == 4172 And [Source]==\'Company\' And [TypeId]=1"; this.formattingRule7.DataMember = "CompanyDocs.CompanyDocsCompanyDocuments"; this.formattingRule7.Formatting.Visible = DevExpress.Utils.DefaultBoolean.True; this.formattingRule7.Name = "formattingRule7"; // // Odding // this.Odding.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(220)))), ((int)(((byte)(220)))), ((int)(((byte)(220))))); this.Odding.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid; this.Odding.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.Odding.Name = "Odding"; this.Odding.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F); // // GroupCaption3 // this.GroupCaption3.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(128)))), ((int)(((byte)(128))))); this.GroupCaption3.BorderColor = System.Drawing.Color.Silver; this.GroupCaption3.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.GroupCaption3.BorderWidth = 2F; this.GroupCaption3.Font = new System.Drawing.Font("Tahoma", 8F, System.Drawing.FontStyle.Bold); this.GroupCaption3.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))); this.GroupCaption3.Name = "GroupCaption3"; this.GroupCaption3.Padding = new DevExpress.XtraPrinting.PaddingInfo(15, 5, 0, 0, 254F); this.GroupCaption3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // xrControlStyle1 // this.xrControlStyle1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(220)))), ((int)(((byte)(220)))), ((int)(((byte)(220))))); this.xrControlStyle1.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid; this.xrControlStyle1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrControlStyle1.Name = "xrControlStyle1"; this.xrControlStyle1.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F); // // Title // this.Title.BackColor = System.Drawing.Color.Transparent; this.Title.BorderColor = System.Drawing.Color.Black; this.Title.Borders = DevExpress.XtraPrinting.BorderSide.None; this.Title.BorderWidth = 1F; this.Title.Font = new System.Drawing.Font("Tahoma", 14F); this.Title.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(75)))), ((int)(((byte)(75)))), ((int)(((byte)(75))))); this.Title.Name = "Title"; // // xrControlStyle4 // this.xrControlStyle4.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid; this.xrControlStyle4.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrControlStyle4.Name = "xrControlStyle4"; this.xrControlStyle4.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F); // // xrControlStyle2 // this.xrControlStyle2.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid; this.xrControlStyle2.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrControlStyle2.Name = "xrControlStyle2"; this.xrControlStyle2.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F); // // tbl_header_style // this.tbl_header_style.BackColor = System.Drawing.SystemColors.ControlLight; this.tbl_header_style.BorderColor = System.Drawing.Color.Silver; this.tbl_header_style.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid; this.tbl_header_style.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.tbl_header_style.BorderWidth = 1F; this.tbl_header_style.Font = new System.Drawing.Font("Frutiger LT Arabic 55 Roman", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.tbl_header_style.ForeColor = System.Drawing.Color.Black; this.tbl_header_style.Name = "tbl_header_style"; this.tbl_header_style.Padding = new DevExpress.XtraPrinting.PaddingInfo(13, 13, 13, 13, 254F); this.tbl_header_style.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // tbl_even_detail // this.tbl_even_detail.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224))))); this.tbl_even_detail.BorderColor = System.Drawing.Color.Black; this.tbl_even_detail.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid; this.tbl_even_detail.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.tbl_even_detail.BorderWidth = 1F; this.tbl_even_detail.Font = new System.Drawing.Font("Frutiger LT Arabic 55 Roman", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.tbl_even_detail.ForeColor = System.Drawing.Color.Black; this.tbl_even_detail.Name = "tbl_even_detail"; this.tbl_even_detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(13, 13, 13, 13, 254F); this.tbl_even_detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; // // tbl_odd_detail // this.tbl_odd_detail.BackColor = System.Drawing.Color.White; this.tbl_odd_detail.BorderColor = System.Drawing.Color.Black; this.tbl_odd_detail.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid; this.tbl_odd_detail.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.tbl_odd_detail.BorderWidth = 1F; this.tbl_odd_detail.Font = new System.Drawing.Font("Frutiger LT Arabic 55 Roman", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.tbl_odd_detail.ForeColor = System.Drawing.Color.Black; this.tbl_odd_detail.Name = "tbl_odd_detail"; this.tbl_odd_detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(13, 13, 13, 13, 254F); this.tbl_odd_detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; // // StatusImg // this.StatusImg.DataMember = "EmployeeDetailsReport"; this.StatusImg.Expression = "\'~/Content/Icons/\' + ToStr([EmpStatus]) + \'.png\'"; this.StatusImg.Name = "StatusImg"; // // PeriodYear // this.PeriodYear.DataMember = "SP_TerminatedEmp"; this.PeriodYear.Expression = "Abs(ToInt([ServYear]))"; this.PeriodYear.Name = "PeriodYear"; // // PeriodMonth // this.PeriodMonth.DataMember = "SP_TerminatedEmp"; this.PeriodMonth.Expression = "(DateDiffMonth([ServStartDate],[ActualDate])%12)"; this.PeriodMonth.Name = "PeriodMonth"; // // PeriodDay // this.PeriodDay.DataMember = "SP_TerminatedEmp"; this.PeriodDay.Expression = "(DateDiffDay([ServStartDate],[ActualDate])%365)%30"; this.PeriodDay.FieldType = DevExpress.XtraReports.UI.FieldType.Int32; this.PeriodDay.Name = "PeriodDay"; // // InUse // this.InUse.Description = "موقف العهدة بالمخزن - مع الموظف"; this.InUse.MultiValue = true; this.InUse.Name = "InUse"; this.InUse.Type = typeof(int); this.InUse.Visible = false; // // categoryIds // this.categoryIds.Description = "Custody Category"; dynamicListLookUpSettings1.DataAdapter = null; dynamicListLookUpSettings1.DataMember = "SP_EmployeeCustody"; dynamicListLookUpSettings1.DataSource = this.sqlDataSource1; dynamicListLookUpSettings1.DisplayMember = "CategoryName"; dynamicListLookUpSettings1.ValueMember = "CategoryId"; this.categoryIds.LookUpSettings = dynamicListLookUpSettings1; this.categoryIds.MultiValue = true; this.categoryIds.Name = "categoryIds"; this.categoryIds.Type = typeof(int); // // DeptIds // this.DeptIds.Description = "Department"; dynamicListLookUpSettings2.DataAdapter = null; dynamicListLookUpSettings2.DataMember = "SP_EmployeeCustody"; dynamicListLookUpSettings2.DataSource = this.sqlDataSource1; dynamicListLookUpSettings2.DisplayMember = "deptName"; dynamicListLookUpSettings2.ValueMember = "deptId"; this.DeptIds.LookUpSettings = dynamicListLookUpSettings2; this.DeptIds.MultiValue = true; this.DeptIds.Name = "DeptIds"; this.DeptIds.Type = typeof(int); // // EmpIds // this.EmpIds.Description = "Employee Name"; dynamicListLookUpSettings3.DataAdapter = null; dynamicListLookUpSettings3.DataMember = "SP_EmployeeCustody"; dynamicListLookUpSettings3.DataSource = this.sqlDataSource1; dynamicListLookUpSettings3.DisplayMember = "EmpName"; dynamicListLookUpSettings3.ValueMember = "EmpId"; this.EmpIds.LookUpSettings = dynamicListLookUpSettings3; this.EmpIds.MultiValue = true; this.EmpIds.Name = "EmpIds"; this.EmpIds.Type = typeof(int); // // from // this.from.Description = "Receive Date from"; this.from.Name = "from"; this.from.Type = typeof(System.DateTime); this.from.ValueInfo = "2000-01-01"; // // to // this.to.Description = "To"; this.to.Name = "to"; this.to.Type = typeof(System.DateTime); this.to.ValueInfo = "2030-01-01"; // // Culture // this.Culture.Description = "Culture"; this.Culture.Name = "Culture"; this.Culture.ValueInfo = "en-GB"; this.Culture.Visible = false; // // CompanyId // this.CompanyId.Description = "CompanyId"; this.CompanyId.Name = "CompanyId"; this.CompanyId.Type = typeof(int); this.CompanyId.ValueInfo = "0"; this.CompanyId.Visible = false; // // MappingEmpIds // this.MappingEmpIds.Description = "MappingEmpIds"; this.MappingEmpIds.Name = "MappingEmpIds"; this.MappingEmpIds.Visible = false; // // MappingDeptIds // this.MappingDeptIds.Description = "MappingDeptIds"; this.MappingDeptIds.Name = "MappingDeptIds"; this.MappingDeptIds.Visible = false; // // ReportName // this.ReportName.Description = "ReportName"; this.ReportName.Name = "ReportName"; this.ReportName.ValueInfo = "EmployeeCustodiesReport"; this.ReportName.Visible = false; // // MappingInUse // this.MappingInUse.Description = "MappingInUse"; this.MappingInUse.Name = "MappingInUse"; this.MappingInUse.Visible = false; // // MappingCategoryIds // this.MappingCategoryIds.Description = "MappingCategoryIds"; this.MappingCategoryIds.Name = "MappingCategoryIds"; this.MappingCategoryIds.Visible = false; // // Custodystatus // this.Custodystatus.Description = "DisposalOrNot"; this.Custodystatus.Name = "Custodystatus"; this.Custodystatus.Type = typeof(int); this.Custodystatus.ValueInfo = "1"; this.Custodystatus.Visible = false; // // en_DisposalEmployeesCustodies // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.ReportHeader, this.PageFooter }); this.Bookmark = "الهيكل التوظيفى"; this.CalculatedFields.AddRange(new DevExpress.XtraReports.UI.CalculatedField[] { this.StatusImg, this.PeriodYear, this.PeriodMonth, this.PeriodDay }); this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] { this.sqlDataSource1 }); this.Dpi = 254F; this.FilterString = "[ReceiveDate] Between(?from, ?to)"; this.FormattingRuleSheet.AddRange(new DevExpress.XtraReports.UI.FormattingRule[] { this.formattingRule1, this.formattingRule2, this.formattingRule3, this.formattingRule4, this.formattingRule5, this.formattingRule6, this.formattingRule7 }); this.Landscape = true; this.Margins = new System.Drawing.Printing.Margins(0, 4, 0, 0); this.PageHeight = 2100; this.PageWidth = 2970; this.PaperKind = System.Drawing.Printing.PaperKind.A4; this.Parameters.AddRange(new DevExpress.XtraReports.Parameters.Parameter[] { this.InUse, this.categoryIds, this.DeptIds, this.EmpIds, this.from, this.to, this.Culture, this.CompanyId, this.User, this.CompanyName, this.MappingEmpIds, this.MappingDeptIds, this.ReportName, this.MappingInUse, this.MappingCategoryIds, this.Custodystatus }); this.ReportUnit = DevExpress.XtraReports.UI.ReportUnit.TenthsOfAMillimeter; this.SnapGridSize = 25F; this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] { this.Odding, this.GroupCaption3, this.xrControlStyle1, this.Title, this.xrControlStyle4, this.xrControlStyle2, this.tbl_header_style, this.tbl_even_detail, this.tbl_odd_detail }); this.Version = "17.1"; ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.xrPivotGrid1 = new DevExpress.XtraReports.UI.XRPivotGrid(); this.bindingSource3 = new System.Windows.Forms.BindingSource(this.components); this.fieldBudgetYear1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldProgram1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldRegion1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldQuarter1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldMonth1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldDistributedAmount1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand(); this.GroupHeader1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); ((System.ComponentModel.ISupportInitialize)(this.bindingSource3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPivotGrid1}); this.Detail.Dpi = 254F; this.Detail.HeightF = 396.475F; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F); this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // xrPivotGrid1 // this.xrPivotGrid1.Appearance.CustomTotalCell.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold); this.xrPivotGrid1.Appearance.CustomTotalCell.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; this.xrPivotGrid1.Appearance.FieldHeader.BackColor = System.Drawing.Color.Gainsboro; this.xrPivotGrid1.Appearance.FieldHeader.BorderColor = System.Drawing.Color.Silver; this.xrPivotGrid1.Appearance.FieldHeader.Font = new System.Drawing.Font("Verdana", 8F); this.xrPivotGrid1.Appearance.FieldHeader.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrPivotGrid1.Appearance.FieldValueGrandTotal.BackColor = System.Drawing.Color.Gainsboro; this.xrPivotGrid1.Appearance.FieldValueGrandTotal.Font = new System.Drawing.Font("Verdana", 9F); this.xrPivotGrid1.Appearance.FieldValueTotal.Font = new System.Drawing.Font("Verdana", 8F); this.xrPivotGrid1.Appearance.FieldValueTotal.ForeColor = System.Drawing.Color.Blue; this.xrPivotGrid1.Appearance.HeaderGroupLine.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(224)))), ((int)(((byte)(192))))); this.xrPivotGrid1.Appearance.TotalCell.Font = new System.Drawing.Font("Verdana", 8F); this.xrPivotGrid1.DataSource = this.bindingSource3; this.xrPivotGrid1.Dpi = 254F; this.xrPivotGrid1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.fieldBudgetYear1, this.fieldProgram1, this.fieldRegion1, this.fieldQuarter1, this.fieldMonth1, this.fieldDistributedAmount1}); this.xrPivotGrid1.LocationFloat = new DevExpress.Utils.PointFloat(0.0002018611F, 0F); this.xrPivotGrid1.Name = "xrPivotGrid1"; this.xrPivotGrid1.OLAPConnectionString = ""; this.xrPivotGrid1.OptionsChartDataSource.UpdateDelay = 300; this.xrPivotGrid1.SizeF = new System.Drawing.SizeF(1987F, 371.475F); // // bindingSource3 // this.bindingSource3.DataSource = typeof(Cats.Models.Hub.ViewModels.Report.Data.DistributionRows); // // fieldBudgetYear1 // this.fieldBudgetYear1.AreaIndex = 0; this.fieldBudgetYear1.Caption = "Budget Year"; this.fieldBudgetYear1.FieldName = "BudgetYear"; this.fieldBudgetYear1.Name = "fieldBudgetYear1"; // // fieldProgram1 // this.fieldProgram1.AreaIndex = 1; this.fieldProgram1.Caption = "Program"; this.fieldProgram1.FieldName = "Program"; this.fieldProgram1.Name = "fieldProgram1"; // // fieldRegion1 // this.fieldRegion1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldRegion1.AreaIndex = 0; this.fieldRegion1.Caption = "Region"; this.fieldRegion1.FieldName = "Region"; this.fieldRegion1.Name = "fieldRegion1"; this.fieldRegion1.Width = 150; // // fieldQuarter1 // this.fieldQuarter1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldQuarter1.AreaIndex = 0; this.fieldQuarter1.Caption = "Quarter"; this.fieldQuarter1.FieldName = "Quarter"; this.fieldQuarter1.Name = "fieldQuarter1"; // // fieldMonth1 // this.fieldMonth1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldMonth1.AreaIndex = 1; this.fieldMonth1.Caption = "Month"; this.fieldMonth1.FieldName = "Month"; this.fieldMonth1.Name = "fieldMonth1"; this.fieldMonth1.Width = 190; // // fieldDistributedAmount1 // this.fieldDistributedAmount1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldDistributedAmount1.AreaIndex = 0; this.fieldDistributedAmount1.Caption = "Distributed Amount"; this.fieldDistributedAmount1.FieldName = "DistributedAmount"; this.fieldDistributedAmount1.Name = "fieldDistributedAmount1"; // // TopMargin // this.TopMargin.Dpi = 254F; this.TopMargin.HeightF = 18F; this.TopMargin.Name = "TopMargin"; this.TopMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F); this.TopMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // BottomMargin // this.BottomMargin.Dpi = 254F; this.BottomMargin.HeightF = 51F; this.BottomMargin.Name = "BottomMargin"; this.BottomMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F); this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // GroupHeader1 // this.GroupHeader1.Dpi = 254F; this.GroupHeader1.HeightF = 254F; this.GroupHeader1.Name = "GroupHeader1"; // // DistributionReportPivot // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.GroupHeader1}); this.Dpi = 254F; this.Margins = new System.Drawing.Printing.Margins(36, 53, 18, 51); this.PageHeight = 2969; this.PageWidth = 2101; this.PaperKind = System.Drawing.Printing.PaperKind.A4; this.ReportUnit = DevExpress.XtraReports.UI.ReportUnit.TenthsOfAMillimeter; this.SnapGridSize = 31.75F; this.Version = "10.2"; ((System.ComponentModel.ISupportInitialize)(this.bindingSource3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); DevExpress.DataAccess.Sql.SelectQuery selectQuery1 = new DevExpress.DataAccess.Sql.SelectQuery(); DevExpress.DataAccess.Sql.Column column1 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression1 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.Table table1 = new DevExpress.DataAccess.Sql.Table(); DevExpress.DataAccess.Sql.Column column2 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression2 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.Column column3 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression3 = new DevExpress.DataAccess.Sql.ColumnExpression(); DevExpress.DataAccess.Sql.Column column4 = new DevExpress.DataAccess.Sql.Column(); DevExpress.DataAccess.Sql.ColumnExpression columnExpression4 = new DevExpress.DataAccess.Sql.ColumnExpression(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(XtraReport1)); this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.xrPivotGrid1 = new DevExpress.XtraReports.UI.XRPivotGrid(); this.fieldCategoryName = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldProductName = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldProductSales = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.pivotGridField3 = new DevExpress.XtraPivotGrid.PivotGridField(); this.topMarginBand1 = new DevExpress.XtraReports.UI.TopMarginBand(); this.bottomMarginBand1 = new DevExpress.XtraReports.UI.BottomMarginBand(); this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPivotGrid1 }); this.Detail.HeightF = 245F; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.Detail.PageBreak = DevExpress.XtraReports.UI.PageBreak.AfterBand; this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; this.Detail.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.Detail_BeforePrint); // // xrPivotGrid1 // this.xrPivotGrid1.Appearance.Cell.Font = new System.Drawing.Font("Tahoma", 8.25F); this.xrPivotGrid1.Appearance.CustomTotalCell.Font = new System.Drawing.Font("Tahoma", 8.25F); this.xrPivotGrid1.Appearance.FieldHeader.Font = new System.Drawing.Font("Tahoma", 8.25F); this.xrPivotGrid1.Appearance.FieldValue.Font = new System.Drawing.Font("Tahoma", 8.25F); this.xrPivotGrid1.Appearance.FieldValueGrandTotal.Font = new System.Drawing.Font("Tahoma", 8.25F); this.xrPivotGrid1.Appearance.FieldValueTotal.Font = new System.Drawing.Font("Tahoma", 8.25F); this.xrPivotGrid1.Appearance.GrandTotalCell.Font = new System.Drawing.Font("Tahoma", 8.25F); this.xrPivotGrid1.Appearance.Lines.Font = new System.Drawing.Font("Tahoma", 8.25F); this.xrPivotGrid1.Appearance.TotalCell.Font = new System.Drawing.Font("Tahoma", 8.25F); this.xrPivotGrid1.DataMember = "ProductReports"; this.xrPivotGrid1.DataSource = this.sqlDataSource1; this.xrPivotGrid1.Fields.AddRange(new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField[] { this.fieldCategoryName, this.fieldProductName, this.fieldProductSales }); this.xrPivotGrid1.LocationFloat = new DevExpress.Utils.PointFloat(7.999992F, 7.999992F); this.xrPivotGrid1.Name = "xrPivotGrid1"; this.xrPivotGrid1.SizeF = new System.Drawing.SizeF(733F, 117F); // // fieldCategoryName // this.fieldCategoryName.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldCategoryName.AreaIndex = 0; this.fieldCategoryName.FieldName = "CategoryName"; this.fieldCategoryName.Name = "fieldCategoryName"; // // fieldProductName // this.fieldProductName.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldProductName.AreaIndex = 1; this.fieldProductName.FieldName = "ProductName"; this.fieldProductName.Name = "fieldProductName"; // // fieldProductSales // this.fieldProductSales.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldProductSales.AreaIndex = 0; this.fieldProductSales.FieldName = "ProductSales"; this.fieldProductSales.Name = "fieldProductSales"; // // pivotGridField3 // this.pivotGridField3.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.pivotGridField3.AreaIndex = 0; this.pivotGridField3.FieldName = "CategoryName"; this.pivotGridField3.Name = "pivotGridField3"; // // topMarginBand1 // this.topMarginBand1.HeightF = 48F; this.topMarginBand1.Name = "topMarginBand1"; // // bottomMarginBand1 // this.bottomMarginBand1.HeightF = 48F; this.bottomMarginBand1.Name = "bottomMarginBand1"; // // sqlDataSource1 // this.sqlDataSource1.ConnectionName = "nwindConnectionString"; this.sqlDataSource1.Name = "sqlDataSource1"; columnExpression1.ColumnName = "CategoryName"; table1.Name = "ProductReports"; columnExpression1.Table = table1; column1.Expression = columnExpression1; columnExpression2.ColumnName = "ProductName"; columnExpression2.Table = table1; column2.Expression = columnExpression2; columnExpression3.ColumnName = "ProductSales"; columnExpression3.Table = table1; column3.Expression = columnExpression3; columnExpression4.ColumnName = "ShippedDate"; columnExpression4.Table = table1; column4.Expression = columnExpression4; selectQuery1.Columns.Add(column1); selectQuery1.Columns.Add(column2); selectQuery1.Columns.Add(column3); selectQuery1.Columns.Add(column4); selectQuery1.Name = "ProductReports"; selectQuery1.Tables.Add(table1); this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { selectQuery1 }); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // XtraReport1 // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.topMarginBand1, this.bottomMarginBand1 }); this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] { this.sqlDataSource1 }); this.Margins = new System.Drawing.Printing.Margins(50, 49, 48, 48); this.Version = "18.1"; ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
private void InitializeComponent() { this.topMarginBand1 = new DevExpress.XtraReports.UI.TopMarginBand(); this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel(); this.detailBand1 = new DevExpress.XtraReports.UI.DetailBand(); this.xrPivotGrid1 = new DevExpress.XtraReports.UI.XRPivotGrid(); this.xrPivotGridField6 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.xrPivotGridField1 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.xrPivotGridField2 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.xrPivotGridField3 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.xrPivotGridField4 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.xrPivotGridField5 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.xrPivotGridField7 = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.bottomMarginBand1 = new DevExpress.XtraReports.UI.BottomMarginBand(); this.ReportFooter = new DevExpress.XtraReports.UI.ReportFooterBand(); this.xrTable1 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow1 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell1 = new DevExpress.XtraReports.UI.XRTableCell(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // topMarginBand1 // this.topMarginBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel3, this.xrLabel1, this.xrLabel2 }); this.topMarginBand1.Name = "topMarginBand1"; // // xrLabel3 // this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(628.0835F, 77F); this.xrLabel3.Name = "xrLabel3"; this.xrLabel3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel3.SizeF = new System.Drawing.SizeF(100F, 23F); this.xrLabel3.StylePriority.UseTextAlignment = false; this.xrLabel3.Text = "2015/12/1"; this.xrLabel3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // xrLabel1 // this.xrLabel1.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel1.SizeF = new System.Drawing.SizeF(86.45834F, 14.66667F); this.xrLabel1.StylePriority.UseFont = false; this.xrLabel1.Text = "报表编号"; // // xrLabel2 // this.xrLabel2.AutoWidth = true; this.xrLabel2.Font = new System.Drawing.Font("微软雅黑", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(263.5417F, 39.58333F); this.xrLabel2.Name = "xrLabel2"; this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel2.SizeF = new System.Drawing.SizeF(197.9168F, 23F); this.xrLabel2.StylePriority.UseFont = false; this.xrLabel2.StylePriority.UseTextAlignment = false; this.xrLabel2.Text = "制造单元完工日报表"; this.xrLabel2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrLabel2.WordWrap = false; // // detailBand1 // this.detailBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPivotGrid1 }); this.detailBand1.Name = "detailBand1"; // // xrPivotGrid1 // this.xrPivotGrid1.Appearance.Cell.BackColor = System.Drawing.Color.White; this.xrPivotGrid1.Appearance.Cell.Font = new System.Drawing.Font("Times New Roman", 9.75F); this.xrPivotGrid1.Appearance.Cell.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrPivotGrid1.Appearance.CustomTotalCell.BackColor = System.Drawing.Color.White; this.xrPivotGrid1.Appearance.CustomTotalCell.Font = new System.Drawing.Font("Times New Roman", 9.75F); this.xrPivotGrid1.Appearance.CustomTotalCell.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrPivotGrid1.Appearance.FieldHeader.BackColor = System.Drawing.Color.White; this.xrPivotGrid1.Appearance.FieldHeader.Font = new System.Drawing.Font("Times New Roman", 9.75F); this.xrPivotGrid1.Appearance.FieldHeader.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrPivotGrid1.Appearance.FieldValue.BackColor = System.Drawing.Color.White; this.xrPivotGrid1.Appearance.FieldValue.Font = new System.Drawing.Font("Times New Roman", 9.75F); this.xrPivotGrid1.Appearance.FieldValue.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrPivotGrid1.Appearance.FieldValueGrandTotal.BackColor = System.Drawing.Color.White; this.xrPivotGrid1.Appearance.FieldValueGrandTotal.Font = new System.Drawing.Font("Times New Roman", 9.75F); this.xrPivotGrid1.Appearance.FieldValueGrandTotal.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrPivotGrid1.Appearance.FieldValueTotal.BackColor = System.Drawing.Color.White; this.xrPivotGrid1.Appearance.FieldValueTotal.Font = new System.Drawing.Font("Times New Roman", 9.75F); this.xrPivotGrid1.Appearance.FieldValueTotal.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrPivotGrid1.Appearance.FilterSeparator.BackColor = System.Drawing.Color.White; this.xrPivotGrid1.Appearance.FilterSeparator.Font = new System.Drawing.Font("Times New Roman", 9.75F); this.xrPivotGrid1.Appearance.FilterSeparator.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrPivotGrid1.Appearance.GrandTotalCell.BackColor = System.Drawing.Color.White; this.xrPivotGrid1.Appearance.GrandTotalCell.Font = new System.Drawing.Font("Times New Roman", 9.75F); this.xrPivotGrid1.Appearance.GrandTotalCell.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrPivotGrid1.Appearance.HeaderGroupLine.BackColor = System.Drawing.Color.White; this.xrPivotGrid1.Appearance.HeaderGroupLine.Font = new System.Drawing.Font("Times New Roman", 9.75F); this.xrPivotGrid1.Appearance.HeaderGroupLine.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrPivotGrid1.Appearance.Lines.Font = new System.Drawing.Font("Times New Roman", 9.75F); this.xrPivotGrid1.Appearance.Lines.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrPivotGrid1.Appearance.TotalCell.BackColor = System.Drawing.Color.White; this.xrPivotGrid1.Appearance.TotalCell.Font = new System.Drawing.Font("Times New Roman", 9.75F); this.xrPivotGrid1.Appearance.TotalCell.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrPivotGrid1.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.xrPivotGridField6, this.xrPivotGridField1, this.xrPivotGridField2, this.xrPivotGridField3, this.xrPivotGridField4, this.xrPivotGridField5, this.xrPivotGridField7 }); this.xrPivotGrid1.LocationFloat = new DevExpress.Utils.PointFloat(3.178914E-05F, 0F); this.xrPivotGrid1.Name = "xrPivotGrid1"; this.xrPivotGrid1.OptionsChartDataSource.UpdateDelay = 300; this.xrPivotGrid1.OptionsDataField.AreaIndex = 2; this.xrPivotGrid1.OptionsView.RowTotalsLocation = DevExpress.XtraPivotGrid.PivotRowTotalsLocation.Near; this.xrPivotGrid1.OptionsView.ShowColumnGrandTotalHeader = false; this.xrPivotGrid1.OptionsView.ShowColumnHeaders = false; this.xrPivotGrid1.OptionsView.ShowColumnTotals = false; this.xrPivotGrid1.OptionsView.ShowDataHeaders = false; this.xrPivotGrid1.OptionsView.ShowFilterHeaders = false; this.xrPivotGrid1.OptionsView.ShowFilterSeparatorBar = false; this.xrPivotGrid1.OptionsView.ShowHorzLines = false; this.xrPivotGrid1.OptionsView.ShowRowGrandTotalHeader = false; this.xrPivotGrid1.OptionsView.ShowRowGrandTotals = false; this.xrPivotGrid1.OptionsView.ShowRowTotals = false; this.xrPivotGrid1.OptionsView.ShowVertLines = false; this.xrPivotGrid1.SizeF = new System.Drawing.SizeF(728.0834F, 100F); // // xrPivotGridField6 // this.xrPivotGridField6.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.xrPivotGridField6.AreaIndex = 0; this.xrPivotGridField6.Caption = "生产部门"; this.xrPivotGridField6.FieldName = "DEPT"; this.xrPivotGridField6.Name = "xrPivotGridField6"; this.xrPivotGridField6.Width = 80; // // xrPivotGridField1 // this.xrPivotGridField1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.xrPivotGridField1.AreaIndex = 1; this.xrPivotGridField1.Caption = "生产线"; this.xrPivotGridField1.FieldName = "PLINE_NAME"; this.xrPivotGridField1.Name = "xrPivotGridField1"; this.xrPivotGridField1.Width = 260; // // xrPivotGridField2 // this.xrPivotGridField2.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.xrPivotGridField2.AreaIndex = 2; this.xrPivotGridField2.Caption = "合同号"; this.xrPivotGridField2.FieldName = "PROJECT_CODE"; this.xrPivotGridField2.Name = "xrPivotGridField2"; this.xrPivotGridField2.TotalsVisibility = DevExpress.XtraPivotGrid.PivotTotalsVisibility.None; this.xrPivotGridField2.UnboundFieldName = "xrPivotGridField2"; this.xrPivotGridField2.Width = 80; // // xrPivotGridField3 // this.xrPivotGridField3.AllowedAreas = DevExpress.XtraPivotGrid.PivotGridAllowedAreas.RowArea; this.xrPivotGridField3.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.xrPivotGridField3.AreaIndex = 4; this.xrPivotGridField3.Caption = "成品号"; this.xrPivotGridField3.FieldName = "PRODUCT_CODE"; this.xrPivotGridField3.Name = "xrPivotGridField3"; this.xrPivotGridField3.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Custom; // // xrPivotGridField4 // this.xrPivotGridField4.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.xrPivotGridField4.AreaIndex = 5; this.xrPivotGridField4.Caption = "入库地点"; this.xrPivotGridField4.FieldName = "STORE_CODE"; this.xrPivotGridField4.Name = "xrPivotGridField4"; this.xrPivotGridField4.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Var; this.xrPivotGridField4.Width = 80; // // xrPivotGridField5 // this.xrPivotGridField5.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.xrPivotGridField5.AreaIndex = 0; this.xrPivotGridField5.Caption = "备注"; this.xrPivotGridField5.EmptyCellText = " "; this.xrPivotGridField5.EmptyValueText = " "; this.xrPivotGridField5.GrandTotalText = " "; this.xrPivotGridField5.Name = "xrPivotGridField5"; this.xrPivotGridField5.Width = 23; // // xrPivotGridField7 // this.xrPivotGridField7.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.xrPivotGridField7.AreaIndex = 3; this.xrPivotGridField7.Caption = "订单数量"; this.xrPivotGridField7.FieldName = "ORDER_NUM"; this.xrPivotGridField7.Name = "xrPivotGridField7"; this.xrPivotGridField7.Width = 80; // // bottomMarginBand1 // this.bottomMarginBand1.HeightF = 30F; this.bottomMarginBand1.Name = "bottomMarginBand1"; // // ReportFooter // this.ReportFooter.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable1 }); this.ReportFooter.HeightF = 26.04167F; this.ReportFooter.Name = "ReportFooter"; // // xrTable1 // this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(3.178914E-05F, 0F); this.xrTable1.Name = "xrTable1"; this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow1 }); this.xrTable1.SizeF = new System.Drawing.SizeF(728.0834F, 25F); // // xrTableRow1 // this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell1 }); this.xrTableRow1.Name = "xrTableRow1"; this.xrTableRow1.Weight = 1D; // // xrTableCell1 // this.xrTableCell1.Name = "xrTableCell1"; this.xrTableCell1.Text = "总计"; this.xrTableCell1.Weight = 3D; // // Report_Exp2000_1 // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.topMarginBand1, this.detailBand1, this.bottomMarginBand1, this.ReportFooter }); this.Margins = new System.Drawing.Printing.Margins(53, 60, 100, 30); this.Version = "11.1"; ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.pivotGridField3 = new DevExpress.XtraPivotGrid.PivotGridField(); this.topMarginBand1 = new DevExpress.XtraReports.UI.TopMarginBand(); this.bottomMarginBand1 = new DevExpress.XtraReports.UI.BottomMarginBand(); this.fieldProductSales = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldProductName = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.fieldCategoryName = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField(); this.xrPivotGrid1 = new DevExpress.XtraReports.UI.XRPivotGrid(); this.objectDataSource1 = new DevExpress.DataAccess.ObjectBinding.ObjectDataSource(this.components); ((System.ComponentModel.ISupportInitialize)(this.objectDataSource1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPivotGrid1 }); this.Detail.HeightF = 99.99998F; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.Detail.PageBreak = DevExpress.XtraReports.UI.PageBreak.AfterBand; this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // pivotGridField3 // this.pivotGridField3.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.pivotGridField3.AreaIndex = 0; this.pivotGridField3.FieldName = "CategoryName"; this.pivotGridField3.Name = "pivotGridField3"; // // topMarginBand1 // this.topMarginBand1.HeightF = 48F; this.topMarginBand1.Name = "topMarginBand1"; // // bottomMarginBand1 // this.bottomMarginBand1.HeightF = 48F; this.bottomMarginBand1.Name = "bottomMarginBand1"; // // fieldProductSales // this.fieldProductSales.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldProductSales.AreaIndex = 0; this.fieldProductSales.FieldName = "ProductSales"; this.fieldProductSales.Name = "fieldProductSales"; // // fieldProductName // this.fieldProductName.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldProductName.AreaIndex = 1; this.fieldProductName.FieldName = "ProductName"; this.fieldProductName.Name = "fieldProductName"; // // fieldCategoryName // this.fieldCategoryName.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldCategoryName.AreaIndex = 0; this.fieldCategoryName.FieldName = "CategoryName"; this.fieldCategoryName.Name = "fieldCategoryName"; // // xrPivotGrid1 // this.xrPivotGrid1.DataSource = this.objectDataSource1; this.xrPivotGrid1.Fields.AddRange(new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField[] { this.fieldCategoryName, this.fieldProductName, this.fieldProductSales }); this.xrPivotGrid1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrPivotGrid1.Name = "xrPivotGrid1"; this.xrPivotGrid1.SizeF = new System.Drawing.SizeF(751F, 99.99998F); // // objectDataSource1 // this.objectDataSource1.DataSource = typeof(DXWebApplication3.Models.ProductReport); this.objectDataSource1.Name = "objectDataSource1"; // // XtraReport1 // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.topMarginBand1, this.bottomMarginBand1 }); this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] { this.objectDataSource1 }); this.Margins = new System.Drawing.Printing.Margins(50, 49, 48, 48); this.Version = "19.2"; ((System.ComponentModel.ISupportInitialize)(this.objectDataSource1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }