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