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