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