private void dgcontrol_thoiKhoaBieu_Click(object sender, EventArgs e)
{
if (dgview_thoiKhoaBieu.SelectedRowsCount > 0)
{
int[] selectedRows = dgview_thoiKhoaBieu.GetSelectedRows();
foreach (int rowHandle in selectedRows)
{
if (rowHandle >= 0)
{
tkbDTO.MaLop = dgview_thoiKhoaBieu.GetRowCellValue(rowHandle, cl_malop).ToString().Trim();
tkbDTO.MaPhg = dgview_thoiKhoaBieu.GetRowCellValue(rowHandle, cl_maphg).ToString().Trim();
tkbDTO.MaNV = dgview_thoiKhoaBieu.GetRowCellValue(rowHandle, cl_manv).ToString().Trim();
tkbDTO.Thu = dgview_thoiKhoaBieu.GetRowCellValue(rowHandle, cl_thu).ToString().Trim();
tkbDTO.Ngay = dgview_thoiKhoaBieu.GetRowCellValue(rowHandle, cl_ngay).ToString().Trim();
tkbDTO.Thang = dgview_thoiKhoaBieu.GetRowCellValue(rowHandle, cl_thang).ToString().Trim();
tkbDTO.Nam = dgview_thoiKhoaBieu.GetRowCellValue(rowHandle, cl_nam).ToString().Trim();
}
}
}
else
{
tkbDTO = null;
}
BindingChiTiet();
}
public List <TKB_DTO> LoadTKB(string malop)
{
SqlConnection connect = DataProvider.TaoKetNoi();
List <TKB_DTO> lsTKB = new List <TKB_DTO>();
string truyVan = "SELECT Lop.MaLop, Lop.MaPhg, Lop.MaNV, ThoiKhoaBieu.Thu, ThoiKhoaBieu.Ngay, ThoiKhoaBieu.Thang, ThoiKhoaBieu.Nam FROM ThoiKhoaBieu RIGHT JOIN Lop ON ThoiKhoaBieu.MaLop = Lop.MaLop WHERE Lop.MaLop = @MaLop";
SqlParameter[] par = new SqlParameter[1];
par[0] = new SqlParameter("@MaLop", malop);
SqlDataReader reader = DataProvider.TruyVanDuLieu(truyVan, par, connect);
while (reader.Read())
{
TKB_DTO tkb = new TKB_DTO();
tkb.MaLop = reader["MaLop"].ToString().Trim();
tkb.MaPhg = reader["MaPhg"].ToString().Trim();
tkb.MaNV = reader["MaNV"].ToString().Trim();
tkb.Thu = Utilities.ConvertToString(reader["Thu"].ToString(), "0");
tkb.Ngay = Utilities.ConvertToString(reader["Ngay"].ToString(), "0");
tkb.Thang = Utilities.ConvertToString(reader["Thang"].ToString(), "0");
tkb.Nam = Utilities.ConvertToString(reader["Nam"].ToString(), "0");
lsTKB.Add(tkb);
}
reader.Close();
connect.Close();
return(lsTKB);
}
private void GetTKB()
{
if (tkbDTO != null)
{
tkbDTO = new TKB_DTO();
}
tkbDTO.MaLop = lke_maLop.Text;
tkbDTO.MaPhg = txt_maphg.Text;
tkbDTO.MaNV = txt_manv.Text;
tkbDTO.Thu = cb_thu.Text;
tkbDTO.Ngay = cb_ngay.Text;
tkbDTO.Thang = cb_thang.Text;
tkbDTO.Nam = txt_nam.Text;
}
public int AddTKB(TKB_DTO tkb)
{
string insert = "INSERT INTO ThoiKhoaBieu (MaLop, MaPhg, MaNV, Thu, Ngay, Thang, Nam, TrangThai) VALUES(@MaLop, @MaPhg, @MaNV, @Thu, @Ngay, @Thang, @Nam, 1)";
SqlParameter[] par = new SqlParameter[7];
par[0] = new SqlParameter("@MaLop", tkb.MaLop);
par[1] = new SqlParameter("@MaPhg", tkb.MaPhg);
par[2] = new SqlParameter("@MaNV", tkb.MaNV);
par[3] = new SqlParameter("@Thu", tkb.Thu);
par[4] = new SqlParameter("@Ngay", tkb.Ngay);
par[5] = new SqlParameter("@Thang", tkb.Thang);
par[6] = new SqlParameter("@Nam", tkb.Nam);
SqlConnection connect = DataProvider.TaoKetNoi();
int ketQua = DataProvider.ExecuteInsertQuery(insert, par, connect);
connect.Close();
return(ketQua);
}
public int AddTKB(TKB_DTO diem)
{
TKB_DAO tkbDAO = new TKB_DAO();
return(tkbDAO.AddTKB(diem));
}