public static IList <LopInfo> LayDsLop(String namHoc) { LopData m_LData = new LopData(); DataTable m_DT = m_LData.LayDsLopForReport(namHoc); IList <LopInfo> dS = new List <LopInfo>(); foreach (DataRow Row in m_DT.Rows) { LopInfo lop = new LopInfo(); GiaoVienInfo gv = new GiaoVienInfo(); gv.MaGiaoVien = Convert.ToString(Row["MaGiaoVien"]); gv.TenGiaoVien = Convert.ToString(Row["TenGiaoVien"]); KhoiLopInfo kl = new KhoiLopInfo(); kl.MaKhoiLop = Convert.ToString(Row["MaKhoiLop"]); kl.TenKhoiLop = Convert.ToString(Row["TenKhoiLop"]); NamHocInfo nh = new NamHocInfo(); nh.MaNamHoc = Convert.ToString(Row["MaNamHoc"]); nh.TenNamHoc = Convert.ToString(Row["TenNamHoc"]); lop.MaLop = Convert.ToString(Row["MaLop"]); lop.TenLop = Convert.ToString(Row["TenLop"]); lop.KhoiLop = kl; lop.NamHoc = nh; lop.SiSo = Convert.ToInt32(Row["SiSo"]); lop.GiaoVien = gv; dS.Add(lop); } return(dS); }
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="cmb"></param> /// <param name="lopInfo"></param> /// <param name="giaoVien"></param> public void HienThiComboBox(ComboBox cmb, LopInfo lopInfo, GiaoVienInfo giaoVien) { if (this.Data == null) { this.Data = new LopMonHocData(); } cmb.DataSource = this.Data.LayDS(lopInfo, giaoVien, true); cmb.ValueMember = "MaLopMonHoc"; cmb.DisplayMember = "TenMonHoc"; }
/// <summary> /// /// </summary> /// <param name="maGiaoVien"></param> /// <returns></returns> public DataTable LayDS(GiaoVienInfo giaoVienInfo) { if (this.DataService == null) { this.DataService = new DataService(); } SqlCommand cmd = new SqlCommand("SELECT * FROM PHAN_CONG WHERE MaGiaoVien=@maGiaoVien"); cmd.Parameters.Add("maGiaoVien", SqlDbType.VarChar).Value = giaoVienInfo.MaGiaoVien; this.DataService.Load(cmd); return(this.DataService); }
/// <summary> /// /// </summary> /// <param name="lopInfo"></param> /// <param name="giaoVien"></param> /// <param name="layTen"></param> /// <returns></returns> public DataTable LayDS(LopInfo lopInfo, GiaoVienInfo giaoVien, bool layTen) { if (this.DataService == null) { this.DataService = new DataService(); } SqlCommand cmd; if (layTen) { cmd = new SqlCommand("SELECT * FROM LOP_MONHOC A, MON_HOC B WHERE A.MaMonHoc=B.MaMonHoc AND MaLop=@maLop AND MaLopMonHoc IN (SELECT MaLopMonHoc FROM PHAN_CONG WHERE MaGiaoVien=@maGiaoVien)"); cmd.Parameters.Add("maGiaoVien", SqlDbType.VarChar).Value = giaoVien.MaGiaoVien; } else { cmd = new SqlCommand("SELECT * FROM LOP_MONHOC WHERE MaLop=@maLop"); } cmd.Parameters.Add("maLop", SqlDbType.VarChar).Value = lopInfo.MaLop; this.DataService.Load(cmd); return(this.DataService); }
/// <summary> /// /// </summary> /// <param name="maGiaoVien"></param> /// <returns></returns> public GiaoVienInfo LayTuMa(string maGiaoVien) { if (this.Data == null) { this.Data = new GiaoVienData(); } DataTable table = this.Data.LayTuMa(maGiaoVien); if (table.Rows.Count > 0) { GiaoVienInfo info = new GiaoVienInfo(); info.MaGiaoVien = table.Rows[0]["MaGiaoVien"].ToString(); info.HoTen = table.Rows[0]["HoTen"].ToString(); info.GioiTinh = (bool)table.Rows[0]["GioiTinh"]; info.NgaySinh = (DateTime)table.Rows[0]["NgaySinh"]; info.NoiSinh = table.Rows[0]["NoiSinh"].ToString(); info.DiaChi = table.Rows[0]["DiaChi"].ToString(); info.DienThoai = table.Rows[0]["DienThoai"].ToString(); return(info); } return(null); }