private void AddBand()
{
BandedGridColumn bgc;
KQHT_ThanhPhanDiemInfo pKQHT_ThanPhanDiemInfo = new KQHT_ThanhPhanDiemInfo();
cBKQHT_ThanhPhanDiem oBKQHT_ThanhPhanDiem = new cBKQHT_ThanhPhanDiem();
dtThanhPhan = oBKQHT_ThanhPhanDiem.Get(pKQHT_ThanPhanDiemInfo);
grbNhapDiem.Columns.Clear();
if ((dtThanhPhan != null) && (dtThanhPhan.Rows.Count > 0))
{
DataRow[] drThanhPhan = dtThanhPhan.Select("Thi=0");
foreach (DataRow dr in drThanhPhan)
{
dtSinhVien.Columns.Add(dr["KQHT_ThanhPhanDiemID"].ToString(), typeof(float));
bgc = new BandedGridColumn();
grbNhapDiem.Columns.Add(bgc);
SetColumnBandCaption(bgc, dr["KyHieu"].ToString(), dr["KQHT_ThanhPhanDiemID"].ToString(), 70, DevExpress.Utils.HorzAlignment.Default, false);
bgc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
bgc.OptionsColumn.AllowEdit = false;
bgc.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
bgc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
bgvDiem.Columns.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn[] { bgc });
}
}
}
public frmThanhPhanDiem()
{
InitializeComponent();
oBKQHT_ThanhPhanDiem = new cBKQHT_ThanhPhanDiem();
pKQHT_ThanhPhanDiemInfo = new KQHT_ThanhPhanDiemInfo();
SetBarButton(false);
panelTop.Visible = false;
}
private void dlgCongThucDiem_Load(object sender, EventArgs e)
{
cBKQHT_ThanhPhanDiem oBKQHT_ThanhPhanDiem = new cBKQHT_ThanhPhanDiem();
dtThanhPhan = oBKQHT_ThanhPhanDiem.GetLapCongThuc();
grdThanhPhanDiem.DataSource = dtThanhPhan;
if (edit == EDIT_MODE.THEM)
{
dtMonHoc = oBKQHT_CongThucDiem.GetMonChuaToChuc(IDDM_Lop, Program.IDNamHoc, Program.HocKy, 0);
cmbMonHoc.Properties.DataSource = dtMonHoc;
}
else
{
oBKQHT_CongThucDiem.ToInfo(ref pKQHT_CongThucDiemInfo, drCongThuc);
cmbMonHoc.Properties.DataSource = oBKQHT_CongThucDiem.GetMonChuaToChuc(IDDM_Lop, Program.IDNamHoc, Program.HocKy, pKQHT_CongThucDiemInfo.IDDM_MonHoc);
cmbMonHoc.EditValue = pKQHT_CongThucDiemInfo.IDDM_MonHoc;
txtCongThuc.Text = pKQHT_CongThucDiemInfo.CongThuc;
}
}
private void AddBand()
{
BandedGridColumn bgc;
KQHT_ThanhPhanDiemInfo pKQHT_ThanPhanDiemInfo = new KQHT_ThanhPhanDiemInfo();
cBKQHT_ThanhPhanDiem oBKQHT_ThanhPhanDiem = new cBKQHT_ThanhPhanDiem();
dtThanhPhan = oBKQHT_ThanhPhanDiem.GetByIDTrinhDo(pDM_LopInfo.IDDM_TrinhDo);
// dtThanhPhan = oBKQHT_CongThucDiem.GetMon(IDDM_Lop, Program.IDNamHoc, Program.HocKy, int.Parse(cmbMonHoc.EditValue.ToString()));
grbNhapDiem.Columns.Clear();
if ((dtThanhPhan != null) && (dtThanhPhan.Rows.Count > 0))
{
foreach (DataRow dr in dtThanhPhan.Rows)
{
dtSinhVien.Columns.Add(dr["KQHT_ThanhPhanDiemID"].ToString(), typeof(float));
bgc = new BandedGridColumn();
grbNhapDiem.Columns.Add(bgc);
SetColumnBandCaption(bgc, dr["KyHieu"].ToString(), dr["KQHT_ThanhPhanDiemID"].ToString(), 60, DevExpress.Utils.HorzAlignment.Default, false);
bgc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
bgc.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
bgc.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bgc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
bgvDiem.Columns.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn[] { bgc });
}
}
//dtSinhVien.Columns.Add("TK", typeof(float));
//bgc = new BandedGridColumn();
//grbNhapDiem.Columns.Add(bgc);
//SetColumnBandCaption(bgc, "Tổng kết", "TK", 80, DevExpress.Utils.HorzAlignment.Default, false);
//bgc.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
//bgc.OptionsColumn.AllowEdit = false;
//bgc.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
//bgc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
//bgvDiem.Columns.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn[] { bgc });
}
private void AddBand()
{
KQHT_ThanhPhanDiemInfo pKQHT_ThanPhanDiemInfo = new KQHT_ThanhPhanDiemInfo();
cBKQHT_ThanhPhanDiem oBKQHT_ThanhPhanDiem = new cBKQHT_ThanhPhanDiem();
dtThanhPhan = oBKQHT_ThanhPhanDiem.GetByIDTrinhDo(pDM_LopInfo.IDDM_TrinhDo);
if ((dtThanhPhan != null) && (dtThanhPhan.Rows.Count > 0))
{
foreach (DataRow dr in dtThanhPhan.Rows)
{
if ("" + dr["CongThucDiem"] == "")
{
// Begin Add TenThanhPhanDiem
if (!bool.Parse(dr["Thi"].ToString()))
{
// Nếu không phải là thành phần thi
if (int.Parse(dr["SoDiem"].ToString()) == 1)
{
dtSinhVien.Columns.Add(dr["KQHT_ThanhPhanDiemID"].ToString() + "_1", typeof(double));
ColEnd++;
}
else
{
for (int i = 1; i <= int.Parse(dr["SoDiem"].ToString()); i++)
{
dtSinhVien.Columns.Add(dr["KQHT_ThanhPhanDiemID"].ToString() + "_" + i.ToString(), typeof(double));
ColEnd++;
}
}
}
else
{
// Nếu là thành phần thi
IDThanhPhanThi = dr["KQHT_ThanhPhanDiemID"].ToString();
SoLanThi = int.Parse(dr["SoLanThi"].ToString());
for (int i = 1; i <= SoLanThi; i++)
{
dtSinhVien.Columns.Add(dr["KQHT_ThanhPhanDiemID"].ToString() + "_" + i.ToString(), typeof(double));
ColEnd++;
}
}
// End Add TenThanhPhanDiem
}
else
{
IDKQHT_ThanhPhanTBHS = int.Parse(dr["KQHT_ThanhPhanDiemID"].ToString());
}
}
if (IDKQHT_ThanhPhanTBHS > 0)
{
DataRow[] arrDr = dtThanhPhan.Select("KQHT_ThanhPhanDiemID = " + IDKQHT_ThanhPhanTBHS.ToString());
dtSinhVien.Columns.Add(IDKQHT_ThanhPhanTBHS.ToString() + "_1", typeof(double));
}
// Add cột lý do không được dự thi vào
dtSinhVien.Columns.Add("LyDo", typeof(string));
// Add cột điểm trung bình môn học
for (int i = 1; i <= SoLanThi; i++)
{
dtSinhVien.Columns.Add("TK_" + i.ToString(), typeof(double));
dtSinhVien.Columns.Add("IDKQHT_XepLoai_" + i.ToString(), typeof(int));
if (i > 1)
{
dtSinhVien.Columns.Add(IDKQHT_ThanhPhanTBHS.ToString() + "_" + i.ToString(), typeof(double));
}
}
}
}
