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