页面汇总基础代码

子页面被调用代码        
    private void FormPMOMMACS10_EF_START_FORM_BY_EF(object sender, EF.EF_Args i_args) { EF.Utility.SetGridColumn(new EF.EFDevGrid[] { efDevGrid1 }, new string[] { "PMOMMACS10_INQ" }, "MA1RM"); Grid_Style.efDevGrid_sTyle(efDevGrid1, gridView1); gridView1.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CellSelect; gridView1.OptionsSelection.MultiSelect = true; this.efDevGrid1.LoadLayout(EF.EFDevGrid.ConfigEnum.Default); this.gridView1.Columns["ORDER_NO"].Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Left; this.gridView1.Columns["DELIVERY_DATE_IN"].Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Left; sqlwhere = EF.EF_Args.common_parameter_1;//WHERE条件 varieties_code = EF.EF_Args.common_parameter_2;//品种分类 Query();//调用查询方法 //显示下方汇总行 gridView1.OptionsView.ShowFooter = true; this.gridView1.Appearance.FooterPanel.ForeColor = System.Drawing.Color.Red;//汇总字体为红色 this.gridView1.Appearance.FooterPanel.Options.UseForeColor = true; this.gridView1.Columns["NOM_ROLL_WIDTH"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom; //轧宽求和 this.gridView1.Columns["ORDER_WT"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom; //求和 this.gridView1.Columns["LACK_WT"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom; //求和 this.gridView1.Columns["STOCK_WT4"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom; //求和 this.gridView1.Columns["STOCK_WT"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom; //求和 this.gridView1.Columns["STOCK_WT1"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom; //求和 this.gridView1.Columns["STOCK_WT2"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom; //求和 this.gridView1.Columns["STOCK_WT3"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom; //求和 this.gridView1.Columns["LACK_WT1"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom; //求和 this.gridView1.Columns["LACK_WT2"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom; //求和 } #endregion

后面代码

 #region 列汇总

        private void gridView1_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
        {
            this.gridView1.OptionsView.ShowFooter = true;
            this.gridView1.Columns["NOM_ROLL_WIDTH"].SummaryItem.SetSummary(DevExpress.Data.SummaryItemType.Sum, "{0:N0}");
            this.gridView1.Columns["ORDER_WT"].SummaryItem.SetSummary(DevExpress.Data.SummaryItemType.Sum, "{0:N0}");
            this.gridView1.Columns["LACK_WT"].SummaryItem.SetSummary(DevExpress.Data.SummaryItemType.Sum, "{0:N0}");
            this.gridView1.Columns["STOCK_WT4"].SummaryItem.SetSummary(DevExpress.Data.SummaryItemType.Sum, "{0:N0}");
            this.gridView1.Columns["STOCK_WT"].SummaryItem.SetSummary(DevExpress.Data.SummaryItemType.Sum, "{0:N0}");
            this.gridView1.Columns["STOCK_WT1"].SummaryItem.SetSummary(DevExpress.Data.SummaryItemType.Sum, "{0:N0}");
            this.gridView1.Columns["STOCK_WT2"].SummaryItem.SetSummary(DevExpress.Data.SummaryItemType.Sum, "{0:N0}");
            this.gridView1.Columns["STOCK_WT3"].SummaryItem.SetSummary(DevExpress.Data.SummaryItemType.Sum, "{0:N0}");
            this.gridView1.Columns["LACK_WT1"].SummaryItem.SetSummary(DevExpress.Data.SummaryItemType.Sum, "{0:N0}");
            this.gridView1.Columns["LACK_WT2"].SummaryItem.SetSummary(DevExpress.Data.SummaryItemType.Sum, "{0:N0}");
        }

        #endregion

 

posted @ 2021-03-01 09:31  gitee1412  阅读(137)  评论(0)    收藏  举报