/// <summary> /// Tra cứu thông tin các laptop thao nhiều tiêu chí /// </summary> /// <param name="infoCombobox">thông tin tiêu chí cần tra cứu</param> /// <returns>danh sách các laptop kết quả </returns> public List <myChiTietDongLaptopDTO> TraCuu(InfoComboboxOfFormTraCuu infoCombobox) { myChiTietDongLaptopDAO chiTietlapTop = new myChiTietDongLaptopDAO(); return(chiTietlapTop.TraCuu(infoCombobox)); }
/// <summary> /// Xử lý việc tra cứu sản phẩm từ CSDL lên DataGridView /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button_OK_XoaSanPham_Click(object sender, EventArgs e) { MyChiTietDongLaptopBUS ChiTietDongLapTop = new MyChiTietDongLaptopBUS(); List <myChiTietDongLaptopDTO> dsLapTop = new List <myChiTietDongLaptopDTO>(); InfoComboboxOfFormTraCuu Infocombobox = new InfoComboboxOfFormTraCuu(); // Kiểm tra thông tin các combobox #region Info Combobox if (string.Compare(Combobox_TenDongLapTop.Text, "--Không quan tâm--") != 0) { Infocombobox.STendongLapTop = Combobox_TenDongLapTop.Text; } if (string.Compare(comboBox_Ram.Text, "--Không quan tâm--") != 0) { Infocombobox.SRam = comboBox_Ram.Text; } if (string.Compare(comboBox_CPU.Text, "--Không quan tâm--") != 0) { Infocombobox.SCPU = comboBox_CPU.Text; } if (string.Compare(comboBox_HardDisk.Text, "--Không quan tâm--") != 0) { Infocombobox.SOCung = comboBox_HardDisk.Text; } if (string.Compare(comboBox_ManHinh.Text, "--Không quan tâm--") != 0) { Infocombobox.SManHinh = comboBox_ManHinh.Text; } if (string.Compare(comboBox_CardManHinh.Text, "--Không quan tâm--") != 0) { Infocombobox.SCardManHinh = comboBox_CardManHinh.Text; } if (string.Compare(comboBox_Loa.Text, "--Không quan tâm--") != 0) { Infocombobox.SDongLoa = comboBox_Loa.Text; } if (string.Compare(comboBox_ODiaQuang.Text, "--Không quan tâm--") != 0) { Infocombobox.SOQuang = comboBox_ODiaQuang.Text; } if (string.Compare(comboBox_HeDieuHanh.Text, "--Không quan tâm--") != 0) { Infocombobox.SHeDieuHanh = comboBox_HeDieuHanh.Text; } if (string.Compare(comboBox_TrongLuong.Text, "--Không quan tâm--") != 0) { Infocombobox.FTrongLuong = float.Parse(comboBox_TrongLuong.Text); } if (string.Compare(comboBox_MauSac.Text, "--Không quan tâm--") != 0) { Infocombobox.SMauSac = comboBox_MauSac.Text; } if (string.Compare(comboBox_CardMang.Text, "--Không quan tâm--") != 0) { Infocombobox.SCardMang = comboBox_CardMang.Text; } if (string.Compare(comboBox_CardReader.Text, "--Không quan tâm--") != 0) { Infocombobox.SCardReader = comboBox_CardReader.Text; } if (string.Compare(comboBox_Webcam.Text, "--Không quan tâm--") != 0) { Infocombobox.SWebCam = comboBox_Webcam.Text; } if (string.Compare(comboBox_Pin.Text, "--Không quan tâm--") != 0) { Infocombobox.SPin = comboBox_Pin.Text; } if (string.Compare(comboBox_NhanDangVanTay.Text, "--Không quan tâm--") != 0) { Infocombobox.SNhanDangVanTay = comboBox_NhanDangVanTay.Text; } if (string.Compare(comboBox_HDMI.Text, "--Không quan tâm--") != 0) { Infocombobox.SCongHDMI = comboBox_HDMI.Text; } if (string.Compare(comboBox_SoCongUSB.Text, "--Không quan tâm--") != 0) { Infocombobox.ISoCongUSB = int.Parse(comboBox_SoCongUSB.Text); } if (string.Compare(comboBox_NhaSanXuat.Text, "--Không quan tâm--") != 0) { Infocombobox.SNhaSanXuat = comboBox_NhaSanXuat.Text; } if (string.Compare(comboBox_GiaBan.Text, "--Không quan tâm--") != 0) { Infocombobox.SGiaBan = comboBox_GiaBan.Text; } if (string.Compare(comboBox_ThoiGianBaoHanh.Text, "--Không quan tâm--") != 0) { Infocombobox.IThoigianBH = int.Parse(comboBox_ThoiGianBaoHanh.Text); } #endregion if (string.Compare(Infocombobox.STendongLapTop, null) == 0 && string.Compare(Infocombobox.SRam, null) == 0 && string.Compare(Infocombobox.SCPU, null) == 0 && string.Compare(Infocombobox.SOCung, null) == 0 && string.Compare(Infocombobox.SManHinh, null) == 0 && string.Compare(Infocombobox.SCardManHinh, null) == 0 && string.Compare(Infocombobox.SDongLoa, null) == 0 && string.Compare(Infocombobox.SOQuang, null) == 0 && string.Compare(Infocombobox.SHeDieuHanh, null) == 0 && Infocombobox.FTrongLuong == 0 && string.Compare(Infocombobox.SMauSac, null) == 0 && string.Compare(Infocombobox.SCardMang, null) == 0 && string.Compare(Infocombobox.SCardReader, null) == 0 && string.Compare(Infocombobox.SWebCam, null) == 0 && string.Compare(Infocombobox.SPin, null) == 0 && string.Compare(Infocombobox.SNhanDangVanTay, null) == 0 && string.Compare(Infocombobox.SCongHDMI, null) == 0 && Infocombobox.ISoCongUSB == 0 && string.Compare(Infocombobox.SNhaSanXuat, null) == 0 && string.Compare(Infocombobox.SGiaBan, null) == 0 && Infocombobox.IThoigianBH == 0) { MessageBox.Show("Vui lòng chọn thông tin trước khi tra cứu !!!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } dsLapTop = ChiTietDongLapTop.TraCuu(Infocombobox); gridTraCuu.Rows.Clear(); if (dsLapTop == null || dsLapTop.Count == 0) { MessageBox.Show("Không tìm thấy thông tin tra cứu !!!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } RutGonDanhSach(dsLapTop); for (int i = 0; i < dsLapTop.Count; i++) { #region DataGridview Tra Cứu gridTraCuu.Rows.Add(dsLapTop[i].STenChiTietDongLapTop, dsLapTop[i].ChiTietDongRam.STenDongRAM, dsLapTop[i].ChiTietDongCPU.STenDongCPU, dsLapTop[i].ChiTietDongOCung.STenDongOCung, dsLapTop[i].ChiTietDongManHinh.STenDongManHinh, dsLapTop[i].ChiTietDongCacDoHoa.STenDongCardDoHoa, dsLapTop[i].ChiTietDongLoa.STenDongLoa, dsLapTop[i].ChiTietDongODiaQuang.STenDongODiaQuang, dsLapTop[i].ChiTietHeDieuHanh.STenHeDieuHanh, dsLapTop[i].ChiTietTrongLuong.FGiaTriTrongLuong, dsLapTop[i].SMauSac, dsLapTop[i].ChiTietDongCardMang.STenDongCardMang, dsLapTop[i].ChiTietDongCardReader.STenDongCardReader, dsLapTop[i].ChiTietDongWebCam.STenDongWebCam, dsLapTop[i].ChiTietDongPin.FThoiGianSuDung, Convert.ToBoolean(dsLapTop[i].BFingerprintReader), Convert.ToBoolean(dsLapTop[i].BHDMI), dsLapTop[i].ISoLuongCongUSB, dsLapTop[i].NhaSanXuat.STenNhaSanXuat, dsLapTop[i].FGiaBanHienHanh, dsLapTop[i].IThoiGianBaoHanh, dsLapTop[i].DanhGia.ITongDiem); #endregion } }
/// <summary> /// Tra cứu thông tin các laptop thỏa yêu cầu của người dùng /// </summary> /// <param name="infoCombobox">Thông tin tiêu chí tra cứu của người dùng</param> /// <returns></returns> public List <myChiTietDongLaptopDTO> TraCuu(InfoComboboxOfFormTraCuu infoCombobox) { try { List <myChiTietDongLaptopDTO> danhsachChiTietDongLapTop = new List <myChiTietDongLaptopDTO>(); DataClasses1DataContext m_EStore = new DataClasses1DataContext(); int flag = 0; string sql = "select * from ChiTietDongLapTop where "; if (string.Compare(infoCombobox.STendongLapTop, null) != 0) { sql += "TenChiTietDongLapTop=N'" + infoCombobox.STendongLapTop + "' "; flag = 1; } if (string.Compare(infoCombobox.SRam, null) != 0) { int maDongRam = myChiTietDongRamDAO.LayMaDongRam(infoCombobox.SRam); if (flag == 0) { sql += "MaDongRam=" + maDongRam.ToString() + " "; flag = 1; } else if (flag == 1) { sql += "and MaDongRam=" + maDongRam.ToString() + " "; flag = 1; } } if (string.Compare(infoCombobox.SCPU, null) != 0) { int maDongCPU = myChiTietDongCPUDAO.LayMaDongCPU(infoCombobox.SCPU); if (flag == 0) { sql += "MaDongCPU=" + maDongCPU.ToString() + " "; flag = 1; } else if (flag == 1) { sql += "and MaDongCPU=" + maDongCPU.ToString() + " "; flag = 1; } } if (string.Compare(infoCombobox.SOCung, null) != 0) { int maDong = myChiTietDongOCungDAO.LayMaDongOCung(infoCombobox.SOCung); if (flag == 0) { sql += "MaDongOCung=" + maDong.ToString() + " "; flag = 1; } else if (flag == 1) { sql += "and MaDongOCung=" + maDong.ToString() + " "; flag = 1; } } if (string.Compare(infoCombobox.SManHinh, null) != 0) { int maDong = myChiTietDongManHinhDAO.LayMaDongManHinh(infoCombobox.SManHinh); if (flag == 0) { sql += "MaDongManHinh=" + maDong.ToString() + " "; flag = 1; } else if (flag == 1) { sql += "and MaDongManHinh=" + maDong.ToString() + " "; flag = 1; } } if (string.Compare(infoCombobox.SCardManHinh, null) != 0) { int maDong = myChiTietDongCardDoHoaDAO.LayMaDongCardDoHoa(infoCombobox.SCardManHinh); if (flag == 0) { sql += "MaDongCardDoHoa=" + maDong.ToString() + " "; flag = 1; } else if (flag == 1) { sql += "and MaDongCardDoHoa=" + maDong.ToString() + " "; flag = 1; } } if (string.Compare(infoCombobox.SDongLoa, null) != 0) { int maDong = myChiTietDongLoaDAO.LayMaDongLoa(infoCombobox.SDongLoa); if (flag == 0) { sql += "MaDongLoa=" + maDong.ToString() + " "; flag = 1; } else if (flag == 1) { sql += "and MaDongLoa=" + maDong.ToString() + " "; flag = 1; } } if (string.Compare(infoCombobox.SOQuang, null) != 0) { int maDong = myChiTietDongODiaQuangDAO.LayMaDongODiaQuang(infoCombobox.SOQuang); if (flag == 0) { sql += "MaDongODiaQuang=" + maDong.ToString() + " "; flag = 1; } else if (flag == 1) { sql += "and MaDongODiaQuang=" + maDong.ToString() + " "; flag = 1; } } if (string.Compare(infoCombobox.SCardMang, null) != 0) { int maDong = myChiTietDongCardMangDAO.LayMaDongCardMang(infoCombobox.SCardMang); if (flag == 0) { sql += "MaDongCardMang=" + maDong.ToString() + " "; flag = 1; } else if (flag == 1) { sql += "and MaDongCardMang=" + maDong.ToString() + " "; flag = 1; } } if (string.Compare(infoCombobox.SCardReader, null) != 0) { int maDong = myChiTietDongCardReaderDAO.LayMaDongCardReader(infoCombobox.SCardReader); if (flag == 0) { sql += "MaDongCardReader=" + maDong.ToString() + " "; flag = 1; } else if (flag == 1) { sql += "and MaDongCardReader=" + maDong.ToString() + " "; flag = 1; } } if (string.Compare(infoCombobox.SWebCam, null) != 0) { int maDong = myChiTietDongWebcamDAO.LayMaDongWebCam(infoCombobox.SWebCam); if (flag == 0) { sql += "MaDongWebCam=" + maDong.ToString() + " "; flag = 1; } else if (flag == 1) { sql += "and MaDongWebCam=" + maDong.ToString() + " "; flag = 1; } } if (string.Compare(infoCombobox.SPin, null) != 0) { int maDong = myChiTietDongPinDAO.LayMaDongPin(infoCombobox.SPin); if (flag == 0) { sql += "MaDongPin=" + maDong.ToString() + " "; flag = 1; } else if (flag == 1) { sql += "and MaDongPin=" + maDong.ToString() + " "; flag = 1; } } if (string.Compare(infoCombobox.SHeDieuHanh, null) != 0) { int maDong = myChiTietHeDieuHanhDAO.LayMaDongHeDieuHanh(infoCombobox.SHeDieuHanh); if (flag == 0) { sql += "MaHeDieuHanh=" + maDong.ToString() + " "; flag = 1; } else if (flag == 1) { sql += "and MaHeDieuHanh=" + maDong.ToString() + " "; flag = 1; } } if (string.Compare(infoCombobox.SNhaSanXuat, null) != 0) { int maDong = myNhaSanXuatDAO.LayMaNhaSanXuat(infoCombobox.SNhaSanXuat); if (flag == 0) { sql += "MaNhaSanXuat=" + maDong.ToString() + " "; flag = 1; } else if (flag == 1) { sql += "and MaNhaSanXuat=" + maDong.ToString() + " "; flag = 1; } } if (infoCombobox.FTrongLuong != 0) { int maDong = myChiTietTrongLuongDAO.LayMaChiTietTrongLuong(infoCombobox.FTrongLuong); if (flag == 0) { sql += "MaChiTietTrongLuong=" + maDong.ToString() + " "; flag = 1; } else if (flag == 1) { sql += "and MaChiTietTrongLuong=" + maDong.ToString() + " "; flag = 1; } } if (string.Compare(infoCombobox.SMauSac, null) != 0) { if (flag == 0) { sql += "MauSac=N'" + infoCombobox.SMauSac + "' "; flag = 1; } else if (flag == 1) { sql += "and MauSac=N'" + infoCombobox.SMauSac + "' "; flag = 1; } } if (string.Compare(infoCombobox.SGiaBan, null) != 0) { string substr = " triệu đồng"; string temp = ConvertString(infoCombobox.SGiaBan.Substring(0, infoCombobox.SGiaBan.Length - substr.Length)); if (flag == 0) { sql += "GiaBanHienHanh=" + temp + " "; flag = 1; } else if (flag == 1) { sql += "and GiaBanHienHanh=" + temp + " "; flag = 1; } } if (infoCombobox.ISoCongUSB != 0) { if (flag == 0) { sql += "SoLuongCongUSB=" + infoCombobox.ISoCongUSB.ToString() + " "; flag = 1; } else if (flag == 1) { sql += "and SoLuongCongUSB=" + infoCombobox.ISoCongUSB.ToString() + " "; flag = 1; } } if (infoCombobox.IThoigianBH != 0) { if (flag == 0) { sql += "ThoiGianBaoHanh=" + infoCombobox.IThoigianBH.ToString() + " "; flag = 1; } else if (flag == 1) { sql += "and ThoiGianBaoHanh=" + infoCombobox.IThoigianBH.ToString() + " "; flag = 1; } } if (string.Compare(infoCombobox.SCongHDMI, null) != 0) { bool kq; if (string.Compare(infoCombobox.SCongHDMI, "Có") == 0) { kq = true; } else { kq = false; } if (flag == 0) { sql += "HDMI=" + BitConverter.GetBytes(kq)[0].ToString() + " "; flag = 1; } else if (flag == 1) { sql += "and HDMI=" + BitConverter.GetBytes(kq)[0].ToString() + " "; flag = 1; } } if (string.Compare(infoCombobox.SNhanDangVanTay, null) != 0) { bool kq; if (string.Compare(infoCombobox.SNhanDangVanTay, "Có") == 0) { kq = true; } else { kq = false; } if (flag == 0) { sql += "FingerprintReader=" + BitConverter.GetBytes(kq)[0].ToString() + " "; flag = 1; } else if (flag == 1) { sql += "and FingerprintReader=" + BitConverter.GetBytes(kq)[0].ToString() + " "; flag = 1; } } var query = m_EStore.ExecuteQuery <CHITIETDONGLAPTOP>(sql); if (query == null) { return(null); } foreach (CHITIETDONGLAPTOP laptop in query) { //Chi tiet dong Laptop #region ChiTietDongLapTop myChiTietDongLaptopDTO dongLapTop = new myChiTietDongLaptopDTO(); dongLapTop.STenChiTietDongLapTop = laptop.TenChiTietDongLapTop; dongLapTop.SMauSac = laptop.MauSac; dongLapTop.IThoiGianBaoHanh = (int)laptop.ThoiGianBaoHanh; dongLapTop.FGiaBanHienHanh = (float)laptop.GiaBanHienHanh; dongLapTop.ChiTietDongRam = myChiTietDongRamDAO.LayChiTietDongRam((int)laptop.MaDongRAM); dongLapTop.ChiTietDongOCung = myChiTietDongOCungDAO.LayChiTietDongOCung((int)laptop.MaDongOCung); dongLapTop.ChiTietDongCacDoHoa = myChiTietDongCardDoHoaDAO.LayChiTietDongCardDoHoa((int)laptop.MaDongCardDoHoa); dongLapTop.ChiTietDongCardMang = myChiTietDongCardMangDAO.LayChiTietDongCardMang((int)laptop.MaDongCardMang); dongLapTop.ChiTietDongCPU = myChiTietDongCPUDAO.LayChiTietDongCPU((int)laptop.MaDongCPU); dongLapTop.ChiTietDongCardReader = myChiTietDongCardReaderDAO.LayChiTietDongCardReader((int)laptop.MaDongCardReader); dongLapTop.ChiTietDongLoa = myChiTietDongLoaDAO.LayChiTietDongLoa((int)laptop.MaDongLoa); dongLapTop.ChiTietDongManHinh = myChiTietDongManHinhDAO.LayChiTietDongManHinh((int)laptop.MaDongManHinh); dongLapTop.ChiTietDongODiaQuang = myChiTietDongODiaQuangDAO.LayChiTietDongODiaQuang((int)laptop.MaDongODiaQuang); dongLapTop.ChiTietDongPin = myChiTietDongPinDAO.LayChiTietDongPin((int)laptop.MaDongPin); dongLapTop.ChiTietDongWebCam = myChiTietDongWebcamDAO.LayChiTietDongWebcam((int)laptop.MaDongWebCam); dongLapTop.ChiTietHeDieuHanh = myChiTietHeDieuHanhDAO.LayChiTietHDH((int)laptop.MaHeDieuHanh); dongLapTop.ChiTietTrongLuong = myChiTietTrongLuongDAO.LayChiTietTrongLuong((int)laptop.MaChiTietTrongLuong); dongLapTop.BFingerprintReader = BitConverter.GetBytes(laptop.FingerprintReader.Value)[0]; dongLapTop.BHDMI = BitConverter.GetBytes(laptop.HDMI.Value)[0]; dongLapTop.ISoLuongCongUSB = (int)laptop.SoLuongCongUSB; dongLapTop.NhaSanXuat = new myNhaSanXuatDTO(laptop.NHASANXUAT.TenNhaSanXuat); dongLapTop.DanhGia = myDanhGiaDAO.LayDanhGia(laptop.DANHGIA.MaDanhGia); dongLapTop.FGiaBanHienHanh = (float)laptop.GiaBanHienHanh; dongLapTop.SMoTaThem = (string)laptop.MoTaThem; dongLapTop.ISoLuongNhap = (int)laptop.SoLuongNhap; dongLapTop.ISoLuongConLai = (int)laptop.SoLuongConLai; dongLapTop.IThoiGianBaoHanh = (int)laptop.ThoiGianBaoHanh; dongLapTop.SHinhAnh = (string)laptop.HinhAnh; dongLapTop.SMauSac = (string)laptop.MauSac; #endregion danhsachChiTietDongLapTop.Add(dongLapTop); } return(danhsachChiTietDongLapTop); } catch (Exception ex) { throw ex; } }