public static IList <GiaoVienInfo> LayDsGiaoVien() { GiaoVienData m_GVData = new GiaoVienData(); DataTable m_DT = m_GVData.LayDsGiaoVienForReport(); IList <GiaoVienInfo> dS = new List <GiaoVienInfo>(); foreach (DataRow Row in m_DT.Rows) { GiaoVienInfo gv = new GiaoVienInfo(); MonHocInfo mh = new MonHocInfo(); mh.MaMonHoc = Convert.ToString(Row["MaMonHoc"]); mh.TenMonHoc = Convert.ToString(Row["TenMonHoc"]); mh.SoTiet = Convert.ToInt32(Row["SoTiet"]); mh.HeSo = Convert.ToInt32(Row["HeSo"]); gv.MaGiaoVien = Convert.ToString(Row["MaGiaoVien"]); gv.TenGiaoVien = Convert.ToString(Row["TenGiaoVien"]); gv.DiaChi = Convert.ToString(Row["DiaChi"]); gv.DienThoai = Convert.ToString(Row["DienThoai"]); gv.MonHoc = mh; dS.Add(gv); } return(dS); }
/// <summary> /// /// </summary> /// <param name="lvDS"></param> public void HienThiDS(ListView lvDS, LopInfo lopInfo) { if (this.Data == null) { this.Data = new MonHocData(); } DataTable table = this.Data.LayDS(lopInfo); lvDS.Items.Clear(); foreach (DataRow row in table.Rows) { MonHocInfo info = new MonHocInfo(); info.MaMonHoc = row["MaMonHoc"].ToString(); info.TenMonHoc = row["TenMonHoc"].ToString(); info.SoTiet = int.Parse(row["SoTiet"].ToString()); info.HeSo = int.Parse(row["HeSo"].ToString()); ListViewItem item = new ListViewItem(); item.Text = info.TenMonHoc; item.SubItems.Add(info.MaMonHoc); item.SubItems.Add(info.SoTiet.ToString()); item.SubItems.Add(info.HeSo.ToString()); object[] tag = new object[2]; tag[0] = info; tag[1] = row; item.Tag = tag; lvDS.Items.Add(item); } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void cmbMonHoc_SelectedIndexChanged(object sender, EventArgs e) { if (this.cmbMonHoc.SelectedIndex != -1) { MonHocInfo info = new MonHocInfo(); info.MaMonHoc = ((DataRowView)this.cmbMonHoc.SelectedItem).Row.ItemArray[2].ToString(); this.GiaoVienController.HienThiComboBox(this.cmbGiaoVien, info); } }
/// <summary> /// /// </summary> /// <param name="cmb"></param> /// <param name="monHocInfo"></param> public void HienThiComboBox(ComboBox cmb, MonHocInfo monHocInfo) { if (this.Data == null) { this.Data = new GiaoVienData(); } cmb.DataSource = this.Data.LayDS(monHocInfo); cmb.DisplayMember = "HoTen"; cmb.ValueMember = "MaGiaoVien"; }
/// <summary> /// /// </summary> /// <param name="col"></param> /// <param name="monHocInfo"></param> public void HienThiDataGridComboBoxColumn(DataGridViewComboBoxColumn col, MonHocInfo monHocInfo) { if (this.Data == null) { this.Data = new GiaoVienData(); } col.DataSource = this.Data.LayDS(monHocInfo); col.DisplayMember = "HoTen"; col.ValueMember = "MaGiaoVien"; col.DataPropertyName = "MaGiaoVien"; }
/// <summary> /// /// </summary> /// <param name="dgvDS"></param> /// <param name="bnDS"></param> /// <param name="monHoc"></param> /// <param name="hocKy"></param> public void HienThiDS(DataGridView dgvDS, BindingNavigator bnDS, MonHocInfo monHoc, HocKyInfo hocKy) { if (this.Data == null) { this.Data = new DiemData(); } BindingSource bs = new BindingSource(); bs.DataSource = this.Data.LayDS(monHoc, hocKy); dgvDS.DataSource = bs; bnDS.BindingSource = bs; }
/// <summary> /// /// </summary> /// <param name="monHocInfo"></param> /// <returns></returns> public DataTable LayDS(MonHocInfo monHocInfo) { if (this.DataService == null) { this.DataService = new DataService(); } SqlCommand cmd = new SqlCommand("SELECT * FROM GIAO_VIEN WHERE MaMonHoc=@maMonHoc"); cmd.Parameters.Add("maMonHoc", SqlDbType.VarChar).Value = monHocInfo.MaMonHoc; this.DataService.Load(cmd); return(this.DataService); }
/// <summary> /// /// </summary> /// <param name="monHoc"></param> /// <param name="hocKy"></param> /// <returns></returns> public DataTable LayDS(MonHocInfo monHoc, HocKyInfo hocKy) { if (this.DataService == null) { this.DataService = new DataService(); } SqlCommand cmd = new SqlCommand("SELECT * FROM DIEM WHERE MaMonHoc=@maMonHoc AND MaHocKy=@maHocKy"); cmd.Parameters.Add("maMonHoc", SqlDbType.VarChar).Value = monHoc.MaMonHoc; cmd.Parameters.Add("maHocKy", SqlDbType.VarChar).Value = hocKy.MaHocKy; this.DataService.Load(cmd); return(this.DataService); }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btThem_Click(object sender, EventArgs e) { DataRow row = this.PhanCongController.Data.DataService.NewRow(); row["MaLopMonHoc"] = int.Parse(this.cmbMonHoc.SelectedValue.ToString()); row["MaGiaoVien"] = this.cmbGiaoVien.SelectedValue.ToString(); this.PhanCongController.Data.DataService.Rows.Add(row); this.PhanCongController.Update(); this.LopMonHocController.HienThiComboBoxDSChuaPhanCong(this.cmbMonHoc, this.MaLop); if (this.cmbMonHoc.Items.Count > 0) { MonHocInfo infoMonHoc = new MonHocInfo(); infoMonHoc.MaMonHoc = ((DataRowView)this.cmbMonHoc.SelectedItem).Row.ItemArray[2].ToString(); this.GiaoVienController.HienThiComboBox(this.cmbGiaoVien, infoMonHoc); } }
public static IList <KQHocKyMonHocInfo> LayDsKQHocKyMonHoc(String maLop, String maMonHoc, String maHocKy, String maNamHoc) { KQHocKyMonHocData m_KQHKMHData = new KQHocKyMonHocData(); DataTable m_DT = m_KQHKMHData.LayDsKQHocKyMonHocForReport(maLop, maMonHoc, maHocKy, maNamHoc); IList <KQHocKyMonHocInfo> dS = new List <KQHocKyMonHocInfo>(); foreach (DataRow Row in m_DT.Rows) { KQHocKyMonHocInfo ketqua = new KQHocKyMonHocInfo(); HocSinhInfo hs = new HocSinhInfo(); hs.MaHocSinh = Convert.ToString(Row["MaHocSinh"]); hs.HoTen = Convert.ToString(Row["HoTen"]); LopInfo l = new LopInfo(); l.MaLop = Convert.ToString(Row["MaLop"]); l.TenLop = Convert.ToString(Row["TenLop"]); MonHocInfo mh = new MonHocInfo(); mh.MaMonHoc = Convert.ToString(Row["MaMonHoc"]); mh.TenMonHoc = Convert.ToString(Row["TenMonHoc"]); HocKyInfo hk = new HocKyInfo(); hk.MaHocKy = Convert.ToString(Row["MaHocKy"]); hk.TenHocKy = Convert.ToString(Row["TenHocKy"]); NamHocInfo nh = new NamHocInfo(); nh.MaNamHoc = Convert.ToString(Row["MaNamHoc"]); nh.TenNamHoc = Convert.ToString(Row["TenNamHoc"]); ketqua.HocSinh = hs; ketqua.Lop = l; ketqua.MonHoc = mh; ketqua.HocKy = hk; ketqua.NamHoc = nh; ketqua.DTBKiemTra = Convert.ToSingle(Row["DTBKiemTra"]); ketqua.DTBMonHocKy = Convert.ToSingle(Row["DTBMonHocKy"]); dS.Add(ketqua); } return(dS); }
/// <summary> /// /// </summary> /// <param name="maMonHoc"></param> /// <returns></returns> public MonHocInfo LayTuMa(string maMonHoc) { if (this.Data == null) { this.Data = new MonHocData(); } DataTable table = this.Data.LayTuMa(maMonHoc); if (table.Rows.Count > 0) { MonHocInfo info = new MonHocInfo(); info.MaMonHoc = table.Rows[0]["MaMonHoc"].ToString(); info.TenMonHoc = table.Rows[0]["TenMonHoc"].ToString(); info.SoTiet = int.Parse(table.Rows[0]["SoTiet"].ToString()); info.HeSo = int.Parse(table.Rows[0]["HeSo"].ToString()); return(info); } return(null); }