private void dgvData_CellClick(object sender, DataGridViewCellEventArgs e) { int row = dgvData.CurrentCell.RowIndex; switch (dataType) { case DataManager.PRODUCTCAR: btnProCarSua.Enabled = btnProCarXoa.Enabled = true; txbProCarMaSP.Text = dgvData.Rows[row].Cells[0].Value.ToString(); txbProCarTenSP.Text = dgvData.Rows[row].Cells[1].Value.ToString(); txbProCarThuongHieu.Text = dgvData.Rows[row].Cells[2].Value.ToString(); cbbProCarLoai.Text = dgvData.Rows[row].Cells[3].Value.ToString(); txbProCarGiaSP.Text = dgvData.Rows[row].Cells[4].Value.ToString(); txbProCarGiaTT.Text = dgvData.Rows[row].Cells[5].Value.ToString(); nmrProCarRate.Value = (int)dgvData.Rows[row].Cells[6].Value; DataRow rowTableImg = new BLImageCar().FindImageByID(txbProCarMaSP.Text.Trim()); MemoryStream mem = new MemoryStream((byte[])rowTableImg[1]); ptbProCarImage1.Image = Image.FromStream(mem); mem = new MemoryStream((byte[])rowTableImg[2]); ptbProCarImage2.Image = Image.FromStream(mem); mem = new MemoryStream((byte[])rowTableImg[3]); ptbProCarImage3.Image = Image.FromStream(mem); mem = new MemoryStream((byte[])rowTableImg[4]); ptbProCarImage4.Image = Image.FromStream(mem); break; case DataManager.DETAILCAR: btnDetCarSua.Enabled = btnDetCarXoa.Enabled = true; txbDetCarMaSP.Text = dgvData.Rows[row].Cells[0].Value.ToString(); txbDetCarMau.Text = dgvData.Rows[row].Cells[1].Value.ToString(); txbDetCarXang.Text = dgvData.Rows[row].Cells[2].Value.ToString(); txbDetCarXilanh.Text = dgvData.Rows[row].Cells[3].Value.ToString(); txbDetCarLoai.Text = dgvData.Rows[row].Cells[4].Value.ToString(); break; case DataManager.CATEGORY_CAR: btnCatCarSua.Enabled = btnCatCarXoa.Enabled = true; txbCatCarLoai.Text = dgvData.Rows[row].Cells[0].Value.ToString(); //DataRow rowTable = new BLCATEGORY_CAR().FindImageByID(txbProSmartMaSP.Text.Trim()); MemoryStream ms = new MemoryStream((byte[])dgvData.Rows[row].Cells[1].Value); btnCatCarChangeImg.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); }