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;
}
