private void InitGrid() { gridViewDetail._SetPermissionElement(BtnPrint, BtnExport); gridViewDetail.OptionsView.AllowHtmlDrawHeaders = true; gridViewDetail.OptionsBehavior.CopyToClipboardWithColumnHeaders = false; gridViewDetail.IndicatorWidth = 50; // gridViewDetail.OptionsView.AllowCellMerge = false; // ColTenCT.ShowButtonMode = DevExpress.XtraGrid.Views.Base.ShowButtonModeEnum.ShowAlways; _colDong = InitGrid(gridControlDetail, gridViewDetail, IsAdd); _colDong.Fixed = FixedStyle.Right; foreach (GridColumn c in gridViewDetail.Columns) { c.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False; c.AppearanceHeader.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap; c.AppearanceHeader.Options.UseTextOptions = true; c.MaxWidth = 0; c.MinWidth = 0; } ColTenCT.MinWidth = 200; ColTenCT.Width = 200; ColGioPhat.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True; AppCtrl.InitCotTime(ColGioPhat, KE_HOACH_LPS_CT.GIO_PHAT_SONG); CotCheckEdit(ColChuNhat, KE_HOACH_LPS_CT.CN); CotCheckEdit(ColThu2, KE_HOACH_LPS_CT.T2); CotCheckEdit(ColThu3, KE_HOACH_LPS_CT.T3); CotCheckEdit(ColThu4, KE_HOACH_LPS_CT.T4); CotCheckEdit(ColThu5, KE_HOACH_LPS_CT.T5); CotCheckEdit(ColThu6, KE_HOACH_LPS_CT.T6); CotCheckEdit(ColThu7, KE_HOACH_LPS_CT.T7); HelpGridColumn.CotTextLeft(ColCategory, KE_HOACH_LPS_CT.CATEGORY); DMTietMuc.InitCot(ColTietMuc, KE_HOACH_LPS_CT.TIET_MUC, true); HelpGridColumn.CotTextLeft(ColTenGoc, KE_HOACH_LPS_CT.TEN_GOC); DMNuocSanXuat.InitCotMulti(ColNuocSX, KE_HOACH_LPS_CT.NUOC_SAN_XUAT, true); HelpGridColumn.CotCalcEditDec(ColNamSX, KE_HOACH_LPS_CT.NAM_SAN_XUAT, 0, true, false).EditMask = "d"; DMPostMaster.InitCot(ColPostMaster, KE_HOACH_LPS_CT.POST_MASTER_ID); HelpGridColumn.CotCalcEditDec(ColTongTap, KE_HOACH_LPS_CT.TONG_TAP_CT, 0, 1, true, false); HelpGridColumn.CotCalcEditDec(ColTongTapPhat, KE_HOACH_LPS_CT.TONG_TAP, 0, 1, true, false); AppCtrl.InitCotTimecode(ColThoiLuong, KE_HOACH_LPS_CT.THOI_LUONG, KE_HOACH_LPS_CT.THOI_LUONG_NUM); HelpGridColumn.CotCalcEditDec(ColTapSoNgay, KE_HOACH_LPS_CT.SO_TAP_NGAY, 0, 1, false, false); HelpGridColumn.CotDateEdit(ColNgayBatDau, KE_HOACH_LPS_CT.NGAY_BAT_DAU, false); HelpGridColumn.CotDateEdit(ColNgayKetThuc, KE_HOACH_LPS_CT.NGAY_PHAT_CUOI, false); HelpGridColumn.CotTextLeft(ColGhiChu, KE_HOACH_LPS_CT.GHI_CHU); HelpGridColumn.CotDateEdit(ColExpiredate, KE_HOACH_LPS_CT.EXPIRE_DATE, false); // HelpGridColumn.CotMemoExEdit(ColDSNgayPhat, KE_HOACH_LPS_CT.DS_NGAY_PHAT); CotCheckEdit(ColPhatLai, KE_HOACH_LPS_CT.PHAT_LAI); HelpGridColumn.CotTextLeft(ColMaCT, CHUONG_TRINH.MA_CT); HelpGridColumn.CotReadOnlyDate(ColAWB, CHUONG_TRINH.NGAY_AWB); DMDaoDien.InitCotMulti(ColDaoDien, CHUONG_TRINH.DAO_DIEN, true); DMDienVien.InitCotMulti(ColDienVien, CHUONG_TRINH.DIEN_VIEN, true); DMDoiTuongKG.InitCotMulti(ColDTKhanGia, CHUONG_TRINH.DOI_TUONG_KHAN_GIA, true); HelpGridColumn.CotCalcEditDec(ColRating, CHUONG_TRINH.RATING, 0, true); DMTuKhoa.InitCotMulti(ColTuKhoa, CHUONG_TRINH.TU_KHOA, true); HelpGridColumn.CotTextLeft(ColKHPL, CHUONG_TRINH.KY_HIEU_PHAN_LOAI); HelpGridColumn.CotTextLeft(ColKHXK, CHUONG_TRINH.KY_HIEU_XEP_KHO_ND); HelpGridColumn.CotMemoExEdit(ColGhiChuCT, "GHI_CHU_CT"); DMRanking.InitCot(ColRanking, CHUONG_TRINH.RANKING, true); CotCheckEdit(ColScript, CHUONG_TRINH.SCRIPT); CotCheckEdit(ColPhoTo, CHUONG_TRINH.PHOTOS); CotCheckEdit(ColTrailerGoc, CHUONG_TRINH.TRAILER_GOC); DMBanQuyenThuoc.InitCot(ColBanQuyenThuoc, CHUONG_TRINH.BAN_QUYEN_THUOC, true); DMDaiTruyenHinh.InitCotMulti(ColKenhHanCheBan, CHUONG_TRINH.KENH_HAN_CHE_BAN, true); HelpGridColumn.CotTextLeft(ColCodeCT, CHUONG_TRINH.CODE_CT); HelpGridColumn.CotTextLeft(ColCLass, CHUONG_TRINH.CLASS); HelpGridColumn.CotTextLeft(ColNguonTrading, CHUONG_TRINH.NGUON_TRADING); HelpGridColumn.CotMemoExEdit(ColNoteBQ, CHUONG_TRINH.NOTE_BQ); HelpGridColumn.CotCalcEditDec(ColRunThu, CHUONG_TRINH.RUN_THU, 0, true); DMDaiTruyenHinh.InitCotMulti(ColChanelRight, CHUONG_TRINH.CHANLE_RIGHT, true); HelpGridColumn.CotTextLeft(ColPeriod, CHUONG_TRINH.PERIOD); CotCheckEdit(ColIsTrongKho, CHUONG_TRINH.IS_TRONG_KHO); CotCheckEdit(ColThanhLy, CHUONG_TRINH.IS_THANH_LY); HelpGridColumn.CotMemoExEdit(ColMuaKem, CHUONG_TRINH.MUA_KEM); HelpGridColumn.CotCalcEditDec(ColReleaseDay, CHUONG_TRINH.RELEASE_DAYS, 0, true); HelpGridColumn.CotMemoExEdit(ColTomTat, CHUONG_TRINH.TOM_TAT); DMTinhTrangBang.InitCot(ColTinhTrangBang, CHUONG_TRINH.TINH_TRANG_BANG, true); HelpGridColumn.CotCalcEditDec(ColTongSoRun, CHUONG_TRINH.TONG_SO_RUN, 0, true); CotCheckEdit(ColPopUp, CHUONG_TRINH_POST_MASTER.POP_UP); DMLoaiBang.InitCot(ColLoaiLuuTru, CHUONG_TRINH_POST_MASTER.LOAI_LUU_TRU, true); HelpGridColumn.CotCalcEditDec(ColKe, CHUONG_TRINH_POST_MASTER.KE, 0, true); HelpGridColumn.CotCalcEditDec(ColNgan, CHUONG_TRINH_POST_MASTER.NGAN, 0, true); HelpGridColumn.CotCalcEditDec(ColTang, CHUONG_TRINH_POST_MASTER.TANG, 0, true); HelpGridColumn.CotReadOnlyDate(ColNgayNhapKho, CHUONG_TRINH_POST_MASTER.NGAY_NHAP_KHO); CotCheckEdit(ColTrailerPost, CHUONG_TRINH_POST_MASTER.TRAILER_POST); HelpGridColumn.CotCalcEditDec(ColTongBang, CHUONG_TRINH_POST_MASTER.TONG_BANG, 0, true); CotCheckEdit(ColMoiThiTruong, CHUONG_TRINH.MOI_THI_TRUONG); HelpGridColumn.CotTextLeft(ColPhanLoaiDrama, CHUONG_TRINH.PHAN_LOAI_DRAMA); HelpGridColumn.CotDateEdit(ColReleaseDate, CHUONG_TRINH.RELEASE_DATE); HelpGridColumn.CotSpinEditInt(ColReleaseRun, CHUONG_TRINH.RELEASE_RUN, true); HelpGridColumn.CotTextLeft(ColReleaseRule, CHUONG_TRINH.RELEASE_RULE); HelpGridColumn.CotTextLeft(ColDonViHauKy, CHUONG_TRINH.DON_VI_HAU_KY); DMDonViCungCap.InitCot(ColDonViCungCap, CHUONG_TRINH.DON_VI_CUNG_CAP, true); dtLoaiGhiChu = DMLoaiGhiChu.GetUsingLoaiGhiChu(); if (dtLoaiGhiChu != null) { foreach (DataRow row in dtLoaiGhiChu.Rows) { var id = row["ID"].ToString(); var alias = "ctlgc" + id; sqlColumn += "," + alias + ".noi_dung NOI_DUNG_GC" + id; sqlLeftJoin += " left join chuong_trinh_ghi_chu " + alias + " on KHLPSCT.ct_id=" + alias + ".ct_id and " + alias + ".loai_ghi_chu=" + id + Environment.NewLine; var colGhiChuKhac = gridViewDetail.Columns.Add(); colGhiChuKhac.Name = "Col_CT_GhiChuKhac" + id; colGhiChuKhac.Caption = row["NAME"].ToString(); colGhiChuKhac.OptionsColumn.ReadOnly = true; colGhiChuKhac.OptionsColumn.AllowMerge = DefaultBoolean.False; colGhiChuKhac.AppearanceHeader.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap; colGhiChuKhac.AppearanceHeader.Options.UseTextOptions = true; colGhiChuKhac.MaxWidth = 0; colGhiChuKhac.MinWidth = 0; colGhiChuKhac.Visible = true; HelpGridColumn.CotTextLeft(colGhiChuKhac, "NOI_DUNG_GC" + id); } } _repCT = InitCotTenCtrinh(ColTenCT, KE_HOACH_LPS_CT.CTPM_ID); ColPostMaster.Visible = false; ColTongTap.Visible = true; gridViewDetail.OptionsCustomization.AllowColumnMoving = true; gridViewDetail.OptionsView.NewItemRowPosition = NewItemRowPosition.Top; gridViewDetail.DefaultNewRow += newRow; _repCT.ButtonClick += repCT_ButtonClick; //this.gridViewDetail.GroupSummary.AddRange(new DevExpress.XtraGrid.GridSummaryItem[] { //new DevExpress.XtraGrid.GridGroupSummaryItem(DevExpress.Data.SummaryItemType.Sum,KE_HOACH_LPS_CT.TONG_TAP, null, "(Tổng tập phát: {0})")}); // gridViewDetail.OptionsPrint. gridViewDetail.OptionsBehavior.Editable = false; // gridViewDetail.GroupSummary.Clear(); gridViewDetail.CustomSummaryCalculate += gridViewDetail_CustomSummaryCalculate; summarySoTapCan = new GridGroupSummaryItem(SummaryItemType.Custom, KE_HOACH_LPS_CT.SO_TAP_NGAY, null, "(Số tập cần: {0}") {Tag = 1}; summarySoTapPhat = new GridGroupSummaryItem(SummaryItemType.Custom, KE_HOACH_LPS_CT.TONG_TAP, null, " Số tập phát: {0}") {Tag = 2}; summarySoTapThieu = new GridGroupSummaryItem(SummaryItemType.Custom, KE_HOACH_LPS_CT.TONG_TAP_CT, null, " Số tập thiếu: {0})") { Tag = 3 }; gridViewDetail.GroupSummary.Add(summarySoTapCan); gridViewDetail.GroupSummary.Add(summarySoTapPhat); gridViewDetail.GroupSummary.Add(summarySoTapThieu); }
public static void InitGridView(DevExpress.XtraGrid.GridControl _GridControl, Boolean CreatSUM) { //BandedGridView DevExpress.XtraGrid.Views.BandedGrid.BandedGridView _BandedGridView = new DevExpress.XtraGrid.Views.BandedGrid.BandedGridView(); Boolean isBandedGridView = true; try { _BandedGridView = _GridControl.MainView as DevExpress.XtraGrid.Views.BandedGrid.BandedGridView; } catch { isBandedGridView = false; } if (isBandedGridView) { if (!Object.Equals(_BandedGridView, null)) { SetTheme(_BandedGridView); if (CreatSUM) { _BandedGridView.GroupSummary.Clear(); for (int i = 0; i < _BandedGridView.Columns.Count; i++) { if (_BandedGridView.Columns[i].Visible && _BandedGridView.Columns[i].GroupIndex < 0) { if (!Object.Equals(_BandedGridView.GetRowCellValue(0, _BandedGridView.Columns[i]), null)) { if (SHARED.Libraries.StringHelper.IsNumber(_BandedGridView.GetRowCellValue(0, _BandedGridView.Columns[i]).ToString())) { _BandedGridView.Columns[i].SummaryItem.Collection.Clear(); _BandedGridView.Columns[i].Summary.Add(DevExpress.Data.SummaryItemType.Sum, _BandedGridView.Columns[i].FieldName, "{0}"); GridGroupSummaryItem itemTop = new GridGroupSummaryItem(); itemTop.FieldName = _BandedGridView.Columns[i].FieldName; itemTop.SummaryType = DevExpress.Data.SummaryItemType.Sum; itemTop.DisplayFormat = "(" + _BandedGridView.Columns[i].Caption + ": {0})"; _BandedGridView.GroupSummary.Add(itemTop); GridGroupSummaryItem itemDown = new GridGroupSummaryItem(); itemDown.FieldName = _BandedGridView.Columns[i].FieldName; itemDown.SummaryType = DevExpress.Data.SummaryItemType.Sum; itemDown.DisplayFormat = "{0}"; itemDown.ShowInGroupColumnFooter = _BandedGridView.Columns[i]; _BandedGridView.GroupSummary.Add(itemDown); } } } } } } } //GridView if (_GridControl.ViewCollection.Count > 0) { DevExpress.XtraGrid.Views.Grid.GridView _GridView = new DevExpress.XtraGrid.Views.Grid.GridView(); _GridView = _GridControl.ViewCollection[0] as DevExpress.XtraGrid.Views.Grid.GridView; SetTheme(_GridView); if (CreatSUM) { _GridView.GroupSummary.Clear(); for (int i = 0; i < _GridView.Columns.Count; i++) { if (_GridView.Columns[i].Visible && _GridView.Columns[i].GroupIndex < 0) { if (!Object.Equals(_GridView.GetRowCellValue(0, _GridView.Columns[i]), null)) { if (SHARED.Libraries.StringHelper.IsNumber(_GridView.GetRowCellValue(0, _GridView.Columns[i]).ToString())) { _GridView.Columns[i].SummaryItem.Collection.Clear(); _GridView.Columns[i].Summary.Add(DevExpress.Data.SummaryItemType.Sum, _GridView.Columns[i].FieldName, "{0}"); GridGroupSummaryItem itemTop = new GridGroupSummaryItem(); itemTop.FieldName = _GridView.Columns[i].FieldName; itemTop.SummaryType = DevExpress.Data.SummaryItemType.Sum; itemTop.DisplayFormat = "(" + _GridView.Columns[i].Caption + ": {0})"; _GridView.GroupSummary.Add(itemTop); GridGroupSummaryItem itemDown = new GridGroupSummaryItem(); itemDown.FieldName = _GridView.Columns[i].FieldName; itemDown.SummaryType = DevExpress.Data.SummaryItemType.Sum; itemDown.DisplayFormat = "{0}"; itemDown.ShowInGroupColumnFooter = _GridView.Columns[i]; _GridView.GroupSummary.Add(itemDown); } } } } } } }
public override void Sorgula() { if (Validate()) { grdselect = false; dtrapor = Transaction.Instance.ExecuteSql(Sql()); grdv.Columns.Clear(); grd.DataSource = dtrapor; if (rbhasta.Checked) grdv.Columns["hastaId"].Visible = false; foreach (GridColumn item in grdv.Columns) item.Width = 90; grdv.ViewCaption = "Tetkik Dökümü (Bulunan Kayıt Sayısı:" + dtrapor.Rows.Count.ToString() + ")"; grdv.Columns["TetkikAdi"].Width = 250; if (cbunite.Checked) grdv.Columns["Unite"].Width = 160; if (cblab.Checked) grdv.Columns["Laboratuvar"].Width = 300; grdv.GroupFooterShowMode = GroupFooterShowMode.VisibleAlways; grdv.OptionsView.ShowFooter = true; GridGroupSummaryItem item1 = new GridGroupSummaryItem(); item1.FieldName = "Adet"; item1.SummaryType = DevExpress.Data.SummaryItemType.Sum; item1.ShowInGroupColumnFooter = grdv.Columns["Adet"]; grdv.GroupSummary.Add(item1); grdv.Columns["Adet"].SummaryItem.FieldName = "Adet"; grdv.Columns["Adet"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; GridGroupSummaryItem item2 = new GridGroupSummaryItem(); item2.FieldName = "ToplamTutar"; item2.SummaryType = DevExpress.Data.SummaryItemType.Sum; item2.ShowInGroupColumnFooter = grdv.Columns["ToplamTutar"]; grdv.GroupSummary.Add(item2); grdv.Columns["ToplamTutar"].SummaryItem.FieldName = "ToplamTutar"; grdv.Columns["ToplamTutar"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; grdselect = true; } }
void FormatearFinanciamiento() { grid.ViewCaption = "Financiamientos"; grvFinanciera.ViewCaption = "Creditos Grupales"; if (DtCronos.Rows.Count > 0) { grid.Columns[0].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Center; grid.Columns[1].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Center; //grid.Columns[2].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Far; grid.Columns[3].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Far; grid.Columns[4].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Far; grid.Columns[5].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Far; grid.Columns[6].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Center; grid.Columns[7].Width = 200; grid.Columns[2].Width = 150; grid.Columns[0].DisplayFormat.FormatType = FormatType.Numeric; grid.Columns[3].DisplayFormat.FormatType = FormatType.Numeric; grid.Columns[3].DisplayFormat.FormatString = "$ #,##0.00"; grid.Columns[4].DisplayFormat.FormatType = FormatType.Numeric; grid.Columns[4].DisplayFormat.FormatString = "$ #,##0.00"; grid.Columns[5].DisplayFormat.FormatType = FormatType.Numeric; grid.Columns[5].DisplayFormat.FormatString = "$ #,##0.00"; grid.Columns[6].DisplayFormat.FormatType = FormatType.Numeric; gpoContenedor.Text = "Historial de Pagos"; grid.Columns[1].Group(); grid.SetGroupLevelExpanded(0, true, true); GridGroupSummaryItem item = new GridGroupSummaryItem(); item.FieldName = "Prestamo"; item.SummaryType = DevExpress.Data.SummaryItemType.Sum; item.DisplayFormat = "Total: {0:c2}"; grid.GroupSummary.Add(item); } if (DtFinanciera.Rows.Count > 0) { gridFinanciera.DataSource = DtFinanciera; grvFinanciera.Columns[3].DisplayFormat.FormatType = FormatType.Numeric; grvFinanciera.Columns[3].DisplayFormat.FormatString = "$ #,##0.00"; grvFinanciera.Columns[2].DisplayFormat.FormatType = FormatType.Numeric; grvFinanciera.Columns[2].DisplayFormat.FormatString = "$ #,##0.00"; grvFinanciera.Columns[2].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Far; grvFinanciera.Columns[3].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Far; // Create and setup the second summary item. } }
private Rectangle GetColumnBounds(GridView view, GridGroupSummaryItem item) { GridColumn column = view.Columns[item.FieldName]; return GetColumnBounds(column); }
/// <summary> /// 设置表格列属性 /// </summary> private void SetColumns() { Grid.EndEdit(); gvSource.BeginUpdate(); gvSource.OptionsView.ShowFooter = cbSum.Checked; gvSource.OptionsView.ShowGroupPanel = cbGroup.Checked; gvSource.OptionsView.ColumnAutoWidth = cbAuto.Checked; gvSource.OptionsCustomization.AllowFilter = cbFilter.Checked; gvSource.OptionsView.AllowCellMerge = ckMerge.Checked; gvSource.GroupSummary.Clear(); foreach (DataGridViewRow dvRow in Grid.Rows) { DevExpress.XtraGrid.Columns.GridColumn gc = gvSource.Columns.ColumnByFieldName(dvRow.Cells["F_ColumnName"].Value.ToString()); if (gc != null) { gc.Visible = Convert.ToBoolean(dvRow.Cells["F_Visible"].Value); if (Convert.ToBoolean(dvRow.Cells["F_Merge"].Value) == true) { gc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True; } else { gc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False; } gc.Caption = dvRow.Cells["F_ColumnCaption"].Value.ToString(); if (!dvRow.Cells["F_Format"].Value.Equals(DBNull.Value)) { gc.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom; gc.DisplayFormat.FormatString = dvRow.Cells["F_Format"].Value.ToString(); } switch (dvRow.Cells["F_SumType"].Value.ToString()) { case "合计": gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; break; case "统计": gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Count; break; case "平均": gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Average; break; case "最大值": gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Max; break; case "最小值": gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Min; break; case "自定义": gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom; break; case "(无)": gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.None; break; } if (dvRow.Cells["F_FootFormat"].Value != DBNull.Value) { gc.SummaryItem.DisplayFormat = dvRow.Cells["F_FootFormat"].Value.ToString(); } if (dvRow.Cells["F_GroupType"].Value.ToString() != "(无)") { GridGroupSummaryItem Gi = new GridGroupSummaryItem(); switch (dvRow.Cells["F_GroupType"].Value.ToString()) { case "合计": Gi.SummaryType = DevExpress.Data.SummaryItemType.Sum; break; case "统计": Gi.SummaryType = DevExpress.Data.SummaryItemType.Count; break; case "平均": Gi.SummaryType = DevExpress.Data.SummaryItemType.Average; break; case "最大值": Gi.SummaryType = DevExpress.Data.SummaryItemType.Max; break; case "最小值": Gi.SummaryType = DevExpress.Data.SummaryItemType.Min; break; case "自定义": Gi.SummaryType = DevExpress.Data.SummaryItemType.Custom; break; case "(无)": Gi.SummaryType = DevExpress.Data.SummaryItemType.None; break; } Gi.DisplayFormat = dvRow.Cells["F_GroupFormat"].Value.ToString(); Gi.ShowInGroupColumnFooterName = dvRow.Cells["F_ColumnName"].Value.ToString(); Gi.FieldName = dvRow.Cells["F_ColumnName"].Value.ToString(); gvSource.GroupSummary.Add(Gi); } } } gvSource.EndUpdate(); }
/// <summary> /// 获取表格列属性 /// </summary> private void GetColumns() { cbFilter.Checked = gvSource.OptionsCustomization.AllowFilter; cbAuto.Checked = gvSource.OptionsView.ColumnAutoWidth; cbGroup.Checked = gvSource.OptionsView.ShowGroupPanel; cbSum.Checked = gvSource.OptionsView.ShowFooter; ckMerge.Checked = gvSource.OptionsView.AllowCellMerge; int intRow; foreach (DevExpress.XtraGrid.Columns.GridColumn gc in gvSource.Columns) { if (gc.Tag != null) { continue; } if (gc.Tag == "0") { continue; } intRow = Grid.Rows.Add(); Grid.Rows[intRow].Cells["F_ColumnName"].Value = gc.FieldName; Grid.Rows[intRow].Cells["F_ColumnCaption"].Value = gc.Caption; Grid.Rows[intRow].Cells["F_Visible"].Value = gc.Visible; if (gc.OptionsColumn.AllowMerge == DevExpress.Utils.DefaultBoolean.True) { Grid.Rows[intRow].Cells["F_Merge"].Value = true; } else { Grid.Rows[intRow].Cells["F_Merge"].Value = false; } Grid.Rows[intRow].Cells["F_Format"].Value = gc.DisplayFormat.FormatString; switch (gc.SummaryItem.SummaryType) { case DevExpress.Data.SummaryItemType.Sum: Grid.Rows[intRow].Cells["F_SumType"].Value = "合计"; break; case DevExpress.Data.SummaryItemType.Count: Grid.Rows[intRow].Cells["F_SumType"].Value = "统计"; break; case DevExpress.Data.SummaryItemType.Average: Grid.Rows[intRow].Cells["F_SumType"].Value = "平均"; break; case DevExpress.Data.SummaryItemType.Max: Grid.Rows[intRow].Cells["F_SumType"].Value = "最大值"; break; case DevExpress.Data.SummaryItemType.Min: Grid.Rows[intRow].Cells["F_SumType"].Value = "最小值"; break; case DevExpress.Data.SummaryItemType.Custom: Grid.Rows[intRow].Cells["F_SumType"].Value = "自定义"; break; case DevExpress.Data.SummaryItemType.None: Grid.Rows[intRow].Cells["F_SumType"].Value = "(无)"; break; } Grid.Rows[intRow].Cells["F_FootFormat"].Value = gc.SummaryItem.DisplayFormat; Grid.Rows[intRow].Cells["F_GroupType"].Value = "(无)"; Grid.Rows[intRow].Cells["F_GroupFormat"].Value = ""; GridGroupSummaryItem Gi = GetGroupType(gc.FieldName); if (Gi != null) { switch (Gi.SummaryType) { case DevExpress.Data.SummaryItemType.Sum: Grid.Rows[intRow].Cells["F_GroupType"].Value = "合计"; break; case DevExpress.Data.SummaryItemType.Count: Grid.Rows[intRow].Cells["F_GroupType"].Value = "统计"; break; case DevExpress.Data.SummaryItemType.Average: Grid.Rows[intRow].Cells["F_GroupType"].Value = "平均"; break; case DevExpress.Data.SummaryItemType.Max: Grid.Rows[intRow].Cells["F_GroupType"].Value = "最大值"; break; case DevExpress.Data.SummaryItemType.Min: Grid.Rows[intRow].Cells["F_GroupType"].Value = "最小值"; break; case DevExpress.Data.SummaryItemType.Custom: Grid.Rows[intRow].Cells["F_GroupType"].Value = "自定义"; break; case DevExpress.Data.SummaryItemType.None: Grid.Rows[intRow].Cells["F_GroupType"].Value = "(无)"; break; } Grid.Rows[intRow].Cells["F_GroupFormat"].Value = Gi.DisplayFormat; } } }
/// <summary> /// 그리드의 밴드에 컬럼을 추가한다. /// </summary> /// <param name="column">XGridColumn</param> public void AddBandColumn(XGridColumn column) { //Caption if (string.IsNullOrEmpty(column.Caption)) { if (!string.IsNullOrEmpty(column.CaptionCode)) { column.Caption = DomainUtils.GetFieldName(column.CaptionCode); } else { column.Caption = DomainUtils.GetFieldName(column.FieldName); } } var bandedColumn = new BandedGridColumn() { Caption = column.Caption, FieldName = column.FieldName, UnboundType = column.ColumnType }; bandedColumn.OptionsColumn.AllowMerge = DefaultBoolean.False; bandedColumn.OptionsFilter.FilterPopupMode = FilterPopupMode.CheckedList; bandedColumn.CustomizationCaption = bandedColumn.Caption; bandedColumn.AppearanceHeader.Options.UseTextOptions = true; bandedColumn.AppearanceHeader.TextOptions.HAlignment = HorzAlignment.Center; bandedColumn.AppearanceCell.Options.UseTextOptions = true; switch (column.FieldName) { case "ROW_NO": case "INS_TIME": case "INS_USER": case "INS_USER_NAME": case "UPD_TIME": case "UPD_USER": case "UPD_USER_NAME": bandedColumn.AppearanceCell.TextOptions.HAlignment = HorzAlignment.Center; break; default: if (column.FieldName.EndsWith("_DATE")) { bandedColumn.AppearanceCell.TextOptions.HAlignment = HorzAlignment.Center; } else { bandedColumn.AppearanceCell.TextOptions.HAlignment = column.HorzAlignment; } break; } bandedColumn.DisplayFormat.FormatType = bandedColumn.GroupFormat.FormatType = column.FormatType; if (!string.IsNullOrEmpty(column.FormatString)) { bandedColumn.DisplayFormat.FormatString = column.FormatString; bandedColumn.GroupFormat.FormatString = column.FormatString; } if (column.RepositoryItem != null) { bandedColumn.ColumnEdit = column.RepositoryItem; } if ((column.IsSummary) && (MainView.GetType() == typeof(GridView) || MainView.GetType() == typeof(BandedGridView) || MainView.GetType() == typeof(AdvBandedGridView))) { bandedColumn.SummaryItem.SummaryType = column.SummaryItemType; bandedColumn.SummaryItem.FieldName = column.FieldName; if (!string.IsNullOrEmpty(column.FormatString)) { bandedColumn.SummaryItem.DisplayFormat = string.Format("{{0:{0}}}", column.FormatString); } if (column.IsSummaryGroup) { var item = new GridGroupSummaryItem() { FieldName = column.FieldName, ShowInGroupColumnFooter = bandedColumn, ShowInGroupColumnFooterName = column.FieldName, SummaryType = column.SummaryItemType }; if (!string.IsNullOrEmpty(column.FormatString)) { item.DisplayFormat = string.Format("{{0:{0}}}", column.FormatString); } GroupSummaryAdd(item); bandedColumn.OptionsColumn.AllowGroup = DefaultBoolean.True; } } if (column.ReadOnly || MainView.OptionsBehavior.Editable == false) { bandedColumn.OptionsColumn.ReadOnly = true; bandedColumn.OptionsColumn.AllowEdit = false; bandedColumn.OptionsColumn.AllowFocus = false; } else { bandedColumn.OptionsColumn.ReadOnly = false; bandedColumn.OptionsColumn.AllowEdit = true; bandedColumn.OptionsColumn.AllowFocus = true; } if (column.Width > 0) { bandedColumn.Width = column.Width; bandedColumn.MinWidth = column.Width; } else { switch (column.FieldName) { case "ROW_NO": bandedColumn.Width = 50; bandedColumn.MinWidth = 50; break; case "INS_TIME": case "UPD_TIME": bandedColumn.Width = 150; bandedColumn.MinWidth = 150; break; case "INS_USER": case "UPD_USER": bandedColumn.Width = 100; bandedColumn.MinWidth = 100; break; case "INS_USER_NAME": case "UPD_USER_NAME": bandedColumn.Width = 100; bandedColumn.MinWidth = 100; break; default: if (column.FieldName.EndsWith("_DATE")) { bandedColumn.Width = 100; bandedColumn.MinWidth = 100; } else { bandedColumn.BestFit(); } break; } } bandedColumn.Visible = column.Visible; if (column.Visible) { bandedColumn.VisibleIndex = MainView.Columns.Count; } MainView.Columns.Add(bandedColumn); }
void GenerateTable() { SplashScreenManager.ShowForm(typeof(WaitScreen)); if (gridControl1.DataSource != null) { gridControl1.DataSource = null; } gridControl1.DataSource = CreateColumns(); gridView1.Columns["SubsistemaTipo"].OptionsColumn.AllowEdit = false; gridView1.Columns["SubsistemaArea"].OptionsColumn.AllowEdit = false; gridView1.Columns["LocalTipo"].OptionsColumn.AllowEdit = false; gridView1.Columns["Cod1"].OptionsColumn.AllowEdit = false; gridView1.Columns["Cod1"].Width = 45; gridView1.Columns["Cod2"].OptionsColumn.AllowEdit = false; gridView1.Columns["Cod2"].Width = 40; gridView1.Columns["Cod3"].OptionsColumn.AllowEdit = false; gridView1.Columns["Cod3"].Width = 40; gridView1.Columns["Local"].OptionsColumn.AllowEdit = false; gridView1.Columns["Local"].Width = 200; //gridView1.Columns["Hab"].OptionsColumn.AllowEdit = false; //gridView1.Columns["Coef/Area"].OptionsColumn.AllowEdit = false; gridView1.Columns["Coef/Num.Habitaciones"].OptionsColumn.AllowEdit = false; gridView1.Columns["Área Útil [m²]"].OptionsColumn.AllowEdit = false; //gridView1.Columns["Promedio de % Base Diseño"].OptionsColumn.AllowEdit = false; gridView1.Columns["Áreas De Cálculo [m²]"].OptionsColumn.AllowEdit = false; RepositoryItemComboBox _repository = new RepositoryItemComboBox(); var _allPorcientos = new DB_PLANTILLA().GetAllRecords <T_Porciento_BD>(); foreach (var item in _allPorcientos) { _repository.Items.Add(item.Value); } gridView1.Columns["Promedio de % Base Diseño"].ColumnEdit = _repository; gridView1.Columns["RoomID"].OptionsColumn.AllowEdit = false; gridView1.Columns["RoomID"].Visible = false; gridView1.Columns["ID"].OptionsColumn.AllowEdit = false; gridView1.Columns["ID"].Visible = false; gridView1.Columns["Obj. Obra"].GroupIndex = 1; gridView1.Columns["LocalTipo"].GroupIndex = 2; gridView1.GroupLevelStyle += (s, e) => { if (e.Level == 0) { e.LevelAppearance.ForeColor = Color.WhiteSmoke; e.LevelAppearance.BackColor = Color.Gray; } if (e.Level == 1) { e.LevelAppearance.ForeColor = Color.Black; e.LevelAppearance.BackColor = Color.LightGray; } }; GridGroupSummaryItem _summaryAreaLocal = new GridGroupSummaryItem { FieldName = "Área Útil [m²]", SummaryType = SummaryItemType.Sum, DisplayFormat = "Total: {0:0.00}", ShowInGroupColumnFooter = gridView1.Columns["Área Útil [m²]"] }; gridView1.GroupSummary.Add(_summaryAreaLocal); GridGroupSummaryItem _summaryAreaCalculo = new GridGroupSummaryItem { FieldName = "Áreas De Cálculo [m²]", SummaryType = SummaryItemType.Sum, DisplayFormat = "Total: {0:0.00}", ShowInGroupColumnFooter = gridView1.Columns["Áreas De Cálculo [m²]"] }; gridView1.GroupSummary.Add(_summaryAreaCalculo); GridGroupSummaryItem _summaryHabitaciones = new GridGroupSummaryItem { FieldName = "Hab", SummaryType = SummaryItemType.Sum, DisplayFormat = "Total: {0}", ShowInGroupColumnFooter = gridView1.Columns["Hab"] }; gridView1.GroupSummary.Add(_summaryHabitaciones); _localesByProject = new DB_BIM().GetElements <Locales_Proyecto>(x => x.Proyecto == _proyecto.Id); foreach (var item in _localesByProject) { AddGridViewRow(item); } SplashScreenManager.CloseForm(); }
private void InitAllowanceColumn() { // BandedGridColumn column = null; List <BandedGridColumn> bandedGridColumns = new List <BandedGridColumn>(); foreach (BandedGridColumn column in this.bandAllowance.Columns) { if ((column == this.colAllowance ? false : column != this.colTotalSalary)) { bandedGridColumns.Add(column); } } foreach (BandedGridColumn bandedGridColumn in bandedGridColumns) { this.gbList.Columns.Remove(bandedGridColumn); } List <BandedGridColumn> bandedGridColumns1 = new List <BandedGridColumn>(); foreach (BandedGridColumn column1 in this.bandTaxAllowance.Columns) { if ((column1 == this.colNumberDepend || column1 == this.colDependMoney || column1 == this.colTaxYourSelfMoney || column1 == this.colTaxOvertime150Money || column1 == this.colTaxOvertime200Money || column1 == this.colTaxOvertime300Money || column1 == this.colTaxOvertime195Money || column1 == this.colTaxOvertime260Money ? false : column1 != this.colTaxOvertime390Money)) { bandedGridColumns1.Add(column1); } } foreach (BandedGridColumn bandedGridColumn1 in bandedGridColumns1) { this.gbList.Columns.Remove(bandedGridColumn1); } foreach (DataRow row in (new DIC_ALLOWANCE()).GetList().Rows) { BandedGridColumn brown = new BandedGridColumn() { FieldName = row["AllowanceCode"].ToString(), Caption = string.Concat(row["AllowanceName"].ToString().Remove(1).ToUpper(), row["AllowanceName"].ToString().Remove(0, 1).ToLower()), ColumnEdit = this.repCalculator, Name = string.Concat("colAllowance", row["AllowanceCode"].ToString()) }; brown.AppearanceHeader.Options.UseForeColor = true; brown.AppearanceHeader.ForeColor = Color.Brown; brown.AppearanceCell.Options.UseBackColor = true; brown.AppearanceCell.BackColor = Color.Ivory; brown.OptionsColumn.ReadOnly = true; brown.SummaryItem.DisplayFormat = "{0:##,##0}"; brown.SummaryItem.SummaryType = SummaryItemType.Sum; brown.Visible = true; brown.Width = 76; this.bandAllowance.Columns.Add(brown); GridSummaryItem gridGroupSummaryItem = new GridGroupSummaryItem(SummaryItemType.Sum, brown.FieldName, brown, "{0:##,##0}"); this.gbList.GroupSummary.Add(gridGroupSummaryItem); brown.Width = 76; if (bool.Parse(row["IsShowInSalaryTableList"].ToString())) { BandedGridColumn red = new BandedGridColumn() { FieldName = string.Concat("Tax", row["AllowanceCode"].ToString()), Caption = string.Concat(row["AllowanceName"].ToString().Remove(1).ToUpper(), row["AllowanceName"].ToString().Remove(0, 1).ToLower()), ColumnEdit = this.repCalculator, Name = string.Concat("colTaxAllowance", row["AllowanceCode"].ToString()) }; red.AppearanceHeader.Options.UseForeColor = true; red.AppearanceHeader.ForeColor = Color.Red; red.AppearanceCell.Options.UseBackColor = true; red.AppearanceCell.BackColor = Color.Ivory; red.OptionsColumn.ReadOnly = true; red.SummaryItem.DisplayFormat = "{0:##,##0}"; red.SummaryItem.SummaryType = SummaryItemType.Sum; red.Visible = true; red.Width = 76; this.bandTaxAllowance.Columns.Add(red); GridSummaryItem gridSummaryItem = new GridGroupSummaryItem(SummaryItemType.Sum, red.FieldName, red, "{0:##,##0}"); this.gbList.GroupSummary.Add(gridSummaryItem); red.Width = 76; } } this.colEmployeeCode.Width = 65; this.colFirstName.Width = 121; this.colLastName.Width = 56; this.colCoefficientSalary.Width = 54; this.colBasicSalary.Width = 76; this.colInsuranceSalary.Width = 76; this.colAllowanceInsurance.Width = 76; this.colAllowance.Width = 64; this.colTotalSalary.Width = 76; this.colTaxYourSelfMoney.Width = 75; this.colNumberDepend.Width = 66; this.colDependMoney.Width = 77; this.colTaxOvertime150Money.Width = 75; this.colTaxOvertime200Money.Width = 75; this.colTaxOvertime300Money.Width = 75; this.colTaxOvertime195Money.Width = 75; this.colTaxOvertime260Money.Width = 75; this.colTaxOvertime390Money.Width = 75; }
private object CreateObject(XmlElement xmlElement, bool suspend) { Type type = GetTypeByName(xmlElement.Name); if (xmlElement.Attributes["value"] != null) { try { return(Convert.ChangeType(xmlElement.Attributes["value"].InnerText, type)); } catch (Exception ex) { MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } } if (type == null) { return(null); } object newObj; if (type.FullName == "System.Windows.Forms.Form") { newObj = this.mainPanel; } else if (type.FullName == "System.Windows.Forms.DataGridView") { GridControl grdEntity = new GridControl(); grdEntity.Name = "grdEntity"; grdEntity.Dock = DockStyle.Fill; grdEntity.LookAndFeel.UseWindowsXPTheme = true; XmlNode nodeTmp = xmlElement.SelectSingleNode("DataMember"); if (nodeTmp != null) { grdEntity.Text = nodeTmp.Attributes["value"].Value; } GridView viewEntity = new GridView(); viewEntity.Appearance.GroupPanel.Options.UseBackColor = true; viewEntity.Appearance.GroupPanel.BackColor = Color.SkyBlue; viewEntity.Appearance.GroupPanel.BackColor2 = Color.White; viewEntity.Appearance.FocusedRow.Options.UseBackColor = true; viewEntity.Appearance.FocusedRow.BackColor = Color.FromArgb(51, 153, 255); viewEntity.Appearance.HideSelectionRow.Options.UseBackColor = true; viewEntity.Appearance.HideSelectionRow.BackColor = Color.FromArgb(51, 153, 255); viewEntity.Appearance.HideSelectionRow.Options.UseForeColor = true; viewEntity.Appearance.HideSelectionRow.ForeColor = Color.White; viewEntity.OptionsView.ColumnAutoWidth = false; //viewEntity.OptionsView.ShowGroupPanel = false; //viewEntity.OptionsCustomization.AllowFilter = false; viewEntity.GroupPanelText = "查询结果"; viewEntity.OptionsBehavior.Editable = false; viewEntity.GroupFooterShowMode = GroupFooterShowMode.VisibleIfExpanded; viewEntity.OptionsView.ShowDetailButtons = false; viewEntity.OptionsView.ShowFooter = true; viewEntity.FocusRectStyle = DrawFocusRectStyle.None; viewEntity.GridControl = grdEntity; viewEntity.Name = "GirdView"; viewEntity.OptionsSelection.EnableAppearanceFocusedCell = false; viewEntity.PaintStyleName = "WindowsXP"; viewEntity.RowHeight = 25; viewEntity.ColumnPanelRowHeight = 30; viewEntity.GroupFooterShowMode = GroupFooterShowMode.VisibleAlways; GridGroupSummaryItem summaryItem; IEnumerator enumerator = _solution.DataSetList.GetEnumerator(); SnDataSet temp = null; while (enumerator.MoveNext()) { temp = enumerator.Current as SnDataSet; if (temp.DataSetID != grdEntity.Text && !string.IsNullOrEmpty(grdEntity.Text)) { continue; } for (int i = 0; i < temp.FieldsList.Count; i++) { GridColumn gridColumn = new GridColumn(); gridColumn.FieldName = temp.FieldsList[i].FieldName; gridColumn.Caption = temp.FieldsList[i].FieldChineseName; gridColumn.Width = temp.FieldsList[i].DisplayWidth > 0 ? temp.FieldsList[i].DisplayWidth : 90; if (!temp.FieldsList[i].ColumnVisible) { gridColumn.Visible = false; gridColumn.VisibleIndex = -1; } else { gridColumn.VisibleIndex = i; } switch (temp.FieldsList[i].CalcType) { case "Sum": summaryItem = new GridGroupSummaryItem(); summaryItem.FieldName = temp.FieldsList[i].FieldChineseName; summaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; summaryItem.DisplayFormat = "合计:{0:0.00}"; summaryItem.ShowInGroupColumnFooter = gridColumn; viewEntity.GroupSummary.Add(summaryItem); gridColumn.SummaryItem.DisplayFormat = "合计:{0:0.00}"; gridColumn.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; break; case "Average": summaryItem = new GridGroupSummaryItem(); summaryItem.FieldName = temp.FieldsList[i].FieldChineseName; summaryItem.SummaryType = DevExpress.Data.SummaryItemType.Average; summaryItem.DisplayFormat = "均值:{0:c2}"; summaryItem.ShowInGroupColumnFooter = gridColumn; viewEntity.GroupSummary.Add(summaryItem); gridColumn.SummaryItem.DisplayFormat = "均值:{0:c}"; gridColumn.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Average; break; case "Max": gridColumn.SummaryItem.DisplayFormat = "最大:{0:c}"; gridColumn.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Max; break; case "Min": gridColumn.SummaryItem.DisplayFormat = "最小:{0:c}"; gridColumn.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Min; break; case "Count": gridColumn.SummaryItem.DisplayFormat = "行数:{0:d}"; gridColumn.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Count; break; default: gridColumn.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.None; break; } foreach (StyleFormat s in temp.FieldsList[i].StyleFormat) { DevExpress.XtraGrid.StyleFormatCondition styleFormatCondition = new DevExpress.XtraGrid.StyleFormatCondition(); styleFormatCondition.Column = gridColumn; styleFormatCondition.Appearance.Options.UseForeColor = true; styleFormatCondition.Appearance.Options.UseBackColor = true; styleFormatCondition.Appearance.BackColor = System.Drawing.Color.FromArgb(s.BackColorRed, s.BackColorGreen, s.BackColorBlue); styleFormatCondition.Appearance.ForeColor = System.Drawing.Color.FromArgb(s.ForeColorRed, s.ForeColorGreen, s.ForeColorBlue); styleFormatCondition.ApplyToRow = s.ApplyToRow; styleFormatCondition.Condition = s.Condition; if (s.Value1 != null) { styleFormatCondition.Value1 = s.Value1.ToString() != "<Null>" ? GetValueByTypeName(s.Type1, s.Value1) : "<Null>"; } if (s.Value2 != null) { styleFormatCondition.Value2 = s.Value2.ToString() != "<Null>" ? GetValueByTypeName(s.Type2, s.Value2) : "<Null>"; } viewEntity.FormatConditions.Add(styleFormatCondition); } switch (temp.FieldsList[i].FieldType.ToUpper()) { case "TIMESTAMP": case "DATETIME": gridColumn.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime; break; case "DECIMAL": if (temp.FieldsList[i].DecimalDigits == 0 && temp.FieldsList[i].DecimalDigits > 6) { temp.FieldsList[i].DecimalDigits = 2; } string tempstr = "0."; for (int j = 0; j < temp.FieldsList[i].DecimalDigits; j++) { tempstr += "0"; } gridColumn.DisplayFormat.FormatString = tempstr; gridColumn.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom; break; case "INT": gridColumn.DisplayFormat.FormatString = "0"; gridColumn.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom; break; } viewEntity.Columns.Add(gridColumn); } if (File.Exists(FileName + grdEntity.Text + ".xml")) { viewEntity.RestoreLayoutFromXml(FileName + grdEntity.Text + ".xml"); } } grdEntity.MainView = viewEntity; newObj = grdEntity; _componentContainer.Add(newObj); } else { newObj = type.Assembly.CreateInstance(type.FullName); _componentContainer.Add(newObj); } string componentName = null; if (xmlElement["Name"] != null && xmlElement["Name"].Attributes["value"] != null) { componentName = xmlElement["Name"].Attributes["value"].InnerText; } bool hasSuspended = false; if (suspend && newObj is ContainerControl) { hasSuspended = true; ((Control)newObj).SuspendLayout(); } foreach (XmlNode subNode in xmlElement.ChildNodes) { if (subNode is XmlElement) { XmlElement subElement = (XmlElement)subNode; if (subElement.Attributes["value"] != null) { try { SetValue(newObj, subElement.Name, subElement.Attributes["value"].InnerText); } catch (Exception ex) { MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { PropertyInfo propertyInfo = newObj.GetType().GetProperty(subElement.Name); object pList = propertyInfo.GetValue(newObj, null); if (pList is IList) { foreach (XmlNode node in subElement.ChildNodes) { if (node is XmlElement) { XmlElement cNode = node as XmlElement; object collectionObj = CreateObject(cNode, false); if (collectionObj != null) { try { ((IList)pList).Add(collectionObj); } catch (Exception ex) { MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } } } } } } if (_acceptButton != null && newObj is Form) { ((Form)newObj).AcceptButton = (IButtonControl)Container.Components[_acceptButton]; _acceptButton = null; } if (_cancelButton != null && newObj is Form) { ((Form)newObj).CancelButton = (IButtonControl)Container.Components[_cancelButton]; _cancelButton = null; } if (hasSuspended) { ((Control)newObj).ResumeLayout(false); } return(newObj); }
private void InitSalaryPlusMinus() { //BandedGridColumn column = null; // DataRow row = null; BandedGridColumn bandedGridColumn; GridSummaryItem gridGroupSummaryItem; BandedGridColumn blue; GridSummaryItem gridSummaryItem; List <BandedGridColumn> bandedGridColumns = new List <BandedGridColumn>(); foreach (BandedGridColumn column in this.bandPlusMinusBefore.Columns) { bandedGridColumns.Add(column); } foreach (BandedGridColumn bandedGridColumn1 in bandedGridColumns) { this.gbList.Columns.Remove(bandedGridColumn1); } List <BandedGridColumn> bandedGridColumns1 = new List <BandedGridColumn>(); foreach (BandedGridColumn column1 in this.bandPlusMinusAfter.Columns) { bandedGridColumns1.Add(column1); } foreach (BandedGridColumn bandedGridColumn2 in bandedGridColumns1) { this.gbList.Columns.Remove(bandedGridColumn2); } if (!(this.m_SalaryTableListID == Guid.Empty)) { HRM_SALARY_DEDUCTION hRMSALARYDEDUCTION = new HRM_SALARY_DEDUCTION(); DataTable list = hRMSALARYDEDUCTION.GetList(this.m_SalaryTableListID, true); foreach (DataRow row in list.Rows) { bandedGridColumn = new BandedGridColumn() { FieldName = string.Concat("Deduction", row["DeductionCode"].ToString()), Caption = string.Concat(row["DeductionName"].ToString().Remove(1).ToUpper(), row["DeductionName"].ToString().Remove(0, 1).ToLower()), ColumnEdit = this.repCalculator, Name = string.Concat("colDeductionCode", row["DeductionCode"].ToString()) }; bandedGridColumn.AppearanceHeader.Options.UseForeColor = true; bandedGridColumn.AppearanceHeader.ForeColor = Color.Blue; bandedGridColumn.AppearanceCell.Options.UseBackColor = true; bandedGridColumn.AppearanceCell.BackColor = Color.Azure; bandedGridColumn.OptionsColumn.ReadOnly = true; bandedGridColumn.SummaryItem.DisplayFormat = "{0:##,##0}"; bandedGridColumn.SummaryItem.SummaryType = SummaryItemType.Sum; bandedGridColumn.Visible = true; bandedGridColumn.Width = 76; this.bandPlusMinusBefore.Columns.Add(bandedGridColumn); gridGroupSummaryItem = new GridGroupSummaryItem(SummaryItemType.Sum, bandedGridColumn.FieldName, bandedGridColumn, "{0:##,##0}"); this.gbList.GroupSummary.Add(gridGroupSummaryItem); bandedGridColumn.Width = 76; } HRM_SALARY_INCOME hRMSALARYINCOME = new HRM_SALARY_INCOME(); DataTable dataTable = hRMSALARYINCOME.GetList(this.m_SalaryTableListID, true); if (dataTable.Rows.Count + list.Rows.Count <= 0) { this.bandPlusMinusBefore.Visible = false; } foreach (DataRow dataRow in dataTable.Rows) { blue = new BandedGridColumn() { FieldName = string.Concat("Income", dataRow["IncomeCode"].ToString()), Caption = string.Concat(dataRow["IncomeName"].ToString().Remove(1).ToUpper(), dataRow["IncomeName"].ToString().Remove(0, 1).ToLower()), ColumnEdit = this.repCalculator, Name = string.Concat("colIncomeCode", dataRow["IncomeCode"].ToString()) }; blue.AppearanceHeader.Options.UseForeColor = true; blue.AppearanceHeader.ForeColor = Color.Blue; blue.AppearanceCell.Options.UseBackColor = true; blue.AppearanceCell.BackColor = Color.Azure; blue.OptionsColumn.ReadOnly = true; blue.SummaryItem.DisplayFormat = "{0:##,##0}"; blue.SummaryItem.SummaryType = SummaryItemType.Sum; blue.Visible = true; blue.Width = 76; this.bandPlusMinusBefore.Columns.Add(blue); gridSummaryItem = new GridGroupSummaryItem(SummaryItemType.Sum, blue.FieldName, blue, "{0:##,##0}"); this.gbList.GroupSummary.Add(gridSummaryItem); blue.Width = 76; } list = hRMSALARYDEDUCTION.GetList(this.m_SalaryTableListID, false); foreach (DataRow row1 in list.Rows) { bandedGridColumn = new BandedGridColumn() { FieldName = string.Concat("Deduction", row1["DeductionCode"].ToString()), Caption = string.Concat(row1["DeductionName"].ToString().Remove(1).ToUpper(), row1["DeductionName"].ToString().Remove(0, 1).ToLower()), ColumnEdit = this.repCalculator, Name = string.Concat("colDeductionCode", row1["DeductionCode"].ToString()) }; bandedGridColumn.AppearanceHeader.Options.UseForeColor = true; bandedGridColumn.AppearanceHeader.ForeColor = Color.Blue; bandedGridColumn.AppearanceCell.Options.UseBackColor = true; bandedGridColumn.AppearanceCell.BackColor = Color.Azure; bandedGridColumn.OptionsColumn.ReadOnly = true; bandedGridColumn.SummaryItem.DisplayFormat = "{0:##,##0}"; bandedGridColumn.SummaryItem.SummaryType = SummaryItemType.Sum; bandedGridColumn.Visible = true; bandedGridColumn.Width = 76; this.bandPlusMinusAfter.Columns.Add(bandedGridColumn); gridGroupSummaryItem = new GridGroupSummaryItem(SummaryItemType.Sum, bandedGridColumn.FieldName, bandedGridColumn, "{0:##,##0}"); this.gbList.GroupSummary.Add(gridGroupSummaryItem); bandedGridColumn.Width = 76; } dataTable = hRMSALARYINCOME.GetList(this.m_SalaryTableListID, false); if (dataTable.Rows.Count + list.Rows.Count <= 0) { this.bandPlusMinusAfter.Visible = false; } foreach (DataRow dataRow1 in dataTable.Rows) { blue = new BandedGridColumn() { FieldName = string.Concat("Income", dataRow1["IncomeCode"].ToString()), Caption = string.Concat(dataRow1["IncomeName"].ToString().Remove(1).ToUpper(), dataRow1["IncomeName"].ToString().Remove(0, 1).ToLower()), ColumnEdit = this.repCalculator, Name = string.Concat("colIncomeCode", dataRow1["IncomeCode"].ToString()) }; blue.AppearanceHeader.Options.UseForeColor = true; blue.AppearanceHeader.ForeColor = Color.Blue; blue.AppearanceCell.Options.UseBackColor = true; blue.AppearanceCell.BackColor = Color.Azure; blue.OptionsColumn.ReadOnly = true; blue.SummaryItem.DisplayFormat = "{0:##,##0}"; blue.SummaryItem.SummaryType = SummaryItemType.Sum; blue.Visible = true; blue.Width = 76; this.bandPlusMinusAfter.Columns.Add(blue); gridSummaryItem = new GridGroupSummaryItem(SummaryItemType.Sum, blue.FieldName, blue, "{0:##,##0}"); this.gbList.GroupSummary.Add(gridSummaryItem); blue.Width = 76; } this.colEmployeeCode.Width = 65; this.colFirstName.Width = 121; this.colLastName.Width = 56; this.colCoefficientSalary.Width = 54; this.colBasicSalary.Width = 76; this.colInsuranceSalary.Width = 76; this.colAllowanceInsurance.Width = 76; this.colAllowance.Width = 64; this.colTotalSalary.Width = 76; this.colTaxYourSelfMoney.Width = 75; this.colNumberDepend.Width = 66; this.colDependMoney.Width = 77; this.colTaxOvertime150Money.Width = 75; this.colTaxOvertime200Money.Width = 75; this.colTaxOvertime300Money.Width = 75; this.colTaxOvertime195Money.Width = 75; this.colTaxOvertime260Money.Width = 75; this.colTaxOvertime390Money.Width = 75; } }
protected override void AssignField() { DevExpress.XtraGrid.Views.Grid.GridView gvFormat = null; switch (intIndex) { case -1: gvFormat = gvReport; break; case 1: gvFormat = gvStockIn; break; case 2: gvFormat = gvPay; break; case 3: gvFormat = gvStockBack; break; case 4: gvFormat = gvStockIn; break; case 5: gvFormat = gvPay; break; case 6: gvFormat = gvStockBack; break; } DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs("select * from t_ReportField where F_Class = '" + ReportTag + "' and F_Tag = '" + intIndex.ToString() + "' order by F_Order"); DataTable dtGroup = ds.Tables[0]; if (ds.Tables[0].Rows.Count == 0) { return; } gvFormat.GroupSummary.Clear(); foreach (GridColumn gc in gvFormat.Columns) { DataRow[] drTmp = dtGroup.Select("F_Field = '" + gc.FieldName + "'"); if (drTmp.Length > 0) { DataRow dr = drTmp[0]; gc.Caption = dr["F_Caption"].ToString(); gc.Width = Convert.ToInt32(dr["F_Width"]); gc.Visible = Convert.ToBoolean(dr["F_Visible"]); gc.VisibleIndex = Convert.ToInt32(dr["F_Order"]); if (dr["F_Format"].ToString().Length > 0) { gc.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom; gc.DisplayFormat.FormatString = dr["F_Format"].ToString(); } switch (dr["F_SumType"].ToString()) { case "sum": gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; break; case "avg": gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Average; break; case "count": gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Count; break; case "max": gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Max; break; case "min": gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Min; break; } if (dr["F_FootFormat"].ToString().Length > 0) { gc.SummaryItem.DisplayFormat = dr["F_FootFormat"].ToString(); } if (Convert.ToBoolean(dr["F_Edit"]) == false) { //gc.AppearanceCell.BackColor = System.Drawing.Color.FromArgb(192, 255, 192); gc.OptionsColumn.AllowFocus = false; gc.OptionsColumn.AllowEdit = false; } if (Convert.ToBoolean(dr["F_Merge"]) == true) { gc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True; } else { gc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False; } gc.AppearanceHeader.TextOptions.VAlignment = DevExpress.Utils.VertAlignment.Center; gc.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; if (gc.FieldName == "Aid") { gc.AppearanceCell.TextOptions.VAlignment = DevExpress.Utils.VertAlignment.Center; gc.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; } if (dr["F_GroupType"].ToString().Length > 0) { GridGroupSummaryItem Gi = new GridGroupSummaryItem(); switch (dr["F_GroupType"].ToString()) { case "sum": Gi.SummaryType = DevExpress.Data.SummaryItemType.Sum; break; case "avg": Gi.SummaryType = DevExpress.Data.SummaryItemType.Average; break; case "count": Gi.SummaryType = DevExpress.Data.SummaryItemType.Count; break; case "max": Gi.SummaryType = DevExpress.Data.SummaryItemType.Max; break; case "min": Gi.SummaryType = DevExpress.Data.SummaryItemType.Min; break; } Gi.FieldName = dr["F_Field"].ToString(); Gi.ShowInGroupColumnFooterName = dr["F_Field"].ToString(); Gi.DisplayFormat = dr["F_GroupFormat"].ToString(); //Gi.ShowInGroupColumnFooter = gc; gvFormat.GroupSummary.Add(Gi); } } } }
protected override void SaveFieldFormat() { string strSumType = ""; DataRow drColumn; DevExpress.XtraGrid.Views.Grid.GridView gvFormat = null; switch (intIndex) { case -1: gvFormat = gvReport; break; case 1: gvFormat = gvStockIn; break; case 2: gvFormat = gvPay; break; case 3: gvFormat = gvStockBack; break; case 4: gvFormat = gvStockIn; break; case 5: gvFormat = gvPay; break; case 6: gvFormat = gvStockBack; break; } DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs("select * from t_ReportField where F_Class = '" + ReportTag + "' and F_Tag = '" + intIndex.ToString() + "'"); foreach (GridColumn gc in gvFormat.Columns) { string strField = gc.FieldName; string strCapiton = gc.Caption; int intWith = gc.Width; bool blnVisible = gc.Visible; drColumn = ds.Tables[0].NewRow(); drColumn["F_Class"] = ReportTag; drColumn["F_Tag"] = intIndex; drColumn["F_Field"] = gc.FieldName; drColumn["F_Caption"] = strCapiton; drColumn["F_Width"] = intWith; drColumn["F_Visible"] = blnVisible; drColumn["F_Edit"] = 0; drColumn["F_Format"] = gc.DisplayFormat.FormatString; drColumn["F_FootFormat"] = gc.SummaryItem.DisplayFormat; drColumn["F_Order"] = gc.VisibleIndex; if (gc.OptionsColumn.AllowMerge == DevExpress.Utils.DefaultBoolean.True) { drColumn["F_Merge"] = true; } else { drColumn["F_Merge"] = false; } strSumType = ""; switch (gc.SummaryItem.SummaryType) { case DevExpress.Data.SummaryItemType.Sum: strSumType = "sum"; break; case DevExpress.Data.SummaryItemType.Average: strSumType = "avg"; break; case DevExpress.Data.SummaryItemType.Count: strSumType = "count"; break; case DevExpress.Data.SummaryItemType.Max: strSumType = "max"; break; case DevExpress.Data.SummaryItemType.Min: strSumType = "min"; break; } drColumn["F_SumType"] = strSumType; GridGroupSummaryItem Gi = GetGroupType(strField); if (Gi != null) { strSumType = ""; switch (Gi.SummaryType) { case DevExpress.Data.SummaryItemType.Sum: strSumType = "sum"; break; case DevExpress.Data.SummaryItemType.Average: strSumType = "avg"; break; case DevExpress.Data.SummaryItemType.Count: strSumType = "count"; break; case DevExpress.Data.SummaryItemType.Max: strSumType = "max"; break; case DevExpress.Data.SummaryItemType.Min: strSumType = "min"; break; } drColumn["F_GroupType"] = strSumType; drColumn["F_GroupFormat"] = Gi.DisplayFormat; } ds.Tables[0].Rows.Add(drColumn); } myHelper.ExecuteSQL("delete from t_ReportField where F_Class = '" + ReportTag + "' and F_Tag = '" + intIndex.ToString() + "'"); myHelper.SaveData(ds, "select * from t_ReportField where F_Class = '" + ReportTag + "' and F_Tag = '" + intIndex.ToString() + "'"); }
/// <summary> /// 保存字段格式 /// </summary> private void SaveFieldFormat() { string strSumType = ""; DataRow drColumn; bool blnFlag = false, blnTag = false; DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs("select * from t_ReportField where F_Class = '" + this.Name + "' and F_Tag = '0' order by F_Order"); if (ds.Tables[0].Rows.Count == 0) { blnTag = false; } else { blnTag = true; } foreach (GridColumn gc in gvBase.Columns) { string strField = gc.FieldName; string strCapiton = gc.Caption; int intWith = gc.Width; bool blnVisible = gc.Visible; if (blnTag == false) { drColumn = ds.Tables[0].NewRow(); blnFlag = true; } else { DataRow[] dr = ds.Tables[0].Select("F_Field = '" + strField + "'"); drColumn = dr[0]; } drColumn["F_Class"] = this.Name; drColumn["F_Tag"] = "0"; drColumn["F_Field"] = gc.FieldName; drColumn["F_Caption"] = strCapiton; drColumn["F_Width"] = intWith; drColumn["F_Visible"] = blnVisible; drColumn["F_Edit"] = 0; drColumn["F_Format"] = ""; drColumn["F_FootFormat"] = ""; drColumn["F_Order"] = gc.VisibleIndex; if (gc.OptionsColumn.AllowMerge == DevExpress.Utils.DefaultBoolean.True) { drColumn["F_Merge"] = true; } else { drColumn["F_Merge"] = false; } strSumType = ""; switch (gc.SummaryItem.SummaryType) { case DevExpress.Data.SummaryItemType.Sum: strSumType = "sum"; break; case DevExpress.Data.SummaryItemType.Average: strSumType = "avg"; break; case DevExpress.Data.SummaryItemType.Count: strSumType = "count"; break; case DevExpress.Data.SummaryItemType.Max: strSumType = "max"; break; case DevExpress.Data.SummaryItemType.Min: strSumType = "min"; break; } drColumn["F_SumType"] = strSumType; GridGroupSummaryItem Gi = GetGroupType(strField); if (Gi != null) { strSumType = ""; switch (Gi.SummaryType) { case DevExpress.Data.SummaryItemType.Sum: strSumType = "sum"; break; case DevExpress.Data.SummaryItemType.Average: strSumType = "avg"; break; case DevExpress.Data.SummaryItemType.Count: strSumType = "count"; break; case DevExpress.Data.SummaryItemType.Max: strSumType = "max"; break; case DevExpress.Data.SummaryItemType.Min: strSumType = "min"; break; } drColumn["F_GroupType"] = strSumType; drColumn["F_GroupFormat"] = Gi.DisplayFormat; } if (blnFlag == false) { drColumn.EndEdit(); } else { ds.Tables[0].Rows.Add(drColumn); } } myHelper.SaveData(ds, "select * from t_ReportField where F_Class = '" + this.Name + "' and F_Tag = '0'"); DataSet dsGrid = myHelper.GetDs("select * from t_GridFormat where F_Class = '" + this.Name + "' and F_Tag = '0'"); DataRow drGrid = null; if (dsGrid.Tables[0].Rows.Count == 0) { blnFlag = true; drGrid = dsGrid.Tables[0].NewRow(); } else { blnFlag = false; drGrid = dsGrid.Tables[0].Rows[0]; drGrid.BeginEdit(); } drGrid["F_Class"] = this.Name; drGrid["F_Tag"] = "0"; drGrid["F_AllowMerge"] = gvBase.OptionsView.AllowCellMerge; drGrid["F_AllowFilter"] = gvBase.OptionsCustomization.AllowFilter; drGrid["F_AllowPanel"] = gvBase.OptionsView.ShowGroupPanel; drGrid["F_AllowSum"] = gvBase.OptionsView.ShowFooter; drGrid["F_AutoWidth"] = gvBase.OptionsView.ColumnAutoWidth; if (blnFlag == true) { dsGrid.Tables[0].Rows.Add(drGrid); } else { drGrid.EndEdit(); } myHelper.SaveData(dsGrid, "select * from t_GridFormat where F_Class = '" + this.Name + "' and F_Tag = '0'"); }
/// <summary> /// 设置单据明细字段 /// </summary> private void AssignField() { DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet dsGrid = myHelper.GetDs("select * from t_GridFormat where F_Class = '" + this.Name + "' and F_Tag = '0'"); if (dsGrid.Tables[0].Rows.Count > 0) { gvBase.OptionsCustomization.AllowFilter = Convert.ToBoolean(dsGrid.Tables[0].Rows[0]["F_AllowFilter"]); gvBase.OptionsView.AllowCellMerge = Convert.ToBoolean(dsGrid.Tables[0].Rows[0]["F_AllowMerge"]); gvBase.OptionsView.ShowFooter = Convert.ToBoolean(dsGrid.Tables[0].Rows[0]["F_AllowSum"]); gvBase.OptionsView.ShowGroupPanel = Convert.ToBoolean(dsGrid.Tables[0].Rows[0]["F_AllowPanel"]); gvBase.OptionsView.ColumnAutoWidth = Convert.ToBoolean(dsGrid.Tables[0].Rows[0]["F_AutoWidth"]); } dsGrid.Dispose(); DataSet ds = myHelper.GetDs("select * from t_ReportField where F_Class = '" + this.Name + "' and F_Tag = '0' order by F_Order"); if (ds.Tables[0].Rows.Count == 0) { return; } gvBase.GroupSummary.Clear(); gvBase.Columns.Clear(); foreach (DataRow dr in ds.Tables[0].Rows) { GridColumn gc = gvBase.Columns.AddField(dr["F_Field"].ToString()); gc.Caption = dr["F_Caption"].ToString(); gc.Width = Convert.ToInt32(dr["F_Width"]); gc.Visible = Convert.ToBoolean(dr["F_Visible"]); switch (dr["F_SumType"].ToString()) { case "sum": gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; break; case "avg": gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Average; break; case "count": gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Count; break; case "max": gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Max; break; case "min": gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Min; break; } if (Convert.ToBoolean(dr["F_Edit"]) == false) { //gc.AppearanceCell.BackColor = System.Drawing.Color.FromArgb(192, 255, 192); gc.OptionsColumn.AllowFocus = false; gc.OptionsColumn.AllowEdit = false; } if (Convert.ToBoolean(dr["F_Merge"]) == true) { gc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True; } else { gc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False; } gc.AppearanceHeader.TextOptions.VAlignment = DevExpress.Utils.VertAlignment.Center; gc.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; if (gc.FieldName == "Aid") { gc.AppearanceCell.TextOptions.VAlignment = DevExpress.Utils.VertAlignment.Center; gc.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; } if (dr["F_GroupType"].ToString().Length > 0) { GridGroupSummaryItem Gi = new GridGroupSummaryItem(); switch (dr["F_GroupType"].ToString()) { case "sum": Gi.SummaryType = DevExpress.Data.SummaryItemType.Sum; break; case "avg": Gi.SummaryType = DevExpress.Data.SummaryItemType.Average; break; case "count": Gi.SummaryType = DevExpress.Data.SummaryItemType.Count; break; case "max": Gi.SummaryType = DevExpress.Data.SummaryItemType.Max; break; case "min": Gi.SummaryType = DevExpress.Data.SummaryItemType.Min; break; } Gi.FieldName = dr["F_Field"].ToString(); Gi.ShowInGroupColumnFooterName = dr["F_Field"].ToString(); Gi.DisplayFormat = dr["F_GroupFormat"].ToString(); //Gi.ShowInGroupColumnFooter = gc; gvBase.GroupSummary.Add(Gi); } } }