private void AddBand() { BandedGridColumn bgc; NS_LoaiPhuCapInfo pNS_LoaiPhuCapInfo = new NS_LoaiPhuCapInfo(); cBNS_LoaiPhuCap oBNS_LoaiPhuCap = new cBNS_LoaiPhuCap(); dtLoaiPhuCap = oBNS_LoaiPhuCap.Get(pNS_LoaiPhuCapInfo); grbPhuCap.Columns.Clear(); if ((dtLoaiPhuCap != null) && (dtLoaiPhuCap.Rows.Count > 0)) { foreach (DataRow dr in dtLoaiPhuCap.Rows) { if ("" + dr["KyHieu"] == "PCGV&YT") { IDPhuCapGV_YT = int.Parse(dr["NS_LoaiPhuCapID"].ToString()); } dtGiaoVien.Columns.Add(dr["NS_LoaiPhuCapID"].ToString(), typeof(double)); bgc = new BandedGridColumn(); grbPhuCap.Columns.Add(bgc); SetColumnBandCaption(bgc, dr["TenLoaiPhuCap"].ToString(), dr["NS_LoaiPhuCapID"].ToString(), 130, DevExpress.Utils.HorzAlignment.Default, false); bgc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False; bgc.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; bgc.DisplayFormat.FormatString = "n2"; bgc.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; bgc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; bgvBangLuong.Columns.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn[] { bgc }); } bgc = new BandedGridColumn(); grbPhuCap.Columns.Add(bgc); SetColumnBandCaption(bgc, "Tổng hệ số phụ cấp", "TongHeSoPhuCap", 120, DevExpress.Utils.HorzAlignment.Default, false); bgc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False; bgc.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; bgc.DisplayFormat.FormatString = "n2"; bgc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; bgvBangLuong.Columns.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn[] { bgc }); bgc = new BandedGridColumn(); grbPhuCap.Columns.Add(bgc); SetColumnBandCaption(bgc, "Thành tiền", "ThanhTienPhuCap", 120, DevExpress.Utils.HorzAlignment.Default, false); bgc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False; bgc.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; bgc.DisplayFormat.FormatString = "n2"; bgc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; bgvBangLuong.Columns.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn[] { bgc }); } }
private void GetLoaiPhuCap() { pNS_LoaiPhuCapInfo.NS_LoaiPhuCapID = 0; dtLoaiPhuCap = cBNS_LoaiPhuCap.Get(pNS_LoaiPhuCapInfo); grdLoaiPhuCap.DataSource = dtLoaiPhuCap; }