public dlgThemThangRenLuyen(ref DataTable _dtThang)
{
InitializeComponent();
oBSV_ThangRenLuyenTrongKy = new cBSV_ThangRenLuyenTrongKy();
pSV_ThangRenLuyenTrongKyInfo = new SV_ThangRenLuyenTrongKyInfo();
this.DialogResult = DialogResult.Cancel;
dtThang = _dtThang;
}
private void AddBand()
{
BandedGridColumn bgc;
GridBand grbThang;
DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit RepositoryItemCmd;
dtThang = new cBSV_ThangRenLuyenTrongKy().GetByHocKyNamHoc(Program.IDNamHoc, Program.HocKy);
if (dtThang.Rows.Count > 0)
{
foreach (DataRow dr in dtThang.Rows)
{
dtDiemRenLuyen.Columns.Add("SoDiem_" + dr["SV_ThangRenLuyenTrongKyID"], typeof(double));
dtDiemRenLuyen.Columns.Add("XepLoaiRenLuyen_" + dr["SV_ThangRenLuyenTrongKyID"], typeof(int));
grbThang = new GridBand();
grbTheoThang.Children.AddRange(new GridBand[] { grbThang });
// Add cột số điểm của tháng
bgc = new BandedGridColumn();
grbThang.Columns.Add(bgc);
SetColumnBandCaption(bgc, "Số điểm", "SoDiem_" + dr["SV_ThangRenLuyenTrongKyID"], 66, DevExpress.Utils.HorzAlignment.Default, false);
bgc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
bgrvDiemRenLuyen.Columns.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn[] { bgc });
// Add cột xếp loại của tháng
RepositoryItemCmd = new DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit();
bgc = new BandedGridColumn();
bgc.OptionsColumn.AllowEdit = false;
grdDiemRenLuyen.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] {
RepositoryItemCmd
});
bgc.ColumnEdit = RepositoryItemCmd;
// repositoryItemLookUpEdit_XepLoaiRenLuyen
RepositoryItemCmd.AutoHeight = false;
RepositoryItemCmd.Columns.AddRange(new DevExpress.XtraEditors.Controls.LookUpColumnInfo[] {
new DevExpress.XtraEditors.Controls.LookUpColumnInfo("TenXepLoaiRenLuyen", 20, "Xếp loại")
});
RepositoryItemCmd.Name = "RepositoryItemCmd" + dr["SV_ThangRenLuyenTrongKyID"];
RepositoryItemCmd.DataSource = dtXepLoaiRenLuyen;
RepositoryItemCmd.DisplayMember = "TenXepLoaiRenLuyen";
RepositoryItemCmd.ValueMember = "DM_XepLoaiRenLuyenID";
RepositoryItemCmd.NullText = "";
grbThang.Columns.Add(bgc);
SetColumnBandCaption(bgc, "Xếp loại", "XepLoaiRenLuyen_" + dr["SV_ThangRenLuyenTrongKyID"], 100, DevExpress.Utils.HorzAlignment.Default, false);
bgc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
bgrvDiemRenLuyen.Columns.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn[] { bgc });
SetBandCaption(grbThang, "Tháng " + dr["Thang"], 165);
}
}
else
{
grbTheoThang.Visible = false;
}
}
