private void getReport() { var outGateDT = new DataTable(); string condition; DateTime dateOut; string dateOutStr; outGateSummary.Rows.Clear(); condition = "where [Booking Number] <> '' and [Gate Date Out] >= '" + Conversions.ToString(fromInBunifuDatePicker.Value.Date) + "' and " + " [Gate Date Out] <= '" + Conversions.ToString(toInBunifuDatePicker.Value.Date) + "' and ([Container Rejected] is null or [Container Rejected] = 0) order by [Gate Date Out], [Gate Time Out]"; outGateDT = dbCeres.getTableInfo("[Containers In-Out]", "*", condition); foreach (DataRow row in outGateDT.Rows) { if (row["Gate Date Out"] != DBNull.Value) { dateOut = Conversions.ToDate(row["Gate Date Out"]); dateOutStr = dateOut.ToString("dd-MMM-yyyy @ hh:mm tt"); } else { dateOutStr = ""; } var newRow = outGateSummary.NewOutgatedContainersRow(); if (row["ContainerSize"] != DBNull.Value) { newRow.Size = Conversions.ToString(row["ContainerSize"]); } else { newRow.Size = ""; } newRow.Container_Number = Strings.Trim(Conversions.ToString(row["Container Number"])); newRow.Booking_Number = Strings.Trim(Conversions.ToString(row["Booking Number"])); newRow.Tare = MdlContainerManagement.DoFunctions.CVS(Conversions.ToString(row["TARE Weight Out"])); newRow._Date_Time = dateOutStr; newRow.Outgoing_Carrier = Strings.Trim(Conversions.ToString(row["carrier name out"])); newRow.ssLine = Strings.Trim(Conversions.ToString(row["SS Line Name Out"])); outGateSummary.AddOutgatedContainersRow(newRow); } try { var reportSource = new CrystalReportOuGate(); reportSource.Database.Tables[0].SetDataSource(outGateSummary.CopyToDataTable()); CrystalReportViewer1.ReportSource = reportSource; } catch { } }
private void InitializeComponent() { var resources = new System.ComponentModel.ComponentResourceManager(typeof(FrmOutGateReport)); var BorderEdges1 = new Bunifu.UI.WinForms.BunifuButton.BunifuButton.BorderEdges(); var StateProperties1 = new Bunifu.UI.WinForms.BunifuButton.BunifuButton.StateProperties(); var StateProperties2 = new Bunifu.UI.WinForms.BunifuButton.BunifuButton.StateProperties(); _closeFlatButton = new Bunifu.Framework.UI.BunifuFlatButton(); _closeFlatButton.Click += new EventHandler(closeFlatButton_Click); _closeFlatButton.Load += new EventHandler(closeFlatButton_Load); Label8 = new Label(); CrystalReportViewer1 = new CrystalDecisions.Windows.Forms.CrystalReportViewer(); _refreshInShapedButton = new Bunifu.UI.WinForms.BunifuButton.BunifuButton(); _refreshInShapedButton.Click += new EventHandler(refreshInShapedButton_Click); toInBunifuDatePicker = new Bunifu.UI.WinForms.BunifuDatePicker(); fromInBunifuDatePicker = new Bunifu.UI.WinForms.BunifuDatePicker(); Label1 = new Label(); Label2 = new Label(); CrystalReportOuGate1 = new CrystalReportOuGate(); SuspendLayout(); // // closeFlatButton // _closeFlatButton.Active = false; _closeFlatButton.Activecolor = Color.FromArgb(Conversions.ToInteger(Conversions.ToByte(64)), Conversions.ToInteger(Conversions.ToByte(64)), Conversions.ToInteger(Conversions.ToByte(64))); _closeFlatButton.Anchor = AnchorStyles.Top | AnchorStyles.Right; _closeFlatButton.BackColor = Color.FromArgb(Conversions.ToInteger(Conversions.ToByte(64)), Conversions.ToInteger(Conversions.ToByte(64)), Conversions.ToInteger(Conversions.ToByte(64))); _closeFlatButton.BackgroundImageLayout = ImageLayout.Stretch; _closeFlatButton.BorderRadius = 0; _closeFlatButton.ButtonText = "🗙"; _closeFlatButton.Cursor = Cursors.Hand; _closeFlatButton.DisabledColor = Color.Gray; _closeFlatButton.Iconcolor = Color.Transparent; _closeFlatButton.Iconimage = null; _closeFlatButton.Iconimage_right = null; _closeFlatButton.Iconimage_right_Selected = null; _closeFlatButton.Iconimage_Selected = null; _closeFlatButton.IconMarginLeft = 0; _closeFlatButton.IconMarginRight = 0; _closeFlatButton.IconRightVisible = true; _closeFlatButton.IconRightZoom = 0d; _closeFlatButton.IconVisible = true; _closeFlatButton.IconZoom = 90.0d; _closeFlatButton.IsTab = false; _closeFlatButton.Location = new Point(1216, 0); _closeFlatButton.Name = "_closeFlatButton"; _closeFlatButton.Normalcolor = Color.FromArgb(Conversions.ToInteger(Conversions.ToByte(64)), Conversions.ToInteger(Conversions.ToByte(64)), Conversions.ToInteger(Conversions.ToByte(64))); _closeFlatButton.OnHovercolor = Color.Gray; _closeFlatButton.OnHoverTextColor = Color.White; _closeFlatButton.selected = false; _closeFlatButton.Size = new Size(43, 41); _closeFlatButton.TabIndex = 168; _closeFlatButton.Text = "🗙"; _closeFlatButton.TextAlign = ContentAlignment.MiddleCenter; _closeFlatButton.Textcolor = Color.White; _closeFlatButton.TextFont = new Font("Microsoft Sans Serif", 18.32727f, FontStyle.Regular, GraphicsUnit.Point, Conversions.ToByte(0)); // // Label8 // Label8.BackColor = Color.FromArgb(Conversions.ToInteger(Conversions.ToByte(64)), Conversions.ToInteger(Conversions.ToByte(64)), Conversions.ToInteger(Conversions.ToByte(64))); Label8.Dock = DockStyle.Top; Label8.Font = new Font("Segoe UI", 11.78182f, FontStyle.Bold, GraphicsUnit.Point, Conversions.ToByte(0)); Label8.ForeColor = Color.White; Label8.Location = new Point(0, 0); Label8.Name = "Label8"; Label8.Size = new Size(1259, 41); Label8.TabIndex = 167; Label8.TextAlign = ContentAlignment.MiddleCenter; // // CrystalReportViewer1 // CrystalReportViewer1.ActiveViewIndex = 0; CrystalReportViewer1.BorderStyle = BorderStyle.FixedSingle; CrystalReportViewer1.Cursor = Cursors.Default; CrystalReportViewer1.Dock = DockStyle.Fill; CrystalReportViewer1.Location = new Point(0, 41); CrystalReportViewer1.Name = "CrystalReportViewer1"; CrystalReportViewer1.ReportSource = CrystalReportOuGate1; CrystalReportViewer1.Size = new Size(1259, 758); CrystalReportViewer1.TabIndex = 169; // // refreshInShapedButton // _refreshInShapedButton.AllowToggling = false; _refreshInShapedButton.Anchor = AnchorStyles.None; _refreshInShapedButton.AnimationSpeed = 200; _refreshInShapedButton.AutoGenerateColors = false; _refreshInShapedButton.BackColor = Color.Transparent; _refreshInShapedButton.BackColor1 = Color.WhiteSmoke; _refreshInShapedButton.BackgroundImage = (Image)resources.GetObject("refreshInShapedButton.BackgroundImage"); _refreshInShapedButton.BorderStyle = Bunifu.UI.WinForms.BunifuButton.BunifuButton.BorderStyles.Solid; _refreshInShapedButton.ButtonText = ""; _refreshInShapedButton.ButtonTextMarginLeft = 0; _refreshInShapedButton.ColorContrastOnClick = 45; _refreshInShapedButton.ColorContrastOnHover = 45; _refreshInShapedButton.Cursor = Cursors.Hand; BorderEdges1.BottomLeft = true; BorderEdges1.BottomRight = true; BorderEdges1.TopLeft = true; BorderEdges1.TopRight = true; _refreshInShapedButton.CustomizableEdges = BorderEdges1; _refreshInShapedButton.DialogResult = DialogResult.None; _refreshInShapedButton.DisabledBorderColor = Color.Empty; _refreshInShapedButton.DisabledFillColor = Color.FromArgb(Conversions.ToInteger(Conversions.ToByte(204)), Conversions.ToInteger(Conversions.ToByte(204)), Conversions.ToInteger(Conversions.ToByte(204))); _refreshInShapedButton.DisabledForecolor = Color.FromArgb(Conversions.ToInteger(Conversions.ToByte(168)), Conversions.ToInteger(Conversions.ToByte(160)), Conversions.ToInteger(Conversions.ToByte(168))); _refreshInShapedButton.FocusState = Bunifu.UI.WinForms.BunifuButton.BunifuButton.ButtonStates.Pressed; _refreshInShapedButton.Font = new Font("Segoe UI Semibold", 9.75f); _refreshInShapedButton.ForeColor = Color.WhiteSmoke; _refreshInShapedButton.IconLeftCursor = Cursors.Hand; _refreshInShapedButton.IconMarginLeft = 3; _refreshInShapedButton.IconPadding = 3; _refreshInShapedButton.IconRightCursor = Cursors.Hand; _refreshInShapedButton.IdleBorderColor = Color.WhiteSmoke; _refreshInShapedButton.IdleBorderRadius = 3; _refreshInShapedButton.IdleBorderThickness = 1; _refreshInShapedButton.IdleFillColor = Color.WhiteSmoke; _refreshInShapedButton.IdleIconLeftImage = My.Resources.Resources.refresh_pngrepo_com; _refreshInShapedButton.IdleIconRightImage = null; _refreshInShapedButton.IndicateFocus = false; _refreshInShapedButton.Location = new Point(1041, 46); _refreshInShapedButton.Name = "_refreshInShapedButton"; StateProperties1.BorderColor = Color.Teal; StateProperties1.BorderRadius = 3; StateProperties1.BorderStyle = Bunifu.UI.WinForms.BunifuButton.BunifuButton.BorderStyles.Solid; StateProperties1.BorderThickness = 1; StateProperties1.FillColor = Color.White; StateProperties1.ForeColor = Color.White; StateProperties1.IconLeftImage = null; StateProperties1.IconRightImage = null; _refreshInShapedButton.onHoverState = StateProperties1; StateProperties2.BorderColor = Color.White; StateProperties2.BorderRadius = 3; StateProperties2.BorderStyle = Bunifu.UI.WinForms.BunifuButton.BunifuButton.BorderStyles.Solid; StateProperties2.BorderThickness = 1; StateProperties2.FillColor = Color.White; StateProperties2.ForeColor = Color.White; StateProperties2.IconLeftImage = null; StateProperties2.IconRightImage = null; _refreshInShapedButton.OnPressedState = StateProperties2; _refreshInShapedButton.Size = new Size(40, 31); _refreshInShapedButton.TabIndex = 174; _refreshInShapedButton.TextAlign = ContentAlignment.MiddleCenter; _refreshInShapedButton.TextMarginLeft = 0; _refreshInShapedButton.UseDefaultRadiusAndThickness = true; // // toInBunifuDatePicker // toInBunifuDatePicker.Anchor = AnchorStyles.None; toInBunifuDatePicker.BorderRadius = 3; toInBunifuDatePicker.CalendarFont = new Font("Segoe UI", 11.78182f, FontStyle.Regular, GraphicsUnit.Point, Conversions.ToByte(0)); toInBunifuDatePicker.Color = Color.Teal; toInBunifuDatePicker.CustomFormat = "MMM dd, yyyy"; toInBunifuDatePicker.DateBorderThickness = Bunifu.UI.WinForms.BunifuDatePicker.BorderThickness.Thin; toInBunifuDatePicker.DateTextAlign = Bunifu.UI.WinForms.BunifuDatePicker.TextAlign.Left; toInBunifuDatePicker.DisabledColor = Color.Gray; toInBunifuDatePicker.DisplayWeekNumbers = false; toInBunifuDatePicker.DPHeight = 0; toInBunifuDatePicker.DropDownAlign = LeftRightAlignment.Right; toInBunifuDatePicker.FillDatePicker = false; toInBunifuDatePicker.Font = new Font("Segoe UI", 11.78182f, FontStyle.Regular, GraphicsUnit.Point, Conversions.ToByte(0)); toInBunifuDatePicker.ForeColor = Color.FromArgb(Conversions.ToInteger(Conversions.ToByte(64)), Conversions.ToInteger(Conversions.ToByte(64)), Conversions.ToInteger(Conversions.ToByte(64))); toInBunifuDatePicker.Format = DateTimePickerFormat.Custom; toInBunifuDatePicker.Icon = (Image)resources.GetObject("toInBunifuDatePicker.Icon"); toInBunifuDatePicker.IconColor = Color.Teal; toInBunifuDatePicker.IconLocation = Bunifu.UI.WinForms.BunifuDatePicker.Indicator.Right; toInBunifuDatePicker.Location = new Point(876, 47); toInBunifuDatePicker.MinimumSize = new Size(160, 28); toInBunifuDatePicker.Name = "toInBunifuDatePicker"; toInBunifuDatePicker.Size = new Size(160, 31); toInBunifuDatePicker.TabIndex = 173; // // fromInBunifuDatePicker // fromInBunifuDatePicker.Anchor = AnchorStyles.None; fromInBunifuDatePicker.BorderRadius = 3; fromInBunifuDatePicker.CalendarFont = new Font("Segoe UI", 11.78182f, FontStyle.Regular, GraphicsUnit.Point, Conversions.ToByte(0)); fromInBunifuDatePicker.Color = Color.Teal; fromInBunifuDatePicker.CustomFormat = "MMM dd, yyyy"; fromInBunifuDatePicker.DateBorderThickness = Bunifu.UI.WinForms.BunifuDatePicker.BorderThickness.Thin; fromInBunifuDatePicker.DateTextAlign = Bunifu.UI.WinForms.BunifuDatePicker.TextAlign.Left; fromInBunifuDatePicker.DisabledColor = Color.Gray; fromInBunifuDatePicker.DisplayWeekNumbers = false; fromInBunifuDatePicker.DPHeight = 0; fromInBunifuDatePicker.DropDownAlign = LeftRightAlignment.Right; fromInBunifuDatePicker.FillDatePicker = false; fromInBunifuDatePicker.Font = new Font("Segoe UI", 11.78182f, FontStyle.Regular, GraphicsUnit.Point, Conversions.ToByte(0)); fromInBunifuDatePicker.ForeColor = Color.FromArgb(Conversions.ToInteger(Conversions.ToByte(64)), Conversions.ToInteger(Conversions.ToByte(64)), Conversions.ToInteger(Conversions.ToByte(64))); fromInBunifuDatePicker.Format = DateTimePickerFormat.Custom; fromInBunifuDatePicker.Icon = (Image)resources.GetObject("fromInBunifuDatePicker.Icon"); fromInBunifuDatePicker.IconColor = Color.Teal; fromInBunifuDatePicker.IconLocation = Bunifu.UI.WinForms.BunifuDatePicker.Indicator.Right; fromInBunifuDatePicker.Location = new Point(638, 46); fromInBunifuDatePicker.MinimumSize = new Size(160, 28); fromInBunifuDatePicker.Name = "fromInBunifuDatePicker"; fromInBunifuDatePicker.Size = new Size(160, 31); fromInBunifuDatePicker.TabIndex = 172; // // Label1 // Label1.Anchor = AnchorStyles.None; Label1.BackColor = Color.WhiteSmoke; Label1.Font = new Font("Segoe UI", 11.78182f, FontStyle.Regular, GraphicsUnit.Point, Conversions.ToByte(0)); Label1.ForeColor = Color.FromArgb(Conversions.ToInteger(Conversions.ToByte(64)), Conversions.ToInteger(Conversions.ToByte(64)), Conversions.ToInteger(Conversions.ToByte(64))); Label1.Location = new Point(834, 51); Label1.Margin = new Padding(0); Label1.Name = "Label1"; Label1.Size = new Size(39, 27); Label1.TabIndex = 171; Label1.Text = "To:"; Label1.TextAlign = ContentAlignment.MiddleRight; // // Label2 // Label2.Anchor = AnchorStyles.None; Label2.BackColor = Color.WhiteSmoke; Label2.Font = new Font("Segoe UI", 11.78182f, FontStyle.Regular, GraphicsUnit.Point, Conversions.ToByte(0)); Label2.ForeColor = Color.FromArgb(Conversions.ToInteger(Conversions.ToByte(64)), Conversions.ToInteger(Conversions.ToByte(64)), Conversions.ToInteger(Conversions.ToByte(64))); Label2.Location = new Point(570, 51); Label2.Margin = new Padding(0); Label2.Name = "Label2"; Label2.Size = new Size(65, 26); Label2.TabIndex = 170; Label2.Text = "From:"; Label2.TextAlign = ContentAlignment.MiddleRight; // // FrmOutGateReport // AutoScaleDimensions = new SizeF(6.0f, 13.0f); AutoScaleMode = AutoScaleMode.Font; BackColor = Color.White; ClientSize = new Size(1259, 799); Controls.Add(_refreshInShapedButton); Controls.Add(toInBunifuDatePicker); Controls.Add(fromInBunifuDatePicker); Controls.Add(Label1); Controls.Add(Label2); Controls.Add(CrystalReportViewer1); Controls.Add(_closeFlatButton); Controls.Add(Label8); FormBorderStyle = FormBorderStyle.None; Name = "FrmOutGateReport"; Text = "FrmOutGateReport"; Load += new EventHandler(FrmOutGateReport_Load); ResumeLayout(false); }