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