this->ADOQuery2->Close();
this->ADOQuery2->SQL->Clear(); //逾期贷款 //取出贷款
this->ADOQuery2->SQL->Add("select ye as 余额 from fhdkfhz where zhzt like '21%' and khh='"+this->Editkhh->Text+"' and ye>0 ");
this->ADOQuery2->Close();
this->ADOQuery2->SQL->Clear(); //逾期贷款 //取出贷款
this->ADOQuery2->SQL->Add("select ye as 余额 from fhdkfhz where zhzt like '31%' and khh='"+this->Editkhh->Text+"' and ye>0 ");
this->ADOQuery2->Close();
this->ADOQuery2->SQL->Clear(); //逾期贷款 //取出贷款
this->ADOQuery2->SQL->Add("select ye as 余额 from fhdkfhz where zhzt like '41%' and khh='"+this->Editkhh->Text+"' and ye>0 ");
this->ADOQuery2->Close();
this->ADOQuery2->SQL->Clear(); //逾期贷款 //取出贷款
this->ADOQuery2->SQL->Add("select ye as 余额 from fhdkfhz where zhzt like '51%' and khh='"+this->Editkhh->Text+"' ");
this->ADOQuery4->Close();
this->ADOQuery4->SQL->Clear(); //判断该户家庭成员是否有贷款未结清
this->ADOQuery4->SQL->Add("select ye from fhdkfhz where khh='"+tmp_tmpkhh+"' and zhzt like '21%' and ye>0");
this->ADOQuery4->Open();
if(this->DataSource4->DataSet->RecordCount>=1)
{
ShowMessage("该客户家庭成员有贷款逾期,禁止放贷!");
JTCY_WG=true;
break;
}
this->ADOQuery4->Close();
this->ADOQuery4->SQL->Clear(); //判断该户家庭成员是否有贷款未结清
this->ADOQuery4->SQL->Add("select ye as 余额 from fhdkfhz where khh='"+tmp_tmpkhh+"' and zhzt like '31%' and ye>0");
this->ADOQuery4->Open();
if(this->DataSource4->DataSet->RecordCount>=1)
{
ShowMessage("该客户家庭成员有呆滞贷款,禁止放贷!");
JTCY_WG=true;
break;
}
this->ADOQuery4->Close();
this->ADOQuery4->SQL->Clear(); //判断该户家庭成员是否有贷款未结清
this->ADOQuery4->SQL->Add("select ye as 余额 from fhdkfhz where khh='"+tmp_tmpkhh+"' and zhzt like '41%' and ye>0");
this->ADOQuery4->Open();
if(this->DataSource4->DataSet->RecordCount>=1)
{
ShowMessage("该客户家庭成员有呆账贷款,禁止放贷!");
JTCY_WG=true;
break;
}
this->ADOQuery4->Close();
this->ADOQuery4->SQL->Clear(); //判断该户是否有核销贷款
this->ADOQuery4->SQL->Add("select zh as 帐号 from fhdkfhz where khh='"+tmp_tmpkhh+"' and zhzt like '51%'");
this->ADOQuery4->Open();
if(this->DataSource4->DataSet->RecordCount>=1)
{
ShowMessage("该客户家庭成员有贷款核销,禁止放贷!");
JTCY_WG=true;
break;
}
this->ADOQuery2->Next();
}//end while
if(JTCY_WG==true)
{
return;
}
this->ADOCommand1->CommandText="insert into NYGXD_JJXX(XM,KHH,JTZZ,DKYT,JKRQ,DQRQ,JKJE,JKFS,HKFS,JXFS,DKZH,CKZH,SJM,JGM,XDY,DKPZ) values ('"+this->Editxm->Text+"','"+this->Editzjhm->Text+"','"+this->Editjtzz->Text+"','"+this->ComboBoxdkyt->Text+"','"+tmpdate_begin+"','"+tmpdate_end+"','"+this->Editjkje->Text+"','"+this->ComboBoxjkfs->Text+"','"+this->ComboBoxhkfs->Text+"','"+this->ComboBox1->Text+"','"+this->Editdkzh->Text+"','"+this->Editckzh->Text+"','"+this->Editsjm->Text+"','"+tmpzzjgm+"','"+this->Editxdy->Text+"','"+this->ComboBox2->Text+"')";