📄 bxsw.cs
字号:
using System;using System.Collections;using System.ComponentModel;using System.Drawing;using System.Windows.Forms;using System.Data;using System.Data.SqlClient;using DevExpress.XtraReports.UI;namespace SKXT.StatQuery{ public class BXSW : SKXT.MdiQueryBase {
private DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn RI;
private DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn YIYUE;
private DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn ERYUE;
private DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn SANYUE;
private DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn SIYUE;
private DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn WUYUE;
private DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn LIUYUE;
private DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn QIYUE;
private DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn BAYUE;
private DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn JIUYUE;
private DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn SHIYUE;
private DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn SHYIYUE;
private DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn SHERYUE;
private DevExpress.XtraGrid.Views.BandedGrid.GridBand gridBand2;
private DevExpress.XtraGrid.Views.BandedGrid.GridBand gridBand3;
private DevExpress.XtraGrid.Views.BandedGrid.GridBand gridBand4;
private DevExpress.XtraGrid.Views.BandedGrid.GridBand gridBand5;
private DevExpress.XtraGrid.Views.BandedGrid.GridBand gridBand6;
private DevExpress.XtraGrid.Views.BandedGrid.GridBand gridBand7;
private DevExpress.XtraGrid.Views.BandedGrid.GridBand gridBand8;
private DevExpress.XtraGrid.Views.BandedGrid.GridBand gridBand9;
private DevExpress.XtraGrid.Views.BandedGrid.GridBand gridBand10;
private DevExpress.XtraGrid.Views.BandedGrid.GridBand gridBand11;
private DevExpress.XtraGrid.Views.BandedGrid.GridBand gridBand12;
private DevExpress.XtraGrid.Views.BandedGrid.GridBand gridBand13;
private DevExpress.XtraGrid.Views.BandedGrid.GridBand gridBand14; private System.ComponentModel.IContainer components = null; public BXSW() { // 该调用是 Windows 窗体设计器所必需的。 InitializeComponent(); // TODO: 在 InitializeComponent 调用后添加任何初始化 } /// <summary> /// 清理所有正在使用的资源。 /// </summary> protected override void Dispose( bool disposing ) { if( disposing ) { if (components != null) { components.Dispose(); } } base.Dispose( disposing ); } #region 设计器生成的代码 /// <summary> /// 设计器支持所需的方法 - 不要使用代码编辑器修改 /// 此方法的内容。 /// </summary> private void InitializeComponent() { System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(BXSW));
this.RI = new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn();
this.YIYUE = new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn();
this.ERYUE = new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn();
this.SANYUE = new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn();
this.SIYUE = new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn();
this.WUYUE = new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn();
this.LIUYUE = new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn();
this.QIYUE = new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn();
this.BAYUE = new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn();
this.JIUYUE = new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn();
this.SHIYUE = new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn();
this.SHYIYUE = new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn();
this.SHERYUE = new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn();
this.gridBand2 = new DevExpress.XtraGrid.Views.BandedGrid.GridBand();
this.gridBand3 = new DevExpress.XtraGrid.Views.BandedGrid.GridBand();
this.gridBand4 = new DevExpress.XtraGrid.Views.BandedGrid.GridBand();
this.gridBand5 = new DevExpress.XtraGrid.Views.BandedGrid.GridBand();
this.gridBand6 = new DevExpress.XtraGrid.Views.BandedGrid.GridBand();
this.gridBand7 = new DevExpress.XtraGrid.Views.BandedGrid.GridBand();
this.gridBand8 = new DevExpress.XtraGrid.Views.BandedGrid.GridBand();
this.gridBand9 = new DevExpress.XtraGrid.Views.BandedGrid.GridBand();
this.gridBand10 = new DevExpress.XtraGrid.Views.BandedGrid.GridBand();
this.gridBand11 = new DevExpress.XtraGrid.Views.BandedGrid.GridBand();
this.gridBand12 = new DevExpress.XtraGrid.Views.BandedGrid.GridBand();
this.gridBand13 = new DevExpress.XtraGrid.Views.BandedGrid.GridBand();
this.gridBand14 = new DevExpress.XtraGrid.Views.BandedGrid.GridBand();
((System.ComponentModel.ISupportInitialize)(this.barManager1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.barAndDockingController1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.navBarControl1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gridControl1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.bandedGridView1)).BeginInit();
//
// ImageList_Small
//
this.ImageList_Small.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("ImageList_Small.ImageStream")));
//
// bar1
//
this.bar1.Appearance.BackColor = System.Drawing.Color.CornflowerBlue;
this.bar1.Appearance.BackColor2 = System.Drawing.Color.LightSteelBlue;
this.bar1.Appearance.Options.UseBackColor = true;
this.bar1.OptionsBar.AllowQuickCustomization = false;
//
// barLargeButtonItem1
//
this.barLargeButtonItem1.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barLargeButtonItem1_ItemClick);
//
// barAndDockingController1
//
this.barAndDockingController1.PropertiesBar.AllowLinkLighting = false;
//
// navBarControl1
//
this.navBarControl1.Location = new System.Drawing.Point(0, 36);
this.navBarControl1.Name = "navBarControl1";
this.navBarControl1.Size = new System.Drawing.Size(184, 521);
this.navBarControl1.Styles.AddReplace("GroupBackground", new DevExpress.Utils.ViewStyleEx("GroupBackground", "NavBarControl", "", true, false, false, DevExpress.Utils.HorzAlignment.Near, DevExpress.Utils.VertAlignment.Center, null, System.Drawing.Color.FromArgb(((System.Byte)(214)), ((System.Byte)(223)), ((System.Byte)(247))), System.Drawing.Color.Black, System.Drawing.Color.Empty, System.Drawing.Drawing2D.LinearGradientMode.Horizontal));
this.navBarControl1.Styles.AddReplace("GroupHeader", new DevExpress.Utils.ViewStyleEx("GroupHeader", "NavBarControl", new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold), "", true, false, false, DevExpress.Utils.HorzAlignment.Near, DevExpress.Utils.VertAlignment.Center, null, System.Drawing.Color.Empty, System.Drawing.Color.RoyalBlue, System.Drawing.Color.Empty, System.Drawing.Drawing2D.LinearGradientMode.Horizontal));
this.navBarControl1.Styles.AddReplace("Item", new DevExpress.Utils.ViewStyleEx("Item", "NavBarControl", "", true, true, false, DevExpress.Utils.HorzAlignment.Center, DevExpress.Utils.VertAlignment.Center, null, System.Drawing.Color.White, System.Drawing.Color.RoyalBlue, System.Drawing.Color.Empty, System.Drawing.Drawing2D.LinearGradientMode.Horizontal));
this.navBarControl1.Styles.AddReplace("Background", new DevExpress.Utils.ViewStyleEx("Background", "NavBarControl", "", true, false, false, DevExpress.Utils.HorzAlignment.Center, DevExpress.Utils.VertAlignment.Center, null, System.Drawing.Color.FromArgb(((System.Byte)(99)), ((System.Byte)(117)), ((System.Byte)(214))), System.Drawing.Color.Silver, System.Drawing.Color.FromArgb(((System.Byte)(122)), ((System.Byte)(160)), ((System.Byte)(230))), System.Drawing.Drawing2D.LinearGradientMode.Horizontal));
//
// gridControl1
//
//
// gridControl1.EmbeddedNavigator
//
this.gridControl1.EmbeddedNavigator.Name = "";
this.gridControl1.Location = new System.Drawing.Point(184, 96);
this.gridControl1.Name = "gridControl1";
this.gridControl1.Size = new System.Drawing.Size(752, 461);
this.gridControl1.Styles.AddReplace("FooterPanel", new DevExpress.Utils.ViewStyleEx("FooterPanel", "Grid", "", true, false, false, DevExpress.Utils.HorzAlignment.Default, DevExpress.Utils.VertAlignment.Top, null, System.Drawing.SystemColors.Control, System.Drawing.SystemColors.ControlText, System.Drawing.Color.Empty, System.Drawing.Drawing2D.LinearGradientMode.Horizontal));
this.gridControl1.Styles.AddReplace("Style2", new DevExpress.Utils.ViewStyleEx("Style2", "", "", true, false, false, DevExpress.Utils.HorzAlignment.Center, DevExpress.Utils.VertAlignment.Center, null, System.Drawing.SystemColors.Window, System.Drawing.SystemColors.WindowText, System.Drawing.Color.Empty, System.Drawing.Drawing2D.LinearGradientMode.Horizontal));
this.gridControl1.Styles.AddReplace("Style1", new DevExpress.Utils.ViewStyleEx("Style1", "", "", true, true, false, DevExpress.Utils.HorzAlignment.Center, DevExpress.Utils.VertAlignment.Center, null, System.Drawing.SystemColors.Control, System.Drawing.SystemColors.WindowText, System.Drawing.Color.Empty, System.Drawing.Drawing2D.LinearGradientMode.Horizontal));
//
// ImageList1
//
this.ImageList1.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("ImageList1.ImageStream")));
//
// bandedGridView1
//
this.bandedGridView1.Bands.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.GridBand[] {
this.gridBand2,
this.gridBand3,
this.gridBand4,
this.gridBand5,
this.gridBand6,
this.gridBand7,
this.gridBand8,
this.gridBand9,
this.gridBand10,
this.gridBand11,
this.gridBand12,
this.gridBand13,
this.gridBand14});
this.bandedGridView1.Columns.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn[] {
this.RI,
this.YIYUE,
this.ERYUE,
this.SANYUE,
this.SIYUE,
this.WUYUE,
this.LIUYUE,
this.QIYUE,
this.BAYUE,
this.JIUYUE,
this.SHIYUE,
this.SHYIYUE,
this.SHERYUE});
this.bandedGridView1.DetailTabHeaderLocation = DevExpress.XtraTab.TabHeaderLocation.Bottom;
this.bandedGridView1.OptionsView.ShowColumnHeaders = false;
this.bandedGridView1.OptionsView.ShowFooter = true;
this.bandedGridView1.OptionsView.ShowGroupedColumns = false;
this.bandedGridView1.OptionsView.ShowGroupPanel = false;
this.bandedGridView1.PreviewFieldName = "梅山水库";
this.bandedGridView1.VertScrollTipFieldName = "梅山水库";
this.bandedGridView1.ViewCaption = "梅山水库";
//
// label_title
//
this.label_title.BackColor = System.Drawing.Color.White;
this.label_title.Location = new System.Drawing.Point(184, 36);
this.label_title.Name = "label_title";
//
// RI
//
this.RI.Caption = "日";
this.RI.FieldName = "RI";
this.RI.Name = "RI";
this.RI.Options = ((DevExpress.XtraGrid.Columns.ColumnOptions)(((((((((DevExpress.XtraGrid.Columns.ColumnOptions.CanFiltered | DevExpress.XtraGrid.Columns.ColumnOptions.CanMoved)
| DevExpress.XtraGrid.Columns.ColumnOptions.CanGrouped)
| DevExpress.XtraGrid.Columns.ColumnOptions.CanResized)
| DevExpress.XtraGrid.Columns.ColumnOptions.CanSorted)
| DevExpress.XtraGrid.Columns.ColumnOptions.ReadOnly)
| DevExpress.XtraGrid.Columns.ColumnOptions.CanFocused)
| DevExpress.XtraGrid.Columns.ColumnOptions.ShowInCustomizationForm)
| DevExpress.XtraGrid.Columns.ColumnOptions.NonEditable)));
this.RI.StyleName = "Style2";
this.RI.SummaryItem.DisplayFormat = "本年度";
this.RI.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom;
this.RI.Visible = true;
//
// YIYUE
//
this.YIYUE.Caption = "一月";
this.YIYUE.FieldName = "YIYUE";
this.YIYUE.Name = "YIYUE";
this.YIYUE.Options = ((DevExpress.XtraGrid.Columns.ColumnOptions)(((((((((DevExpress.XtraGrid.Columns.ColumnOptions.CanFiltered | DevExpress.XtraGrid.Columns.ColumnOptions.CanMoved)
| DevExpress.XtraGrid.Columns.ColumnOptions.CanGrouped)
| DevExpress.XtraGrid.Columns.ColumnOptions.CanResized)
| DevExpress.XtraGrid.Columns.ColumnOptions.CanSorted)
| DevExpress.XtraGrid.Columns.ColumnOptions.ReadOnly)
| DevExpress.XtraGrid.Columns.ColumnOptions.CanFocused)
| DevExpress.XtraGrid.Columns.ColumnOptions.ShowInCustomizationForm)
| DevExpress.XtraGrid.Columns.ColumnOptions.NonEditable)));
this.YIYUE.SummaryItem.DisplayFormat = "最大值";
this.YIYUE.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom;
this.YIYUE.Visible = true;
//
// ERYUE
//
this.ERYUE.Caption = "二月";
this.ERYUE.FieldName = "ERYUE";
this.ERYUE.Name = "ERYUE";
this.ERYUE.Options = ((DevExpress.XtraGrid.Columns.ColumnOptions)(((((((((DevExpress.XtraGrid.Columns.ColumnOptions.CanFiltered | DevExpress.XtraGrid.Columns.ColumnOptions.CanMoved)
| DevExpress.XtraGrid.Columns.ColumnOptions.CanGrouped)
| DevExpress.XtraGrid.Columns.ColumnOptions.CanResized)
| DevExpress.XtraGrid.Columns.ColumnOptions.CanSorted)
| DevExpress.XtraGrid.Columns.ColumnOptions.ReadOnly)
| DevExpress.XtraGrid.Columns.ColumnOptions.CanFocused)
| DevExpress.XtraGrid.Columns.ColumnOptions.ShowInCustomizationForm)
| DevExpress.XtraGrid.Columns.ColumnOptions.NonEditable)));
this.ERYUE.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom;
this.ERYUE.Visible = true;
//
// SANYUE
//
this.SANYUE.Caption = "三月";
this.SANYUE.FieldName = "SANYUE";
this.SANYUE.Name = "SANYUE";
this.SANYUE.Options = ((DevExpress.XtraGrid.Columns.ColumnOptions)(((((((((DevExpress.XtraGrid.Columns.ColumnOptions.CanFiltered | DevExpress.XtraGrid.Columns.ColumnOptions.CanMoved)
| DevExpress.XtraGrid.Columns.ColumnOptions.CanGrouped)
| DevExpress.XtraGrid.Columns.ColumnOptions.CanResized)
| DevExpress.XtraGrid.Columns.ColumnOptions.CanSorted)
| DevExpress.XtraGrid.Columns.ColumnOptions.ReadOnly)
| DevExpress.XtraGrid.Columns.ColumnOptions.CanFocused)
| DevExpress.XtraGrid.Columns.ColumnOptions.ShowInCustomizationForm)
| DevExpress.XtraGrid.Columns.ColumnOptions.NonEditable)));
this.SANYUE.SummaryItem.DisplayFormat = "日 期";
this.SANYUE.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom;
this.SANYUE.Visible = true;
//
// SIYUE
//
this.SIYUE.Caption = "四月";
this.SIYUE.FieldName = "SIYUE";
this.SIYUE.Name = "SIYUE";
this.SIYUE.Options = ((DevExpress.XtraGrid.Columns.ColumnOptions)(((((((((DevExpress.XtraGrid.Columns.ColumnOptions.CanFiltered | DevExpress.XtraGrid.Columns.ColumnOptions.CanMoved)
| DevExpress.XtraGrid.Columns.ColumnOptions.CanGrouped)
| DevExpress.XtraGrid.Columns.ColumnOptions.CanResized)
| DevExpress.XtraGrid.Columns.ColumnOptions.CanSorted)
| DevExpress.XtraGrid.Columns.ColumnOptions.ReadOnly)
| DevExpress.XtraGrid.Columns.ColumnOptions.CanFocused)
| DevExpress.XtraGrid.Columns.ColumnOptions.ShowInCustomizationForm)
| DevExpress.XtraGrid.Columns.ColumnOptions.NonEditable)));
this.SIYUE.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom;
this.SIYUE.Visible = true;
//
// WUYUE
//
this.WUYUE.Caption = "五月";
this.WUYUE.FieldName = "WUYUE";
this.WUYUE.Name = "WUYUE";
this.WUYUE.Options = ((DevExpress.XtraGrid.Columns.ColumnOptions)(((((((((DevExpress.XtraGrid.Columns.ColumnOptions.CanFiltered | DevExpress.XtraGrid.Columns.ColumnOptions.CanMoved)
| DevExpress.XtraGrid.Columns.ColumnOptions.CanGrouped)
| DevExpress.XtraGrid.Columns.ColumnOptions.CanResized)
| DevExpress.XtraGrid.Columns.ColumnOptions.CanSorted)
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -