private void FrmCapNhatHangTon_Load(object sender, EventArgs e) { DataTable dtMatHang = new DataTable(); dtMatHang = bllMatHang.GetAllMatHang(); dtMatHang = cf.AutoNumberedTable(dtMatHang); dgvResults.AutoGenerateColumns = false; dgvResults.DataSource = dtMatHang; }
private void LoadMatHang() { try { DataTable dtMatHang = new DataTable(); dtMatHang = bllMatHang.GetAllMatHang(); dtMatHang = cf.AutoNumberedTable(dtMatHang); dgvMatHang.AutoGenerateColumns = false; dgvMatHang.DataSource = dtMatHang; intRowCount = dgvMatHang.Rows.Count; } catch { } }
private void InitForm() { try { string strMaXuatKho = cf.CreateId("MXK", "XUATKHO"); txtMaPhieuXuat.Text = strMaXuatKho; string strMaNhanVien = Variable.strMaNhanVien; if (strMaNhanVien == "") { strMaNhanVien = "Chưa đăng nhập"; } txtMaNhanVien.Text = strMaNhanVien; dtNgayLap.Text = DateTime.Now.ToShortDateString(); dtNgayNhap.Text = DateTime.Now.ToShortDateString(); LoadCMBKhachHang(); colMaMatHang.DataSource = bllMatHang.GetAllMatHang(); colMaMatHang.DisplayMember = "MAMATHANG"; colMaMatHang.ValueMember = "MAMATHANG"; colTenMatHang.DataSource = bllMatHang.GetAllMatHang(); colTenMatHang.DisplayMember = "TENMATHANG"; colTenMatHang.ValueMember = "MAMATHANG"; colDonViTinh.DataSource = bllDonVITinh.GetDonViTinh(); colDonViTinh.DisplayMember = "DONVITINH"; colDonViTinh.ValueMember = "MADONVITINH"; cmbMucThue.DataSource = bllMucThue.GetMucThue(); cmbMucThue.DisplayMember = "SOTHUE"; cmbMucThue.ValueMember = "MATHUE"; } catch { } }
private void btnTraCuu_Click(object sender, EventArgs e) { if (dgvResults.Rows.Count > 0) { dgvResults.Rows.Clear(); } DataTable dtMatHang = new DataTable(); DateTime dateNgayBD = dtNgayBD.Value; DateTime dateNgayKT = dtNgayKT.Value; dtMatHang = bllMatHang.GetAllMatHang(); // Add dòng for (int i = 0; i < dtMatHang.Rows.Count; i++) { dgvResults.Rows.Add(); } for (int i = 0; i < dtMatHang.Rows.Count; i++) { //Lấy dữ liệu string strMaMatHang = dtMatHang.Rows[i]["MAMATHANG"].ToString(); string strTenMatHang = dtMatHang.Rows[i]["TENMATHANG"].ToString(); string strDonViTinh = dtMatHang.Rows[i]["DONVITINH"].ToString(); int intSLTon = int.Parse(dtMatHang.Rows[i]["TONDAU"].ToString()); int intSLNhap = 0; DataTable dtTongNhap = bllNhapKho.TimKiemTongNhap(dateNgayBD, dateNgayKT, strMaMatHang); if (dtTongNhap.Rows.Count > 0) { intSLNhap = int.Parse(dtTongNhap.Rows[0]["SOLUONGNHAP"].ToString()); } int intSLXuat = 0; DataTable dtTongXuat = bllXuatKho.TimKiemTongXuat(dateNgayBD, dateNgayKT, strMaMatHang); if (dtTongXuat.Rows.Count > 0) { intSLXuat = int.Parse(dtTongXuat.Rows[0]["SOLUONGXUAT"].ToString()); } int intTon = intSLTon + intSLNhap - intSLXuat; // Đưa vào lưới dgvResults.Rows[i].Cells[0].Value = i + 1; dgvResults.Rows[i].Cells[1].Value = strMaMatHang; dgvResults.Rows[i].Cells[2].Value = strTenMatHang; dgvResults.Rows[i].Cells[3].Value = strDonViTinh; dgvResults.Rows[i].Cells[4].Value = intSLTon; dgvResults.Rows[i].Cells[6].Value = intSLNhap; dgvResults.Rows[i].Cells[8].Value = intSLXuat; dgvResults.Rows[i].Cells[10].Value = intTon; } btnIn.Enabled = false; }