public bool CapNhat(ComboBoxEx comboBoxEx_NienHoc, DateTimeInput dateTimeInput_DauNam, DateTimeInput dateTimeInput_Dau_HK1, DateTimeInput dateTimeInput_Cuoi_HK1, DateTimeInput dateTimeInput_Dau_HK2, DateTimeInput dateTimeInput_Cuoi_HK2, DateTimeInput dateTimeInput_CuoiNam)
{
bool ok = false;
// cập nhật thời gian bắt đầu và kết thúc niên học
nienHocInfo = new NienHocInfo(comboBoxEx_NienHoc.SelectedValue.ToString(), comboBoxEx_NienHoc.Text, dateTimeInput_DauNam.Value, dateTimeInput_CuoiNam.Value);
ok = nienHocData.CapNhat(nienHocInfo) >= 0;
// cập nhật những mốc thời gian từng học kỳ
HocKyInfo hocKy1 = new HocKyInfo();
hocKy1.MaNienhoc = comboBoxEx_NienHoc.SelectedValue.ToString();
hocKy1.ThoiGianBatDau = dateTimeInput_Dau_HK1.Value;
hocKy1.ThoiGianKetThuc = dateTimeInput_Cuoi_HK1.Value;
HocKyInfo hocKy2 = new HocKyInfo();
hocKy2.MaNienhoc = comboBoxEx_NienHoc.SelectedValue.ToString();
hocKy2.ThoiGianBatDau = dateTimeInput_Dau_HK2.Value;
hocKy2.ThoiGianKetThuc = dateTimeInput_Cuoi_HK2.Value;
ok = ok && hocKyData.CapNhatHocKy(hocKy1, hocKy2);
return(ok);
}
/// <summary>
///
/// </summary>
/// <param name="dgvDS"></param>
/// <param name="bnDS"></param>
/// <param name="hocKy"></param>
public void HienThiDS(DataGridView dgvDS, BindingNavigator bnDS, HocKyInfo hocKy)
{
if (this.Data == null)
{
this.Data = new DiemData();
}
BindingSource bs = new BindingSource();
bs.DataSource = this.Data.LayDS(hocKy);
dgvDS.DataSource = bs;
bnDS.BindingSource = bs;
}
/// <summary>
///
/// </summary>
/// <param name="hocKy"></param>
/// <returns></returns>
public DataTable LayDS(HocKyInfo hocKy)
{
if (this.DataService == null)
{
this.DataService = new DataService();
}
SqlCommand cmd = new SqlCommand("SELECT * FROM DIEM WHERE MaHocKy=@maHocKy");
cmd.Parameters.Add("maHocKy", SqlDbType.VarChar).Value = hocKy.MaHocKy;
this.DataService.Load(cmd);
return(this.DataService);
}
/// <summary>
///
/// </summary>
/// <param name="phanLop"></param>
/// <param name="monHoc"></param>
/// <param name="hocKy"></param>
/// <returns></returns>
public DataTable LayDS(PhanLopInfo phanLop, MonHocInfo monHoc, HocKyInfo hocKy)
{
if (this.DataService == null)
{
this.DataService = new DataService();
}
SqlCommand cmd = new SqlCommand("SELECT * FROM DIEM WHERE MaHocSinhLop=@maHocSinhLop AND MaMonHoc=@maMonHoc AND MaHocKy=@maHocKy");
cmd.Parameters.Add("maHocSinhlop", SqlDbType.VarChar).Value = phanLop.MaHocSinhLop;
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>
/// Lấy thông tin 2 học kỳ tương ứng với niên học
/// </summary>
/// <param name="maNienHoc"></param>
/// <returns></returns>
public HocKyInfo[] LayThongTinHocKy(string maNienHoc)
{
DataTable table = new HocKyData().BangHocKy(maNienHoc);
HocKyInfo[] hocKyInfo = new HocKyInfo[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
hocKyInfo[i] = new HocKyInfo();
hocKyInfo[i].Id = Convert.ToInt32(table.Rows[i]["ma_hoc_ky"]);
hocKyInfo[i].TenHocKy = Convert.ToString(table.Rows[i]["ten_hoc_ky"]);
hocKyInfo[i].ThoiGianBatDau = Convert.ToDateTime(Convert.ToDateTime(table.Rows[i]["tg_bat_dau"]).ToString("dd/MM/yyyy"));
hocKyInfo[i].ThoiGianKetThuc = Convert.ToDateTime(Convert.ToDateTime(table.Rows[i]["tg_ket_thuc"]).ToString("dd/MM/yyyy"));
hocKyInfo[i].MaNienhoc = Convert.ToString(table.Rows[i]["ma_nien_hoc"]);
}
return(hocKyInfo);
}
public static IList <KQHocKyTongHopInfo> LayDsKQHocKyTongHop(String maLop, String maHocKy, String maNamHoc)
{
KQHocKyTongHopData m_KQHKTHData = new KQHocKyTongHopData();
DataTable m_DT = m_KQHKTHData.LayDsKQHocKyTongHopForReport(maLop, maHocKy, maNamHoc);
IList <KQHocKyTongHopInfo> dS = new List <KQHocKyTongHopInfo>();
foreach (DataRow Row in m_DT.Rows)
{
KQHocKyTongHopInfo ketqua = new KQHocKyTongHopInfo();
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"]);
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"]);
HocLucInfo hl = new HocLucInfo();
hl.MaHocLuc = Convert.ToString(Row["MaHocLuc"]);
hl.TenHocLuc = Convert.ToString(Row["TenHocLuc"]);
HanhKiemInfo hkiem = new HanhKiemInfo();
hkiem.MaHanhKiem = Convert.ToString(Row["MaHanhKiem"]);
hkiem.TenHanhKiem = Convert.ToString(Row["TenHanhKiem"]);
ketqua.HocSinh = hs;
ketqua.Lop = l;
ketqua.HocKy = hk;
ketqua.NamHoc = nh;
ketqua.HocLuc = hl;
ketqua.HanhKiem = hkiem;
ketqua.DTBMonHocKy = Convert.ToSingle(Row["DTBMonHocKy"]);
dS.Add(ketqua);
}
return(dS);
}
public HocKyInfo LayTuMa(string maHocKy)
{
if (this.Data == null)
{
this.Data = new HocKyData();
}
DataTable table = this.Data.LayTuMa(maHocKy);
if (table.Rows.Count > 0)
{
HocKyInfo hocKyInfo = new HocKyInfo();
hocKyInfo.MaHocKy = table.Rows[0]["MaHocKy"].ToString();
hocKyInfo.TenHocKy = table.Rows[0]["TenHocKy"].ToString();
hocKyInfo.HeSo = int.Parse(table.Rows[0]["HeSo"].ToString());
return(hocKyInfo);
}
return(null);
}
/// <summary>
/// Cập nhật học kỳ
/// </summary>
/// <param name="hocKyInfo"></param>
/// <returns></returns>
public bool CapNhatHocKy(HocKyInfo hocKyInfo1, HocKyInfo hocKyInfo2)
{
mySqlCommand = new MySqlCommand();
string mySQLQuery1 = "update hoc_ky set tg_bat_dau=@tgbatdau1, tg_ket_thuc=@tgketthuc1 where ma_nien_hoc = @manienhoc and ten_hoc_ky like 'Học kỳ 1';";
string mySQLQuery2 = "update hoc_ky set tg_bat_dau=@tgbatdau2, tg_ket_thuc=@tgketthuc2 where ma_nien_hoc = @manienhoc and ten_hoc_ky like 'Học kỳ 2';";
mySqlCommand.CommandText = mySQLQuery1 + mySQLQuery2;
mySqlCommand.Parameters.Add("@manienhoc", MySqlDbType.VarChar, 6).Value = hocKyInfo1.MaNienhoc;
mySqlCommand.Parameters.Add("@tgbatdau1", MySqlDbType.Date).Value = hocKyInfo1.ThoiGianBatDau;
mySqlCommand.Parameters.Add("@tgketthuc1", MySqlDbType.Date).Value = hocKyInfo1.ThoiGianKetThuc;
mySqlCommand.Parameters.Add("@tgbatdau2", MySqlDbType.Date).Value = hocKyInfo2.ThoiGianBatDau;
mySqlCommand.Parameters.Add("@tgketthuc2", MySqlDbType.Date).Value = hocKyInfo2.ThoiGianKetThuc;
try
{
DataServices.OpenConnection(true);
return(dataServices.ExecuteUpdate(mySqlCommand) > 0);
}
catch { return(false); }
}
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);
}
