public SanPham(int id)
{
DataTable dt = SanPhamControl.layThongTin(id);
idSP = Convert.ToInt32(dt.Rows[0][0].ToString());
tenSP = dt.Rows[0][1].ToString();
donGia = float.Parse(dt.Rows[0][3].ToString());
soLuong = 1;
}
private void loadLoaiSP()
{
DataTable dt = SanPhamControl.layDanhSachLoaiSP();
for (int i = 0; i < dt.Rows.Count; ++i)
{
cbLoai.Items.Add(dt.Rows[i][1]);
}
}
private void timTheoMatHang(int id)
{
dgvDanhSach.Rows.Clear();
DataTable dt = SanPhamControl.layDSSPTheoMH(id);
for (int i = 0; i < dt.Rows.Count; i++)
{
dgvDanhSach.Rows.Add(false, dt.Rows[i][0], dt.Rows[i][1], dt.Rows[i][2], dt.Rows[i][3], dt.Rows[i][4], String.Format("{0:dd/MM/yyyy}", dt.Rows[0][5]),
String.Format("{0:dd/MM/yyyy}", dt.Rows[0][6]), dt.Rows[i][7]);
}
}
private void timKiem(string value)
{
dgvDanhSach.Rows.Clear();
DataTable dt = SanPhamControl.timKiem(value);
for (int i = 0; i < dt.Rows.Count; i++)
{
dgvDanhSach.Rows.Add(false, dt.Rows[i][0], dt.Rows[i][1], dt.Rows[i][2], dt.Rows[i][3], dt.Rows[i][4], String.Format("{0:dd/MM/yyyy}", dt.Rows[0][5]),
String.Format("{0:dd/MM/yyyy}", dt.Rows[0][6]), dt.Rows[i][7]);
}
}
private void loadDuLieu()
{
dgvDanhSach.Rows.Clear();
DataTable dt = SanPhamControl.layDanhSach();
for (int i = 0; i < dt.Rows.Count; i++)
{
dgvDanhSach.Rows.Add(new object[] { false, dt.Rows[i][0], dt.Rows[i][1], dt.Rows[i][2], dt.Rows[i][3], dt.Rows[i][4], String.Format("{0:dd/MM/yyyy}", dt.Rows[i][5]),
String.Format("{0:dd/MM/yyyy}", dt.Rows[i][6]), dt.Rows[i][7] });
}
}
public frmSuaSP(int id)
{// MaSP, TenSP, TenLoaiSP, DonGia, DonViDo, HSD, NSX, SoLuong
InitializeComponent();
idSP = id;
DataTable dt = SanPhamControl.layThongTin(id);
txtTenCu.Text = dt.Rows[0][1].ToString();
txtLoaiCu.Text = dt.Rows[0][2].ToString();
txtDonGiaCu.Text = dt.Rows[0][3].ToString();
txtDonViCu.Text = dt.Rows[0][4].ToString();
txtHSDCu.Text = String.Format("{0:dd/MM/yyyy}", dt.Rows[0][5]); //dt.Rows[0][5].ToString();
txtNSXCu.Text = String.Format("{0:dd/MM/yyyy}", dt.Rows[0][6]);
txtSoLuongCu.Text = dt.Rows[0][7].ToString();
loadLoaiSP();
}
private void loadDanhSachSP()
{
dgvDanhSachSP.Rows.Clear();
DataTable dt = SanPhamControl.layDanhSach();
for (int i = 0; i < dt.Rows.Count; ++i)
{
int soluong;
int vitri = HDB.ChiTiet.isContain(Convert.ToInt32(dt.Rows[i][0].ToString()));
if (vitri != -1) // nếu sản phẩm có trong HDB
{
soluong = Convert.ToInt32(dt.Rows[i]["SoLuong"].ToString()) - HDB.ChiTiet.ListSanPham[vitri].SoLuong;
}
else
{
soluong = Convert.ToInt32(dt.Rows[i]["SoLuong"].ToString());
}
dgvDanhSachSP.Rows.Add(new object[] { dt.Rows[i][0], dt.Rows[i][1], dt.Rows[i][3], dt.Rows[i][4], soluong });
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
string tensp = txtTen.Text;
LoaiSP loai = cbLoai.SelectedValue as LoaiSP;
double dongia = double.Parse(txtDonGia.Text);
string donvi = txtDonVi.Text;
string hsd = dtpHSD.Text;
string nsx = dtpNSX.Text;
int soluong = Convert.ToInt32(txtSoLuong.Text);
if (true)
{
int ketqua = SanPhamControl.themDuLieu(tensp, loai.IdLoai, dongia, donvi, hsd, nsx, soluong);
if (ketqua > 0)
{
MessageBox.Show("them thanh cong");
this.Close();
}
}
}
private void btnXacNhan_Click(object sender, EventArgs e)
{
string ten = txtTenMoi.Text;
int loai = SanPhamControl.layIDLoaiSP(cbLoai.Text);
float dongia = float.Parse(txtDonGiaMoi.Text);
string donvi = txtDonViMoi.Text;
DateTime hsd = Convert.ToDateTime(dtpHSDMoi.Text);
DateTime nsx = Convert.ToDateTime(dtpNSXMoi.Text);
int soluong = Convert.ToInt32(txtSoLuongMoi.Text);
if (kiemTra(ten, loai, dongia, donvi, hsd, nsx, soluong))
{
int ketQua = 0;//int id, string ten, int loai, float dongia, string donvido, DateTime hsd, DateTime nsx, int soluong
ketQua = SanPhamControl.suaThongTin(idSP, ten, loai, dongia, donvi, hsd, nsx, soluong);
if (ketQua > 0)
{
MessageBox.Show("thay đổi thành công");
this.Close();
}
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
int ketQua = 0;
for (int i = 0; i < dgvDanhSach.Rows.Count - 1; ++i)
{
if (Convert.ToBoolean(dgvDanhSach.Rows[i].Cells["colCheck"].Value.ToString()))
{
ketQua += SanPhamControl.xoaThongTin(Convert.ToInt32(dgvDanhSach.Rows[i].Cells["colMa"].Value.ToString()));
}
}
if (ketQua > 0)
{
MessageBox.Show("xóa thành công " + ketQua);
loadDuLieu();
}
else
{
MessageBox.Show("xóa thất bại");
}
}
private void timKiem()
{
foreach (DataGridViewCell item in dgvDanhSachSP.SelectedCells)
{
item.Selected = false;
}
string stringTimKiem = txtTimKiemSP.Text;
DataTable dt = SanPhamControl.timKiem(stringTimKiem);
for (int i = 0; i < dt.Rows.Count; ++i)
{
for (int j = 0; j < dgvDanhSachSP.Rows.Count - 1; ++j)
{
if (dgvDanhSachSP.Rows[j].Cells[0].Value.ToString().Equals(dt.Rows[i][0].ToString()))
{
dgvDanhSachSP.Rows[j].Selected = true;
break;
}
}
}
}
private void dgvDanhSach_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int id = Convert.ToInt32(dgvDanhSach.Rows[e.RowIndex].Cells["colMa"].Value.ToString());
if (e.ColumnIndex == dgvDanhSach.Columns["colSua"].Index)
{
frmSuaSP f = new frmSuaSP(id);
f.ShowDialog();
loadDuLieu();
}
else if (e.ColumnIndex == dgvDanhSach.Columns["colXoa"].Index)
{
int ketQua = SanPhamControl.xoaThongTin(id);
if (ketQua <= 0)
{
MessageBox.Show("Thực hiện thất bại");
}
else
{
loadDuLieu();
}
}
}
