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