private void dgvData_CellClick(object sender, DataGridViewCellEventArgs e)
{
int row = dgvData.CurrentCell.RowIndex;
switch (dataType)
{
case DataManager.PRODUCTFASHION:
btnProLaptopSua.Enabled = btnProLaptopXoa.Enabled = true;
txbProFashionMaSP.Text = dgvData.Rows[row].Cells[0].Value.ToString();
txbProFashionTenSP.Text = dgvData.Rows[row].Cells[1].Value.ToString();
txbProFashionThuongHieu.Text = dgvData.Rows[row].Cells[2].Value.ToString();
cbbProFashionLoai.Text = dgvData.Rows[row].Cells[3].Value.ToString();
txbProFashionGiaSP.Text = dgvData.Rows[row].Cells[4].Value.ToString();
txbProFashionGiaTT.Text = dgvData.Rows[row].Cells[5].Value.ToString();
nmrProFashionRate.Value = (int)dgvData.Rows[row].Cells[6].Value;
DataRow rowTableImg = new BLImageFahion().FindImageByID(txbProFashionMaSP.Text.Trim());
MemoryStream mem = new MemoryStream((byte[])rowTableImg[1]);
ptbProFashionImage1.Image = Image.FromStream(mem);
mem = new MemoryStream((byte[])rowTableImg[2]);
ptbProFashionImage2.Image = Image.FromStream(mem);
mem = new MemoryStream((byte[])rowTableImg[3]);
ptbProFashionImage3.Image = Image.FromStream(mem);
mem = new MemoryStream((byte[])rowTableImg[4]);
ptbProFashionImage4.Image = Image.FromStream(mem);
break;
case DataManager.DETAILFASHION:
btnDetFashionSua.Enabled = btnDetFashionXoa.Enabled = true;
txbDetLaptopMaSP.Text = dgvData.Rows[row].Cells[0].Value.ToString();
txbDetFashionMauSac.Text = dgvData.Rows[row].Cells[1].Value.ToString();
cbbDetFashionSize.Text = dgvData.Rows[row].Cells[2].Value.ToString();
txbDetFashionkieuDang.Text = dgvData.Rows[row].Cells[3].Value.ToString();
txbDetFashionChatLieu.Text = dgvData.Rows[row].Cells[4].Value.ToString();
break;
case DataManager.CATEGORY_FASHION:
btnCatFashionSua.Enabled = btnCatFahionXoa.Enabled = true;
txbCatFashionLoai.Text = dgvData.Rows[row].Cells[0].Value.ToString();
//DataRow rowTable = new BLCATEGORY_LAPTOP().FindImageByID(txbProSmartMaSP.Text.Trim());
MemoryStream ms = new MemoryStream((byte[])dgvData.Rows[row].Cells[1].Value);
btnCatFashionChangeImg.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);
}
