public List <Lop_DTO> loadDSLop2(string MaKhoa) { List <Lop_DTO> lsLop = new List <Lop_DTO>(); SqlConnection connect = DataProvider.TaoKetNoi(); string strTruyVan = "SELECT MaLop, TenLop, LichHoc, GioBatDau, MaNV FROM Lop WHERE MaKhoaHoc = @MaKhoaHoc GROUP BY MaLop, TenLop, MaKhoaHoc, LichHoc, GioBatDau, MaNV"; SqlParameter[] parameter = new SqlParameter[1]; parameter[0] = new SqlParameter("@MaKhoaHoc", MaKhoa); SqlDataReader reader = DataProvider.TruyVanDuLieu(strTruyVan, parameter, connect); while (reader.Read()) { Lop_DTO loai = new Lop_DTO() { MaLop = reader["MaLop"].ToString(), TenLop = reader["TenLop"].ToString(), MaNV = reader["MaNV"].ToString(), LichHoc = reader["LichHoc"].ToString(), GioBatDau = reader["GioBatDau"].ToString() }; lsLop.Add(loai); } reader.Close(); connect.Close(); return(lsLop); }
public List <Lop_DTO> LoadDSLop() { List <Lop_DTO> lsLop = new List <Lop_DTO>(); SqlConnection connect = DataProvider.TaoKetNoi(); string strTruyVan = "SELECT * FROM Lop WHERE TrangThai = 1"; SqlDataReader reader = DataProvider.TruyVanDuLieu(strTruyVan, connect); while (reader.Read()) { Lop_DTO loai = new Lop_DTO() { MaLop = reader["MaLop"].ToString(), TenLop = reader["TenLop"].ToString(), MaNV = reader["MaNV"].ToString(), MaPhg = reader["MaPhg"].ToString(), MaKhoaHoc = reader["MaKhoaHoc"].ToString(), LichHoc = reader["LichHoc"].ToString(), GioBatDau = reader["GioBatDau"].ToString(), GioKetThuc = reader["GioKetThuc"].ToString(), //SoHV = int.Parse(reader["SoHV"].ToString()), TrangThai = int.Parse(reader["TrangThai"].ToString()) }; lsLop.Add(loai); } reader.Close(); connect.Close(); return(lsLop); }
private void dgcontrol_lopHoc_Click(object sender, EventArgs e) { if (dgview_lopHoc.SelectedRowsCount > 0) { int[] selectedRows = dgview_lopHoc.GetSelectedRows(); foreach (int rowHandle in selectedRows) { if (rowHandle >= 0) { lopDTO.MaLop = dgview_lopHoc.GetRowCellValue(rowHandle, cl_malop).ToString().Trim(); lopDTO.MaKhoaHoc = dgview_lopHoc.GetRowCellValue(rowHandle, cl_makhoahoc).ToString().Trim(); lopDTO.TenLop = dgview_lopHoc.GetRowCellValue(rowHandle, cl_tenlop).ToString().Trim(); lopDTO.MaNV = dgview_lopHoc.GetRowCellValue(rowHandle, cl_manv).ToString().Trim(); lopDTO.MaPhg = dgview_lopHoc.GetRowCellValue(rowHandle, cl_maphg).ToString().Trim(); lopDTO.LichHoc = dgview_lopHoc.GetRowCellValue(rowHandle, cl_lichhoc).ToString().Trim(); lopDTO.GioBatDau = dgview_lopHoc.GetRowCellValue(rowHandle, cl_giobatdau).ToString().Trim(); lopDTO.GioKetThuc = dgview_lopHoc.GetRowCellValue(rowHandle, cl_gioketthuc).ToString().Trim(); } } } else { lopDTO = null; } BindingChiTiet(); }
public List <Lop_DTO> LayTatCaLop() { List <Lop_DTO> dsLop = new List <Lop_DTO>(); DataTable data = DataProvider.Instance.ExecuteQuery("select Lop.*,TenKhoi,TenGiaoVien,MaGiaoVien from Lop left join Khoi on Khoi.MaKhoi = Lop.MaKhoi left join GVCN on Lop.MaLop = GVCN.MaLop left join GiaoVien on GiaoVien.MaGiaoVien = GVCN.MaGaioVien"); foreach (DataRow row in data.Rows) { Lop_DTO lop = new Lop_DTO(row); dsLop.Add(lop); } return(dsLop); }
public List <Lop_DTO> TimKiemLop(string param) { List <Lop_DTO> dsLop = new List <Lop_DTO>(); string query = string.Format("select Lop.*,TenKhoi,TenGiaoVien,MaGiaoVien from Lop left join Khoi on Khoi.MaKhoi = Lop.MaKhoi left join GVCN on Lop.MaLop = GVCN.MaLop left join GiaoVien on GiaoVien.MaGiaoVien = GVCN.MaGaioVien where TenLop like N'%{0}%'", param); DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow row in data.Rows) { Lop_DTO lop = new Lop_DTO(row); dsLop.Add(lop); } return(dsLop); }
private void LoadDSLop() { Lop_BUS lopBUS = new Lop_BUS(); Lop_DTO lopDAO = new Lop_DTO(); lsLop = lopBUS.DanhSachLop(); lke_lopHoc.Properties.DataSource = lsLop; lke_lopHoc.Properties.DisplayMember = "MaLop"; lke_lopHoc.Properties.ValueMember = "MaLop"; lke_lopHoc.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("MaLop", "Mã Lớp Học", 10)); lke_lopHoc.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("TenLop", "Tên Lớp Học", 20)); }
private void GetDetail() { if (lopDTO != null) { lopDTO = new Lop_DTO(); } lopDTO.MaLop = txt_maLop.Text.Trim(); lopDTO.MaKhoaHoc = lke_makh.Text.Trim(); lopDTO.TenLop = txt_tenLop.Text.Trim(); lopDTO.MaNV = lke_maNhanVien.Text.Trim(); lopDTO.MaPhg = cbo_maPhong.Text.Trim(); lopDTO.LichHoc = cbo_lichHoc.Text.Trim(); lopDTO.GioBatDau = txt_gioBatDau.Text.Trim(); lopDTO.GioKetThuc = txt_gioKetThuc.Text.Trim(); }
private void LoadDSLop() { Lop_BUS lopBUS = new Lop_BUS(); Lop_DTO lopDAO = new Lop_DTO(); lsLop = lopBUS.DanhSachLop(); //cbo_maLop.DataSource = lsLop; //cbo_maLop.DisplayMember = "MaLop"; //cbo_maLop.ValueMember = "MaLop"; //cbo_searchLop.DataSource = lsLop; //cbo_searchLop.DisplayMember = "MaLop"; //cbo_searchLop.ValueMember = "MaLop"; }
public int UpdateLopHoc(Lop_DTO lopDTO) { string update = "UPDATE Lop SET MaLop = @MaLop, TenLop = @TenLop, MaNV = @MaNV, MaPhg = @MaPhg, MaKhoaHoc = @MaKhoaHoc, LichHoc = @LichHoc, GioBatDau = @GioBatDau, GioKetThuc = @GioKetThuc WHERE MaLop = @MaLop"; SqlParameter[] parameter = new SqlParameter[8]; parameter[0] = new SqlParameter("@MaLop", lopDTO.MaLop); parameter[1] = new SqlParameter("@TenLop", lopDTO.TenLop); parameter[2] = new SqlParameter("@MaNV", lopDTO.MaNV); parameter[3] = new SqlParameter("@MaPhg", lopDTO.MaPhg); parameter[4] = new SqlParameter("@MaKhoaHoc", lopDTO.MaKhoaHoc); parameter[5] = new SqlParameter("@LichHoc", lopDTO.LichHoc); parameter[6] = new SqlParameter("@GioBatDau", lopDTO.GioBatDau); parameter[7] = new SqlParameter("@GioKetThuc", lopDTO.GioKetThuc); SqlConnection connect = DataProvider.TaoKetNoi(); int ketQua = DataProvider.ExecuteUpdateQuery(update, parameter, connect); connect.Close(); return(ketQua); }
public int AddLopHoc(Lop_DTO lopDTO) { string insert = "INSERT INTO Lop (MaLop, TenLop, MaNV, MaPhg, MaKhoaHoc, LichHoc, GioBatDau, GioKetThuc, SoHV, TrangThai) VALUES (@MaLop, @TenLop, @MaNV, @MaPhg, @MaKhoaHoc, @LichHoc, @GioBatDau, @GioKetThuc, NULL, 1)"; SqlParameter[] parameter = new SqlParameter[8]; parameter[0] = new SqlParameter("@MaLop", lopDTO.MaLop); parameter[1] = new SqlParameter("@TenLop", lopDTO.TenLop); parameter[2] = new SqlParameter("@MaNV", lopDTO.MaNV); parameter[3] = new SqlParameter("@MaPhg", lopDTO.MaPhg); parameter[4] = new SqlParameter("@MaKhoaHoc", lopDTO.MaKhoaHoc); parameter[5] = new SqlParameter("@LichHoc", lopDTO.LichHoc); parameter[6] = new SqlParameter("@GioBatDau", lopDTO.GioBatDau); parameter[7] = new SqlParameter("@GioKetThuc", lopDTO.GioKetThuc); SqlConnection connect = DataProvider.TaoKetNoi(); int ketQua = DataProvider.ExecuteInsertQuery(insert, parameter, connect); connect.Close(); return(ketQua); }
public int AddLop(Lop_DTO lopDTO) { Lop_DAO lopDAO = new Lop_DAO(); return(lopDAO.AddLopHoc(lopDTO)); }
public int UpdateLop(Lop_DTO lopDTO) { Lop_DAO lopDAO = new Lop_DAO(); return(lopDAO.UpdateLopHoc(lopDTO)); }