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