private void cmbMasothue_SelectedIndexChanged(object sender, EventArgs e)
{
if (cmbMasothue.SelectedIndex != -1)
{
string str;
str = "select d.Mataisan,d.Tentaisan from tblThueNha as b join tblNha_TaiSan as c on b.Manha=c.MaNha " +
"join tblTaiSan as d on c.Mataisan=d.Mataisan where b.Masothue='" + cmbMasothue.SelectedValue + "'";
DAO.FillDataToCombo(str, cmbTaisan, "Mataisan", "Tentaisan");
}
cmbTaisan.Text = "";
}
private void cmbManha_SelectedIndexChanged(object sender, EventArgs e)
{
if (cmbManha.SelectedIndex != -1)
{
string str;
str = "select distinct Makhach from tblThueNha where Manha = '" + cmbManha.SelectedValue + "' ";
// MessageBox.Show(str);
DAO.FillDataToCombo(str, cmbMakhach, "MaKhach", "MaKhach");
txtDienthoai.Text = DAO.GetFieldValues("select Dienthoai from tblDanhMucNha where Manha = '" + cmbManha.SelectedValue + "'");
txtTenchunha.Text = DAO.GetFieldValues("select Tenchunha from tblDanhMucNha where Manha = '" + cmbManha.SelectedValue + "'");
txtDiachinha.Text = DAO.GetFieldValues("select Diachi from tblDanhMucNha where Manha = '" + cmbManha.SelectedValue + "'");
txtLoainha.Text = DAO.GetFieldValues("select b.Tenloai from tblDanhMucNha as a join tblLoainha as b on a.Maloai=b.Maloai where a.Manha = '" + cmbManha.SelectedValue + "'");
txtDongiathue.Text = DAO.GetFieldValues("select Dongiathue from tblDanhMucNha where Manha = '" + cmbManha.SelectedValue + "'");
txtDoituongsudung.Text = DAO.GetFieldValues("select b.TenDTSD from tblDanhMucNha as a join tblDoiTuongSuDung as b on a.MaDTSD=b.MaDTSD where a.Manha = '" + cmbManha.SelectedValue + "'");
txtTinhtrang.Text = DAO.GetFieldValues("select Tinhtrang from tblDanhMucNha where Manha = '" + cmbManha.SelectedValue + "'");
txtGhichu.Text = DAO.GetFieldValues("select Ghichu from tblDanhMucNha where Manha = '" + cmbManha.SelectedValue + "'");
}
}