private void btnXoaHoSo_Click(object sender, EventArgs e) { if (MaHoSo.Trim() == "") { MessageBox.Show("chưa chọn hồ sơ!"); return; } //string qr = " select NguoiDaiDien from tblHoGiaDinh where MaHoGiaDinh = (select MaHoGiaDinh from tblHoSoCapGCNDatNN where MaHoSoCapGCNDatNN =" + MaHoSo + ")"; //if (MessageBox.Show("Bạn có chắc muốn xóa hồ sơ của gia đình Ông(Bà) "+cls.ExecuteQueryScalar(qr) +" không?","Xóa.",MessageBoxButtons.YesNo,MessageBoxIcon.Warning) == DialogResult.Yes) if (MessageBox.Show("Bạn có chắc muốn xóa hồ sơ" + MaHoSo + " không?", "Xóa.", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { string qr = "delete from tblHoSoCapGCNDatNN where MaHoSoCapGCNDatNN =" + MaHoSo + ""; int kq = Convert.ToInt32(cls.ExecuteQueryInsertUpdateDelete(qr)); if (kq > 0) { MessageBox.Show("Xóa thành công!"); } else { MessageBox.Show("Error!"); } FillData(); } }
private void chkDone_CheckedChanged(object sender, EventArgs e) { if (clsConfig.TrangThaiHoSo < 2) { } else if (chkDone.Checked == true) { clsConfig.TrangThaiHoSo++; Status(clsConfig.TrangThaiHoSo); string query = " update tblHoSoCapGCNDatNN set TrangThaiHoSo =" + clsConfig.TrangThaiHoSo + " where MaHoSoCapGCNDatNN ='" + clsConfig.MaHoSo + "' "; cls.ExecuteQueryInsertUpdateDelete(query); } }
private void btnThue_Click(object sender, EventArgs e) { try{ if (textBox1.Text.Trim() != "" || IDThuaDat != 0) { string query = " update tblThuaDatCapGCNDatNN set TienDaNop = TienDaNop +" + textBox1.Text.Trim() + " where ID =" + IDThuaDat; clsDatabase cls = new clsDatabase(); cls.ExecuteQueryInsertUpdateDelete(query); this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void TaoHoSoMoi() { if (clsConfig.MaHoSo != 0) { FillData(clsConfig.MaHoSo); } else { string query = " INSERT INTO tblHoSoCapGCNDatNN (MaDonViHanhChinh,TrangThaiHoSo,NgayNhapLieu) " + " VALUES ('" + clsConfig.MaDonVihanhChinh + "' ,2,'" + DateTime.Now.ToString() + "') "; cls.ExecuteQueryInsertUpdateDelete(query); query = " SELECT MAX(MaHoSoCapGCNDatNN) from tblHoSoCapGCNDatNN"; clsConfig.MaHoSo = Convert.ToInt32(cls.ExecuteQueryScalar(query)); FillData(clsConfig.MaHoSo); } }
private void btnHoiDong_Click(object sender, EventArgs e) { try { string query = ""; if (cmbDanhMuc.Text == "Cán bộ cơ quan địa chính") { query = " Update tblXetQuyenSuDungDatNN set CQDC ='" + richTextBox1.Text.Trim() + "' where MaHoSoCapGCNDatNN = " + clsConfig.MaHoSo.ToString(); } else if (cmbDanhMuc.Text == "Cán bộ Hội đồng giao đất nông nghiệp") { query = "Update tblXetGiaoDatNN set HDGD ='" + richTextBox1.Text.Trim() + "' where MaHoSoCapGCNDatNN = " + clsConfig.MaHoSo.ToString(); } if (query != "") { cls.ExecuteQueryInsertUpdateDelete(query); } } catch (Exception ex) { //MessageBox.Show(ex.Message); } }