private void cmbNha_SelectedIndexChanged(object sender, EventArgs e) { if (cmbNha.SelectedIndex != -1) { string sql, sql1; if (cmbNha.Text == "") { txtTiendatcoc.Text = ""; return; } sql = "SELECT Dongiathue FROM tblDanhMucNha WHERE Manha = '" + cmbNha.Text + "'"; DataTable table = DAO.DocBang(sql); if (table.Rows.Count > 0) { txtTiendatcoc.Text = table.Rows[0][0].ToString(); } if (cmbNha.Text == "") { txtDoituong.Text = ""; return; } sql1 = "SELECT b.TenDTSD FROM tblDanhMucNha as a join tblDoiTuongSuDung as b on a.MaDTSD = b.MaDTSD WHERE a.Manha = '" + cmbNha.Text + "'"; DataTable table1 = DAO.DocBang(sql1); if (table1.Rows.Count > 0) { txtDoituong.Text = table1.Rows[0][0].ToString(); } } }
private void btnTim_Click(object sender, EventArgs e) { if (cmbMasothue.Text == "") { txtTongtienthu.Text = ""; return; } string sql = "select Sum(a.TongTien) from tblThuTienNha as a join tblThueNha as b on a.Masothue=b.Masothue where b.Masothue='" + cmbMasothue.SelectedValue.ToString() + "'"; DataTable table = DAO.DocBang(sql); if (table.Rows.Count > 0) { txtTongtienthu.Text = table.Rows[0][0].ToString(); } }
private void cmbManha_SelectedIndexChanged(object sender, EventArgs e) { string sql; if (cmbManha.Text == "") { txtTenchunha.Text = ""; return; } sql = "SELECT Tenchunha FROM tblDanhMucNha WHERE Manha = '" + cmbManha.Text + "'"; DataTable table = DAO.DocBang(sql); if (table.Rows.Count > 0) { txtTenchunha.Text = table.Rows[0][0].ToString(); } }
private void cmbMasothue_SelectedIndexChanged(object sender, EventArgs e) { string sql, sql1; if (cmbMasothue.SelectedIndex != -1) { txtNgaybatdau.Text = DAO.GetFieldValues("select NgayBD from tblThueNha where Masothue = '" + cmbMasothue.SelectedValue.ToString() + "'"); } if (cmbMasothue.Text == "") { txtDongiathue.Text = ""; return; } sql = "SELECT Tiendatcoc FROM tblThueNha WHERE Masothue = '" + cmbMasothue.Text + "'"; DataTable table = DAO.DocBang(sql); if (table.Rows.Count > 0) { txtDongiathue.Text = table.Rows[0][0].ToString(); } if (cmbMasothue.SelectedIndex != -1) { if (cmbMasothue.Text == "") { txtHinhThuc.Text = ""; return; } sql1 = "SELECT b.TenhinhthucTT FROM tblThueNha as a join tblHinhThucThanhToan as b on a.MahinhthucTT=b.MahinhthucTT WHERE a.Masothue = '" + cmbMasothue.Text + "'"; DataTable tbl = DAO.DocBang(sql1); if (tbl.Rows.Count > 0) { txtHinhThuc.Text = tbl.Rows[0][0].ToString(); } double dg, ht, tt; dg = Convert.ToDouble(txtDongiathue.Text); ht = Convert.ToDouble(txtHinhThuc.Text); tt = dg * ht; txtTongtien.Text = tt.ToString(); } }
private void cmbMasothue_SelectedIndexChanged(object sender, EventArgs e) { if (cmbMasothue.SelectedIndex != -1) { string sql, sql1, sql2; if (cmbMasothue.Text == "") { txtManha.Text = ""; return; } sql = "SELECT Manha FROM tblThueNha WHERE Masothue = '" + cmbMasothue.Text + "'"; DataTable table = DAO.DocBang(sql); if (table.Rows.Count > 0) { txtManha.Text = table.Rows[0][0].ToString(); } if (cmbMasothue.Text == "") { txtTenkhach.Text = ""; return; } sql1 = "SELECT b.Tenkhach FROM tblThueNha as a join tblKhachThue as b on a.Makhach=b.Makhach WHERE a.Masothue = '" + cmbMasothue.Text + "'"; DataTable table1 = DAO.DocBang(sql1); if (table1.Rows.Count > 0) { txtTenkhach.Text = table1.Rows[0][0].ToString(); } if (cmbMasothue.Text == "") { txtDiachi.Text = ""; return; } sql2 = "SELECT b.Diachi FROM tblThueNha as a join tblDanhMucNha as b on a.Manha=b.Manha WHERE Masothue = '" + cmbMasothue.Text + "'"; DataTable table2 = DAO.DocBang(sql2); if (table2.Rows.Count > 0) { txtDiachi.Text = table2.Rows[0][0].ToString(); } } }
private void cmbMasothue_SelectedIndexChanged(object sender, EventArgs e) { if (cmbMasothue.SelectedIndex != -1) { txtNgayketthuc.Text = DAO.GetFieldValues("select NgayKT from tblThueNha where Masothue = '" + cmbMasothue.SelectedValue.ToString() + "'"); } string sql, sql1; if (cmbMasothue.Text == "") { txtBoithuong.Text = ""; return; } sql = "select sum(Thanhtien) from tblTraNha_MatTaiSan where Masothue='" + cmbMasothue.SelectedValue + "'"; DataTable table = DAO.DocBang(sql); if (table.Rows.Count > 0) { txtBoithuong.Text = table.Rows[0][0].ToString(); } if (cmbMasothue.Text == "") { txtTiendatcoc.Text = ""; return; } sql1 = "SELECT Tiendatcoc FROM tblThueNha WHERE Masothue = '" + cmbMasothue.Text + "'"; DataTable tbl = DAO.DocBang(sql1); if (tbl.Rows.Count > 0) { txtTiendatcoc.Text = tbl.Rows[0][0].ToString(); } }
private void btnLuu_Click(object sender, EventArgs e) { double gt1, gt2, ss; if (cmbMasothue.SelectedIndex == -1) { MessageBox.Show("Bạn chưa chọn mã thuê nhà!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (cmbTaisan.SelectedIndex == -1) { MessageBox.Show("Bạn chưa chọn tài sản!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (txtSoluong.Text == "") { MessageBox.Show("Bạn chưa nhập số lượng!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtSoluong.Focus(); return; } if (txtGiatri.Text == "") { MessageBox.Show("Bạn chưa nhập giá trị!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtGiatri.Focus(); return; } // string sql = "select * from tblTraNha_MatTaiSan where Masothue='" + cmbMasothue.SelectedValue.ToString() + "' and Mataisan='" + cmbTaisan.SelectedValue.ToString() + "'"; DAO.OpenConnection(); if (DAO.CheckKeyExit(sql)) { MessageBox.Show("Tài sản này đã được kê khai trong nhà bạn chọn", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); DAO.CloseConnection(); cmbMasothue.Focus(); return; } string str = "select a.Giatri from tblNha_TaiSan as a join tblThueNha as b on a.Manha=b.Manha where a.Mataisan = '" + cmbTaisan.SelectedValue.ToString() + "' and b.Masothue= '" + cmbMasothue.SelectedValue.ToString() + "'"; DataTable table = DAO.DocBang(str); if (table.Rows.Count > 0) { txtGiatribandau.Text = table.Rows[0][0].ToString(); } gt1 = Convert.ToDouble(txtGiatribandau.Text); gt2 = Convert.ToDouble(txtGiatri.Text); ss = gt2 - gt1; if (ss > 0) { MessageBox.Show("Giá trị không hợp lệ vì lớn hơn giá trị ban đầu, mời nhập lại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtGiatri.Focus(); return; } else { sql = "insert into tblTraNha_MatTaiSan (Masothue,Mataisan,Soluong,Giatri,Thanhtien) " + " values ('" + cmbMasothue.SelectedValue.ToString() + "','" + cmbTaisan.SelectedValue.ToString() + "'," + txtSoluong.Text.Trim() + "," + txtGiatri.Text.Trim() + "," + txtThanhtien.Text.Trim() + ")"; DAO.con.Open(); SqlCommand cmd = new SqlCommand(sql, DAO.con); cmd.ExecuteNonQuery(); DAO.CloseConnection(); loadDataGridView(); } }