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