private void frmNhapVT_Load(object sender, EventArgs e)
{
createTable_CTNhap();
createTable_PhieuNhap();
createTable_TonKho();
load();
HienThi();
string sql1 = "select * from NHACUNGCAP";
DataTable dt1 = conn.getDataTable(sql1, "NHACUNGCAP");
cboMaNCC.DataSource = dt1;
cboMaNCC.DisplayMember = "TENNCC";
cboMaNCC.ValueMember = "MANCC";
cboMaNCC.Text = "";
string sql2 = "select * from TAIKHOAN,NHANVIEN where TAIKHOAN.MANV = NHANVIEN.MANV AND ID='" + frmDangNhap.ID_USER + "'";
DataTable dt2 = conn.getDataTable(sql2, "TAIKHOAN,NHANVIEN");
cboNV.DataSource = dt2;
cboNV.DisplayMember = "TENNV";
cboNV.ValueMember = "MANV";
loadVatTu();
}
private void frmBanVT_Load(object sender, EventArgs e)
{
createTable_HOADON();
createTable_CTHOADON();
createTable_TonKho();
load_Begin();
createTable_KhachHang();
HienThi();
string strSQL = "SELECT * FROM KHACHHANG";
DataTable dt = conn.getDataTable(strSQL, "KHACHHANG");
cboTenKH.DataSource = dt;
cboTenKH.DisplayMember = "TENKH";
cboTenKH.ValueMember = "MAKH";
cboTenKH.Text = "";
txtMaKH.Clear();
txtSDTKH.Clear();
txtDiaChiKH.Clear();
txtMaKH.Focus();
string sql3 = "select * from VATTU";
DataTable dt3 = conn.getDataTable(sql3, "VATTU");
cboMaVT.DataSource = dt3;
cboMaVT.DisplayMember = "TENVT";
cboMaVT.ValueMember = "MAVT";
cboMaVT.Text = "";
pckNgayXuat.Text = DateTime.Now.Date.ToString();
string s = "SELECT * from NHANVIEN,TAIKHOAN WHERE NHANVIEN.MANV = TAIKHOAN.MANV AND ID ='" + frmDangNhap.ID_USER + "'";
DataTable dt2 = conn.getDataTable(s, "NHANVIEN,TAIKHOAN");
cboNhanVien.DataSource = dt2;
cboNhanVien.ValueMember = "MANV";
cboNhanVien.DisplayMember = "TENNV";
}
private void frmVatTu_Load(object sender, EventArgs e)
{
createTable_VatTu();
dgVVatTu.DataSource = conn.Dset.Tables["VATTU"];
string s = "select * from LOAIVT";
DataTable dt = conn.getDataTable(s, "LOAIVT");
cboMaLoai.DataSource = dt;
cboMaLoai.DisplayMember = "TENLOAI";
cboMaLoai.ValueMember = "MALOAI";
cboMaLoai.Text = "";
load_begin();
}