private void dgvData_CellClick(object sender, DataGridViewCellEventArgs e) { int row = dgvData.CurrentCell.RowIndex; switch (dataType) { case DataManager.PRODUCTSMARTPHONE: btnProSmartSua.Enabled = btnProSmartXoa.Enabled = true; txbProSmartMaSP.Text = dgvData.Rows[row].Cells[0].Value.ToString(); txbProSmartTenSP.Text = dgvData.Rows[row].Cells[1].Value.ToString(); txbProSmartThuongHieu.Text = dgvData.Rows[row].Cells[2].Value.ToString(); cbbProSmartLoai.Text = dgvData.Rows[row].Cells[3].Value.ToString(); txbProSmartGiaSP.Text = dgvData.Rows[row].Cells[4].Value.ToString(); txbProSmartGiaTT.Text = dgvData.Rows[row].Cells[5].Value.ToString(); nmrProSmartRate.Value = (int)dgvData.Rows[row].Cells[6].Value; DataRow rowTableImg = new BLImageSmartPhone().FindImageByID(txbProSmartMaSP.Text.Trim()); MemoryStream mem = new MemoryStream((byte[])rowTableImg[1]); ptbProSmartImage1.Image = Image.FromStream(mem); mem = new MemoryStream((byte[])rowTableImg[2]); ptbProSmartImage2.Image = Image.FromStream(mem); mem = new MemoryStream((byte[])rowTableImg[3]); ptbProSmartImage3.Image = Image.FromStream(mem); mem = new MemoryStream((byte[])rowTableImg[4]); ptbProSmartImage4.Image = Image.FromStream(mem); break; case DataManager.DETAILSMARTPHONE: btnDetSmartSua.Enabled = btnDetSmartXoa.Enabled = true; txbDetSmartMaSP.Text = dgvData.Rows[row].Cells[0].Value.ToString(); txbDetSmartManHinh.Text = dgvData.Rows[row].Cells[1].Value.ToString(); txbDetSmartCamTruoc.Text = dgvData.Rows[row].Cells[2].Value.ToString(); txbDetSmartCamSau.Text = dgvData.Rows[row].Cells[3].Value.ToString(); ckbDetSmartFlash.Checked = (Boolean)dgvData.Rows[row].Cells[4].Value; txbDetSmartRam.Text = dgvData.Rows[row].Cells[5].Value.ToString(); txbDetSmartChip.Text = dgvData.Rows[row].Cells[6].Value.ToString(); cbbDetSmartHDH.Text = dgvData.Rows[row].Cells[7].Value.ToString(); txbDetSmartPin.Text = dgvData.Rows[row].Cells[8].Value.ToString(); cbbDetSmartSim.Text = dgvData.Rows[row].Cells[9].Value.ToString(); txbDetSmartKetNoi.Text = dgvData.Rows[row].Cells[10].Value.ToString(); ckbDetSmartNFC.Checked = (Boolean)dgvData.Rows[row].Cells[11].Value; ckbDetSmartFM.Checked = (Boolean)dgvData.Rows[row].Cells[12].Value; break; case DataManager.CATEGORY_SMARTPHONE_TABLET: btnCatSmartSua.Enabled = btnCatSmartXoa.Enabled = true; txbCatSmartLoai.Text = dgvData.Rows[row].Cells[0].Value.ToString(); //DataRow rowTable = new BLCategory_Smartphone_Tablet().FindImageByID(txbProSmartMaSP.Text.Trim()); MemoryStream ms = new MemoryStream((byte[])dgvData.Rows[row].Cells[1].Value); btnCatSmartChangeImg.Image = Image.FromStream(ms); break; } }
// Chia bảng ra nhiều lần get, một lần get (end - begin) item static private DataTable GetDatabase(int begin, int end, out bool flag, string nameTable) { flag = true; DataSet dt = null; if (nameTable.Contains("IMAGE")) { switch (nameTable.Trim()) { case "IMAGE_PHONE": dt = new BLImageSmartPhone().GetData(); break; case "IMAGE_LAPTOP": dt = new BLImageLaptop().GetData(); break; case "IMAGE_FASHION": dt = new BLImageFahion().GetData(); break; case "IMAGE_CAR": dt = new BLImageCar().GetData(); break; case "IMAGE_BOOK": dt = new BLImageCar().GetData(); break; default: flag = false; return(null); } } else if (nameTable.Contains("PRODUCT")) { switch (nameTable.Trim()) { case "PRODUCT_PHONE": dt = new BLProductSmart().GetData(); break; case "PRODUCT_LAPTOP": dt = new BLProductLaptop().GetData(); break; case "PRODUCT_FASHION": dt = new BLProductFashion().GetData(); break; case "PRODUCT_CAR": dt = new BLProductCar().GetData(); break; case "PRODUCT_BOOK": dt = new BLProductBook().GetData(); break; default: flag = false; return(null); } } else if (nameTable.Contains("DETAIL")) { switch (nameTable.Trim()) { case "DETAIL_PHONE": dt = new BLDetailSmartPhone().GetData(); break; case "DETAIL_LAPTOP": dt = new BLDetailLaptop().GetData(); break; case "DETAIL_FASHION": dt = new BLDetailFashion().GetData(); break; case "DETAIL_CAR": dt = new BLDetailCar().GetData(); break; case "DETAIL_BOOK": dt = new BLDetailBook().GetData(); break; default: flag = false; return(null); } } else if (nameTable.Contains("CATEGORY")) { switch (nameTable.Trim()) { case "CATEGORY_PHONE": dt = new BLCategory_Smartphone_Tablet().GetData(); break; case "CATEGORY_LAPTOP": dt = new BLCategory_Laptop().GetData(); break; case "CATEGORY_FASHION": dt = new BLCategory_Fashion().GetData(); break; case "CATEGORY_CAR": dt = new BLCategory_Car().GetData(); break; case "CATEGORY_BOOK": dt = new BLCategory_Book().GetData(); break; default: flag = false; return(null); } } else { switch (nameTable.Trim()) { case "CUSTOMER": dt = new BLCustomer().GetData(); break; case "COMMENT": dt = new BLComment().GetData(); break; case "BILL": dt = new BLDetailBill().GetData(); break; default: flag = false; return(null); } } DataTable table = dt.Tables[0]; if (table.Rows.Count <= end) { end = table.Rows.Count; flag = false; } DataTable resulrSplip = table.AsEnumerable().Skip(begin).Take(end - begin).CopyToDataTable(); return(resulrSplip); }